I need major help with using excel fomulas to submit this assignment

Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. H18 x G I B D E F Excel formulas must be used. Please be sure to submit your file as an Excel file. Any submissions in numbers format will receive a 0 1 2 3 4 5 MFG Student Name => Section Number > Data Section: 8 Depreciation equipment Direct labor Direct materials inventory, 1/1 Direct materials inventory. 12/31 Factory rent Finished goods, 1/1 Finished goods, 12/31 Indirect labor Indirect materials Purchases of direct materials Work in process, 1/1 Work in process, 12/31 $45,000 642,000 91,500 93,000 76,410 132,000 172,500 37,500 26,250 645,180 30,300 28,665 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Answer Section: Jackson Manufacturing Schedule of Cost of Goods Manufactured and sold For the Year Ended December 31 30,300 Work in process, 1/1 Direct materials Direct materials inventory, 1/1 Add: Purchases of Materials 91,500 FORMULA1 Cost of direct materials available Less: Direct Material, 12/31 $0 FORMULA2 35 36 37 38 39 40 Cost of direct materials used Direct labor Manufacturing overhead: Factory rent FORMULAS 642,000 $76,410 MFG + puate G68 4 x fx A E G H I 30,300 30 31 32 B Work in process, 1/1 Direct materials Direct materials inventory, 1/1 Add Purchases of Materials 91,500 FORMULA1 34 35 36 37 Cost of direct materials available Less: Direct Material, 12/31 $0 FORMULA2 FORMULAS 642,000 Cost of direct materials used Direct labor Manufacturing overhead: Factory rent Depreciation - Equipment Indirect Labor Indirect Material $76,410 FORMULA FORMULAS FORMULAG 0 Total manufacturing costs incurred FORMULAZ Total manufacturing costs Less Work in Process, 12/31 $0 FORMULAR Cost of goods manufactured Finished Goods, 17 FORMULA FORMULA 10 39 40 41 42 43 44 45 46 47 4R 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 60 65 66 Cost of goods available for sale Less: Finished goods, 12/31 Cont of Goods Sold FORMULA 11 172,500 FORMULA12 RRRRRRR SP