Retail Case Study

“Thanks for all the patience, hard work and professionalism. You are all a joy to work with.”
-Fraser M., Demand Planning Manager

Application Type:

New Product Planning and Sizing Application

A Company Snapshot:

Revlon was founded in 1932, by Charles Revson and his brother Joseph, along with a chemist, Charles Lachman, who contributed the “L” in the REVLON name. Starting with a single product – a nail enamel unlike any before it – the three founders pooled their meager resources and developed a unique manufacturing process.

Their Needs:

Revlon came to ESW with a very important project to be able to forecast and plan new product lines based on their existing data and inventories. They needed to import raw data via Excel worksheets an aggregate it into a single repository for calculation and forecasting purposes using decay rates, 156 curves, and various other data sources. Visualizations of the output as well as summary reports were to be produced for management review.

The Solution:

ESW delivered a formal Excel based application that provided key data to management for worldwide company use. The calculation model was a rinse and reused system and could be expanded upon with limited knowledge of the inner workings of the application. This project was deemed a complete success by the organization which emphasized the pace and quality that were delivered by ESWexceeded most if not all of the consulting firms they have ever engaged with.

Key Client Benefits:

Revlon was able to quickly forecast various metrics of potential new products and align their R&D budgets accordingly. Not only did this produce a huge cost savings for multiple departments, it set the stage by producing quality requirements for a larger enterprise system to be implemented in near future. A huge win ESW and a top global organization.

Screenshot: