Reference no: EM131003630

Question: I need assignment this tomorrow. It is from information system in organisation. you have to do this in excel.

Spreadsheets as Decision Support System (DSS)

At a very simple level, a DSS might just be a spreadsheet that allows the user to vary some of the parameters and see the impact this has on outcomes.

For example:
• we may build a spreadsheet to support various investment decisions;
• we can look at different mobile phone plan options and see how much it may cost;
• businesses often use spreadsheets in modelling outcomes as part of business case development for a range of proposals such as:
o the University enters into agreements with offshore organisations to make its degree programs available in these locations - spreadsheets are used to look at the set of costs (fixed and variable) and to compare this to projected income in a range of circumstances (mainly student numbers per cohort, but also considering the impact of issues such as exchange rates, labour costs, wastage rates etc...)

Option 1
- Cost: $25 per month (expires at the end of the month)
- Call cap: $225 calls/month
- Data cap: 200 MB connection is cut off once monthly limit is reached
- 0.89c per minute or part of minute
- 0.25c connect fee (per call

Option 2
- Cost:$35 per month (expires at the end of the month)
- Call cap: unlimited
- Data cap: 50 MB + 0.35c/MB
- 0.65c per minute or part of minute
- 0.30c connect fee (per call

Option 3
- Cost: $45 per month (expires at the end of the month)
- Call cap: unlimited
- Data cap: 200 MB +0.35 c/MB
- 0.50c per minute or part of minute
- 0.35c connect fee (per call)

Option 4
- Cost: $65 per month (expires at the end of the month)
- Call cap: unlimited
- Data cap: 200 MB +0.45 c/MB
- 0.50c per minute or part of minute
- 0.35c connect fee (per call)

1) At the end of each month each of the plans expireand you are required to purchase another month worth of access.

2) If you reach the call cap limit you must pay the difference between the call cap and the actual dollar amount used. E.g. In the first January month (option 1) granny has used 560 minutes of talk time (at 0.89c per minute) and has made 174 calls (at 0.25c connection fee for each call). Thus, under option 1 (January) the total cost of calls, including connect fees, would be $541.90. The cap limit is $225 and is not reached. This means that granny has had to pay an extra $316.90 for that month, plus the $25.00 plan fee, for a total of $341.90 for the first January option 1.

Attachment:- data.xlsx