An analysis of the accounts of Williams Company reveals the following manufacturing cost data for the month ended September 30, 2020. Inventories Raw materials Beginning $12,800 7,700 Ending $11,200 5,300 Work in process Finished goods 10,100 12,600 Costs incurred: raw materials purchases $58,400, direct labor $54,700, manufacturing overhead $26,000. The specific overhead costs were: indirect labor $6,400, factory insurance $4,900, machinery depreciation $6,100, machinery repairs $2,900, factory utilities $4,000, miscellaneous factory costs $1,700. Assume that all raw materials used were direct materials. (a) Your answer is correct. Prepare the cost of goods manufactured schedule for the month ended September 30, 2020. Williams Co. Cost of Goods Manufacturing Schedule For the Month Ended September 30, 2020 Work in Process 9/1/20 7700 Direct Materials Raw Materials Inventory 9/1/20 12800 Add v Raw Materials Purchases 58400 CALCULATOR PRINTER VERSION 4 BACK NE Total Raw Materials Available for Use 71200 Less Raw Materials Inventory 9/30/20 11200 Direct Materials Used 60000 Direct Labor 54700 Manufacturing Overhead V Indirect Labor 6400 M Factory Insurance 4900 Machine Depreciation 6100 Factory Utilities 4000 Machine Repairs 2900 Miscellaneous Factory Costs V 1700 Total Overhead 26000 Total Manufacturing Costs V 140700 Total Cost of Work in Process 148400 Less Work in Process 9/30/20 5300 1 143100 Cost of Goods Manufactured (b) Your answer is correct. Show the presentation of the ending inventories on September 30, 2020, balance sheet. Williams Co. Balance Sheet Presentation (partial) September 30, 2020 Inventories Finished Goods Inventory 12600 Work in Process Inventory 5300 Raw Materials Inventory 11200 Total Inventories 29100 (ci) Williams Company is considering the purchase of a new automated assembly line for its factory. The purchase would result in several changes in Williams' cost structure. Both direct labor and indirect labor would decrease by 40%. Factory insurance would increase to $8,100, machinery depreciation would double, machinery repairs would decrease to $400, utilities would decrease to $2,200 and miscellaneous factory costs would increase to $1,800. Materials usage would remain at current levels. Analyze the new purchase by preparing a cost of goods manufactured schedule for September 30, 2020 using the new data. Williams Co. Cost of Goods Manufacturing Schedule For the Month Ended September 30, 2020 Work in Process 9/1/20 $ Direct Materials Raw Materials Inventory 9/1/20 Add Raw Materials Purchases Total Raw Materials Available for Use Less Raw Materials Inventory 9/30/20 Direct Materials Used $ Direct Labor Manufacturing Overhead Indirect Labor A Factory Insurance Machine Depreciation Factory Utilities Machine Repairs Miscellaneous Factory Costs Total Overhead Total Manufacturing Costs Total Cost of Work in Process Less Work in Process 9/30/20 Cost of Goods Manufactured