please help me fill in the missing date using the given information, and please show full formulas :)
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 "-B5" 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 *-84+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 "SUM(C4,C5,C6) into a blank cell, the formula would output the result of adding those three separate cells. Similarly, if you entered "-SUM(C4:C6)", the formula would output the same result of adding those cells. 1. Use the Open Excel in New Tab 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. ces X Open Excel in new tab Med Ex acel McGraw Hill Excel Question-Saved Search (Option View Help File Home Insert Formulas Data Review Editing General Comment H 2 *** & Accessibility tab summary: Financial information for Stanford Enterprises, is presented in rows 5 to 19. A statement for requirement 1 is presented in rows 21 to 24. A table for overhead D G H 0 P Q Stanford Enterprises uses job-order costing Overhead is applied on the basis of direct labor hours The following information relates to the year just ended. Datal Estimated total overhead costs Estimated total direct labor hours $275,000 25,000 Actual total direct labor hours 27,760 Actual costs for the year: $375,000 Purchase of raw (direct) materials Direct labor cost $536,300 Manufacturing overhead $302,750 wwentories Raw (Direct) Materials $15,000 $11,375 27,875 Work in Process 22,350 19 Finished Goods 34,600 26,450 20 21 Required: 22 Use the data to fill in the following information B (Use cells 86 to C18 from the given information to complete this question. If overhead is overapplied, your answer 24 should be displayed as a negative value. All answers should be input and displayed as positive values.) 0 1 3 47. S. Beginning Endins 4 26 1. Overhead: 2222222322 27 Actual overhead cost Predetermined overhead rate Actual direct labor hours Total overhead applied (Over) or under applied overhead 33 2. 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 and displayed as positive values.) 36 37 Stanford Enterprises 38 Schedule of Cost of Goods Manufactured 39 Direct materials: 40 28 29 30 31 Raw materials inventory, beginning Add: Purchases of raw materials Total raw materials available 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 41 42 43 33, Prepare a schedue of cost of goods sold. 4 (Use cells 86 to C18 from the given information to complete this question. If overhead is overapplied, your answer 5 should be displayed as a 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 69 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 70 Nothing in this area will be graded, but it will be submitted with your assignment. 71 67 CSSRERE 68 72 73
