1. Siena Melamine Factory uses process costing.It has two departments: Mixing and Finishing.The Finishing Department receives the mixed components from the Mixing Department and finishes them.60% of the materials are added at the beginning of the process in the Finishing Department, and the remaining 40% are added when the units are 80% complete.Finishing's beginning Work in Process amounts to 8,000 units which are 40% complete as to conversion costs.Finishing received 40,000 units from Mixing.Finishing's ending Work in Process amounted to 15,000 units that are 90% complete as to conversion costs.The costs of beginning Work in Process are $96,000 in transferred in costs, $19,200 in materials, and $9,600 in conversion costs.Costs added during the period included $500,000 in transferred in costs, $194,400 in material costs, and $129,900 in conversion costs.Siena uses the FIFO method.

I am looking for the material cost per unit, conversion cost per unit and total product cost? I have attached my spreadsheet if you can show me where I have errors, I would appreciate it.

Siena Melamine Factory Step 1 Physical Units Completion % Input BI WIP Materials Conversion Units Started Units to account for Output Units Completed WIP - Ending Materials Conversion Units accounted for Total wighted average EQ Less BI EQ EQ FIFo 8000 100% 40% 8000 100% 33000 100% 90% 15000 40000 48000 33000 15000 48000 26000 8000 18000 Direct Materials BI Transfer Costs WIP Added Transfer Costs Added Total Costs to Account for Divide by EQ Goods completed and transferred out Ending WIP Step2 Direct Materials Conversion Total 19200 9600 194400 194400 10.80 37500 86400.00 12900 12900 0.66 ### 96000 28800 500000 207300 707300 39.29 37500 Step2 Direct Conversion 60% are transferred in at beginning rest are transferred when 80%, 0 3200 2116.923 33000 1296717 162000 13500 8930.769 22700 3200 19500 Disregard for FIFO