Please when you answer use the Excel attachment!

(LO 8-3) 8-33. Compute Costs per Equivalent Unit: Weighted Average Method The Matsui Lubricants plant uses the weighted- average method to account for its work-in- process inventories. The accounting records show the following information for a particular day. Beginning WIP inventory Direct materials $976 272 Conversion costs Current period costs Direct materials 11,440 6,644 Conversion costs Quantity information is obtained from the manufacturing records and includes the following: Beginning inventory 600(60% complete as unitsto materials, 53% complete as to conversion) Current period units started Ending inventory 4,000 units 1,200(40% complete as units to materials, 20% complete as to conversion) Required Compute the cost per equivalent unit for direct materials and conversion costs. A F G H B C D E Compute Costs per Equivalent Unit-Weighted-Average Method 1 Ex. 8-33 2 3 4 Physical Units S Equivalent Units Materials Conversion Eq. Units Costs Eq. Units 8 9 6 a. 7 Flow of units: Units to be accounted for: Beginning WIP inventory 0 Units started this period 1 Total units to account for 2 Units accounted for: 3 Completed and transferred out Units in ending inventory 5 Materials 6 Conversion costs Total units accounted for 8 4 9 b. Total Direct Materials Conversion Costs $ $ $ 0 21 Flow of costs: 2 Costs to be accounted for: 23 Costs in beginning WIP inventory 24 Current period costs 5 Total costs to be accounted for 6 Cost per equivalent unit 7 Materials 28 Conversion costs 19 0 1 2 #DIV/0! #DIV/0