Question

This is a special order problem that also requires that you use the high low method to estimate some cost function parameters, so you may want to review the high-low method lectures in Module 1. As with almost all of the analyses that we have done, determining variable and fixed costs, and knowing what to do with them, is critical.
______________________________________________________

Huang Automotive is presently operating at 75% of capacity. The company recently received an offer from a Korean truck manufacturer to purchase 23,500 units of a power steering system component for $195 per unit.  Peter Wu, vice-president of sales, notes that although there will be an additional $2.50 shipping cost for each component, he thinks that accepting the order will get the company's "foot in the door" of an expanding international market.

Huang's production and cost information for the last two years for the component are as follows:

	202,000 units	232,000 units
Direct material costs	$16,867,000	$19,372,000
Direct labor costs	5,454,000	6,264,000
Overhead costs	23,701,000	25,216,000
Selling and administrative costs	9,022,000	9,352,000
Total costs	$55,044,000	$60,204,000
Total costs per unit	$272.50	$259.50

T.J. Chan, vice-president of engineering, feels that any new market should first show its profitability and that the $195 per unit offer is not only below the regular $250 selling price, but it's below the unit cost of the component. She also points out that there will be additional setup costs of $270,000 and that Huang will have to lease some special equipment for $240,000.

Required
1. Using the high-low method to determine cost behavior, what would the expected profit be on the special order (use a negative sign for a loss)?

Answer 1

Solution:

Per unit direct material cost = $1,68,67,000 / 202000 = $83.50 per unit

Per unit direct labor cost = $5,454,000 / 202000 = $27 per unit

Variable overhead cost per unit using high low method = (Cost at high level activity - Cost at low level activity) / (High level activity - Low level activity)

= ($25,216,000 - $23,701,000) / (232000 - 202000) = $50.50 per unit

Variable selling and administrative expense using high low method = ($9,352,000 - $9,022,000) / (232000 - 202000) = $11 per unit

Computation of expected profit from special order - Huang Automotive
Particulars	Amount
Revenue from special order (23500 * $195)	$4,582,500.00
Relevant Costs:
Direct material (23500*$83.50)	$1,962,250.00
Direct labor (23500 * $27)	$634,500.00
Variable overhead (23500*$50.50)	$1,186,750.00
Variable selling and administrative expenses (23500*$11)	$258,500.00
Additional shipping cost (23500*$2.50)	$58,750.00
Additional setup costs	$270,000.00
Lease cost of special equipment	$240,000.00
Profit from special order	-$28,250.00