8 2 points -DO You are interested in analyzing different implant parts being made in a bioengineering production facility. The company can make nine different parts for shoulder, knee, or hip replacement. On the worksheet shown, you have created a place for the user to choose the body location (shoulder, knee, or hip) in cell B5 using a data validation list. Once the body location is set, a list of material choices will appear in cells D5 to F5. The user can choose a material in cell B6 using a data validation list. If the material chosen does not match one of the possible choices in cells D5 to F5, a warning will be issued for the user to choose another material. In cell B9, the user will choose if the part is size small (S), medium (M), or large (L) using a data validation list. Based upon body location and size, the part number will adjust automatically using a VLOOKUP function. After the part number has been determined, the material weight (cell B11) and part volume (cell B12) will adjust automatically using a VLOOKUP function. The user will enter the number of desired parts in cell B14. If the user requests more than 250 parts, a warning of "Too Many" will be issued; if the user requests fewer than 20 parts, a warning of "Too Small" will be issued in cell C14. The amount of material to be ordered will be determined in cell B16 by multiplying the number of parts and the material weight. The cost of the material to be ordered will be determined in cell B17. If the order cost is greater than $1000, a request to "Check with Purchasing" will appear; otherwise, the cost of the order will appear. Finally, in cell B18 the amount of boxes needed for shipping will appear determined by the number of parts requested and the number of parts per box, based on the part number chosen in cell B10. Lookup functions in Excel contain four parts. =VLOOKUP (_(1), (2). (3). Fill in the following information in the VLOOKIID function used to determine the third & Return Submit Nasty Vim patTUTINCT CRUSH I MIDTV. Lookup functions in Excel contain four parts. =VLOOKUP (_ (1), (2), (3). Fill in the following information in the VLOOKUP function used to determine the third possible material choice in cell F5 based on the choice of body location in cell B5. Body Lacation MATAL Cost/bm of material Material Chaices Auth WC-2 CuAg-5 Wang Material Match/Choose Again $ 22.00 Bory Incation Shoulder Part Part Number 102 Material Weight 0.45 Number/Box 76 Part Veluma (Energy Cost/Part 55 0.1 Shoulder 163 0.15 24 35 004 Shoulder 15 0.15 35 15 0.09 Hip KAS 64 15 0.02 KALL 0.1 2 23 0.00 = 132 04 M 6 002 053 05 65 0.07 057 03 98 15 0.05 D38 04 93 S 0.04 Body Lacation Material Choice Knee Hip Auto-4 2006-2 Pt2n-4 CoN-7 Cule 5 PIC MICO MnP-B Knee Part Part Number Knee Material Weight m 0.15 Part Volume cl 25 Material Material Cost/m Auls-4 5.00 Number of Part Two Many CUAES 7.00 16 Amount of Matto Order 45 Fast- 22.00 1 Cast of Matt Order (5) $990.00 Fasis 2.00 18 Amount of Bowes Needed 1800 Cate 24.00 20 Colg-12 CEAL-2 13.00 Pn-4 19.00 100 SeCo-4 ZW- $ 7.00 MR 13.00 11.00 The lookup statement typed into cell F5 is type your answer... Submit