Spreadsheet: 88449d1288269580-calculating-ytd-sales-example
Sheet: Sheet1

 | CURRENT MONTH SALES |  |  |  |  |  |  |  |  |  | YEAR TO DATE SALES
 | T/Y | % OF TOTAL | L/Y | % OF TOTAL | DIFF $ | DIFF % | T/Y PLAN | % OF TOTAL | DIFF $ | DIFF% | T/YEAR | % OF TOTAL | L/YEAR | % OF TOTAL | DIFF $ | DIFF % | PLAN | % OF TOTAL | DIFF $ | DIFF %
BOOTS | 69947.42 | 0.327166795222936 | 58136.62 | 0.3446380677899928 | 11810.8 | 0.2031559454264798 | 58846 | 0.3453748319961499 | 11101.42 | 0.1886520749073853 | 433070 | 0.2951875842222178 | 382408 | 0.2890172711415037 | 50662 | 0.1324815380431372 | 399254 | 0.2938590874230307 | 33816 | 0.08469796169856783
HATS | 17306.29 | 0.08094713767139297 | 10896.83 | 0.06459719254810527 | 6409.460000000001 | 0.5881949154020023 | 11006 | 0.06459564627926495 | 6300.290000000001 | 0.5724413956023988 | 111951 | 0.07630762980871801 | 103927 | 0.07854620702998642 | 8024 | 0.07720804025902797 | 103280 | 0.07601618656056197 | 8671 | 0.0839562354763749
BELTS | 9911.88 | 0.04636108114115309 | 6589.14 | 0.03906089617865217 | 3322.739999999999 | 0.5042752164925922 | 6655 | 0.0390590610565608 | 3256.879999999999 | 0.489388429752066 | 56263 | 0.03834977959935956 | 46111 | 0.03484988648146972 | 10152 | 0.2201643859382794 | 47276 | 0.03479610026953067 | 8987 | 0.1900964548608173
TOTAL  BHB | 97165.59 | 0.4544750140354821 | 75622.59 | 0.4482961565167503 | 21542.99999999999 | 0.2848751940392414 | 76507 | 0.4490295393319756 | 20658.59 | 0.2700222201890023 | 601284 | 0.4098449936302954 | 532446 | 0.4024133646529598 | 68838 | 0.1292863501650872 | 549810 | 0.4046713742531233 | 51474 | 0.09362143285862388
KIDS | 3278.95 | 0.01533671382298655 | 4286.16 | 0.02540866497981403 | -1007.21 | -0.2349912275789985 | 4329 | 0.02540746435970725 | -1050.05 | -0.2425617925617926 | 27672 | 0.01886168709584412 | 32676 | 0.02469594870353072 | -5004 | -0.1531399192067573 | 32901 | 0.02421580706844548 | -5229 | -0.1589313394729643
LTOP | 13877.79 | 0.06491092993961621 | 10501.95 | 0.0622563154862996 | 3375.84 | 0.3214488737805836 | 10607 | 0.06225386335491217 | 3270.790000000001 | 0.3083614594135949 | 90199 | 0.0614811113890591 | 81945 | 0.06193259629424729 | 8254 | 0.1007260967722253 | 81712 | 0.0601416986467529 | 8487 | 0.103864793420795
LOUT | 518.27 | 0.002424117071940481 | 619.53 | 0.003672618431170134 | -101.26 | -0.1634464836246832 | 626 | 0.003674075465275292 | -107.73 | -0.1720926517571885 | 7826 | 0.005334329401997545 | 10090 | 0.007625845342717129 | -2264 | -0.224380574826561 | 9214 | 0.006781691934246882 | -1388 | -0.1506403299327111
LBOT | 18912.29 | 0.08845892113857497 | 12203.05 | 0.07234055872434056 | 6709.240000000002 | 0.5498002548543194 | 12325 | 0.07233702892894243 | 6587.290000000001 | 0.534465720081136 | 102233 | 0.06968368230953424 | 84422 | 0.06380466952654762 | 17811 | 0.2109758119921347 | 89834 | 0.06611965630791561 | 12399 | 0.1380212391744774
MBOT | 12614.93 | 0.05900412366977471 | 11005.12 | 0.06523914346236513 | 1609.809999999999 | 0.1462782777470849 | 11115 | 0.0652353814641132 | 1499.93 | 0.1349464687359425 | 57879 | 0.03945127158934525 | 50865 | 0.03844287644770136 | 7014 | 0.1378944264228841 | 50808 | 0.03739572431031209 | 7071 | 0.1391709966934341
MTOP | 7691.83 | 0.03597718644232534 | 7410.42 | 0.04392950313094086 | 281.4099999999999 | 0.03797490560589006 | 7484 | 0.04392456993948927 | 207.8299999999999 | 0.02776990913949759 | 76631 | 0.05223294101769408 | 76403 | 0.05774404972444171 | 228 | 0.002984176014030863 | 81048 | 0.05965298110341234 | -4417 | -0.05449856874938308
MOUT | 1568.48 | 0.007336290244461779 | 1216.12 | 0.007209246891215314 | 352.3600000000001 | 0.2897411439660561 | 1228 | 0.007207291807281243 | 340.48 | 0.2772638436482085 | 8005 | 0.005456338725145712 | 7070 | 0.005343382217344906 | 935 | 0.1322489391796322 | 8323 | 0.00612589776087875 | -318 | -0.0382073771476631
SHOW | 5246.14 | 0.0245379001983326 | 3772.57 | 0.02236406649376061 | 1473.57 | 0.3906011021664277 | 3811 | 0.02236725494914399 | 1435.14 | 0.3765783258987143 | 52642 | 0.0358816468668483 | 46536 | 0.03517109404050389 | 6106 | 0.1312102458311845 | 47633 | 0.03505885955111588 | 5009 | 0.1051581886507253
TOTAL CLOTHING | 63708.68000000001 | 0.2979861825280127 | 51014.92000000001 | 0.3024201175999063 | 12693.76 | 0.24882446154968 | 51525 | 0.3024069302688648 | 12183.68 | 0.2364615235322659 | 423087 | 0.2883830083954683 | 390007 | 0.2947604622970346 | 33080 | 0.08481899042837693 | 401473 | 0.2954923166830799 | 21614 | 0.05383674618218411
JEWELRY/MISC | 6684.51 | 0.03126562372615985 | 6367.24 | 0.03774545700722116 | 317.2700000000004 | 0.04982849711963118 | 6431 | 0.03774437590604696 | 253.5100000000002 | 0.03941999689006379 | 73115 | 0.04983637799987867 | 70577 | 0.05334086092695211 | 2538 | 0.03596072374852997 | 72640 | 0.05346452160882283 | 475 | 0.006539096916299559
BATH | 301.46 | 0.001410026303870912 | 69.85 | 0.0004140758275099412 | 231.61 | 3.315819613457409 | 71 | 0.0004167082396717983 | 230.46 | 3.245915492957746 | 3513 | 0.002394518168824096 | 972 | 0.0007346205820734439 | 2541 | 2.614197530864197 | 1122 | 0.0008258148849820926 | 2391 | 2.131016042780749
BEDDING | 209.29 | 0.0009789172863303361 | 369.74 | 0.002191845332333939 | -160.45 | -0.4339535890084925 | 374 | 0.002195054670947219 | -164.71 | -0.4404010695187166 | 4535 | 0.003091130058530394 | 2572 | 0.001943872569025615 | 1963 | 0.7632192846034215 | 2459 | 0.00180987415523259 | 2076 | 0.8442456283041887
KITCHEN | 353.59 | 0.001653855240448868 | 187.64 | 0.001112343425539948 | 165.95 | 0.8844063099552334 | 190 | 0.001115134725882277 | 163.59 | 0.8609999999999999 | 1671 | 0.001138980888159711 | 1761 | 0.001330932968139233 | -90 | -0.05110732538330494 | 1758 | 0.001293923857217931 | -87 | -0.04948805460750853
KIDS | 958.74 | 0.004484338282270278 | 1211.96 | 0.007184586111795968 | -253.22 | -0.2089342882603386 | 1224 | 0.007183815286736353 | -265.26 | -0.2167156862745098 | 7843 | 0.005345916879614969 | 8020 | 0.006061375584597757 | -177 | -0.02206982543640898 | 8121 | 0.005977221640766109 | -278 | -0.03423223740918606
RUGS/DRAPES | 19.95 | 9.331262775235419e-05 | 119.9 | 0.0007107758298989542 | -99.95 | -0.8336113427856547 | 121 | 0.0007101647464829238 | -101.05 | -0.8351239669421487 | 1019 | 0.0006945670407149882 | 419 | 0.0003166728640830998 | 600 | 1.431980906921241 | 482 | 0.0003547618311598651 | 537 | 1.114107883817427
HARDWARE | 68.85 | 0.0003220338055513577 | 0 | 0 | 68.85 | #N/A | 0 | 0 | 68.85 | #N/A | 906 | 0.0006175443953756422 | 199 | 0.0001504007158771763 | 707 | 3.552763819095477 | 300 | 0.0002208061189791691 | 606 | 2.02
ACCESS/COLLECT | 1008.26 | 0.004715959401382888 | 725.49 | 0.004300756937726374 | 282.77 | 0.3897641593957187 | 732 | 0.004296203259714877 | 276.26 | 0.3774043715846994 | 15067 | 0.01026991325068963 | 5255 | 0.003971636994646037 | 9812 | 1.867174119885823 | 6247 | 0.004597919417542899 | 8820 | 1.411877701296622
OUTDOOR | 141.8 | 0.0006632446423701165 | 139.86 | 0.0008291001465360112 | 1.939999999999998 | 0.01387101387101385 | 141 | 0.0008275473492073739 | 0.8000000000000114 | 0.005673758865248308 | 2450 | 0.001669960009569893 | 556 | 0.0004202150654658794 | 1894 | 3.406474820143885 | 800 | 0.0005888163172777844 | 1650 | 2.0625
CHRISTMAS | 22.9 | 0.0001071107356154842 | 7 | 4.149650383063119e-05 | 15.9 | 2.271428571428571 | 7 | 4.108391095355757e-05 | 15.9 | 2.271428571428571 | 1350 | 0.000920182046089533 | 1376 | 0.001039956708778867 | -26 | -0.0188953488372093 | 1437 | 0.00105766130991022 | -87 | -0.0605427974947808
STORE/EVENTS | 1429.96 | 0.006688387227105583 | 1316.05 | 0.007801639123757453 | 113.9100000000001 | 0.0865544622164812 | 1329 | 0.007800073951039716 | 100.96 | 0.07596689240030101 | 12378 | 0.008437046938145364 | 10507 | 0.007941006641816538 | 1871 | 0.1780717616826877 | 10522 | 0.007744406612996059 | 1856 | 0.1763923208515491
DROP SHIP | 130 | 0.0006080522109175962 | 119.95 | 0.0007110722334977445 | 10.05 | 0.08378491037932469 | 0 | 0 | 130 | #N/A | 1151 | 0.0007845403963326314 | 87 | 6.57530767905243e-05 | 1064 | 12.22988505747126 | 0 | 0 | 1151 | #N/A
TOTAL GIFTS | 4644.8 | 0.02172523776361578 | 4267.44 | 0.02529769147242696 | 377.3600000000006 | 0.08842772247530149 | 4189 | 0.02458578614063609 | 455.8 | 0.108808784912867 | 51883 | 0.03536430007204685 | 31724 | 0.02397644377129417 | 20159 | 0.6354495019543563 | 33248 | 0.02447120614606472 | 18635 | 0.5604848411934552
WEST/ENG TACK | 26879.46 | 0.1257239621636238 | 20494.45 | 0.1214925747045256 | 6385.009999999998 | 0.3115482484282329 | 20699 | 0.1214851246896697 | 6180.459999999999 | 0.2985873713705976 | 196806 | 0.1341461835279234 | 171415 | 0.129552455839629 | 25391 | 0.1481258932998862 | 174288 | 0.1282795228821381 | 22518 | 0.1291999449187552
SADDLES | 4241 | 0.01983653405001173 | 3130.5 | 0.01855782932025585 | 1110.5 | 0.3547356652291966 | 3162 | 0.01855818949073558 | 1079 | 0.3412397216951297 | 21826 | 0.01487695802811122 | 30662 | 0.02317380276495467 | -8836 | -0.2881742873915596 | 25551 | 0.01880605715345584 | -3725 | -0.1457868576572346
TACK [NAME] | 10473.39 | 0.04898744573309417 | 7791.77 | 0.04619017337891389 | 2681.619999999999 | 0.3441605694213252 | 7870 | 0.04619005417207116 | 2603.389999999999 | 0.3307992376111816 | 99100 | 0.06754817834627609 | 96301 | 0.07278260974717564 | 2799 | 0.02906511874227682 | 101648 | 0.07481500127331529 | -2548 | -0.02506689752872658
TOTAL TACK | 41593.85 | 0.1945479419467297 | 31416.72 | 0.1862405774036954 | 10177.13 | 0.3239399275290354 | 31731 | 0.1862333683524765 | 9862.849999999999 | 0.3108269515615644 | 317732 | 0.2165713199023107 | 298378 | 0.2255088683517593 | 19354 | 0.06486403153047476 | 301487 | 0.2219005813089092 | 16245 | 0.0538829203249228
SUB TOTAL | 213797.43 | 1 | 168688.91 | 1 | 45108.51999999999 | 0.2674065532820147 | 170383 | 1 | 43414.42999999999 | 0.2548049394599226 | 1467101 | 1 | 1323132 | 1 | 143969 | 0.1088092495684482 | 1358658 | 1 | 108443 | 0.07981625986819346
OTHER INCOME GAIN/LOSS | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
FREIGHT NET INC/LOSS | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
CAT LIST SALES | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
TOTAL OTHER INCOME | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GRAND TOTAL INCOME | 213797.43 |  | 168688.91 |  | 45108.51999999999 | 0.2674065532820147 | 170383 |  | 43414.42999999999 | 0.2548049394599226 | 1467101 |  | 1323132 |  | 143969 | 0.1088092495684482 | 1358658 |  | 108443 | 0.07981625986819346