Module
2.6
Task 3 |
A.M.D.G.
|
Answer
the following questions in your jotter.
- If the hotel
has 12 beds and is expanding to 25 beds, how many new beds are being
created?
- If it costs
£800 per new bed, how much will this expansion cost?
- If 20 people
stay each night and supplies cost £4 per day per person, how
much would be spent on supplies in one season?
- If you know
the hotel’s total income and expenditure, how would you calculate
the profit?
- Add the following
information to your spreadsheet.
| Cost
Of Expansion |
|
| |
|
| Cost of
Supplies Per Day |
|
| Cost of
Supplies Per Year |
|
| |
|
| Total Expenditure |
|
| |
|
| TOTAL PROFIT |
|
- Enter a formula
to calculate the cost of any expansion (not applicable at option 1
but include the formula for subsequent options).
- Enter a formula
for the cost of supplies based on the number of guests staying in
a full year.
- Enter a formula
to calculate Total Expenditure for a year.
- Enter a formula
to calculate profit having calculated Total Expenditure and Total
Income.
|