In: Accounting
MVP Company has two departments. Its first department
(the Melting Department) shows the following data for the month of
August: Work in process, beginning: Units in
process
400 Stage of completion with respect to materials 60%Stage of
completion with respect to conversion 85% Costs in the beginning
inventory: Materials cost $170 Labour
cost $160 Overhead cost $300 Units started into
production during the month 1,100Units completed and transferred
out 1,400Costs added to production during the
month: Materials cost $1,300
Labour cost $800 Overhead cost $1,700Work in process,
ending: Units in process
??? Stage of completion with respect to materials
70% Stage of completion with respect to
conversion 80%
Required: Using the weighted average method and FIFO method,
prepare a production cost report for the company.
| WEIGHTED AVERAGE COST | |||||||
| UNITS TO ACCOUNT FOR: | |||||||
| Beginning Work in Process units | 400 | ||||||
| Add: Units Started in Process | 1,100 | ||||||
| Total Units to account for: | 1,500 | ||||||
| UNITS TO BE ACCOUNTED FOR: | |||||||
| Units started and completed | 1,400 | ||||||
| Ending Work in Process | 100 | ||||||
| Total Units to be accounted for: | 1,500 | ||||||
| Equivalent Units: | |||||||
| Material Cost | Conversion | ||||||
| % Completion | Units | % Completion | Units | ||||
| Units started and completed | 100% | 1,400 | 100% | 1,400 | |||
| Ending Work in Process | 70% | 70 | 80% | 80 | |||
| Total Equivalent units | 1,470 | 1,480 | |||||
| TOTAL COST TO ACCOUNT FOR: | |||||||
| Material | Conversion | ||||||
| Beginning work in Process | 170 | 2,160 | |||||
| Cost Added during May | 1,300 | 800 | |||||
| Total Cost to account for: | 1,470 | 2,960 | |||||
| Total Cost to account for: | 4,430 | ||||||
| COST PER EQUIVALENT UNIT: | |||||||
| Material | Conversion | ||||||
| Total cost added during the year | 1,470 | 2,960 | |||||
| Equivalent Units | 1,470 | 1,480 | |||||
| Cost per Equivalent unit | 1 | 2 | |||||
| TOTAL COST ACCOUNTED FOR: | |||||||
| Units started and Transferred out (1400 units) | |||||||
| Equivalent unit | Cost per EU | Total Cost | |||||
| Material | 1,400 | 1 | 1400 | ||||
| Conversion Cost | 1,400 | 2 | 2800 | ||||
| Total Cost of Units completed and transferred out: | 4200 | ||||||
| Ending Work in process (100 units) | |||||||
| Equivalent unit | Cost per EU | Total Cost | |||||
| Material | 70 | 1 | 70 | ||||
| Conversison Cost | 80 | 2 | 160 | ||||
| Total cost of Ending Work in process: | 230 | ||||||
| FIFO | |||||||
| UNITS TO ACCOUNT FOR: | |||||||
| Beginning Work in Process units | 400 | ||||||
| Add: Units Started in Process | 1,100 | ||||||
| Total Units to account for: | 1,500 | ||||||
| UNITS TO BE ACCOUNTED FOR: | |||||||
| Units completed from Beginning WIP | 400 | ||||||
| Units started and completed | 1,000 | ||||||
| Ending Work in Process | 100 | ||||||
| Total Units to be accounted for: | 1,500 | ||||||
| Equivalent Units: | |||||||
| Material Cost | Conversion | ||||||
| % Completion | Units | % Completion | Units | ||||
| Units completed from Beg. WIP | 40% | 160 | 15% | 60 | |||
| Units started and completed | 100% | 1,000 | 100% | 1,000 | |||
| Ending Work in Process | 70% | 70 | 80% | 80 | |||
| Total Equivalent units | 1,230 | 1,140 | |||||
| COST PER EQUIVALENT UNIT: | |||||||
| Material | Conversion | ||||||
| Total cost added during the year | 1,300 | 2,500 | |||||
| Equivalent Units | 1,230 | 1,140 | |||||
| Cost per Equivalent unit | 1.06 | 2.19 | |||||
| TOTAL COST ACCOUNTED FOR: | |||||||
| Units Completed from Beginning WIP (400 units) | |||||||
| Equivalent unit | Cost per EU | Total Cost | |||||
| Beginning Cost | 630 | ||||||
| Material | 160 | 1.06 | 169.6 | ||||
| Conversion Cost | 60 | 2.19 | 131.4 | ||||
| Cost of units completed from Beg WIP | 931 | ||||||
| Units started and Transferred out (1000 units) | |||||||
| Equivalent unit | Cost per EU | Total Cost | |||||
| Material | 1,000 | 1.06 | 1060 | ||||
| Conversion Cost | 1,000 | 2.19 | 2190 | ||||
| Total Cost of Units completed and transferred out: | 3250 | ||||||
| Ending Work in process (100 units) | |||||||
| Equivalent unit | Cost per EU | Total Cost | |||||
| Material | 70 | 1.06 | 74.2 | ||||
| Conversison Cost | 80 | 2.19 | 175.2 | ||||
| Total cost of Ending Work in process: | 249 | ||||||