Spreadsheet: 129118d1321457019-sum-of-formula-div-0-when-0-is-entered-updated-carnegie-labor-guide-11-20
Sheet: Labor

 |  |  |  |  |  |  |  |  |  |  | Scheduling Guide and Efficiency - Carnegie
 |  |  |  |  |  |  | Run For Weekending - 11/20/2011
 | BOH |  |  | Sales |  |  |  |  |  |  |  |  |  | Cook/Prep Hours |  |  |  |  |  |  | Expo Hours |  |  |  |  |  |  |  | Dish |  |  |  |  |  |  |  |  |  | Total BOH Hours
 |  |  |  | Proj |  | Actual |  |  |  | Diff |  |  |  | Proj | Norm |  |  | Actual | Efficiency |  | Proj |  | Norm |  | Actual | Efficiency |  |  | Proj |  | Norm |  |  |  | Actual | Efficiency |  |  | Proj |  | Norm |  | Actual | Efficiency
 | Saturday |  |  | 3644 |  | 3644 |  |  |  | 0 |  |  |  | 36.44 | 36.44 |  |  |  | #N/A |  | 7.288 |  | 7.288 |  |  | #N/A |  |  | 10.55503448275862 |  | 10.55503448275862 |  |  |  |  | #N/A |  |  | 54.28303448275863 |  | 54.28303448275863 |  | 0 | #N/A
 | Sunday |  |  | 2591 |  | 2591 |  |  |  | 0 |  |  |  | 33.683 | 33.683 |  |  |  | #N/A |  | 5.182 |  | 5.182 |  |  | #N/A |  |  | 7.50496551724138 |  | 7.50496551724138 |  |  |  |  | #N/A |  |  | 46.36996551724138 |  | 46.36996551724138 |  | 0 | #N/A
 | Monday |  |  | 2202 |  | 2202 |  |  |  | 0 |  |  |  | 28.626 | 28.626 |  |  |  | #N/A |  | 4.12875 |  | 4.12875 |  |  | #N/A |  |  | 6.378206896551725 |  | 6.378206896551725 |  |  |  |  | #N/A |  |  | 39.13295689655173 |  | 39.13295689655173 |  | 0 | #N/A
 | Tuesday |  |  | 1772 |  | 1772 |  |  |  | 0 |  |  |  | 23.036 | 23.036 |  |  |  | #N/A |  | 3.3225 |  | 3.3225 |  |  | #N/A |  |  | 5.132689655172414 |  | 5.132689655172414 |  |  |  |  | #N/A |  |  | 31.49118965517241 |  | 31.49118965517241 |  | 0 | #N/A
 | Wednesday |  |  | 2521 |  | 2521 |  |  |  | 0 |  |  |  | 27.731 | 27.731 |  |  |  | #N/A |  | 4.411750000000001 |  | 4.411750000000001 |  |  | #N/A |  |  | 7.302206896551724 |  | 7.302206896551724 |  |  |  |  | #N/A |  |  | 39.44495689655172 |  | 39.44495689655172 |  | 0 | #N/A
 | Thursday |  |  | 3156 |  | 3156 |  |  |  | 0 |  |  |  | 34.716 | 34.716 |  |  |  | #N/A |  | 5.1285 |  | 5.1285 |  |  | #N/A |  |  | 9.141517241379312 |  | 9.141517241379312 |  |  |  |  | #N/A |  |  | 48.98601724137932 |  | 48.98601724137932 |  | 0 | #N/A
 | Friday |  |  | 4919 |  | 4919 |  |  |  | 0 |  |  |  | 49.19 | 49.19 |  |  |  | #N/A |  | 8.60825 |  | 8.60825 |  |  | #N/A |  |  | 14.24813793103448 |  | 14.24813793103448 |  |  |  |  | #N/A |  |  | 72.04638793103449 |  | 72.04638793103449 |  | 0 | #N/A
 |  |  |  |  |  | 20805 |  |  |  |  |  |  |  | Overall Efficiency |  |  |  |  | #N/A |  | Overall Efficiency |  |  |  |  | #N/A |  |  | Overall Efficiency |  |  |  |  |  |  | #N/A |  |  | Overall Efficiency |  |  |  |  | #N/A
 | Norm Updates with Actual Sales each Day
 | FOH
 |  |  |  | Server |  |  |  |  |  |  |  |  |  | Bartender |  |  |  |  |  |  | Barista |  |  |  |  |  |  |  | Host/Tour |  |  |  |  |  |  |  |  |  | QSS |  |  |  |  |  |  |  |  | Total FOH Hours
 |  | Proj |  | Norm |  | Actual |  |  |  | Efficiency |  |  |  | Proj | Norm |  |  | Actual | Efficiency |  | Proj |  | Norm |  | Actual | Efficiency |  |  | Proj |  | Norm |  |  |  | Actual | Efficiency |  |  | Proj |  | Norm |  | Actual | Efficiency |  |  |  | Proj |  | Norm |  | Actual | Efficiency
 | Sat | 47.90234741784037 |  | 47.90234741784037 |  |  |  |  |  | #N/A |  |  |  | 15.39718309859155 | 15.39718309859155 |  |  |  | #N/A |  | 20.4975 |  | 20.4975 |  |  | #N/A |  |  | 22.5928 |  | 22.5928 |  |  |  |  | #N/A |  |  | 0 |  | 0 |  |  | #N/A |  |  |  | 106.3898305164319 |  | 106.3898305164319 |  | 0 | #N/A
 | Sunday | 34.06009389671362 |  | 34.06009389671362 |  |  |  |  |  | #N/A |  |  |  | 10.94788732394366 | 10.94788732394366 |  |  |  | #N/A |  | 18 |  | 18 |  |  | #N/A |  |  | 16.0642 |  | 16.0642 |  |  |  |  | #N/A |  |  | 0 |  | 0 |  |  | #N/A |  |  |  | 79.07218122065728 |  | 79.07218122065728 |  | 0 | #N/A
 | Mon | 28.94647887323944 |  | 28.94647887323944 |  |  |  |  |  | #N/A |  |  |  | 9.304225352112676 | 9.304225352112676 |  |  |  | #N/A |  | 18 |  | 18 |  |  | #N/A |  |  | 14 |  | 14 |  |  |  |  | #N/A |  |  | 0 |  | 0 |  |  | #N/A |  |  |  | 70.25070422535211 |  | 70.25070422535211 |  | 0 | #N/A
 | [NAME] | 25.78967136150235 |  | 25.78967136150235 |  |  |  |  |  | #N/A |  |  |  | 7.487323943661972 | 7.487323943661972 |  |  |  | #N/A |  | 18 |  | 18 |  |  | #N/A |  |  | 14 |  | 14 |  |  |  |  | #N/A |  |  | 0 |  | 0 |  |  | #N/A |  |  |  | 65.27699530516432 |  | 65.27699530516432 |  | 0 | #N/A
 | Wed | 30.77276995305164 |  | 30.77276995305164 |  |  |  |  |  | #N/A |  |  |  | 10.65211267605634 | 10.65211267605634 |  |  |  | #N/A |  | 18 |  | 18 |  |  | #N/A |  |  | 15.6302 |  | 15.6302 |  |  |  |  | #N/A |  |  | 0 |  | 0 |  |  | #N/A |  |  |  | 75.05508262910797 |  | 75.05508262910797 |  | 0 | #N/A
 | Thu | 38.52394366197183 |  | 38.52394366197183 |  |  |  |  |  | #N/A |  |  |  | 13.33521126760563 | 13.33521126760563 |  |  |  | #N/A |  | 18 |  | 18 |  |  | #N/A |  |  | 19.5672 |  | 19.5672 |  |  |  |  | #N/A |  |  | 0 |  | 0 |  |  | #N/A |  |  |  | 89.42635492957747 |  | 89.42635492957747 |  | 0 | #N/A
 | Fri | 64.66291079812207 |  | 64.66291079812207 |  |  |  |  |  | #N/A |  |  |  | 19.62981220657277 | 19.62981220657277 |  |  |  | #N/A |  | 27.669375 |  | 27.669375 |  |  | #N/A |  |  | 30.4978 |  | 30.4978 |  |  |  |  | #N/A |  |  | 0 |  | 0 |  |  | #N/A |  |  |  | 142.4598980046948 |  | 142.4598980046948 |  | 0 | #N/A
 |  |  |  | Overall Efficiency |  |  |  |  |  | #N/A |  |  |  | Overall Efficiency |  |  |  |  | #N/A |  | Overall Efficiency |  |  |  |  | #N/A |  |  | Overall Efficiency |  |  |  |  |  |  | #N/A |  |  | Overall Efficiency |  |  |  |  | #N/A |  |  |  | Overall Efficiency |  |  |  |  | #N/A
 | Norm Updates with Actual Sales each Day
 | Norm Calculator
 | Position |  |  |  | Hours |  |  |  | Money
 | Cook/Prep |  |  |  | 233.422 |  |  |  |  | 2334.22
 | Expo |  |  |  | 38.06975 |  |  |  |  | 304.558
 | Dish |  |  |  | 60.26275862068966 |  |  |  |  | 436.905
 | Server |  |  |  | 270.6582159624413 |  |  |  |  | 576.502
 | Bartender |  |  |  | 86.7537558685446 |  |  |  |  | 184.7855
 | Barista |  |  |  | 138.166875 |  |  |  |  | 1139.87671875
 | Host Tour |  |  |  | 132.3522 |  |  |  |  | 661.761
 | QSS |  |  |  | 0 |  |  |  |  | 0
 | Shift Lead |  |  |  | N/A |  |  |  |  | N/A
 |  |  |  |  |  |  |  |  |  | 5638.60821875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOURLY SALES GUIDE IN PROGRESS…
 | Hourly | Monday |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  | Wednesday |  |  |  |  |  | Thursday |  |  |  |  | Friday |  |  |  |  |  | Saturday |  |  |  |  |  |  | Sunday
 | Sales | Proj |  |  | Actual |  |  |  | Proj |  |  |  | Actual |  |  | Proj |  |  |  | Actual |  | Proj |  | Actual |  |  | Proj |  |  | Actual |  |  | Proj |  |  |  |  | Actual |  | Proj |  | Actual
 | 10:00 AM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 11:00 AM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 12:00 PM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 1:00 PM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 2:00 PM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 3:00 PM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 4:00 PM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 5:00 PM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 6:00 PM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 7:00 PM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 8:00 PM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 9:00 PM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 10:00 PM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 11:00 PM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1 |  | 1 |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  | 1 |  | 1 |  | 1
 | 12:00AM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 1:00AM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 2:00AM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 | 3:00AM | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0