Question

Small Builders, Inc. has two lines of business: product and service. Their product line of business offers 2 products: Product A and Product B. In this assignment, you will use Pivot Tables to help show which product is more successful, which salesperson is selling the most or the least and which customer(s) are the most important relationships to maintain. Use the Excel spreadsheet included here which provides December's Sales Report: Week 4 Assignment 2.xls Pivot Tables Required: 1. Format the Sales Report given including: adding a header to identify the name of the company, time period, and type of report. Also include other features you have learned to correct the formatting of the table, such as bold font or borders 2. Create the following Pivot tables depicting the following information (Hint: Each will be shown on their own worksheet): a. Sum of Orders by Product and by Salesperson this will show us which product we are selling more of and who is selling each product more/less. Be sure to SORT the data in descending order to show the highest sales by salesperson under each product b. Sum of Orders by Product and by Customer this will show us which product is being sold to which customer and the amount of the sales. Be sure to SORT the data in descending order to show the highest sales by customer under each product. c. Salesperson by Customer -this will show us which salesperson is dealing with which customer.Be sure to SORT the data in descending order to show the highest sales by customer to ensure we see the customers in order of most sales 3. Using what you have learned thus far in the course, adjust the formatting of the reports to center them on the middle of the page and add a header to label the report, including the company name, time period of the report, and the type of report 4. Label the Worksheets within the Excel Workbook accordingly 5. On the appropriate worksheet, answer the following questions once you have completed the 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? 6. Upload your assignment by clicking on "Week 3 Assignment" above

Please show the formulas that need to be used if needed. Thank you

Answer 1

Salesperson by Customer:

Sum of Orders by Product and by Salesperson:

Salesperson by Customer: