Question: Martin is working to develop a preliminary cost - benefit analysis for a new client - server system. He has identified several cost factors and
Martin is working to develop a preliminary costbenefit analysis for a new clientserver system. He has identified several cost factors and values for the new system, summarized in the following tables:
Development CostsPersonnel:
Systems Analysts hoursea @ $hour
Programmer Analysts hoursea @ $hour
GUI Designer hoursea @ $hour
Telecommunications Specialist hoursea @ $hour
System Architect hoursea @ $hour
Database Specialist hoursea @ $hour
System Librarian hoursea @ $hour
Development CostsTraining:
Oracle training registration $student
Development CostsNew Hardware and Software:
Development server $
Server software OS misc. $
DBMS server software $
DBMS client software $client
Annual Operating CostsPersonnel:
Programmer Analysts hoursea @ $hour
System Librarian hoursea @ $hour
Annual Operating CostsHardware, Software, and Misc. :
Maintenance agreement for server $
Maintenance agreement for server $
DBMS software
Preprinted forms year @ $form
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 system's 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 project's life.
Using a format like the spreadsheets, develop a spreadsheet that summarizes this project's cash flow, assuming a year useful life after the project is developed. Compute the present value of the cash flows, using an interest rate of
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
