please include the formulas used, thank you.
B D G E Process Casting 2 Five-step process: Materials added at different points 9 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 5 6 2 8 9 10 Gallons Beginning work in process inventory Started production Costs 0 gallons Beginning work in process inventory 14,300 gallons Costs added during November: Chicken $0 21,740 13,600 gallons 13 72 13 14 15 Completed and transferred out to Retort in November Ending work in process inventory (60% of the way through the mixing process) Cream Green peppers and mushrooms Direct labor Manufacturing overhead Total costs 700 gallons 4,000 5,440 11,200 9,830 $52,210 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 tab you will 18 be marked wrong. 19 20 Requirements 1 Summarize the flow of physical units and compute the equivalent units. (Hint: Each direct material added at a INSTRUCTIONS INTERANSWERS 3 Type here to search . B F G 21 22 ii. C D E Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you 18 be marked wrong 19 20 Requirements 1 Summarize the flow of physical units and compute the equivalent units. (Hint: Each direct material added at a different point in the production process requires its own equivalent-unit computation.) 1. Check your spelling carefully and do not abbreviate. ii. Follow the format of the exhibit that shows the flow of physical units and output in terms of 23 equivalent units. Complete all input areas. Be sure to include any zero balances in the report. 2 Compute the cost per equivalent unit for each cost category. Check your spelling carefully and do not abbreviate. ii. Follow the format of the exhibits that show how to summarize total costs to account for and to compute the cost per equivalent unit. Complete all input areas. Be sure to include any zero balances in the report. 3 Compute the total costs of the units (gallons): Completed and transferred out to the Retort Department b. In the Mixing Department's ending work in process inventory Check your spelling carefully and do not abbreviate. Follow the format of the exhibit that assigns total costs to units completed and to units in ending work in process. Complete all input areas. Be sure to include any zero balances in the report, 36 Saving & Submitting Solution 1 Save file to desktop Create folder on desktop and label COMPLETED EXCEL PROJECTS INSTRUCTIONS INTERANSWERS 24 25 26 1. 27 28 29 30 a. 1. ii. 33 34 il 37 a Type here to search FOTE Siles A1 dicboard Alignment Number (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab A B D E (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.) 1. Compute the equivalent units. 3 (Hint: Each direct material added at a different point in the production process requires its own equivalent-unit computation.) Grammer Chicken Mixing Department Flow of Physical Units and Computation of Equivalent Units Equivalent Units 4 5 6 7 Chicken, Cream Green Peppers, Conversion Mushrooms Costs Flow of 8 Flow of Production Physical Units Units to account for: 10 11 12 Total physical units to account for 13 Units accounted for: 14 15 To Total physical units accounted for 17 Total equivalent units 18 19 2. Compute the cost per equivalent unit for each cost category 20 Grammer Chicken 21 Mixing Department INSTRUCTIONS ENTERANSWERS Type here to search Number Styles AI B (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will A D 19 2. Compute the cost per equivalent unit for each cost category. 20 Grammer Chicken 21 Mixing Department 22 Cost per Equivalent Unit 23 Month Ended November 30 24 Green Peppers and Mushrooms Conversion Costs Total Chicken and Cost per Equivalent Unit Cream 25 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 Mbing Department's ending work in process inventory 12 Grammer Chicken 93 Mixing Department Assignment of Costs 34 Chicken and Cream Green Peppers and Mushrooms Conversion Costs Total 35 Assign costs 36 Completed and transferred out 37 30 Costs assigned to units completed and transferred out INSTRUCTIONS ENTERANSWERS 3 Type here to search Font Clipboard Aignment Number Styles AL (Always ute cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you B D 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 32 Grammer Chicken 23 Mixing Department 34 Assignment of Costs Chicken and Cream Green Peppers and Mushrooms Conversion Costs Total 35 Assign costs 36 Completed and transferred out 37 36 Costs assigned to units completed and transferred out 40 41 Ending work in process: Costs assigned to units in ending WIP 45 Total costs accounted for 47 59 INSTRUCTIONS ENTERANSWERS 11 Type here to search o TE
