Spreadsheet: 121407d1316031992-formula-to-lookup-x-and-y-axis-intersect-excel-help
Sheet: 134

[NAME] |  |  |  |  |  |  |  |  |  |  |  | IDEAL P&L |  |  | Mgn (net) |  | Actual P&L | Mgn (net) |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Gross Sales |  | 109006.59 | 1.024479154331368 |  | 109006.59 | 1.024479154331367 |  | 0
Net Sales |  | 106401.96 |  | Pace | 0.3495063436801354 |  | Manager |  | Brunn |  |  | Coupons/Promos |  | -2604.63 | -0.02447915433136757 |  | -2604.63 | -0.02447915433136758 |  | 0
[NAME] |  | 0.3073 |  | SSS |  |  | Salary |  | 50000 |  |  | Net Sales |  | 106401.96 | 1 |  | 106401.96 | 1 |  | 0
# Managers |  | 1 |  | Act. [NAME] | 0.3228669847811074 |  | Pers. Bonus % |  | 0.1
[NAME] |  | 3846.16 |  |  |  |  | PD % Earned |  | 0.55 |  |  | [NAME] | 0.3123 | 33229.33210800001 | 0.3123 |  | 34353.68 | 0.3228669847811074 |  | 0.01056698478110735
All Discount % |  | -0.02447915433136757 |  |  |  |  | Total Bonus |  | 179.8076923076923 |  |  |  |  |  |  |  | 0
Close Time Adj |  | 21 |  |  |  |  |  |  |  |  |  | Hourly | 9.65 | 20349.98698235294 | 0.1912557530176412 |  | 20246.88 | 0.1902867202822204 |  | -0.0009690327354208716
PACE |  |  |  |  |  |  |  |  |  |  |  | OT | 40 | 579 | 0.005441629082772534 |  | 1435.01 | 0.01348668765124251 |  | 0.008045058568469977
 | 0.4157785137259081 | 0.3 | 0.8 | 0.95 | 1.1 | 1.5 | 1.6 | 1.65 | 1.75 |  |  | Manager | 3846.16 | 3846.16 | 0.03614745442659138 |  | 3846.16 | 0.03614745442659138 |  | 0
 | 0.4057785137259081 | 0.4 | 0.75 | 0.9 | 1.05 | 1.4 | 1.5 | 1.6 | 1.65 |  |  | Payroll Taxes | 0.095 | 2353.63896332353 | 0.02212025947006549 |  | 2476.4 | 0.02327400735851106 |  | 0.001153747888445571
 | 0.3957785137259081 | 0.5 | 0.7 | 0.85 | 1 | 1.3 | 1.4 | 1.5 | 1.6 |  |  | Health Insurance | 400 | 400 | 0.003759329245438711 |  | 229.78 | 0.002159546685042268 |  | -0.001599782560396443
 | 0.3857785137259081 | 0.5 | 0.65 | 0.8 | 0.95 | 1.2 | 1.3 | 1.4 | 1.5 |  |  | Workers Comp | 250 | 250 | 0.002349580778399194 |  | 250 | 0.002349580778399194 |  | 0
 | 0.3757785137259081 | 0.4 | 0.6 | 0.75 | 0.9 | 1.1 | 1.2 | 1.3 | 1.4 |  |  | EE Gifts | 100 | 100 | 0.0009398323113596778 |  | 70.32 | 0.0006608900813481253 |  | -0.0002789422300115525
 | 0.3657785137259081 | 0.3 | 0.55 | 0.7 | 0.85 | 1 | 1.1 | 1.2 | 1.3 |  |  | Payroll expense | 150 | 150 | 0.001409748467039517 |  | 150 | 0.001409748467039517 |  | 0
 | 0.3557785137259081 | 0 | 0.4 | 0.55 | 0.7 | 0.85 | 0.95 | 1.05 | 1.15 |  |  | KL Bonus | 325 | 325 | 0.003054455011918953 |  | 75 | 0.0007048742335197583 |  | -0.002349580778399194
 | 0.3457785137259081 | 0 | 0.25 | 0.4 | 0.55 | 0.7 | 0.8 | 0.9 | 1 |  |  | CSR Bonus | 0 | 0 | 0 |  | 0 | 0 |  | 0
 | 0.3357785137259081 | 0 | 0.1 | 0.25 | 0.4 | 0.55 | 0.65 | 0.75 | 0.85 |  |  | Total Labor |  | 28353.78594567647 | 0.2664780418112267 |  | 28779.55 | 0.2704795099639141 |  | 0.004001468152687426
 | 0.325778513725908 | 0 | 0 | 0.1 | 0.25 | 0.4 | 0.5 | 0.6 | 0.7
 | 0.315778513725908 | 0 | 0 | 0 | 0.1 | 0.25 | 0.35 | 0.45 | 0.55 |  |  | Prime Costs |  | 61583.11805367649 | 0.5787780418112267 |  | 63133.23 | 0.5933464947450214 |  | 0.01456845293379472
 |  | -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.01945311909667829 | 2069.85 | 0.01945311909667829 |  | 2069.85 | 0.01945311909667829 |  | 0
 |  | Same Store Sales Growth |  |  |  |  |  |  |  |  |  | Laundry | 225 | 225 | 0.002114622700559275 |  | 213.48 | 0.00200635401829064 |  | -0.0001082686822686352
 |  |  |  |  |  |  |  |  |  |  |  | Chemicals | 500 | 500 | 0.004699161556798389 |  | 1227.67 | 0.01153803933686936 |  | 0.006838877780070968
