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 1-8(LO 1.5) 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 percentage[(Sales Price - Cost)/Sales Price] for each SKU (product).(This 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 3 decimal places. Round average and median gross margin percentage to 1 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. 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-CIKSK2-PRKSK2-SPKSK2-STKAnswer
 P 1-8(LO 1.5) Download the SkyDio Drone SKU data set. In

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 General Management Questions!