Cost of Goods Manufactured and Cost of Goods Sold - Excel 4 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 - ' ' % Paste BIU Clipboard Font Cell Alignment Number Conditional Format as Formatting Table Styles Styles Cells Editing A1 fx Stanford Enterprises uses job-order costing. B C D E 0 Sign In 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: 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: Purchase of raw materials (all direct) 10 11 Direct labor cost 12 13 Manufacturing overhead costs 14 Inventories: $ 275,000 25,000 27,760 $375,000 $536,300 $302,750 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: Actual manufacturing overhead cost 22 23 Predetermined overhead rate 24 Actual direct labor hours Sheet1 READY Attempt(s) > + 100% Hint Show Me