Question

please write the formulas in this format, for example =B12+C3 and so on... use the cell numbers and lettsers that are showen in the picture, dont change the numbers and letters please!!! thanks

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 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 cel in the worksheet. From the Excel Simulation below, if in a blank cell, 85" was entered the formula would output the result from cell 85 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. If in a blank cell-89B10 was entered the formula would add the values from those cells and output the result, or 17.250 in this example 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 ranges to utilize this function. From the Excel Simulation below. If in a blank cell SUM(B13,B14) was entered the formula would output the result of adding those two separate cells, or 737,320 in this example. Similarly. If in a blank cell SUMB13 B14was 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. OBS. HOME 7 - Process Costing using the Weighted Average Method - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT Number Condos Formatas Formatsing 3 EUR 21 O 401 2 Percent completed with respect to conversion Cost in the beginning inventory: Materials cost Conversion cost 11 Units started into production during the 13 costs added to production during the 11 Materials cost Conversion cost is work in process, $10.500 $6,750 6,200 $330,912 $406,408 Veitir grocess completed

i posted the whole question i dont understand what you mean?

Answer 1

pa
Equivalent units of production
	Materials	Conversion
Units transferred to the next department	6,050	6,050
Ending work in process
Materials	180
Conversion		135
Equivlent units of production	6,230	6,185
2 Compute cost per equivalent unit
Mixing Department
Cost per Equivalent unit
	Materials	Conversion
Cost of beginning work in process	10,500	6,750
Cost added during the process	3,30,000	4,06,408
Total cost	3,40,500	4,13,158
Equivalent units of production	6,230	6,185
Cost per equivalent unit	54.65	66.80
3 Assign costs
Mixing departmnt
Costs of Ending Work in Process inventory and the units transferred out
	Materials	Conversion	Total
Ending work in process inventory
Equivalent units of production	180.00	135.00
Cost per equivalent	54.65	67
Cost of ending stock in process inventory	9,837.88	9,018.00	18,855.88
Units completed and transferred out
Units transferred to the next department	6,050	6,050
Cost per equivalent unit	54.65	66.80
Cost of units transferred out	3,30,662.12	4,04,140.00	7,34,802.12
4. Prepare reconciliation
Mixing department
cost reconciliation
costs to be accounted for:
Cost of beginning WIP inventory	17,250
Costs added to production during the period	7,36,408
Total cost to be accounted for	7,53,658.00
Costs accounted for as follows:
Cost of ending work in process inventory	18,855.88
cost of units transferred out	7,34,802.12
Total cost accounted for	7,53,658.00

A235 to pa B C D E 180 35 Equivalent units of production Materials Conversion 26 Units transferred to the next department 6,050 6,050 27 Ending work in process 28 Materials 29 Conversion 135 30 Equivlent units of production 6,2306 ,185 31 32 2 Compute cost per equivalent unit 33 Mixing Department Cost per Equivalent unit Materials Conversion 36 Cost of beginning work in process 10,500 6,750 37 Cost added during the process 3,30,000 4,06,408 38 Total cost 3,40,500 4,13,158 39 Equivalent units of production 6,230 6,185 40 Cost per equivalent unit 54.65 66.80 41 42 | 3 Assign costs Mixing departmnt Costs of Ending Work in Process inventory and the units transferred out Materials Conversion Total 46 Ending work in process inventory 47 Equivalent units of production 180.00 135.00 48 Cost per equivalent 54.65 67 49 Cost of ending stock in process inventory 9.837.88 9,018.00 18,855.88 50 51 Units completed and transferred out 52 Units transferred to the next department 6,050 6,050 53 Cost per equivalent unit 54.65 66.80 54 Cost of units transferred out 3,30,662.12 ###### 7,34,802.12 55 4. Prepare reconciliation 57 Mixing department cost reconciliation 59 costs to be accounted for: 60 Cost of beginning WIP inventory 17,250 61 Costs added to production during the period 7,36,408 62 Total cost to be accounted for 7,53,658.00 63 Costs accounted for as follows: 64 Cost of ending work in process inventory 18,855.88 65 cost of units transferred out 7,34,802.12 66 Total cost accounted for 7,53,658,00 45 56 67 K ™ Sheet1 Sheet2 Sheet3

With formula

pa
Equivalent units of production
	Materials	Conversion
Units transferred to the next department	=+B4+B11-B16	=+B26
Ending work in process
Materials	=+B16*B17
Conversion		=+B16*B18
Equivlent units of production	=+B26+B28	=+C26+C29
2 Compute cost per equivalent unit
Mixing Department
Cost per Equivalent unit
	Materials	Conversion
Cost of beginning work in process	=+B9	=+B10
Cost added during the process	=+B12	=+B13
Total cost	=+B36+B37	=+C36+C37
Equivalent units of production	=+B30	=+C30
Cost per equivalent unit	=+B38/B39	=+C38/C39
3 Assign costs
Mixing departmnt
Costs of Ending Work in Process inventory and the units transferred out
	Materials	Conversion	Total
Ending work in process inventory
Equivalent units of production	=+B28	=+C29
Cost per equivalent	=+B40	=+C40
Cost of ending stock in process inventory	=+B47*B48	=+C47*C48	=+C49+B49
Units completed and transferred out
Units transferred to the next department	=+B26	=+C26
Cost per equivalent unit	=+B40	=+C40
Cost of units transferred out	=+B52*B53	=+C52*C53	=+C54+B54
4. Prepare reconciliation
Mixing department
cost reconciliation
costs to be accounted for:
Cost of beginning WIP inventory	=+B9+B10
Costs added to production during the period	=+B12+B13
Total cost to be accounted for	=+B60+B61
Costs accounted for as follows:
Cost of ending work in process inventory	=+D49
cost of units transferred out	=+D54
Total cost accounted for	=+B64+B65