Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 vot Tables maintain. Use the Excel spreadsheet included here which provides December's Sales Report: Week 3 Excel Assignment xls 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 feat ures 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) 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 i dealing with sure which customer.Be to RT the data in descending order to show the highest sales by customer to ensure we see the customers in order of most sales 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 3. Using what you have learned thus far in ncluding the company name, time period of the report, and the type of report 4. Label the Worksheets within the Excel Workbook accordingly once you have completed the pivot tables 5. On the appropriate worksheet, answer the following questio 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
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