How would I answer this with the excel formulas ?

A1 Process Costing D Process Conting 2 Ave-step process: Materials added at different points Grammer Chicken produces canned chicken a la king. The chicken a la king passes through three departments: (1) Mixing. (2) Retort (sterilization), and (3) Packing. In the Mixing Department, chicken and cream are added at the beginning of the process, the mixture is partly cooked, and chopped green peppers and mushrooms are added at the end of the process. Conversion costs are Incurred evenly throughout the mixing process. November data from the Mixing Department are as follows: 4 3 6 7 9 Gallons Costs 8 Beginning work in process Inventory O gallons Beginning work in process inventory SO Started production 14,300 gallons Costs added during November: 10 Chicken 21,740 Completed and transferred out to 11 Retort in November 13,600 gallons Cream 4,000 12 Ending work in process inventory Green peppers and mushrooms 5,440 13 (60% of the way through the Direct labor 11,200 mixing process) 700 gallons Manufacturing overhead 9,830 15 Total costs $52,210 16 17 Use the blue shaded areas on the ENTERANSWERS tab for Inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions 18 tab you will be marked wrong 19 INSTRUCTIONS ENTERANSWERS hp + 3 2 3 5 4 5 6 & 7 8 9 0 W E R Y U P C 3 Insert Page Layout Formal Dube Rare View ABO (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) 2 1. Compute the equivalent units. (Hint Cach direct material added at different point in the production proces requires its own equivalent-unit 3 computation) 4 Grammer Chicken Mixing Department Flow of Physical Units and Computation of Equivalent Units 7 Equivalent Units 5 6 Flow of Physical Units How of Production Chicken, Cream Green Peppers, Conversion Mushrooms Costs 9 Units to account for 10 12 Total physical units to account for 13 Units accounted for 14 15 16 Total physical units accounted for 17 Total equivalent units 19 2. Compute the cost per equivalent unit for each cost category 20 Grammer Chicken INSTRUCTIONS ENTERANSWERS O A + 3 5 4 5 6 8 7 CD ( 9 E R T Y U Home Insert Page Layout Formulas Data Review View Help A10 14 15 16 Total physical units accounted for 1 Total equivalent units 18 19 2. Compute the cost per equivalent unit for each cort category 20 Grammer Chicken 21 Mixing Department 22 Cost per Equivalent Unit Month Ended November 30 Chicken and Cream Green Peppers and Mushrooms Conversion Costs 24 25 Cost per Equivalent Unit Total > 26 27 Total costs to account for 28 29 Cost per equivalent unit 30 3. Compute the total costs of the units (gallons): a. Completed and transferred out to the Retort Department 31 b. In the Mixing Department's ending work in process inventory Grammer Chicken 31 Mixing Department Assignment of Costs INSTRUCTIONS ENTERANSWERS M 21 Green Peegera hop e 96 $ 4 > 2 3 6 & 7 00 9 0 W E R Y U File Home Page Layout formulas Duta Review View A10 29 Cost per equivalent unit 20 3. Compute the total costs of the units (gallons): a. Completed and transferred out to the Retort Department 31 b. In the Mining Department's ending work in process Inventory 32 Grammer Chieken 33 Mling Department 34 Assignment of Costs Chicken and Cream Green Peppers and Mushrooms Conversion Costs 35 Total Assign costs 36 Completed and transferred out 37 38 19 Costs assigned to units completed and transferred out 40 1 Ending work in process 43 4 Costs assigned to units in ending WIP 45 Total costs accounted for 45 47 40 30 INSTRUCTIONS ENTERANSWERS top 144 3 5 6 7 00 9 E R T Y U o