Overview
This assignment covers three topics – modeling, spreadsheet engineering, and scenarios.
Begin to translate the given scenario into a model:
Create a decision support system spreadsheet to help calculate the length that the money will last in retirement. While constructing the spreadsheet ensure that you follow the guidelines – isolate inputs and calculations, organize data clearly, and make the results clear. Your sheet can be structured as you please as long as it is clear and effective – the data and calculations may dictate that you construct your calculations following a different format than the example.
Note: There is ambiguity here, that is part of the assignment. Determine, as accurately as you can, the most likely scenario (i.e. the base case) for how long the money will last. You will have incomplete information and you will have superfluous information; sorting through the information, evaluating importance, and filling in gaps is part of the challenge.
Use the scenario manager to create two additional scenarios that can be compared to the baseline that you’ve already created:
The deliverables for this assignment are:
containing all of your worksheets related to this assignment, including: o Influence Chart (cut-and-paste or screenshot)
DSS (Decision Support System)