Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Download the SkyDio Drone Sales Journal dataset in Excel. Note the sales price and cost of each sale. Required: In Excel, calculate the gross margin
Download the SkyDio Drone Sales Journal dataset in Excel. Note the sales price and cost of each sale. Required: In Excel, calculate the gross margin (Sales Price Cost) for each line of the invoice. Use a pivot table to determine the following. It may be helpful to perform this project after completing Lab 1.3 Excel, Lab 1.3 Tableau, or Lab 1.3 Power BL. a. What is the total gross margin earned from customer 30227 _ b. What are the total sales for customer 30007 d. Which customer bought the most during the menth? Customer 3013 &. Which customer bought the least during the month? Customer 3003 f. What was the total amount of customer sales for the month for the company? Mote: Round to 2 decimal places. c. What is the total cost of sales for customer 30397 _
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started