Spreadsheet: 121394d1316025491-formula-to-lookup-x-and-y-axis-intersect-excel-help
Sheet: 100

Downtown |  |  |  |  |  |  |  |  |  |  |  | IDEAL P&L |  |  | Mgn (net) |  | Actual P&L | Mgn (net) |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Gross Sales |  | 87839.43999999999 | 1.028577878970835 |  | 87839.43999999999 | 1.028577878970835 |  | 0
Net Sales |  | 85398.91999999998 |  | Pace | 0.4204600011335037 |  | Manager |  | May |  |  | Coupons/Promos |  | -2440.52 | -0.02857787897083476 |  | -2434.57 | -0.02850820595857653 |  | 6.967301225823536e-05
[NAME] |  | 0.3204 |  | SSS | 0.1019407434839188 |  | Salary |  | 47000 |  |  | Net Sales |  | 85398.91999999998 | 1 |  | 85398.91999999998 | 1 |  | 0
# Managers |  | 1 |  | Act. [NAME] | 0.3145995288933396 |  | Pers. Bonus % |  | 0.1
[NAME] |  | 3615.4 |  |  |  |  | PD % Earned |  | 1.5 |  |  | [NAME] | 0.3254 | 27788.808568 | 0.3254 |  | 26866.45999999999 | 0.3145995288933396 |  | -0.01080047110666044
All Discount % |  | -0.02857787897083476 |  |  |  |  | Total Bonus |  | 542.3076923076923 |  |  |  |  |  |  | * | 661.05 | 0.007740730210639668 |  | 0.007740730210639668 | *Parking Downtown Only
Close Time Adj |  | -20 |  |  |  |  |  |  |  |  |  | Hourly | 9.65 | 10927.60596 | 0.1279595334460905 |  | 11795.61 | 0.138123643718211 |  | 0.01016411027212052
PACE |  |  |  |  |  |  |  |  |  |  |  | OT | 80 | 1158 | 0.01355989045294718 |  | 756.99 | 0.008864163621741354 |  | -0.004695726831205829
 | 0.4537146205806818 | 0.3 | 0.8 | 0.95 | 1.1 | 1.5 | 1.6 | 1.65 | 1.75 |  |  | Manager | 3615.4 | 3615.4 | 0.04233543000309607 |  | 2750.2 | 0.03220415433825159 |  | -0.01013127566484448
 | 0.4437146205806818 | 0.4 | 0.75 | 0.9 | 1.05 | 1.4 | 1.5 | 1.6 | 1.65 |  |  | Payroll Taxes | 0.095 | 1491.5955662 | 0.0174662111207027 |  | 1447.17 | 0.01694599884869739 |  | -0.0005202122720053166
 | 0.4337146205806818 | 0.5 | 0.7 | 0.85 | 1 | 1.3 | 1.4 | 1.5 | 1.6 |  |  | Health Insurance | 400 | 400 | 0.004683899983746868 |  | 400 | 0.004683899983746868 |  | 0
 | 0.4237146205806818 | 0.5 | 0.65 | 0.8 | 0.95 | 1.2 | 1.3 | 1.4 | 1.5 |  |  | Workers Comp | 250 | 250 | 0.002927437489841792 |  | 250 | 0.002927437489841792 |  | 0
 | 0.4137146205806818 | 0.4 | 0.6 | 0.75 | 0.9 | 1.1 | 1.2 | 1.3 | 1.4 |  |  | EE Gifts | 100 | 100 | 0.001170974995936717 |  | 191.58 | 0.002243353897215563 |  | 0.001072378901278846
 | 0.4037146205806818 | 0.3 | 0.55 | 0.7 | 0.85 | 1 | 1.1 | 1.2 | 1.3 |  |  | Payroll expense | 150 | 150 | 0.001756462493905076 |  | 150 | 0.001756462493905076 |  | 0
 | 0.3937146205806818 | 0 | 0.4 | 0.55 | 0.7 | 0.85 | 0.95 | 1.05 | 1.15 |  |  | KL Bonus | 325 | 325 | 0.00380566873679433 |  | 125 | 0.001463718744920896 |  | -0.002341949991873434
 | 0.3837146205806818 | 0 | 0.25 | 0.4 | 0.55 | 0.7 | 0.8 | 0.9 | 1 |  |  | CSR Bonus | 0 | 0 | 0 |  | 0 | 0 |  | 0
 | 0.3737146205806818 | 0 | 0.1 | 0.25 | 0.4 | 0.55 | 0.65 | 0.75 | 0.85 |  |  | Total Labor |  | 18417.6015262 | 0.2156655087230612 |  | 18527.6 | 0.2169535633471712 |  | 0.001288054624110024
 | 0.3637146205806818 | 0 | 0 | 0.1 | 0.25 | 0.4 | 0.5 | 0.6 | 0.7
 | 0.3537146205806818 | 0 | 0 | 0 | 0.1 | 0.25 | 0.35 | 0.45 | 0.55 |  |  | Prime Costs |  | 46206.41009419999 | 0.5410655087230611 |  | 45394.06 | 0.5315530922405108 |  | -0.009512416482550301
 |  | -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.0181189645021272 | 1547.34 | 0.0181189645021272 |  | 1547.34 | 0.0181189645021272 |  | 0
 |  | Same Store Sales Growth |  |  |  |  |  |  |  |  |  | Laundry | 185 | 185 | 0.002166303742482926 |  | 186.1 | 0.00217918446743823 |  | 1.288072495530396e-05
 |  |  |  |  |  |  |  |  |  |  |  | Chemicals | 320 | 320 | 0.003747119986997494 |  | 117.25 | 0.001372968182735801 |  | -0.002374151804261693
 |  |  |  |  |  |  |  |  |  |  |  | Smallwares/Equip | 500 | 500 | 0.005854874979683585 |  | 276.53 | 0.003238097156263803 |  | -0.002616777823419781
 |  |  |  |  |  |  |  |  |  |  |  | Cleaning | 0.007 | 597.7924399999999 | 0.007000000000000001 |  | 437.75 | 0.005125943044712979 |  | -0.001874056955287022
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 70 | 70 | 0.0008196824971557019 |  | 0 | 0 |  | -0.0008196824971557019
 |  |  |  |  |  |  |  |  |  |  |  | Delivery Expense | 0.008 | 683.1913599999999 | 0.008 |  | 86.93 | 0.001017928563967788 |  | -0.006982071436032211
 |  |  |  |  |  |  |  |  |  |  |  | Merchandise | 0.003 | 256.19676 | 0.003 |  | 633.72 | 0.007420702744250164 |  | 0.004420702744250164
 |  |  |  |  |  |  |  |  |  |  |  | Vendor Freight | 0.003 | 256.19676 | 0.003 |  | 437.73 | 0.005125708849713791 |  | 0.002125708849713791
 |  |  |  |  |  |  |  |  |  |  |  | Office Supplies | 100 | 100 | 0.001170974995936717 |  | 118.29 | 0.001385146322693543 |  | 0.0002141713267568256
 |  |  |  |  |  |  |  |  |  |  |  | Cash Over/Short | 50 | 50 | 0.0005854874979683585 |  | 17.89 | 0.0002094874267730787 |  | -0.0003760000711952798
 |  |  |  |  |  |  |  |  |  |  |  | Postage | 50 | 50 | 0.0005854874979683585 |  | 0 | 0 |  | -0.0005854874979683585
 |  |  |  |  |  |  |  |  |  |  |  | Uniforms | 100 | 100 | 0.001170974995936717 |  | 238.5 | 0.00279277536530907 |  | 0.001621800369372353
 |  |  |  |  |  |  |  |  |  |  |  | Other | 0 | 0 | 0 |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Total Direct Operating |  | 4715.71732 | 0.05521987069625706 |  | 4098.03 | 0.04798690662598544 |  | -0.007232964070271616
 |  |  |  |  |  |  |  |  |  |  |  | PACE |  | 34476.79258579999 | 0.4037146205806818
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] on [NAME] |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | PACE ADJ |  | 34476.79258579999 | 0.4037146205806818 |  | 35906.82999999999 | 0.4204600011335037 |  | 0.01674538055282193
 |  |  |  |  |  |  |  |  |  |  |  | Hours |  | 1132.3944 |  |  | 1090.23 |  |  | -42.16440000000011
 |  |  |  |  |  |  |  |  |  |  |  | OT |  | 80 |  |  | 34.5 |  |  | -45.5
 |  |  |  |  |  |  |  |  |  |  |  | Manager |  | 180 |  |  | 182.52 |  |  | 2.519999999999982
 |  |  |  |  |  |  |  |  |  |  |  | Total |  | 1392.3944 |  |  | 1307.25 |  |  | -85.14440000000013
 |  |  |  |  |  |  |  |  |  |  |  | SPMH |  | 63.08517184498874 |  |  | 67.19406387454579 |  |  | 4.108892029557055
 |  |  |  |  |  |  |  |  |  |  |  | ASSUMPTIONS
 |  |  |  |  |  |  |  |  |  |  |  | Weekly Sales |  | 21349.73
 |  |  |  |  |  |  |  |  |  |  |  | % Coupons/Promos |  | 0.02857787897083476
 |  |  |  |  |  |  |  |  |  |  |  | Managers |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | Day of Week | % by Day | Gross Sales
 |  |  |  |  |  |  |  |  |  |  |  | M | 0.2 | 4391.972
 |  |  |  |  |  |  |  |  |  |  |  | T | 0.2 | 4391.972
 |  |  |  |  |  |  |  |  |  |  |  | W | 0.2 | 4391.972
 |  |  |  |  |  |  |  |  |  |  |  | H | 0.2 | 4391.972
 |  |  |  |  |  |  |  |  |  |  |  | F | 0.2 | 4391.972
 |  |  |  |  |  |  |  |  |  |  |  | S
 |  |  |  |  |  |  |  |  |  |  |  | S
 |  |  |  |  |  |  |  |  |  |  |  | Total Gross Sales | 1 | 21959.86
 |  |  |  |  |  |  |  |  |  |  |  | Hours | Mgr | Hourly | CSR
 |  |  |  |  |  |  |  |  |  |  |  | M | 9 | 59.61972 | 5
 |  |  |  |  |  |  |  |  |  |  |  | T | 9 | 59.61972 | 5
 |  |  |  |  |  |  |  |  |  |  |  | W | 9 | 59.61972 | 5
 |  |  |  |  |  |  |  |  |  |  |  | H | 9 | 59.61972 | 5
 |  |  |  |  |  |  |  |  |  |  |  | F | 9 | 59.61972 | 5
 |  |  |  |  |  |  |  |  |  |  |  | S
 |  |  |  |  |  |  |  |  |  |  |  | S
 |  |  |  |  |  |  |  |  |  |  |  | Close Time Adj |  | -20
 |  |  |  |  |  |  |  |  |  |  |  | Total Hours | 45 | 278.0986 | 25