The following data were taken from the records of Cheyenne Company for the fiscal year ended June 30, 2022. $54,600 $4,700 44,200 17,700 96,800 31,600 26,300 8,550 Raw Material Inventory 7/1/21 Raw Material Inventory 6/30/22 Finished Goods Inventory 7/1/21 Finished Goods Inventory 6/30/22 Work in Process Inventory 7/1/21 Work in Process Inventory 6/30/22 Direct Labor Indirect Labor Accounts Receivable 24,600 562,900 Factory Insurance Factory Machinery Depreciation Factory Utilities Office Utilities Expense Sales Revenue Sales Discounts Plant Manager's Salary Factory Property Taxes Factory Repairs Raw Material Purchases 29,600 4,600 147,050 65,400 25,630 9,610 35,300 2,500 98,100 Cash 36,300 Prepare a cost of goods manufactured schedule.(Assume all raw materials used were direct materials CHEYENNE COMPANY Cost of Goods Manufactured Schedule Cost of Goods Manufactured Direct Labor Direct Materials $ Direct Materials Used $ Factory Machinery Depreciation Factory insurance Factory Property Taxe Factory Repairs Factory Utilities Indirect Labor Manufacturing Overhead Plant Manager's Salary Raw Materials inventory, July 1, 2021 Raw Materials inventory, June 30, 2022 Raw Materials Purchases Total cost of Work in Process inventory Total Manufacturing Costs Total Manufacturing Overhead Total Raw Materials Available for Use Work in Process, July 1, 2021 Work in Process, June 30, 2022 Finished Goods inventory, July 1, 2021 Finished Goods Inventory, June 30, 2022 Office Utilities Expense Sales Revenue Accounts Receivable Sales Discounts Cash