You have been asked by the CEO of Mountaineer Co. to assist in analyzing product costs. This analysis is used in internal decision making and in reporting to investors. The following Tableau Dashboard provides data needed for the analysis Raw Materials Inventories Raw materials, beginning Raw materials purchases Raw materials used Raw materials, ending $0 $25,000 $50,000 $75,000 $100,000 $125,000 $150,000 $175,000 $200,000 Work in Process & Finished Goods Inventories Work in Process Finished Goods Rent expense - Factor 550,000 54,000 50,000 $40,000 43,009 Repairs expense -Factory 530,000 33.000 Factory supplies used indirect materials) Factory utilities 520,000 $10,000 50,000 $40,000 43,000 $30,000 33,000 Factory utilities $20,000 $10,000 SO Beginning Ending Beginning Ending Indirect labor Additional Data Accounts receivable, net $150,000 Cash $350,000 Direct labor $180,000 Sales and Select Expense Accounts Sales General & administrative expenses Selling expenses $0 5200,000 $400,000 $600,000 $800,000 $1,000,000 tableau epare a schedule of cost of goods manufactured for the current year ended December 31 List individual overhead account balan Prepare a schedule of cost of goods manufactured for the current year ended Decem in the schedule. aineer CO Schedule of Cost of Goods Manufactured For Year Ended December 31 Direct materials Raw materials inventory, beginning Raw materials purchases Raw materials available for use Less: Raw materials inventory, ending Direct materials used Direct labor Factory overhead Rent expense - Factory Factory utilities Repairs expense - Factory Indirect labor Repairs expense - Factory Factory supplies used indirect materials Total factory overhead costs Total manufacturing costs Work in process inventory, beginning Total cost of work in process Less: Work in process inventory, ending Cost of goods manufactured Additional Data Antec Cash $150.000 $350,000 $180,000 Sales and Select Expense Accounts Sales General & administrative expenses Selling expenses $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 tableau 1 of Compute cost of goods sold for the current year ended December 31. Note: use cost of goods manufactured calculated in part 1 Mountaineer Co. Computation of Cost of Goods Sold For Year Ended December 31 Cost of goods sold Goods available for sale Cost of goods sold Sales and Select Expense Accounts Sales General & administrative expenses Selling expenses $200,000 $400,000 $600,000 $0 $800,000 $1,000,000 tableau Prepare an income statement for the company. Note: use cost of goods sold calculated in part 1 Income Statement Cost of goods sold: Cost of goods available for sale Cost of goods sold Operating expenses