I need help with all of the yellow on question 2 can you put them all in formulas from excell. using SUM

$ 275,000 25,000 27,760 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost 6 Estimated total direct labor hours 7 Actual total direct labor hours 8 9 Actual costs for the year: 10 Purchase of raw materials (all direct) 11 Direct labor cost 12 Manufacturing overhead costs 13 14 Inventories: Beginning 15 Raw materials (all direct) $ 15,000 16 $ 27,875 Finished goods $ 34,600 $375,000 $536,300 $302,750 Work in process Ending 11,375 22,350 26,450 $ $ $ 17 18 29 2. Prepare a schedule of cost of goods manufactured: 30 31 Stanford Enterprises 32 Schedule of Cost of Goods Manufactured 33 Direct materials: 34 Raw materials inventory, beginning 35 Add: Purchases of raw materials 36 Total raw materials available 37 Deduct: Raw materials inventory, ending 38 Raw materials used in production 39 Direct labor 40 Manufacturing overhead applied to work in process 41 Total manufacturing costs 42 Add: Beginning work in process inventory 43 44 Deduct: Ending work in process inventory 45 Cost of goods manufactured 46