An analysis of the accounts of Lily Company reveals the following manufacturing cost data for the month ended September 30, 2020. Inventories Beginning Ending Raw materials $13,600 $12,900 Work in process 9,100 6,600 Finished goods 11,600 13,600 Costs incurred: raw materials purchases $64,100, direct labor $52,600, manufacturing overhead $35,250. The specific overhead costs were: indirect labor $8,100, factory insurance $6,600, machinery depreciation $7,600, machinery repairs $4,400, factory utilities $5,200, miscellaneous factory costs $3,350. Assume that all raw materials used were direct materials. Lily Company is considering the purchase of a new automated assembly line for its factory. The purchase would result in several changes in Lily' cost structure. Both direct labor and indirect labor would decrease by 40%. Factory insurance would increase to $9,600, machinery depreciation would double, machinery repairs would decrease to $660, utilities would decrease to $4,100 and miscellaneous factory costs would increase to $3,450. 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. Lily 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 Direct Labor Manufacturing Overhead Indirect Labor Factory Insurance Machine Depreciation Factory Utilities Machine Repairs Miscellaneous Factory Costs Total Manufacturing Overhead Total Manufacturing Costs Total Cost of Work in Process Less : Work in Process 9/30/20 Cost of Goods Manufactured $