EXCEL OR TABLES.

I WOULD LOVE TO LEARN. SHOW THE PROCESS TO SOLVE IT, PLEASE. :)

Schedule of Cost of Goods Manufactured and Sold At December 31, 2019, the end of its fiscal year, Kelly Metal Products Corporation collected the following data for 2019: Materials inventory, January 1 Materials inventory, December 31 Work-in-process inventory, January 1 Work-in-process inventory, December 31 Finished goods inventory, January 1 Finished goods inventory, December 31 Net delivered cost of materials purchased Direct labor.. Indirect materials Indirect labor. Factory supplies used. Factory depreciation. . Factory repairs and maintenance. Selling expenses (total) Non-factory administrative expenses (total). $ 32,000 22,000 34,000 45,000 21,000 18,000 210,000 190,000 13,000 25,000 12,000 78,000 28,000 63,000 57,000 Required Prepare a schedule of cost of goods manufactured and sold for Kelly Metal Products Corporation for the year ended December 31, 2019, assuming that there were no other manufacturing overhead items than those listed above