SC_EX19_EOM6-1_JestenWuollet_2

Author: Note: Do

Murray Medical CREATE, SORT, AND QUERY TABLES Jesten Wuollet Shelly Cashman Excel 2019 | Module 6: End of Module Project 1 o not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SA website.

Murray Medical Medical Monitoring De Criteria Range Client ID Client Name Account Rep Area Device SE Account Representativ Client ID Client Name Account Rep Area Device 2326 St. John's Hospital Hayati MW O2 Monitor 2141 Capital Clinic Hayati MW Destra 2355 Ridgeway Hospital Hirko NE Critiscope 2855 Parkview Medical Hirko NE Vivo II 3068 Donovan Medical Center Kruse NW Vivo II 2287 Agora Hospital Kruse NW Vivo II 2077 Northwest Hospital Kruse NW Vivo II 2701 Associated Healthcare Malick MW O2 Monitor 3014 Midwest Clinic Malick MW Destra 2310 LaMont Medical Clinic Soto NY Vivo III 2219 Mercy West Soto NW Vivo III 2203 First Choice Medical Wilkins SW O2 Monitor 3115 Dermatology Associates Wilkins SW AnesPro Total 19 Extract Range Client ID Client Name Account Rep Area Device 2340 Brevard Healthcare Flowers SE DataSigns 2198 Cox Family Care Gonzalez SE AnesPro 2911 East Grove Pediatric Gonzalez SE Vivo III 2275 Gulf Medical Center Silva SE Critiscope

l evices Bonus Tiers Total Sales Eval Score Tier Rep Bonus Score Tier >=100000 0 Bronze 6 Silver 8 Gold ves 9 Platinum Total Sales Eval Score Tier Rep Bonus $ 120,100 6.5 Silver $ - $ 47,750 7.0 Silver $ - $ 220,500 9.0 Platinum $ 11,025 $ 127,500 8.0 Gold $ - $ 107,500 9.5 Platinum $ 5,375 $ 57,500 9.0 Platinum $ 2,875 $ 28,500 8.5 Gold $ - $ 98,750 5.5 Bronze $ - $ 64,500 7.0 Silver $ - $ 66,800 5.0 Bronze $ - $ 30,650 4.5 Bronze $ - $ 56,300 6.0 Silver $ - $ 52,500 7.0 Silver $ - $ 1,078,850 7.1 $19,275 Total Sales Eval Score Tier Rep Bonus $ 105,500 6.5 Silver $ - $ 158,500 7.5 Silver $ - $ 140,500 7.0 Silver $ - $ 120,750 8.0 Gold $ -

Murray Medical Medical Monitoring Devices Device ID Device Name Type Release Date Unit Cost AN-2055 AnesPro Anesthesia system 8/14/2017 $ 5,087 CO-1840 Critiscope Continuous patient monitor 3/3/2015 $ 2,994 MR-1773 DataSigns MRI monitor 9/20/2018 $ 457 MO-2495 Destra Mobile patient monitor 10/1/2020 $ 254 PU-1384 O2 Monitor Pulse oximeter 4/12/2016 $ 177 VI-2251 Vivo II Vital signs monitor 9/5/2015 $ 1,168 VI-2252 Vivo III Vital signs monitor 10/17/2020 $ 1,386

Unit Price $ Profit % Profit $ 5,500 $ 413 8% $ 3,100 $ 106 3% $ 480 $ 23 5% $ 280 $ 26 9% $ 190 $ 13 7% $ 1,250 $ 82 7% $ 1,500 $ 114 8%