Master Anaplanner/Community Boss

The vision and interest to connect retail planning activities was well understood before 1990, but technology wasn’t as evolved as our ambition.The vision and interest to connect retail planning activities was well understood before 1990, but technology wasn’t as evolved as our ambition.

Anaplan is an ideal platform to enable virtually all retail, wholesale, and eCommerce planning activities. The value provided by Anaplan combines the flexibility of spreadsheets and the connected business drivers in today’s most common point solutions. But the best part is that when fully deployed to the organization, Anaplan ensures the right people are planning with the right data, at the right time, and within the right connected process environment. Meaning, planners are driving business instead of running around endlessly piecing data together from different parts of the business.

Retail Planning History

I think it’s important to start with how technology was used to enable planning activities over the last 40 or so years because these solutions framed the retail planning landscape that we see today.

Before 1990 – Ledger Paper
Blog1990.pngBecause technology was so limited and data storage so expensive, the Retail Inventory Method (RIM) was the dominant method for inventory valuation and for inventory balancing. RIM does not use units but rather estimates the cost of goods sold by tracking the cumulative markup on new receipts. The method for merchandise planning and store planning was to use ledger paper and electric erasers. I can still remember the holes my eraser created from reworking my plans over and over.

The most important observation from this time period is that the demand for planning automation was so high that even a one-person solution was considered value-add. I should note that VisiCalc (1979), SuperCalc (1983), Lotus-123 (1983), Quattro Pro (1988), and Excel (1987) showed up in most of the retailers by 1990, but it was for DOS, slow, limited memory, and usually for one PC that everyone on the floor had to share. Mainframes had a role but mostly for transactional systems like item setup, allocation, purchase orders, and replenishment.

1990 to 2010 – The Rise of Spreadsheets and On-Premise Point Solutions
Time_PointSolutions.pngThe race was on to innovate using whatever technology was in Gartner’s upper right-hand quadrant. As technology evolved, we continually rebuilt our planning applications in the seemingly never-ending chase to get us one step closer to our Connected Planning vision.

By 2000, spreadsheets were so pervasive that on-premise point solutions were able to make a good case for their offerings to consolidate and enforce consistency through best practices. But it didn’t take long for retailers to realize that integrating these proprietary systems together was harder and more financially burdensome than trying to integrate all those spreadsheets. Sadly, most retailers continued to use their spreadsheets.

2010 to Present
Time_Cloud.pngInternet and computing speeds are fast enough to support software-as-a-service (SaaS). The new generation of cloud vendors were able to learn from prior generation solutions to build platforms that were very functionally rich and flexible, while also taking advantage of the latest advancements in technology to maximize speed and scalability.

Anaplan’s founder, Michael Gould, had been involved in the development of three prior generations of planning tools. Anaplan also benefited from not having to worry about compatibility with legacy applications, as they had a fresh start.

As one might expect, retailers were slow to adopt SaaS because many had already made significant investments in point solutions and point-to-point integrations. The pathway to a connected planning environment would require a practical and financially achievable roadmap.

Meanwhile, it was obvious to retail planning solution providers that SaaS was the future, and they quickly invested in their technology roadmap to point towards that aim. The problem for most of them, however, is that their applications were meant for on-premise, mostly client/server platforms, and the transition to cloud was, and still is, very challenging.

Native cloud solutions are inherently better optimized for Connected Planning because they use open source technologies, provide rich data integration methods, outsource scalable and secure data centers, rely heavily on in-memory storage, and best of all, leverage and connect their customers and partners to help improve their offerings.

2020 Retail Planning and Analysis Processes

Wheel.png

Retailers have known for a very long time what they want from a planning ecosystem. Everything in this retail wheel of functionality should relate to a common data source, but because of today’s mishmash of spreadsheets, point-to-point solutions, and unsupportable integration points, this diagram, for most, tends to resemble a wheel of idealism, an unobtainable library of enabled and connected processes.

Value Drivers

A common realization became evident as retailers’ solutions evolved from ledger paper to a kludgy and expensive integration of point solutions. That is, if the vision of a Connected Planning environment was the goal then there would have to be a financially rationalized strategic roadmap that takes them from their current state of investments to the envisioned state. In addition, the roadmap must also realize an ongoing return on investment.

To accomplish this task, many retailers used value drivers, or capabilities, that must be present in the solution as the complexity of the solutions increased. The value drivers are then mapped to KPIs which in turn are mapped to measurable financial drivers to rationalize capital investment.

ValueDrivers.png

