The Weekly Rota: Days Off, Scheduled vs Needed and Coverage Gaps
This lesson is part of the course
In this lesson
You count the attendants scheduled each day, compare them with the shifts needed, find the days that are short and check the weekend pattern with COUNTIFS.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Room Credits: Turning the Occupancy Forecast into Cleaning Workload Locked
- Attendants Needed: Productive Minutes, Full Shifts and Part-Time Cover Locked
- The Weekly Rota: Days Off, Scheduled vs Needed and Coverage Gaps Locked
- Linen Par Levels: Par Stock, Purchases and Replacement for Losses Locked
- Laundry Costs: Kilograms per Occupied Room, In-House vs Outsourced Locked
- Guest Amenities: Cost per Occupied Room by Room Type and Wastage Locked
- Inspections and Quality: Re-Clean Rates, Scores and Rooms per Hour Locked
- Department Dashboard: Labour Cost and Total Cost per Occupied Room vs Budget Locked