Enterprise Report - Housekeeping Forecast .ng
Enterprise Housekeeping Forecast
Report Description: The Enterprise Housekeeping Forecast Report provides a projection of anticipated housekeeping services, including checkout, deep cleaning, no service requests, stayover service, and greener stay, 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
Enterprise Housekeeping Forecast Section: provides a projection of anticipated housekeeping services
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Property Code | Identifies the hotel code | Not Applicable | Not Applicable |
Property Name | Identifies the name of the hotel | Not Applicable | Not Applicable |
Property City | Identifies the City the hotel is operating | Not Applicable | Not Applicable |
Property State | Identifies the State the hotel is operating | Not Applicable | Not Applicable |
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 |
Stayover Service Rooms | Number of rooms needing stay over service | Not Applicable | =sum(stayover service) |
Checkout Service Rooms | Number of rooms requiring checkout service | Not Applicable | =sum(checkout service) |
Stayover Service Value | Estimated time required for stayover service in minutes | Not Applicable | =sum(stayover service minutes) |
Total Rooms | Total number of rooms for all services | Not Applicable | =sum(all service types) |
Total Value | Estimated time required for all service in minutes | Not Applicable | =sum(all service minutes) |
No Service Rooms | Number of rooms not requiring any service | Not Applicable | =sum(no service) |
No Service Value | Estimated time required for no service in minutes | Not Applicable | =sum(no 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 Value | Estimated time for stay over service with linen change in minutes | Not Applicable | =sum(stayover service w/linen change minutes) |
Housekeeping Forecast Section: provides a projection of anticipated housekeeping services
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) |
Deep Clean Rooms | Number of rooms scheduled for deep cleaning | Not Applicable | =sum(deep clean) |
Greener Stay Rooms | Number of rooms participating in no housekeeping service in exchange for loyalty points | Not Applicable | =sum(no service/greener stay) |
No Service Rooms | Number of rooms not requiring any service | Not Applicable | =sum(no service) |
Stayover Service Rooms | Number of rooms needing stay over service | Not Applicable | =sum(stayover service) |
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) |
Total Rooms | Total number of rooms of this particular type | Not Applicable | =sum(all service types) |
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.”
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.