B D G H M Production Report 1 2 3 Equivalent units produced %6 % Comp. Comp. Physical Units Equivalent Units Direct Conversion Material Cost Using the following information complete the production report using the weighted average method: WIP, beginning 35,000 units, DM 60%, CC 30% complete WIP, ending 20,000 units, DM 75, CC 25% complete Units started this period 175,000 Units completed and transferred out 190,000 Costs DM CC Beginning $43,000 $18.000 Added this period $223,500 $99,000 The highlighted cells will be your input section. In other words these are the only cells in which you will type just a number. Every other cell that contains information will come from a calculation. Use the information provided above for the input. The rest of the template will be completed by putting formulas in the appropriate cells so that the necessary calculations are performed to complete the production report 4 5 WIP, beginning 6 Units Started 7 Units to account for 8 Completed & Transferred out 9 Ending WIP 10 Units accounted for 11 Equivalent units of production 12 Cost per Equivalent unit: 13 WIP, beginning 14 Costs added 15 costs to account for 16 Equivalent units 17 Cost per Equivalent unit 18 19 Assignment of Costs 20 Completed & transferred out 21 WIP, ending: 22 Direct Materials 23 Conversion costs 24 Total WIP 25 Total costs accounted for 26 27 28 20 39 Production Report 40 41 42 Equivalent units produced % % Comp. Comp. Physical Units Equivalent Units Direct Conversion Material Cost 43 44 WIP, beginning 45 Units Started 46 Units to account for 47 Completed & Transferred out 48 Ending WIP 49 Units accounted for 50 Equivalent units of production 51 Cost per Equivalent unit: 52 WIP, beginning 53 Costs added 54 costs to account for 55 Equivalent units 56 Cost per Equivalent unit 57 58 Assignment of Costs 59 Completed & transferred out 60 WIP, ending: 61 Direct Materials 62 Conversion costs 63 Total WIP 64 Total costs accounted for 65 66 67 60