Module
2.6
Introduction |
A.M.D.G.
|
In First Year you
learned how to enter text, numbers and formulae in spreadsheet cells
and how to draw charts from spreadsheet data.
In this module
you will create larger spreadsheets with many linked formulae. The spreadsheets
will allow you to model a number of different scenarios using different
data to allow you to make the most informed decisions possible.
| The first
scenario will put you in charge of a hotel and its finances. You
must calculate the various expenses – salaries and supplies.
Money is generated by the guests coming and staying at your hotel.
The amount of guests will vary from season to season. |
|
|
The second,
more complicated scenario puts you in charge of a football club
and its finances. Money is generated from television, merchandising,
food sales and, of course, gate receipts. Money must be spent
on players’ salaries, maintenance, travel and security.
It is your task to decide the most profitable route to success.
|
|
