This is the question , honestly , you could skip the garbage at first and jump to the Question section.
below is my excel sheet , I need to do the 4 requirements under the Question section.
to make your life easier you could copy the numbers from my sheet but i dont know how the function work exactly , as the professor is the one who sets it up.
Ans: Long Engineering Company (LEC)
Basic Information |
||||
Gross Profit | 20% of sales | Hardware cost | 150,000 | |
Supervisisor Salary Alocated | Software Cost | 175,000 | ||
Year | Data Conversion Cost | 15000 | ||
1 | 40% | Engineer Salary | $100,000 | |
2 | 30% | Training cost per Year | $29,423 | |
3 | 20% | Discounting Rate | 20% | |
4 | 20% | Hardware Maintenance | 15% | |
5 | 20% | Software Maintenance | 15% | |
Incremental sales |
||||
1 | $200,000 | |||
2 | $300,000 | |||
3 | $400,000 | |||
4 | $400,000 | |||
5 | $400,000 |
Computation of Net Present Value |
||||||
Particulars | Amount ($) | |||||
Time ( in years) | 0 | 1 | 2 | 3 | 4 | 5 |
Initial Investment | ||||||
Hardware cost | $150,000 | |||||
Software Cost | $175,000 | |||||
Data Conversion Cost | $15,000 | |||||
Recurring Cost | ||||||
Hardware Maintenance |
$22,500 | $22,500 | $22,500 | $22,500 | $22,500 | |
Software Maintenance |
$26,250 | $26,250 | $26,250 | $26,250 | $26,250 | |
People,Supervisor cost |
$40,000 | $30,000 | $20,000 | $20,000 | $20,000 | |
Training Cost | $29,423 | $29,423 | $29,423 | $29,423 | $29,423 | |
Total Cost | $340,000 | $118,173 | $108,173 | $98,173 | $98,173 | $98,173 |
Recurring Benefits |
||||||
Increased profit | $40,000 | $60,000 | $80,000 | $80,000 | $80,000 | |
Wages Saving | $120,000 | $120,000 | $120,000 | $120,000 | $120,000 | |
Phone Bill Saving |
$18,000 | $18,000 | $18,000 | $18,000 | $18,000 | |
Total Benefits | $178,000 | $198,000 | $218,000 | $218,000 | $218,000 | |
Incremental Benefits | -$340,000 | $59,827 | $89,827 | $119,827 | $119,827 | $119,827 |
Present Value Factor @ 20% | 1 | 0.83 | 0.69 | 0.58 | 0.48 | 0.40 |
Present Value | -$340,000 | $49,856 | $62,380 | $69,344 | $57,787 | $48,156 |
Net present Value | -$52,477 |
If Value of the Software is decreased by $52,477 then the NPV become Zero. So the new negotiated Software price is should be $122,523.to accept the project.
This is the question , honestly , you could skip the garbage at first and jump...
Cost benefit analysis for the Long Engineering Company The Long Engineering Company (LEC) has decided to install a network system to help their technical support engineers (five of them who earn an average of $100,000 each per year) to deliver better customer service including: mail out sales and other literature, answer phone calls for technical assistance and log and forward repair requests using an alpha-numeric paging system that will be part of the new network system. Currently all company...
Business Case Sample Exercise 4 years by developing a new information system. The new information system will connect all its branch offices across the country and linked to a common server. In measuring the economic worth of this project, the preliminary estimated costs for the new venture by ABC Enterprise covers personnel, training, infrastructure and maintenance. - The personnel that will form the project team includes; three (3) systems analysts who will be required to work for 400 hours at...
Chapter 14 Running Case Assignment: Improving Decision Making: Using Spreadsheet Software to Analyze the Return on a New System Investment Software skills: Spreadsheet formulas and functions Business skills: Capital budgeting This project provides you with an opportunity to use spreadsheet software to use the capital budgeting models discussed in this chapter to analyze the return on a new information system investment for a real-world company. Dirt Bikes's management would like to analyze the return on its investment in its employee...
Ocean Sound College is a culinary sushi college located on the West Coast, and is a subsidiary of the Sushi Heights Corporation. You are the systems analyst assigned from the college IT department to conduct the systems analysis phase of the development of a new listing system for the school’s housing office. Background Based on your earlier recommendations, the housing office decided to continue the systems development process for a new listing system. Now, at the end of the systems...
10.24 An automaker is considering installing a three-dimensional (3-D) computerized car-styling system at a cost of $230,000 (including hardware and software). With the 3-D computer modeling system, designers will have the ability to view their design from many angles and to fully account for the space required for the engine and passengers. The digital information used to create the computer model can be revised in consultation with engineers, and the data can be used to run milling machines that make...
Industrial Psychology: Please read the case above before answering the following question: What changes would you suggest that could increase the transfer of training in this case? What Went Wrong at University Hospital (Part 1)? Pat Rowe, Vice President of University Hospital, recently attended a conference session that discussed the problems of integrating computer technology into the work practices of health care professionals. The session lecturer argued that implementation often fails because staff do not receive proper training in the...
the solutions to mini case #4 are not posted in the textbook solutions. Any help on this? Appendix 1A- Detailed Economic Feasibility Analysis for Tune Source 33 then can be used to project the increase in the number of service calls made each week. For example, if the system per mits the average service response time to fall to 4 hours, the management believes that each truck will be able to make I6 service calls per week on average-an increase...
Walmart is considering the installation of customer kiosks in their Supercenters. The kiosks will allow customers to search for products, tell them if the products are in stock, and show them on a map where in the store the products are located. Use the following facts to conduct a break-even analysis of the customer kiosk technology. Costs • There will be a one-time cost of $18,000,000 in 2018 to develop and implement the system software. • Starting in 2019 there...
Question 4 (20 marks) T&A is one of the leading companies in fashion and design. The company has annual revenue of $2 billion and 12,000 employees. Currently, T&A’s information systems handle hundreds of thousands of transactions each day and they could no longer keep pace with the company's growth. For many years the company has relied on more than five information systems, all of which are outdated. Since these information systems are not fully integrated, the finance staff need a...
After reading the abstract of this article, what single phrase would you choose to describe this article (content of the article) ? Why would you choose this word? List of single phrases to choose from: WOW SURPRISING INTERESTING UNLIKELY IMPOSSIBLE ABOUT TIME WASTED EFFORT NO REAL CHANGE INNOVATIVE NO WAY SO WHAT Article: The Financial And Nonfinancial Costs Of Implementing Electronic Health Records In Primary Care Practices Neil S. Fleming, Steven D. Culler, Russell McCorkle, Edmund R. Becker, and David...