Home Insert Draw Page Layout Formulas Data Review View Tell me Paste Merge Center H45 A B C D E H 9 12 1 Read these Instructions carefully! 3 For October 2020, TruBent Machining's manufacturing activities generated 4 the records shown in the Data sheet. TruBent worked on twenty Jobs that month 5 and each data record pertains to the inputs for each job. The records are in 6 chronological order and each record has fields for: Record No., Date, 7 Job No. Category, Sub-Category, and Quantity (measured in appropriate input units- 8 for example, labor and machine quantities are measured in hours.) 10 In order to complete the assignment you will need to do the following activities: 11 1. Watch video and use the practive data (optional if you already know to work with Excel Tables and Pivot tables. 13 2. Prepare the Data by adding unit costs and item costs as explained on the Data tab. 14 3. Create an Excel table using the data in the Data tab 15 4. Use the Excel table to create a Pivot table located in the Pivot tab. 16 5. Answer the questions given below. 17 a. Some of the questions pertain to the specific job high-lighted in Green below. Note 18 that this job is keyed to your UIN. Therefore be sure that you have entered 19 your UIN and Name on the Instructions tab. 20 b. Some of the questions pertain to the entirety of the data set and not a particular job. 21 22 The main objective is to determine the total amount of costs added in October 23 to Job No. #VALUE! 24 25 The Cost per Unit of input for each sub-category are given in the table. 26 Machine costs are treated as overhead. Direct costs pertain to materials and labor. 27 There are two types of labor "skill" and "normal". Each has a separate 28 cost per labor hour. There are three types of materials used by TruBent. 29 once again each material is measured in an appropriate input unit and the 30 cost per unit is with respect to that input unit. Instructions Sample Data A Questions Data Pivot Ready Pivot 2 + 27 H45 F G A B C D E 26 Machine costs are treated as overhead. Direct costs pertain to materials and labor. 27 There are two types of labor "skill" and "normal". Each has a separate 28 cost per labor hour. There are three types of materials used by Trubent, 29 once again each material is measured in an appropriate input unit and the 30 cost per unit is with respect to that input unit. 31 32 Sub Category Cost per unit 33 Machine 1 $ 30.00 34 Machine 2 $ 40.00 35 Machine 3 $ 50.00 36 Mat 1 $ 5.25 37 Mat 2 $ 6.50 38 Mat 3 $ 13.20 39 Normal $ 25.00 40 Skill 35.00 41 42 Required - Part 1 43 Questions 1 to 6 pertain only to Job No. =*=> 44 Enter your answers in the appropriate Yellow shaded cell 45 Determine the total Direct Material costs added in October 46 47 Determine the total Direct Labor costs added in October 48 49 Determine the total Machine 1 related OH costs added in October 50 51 Determine the total Machine 2 related OH costs added in October 52 53 Determine the total Machine 3 related OH costs added in October 54 55 Determine the total manufacturing costs added in October CC Daciadas Instructions Sample Data Questions Data Ready #VALUE! 01 Q2 03 Q4 05 Q6 Pivot Pivot 2 7 Home Insert Draw Page Layout Formulas Data Review View Tell me Paste Merge Center H45 A B C D E H 9 12 1 Read these Instructions carefully! 3 For October 2020, TruBent Machining's manufacturing activities generated 4 the records shown in the Data sheet. TruBent worked on twenty Jobs that month 5 and each data record pertains to the inputs for each job. The records are in 6 chronological order and each record has fields for: Record No., Date, 7 Job No. Category, Sub-Category, and Quantity (measured in appropriate input units- 8 for example, labor and machine quantities are measured in hours.) 10 In order to complete the assignment you will need to do the following activities: 11 1. Watch video and use the practive data (optional if you already know to work with Excel Tables and Pivot tables. 13 2. Prepare the Data by adding unit costs and item costs as explained on the Data tab. 14 3. Create an Excel table using the data in the Data tab 15 4. Use the Excel table to create a Pivot table located in the Pivot tab. 16 5. Answer the questions given below. 17 a. Some of the questions pertain to the specific job high-lighted in Green below. Note 18 that this job is keyed to your UIN. Therefore be sure that you have entered 19 your UIN and Name on the Instructions tab. 20 b. Some of the questions pertain to the entirety of the data set and not a particular job. 21 22 The main objective is to determine the total amount of costs added in October 23 to Job No. #VALUE! 24 25 The Cost per Unit of input for each sub-category are given in the table. 26 Machine costs are treated as overhead. Direct costs pertain to materials and labor. 27 There are two types of labor "skill" and "normal". Each has a separate 28 cost per labor hour. There are three types of materials used by TruBent. 29 once again each material is measured in an appropriate input unit and the 30 cost per unit is with respect to that input unit. Instructions Sample Data A Questions Data Pivot Ready Pivot 2 + 27 H45 F G A B C D E 26 Machine costs are treated as overhead. Direct costs pertain to materials and labor. 27 There are two types of labor "skill" and "normal". Each has a separate 28 cost per labor hour. There are three types of materials used by Trubent, 29 once again each material is measured in an appropriate input unit and the 30 cost per unit is with respect to that input unit. 31 32 Sub Category Cost per unit 33 Machine 1 $ 30.00 34 Machine 2 $ 40.00 35 Machine 3 $ 50.00 36 Mat 1 $ 5.25 37 Mat 2 $ 6.50 38 Mat 3 $ 13.20 39 Normal $ 25.00 40 Skill 35.00 41 42 Required - Part 1 43 Questions 1 to 6 pertain only to Job No. =*=> 44 Enter your answers in the appropriate Yellow shaded cell 45 Determine the total Direct Material costs added in October 46 47 Determine the total Direct Labor costs added in October 48 49 Determine the total Machine 1 related OH costs added in October 50 51 Determine the total Machine 2 related OH costs added in October 52 53 Determine the total Machine 3 related OH costs added in October 54 55 Determine the total manufacturing costs added in October CC Daciadas Instructions Sample Data Questions Data Ready #VALUE! 01 Q2 03 Q4 05 Q6 Pivot Pivot 2 7