please answer in excel format only!!

Question 3 At May 31, 2020, the accounts of Lopez Company show the following. 1. May 1 inventories - finished goods $12,600, work in process $14,700 and raw materials $8,200. 2. May 31 inventories - finished goods $9,500, work in process, $15,900, and raw materials $7,100. 3. Debit postings to work in process were direct materials, $62,400, direct labor $50,000, and manufacturing overhead applied $40,000. 4. Sales revenue totaled $215,000. Instructions (a) Prepare a condensed cost of goods manufactured schedule. (b) Prepare an income statement for May through gross profit. (c) Indicate the balance sheet presentation of the manufacturing inventories at May 31, 2020. NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 30 11 13 24 25 26 27 30 2 31 34 35 M 3 M 41 COEGERUSSE 42 (4) Prepare a condensed cost of goods manufactured schedule Work in process, May 1 Direct materials used Dured labor Value Value Value 9 Manufacturing overhead applied Total manufacturing costs Total cost of work in process Less Work in process, May 31 9 Value Cost of goods manufactured 9 (b) Prepare an income statement for May through gross profit Value Sales revenue. Cost of goods sold Value Finished goods May 1 Cost of goods nufactured: 2 Cost of goods available for sale 9 Less: Finished goods, May 21 Value Cost of goods sold Gross proft ri 8.80 Activate Windows