Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Audit Is An Audit Is An Audit

Authors: Marina Peters

1st Edition

B08B37VNZ6, 979-8652328412

More Books

Students also viewed these Accounting questions

Question

a. 6.6846 b. 10.57% c. 8.4896 d. 9.9575 e. 9.593k

Answered: 1 week ago