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

MANCHESTER PROJECTED LABOR ANALYSIS
WEEK ENDING: | 5/18/2009 - 5/24/2009
 |  |  |  | 3.44
SERVERS | Hours | Wages | w/Fica |  | BAR | Hours | Wages | w/Fica |  | 2008
[NAME] | 5.62 | 21.9742 |  |  | [NAME] | 5.33 | 38.6425 |  |  | Proj Labor | 0.4182
[NAME] | 16.77 | 65.5707 |  |  | [NAME] | 10.92 | 79.17 |  |  | Actual Labor | 0.4259
[NAME] A | 19.95 | 78.0045 |  |  | Jon |  | 0 |  |  | Proj Sales | 14986
Jess SQ | 38.12 | 149.0492 |  |  | [NAME] |  | 0 |  |  | Actual Sales | 16978
[NAME] | 12.47 | 48.75770000000001 |  |  | Kathy |  | 0 |  |  | FOH Labor % | 0.1564
[NAME] | 11.07 | 43.2837 |  |  | [NAME] | 18 | 112.5 |  |  | FOH Labor $ | 2005
[NAME] | 29.63 | 115.8533 |  |  | [NAME] | 13.38 | 83.625 |  |  | w/Fica | 2346
Kathy | 28.5 | 111.435 |  |  | [NAME] | 16.4 | 102.5 |  |  | BOH Labor % | 0.2878
[NAME] | 8.45 | 33.0395 |  |  | [NAME] | 37.05 | 231.5625 | 101.08 |  | BOH Labor $ | 4176
Candace | 10.63 | 41.56330000000001 |  |  | BUSSER | Hours | Wages | w/Fica |  | w/Fica | 4886
[NAME] |  | 0 |  |  | Cody S | 15.45 | 100.425 |  |  | Total $ w/ Fica | 7232
[NAME] | 12.5 | 48.875 |  |  | [NAME] |  | 0
[NAME] | 16.45 | 64.3195 |  |  | Vicky | 14.65 | 95.22500000000001
Jared | 24.95 | 97.5545 |  |  | [NAME] |  | 0 |  |  | 2008 ACTUAL TOTALS
[NAME] | 20.2 | 78.982 |  |  | [NAME] | 22.92 | 148.98 |  |  | Total Labor $ | 9858.527100000001
 |  | 0 |  |  | Sean |  | 0 |  |  | w/Fica | 11534.476707
 |  | 0 |  |  | [NAME] | 4.02 | 26.13 |  |  | Weekly Sales | 31427
 |  | 0 |  |  | [NAME] | 8.58 | 55.77
 |  | 0 |  |  |  |  | 0 | 65.62
Training |  | 0 |  |  | HOST | Hours | Wages | w/Fica |  | Labor Cost % | 0.3670244282623222
Server OT |  | 0 |  |  | [NAME] | 6.12 | 61.2
Total Server | 255.3099999999999 | 998.2620999999999 | 1167.966657 |  | Shanan | 20.25 | 202.5
 |  |  |  |  | Faryn | 9.72 | 97.2
Mngmnt | Hours | Wages | w/Fica |  | [NAME] | 2.73 | 27.3
 |  |  |  |  | [NAME] | 2.92 | 29.2
 |  |  |  |  | [NAME] | 2.63 | 23.67
[NAME] | 40 | 440 |  |  | [NAME] | 5.12 | 46.08
[NAME] (ot) | 7.52 | 124.08 |  |  | EXP | 4.3 | 26.875 |  |  | FH CASUAL LABOR
 |  |  |  |  | OTHER |  |  | 53.79 |  | Serve
Total Mngmnt | 47.52 | 564.08 | 659.9736 |  | Total Support | 220.49 | 1588.555 | 1858.60935 |  | Host
 |  |  |  |  |  |  |  |  |  | Total | 0
TOTAL FOH | Hours | Wages | w/Fica |  | SALES | 29357
 | 523.3199999999999 | 3150.8971 | 3686.549607 |  | LABOR % | 0.1255765100998058
KITCHEN | Hours | Wages | w/Fica |  | KITCHEN | Hours | Wages | w/Fica |  | CLEANING / MAINT
[NAME] | 40 | 440 |  |  | [NAME] | 16.12 | 193.44 |  |  | George | 280
[NAME]  (ot) | 4.8 | 79.2 |  | 17.25 | [NAME](ot) |  | 0
[NAME] | 15.18 | 204.93 |  |  | [NAME] | 40 | 520
[NAME](ot) |  | 0 |  |  | [NAME](ot) | 15.5 | 290.625
[NAME] | 40 | 440 |  |  | Hugo | 40 | 400 |  |  | BH CASUAL LABOR
[NAME]ot) | 1.95 | 32.175 |  |  | Hugo  (ot) | 5.08 | 76.2
[NAME] | 40 | 510 |  |  | [NAME] | 38.05 | 418.55
[NAME]ot) | 14.23 | 273.216 |  |  | [NAME]   (ot) |  | 0
[NAME] | 40 | 400 |  |  | [NAME] | 8.13 | 81.30000000000001 |  |  | Total | 0
[NAME]) | 3.77 | 56.55 |  |  | [NAME]   (ot) |  | 0
[NAME] | 39.62 | 435.82 |  |  | Everton | 31.88 | 382.56
[NAME]  (ot) |  | 0 |  |  | [NAME]  (ot) |  | 0
Vicente | 40 | 450 |  |  | Ricky | 15 | 191.25
Vicente   (ot) | 4.05 | 68.36399999999999 |  |  | Ricky |  | 0
[NAME] | 40 | 400 |  |  | George | 12 | 108
[NAME]   (ot) | 13.43 | 201.45 |  |  | [NAME]) | 4 | 54
TOTAL BOH | 562.7900000000001 | 6707.630000000001 | 7847.927100000001 |  | SALES | 31427
 |  |  |  |  | LABOR % | 0.2497192573265027