Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create this figure in Java: 2012 2013 2014 2015 2016 Total 500,000 70,000 68,000 638,000 601,887 530,000 70,000 68,000 668,000 594,518 561,800 70,000 68,000 699,800

Create this figure in Java:

image text in transcribed

2012 2013 2014 2015 2016 Total 500,000 70,000 68,000 638,000 601,887 530,000 70,000 68,000 668,000 594,518 561,800 70,000 68,000 699,800 587,566 595,508 70,000 68,000 733,508 581,007 2,364,978 0 0 0 0 0 0 0 0 Benefits Increased sales Reduction in customer complaint callse Reduced inventory costs Total Benefits Present Value Total Benefits Development Costs 2 Servers @ $125,000 Printer Software licenses Server software Development labor Total Development Costs Operational Costs Hardware Software Operational labor Total Operational Costs Total Costs Present Value Total Costs NPV (PV Total Benefits - PV Total Costs) 250,000 100,000 34,825 10,945 1,236,525 1,632,295 0 0 0 0 0 0 0 0 0 50,000 20,000 115,000 185,000 185,000 174,528 50,000 20,000 119,600 189,600 189,600 168,743 50,000 20,000 124,384 194,384 194,384 163,209 50,000 20,000 129,359 199,359 199,359 157,911 1,632,295 1,632,295 2,296,686 68,292 Customer service values are based on reduced costs of handling customer complaint phone calls. An important yet intangible benefit will be the ability to offer services that our competitors currently offer. FIGURE 1-13 Cost-Benefit Analysis Discounted Cash Flow Method Determine NPV In Figure 1-13, the present value of the costs and benefits has been calculated and added to our example spreadsheet, using a 6% rate of return. The NPV is simply the difference between the total present value of the benefits and the total present value of the costs. As long as the NPV is greater than zero, the project is considered economically viable. In this example, since NPV is $68,292, the proj- ect should be accepted from an economic feasibility perspective. 2012 2013 2014 2015 2016 Total 500,000 70,000 68,000 638,000 601,887 530,000 70,000 68,000 668,000 594,518 561,800 70,000 68,000 699,800 587,566 595,508 70,000 68,000 733,508 581,007 2,364,978 0 0 0 0 0 0 0 0 Benefits Increased sales Reduction in customer complaint callse Reduced inventory costs Total Benefits Present Value Total Benefits Development Costs 2 Servers @ $125,000 Printer Software licenses Server software Development labor Total Development Costs Operational Costs Hardware Software Operational labor Total Operational Costs Total Costs Present Value Total Costs NPV (PV Total Benefits - PV Total Costs) 250,000 100,000 34,825 10,945 1,236,525 1,632,295 0 0 0 0 0 0 0 0 0 50,000 20,000 115,000 185,000 185,000 174,528 50,000 20,000 119,600 189,600 189,600 168,743 50,000 20,000 124,384 194,384 194,384 163,209 50,000 20,000 129,359 199,359 199,359 157,911 1,632,295 1,632,295 2,296,686 68,292 Customer service values are based on reduced costs of handling customer complaint phone calls. An important yet intangible benefit will be the ability to offer services that our competitors currently offer. FIGURE 1-13 Cost-Benefit Analysis Discounted Cash Flow Method Determine NPV In Figure 1-13, the present value of the costs and benefits has been calculated and added to our example spreadsheet, using a 6% rate of return. The NPV is simply the difference between the total present value of the benefits and the total present value of the costs. As long as the NPV is greater than zero, the project is considered economically viable. In this example, since NPV is $68,292, the proj- ect should be accepted from an economic feasibility perspective

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Expert Oracle9i Database Administration

Authors: Sam R. Alapati

1st Edition

1590590228, 978-1590590225

More Books

Students also viewed these Databases questions