In: Accounting
Prepare a cost of production report for the Machining Department for May using the FIFO method of costing.
Phillips Company needs to prepare a cost of production report for
the machining department. The follow data has been provided:
1. Work in process, May 1, had 90,000 units that were 40%
completed and the following costs:
Direct materials
$72,720
Direct labor
$108,000
Overhead $36,000
2. During the month of May, 180,000 units were completed and
transferred to the next department and the following costs were
added to production:
Direct materials
$216,000
Direct labor
$144,000
Overhead $162,000
3. On May 31, there were 45,000 partially completed units in process. These units were 80% complete.
Costs Charged to Production: |
|
Cost of beginning WIP |
$ 216,720.00 |
Costs incurred this period |
$ 522,000.00 |
Total Cost to account for |
$ 738,720.00 |
Total costs accounted for |
$ 738,720.00 |
Difference due to rounding cost/unit |
$ - |
Units Reconciliation |
|
Units to account for: |
|
Beginning WIP |
90,000 |
Units started this period |
135,000 |
Total Units to account for |
225,000 |
Total Units accounted for: |
|
Completed & Transferred out |
180,000 |
Ending WIP |
45,000 |
Total Units accounted for |
225,000 |
EUP - FIFO Method |
Units |
% Material |
EUP Materials |
% Conversion |
EUP - Conversion |
Units of ENDING WIP |
45,000 |
100.0% |
45,000 |
80.0% |
36,000 |
Units STARTED & COMPLETED |
90,000 |
100% |
90,000 |
100% |
90,000 |
Units of beginning WIP |
90,000 |
0.00% |
- |
60% |
54,000 |
Equivalent Units of Production |
135,000 |
180,000 |
|||
COST per EUP |
Material |
Conversion |
|||
Cost incurred this period |
$ 216,000.00 |
$ 306,000.00 |
|||
Total Costs |
Costs |
$ 216,000.00 |
Costs |
$ 306,000.00 |
|
Equivalent units of production |
EUP |
135,000 |
EUP |
180,000 |
|
Cost per EUP |
$ 1.6000 |
$ 1.7000 |
COST ASSIGNMENT & RECONCILIATION |
||||
Cost Transferred out: |
EUP |
Cost per EUP |
Total Cost |
|
Cost of Beginning WIP |
216,720.00 |
|||
Cost to complete beginning WIP- |
||||
- Direct Materials |
- |
1.60 |
- |
|
- Conversion |
54,000.00 |
1.70 |
91,800.00 |
|
Total cost to complete beginning WIP |
308,520.00 |
|||
Cost of Units started & completed this period: |
EUP |
Cost per EUP |
Total Cost |
|
- Direct Materials |
90,000.00 |
1.60 |
144,000.00 |
|
- Conversion |
90,000.00 |
1.70 |
153,000.00 |
|
Total costs started & Completed this period |
297,000.00 |
|||
Total cost of work finished this period |
605,520.00 |
|||
Costs of Ending WIP: |
EUP |
Cost per EUP |
Total Cost |
|
- Direct Materials |
45,000 |
$ 1.60 |
$ 72,000.00 |
|
- Conversion |
36,000 |
$ 1.70 |
$ 61,200.00 |
|
Total cost of ending WIP |
$ 133,200.00 |
|||
Total costs accounted for |
$ 738,720.00 |