new user training material for the new system 5 Site

New user training material for the new system 5 site

This preview shows page 4 - 7 out of 8 pages.

Develop/purchase/lease new user training material for the new system 5 Site preparation Acquire or lease a site to host the new computer system 6 Supplies One time cost of supplies to support the development of the new system Recurring cost Worksheet 1 Application Software maintenance Ongoing cost to maintain/improve and fix issues in the new system 2 Hardware Annual hardware maintenance cost 3 Software Annual maintenance cost of the software for the system 4
WBIT 3110, Unit 2 HW 4 User Training Develop/purchase/lease new user training material for the new system 5 Site preparation Acquire or lease a site to host the new computer system 6 Supplies Ongoing cost of supplies to support the system(paper/user PC, ect) 7 Others Other expensive not list above 5 SIMILAR to Problem and Exercise question 11. This SAME IDEA, but totally different numbers. USE THE NUMBERS BELOW!! Assuming monetary benefits of an information system at $95,000 per year, one-time costs of $75,000, recurring costs of $50,000 per year, a discount rate of 9 percent,and a five-year time horizon, calculate the netpresent value of these costs and benefits of an information system. Also calculate the overall return on investment of the project and then present a break-even analysis. At what point does break-even occur? This question is worth 25% of the assignment.NOTE THE CHANGES TO THE PROBLEM IN THE TEXT ABOVE IN BOLD TEXTSome helpful pointers:a.Fill in the chart provided (some answers already given to you) – the chart is on the next page. You must provide answers for all of the fields in the table filled in orange. b.Calculate the discount rate using the formula rate = 1/(1 + i)nwhere i is the rate, so percent = 0.09and n = the years, so, for example, in the third year, n would be that expression cubed (to the third power). Discount rate results should be FIVE decimal places, such as 0.85430 (not one of the answers).c.You don’t need to include the decimal places in your monetary answers.d.Overall ROI and break-even fraction should beTHREEdecimal places, such as 0.743 (of a year – also not one of the answers)d.Give your break-even point in terms of decimal places, and then compute that in months below the chart. So, for example, if your break-even date comes in between year oneand two, say, at .321, then it would be at 1.321 years. This computes to one year and3.852 months. (of course, this is not the answer). So you need to express your answer as BOTH a decimal(1.321 years) AND the number of years and months(1 year, 3.852 months). DO NOT just express your answer in terms of one or the other,express it in terms of BOTH.e.Even if your Overall ROI computes to a negative percent, express it as a positive percent 9 . 5
WBIT 3110, Unit 2 HW Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Totals Net Economic $0 $95,000 $95,000 $95,000 $95,000 $95,000 Benefit Discount Rate (.09) 1 0.91743 0.84168 0.77218 0.70843 0.64993 PV of Benefits $0 87,155.85 79,959.60 73,357.10 67,300.85 61,743.35 NPV of all Benefits $0 87,155.85 167,114.45 240,471.5 5 307,772.4 0 369,515.7 5 369,515.75 One-time Costs ($75,000.00) Recurring Costs $0 ($50,000) ($50,000) ($50,000) ($50,000) ($50,000) Discount Rate (.09) 1 0.91743 0.84168 0.77218 0.70843 0.64993 PV of Recurring $0 45,871.50 42,084.00 38,609.00 35,421.50 32,496.50 Costs NPV of all Costs ($75,000) 120,871.5 0 162,955.50 201,564.5 0 236,968.0 0 269,482.5 0 269,482.50 Overall NPV 100,033.25 0.56 Overall ROI 0.37 Break-even Analysis

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture