| 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.
