Table explained

Contents:

What and how

Screen explained

Adjust pickup on total segment level

Adjust pickup on segment level

Pinning functionality

Calculations

What and How?

Useful to view and adjust your Live forecast at a day-by-day level (Room nights and ARR). Depending on your specific property you can adjust the pickup on either total segment level (the entire lump sum) or segment level i.e. Crew, Business, Complimentary and so on. We recommend you review and adjust the figures in the table or daily to ensure the Live forecast for the coming 3 weeks is a accurate as possible. Switch between table and graph views with the icon in the top left corner. All changes made reflects in the graph. Changes cannot be made to passed days, only current and future days. Revenue changes not made here. Use “Reset” to reset changes. When the date picker is in the default selected period, Month or Months, click on a future date and use the text box in the pickup column to adjust your Live forecast. You can add/edit notes on a daily basis, this can be viewed in the graph.

Screen explained

The screen is divided into 3 sections: Room nights/Guest nights, Average room revenue and Revenue. General button logic applies for this module as in all other modules in PMI, i.e. blue is an action required or not done (i.e. unsaved changes) and white if option to make a change exists, but not a call for action.

Detailed description of the comparative data

  1. Export – export data to Microsoft Excel or Google Sheets. Useful for creating reports and analysis. print.
  2. Reset table view – it resets any changes you make to the set up. I.e. if you pin a column left/right you can reset
  3. Use PMI Prediction – When this button is activated you are choosing to accept and use PMI Prediction instead of your Live forecast figures. PMI uses a combination of Machine Learning (ML) and statistical models to automate forecasting of revenue and units (covers, room nights, guest nights etc.). It uses historical data to identify trends (seasons) and adapts to specific properties over time based on their activity. Your Live forecast figures are changed to what PMI Prediction is for the period. Full amount is broken down on a day-to-day level so it spreads the full amount. Read more PMI Prediction explanation
  4. Notes – Here you find the overview of all notes made by you and your colleagues. This makes is easy to understand and follow up on changes made to a specific forecast. Notes can only be edited in the table, and view only in the graph. The amount of notes are always displayed in the Notes button. Notes can be viewed on the graph and Management Perspective and so on. 3 grey dots indicate no notes for a particular day. Hover over 3 grey dots, click to activate. Add your comment and save. 3 blue dots now appear, a comment is saved. Hover over it, click to activate and read or edit the comment. Example of a note can be anything from a last minute cancellation that affected the numbers negatively or a large flight cancellation that added a spike in the numbers.
  5. Reset – This button is greyed out until changes are made and saved. It is highlighted in blue when its ready to use. It undoes any (saved) changes which were made to any editable rows in the table or graph. This cannot be undone and any previous changes made would be lost. The amount of notes are always displayed.
  6. Save – This button ensures all your changes are saved. These are instantly reflected throughout the screen. A note appears in the right hand corner informing you that your changes have been successful or not.
  7. Scroll arrows – Click on the arrow (left or right) to scroll the screen in the corresponding direction.
  8. Expand all – By activating this functionality you populate the table with all the active room segments available at the property.
  9. Pinning functionality – Click on the 3 lines next to a header in Room nights, Average room revenue or Revenue. Here you can pin a column to the left or right, auto size columns and reset columns. You can also remove a column by hovering over the specific header and moving it out of the screen. Use Reset Columns to undo.
  1. Columns in the table are selected in the view settings. Hover over headers, a brief explanation appears, Room Nights/Guest Nights, Average Room Revenue and Revenue (see below for the listing)  
    • Last Year – Last year displayed by same date or weekday, depending on view settings. Lets you compare red apples to red apples
    • Budget/Target– Your submitted budget/target
    • Forecast – Your submitted monthly forecast
    • OTB – latest imported on the book figures with a date stamp. PMI works optimally when updated daily
    • Tentative – latest imported tentative figures with a date stamp. PMI works optimally when updated daily
    • Pickup – Make your changes on total or segment level for a specific day. This is property specific. Please check with your Controller to confirm
    • Live forecast – Your last saved forecast. Days in the past show actual results
    • Act vs Live forecast – How accurate is your forecasting on a daily level? How much in % value was realised in correlation to the Live forecast
    • PMI Prediction – A fully automated forecast generated by PMI’s algorithm, created without any human input. Click on a specific figure in the future and a popup with all the relevant data appears. More information follows below. Click on a specific value in the future and understand how it came to be.
  • Auto icon – PMI updates the Live forecast. Click on icon and
  • It changes from automated to manual icon for that specific day. Input box is activated, add in your values. Input box for the ARR pickup also activated. We recommend you double check ARR and adjust as needed. Don’t forget to Save. To reset, click Reset on the screen.
  • All changes made in the table are displayed in the graph, and throughout the various modules in PMI.
  • Import icon – The Live forecast is imported from external source.
  • During the last update PMI found too few historical days to compare the date to. Review the selected season for the current date.

  • Notes can only be added or edited for one day at a time in the table. Notes can be viewed on the graph and Management Perspective and so on. 3 gray dots indicate no notes for a particular day. Hover over 3 gray dots, click to activate. Add your comment and save. 3 blue dots now appear, a comment is saved. Hover over it, click to activate and read or edit the comment. Example of a note can be anything from a last minute cancellation that affected the numbers negatively or a large flight cancellation that added a spike in the numbers.

Adjust pickup on segment level

  • Click on auto icon to activate and do your manual changes.
  • Don’t forget to save. “Save” changes from grey to blue in the top right corner of the table/graph tile.

Adjust pickup on total segment level

  1. Click on auto icon to activate and do your manual changes.
  2. Don’t forget to save. “Save” changes from grey to blue in the top right corner of the table/graph tile.

Calculations

What is the PMI prediction algorithm? When clicking on a specific date in PMI prediction column, the PMI forecast algorithm appears. Here you have an overview of which historical dates was used to predict the day and those not used.

Was this article helpful?

Related Articles