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

Alliance |  |  |  |  |  |  |  |  |  |  |  | IDEAL P&L |  |  | Mgn (net) |  | Actual P&L | Mgn (net) |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Gross Sales |  | 96199.66999999998 | 1.056204083922619 |  | 96199.66999999998 | 1.056204083922619 |  | 0
Net Sales |  | 91080.56999999998 |  | Pace | 0.2320191891640554 |  | Manager |  | [NAME] |  |  | Coupons/Promos |  | -5119.1 | -0.0562040839226193 |  | -5119.1 | -0.0562040839226193 |  | 0
[NAME] |  | 0.3073 |  | SSS |  |  | Salary |  | 42000 |  |  | Net Sales |  | 91080.56999999998 | 1 |  | 91080.56999999998 | 1 |  | 0
# Managers |  | 1 |  | Act. [NAME] | 0.3842640642235771 |  | Pers. Bonus % |  | 0.12
[NAME] |  | 6299.99 |  |  |  |  | PD % Earned |  | 0 |  |  | [NAME] | 0.3123 | 28444.462011 | 0.3123 |  | 34998.99 | 0.3842640642235771 |  | 0.07196406422357704
All Discount % |  | -0.0562040839226193 |  |  |  |  | Total Bonus |  | 0 |  |  |  |  |  |  |  | 0
Close Time Adj |  | 22 |  |  |  |  |  |  |  |  |  | Hourly | 9.65 | 18934.62488823529 | 0.2078887394779732 |  | 18466.03 | 0.2027439002632505 |  | -0.005144839214722668
PACE |  |  |  |  |  |  |  |  |  |  |  | OT | 40 | 579 | 0.006357008964700156 |  | 1146.28 | 0.01258534064949308 |  | 0.006228331684792927
 | 0.3516026109232995 | 0.3 | 0.8 | 0.95 | 1.1 | 1.5 | 1.6 | 1.65 | 1.75 |  |  | Manager | 6299.99 | 6299.99 | 0.0691694178022821 |  | 6299.99 | 0.0691694178022821 |  | 0
 | 0.3416026109232995 | 0.4 | 0.75 | 0.9 | 1.05 | 1.4 | 1.5 | 1.6 | 1.65 |  |  | Payroll Taxes | 0.095 | 2452.293414382353 | 0.02692444079327077 |  | 2287.65 | 0.0251167729846223 |  | -0.001807667808648467
 | 0.3316026109232995 | 0.5 | 0.7 | 0.85 | 1 | 1.3 | 1.4 | 1.5 | 1.6 |  |  | Health Insurance | 400 | 400 | 0.0043917160377894 |  | 400 | 0.0043917160377894 |  | 0
 | 0.3216026109232995 | 0.5 | 0.65 | 0.8 | 0.95 | 1.2 | 1.3 | 1.4 | 1.5 |  |  | Workers Comp | 250 | 250 | 0.002744822523618375 |  | 250 | 0.002744822523618375 |  | 0
 | 0.3116026109232995 | 0.4 | 0.6 | 0.75 | 0.9 | 1.1 | 1.2 | 1.3 | 1.4 |  |  | EE Gifts | 100 | 100 | 0.00109792900944735 |  | 84.33 | 0.0009258835336669502 |  | -0.0001720454757803999
 | 0.3016026109232995 | 0.3 | 0.55 | 0.7 | 0.85 | 1 | 1.1 | 1.2 | 1.3 |  |  | Payroll expense | 150 | 150 | 0.001646893514171025 |  | 150 | 0.001646893514171025 |  | 0
 | 0.2916026109232995 | 0 | 0.4 | 0.55 | 0.7 | 0.85 | 0.95 | 1.05 | 1.15 |  |  | KL Bonus | 325 | 325 | 0.003568269280703887 |  | 75 | 0.0008234467570855125 |  | -0.002744822523618375
 | 0.2816026109232995 | 0 | 0.25 | 0.4 | 0.55 | 0.7 | 0.8 | 0.9 | 1 |  |  | CSR Bonus | 0 | 0 | 0 |  | 0 | 0 |  | 0
 | 0.2716026109232995 | 0 | 0.1 | 0.25 | 0.4 | 0.55 | 0.65 | 0.75 | 0.85 |  |  | Total Labor |  | 29490.90830261764 | 0.3237892374039562 |  | 29179.28 | 0.3203677798678687 |  | -0.003421457536087524
 | 0.2616026109232995 | 0 | 0 | 0.1 | 0.25 | 0.4 | 0.5 | 0.6 | 0.7
 | 0.2516026109232994 | 0 | 0 | 0 | 0.1 | 0.25 | 0.35 | 0.45 | 0.55 |  |  | Prime Costs |  | 57935.37031361764 | 0.6360892374039563 |  | 64178.27 | 0.7046318440914457 |  | 0.06854260668748946
 |  | -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.02379618397205903 | 2167.37 | 0.02379618397205903 |  | 2167.37 | 0.02379618397205903 |  | 0
 |  | Same Store Sales Growth |  |  |  |  |  |  |  |  |  | Laundry | 225 | 225 | 0.002470340271256537 |  | 232.53 | 0.002553014325667923 |  | 8.267405441138558e-05
 |  |  |  |  |  |  |  |  |  |  |  | Chemicals | 500 | 500 | 0.00548964504723675 |  | 1371.12 | 0.0150539242343345 |  | 0.009564279187097756