To work within the boundaries of an organization’s human resources, appetite for scope, and budget allocation, a strategic roadmap can be implemented at a pace that optimizes these three competing levers. Implementations start with one to five use cases, typically framed in a long-term roadmap, to articulate the organization's long-term vision.

Illustrative example of a typical roadmapIllustrative example of a typical roadmap

Once a foundation is set and the benefits are documented, more advanced applications can be built and connected to each other. After that, other departments and divisions will take an interest and eventually a critical mass is reached where there is a Connected Planning environment established. Applications are integrated into a common data hub, ideally governed by an Anaplan Center of Excellence to support adherence to standards, knowledge sharing, and data governance.

Why Anaplan?

Anaplan connects and enables planning activities together in a single platform, a dream that started with retail planners before 1990 and born from frustration with having to erase their merchandise plans dozens of times in order to achieve turnover out three decimal points. Anaplan further adopts the advantages of future solutions by taking the ease of use and flexibility of spreadsheets and layering on the benefits of point solutions like security, scalability, and auditability.

Anaplan can accommodate a spectrum of applications, from simple to fully integrated and automated. This is Anaplan’s distinct advantage to connect all the planning activities in one platform.

ValueDriversExamples.png

Anaplan relieves the pressure on IT because the application development is designed to be built by business users. In addition to the development benefits and the financial benefits that come from connected planning, Anaplan also provides four distinct features.

AnaplanBenefits.png

Addressing Change Management

You might be asking, with all this change, how does Anaplan ensure user adoption? We all know that retail processes are fundamentally the same at their core, but we also know that no retailer implements them the same way or connects them similarly. Even within organizations that have multiple sales channels (retail, wholesale, eCommerce) and regions (Americas, Europe, Asia Pacific) there are usually inconsistent processes. Anaplan squarely addresses this need by connecting applications front-to-back, meaning they start with the user story and build out a solution around it. There are no pre-conceived solutions.

A great, flexible platform can miss the mark if proper diligence is not put in during the planning and execution of the application. Given the speed and flexibility of the platform, Anaplan implementations typically follow an Agile/SCRUM methodology, called the Anaplan Way. Anaplan also provides a blueprint for developing an Anaplan Center of Excellence in the organization with the intended vision to ensure user-adoption remains high, data quality is maintained, and applications are connected optimally.

ChangeManagement.png

But for many, the best part of Anaplan’s ecosystem is their Community exchange. There you can ask any question about the platform and usually, within 5 or 10 minutes you’ll get an answer, usually more than one, from people all around the world. In addition to being able to collaborate with other Anaplanners you will also find a vast library of documentation, best-practices, blog articles, and newsworthy events.

Summary

Post 1990, retailers finally could grow beyond the one-store format after the technology caught up and allowed them to automate routine tasks. Their vision of connecting all the functional areas of the company: human resources, merchandising, finance, accounting, operations, supply chain, marketing, and design was always well understood, but technology could only take them so far.

Over the years, retailers made massive investments in technology, and benefits were gained. However, with the introduction of eCommerce mega-retailers, traditional companies need to plan more effectivity and respond to insight through improved visibility across the organization if they want to compete.

With the adoption of SaaS platforms like Anaplan, the timeless vision of Connected Planning is possible. Implementation of a Connected Planning ecosystem doesn’t have to be rapid but rather, resolute, measured, and focused.

On a personal note, I’ve worked with many retail planning systems over the years. With the introduction of Anaplan, a SaaS provider, I have an optimistic outlook for what I’ve always believed to be the ideal retail planning configuration.



JaredDolichPortrait.pngJared Dolich is a Principal Consultant at Columbus Consulting. He is a Certified Master Anaplanner, Community Boss, and retail planning enthusiast. Jared’s passion for retail trace back to his high school days when he sold cinnamon toothpicks to his classmates and when he learned firsthand the concept of inventory management, cost of goods sold, and how to make a tidy profit. After being introduced to retail planning solutions as a buyer at Target Stores, he’s been on a personal journey ever since to help retail practitioners reach their potential by using software solutions that effectively enable their processes. Jared provides retailers, wholesalers, and eCommerce planners the rigor, training, and positive thinking needed to help them fully optimize their Anaplan platform. Prior to joining Columbus Consulting, a consultancy focused on the retail industry, Jared was a retail IT executive for Target, Tuesday Morning, Payless, and Ascena.

Contributors
Tom Phelps, Columbus Consulting Partner
Mark McNeela, Columbus Consulting Principal Consultant
Ameneh McCullough, Manager of the Master Anaplanner Program at Anaplan