cell reference please

Humpty Dumpty Inc. manufactures yummy potato chips Production of the potato chips occurs in three departments Cleaning, Cooking and Packaging Consider the Cooking department, where seasoning materials are added, more specifically Seasoning is added when the conversion costs are 80% complete 0 The accounting records of the Humpty Dumpty factory provided the following information for jalapeno flavoured potato chips in its Cooking department during a weekly period (week 9) Transferred in Seasoning Conversion 1 Units costs costs costs 2. Beginning work in process, week 9 125000 $ 70,000 $ $ 8.750 13 Degree (percentage) of completion 0% 35% 34 Transferred In units during week 9 2 5 Costs added during week 9 $ 105,000 $ 14,000 $ 52,850 16 17 Completed units during week 9 210,000 10 136,000 2 2 70% 19 Ending work in process units, week 9 20 Degree (percentage) of completion 21 22 Other possible % complete for costs 23 24 25 (2) 26 units sold during week 9 27 selling price per unit 0% 50% 100% 10% 60% 20% 70% 30% 80% 40% 90% 140,000 1.99 29 REQUIRED: 30 (1) 31 Prepare a Production Report for the Cooking department week 9 using the weighted average mhod and prepare any 32 resulting journal entry 3 (2) Prepare a Production Report for the Cooking department week 9 using the weighted average method and prepare any 2 resulting journal entry. 3 (2) Based on your calculations, would the company achieve a gross profit on this product of 75% in week 9? 5 Show your gross profit calculation 6 7 8 9 Wording to be referenced in completing your production report: 0 Conversion #1 Costs added 2 Costs to be Accounted for: 33 Equivalent Units of Production - Seasoning 25 Transferred In 46 Transferred Out 47 Units Accounted for: -48 Units Started into production 19 Units to be Accounted for: 50 WIP - beginning 51 WIP - ending 52 53 54 55 56 57 58 59 Part (1) Quantity Schedule Equivalent Units of Production Transferred In Seasoning Conversion Total Equivalent Units of Production Total Transferred In Seasoning Conversion Cost per EU.P Total Costs Accounted for Transferred Out WIP ending Transferred in Seasoning Conversion Credit Debit Journal Entry Part (2) Would the company achieve a 75% gross profit in week 9? Show.calculations Gross Pront