You are an accounts payable manager at Tiptop Sellers, which is a medium size department store. The company is having liquidity issues and needs to free up cash for expansion projects. You have come across the Wall Street Journal article entitled, "Delaying Payments to Suppliers Helps Companies Unlock Cash". The article gives you some ideas for increasing liquidity, but you need to do more industry analysis. To help you understand liquidity within the retail sector, your boss creates a dashboard visualization using financial data from the largest five retailers mentioned in the article. The data is sourced from the Reuters website which is publicly available. She asks you to interpret the data and answer the questions below. Click here to view the data in Tableau, and here to view it in Power BI. (The Tableau and Power BI files contain the same data; you can use either to answer the questions in this assignment. Your instructor may specify which program they prefer you to use!) How to Access Tableau: You can open the Tableau file in this problem statement with Tableau Desktop software. If you don't have Tableau Desktop, you can download Tableau Reader, a free program that allows you to open Tableau visualizations. To get it, search for "Tableau Reader" in your internet browser, or click here. How to Access Power BI: You can open the Power BI file in this problem statement with Power BI Desktop. If you don't have it already, search for "Power BI download" in your internet browser, or click here for a free download. f the average quick ratio was calculated using the values from the dashboard, can it be used as a benchmark for TipTop Sellers? What should be considered when using the average quick ratio as a benchmark? How would you assess the current ratio and the acid test ratio for these five companies? What strategies or tactics can retail companies use to increase their current ratio and acid test ratio? Fiqure 1: Total Revenue by Company in 2019 Fiqure 2: Acid Test Visualization in 2019 Walmart Amazon Costco Kroger Nalgreens Cash \& Equivalents Short Term Investments Net Receivables Cur Liabilities Figure 3: Current Ratio By Year Figure 4: Acid Test Ratio By Year Figure 5: Current Asset Ratio Breakdown in 2019 Figure 6: Acid Test Ratio Breakdown in 2019 100bn 50bn Obn 50bn 50bn 100bn 100bn Walmart Amazon Costco Walgreens Kroger Walmart Amazon Costco Walgre... Kroger Cash \& Equivalents Short Term Investments Net Receivables Other Current Assets Current Liabilities You are an accounts payable manager at Tiptop Sellers, which is a medium size department store. The company is having liquidity issues and needs to free up cash for expansion projects. You have come across the Wall Street Journal article entitled, "Delaying Payments to Suppliers Helps Companies Unlock Cash". The article gives you some ideas for increasing liquidity, but you need to do more industry analysis. To help you understand liquidity within the retail sector, your boss creates a dashboard visualization using financial data from the largest five retailers mentioned in the article. The data is sourced from the Reuters website which is publicly available. She asks you to interpret the data and answer the questions below. Click here to view the data in Tableau, and here to view it in Power BI. (The Tableau and Power BI files contain the same data; you can use either to answer the questions in this assignment. Your instructor may specify which program they prefer you to use!) How to Access Tableau: You can open the Tableau file in this problem statement with Tableau Desktop software. If you don't have Tableau Desktop, you can download Tableau Reader, a free program that allows you to open Tableau visualizations. To get it, search for "Tableau Reader" in your internet browser, or click here. How to Access Power BI: You can open the Power BI file in this problem statement with Power BI Desktop. If you don't have it already, search for "Power BI download" in your internet browser, or click here for a free download. f the average quick ratio was calculated using the values from the dashboard, can it be used as a benchmark for TipTop Sellers? What should be considered when using the average quick ratio as a benchmark? How would you assess the current ratio and the acid test ratio for these five companies? What strategies or tactics can retail companies use to increase their current ratio and acid test ratio? Fiqure 1: Total Revenue by Company in 2019 Fiqure 2: Acid Test Visualization in 2019 Walmart Amazon Costco Kroger Nalgreens Cash \& Equivalents Short Term Investments Net Receivables Cur Liabilities Figure 3: Current Ratio By Year Figure 4: Acid Test Ratio By Year Figure 5: Current Asset Ratio Breakdown in 2019 Figure 6: Acid Test Ratio Breakdown in 2019 100bn 50bn Obn 50bn 50bn 100bn 100bn Walmart Amazon Costco Walgreens Kroger Walmart Amazon Costco Walgre... Kroger Cash \& Equivalents Short Term Investments Net Receivables Other Current Assets Current Liabilities