Tasks In Charge
1. Prepare team plan
2. Answer questions within the text of the case

A. Construct an Economic Feasibility workbook including a/an:
1. Documentation worksheet
2. One-Time Cost worksheet
3. Recurring Cost worksheet
4. Tangible Benefit worksheet
5. Economic Feasibility Summary worksheet.
3. Answer Information Specification questions

A. How will discount rates of 8, 10, 12, 14, and 16 percent affect the project’s feasibility?
B. Reset the discount rate to 14 percent. Prepare a breakeven chart that compares the net present value of all benefits to the net present value of all costs.
C. If management stipulates that the internal rate of return must be equal to or greater than the discount rate, is this project still justifiable?
D. Assuming the discount rate is 14 percent, how will eliminating an additional staff position of $32,500 affect the economic feasibility assessment?
E. Assume that the staff position mentioned in Step 3 is eliminated, the site preparation cost increases to $120,000, and the discount rate is 14 percent. What impact will these changes have on the project’s feasibility?
F. Based on the projects’ internal rate of returns, do you think management will fund the custom order-tracing system?

4. Prepare Report
5. Submit on Canvas
EXCEL CASE STUDY PLAN
GROUP 903
EXCEL CASE STUDY #2