Sale Forecasting System For Tupperware
A subsidiary of the US based Tupperware Corporation- the world's leading manufacturer of high quality plastic food storage and serving containers- Tupperware India Pvt. Ltd is originated in India.
Applying a unique selling method, Tupperware has achieved an outstanding acceptance and success in the country. Nowadays, the Company is dealing with an immense network of Sales force, involving 50,000 women across 41 cities in all around the nation.
To maintain the authenticity and fun of its direct selling, Tupperware brings various promotion schemes to its distributors on a monthly basis. These sales schemes are planned under many operational constraints, which are respectively time, discount, unit production cost, retail cost.
Development of an intelligent sales forecasting application that can forecast the monthly variations in product sales (based on the promotion schemes and other operational constraints) was a big challenge for the organization.
Binary offered a web-based system that wonderfully integrated Tupperware's product sales data with their forecasting model. The new system provided the Forecasting and Inventory Planning department of Tupperware with a user friendly application system. It was able to perform the complex logical calculations derived from past observations. Strong analytical reports were encompassed to consolidate the forecasting information.
Developed on Microsoft .NET framework and using technologies like: ASP.NET, Oracle 9i, and Active Directory Application Mode (ADAM), the application provided a SOX complaint secure environment for Tupperware's crucial sales data. An ADAM instance was setup to authenticate selected set of users to support the complete business operations. The Sales Forecasting System has following main subsystems:
|Masters subsystem||Forecasting subsystem|
|Report subsystems||Admin subsystem|
Binary's Sales Forecasting solution was based on the product-oriented business architecture of Tupperware. Some of the key outlined benefits of the application are as follows:
- Automating the Sales Forecasting process, making it free from human error
- Real-time reporting and analysis
- Excel-based reports for easy exchange of information
- SOX-compliance for password management