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.

1  out of 1 found this valuable. Do you find this valuable? Do you?    

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.

 out of  found this valuable. Do you find this valuable?