Please use Excel to solve this questions

QUESTION ONE (continued) BlueScope is subject to 30% company tax. BlueScope Steel Limited Pre-closing Account Balances October 31. Cash and Marketable securities 54,000 Accounts and notes receivable 210,000 Property, plant, and equipment (net) 1, 140,000 Accounts, notes, and taxes payable 70,000 Bonds Payable 582,000 Paid-in capital 100,000 Retained earnings 930,000 Sales 1,488,000 Cost of goods sold 1,112,000 Purchases of direct materials 510,000 Total Manufacturing Cost 1, 100,000 Direct Labor 260,000 Indirect factory labor 90,000 Office salaries 122,000 Sales salaries 42,000 Utilities 135,000 Rent 9,000 Property tax 60,000 Insurance 20,000 Depreciation 54,000 Office supplies expense 6,000 REQUIRED: A. Prepare a Schedule of Cost of Goods Manufactured for October. B. Prepare a Schedule of Cost of Goods Sold for October. C. Prepare an Income Statement for the month of October