please answer questions in yellow with the excel formula to get said answer.

thank you so much in advance

1 2 Stanford Enterprises uses job-order costing. 3 Overhead is applied on the basis of direct labor hours. 4 5 The following information relates to the year just ended. 6 Data: 7 Estimated total overhead costs 8 Estimated total direct labor hours 9 Actual total direct labor hours 10 11 Actual costs for the year: 12 13 Purchase of raw (direct) materials Direct labor cost Manufacturing overhead 14 15 16 Inventories: 17 Raw (Direct) Materials 18 Work in Process Finished Goods $275,000 25,000 27,760 19 20 21 Required: 22 Use the data to fill in the following information. 23 $375,000 $536,300 $302,750 Beginning $15,000 27,875 34,600 Ending $11,375 22,350 26,450 $ (Use cells 86 to C18 from the given information to complete this question. If overhead is overapplied, your answer should be displayed as a 24 negative value. All answers should be input and displayed as positive values.) 25 (Use cells 86 to C18 from the given information to complete this question. If overhead is overapplied, your answer should be displayed as a 24 negative value. All answers should be input and displayed as positive values.) 25 26 1. Overhead: 27 Actual overhead cost 28 Predetermined overhead rate 29 Actual direct labor hours 30 Total overhead applied (Over) or under applied overhead 32 33 2. Prepare a schedule of cost of goods manufactured: 34 35 (Use cells 86 to C18 from the given information to complete this question. All answers should be input and displayed as positive values.) 36 37 38 39 Direct materials: 40 41 42 Stanford Enterprises Schedule of Cost of Goods Manufactured Raw materials inventory, beginning Add: Purchases of raw materials Total raw materials available Deduct: Raw materials inventory, ending 43 44 Raw materials used in production $302,750 45 Direct labor 46 Applied manufacturing overhead 47 Total manufacturing costs 48 Add: Beginning work in process inventory 49 Total cost of work in process 7 Total manufacturing costs 8 Add: Beginning work in process inventory 19 Total cost of work in process 50 Deduct: Ending work in process inventory 51 Cost of goods manufactured 52 553 3. Prepare a schedue of cost of goods sold. 54 (Use cells 86 to C18 from the given information to complete this question. If overhead is overapplied, your answer should be displayed as a 55 negative value. All answers should be input and displayed as positive values.) 56 Stanford Enterprises Schedule of Cost of Goods Sold 57 58 59 Finished goods inventory, beginning 60 Add: Cost of goods manufactured D 61 Cost of goods available for sale 62 Deduct: Finished goods inventory, ending 63 Unadjusted cost of goods sold 64 Underapplied (overapplied) overhead 65 Adjusted cost of goods sold