please show working as it is excel based
B C D E F H 1 K M N Part (1) 2 Humpty Dumpty Inc. manufactures Yummy potato chips. 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 4 5 easoning is added when the conversion costs are 85% % complete 7 Equitalst Uitz of Productie Transferredlo Seasoning Conversion Total 8 9 11 13 Total Transferred In Seasoning Conversion 20 88% 204 $ 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 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 week9 $ 105,000 $ 14.000 $ 52,850 16 Equivalent Units of Production 17 Completed units during week 9 200,400 18 19 Ending work in process units, week 128,000 Degree (percentage of completion ? ? 21 22 Other possible % complete for costs 02 102 40% 50% 602 70% 802 90% 24 100% Cost per E.U.P 25 (2) 26 units sold during week 9 140,000 27 selling price per unit $ 1.99 Costs Accounted for: 28 Transferred Out 29 REQUIRED: WIP-ending 30 (1) Transferred In 31 Prepare a Production Report for the Cooking department week 9 using the weighted average method and prepare a Seasoning 32 resulting journal entry. Conversion 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. Journal Entry 36 37 23 Total Debit Credit Part (2) Would the company achieve a 15% gross profit in week 9? Show calculations 39 Yording 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 Gross Profit B C D E F H 1 K M N Part (1) 2 Humpty Dumpty Inc. manufactures Yummy potato chips. 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 4 5 easoning is added when the conversion costs are 85% % complete 7 Equitalst Uitz of Productie Transferredlo Seasoning Conversion Total 8 9 11 13 Total Transferred In Seasoning Conversion 20 88% 204 $ 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 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 week9 $ 105,000 $ 14.000 $ 52,850 16 Equivalent Units of Production 17 Completed units during week 9 200,400 18 19 Ending work in process units, week 128,000 Degree (percentage of completion ? ? 21 22 Other possible % complete for costs 02 102 40% 50% 602 70% 802 90% 24 100% Cost per E.U.P 25 (2) 26 units sold during week 9 140,000 27 selling price per unit $ 1.99 Costs Accounted for: 28 Transferred Out 29 REQUIRED: WIP-ending 30 (1) Transferred In 31 Prepare a Production Report for the Cooking department week 9 using the weighted average method and prepare a Seasoning 32 resulting journal entry. Conversion 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. Journal Entry 36 37 23 Total Debit Credit Part (2) Would the company achieve a 15% gross profit in week 9? Show calculations 39 Yording 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 Gross Profit
