Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

O Required information Tableau Dashboard Activity 7-1 [The following information applies to the questions displayed below) The Slumber Store (TSS) is a national wholesaler of

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
O Required information Tableau Dashboard Activity 7-1 [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 3560,000 $615,000 $770,000 Cost of Goods Sold 346,500 405,250 556,300 Gross Profit 213,500 209,750 213,700 From the balance sheet Last Year This Year Next Year Inventories 5 88,000 $181,808 $179,825 The Slumber Store (TSS) Financial Data by Product Line Product CAN 100 90 Days-to-Sell 80 70 60 8096 7096 6096 5095 Gross Profit Percentage 4096 309 2096 10% 0 Last Year This Year Next Year The Slumber Store (TSS) Financial Data by Product Line Product Mattresses Y 100 90 Days-to-Sell 80 70 60 3596 30% 2546 2096 Gross Profit Percentage 15% 1096 596 09 Last Year This Your Next Year Required information Y The Slumber Store (TSS) Financial Data by Product Line Product Pillows 100 90 Days-to-Sell 80 70 60 40% 3596 309 25 Gross Profit Percentage 2091 1596 1096 This year The Slumber Store (TSS) Financial Data by Product Line Product Sheets 100 90 Days-to-Sell 30 70 60 2096 1546 Gross Profit Percentage 109 The Slumber Store (TSS) Financial Data by Product Line Product Beds 100 90 Days-to-Sell A BO 70 60 80% 704 60% 50 Gross Profit Percentage 4096 3096 2096 1090 096 Last Year This Year Next Year WEALE tableau 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 prolit 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 remaining constant over the three years shown? Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 6 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? Product line's days to sell Product line's gross profit porcentage Required 4 > Complete this question by entering your answers in the tabs below. Required 3 Reglured 4 Required 5 Required 6 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? Product line's days to sell Product lino's gross profit percentage Complete this question by entering your answers in the tabs below. Required 3 Required 4 Requiris Required 6 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? Product line's days 10-ell Product line's gross profit percentage

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting A Global Approach

Authors: Sidney J. Gray, Belverd E. Needles

1st Edition

9780395839867

More Books

Students also viewed these Accounting questions

Question

When do you think a hiring decision will be made?

Answered: 1 week ago