Download the DJI Mavic 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) a Which product SKU and description has the highest gross margin b Which product SKU and description has the highest gross margin percentage c Which product SKU and description has the lowest gross margin d Which product SKU and description has the lowest gross margin percentage e What are the average and median gross margin DJI Mavic Drone SKU data set SKU Description Sales Price Cost DJI AC2 DJI Action 2 519 311 DJI OM5 DJI OM 5 159 96 DJI AIR DJI AIR 2S 999 616 DJI DSC DJI Action 2 Dual Screen Combo 519 315 DJI 2PC DJI Action 2 Power Combo 399 239 DJI OM4 DJI OM 4 SE 119 72 DJI PO2 DJI Pocket 2 439 270 OSM P11 Osmo Pocket 299 182 OSM A11 Osmo Action 199 125 DJI FLP DJI OM Fill Light Phone Clamp 59 36 DJI P2D DJI Pocket 2 Do It All Handle 99 59 DJI AIF DJI Air 2S Fly More Combo 1749 1082 DJI MI2 DJI Mini 2 449 285 MAV AR2 Mavic Air 2 799 499 MAV 2II Mavic 2 1599 976 DJI SMC DJI Smart Controller 749 450 DJI 2FI DJI Air 2S ND Filters Set 99 62 MAV AI2 Mavic Air 2 Intelligent Flight Battery 115 72 DJI MIN DJI Mini Bag 39 23 DJI FPV DJI FPV Combo 1299 802 DJI MMC DJI Motion Controller 199 122 DJI FMK DJI FPV Fly More Kit 299 181 DJI IFB DJI FPB Intelligent Flight Battery 159 101 DJI GBA DJI FPV Goggles Battery 29 18

Question: Download the DJI Mavic Drone SKU data set. In Excel, calculate the gross margin (Sales Price Cost) and gross margin percentage [(Sales Price

Download the DJI Mavic 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).

a. Which product SKU and description has the highest gross margin?

b. Which product SKU and description has the highest gross margin percentage?

c. Which product SKU and description has the lowest gross margin?

d. Which product SKU and description has the lowest gross margin percentage?

e. What are the average and median gross margin?

DJI Mavic Drone SKU data set

SKU	Description	Sales Price	Cost
DJI-AC2	DJI Action 2	519	311
DJI- OM5	DJI OM 5	159	96
DJI-AIR	DJI AIR 2S	999	616
DJI-DSC	DJI Action 2 Dual-Screen Combo	519	315
DJI-2PC	DJI Action 2 Power Combo	399	239
DJI-OM4	DJI OM 4 SE	119	72
DJI-PO2	DJI Pocket 2	439	270
OSM-P11	Osmo Pocket	299	182
OSM-A11	Osmo Action	199	125
DJI-FLP	DJI OM Fill Light Phone Clamp	59	36
DJI-P2D	DJI Pocket 2 Do-It-All Handle	99	59
DJI-AIF	DJI Air 2S Fly More Combo	1749	1082
DJI-MI2	DJI Mini 2	449	285
MAV-AR2	Mavic Air 2	799	499
MAV-2II	Mavic 2	1599	976
DJI--SMC	DJI Smart Controller	749	450
DJI-2FI	DJI Air 2S ND Filters Set	99	62
MAV-AI2	Mavic Air 2 Intelligent Flight Battery	115	72
DJI-MIN	DJI Mini Bag+	39	23
DJI-FPV	DJI FPV Combo	1299	802
DJI-MMC	DJI Motion Controller	199	122
DJI-FMK	DJI FPV Fly More Kit	299	181
DJI-IFB	DJI FPB Intelligent Flight Battery	159	101
DJI-GBA	DJI FPV Goggles Battery	29	18

Step by Step Solution

★★★★★

3.57 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a DJIAIF or DJI Air 2S Fly More Co... View full answer

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 Business Analytics Data Questions!

The following table gives the sales, product cost, and cost-to-serve data for a merchandising store. The store has four types of merchandise and three types of customers. The costs to serve all...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Big Data. Modern analyses can generate thousands of data points. This problem introduces techniques for handling larger data sets. A spreadsheet with the data can be found on SaplingPlus or at...

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

Required: Download the DJI Mavic 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 (...

Download the DJI Mavic 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 ) ....

Required: Download the DJI Mavic 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 (...

Required: Download the DJI Mavic Drone SKU data set. In Excel, calculate the gross margin ( Sales Price - Cost ) and gross margin percen [ ( Sales Price - Cost ) / Sales Price ] for each SKU (...

Consider a cylindrical specimen of a steel alloy (Figure 6.21) 10.0 mm (0.39 in.) in diameter and 75 mm (3.0 in.) long that is pulled in tension. Determine its elongation when a load of 20,000 N...

The global financial crisis emerged in 20082009. What were the major symptoms of the crisis? What were the major causes? What role did excessive money supply play in the emergence of the crisis? Why...

The sustainable growth rate is a rate that a firm can maintain given its debt capacity, ROE, and payo True or False 2

What are you looking for in the person who takes this position?

Use regression analysis to answer the following questions. a. Fit a linear trend model to the data set. What is the estimated regression function? b. Interpret the R2 value for your model. c. Prepare...

Compute the two-period and four-period moving average predictions for the data set. a. Prepare a line graph comparing the moving average predictions against the original data. b. Compute the MSE for...

Use Solver to determine the weights for a four-period weighted moving average on the data set that minimizes the MSE. a. What are the optimal values for the weights? b. Prepare a line graph comparing...

On May 6, Sheridan Depot returns goods (not defective) with a selling price of $160 and a cost of $56 to Skysong and receives a credit on account. Record the transaction for Skysong. (Credit account...

2 points: Examine the following transaction: Dr. Accounts Receivable 1,000 Cr. Allowance for Doubtful Accounts Dr. Cash 1,000 Cr. Accounts Receivable 1,000 1,000 What would be an appropriate journal...

Gurung Co. has a noncontributory, defined benefit pension plan adopted on 1 January 20X5. On 31 December 20X5, the following information is available For accounting purposes Interest rate used for...