Question

Pat Miranda, the new controller of Vault Hard Drives, Inc., has just returned from a seminar on the choice of the activity level in the predetermined overhead rate. Even though the subject did not sound exciting at first, she found that there were some important ideas presented that should get a hearing at her company. After returning from the seminar, she arranged a meeting with the production manager, J. Stevens, and the assistant production manager, Marvin Washington.

Pat:	I ran across an idea that I wanted to check out with both of you. It’s about the way we compute predetermined overhead rates.
J.:	We’re all ears.
Pat:	We compute the predetermined overhead rate by dividing the estimated total factory overhead for the coming year, which is all a fixed cost, by the estimated total units produced for the coming year.
Marvin:	We’ve been doing that as long as I’ve been with the company.
J.:	And it has been done that way at every other company I’ve worked at, except at most places they divide by direct labor-hours.
Pat:	We use units because it is simpler and we basically make one product with minor variations. But, there’s another way to do it. Instead of basing the overhead rate on the estimated total units produced for the coming year, we could base it on the total units produced at capacity.
Marvin:	Oh, the Marketing Department will love that. It will drop the costs on all of our products. They’ll go wild over there cutting prices.
Pat:	That is a worry, but I wanted to talk to both of you first before going over to Marketing.
J.:	Aren’t you always going to have a lot of unused capacity costs?
Pat:	That’s correct, but let me show you how we would handle it. Here’s an example based on our budget for next year.

Budgeted (estimated) production		83,000	units
Budgeted sales		83,000	units
Capacity		100,000	units
Selling price		$73	per unit
Variable manufacturing cost		$18	per unit
Total manufacturing overhead cost (all fixed)	$	2,158,000
Selling and administrative expenses (all fixed)	$	2,208,000
Beginning inventories		$0

Traditional Approach to Computation of the Predetermined Overhead Rate

Estimated total manufacturing overhead cost, $2,158,000	= $26.00 per unit
Estimated total units produced, 83,000

Budgeted Income Statement
Revenue (83,000 units × $73 per unit)			$	6,059,000
Cost of goods sold:
Variable manufacturing (83,000 units × $18 per unit)	$	1,494,000
Manufacturing overhead applied (83,000 units × $26 per unit)		2,158,000		3,652,000
Gross margin				2,407,000
Selling and administrative expenses				2,208,000
Net operating income			$	199,000

New Approach to Computation of the Predetermined Overhead Rate Using Capacity in the Denominator

Estimated total manufacturing overhead cost at capacity, $2,158,000	= $21.58 per unit
Total units at capacity, 100,000 units

Budgeted Income Statement
Revenue (83,000 units × $73 per unit)			$	6,059,000
Cost of goods sold:
Variable manufacturing (83,000 units × $18 per unit)	$	1,494,000
Manufacturing overhead applied (83,000 units × $21.58 per unit)		1,791,140		3,285,140
Gross margin				2,773,860
Cost of unused capacity [(100,000 units – 83,000 units) × $21.58 per unit]				366,860
Selling and administrative expenses				2,208,000
Net operating income			$	199,000

J.:	Whoa!! I don’t think I like the looks of that “Cost of unused capacity.” If that thing shows up on the income statement, someone from headquarters is likely to come down here looking for some people to lay off.
Marvin:	I’m worried about something else too. What happens when sales are not up to expectations? Can we pull the “hat trick”?
Pat:	I’m sorry, I don’t understand.
J.:	Marvin’s talking about something that happens fairly regularly. When sales are down and profits look like they are going to be lower than the president told the owners they were going to be, the president comes down here and asks us to deliver some more profits.
Marvin:	And we pull them out of our hat.
J.:	Yeah, we just increase production until we get the profits we want.
Pat:	I still don’t understand. You mean you increase sales?
J.:	Nope, we increase production. We’re the production managers, not the sales managers.
Pat:	I get it. Because you have produced more, the sales force has more units it can sell.
J.:	Nope, the marketing people don’t do a thing. We just build inventories and that does the trick.

Required:

In all of the questions below, assume that the predetermined overhead rate under the traditional method is $26 per unit, and under the new capacity-based method it is $21.58 per unit

1. Assume that actual sales is 79,000 units and the actual selling price, actual variable manufacturing cost per unit, and actual fixed costs all equal their respective budgeted amounts. Under the traditional approach, how many units would have to be produced to realize net operating income of $199,000?

2.Under the new capacity-based approach, how many units would have to be produced to realize net operating income of $199,000?

Answer 1

1.

Budgeted income statement
Revenue	= 79000 *73	5767000
COGS
Variable manufacturing	=79000*18	1422000
Manufacturing overhead	=79000*26	2054000
Gross Margin		2291000
Selling and admin		2208000
Net Profit		83000

Desired Profit is $199000

To Calulate how many units are to be sold to get desired profit formula is=

units = desired profit + Fixed expenses / contribution per unit

contribution per unit is = sales - variable cost

$ 79 - $18- $26 = $29

units = $ 199000 + $ 2208000 / $ 29

Units = 83,000

As we are producing 79000 units at present more 4000 units to be produced to get a profit of $ 199,000

1b)

Budgeted income statement
Revenue	= 79000 *73	5767000
COGS
Variable manufacturing	=79000*18	1422000
Manufacturing overhead	=79000*21.58	1704820
Gross Margin		2640180
Selling and admin		2208000
Net Profit		432180

Desired Profit is $199000

To Calulate how many units are to be sold to get desired profit formula is=

units = desired profit + Fixed expenses / contribution per unit

contribution per unit is = sales - variable cost

$ 79 - $18- $21.58 = $33.42

units = $ 199000 + $ 2208000 / $ 33.42

Units = 72023

As we are producing 79000 units at present the desired profit of 199000 is achieved if we produce 72023 units only