EXCEL CELL REFERENCE PLS

B C D E F G H L M N 1 1 Given Data: Required Part (1) 2 Humpty Dumpty Inc. manufactures Yummy potato chips. 3 Production of the potato chips occurs in three departments: Cleaning, Cooking and Packaging. Consider the Cooking department, where the "seasoning" materials are added; more specifically: Quantity Schedule 4 5 6 soning is added when the conversion costs are 85% complete 7 Total Equivalent Units of Production Transferred In Seasoning Conversion 10 11 % & The accounting records of the Humpty Dumpty factory provided the following information for jalapeno 9 flavoured potato chips in its Cooking department during a weekly period (week 9): Transferred in Seasoning Conversion Units costs costs costs 12 Beginning work in process, week | 125,000 $ 70,000 $ $ 8,750 Degree (percentage) of completion 0% 35% 14 Transferred In units during week 9 ? Costs added during week 9 $ 105,000 $ 14.000 $ 52,850 13 15 16 Equivalent Units of Production Total Transferred In Seasoning Conversion ? 71% 17 Completed units during week 9 197,800 18 13 Ending work in process units, wed 128,000 20 Degree (percentage) of completion 21 22 Other possible % complete for cos! 0% 23 50% 100% 10% 60% 20% 70% 30% 80% 40% 90% 24 Cost per E.U.P D E F G H 1 M N 0 Total B C 25 (2) 26 units sold during week 9 140,000 27 selling price per unit S 1.99 28 29 REQUIRED: 30 (1) 31 Prepare a Production Report for the Cooking department week 9 using the weighted average method and prepare any 32 resulting journal entry. 33 (2) 34 Based on your calculations, would the company achieve a gross profit on this product of 75% in week 9? 35 Show your gross profit calculation. 36 37 38 Costs Accounted for: Transferred Out WIP - ending Transferred In Seasoning Conversion Journal Entry Debit Credit Part (2) Would the company achieve a 75% gross profit in week 9? Show calculations 39 Wording to be referenced in completing your production report: 40 Conversion 41 Costs added 42 Costs to be Accounted for: 43 Equivalent Units of Production 44 Seasoning 45 Transferred In 46 Transferred Out 47 Units Accounted for: 48 Units Started into production 49 Units to be Accounted for: 50 WIP-beginning 51 WIP-ending 52 Gross Profit