TPG_Report_ Edit _2018-06-14- Final.xlsx

75 46553 1963 1200 1 15 05 15000 374300 301500 728

Info icon This preview shows pages 59–66. Sign up to view the full content.

1,905.75 -465.53 -19.63% -12.00% 1 1.5 0.5 150.00% 3,743.00 3,015.00 -728 -19.45% -0.45% 0.64 0.63 0 99.34% 1,328.99 1,475.68 146.69 11.04% 1.89% 0.67 0.66 0 99.35% 2,692.18 3,404.47 712.29 26.46% -1.47% 0.48 0.53 0.06 111.50% 2,870.64 3,087.86 217.23 7.57% 0.17% 0.73 0.74 0.01 101.33% 1,468.49 1,321.70 -146.8 -10.00% -1.16% 0.89 0.92 0.04 104.12% 709.96 679.79 -30.17 -4.25% -30.00% 1.56 1.67 0.11 106.79% 4,727.25 6,700.24 1,972.99 41.74% -2.29% 1.65 1.77 0.12 107.55% 455.96 449.02 -6.94 -1.52% 0.83% 0.56 0.51 -0.05 91.43% 474.8 471.69 -3.11 -0.66% -3.67% 0.25 0.42 0.17 166.60% 1,884.45 1,885.00 0.55 0.03%
Image of page 59

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

0.32% 0.33 0.38 0.05 116.18% 1,768.22 1,935.21 166.99 9.44% -1.22% 0.58 0.64 0.06 110.29% 981.64 981.75 0.11 0.01% 17.83% 0.73 0.52 -0.21 71.55% 35.56 39.92 4.36 12.26% -0.08% 1 1 0 100.10% 199.8 200 0.2 0.10% -2.89% 1.31 1.49 0.18 113.82% 0.03 0.12 0.09 319.73% 0.60% 14.86 4.21 -10.65 28.32% 6.01 34.3 28.29 470.48% -2.03% -1.41 -1.54 -0.13 109.07% 0.01 -0.01 -0.02 -179.06% 0.00% -48.08% 1.08 1 -0.08 92.86% 44.07 0 -44.07 -100.00% 0.89% 1.21 1.25 0.04 103.45% 299.47 309.7 10.23 3.42% 0.38% 2.14 1.27 -0.87 59.47% 103.37 127.04 23.67 22.90% -0.58% 2.14 1.08 -1.06 50.59% 178.28 189.47 11.2 6.28% 1.91% 1.03 1.03 0 99.79% 990 990 0 -1.24% 2.35 1.36 -0.99 58.02% 128.19 162.16 33.97 26.50% -0.38% 1.18 1.21 0.03 102.64% 357.12 355.55 -1.57 -0.44% 0.41% 2.2 1.89 -0.31 85.72% 152.48 133.33 -19.15 -12.56% 1.09% 1.09 1.13 0.04 103.89% 150 165 15 10.00% 2.27% 1 1 0 100.00% 1,036.64 1,174.80 138.16 13.33% -0.11% 1 1.14 0.14 113.79% 495 495 0 -2.12% 1.42 1.42 0 99.77% 68.98 73.27 4.28 6.21% 2.25% 1.89 2.05 0.16 108.31% 53.96 44.95 -9.01 -16.69% -2.35% 1.21 0.6 -0.62 49.10% 256.02 663.79 407.78 159.28% 1.87% 2.63 2.86 0.22 108.40% 67.54 62.3 -5.25 -7.77% 2.14% 2.25 2.17 -0.08 96.35% 51.46 49.38 -2.09 -4.05% -2.33% 1.29 1.34 0.05 104.13% 157.07 164.6 7.54 4.80%
Image of page 60
-4.17% 1.5 1.08 -0.42 71.79% 70 70 0 4.76% 1.21 1.41 0.2 116.75% 100 100 0 3.21% 1.23 1.36 0.13 110.41% 133.56 130.26 -3.3 -2.47% -5.75% 1.55 1.41 -0.14 91.17% 80.96 79.55 -1.4 -1.73% -0.45% 1.27 1.21 -0.07 94.63% 244.97 206.77 -38.2 -15.59% -6.82% 1.2 1.19 -0.02 98.58% 176.42 170 -6.42 -3.64% 2.50% 1.29 1.34 0.04 103.48% 332.26 294.78 -37.48 -11.28% -0.67% 1.66 1.76 0.1 105.81% 240.62 237.15 -3.47 -1.44% -2.51% 0.76 0.73 -0.04 94.89% 950.04 950 -0.04 0.00% -9.09% 1 1.1 0.1 110.00% 130 190 60 46.15% 10.72% 1.1 1.25 0.16 114.48% 175 156.75 -18.25 -10.43% 8.23% 1 1.71 0.71 170.69% 352.22 148.36 -203.86 -57.88% 113.52% 1 1.34 0.34 134.17% 280 105.75 -174.25 -62.23% 0.30% 0.35 0.32 -0.03 90.26% 755.07 592.66 -162.41 -21.51% -0.35% 0.36 0.34 -0.02 93.77% 273.82 343.81 69.99 25.56% -1.37% 0.13 0.12 -0.01 93.16% 506.52 856.32 349.8 69.06% -0.37% 0.2 0.23 0.02 111.33% 307.98 714.72 406.74 132.07% -0.41% 0.29 0.29 0 100.17% 382.53 579.04 196.51 51.37% -0.68% 0.38 0.36 -0.01 96.05% 348.19 343.7 -4.49 -1.29% -50.00% 0.39 0.4 0.01 102.54% 807.09 910 102.91 12.75% 1.45% 0.5 0.55 0.05 110.19% 484.89 547.29 62.4 12.87% -0.65% 0.39 0.34 -0.06 85.23% 303.19 383.85 80.66 26.60% -0.86% 0.42 0.44 0.03 106.94% 121.6 153 31.4 25.82% 0.00% 0.45 0.44 -0.01 98.38% 186 179.77 -6.23 -3.35% 0.89% 0.27 0.27 0 98.54% 322.05 239.57 -82.49 -25.61% -0.21% 0.14 0.15 0.01 106.11% 666.04 325.41 -340.64 -51.14% -0.07% 0.25 0.21 -0.04 84.13% 218.8 554.66 335.86 153.50% -1.74% 0.72 0.52 -0.21 71.35% 226.41 313.14 86.73 38.31%
Image of page 61

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

