Download the spreadsheet for this problem. 

                                   2018          2019                2020            2021 

Sales                         $589,500     $613,500      $625,000       $666,666 

Sales returns             20,000       22,000           24,000       26,000 

Net Sales                   569,500      591,500        601,000     640,666 

Cost of Goods Sold  300,000      325,000       350,000      390,000 

Gross Margin            269,500       266,500       251,000      250,666 

Operating Expenses 120,000      125,000       128,000      135,000 

Interest Expense       15,000        15,000          15,000        15,000 

Income Before Tax   $134,500    126,500       108,000      100,666 

Format the data to display sales and income before tax as currency, with no decimals. 

Format the rest of the data to display commas for the thousands, with no decimals. 

Create a column (or bar chart, whichever you prefer) that shows the trend in sales and net sales.  

Create four pie charts, one for each year, to show the relative size of sales returns, cost of goods sold, operating expenses, interest expense, and income before tax expressed as percentages of total sales.

Answer rating: 100% (QA)

Value 1400000 1200000 1000000 800000 600000 400000 200000 0 2018 3 20 Sales returns Inter... View the full answer