In this case, you continue in your role as an analyst conducting research into the relative merits of investing in one or both of these companies. For this case, you will assess the companies’ receivables management and how effective the companies are in managing their investments in receivables. Tableau Instructions: For this case, you will create several calculations and produce text and line charts to allow you to compare and contrast the two companies’ management of receivables. Use the following steps to create the charts you will need for this case: Download the Excel file “Discount_Goods_Big_Store_Financials.” Open Tableau and connect to the Excel file. Click on the "Sheet 1" tab at the bottom of the canvas, to the right of the Data Source at the bottom of the screen. Drag "Year" and "Company" to the Rows shelf. Change "Year" to discrete data type by right-clicking and selecting "Discrete." Drag the "Net sales" and "Average accounts receivable net" under Measure Names to the Rows shelf. Change each to discrete. Format each to center alignment and Currency (custom) with0 decimal places by right-clicking each and selecting "Format." Create a calculated field by clicking the "Analysis" tab from the Toolbar at the top of the screen and selecting "Create Calculated field." A calculation box will pop up. Name the calculation "Receivables Turnover." In the Calculation Editor window, from the Rows shelf, drag "Net sales" to the window, type a division sign, then drag "Average accounts receivable net" beside it. Make sure the window says that the calculation is valid and click OK. Repeat the process one more time by creating a calculated field "Average Collection Period" that consists of the number 365 divided by the newly created "Receivables Turnover." Drag the "Receivables Turnover" and "Average Collection Period" to the Rows shelf. Change both to discrete data type. Format both to center alignment and Number (Custom) with 2 decimal places. Change the title of the sheet to be "Receivables Management" by double-clicking the tab at the bottom of the page and typing Receivables Management. To hide the abc column, which appears when all variables are discrete, click on the Marks Card, and choose Polygon. This will hide the letters. Then click and drag the edge of the column to make it as small as possible. Click on the New Worksheet tab on the lower left ("Sheet 2" should open). Click on the "Sheet 2" tab and drag "Year" to the Columns shelf and "Receivables Turnover" and "Average Collection Period" to the Rows shelf. Drag "Company" under Tables to the Color in the "All" section of the Marks card. You should now see two colored lines in the two graphs. Change the title of the sheet to be "Graph of Receivables Management" by double-clicking the tab at the bottom of the page and typing Graph of Receivables Management. Save your work.
Required:
Based on the visualization you created, answer the following questions: What are Big Store’s receivables turnover ratios in (a) 2012 and (b) 2021? What are Discount Goods' receivables turnover ratios in (a) 2012 and (b) 2021? Which company, Big Store or Discount Goods, exhibited more favorable receivables management, as measured by average collection period, in 2020? What was that company’s average collection period, and is it longer or shorter than the industry average in 2020? The average collection period for the retail industry sector is 4.0 in 2020 and 5.1 in 2021. Which company, Big Store or Discount Goods, exhibited more favorable receivables management, as measured by average collection period, in 2021? What was that company’s average collection period, and is it longer or shorter than the industry average in 2021?