Project Costs Initial estimates for project costs are given below These costs are based on a specific solution option Alternative options may be considered as part of project Stage 1 One off hardware Dedicated servers 35,000 Workstations 10,000 Ethernet, routers and other connections 20,000 Printers and scanners 10,000 Annual software cost (Year 0 onwards) ERP software (licence) 45,000 Server software (including database) 20,000 Developer software 25,000 Annual support (Year 1 onwards) Software 11,500 Hardware 8,500 One off development ERP software (replaces most existing systems) 100,00 In store sales software 30,000 Sales forecasting module 20,000 E commerce software (new system, including database and CMS) 105,000 MSW staff 100 staff days at an average of 300 0 per day Annual data cost (Middle of year 0 onwards) Geodemographic data 60,000 Annual staff cost (Year 1 onwards) 1 systems manager 55,000 systems technicians 30,000 each Project benefits Initial estimates for project financial benefits are Increased sales Net profit to increase by 150,000 in the calendar year after the system goes live, 350,000 the year after that, and 550,000 each year thereafter Reduced costs Reduced mail order and telephone sales should allow MSW to reduce call centre staff by 3 (currently costing 18,000 each per year including overheads) but only after the new system has been running smoothly for 6 months The new system will remove the need for quarterly catalogue production, printing and distribution costs (currently 10,500 per quarter) 2 years after web site deployment there will be overall marketing savings to MSW of 12,000 per year Business Case You are required to assess the financial viability of the proposed project using the estimated costs and benefits given above Assume a discount rate of 5 5 You must then recommend whether to proceed with the project or not You should consider how critical the benefit estimate and discount rate values are to your calculation You might also want to make suggestions for how the profitability of the project could be increased Assume that the product development takes place throughout the duration of project Year 0 The system will go live at the start of Year 1 and is expected to have a 7 year lifespan Calculate NPV on excel

The Answer is in the image, click to view ...

Question: Project Costs Initial estimates for project costs are given below. These costs are based on a specific solution option. Alternative options may be considered as

Project Costs

Initial estimates for project costs are given below. These costs are based on a specific solution option. Alternative options may be considered as part of project Stage 1.

One-off hardware

Dedicated servers: 35,000
Workstations: 10,000
Ethernet, routers and other connections: 20,000
Printers and scanners: 10,000

Annual software cost (Year 0 onwards)

ERP software (licence): 45,000
Server software (including database): 20,000
Developer software: 25,000

Annual support (Year 1 onwards):

Software: 11,500
Hardware: 8,500

One-off development

ERP software (replaces most existing systems): 100,00
In-store sales software: 30,000
Sales forecasting module: 20,000
E-commerce software (new system, including database and CMS): 105,000
MSW staff: 100 staff days at an average of 300.0 per day

Annual data cost (Middle of year 0 onwards)

Geodemographic data: 60,000

Annual staff cost (Year 1 onwards):

1 systems manager: 55,000
systems technicians: 30,000 each

Project benefits

Initial estimates for project financial benefits are:

Increased sales

Net profit to increase by 150,000 in the calendar year after the system goes live, 350,000 the year after that, and 550,000 each year thereafter.

Reduced costs

Reduced mail-order and telephone sales should allow MSW to reduce call centre staff by 3 (currently costing 18,000 each per year including overheads) but only after the new system has been running smoothly for 6 months.
The new system will remove the need for quarterly catalogue production, printing and distribution costs (currently 10,500 per quarter).
2 years after web site deployment there will be overall marketing savings to MSW of 12,000 per year.

Business Case

You are required to assess the financial viability of the proposed project using the estimated costs and benefits given above. Assume a discount rate of 5.5%. You must then recommend whether to proceed with the project or not. You should consider how critical the benefit estimate and discount rate values are to your calculation. You might also want to make suggestions for how the profitability of the project could be increased. Assume that the product development takes place throughout the duration of project Year 0. The system will go live at the start of Year 1 and is expected to have a 7-year lifespan.

Calculate NPV on excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Project Costs Initial estimates for project costs are given below. These costs are based on a specific solution option. Alternative options may be considered as part of project Stage 1. One-off...

Answer the questions at the end of the case Case study 2 Sustainable business improvement in a global corporation Shell Services BACKGROUND Processes People Customer Quality Figure C2.1 Components of...

UPSCase - NewVehiclePurchase Introduction Eddie Northen, VP of Finance UPS West Region, needs to purchase some new vehicles to make local deliveries. UPS currently has approximately 10,000 vehicles...

Question 1 Which of the following statement is true: Not yet answered Select one: Marked out of 1.00 O a. Parametric estimating requires less information and time than analogous estimating. P Flag...

Scenario Motorhome Spares Wales (MSW) is a company that sells new and second-hand replacement parts for motor homes and camper vans. It does this primarily from its network of 13 shops in and around...

Project Management Casebook David I. Cleland, Karen M. Bursic, Richard Puerzer, and A. Yaroslav Vlasak Library of Congress Cataloging-in-PublicationData Project management casebook /edited by David...

Please process at your earliest convenience. I have enclosed the attached document and other required documents. Thank you for your help! Consider how Kyler Valley Spring Park Lodge could use capital...

The mitial design was too complex. It required the user to work with the elbow, the mouse and both hands! To address the problem, a company called Interpix was brought in to evaluate the system from...

A wire is fixed at A and D as shown in fig. 2. Weight 20kN and 25 kN are supported at B and C respectively.When equilibrium is reached it is found that inclination of AB is 300 and that of CD is 600...

In normal air, the partial pressure of oxygen is 0.18 atm, thepartial pressure of nitrogen is 0.77 atm, and the partial pressureof carbon dioxide is 0.05 atm. Scuba divers often use tanks with...

What does earnings per share ( EPS ) reflect? A company's historical performance How much profit a company makes for each share of stock A company's short - term liquidity A company's total assets

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...