Please complete in excel and Include formulas as well please and i will be sure to like the solution! thank you so so much

Fa.9 (1.01. 5), AP At May 31, 2022, the accounts of Loper Conpaay show the followiag- 1. May 1 inventories -finished goods 512,600 , work in process $14,700, and nuw materials $8,200. 2. May 31 ventories - finiahed g0ods $9,500, work in process $15,900, and raw materials $7,100. 3. Debit postinga to work in process were direct materials $62,400, direct labor $50,000, and marufacturing overhesd applied $40,000. (Assime that overbead applied was equal to everhead incurred.) 4. Sales reveaue totaled \$2is.000. Instructions a. Prepare a coodensed cost of goods manufactured schedule for May 2022. b. Prepare an income statement for May 202z through gross profit. c. Prepare the balance sheet mection of the manufacturing inventories at May 31,2022. Compute isork in process and funished goods frum job cost sheets