(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. (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 Physical Units Chicken, Cream Green Peppers, Mushrooms Conversion Costs 0 14300 14 300 Flow of Production Units to account for: Beginning work in process Units started this period Total physical units to account for Units accounted for: Completed and transferred out Ending work in process: Total physical units accounted for Total equivalent units 25 740 5.440 13,600 700 14,300 2. Compute the cost per equivalent unit for each cost category. Grammer Chicken Mixing Department Cost per Equivalent Unit Month Ended November 30 Green Peppers Chicken and and Cost per Equivalent Unit Cream Mushrooms Cost of beginning work in process $0 $0 Cost incurred this period $25 740 $5,440 Total costs to account for $25 740 $5.440 Equivalent units of production Cost per equivalent unit Conversion Costs $0 $21,030 $21,030 Total 0 52210 52210 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 Grammer Chicken Mixing Department Assignment of Costs Chicken and Cream Green Peppers and Mushrooms Conversion Costs Total Assign costs Completed and transferred out Costs assigned to units completed and transferred out Ending work in process: Costs assigned to units an ending WIP Total costs accounted for 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: $0 Costs O gallons Beginning work in process inventory 14,300 gallons Costs added during November: Chicken 21,740 Gallons Beginning work in process inventory Started production Completed and transferred out to Retort in November Ending work in process inventory (60% of the way through the mixing process) 13,600 gallons Cream Green peppers and mushrooms Direct labor Manufacturing overhead Total costs 4,000 5,440 11,200 9,830 $52, 210 700 gallons Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full cre you will be marked wrong. If you copy/paste from the Instructions tab 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) Check your spelling carefully and do not abbreviate. 1. Follow the format of the exhibit that shows the flow of physical units and output in terms of equivalent units. 111. 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 1. 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. Hi. Complete all input areas. Be sure to include any zero balances in the report 3 Compute the total costs of the units (gallons): a b. 1. Completed and transferred out to the Retort Department 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. 1. TH Saving & Submitting Solution 1 Save file to desktop. a. 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 Viewing Results 1 Click on Results tab in My Accountinglab 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
