Spreadsheet: 593644d1539261320-dynamicaly-linked-cells-based-on-the-month-test-labor-tracker
Sheet: Weekly Projections

Month: |  | Period Labor Tracker | Period Labor Tracker |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store# : |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January
Labor Goal % |  | Avg. Hrly Rate |  | Check Average |  | 2018 |  |  |  |  |  | 0 | 0 |  |  |  |  | Budgeted Wkly Sales | PTD Labor % | Wkly Hours Allowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  | 10 |  |  |  |  |  | PTD Labor $ Vs Goal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3001 | 4.28 |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4001 | 4.28 |  |  |  | 2018-10-01 00:00:00 |  |  |  |  |  |  | April
Week 1 |  | Prior Year Sales | Prior Year Meals | Prior Week Sales | Fore-cast Meals | Fore-Cast Sales | Actual Meals | Actual Sales | Actual Vs Fore-cast | Scheduled Labor $ | Sched. Server Hours | Sched. Server Par Staff | Actual Labor $ | Actual Vs Sched. $ | Sched. Labor % | Actual Labor   % | Actual Server Hours | Actual Server Par Staff | Prod-uctivity Var. (Hours) | [NAME] to Schedule | TRENDING OVER GOAL |  |  |  |  |  |  |  |  |  |  | 5001 | 4.79 |  |  |  | 2018-10-01 00:00:00 |  |  |  |  |  |  | May
2018-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 6001 | 5.03 |  |  |  |  |  |  |  |  |  |  | June
2018-10-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 7001 | 5.19 |  |  |  |  |  |  |  |  |  |  | July
2018-10-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 8001 | 5.26 |  |  |  |  |  |  |  |  |  |  | August
2018-10-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 9001 | 5.31 |  |  |  |  |  |  |  |  |  |  | September
2018-10-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 10001 | 5.36 |  |  |  |  |  |  |  |  |  |  | October
2018-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 11001 | 5.43 |  |  |  |  |  |  |  |  |  |  | November
2018-10-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 12001 | 5.45 |  |  |  |  |  |  |  |  |  |  | December
Total |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 13001 | 5.47
 |  |  | FORECAST VS L/Y |  |  |  |  |  |  |  | CURRENT SALES GC VS LY |  |  | 0 |  | TREND IS OVER...CUT! |  |  | EST.
 |  |  | CURRENT MEALS GC VS LY: |  |  |  |  |  |  |  | CURRENT WEEKS SCEDULE VS GOAL
Labor Goal % |  | Avg. Hrly Rate |  | Check Average |  |  |  |  |  |  |  |  |  |  |  |  |  | Budgeted Wkly Sales | PTD Labor % | Wkly Hours Allowed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3001 | 4.28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4001 | 4.28
Week 2 |  | Prior Year Sales | Prior Year Meals | Prior Week Sales | Fore-cast Meals | Fore-Cast Sales | Actual Meals | Actual Sales | Actual Vs Fore-cast | Scheduled Labor $ | Sched. Server Hours | Sched. Server Par Staff | Actual Labor $ | Actual Vs Sched. $ | Sched. Labor % | Actual Labor   % | Actual Server Hours | Actual Server Par Staff | Prod-uctivity Var. (Hours) | [NAME] to Schedule | TRENDING OK |  |  |  |  |  |  |  |  |  |  | 5001 | 4.79
2018-10-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 6001 | 5.03
2018-10-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 7001 | 5.19
2018-10-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 8001 | 5.26
2018-10-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 9001 | 5.31
2018-10-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 10001 | 5.36
2018-10-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 11001 | 5.43
2018-10-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 12001 | 5.45
Total |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 13001 | 5.47
 |  |  | FORECAST VS L/Y |  |  |  |  |  |  |  | CURRENT WEEKS GC VS LY |  |  | 0 |  | TREND IS OVER...CUT! |  |  | EST.
 |  |  | CURRENT MEALS GC VS LY: |  |  |  |  |  |  |  | CURRENT WEEKS SCEDULE VS GOAL
