Spreadsheet: 593531d1539192058-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 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  | Budgeted Wkly Sales | PTD Labor % | Wkly Hours Allowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  |  | PTD Labor $ Vs Goal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3001 | 4.28 |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4001 | 4.28 |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  | May
Thursday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 6001 | 5.03 |  |  |  |  |  |  |  |  |  |  | June
Friday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 7001 | 5.19 |  |  |  |  |  |  |  |  |  |  | July
Saturday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 8001 | 5.26 |  |  |  |  |  |  |  |  |  |  | August
Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 9001 | 5.31 |  |  |  |  |  |  |  |  |  |  | September
Monday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 10001 | 5.36 |  |  |  |  |  |  |  |  |  |  | October
Tuesday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 11001 | 5.43 |  |  |  |  |  |  |  |  |  |  | November
Wednesday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
Thursday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 6001 | 5.03
Friday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 7001 | 5.19
Saturday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 8001 | 5.26
Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 9001 | 5.31
Monday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 10001 | 5.36
Tuesday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 11001 | 5.43
Wednesday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
Thursday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 6001 | 5.03
Friday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 7001 | 5.19
Saturday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 8001 | 5.26
Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 9001 | 5.31
Monday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 10001 | 5.36
Tuesday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 11001 | 5.43
Wednesday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
Thursday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 6001 | 5.03
Friday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 7001 | 5.19
Saturday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 8001 | 5.26
Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 9001 | 5.31
Monday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 10001 | 5.36
Tuesday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 11001 | 5.43
Wednesday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
Thursday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 6001 | 5.03
Friday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 7001 | 5.19
Saturday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 8001 | 5.26
Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 9001 | 5.31
Monday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 10001 | 5.36
Tuesday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 11001 | 5.43
Wednesday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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