1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement. ? X - Sign In FILE % Paste Clipboard HOME Calibri B I Cost of Goods Manufactured and cost of Goods Sold - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW -111A A = U - - > A - Alignment Number Conditional Format as Cell Formatting Table Styles Font Cells Editing Styles E F D 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 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 $ 275,000 25,000 27,760 9 Actual costs for the year: 10 Purchase of raw materials (all direct) 11 Direct labor cost 12 Manufacturing overhead costs $375,000 $536,300 $302,750 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 $ 34,600 Ending $ 11,375 $ 22,350 $ 26,450 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 - Sheet1 - + READY EI - 100% 1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement. ? X - Sign In FILE % Paste Clipboard HOME Calibri B I Cost of Goods Manufactured and cost of Goods Sold - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW -111A A = U - - > A - Alignment Number Conditional Format as Cell Formatting Table Styles Font Cells Editing Styles E F D 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 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 $ 275,000 25,000 27,760 9 Actual costs for the year: 10 Purchase of raw materials (all direct) 11 Direct labor cost 12 Manufacturing overhead costs $375,000 $536,300 $302,750 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 $ 34,600 Ending $ 11,375 $ 22,350 $ 26,450 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 - Sheet1 - + READY EI - 100%
