Question: P 1 - 8 ( LO 1 . 5 ) Download the SkyDio Drone SKU data set. In Excel,...Required:Download the SkyDio Drone SkU data set.
P LO Download the SkyDio Drone SKU data set. In Excel,...Required:Download the SkyDio Drone SkU data set. In Excel, calculate the gross margin Sales Price Cost and gross margin percentageSales Price CostSales Price for each SKU productThis problem may require a review of Excel skills, which you will find inAppendix A at the back of this book.Note: Round gross margin percentage to decimal places. Round average and median gross margin percentage to decimalplace.Questiona. 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 UseMIN 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.SKCIKSKPRKSKSPKSKSTKAnswer
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
