project number 2
1st graph
2nd graph
3rd graph
questions
whats blurry? Csn you zoom in to see?
PROJECT NUMBER 2
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 Net Income and Operating Cash Flow Cash Collections Year 1 Luxburg Net Income and Operating Cash Flow Cash Collections Year 1 Marx Co. Net Income and Operating Cash Flow Which company had the highest credit sales during Year 1? Multiple Choice Luxburg Marx Co. Which company likely has the best credit collection policies by consistently collecting cash from credit sales throughout Year 1 ? \begin{tabular}{|l|} \hline Expo \\ \hline Luxburg \\ \hline Marx Co \\ \hline \end{tabular} Which company appears to have a consistent issue with collecting cash from credit sales during Year 1 ? \begin{tabular}{|l|} \hline Expo \\ \hline Luxburg \\ \hline \end{tabular} 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. The company implemented a new policy requiring credit checks of all customers. The company improved its collection policies starting in October by sending delinquent accounts to a collection agency. The company's accounts receivable clerk lett the company in October and a replacoment has not yet been found. The company electod to switch from credit sales to cash sales only in October. What would be the Accounts Receivable balance reported on the December 31 , Year 1 balance sheet for Luxburg Company? \begin{tabular}{|l|} \hline 557,000 \\ \hline 250,000 \\ \hline$150,000 \\ \hline$270,000 \\ \hline \end{tabular} Expo Net Income and Operating Cash Flow Cash Collection Luxburg Net Income and Operating Cash Flow Jan31Mar3Apr3May3jan3Jua3 Marx Co. Net Income and Operating Cash Flow Year1 Which company had the highest credit sales during Year 1 ? Multiple Choice Which company likely has the best credit collection policies by consistently collecting cash from credit sales throughout Year 1 ? \begin{tabular}{|l|} \hline Expo \\ \hline Luxburg \\ \hline Marx Co. \\ \hline \end{tabular} Which company appears to have a consistent issue with collecting cash from credit sales during Year 1 ? \begin{tabular}{|l|} \hline Expo \\ \hline Luxburg \\ \hline Marx Co \\ \hline \end{tabular} Select the explanation that best describes the potential reason for the widening gap between credit sales and cash collectio from September to December of Year 1 for Expo Company. The company implemented a new policy requiring credit checks of all customers. The company improved its collection policies starting in Oclober by sending delinquent accounts to a collection agency. The company's accounts receivable clerk left the company in Oclober and a replacement has not yet been found The company elected to switch from credit sales to cash sales only in October. What would be the Accounts Receivable balance reported on the December 31 , Year 1 balance sheet for Luxburg Company? \begin{tabular}{|l|} \hline$57,000 \\ \hline$250,000 \\ $150,000 \\ \hline$270,000 \\ \hline \end{tabular}