Spreadsheet: 127957d1320702875-formula-to-lookup-x-and-y-axis-intersect-100
Sheet: 100

Downtown |  |  |  |  |  |  |  |  |  |  |  | IDEAL P&L |  |  | Mgn (net) |  | Actual P&L | Mgn (net) |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Gross Sales |  | 82118.84000000001 | 1.028566418435297 |  | 82118.84 | 1.028566418435297 |  | 0
Net Sales |  | 79838.15000000001 |  | Pace | 0.395876783217046 |  | Manager |  | May |  |  | Coupons/Promos |  | -2280.69 | -0.02856641843529691 |  | -2280.69 | -0.0285664184352969 |  | 0
[NAME] |  | 0.3209 |  | SSS | 0.04912891038270595 |  | Salary |  | 47000 |  |  | Net Sales |  | 79838.15000000001 | 1 |  | 79838.15000000001 | 1 |  | 0
# Managers |  | 1 |  | Act. [NAME] | 0.3196838854607728 |  | Pers. Bonus % |  | 0.1
[NAME] |  | 12581.18 |  | Years Open | 10 |  | PD % Earned |  | #N/A |  |  | [NAME] | 0.3259 | 26019.253085 | 0.3259 |  | 25522.97 | 0.3196838854607728 |  | -0.006216114539227213
All Discount % |  | -0.02856641843529691 |  |  |  |  | Total Bonus |  | #N/A |  |  |  |  |  |  | * | 661.05 | 0.008279876224586865 |  | 0.008279876224586865 | *Parking Downtown Only
Close Time Adj |  | -20 |  |  |  |  |  |  |  |  |  | Hourly | 9.65 | 10375.56806 | 0.1299575210597941 |  | 11254.81 | 0.1409703255899592 |  | 0.01101280453016509
PACE |  |  |  |  |  |  |  |  |  |  |  | OT | 80 | 1158 | 0.01450434410115966 |  | 1326.37 | 0.01661323565237922 |  | 0.002108891551219559
 | 0.3210059094942106 | 0.3 | 0.8 | 0.95 | 1.1 | 1.5 | 1.6 | 1.65 | 1.75 |  |  | Manager | 12581.18 | 12581.18 | 0.1575835612423384 |  | 3615.4 | 0.04528411542602127 |  | -0.1122994458163171
 | 0.3110059094942106 | 0.4 | 0.75 | 0.9 | 1.05 | 1.4 | 1.5 | 1.6 | 1.65 |  |  | Payroll Taxes | 0.08526306170808899 | 2056.097251914799 | 0.02575331783006994 |  | 1380.97 | 0.01729711923435099 |  | -0.008456198595718951
 | 0.3010059094942106 | 0.5 | 0.7 | 0.85 | 1 | 1.3 | 1.4 | 1.5 | 1.6 |  |  | Health Insurance | 400 | 400 | 0.005010136131661367 |  | 377.26 | 0.004725309892576418 |  | -0.0002848262390849491
 | 0.2910059094942106 | 0.5 | 0.65 | 0.8 | 0.95 | 1.2 | 1.3 | 1.4 | 1.5 |  |  | Workers Comp | 250 | 250 | 0.003131335082288354 |  | 250 | 0.003131335082288354 |  | 0
 | 0.2810059094942106 | 0.4 | 0.6 | 0.75 | 0.9 | 1.1 | 1.2 | 1.3 | 1.4 |  |  | EE Gifts | 100 | 100 | 0.001252534032915342 |  | 0 | 0 |  | -0.001252534032915342
 | 0.2710059094942106 | 0.3 | 0.55 | 0.7 | 0.85 | 1 | 1.1 | 1.2 | 1.3 |  |  | Payroll expense | 150 | 150 | 0.001878801049373013 |  | 150 | 0.001878801049373013 |  | 0
 | 0.2610059094942105 | 0 | 0.4 | 0.55 | 0.7 | 0.85 | 0.95 | 1.05 | 1.15 |  |  | KL Bonus | 325 | 325 | 0.004070735606974861 |  | 325 | 0.004070735606974861 |  | 0
 | 0.2510059094942105 | 0 | 0.25 | 0.4 | 0.55 | 0.7 | 0.8 | 0.9 | 1 |  |  | CSR Bonus | 0 | 0 | 0 |  | 0 | 0 |  | 0
 | 0.2410059094942105 | 0 | 0.1 | 0.25 | 0.4 | 0.55 | 0.65 | 0.75 | 0.85 |  |  | Total Labor |  | 27395.8453119148 | 0.343142286136575 |  | 19542.12 | 0.2447717037531556 |  | -0.09837058238341939
 | 0.2310059094942105 | 0 | 0 | 0.1 | 0.25 | 0.4 | 0.5 | 0.6 | 0.7
 | 0.2210059094942105 | 0 | 0 | 0 | 0.1 | 0.25 | 0.35 | 0.45 | 0.55 |  |  | Prime Costs |  | 53415.0983969148 | 0.669042286136575 |  | 45065.09 | 0.5644555892139285 |  | -0.1045866969226465
 |  | -0.051 | -0.05 | -0.03 | -0.01 | 0.01 | 0.03 | 0.05 | 0.07
 |  | Below | -0.031 | -0.011 | 0.009000000000000001 | 0.029 | 0.049 | 0.069 | Above |  |  | Credit Card fees | 0.02172946141662851 | 1734.84 | 0.02172946141662851 |  | 1734.84 | 0.02172946141662851 |  | 0
 |  | Same Store Sales Growth |  |  |  |  |  |  |  |  |  | Laundry | 185 | 185 | 0.002317187960893382 |  | 148.88 | 0.001864772668204361 |  | -0.0004524152926890215
 |  |  |  |  |  |  |  |  |  |  |  | Chemicals | 320 | 320 | 0.004008108905329094 |  | 34.51 | 0.0004322494947590844 |  | -0.003575859410570009
 |  |  |  |  |  |  |  |  |  |  |  | Smallwares/Equip | 500 | 500 | 0.006262670164576709 |  | 101.89 | 0.001276206926137442 |  | -0.004986463238439267
 |  |  |  |  |  |  |  |  |  |  |  | Cleaning | 0.007 | 558.8670500000001 | 0.007 |  | 469.68 | 0.005882901845796777 |  | -0.001117098154203224
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 70 | 70 | 0.0008767738230407391 |  | 0 | 0 |  | -0.0008767738230407391
 |  |  |  |  |  |  |  |  |  |  |  | Delivery Expense | 0.008 | 638.7052000000001 | 0.008 |  | 393.35 | 0.004926842618472497 |  | -0.003073157381527503
 |  |  |  |  |  |  |  |  |  |  |  | Merchandise | 0.003 | 239.51445 | 0.003 |  | 21.66 | 0.000271298871529463 |  | -0.002728701128470537
 |  |  |  |  |  |  |  |  |  |  |  | Vendor Freight | 0.003 | 239.51445 | 0.003 |  | 230.3 | 0.002884585877804032 |  | -0.0001154141221959681
 |  |  |  |  |  |  |  |  |  |  |  | Office Supplies | 100 | 100 | 0.001252534032915342 |  | 23.43 | 0.0002934687239120646 |  | -0.0009590653090032771
 |  |  |  |  |  |  |  |  |  |  |  | Cash Over/Short | 50 | 50 | 0.0006262670164576709 |  | 8.45 | 0.0001058391257813464 |  | -0.0005204278906763245
 |  |  |  |  |  |  |  |  |  |  |  | Postage | 50 | 50 | 0.0006262670164576709 |  | 0 | 0 |  | -0.0006262670164576709
 |  |  |  |  |  |  |  |  |  |  |  | Uniforms | 100 | 100 | 0.001252534032915342 |  | 0 | 0 |  | -0.001252534032915342
 |  |  |  |  |  |  |  |  |  |  |  | Other | 0 | 0 | 0 |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Total Direct Operating |  | 4786.44115 | 0.05995180436921446 |  | 3166.99 | 0.03966762756902558 |  | -0.02028417680018887
 |  |  |  |  |  |  |  |  |  |  |  | PACE |  | 21636.61045308521 | 0.2710059094942106
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] on [NAME] |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | PACE ADJ |  | 21636.61045308521 | 0.2710059094942106 |  | 31606.07 | 0.395876783217046 |  | 0.1248708737228355
 |  |  |  |  |  |  |  |  |  |  |  | Hours |  | 1075.1884 |  |  | 0 |  |  | -1075.1884
 |  |  |  |  |  |  |  |  |  |  |  | OT |  | 80 |  |  | 1096.54 |  |  | 1016.54
 |  |  |  |  |  |  |  |  |  |  |  | Manager |  | 180 |  |  | 40.92 |  |  | -139.08
 |  |  |  |  |  |  |  |  |  |  |  | Total |  | 1335.1884 |  |  | 1137.46 |  |  | -197.7284
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 9.65 |  |  | #N/A |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | SPMH |  | 61.50356009683728 |  |  | 72.19492553584301 |  |  | 10.69136543900574
 |  |  |  |  |  |  |  |  |  |  |  | ASSUMPTIONS
 |  |  |  |  |  |  |  |  |  |  |  | Weekly Sales |  | 19959.5375
 |  |  |  |  |  |  |  |  |  |  |  | % Coupons/Promos |  | 0.02856641843529691
 |  |  |  |  |  |  |  |  |  |  |  | Managers |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | Day of Week | % by Day | Gross Sales
 |  |  |  |  |  |  |  |  |  |  |  | M | 0.2 | 4105.942000000001
 |  |  |  |  |  |  |  |  |  |  |  | T | 0.2 | 4105.942000000001
 |  |  |  |  |  |  |  |  |  |  |  | W | 0.2 | 4105.942000000001
 |  |  |  |  |  |  |  |  |  |  |  | H | 0.2 | 4105.942000000001
 |  |  |  |  |  |  |  |  |  |  |  | F | 0.2 | 4105.942000000001
 |  |  |  |  |  |  |  |  |  |  |  | S
 |  |  |  |  |  |  |  |  |  |  |  | S
 |  |  |  |  |  |  |  |  |  |  |  | Total Gross Sales | 1 | 20529.71000000001
 |  |  |  |  |  |  |  |  |  |  |  | Hours | Mgr | Hourly | CSR
 |  |  |  |  |  |  |  |  |  |  |  | M | 9 | 56.75942000000001 | 5
 |  |  |  |  |  |  |  |  |  |  |  | T | 9 | 56.75942000000001 | 5
 |  |  |  |  |  |  |  |  |  |  |  | W | 9 | 56.75942000000001 | 5
 |  |  |  |  |  |  |  |  |  |  |  | H | 9 | 56.75942000000001 | 5
 |  |  |  |  |  |  |  |  |  |  |  | F | 9 | 56.75942000000001 | 5
 |  |  |  |  |  |  |  |  |  |  |  | S
 |  |  |  |  |  |  |  |  |  |  |  | S
 |  |  |  |  |  |  |  |  |  |  |  | Close Time Adj |  | -20
 |  |  |  |  |  |  |  |  |  |  |  | Total Hours | 45 | 263.7971 | 25