In: Accounting
Activity-Based Costing
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:
| Activity | Activity Costs | ||
| Production | $247,500 | ||
| Setup | 48,000 | ||
| Inspection | 12,500 | ||
| Shipping | 69,300 | ||
| Customer service | 27,600 | ||
| Total | $404,900 | ||
The activity bases identified for each activity are as follows:
| Activity | Activity Base | |
| Production | Machine hours | |
| Setup | Number of setups | |
| Inspection | Number of inspections | |
| Shipping | Number of customer orders | |
| Customer service | Number of customer service requests | |
The activity-base usage quantities and units produced for the three products were determined from corporate records and are as follows:
| 
    Machine Hours  | 
    Number of Setups  | 
    Number of Inspections  | 
    Number
of     Customer Orders  | 
    Number
of     Customer Service Requests  | 
Units | |||||||
| White sugar | 2,000 | 50 | 100 | 410 | 25 | 8,000 | ||||||
| Brown sugar | 1,250 | 70 | 160 | 1,100 | 200 | 5,000 | ||||||
| Powdered sugar | 1,250 | 80 | 240 | 800 | 120 | 5,000 | ||||||
| Total | 4,500 | 200 | 500 | 2,310 | 345 | 18,000 | ||||||
Each product requires 0.25 machine hour per unit.
Required:
1. Determine the activity rate for each activity.
| Activity Rate | |
| Production | |
| Setup | |
| Inspection | |
| Shipping | |
| Customer Service | 
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 unit |