Download the DJI Mavic Drone SKU data set. In Excel, calculate the gross margin (Sales Price
Question:
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 |
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
a DJIAIF or DJI Air 2S Fly More Co...View the full answer
Answered By
Asim farooq
I have done MS finance and expertise in the field of Accounting, finance, cost accounting, security analysis and portfolio management and management, MS office is at my fingertips, I want my client to take advantage of my practical knowledge. I have been mentoring my client on a freelancer website from last two years, Currently I am working in Telecom company as a financial analyst and before that working as an accountant with Pepsi for one year. I also join a nonprofit organization as a finance assistant to my job duties are making payment to client after tax calculation, I have started my professional career from teaching I was teaching to a master's level student for two years in the evening.
My Expert Service
Financial accounting, Financial management, Cost accounting, Human resource management, Business communication and report writing. Financial accounting : • Journal entries • Financial statements including balance sheet, Profit & Loss account, Cash flow statement • Adjustment entries • Ratio analysis • Accounting concepts • Single entry accounting • Double entry accounting • Bills of exchange • Bank reconciliation statements Cost accounting : • Budgeting • Job order costing • Process costing • Cost of goods sold Financial management : • Capital budgeting • Net Present Value (NPV) • Internal Rate of Return (IRR) • Payback period • Discounted cash flows • Financial analysis • Capital assets pricing model • Simple interest, Compound interest & annuities
65+ Reviews
86+ Question Solved
Related Book For 
Introduction To Business Analytics
ISBN: 9781265454340
1st Edition
Authors: Vernon Richardson, Marcia Watson
Question Posted:
