Page 97 - New Employee Onboarding

Confidential and Privileged
For The Audit and Finance Committee's Review
Work-paper #3-2:
Apple Market Basket vs. Modified Producer Price Index:
2015 Performance by Category

Category: Seafood

Apple Market Basket Modified Producer Price Index (MPPI)
Average Actual Store Cost (Jan - Dec) Budgeted Spend Average PPI Sub-Indices (Jan - Dec) Indexed Cost Indexed Spend
Product 2014 2015 fav/(unfav) Volume 2015 2014 2015 fav/(unfav) Referenced PPI Sub-Indices PPI Code 2014 2015 fav/(unfav) 2015 2015 fav/(unfav)
[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16]
Haddock/Cod $4.09 $3.97 2.9% 2,500,000 $10,213,778 $9,912,876 2.9% Prepared frozen fish WPU02230602 93 93 0.0% $4.09 $10,212,863 0.0%
Shrimp, 41/50 P/D T/Off Raw $6.07 $5.63 7.2% 9,000,000 $54,642,013 $50,701,926 7.2% Prepared frozen shellfish WPU02230603 111 104 5.9% $5.71 $51,397,991 5.9%
Shrimp, Breaded, Butterfly, Tail On, 26/30 $4.70 $4.21 10.3% 3,250,000 $15,274,584 $13,695,120 10.3% Prepared frozen shellfish WPU02230603 111 104 5.9% $4.42 $14,367,753 5.9%
Salmon, 6 oz Portion 1/20 lbs $7.42 $7.07 4.7% 1,400,000 $10,389,120 $9,899,543 4.7% Prepared frozen fish WPU02230602 93 93 0.0% $7.42 $10,388,189 0.0%
Overall Performance $90,519,495 $84,209,466 7.0% Overall Performance $86,366,795 4.6%

Category: Dressing Sauces & Soups
Apple Market Basket Modified Producer Price Index (MPPI)
Average Actual Store Cost (Jan - Dec) Budgeted Spend Average PPI Sub-Indices (Jan - Dec) Indexed Cost Indexed Spend
Product 2014 2015 fav/(unfav) Volume 2015 2014 2015 fav/(unfav) Referenced PPI Sub-Indices PPI Code 2014 2015 fav/(unfav) 2015 2015 fav/(unfav)
[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16]
Dressing, Buttermilk Ranch $0.69 $0.67 2.9% 9,839,056 $6,773,555 $6,579,840 2.9% Mayonnaise, salad dressings, and sandwich spreads WPU02890102 221 222 -0.1% $0.69 $6,782,223 -0.1%
Salsa, Crushed $0.54 $0.56 -3.7% 4,953,441 $2,696,048 $2,794,683 -3.7% Canned catsup and other tomato based sauces WPU02440127 157 156 0.8% $0.54 $2,673,485 0.8%
Sauce, Marinara $0.42 $0.44 -4.2% 5,597,363 $2,361,731 $2,460,058 -4.2% Canned catsup and other tomato based sauces WPU02440127 157 156 0.8% $0.42 $2,341,966 0.8%
Sauce, Alfredo $1.36 $1.42 -4.6% 11,551,945 $15,704,174 $16,418,965 -4.6% Prepared sauces, except tomato WPU02860103 157 158 -0.6% $1.37 $15,799,825 -0.6%
Sauce, Honey Barbeque $0.50 $0.51 -2.1% 10,271,221 $5,114,276 $5,221,818 -2.1% Prepared sauces, except tomato WPU02860103 157 158 -0.6% $0.50 $5,145,426 -0.6%
Spinach & Artichoke Dip $1.44 $1.45 -0.6% 11,378,476 $16,409,732 $16,501,488 -0.6% Prepared sauces, except tomato WPU02860103 157 158 -0.6% $1.45 $16,509,680 -0.6%
Sauce, White Queso $1.75 $1.66 5.4% 9,536,241 $16,720,453 $15,823,272 5.4% Prepared sauces, except tomato WPU02860103 157 158 -0.6% $1.76 $16,822,294 -0.6%
Sauce, Wing $0.88 $0.85 3.0% 4,492,695 $3,939,235 $3,821,823 3.0% Prepared sauces, except tomato WPU02860103 157 158 -0.6% $0.88 $3,963,228 -0.6%
Soup, French Onion $0.96 $0.98 -2.2% 4,932,992 $4,712,026 $4,815,487 -2.2% Frozen dinners and nationality foods WPU02850111 166 166 0.1% $0.95 $4,709,424 0.1%
Soup, Tomato Basil $0.81 $0.82 -1.1% 3,810,745 $3,088,066 $3,120,713 -1.1% Frozen dinners and nationality foods WPU02850111 166 166 0.1% $0.81 $3,086,360 0.1%
Overall Performance $77,519,297 $77,558,148 -0.1% Overall Performance $77,833,910 -0.4%

Sources & Notes:
[1]: Products are based on Apple Price Index.
[2]: Average actual store cost for 2014 is calculated by taking the average of prices from January 2014 through December 2014. UOM is price/pound.
[3]: Average actual store cost for 2015 is calculated by taking the average of prices from January 2015 through December 2015. UOM is price/pound.
[4]: Change in average actual store cost= -{[3] - [2]}/[2].
[5]: Budgeted volumes for 2015 are based on Apple Price Index. UOM is pound.
[6]: [2] x [5].
[7]: [3] x [5].
[8]: -{[7] - [6]}/[6]. Notice that [4] & [8] have the same results.
[9]: PPI sub-indices are selected based on resemblance with products in Apple Market Basket.
[10]: See PPI Codes on the Bureau of Labor Statistics: http://www.bls.gov/news.release/pdf/ppi.pdf
[11]: Data were retrieved from the Bureau of Labor Statistic website: http://data.bls.gov/cgi-bin/srgate
[12]: Data were retrieved from the Bureau of Labor Statistic website: http://data.bls.gov/cgi-bin/srgate
[13]: Change in PPI sub-indices = -{[12] - [11]}/[11].
[14]: [2] x {1 - [13]}.
[15]: [5] x [14].
[16]: -{[15] - [6]}/[6]. Notice that [13] & [16] have the same results.