CMIS2250 Management Information Systems and Analytics

Overview

This assignment covers three topics – modeling, spreadsheet engineering, and scenarios.

Begin to translate the given scenario into a model:

1. Create an influence chart.

2. List the key (you must determine which values are important) inputs that can be extracted from the information given.

3. State any assumptions that you needed to make

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:

1. Increase post-retirement spending by 7.5%, increase retirement savings rate by 10%.

2. Decrease post-retirement spending by 10%, decrease earnings by 5%.

The deliverables for this assignment are:

• A spreadsheet containing your workbook file named Modelling Spreadsheet Engineering – Group #.xlsx

containing all of your worksheets related to this assignment, including: o Influence Chart (cut-and-paste or screenshot)

DSS (Decision Support System)

• source data 

• constants table 

• variables table 

• calculations 

• results table