Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Required Information [The following information applies to the questions displayed below.) The Slumber Store (TSS) is a national wholesaler of beds, mattresses, pillows, and sheets.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Required Information [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 Sales Revenue Cost of Goods Sold Gross Profit Last Year $568,000 346,500 213,500 This Year $615,000 485,250 209,750 Next Year $779,80 556, 380 213,780 From the balance sheet Inventories Last Year $ 88,888 This Year $101,888 Next Year $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. The Slumber Store (TSS) Financial Data by Product Line Product | (11) 100 90 Days-to-Sell 80 70 Financial Data by Product Line 100 90 Days-to-Sell 80 70 60 8096 7096 6096 5096 Gross Profit Percentage 4096 3096 2096 1096 096 Last Year This Year Next Year + ableau 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 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 percentage Required 3 Required 4 > 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 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 "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 line's gross profit percentage Required Information [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 Sales Revenue Cost of Goods Sold Gross Profit Last Year $568,000 346,500 213,500 This Year $615,000 485,250 209,750 Next Year $779,80 556, 380 213,780 From the balance sheet Inventories Last Year $ 88,888 This Year $101,888 Next Year $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. The Slumber Store (TSS) Financial Data by Product Line Product | (11) 100 90 Days-to-Sell 80 70 Financial Data by Product Line 100 90 Days-to-Sell 80 70 60 8096 7096 6096 5096 Gross Profit Percentage 4096 3096 2096 1096 096 Last Year This Year Next Year + ableau 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 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 percentage Required 3 Required 4 > 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 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 "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 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_2

Step: 3

blur-text-image_3

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

Ecology, Sustainable Development And Accounting

Authors: Seleshi Sisaye

1st Edition

0415816351, 9780415816359

More Books

Students also viewed these Accounting questions

Question

How would you typify the trends of trade unionism internationally?

Answered: 1 week ago