Pure Cane Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar) in a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows:
The activity bases identified for each activity are as follows:
The activity-base usage quantities and units produced for the three products were determined from corporate records and are as follows:
Each product requires 0.25 machine hour per unit.
Required:
1. Determine the activity rate for each activity.
Activity Rate | |
Production | $ /mh |
Setup | $ /setup |
Inspection | $ /insp. |
Shipping | $ /cust. ord. |
Customer Service | $ /req. |
2. Determine the total and per-unit activity costs for all three products. Round “Activity cost per unit” answers to two decimal places.
White Sugar | Brown Sugar | Powdered Sugar | |
Total activity cost | $ | $ | $ |
Activity cost per uni |
Production | Setup | Inspection | Shipping | Customer Service |
|
Total activity cost | 247500 | 48000 | 12500 | 69300 | 27600 |
Devided by Total activity base | 4500 | 200 | 500 | 2310 | 345 |
Activity rate… | 55 | 240 | 25 | 30 | 80 |
White Sugar | |||
Acitivity | Activity Base usage |
x Activity rate |
,=activity cost |
Production | 2000 | 55 | 110000 |
Setup | 50 | 240 | 12000 |
Inspection | 100 | 25 | 2500 |
Shipping | 410 | 30 | 12300 |
Customer Service |
25 | 80 | 2000 |
Total Activity cost | 138800 | ||
Devided byUnits | 8000 | ||
Cost Per unit | 17.35 |
Brown Sugar | |||
Acitivity | Activity Base usage |
x Activity rate |
,=activity cost |
Production | 1250 | 55 | 68750 |
Setup | 70 | 240 | 16800 |
Inspection | 160 | 25 | 4000 |
Shipping | 1100 | 30 | 33000 |
Customer Service |
200 | 80 | 16000 |
Total Activity cost | 138550 | ||
Devided byUnits | 5000 | ||
Cost Per unit | 27.71 |
Powder Sugar | |||
Acitivity | Activity Base usage |
x Activity rate |
,=activity cost |
Production | 1250 | 55 | 68750 |
Setup | 80 | 240 | 19200 |
Inspection | 240 | 25 | 6000 |
Shipping | 800 | 30 | 24000 |
Customer Service |
120 | 80 | 9600 |
Total Activity cost | 127550 | ||
Devided byUnits | 5000 | ||
Cost Per unit | 25.51 |