The Shift Profitability report is a sales report that shows a location or location group’s relative profitability by tracking expenses (through Controllable Costs) against sales revenue. By calculating these values in accordance with a number of customizable percentage metrics, the report displays the operating profits of a location’s labor dayparts, as well as its day and week totals.
Report Usage
This report takes the form of a table of weekdays, which are further split into rows of labor dayparts. Operating profits for each time-period are color-coded according to a heat map percentage scale at the bottom of the report, enabling easy reference and comparison.
By default, entries with no sales data are gray, profits that result in a negative amount will be highlighted a shade of red, and those that result in a positive amount will be a shade of green. This scale can be adjusted by making use of the report's Step 3 options.
Report Features
- Filter by location or location group.
- Filter by start and end dates.
- Use actual COGS Method, or make use of a custom COGS percentage. Custom percentages are calculated in accordance with each period’s sales, then subtracted from the respective operating profits.
- Calculate results according to net or gross sales. View the average results of specific weekdays and dayparts across multi-week periods (see Frequently Asked Questions for more info).
- Use Controllable Expense % to factor in additional expenses as a percentage of each period’s sales. This amount will then be subtracted from the operating profit.
- Adjust the heat map scale with Operating Profiting % Threshold. A % threshold of 50 will map shades of red to operating profits of 50% and below, for example. This report can be viewed/exported in various formats. It can also be directly emailed.
Frequently Asked Questions
Q: Can the report be run for smaller time periods?
A: While you can still view individual days, the report will automatically fill out any weeks that your chosen dates fall upon.
Q: Why do the results seem small when the report is run for more than one week?
A: When you run the report for more than one week, results are given as averages. The number of instances of any given weekday in your time period is shown in parentheses, and each piece of data will be an average of all of its instances.
For example, if your time range contains three Mondays, the report will display the results for the average of those three Mondays. Averages are useful in diagnosing any recurring issues that you may be having on specific days/dayparts, as there is often too much unpredictable variability between single days. For this reason, we recommend a minimum date period of one Quarter when running this report.
Q: How are Totals calculated?
A: Daypart totals are calculated as the total daypart sales / # of included weeks Grand totals (both week and day) are a weighted average of total sales / # of included weeks. WeekPart totals are split into two (Monday to Thursday, and Friday to Sunday). They display total weekpart sales / # of included weeks.