GM daily digest: Waterfall chart explained

Contents: 

What does the waterfall chart show and how does it work

Waterfall chart data sources for properties with PMI Planning 

Waterfall chart data sources for properties without PMI Planning 

What does the waterfall chart show and how does it work? 

The waterfall chart is designed as a visual representation of your profit and loss report with details showing how you are pacing against targets set, and where you can expect to be at the end of the month. All data is updated each morning with the latest imports in PMI. (if not, this is likely caused by data feed or mapping being incomplete). 

The revenue bars move from left to right to build up total revenue, and the costs move from right to left, deducting from the revenue to leave you with your gross operating profit (GOP). Note – GOP will not be the final accounting profit for the organization because costs such as depreciation, rent and loan interest are deducted after this line. 

Legend: 

  1. The black line represents your goal, either static forecast or budget depending on the view you have selected. 
  1. The grey bar represents our month end prediction (also known as live forecast) – based on how you are doing to date. This is where we expect you to be at the end of the month.
  1. The colored bars (green, amber, and red) represent how you are doing compared to goal MTD (month-to-date). 
    1. Green bar shows you are on pace to meet or exceed your goal, amber – near pace (within 5% to be on pace) and red – off pace to reach your goal. 

4. The dotted line on the hours bar represents pace to goal – the maximum number of hours you should have used to date, in order to meet your goal for the month. Note, the month end prediction (grey bar) will likely be longer than the goal line when revenue is higher than forecasted. 

Waterfall chart data sources for properties with PMI Planning 

When viewing a past month 

  1. The Goal lines are your last approved budget or forecast as selected. 
  1. All actual figures (colored bars) are from the P&L report created in Planning named ‘GM daily digest.’ Click on the P&L menu icon, go to reports and select GM daily digest to view the report. 
    1. To give time for the finance team to prepare and update their P&L report, the P&L is used as the data source only after the offset days as set in PMI settings. Before this date, sources for waterfall chart follow the current month logic. 

When viewing a current month 

  1. The Goal lines are your last approved budget or forecast as selected. 
  1. The Pace to goal (dotted lines) shows where you should be today to meet your goal, based on your live forecast.  
  1. The month end expectation (grey bars) is based on the live forecast 
    1. All revenue lines: Live forecast values 
    2. Labor cost: Live forecast hours * current hourly rate as set in the cockpit 
    3. Food cost: MTD goods received values recorded in food cost cockpit + food revenue forecast for remainder of month * food cost % 
    4. Cost of sales: P&L WiP forecast 
    5. Other oper. costs: P&L WiP forecast 
    6. Total oper. costs: Sum of all cost lines 
    7. GOP: Total revenue minus total operating costs 
  1. The month-to-date (colored bars) are actual figures, updated each morning 
    1. All revenue lines: MTD actual figures from R&P 
    2. Labor cost: MTD actual hours * current hourly rate as in labor cockpits 
    3. Food cost: MTD actual goods received values as recorded in food cost cockpit 
    4. Cost of sales: MTD P&L WiP forecast 
    5. Other oper. costs: MTD P&L WiP forecast 
    6. Total oper. costs: Sum of all cost lines 
    7. GOP: Total revenue lines minus total operating costs 

When viewing a future month 

  1. The Goal lines are your last approved budget or forecast depending on comparison selected. 
  1. The month end expectations (grey bars) are based on the live forecast 
    1. All revenue lines: Live forecast 
    2. Labor cost: Static forecast hours * current hourly rate as in labor cockpits 
    3. Food cost: WiP food revenue forecast * forecast food cost % from the food cost cockpit 
    4. COS: P&L WiP forecast 
    5. Other oper. costs: P&L WiP forecast 
    6. Total oper. costs: Sum of all cost lines 
    7. GOP: Total revenue – total oper. costs in graphic 
  1. There are no colored bars for future months, as no actual results yet recorded 

Waterfall chart data sources for properties without PMI Planning 

For properties without PMI Planning there is no Profit and Loss data imported in PMI which limits the information we have available to display, so the waterfall chart will appear as incomplete. To find out more about PMI Planning module, please contact support. 

When viewing a past month 

  1. The Goal lines are your last approved budget or forecast depending on comparison selected. 
  1. MTD actual figures (colored bars) are based on actual results as shown in PMI 
    1. All revenue lines: Actual values as shown in management perspective 
    2. Labor cost: Actual hours * current hourly rate as set in the cockpit 
    3. Food cost: Actual goods received values recorded in food cost cockpit  

When viewing a current month 

  1. The Goal lines are your last approved budget or forecast depending on comparison selected. 
  1. The Pace to goal (dotted lines) shows where you should be today to meet your goal, based on your live forecast.
  2. The month end expectations (grey bars) are based on the live forecast 
    1. All revenue lines: Live forecast 
    2. Labor cost: Live forecast hours * current hourly rate as set in the cockpit 
    3. Food cost: MTD goods received values recorded in food cost cockpit + food revenue forecast for remainder of month * food cost % 
  1. The month to date (colored bars) are actual figures, updated each morning 
    1. All revenue lines: MTD figures from R&P 
    2. Labor cost: MTD hours * current hourly rate as in labor cockpits 
    3. Food cost: MTD goods received values as recorded in food cost cockpit 

When viewing a future month 

  1. The Goal lines are your last approved budget or forecast depending on comparison selected. 
  1. The month end expectations (grey bars) are based on the live forecast 
    1. All revenue lines: Live forecast 
    2. Labor cost: Static forecast hours * current hourly rate as in labor cockpits 
    3. Food cost: WiP food revenue forecast * forecast food cost % from the food cost cockpit 

Was this article helpful?

Related Articles