Tableau Dashboard Activity 2-1: Accounting for Accruals The following Tableau Dashboard shows a trend line over the course of Year 1 for three separate companies. Each graph reports the credit sales and cash collections during Year 1. You can click on each company name within the dashboard to see a line chart for each company. Answer the following questions pertaining to the Tableau Dashboard output: Luxburg Marco Luxburg Net Income and Operating Cash Flow 450K Credit Sales 400K 350K 300K Prey Luxburg Net Income and Operating Cash Flow 4SOK Credit Sales 400K 3SOK BOOK 250K Dollar Value & 200K Cash Collections 150K 100K SOK OK Feb 28 Jan 31 Nov 30 Mar 31 Dec 31 Apr 30 Jul 31 May 31 Aug 31 Jun 30 Oct 31 Sep 30 1. Which company had the highest credit sales during Year 1? 2. Which company likely has the best credit collection policies by consistently collecting cash from credit sales throughout Year 1? 3. Which company appears to have a consistent issue with collecting cash from credit sales during Year 1? 4. Select the explanation that best describes the potential reason for the widening gap between credit sales and cash collections from September to December of Year 1 for Expo Company 5. What would be the Accounts Receivable balance reported on the December 31, Year 1 balance sheet for Luxburg Company? Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 3 Reg 4 Reg 5 What would be the Accounts Receivable balance reported on the December 31, Year 1 balance sheet for Luxburg Company? O $57,000 O $250,000 O $150,000 $270,000 Tableau Dashboard Activity 2-1: Accounting for Accruals The following Tableau Dashboard shows a trend line over the course of Year 1 for three separate companies. Each graph reports the credit sales and cash collections during Year 1. You can click on each company name within the dashboard to see a line chart for each company. Answer the following questions pertaining to the Tableau Dashboard output: Expo Luxburg Marx Co. Expo Net Income and Operating Cash Flow Credit Sales SOOK 400K Expo Net Income and Operating Cash Flow Credit Sales 500K 400K 300K Cash Collections DollarValue 200K 100K OK Oct 31 Nov 30 Sep 30 Dec 31 Jul 31 Feb 28 Mar 31 Jan 31 Aug 31 May 31 Apr 30 Jun 30 Marx Co. Net Income and Operating Cash Flow Credit Sales 300K Cash Collections 250K 200K Dollar Value 150K 100K 50K OK Jan 31 Feb 28 Mar 31 Apr 30 May 31 Jun 30 Jul 31 Aug 31 Sep 30 Oct 31 Nov 30 Dec 31