-0.61% 0.62 0.58 -0.04 93.40% 70.22 97.47 27.25 38.80% -0.02% 0.44 0.44 0.01 101.37% 250.69 260.47 9.78 3.90% -0.01% 0.19 0.17 -0.02 91.61% 185.84 188.52 2.68 1.44% -0.19% 0.37 0.33 -0.04 89.01% 127.64 119.81 -7.83 -6.14% -0.77% 0.28 0.26 -0.02 92.08% 85.2 130.6 45.4 53.29% -0.58% 0.97 0.96 0 99.48% 237.95 172.3 -65.65 -27.59% -0.37% 0.63 0.7 0.07 110.86% 79.53 44.57 -34.96 -43.96% 0.30% 0.38 0.38 -0.01 97.74% 261.27 235.3 -25.97 -9.94% -0.10% 0.48 0.46 -0.02 96.57% 131.18 144.77 13.59 10.36% -2.32% 0.23 0.18 -0.05 78.93% 560.67 569.8 9.13 1.63% 0.15% 0.56 0.6 0.04 106.94% 369.19 352.7 -16.49 -4.47% -1.05% 1.31 1.19 -0.12 90.49% 78.48 62.71 -15.77 -20.09% -1.18% 0.65 0.64 0 99.40% 463.06 424.01 -39.05 -8.43% 1.82% 1.01 1.29 0.28 127.56% 271.94 103.99 -167.95 -61.76% 2.17% 2.72 2.59 -0.13 95.39% 73.74 75 1.26 1.72% 1.18% 1.17 1.13 -0.04 96.86% 816.45 979.54 163.1 19.98% -0.38% 3.55 3.58 0.03 100.96% 18.99 21.53 2.54 13.37%
Image of page 62
-0.91% 1.29 1.2 -0.09 93.02% 73.42 94.21 20.79 28.31% 0.29% 1.43 1.38 -0.05 96.49% 57.77 62.83 5.06 8.76% -0.62% 1.27 1.27 0 100.14% 119.91 115.88 -4.03 -3.36% -0.65% 1.11 1.17 0.06 105.23% 274.5 275.33 0.83 0.30% 2.24% 1.09 1.14 0.05 104.83% 79.79 76.9 -2.89 -3.62% 0.00% 1.24 1.24 0 99.60% 133.38 135.42 2.05 1.53% -0.96% 0.76 0.74 -0.02 97.29% 140.11 104.55 -35.56 -25.38% -0.25% 1.44 1.44 0 99.80% 46.44 47.87 1.43 3.08% 0.40% 1.26 1.18 -0.08 93.47% 38.49 39.41 0.92 2.39% -0.64% 0.31 0.3 -0.01 96.70% 246.58 373.91 127.32 51.64% 0.98% 0.45 0.5 0.05 110.94% 207.05 93.65 -113.39 -54.77% 25.00% 1.19 0.44 -0.75 36.62% 462 462 0 0.00% -0.36% 0.34 0.31 -0.03 91.33% 133.76 364.76 231 172.71% -0.10% 0.25 0.25 0 101.15% 394.99 287.29 -107.71 -27.27% -0.21% 0.81 0.79 -0.02 97.44% 272.03 239.47 -32.55 -11.97% -0.39% 0.5 0.45 -0.05 90.22% 104.45 203.29 98.83 94.62%
Image of page 63

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

