Page 95 - New Employee Onboarding

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

Category: Beef
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]
Beef, 12 oz Rib Eye Select $7.48 $8.26 -10.5% 311,907 $2,333,122 $2,577,618 -10.5% Frozen ground meat patties, portion control meats WPU02210586 138 138 -0.2% $7.50 $2,338,063 -0.2%
Beef, 12 oz Strip Steak $7.28 $8.08 -11.0% 390,441 $2,840,563 $3,152,885 -11.0% Frozen ground meat patties, portion control meats WPU02210586 138 138 -0.2% $7.29 $2,846,578 -0.2%
Beef, 4 oz House Sirloin $5.47 $6.26 -14.4% 2,242,812 $12,262,398 $14,032,843 -14.4% Frozen ground meat patties, portion control meats WPU02210586 138 138 -0.2% $5.48 $12,288,366 -0.2%
Beef, 7 oz House Sirloin $5.50 $6.30 -14.6% 14,474,539 $79,604,337 $91,205,548 -14.6% Frozen ground meat patties, portion control meats WPU02210586 138 138 -0.2% $5.51 $79,772,919 -0.2%
Beef, 9 oz House Sirloin, Phase II $5.51 $6.31 -14.6% 9,308,700 $51,258,770 $58,721,877 -14.6% Frozen ground meat patties, portion control meats WPU02210586 138 138 -0.2% $5.52 $51,367,323 -0.2%
Beef, Fresh Ground Chuck Bulk, 6 lb, 75/25 $2.88 $2.96 -2.5% 18,515,196 $53,386,524 $54,745,923 -2.5% Boxed meat (beef, pork, lamb, etc.), made from purchased carcass WPU02210504 130 119 8.8% $2.63 $48,673,942 8.8%
Overall Performance $201,685,714 $224,436,694 -11.3% Overall Performance $197,287,192 2.2%

Category: Poultry
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]
Chicken Strip, Chipotle 30# $2.55 $2.56 -0.3% 2,304,000 $5,881,013 $5,901,347 -0.3% Canned, cooked, smoked or prepared poultry WPU02220811 127 128 -1.3% $2.59 $5,958,730 -1.3%
Chicken Tenders, Breaded, Homestyle $2.17 $2.33 -7.4% 14,500,000 $31,418,667 $33,748,201 -7.4% Canned, cooked, smoked or prepared poultry WPU02220811 127 128 -1.3% $2.20 $31,833,864 -1.3%
Chicken, Breast, 7 oz Plain $2.27 $2.36 -4.2% 36,000,000 $81,568,667 $84,999,221 -4.2% Young chickens, including bulk, chilled, frozen, whole WPU02220333 176 172 2.3% $2.21 $79,665,887 2.3%
Chicken, Chunks, Boneless, Breaded $1.85 $1.99 -7.8% 31,000,000 $57,352,914 $61,804,656 -7.8% Canned, cooked, smoked or prepared poultry WPU02220811 127 128 -1.3% $1.87 $58,110,832 -1.3%
Chicken, Wings, IF Mrn Crispy $2.21 $2.16 2.0% 8,800,000 $19,434,931 $19,046,183 2.0% Canned, cooked, smoked or prepared poultry WPU02220811 127 128 -1.3% $2.24 $19,691,763 -1.3%
Turkey, Breast, Roasted, Sliced $5.11 $5.23 -2.4% 1,689,270 $8,632,119 $8,836,337 -2.4% Turkeys, including frozen, whole, and parts WPU02220611 169 163 3.8% $4.92 $8,306,499 3.8%
Overall Performance $204,288,310 $214,335,945 -4.9% Overall Performance $203,567,576 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.