Housekeeping Forecast .ng
Housekeeping Forecast
Report Description: The Housekeeping Forecast Report provides a projection of anticipated housekeeping services, including checkout, deep cleaning, no service requests, stayover service, and turndown service, categorized by room types, facilitating efficient resource allocation and scheduling for the housekeeping department.
Date Range: This report can render the data for up to 21 days past or future
Note: housekeeping service types (checkout service, deep clean, stayover service, etc.) will vary by property
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Date | The date for which the housekeeping forecast is generated | Not Applicable | Not Applicable |
Room Type | The type or category of rooms | Not Applicable | Not Applicable |
Room Type Code | Unique code assigned to each room type | Not Applicable | Not Applicable |
Checkout Service Rooms | Number of rooms requiring checkout service | Not Applicable | =sum(checkout service) |
Checkout Service Time | Estimated time required for checkout service in minutes | Not Applicable | =sum(checkout service minutes) |
Deep Clean Rooms | Number of rooms scheduled for deep cleaning | Not Applicable | =sum(deep clean) |
Deep Clean Time | Estimated time required for deep cleaning in minutes | Not Applicable | =sum(deep clean minutes) |
No Service Rooms | Number of rooms not requiring any service | Not Applicable | =sum(no service) |
No Service Time | Estimated time saved for rooms not requiring service in minutes | Not Applicable | =sum(no service minutes) |
Stayover Service Rooms | Number of rooms needing stay over service | Not Applicable | =sum(stayover service) |
Stayover Service Time | Estimated time required for stay over service in minutes | Not Applicable | =sum(stayover service minutes) |
Stayover Service with Linen Change | Rooms requiring stay over service with linen change | Not Applicable | =sum(stayover service w/linen change) |
Stayover Service with Linen Change Time | Estimated time for stay over service with linen change in minutes | Not Applicable | =sum(stayover service w/linen change minutes) |
Turndown Service Rooms | Number of rooms scheduled for turndown service | Not Applicable | =sum(turndown service) |
Turndown Service Times | Estimated time required for turndown service in minutes | Not Applicable | =sum(turndown service minutes) |
Total Rooms | Total number of rooms of this particular type | Not Applicable | =sum(all service types) |
Total Time | Total estimated time required for housekeeping services for this room type | Not Applicable | =sum(all service types minutes) |
Misc Report Information:
Available Features:
Export: ability to download and save the file into an alternate format.
Filter: filter a range of data based on criteria defined by the user.
Highlight: also known as conditional formatting is the ability to highlight certain values making them easier to identify.
Bar Graph: ability to view housekeeping serviced type data in a bar chart.
Grouping: ability to view the data grouped by “Room Type.”
Pie Chart: ability to view grouped data in a Pie Chart view.
Available Configuration:
User Preferences: allows the user to customize their report view by repositioning or removing columns.
Property Preferences: allows the property to customize the report view for all users by repositioning or removing columns.
Baseline Configuration:
Property Preferences Settings:
Following columns to be disabled for initial deployment:
Greener Stay Time
No Service Time
Turndown Service Rooms
Turndown Service Time