please answer it using word or excel thank you

1) Messinger Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise noted: (15 Marks) Work-in-prccess inventory (January 1) $140,400 Worlein-process inventory (March 31) 171,000 Finished goods inventory (January 1) 540.000 Finished goods inventory (March 31 ) 510,000 Direct materials used 3?B,000 Indirect materials used 84,000 Direct manufacturing labour 480,000 Indirect manufacturing labour 186.000 Property taxes on manufacturing plant building 28,800 Salespersons' company vehicle costs 12.000 Amortization of manufacturing equipment 264,000 Amortization of ofce equipment 123.600 Miscellaneous plant overhead 135.000 Plant utilities 92,400 General ofce expenses 305.400 Marketing distribution costs 30,000 Required: a. Prepare a cost of goods manufactured schedule for the quarter. b. Prepare a cost of goods sold schedule for the quarter