In: Accounting
Kansas Supplies is a manufacturer of plastic parts that uses the weighted-average process costing method to account for costs of production. It produces parts in three separate departments: Molding, Assembling, and Packaging. The following information was obtained for the Assembling Department for the month of April.
Work in process on April 1 had 110,000 units made up of the following:
Amount | Degree of Completion | |||||
Prior department costs transferred in from the Molding Department | $ | 152,900 | 100 | % | ||
Costs added by the Assembling Department | ||||||
Direct materials | $ | 89,100 | 100 | % | ||
Direct labor | 37,540 | 60 | % | |||
Manufacturing overhead | 25,070 | 50 | % | |||
$ | 151,710 | |||||
Work in process, April 1 | $ | 304,610 | ||||
During April, 510,000 units were transferred in from the Molding Department at a cost of $708,900. The Assembling Department added the following costs:
Direct materials | $ | 379,080 | |
Direct labor | 196,400 | ||
Manufacturing overhead | 119,980 | ||
Total costs added | $ | 695,460 | |
Assembling finished 410,000 units and transferred them to the Packaging Department.
At April 30, 210,000 units were still in work-in-process inventory. The degree of completion of work-in-process inventory at April 30 was as follows:
Direct materials | 80 | % |
Direct labor | 70 | |
Manufacturing overhead | 35 | |
Required:
a. Prepare a production cost report using the weighted-average method. (Round "Cost per equivalent unit" to 2 decimal places
KANSAS
SUPPLIES
Assembling Department
Production Cost Report- Weighted Average
Flow of Production Units |
|
Physical Units | |
Units to be accounted for: | |
Beginning WIP inventory | 110,000 |
Units started this period | 510,000 |
Total Units to be accounted for | 620,000 |
Compute Equivalent Units
Prior Department Costs | Materials | Labor | Manufacturing Overhead | ||
Units accounted for | |||||
Units Completed and transferred out | |||||
From beginning inventory | ?? | ||||
Started and completed currently | ?? | ||||
Total transferred out | ?? | ?? | ?? | ?? | ?? |
Units in ending WIP inventory | ?? | ?? | ?? | ?? | ?? |
Total Units accounted for | ?? | ?? | ?? | ?? | ?? |
DETAILS
Total Costs | Prior Department Costs | Materials | Labor | Manufacturing | |
Costs to be accounted for | |||||
Costs in beginning WIP inventory | ?? | ?? | ?? | ?? | ?? |
Current period costs | ?? | ?? | ?? | ?? | ?? |
Total costs to be accounted for | $ | $ |
$ |
$ | $ |
Cost per equivalent unit | |||||
Prior department costs | ?? | ||||
Materials | ?? | ||||
Labor | ?? | ||||
Manufacturing overhead | ?? | ||||
Costs accounted for | |||||
Costs assigned to units transferred out | |||||
Prior department costs | ?? | ?? | |||
Materials | ?? | ?? | |||
Labor | ?? | ?? | |||
Manufacturing Overhead | ?? | ?? | |||
Total costs of units transferred out | $ | ||||
Costs assigned to ending WIP inventory | |||||
Prior department costs | ?? | ?? | |||
Materials | ?? | ?? | |||
Labor | ?? | ?? | |||
Manufacturing overhead | ?? | ?? | |||
Total ending WIP inventory | $$ | ||||
Total costs accounted for | $ | $ | $ | $ | $ |
(A) - Statement of Equivalent Units
Particulars | Prior Department cost | Material | Labour | Manufacturing overhead | |
Units Accounted for | |||||
Units Completed and Transferred out | |||||
From Beginning Inventory | 110000 | ||||
Started and Completed Currently | 300000 | ||||
Total Transferred out | 410000 | 410000 | 410000 | 410000 | 410000 |
Units in ending WIP inventory | 210000 | 0 |
168000 (210000*80%) |
147000 (210000*70%) |
73500 (210000*35%) |
Total Units Accounted for | 620000 | 410000 | 578000 | 557000 | 483500 |
(B) - Details
Particulars | Total costs | Prior Department cost | Material | Labour | Manufacturing Overhead |
Costs to be accounted for - | |||||
Costs in beginning WIP Inventory | $304610 | $152900 | $89100 | $37540 | $25070 |
Current Period costs | $1404360 | $708900 | $379080 | $196400 | $119980 |
Total Costs to be accounted for | $1708970 | $861800 | $468180 | $233940 | $145050 |
Costs per Equivalent Unit | |||||
Prior Department cost |
$2.10195 ($861800/410000) |
||||
Material |
$0.81 ($468180/578000) |
||||
Labour |
$0.42 ($233940/557000) |
||||
Manufacturing overhead |
$0.3 ($145050/483500) |
||||
Costs accounted for | |||||
Costs assigned to units transferred out | |||||
Prior Department cost | $861800 |
$861800 ($2.10195*410000) |
|||
Material | $332100 |
$332100 ($0.81*410000) |
|||
Labour | $172200 |
$172200 ($0.42*410000) |
|||
Manufacturing overhead | $123000 |
$123000 ($0.3*410000) |
|||
Total costs of units transferred out (A) | $1489100 | $861800 | $332100 | $172200 | $123000 |
Costs assigned to ending WIP Inventory | |||||
Prior Department cost | $0 | $0 | |||
Material | $136080 |
$136080 ($0.81*168000) |
|||
Labour | $61740 |
$61740 ($0.42*147000) |
|||
Manufacturing Overhead | $22050 |
$22050 ($0.3*73500) |
|||
Total Ending Inventory (B) | $219870 | $0 | $136080 | $61740 | $22050 |
Total Costs accounted for (A+B) | $1708970 | $861800 | $468180 | $233940 | $145050 |