Solve all accordingly please and cell reference

the name of all accounts are shown from A40-A51

Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity K4 X fx A B D G H 1 M N 0 Q R 1 Given Data: Required Part (1) WIP - beginning 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: Quantity Schedule 6 Seasoning is added when the conversion costs are 85% complete 7 Equivalent Units of Production Transferred In Seasoning Conversion Total 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): 10 Transferred in Seasoning Conversion 11 Units costs 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 13 16 Equivalent Units of Production 204,400 128,000 Total Transferred In Seasoning Conversion 17 Completed units during week 9 18 19 Ending work in process units, week 9 20 Degree (percentage) of completion 21 22 Other possible % complete for costs: 23 ? 2. 98% 0% 50% 100% 10% 60% 20% 70% 30% 80% 40% 90% 24 Cost per E.U.P 140,000 1.99 $ Total 25 (2) 26 units sold during week 9 27 selling price per unit 28 29 REQUIRED: 30 (1) Costs Accounted for: Transferred Out WIP - ending Transferred In Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity K4 X fx A B D G H 1 M N 0 Q R 1 Given Data: Required Part (1) WIP - beginning 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: Quantity Schedule 6 Seasoning is added when the conversion costs are 85% complete 7 Equivalent Units of Production Transferred In Seasoning Conversion Total 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): 10 Transferred in Seasoning Conversion 11 Units costs 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 13 16 Equivalent Units of Production 204,400 128,000 Total Transferred In Seasoning Conversion 17 Completed units during week 9 18 19 Ending work in process units, week 9 20 Degree (percentage) of completion 21 22 Other possible % complete for costs: 23 ? 2. 98% 0% 50% 100% 10% 60% 20% 70% 30% 80% 40% 90% 24 Cost per E.U.P 140,000 1.99 $ Total 25 (2) 26 units sold during week 9 27 selling price per unit 28 29 REQUIRED: 30 (1) Costs Accounted for: Transferred Out WIP - ending Transferred In