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 $560, eee 346,500 213,500 This Year Next Year $615,000 $770,000 405,250 556,300 209.750 213,700 From the balance sheet Inventories Last Year This Year Next Year $ 88,000 $101,805 $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 IND 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 CAM 100 90 Days-to-Sell 80 70 60 Required information 8096 70% 60 50% Gross Profit Percentage 4046 30% 20% 2096 096 Last Year This Year Next Year 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 uon tableau TE 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-sel improving, worsening of 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? 8. Using the filter options in the upper right corner of the Tableau dashboard, select the product line "Sheets.'s 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 Required 4 Required 5 Required 6 Using the liter 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 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 day to sell Product lines gross profit percenta (Required 3 Required 4 > RECHT errentan mwncorun ne remaininnant or are nown Required information gross pront 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 lines days to sol Product line's gross probt porcentage gross proht 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 "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 prolit percentage improving, worsening, or remaining constant over the three years shown? Producina's days to so Product line's Uss profil percentage 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 "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? Product line's days to com Product lino's gross prolit porcentage 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 Last Year This Year Next Year Sales Revenue 3560,000 5615,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 $ 13,000 $101,0 $179,825 Required: 1. Use the financial statement totals to compute the company's actual inventory turnover ratio for this year and its forecasted inventory turnover ratio for next year. Also compute the days to sell for this year (actual) and next year forecasted). Is inventory turnover expected to improve or worsen next year? 2. Use the financial statement totals to compute the company's actual gross profit percentage for this year and its forecasted gross profit percentage for next year. Is the gross profit percentage expected to improve or worsen next year
