please solve B and C part

P2.45A (L0.4) Excel The following data were taken from the records of Stellar Manufacturing Company for the fiscal year ended December 31, 2022: Raw Materials Inventory (1/1/22) $ 47,000 Factory Machinery $ 7,700 Depreciation Raw Materials Inventory 44,800 Factory Utilities 12,900 (12/31/22) Finished Goods Inventory 85,000 Office Utilities 8,600 (1/1/22) Finished Goods Inventory 77,800 Sales 465,000 (12/31/22) Work in Process Inventory 9,500 Sales Discounts 2,500 (1/1/22) Work in Process Inventory 7,500 Factory Manager's Salary 40,000 (12/31/22) Direct Labour 145,100 Factory Property Taxes 6,900 Indirect Labour 18,100 Factory Repairs Accounts Receivable 27,000 Raw Materials Purchases 62,500 Factory Insurance 7,400 Cash 28,000 Instructions a. Prepare a cost of goods manufactured schedule. (Assume all raw materials used were direct materials.) a. CGM $305,600 b. Prepare an income statement through gross profit. b. Gross profit $149,700 c. Prepare the current assets section of the balance sheet at December 31, 2022. c. Current assets $185,100 800