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.

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?

Transcribed Image Text:

1 Sales Revenue 2 Home party sales 3 Company website 4 Amazon.com Year 2 B D Year 1 Year 3 $375,000 $ 393,225 $ 403,921 $ $251,800 $ 280,253 $308,279 $ $ 301,390 $307,177 $ 361,240 $ F Year 8 Sparkline 296,729 G H Year 4 Year 5 Year 6 Year 7 381,705 $ 350,187 $318,950 $ 306,033 $ 320,456 $ 349,874 $ 381,012 $428,067 $ 432,043 $ 525,105 $ 617,523 $ 826,864 $1,155,459 480,805 5 6 Gross Profit 7 Home party sales 8 Company website 9 Amazon.com $ 142,500 $ 147,263 $ $100,720 $ 124,769 $ $ 105,487 $ 110,706 $ 135,478 $ 135,211 $ 118,017 $ 124,874 $128,541 $ 130,157 $ 128,963 $ 126,987 139,591 $ 172,208 $182,962 $ 216,174 $ 282,954 133,933 $ 162,257 $ 186,739 $ 178,272 $ 200,357 10