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 technical manuals and are in physical format, but will need to be scanned and converted to electronic readable form. There are about 3000 pages of technical literature. The initial feasibility study estimated that there would be savings in various areas including: (1) there are currently four clerical staff, two of these would no longer be needed ($60,000 per year each), and (2) Reduced long distance toll bills of $1,500 per month for calls to field support staff regarding repair requests. It was also expected that there would be an increase in sales of $400,000 per year because of improved customer service, with a gross profit rate of 40%. The company typically uses a cost of money (discount rate) of 20% for these types of projects.
Ten months ago, our company’s IT consultant/vendor gave us the following proposal, and we
prepared an Excel spreadsheet (see separate handout) showing a Net Present Value of $257,605
for the project: "Our system will provide a full LAN configuration for your customer support services area covering the major areas of functionality required including: call logging by customer or inquirer, recording of nature of request and nature of response, access to all company technical literature online, and automatic message forwarding to hand-held devices of field service persons where necessary. The cost of the system includes the required file server and six workstations, laser printer and WAN communications adapter ($150,000). The software provided will include the necessary LAN operating system (Windows), and applications software to meet the functionality requirements mentioned above ($175,000). Existing staff should be able to handle the new system with additional training, as the entire system will be very user friendly with a low learning curve and should be easily administrated by one of the existing engineers, only absorbing 20% of his time. We do recommend that you budget for at least one week of training for each of your employees each year to gain and maintain the skills necessary to achieve full benefit from this system. It will also be necessary to budget for conversion of the company's technical literature at an estimated cost of $5 per page. A maintenance contract is available if you wish at a cost of 15% of the initial cost of the hardware, and a similar contract is available for the software. Training costs typically amount to $2500 per week, per employee."
Assignment:
The financial situation of the company has changed substantially in the last 10 months, so your manager
wants you to make changes to the previous Excel spreadsheet so as to present a more conservative
analysis by including the following changes:
Please turn in a printed copy of the revised version of the spreadsheet in class on Thursday, January
31th, 2019; be sure to include your name. The NPV of the project should be Zero, and the new
software cost should be highlighted?
Ans:
Basic Information | ||||
Gross Profit | 20% of sales | Hardware cost | 150,000 | |
Supervisor Salary Allocated | 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 |
a) Computation of Net Present Value
Particulars | Amount ($) | |||||
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 |
So if the software cost is decreased by $52,477 then the NPV of the project become Zero and the cost of Software becomes $122,523.
Cost benefit analysis for the Long Engineering Company The Long Engineering Company (LEC) has decided...
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. IEN 363 Spring 2019 Fnancial Analys1S Assignment ost benefit analysis...
Part 2: Cost Benefit Analysis Assumptions In order to simplify the cost benefit analysis, we will not make a net present value calculation for each cost and income. Please report all calculations in yearly terms Please calculate the cost benefit over a 5 year term Instructions Please create a table that lays out the project cost and benefits (15) Please create a table that shows the cost over 5 years (5) Please create a table that shows the benefit over...
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...
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...
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...
5. A new sprinkler system for Industrial Chemical Company will cost $220,000. project will generate the following year-end, after-tax, net cash flows: This Year 1 - $120,000 Year 4 - $80,000 Year 2 - $120,000 Year 3 - -$20,000 (note: the Year 3 CF is negative) a. If the discount rate is 6% what is the Net Present Value (NPV) of the project? (3 points) Does the NPV indicate that this project is acceptable? (half-point) b. Based on your answer...
A company is deciding whether to purchase and maintain its own payroll system or to pay as a service from the cloud provider. Estimate the 3-year cost of purchasing and maintaining the system considering one-time purchase costs of $12,000 for hardware and $10,000 for software. Also, consider the following maintenance, operation and upgrade costs per month: $100 for hardware, $100 for software, and $1,000 for IT staff. Compare the total above with the 3-year cost of the cloud-based system for...
Real-World Case 6 Certain members of the C-Suite in ABC Hospital are interested in adding voice recognition (VR) software to their current EHR. As Director of HIM, Cynthia Reedy is preparing an extensive report on the impact this would have on the department. She is proposing a feasibility study and subsequent RFP be completed. The initial aspect of the report includes information on voice recognition including the projected workload of VR software and how it would be implemented in the...
6. Financial Returns Section: Present value of the project (PW) , Cost/Benefit analysis, and sensitivity analysis. (See below) 7. Cash flow diagrams and references Note the following: 1. For the initial cost estimate, assume that five robotic welders will save about $1 million per year which is equivalent to about 7 full time equivalent (FTE) highly skilled welders. 2. The purpose of the investment is to transition the welders to custom projects that provide high margins to the firm that...
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...