Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Dairy Division of BMC, located in the city of Colac, operates at capacity, and considers applying ABC analysis to three product lines within its

The Dairy Division of BMC, located in the city of Colac, operates at capacity, and considers applying ABC analysis to three product lines within its division: full cream milk, skim milk, and almond milk. The manager of this division identifies four activities, and their activity cost allocation rates as follows

Ordering $100 per purchase order
Machine set up $75 per set up
Freezing $5 per hour
Packaging $0.15 per item sold

The revenues, cost of goods sold, and activity usage of the three product lines are as follows:

Table 2 - Dairy Division, year 2021

Year 2021 Full Cream Skim Almond
Financial data
Revenues $250,000 $150,000 $75,000
Direct manufacturing cost $40,000 $25,000 $15,000
Manufacturing overhead allocated ? ? ?
Activity-area usage (cost-allocation base)
Ordering (purchase orders) 200 100 60
Machine set up (setups) 90 35 30
Freezing (hours) 190 180 40
Packaging (items sold) 100,000 60,000 8,000

Using a division-wide allocation rate, the Dairy Division of BMC allocated manufacturing overhead to the three products at the rate of 30% of direct manufacturing cost.

Required

a) Using the division-wide allocation rate, calculate and identify which product line has the highest gross margin in dollars and in percentage (i.e., gross profit/revenue).

b) Using ABC, calculate and determine the profitability (i.e., gross profit/revenue) of the three product lines (i.e., specify the highest, the middle, and the lowest profitable product line).

c) The division expects that, in the year 2022, there will be no freezing activity because the division wants to sell the products as fresh as possible. The division wants to manufacture the products at a smaller batch each time so there is an increase of set up activities for every product line as below

Activity Full Cream Skim Almond
Ordering 200 100 60
Machine set up 140 110 120
Freezing 0 0 0
Packaging 100,000 60,000 8,000

If everything else is equal (activity cost allocation rate, direct manufacturing cost, and sales revenue for all three products remain the same), provide the annual change of gross margin under ABC for each product (i.e., total gross margin under ABC in 2022 minus total gross margin under ABC in 2021).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Financial Accounting An IFRS Standards Approach

Authors: Pearl Tan, Chu Yeong Lim, Ee Wen Kuah

4th Edition

9789814821278, 9814821276

More Books

Students also viewed these Accounting questions

Question

A greater tendency to create winwin situations.

Answered: 1 week ago

Question

Improving creative problem-solving ability.

Answered: 1 week ago