All one question. thank you!

1. Calculate and dispose of overapplied or underapplied manufacturing overhead. 2. Calculate the cost of goods manufactured and cost of goods sold. 3. Prepare an income statement for a manufacturing firm. 7 5 X Q5. FILE HOME x CA Cost of Goods Manufactured and cost of Goods Sold - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT Sign in 11 Paste BIU- -A A 96 A Alignment Number Conditional Format - Cell Formatting The Styles Styles Cells Clipboard Font F22 G 11 B D Stanford Enterprises uses job-order costing. 2 Overhead is applied on the basis of direct labor hours. The following information relates to the year just ended, 4 Data: 5 Estimated total overhead costs $ 275.000 6 Estimated total direct labor hours 250 7 Actual total direct labor hours 27,760 $ Actual costs for the year 10 Purchase of raw (direct) materials 11 Direct labor cost 12 Manufacturing overhead 375XXO 536300 302,750 $ 14 Investories Beginning Ending 15 Raw Materials (All Direct) $ 15.000 $ 11.375 16 Work in Process 27.875 22.350 17 Finished Goods 34,600 26450 18 19 Use the data to answer the following 20 211.Overhead Actual overhead cost Predetermined overhead rate 24 Actual direct labor hours BAR ? Cost of Goods Manufactured and Cost of Goods Sold - Excel C - 5 X 3 FILE INSERT HOME PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Calibri 11 A A Paste Cells % Alignment Number Conditional Format as Cell Formatting Table Styles Styles BIU- Clipboard Font w F22 X F E D A H G B 1 Stanford Enterprises uses job-order costing. 2 Overhead is applied on the basis of direct labor hours. 3 The following information relates to the year just ended. 4 Data: 5 Estimated total overhead costs $ 275,000 6 Estimated total direct labor hours 25,000 7 Actual total direct labor hours 27,760 8 9 Actual costs for the year: 10 Purchase of raw (direct) materials s 375,000 11 Direct labor cost $ 536,300 12 Manufacturing overhead $ 302,750 13 14 Inventories: 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. Overhead: 22 Actual overhead cost 23 Predetermined overhead rate Actual direct labor hours Sheet1 24 4 EL 100% Hint READY Attempt(s) 1/3 BH- Cost of Goods Manufactured and cost of Goods Sold - Excel X Sign In DATA FORMULAS REVIEW PAGE LAYOUT VIEW FILE HOME INSERT X Calibri - 11 96 A Cells Paste BIU- Cell Alignment Number Conditional Format as Formatting Table Styles Styles Font Clipboard > F22 H I G B c D F E 21 1. Overhead: 22 Actual overhead cost 23 Predetermined overhead rate 24 Actual direct labor hours | 25 Total overhead applied 26 27 (Over) or under applied overhead 28 29 2. Prepare a schedule of cost of goods manufactured: 30 Stanford Enterprises 31 Cost of Goods Manufactured Report 32 Direct materials: 33 Beginning raw materials inventory 34 Plus: Raw materials purchased 35 Less: Ending raw materials inventory 36 Raw materials used in production 37 Direct labor 38 Manufacturing overhead applied 39 Total current manufacturing costs 40 Plus: Beginning work in process inventory 41 Less: Ending work in process inventory 42 Cost of goods manufactured 43 44 3. Prepare an income statement Sheet1 TOON READY Attempt(o) Hint 1/3 Cost of Goods Manufactured and Cost of Goods Sold - Excel ? - 8 X OBS. FILE HOME x Calb INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW sign in a 11 - A A 96 BIU- Cells Alignment Number Conditional Formatas Cell Formatting Table Styles Styles Font F22 G H 1 $ 1,500,000 A B D E 40 Plus: Beginning work in process inventory 41 Less: Ending work in process inventory 42 Cost of goods manufactured 43 44 3. Prepare an income statement. 45 Stanford Enterprises 46 Income Statement 47 Sales revenge 48 Less: Cost of Goods Sold 49 Finished goods inventory, beginning SO Plus: Cost of goods manufactured 51 Less: Ending finished goods inventory $2 Unadjusted cost of goods sold 53 Underapplied (overapplied) overhead 54 Adjusted cost of goods sold 55 Gross Profit 56 Less: Selling, general, and administrative expenses (10% of Sales) 57 Net Operating Income S8 59 60 61 Sheet1 . READY Attempt(s) 100% Hint 1/3