Question: I ' m having trouble with the formula using index, match, and max. b 2 . What is the SKU with the highest gross margin?

I'm having trouble with the formula using index, match, and max.
b2. What is the SKU with the highest gross margin? Hint: Use INDEX, MATCH and MAX formulas.
SKUDescriptionSales PriceCostGross MarginGross Margin %DJI-AC2DJI Action 25193112080.4008DJI-OM5DJI OM 515996630.3962DJI-AIRDJI AIR 2S 9996163830.3834DJI-DSCDJI Action 2 Dual-Screen Combo 5193152040.3931DJI-2PCDJI Action 2 Power Combo 3992391600.4010DJI-OM4DJI OM 4 SE 11972470.3950DJI-PO2DJI Pocket 24392701690.3850OSM-P11Osmo Pocket 2991821170.3913OSM-A11Osmo Action 199125740.3719DJI-FLPDJI OM Fill Light Phone Clamp 5936230.3898DJI-P2DDJI Pocket 2 Do-It-All Handle 9959400.4040DJI-AIFDJI Air 2S Fly More Combo 1,7491,0826670.3814DJI-MI2DJI Mini 24492851640.3653MAV-AR2Mavic Air 27994993000.3755MAV-2IIMavic 21,5999766230.3896DJI-SMCDJI Smart Controller 7494502990.3992DJI-2FIDJI Air 2S ND Filters Set 9962370.3737MAV-AI2Mavic Air 2 Intelligent Flight Battery 11572430.3739DJI-MINDJI Mini Bag+3923160.4103DJI-FPVDJI FPV Combo 1,2998024970.3826DJI-MMCDJI Motion Controller 199122770.3869DJI-FMKDJI FPV Fly More Kit 2991811180.3946DJI-IFBDJI FPB Intelligent Flight Battery 159101580.3648DJI-GBADJI FPV Goggles Battery 2918110.3793

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!