please solve a

P2.45A ( LO4) Excel The following data were taken from the records of Stellar Manufacturing Company for the fiscal year ended December 31,2022 : Raw Materials 44,800 Factory Utilities 12,900 Inventory (12/31/22) Finished Goods 85,000 Office Utilities 8,600 Inventory (1/1/22) Finished Goods 77,800 Sales 465,000 Inventory (12/31/22) Work in Process 9,500 Sales Discounts 2,500 Inventory (1/1/22) Inventory (12/31/22) Manager's Salary Direct Labour 145,100 Factory Property 6,900 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