Implementation of an SAP BW and Integrated Planning solution for SHS Group
De Villiers Walton had the in-depth skills we needed to help us realise our vision.
Everyone loves a ‘buy one, get one free’ deal. Yet without smart reporting and intelligent financial planning, it would be harder for brand-owning businesses to support these offers: a reality that the SHS Group Ltd, a holding company within the fast-moving consumer goods industry, knows very well.
Behind the brand
The group, based in the UK and Ireland, incorporates twelve brand-owning or brokerage operating companies that represent own and external brands within the grocery trade. While it invests significantly in above-the-line spend on its own brands such as WKD, Shloer, and Merrydown Cider, its largest marketing investment is made in sales promotions, funding ‘buy one, get one free’ and other promotions with supermarket multiples, particularly on a seasonal basis.
With different operating companies in distinct sectors and geographies, from an IT perspective a consolidated software system for the SHS Group was logistically harder to implement than it would have been for a business with a single brand or geographical location. Yet it was clear that an enterprise platform would allow the business operate in a more unified way.
Group information systems director, Brian Acheson, has spent the last five years overseeing the move to a single SAP system. “I joined the group in 2005 before the SAP investment was made,” he says. “The systems in place then were at the end of their life and did not support the group strategy to up-scale and acquire more brand-owning companies.”
Following Acheson’s appointment, the SHS Group put SAP into operation for every one of its business processes across all territories and operating companies. It also implemented the fast-moving consumer goods trade promotion management (TPM) aspect of SAP. “From a business point of view, what we are doing is planning all of our marketing and trade spend in SAP’s integrated planning tool, then executing all of that trade spend in the customer relationship management (CRM) component of SAP,” says Acheson.
The group uses SAP’s enterprise core component (ECC) to take orders. Information from this activity – including sales promotions – are all incorporated into the SAP Business Intelligence (BI) tool in the data warehouse, where all integrated plans for trade spend start. In large organisations in particular, the information generated from this accurate BI enables both chief financial officers (CFOs) and other board level directors to be better informed when they make important decisions about the future of the business.
“We have a completely closed-loop solution, planning all our marketing and trade spend in SAP and then getting the results out at a very detailed level,” says Acheson. “We are able to look at the effectiveness of our below-the-line spend by brand, by territory – any way we want, in fact, thanks to SAP.”
Building better business systems
To ensure that The SHS Group Ltd was achieving the maximum benefit from SAP, they engaged SAP consulting specialists, De Villiers Walton, to undertake an Independent Programme Review and look closely at the Business Warehouse integrated planning module which was part of the existing SAP investment.
De Villiers Walton was chosen because of its extensive experience in the SAP arena. “When we first met with The SHS Group, it had already begun its BI project but had not had the support it needed to make the most of the integrated planning module,” says co-founder and joint managing director of De Villiers Walton, Daneel de Villiers.
“The first part of our work was therefore to re-design the proposed project, bringing it back to basics and aligning its functionality with the needs of the business.”
In October 2009, The SHS Group implemented an account planning capability, using it to plan the trade spend that it would execute throughout all of its key accounts for the upcoming financial year, including how much was to be spent on each brand and each account.
A follow-up project was undertaken by De Villiers Walton in November 2009, which added additional functionality to the SAP account planning module that allowed sales force account managers to re-forecast how much they were going to spend on promotion, and what they expected to sell on a monthly basis.
The right tools for the job
“All through the year, we refresh our sales and promotional spend forecasts,” says Acheson. “Given that we spend tens of millions of pounds on trade promotions and rely on them to support £400m-worth of sales that really is the most important thing we do.
“We have well over a hundred ‘road warriors’ working from home and visiting customers. The integrated planning module within SAP business warehouse is the tool that enables the sales team to take responsibility for the trade spend and the results they are getting on each account.
“De Villiers Walton’s work in evolving and enhancing this aspect of our SAP solution allowed us to get real value out of the more mundane invoicing, order taking, distribution, logistics and purchasing system that we implemented. This solution allows us to analyse the money that we have spent on trade promotions and see the profitability and results by account and by stock keeping unit (SKU), allowing us to see what the allocated investment achieved based on the objectives we set.”
Taking SAP solutions to the next level
The SHS Group was delighted that De Villiers Walton’s expertise in SAP data warehouse technology and integrated planning technology enabled them to achieve this outcome. Acheson describes this as being “at the outer reaches of the SAP product set.”
“Every single SAP customer you might come across has enterprise core component (ECC) for accounts, but the further you get away from the centre, the more obscure the skill-sets become,” he adds.
The expert team from De Villiers Walton applies a business-driven, ‘back to basics’ approach to its work that removes some of the complexities associated with SAP investments. According to Brian Acheson, while the SHS Group had worked with another partner in the past, it had been unable to help the organisation develop the BI functionality to the level it sought - despite significant investment being made.
“De Villiers Walton had the in-depth skills we needed to help us realise our vision,” he says. “Until this point, we had not been able to implement it because of a scarcity of people who really knew what they were doing.
“When De Villiers Walton came on board we had already developed our own in-house capability as well as an understanding of what we wanted to do and how we wanted to do it. We had even got as far as being clear on the business requirement, but what we needed was the technical knowledge to implement it.
“The skill-sets that De Villiers Walton brought to bear helped us to understand how the technology worked. We had lost a lot of confidence following failed attempts in the past, but De Villiers Walton knew what the pitfalls were and what we could expect. They took on not just a technical development role, but also a quality assurance and advisory role.”
Back to basics
“Previously, we had been trying to do the whole thing as one big project and go straight to the end result without really understanding it,” says Acheson. “Breaking it down into small pieces helped us to regain our confidence by delivering something that was less than half the solution, but which worked and added value to the business, with a follow-up project planned that would give us re-forecasting capability.
“The key to the success of these smaller projects was that they were affordable and were carried out in a sufficiently short time frame, which gave us the confidence to buy-in. De Villiers Walton’s consultants had the wisdom and the experience to know that, as we were doing the project for the first time and did not really know what are business requirements were, the best approach was to get us up and running and using the system, then come back and put the complexity in later.”
Brian Acheson is delighted with the results achieved by De Villiers Walton, which have helped to evolve his organisations’ IT roadmap and business needs. “We are now planning our annual trade spend much earlier in the year. We also have improved accountability because everything can now be done at a detailed level by the account manager who will ultimately be held responsible for the result.
“We have also been able to reduce resources in one of our operating companies, which previously analysed the effectiveness of account plans. This has saved considerable number-crunching resource. In addition, previously we were only able to analyse our top accounts and it would take as long as 13 weeks after month-end to turn around a months’ worth-of essential sales analysis, to tell us which accounts were working and which weren’t. Now we can access the data at month end, straight out of the business warehouse.”
Reaction from within The SHS Group to the improved SAP BI solution has so far been extremely positive. “The general consensus is that this is what we always wanted and needed,” says Acheson. “Now we can stop telling each other stories and making assumptions – the figures are the figures.
“This has also helped relieve some of the anxieties in the business as people can now see results at a detailed level. If there is something wrong, the information allows them to identify the problem and do something about it. Previously, the cycle-times were so long and the information was so imprecise that you were judging things at the end of the year when it was too late to do anything about it – you’d either done well or you hadn’t.
“Over the last ten years, we have always needed to know where below-the-line trade spend is going and what it is doing for us. We have always been on top of this - albeit with inadequate technology – but now we are doing it so much better.”