kindly solve this question on EXCEL as soon as possible. Thank you in advance. i'll surely give u thumbs up. URGENT HELP REQUIRED

04 Hamza wants you to value his closing inventory. During the month of July he had the following inventory: 20 units of Material A cost 2.20 per unit, expected selling price 4. 35 units of Material B cost 5.20 per unit, expected selling price 6.20. 35 units of Material C cost 3.80 per unit, expected selling price 4. 70 units of Material D cost 9.40 per unit, expected selling price 9. Hamza expects selling costs of 10% on all selling prices. Required: 9. Calculate the closing inventory for the month of July. (23 marks) b. Briefly explain where we expect to see closing inventory in the financial statements. (2 marks) (Question total: 25 marks)