please show the cell functions for each highlighted square, thank you!

E 6 9 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 Percent completed with respect to materials 60% 7 Percent completed with respect to conversion 40% 8 Cost in the beginning inventory: 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 $330,912 14 Conversion cost $406,408 15 Work in process, July 31: 16 Units in process 17 Percent completed with respect to materials 40% 18 Percent completed with respect to conversion 30% 19 20 Use the data to answer the following. 21 22 1. Compute equivalent units. 23 Mixing Department 24 Equivalent Units of Production 450 4 Conversion 3 Mixing Department Equivalent Units of Production 5 Materials Units transferred to the next department 7 Ending work in process: 3 Materials Conversion Equivalent units of production 2 2. Compute cost per equivalent unit. Mixing Department Cost per Equivalent Unit 3 . Materials Conversion Cost of beginning work in process Cost added during the period Total cost Equivalent units of production Cost per equivalent unit 3. Assign costs. Mixing Department Costs of Ending Work in Process Inventory and the Units Transferred Out Materials Conversion Ending work in process inventory: Sheet1 Total A B D E 14 5 Total Costs of Ending Work in Process Inventory and the Units Transferred Out Materials Conversion 6 Ending work in process inventory: 7 Equivalent units of production 8 Cost per equivalent unit 9 Cost of ending work in process inventory Units completed and transferred out: 2 Units transferred to the next department Cost per equivalent unit Cost of units transferred out 4. Prepare reconciliation Mixing Department Cost Reconciliation Costs to be accounted for: Cost of beginning work in process inventory Costs added to production during the period Total cost to be accounted for Costs accounted for as follows: Cost of ending work in process inventory Cost of units transferred out Total cost accounted for Sheet1 ADY + 100%