Commercial Analyst Task

The attached spreadsheet outlines fictitious amounts of overdue debt that is owed by customers to ABC Pty Ltd. Column C refers to overdue debt owed by customers while column F to O represent the previous five months of payment history of customers. Column B refers to the manager responsible for managing the account. Based on this overview, we would like the candidates to answer the following questions.

1. Which entity has the highest amount of total Overdue Amount?

2. Provide a summary of overdue debt by account manager? What additional information can you provide based on the summary?

3. What is the average overdue debt per account?

4. What percentage of accounts pay debt in a timely manner.

5. Based on information provided, what information can be gained from past five months of payment history for each customer?

6. Provide an additional insight about the dataset.

Please answer these questions in a single word document and represent in a professional report layout manner and supported by diagrams or tables if possible.

Please note, that no additional information will be provided for this task. You need to answer the questions with the information provided in the attached spreadsheet and you are free to make any additional assumption you would like about the dataset. We are not looking for a right answer, instead we are looking to understand your comfort with numbers.