90.2K

Verified Solution

Link Copied!

Required information

Skip to question

$[$The following information applies to the questions displayed below.$]$

The Slumber Store $($TSS$)$ is a national wholesaler of beds, mattresses, pillows, and sheets.

Key totals from TSS$$s most recent and forecasted financial statements are presented in the table below.

From the income statement Last Year This Year Next Year

Sales Revenue $ $560,000$ $ $615,000$ $ $770,000$

Cost of Goods Sold $346,500405,250556,300$

Gross Profit $213,500209,750213,700$

From the balance sheet Last Year This Year Next Year

Inventories $ $88,000$ $ $101,808$ $ $179,825$

Assume that you work inside TSS$$s accounting department, and can access the above totals as well as financial data by product line. Use the Tableau dashboard below, which will allow you to use the filter options in the upper$-$right corner of the dashboard to reveal specific amounts, to answer the following questions.

$3.$ Using the filter options in the upper right corner of the Tableau dashboard, select the product line $$Beds$.$ Is the trend for this product line$$s days$-$to$-$sell improving, worsening, or remaining constant over the three years shown? Is the trend for this product line$$s gross profit percentage improving, worsening, or remaining constant over the three years shown?

$4.$ Using the filter options in the upper right corner of the Tableau dashboard, select the product line $$Mattresses$.$ Is the trend for this product line$$s days$-$to$-$sell improving, worsening, or remaining constant over the three years shown? Is the trend for this product line$$s gross profit percentage improving, worsening, or remaining constant over the three years shown?

$5.$ Using the filter options in the upper right corner of the Tableau dashboard, select the product line $$Pillows$.$ Is the trend for this product line$$s days$-$to$-$sell improving, worsening, or remaining constant over the three years shown? Is the trend for this product line$$s gross profit percentage improving, worsening, or remaining constant over the three years shown?

$6.$ Using the filter options in the upper right corner of the Tableau dashboard, select the product line $$Sheets$.$ Is the trend for this product line$$s days$-$to$-$sell improving, worsening, or remaining constant over the three years shown? Is the trend for this product line$$s gross profit percentage improving, worsening, or remainingThe Slumber Store $($TSS$)$

Product

$($AII$)$

Financial Data by Product Line constant over the three years shown?

Answer & Explanation Solved by verified expert

See Answer