provide all answers in formula form please! they need to be entered in the cells with formula only
1. Computea predetermined overhead rate 2. Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement VBS HIGH - X Coat of Goods Manufactured and cost of Goods Sold - Exoal PAGE LAYOUT FORMULAS DATA REVIEW VIEW ints FILE HOME INSERT Sign In - Alignment Number Conditional Formatas Cell Formatting Table Styles Cells Editing Reference 2 Stanford Enterprises uses job-order costing. The allocation base for overhead is direct labor hours. Data for the year just ended: Estimated total manufacturing overhead cost Estimated total direct labor hours Actual total direct labor hours $ 275.000 27,760 25.000 Actual costs for the year Purchase of raw materials (all direct) Direct labor cost Manufacturing overhead costs $375,000 $536,300 $302.750 nontones Raw materials (all direct) Work in process Finished goods Beginning 15.000 27875 34 600 Ending 11.375 22.350 26.450 se the data to answer the following: Excel A Algiment Number C d ting Formatting Table Styles $ Raw materials (all direct) Work in proces nished goods Beginning 15.000 27875 34,600 Ending 11.375 22350 26.450 19. Use the data to answer the following. 2 .Compute applied overhead and determine the amount of underapplied or overapplied overhead: Actual manufacturing overhead cost S 302,750 Predetermined overhead rate Actual direct labor hours Manufacturing overhead applied Underapplied (overapplied) manufacturing overhead 2. Prepare a schedule of cost of goods manufactured: Stanford Enterprises Schedule of Cost of Goods Manufactured Direct materials Raw materials inventory, beginning Add Purchases of raw materials Total raw materials available Deduct: Raw materials inventory, ending Sheet HEADY Attempts) 2/3 A Alignment Number Cells Eating Formatting Table Styles Total raw matenas available Deduct: Raw materials inventory, ending Raw materials used in production Direct labor 40 Manufacturing overhead applied to work in process 41 Total manufacturing costs 42 Nad: Beginning work in process inventory 43 Potal cost of work in process 14 Deduct: Ending work in process inventory 45 Cost of goods manufactured 1. Prepare a schedule of cost of goods sold. Stanford Enterprises Schedule of Cost of Goods Sold 2 Finished goods inventory, beginning Add: Cost of goods manufactured 4 Cost of goods available for sale 35 Deduct: Finished goods inventory, ending 56 adjusted cost of goods sold Underapplied coverapplied) overhead Adjusted cost of goods sold Sheet Altepe 2/3 1. Computea predetermined overhead rate 2. Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement VBS HIGH - X Coat of Goods Manufactured and cost of Goods Sold - Exoal PAGE LAYOUT FORMULAS DATA REVIEW VIEW ints FILE HOME INSERT Sign In - Alignment Number Conditional Formatas Cell Formatting Table Styles Cells Editing Reference 2 Stanford Enterprises uses job-order costing. The allocation base for overhead is direct labor hours. Data for the year just ended: Estimated total manufacturing overhead cost Estimated total direct labor hours Actual total direct labor hours $ 275.000 27,760 25.000 Actual costs for the year Purchase of raw materials (all direct) Direct labor cost Manufacturing overhead costs $375,000 $536,300 $302.750 nontones Raw materials (all direct) Work in process Finished goods Beginning 15.000 27875 34 600 Ending 11.375 22.350 26.450 se the data to answer the following: Excel A Algiment Number C d ting Formatting Table Styles $ Raw materials (all direct) Work in proces nished goods Beginning 15.000 27875 34,600 Ending 11.375 22350 26.450 19. Use the data to answer the following. 2 .Compute applied overhead and determine the amount of underapplied or overapplied overhead: Actual manufacturing overhead cost S 302,750 Predetermined overhead rate Actual direct labor hours Manufacturing overhead applied Underapplied (overapplied) manufacturing overhead 2. Prepare a schedule of cost of goods manufactured: Stanford Enterprises Schedule of Cost of Goods Manufactured Direct materials Raw materials inventory, beginning Add Purchases of raw materials Total raw materials available Deduct: Raw materials inventory, ending Sheet HEADY Attempts) 2/3 A Alignment Number Cells Eating Formatting Table Styles Total raw matenas available Deduct: Raw materials inventory, ending Raw materials used in production Direct labor 40 Manufacturing overhead applied to work in process 41 Total manufacturing costs 42 Nad: Beginning work in process inventory 43 Potal cost of work in process 14 Deduct: Ending work in process inventory 45 Cost of goods manufactured 1. Prepare a schedule of cost of goods sold. Stanford Enterprises Schedule of Cost of Goods Sold 2 Finished goods inventory, beginning Add: Cost of goods manufactured 4 Cost of goods available for sale 35 Deduct: Finished goods inventory, ending 56 adjusted cost of goods sold Underapplied coverapplied) overhead Adjusted cost of goods sold Sheet Altepe 2/3