Please prepare statement in excel format

Problem 15 Check course schedule for due date. Use the working papers provided The following data were taken from the records of Flexsteel Manufacturing Company for t year ended May 31, 2016. Factory Insurance Plant Manager's Salary Operating Expenses Sales Discounts Factory Property Taxes Raw Materials Purchases $7,000 4,000 30,000 12,900 100,000 475,000 2,500 5,000 6,000 1,000 67,500 28,000 2,000 27,000 Raw Materials $47,000 Factory Mach-Depreciation Raw Materials Finished Goods Finished Goods Inventory 6/1/15 Inventory 5/31/16 Inventory 6/1/15 Inventory 5/31/16 44,000 Factory Utilities 85,000 Sales Revenue 77,000 Short-term investments Work in Process 9,500 Factory Repairs 8,000 Caslh 18,000 Accounts Receivable Inventory 6/1/15 Work in Process Inventory 5/31/16 Direct Labor Indirect Labor 145,000 Prepaid Expenses Instructions (a) Prepare a cost of goods manufactured schedule. (Assume all raw materials used were dire materials.) (b) Prepare an entire income statement through net income (c) Prepare the current asset section of the balance sheet at May 31, 2016