Question

In: Accounting

Activity-Based Product Costing Sweet Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar)...

Activity-Based Product Costing

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:

ActivityBudgeted Activity Cost

Production $448,900

Setup 130,200

Inspection 94,600

Shipping 136,400

Customer service 79,800

Total $889,900

The activity bases identified for each activity are as follows:

ActivityActivity Base

ProductionMachine hours

SetupNumber of setups

InspectionNumber of inspections

ShippingNumber of customer orders

Customer serviceNumber 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 Customer
Service
Requests Units

White sugar 2,950 80 220 880 70 7,375

Brown sugar 1,880 110 330 2,420 440 4,700

Powdered sugar 1,870 110 550 1,100 190 4,675

Total 6,700 300 1,100 4,400 700 16,750

Each product requires 0.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.

Production$ per machine hour

Setup$ per setup

Inspection$ per move

Shipping$ per cust. ord.

Customer service$ per customer service request

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

Total Activity CostActivity Cost Per Unit

White sugar$$

Brown sugar

Powdered sugar

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 volume .

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 x 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.

Solutions

Expert Solution

1 .Activity based costing uses different cost drivers for allocating cost to its products

Cost [A] Cost driver [B] Activity rate [A/B]
Production $448,900 6,700 Machine hours $67 per machine hour
Set up $130,200 300 setups $434 per setup
Inspection $94,600 1,100 inspections $86 per inspection
Shipping $136,400 4,400 customer orders $31 per customer order
Customer services $79,800 700 requests $114 per customer request
889,900

2.cost allocated = Activity rate* cost driver utilised by product

Activity rate [A/B] white Brown Powdered
Production $67 per machine hour $197,650[$67*2950] $125,960[$67*1880] $125,290[$67*1870]
Set up $434 per setup $34,720[$434*80] $47,740[$434*110] $47,740[$434*110]
Inspection $86 per inspection $18,920[$86*220] $28,380[330*$86] $47,300[550*$86]
Shipping $31 per customer order $27,280[$31*880] $75,020[2,420*$31] $34,100[1,100*$31]
Customer services $114 per customer request $7,980[$114*70] $50,160[$114*440] $21,660[190*$114]
Total $286,550 $327,260 $276,090
Number of units 7,375 4,700 4,675
cost per unit $38.85[$286,550/7,375] $69.63[$327,260/4,700]] $59.06[$276,090/4,675]

unit costs are different because product consume many activities in ratios different from the volume.

Please upvote if you find this helpful.Incase of query pelase comment.


Related Solutions

Activity-Based Product Costing Sweet Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar)...
Activity-Based Product Costing 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: ActivityBudgeted Activity Cost Production $448,900 Setup 130,200 Inspection 94,600 Shipping 136,400 Customer service 79,800 Total $889,900 The activity bases identified for each activity are as follows: ActivityActivity Base ProductionMachine...
Activity-Based Product Costing Sweet Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar)...
Activity-Based Product Costing 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 $465,000 Setup 189,500 Inspection 105,300 Shipping 159,600 Customer service 58,500 Total $977,900 The activity bases identified for each activity are as follows: Activity Activity...
Activity-Based Product Costing Sweet Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar)...
Activity-Based Product Costing 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 $444,600 Setup 190,000 Inspection 91,200 Shipping 151,200 Customer service 52,800 Total $929,800 The activity bases identified for each activity are as follows: Activity Activity...
Activity-Based Product Costing Sweet Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar)...
Activity-Based Product Costing 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 $444,600 Setup 190,000 Inspection 91,200 Shipping 151,200 Customer service 52,800 Total $929,800 The activity bases identified for each activity are as follows: Activity Activity...
Activity-Based Product Costing Sweet Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar)...
Activity-Based Product Costing 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 $427,000 Setup 187,000 Inspection 120,000 Shipping 131,200 Customer service 80,400 Total $945,600 The activity bases identified for each activity are as follows: Activity Activity...
Activity-Based Product Costing Sweet Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar)...
Activity-Based Product Costing 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 $427,000 Setup 187,000 Inspection 120,000 Shipping 131,200 Customer service 80,400 Total $945,600 The activity bases identified for each activity are as follows: Activity Activity...
Activity-Based Costing Pure Cane Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar)...
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...
Sweet Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar) in a continuous...
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: 1 Activity Budgeted Activity Cost 2 Production $500,000.00 3 Setup 144,000.00 4 Inspection 44,000.00 5 Shipping 115,000.00 6 Customer service 84,000.00 7 Total $887,000.00 The activity bases identified for each activity are...
Sweet Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar) in a continuous...
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 $466,200 Setup 219,500 Inspection 106,600 Shipping 133,200 Customer service 48,000 Total $973,500 The activity bases identified for each activity are as follows: Activity Activity Base Production Machine...
Sweet Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar) in a continuous...
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 $489,100 Setup 259,000 Inspection 110,400 Shipping 180,600 Customer service 93,100 Total $1,132,200 The activity bases identified for each activity are as follows: Activity Activity Base Production Machine...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT