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.
Optimize Profits by Prioritizing Most Profitable Target Customers and Event Types
The team made use of accounting analytics to allow UP to gain valuable insights into the revenue and profitability for each customer and type of event. The insights will empower informed decision-making by the management.
Analyzing the Feasibility of the Clinic’s Pricing Model and Designing a Compensation Package for Newly Onboarded Oncologists
The team was tasked to analyze the feasibility of the clinic’s pricing model amidst rising costs for 4 components of interest (chemotherapy facility, nursing treatment, consumables and drug compounding/preparation), and design a compensation package for newly onboarded oncologists while determining the optimal number of new doctors and/or nurses for onboarding.
Develop Models for Forecasting at ICS
The team was tasked to develop models to:
- Forecast future revenue and operating expenses
- Provide data-driven recommendations on future management decisions (hire more doctors, nurses or buy more chairs)
- Saving resources for potential investments in the future
Improving Data Collection and Verification to Monitor and Measure Environmental Footprint Accurately
The team was tasked to help FPG achieve its objective to be Asia's leading environmentally-sustainable retailer and achieve net-zero by 2050 through improvement of its data collection and verification process to accurately measure and monitor their environmental footprint.
Derive Data-Driven Insights to Better Craft Content for Target Demographics
The team was tasked to derive data-driven insights to better craft content for target demographics to help SMSDome acquire new customers and retain existing ones.
Use an Objective Data-Driven Strategy to Analyse Historical Sales & Revenue Data
The team used an objective data-driven strategy to analyse historical sales & revenue data to identify sales opportunities, such as bundling of services, promoting specific services for different industries & identifying trending services to be utilised for future sales strategy.
MoneyMax Auto Leasing Credit Risk Analysis
The team was tasked to analyse and find common characteristics among hirers who default on car loans and research possible non traditional credit factors that are related to creditworthiness.
Store Performance App for Performance Analysis of AI Un-manned Store Performances
The team completed the following in the project:
Dashboarding - Four dashboards were created to provide an overview and detailed understanding of store performances.
Forecasting - Applied forecasting model for each product category at each location with a forecast period of 6 months.
Product Bundling - Pareto's 80/20 rule was used to narrow down product scope. Association rules from market basket analysis identified complementary products for product bundling strategies.
Part-timer Profiling to Manage Part-timers across Different Jobs and Age Groups
The team was tasked to define optimal part-timer profiling per industry and leverage on potential recruitment sources & strategy.