1. Compute the equivalent units of production using the weighted average method. 2. Compute the cost per equivalent unit using the weighted average method. 3. Assign costs to units using the weighted average method. 4. Prepare a cost reconciliation report. Process Costing using the Weighted-Average Method - Excel FILE HOME INSERT PAGE LAYOUT Calibri 11 ' ' Paste Clipboard BIU F| A1 FORMULAS DATA REVIEW % ? - VIEW Alignment Number Conditional Format as Cell Cells Editing Sign In Font Formatting Table Styles Styles fx Hayword, Inc. uses weighted-average costing and has two departments - mixing A B D 1 Hayword, Inc. uses weighted-average costing and has two departments - mixing and packaging. 2 The following information relates to work in the mixing department for the month of July: 3 4 Work in process, July 1: 5 Units in process 300 6 Percent completed with respect to materials 60% 7 Percent completed with respect to conversion 40% 8 Cost in the beginning inventory: 9 Materials cost $10,500 10 Conversion cost $6,750 11 Units started into production during the period 6,200 12 Costs added to production during the period: 13 Materials cost $332,150 14 Conversion cost $407,645 15 Work in process, July 31: 16 Units in process 450 17 Percent completed with respect to materials 40% 30% 18 Percent completed with respect to conversion 19 20 Use the data to answer the following. 21 E