Blue Mountain Coffee Company sells two different coffees-to-go (flavored coffees and iced coffees). Additionally, they sell their private label ground coffee. Their store fronts are very small with no seating - providing walk-up service only, generally located in outdoor walking/shopping districts. While Blue Mountain did experience a downturn in March and April during the peak of the local shutdown effort in response to COVID-19 concerns, they are now experiencing an increase in sales.

The Budgeted P&L Statement on the next page shows the Corner Shores store?s weekly budget for the 3^rd Quarter of 2020 as well as actual results from Week 1 (July 1 ? July 8, 2020).

Eva, the owner of Blue Mountain Coffee, experimented with offering 10% discounts on flavored and iced coffees through her Twitter and Instagram social media channels. Knowing that not every customer would take advantage of the discount, she hoped that the discounts would increase sales volume for the week and wants to know if the strategy worked.

Instructions

Prepare a report for Eva that addresses the performance and CVP analyses below. Be sure to organize your report to Eva in the same order as listed below.

Performance Analysis

Eva has noted that actual operating income was $675 vs. budgeted income of $800, 16% less than expected.

1. Prepare a performance analysis report for Blue Mountain Coffee. The report should provide details about revenue and spending variances and activity variances for each product line as well as for the store as a whole.
   1. The individual product line reports should be completed through to product-line margin
   2. The report at the store level should be completed through to pre-tax operating income
2. Briefly discuss the results and assess the degree to which it appears the discounting strategy did or did not work.

CVP Analysis

Eva also wants to know a few more things about her business related to the interaction between prices, costs, and volume. The following issues should be addressed using the budgeted weekly P&L as a reference point.

1. Keeping sales mix, prices, and costs as budgeted, how many units of each of the three product lines would the Corner Shores store need to sell in order to generate $1,000 of pre-tax operating income in a week?
2. Assume Eva offers a 10% discount on Coffee Beans, resulting in average price per bag of $19.00 (10% discount x 50% of customers using the discount x $20.00 budgeted price = $19.00). What is the minimum number of bags of coffee she would need to sell in order to keep product-line margin at $750?

Transcribed Image Text:

Revenue Variable costs (ingredients, labor) Contribution margin Direct Fixed costs Product-line margin Blue Mountain Coffee ToGo, Corner Shores Store Budgeted Weekly P&L, 3rd Quarter, 2020 Flavored Coffees (12 oz) Fixed operating expenses (rent, marketing) Pre-tax operating income Operating Data Weekly volume $1,500 600 $900 $100 $800 300 $5.00 2.00 $3.00 Iced Coffees (16 oz) $6.00 4.00 $2.00 $3,600 2,400 $1,200 $300 $900 600 Coffee Beans Ground (2.5 lb) $2,000 $20.00 800 8.00 $12.00 $1,200 $450 $750 100 Total $7,100 $3,800 $3,300 $850 $2,450 $2,500 $800 1,000 Revenue Variable costs (ingredients, labor) Contribution margin Direct Fixed costs Product-line margin Blue Mountain Coffee ToGo, Corner Shores Store Acual P&L, Week 1, 3rd Quarter, 2020 Flavored Coffees (12 oz) Fixed operating expenses (rent, marketing) Pre-tax operating income Operating Data Weekly volume $1,552 720 $832 $100 $732 320 $4.85 2.25 $2.60 Iced Coffees (16 oz) $5.90 3.90 $2.00 $3,983 2,633 $1,350 $300 $1,050 675 Coffee Beans Ground (2.5 lb) $1,900 808 $1,093 $450 $643 95 $20.00 8.50 $11.50 Total $7,435 $4,160 $3,275 $850 $2,425 $2,600 $675 1,090 Revenue Variable costs (ingredients, labor) Contribution margin Direct Fixed costs Product-line margin Blue Mountain Coffee ToGo, Corner Shores Store Budgeted Weekly P&L, 3rd Quarter, 2020 Flavored Coffees (12 oz) Fixed operating expenses (rent, marketing) Pre-tax operating income Operating Data Weekly volume $1,500 600 $900 $100 $800 300 $5.00 2.00 $3.00 Iced Coffees (16 oz) $6.00 4.00 $2.00 $3,600 2,400 $1,200 $300 $900 600 Coffee Beans Ground (2.5 lb) $2,000 $20.00 800 8.00 $12.00 $1,200 $450 $750 100 Total $7,100 $3,800 $3,300 $850 $2,450 $2,500 $800 1,000 Revenue Variable costs (ingredients, labor) Contribution margin Direct Fixed costs Product-line margin Blue Mountain Coffee ToGo, Corner Shores Store Acual P&L, Week 1, 3rd Quarter, 2020 Flavored Coffees (12 oz) Fixed operating expenses (rent, marketing) Pre-tax operating income Operating Data Weekly volume $1,552 720 $832 $100 $732 320 $4.85 2.25 $2.60 Iced Coffees (16 oz) $5.90 3.90 $2.00 $3,983 2,633 $1,350 $300 $1,050 675 Coffee Beans Ground (2.5 lb) $1,900 808 $1,093 $450 $643 95 $20.00 8.50 $11.50 Total $7,435 $4,160 $3,275 $850 $2,425 $2,600 $675 1,090

Answer rating: 100% (QA)

Answer Net Contribution Margin Variance Flavored Coffee... View the full answer