What is the Time Sheet in PMI?

The Time Sheet is an overview of all Labor cockpits, with past and future scheduled hours.

Intended users

It is used primarily by heads of departments, management teams and human resources.

Navigation is from the main menu.

View Options

In View Options, choose what you want to display:

1. Include Period-End: This will include the Live Forecast in your Time Sheet.
2. Show Weather: If ticked, you will have a weather forecast icon for the next 10 days. It will also save the data historically from that day onward.
3. Daily Note: Displays daily notes made.
4. View Total Rows For: Ticking SMART Forecast and/or Budget will add comparison totals at the bottom of the sheet.
5. View Columns For: Productive Hours • Non Productive Hours • Productivity • Cost Driver.

What’s on the page?

The key calculations are made as shown below, using “Sum Column F&B”, as an example.

1. Total F&B − YTD/MTD: Actual hours spent month-to-date in the division (given that all dates, including yesterday, are updated and saved).
2. Total F&B − YTD/MTD SMART Forecast: The actual F&B revenue divided by the forecasted productivity, i.e. available hours MTD with the same productivity as forecasted. Calculated according to SMART.
3. Total F&B − YTD/MTD SMART Budget: The actual F&B revenue divided by the budgeted productivity, i.e. available hours MTD with the same productivity as the budget. Calculated according to SMART.

Note: The Time Sheet will only be valid if all cockpits are updated with yesterday’s hours.

Note: Each department has its own cost driver based on an individual productivity target. On the divisional level, all calculations will be based on financial goals. Use the Time Sheet as a tool to summarize and compare. Use the date picker to select periods. Select your comparisons and views in View Options in the top right menu. See more under View Options below.

In Months and Year view it is possible to hover over the hours and get a popup with actual used hours Last Year.

Tools

In Tools, you can choose to export the report to Excel or PDF file format.

Take Note

If you find a discrepancy between the hours in the Timesheet and a Cockpit, check to make sure all the hours have been saved in the Cockpit. Hours that have not been saved will not be included in the Timesheet report.

Recommendations

Time Sheet shows a great overview of the hotel’s labor hours. If you wish, you can export the figures into Excel (or PDF) format to use for your own calculations.