Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I JUST NEED THE ANSWERS TO THE QUESTIONS A-F Required: Answer the following questions using the information provided by the completed Pivot Tables a. Who
I JUST NEED THE ANSWERS TO THE QUESTIONS A-F
Required: Answer the following questions using the information provided by the completed Pivot Tables a. Who sells the most of Product A? b. Who sells the most of Product B? c. Who is selling the least of either product? d. Which product is the company selling more of? e. Which customers have the highest in order sales? f. Give an example of how this information can be used to help Small Builders, Inc. in maintaining their relationship with the customers we have identified? Order Date Order Amount ustomer Salesperson Product ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland 30.00 Manufacturing Directly, Inc. Johnson, Larry 560.00 60.00 $45.00 550.00 Built Tough, Inc ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc.Lars, 60.00 Manufacturing Directly, Inc.Johnson, Larry $45.00 550.00 575.00 60.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 550.00 560.00 530.00 30.00 Manufacturing Directly, Inc. Johnson, Larry ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc.Lars, 4 12/5/16 5 12/6/15 Lenny's Shap, LLC Owen, Rab Levies by Lee, LLC Christen, Bill Jobs for Less, Inc Owen, Rob 7 12/6/15 8 12/6/15 ABC Works, Inc. Smith, Roland 12/11/15 112/12/15 212/13/15 560.00 $45.00 550.00 obs for Less, Inc Johnson, Larry Engine Repair, LLC Erics, Rebecca Engine Repair, LLC Erics, Rebecca Little Engineers, Inc. Lars, Sam Repairs by Larry, LLC Erics, Rebecca 560.00 50.00 Manufacturing Directly, Inc.Johnson, Larry 545.00 Manufacturing Directly, Inc.Johnson, Larry 712/18/15 812/19/15 9 12/20/15 Built Tough, Inc 560.00 530.00 12/21/15 Bandwagon, Inc. Owen, Rab Afternoon Too, Inc. Johnson, Larry Afternoon Too, Inc.Johnson, Larry ABC Works, Inc. Smith, Roland 112/21/15 12/21/15 575.00 $45.00 3 12/21/15 4 12/25/15$75.00 5 12/26/15 6 12/27/15 7 12/28/15 8 12/29/15 Jobs for Less, Inc Johnson, Larry Jobs for Less, Inc Johnson, Larry Little Engineers, Inc. Lars, Sam 530.00 575.00 Built Tough, Inc ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland 0 12/31/15 550.00 1,950.00Step 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