please do it excel

P19.4A (LO 3) The following data were taken from the records of Clarkson Company for the fiscal year ended June 30, 2020. Prepare a cost of goods manufactured schedule, a partial income statement, and a partial balance sheet. Excel $ 4,600 $ 48,000 39,600 96,000 Raw Materials Inventory 7/1/19 Raw Materials Inventory 6/30/20 Finished Goods Inventory 7/1/19 Finished Goods Inventory 6/30/20 Work in Process Inventory 7/1/19 Work in Process Inventory 6/30/20 Direct Labor Indirect Labor Accounts Receivable Factory Insurance Factory Machinery Depreciation Factory Utilities Office Utilities Expense Sales Revenue Sales Discounts Plant Manager's Salary Factory Property Taxes Factory Repairs Raw Materials Purchases Cash 16,000 27,600 8,650 534,000 4,200 58,000 9,600 1,400 96,400 32,000 75,900 19,800 18,600 139,250 24,460 27,000 Instructions a. Prepare a cost of goods manufactured schedule. (Assume all raw materials used were direct materials.) b. Prepare an income statement through gross profit. c. Prepare the current assets section of the balance sheet at June 30, 2020. a. CGM $386,910 b. Gross profit $122,790 c. Current assets $193,100 nnnn