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

Date | 2009-09-06 00:00:00 | 2009-09-07 00:00:00 | 2009-09-08 00:00:00 | 2009-09-09 00:00:00 | 2009-09-10 00:00:00 | 2009-09-11 00:00:00 | 2009-09-12 00:00:00
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Net Sales* | 5177 | 5950
WTD Net Sales |  | 11127 | 11127 | 11127 | 11127 | 11127 | 11127
MTD Net sales | 49223 | 55173 | 55173 | 55173 | 55173 | 55173 | 55173
LY Sales | 7702 | 5516 | 5143 | 5830 | 7033 | 10484 | 12696
LY [NAME] |  | 13218 | 18361 | 24191 | 31224 | 41708 | 54404
LY Sales MTD | 61550 | 67066 | 72209 | 78039 | 85072 | 95556 | 108252
Comp $ +/-       * | -2525 | 434 | -5143 | -5830 | -7033 | -10484 | -12696
WTD Comp  $ +/-       * |  | -2091 | -7234 | -13064 | -20097 | -30581 | -43277
MTD Comp $ +/-        * | -12327 | -11893 | -17036 | -22866 | -29899 | -40383 | -53079
Comp %  +/-       * | -0.4877342090013521 | 0.07294117647058823 | #N/A | #N/A | #N/A | #N/A | #N/A
WTD Comp  % +/-     * |  | -0.1879212725802103 | -0.6501303136514783 | -1.174081064078368 | -1.806147209490429 | -2.748359845421048 | -3.889368203469039
MTD Comp % +/-     * |  | -0.2155583346926939 | -0.3087742192739202 | -0.4144418465553804 | -0.5419136171678176 | -0.7319340982002066 | -0.9620466532543092
Food/Bev Sales | 4489 | 5312
WTD F&B |  | 9801 | 9801 | 9801 | 9801 | 9801 | 9801
LBW Sales | 689 | 638
WTD LBW |  | 1327 | 1327 | 1327 | 1327 | 1327 | 1327
Alcohol Sales Mix   * | 0.1330886613869036 | 0.1072268907563025 | #N/A | #N/A | #N/A | #N/A | #N/A
WTD Alc Mix |  | 0.1192594589736677 | 0.1192594589736677 | 0.1192594589736677 | 0.1192594589736677 | 0.1192594589736677 | 0.1192594589736677
BOH Labor $ | 851 | 713
WTD BOH Labor $ |  | 1564 | 1564 | 1564 | 1564 | 1564 | 1564
BOH Labor Hours | 81 | 66
WTD BOH Labor Hrs |  | 147 | 147 | 147 | 147 | 147 | 147
FOH Labor $ | 302 | 382
WTD FOH Labor $ |  | 684 | 684 | 684 | 684 | 684 | 684
FOH Labor Hours | 93 | 112
WTD FOH Labor Hrs |  | 205 | 205 | 205 | 205 | 205 | 205
BOH Labor %   * | 0.18957451548229 | 0.1342243975903614 | #N/A | #N/A | #N/A | #N/A | #N/A
WTD BOH % |  | 0.1595755535149475 | 0.1595755535149475 | 0.1595755535149475 | 0.1595755535149475 | 0.1595755535149475 | 0.1595755535149475
BOH Productivity   * | 55.41975308641975 | 80.48484848484848 | #N/A | #N/A | #N/A | #N/A | #N/A
WTD BOH Prod |  | 66.6734693877551 | 66.6734693877551 | 66.6734693877551 | 66.6734693877551 | 66.6734693877551 | 66.6734693877551
FOH Labor %   * | 0.05833494301719142 | 0.0642016806722689 | #N/A | #N/A | #N/A | #N/A | #N/A
WTD FOH % |  | 0.06147209490428687 | 0.06147209490428687 | 0.06147209490428687 | 0.06147209490428687 | 0.06147209490428687 | 0.06147209490428687
FOH Productivity   * | 55.66666666666666 | 53.125 | #N/A | #N/A | #N/A | #N/A | #N/A
WTD FOH Prod |  | 54.27804878048781 | 54.27804878048781 | 54.27804878048781 | 54.27804878048781 | 54.27804878048781 | 54.27804878048781
[NAME] | 2283 | 2623
Lunch Sales WTD |  | 4906 | 4906 | 4906 | 4906 | 4906 | 4906
[NAME] | 3341 | 1835 | 1868 | 2126 | 2214 | 2573 | 4887
[NAME] |  | 5176 | 7044 | 9170 | 11384 | 13957 | 18844
"+/-" LY | -1058 | 788 | -1868 | -2126 | -2214 | -2573 | -4887
"+/- [NAME] |  | -270 | -2138 | -4264 | -6478 | -9051 | -13938
DATE | 2009-09-07 00:00:00
DAILY SALES: $ | 5950
[NAME] SALES: $ | 5516
+/- [NAME] | 434
WTD +/- [NAME] | -2091
WTD SALES: $ | 11127
MTD SALES: $ | 55173
FOOD & BEV $ | 5312
LIQUOR MIX: % | 0.1072268907563025
WTD LIQUOR MIX: % | 0.1192594589736677
FOH: $ | 382
FOH HOURS | 112
FOH LABOR: % | 0.0642016806722689
FOH PROD: $ | 53.125
WTD FOH LABOR: % | 0.06147209490428687
BOH: $ | 713
BOH HOURS | 66
BOH LABOR: % | 0.1342243975903614
BOH PROD: $ | 80.48484848484848
WTD BOH LABOR: % | 0.1595755535149475
LUNCH: $ | 2623
LUNCH VS LY | 788
WTD LUNCH VS LY | -270