Implementation Concerns

To design the Economic Feasibility workbook described in the case scenario, you will create a workbook consisting of five worksheets. You should create separate worksheets for the documentation, or e-time costs, recurring costs, recurring benefits, and economic feasibility summary. Since the Economic Feasibility Summary worksheet consolidates data from three of the worksheets, you should create this worksheet last. You shouls also consider using range names to simplify the consolidation process.

While you are free to work with the design of your worksheets, you should have a consistent professional appearance. You should also use proper formatting for the cells. For instance, dollar values should display with a dollar sign and be formatted to two decimal places.


Test your Design

After creating teh Economic Feasibility workbook descraibed in the case scenario, you should test the design of your worksheets. Perform teh following operations.

1. What recommendations would you make if the useful life of the project is three years insetad of five years? Six years?

2. Identify atleast three additional beefits that might be derived from the project. Estimate their value and include the values in your analysis. What impact do these benefits have on your economic feasibilty?

3.Identify atleast one additional one-time cost and atleast three additional recurring costs. Estimate their values and include these values in your analysis. What impact do these new costs have on your economic feasibilty? is the project still justifiable? Why or Why not?


Case Deliverables

In order to satisfactorily complete this case, you should build the workbook as described in the case scenario and then prepare both written and oral presentations. Unless otherwise specified, submit the following deliverables to your professor. Also, unless otherwise specified, perform these steps after you have tested your design.

1. A written report discussing any assumptions you have made about the case and the key elements of the case. Additionally, what features did you add to make the worksheets more functional? user-friendly? (Please note that these assumptions cannot violate any of the requirements specified above and must be approved by your professor.)

2. A printout of each worksheet.

3. A printout of each worksheet's formulas.