Spreadsheet: 116109d1311605858-excel-2007-hours-and-minutes-to-decimal-weekly-costs-2011
Sheet: Old Labor

WEEK OF: |  |  | 5/24/2010 - 5/30/2010
SERVERS | Hours | Wages | w/Fica | BAR | Hours | Wages | w/Fica | BUS | Hours | Wages | w/Fica |  | ACTUAL SALES $ |  |  | ACTUAL SALES $ |  |  | ACTUAL SALES $
[NAME] |  | 0 |  | [NAME] |  | 0 |  | LeeAnn |  | 0 |  |  | ACTUAL LABOR $ |  |  | ACTUAL LABOR $ |  |  | ACTUAL LABOR $
[NAME] |  | 0 |  | [NAME] | 39.77 | 377.8150000000001 |  | [NAME] |  | 0 |  |  | ACTUAL LABOR % |  |  | ACTUAL LABOR % |  |  | ACTUAL LABOR %
[NAME] |  | 0 |  | [NAME]   (ot) |  | 0 |  | Emma |  | 0 |  |  | FOH LABOR $ |  |  | FOH LABOR $ |  |  | FOH LABOR $
Jared |  | 0 |  | [NAME] |  | 0 |  | Cassidy |  | 0 |  |  | FOH LABOR % |  |  | FOH LABOR % |  |  | FOH LABOR %
[NAME] |  | 0 |  | [NAME] |  | 0 |  | [NAME] |  | 0 |  |  | KITCH LABOR $ |  |  | KITCH LABOR $ |  |  | KITCH LABOR $
[NAME] |  | 0 |  | [NAME] |  | 0 |  | Cody S |  | 0 |  |  | KITCH LABOR % |  |  | KITCH LABOR % |  |  | KITCH LABOR %
[NAME] |  | 0 |  | [NAME] |  | 0 |  | Vicky |  | 0 |  |  | PL LABOR $ |  |  | PL LABOR $ |  |  | PL LABOR $
[NAME] |  | 0 |  | Jessica |  | 0 |  | [NAME] |  | 0 |  |  | PL LABOR % |  |  | PL LABOR % |  |  | PL LABOR %
Kathy |  | 0 |  | [NAME] |  | 0 |  | [NAME] |  | 0 |  |  | BOH LABOR $ |  |  | BOH LABOR $ |  |  | BOH LABOR $
[NAME] |  | 0 |  | Jared |  | 0 |  | Sean |  | 0 |  |  | BOH LABOR % |  |  | BOH LABOR % |  |  | BOH LABOR %
[NAME] |  | 0 |  |  |  |  |  | HOST | Hours | Wages | w/Fica
Candace |  | 0 |  |  |  |  |  | Cassidy |  | 0
[NAME] |  | 0 |  |  |  |  |  | Faryn |  | 0
[NAME] |  | 0 |  |  |  |  |  | [NAME] |  | 0 |  |  | ACTUAL SALES $ |  |  | ACTUAL SALES $ |  |  | ACTUAL SALES $
[NAME] |  | 0 |  |  |  |  |  | [NAME] |  | 0 |  |  | ACTUAL LABOR $ |  |  | ACTUAL LABOR $ |  |  | ACTUAL LABOR $
 |  | 0 |  |  |  |  |  | [NAME] |  | 0 |  |  | ACTUAL LABOR % |  |  | ACTUAL LABOR % |  |  | ACTUAL LABOR %
 |  | 0 |  |  |  |  |  | [NAME] |  | 0 |  |  | FOH LABOR $ |  |  | FOH LABOR $ |  |  | FOH LABOR $
 |  | 0 |  | Exp |  | 0 |  | [NAME] |  | 0 |  |  | FOH LABOR % |  |  | FOH LABOR % |  |  | FOH LABOR %
Training |  | 0 |  | Training |  | 0 |  | [NAME] |  | 0 |  |  | KITCH LABOR $ |  |  | KITCH LABOR $ |  |  | KITCH LABOR $
Server OT |  | 0 |  | Bar OT | 13 | 126.75 |  | [NAME] |  | 0 |  |  | KITCH LABOR % |  |  | KITCH LABOR % |  |  | KITCH LABOR %
Total Server | 0 | 0 | 0 | Total Bar | 52.77 | 504.5650000000001 | 590.3410500000001 | Total Support | 0 | 0 | 0 |  | PL LABOR $ |  |  | PL LABOR $ |  |  | PL LABOR $
 |  |  |  |  |  |  |  |  |  |  |  |  | PL LABOR % |  |  | PL LABOR % |  |  | PL LABOR %
