Reducing Delinquent Accounts Receivable- BUS 373 Management Information Systems Finance and Accounting Coursework Help

Reducing Delinquent Accounts Receivable- BUS 373 Management Information Systems Finance and Accounting Coursework Help: Group Case Three Assignment Brief

Programme Title
Bachelor of Science (Finance), Bachelor of Science (Accounting) & Bachelor of Science (Marketing)

Course Title
Management Information Systems

Course Code
BUS 373

Assignment Title
Reducing Delinquent Accounts Receivable

Instructor
Associate Professor Dr. Norshidah Mohamed

Due Date
April 10, 2018 (milestone data analysis)
April 17, 2018 (report & presentation)

Assignment Format
Report
Oral Presentation

Assignment Length
Maximum 5,000 words

Submission Format
Electronic Submission
Oral presentation
Data Visualization in PowerPoint Slides and Excel Spreadsheet

Assignment Remit
Wolf Distributing has collected raw data about its Accounts Receivables (AR). The raw data is available in spreadsheet. Students are required to analyse the raw data, provide evidence to determine the contributors to business problem and suggest action(s) to be taken.
Create a Pareto chart with the following groupings:
Group the data by collector. Does the data provide any insights into the problem? If so, what potential corrective actions do you suggest?
Group the data by sales representative. Does the data provide any insights into the problem? If so, what potential corrective actions do you suggest?
Group the data by chain name. Does the data provide any insights into the problem? If so, what potential corrective actions do you suggest?
Create a scatter plot of number of invoices (y-axis) by open AR dollars (x-axis). Group the data by chain name. Does this data provide any insights into the problem? If so, what potential corrective actions do you suggest?
Create individual run charts for Orgrimmar, Stormwind, Dalaran and Kharanos. Use transaction date for the x-axis (time) and number of invoices for the y-axis. Use a pivot table to aggregate the number of invoices by date. Does this data provide any insights into the problem? If so, what potential corrective actions do you suggest?
Write a report containing Introduction, Method, Findings and Conclusion. You are not required to provide recommendations beyond the findings you have. Your conclusion, however, should contain the limitations of Excel for this assignment and suggestions on the need for more powerful tool(s) for what kinds of situation(s).
Course Learning Outcomes
Students will collaborate and work in teams.
Students will demonstrate excellent communication skills (written and oral) while preparing reports and presenting assignments.
Students will possess the ability to read and understand a case in total so as to respond to questions in a more integrative manner.
Students will point out and express clearly the benefits vs. limits of information technology used to support business functions and its relevance in real world situations.