Martin 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:

B D 1 Sales Revenue Year 1 2 Home party sales $ 3 Company website 4 Amazon.com E H Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 358,168 $ 351,005 $ 333,595 $318,249 $331,075 $325,910 $331,288 $ $ 217,684 $ 215,507 $204,732 $ 198,590 $ 190,646 $ 186,833 $ 183,097 $ $ 175,680 $ 191,843 $212,715 $ 254,407 $297,198 $ 349,505 $ 481,618 $ G Year 8 Sparkline 321,217 177,604 706,004 5 6 Gross Profit 7 Home party sales 8 Company website $ 9 Amazon.com $ $ 136,104 $127,766 $122,196 $ 87,074 $ 93,228 $ 71,568 $ 71,950 $ 111,387 $ 126,338 $ 130,157 $128,963 $ 126,987 91,556 $ 72,481 $ 87,380 $ 88,574 $ 73,568 $ 71,451 $ 89,717 $ 95,210 $ 101,589 71,305 $ 71,489 $ 70,196 10