Show formula .

1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold. All answers must be entered as a formula Click OK to begin. OK 1. Computea predetermined overhead rate 2. Prepare schedules of cost of goods manufactured and cost of goods sold Cost of Goods Montecture and cost of Goods Solid - Excel 7 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Cab - A A . Fies - Paste BIU % Alignment Number Conditional Format as a Formatting Table Styles Shes Celson Clipboard fo A1 Stanford Enterprises uses job-order costing. E G H - C D Stanford Energiesses job onder costing 2. The allocation base for overhead is direct labor hours 3 4 Duta for the year justcoded: 5 Estimated total manufacturing overhead cost 6 Estimated total direct labor hours 7 Actual total direct labor hours $ 275.000 25.000 27,760 Actual con for the year 10 Purchase of raw materials (all direct) $375.000 11 Direct labor cost 5536,300 12 Manufacturing overhead Core $302.50 13 14 Inventions Beginning Fading 15 Raw materials all doct) S 15.000 $ 11375 16 Work is process S 2775 $ 22.350 12 Finished goods $ 34.600 5 26.450 18 19 Use the data te the following 20 21 Compute applied overhead and determine the amount of undergplied everapplied overhead 22 Actualacting overhead cost 23 Prednederhede 24 Actual direct labore Sheets READY Aftampil 1. Compute a predetermined overhead rate: 2. Prepare schedules of cost of goods manufactured and cost of goods sold. BH 5 ? 6 X ! Cost of Goods Manufactured and Cost of Goods Sold - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME INSERT Sign in * Calibri -11 -A A 96 Paste BIU- Cells Editing Alignment Number Conditional Formatas Cell Formatting Table Styles Styles Clipboard Font