answers must be written in formulas

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 KBS. FILE HOME ? -- X INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in Calib M Paste BIU- Cells Editing CAA % A. Alignment Number Conditional Format as Cell Formatting Table Styles Styles f Stanford Enterprises uses job-order costing, Clipboard Font > B C D E F G H . 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: Estimated total manufacturing overhead cost 6 Estimated total direct labor hours 7 Actual total direct labor hours $ 275,000 25,000 27.760 8 $375.000 $536,300 $302,750 9 Actual costs for the year: 10 Purchase of raw materials (all direct) 11 Direct labor cost 12 Manufacturing overhead costs 13 14. Inventories: 15 Raw materials (all direct) 16 Work in process 17 Finished goods 18 19 Use the data to answer the following. Beginning $ 15.000 $ 27,875 s 34,600 $ S $ Ending 11,375 22,350 26,450 1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold X 5 - 5 x Cost of Goods Manufactured and Cost of Goods Sold - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME INSERT Sign In Calibri 11 IR 14 Paste BIU- Cells Editing -A A %6 Alignment Number Conditional Format as Cell Formatting Table Styles Styles Stanford Enterprises uses job-order costing. Clipboard Font