M Question 2 - Ch 5 X x1 Integrated Excel T X Instagram . F + X Instagramin O x C L. Timetable Planner X L. swing.langara.bc X https://ezto.mheducation.com/ext/common/excelonline/excel-tool.html?Q_13252717777924956_ans1 Search i pyy M Gmail YouTube 7 63 PER Instagram 17 Google Calendar -... ChatGPT: Optimize.. Class Managerial... MindTap - Cengag. Excel McGraw Hill Excel Question - Saved V Search (Option + Q) File Home Insert Draw Formulas Data Review View Help Calibri V 17 A ab General 00 A1 X V fx Accessibility tab summary: Financial information for Stanford Enterprises, is presented in rows 5 to 19. A statement for requirement 1 is prese A B C D E F G H I J K Stanford Enterprises uses job-order costing. Overhead is applied on the basis of direct labor hours. VOUAWN The following information relates to the year just ended. 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 Ending 17 Raw (Direct) Materials $15,000 $11,375 18 Work in Process 27,875 22,350 Finished Goods 26,450 19 34,600 20 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, your answer should be displayed as a 24 negative value. All answers should be input and displayed as positive values.)(Use cells B6 to C18 from the given information to complete this question. If overhead is overapplied, your answer should be displayed as a 24 negative value. All answers should be input and displayed as positive values.) 25 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 3735 (Use cells B6 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 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 5235 (Use cells B6 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 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