KITCHEN | Hours | Wages | w/Fica | KITCHEN | Hours | Wages | w/Fica | PL | Hours | Wages | w/Fica |  | BOH LABOR $ |  |  | BOH LABOR $ |  |  | BOH LABOR $
[NAME] |  | 0 |  | [NAME] |  | 0 |  | [NAME] |  | 0 |  |  | BOH LABOR % |  |  | BOH LABOR % |  |  | BOH LABOR %
[NAME]  (ot) |  | 0 |  | [NAME](ot) |  | 0 |  | [NAME]ot) |  | 0
[NAME] |  | 0 |  | [NAME] |  | 0 |  | [NAME] | 38.4 | 384
[NAME]   (ot) |  | 0 |  | [NAME]   (ot) |  | 0 |  | [NAME]   (ot) |  | 0
[NAME] |  | 0 |  | [NAME] |  | 0 |  | [NAME] |  | 0 |  |  | ACTUAL SALES $ |  |  | ACTUAL SALES $ |  |  | ACTUAL SALES $
[NAME]ot) |  | 0 |  | [NAME]   (ot) |  | 0 |  | Abby/Mike |  | 0 |  |  | ACTUAL LABOR $ |  |  | ACTUAL LABOR $ |  |  | ACTUAL LABOR $
Victoria |  | 0 |  | Brownie |  | 0 | ??? | [NAME] |  | 0 |  |  | ACTUAL LABOR % |  |  | ACTUAL LABOR % |  |  | ACTUAL LABOR %
Victoria   (ot) |  | 0 |  | Brownie  (ot) |  | 0 |  | [NAME]   (ot) |  | 0 |  |  | FOH LABOR $ |  |  | FOH LABOR $ |  |  | FOH LABOR $
[NAME] |  | 0 |  | [NAME] |  | 0 |  | TOTAL PL | 38.4 | 384 | 449.28 |  | FOH LABOR % |  |  | FOH LABOR % |  |  | FOH LABOR %
[NAME]  (ot) |  | 0 |  | [NAME]) |  | 0 |  | R & P | Hours | Wages | w/Fica |  | KITCH LABOR $ |  |  | KITCH LABOR $ |  |  | KITCH LABOR $
Vicente |  | 0 |  | George |  | 0 |  | George | 28 | 252 |  |  | KITCH LABOR % |  |  | KITCH LABOR % |  |  | KITCH LABOR %
Vicente   (ot) |  | 0 |  | [NAME]) |  | 0 |  |  |  |  |  |  | PL LABOR $ |  |  | PL LABOR $ |  |  | PL LABOR $
[NAME] (line) |  | 0 |  | O'Neil |  | 0 |  | [NAME] |  |  |  |  | PL LABOR % |  |  | PL LABOR % |  |  | PL LABOR %
[NAME] (ot) |  | 0 |  | O'Neil   (ot) |  | 0 |  | STAFF R&P |  |  |  |  | BOH LABOR $ |  |  | BOH LABOR $ |  |  | BOH LABOR $
 |  |  |  | TOTAL REST. | 0 | 0 | 0 | TOTAL R & P | 28 | 252 | 294.84 |  | BOH LABOR % |  |  | BOH LABOR % |  |  | BOH LABOR %
Total FOH | Hours | Wages | w/Fica | Total BOH | Hours | Wages | w/Fica
Restaurant | 52.77 | 504.5650000000001 | 590.3410500000001 | Restaurant | 38.4 | 384 | 449.28
 |  |  |  |  |  |  |  |  |  |  |  |  | ACTUAL SALES $ |  |  | ACTUAL SALES $ |  |  | ACTUAL SALES $
REST. SALES |  |  |  |  |  | 2010 |  | 2009 |  |  |  |  | ACTUAL LABOR $ |  |  | ACTUAL LABOR $ |  |  | ACTUAL LABOR $
FH LABOR % |  | #N/A |  | ACTUAL SALES $ |  |  |  | 32161 |  |  |  |  | ACTUAL LABOR % |  |  | ACTUAL LABOR % |  |  | ACTUAL LABOR %
 |  |  |  | ACTUAL LABOR $ |  | 1039.62105 |  | 10078 |  |  |  |  | FOH LABOR $ |  |  | FOH LABOR $ |  |  | FOH LABOR $
KITCH. SALES |  |  |  | ACTUAL LABOR % |  | #N/A |  | 0.3134 |  |  |  |  | FOH LABOR % |  |  | FOH LABOR % |  |  | FOH LABOR %
KITCH LABOR % |  | #N/A |  | FOH LABOR $ |  | 590.3410500000001 |  | 2753 |  |  |  |  | KITCH LABOR $ |  |  | KITCH LABOR $ |  |  | KITCH LABOR $
 |  |  |  | FOH LABOR % |  | #N/A |  | 0.1542 |  |  |  |  | KITCH LABOR % |  |  | KITCH LABOR % |  |  | KITCH LABOR %
PL SALES |  |  |  | KITCH LABOR $ |  | 0 |  | 7361 |  |  |  |  | PL LABOR $ |  |  | PL LABOR $ |  |  | PL LABOR $
PL LABOR % |  | #N/A |  | KITCH LABOR % |  | #N/A |  | 0.3952 |  |  |  |  | PL LABOR % |  |  | PL LABOR % |  |  | PL LABOR %
 |  |  |  | PL LABOR $ |  | 449.28 |  | 1295 |  |  |  |  | BOH LABOR $ |  |  | BOH LABOR $ |  |  | BOH LABOR $
TOTAL BOH SALES |  |  |  | PL LABOR % |  | #N/A |  | 0.0905 |  |  |  |  | BOH LABOR % |  |  | BOH LABOR % |  |  | BOH LABOR %
TOTAL BOH LABOR % |  | #N/A |  | BOH LABOR $ |  | 449.28 |  | 7325
 |  |  |  | BOH LABOR % |  | #N/A |  | 0.2597
 |  |  |  |  |  |  |  |  |  |  |  |  | OTHER INFORMATION:
 |  |  |  |  |  |  |  |  |  |  |  |  | FH OT | 126.75
 |  |  |  |  |  |  |  |  |  |  |  |  | BH OT | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | PL OT | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 6% of Sales | 2518.4016
 |  |  |  |  |  |  |  |  |  |  |  |  | 6% of Rest Sales | 2362.7856