Updated: Nov 17, 2022
A printable PDF is available here.
If you follow any of the work/writing that we do on S&OP, you will quickly realize that we believe data to be an important part of the S&OP process. At the center of our philosophy on S&OP is the 5-Section Sheet. This sheet is a family view that connects demand with supply AND covers the buffers or levers that you must manage the business. These being inventory, backlog and flex capacity.
The 5-Section sheet presents the story for the family. By being able to view all of this information at together, you have an actionable plan. You can read more about the 5-Section Sheet in Duncan’s article “Getting to the Story” or pick up his book: Sales and Operations Planning How to Run an S&OP Process Everyone Understands.
Sometimes however data, or numbers, can make it difficult to see the story. This doesn’t mean the data is not important, however for some of us, it is hard to “feel” what is happening if the data is overwhelming. As a result, people push for graphical representations or dashboards for S&OP. But what is the right way to do this? Too often, graphs are over-simplified or over-complicated and the understanding of what you are presenting is lost.
The graphical view still needs to answer the fundamental questions you should look for out of S&OP. These are:
What happened in the past? Did we do what we said we wanted to do?
What has changed in our plan going forward?
What are the risks in the plan?
Are we tracking to our objectives (budget, backlog targets)?
Do we have a viable plan (i.e.. are demand and supply balanced)?
Is our process in control?
To understand this, let’s start with the 5-Section Sheet below:
I’m not going to go into the details the data presented here (check out the links above if you are interested in digging into this), but by understanding the data in this presentation you can answer these six questions. I’ve worked with many executives over the years, and once they know how to read this, they are able to quickly get a handle on what is happening in the business.
Now consider one section of the 5-Section Sheet in a graphical view to see how it helps answer these questions. The section we will consider is the Shipment Plan. This is a good place to start because shipments usually represent the section of the plan that directly links to revenue. Often this is the focus of the S&OP process, so not a bad place to start. The graph is shown below, with the data pulled directly from the 5-Section Sheet.
First, look at general format for the graph.
It contains both historical and planned or “forecasted” information. The S&OP month we are in is April. The months from September to March (shaded in grey) are the last six months of history. Months April through March going forward are forecasted. History allows me to validate what has happened.
The forecast is in units. This is important because it allows me to balance the data to supply and inventory.
I’m not showing it here, but I use the same format for the other sections of the 5-Section Sheet (bookings, supply, backlog, and inventory).
Secondly look at some of the data elements. To do this I’ve stripped out a portion of the data to make it easier to see.
The green solid line represents the actual historical shipments (grey area) and the current planned shipments for the April S&OP plan. Once again, this answers how did we do, and what do we plan to do going forward.
The red dashed lines represent a fixed tolerance level (in this case plus or minus 15%) from the previous plan (S&OP plan for March). By showing this data on the graph I can see:
Am I in control? Out of the past six months, only once (September) have I been able to call shipments within a +/- 15% tolerance. Four out of the six month’s we have under forecasted our shipments. Working on removing a bias and improving the forecast accuracy should be an objective for this family.
How much volatility have I put into the plan? In last month’s S&OP meeting we had a spike in May, which has now shifted out to June. We would need to look at the supply and inventory graphs to get a full picture of the impact of this; however there is a question as to what is driving this volatility two months out.
How confident am I in the plan going forward, based on our plan accuracy in the past? What level of risk do I assign to the plan based on this information?
The pink bars represent the aged backlog by promise date. Seeing the aged backlog against the shipping plan allows me to assess the risk in meeting the shipping plan or potentially impacting my lead-time market strategy. From the graph, I can see that there were some open orders that should’ve shipped in March that are past due. These plus the backlog for April equal the shipment plan for that month. By knowing the desired backlog profile and customer expected lead-time, I can gauge the risk on pushing out customer lead-times or being able to meet my shipment plan. A couple examples would be:
If the customer expected lead-time for this product is 4 weeks, I am not calling for a high enough shipment plan. My first two months are filled with open orders (the pink bars match the green line). I’m at risk of not meeting expected lead times.
If this family has some book and ship demand, our shipping plan is too low. There is no room in month one (once we factor in the past due orders) between the open orders and the shipping plan. This won’t allow for drop-in orders.
Now let’s go back to the full graph and include the budget.
The green shaded area represents the budget. This is the dollar-ized budget converted to units for the family. Is our plan tracking to the budget set for the year. This allows us to see if we are tracking close to our desired targets for the family. We can also see that we don’t have a budget established for the next fiscal year, which starts in October.
To assess the viability of the plan you need all five sections of the 5-Section Sheet. By graphing the other sections of the sheet, you can create a complete picture for the family on one slide. By using the same format across all 5-Sections you can get to the complete story.
The math in the 5-Section sheet ensures that you have a balanced plan. If the plan is unbalanced, the math will not work. Being able to view it graphically often helps the story come out clearer for all involved in your S&OP process. If you are going to simplify your message, make sure you can still answer the six fundamental questions, and you will be well on your way to having an effective S&OP process. If you have questions on how to do this don’t hesitate to reach out.
The 5-Section Sheet is our standard method of assembling and presenting the S&OP family data. For an in depth understanding of the 5-Section Sheet please refer to the book Sales and Operations Planning; How to Run an S&OP Process Everyone Understands. This book covers the mechanics of the 5-Section Sheet in detail.
Learn more about how you can use the 5-Section Sheet through the DBM S&OP Tool to implement a sustainable S&OP.
How effective is your S&OP?
Evaluate your process and get recommendations.
At DBM Systems, our consultants have over 20 years of experience providing S&OP leadership to businesses worldwide. We equip teams with coaching and the tools needed to run an effective S&OP process. Learn about our process and unlock the power of S&OP in your organization.