L’Oréal UK has automated its spreadsheet-based business processes using Cognos Planning, in a move aimed at driving joint planning with retailers.
The cosmetics giant’s national accounts team – which works with retailers including Tesco, Asda, Boots and Morrisons – is using the Cognos software to improve planning and forecasting information.
The software allows account managers to derive unit sales and profit margin projections from retailers’ electronic point of sale data and to compare projections against tailored key performance indictors.
The accounts team is also using the software’s scenario modelling function to forecast the success of special promotions and predict seasonal variations in sales and profits.
Keith Mattocks, project leader, sales and marketing IT at L’Oréal UK said: “The spreadsheets that the national accounts team had been using prior to the rollout of Cognos Planning had become gargantuan and difficult to manage. Not only that, every time a new scenario needed to be created, our account managers had to start again from scratch. This meant spending hours re-working the spreadsheets and inputting new data.”
Mattocks said the new software allowed accounts team members. to demonstrate the effect of various different scenarios to customers “in minutes rather than hours”.