(LO 1-3, 1-5) Download the DJI Mavic Drone SKU dataset. In Excel, calculate the gross margin (Sales...
Question:
(LO 1-3, 1-5) Download the DJI Mavic Drone SKU dataset. In Excel, calculate the gross margin (Sales Price – Cost), and gross margin percentage (Sales Price – Cost)/Sales Price for each SKU (product). You may want to consider completing the Excel tutorial in Appendix A before completing this assignment.
a. What is the SKU with the highest gross margin? (Hint: Use =max() function to calculate)
b. What is the SKU with the highest gross margin percentage? (Hint: Use =max() function to calculate)
c. What is the SKU with the lowest gross margin? (Hint: Use =min() function to calculate)
d. What is the SKU with the lowest gross margin percentage? (Hint: Use =min() function to calculate)
e. What is the average and median gross margin of the SKUs offered for sale (round to two digits)? (Hint: Use =average() and =median() functions to calculate)
f. What is the average and median gross margin percentage of the SKUs offered for sale
(round to three digits)? (Hint: Use =average() and =median() functions to calculate)
Step by Step Answer:
Introduction To Data Analytics For Accounting
ISBN: 9781266358234
2nd Edition
Authors: Vernon Richardson, Katie Terrell And Ryan Teeter