All questions must be answered in this Excel file and referencing

A B C D E F G H L M N 1 Given Data: Required Part (1) Quantity Schedule 85% Total Equivalent Units of Production Transferred In Seasoning Conversion 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: 5 6 Seasoning is added when the conversion costs are complete 7 8 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 11 Units costs costs costs 12 Beginning work in process, week 9 125,000 $ 70,000 $ $ 8,750 13 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 % 16 Equivalent Units of Production 17 Completed units during week 9 209,200 18 128,000 Total Transferred In Seasoning Conversion 2 74% 0% 50% 100% 10% 60% 20% 70% 30% 80% 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 28 29 REQUIRED: 40% 90% Cost per E.U.P 140,000 1.99 Total Costs Accounted for: Transferred Out WIP - ending J L M N K Total H Costs Accounted for: Transferred Out WIP - ending Transferred In Seasoning Conversion Journal Entry Debit Credit A B D G 27 selling price per unit $ 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 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 53 54 55 56 57 Part (2) Would the company achieve a 75% gross profit in week 9? Show calculations Gross Profit % 50