In: Finance
Production data:
Units (gallons) in process, April 1: materials 100% complete;
labor and overhead 60% complete . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30,000
Units (gallons) started into production during April . . . . . . . . . . . . . . . . . . 4 20,000
Units (gallons) completed and transferred to the Finishing Department . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 370,000
Units (gallons) in process, April 30: materials 50% complete; labor and overhead 25% complete . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80,000
Cost data: Work in process inventory, April 1: Materials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 92,000
Labor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21,000
Overhead . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37,000
Total cost of work in process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 150,000
Cost added during April: Materials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 851,000
Labor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 330,000
Overhead . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 665,000
Total cost added during April . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $1,846,000
a.Prepare a cost reconciliation report for april
| Cost reconciliation | ||
| Costs to be accounted for | ||
| Cost of beginning work in process inventory | 150000 | |
| Costs added during the month | 1846000 | |
| Total costs | 1996000 | |
| Costs accounted for | ||
| Cost of units transferred out | 1850000 | |
| Costs of ending work in process | 146000 | |
| Total costs | 1996000 |
Workings:
| Gallons | Direct Materials | Labor | Overhead | |
| UNITS | ||||
| Units to account for: | ||||
| Beginning work in process | 30000 | |||
| Transferred in | 420000 | |||
| Total units to account for | 450000 | |||
| Units accounted for | ||||
| Completed and transferred out | 370000 | 370000 | 370000 | 370000 |
| Ending work in process | 80000 | 40000 | 20000 | 20000 |
| Equivalent units | 450000 | 410000 | 390000 | 390000 |
| Cost per equivalent unit | Direct Materials | Labor | Overhead | |
| Work in process beginning | 92000 | 21000 | 37000 | |
| Costs added during June | 851000 | 330000 | 665000 | |
| Total costs for January in roasting Department | 943000 | 351000 | 702000 | |
| Total equivalent units | 410000 | 390000 | 390000 | |
| Cost per equivalent unit | 2.30 | 0.90 | 1.80 | |
| Direct Materials | Labor | Overhead | Total | |
| Cost of goods transferred | 851000 | 333000 | 666000 | 1850000 |
| [370000*2.3] | [370000*0.9] | [370000*1.8] | ||
| Direct Materials | Conversion | Total | ||
| Work in process | 92000 | 18000 | 36000 | 146000 |
| [40000*2.3] | [20000*0.9] | [20000*1.8] |