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

An Excel spreadsheet of the budgeted P&L and actual results is available for download.

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. The report should be in a single word document, but you can include images from Excel worksheets and/or jpg images of your analysis in the word document.

Performance Analysis

Eva has noted that actual operating income was $675 vs. budgeted income of $800, 16% less than expected 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.

a.The individual product line reports should be completed through to product-line margin

b.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?

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