befor 11pm please!! show Exceel formular as explanation

D E F LL A B 1 Selected ledger accounts for Serenade Processing Company 2 are given below for the year ended October 31, 2021: 3 Raw Materials 4 5 Open $ 20,000 6 Debits 630,000 596,040 Credits 7 7 8 Close $ 53,960 9 9 10 WIP - Mixing Department 11 $ Open Direct materials 12 50,000 330,000 $ 860,000 Credits 200,000 400,000 13 Direct labour 14 . Applied Overhead 15 Close $ 120,000 16 A B D E E LL G 17 WIP - Finishing Department $ 60,000 18 19 Open Transferred in Direct materials Direct labour 20 860,000 200,000 $ 1,350,720 Credits 120,000 240,000 21 22 Applied Overhead 23 Close $ 129,280 24 25 Finished Goods 26 $ 40,000 Open Debits 27 1,350,720 1,260,720 Credits 28 Close $ 130,000 29 D G EF C B 29 30 Manufacturing Overhead $ 688,200 640,000 Credits 31 Debits 32 33 Close $ 48,200 Close 34 35 36 Factory Wages Payable $ 10,000 Open 389,000 383,920 Credits 37 Debits 38 39 40 $ (956,800) Close 41 F48 D E B B 41 42 Cost of Goods Sold 43 $ Open Debits 44 1,260,720 $ 1,260,720 45 Close 46 47 48 49 50 51 G L M H N 1 Required: You have the option of doing some or all of your calculations with the use of the above t-accounts, or cell reference your calculations 2 directly to the amounts provided within the t-accounts. 3 1 What was the cost of indirect materials put into production during the year? 5 2 What was the cost of goods manufactured for the year? 4 6 7 8 3 How much of the factory labour cost for the year consisted of indirect labour? 9 10 4 What was the balance in the manufacturing overhead account? Was manufacturing overhead underapplied or overapplied? 11 12 13 S What was the cost of goods sold for the year (before considering underapplied or overapplied overhead)? 14