Hayword, Inc uses weighted average costing and has two departments and has provided data related to its mixing department for me month or July. The Controller has asked you prepare a cost reconciliation report and provide the related computations. Use the Information included in the Excel Simulation and the Excel functions described below to complete the task Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below. Fin a blank cell, -85 was entered the formuln would output the result from celles, or 300 in this example, Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys. plus sign to add) - minus sign to subtract)..asterisk sign to multiply, and forward slash to divide) From the Excel Simulation below. it in a blank cell 09-B10 was entered the formula would add the values from those cells and output the result, or 17.250 in this example in using the other math symbols the result would output on appropriate answer for its function SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell referencer or ranges to welige this function. From the Excel Simulation below. it in a blank cell SUM(813,814" was entered the formula would output the result of adding those two separate cells. 737320 in this example Smarty in i blank cell SUM/513814) was entered the formula would output me Same result of adding those cells, excent they are expressed as unge in the formula, and the result would be 77.320 in this example Process Corting using the Weighted Average Method - Eacel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME INSERT X Calibri % Paste BTU Alignment Mumber Conditional Format Formatting Table Style Gicbear Font Al Hayword, Inc. uses weighted average costing and has two departments mixing E A 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 50% 7 Percent completed with respect to conversion 40% Cout in the beginning inventory Materials cost $10.500 10 Conversion cost 56,750 11 Units started into production during the period 6.200 12 Costs noded to production during the period: 1) Materials.com 3930,913 14 Conversion cost 5406,401 15 Work in process, July 31 15 Units in procesi 450 17 Percent completed with respect to material LON 13 Percent completed with respect to conversion SON 15 30 Ose meets to show the following 22 Comoute equivalent un 23 Main Department Louvaient units of Production Attempts) Process Costing using the Weighted Average Methodical FILE HONE INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Calibri A % Paste C Alignment Number Conditional Format as Formatting Table Style Clipboard Font Al Hayword, Inc uses weighted average costing and has two departments - mixing D Conversion B 24 Equivalent Units of Production Materials 25 Units transferred to the next department 27 Ending work in process: 28 Materials 19 Conversion 30 Equivalent units of production 31 32 2. Compute cost per equivalent unit 33 Mixing Department Cost per Equivalent Unit Materials 36 Cost of beginning work in process 37 Cost added during the period 3 Total cost 19 Equivalent units of production 40 Colt per equivalent unit Conversion : 42 3. Assino Mixing Department Costs of Ending Work in Process Inventory and the Units Transferred Out Materials Conversion 46 Ending work in process inventory Equivalent units of production Sheet HEADY Arps) Process Costing using the Weighted Average Method - Excel - FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Soala X Paste BTU Cell Alignment Number Conditional Format Cell Formatting Table Style Clipboard For Al f Hayword, Inc uses weighted average costing and has two departments - mixing A E 48 Cost per equivalent unit 49 Cost of ending work in process inventory 50 51 Units completed and transferred out 52 Units transferred to the next department 53 Cost per equivalent unit 54 Cost of units transferred out 55 56 1. Prepare reconciliation 59 Mixing Department 58 Cost Reconciliation 59 Costs to be accounted for 10 Cost of beginning work in process inventory 51 Couts added to product during the period 62 Total cost to be accounted for Costs accounted for as follows Cont of ending work in process inventory 5 Cost of units transferred out Total costouted for 52 Alampalay Process Costing using the Weighted Average Method - Excel - FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Soala X Paste BTU Cell Alignment Number Conditional Format Cell Formatting Table Style Clipboard For Al f Hayword, Inc uses weighted average costing and has two departments - mixing A E 48 Cost per equivalent unit 49 Cost of ending work in process inventory 50 51 Units completed and transferred out 52 Units transferred to the next department 53 Cost per equivalent unit 54 Cost of units transferred out 55 56 1. Prepare reconciliation 59 Mixing Department 58 Cost Reconciliation 59 Costs to be accounted for 10 Cost of beginning work in process inventory 51 Couts added to product during the period 62 Total cost to be accounted for Costs accounted for as follows Cont of ending work in process inventory 5 Cost of units transferred out Total costouted for 52 Alampalay