Spreadsheet: 121406d1316031180-formula-to-lookup-x-and-y-axis-intersect-excel-help
Sheet: 105

Montgomery |  |  |  |  |  |  |  |  |  |  |  | IDEAL P&L |  |  | Mgn (net) |  | Actual P&L | Mgn (net) |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Gross Sales |  | 106436.41 | 1.041730728970869 |  | 106436.41 | 1.041730728970869 |  | 0
Net Sales |  | 102172.67 |  | Pace | 0.3846409220782818 |  | Manager |  | [NAME] |  |  | Coupons/Promos |  | -4263.74 | -0.04173072897086862 |  | -4161.59 | -0.04073095085016375 |  | 0.0009997781207048764
[NAME] |  | 0.3063 |  | SSS | -0.07191014195761258 |  | Salary |  | 44000 |  |  | Net Sales |  | 102172.67 | 1 |  | 102172.67 | 1 |  | 0
# Managers |  | 1 |  | Act. [NAME] | 0.3256883665661277 |  | Pers. Bonus % |  | 0.13
[NAME] |  | 4249.98 |  |  |  |  | PD % Earned |  | #N/A |  |  | [NAME] | 0.3113 | 31806.35217100001 | 0.3113 |  | 33276.45 | 0.3256883665661277 |  | 0.01438836656612769
All Discount % |  | -0.04173072897086862 |  |  |  |  | Total Bonus |  | #N/A |  |  |  |  |  |  |  | 0
Close Time Adj |  | 21 |  |  |  |  |  |  |  |  |  | Hourly | 9.65 | 16597.653565 | 0.1624470963223335 |  | 16910.62 | 0.1655102093348446 |  | 0.003063113012511109
PACE |  |  |  |  |  |  |  |  |  |  |  | OT | 80 | 1158 | 0.01133375490725651 |  | 1101.05 | 0.010776365147353 |  | -0.0005573897599035049
 | 0.4355565583763741 | 0.3 | 0.8 | 0.95 | 1.1 | 1.5 | 1.6 | 1.65 | 1.75 |  |  | Manager | 4249.98 | 4249.98 | 0.04159605499200519 |  | 4249.98 | 0.04159605499200519 |  | 0
 | 0.4255565583763741 | 0.4 | 0.75 | 0.9 | 1.05 | 1.4 | 1.5 | 1.6 | 1.65 |  |  | Payroll Taxes | 0.095 | 2090.535188675 | 0.02046080609105155 |  | 2017.89 | 0.0197498019773781 |  | -0.0007110041136734468
 | 0.4155565583763741 | 0.5 | 0.7 | 0.85 | 1 | 1.3 | 1.4 | 1.5 | 1.6 |  |  | Health Insurance | 400 | 400 | 0.003914941246029882 |  | 0 | 0 |  | -0.003914941246029882
 | 0.4055565583763741 | 0.5 | 0.65 | 0.8 | 0.95 | 1.2 | 1.3 | 1.4 | 1.5 |  |  | Workers Comp | 250 | 250 | 0.002446838278768676 |  | 250 | 0.002446838278768676 |  | 0
 | 0.3955565583763741 | 0.4 | 0.6 | 0.75 | 0.9 | 1.1 | 1.2 | 1.3 | 1.4 |  |  | EE Gifts | 100 | 100 | 0.0009787353115074705 |  | 14.04 | 0.0001374144377356488 |  | -0.0008413208737718217
 | 0.3855565583763741 | 0.3 | 0.55 | 0.7 | 0.85 | 1 | 1.1 | 1.2 | 1.3 |  |  | Payroll expense | 150 | 150 | 0.001468102967261206 |  | 150 | 0.001468102967261206 |  | 0
 | 0.3755565583763741 | 0 | 0.4 | 0.55 | 0.7 | 0.85 | 0.95 | 1.05 | 1.15 |  |  | KL Bonus | 325 | 325 | 0.003180889762399279 |  | 225 | 0.002202154450891809 |  | -0.0009787353115074705
 | 0.3655565583763741 | 0 | 0.25 | 0.4 | 0.55 | 0.7 | 0.8 | 0.9 | 1 |  |  | CSR Bonus | 0 | 0 | 0 |  | 0 | 0 |  | 0
 | 0.3555565583763741 | 0 | 0.1 | 0.25 | 0.4 | 0.55 | 0.65 | 0.75 | 0.85 |  |  | Total Labor |  | 25321.168753675 | 0.2478272198786133 |  | 24978.58 | 0.2444741827731428 |  | -0.003353037105470552
 | 0.3455565583763741 | 0 | 0 | 0.1 | 0.25 | 0.4 | 0.5 | 0.6 | 0.7
 | 0.335556558376374 | 0 | 0 | 0 | 0.1 | 0.25 | 0.35 | 0.45 | 0.55 |  |  | Prime Costs |  | 57127.520924675 | 0.5591272198786132 |  | 58255.03000000001 | 0.5701625493392705 |  | 0.01103532946065722
 |  | -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.02085861121178491 | 2131.18 | 0.02085861121178491 |  | 2131.18 | 0.02085861121178491 |  | 0
 |  | Same Store Sales Growth |  |  |  |  |  |  |  |  |  | Laundry | 185 | 185 | 0.00181066032628882 |  | 230.24 | 0.0022534401812148 |  | 0.00044277985492598
 |  |  |  |  |  |  |  |  |  |  |  | Chemicals | 320 | 320 | 0.003131952996823905 |  | 386.12 | 0.003779092784792645 |  | 0.0006471397879687399
 |  |  |  |  |  |  |  |  |  |  |  | Smallwares/Equip | 500 | 500 | 0.004893676557537353 |  | 131.54 | 0.001287428428756927 |  | -0.003606248128780426
 |  |  |  |  |  |  |  |  |  |  |  | Cleaning | 0.007 | 715.2086900000002 | 0.007000000000000001 |  | 795.64 | 0.007787209632478038 |  | 0.0007872096324780375
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 70 | 70 | 0.0006851147180552293 |  | 40 | 0.0003914941246029882 |  | -0.0002936205934522411
 |  |  |  |  |  |  |  |  |  |  |  | Delivery Expense | 0.008 | 817.3813600000001 | 0.008 |  | 434.06 | 0.004248298493129327 |  | -0.003751701506870674
 |  |  |  |  |  |  |  |  |  |  |  | Merchandise | 0.003 | 306.5180100000001 | 0.003 |  | 21.45 | 0.0002099387243183524 |  | -0.002790061275681648
 |  |  |  |  |  |  |  |  |  |  |  | Vendor Freight | 0.003 | 306.5180100000001 | 0.003 |  | 326.96 | 0.003200072974504825 |  | 0.0002000729745048253
 |  |  |  |  |  |  |  |  |  |  |  | Office Supplies | 100 | 100 | 0.0009787353115074705 |  | 38.32 | 0.0003750513713696627 |  | -0.0006036839401378078
 |  |  |  |  |  |  |  |  |  |  |  | Cash Over/Short | 50 | 50 | 0.0004893676557537353 |  | 43.98 | 0.0004304477900009855 |  | -5.891986575274976e-05
 |  |  |  |  |  |  |  |  |  |  |  | Postage | 50 | 50 | 0.0004893676557537353 |  | 76.68 | 0.0007504942368639284 |  | 0.0002611265811101931
 |  |  |  |  |  |  |  |  |  |  |  | Uniforms | 100 | 100 | 0.0009787353115074705 |  | 0 | 0 |  | -0.0009787353115074705
 |  |  |  |  |  |  |  |  |  |  |  | Other | 0 | 0 | 0 |  | -38.32 | -0.0003750513713696627 |  | -0.0003750513713696627
 |  |  |  |  |  |  |  |  |  |  |  | Total Direct Operating |  | 5651.80607 | 0.05531622174501263 |  | 4617.849999999999 | 0.04519652858244772 |  | -0.01011969316256491
 |  |  |  |  |  |  |  |  |  |  |  | PACE |  | 39393.34300532501 | 0.3855565583763741
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] on [NAME] |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | PACE ADJ |  | 39393.34300532501 | 0.3855565583763741 |  | 39299.79000000001 | 0.3846409220782818 |  | -0.0009156362980922705
 |  |  |  |  |  |  |  |  |  |  |  | Hours |  | 1719.9641 |  |  | 1664.69 |  |  | -55.27410000000009
 |  |  |  |  |  |  |  |  |  |  |  | OT |  | 80 |  |  | 62.53 |  |  | -17.47
 |  |  |  |  |  |  |  |  |  |  |  | Manager |  | 180 |  |  | 134.85 |  |  | -45.15000000000001
 |  |  |  |  |  |  |  |  |  |  |  | Total |  | 1979.9641 |  |  | 1862.07 |  |  | -117.8941000000002
 |  |  |  |  |  |  |  |  |  |  |  | SPMH |  | 53.75673730649965 |  |  | 57.16026250355787 |  |  | 3.403525197058222
 |  |  |  |  |  |  |  |  |  |  |  | ASSUMPTIONS
 |  |  |  |  |  |  |  |  |  |  |  | Weekly Sales |  | 25543.1675
 |  |  |  |  |  |  |  |  |  |  |  | % Coupons/Promos |  | 0.04173072897086862
 |  |  |  |  |  |  |  |  |  |  |  | Managers |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | Day of Week | % by Day | Gross Sales
 |  |  |  |  |  |  |  |  |  |  |  | M | 0.132 | 3512.401530000001
 |  |  |  |  |  |  |  |  |  |  |  | T | 0.153 | 4071.192682500001
 |  |  |  |  |  |  |  |  |  |  |  | W | 0.153 | 4071.192682500001
 |  |  |  |  |  |  |  |  |  |  |  | H | 0.153 | 4071.192682500001
 |  |  |  |  |  |  |  |  |  |  |  | F | 0.162 | 4310.674605000001
 |  |  |  |  |  |  |  |  |  |  |  | S | 0.132 | 3512.401530000001
 |  |  |  |  |  |  |  |  |  |  |  | S | 0.115 | 3060.046787500001
 |  |  |  |  |  |  |  |  |  |  |  | Total Gross Sales | 1 | 26609.1025
 |  |  |  |  |  |  |  |  |  |  |  | Hours | Mgr | Hourly | CSR
 |  |  |  |  |  |  |  |  |  |  |  | M | 9 | 50.82401530000001 | 5
 |  |  |  |  |  |  |  |  |  |  |  | T | 9 | 56.41192682500001 | 5
 |  |  |  |  |  |  |  |  |  |  |  | W | 9 | 56.41192682500001 | 5
 |  |  |  |  |  |  |  |  |  |  |  | H | 9 | 56.41192682500001 | 5
 |  |  |  |  |  |  |  |  |  |  |  | F | 9 | 58.80674605000002 | 5
 |  |  |  |  |  |  |  |  |  |  |  | S | 0 | 64.82401530000001 | 0
 |  |  |  |  |  |  |  |  |  |  |  | S | 0 | 60.30046787500001 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Close Time Adj |  | 21
 |  |  |  |  |  |  |  |  |  |  |  | Total Hours | 45 | 424.991025 | 25