Pls show the excel function for each of the answer box.
Homework: Chapter 5 G Saved Help Save & Exit Submit Hayword, Inc. uses weighted-average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller in the Excel Simulation and the Excel functions described below to complete the task. has asked you prepare a cost reconciliation report and provide the related computations. Use the information included Cell Reference: Allows you to refer to deta from another cell in the worksheet. From the Excel Simulation below, if in a blank was entered, the formula would output the result from cell 85, or 300 in this example. . 10 points . 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 multiplyl, and/(forward slash to divide). From the Excel Simulation below, i in a blank cell B9+B10 was entered, the formula would add the values from those cells and output the result, or 17,250 in If using the other math symbols the result would output an appropriate answer for its function SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or function. From the Excel Simulation below, if in a blank cell SUM(B13,814) was e those two separate cells, or 737,320 in this example. Simlarly, if in a blank cell SUMB13.814) was entered, the formula would output the same result of adding those cells, except they are expressed as a range in the formula, and the result would be 737,320 in this example. ellook Print References ranges to utiize this would result of adding F16 5 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: 4 Work in process, July 1: s Units in process 10 300 60% 40% 7 Percent completed with respect to conversion 8 Cost in the beginning inventory 9 Materials cost 0 Conversion cost $10,500 56,750 6,200 |Units started into production during the period References 12 Costs added to production during the period: $330,912 $406 408 3Materials cost 14 Conversion cost is Work in process, July 31 16 Units in process 450 40% 30% 7 Percent completed with respect to materials 18 Percent completed with respect to conversion 19 20 Use the data to answer the following 21 22 1. Compute equivalent units 23 24 Mixing Department Equivalent Units of Production Sheet1 ! 100% F16 5 23 Mixing Department Equivalent Units of Production MaterialsConversion 25 26 Units transferred to the next department 27 Ending work in process: 8 Materials so Equivalent units of production 31 32 2. Compute cost per equivalent unit Mixing Department Cost per Equivalent Unit References Materials Conversion 35 36 Cost of beginning work in process 7 Cost added during the period 38 Total cost 39 Equivalent units of production 40 Cost per equivalent unit 41 42 3. Assign costs. Mixing Department Costs of Ending Work in Process Inventory and the Units Transferred Out Materials ConversionTotal 45 46 Ending work in process inventory Sheeti ,00% F16 5 43 Mixing Department Costs of Ending Work in Process Inventory and the Units Transferred Out Materials ConversionTotal 10 46 Ending work in process inventory 7 Equivalent units of production 48 Cost per equivalent unit 49 Cost of ending work in process inventory 50 1 Units completed and transferred out: 2 Units transferred to the next department s3 Cost per equivalent unit References 4 Cost of units transferred out 56 4. Prepare reconciliation. 57 Mixing Department Cost Reconciliation 59 Costs to be accounted for 60 Cost of beginning work in process inventory 61 Costs added to production during the period 62 Total cost to be accounted for 63 Costs accounted for as follows: 64 Cost of ending work in process inventory 65 Cost of units transferred out 66 Total cost accounted for Sheeti 100% Homework: Chapter 0 F16 5 49 Cost of ending work in process inventory s1 Units completed and transferred out 52 Units transferred to the next department 53 Cost per equivalent unit S4 Cost of units transferred out 10 56 4. Prepare reconciliation Mixing Department Cost Reconciliation Print s9 Costs to be accounted for References 60 Cost of beginning work in process inventory 61 Costs added to production during the period 62 Total cost to be accounted for 63 Costs accounted for as follows 64 Cost of ending work in process inventory 65 Cost of units transferred out 66 Total cost accounted for 67