New Store (no comps) |  |  |  |  |  |  |  |  |  |  |  | Smallwares/Equip | 500 | 500 | 0.00548964504723675 |  | 271.55 | 0.002981426225154279 |  | -0.002508218822082471
 | <$55,000 | $55,000-$72,999 | $73,000-$83,999 | $84,000-$99,999 | $100,000 + |  |  |  |  |  |  | Cleaning | 0.007 | 637.5639899999999 | 0.007 |  | 683.16 | 0.007500611820940516 |  | 0.0005006118209405159
PACE |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 70 | 70 | 0.000768550306613145 |  | 86.6 | 0.000950806522181405 |  | 0.00018225621556826
0.3516026109232995 | 0 | 1 | 1.3 | 1.5 | 1.75 |  |  |  |  |  |  | Delivery Expense | 0.008 | 728.6445599999998 | 0.008 |  | 422.98 | 0.004644020124160401 |  | -0.003355979875839599
0.3416026109232995 | 0 | 0.9 | 1.2 | 1.4 | 1.6 |  |  |  |  |  |  | Merchandise | 0.003 | 273.24171 | 0.003 |  | 100.54 | 0.001103857826098366 |  | -0.001896142173901634
0.3316026109232995 | 0 | 0.8 | 1.1 | 1.3 | 1.45 |  |  |  |  |  |  | Vendor Freight | 0.003 | 273.24171 | 0.003 |  | 192.14 | 0.002109560798752138 |  | -0.0008904392012478619
0.3216026109232995 | 0 | 0.7 | 1 | 1.2 | 1.3 |  |  |  |  |  |  | Office Supplies | 100 | 100 | 0.00109792900944735 |  | 85.76 | 0.0009415839185020474 |  | -0.0001563450909453027
0.3116026109232995 | 0 | 0.6 | 0.9 | 1.1 | 1.15 |  |  |  |  |  |  | Cash Over/Short | 50 | 50 | 0.0005489645047236751 |  | 20.01 | 0.0002196955947904148 |  | -0.0003292689099332603
0.3016026109232995 | 0 | 0.5 | 0.75 | 1 | 1 |  |  |  |  |  |  | Postage | 50 | 50 | 0.0005489645047236751 |  | 116.5 | 0.001279087296006163 |  | 0.0007301227912824878
0.2916026109232995 | 0 | 0.35 | 0.6 | 0.85 | 0.85 |  |  |  |  |  |  | Uniforms | 100 | 100 | 0.00109792900944735 |  | 0 | 0 |  | -0.00109792900944735
0.2816026109232995 | 0 | 0.2 | 0.45 | 0.7 | 0.7 |  |  |  |  |  |  | Other | 0 | 0 | 0 |  | 19.6 | 0.0002151940858516806 |  | 0.0002151940858516806
0.2716026109232995 | 0 | 0 | 0.2999999999999999 | 0.55 | 0.55 |  |  |  |  |  |  | Total Direct Operating |  | 5675.06197 | 0.06230815167274426 |  | 5769.860000000001 | 0.06334896674449887 |  | 0.00104081507175461
0.2616026109232995 | 0 | 0 | 0.1499999999999999 | 0.4 | 0.4
0.2516026109232994 | 0 | 0 | 0 | 0.25 | 0.25 |  |  |  |  |  |  | PACE |  | 27470.13771638234 | 0.3016026109232995
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] on [NAME] |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | PACE ADJ |  | 27470.13771638234 | 0.3016026109232995 |  | 21132.43999999998 | 0.2320191891640554 |  | -0.06958342175924412
 |  |  |  |  |  |  |  |  |  |  |  | Hours |  | 1962.137294117647 |  |  | 1772.48 |  |  | -189.6572941176469
 |  |  |  |  |  |  |  |  |  |  |  | OT |  | 40 |  |  | 64.3 |  |  | 24.3
 |  |  |  |  |  |  |  |  |  |  |  | Manager |  | 180 |  |  | 334.48 |  |  | 154.48
 |  |  |  |  |  |  |  |  |  |  |  | Total |  | 2182.137294117647 |  |  | 2171.26 |  |  | -10.87729411764667
 |  |  |  |  |  |  |  |  |  |  |  | SPMH |  | 44.0850675433319 |  |  | 44.30591914372299 |  |  | 0.2208516003910859
 |  |  |  |  |  |  |  |  |  |  |  | ASSUMPTIONS
 |  |  |  |  |  |  |  |  |  |  |  | Weekly Sales |  | 22770.14249999999
 |  |  |  |  |  |  |  |  |  |  |  | % Coupons/Promos |  | 0.0562040839226193
 |  |  |  |  |  |  |  |  |  |  |  | Managers |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | Day of Week | % by Day | Gross Sales
 |  |  |  |  |  |  |  |  |  |  |  | M | 0.132 | 3174.589109999999
 |  |  |  |  |  |  |  |  |  |  |  | T | 0.153 | 3679.637377499999
 |  |  |  |  |  |  |  |  |  |  |  | W | 0.153 | 3679.637377499999
 |  |  |  |  |  |  |  |  |  |  |  | H | 0.153 | 3679.637377499999
 |  |  |  |  |  |  |  |  |  |  |  | F | 0.162 | 3896.086635
 |  |  |  |  |  |  |  |  |  |  |  | S | 0.132 | 3174.589109999999
 |  |  |  |  |  |  |  |  |  |  |  | S | 0.115 | 2765.7405125
 |  |  |  |  |  |  |  |  |  |  |  | Total Gross Sales | 1 | 24049.9175
 |  |  |  |  |  |  |  |  |  |  |  | Hours | Mgr | Hourly | CSR
 |  |  |  |  |  |  |  |  |  |  |  | M | 9 | 57.7186954117647 | 5
 |  |  |  |  |  |  |  |  |  |  |  | T | 9 | 63.6604397352941 | 5
 |  |  |  |  |  |  |  |  |  |  |  | W | 9 | 63.6604397352941 | 5
 |  |  |  |  |  |  |  |  |  |  |  | H | 9 | 63.6604397352941 | 5
 |  |  |  |  |  |  |  |  |  |  |  | F | 9 | 66.2069015882353 | 5
 |  |  |  |  |  |  |  |  |  |  |  | S | 0 | 71.7186954117647 | 0
 |  |  |  |  |  |  |  |  |  |  |  | S | 0 | 66.9087119117647 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Close Time Adj |  | 22
 |  |  |  |  |  |  |  |  |  |  |  | Total Hours | 45 | 475.5343235294117 | 25