Question: James is working to develop a preliminary cost - benefit analysis for a new client - server system. He has identified a number of cost
James is working to develop a preliminary costbenefit analysis for a new clientserver system. He has identified a number of cost factors and values for the new system, summarized in the following tables:
Development Costs Personnel
Systems Analysts hoursea @ $hour
Programmer Analysts hoursea @ $hour
GUI Designer hoursea @ $hour
Telecommunication Specialist hoursea @ $hour
System Architect hoursea @ $hour
Database Specialist hoursea @ $hour
System Librarian hoursea @ hour
Development Costs Training
Oracle training registrations $registration
Development Costs New HardwareSoftware
Development server $
Server software OS misc. $
DBMS server software $
DMBS client software $client
Annual Operating Costs Personnel increase each year starting the st year
Programmer Analysts hoursea @ $hour
System Librarian hoursea @ $hour
Annual Operating Costs Hardware, Software, and Misc. starting the st year
Maintenance agreement for server $
Maintenance agreement for DBMS $
The benefits of the new system are expected to come from two sources: increased sales and lower inventory levels. Sales are expected to increase by $ in the first year of the systems operation and will grow at a rate of each year thereafter. Savings from lower inventory levels are expected to be $ per year for each year of the projects life.
Develop an Excel spreadsheet that summarizes this projects cash flow for the costbenefit analysis, assuming a fouryear useful life after the project is developed. See the example of the costbenefit analysis below. Compute the present value of the cash flows, using an interest rate of and then type your answers to the following questions in a Word document.
What is the NPV for this project?
What is the ROI for this project?
What is the breakeven point?
Should this project be accepted by the approval committee?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
