History and Variance Analysis Report - Today's Date:
Friday October 19th, 2007
DEPARTMENT | ANALYSIS | CURRENT | PRIOR-1 | PRIOR-2 | PRIOR-3 | PRIOR-4 | PRIOR-5 | PRIOR-6 | AVERAGE |
2007-09-21 | 2007-08-24 | 2007-07-27 | 2007-06-22 | 0000-00-00 | 0000-00-00 | 0000-00-00 | Fountain/Coffee | LEVEL | 555.20 | 667.50 | 329.27 | 813.25 | 0.00 | 0.00 | 0.00 | 591.30 | VAR $ | -112.30 | 338.23 | -483.98 | 813.25 | 0.00 | 0.00 | 138.80 | VAR % | -16.82 | 102.72 | -59.51 | 100.00 | 0.00 | 0.00 | 31.60 | BOOK | 511.33 | 1,291.94 | 149.24 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 43.87 | -624.44 | 180.03 | 0.00 | 0.00 | 0.00 | 0.00 | -133.51 | % +/- | 8.58 | -48.33 | 120.63 | 0.00 | 0.00 | 0.00 | 0.00 | 26.96 | COFFEE | LEVEL | 0.00 | 0.00 | 396.11 | 603.55 | 0.00 | 0.00 | 0.00 | 499.83 | VAR $ | 0.00 | -396.11 | -207.44 | 603.55 | 0.00 | 0.00 | 0.00 | VAR % | 0.00 | -100.00 | -34.37 | 100.00 | 0.00 | 0.00 | -11.46 | BOOK | 0.00 | 0.00 | 383.75 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 0.00 | 0.00 | 12.36 | 0.00 | 0.00 | 0.00 | 0.00 | 12.36 | % +/- | 0.00 | 0.00 | 3.22 | 0.00 | 0.00 | 0.00 | 0.00 | 3.22 | NEWS/NON TAX | LEVEL | 5.00 | 6.25 | 6.00 | 6.50 | 0.00 | 0.00 | 0.00 | 5.94 | VAR $ | -1.25 | 0.25 | -0.50 | 6.50 | 0.00 | 0.00 | 1.25 | VAR % | -20.00 | 4.17 | -7.69 | 100.00 | 0.00 | 0.00 | 19.12 | BOOK | 6.25 | -6.83 | 12.00 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | -1.25 | 13.08 | -6.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.94 | % +/- | -20.00 | -191.51 | -50.00 | 0.00 | 0.00 | 0.00 | 0.00 | -87.17 | IWANNA/MAGS/MAPS | LEVEL | 420.40 | 446.61 | 92.26 | 92.99 | 0.00 | 0.00 | 0.00 | 263.07 | VAR $ | -26.21 | 354.35 | -0.73 | 92.99 | 0.00 | 0.00 | 105.10 | VAR % | -5.87 | 384.08 | -0.79 | 100.00 | 0.00 | 0.00 | 119.36 | BOOK | 302.45 | -96.01 | 145.96 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 117.95 | 542.62 | -53.70 | 0.00 | 0.00 | 0.00 | 0.00 | 202.29 | % +/- | 39.00 | -565.17 | -36.79 | 0.00 | 0.00 | 0.00 | 0.00 | -187.65 | CLOTHING | LEVEL | 0.00 | 0.00 | 0.00 | 202.18 | 0.00 | 0.00 | 0.00 | 202.18 | VAR $ | 0.00 | 0.00 | -202.18 | 202.18 | 0.00 | 0.00 | 0.00 | VAR % | 0.00 | 0.00 | -100.00 | 100.00 | 0.00 | 0.00 | 0.00 | BOOK | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | % +/- | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | FEED/SEED | LEVEL | 106.73 | 132.24 | 150.08 | 151.97 | 0.00 | 0.00 | 0.00 | 135.26 | VAR $ | -25.51 | -17.84 | -1.89 | 151.97 | 0.00 | 0.00 | 26.68 | VAR % | -19.29 | -11.89 | -1.24 | 100.00 | 0.00 | 0.00 | 16.89 | BOOK | 136.68 | 155.92 | 161.19 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | -29.95 | -23.68 | -11.11 | 0.00 | 0.00 | 0.00 | 0.00 | -21.58 | % +/- | -21.91 | -15.19 | -6.89 | 0.00 | 0.00 | 0.00 | 0.00 | -14.66 | BAIT/TACKLE | LEVEL | 4,452.56 | 3,839.36 | 3,885.69 | 4,148.93 | 0.00 | 0.00 | 0.00 | 4,081.64 | VAR $ | 613.20 | -46.33 | -263.24 | 4,148.93 | 0.00 | 0.00 | 1,113.14 | VAR % | 15.97 | -1.19 | -6.34 | 100.00 | 0.00 | 0.00 | 27.11 | BOOK | 4,305.88 | 3,556.14 | 3,321.45 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 146.68 | 283.22 | 564.24 | 0.00 | 0.00 | 0.00 | 0.00 | 331.38 | % +/- | 3.41 | 7.96 | 16.99 | 0.00 | 0.00 | 0.00 | 0.00 | 9.45 | GROCERY 7% | LEVEL | 108.97 | 63.06 | 57.09 | 111.92 | 0.00 | 0.00 | 0.00 | 85.26 | VAR $ | 45.91 | 5.97 | -54.83 | 111.92 | 0.00 | 0.00 | 27.24 | VAR % | 72.80 | 10.46 | -48.99 | 100.00 | 0.00 | 0.00 | 33.57 | BOOK | 106.91 | -148.15 | -144.98 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 2.06 | 211.21 | 202.07 | 0.00 | 0.00 | 0.00 | 0.00 | 138.45 | % +/- | 1.93 | -142.56 | -139.38 | 0.00 | 0.00 | 0.00 | 0.00 | -93.34 | GROCERY 2% | LEVEL | 3,702.95 | 4,140.32 | 4,785.23 | 5,407.45 | 0.00 | 0.00 | 0.00 | 4,508.99 | VAR $ | -437.37 | -644.91 | -622.22 | 5,407.45 | 0.00 | 0.00 | 925.74 | VAR % | -10.56 | -13.48 | -11.51 | 100.00 | 0.00 | 0.00 | 16.11 | BOOK | 3,747.12 | 4,270.61 | 5,127.17 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | -44.17 | -130.29 | -341.94 | 0.00 | 0.00 | 0.00 | 0.00 | -172.13 | % +/- | -1.18 | -3.05 | -6.67 | 0.00 | 0.00 | 0.00 | 0.00 | -3.63 | NON-FOOD | LEVEL | 5,411.87 | 5,519.76 | 6,179.06 | 5,766.67 | 0.00 | 0.00 | 0.00 | 5,719.34 | VAR $ | -107.89 | -659.30 | 412.39 | 5,766.67 | 0.00 | 0.00 | 1,352.97 | VAR % | -1.95 | -10.67 | 7.15 | 100.00 | 0.00 | 0.00 | 23.63 | BOOK | 5,413.49 | 5,267.25 | 6,839.12 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | -1.62 | 252.51 | -660.06 | 0.00 | 0.00 | 0.00 | 0.00 | -136.39 | % +/- | -0.03 | 4.79 | -9.65 | 0.00 | 0.00 | 0.00 | 0.00 | -1.63 | BEER | LEVEL | 4,576.18 | 4,336.82 | 3,829.48 | 3,884.81 | 0.00 | 0.00 | 0.00 | 4,156.82 | VAR $ | 239.36 | 507.34 | -55.33 | 3,884.81 | 0.00 | 0.00 | 1,144.05 | VAR % | 5.52 | 13.25 | -1.42 | 100.00 | 0.00 | 0.00 | 29.34 | BOOK | 4,933.30 | 4,505.80 | 3,961.94 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | -357.12 | -168.98 | -132.46 | 0.00 | 0.00 | 0.00 | 0.00 | -219.52 | % +/- | -7.24 | -3.75 | -3.34 | 0.00 | 0.00 | 0.00 | 0.00 | -4.78 | CIGARETTES | LEVEL | 17,274.40 | 16,628.21 | 17,819.83 | 17,144.67 | 0.00 | 0.00 | 0.00 | 17,216.78 | VAR $ | 646.19 | -1,191.62 | 675.16 | 17,144.67 | 0.00 | 0.00 | 4,318.60 | VAR % | 3.89 | -6.69 | 3.94 | 100.00 | 0.00 | 0.00 | 25.28 | BOOK | 17,185.17 | 16,970.53 | 17,820.10 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 89.23 | -342.32 | -0.27 | 0.00 | 0.00 | 0.00 | 0.00 | -84.45 | % +/- | 0.52 | -2.02 | -0.00 | 0.00 | 0.00 | 0.00 | 0.00 | -0.50 | TOBACCO PROD | LEVEL | 5,073.00 | 5,146.21 | 4,785.39 | 4,499.01 | 0.00 | 0.00 | 0.00 | 4,875.90 | VAR $ | -73.21 | 360.82 | 286.38 | 4,499.01 | 0.00 | 0.00 | 1,268.25 | VAR % | -1.42 | 7.54 | 6.37 | 100.00 | 0.00 | 0.00 | 28.12 | BOOK | 4,393.79 | 5,346.45 | 4,990.56 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 679.21 | -200.24 | -205.17 | 0.00 | 0.00 | 0.00 | 0.00 | 91.27 | % +/- | 15.46 | -3.75 | -4.11 | 0.00 | 0.00 | 0.00 | 0.00 | 2.53 | CANDY | LEVEL | 6,966.43 | 7,466.80 | 6,784.88 | 6,492.84 | 0.00 | 0.00 | 0.00 | 6,927.74 | VAR $ | -500.37 | 681.92 | 292.04 | 6,492.84 | 0.00 | 0.00 | 1,741.61 | VAR % | -6.70 | 10.05 | 4.50 | 100.00 | 0.00 | 0.00 | 26.96 | BOOK | 7,635.65 | 6,687.19 | 6,929.62 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | -669.22 | 779.61 | -144.74 | 0.00 | 0.00 | 0.00 | 0.00 | -11.45 | % +/- | -8.76 | 11.66 | -2.09 | 0.00 | 0.00 | 0.00 | 0.00 | 0.27 | SNACKS | LEVEL | 4,201.28 | 3,689.52 | 3,619.65 | 3,688.66 | 0.00 | 0.00 | 0.00 | 3,799.78 | VAR $ | 511.76 | 69.87 | -69.01 | 3,688.66 | 0.00 | 0.00 | 1,050.32 | VAR % | 13.87 | 1.93 | -1.87 | 100.00 | 0.00 | 0.00 | 28.48 | BOOK | 3,649.24 | 3,897.04 | 3,584.10 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 552.04 | -207.52 | 35.55 | 0.00 | 0.00 | 0.00 | 0.00 | 126.69 | % +/- | 15.13 | -5.33 | 0.99 | 0.00 | 0.00 | 0.00 | 0.00 | 3.60 | DAIRY | LEVEL | 567.67 | 767.90 | 581.25 | 631.07 | 0.00 | 0.00 | 0.00 | 636.97 | VAR $ | -200.23 | 186.65 | -49.82 | 631.07 | 0.00 | 0.00 | 141.92 | VAR % | -26.08 | 32.11 | -7.89 | 100.00 | 0.00 | 0.00 | 24.54 | BOOK | 452.84 | 771.06 | 628.41 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 114.83 | -3.16 | -47.16 | 0.00 | 0.00 | 0.00 | 0.00 | 21.50 | % +/- | 25.36 | -0.41 | -7.50 | 0.00 | 0.00 | 0.00 | 0.00 | 5.81 | HBA | LEVEL | 1,926.67 | 1,880.65 | 1,814.93 | 1,881.20 | 0.00 | 0.00 | 0.00 | 1,875.86 | VAR $ | 46.02 | 65.72 | -66.27 | 1,881.20 | 0.00 | 0.00 | 481.67 | VAR % | 2.45 | 3.62 | -3.52 | 100.00 | 0.00 | 0.00 | 25.64 | BOOK | 1,636.03 | 1,938.72 | 1,739.78 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 290.64 | -58.07 | 75.15 | 0.00 | 0.00 | 0.00 | 0.00 | 102.57 | % +/- | 17.76 | -3.00 | 4.32 | 0.00 | 0.00 | 0.00 | 0.00 | 6.36 | SOFT DRINKS | LEVEL | 3,917.36 | 3,441.44 | 3,507.91 | 3,200.86 | 0.00 | 0.00 | 0.00 | 3,516.89 | VAR $ | 475.92 | -66.47 | 307.05 | 3,200.86 | 0.00 | 0.00 | 979.34 | VAR % | 13.83 | -1.89 | 9.59 | 100.00 | 0.00 | 0.00 | 30.38 | BOOK | 4,598.81 | 3,477.00 | 3,761.07 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | -681.45 | -35.56 | -253.16 | 0.00 | 0.00 | 0.00 | 0.00 | -323.39 | % +/- | -14.82 | -1.02 | -6.73 | 0.00 | 0.00 | 0.00 | 0.00 | -7.52 | SPORT DRINKS | LEVEL | 2,894.03 | 2,452.88 | 2,873.99 | 1,753.06 | 0.00 | 0.00 | 0.00 | 2,493.49 | VAR $ | 441.15 | -421.11 | 1,120.93 | 1,753.06 | 0.00 | 0.00 | 723.51 | VAR % | 17.98 | -14.65 | 63.94 | 100.00 | 0.00 | 0.00 | 41.82 | BOOK | 2,760.08 | 2,392.28 | 2,241.99 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 133.95 | 60.60 | 632.00 | 0.00 | 0.00 | 0.00 | 0.00 | 275.52 | % +/- | 4.85 | 2.53 | 28.19 | 0.00 | 0.00 | 0.00 | 0.00 | 11.86 | WATER/FLV WATER | LEVEL | 914.57 | 906.62 | 981.34 | 1,759.05 | 0.00 | 0.00 | 0.00 | 1,140.40 | VAR $ | 7.95 | -74.72 | -777.71 | 1,759.05 | 0.00 | 0.00 | 228.64 | VAR % | 0.88 | -7.61 | -44.21 | 100.00 | 0.00 | 0.00 | 12.26 | BOOK | 869.51 | 1,173.70 | 1,763.99 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 45.06 | -267.08 | -782.65 | 0.00 | 0.00 | 0.00 | 0.00 | -334.89 | % +/- | 5.18 | -22.76 | -44.37 | 0.00 | 0.00 | 0.00 | 0.00 | -20.65 | ENERGY DRINKS | LEVEL | 1,240.58 | 1,535.13 | 1,821.57 | 1,253.95 | 0.00 | 0.00 | 0.00 | 1,462.81 | VAR $ | -294.55 | -286.44 | 567.62 | 1,253.95 | 0.00 | 0.00 | 310.15 | VAR % | -19.19 | -15.72 | 45.27 | 100.00 | 0.00 | 0.00 | 27.59 | BOOK | 1,391.96 | 1,560.81 | 1,728.01 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | -151.38 | -25.68 | 93.56 | 0.00 | 0.00 | 0.00 | 0.00 | -27.83 | % +/- | -10.88 | -1.65 | 5.41 | 0.00 | 0.00 | 0.00 | 0.00 | -2.37 | PROPANE | LEVEL | 215.88 | 197.89 | 251.86 | 287.84 | 0.00 | 0.00 | 0.00 | 238.37 | VAR $ | 17.99 | -53.97 | -35.98 | 287.84 | 0.00 | 0.00 | 53.97 | VAR % | 9.09 | -21.43 | -12.50 | 100.00 | 0.00 | 0.00 | 18.79 | BOOK | 45.88 | 206.54 | 241.84 | 0.00 | 0.00 | 0.00 | 0.00 | AMT +/- | 170.00 | -8.65 | 10.02 | 0.00 | 0.00 | 0.00 | 0.00 | 57.12 | % +/- | 370.53 | -4.19 | 4.14 | 0.00 | 0.00 | 0.00 | 0.00 | 123.50 | TOTAL STORE | LEVEL | 64,531.73 | 63,265.17 | 64,552.87 | 63,782.43 | 0.00 | 0.00 | 0.00 | 64,033.05 | VAR $ | 1,266.56 | -1,287.70 | 770.44 | 63,782.43 | 0.00 | 0.00 | 16,132.93 | VAR % | 2.00 | -1.99 | 1.21 | 100.00 | 0.00 | 0.00 | 25.30 | BOOK | 64,082.37 | 63,217.99 | 65,386.31 | 0.00 | 0.00 | 0.00 | 0.00 | excl depts w/o book figure | AMT +/- | 449.36 | 47.18 | -833.44 | 0.00 | 0.00 | 0.00 | 0.00 | -112.30 | excl depts w/o book figure | % +/- | 0.70 | 0.07 | -1.27 | 0.00 | 0.00 | 0.00 | 0.00 | -0.17 | incl all depts | AMT +/- | 449.36 | 47.18 | -833.44 | 63,782.43 | 0.00 | 0.00 | 0.00 | 15,861.38 | incl all depts | % +/- | 0.70 | 0.07 | -1.27 | 0.00 | 0.00 | 0.00 | 0.00 | -0.17 | *later booking due to delayed findings (if any) | AMT +/- | 449.36 | 47.18 | -833.44 | 63,782.43 | 0.00 | 0.00 | 0.00 | 15,861.38 | *revised % based on delayed booking | % +/- | 0.70 | 0.07 | -1.27 | 0.00 | 0.00 | 0.00 | 0.00 | -0.17 |