please help. can you show your solution through excel formula. that might help thank you!

Required: Supply the missing data in the following cases. Each case is independent of the others. Case 2 3 4 Direct materials 5 4 000 S 6.300 5.300 3 3.300 Direct labour 3,300 7.300 4,300 Manufacturing overhead 5.300 DOF F 9,300 Total manufacturing costs 18.600 20.300 Beginning work in-process inventory 2.800 2.150 3.300 Ending work-in-process inventory 1.300 3, 150 Cast of goods manufactured 18.300 19.300 Sales 30.2no 22,500 36,300 40 300 Beginning finished goods inventory 1.JOU 2 800 Cost of goods manufactured 10. 100 Goods available for sale 20 400 Ending finished goods inventory 1.no0 4,300 3.800 Cost of gouds sold 50% Gross margin 405% Operating axpertins 3,750 Net Income 4,300 5.600 3 9 300