please show on a microsoft excel sheet if possible :(

be classified and reported E14-98 The following information is available for Collins Company. January 1, 2017 2017 December 31, 2017 $22,000 $30,000 20,300 17,200 27,000 Raw materials inventory Work in process inventory Finished goods inventory Materials purchased Direct labor Manufacturing overhead 29,000 $170,000 200,000 183,000 Sales revenue 875,000 Instructions (a) Compute cost of goods manufactured. (b) Prepare an income statement through gross profit. (c) Show the presentation of the ending inventories on the December 31, 2017 balance sheet. (d) How would the income statement and balance sheet of a merchandising company be different from Laurel's financial statements? E14-108 An analysis of the ma Prepare a cost of goods manufactured schedule and a partial income statement. (LO 3)