s
Required:
Download the DJI Mavic Drone SKU data set. In Excel, calculate the gross margin (Sales Price - Cost) and gross margin percentag
[(Sales Price - Cost)/Sales Price] for each SKU (product). (This problem may require a review of Excel skills, which you will find in
Appendix A at the back of this book.)
Note: Round average and median gross margin to 2 decimal places.
Question
a. Which product 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. Which product has the lowest gross margin percentage? (Hint: Use =MIN() Excel function to calculate.)
e. What is the average gross margin? (Hint: Use AVERAGE() Excel function to calculate.)
e. What is the median gross margin? (Hint: Use =MEDIAN() Excel function to calculate.)
Answer
