The Accounting Analytics Capstone course is a compulsory capstone course for undergraduate students pursuing a 2nd Major in Accounting Data & Analytics. We showcase their completed projects below.
To Create a Dashboard to Manage the Sales Quotation Process
The team was tasked to address the following problems in the sales quotation process:
- The average salesperson is highly dependent on senior staff for sales quotations leading to a long and tedious sales quotation process.
- An increase in sales enquiries has led to bottlenecks arising in its costing and sales quotations processes.
- With many customisable product variations available for clients to choose from, complexity arises in the sales quotation process.
To Replace the Existing Remuneration Model With A Pay-Per-Job Model
The key objective of the project was to replace the existing remuneration model with a pay-per-job model with minimal deviation from their existing salary.
Adjustment, Forecasting, Dashboarding Tool
The team was tasked to improve the manual forecast of Income and Cashflow statements with forecasting tools and developing a dashboard to automatically generate insights for the Management.
Extraction and Utilisation of The Point-Of-Sale Systems’ Data To Create Operational and Financial Reporting Dashboards
The team was tasked to extract and utilise the Point-Of-Sale Systems’ data to create operational and financial reporting dashboards.
Developing Audit Analytics Solution to Manage Rewards Programme
The team was tasked to develop an audit analytics solution as part of their GrabRewards system, more specifically to establish if points are used or expire according to the products’ T&Cs and highlight accounts with unusual allocation patterns using machine learning.
How can GBFS Enhance its Lending Decisions for Corporate Clients using a Credit Scoring Model?
Through a credit scoring model, the team aims to automate loan application procedures and flag out subjective factors for review, thereby allowing employees to shift their focus to factors that require more human judgement.
Improving Time-Consuming Approval Process and Reducing Subjectivity in Decision-Making
The team was tasked to improve the time-consuming loan approval process which required analysts to vet supporting documents manually and could potentially lose customers to competitors and to remove the subjectivity in the decision-making of approvals which was largely based on individual analyst's professional judgement.
Resolving Time Consuming Manual Check Processes and Improving Manual Forwarder Selection Process
The team was tasked to propose solutions to resolve the certain manual check processes which were time consuming due to pricing of different categories of products and improving the manual process of selecting an forwarder. With the consideration of many factors like freight days, port of calls, service vs price, a manual approach was not optimal.
Quantify the Effects of Promotions in terms of Effectiveness and Propose an Optimal Promotional Schedule
Our project aims to quantify the effects of Lim Kee's promotions in terms of effectiveness and propose an optimal promotion schedule, while considering constraints including production limit, storage capacity, shelf-lives of products and a Just-In-Time production philosophy. We aim to select the most efficient and effective promotions to schedule without exceeding supply-side constraints.
