What is the ending Balance for the Inventory Accounts.

Supreme Technology Company uses a job order cost system. The following data summarize the operations related to production for March: a. Materials purchased on account, $60,000. b. Materials requisitioned, $32,000, of which $9,000 was for general factory use. c. Factory labor used, $40,000, of which $18,000 was indirect. d. Other costs incurred on account for factory overhead, $12.500; selling expenses, $6,000; and administrative expenses, $194,570. e. Prepaid expenses expired for factory overhead were $14,000; for selling expenses, $14,000; and for administrative expenses, $26,000. f. Depreciation of factory equipment was $25,000; of office equipment, $19,000, and of office building, $18,000. 9. Factory overhead costs applied to jobs, $39,000. h. Jobs completed $40,000. 1. Cost of goods sold, $35,000. Balances of Inventory accounts as of March 1: Materials - $21,300 Work-in-Process - $25,200 Finished Goods - $26,100 Factory Overhead - $18,300 Instructions: A) Journalize the transactions above. (excel attached) B) Report the ending balances of all inventory accounts