report_04 Department Bakery 0 291 0 261 0 -30 -10.31% Fish 22,434.40 0 22,898.42 0 464.02 0 2.07% Fruits 117,518.97 9,230.00 152,648.09 24,882.27 35,129.12 15,652.27 29.89% 169.58% Meat 48,951.48 152 43,553.42 172 -5,398.06 20 -11.03% 13.16% Production Bakery 921.76 246,587.00 994.64 328,909.00 72.89 82,322.00 7.91% 33.38% Vegetables 267,250.37 112,417.42 277,125.10 123,685.00 9,874.73 11,267.58 3.69% 10.02% 457,076.97 368,677.42 497,219.68 477,909.27 40,142.70 109,231.86 8.78% 29.63% Last Year Similar Week Sales (X) Last Year Sales(NO) Last Week Sales(KG) Last Week Sales(NO) Volume Variance( KG) Volume Variance( NO) Volume Variance as a% (KG) Volume Variance as a% (NO)
Image of page 64
report_05 Department Bakery Buns 0 9 0 11 0 2 Bakery Ingredients 0 282 0 250 0 -32 Fish 22,434.40 0 22,898.42 0 464.02 0 2.07% Fruits Inorganic 116,674.24 9,158.00 152,150.17 24,854.27 35,475.93 15,696.27 30.41% Fruits Organic 844.73 72 497.92 28 -346.8 -44 -41.06% Meat Fresh Meat 26,465.86 0 26,728.32 0 262.47 0 0.99% Meat 19,060.89 0 14,330.58 24 -4,730.31 24 -24.82% Meat 3,424.73 152 2,494.51 148 -930.22 -4 -27.16% Production Bakery Bakery 869.53 244,848.00 806.42 317,379.00 -63.11 72,531.00 -7.26% Production Bakery Deli 0 277 0 216 0 -61 Production Bakery Drinks 0 220 0 255 0 35 Production Bakery Hot Food 52.23 1,189.00 188.23 3,589.00 136 2,400.00 260.41% Production Bakery Juice 0 34 0 4,999.00 0 4,965.00 Production Bakery Pizza 0 19 0 2,471.00 0 2,452.00 Vegetables Exotic 10,829.06 0 10,859.03 438 29.98 438 0.28% Vegetables 143,903.78 0 149,131.11 0 5,227.33 0 3.63% Vegetables Organic 3,914.22 642 3,368.49 513 -545.73 -129 -13.94% Vegetables 0 77,555.14 0 89,870.00 0 12,314.86 Vegetables Pola 5,804.24 34,220.28 6,249.99 32,864.00 445.74 -1,356.28 7.68% Vegetables 102,799.06 0 107,516.48 0 4,717.41 0 4.59% SubDepar tment Last Year Similar Week Sales (X) Last Year Sales(NO) Last Week Sales(KG) Last Week Sales(NO) Volume Variance( KG) Volume Variance( NO) Volume Variance as a% (KG) Fresh Sea Food Frozen Chicken Processed Meat Serve Over Low Country Vegetables Packets & Units Up Country Vegetables
Image of page 65

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

22.22% -11.35% 171.39% -61.11% -2.63% 29.62% -22.02% 15.91% 201.85% 14602.94% 12905.26% -20.09% 15.88% -3.96% Volume Variance as a% (NO)
Image of page 66
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '12
  • Ashok
  • Flour

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern