(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)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Introduction To Data Analytics For Accounting

ISBN: 9781266358234

2nd Edition

Authors: Vernon Richardson, Katie Terrell And Ryan Teeter

Question Posted: