100- Paste B11 6 7 1 SKU 2 SK2-STK 3 SK2-SPK 4 SK2-CIK 5 SK2-PRK SK2-CHG...

Transcribed Image Text:

100- Paste B11 6 7 1 SKU 2 SK2-STK 3 SK2-SPK 4 SK2-CIK 5 SK2-PRK SK2-CHG MEM-128. 8 MEM-256 9 MEM-64 10 SK2-BEA 11 SK2-JOY 12 SK2-ADP 13 SK2-USB 14 SKY-PLR 15 PRK-CSE 16 CAM-FIL 17 SKY-BAT 18 SKY-PLR 19 SKY-STK 20 SKY-SPK 21 SKY-PRK 22 SKY-CHG 23 SKY-BAT 24 25 26 27 28 29 30 31 32 33 34 A 35 Insert Draw Page Layout X 36 V Ready Calibri (Body) BIU A V Description Skydio 2 Starter Kit Skydio 2 Sports Kit Skydio 2 Cinema Kit V XV fx Joystick Controller B C Sales Price Skydio 2 Pro Kit Dual Charger SanDisk 128 GB MicroSD Ca SanDisk 256 GB MicroSD Ca SanDisk 64 GB MicroSD Carc Skydio 2 Beacon Joystick Controller Wall Adapter 65W Skydio Controller USB-C to L Skydio 1 Propellers Pro Hard Case PolarPro ND Filters Skydio 1 Battery Skydio 1 Propellers Skydio 1 Starter Kit Skydio 1 Sports Kit Skydio 1 Pro Kit Dual Charger Skydio 1 Battery Sheet1 + 12 Accessibility: Good to go V 949 1399 1799 2599 149 59 69 49 219 179 34 19 Formulas 29 229 69.99 115 25 799 1199 2299 129 115 v Cost D 541 752 1060 1486 86 35 40 31 114 107 20 11 17 133 40 66 14 461] 718 1234 77 65 Data Review Vie M E F > G eBook Print References place. Question a. Which product SKU has the highest gross margin? (Hint: Use=MAX() Excel function to calculate.) b. Which product has the highest gross margin percentage? (Hint: Use MAX() Excel function to calculate.)) c. Which product has the lowest gross margin? (Hint: Use MIN) Excel function to calculate.) d. What is the gross margin percentage of the product SKU and description with the lowest gross margin percentage? (Hint: Use -MIN() Excel function to calculate.) e. What is the average gross margin percentage? (Hint: Use "AVERAGE() Excel function to calculate.) e. What is the median gross margin percentage? (Hint: Use =MEDIAN() Excel function to calculate.) SK2-SPK SK2-CIK SK2-PRK SK2-SPK SK2-STK Answer 100- Paste B11 6 7 1 SKU 2 SK2-STK 3 SK2-SPK 4 SK2-CIK 5 SK2-PRK SK2-CHG MEM-128. 8 MEM-256 9 MEM-64 10 SK2-BEA 11 SK2-JOY 12 SK2-ADP 13 SK2-USB 14 SKY-PLR 15 PRK-CSE 16 CAM-FIL 17 SKY-BAT 18 SKY-PLR 19 SKY-STK 20 SKY-SPK 21 SKY-PRK 22 SKY-CHG 23 SKY-BAT 24 25 26 27 28 29 30 31 32 33 34 A 35 Insert Draw Page Layout X 36 V Ready Calibri (Body) BIU A V Description Skydio 2 Starter Kit Skydio 2 Sports Kit Skydio 2 Cinema Kit V XV fx Joystick Controller B C Sales Price Skydio 2 Pro Kit Dual Charger SanDisk 128 GB MicroSD Ca SanDisk 256 GB MicroSD Ca SanDisk 64 GB MicroSD Carc Skydio 2 Beacon Joystick Controller Wall Adapter 65W Skydio Controller USB-C to L Skydio 1 Propellers Pro Hard Case PolarPro ND Filters Skydio 1 Battery Skydio 1 Propellers Skydio 1 Starter Kit Skydio 1 Sports Kit Skydio 1 Pro Kit Dual Charger Skydio 1 Battery Sheet1 + 12 Accessibility: Good to go V 949 1399 1799 2599 149 59 69 49 219 179 34 19 Formulas 29 229 69.99 115 25 799 1199 2299 129 115 v Cost D 541 752 1060 1486 86 35 40 31 114 107 20 11 17 133 40 66 14 461] 718 1234 77 65 Data Review Vie M E F > G eBook Print References place. Question a. Which product SKU has the highest gross margin? (Hint: Use=MAX() Excel function to calculate.) b. Which product has the highest gross margin percentage? (Hint: Use MAX() Excel function to calculate.)) c. Which product has the lowest gross margin? (Hint: Use MIN) Excel function to calculate.) d. What is the gross margin percentage of the product SKU and description with the lowest gross margin percentage? (Hint: Use -MIN() Excel function to calculate.) e. What is the average gross margin percentage? (Hint: Use "AVERAGE() Excel function to calculate.) e. What is the median gross margin percentage? (Hint: Use =MEDIAN() Excel function to calculate.) SK2-SPK SK2-CIK SK2-PRK SK2-SPK SK2-STK Answer

Answer rating: 100% (QA)

Answer a The product SKU with the highest gross margin is SK2PRK Skydio 2 Pro Kit The gross ... View the full answer