Labor Goal % |  | Avg. Hrly Rate |  | Check Average |  |  |  |  |  |  |  |  |  |  |  |  |  | Budgeted Wkly Sales | PTD Labor % | Wkly Hours Allowed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3001 | 4.28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4001 | 4.28
Week 3 |  | Prior Year Sales | Prior Year Meals | Prior Week Sales | Fore-cast Meals | Fore-Cast Sales | Actual Meals | Actual Sales | Actual Vs Fore-cast | Scheduled Labor $ | Sched. Server Hours | Sched. Server Par Staff | Actual Labor $ | Actual Vs Sched. $ | Sched. Labor % | Actual Labor   % | Actual Server Hours | Actual Server Par Staff | Prod-uctivity Var. (Hours) | [NAME] to Schedule | TRENDING OK |  |  |  |  |  |  |  |  |  |  | 5001 | 4.79
2018-10-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 6001 | 5.03
2018-10-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 7001 | 5.19
2018-10-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 8001 | 5.26
2018-10-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 9001 | 5.31
2018-10-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 10001 | 5.36
2018-10-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 11001 | 5.43
2018-10-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 12001 | 5.45
Total |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 13001 | 5.47
 |  |  | FORECAST VS L/Y |  |  |  |  |  |  |  | CURRENT WEEKS GC VS LY |  |  | 0 |  | TREND IS OVER...CUT! |  |  | EST.
 |  |  | CURRENT MEALS GC VS LY: |  |  |  |  |  |  |  | CURRENT WEEKS SCEDULE VS GOAL
Labor Goal % |  | Avg. Hrly Rate |  | Check Average |  |  |  |  |  |  |  |  |  |  |  |  |  | Budgeted Wkly Sales | PTD Labor % | Wkly Hours Allowed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3001 | 4.28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4001 | 4.28
Week 4 |  | Prior Year Sales | Prior Year Meals | Prior Week Sales | Fore-cast Meals | Fore-Cast Sales | Actual Meals | Actual Sales | Actual Vs Fore-cast | Scheduled Labor $ | Sched. Server Hours | Sched. Server Par Staff | Actual Labor $ | Actual Vs Sched. $ | Sched. Labor % | Actual Labor   % | Actual Server Hours | Actual Server Par Staff | Prod-uctivity Var. (Hours) | [NAME] to Schedule | TRENDING OK |  |  |  |  |  |  |  |  |  |  | 5001 | 4.79
2018-10-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 6001 | 5.03
2018-10-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 7001 | 5.19
2018-10-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 8001 | 5.26
2018-10-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 9001 | 5.31
2018-10-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 10001 | 5.36
2018-10-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 11001 | 5.43
2018-10-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 12001 | 5.45
Total |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 13001 | 5.47
 |  |  | FORECAST VS L/Y |  |  |  |  |  |  |  | CURRENT WEEKS GC VS LY |  |  | 0 |  | TREND IS OVER...CUT! |  |  | EST.
 |  |  | CURRENT MEALS GC VS LY: |  |  |  |  |  |  |  | CURRENT WEEKS SCEDULE VS GOAL
Labor Goal % |  | Avg. Hrly Rate |  | Check Average |  |  |  |  |  |  |  |  |  |  |  |  |  | Budgeted Wkly Sales | PTD Labor % | Wkly Hours Allowed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3001 | 4.28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4001 | 4.28
Week 5 |  | Prior Year Sales | Prior Year Meals | Prior Week Sales | Fore-cast Meals | Fore-Cast Sales | Actual Meals | Actual Sales | Actual Vs Fore-cast | Scheduled Labor $ | Sched. Server Hours | Sched. Server Par Staff | Actual Labor $ | Actual Vs Sched. $ | Sched. Labor % | Actual Labor   % | Actual Server Hours | Actual Server Par Staff | Prod-uctivity Var. (Hours) | [NAME] to Schedule | TRENDING OK |  |  |  |  |  |  |  |  |  |  | 5001 | 4.79
2018-10-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 6001 | 5.03
2018-10-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 7001 | 5.19
2018-10-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 8001 | 5.26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 9001 | 5.31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 10001 | 5.36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 11001 | 5.43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 12001 | 5.45
Total |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 13001 | 5.47
 |  |  | FORECAST VS L/Y |  |  |  |  |  |  |  | CURRENT WEEKS GC VS LY |  |  | 0 |  | TREND IS OVER...CUT! |  |  | EST.
 |  |  | CURRENT MEALS GC VS LY: |  |  |  |  |  |  |  | CURRENT WEEKS SCEDULE VS GOAL
WEEK TO DATE VS LAST YEAR CALCULATOR
PY |  | CY
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
 |  |  |  | 0 | 0
PY |  | CY
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
 |  |  |  | 0 | 0
PY |  | CY
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
 |  |  |  | 0 | 0
PY |  | CY
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
0 |  | 0 |  | 0
 |  |  |  | 0 | 0