Sweet 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 Budgeted Activity Cost

Production $$472,500$

Setup $287,700$

Inspection $73,800$

Shipping $122,400$

Customer Service $40,500$

Total $$996,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:

Line Item Description Machine Hours Number of Setups Number of Inspections Number of Customer Orders Customer Service Requests Units

White sugar $3,300180180720308,250$

Brown sugar $2,1002702701,9801905,250$

Powdered sugar $2,100250450900805,250$

Total $7,5007009003,60030018,750$

Each product requires $0\mathrm{.}9$ machine hour per unit.

Required:

If required, round all per unit amounts to the nearest cent.

$1.$ Determine the activity rate for each activity.

Activity Amount

Production $fill in the blank $1$

$63$

per machine hour

Setup $fill in the blank $2$

$411$

per setup

Inspection $fill in the blank $3$

$82$

per inspection hour

Shipping $fill in the blank $4$

$34$

per cust. ord.

Customer service $fill in the blank $5$

$135$

per customer service request

$2.$ Determine the total and per$-$unit activity cost for all three products.

Line Item Description Total Activity Cost Activity Cost Per Unit

White sugar $fill in the blank $6$

$fill in the blank $7$

Brown sugar fill in the blank $8$

fill in the blank $9$

Powdered sugar fill in the blank $10$

fill in the blank $11$

$3.$ Why aren$$t the activity unit costs equal across all three products since they require the same machine time per unit?

The unit costs are different because the products consume many activities in ratios different from the fill in the blank $1$ of $1$

volume

$.$

Feedback Area

Feedback

$1.$ Calculate Activity Rate for each activity:

Total Cost $-$: Total Activity$-$Base $=$ Activity Rate

$2.$ Calculate Activity Cost for each product:

Activity$-$Base Usage $\backslash$times Activity rate from Req. $(1)=$ Activity cost; Sum all activity costs per product to determine a total and divide the total overhead by budgeted units to derive the activity costs per unit for each product.