Blue Mountain Coffee Company sells three coffee products to go (flavored, lattes, and iced coffees). Additionally,...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
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
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Because many entrepreneurs are innovators usually keep a close eye on the innovations generated by big companies
-
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...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
A card is drawn at random from a deck of 52 playing cards. Find the probability that it is a club or a king.
-
To sell a farm that it had acquired in a foreclosure action, the RBC Royal Bank agreed to monthly payments of $2700 for 20 years, with the first payment due 15 months from the date of sale. If the...
-
The GPAs of all students enrolled at a large university have an approximately normal distribution with a mean of 3.02 and a standard deviation of .29. Find the probability that the mean GPA of a...
-
Latham and Chris produces crushed limestone used in highway construction, among other products. To produce the crushed limestone, the company starts with limestone rocks from its quarry in Alberta...
-
Lilly Painting Company is considering whether to purchase a new spray paint machine that costs $4,000. The machine is expected to save labor, increasing net income by $600 per year. The effective...
-
The table on the right shows closing costs for a purchase of a $268,000 house requiring a 20% down payment. ... Question content area top right Part 1 Title insurance premium $245 Document recording...
-
1. What is the etymology of the word Deontology and its relationship with the non-consequentialist approach? 2. When Kant refers to good will or good intention, does he mean wishing others well? 3....
-
Criterion Feedback 12/26/22 You have a well thought out overview of internet marketing - good. What are lacking are a few points for why internet marketing improves communication with consumers....
-
Nardin Outfitters has a capacity to produce 20,000 of their special arctic tents per year. The company is currently producing and selling 5,000 tents per year at a selling price of $1,700 per tent....
-
Sandy and Brian Scott contracted with Kitchen Renovations (Based in CA) for the complete upgrade of the kitchen of their beach house. Sandy wanted certain features in the kitchen, including a JennAir...
-
If logrolling is bad legislating such that the practice should be limited by single-subject rules. The question also asks whether a consequence of single-subject rules is to make it more difficult...
-
Write a summary in 300 words describing the three takeaways or key elements from one of the following research tutorial videos: MarketLine - Country Profile with PESTEL Analysis...
-
What is the coupon rate (semiannual compounding) on a $1,000 par value bond that has 20 years remaining to maturity? The yield to maturity is 7% APR and the bond sells for $1,220. (please show work)...
-
(a) What do data breach notification laws require? (b) Why has this caused companies to think more about security?
-
The International Accounting Standards Board and the Financial Accounting Standards Board have replaced IAS 11 Construction Contracts and IAS 18 Revenue with IFRS 15. Requirement: With reference to...
-
A supermarket awards 100 points to customers for each 100 worth of purchases in a single transaction. The customers may then exchange 1,000 points for goods with a retail value of 60; the cost to the...
-
How does one account for investment property in accordance with IAS 40?
Study smarter with the SolutionInn App