Blue Mountain Coffee Company sells three coffee products to go (flavored, lattes, and iced coffees). Additionally,...

 

Transcribed Image Text:

Blue Mountain Coffee Company sells three coffee products to go (flavored, lattes, and iced coffees). Additionally, they sell their private label coffee beans whole or ground. Their store fronts are small with no seating-providing only walk-up service generally located in outdoor walking/shopping districts. The P&L Statement below shows one store's weekly budget. Additional information is provided below. Use the worksheet to help answer the questions. Blue Mountain Coffee Company Forecast P&L - Week 1, March 2024 Flavored Coffees (12 oz) Lattes (20 oz) Iced Coffees (1602) Revenue $1,500 $6.00 $3,000 $6.00 $2,700 $4.50 $2,100 Coffee Beans $20.00 Total $9,300 Variable costs (ingredients) 600 2.00 2000 4.00 1,950 3.25 840 8.00 5,390 Contribution margin $900 $3.00 $1,000 $2.00 $750 $1.25 $1,200 $12.00 $3,910 Direct Fixed costs $450 $450 $625 $1,000 Segment Margn $450 $550 $1251 $260 $2.525 $1,385 Fixed operating expenses (rent marketing, labor) 475 Pre-tax operating income Income taxes @21% After-tax income Operating Data 1. Weekly volume 300 500 600 105 $ 010 In on $ 191 $ 719 1,505 Required: Answer each of the following questions independently (each question refers to the forecast above). 1. Determine the weekly volume needed for the Flavored Coffee line to breakeven. 2. Determine the revenue needed by the Iced Coffees to generate $750 of Segment Margin. 3. Blue Mountain is considering increasing the price of the Coffee Bean packages. Determine the price necessary for that product line to generate $750 of Segment Margin. 4. The store needs to replace their Latte machine. The new machine will result in $26 additional weekly direct fixed costs. How many additional Lattes will they need to sell to keep Segment Margin unchanged? 5. Determine the weighted average contribution margin ratio (WACM %) for Blue Mountain Coffee. 6. Assuming sales mix remains constant, how much revenue in total is needed for Blue Mountain Coffee to breakeven? 7. Assuming sales mix remains constant, determine the revenue from each product line that is needed to generate $1,000 after-tax income. Blue Mountain Coffee Company sells three coffee products to go (flavored, lattes, and iced coffees). Additionally, they sell their private label coffee beans whole or ground. Their store fronts are small with no seating-providing only walk-up service generally located in outdoor walking/shopping districts. The P&L Statement below shows one store's weekly budget. Additional information is provided below. Use the worksheet to help answer the questions. Blue Mountain Coffee Company Forecast P&L - Week 1, March 2024 Flavored Coffees (12 oz) Lattes (20 oz) Iced Coffees (1602) Revenue $1,500 $6.00 $3,000 $6.00 $2,700 $4.50 $2,100 Coffee Beans $20.00 Total $9,300 Variable costs (ingredients) 600 2.00 2000 4.00 1,950 3.25 840 8.00 5,390 Contribution margin $900 $3.00 $1,000 $2.00 $750 $1.25 $1,200 $12.00 $3,910 Direct Fixed costs $450 $450 $625 $1,000 Segment Margn $450 $550 $1251 $260 $2.525 $1,385 Fixed operating expenses (rent marketing, labor) 475 Pre-tax operating income Income taxes @21% After-tax income Operating Data 1. Weekly volume 300 500 600 105 $ 010 In on $ 191 $ 719 1,505 Required: Answer each of the following questions independently (each question refers to the forecast above). 1. Determine the weekly volume needed for the Flavored Coffee line to breakeven. 2. Determine the revenue needed by the Iced Coffees to generate $750 of Segment Margin. 3. Blue Mountain is considering increasing the price of the Coffee Bean packages. Determine the price necessary for that product line to generate $750 of Segment Margin. 4. The store needs to replace their Latte machine. The new machine will result in $26 additional weekly direct fixed costs. How many additional Lattes will they need to sell to keep Segment Margin unchanged? 5. Determine the weighted average contribution margin ratio (WACM %) for Blue Mountain Coffee. 6. Assuming sales mix remains constant, how much revenue in total is needed for Blue Mountain Coffee to breakeven? 7. Assuming sales mix remains constant, determine the revenue from each product line that is needed to generate $1,000 after-tax income.

Answer rating: 100% (QA)

Blue Mountain Coffee Company PL Analysis 1 Breakeven volume for Flavored Coffee Let x be the number of Flavored Coffees needed to breakeven Variable cost per Flavored Coffee 060 from PL statement Pric... View the full answer