Incentive Management
Introduction
In the travel industry, when it comes to online bookings of airline tickets, 4 main global distributor system (GDS) companies take up close to 90% of the market share worldwide. These GDS companies enter into contracts with many different travel agents / online ticketing websites (Zuji.com, Booking.com) in different countries. As these agreements with the travel agents are usually not exclusive in nature, the market strategy between these GDS vying for bookings made by the travel agents through their own system lies in the incentives that are paid back to the travel agents for each booking.
These incentive computations are complex in nature, and varies from country to country. There are many factors to consider in each contract’s incentive computation, such as frequency of incentive payment and computation, target setting, tier incentive rates and bonus incentive for growth or market shares.
Issues with Legacy System
In this particular case study, our client has contracts with travel agents in many different countries, and for each of these countries, they have different ways of calculating incentive payback. The task at hand is to compute the incentives accurately, for large number of contracts, with large volumes of booking data, and applying a complex set of computation logic to generate a payment report for the travel agents on a monthly basis. However, lying behind the simple process is a manual, error prone mixture of systems to manually generate payment reports each month.
There are a few key issues with the legacy system of computation being used:
- Contract management system could not handle the complexity of the contracts.
- Computation system was a traditional relationship DB system, unable to handle the complex computation requirements of the contracts.
- Contracts had to be “stored” in excel files, that does not reside on a share database.
- Incentive computations had to be manually calculated for each payment cycle on excel. Error prone and taxing on user as all bookings had to be retrieved from source and “pasted” onto excel sheets to compute incentives.
- Entire process was labour intensive and could not meet the payment cycles required of the business.
Value Proposition
Analysis of the above process shows the main issue exist in contract management and the computation of the complex incentive payout amounts. Having manually store contracts in Excel files as records and using the Excel files to manually compute the incentives stands out as the key process that needs to be replaced with a proper system.
The current relational DB system is unable to perform the complex calculations required, it is also slow in speed and cannot provide an Excel-like “live” system that can react to contract term changes instantly. This is also a bug bear in computation investigation in the event of discrepancies in payment amounts.
Our team of consultants proposed Incentive Management module powered by IBM Cognos TM1 as it is able to counter every problem and issue that the current system encounters. It provides a single, cohesive set of performance management applications for complex computations of the incentive payouts, the reporting requirements as well as a highly customised contract management system.
Users are now able to:
- Maintain contracts with very complex incentive calculation terms via a system instead of manually maintaining in Excel
- Retain full functionality of Excel in payment report and in accessing the solution
- Quickly view and edit the contracts that are being managed by our solution
- Once the contracts are edited with new terms, TM1’s unique RAM-based approach provides users with the ability immediately see the new incentive computation. All complex calculations are performed realtime and on RAM, resulting in very high performance and quick computations.
- It also allows the users to look at incentive computations and do in depth analysis if there should be a need to verify the incentive computations.
Please contact us through this form to find out more!
Inventory Planning
Manufacturing and distribution businesses need to plan and monitor the inventory to avoid overstock and shortages that impact profitability. This module integrates both demand and supply data together for an accurate inventory planning process.
Features
- Collate sales planning data collected from customers.
- Plan additional stock against anticipated demand.
- Capable of scenario modelling by changing cost and sell prices in future months.
Please contact us through this form to find out more!
Product Profitability
This module supports decision-makers in strategizing their businesses by pooling data from departments such as sales, marketing and operations in an integrated system. This then facilitates greater collaboration between key stakeholders to determine product profitability and finding ways to improve them.
Features
- Perform product profitability analysis.
- Capable of product-channel profitability analysis.
- Incorporate costing drivers.
Please contact us through this form to find out more!
Hospitality Forecasting & Analytics Solutions
We have a suite of solutions designed to help companies in the hospitality industry to drive their business analytics with driver-based planning methods. Please contact us through this form to find out more!
Project Costing
Another popular module in Adept Performance Management Solution (APM) is Project Costing. One key strength of this module is to allow a company to centrally maintain its product or raw material listing and details such as cost and sell prices, dimensions and colour. This eliminates the possibility of using out-dated or erroneous information such as cost prices that commonly plague organisations that use Excel spreadsheets to prepare project costing sheets. Obviously, when one gets the prices wrong, profitability will be severely impacted.
Thus, having important data centralised in the Project Costing not only helps to reduce errors, its ultimate benefit is to improve profitability. Users can now focus more on selecting the right material for the project during the planning phase in the Project Costing module and not having to worry about the accuracy of the data. In addition, project managers can create multiple versions or perform "sandboxing" i.e. scenario modelling to analyse different configurations for the same bid. This helps the managers to determine which proposal will be the most profitable, cost effective or competitive in price against other competitors and at the same time, meeting the required quality expected from the clients. All these result in higher chance of winning the tender and improving profitability.
The Project Costing module is useful for companies in hospitality, construction, property and medi-care industries.
Please contact us through this form to find out more!
