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.
Determining Customer Profitability of Fuji Xerox
To determine customer profitability, the team used dashboarding to present key managerial insights through data visualisation; search tools to analyse profitability of customers on a contract-level and customer-level basis, while making them compatible with the company's current resources, as much as possible.
Develop a Dashboard for Effective Tracking of Historical Financial Performance
The team was tasked to design & develop a dashboard to enable effective tracking of
historical financial performance of Construction Company and to provide analytical insights to address areas of concern and allow sensitivity studies to be incorporated.
Differentiating Lim Kee's Business Based on Cost Innovation
Lim Kee’s rapid growth since their establishment in the 1980s is slowing down due to customer saturation in the Pau sector in Singapore. As a result, Lim Kee has to differentiate itself now based on cost innovation rather than product innovation in order to increase their bottom line, especially in the Kopitiam sector.
Top International Holding
Create an integrated digital dashboard prototype that reports on the key indicators of finances, operations and projects on a real time (or sufficiently timely) basis. Some indicators were: efficiency information, mining statuses, projections and achievement of targets or milestones.
Model to Establish Engagement Score of ISCA Members
The team was tasked to recommend a suitable methodology to measure members' engagement score and develop a predictive model to identify members who are likely to not renew membership.
ISCA Membership Engagement Scoring Model
The team was tasked to develop a model to predict the probability of a member resigning, measure the engagement level of each member and identify the factors that drive member engagement.
Devising a Solution for SGX's Current Revenue Forecast Process.
SGX’s present system requires human intervention to manually sift through various new sources to determine the inputs for their forecast.
The team’s proposed solution—to convert the semi-automated revenue prediction process to a fully automated one—aims to streamline the process and eliminate the human judgement bottleneck. This would enable a standard operating procedure, reduce total man-hours and improve the process accuracy over time.
Developing a Tool to Continuously Monitor and Flag out Non-Compliance in Procurement
To develop a tool that allows continuous monitoring and flagging out of non-compliances to the SGX Procurement Policy, specifically:
1. PO raised after service commencement date
2. Invoice payment in excess of approved PO amount
3. Contracts which are more than $5k but broken into smaller value contracts
Developing a Dashboard to Track Historical Data and Inventory - Hi Beau
Hi-Beau has commissioned the team to design and develop a dashboard, enabling its management to effectively track historical data and inventory to support the forecasting and planning of sales and procurement processes through predictive analytics.