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  |