Please show work- excel formulas are needed for my response.

A B F G H 1 Problem 1 2 7 The debits to Work in ProcessAssembly Department for April, together with data concerning production, are as follows: 1 5 April 1, work in process: $ 5 Materials cost, 5,000 units 12,500 Conversion costs (CC), 5,000 units, 80% completed 8,500 3 Costs added to WIP during April: Materials added during April, 18,000 units 45,000 o Conversion costs during April 35,000 1 Goods finished during April, 20,000 units 2 April 30, work in process, 3,000 units, 60% completed 3 4 All direct materials are placed in process at the beginning of the process, 5 and the weighted average method is used to cost inventories. 6 7 Required: 8 9 A. The materials cost per equivalent unit (to the nearest cent) for April: o B. The conversion costs per equivalent unit (to the nearest cent) for April: 6 7 Required: 8 9 A. The materials cost per equivalent unit (to the nearest cent) for April: 0 B. The conversion costs per equivalent unit (to the nearest cent) for April: -1 2 Solution: -3 Physical units % of completion Equivalent units (EU) -4 DM CC DM 5 Units completed and Transferred to Finished goods 26 Ending WIP -7 Total EU -8 Costs -9 Beginning WIP costs so Costs added during April #1 Total costs =2 Costs per EU 3 4