Read these Instructions carefully! For October 2021, TruBent Machining's manufacturing activities generated the records shown in the Data sheet. TruBent worked on numerous Jobs that month and each data record pertains to the inputs for each job. The records are in chronological order and each record has fields for :Year, Month, Day, lob No., Type, Sub-Category, and Quantity (measured in appropriate input units -- for example, labor and machine quantities are measured in hours.) n order to complete the assignment you will need to do the following activities: 1. Watch video and use the practice data (optional if you already know to work with Excel Tables and PivotTables). 2. Prepare the Data by adding Unit Costs and Item Costs as explained on the Data tab. 3. Create an Excel table using the data in the Data tab. 4. Use the Excel table to create a PivotTable located in the Pivot 2 tab. 5. Answer the questions given below. a. Some of the questions pertain to the specific job high-lighted in Green below. Note that this job is keyed to your UIN. Therefore be sure that you have entered your UIN and Name on the "Name & ID" tab. o. Some of the questions pertain to the entirety of the data set and not a particular job. Among the objectives are to determine the total amount of costs added in October to WIP and co Job No. 6523 The Costs per unit for each type of input by category are given in the table below. Machine costs are treated as overhead. Direct costs pertain to materials and labor. There are two types of labor, "skilled" and "normal". Each has a separate cost per labor hour. There are three types of materials used by TruBent, once again each material is measured in an appropriate input unit and the cost per unit is with respect to that input unit. Type . Materials Category Machine T1 Machine T2 Machine T3 Mat X1 Mat X2 Mat X3 Normal Skilled $ $ $ $ $ $ $ $ Cost per unit 35.00 42.00 45.00 5.25 7.50 13.20 29.00 41.00 Labor 6523 Required - Part 1 Questions 1 to 6 pertain only to Job No. ===> Enter your answers in the appropriate Yellow shaded cell!!! Determine the total Direct Material costs added (to WIP) in October Q1 Determine the total Direct Labor costs added in October Q2 Determine the total Machine 1 related OH costs added in October Q3 Determine the total Machine 2 related OH costs added in October 04 Determine the total Machine 3 related OH costs added in October Q5 Q6 Determine the total manufacturing costs added in October Required - Part 2 Questions 7 to 12 pertain to all work done in October (i.e., include all jobs) Determine the total Direct Material costs added in October Q7 Determine the total Direct Labor costs added in October Q8 Determine the total Machine 1 related OH costs added in October Q9 Determine the total Machine 2 related OH costs added in October Q10 Determine the total Machine 3 related OH costs added in October Q11 Q12 Determine the total manufacturing costs added in October Required - Part 3 Questions 13 to 18 pertain to all work done on October 27 through October 30 (inclusive) Determine the total Direct Material costs added Q13 Determine the total Direct Labor costs added Q14 Determine the total Machine 1 related OH costs added Q15 Determine the total Machine 2 related OH costs added Q16 Determine the total Machine 3 related OH costs added Q17 Q18 Determine the total manufacturing costs added Required - rt 4 Questions 19 to 20 Assume the actual overhead for the October is: $ 166,900 Answer the following two questions regarding the closing of the mfg. overhead accounts for the month. You should create Pivot Tables that show the overhead applied for the month, the amount of overhead applied by job, and the amount of overhead applied to each job as a percentage of the total OH applied. What is the total amount of overhead under (use a positive number) or over (use a negative number) applied during the month? Q19 What is the total amount of adjustment required to be made to Job 6500? Q20 6523 Required - Part 1 Questions 1 to 6 pertain only to Job No. ===> Enter your answers in the appropriate Yellow shaded cell!!! Determine the total Direct Material costs added (to WIP) in October Q1 Determine the total Direct Labor costs added in October Q2 Determine the total Machine 1 related OH costs added in October Q3 Determine the total Machine 2 related OH costs added in October Q4 Determine the total Machine 3 related OH costs added in October Q5 Q6 Determine the total manufacturing costs added in October Required - Part 2 Questions 7 to 12 pertain to all work done in October (.e., include all jobs) Determine the total Direct Material costs added in October Q7 Determine the total Direct Labor costs added in October Q8 Determine the total Machine 1 related OH costs added in October Q9 Determine the total Machine 2 related OH costs added in October Q10 Determine the total Machine 3 related OH costs added in October Q11 Q12 Determine the total manufacturing costs added in October Required - Part 3 Questions 13 to 18 pertain to all work done on October 27 through October 30 (inclusive) Determine the total Direct Material costs added Q13 Determine the total Direct Labor costs added Q14 Determine the total Machine 1 related OH costs added Q15 Determine the total Machine 2 related OH costs added Q16 Determine the total Machine 3 related OH costs added Q17 Q18 Determine the total manufacturing costs added Required - Part 4 Questions 19 to 20 Assume the actual overhead for the October is: $ 166,900 Answer the following two questions regarding the closing of the mfg. overhead accounts for the month. You should create Pivot Tables that show the overhead applied for the month, the amount of overhead applied by job, and the amount of overhead applied to each job as a percentage of the total OH applied. What is the total amount of overhead under (use a positive number) or over (use a negative number) applied during the month? Q19 What is the total amount of adjustment required to be made to Job 6500? Q20 Read these Instructions carefully! For October 2021, TruBent Machining's manufacturing activities generated the records shown in the Data sheet. TruBent worked on numerous Jobs that month and each data record pertains to the inputs for each job. The records are in chronological order and each record has fields for :Year, Month, Day, lob No., Type, Sub-Category, and Quantity (measured in appropriate input units -- for example, labor and machine quantities are measured in hours.) n order to complete the assignment you will need to do the following activities: 1. Watch video and use the practice data (optional if you already know to work with Excel Tables and PivotTables). 2. Prepare the Data by adding Unit Costs and Item Costs as explained on the Data tab. 3. Create an Excel table using the data in the Data tab. 4. Use the Excel table to create a PivotTable located in the Pivot 2 tab. 5. Answer the questions given below. a. Some of the questions pertain to the specific job high-lighted in Green below. Note that this job is keyed to your UIN. Therefore be sure that you have entered your UIN and Name on the "Name & ID" tab. o. Some of the questions pertain to the entirety of the data set and not a particular job. Among the objectives are to determine the total amount of costs added in October to WIP and co Job No. 6523 The Costs per unit for each type of input by category are given in the table below. Machine costs are treated as overhead. Direct costs pertain to materials and labor. There are two types of labor, "skilled" and "normal". Each has a separate cost per labor hour. There are three types of materials used by TruBent, once again each material is measured in an appropriate input unit and the cost per unit is with respect to that input unit. Type . Materials Category Machine T1 Machine T2 Machine T3 Mat X1 Mat X2 Mat X3 Normal Skilled $ $ $ $ $ $ $ $ Cost per unit 35.00 42.00 45.00 5.25 7.50 13.20 29.00 41.00 Labor 6523 Required - Part 1 Questions 1 to 6 pertain only to Job No. ===> Enter your answers in the appropriate Yellow shaded cell!!! Determine the total Direct Material costs added (to WIP) in October Q1 Determine the total Direct Labor costs added in October Q2 Determine the total Machine 1 related OH costs added in October Q3 Determine the total Machine 2 related OH costs added in October 04 Determine the total Machine 3 related OH costs added in October Q5 Q6 Determine the total manufacturing costs added in October Required - Part 2 Questions 7 to 12 pertain to all work done in October (i.e., include all jobs) Determine the total Direct Material costs added in October Q7 Determine the total Direct Labor costs added in October Q8 Determine the total Machine 1 related OH costs added in October Q9 Determine the total Machine 2 related OH costs added in October Q10 Determine the total Machine 3 related OH costs added in October Q11 Q12 Determine the total manufacturing costs added in October Required - Part 3 Questions 13 to 18 pertain to all work done on October 27 through October 30 (inclusive) Determine the total Direct Material costs added Q13 Determine the total Direct Labor costs added Q14 Determine the total Machine 1 related OH costs added Q15 Determine the total Machine 2 related OH costs added Q16 Determine the total Machine 3 related OH costs added Q17 Q18 Determine the total manufacturing costs added Required - rt 4 Questions 19 to 20 Assume the actual overhead for the October is: $ 166,900 Answer the following two questions regarding the closing of the mfg. overhead accounts for the month. You should create Pivot Tables that show the overhead applied for the month, the amount of overhead applied by job, and the amount of overhead applied to each job as a percentage of the total OH applied. What is the total amount of overhead under (use a positive number) or over (use a negative number) applied during the month? Q19 What is the total amount of adjustment required to be made to Job 6500? Q20 6523 Required - Part 1 Questions 1 to 6 pertain only to Job No. ===> Enter your answers in the appropriate Yellow shaded cell!!! Determine the total Direct Material costs added (to WIP) in October Q1 Determine the total Direct Labor costs added in October Q2 Determine the total Machine 1 related OH costs added in October Q3 Determine the total Machine 2 related OH costs added in October Q4 Determine the total Machine 3 related OH costs added in October Q5 Q6 Determine the total manufacturing costs added in October Required - Part 2 Questions 7 to 12 pertain to all work done in October (.e., include all jobs) Determine the total Direct Material costs added in October Q7 Determine the total Direct Labor costs added in October Q8 Determine the total Machine 1 related OH costs added in October Q9 Determine the total Machine 2 related OH costs added in October Q10 Determine the total Machine 3 related OH costs added in October Q11 Q12 Determine the total manufacturing costs added in October Required - Part 3 Questions 13 to 18 pertain to all work done on October 27 through October 30 (inclusive) Determine the total Direct Material costs added Q13 Determine the total Direct Labor costs added Q14 Determine the total Machine 1 related OH costs added Q15 Determine the total Machine 2 related OH costs added Q16 Determine the total Machine 3 related OH costs added Q17 Q18 Determine the total manufacturing costs added Required - Part 4 Questions 19 to 20 Assume the actual overhead for the October is: $ 166,900 Answer the following two questions regarding the closing of the mfg. overhead accounts for the month. You should create Pivot Tables that show the overhead applied for the month, the amount of overhead applied by job, and the amount of overhead applied to each job as a percentage of the total OH applied. What is the total amount of overhead under (use a positive number) or over (use a negative number) applied during the month? Q19 What is the total amount of adjustment required to be made to Job 6500? Q20