pls show equation and cell references, thank u!

A1 V fx Accessibility tab summary: Financial inforn A B C D 2 4 7 9 2 Stanford Enterprises uses job-order costing. 3 Overhead is applied on the basis of direct labor hours. 4 5 The following information relates to the year just ended. 6 Data: Estimated total overhead costs $275,000 8 Estimated total direct labor hours 25,000 9 Actual total direct labor hours 27,760 10 11. Actual costs for the year: 12 Purchase of raw (direct) materials $375,000 13 Direct labor cost $536,300 14 Manufacturing overhead $302,750 15 16 Inventories: Beginning 17 Raw (Direct) Materials $15,000 18 Work in Process 27,875 19 Finished Goods 34,600 20 21 Required: 22 Use the data to fill in the following information. in 10 9002 Ending $11,375 22,350 26,450 Agraded w 8 E B D E 21 Required: 22 Use the data to fill in the following information. 23 (Use cells B6 to C18 from the given information to complete this question. If overhead is overapplied, 24 negative value. All answers should be input and displayed as positive values.) 25 26 1. Overhead: 27 Actual overhead cost 28 Predetermined overhead rate 29 Actual direct labor hours 30 Total overhead applied 31 (over) or under applied overhead 32 1332. Prepare a schedule of cost of goods manufactured: 34 35 (Use cells 86 to C18 from the given information to complete this question. All answers should be input 36 37 Stanford Enterprises 38 Schedule of Cost of Goods Manufactured 39 Direct materials 40 Raw materials inventory, beginning 411 Ado Purchases of raw materials NONmmmmm ma DO OWN A1 fx Accessibility tab summary: Financial inform D C A B 34 00 35 (Use cells B6 to C18 from the given information to complete this question. All answers should b 36 37 Stanford Enterprises 38 Schedule of Cost of Goods Manufactured 39 Direct materials: 40 Raw materials inventory, beginning 41 Add: Purchases of raw materials 42 Total raw materials available 43 Deduct: Raw materials inventory, ending 44 Raw materials used in production 45 Direct labor 46 Applied manufacturing overhead 47 Total manufacturing costs 48 Add: Beginning work in process inventory 49 Total cost of work in process 50 Deduct. Ending work in process inventory 51 Cost of goods manufactured 52 53 3. Prepare a schedue of cost of goods sold. 54 (Use cells B6 to C18 from the given information to complete this question. If overhead is overap negative value Allancuar shu hoinnit and Hentavo pennelave value A1 fx Accessibility tab summary: Financial inforn B B C D 48 Add: Beginning work in process inventory 49 Total cost of work in process 50 Deduct: Ending work in process inventory 51 Cost of goods manufactured 52 53 3. Prepare a schedue of cost of goods sold. 54 (Use cells B6 to C18 from the given information to complete this question. If overhead is overa 55 negative value. All answers should be input and displayed as positive values.) 56 57 Stanford Enterprises 58 Schedule of Cost of Goods Sold 59 Finished goods inventory, beginning 60 Add: Cost of goods manufactured 61 cost of goods available for sale 62 Deduct: Finished goods inventory, ending 63 Unadjusted cost of goods sold 64 Underapplied (overapplied) overhead 65 Adjusted cost of goods sold 66 67 68 E Graded Worksheet + Calculation Mode: Automatic Workbook Statistics Stanford Enterprises has provided its manufacturing estimated and actual data for the year end. The Controller has asked you to compute the predetermined overhead rate, the schedule of cost of goods manufactured, and the schedule of cost of goods sold Here are some tips for using Excel Cell Reference: Allows you to refer to data from another cell in the worksheet. If you entered" 85" into a blank cell, the formula would output the value from cell B5. Basic Math Functions: Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys + (plus sign to add). - minus sign to subtract). (asterisk sign to multiply), and forward slash to divide) For example, if you entered --B4-85 in a blank cell, the formula would add the values from those cells and output the result SUM Function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges If you entered SUMCA,C5,C6)" imo a blank cell, the formula would output the result of adding those three separate cells. Similarly, if you entered "SUMICA.C6), the formula would output the same result of adding those cells 1 Use the Open Excel in New Tob button to launch this question 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect 13638