Sales and Accounts Receivable: Question 1 (In-class Assignment) Using the 2021 and 2022 data provided in this file, create a visualization to answer the following questions: a) Perform an analysis of sales by month, and by product line. Compare to prior month and prior year data. b) What trends do you notice in sales? Hints: In this question you compare sales by month and product line to the same month and product line in the prior year (i.e., compare each product sold in January 2021 to the same product sold in January 2022). To do this, you might create new variables that show the month and year from each transaction. We recommend a pivot table to create the data for your visualization.

Solved: Sales and Accounts Receivable: Question 1 (In-class Assignment) Using

Home
questions and answers
sales and accounts receivable question 1 in class assignment using the

Question

Sales and Accounts Receivable: Question 1 (In-class Assignment) Using the 2021 and 2022 data provided in this file, create a visualization to answer the following questions: a) Perform an analysis of sales by month, and by product line. Compare to prior month and prior year data. b) What trends do you notice in sales?