Need the answers before 8pm!! please add the cell reference as the calculs explanation!!
A B C D E G 1 Given Data: 5 7 2 Humpty Dumpty Inc. manufactures Yummy potato chips 3 Production of the potato chips occurs in three departments: Cleaning Cooking and Packaging 4 Consider the Cooking department where the "seasoning materials are added, more specifically 6 leasoning is added when the conversion costs are 85% complete 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 12 Beginning work in process, week 9 125,000 $ 70.000$ $ 8.750 Degree (percentage) of completion 0% 35% 14 Transferred in units during week 9 15 Costs added during week 9 $ 105,000 $ 14.000 $ 52,850 10 11 costs 13 ? 16 17 Completed units during week 9 197 200 18 19 Ending work in process units, week 128,000 20 Degree (percentage) of completion - 74% B c D E E F 03 90% 20 Degree (percentage) of completion ? 2 74% 21 22 Other possible % complete for costs. 0% 10% 20% 30% 40% 23 50% 60% 70% 80% 24 100% 25 (2) 26 units sold during week 9 140,000 27 selling price per unit 1.99 28 23 REQUIRED: 30 (1) 31 Prepare a Production Report for the Cooking department week 9 using the weighted-average method and prepare ar 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 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 M N Required Part (1) Quantity Schedule tments Cleaning, Cooking and Packaging ning materials are added, more specifically complete Total Equivalent Units of Production Transferred in Seasoning Conversion bry provided the following information for jalapeno ing a weekly penod (Week 9) Transferred in Seasoning Conversion costs costs 5 70 0005 $ 8.750 0% $ 105000S 140005 52 850 Equivalent Units of Production O G 11 Total Tansferred in Seasoning Conversion 2 74% 21 10% 60% 20% 70% 30% B0% 40% 90% Cost per EUP Total Costs Accounted for Transferred Out WP-ending Transferred in tment week 9 using the weighted average method and prepare ar Seasoning Conversion 30 Buleve a gross profit on this product of 75% sr week 97 Mb Debit Credit Journal Entry 3 on report Part (2) Would the company achieve a 75% gross profit in week 97 Show calculations 0 4 - 47 Gross Profit
