Jason Home Products currently sells its products through multiple distribution channels. When the company first started, its

Question:

Jason Home Products currently sells its products through multiple distribution channels.

When the company first started, its home cleaning products were sold strictly through home party sales. About 15 years ago, the company set up a website and sold its products through its own website. It also sells its products on Amazon.com. Annual sales and gross profit data from the past eight years is shown in the following screenshot of an Excel worksheet that a company manager prepared. Access the Excel file online in the MyLab Accounting exercise to complete the requirements for this exercise.

image text in transcribed

Requirements:

1. Insert sparklines in Column J for the Sales Revenue and Gross Profit rows.
2. Which distribution channel(s) is trending upward in sales revenue over the eight-year time period?
3. Which distribution channel(s) is trending upward in gross profit over the eight-year time period?
4. Create a line chart to show the trend over the eight-year period for each of the following categories:

a. Sales Revenue

b. Gross Profit 

5. What conclusions can you draw from the sparklines and/or line charts?

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: