Please answer question 1-22

A 3 C D E F G WINE Read these Instructions carefully! 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, Job No., Category, Sub-Category, and Quantity (measured in appropriate input units -- for example, labor and machine quantities are measured in hours.) 9 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 12 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. 6506 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. 31 32 Sub Category Cost per unit 33 Machine 1 30.00 34 Machine 2 40.00 35 Machine 3 50.00 36 Mat 5.25 37 Mat 2 6.50 38 Mat 3 13.20 39 Normal 25.00 40 Skill 35.00 41\fA B C D E F 337 15436 6517 Material Mat 2 338 15437 6501 Material Mat 2 10 339 15438 6507 Machine Machine : 3 340 15439 6501 Machine Machine : 1.75 341 15440 6510 Labor Normal 5.5 342 15441 6502 Labor Normal 5.75 343 15442 6506 Labor Normal 8 344 15443 6502 Material Mat 2 19.5 345 15444 6519 Material Mat 2 26 346 15445 6512 Labor Normal 8 347 15446 6512 Machine Machine : 17.75 348 15447 6508 Material Mat 1 29.5 349 15448 6506 Labor Normal 4.75 350 15449 6519 Machine Machine : 10.25 351 15450 6513 Material Mat 1 20 352 15451 #HUHHUUH 6506 Labor Skill 5 353 15452 PROAHHHH 6501 Material Mat 3 18.5 354 15453 6501 Material Mat 2 5.5 355 15454 6512 Labor Normal 8 356 15455 6515 Machine Machine : 4.5 357 15456 6510 Machine Machine : 1.25 358 15457 6518 Labor Normal 6.5 359 15458 #HHUHHUH 6505 Machine Machine : 13.25 360 15459 6500 Machine Machine : 6.5 361 15460 6502 Material Mat 3 40.5 362 15461 6504 Material Mat 2 4.5 363 15462 6515 Labor Normal 8 364 15463 6503 Machine Machine : 2 365 15464 6501 Material Mat 1 45 366 15465 6515 Labor Skill 7 367 15466 6506 Material Mat 2 12 368 15467 6516 Labor Normal 2.75 369 15468 6511 Material Mat 3 25.5 370 15469 6510 Labor Skill 5.75 371 15470 6510 Machine Machine : 18.5 372 15471 6514 Labor Normal 5.75 373 15472 6515 Material Mat 1 32 374 15473 6507 Labor Normal 5.5 375 15474 6512 Labor Normal 6.75 376 15475 6508 Machine Machine : 12.75 377 15476 6501 Labor Skill 5.25 378 15477 6501 Labor Normal 3.75 379 15478 6516 Labor Normal 3.25 380 15479 6519 Labor Normal 2.5 381 15480 6502 Labor Normal 7 382 15481 6518 Labor Skill 2.25 383 15482 6502 Material Mat 1 38 384 15483 6512 Labor Skill 3\fA B D E F 433 15532 6507 Labor Normal 8 434 15533 6514 Material Mat 1 6.5 435 15534 6507 Labor Normal 5.25 436 15535 6512 Machine Machine : 4.25 437 15536 ARDAHHHH 6503 Labor Normal 5 438 15537 AHHHHHHHH 6501 Labor Normal 7.25 439 15538 PHH HHHH 6509 Machine Machine : 9.25 440 15539 6508 Labor Skill 7.75 441 15540 6517 Labor Normal 5 442 15541 6504 Labor Normal 5.75 443 15542 6503 Material Mat 1 36 444 15543 6504 Labor Skill 6 445 15544 6511 Material Mat 2 9 446 15545 6514 Material Mat 1 18 447 15546 6515 Material Mat 2 5 448 15547 6512 Material Mat 1 2.5 449 15548 6516 Material Mat 2 35 450 15549 6513 Machine Machine : 10 451 15550 6500 Labor Skill 6.25 452 15551 6507 Labor Skill 2.25 453 15552 PHH HHHH 6508 Material Mat 1 21 454 15553 6502 Labor Skill 6.25 455 15554 6513 Machine Machine : 11.5 456 15555 #8#8HUH 6503 Material Mat 1 27.5 457 15556 #HUHHUH" 6510 Labor Normal 2.5 458 15557 6513 Machine Machine : 6 459 15558 6511 Machine Machine : 3.75 460 15559 6506 Labor Normal 6.25 461 15560 6501 Labor Normal 7 462 15561 6506 Machine Machine : 18.5 463 15562 6506 Labor Skill 4.75 464 15563 6515 Machine Machine : 16.25 465 15564 6501 Material Mat 1 8 466 15565 HHHHHHHH 6502 Machine Machine : 11.5 467 15566 6506 Labor Normal 3.25 468 15567 6507 Machine Machine : 5.25 469 15568 6501 Material Mat 2 43 470 15569 6510 Labor Normal 8.25 471 15570 6517 Material Mat 3 16 472 15571 6510 Labor Skill 5 473 15572 6515 Labor Normal 5 474 15573 6518 Labor Skill 3.75 475 15574 #HHUHHHH 6509 Machine Machine : 18 476 15575 6506 Labor Normal 5.75 477 15576 6515 Labor Normal 8 478 15577 6519 Machine Machine : 5.5 479 15578 6514 Labor Normal 8.25 480 15579 HHHHHHHH 6514 Labor Skill 7.75\fRecord No. Date Job No. Category Sub Cat Qnt 15101 ####HEHE 6511 Labor Normal 4.5 LO NJ 15102 ##UHHHHH 6517 Labor Normal 5 15103 ##HUHHHH 6501 Labor Skill 4.5 15104 ##HUHUHU 6503 Material Mat 2 18 15105 #HUHSEED 6505 Material Mat 3 23 15106 ##HUHHH 6511 Material Mat 2 15 15107 ###HUHHH 6513 Machine Machine : 13 15108 ###UHHHH 6506 Machine Machine : 17.5 10 15109 ##HUHHHH 6504 Material Mat 2 29.5 11 15110 #PAPAROH 6514 Material Mat 2 30.5 12 15111; HHHHH 6501 Labor Normal 7 13 15112 ##HUHHUH 6509 Labor Normal 2.25 14 15113 ###UHHHH 6503 Material Mat 3 6.5 15 15114 #HEHEHE 6504 Labor Normal 5.5 16 15115 ##HUHHH4 6513 Material Mat 1 11.5 17 15116 ####UHHH 6516 Labor Normal 8.5 18 15117 #HU#UHHH 6502 Material Mat 1 7.5 19 15118 ####89-= 6501 Labor Normal 2.5 20 15119 #HARRAH 6519 Machine Machine : 12 21 15120 ####UHHH 6504 Machine Machine : 18.5 22 15121 #HUHHHHH 6504 Machine Machine : 1 23 15122 #HUBUHHH 6503 Labor Skill 6.25 24 15123 #HUHHHHH 6505 Machine Machine : 14.25 25 15124 #HBUECHE 6512 Machine Machine : 11 26 15125 ##HUHHUH 6501 Labor Normal 7.25 27 15126 ##UHHHH 6500 Labor Normal 4 28 15127 ## 6518 Labor Normal 2 29 15128 #BEHUHHH 6505 Machine Machine : 16 30 15129 ##HUHHHH 6519 Labor Skill 31 15130 #HUHHUH" 6516 Labor Normal 6.5 32 15131 ##8989- 6517 Labor Skill 8.5 33 15132 ####UHHH 6515 Machine Machine : 13.5 34 15133 ##HUHHHH 6515 Labor Normal 2.75 35 15134 #BUBB##- 6501 Labor Normal 3.5 36 15135 APPROACH 6519 Labor Normal 4 37 15136 #HUBSHHH 6504 Labor Skill 6.5 38 15137 THHHHHHH 6519 Labor Normal 7.25 39 15138 ###UHHHH 6509 Labor Normal 6.75 40 15139 #HUHHUH 6514 Labor Normal 5.75 41 15140 ##BUSES 6519 Labor Skill 4.25 42 15141 6518 Labor Skill 3.75 43 15142 #H#UHHHH 6511 Material Mat 1 36 44 15143 ##8FEET 6506 Machine Machine: 10.5 45 15144 ##BUSHES 6501 Machine Machine : 6 46 15145 ##HUHHUH 6506 Material Mat 3 7.5 47 15146 ##HUHHHH 6512 Material Mat 2 37 48 15147 ##HUHHUH 6517 Labor Normal 2.549 15148 #HUUHHHH 6502 Labor Skill 2.5 50 15149 ##HUHHHH 6506 Labor Skill 8 51 15150 #HHUHHHH 6513 Material Mat 2 40 52 15151 #HUH###H 6519 Material Mat 2 35 53 15152 6518 Machine Machine : 8.75 54 15153 #HAPPENS 6513 Material Mat 2 27 55 15154 ####BEES 6506 Labor Skill 5.75 56 15155 ##BUBB#H 6507 Labor Normal 4.5 57 15156 #####!#! 6511 Machine Machine : 3.5 58 15157 ##HOPPED 6500 Material Mat 2 27 59 15158 #HUBSBED 6518 Labor Normal 2.25 60 15159 ####USED 6514 Material Mat 2 22.5 61 15160 ##BUSHES 6506 Labor Skill 3.5 62 15161 #PAUSED 6508 Material Mat 1 35 63 15162 #HUBSEED 6510 Labor Skill 5.75 64 15163 #######H 6515 Labor Normal 6 65 15164 #HUBSHED 6505 Material Mat 2 19 66 15165 6504 Labor Normal 6.75 67 15166 #UHUHHUH 6515 Material Mat 2 8.5 68 15167 6516 Material Mat 1 4.5 69 15168 ##HUHHHH 6505 Labor Skill 4.5 70 15169 6503 Labor Skill 8.75 71 15170 #PUBSHHH 6516 Labor Normal 7.25 72 15171 6502 Labor Normal 3.75 73 15172 #HHUHHUH 6509 Labor Normal 5.5 74 15173 6501 Machine Machine : 3 75 15174 #HUHHUH 6516 Labor Normal 76 15175 ###BASED 6500 Material Mat 3 14 77 15176 #BRANAGH 6506 Labor Normal 8.5 78 15177 ##BUSHES 6506 Machine Machine : 13 79 15178 ####SHHH 6514 Labor Normal 2.5 80 15179 #HAPPROH 6519 Labor Normal 3.75 81 15180 #HAHASEE 6511 Labor Normal 5.25 82 15181 #HUBSBEE 6500 Material Mat 2 6 83 15182 ##HUHHH 6511 Material Mat 1 5 84 15183 #######H 6507 Labor Normal 4.75 85 15184 #HOUSE 6502 Material Mat 2 32.5 86 15185 #HUBSEED 6500 Material Mat 1 39.5 87 15186 ###UHHHH 6511 Labor Normal 3 88 15187 ##HUUH 6519 Machine Machine : 4 89 15188 #HUBSHHH 6503 Labor Normal 6.25 90 15189 6516 Labor Normal 6.75 91 15190 #HUHHHHH 6516 Machine Machine : 6.5 92 15191 6503 Material Mat 2 26 93 15192 #HUBSHUH 6502 Material Mat 1 3.5 94 15193 ##HUHHHH 6515 Material Mat 2 12.5 95 15194 ##HUHHUH 6518 Labor Normal 8.5 96 15195 #HHUHHHH 6517 Machine Machine : 3A C D E F G H 97 15196 #HUUUHHH 6514 Material Mat 3 25.5 98 15197 APPROACH 6517 Labor Normal 2.5 99 15198 #HARRAH 6515 Labor Normal 8.5 100 15199 #HAPPENS 6504 Machine Machine : 4.75 101 15200 ###UHHH 6515 Material Mat 2 31.5 102 15201 ##HUHHUH 6507 Labor Normal 7.25 103 15202 #HUHBAR 6511 Material Mat 1 39.5 104 15203 6508 Material Mat 1 37.5 105 15204 #SUBUHHH 6518 Labor Skill 3.25 106 15205 ##HUHHHH 6517 Material Mat 2 7 107 15206 ##HUHHUH 6507 Labor Skill 6 108 15207 #PRESSED 6507 Labor Skill 7 109 15208 #HUBSHHH 6504 Material Mat 1 5.5 110 15209 ###UHHHH 6519 Machine Machine : 9 111 15210 #HUHHUH 6508 Labor Normal 4.25 112 15211 6504 Labor Normal 6.75 113 15212 #HUSSEIN 6500 Material Mat 2 8 114 15213 #HARPER 6508 Labor Normal 2.75 115 15214 PPPPPPHH 6518 Labor Normal 3.25 116 15215 #HRAPPER 6508 Machine Machine : 15.75 117 15216 ##HUHHUH 6511 Material Mat 2 41 118 15217 ###UHHHH 6511 Labor Normal 3.5 119 15218 PHARAOHH 6513 Machine Machine : 19.75 120 15219 PROPROAR 6503 Labor Skill 5 121 15220 ##HUHHHH 6510 Labor Skill 3 122 15221 ##HUHHHH 6516 Material Mat 2 36 123 15222 ##HUHHHH 6512 Labor Skill 8.75 124 15223 ##HUHHHH 6500 Labor Normal 3 125 15224 6519 Machine Machine : 13.75 126 15225 ##BUSHES 6514 Machine Machine : 12.25 127 15226 ###HUHHH 6519 Labor Normal 5.75 128 15227 ##HUHHUH 6505 Machine Machine : 4.5 129 15228 ##HAHAHA 6510 Labor Skill 5 130 15229 #HHEHEHE 6519 Material Mat 2 32.5 131 15230 #HUHHHHH 6507 Machine Machine : 13.75 132 15231 ##HUHHHH 6516 Material Mat 2 13.5 133 15232 #HUHHHHH 6508 Labor Normal 5.5 134 15233 6518 Labor Normal 7 135 15234 ###HUHHH 6504 Labor Normal 7.75 136 15235 ###UHHHH 6502 Labor Normal 4.75 137 15236 #HURRAH 6502 Labor Normal 6.25 138 15237 #BUBBHUH 6518 Material Mat 1 14 139 15238 #HUBUHHH 6502 Labor Normal 5.25 140 15239 #BUUHHHH 6511 Material Mat 1 21 141 15240 #PHARAOH 6502 Machine Machine : 19 142 15241 #HAPPENS 6511 Labor Skill 2.75 143 15242 #PROFESS 6506 Labor Skill 2.25 144 15243 ###8### # 6515 Material Mat 1 40A B C D E F G H 145 15244 SUM#UHHH 6502 Labor Normal 6.5 146 15245 #BUUHHHH 6517 Machine Machine : 17.5 147 15246 APPROACH 6519 Labor Normal 3 148 15247 #HUBUHHH 6518 Material Mat 2 28 149 15248 ##HARRAH 6513 Machine Machine : 10.25 150 15249 ##HUHHHH 6510 Labor Skill 7.25 151 15250 ##HUHHHH 6506 Material Mat 1 3.5 152 6507 Labor Normal 6.5 153 15252 ### 6519 Machine Machine : 13.75 154 15253 #HUBSHAN 6511 Machine Machine : 8.5 155 15254 ##HUHHUH 6510 Material Mat 3 40.5 156 15255 ###UHHUH 6511 Material Mat 2 21 157 15256 #UHUHHUH 6518 Material Mat 2 17.5 158 15257 6508 Labor Normal 3.5 159 15258 ##HOUSES 6511 Labor Normal 8 160 15259 ##HUHHUH 6506 Labor Normal 3 161 15260 ##HUHHUH 6509 Material Mat 1 28 162 15261 ##HUH 6512 Labor Normal 8.5 163 15262 6507 Labor Normal 7.5 164 15263 #UHUHHUH 6506 Machine Machine : 9 165 15264 #HUFF 6511 Labor Normal 7.5 166 15265 #HUSSEIN 6515 Labor Normal 7 167 15266 ##HUHHUH 6506 Machine Machine : 2.5 168 15267 #HUHHUH 6508 Labor Normal 8.25 169 15268 #HEUSSEN 6512 Labor Normal 7.25 170 15269 6500 Labor Normal 4.25 171 15270 #HUHHUHH 6505 Machine Machine : 6.25 172 15271 6503 Material Mat 1 10 173 15272 ##HUHHUH 6513 Labor Skill 7.75 174 15273 ###UHHHH 6502 Labor Normal 8 175 15274 ##BUSBEE 6515 Labor Skill 6.5 176 15275 ##HUHHUH 6512 Material Mat 3 18 177 15276 PROPROAR 6508 Material Mat 3 26.5 178 15277 #HUBSSHE 6500 Material Mat 1 42.5 179 15278 ###BU#HI 6504 Material Mat 2 35.5 180 15279 ###! 6514 Material Mat 2 10.5 181 15280 #BUS##HH 6509 Labor Normal 6.5 182 15281 ##HUSHHI 6502 Labor Normal 4.5 183 15282 PAPAROAR 6517 Machine Machine : 14.75 184 15283 ###UHHHH 6514 Labor Skill 8.5 185 15284 #HHHHI 6513 Labor Normal 4.5 186 15285 ##HUHHUH 6507 Labor Normal 3.25 187 15286 #HUHHUH 6505 Material Mat 2 9 188 15287 ##HUHHUH 6516 Material Mat 1 38.5 189 15288 PPPPPPIT 6513 Machine Machine : 19 190 15289 #UHUHHUH 6512 Labor Normal 5.5 191 15290 ####UHHH 6510 Labor Normal 6 192 15291 #HUBPAPA 6500 Material Mat 2 44.5A B C D E F 193 15292 HUHUHHUH 6514 Material Mat 2 6 194 15293 #HUHHUHH 6517 Material Mat 1 18.5 195 15294 #UHUHHUH 6510 Machine Machine : 15 196 15295 #UHUHHUH 6515 Labor Normal 6.75 197 15296 #UHUHHUH 6502 Material Mat 1 38.5 198 15297 #UHUHHUH HHHHHHHH 6509 Labor Skill 5 199 15298 AHHHHHOW 6510 Machine Machine : 2.25 200 15299 HHHHHHHH 6509 Labor Normal 2.25 201 15300 HHHHHHHH 6505 Labor Normal 8.25 202 15301 AHHHHHH 6502 Labor Normal 4 203 15302 6509 Machine Machine : 17 204 15303 PRHHHHHH 6518 Labor Skill 2.75 205 15304 ARDOHHHH 6500 Labor Normal 6 206 15305 6509 Material Mat 1 9 207 15306 6513 Labor Skill 6.75 208 15307 #HHUHHUH HHHHHHHH 6503 Labor Skill 8.75 209 15308 #UHUHHUH 6511 Machine Machine : 5.5 210 15309 #UHUHHUH 6507 Labor Normal 6.25 211 15310 #UHHHHHH HHHHHHHH 6505 Labor Skill 7.5 212 15311 6519 Labor Normal 5.75 213 15312 6508 Labor Normal 8 214 15313 HHHHHHHH 6502 Labor Skill 7.25 215 15314 #8HUHHUH 6511 Material Mat 1 32.5 216 15315 AHH HHHH 6513 Labor Normal 5 217 15316 ARBOHHHH 6508 Machine Machine : 6.75 218 15317 #HUHHHHH 6514 Machine Machine : 16.25 219 15318 6519 Labor Skill 5.75 220 15319 6510 Machine Machine : 4.5 221 15320 #UHUHHUH THATHHHH 6505 Labor Skill 5 222 15321 6509 Labor Normal 2.5 223 15322 6518 Material Mat 1 43.5 224 15323 HHHHHHHH 6504 Labor Skill 6.25 225 15324 FROMHHHH 6510 Labor Skill 4 226 15325 #HHHHHHH 6503 Material Mat 1 11.5 227 15326 #UHUHHUH 6515 Labor Skill 7.75 228 15327 HHHHHHHH 6511 Labor Normal 8.5 229 15328 # 6512 Labor Normal 8.75 230 15329 6507 Material Mat 1 16 231 15330 6501 Material Mat 2 11.5 232 15331 6510 Machine Machine : 7.25 233 15332 6519 Material Mat 1 32 234 15333 6515 Machine Machine : 15.25 235 15334 PHHHHHHH 6506 Labor Normal 6.75 236 15335 #8HUHHUH 6517 Labor Normal 3.5 237 15336 #HUHHUH! 6500 Labor Normal 6.25 238 15337 #UHUHHUH 6517 Machine Machine : 6.75 239 15338 PROAHHHH 6503 Labor Normal 7 240 15339 AHHHHHH 6513 Labor Normal 6A C D E F 241 15340 6507 Material Mat 2 34 242 15341 6512 Material Mat 1 43 243 15342 6508 Labor Normal 6.5 244 15343 6511 Material Mat 2 5 245 15344 6510 Material Mat 3 2.5 246 15345 THATHHHH 6507 Machine Machine : 2.75 247 15346 ##HUHHUH 6503 Labor Normal 8 248 15347 6517 Labor Normal 6.5 249 15348 6504 Labor Normal 5.5 250 15349 PRAOHHHH 6500 Material Mat 2 2.5 251 15350 6505 Machine Machine : 6 252 15351 6506 Labor Normal 2.75 253 15352 6513 Labor Normal 8.75 254 15353 6503 Material Mat 1 18.5 255 15354 ##HUHHUH 6502 Machine Machine : 10.5 256 15355 6516 Labor Normal 2.5 257 15356 6505 Material Mat 2 3.5 258 15357 6502 Material Mat 2 29 259 15358 6519 Material Mat 2 34.5 260 15359 6519 Material Mat 2 31.5 261 15360 6512 Material Mat 2 36.5 262 15361 6515 Material Mat 2 9.5 263 15362 6503 Material Mat 3 14 264 15363 6506 Machine Machine : 13 265 15364 #HHUHHUH 6517 Labor Skill 6.25 266 15365 6501 Material Mat 3 41 267 15366 6513 Labor Normal 4.25 268 15367 6519 Labor Normal 7.25 269 15368 6504 Labor Normal 5.25 270 15369 6509 Labor Skill 3.5 271 15370 6501 Labor Normal 8.75 272 15371 6508 Material Mat 2 12 273 15372 6508 Material Mat 2 21.5 274 15373 6515 Machine Machine : 19.25 275 15374 6505 Labor Normal 5.5 276 15375 6508 Machine Machine : 15.75 277 15376 6511 Machine Machine : 13.5 278 15377 6514 Labor Normal 4.75 279 15378 6508 Labor Skill 3 280 15379 6505 Labor Normal 4 281 15380 #UHUHHUH 6503 Labor Skill 3.5 282 15381 6505 Material Mat 1 22.5 283 15382 6502 Labor Normal 3 284 15383 #HUHHUHH 6516 Material Mat 1 24 285 15384 PHHHHHHH 6515 Material Mat 2 16 286 15385 PRHHHHHH 6517 Labor Normal 3.25 287 15386 AHH HHHH 6517 Labor Skill 2.25 288 15387 6513 Labor Skill 7.25