Please do in excell

Shine Company uses a process cost system to account for the costs incurred in making its single product, a hair conditioner. This product is processed in Department A and then in Department B Materials are added in both departments. Production for May was as follows: Department Department Units started or transferred in Units completed and transferred out Stage of completion of May 31 inventory: 200,000 160,000 160,000 120,000 Materials Conversion 100% 50% 80% 40% Costs incurred this month: Direct materials costs Conversion costs $200,000 $540,000 $304,000 $272,000