This is all one problem. I need help solving this. I have to enter formulas into the cells and I am lost.

1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold. Cost of Goods Manufactured and Cost of Goods Sold - Excel 7 0 - 5 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A A % Paste BIUT Alignment Number Conditional Format as Cell Cells Editing Formatting * Table * Styles Clipboard Font G Styles A Al X V Stanford Enterprises uses job-order costing. A B C D E F G H Stanford Enterprises uses job-order costing. W N The allocation base for overhead is direct labor hours. Data for the year just ended: 5 Estimated total manufacturing overhead cost $ 275,000 6 Estimated total direct labor hours 25,000 Actual total direct labor hours 27,760 9 Actual costs for the year: 10 Purchase of raw materials (all direct) $375,000 11 Direct labor cost $536,300 12 Manufacturing overhead costs $302,750 13A B C D E F G H 13 14 Inventories: Beginning Ending 15 Raw materials (all direct) $ 15,000 11,375 16 Work in process $ 27,875 $ 22,350 17 Finished goods $ 34,600 26,450 18 19 Use the data to answer the following. 20 21 1. Compute applied overhead and determine the amount of underapplied or overapplied overhead: 22 Actual manufacturing overhead cost 23 Predetermined overhead rate 24 Actual direct labor hours 25 Manufacturing overhead applied27 Underapplied (overapplied) manufacturing overhead 28 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 laborManufacturing overhead applied to work in process Total manufacturing costs Add: Beginning work in process inventory Total cost of work in process Deduct: Ending work in process inventory Cost of goods manufactured 3' Prepare a schedule of cost of goods sold. Stanford Enterprises Schedule of Cost of Goods Sold 52 Finished goods inventory+ beginning 50 Schedule of Cost of Goods Sold 51 52 Finished goods inventory, beginning 53 Add: Cost of goods manufactured 54 Cost of goods available for sale 55 Deduct: Finished goods inventory, ending 56 Unadjusted cost of goods sold 57 Underapplied (overapplied) overhead 58 Adjusted cost of goods sold 59 60 61