Consider the scenario where a manager wants the Kitchen and Server schedules to be based on other department sales.
The table below lists three departments, the department sales, and an “X“ indicating if that department will be included in a schedule’s projection metrics.
The sum of all department sales will equal the total sales for the entire store.
Each scheduled sales value will be less than or equal to the store-wide sales.
Instead of using department sales directly, our system calculates averages over six weeks, ending with the last date of recorded sales.
An average is calculated for each day of the week. For example, an average is calculated for six consecutive Mondays.
For each day of the week grouping, we remove outliers with more than one standard deviation away from our mean.
Department Name | Department Sales | Kitchen Schedule | Server Schedule |
---|
Food | $1000 | X | X |
Liquor | $500 | | X |
Catering | $250 | X | |
Total Sales | $1750 | $1250 | $1500 |