Module
2.6
Task 1 |
A.M.D.G.
|
Answer
the following questions in your jotter.
- If a hotel has
12 beds and is 50% full, how many beds are occupied?
- If a hotel has
12 beds and is 75% full, how many beds are occupied?
- If a season
lasts 90 days, how many guests would come in a season if the hotel
has 12 beds and is 75% occupied?
Do the following:
- Open a new spreadsheet
document in Microsoft Excel
- On sheet 1 of
the workbook, enter the following information:
Original
No. Of Beds
|
|
|
|
| New No.
of Beds |
|
|
|
| Cost Per
Night |
|
|
|
| Season |
% Occupancy |
Nightly
Occupancy |
Season
Occupancy |
| Winter |
40% |
|
|
| Spring |
75% |
|
|
| Summer |
95% |
|
|
| Autumn |
60%
|
|
|
| |
TOTAL |
|
|
| |
|
|
|
| TOTAL INCOME |
|
|
|
- Enter the number
of beds.
- Enter and fill
down formulae to calculate nightly occupancy.
- Enter and fill
down formulae to calculate season occupancy by multiplying nightly
occupancy by 90.
|