Question

Please help for question 2 & 3 I was able to answer question #1.

Ultratech, Inc., manufactures several different types of printed circuit boards; however, two of the boards account for the majority of the company’s sales. The first of these boards, a television circuit board, has been a standard in the industry for several years. The market for this type of board is competitive and price-sensitive. Ultratech plans to sell 79,000 of the TV boards in 20x4 at a price of $450 per unit. The second high-volume product, a personal computer circuit board, is a recent addition to Ultratech’s product line. Because the PC board incorporates the latest technology, it can be sold at a premium price. The 20x4 plans include the sale of 54,000 PC boards at $785 per unit.

Ultratech’s management group is meeting to discuss how to spend the sales and promotion dollars for 20x4. The sales manager believes that the market share for the TV board could be expanded by concentrating Ultratech’s promotional efforts in this area. In response to this suggestion, the production manager said, “Why don’t you go after a bigger market for the PC board? The cost sheets that I get show that the contribution from the PC board is more than double the contribution from the TV board. I know we get a premium price for the PC board. Selling it should help overall profitability.”

The cost-accounting system shows that the following costs apply to the PC and TV boards.

  

	PC Board			TV Board
Direct material	$	243		$	153
Direct labor		3.5	hr.		1.5	hr.
Machine time		1.5	hr.		1.5	hr.

  

Variable manufacturing overhead is applied on the basis of direct-labor hours. For 20x4, variable overhead is budgeted at $26,469,450, and direct-labor hours are estimated at 322,875. The hourly rates for machine time and direct labor are $26 and $34, respectively. The company applies a material-handling charge at 10 percent of material cost. This material-handling charge is not included in variable manufacturing overhead. Total 20x4 expenditures for direct material are budgeted at $25,209,000.

Andrew Fulton, Ultratech’s controller, believes that before the management group proceeds with the discussion about allocating sales and promotional dollars to individual products, it might be worthwhile to look at these products on the basis of the activities involved in their production. Fulton has prepared the following schedule to help the management group understand this concept.

“Using this information,” Fulton explained, “we can calculate an activity-based cost for each TV board and each PC board and then compare it to the standard cost we have been using. The only cost that remains the same for both cost methods is the cost of direct material. The cost drivers will replace the direct labor, machine time, and overhead costs in the old standard cost figures.”

  

Budgeted Cost				Cost Driver	Budgeted Annual Activity for Cost Driver
Procurement	$	940,000		Number of parts		8,024,100 parts
Production scheduling		510,000		Number of boards		139,650 boards
Packaging and shipping		1,020,000		Number of boards		139,650 boards
Total	$	2,470,000
Machine setup	$	948,000		Number of setups		615,300 setups
Hazardous waste disposal		124,000		Pounds of waste		50,337 pounds
Quality control		1,204,000		Number of inspections		475,650 inspections
General supplies		174,000		Number of boards		139,650 boards
Total	$	2,450,000
Machine insertion	$	3,100,000		Number of parts		5,658,000 parts
Manual insertion		9,400,000		Number of parts		2,256,000 parts
Wave-soldering		334,000		Number of boards		139,650 boards
Total	$	12,834,000

  

Required per unit	PC Board			TV Board
Parts:		83			40
Machine insertions		50			39
Manual insertions		33			1
Machine setups		5			4
Hazardous waste disposal		.80	lb.		.06	lb.
Inspections		4			3

  

Required:

1.	Identify at least four general advantages associated with activity-based costing. (Select all that apply.)

     

2.	On the basis of Ultratech’s unit cost data given in the problem, calculate the total amount that each of the two product lines will contribute toward covering fixed costs and profit in 20x4. (Round your intermediate calculations to 2 decimal places.) PC Board TV Board Total Contribution Margin

       

3.	Using activity-based costing, calculate the total amount that each of the two product lines will contribute toward covering fixed costs and profit in 20x4. (Round your intermediate calculations to 2 decimal places.) PC Board TV Board Total Contribution Margin

      

Answer 1

Ultratech, Inc., Reg 1: Using Ultratech's unit cost data, the total contribution margin expected from the PC board is = $39,29,488 Using Ultratech's unit cost data, the total contribution margin expected from the TV board is = $54,29,612 It is calculated as follows: It is calculated as follows: Revenue Direct Material Material handling charge Direct Labor Variable overhead Machine time Total Cost Unit Contribution Margin Total Contribution Margin *Variable Overhead Rate: Per Unit $785 $243 $24 $119 $287 $39 $712 $73 Total for 54.000 units $4,23,90,000 $1,31,22,000 $13,12,200 $64,26,000 $1,54,94,312 $21,06,000 $3,84,60,512 Revenue Direct Material Material handling charge Direct Labor Variable overhead* | Machine time Total Cost Unit Contribution Margin Total Contribution Margin *Variable Overhead Rate: Per Unit $450 $153 $15 $51 $123 $39 $381 $69 Total for 79,000 units $3,55,50,000 $1,20,87,000 $12,08,700 $40,29,000 $97.14.688 $30,81,000 $3.01.20,388 $39,29,488 $54,29,612 I $82 $82 Req 2: $0.12 | Pool Rates: Procurement Production Scheduling Packaging and Shipping Machine Setup Hazardous waste disposal Quality Control General Supplies Machine insertion Manual insertion Wave soldering $3.65 $7.30 $1.54 $2.46 $2.53 $1.25 $0.55 $4.17 $2.39 per part per board per board per setup per lb per inspection per board per part per part per board Using Activity-based costing, the total contribution margin expected from PC board is = $1,79,81,404 Using Activity-based costing, the total contribution margin expected from TV board is = $1,88,24,229 It is calculated as follows: It is calculated as follows: Revenue Direct Material Procurement Production Scheduling Packaging and Shipping Machine setup Hazardous waste disposal Quality Control General Supplies Machine insertion Manual Insertion Wave Soldering Total Cost Unit contribution Margin Total contribution Margin Per Unit $785 $243 $10 $3.65 $7.30 $7.70 $1.97 $10 $1.25 $27.39 $138 $2.39 $452.01 $332.99 Total for 54.000 units $4,23,90,000 $1,31,22,000 $5.25.053 $1.97,207 $3,94,415 $4,15,992 $1,06,419 $5,46,755 $67,282 $14.79.321 $74,25,000 $1.29.151 $2.44.08.596 Revenue Direct Material Procurement Production Scheduling Packaging and Shipping Machine setup Hazardous waste disposal Quality Control General Supplies Machine insertion Manual Insertion Wave Soldering Total Cost Unit contribution Margin Total contribution Margin Per Unit $450 $153 $4.69 $3.65 $7.30 $6.16 $0.15 $7.59 $1.25 $21.37 $4.17 $2.39 $211.72 $238.28 Total for 79,000 units $3,55,50.000 $1,20,87,000 $3.70.185 $2,88,507 $5,77,014 $4.86.865 $11.677 $5,99,912 $98.432 $16.88.070 $3,29,167 $1,88,944 $1,67,25,771 $1.79.81.404 $1.88.24.229