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.
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.
Developing a Semi-Automation Solution to Forecasting Processes and Creating an Interactive Dashboard for Cash Flow Performance Analysis
The team was tasked to:
- Develop a semi-automation solution to the forecasting processes to reduce the amount of manual and repetitive work required such as compiling information from various sources and calculation of values
- Create an interactive dashboard which allows for Cash Flow performance analysis as well as for comparison of actual and forecasted figures
Credit Modelling System for Smallholder Farmers
The team was tasked to create a credit scoring system which assesses farmers’ ability to repay and allow for customized loans to be lent to these farmers.
Improving Data Management and Operations & Decision Making
The team developed a solution to address the manual recording process of inventory inflows and outflows and improve decision making by capitalising on existing data to capture the market trend more accurately.
Boosting the Productivity and Efficiency of the Deals Management Team
This project aims to boost the productivity and efficiency of the Deals Management team. Our solution was to ensure that they can obtain clear visualizations with a few clicks, that will be useful for their client and sales analysis. This is done using a web portal, which would contain functions that allow the seamless integration of data.