Spreadsheet: 52559d1252413933-help-with-a-formula-referencing-multiple-tabs-sept-09-sales-and-labor
Sheet: Sept Wk 1

Date | 2009-08-30 00:00:00 | 2009-08-31 00:00:00 | 2009-09-01 00:00:00 | 2009-09-02 00:00:00 | 2009-09-03 00:00:00 | 2009-09-04 00:00:00 | 2009-09-05 00:00:00
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Net Sales* | 5812 | 5461 | 4723 | 5721 | 4093 | 8678 | 9558
WTD Net Sales |  | 11273 | 15996 | 21717 | 25810 | 34488 | 44046
MTD Net sales |  | 11273 | 15996 | 21717 | 25810 | 34488 | 44046
LY Sales | 8587 | 8269 | 4782 | 6429 | 5436 | 11033 | 9312
LY [NAME] |  | 16856 | 21638 | 28067 | 33503 | 44536 | 53848
LY Sales MTD |  | 16856 | 21638 | 28067 | 33503 | 44536 | 53848
Comp $ +/-       * | -2775 | -2808 | -59 | -708 | -1343 | -2355 | 246
WTD Comp  $ +/-       * |  | -5583 | -5642 | -6350 | -7693 | -10048 | -9802
MTD Comp $ +/-        * |  | -5583 | -5642 | -6350 | -7693 | -10048 | -9802
Comp %  +/-       * | -0.4774604267033724 | -0.514191540010987 | -0.0124920601312725 | -0.1237545883586786 | -0.3281211825067188 | -0.2713758930629177 | 0.02573760200878845
WTD Comp  % +/-     * |  | -0.4952541470770869 | -0.3527131782945737 | -0.2923976608187134 | -0.2980627663696242 | -0.2913477151472976 | -0.2225400717431776
MTD Comp % +/-     * |  | -0.4952541470770869 | -0.3527131782945737 | -0.2923976608187134 | -0.2980627663696242 | -0.2913477151472976 | -0.2225400717431776
Food/Bev Sales | 4842 | 4471 | 3876 | 4415 | 3302 | 6710 | 7810
WTD F&B |  | 9313 | 13189 | 17604 | 20906 | 27616 | 35426
LBW Sales | 971 | 990 | 846 | 1272 | 775 | 1967.72 | 1729
WTD LBW |  | 1961 | 2807 | 4079 | 4854 | 6821.72 | 8550.720000000001
Alcohol Sales Mix   * | 0.1670681348933241 | 0.1812854788500275 | 0.1791234384924836 | 0.2223387519664394 | 0.1893476667481065 | 0.2267480986402397 | 0.1808955848503871
WTD Alc Mix |  | 0.1739554688193028 | 0.1754813703425857 | 0.1878252060597689 | 0.1880666408368849 | 0.1977998144282069 | 0.1941315897016755
BOH Labor $ | 855 | 762 | 470 | 859 | 707 | 1109 | 1163
WTD BOH Labor $ |  | 1617 | 2087 | 2946 | 3653 | 4762 | 5925
BOH Labor Hours | 79 | 68 | 46 | 71 | 65 | 101 | 105
WTD BOH Labor Hrs |  | 147 | 193 | 264 | 329 | 430 | 535
FOH Labor $ | 313 | 361 | 299 | 356 | 312 | 495 | 471
WTD FOH Labor $ |  | 674 | 973 | 1329 | 1641 | 2136 | 2607
FOH Labor Hours | 107 | 112 | 83 | 122 | 98 | 156 | 152
WTD FOH Labor Hrs |  | 219 | 302 | 424 | 522 | 678 | 830
BOH Labor %   * | 0.1765799256505576 | 0.1704316707671662 | 0.1212590299277606 | 0.194563986409966 | 0.2141126589945488 | 0.1652757078986587 | 0.1489116517285531
WTD BOH % |  | 0.1736282615698486 | 0.1582379255440139 | 0.1673483299250171 | 0.1747345259734048 | 0.172436268829664 | 0.1672500423417829
BOH Productivity   * | 61.29113924050633 | 65.75 | 84.26086956521739 | 62.1830985915493 | 50.8 | 66.43564356435644 | 74.38095238095238
WTD BOH Prod |  | 63.35374149659864 | 68.33678756476684 | 66.68181818181819 | 63.54407294832827 | 64.22325581395349 | 66.21682242990654
FOH Labor %   * | 0.05385409497591191 | 0.06610510895440395 | 0.06330721998729621 | 0.06222688341199091 | 0.07622770583923773 | 0.05704079280940309 | 0.04927809165097301
WTD FOH % |  | 0.05978887607557882 | 0.06082770692673168 | 0.06119629783119215 | 0.06358000774893452 | 0.06193458594293667 | 0.05918812150933116
FOH Productivity   * | 54.3177570093458 | 48.75892857142857 | 56.90361445783132 | 46.89344262295082 | 41.76530612244898 | 55.62820512820513 | 62.88157894736842
WTD FOH Prod |  | 51.47488584474886 | 52.96688741721854 | 51.21933962264151 | 49.44444444444444 | 50.86725663716814 | 53.06746987951807
[NAME] | 2798 | 2288 | 1259 | 2392 | 965 | 2951 | 2569
Lunch Sales WTD |  | 5086 | 6345 | 8737 | 9702 | 12653 | 15222
[NAME] | 3001 | 2201 | 1864 | 2030 | 1998 | 3239 | 3541
[NAME] |  | 5202 | 7066 | 9096 | 11094 | 14333 | 17874
"+/-" LY | -203 | 87 | -605 | 362 | -1033 | -288 | -972
"+/- [NAME] |  | -116 | -721 | -359 | -1392 | -1680 | -2652
DATE | 2009-09-07 00:00:00
DAILY SALES: $ | 9558
[NAME] SALES: $ | 9312
+/- [NAME] | 246
WTD SALES: $ | 44046
MTD SALES: $ | 44046
FOOD & BEV $ | 7810
LIQUOR MIX: % | 0.1808955848503871
WTD LIQUOR MIX: % | 0.1941315897016755
FOH: $ | 471
FOH HOURS | 152
FOH LABOR: % | 0.04927809165097301
FOH PROD: $ | 62.88157894736842
WTD FOH LABOR: % | 0.05918812150933116
BOH: $ | 1163
BOH HOURS | 105
BOH LABOR: % | 0.1489116517285531
BOH PROD: $ | 74.38095238095238
WTD BOH LABOR: % | 0.1672500423417829
LUNCH: $ | 2569
LUNCH VS LY | -972