EXCEL CELL REFERENCE ANSWER PLEASE.

PLEASE ANSWER THE REQUIRED

4 A B D E F G H I J K L M N 1 Selected ledger accounts for Serenade Processing Company 2 are given below for the year ended October 31, 2021: 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 directly to the amounts provided within the t-accounts. 3 4 Raw Materials 1 What was the cost of indirect materials put into production during the year? 5 $ Open Debits 20,000 630,000 ? Credits 2 What was the cost of goods manufactured for the year? 7 8 Close $ 53,540 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? 111 12 Open Direct materials WIP - Mixing Department $ 50,000 330,000 ? Credits 200,000 400,000 $ 120,000 13 Direct labour 5 What was the cost of goods sold for the year before considering underapplied or overapplied overhead)? 14 Applied Overhead Close 15 B C D F G H H 17 18 19 E WIP - Finishing Department $ 60,000 ? 200,000 ? Credits 120,000 240,000 $ 128,845 Open Transferred in Direct materials Direct labour Applied Overhead Close 20 21 22 23 24 25 Finished Goods 40,000 26 $ 27 Open Debits Close ? Credits 28 $ 130,000 29 30 Manufacturing Overhead $ 688,050 ? Credits 31 Debits 32 33 Close Close 34 B C D E F G 32 33 Close Close 34 35 36 Factory Wages Payable $ 10,000 Open 389,000 383,830 Credits 37 Debits 38 39 40 ? Close 41 42 Cost of Goods Sold 43 $ 44 Open Debits Close 45 ? 46 47 48 49