please I need answers of the questions 6 and 7.thanks.

Exercise 2 QOH 3) Make cell "15" a drop down list where you can select from the various "htem Groups forange cell 4) Insert a formula in cell "US" that will automatically generate the total cost per item group noted in cell "IS" (green cell) 5) Use a "vlookup" formula and the "Item Roll Up" tab (red tab) to populate the "Item Group Roll Ups" in column D (purple column) 6) In column H, define the ABC class for each item. All items in Item Group "Medicines" or "Medical equip greater than $5k" should be class A. Items not in cither of those categories that have a total cost / item of great than $5,000 should be class B All Other Items should be class 7) Create a new tab for the Executive Leadership Team (ELT) with a Pivot Table summarizing Total Costs by "Item Group Roll Up" This pivot table should also allow ELT to expand drill in to see total cost by "htem Group" and then by "Item". Please include any other data analysis you think ELT may want to see ABC Class Unit Cost 1.331 0.03 1.5 0.01 0.708 Quantity of Enits) Total Cost Item 148 707 396 401 717 Item Number 10001 10002 10003 10004 10005 10005 10007 1000 10009 10010 10011 10012 1001 685 0.458 2.84 TO 0.124 100 10 0,033 009 11:18 548 802 626 972 3 Item Name Item Group Item Group Roll Up Mask. Oxygen, Nonrebreather, Pediatrie Medical supplies Methyldopa 250mg. Film coated tablet Medicines Salbutamol, 100mcg dose, 200 dose inhaler Medicines Magnesium trisilicate 250mg + Aluminium hydroxide 12 Medicines Suture, Polyglycolic acid, 0, 3/8 circle 35mm needle, Abe Medical supplies Printer paper roll for Pima CD4 analyzer Medical supplies Wax, Dental, Modeling, Pink 500g (24 sheets) Medical supplies Arm sling, Medium Medical supplies Tape, Identification, for surgical instruments, Blue, 0.25in Medical supplies Sleeve, for complete curing light Medical supplies Standard sail, Surgical implant, for SIGN system, mmx Medical supplies Tape, Identification, for surgical instruments, Orange, 0.2: Medical supplies Pipette, Pasteur (transfer) Glass, Flint Soda Lime, 5.75in, Medical supplies Tuhe. Feeding, Nasogastric, Sterile, 10Fr. 40cm Medical supplies File, Bone, Howard 12 Medical supplies Catheter, Thoracic, Straight, Sterile, 32Fr x 20 in Medical supplies Bandage, Compression, Self-adhesive. Nonsterile, Hem Medical supplies Stockinette, Cotton, Nonsterile, 4in x 25yd roll Medical supplies Cap screw, Shoulder Medical supplies Tube, Endotracheal, Cuffed, Murphy eye, Magill curve, N Medical supplies Catheter, Umbilical, CH 5, 35cm. Sterile. Disposable Medical supplies Paper points, Sterile, Size 0.04. Assorted 15.40, Color cor Medical supplies Towel, OR, Sterile, 17in x 27in Medical supplies Band, Resistance, Blue, 25yd Medical supplies Ring. O, for chemo hood, in Medical supplies Sealant, for haematocrit capillary tube Medical supplies Band, Resistance, Green, 25yd Medical supplies Lidocaine, with prilocaine, 2.5%, cream, 30g tube Medicines Finishing Strip, Course Medium Medical supplies Tube, Feeding, Nasogastric, Sterile, 5Fr. 40cm Medical supplies Film, Laboratory Wrapping, 2in 250troll Medical supplies Cartridge for GeneXpert machine, MTB/RIF Medical supplies Vitamin B compound, Tablet Medicines Hydrochloric acid 3% + Ethanol alcohol). gi Medical supplies Tube, Endotracheal, Cuffed, Murphy eye, Magill curve, N Medical supplies Indian ink, Black, 100ml Medical supplies HTH Granular 45 kg Medical supplies Composite material Refill, 1 x 4.58 Syringe, AZ Medical equiple thank 10015 10016 10017 10018 10019 10020 10021 10022 10023 10024 10025 56 213 196 376 0.88 0.885 SO 0686 74 0.075 0.606 59.12 5 1.958 53.98 27 170 994 664 994 552 749 10028 10029 10030 10031 10032 10033 10034 10035 10036 10037 10039 10041 0.1 19.95 9.98 0.005 12.95 1.385 1 160 17.5 16