Question 3
Part A
Single Plantwide Overhead Rate = Total Estimated Indirect Costs / Total Estimated Direct Labour Hours
Total Estimated Indirect Costs = $ 900,000
Total Estimated Direct Labour Hours = 50,000
Single Plantwide Overhead Rate = 900,000 / 50,000
Single Plantwide Overhead Rate = $ 18 per Hour
Part B
For Product T
Indirect Costs = 25,000 Labour Hours * $ 18 per Hour = $ 450,000
Indirect Factory Overhead Cost per Unit = 450,000 / 1,000 Units = $ 450
For Product U
Indirect Costs = 25,000 Labour Hours * $ 18 per Hour = $ 450,000
Indirect Factory Overhead Cost per Unit = 450,000 / 1,000 Units = $ 450
Part C
A | B | C = A/B | ||
Particular | Estimated Activity Costs | Activity Level | Activity Allocation Rate | |
Plant Supervision | 600,000 | 50,000 | 12 | Per Direct Labour Hour |
Setup Labour | 300,000 | 400 | 750 | Per Setup |
Total | 900,000 |
Part D
Factory Overhead Cost for Activity Based Costing
Product T
Plant Supervision Costs = 25,000 Labour Hours * $ 12 per Hour = $ 300,000
Set-up Labour = 100 Setups * $ 750 Per Setup = 75,000
Total Factory Overhead Cost = 300,000 + 75,000
Total Factory Overhead Cost = $ 375,000
Factory Overhead Cost per Unit = 375,000 / 1,000 Units
Factory Overhead Cost per Unit = $ 375
Product U
Plant Supervision Costs = 25,000 Labour Hours * $ 12 per Hour = $ 300,000
Set-up Labour = 300 Setups * $ 750 Per Setup = $ 225,000
Total Factory Overhead Cost = 300,000 + 225,000
Total Factory Overhead Cost = $ 525,000
Factory Overhead Cost per Unit = 525,000 / 1,000 Units
Factory Overhead Cost per Unit = $ 525
Part E
The Factory Overhead Cost per Unit in both the methods is different becuase of the fact that the single Plantwide Overhead Rate allocates costs on the basis of single cost driver whereas Activity Based Costing allocates Indirect Costs by taking into account all the activities associated with the product and the level of resource consumed by each product so they results in giving more realistic and accurate information about cost Allocation.
Question 4
A | B | C = A/B | ||
Particulars | Estimated Activity Costs | Activity Level | Activity Allocation Rate | |
Cutting | 40,000 | 100,000 | 0.40 | Per DLH |
Sewing | 210,000 | 140,000 | 1.50 | Per DLH |
Setup | 80,000 | 800 | 100 | Per Setup |
QC Inspection | 20,000 | 1,000 | 20 | Per Inspection |
Purchase Order | 10,000 | 400 | 25 | Per Po |
Total | 360,000 |
For Handbags
Particulars | Activity Level | Activity Allocation Rate | Total Overhead Costs |
Cutting | 60,000 | 0.40 | 24,000 |
Sewing | 60,000 | 1.50 | 90,000 |
Setup | 500 | 100 | 50,000 |
QC Inspection | 200 | 20 | 4,000 |
Purchase Order | 100 | 25 | 2,500 |
Total Overhead Cost | 170,500 | ||
÷ Number of Units | 60,000 | ||
Factory Overhead Cost per Unit |
2.84 |
For Moccasins
Particulars | Activity Level | Activity Allocation Rate | Total Overhead Costs |
Cutting | 40,000 | 0.40 | 16,000 |
Sewing | 80,000 | 1.50 | 120,000 |
Setup | 300 | 100 | 30,000 |
QC Inspection | 800 | 20 |
16,000 |
Purchase Orders | 300 | 25 | 7,500 |
Total Overhead | 189,500 | ||
÷ Number of Units | 40,000 | ||
Factory Overhead Cost per Unit |
4.74 |
Notes
Total Overhead Cost = Activity Allocation Rate * Activity Level
3. Daisy Company produces two products, T and U. The indirect labor costs include the following...
Ornate Co. manufacturers two products and uses activity based costing to allocate indirect costs. Activity Set up Material orders and receiving Total indirect costs Overhead Alloc. Base 60,000 #set ups $ 48,000# purch orders $ 108,000 Direct labor hours Number of setups Number of purchase orders units produced Lo-Shine 1,000 400 1,800 Hi-Shine 7,000 235 780 75 174 If Ornate Co. uses activity based costing, what is the indirect cost per unit (overhead per unit) for Hi-Shine?
Four Finger Appliance Company manufactures small kitchen appliances. The product line consists of blenders and toaster ovens. Four Finger Appliance presently uses the multiple production department factory overhead rate method. The factory overhead is as follows: 1 Assembly Department $303,860.00 2 Test and Pack Department 222,580.00 3 Total $526,440.00 The direct labor information for the production of 7,945 units of each product is as follows: Department Assembly Test and Pack Blender 840 dlh 2,525 dlh Toaster oven 2,470 745 Total...
Paris, Inc, Produces two products, Product A and Product B. If currently allocates overhead costs using direct-labor hours, but the controller has recommended an activity-based costing (ABC) system using the following data: Activity Level Activity Cost-Driver Base Cost Product A Product B Production setup Number of setups 90,000 11 19 Materials handing & requisition Number of parts per unit 15,000 6 18 Packaging & shipping Number of units shipped 45,000 60,000 120,000 Total overhead 150,000 A, Compute the amount of...
Activity-Based Costing: Factory Overhead Costs The total factory overhead for Bardot Marine Company is budgeted for the year at $762,000, divided into four activities: fabrication, $312,000; assembly, $120,000; setup, $180,000; and inspection, $150,000. Bardot Marine manufactures two types of boats: speedboats and bass boats. The activity-base usage quantities for each product by each activity are as follows: Fabrication Assembly Setup Inspection Speedboat 6,000 dlh 18,000 dlh 43 setups 75 inspections Bass boat 18,000 6,000 317 525 24,000 dlh 24,000 dlh...
Activity-Based Costing: Factory Overhead Costs The total factory overhead for Bardot Marine Company is budgeted for the year at $1,496,400, divided into four activities: fabrication, $814,000; assembly, $342,000; setup, $183,150; and inspection, $157,250. Bardot Marine manufactures two types of boats: speedboats and bass boats. The activity-base usage quantities for each product by each activity are as follows: Fabrication Assembly Setup Inspection Speedboat 9,250 dlh 28,500 dlh 67 setups 116 inspections Bass boat 27,750 9,500 488 809 37,000 dlh 38,000 dlh...
Activity-Based Costing: Factory Overhead Costs The total factory overhead for Bardot Marine Company is budgeted for the year at $1,211,600, divided into four activities: fabrication, $660,000; assembly, $248,000; setup, $163,350; and inspection, $140,250. Bardot Marine manufactures two types of boats: speedboats and bass boats. The activity-base usage quantities for each product by each activity are as follows: Fabrication Assembly Setup Inspection Speedboat 8,250 dlh 23,250 dlh 59 setups 103 inspections Bass boat 24,750 7,750 436 722 33,000 dlh 31,000 dlh...
Activity-Based Costing: Factory Overhead Costs The total factory overhead for Bardot Marine Company is budgeted for the year at $1,345,650, divided into four activities: fabrication, $627,000; assembly, $288,000; setup, $232,650; and inspection, $198,000. Bardot Marine manufactures two types of boats: speedboats and bass boats. The activity-base usage quantities for each product by each activity are as follows: Fabrication Assembly Setup Inspection Speedboat 8,250 dlh 27,000 dlh 59 setups 103 inspections Bass boat 24,750 9,000 436 722 33,000 dlh 36,000 dlh...
Activity-Based Costing: Factory Overhead Costs The total factory overhead for Bardot Marine Company is budgeted for the year at $909,050, divided into four activities: fabrication, $396,000; assembly, $155,000; setup, $193,050; and inspection, $165,000. Bardot Marine manufactures two types of boats: speedboats and bass boats. The activity-base usage quantities for each product by each activity are as follows: Fabrication Assembly Setup Inspection Speedboat 8,250 dlh 23,250 dlh 59 setups ...
Activity-Based Costing: Factory Overhead Costs The total factory overhead for Bardot Marine Company is budgeted for the year at $1,157,000, divided into four activities: fabrication, $600,000; assembly, $248,000; setup, $166,500; and inspection, $142,500. Bardot Marine manufactures two types of boats: speedboats and bass boats. The activity-base usage quantities for each product by each activity are as follows: Fabrication Assembly Setup Inspection Speedboat 7,500 dlh 23,250 dlh 54 setups 94 inspections Bass boat 22,500 7,750 396 656 30,000 dlh 31,000 dlh...
Consider the following data for two products of Gitano Manufacturing. (Loss amounts should be indicated with a minus sign. Round your intermediate calculations and "OH rate and cost per unit" answers to 2 decimal places.) Number of units produced Direct labor cost (@ $29 per DLH) Direct materials cost Product A 13,000 units 0.18 DLH per unit $ 1.60 per unit Product B 1,100 units 0.28 DLH per unit $ 2.30 per unit Activity Machine setup Materials handling Quality control...