I am struggling with the correct formulas for this question. Please use excel and show the formulas. Thank you so much!!

Ch. 18 - Manufacturing Statement Richards Company manufactures a single product. All raw materials used are traceable to specific units of product. Current information for the company follows: 2 Beginning raw materials inventory Ending raw materials inventory Raw material purchases Beginning work in process inventory Ending work in process inventory Direct labor Advertising expense Indirect labor Factory Maintenance Factory Utilities Sales comissions 5 Office Rent Factory Equipment Depreciation Sales Beginning finished goods inventory Ending finished goods inventory 1 Calculate the following: 1) direct materials used 2) factory overhead 5 3) cost of goods manufactured 5 4) cost of goods sold 7 5) gross profit 25,600 27,000 105,000 55,000 40,000 145,000 21,000 12,000 17,500 24,000 13,000 18,500 14,900 540,000 71,300 86,500 7 3 3 1 B