Steps to Perform: Step Instructions Points Possible 1. Summarize the ow 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.) i. Check your spelling carefully and do not abbreviate. ii. Follow the format of the exhibit that shows the ow of physical units and output in terms of equivalent units. iii. Complete all input areas. Be sure to include any zero balances in the report. 23 2. Compute the cost per equivalent unit for each cost category. i. 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. iii. Complete all input areas. Be sure to include any zero balances in the report. 24 3. Compute the total costs of the units (gallons): a. Completed and transferred out to the Retort Department b. In the Mixing Department's ending work in process inventory i. Check your spelling carefully and do not abbreviate. ii. Follow the format of the exhibit that assigns total costs to units completed and to units in ending work in process. iii. Complete all input areas. Be sure to include any zero balances in the report. 29 Total Points 76- H I I} I In I U I: I' U Process Costing Fivestep 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. 4 E November data from the Mixing Department are as follows: 6 ? Gallons Costs 8_ Beginning work in process inventory 0 gallons Beginning work in process inventory $0 9 Started production 14,300 gallons Costs added during November: 11 Chicken 21, 240 Completed and transferred out to 1 Retort in November 13,600 gallons Cream 4,000 11 Ending work in process inventory Green peppers and mushrooms 5,440 11 [60% of the way through the Direct labor 11,200 11 mixing process] 2'00 gallons Manufacturing overhead 9,330 1i Total costs $52,210 '3 [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 copyfpaste from the Instructions tab 18 you will be marked wrong. 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 equivalentunit computation.) 21 21 i. 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 equivalent units. 21 21 iii. Complete all input areas. Be sure to include any zero balances in the report. 23 2 Compute the cost per equivalent unit for each cost category. 26 i. 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 INSTRUCTIONS ENTERANSWERS 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 equivalentunit computation.) i. 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 equivalent units. iii. 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. i. 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. iii. Complete all input areas. Be sure to include any zero balances in the report. 3 Compute the total costs of the units [gallons]: a. Completed and transferred out to the Retort Department b. In the Mixing Department's ending work in process inventory i. 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 II' work in process. iii. Complete all input areas. Be sure to include any zero balances in the report. Saving Bl. Submitting Solution 1 Save file to desktop. 3. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. . Navigate back to the activity window screen where you downloaded the initial spreadsheet b. Click Choose button under step 3: locate the file you just saved and click Open c. Click Upload button under step 3 d. Click Submit button under step 4 a Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 3 Click on Project link: this will bring up your Score Card 4 Within Score Card window, click on Live Comments Report [lower right] to download spreadsheet with feedback INSTRUCTIONS ENTERANSWERS (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be 1 marked wrong.) 2 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 Flow of Green Peppers, | Conversion 8 Flow of Production Physical Units Chicken, Cream Mushrooms Costs Units to account for: 10 11 12 Total physical units to account for 13 Units accounted for: 14 15 16 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 22 Cost per Equivalent Unit 23 Month Ended November 30 Green Peppers Chicken and and Conversion Cost per Equivalent Unit Cream Mushrooms Costs Total Total costs to account for 29 Cost per equivalent unit 30 3. Comnute the total costs of the units feallonel- INSTRUCTIONS ENTERANSWERS +A B C D E F 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 32 Grammer Chicken 33 Mixing Department 34 Assignment of Costs Green Peppers Chicken and and Conversion 35 Assign costs Cream Mushrooms Costs Total 36 Completed and transferred out 37 38 39 Costs assigned to units completed and transferred out 40 41 Ending work in process: 42 43 44 Costs assigned to units in ending WIP 45 Total costs accounted for 46 47 48 49 50 51 52 53 54 INSTRUCTIONS ENTERANSWERS (+