During my work with numerous brand owners and manufacturers, I have been amazed to see multi-billion dollar companies manage their business using spreadsheets. Sure, they have state-of-the-art ERP systems for capturing transactions, but when they project revenue, decide whether to build up supply of one product line over another, or make capital investment decisions - out comes Excel!
Don’t get me wrong, Excel is a great tool. It lets you create lots of models, lets you enter and edit any data you want, and lets you see the impact of changing the model and data. However, it was not designed as an enterprise application!
I have seen companies struggle with formal, monthly, sales and operations planning (S&OP) processes. Why did they struggle? The process took six weeks to complete! Hence when it came to making decisions, the primary input data, the level of customer demand, was six weeks out of date. You may well ask, “how can that be?”. The answer is that the collection, consolidation and analysis of the data, coupled with the mechanics of communicating and collaborating between Sales, Finance, and Operations required that amount of time. Within this process, it is extremely difficult to detect significant change, and certainly never time to respond to it.
Now, I am not proposing instant decisions. Rather, I am proposing that the time required for data collection, consolidation and analysis, and the time for communicating with participants should be nearly zero. If the entire S&OP process could be completed in a week, how would that change the process? What if it could be done in a single day? I suggest that weekly S&OP would improve customer response with lower inventory risk and investment.