Given the following data, what formulas would be used to solve the schedule of cost of goods sold and manufactured? Thanks!

Course Documents-MH \D Study Guide for Test-2-,/XyD chapter 2 lob Cost Excel ?\. ? px?0.08935822314423625 1527374579647 was entered, the formula would output the result of adding those three separate cells, or 1,214,050 in this example Similarly, if in a blank cell adding those cells, except they are expressed as a range in the formula, and the result would be 1,214,050 in this example SUM E10 E12 was entered, the formula would output the same result of Cost of Goods Manufactured and Cost of Goods Sald-Excel FILE HOME INSERT PAGE LAYOUTFORMULAS DATA REVIEWVEW n In Blu-Q2.? . Alignment Number Conditione! Forretas. Cell Formatting TableStyles Paste Cells Editing 1Stanford Enterprises uses job-order costing 2 The allocation base for overhead is direct labor hours. 4 Data for the year just ended: Eshimated total manufacturing overhead cost Estimated total direct labor hours s 275,000 25,000 27,760 7Actual total direct labor hours 9 Actual costs for the year: 10 Purchase of raw materials (all di 11 Direct labar cost 12 Manufacturing overhead costs 5375,000 536,300 302,750 14 Inventories: 15 Raw materials (all di 1 Work in process 15,000 11,375 5 27,875 22,350 34,00 26,450 Finished goods 18 19 Use the data to answer the following. 21 1. Compute applied overhead and determine the amount af underapplied ar ?verapplied overhead: 22 Actual manufacturing overhead cost 23 Predetermined overhead rate 4 Actual direct labor hou .Sheetl