In: Accounting
XYZ Corporation produces two products: Construction Equipment and Laboratory Equipment. The total units manufactured for Construction Equipment were 50,000 units, while 400,000 units of Laboratory Equipment were manufactured. The sales price per unit was $650 and $475, for Construction and Laboratory Equipment, respectively. The total direct materials cost per unit was $95 and $75 for Construction and Laboratory Equipment, respectively, while director labor cost per unit was $75 and $55 for Construction and Labor Equipment, respectively. Total overhead costs were $49,500,000. XYZ Corporation decided to use ABC to distribute overhead costs to its products, thus the total overhead cost can be classified in three activities: Setups with a cost of $500,000, Engineering with a total cost of $44,000,000 and Packaging with a total cost of $5,000.000. The activity bases and usage per product is as follows: # of setups for Setup activity, # of machine hours for Engineering activity and # of shipments for the Packaging activity. The Construction Equipment required 400 setups, 300,000 machine hours and 50,000 shipments. The Laboratory Equipment required 100 setups, 300,000 machine hours and 200,000 shipments.
What is the activity rate for the setup up activity? (round to two decimal places, do not include the comma or dollar sign).
What is the activity rate for the engineering activity? (round to two decimal places, do not include commas or dollar sign)
What is the activity rate for the packaging activity? (round to two decimal places, do not include commas or dollar sign)
What is the direct cost per unit for the Construction Equipment? (round to two decimal places, do not include commas or dollar sign)
What is the total direct cost per unit for the Laboratory Equipment? (round to two decimal places, do not include commas or dollar sign)
What is the total overhead cost per unit for the Construction Equipment if ABC is used? (round to two decimal places, do not include commas or dollar sign)
What is the total overhead cost per unit for the Laboratory Equipment if ABC is used? (round to two decimal places, do not include commas or dollar sign)
What is the total cost per unit for the Construction Equipment if ABC is used? (round to two decimal places, do not include commas or dollar sign
What is the total cost per unit for the Laboratory Equipment if ABC is used? (round to two decimal places, do not include commas or dollar sign)
What is the profit per unit for the Construction Equipment if ABC is used? (round to two decimal places, do not include commas or dollar sign)
What is the profit per unit for the Laboratory Equipment if ABC is used? (round to two decimal places, do not include commas or dollar sign)
Activity rate for setup activity= total setup cost / total number of setup
= 500,000 $ / 500 = 1,000 $ per setup
Activity rate of engineering activity = 44,000,000 $ / 600,000 hours = 77.33 per machne hour
Activity rate for packaging activity = 5,000,000 $ / 250,000 shipments = 20 per shipment
Direct cost per unit for construction equipment = direct material cost + direct labor cost = 95 $ + 75 $ = 170 $
Direct cost per unit for Laboratory equipment = direct material cost + direct labor cost = 75 $ + 55 $ = 130 $
Calcuation of total overhead cost per unit:-
Particulars | Construction | Laboratory |
Setup | 8.00 $ | 0.25 $ |
Engineering activity | 440.00 $ | 55.00 $ |
Packaging activity | 20.00 $ | 10.00 $ |
Total | 468.00 $ | 65.25 $ |
Calculation of total cost per unit:-
Particulars | Construction | Laboratory |
Direct material per unit | 95.00 $ | 75.00 $ |
Direct Labor per unit | 75.00 $ | 55.00 $ |
Setup | 8.00 $ | 0.25 $ |
Engineering activity | 440.00 $ | 55.00 $ |
Packaging activity | 20.00 $ | 10.00 $ |
Total | 638.00 $ | 195.25 $ |
Calculation of profit per unit:-
Particulars | Construction | Laboratory |
Sales price | 650.00 $ | 475.00 $ |
Less:- costs | ||
Direct material per unit | 95.00 $ | 75.00 $ |
Direct Labor per unit | 75.00 $ | 55.00 $ |
Setup | 8.00 $ | 0.25 $ |
Engineering activity | 440.00 $ | 55.00 $ |
Packaging activity | 20.00 $ | 10.00 $ |
Net profit per unit | 12.00 $ | 279.75 $ |