Question
Broger Bites has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve
Broger Bites has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if Broger discontinues frozen foods. The operating results from the most recent period are:
Frozen Treats | Baked Goods | Fresh Fruits | Total | |
---|---|---|---|---|
Sales | $120,000 | $91,000 | $158,175 | $369, 175 |
Cost of goods sold | 105,000 | 67,000 | 110,000 | 282,000 |
SFS estimates that store support expenses, in total, are approximately 20% of revenues.
The controller says that not every sales dollar requires or uses the same amount of store support activities. A preliminary analysis reveals store support activities for these three product lines are:
Activity (cost driver) | Frozen Treats | Baked Goods | Fresh Fruits | Total cost driver units | Overhead costs |
---|---|---|---|---|---|
Order processing (number of purchase orders) | 20 | 60 | 120 | 200 orders | $12,400 |
Receiving (number of deliveries) | 15 | 75 | 160 | 250 deliveries | $20,500 |
Shelf-stocking hours | 30 | 170 | 300 | 500 stocking hours | $8,000 |
Customer support (total units sold) | 30,000 | 40,000 | 86,000 | 156,000 units sold | $15,600 |
Total overhead costs | $56,500 |
- Volume based: What is the overhead rate per unit if Broger uses units sold as the cost driver?
- Volume based: How much overhead is allocated to Frozen Treats using units sold as the allocation base?
- Volume based: What is the net profit or loss on the Frozen Treats?
- Activity based: Calculate the overhead rate for each of the four activities above. (Order processing, receiving, shelf stocking, and customer support)
- Activity based: How much overhead is allocated to Frozen Treats using the activity rates you calculated in part 4.
- Activity based: What is the net profit or loss on the Frozen Treats?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started