(LO 2-7) Download the Skydio Drone Sales Journal dataset in Excel. Note the sales price and cost...

Question:

(LO 2-7) Download the “Skydio Drone Sales Journal” dataset in Excel. Note the sales price and cost of each sale. In Excel, calculate the gross margin (Sales Price – Cost) for each line of the invoice. Use a PivotTable to determine the following. It may be helpful to perform this project after completing Lab 2-1 Excel, Lab 2-2 Excel, or Lab 2-3 Excel.

Required:

1. What is the total gross margin for customer 3022?

2. What are the total sales for customer 3000?

3. What is the total cost of sales for customer 3039?

4. Which customer bought the most during the month?

5. Which customer bought the least during the month?

6. What was the total customer sales for the month for the company?

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

Step by Step Answer:

Answer rating: 100% (1 review)

Answered By

Joel mwangi

Greetings! I am a highly qualified and dedicated tutor with a passion for instilling a love for the sciences in my students. Holding a Master's degree in Chemistry, I bring over a decade of enriching experience in teaching both Biology and Chemistry at higher levels. My academic background has equipped me with a deep understanding of the subject matter, allowing me to foster a dynamic and engaging learning environment. My expertise extends beyond traditional classrooms, as I have successfully navigated the realm of online tutoring for over 5 years. This experience has honed my ability to adapt to diverse learning styles and create personalized approaches that cater to individual needs. I find immense joy in breaking down complex scientific concepts into digestible, easy-to-understand components, ensuring that my students not only grasp the material but also develop a profound appreciation for the subject matter. Beyond the confines of the laboratory, my interests span across both physical and social sciences. This broad perspective allows me to connect seemingly disparate ideas, offering a holistic understanding of the interconnectedness of various scientific disciplines. I am not only a teacher but also a lifelong learner, continuously seeking new ways to enhance my own knowledge and share these insights with my students. One of my standout skills lies in my mastery of various writing formats. This proficiency enables me to guide students not only in understanding scientific principles but also in expressing their ideas eloquently in both oral and written forms. I firmly believe that effective communication is paramount in the learning process, and I strive to empower my students with the skills necessary to articulate their thoughts with clarity and precision. My commitment to excellence is reflected not only in my academic qualifications and teaching experience but also in my high proficiency in the English language. Clear communication is the cornerstone of effective teaching, and I ensure that my students are equipped with the language skills needed to excel in their academic pursuits.

5.00+ 2+ Reviews 10+ Question Solved

Related Book For book-img-for-question