Cost of Goods Manufactured and Cost of Goods Sold - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Calibri 11 % # A A Paste B TU - > Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 X Stanford Enterprises uses job-order costing. c D B E G F - 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 $ 275,000 25,000 27,760 8 11 $375,000 $536,300 $302,750 9 Actual costs for the year: 10 Purchase of raw materials (all direct) Direct labor cost 12 Manufacturing overhead costs 13 14 Inventories: Raw materials (all direct) Work in process Finished goods 15 16 17 18 Beginning $ 15,000 S 27,875 S 34,600 Ending $ 11,375 $ 22,350 $ 26,450 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 Actual direct labor hours Sheet1 . READY 100% 5. Cost of Goods Manufactured and Cost of Goods Sold - Excel ? E 1 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Calibri - 11 M Paste BIU. A A % A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A1 3 X fu Stanford Enterprises uses job-order costing. > B c D E F G H 24 25 26 27 Actual direct labor hours Manufacturing overhead applied 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 labor 40 Manufacturing overhead applied to work in process 41 Total manufacturing costs 42 Add: Beginning work in process inventory 43 44 Deduct: Ending work in process inventory 45 Cost of goods manufactured 47 3. Prepare a schedule of cost of goods sold. Sheet1 READY 100% Attempt(s) 0 49 Stanford Enterprises 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 50 61 62 . Sheet1 100% READY Attempt(s)