Case Background

In April $2014,$ Wolf Distributing had a cash flow problem because of unpaid invoices for the Berserker Range energy drink in Chicago. Christine Taylor, the company's COO, tried various traditional methods to solve this problem but made little progress. Here, she used three statistical tools to better understand the problem: Pareto diagrams, scatter plots, and run charts.

Assignment Questions

Create a Pareto diagram, grouping data by Collector $($hint: only $4$ collectors; Pareto for Past Due $ and Pareto for Past Due Invoices$)$

Create a Pareto diagram, grouping data by Sales Rep $($hint: past due in $ and number of past due invoices. Take only $810$ categories for Pareto and lump all categories that do not fall under the top $8$ categories.$)$

Create a Pareto diagram, grouping data by Chain Name $($hint: past due in $ and number of past due invoices. Out of $32$ Chain Names, take $8$ top categories and lump all others under "Other" for Pareto Chart$).$

Create a scatterplot of the number of invoices $($y$-$axis$)$ by Open AR Dollars $($x$-$axis$).$ Group the data by chain name $($i$.$e$.,$ each point on the scatterplot represents a chain name$).$

Create individual run charts for the following chains: Orgrimmar, Stormwind, Dalaran, and Kharanos. Use the transaction date for the x$-$axis $($time$)$ and the number of invoices for the y$-$axis. Use a pivot table to aggregate the number of invoices by date.

Assuming that you address and resolve your top problems, what is next?

The AR data is available in this folder.