New Store (no comps) |  |  |  |  |  |  |  |  |  |  |  | Smallwares/Equip | 500 | 500 | 0.004699161556798389 |  | 338.06 | 0.003177197111782527 |  | -0.001521964445015862
 | <$55,000 | $55,000-$72,999 | $73,000-$83,999 | $84,000-$99,999 | $100,000 + |  |  |  |  |  |  | Cleaning | 0.007 | 744.8137200000002 | 0.007000000000000001 |  | 961.91 | 0.009040340986199876 |  | 0.002040340986199875
PACE |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 70 | 70 | 0.0006578826179517744 |  | 190.8 | 0.001793200050074265 |  | 0.001135317432122491
0.4157785137259081 | 0 | 1 | 1.3 | 1.5 | 1.75 |  |  |  |  |  |  | Delivery Expense | 0.008 | 851.2156800000001 | 0.008 |  | 231.32 | 0.002174020102637206 |  | -0.005825979897362794
0.4057785137259081 | 0 | 0.9 | 1.2 | 1.4 | 1.6 |  |  |  |  |  |  | Merchandise | 0.003 | 319.2058800000001 | 0.003 |  | 398.38 | 0.003744103961994684 |  | 0.0007441039619946839
0.3957785137259081 | 0 | 0.8 | 1.1 | 1.3 | 1.45 |  |  |  |  |  |  | Vendor Freight | 0.003 | 319.2058800000001 | 0.003 |  | 268.82 | 0.002526457219397086 |  | -0.0004735427806029147
0.3857785137259081 | 0 | 0.7 | 1 | 1.2 | 1.3 |  |  |  |  |  |  | Office Supplies | 100 | 100 | 0.0009398323113596778 |  | 153.02 | 0.001438131402842579 |  | 0.0004982990914829012
0.3757785137259081 | 0 | 0.6 | 0.9 | 1.1 | 1.15 |  |  |  |  |  |  | Cash Over/Short | 50 | 50 | 0.0004699161556798389 |  | -13.7 | -0.0001287570266562759 |  | -0.0005986731823361147
0.3657785137259081 | 0 | 0.5 | 0.75 | 1 | 1 |  |  |  |  |  |  | Postage | 50 | 50 | 0.0004699161556798389 |  | 41.18 | 0.0003870229458179153 |  | -8.289320986192358e-05
0.3557785137259081 | 0 | 0.35 | 0.6 | 0.85 | 0.85 |  |  |  |  |  |  | Uniforms | 100 | 100 | 0.0009398323113596778 |  | 0 | 0 |  | -0.0009398323113596778
0.3457785137259081 | 0 | 0.2 | 0.45 | 0.7 | 0.7 |  |  |  |  |  |  | Other | 0 | 0 | 0 |  | -0.22 | -2.067631084991291e-06 |  | -2.067631084991291e-06
0.3357785137259081 | 0 | 0 | 0.2999999999999999 | 0.55 | 0.55 |  |  |  |  |  |  | Total Direct Operating |  | 5899.291160000002 | 0.05544344446286516 |  | 6080.570000000001 | 0.05714716157484317 |  | 0.001703717111978004
0.325778513725908 | 0 | 0 | 0.1499999999999999 | 0.4 | 0.4
0.315778513725908 | 0 | 0 | 0 | 0.25 | 0.25 |  |  |  |  |  |  | PACE |  | 38919.55078632353 | 0.3657785137259081
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] on [NAME] |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | PACE ADJ |  | 38919.55078632353 | 0.3657785137259081 |  | 37188.16000000003 | 0.3495063436801354 |  | -0.01627217004577269
 |  |  |  |  |  |  |  |  |  |  |  | Hours |  | 2108.806941176471 |  |  | 2013.41 |  |  | -95.39694117647105
 |  |  |  |  |  |  |  |  |  |  |  | OT |  | 40 |  |  | 76.63 |  |  | 36.63
 |  |  |  |  |  |  |  |  |  |  |  | Manager |  | 180 |  |  | 192.64 |  |  | 12.63999999999999
 |  |  |  |  |  |  |  |  |  |  |  | Total |  | 2328.806941176471 |  |  | 2282.68 |  |  | -46.12694117647106
 |  |  |  |  |  |  |  |  |  |  |  | SPMH |  | 46.80791184216064 |  |  | 47.75377626298913 |  |  | 0.9458644208284923
 |  |  |  |  |  |  |  |  |  |  |  | ASSUMPTIONS
 |  |  |  |  |  |  |  |  |  |  |  | Weekly Sales |  | 26600.49000000001
 |  |  |  |  |  |  |  |  |  |  |  | % Coupons/Promos |  | 0.02447915433136757
 |  |  |  |  |  |  |  |  |  |  |  | Managers |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | Day of Week | % by Day | Gross Sales
 |  |  |  |  |  |  |  |  |  |  |  | M | 0.132 | 3597.217470000001
 |  |  |  |  |  |  |  |  |  |  |  | T | 0.153 | 4169.502067500001
 |  |  |  |  |  |  |  |  |  |  |  | W | 0.153 | 4169.502067500001
 |  |  |  |  |  |  |  |  |  |  |  | H | 0.153 | 4169.502067500001
 |  |  |  |  |  |  |  |  |  |  |  | F | 0.162 | 4414.766895000002
 |  |  |  |  |  |  |  |  |  |  |  | S | 0.132 | 3597.217470000001
 |  |  |  |  |  |  |  |  |  |  |  | S | 0.115 | 3133.939462500001
 |  |  |  |  |  |  |  |  |  |  |  | Total Gross Sales | 1 | 27251.64750000001
 |  |  |  |  |  |  |  |  |  |  |  | Hours | Mgr | Hourly | CSR
 |  |  |  |  |  |  |  |  |  |  |  | M | 9 | 62.69079376470589 | 5
 |  |  |  |  |  |  |  |  |  |  |  | T | 9 | 69.42355373529412 | 5
 |  |  |  |  |  |  |  |  |  |  |  | W | 9 | 69.42355373529412 | 5
 |  |  |  |  |  |  |  |  |  |  |  | H | 9 | 69.42355373529412 | 5
 |  |  |  |  |  |  |  |  |  |  |  | F | 9 | 72.30902229411767 | 5
 |  |  |  |  |  |  |  |  |  |  |  | S | 0 | 76.69079376470589 | 0
 |  |  |  |  |  |  |  |  |  |  |  | S | 0 | 71.24046426470589 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Close Time Adj |  | 21
 |  |  |  |  |  |  |  |  |  |  |  | Total Hours | 45 | 512.2017352941177 | 25