DM
MD04; MM03
[00:00:00] Hey, everyone, Martin here. If you're all about maximizing the ROI in your SAP system, you've come to the right place. In this video, we're going to delve into the forecast consumption. And in this case, specifically backward and forward consumption. So often we hear from clients, well, if we could only get the forecast fixed, everything will be just fine. The truth is forecast is all about knowing the risk in the forecast and being prepared to manage it. Today, Patrick is going to take us and introduce us to one of the key features that can help us with this. Okay, please, Patrick, tell us more about what the forecast consumption mode of backwards and forwards offers us. You bet, Martin. I know from personal experience just how tricky demand management can be. Even with a decent quality forecast, it can be challenging if you don't have the right settings in place to help you deal with variance in either time, quantity, or both. So, let's [00:01:00] dive in and take a look. Today, we're going to touch on where we find the consumption mode and how to select it. Discuss how to set the number of days, in this case working days, to deal with that variability. And how to think about choosing the consumption mode based on the demonstrated bias. Let's go in and take a look. Today we are going to talk about some forecast consumption parameters. These fields are often misunderstood and they can make a significant impact on your supply chain if used incorrectly. First, I want to show you where to find the consumption mode so I can explain it in greater detail. I almost always start on the MD04 screen when evaluating planning parameters. So let's start there and do a quick overview of the data before we jump into the material master. We can see that this material number has a planned independent requirement loaded to represent the forecast. It looks like the forecast is roughly 23 pieces per week, April 1st, April 8th, April 15th, and so on and we can also [00:02:00] see a sales order for 100 pieces on May 2nd.Now, let's switch our view to summarize this data in weekly periods. We want to do this because we're going to make some changes to the system down the road, and this will give us an idea of what it looked like before we made those changes. So, here we have the planned independent requirements at a rate of 23 or so per week. We have requirements of 100 pieces on week 18 for that sales order that we looked at. And as MRP does its math, it says you need 23 this week, 23 this week, 23 this week, 22 this week, and then all of a sudden we need 23 pieces for planned independent requirements and 100 pieces to cover that sales order. So a total of 123 pieces there in week 18. So MRP is actually adding the customer demand to the forecast. Are we sure we want to do that? Let's leverage some built in functionality by letting the system [00:03:00] know how we want our forecast to be decremented when we get orders. Finally, we are ready to talk about consumption mode. So, the consumption mode controls the direction on the time axis in which the system consumes the forecast. Let me show you what I mean and then you can start using it as you see fit. So, from the MD04 screen, we're going to double click on the material number and then, we're actually going to navigate to the MRP3 tab. Maybe a tab that you don't use too often. So, in this case, we want to scroll and look into the planning section and there it is, consumption mode. So, before we start changing numbers, let's look and see what consumption mode does and we're just going to click into the field and look at some of the standard options. So, here we are, let's click, and let's see what the system is telling us. So, today's topic is actually going to focus on one of my personal [00:04:00] favorites, option 2, backward forward consumption. But before we can get to that one, I've used SAP in many industries, and it's always hard to predict when the orders are going to come in. If you have a steady flow of orders throughout the week, or if you have a month end push or a quarter end rush to hit sales quotas, these options can be extremely valuable tools and the reason that I said backward forward consumption is one of my favorites is it actually gives us some flexibility. So, let's start with a quick overview of backward consumption. With backward consumption, sales orders consume forecasted quantities that lie before the requirement state. And with forward consumption, sales orders consume forecasted quantities that lie after the requirement state. So naturally, with backward forward consumption, sales orders consume forecasted quantities that lie before the requirement state. And if the actual demand is not satisfied, the sales orders [00:05:00] then consume forecasted quantities that lie after the requirement state in order to satisfy the remaining demand. Too confusing? Let's try it out. So, the idea here is to start with backward forward consumption and then see how it changes that view that we looked at on our MD04 screen. So, let's quickly go over to MM02 and go into change mode and go to that MRP3 tab and then go to our plant and from here we're going to actually go in and we're going to update our consumption mode. Again, I'll show you the examples, backward forward consumption is the one that we want to use. But, this doesn't work by itself. Just defining the mode doesn't work by itself, you actually have to go in and tell the system how many periods backwards, how many periods forwards, you need to populate so that those orders can be [00:06:00] consumed. So, before we jump in there, we take a quick look at backward consumption periods and just show you all that this is populated in work days. So, when we populate our consumption periods, backwards and forwards, we want to make sure that we populate it in work days. So if your company works five days a week and you want to consume a week of forecast, you should populate five. Whereas in some other SAP date fields, we use seven calendar days to represent a week. So it's always best to double check before you load the data. Now, let's go take a look at those numbers, backward consumption, forward consumption and look at what happens when we actually populate them. So again, these are in work days. So we'll start with 10 work days backwards. So when a sales order comes in, it's going to look back two weeks to see if there's forecast. We'll do 10 work days forward, [00:07:00] so if it sees demand 10 work days in the past, it will delete that, and then it will look forward if it hasn't consumed all of the independent requirements, it'll look forward 10 more days, two more weeks to decrement the forecast. So I'm going to save this, I'm going to execute MRP , we will run the MRP , and then go back to our MD04 screen, and double click on our material number again, enter, and I'm going to go just refresh the screen. And take a look at that summarized view to show our weekly demand. Now, what you'll see here, is you have that forecast, 23 in week 14, 23 in week 15, 23 in week 16. Now there's nothing in week 17. There's nothing planned in week 18. There's nothing planned in week 19. And there's nothing planned in week 20. Because this 100 piece [00:08:00] order, when it came in, SAP said, Oh, we have a 100 piece order? Let's go back two weeks and remove the forecast, but the forecast there wasn't sufficient, so it deleted roughly 46 pieces and then it said, okay, well, I deleted 46 pieces in the past backward. Then it looked forward and said, let me go delete whatever demand I have in the next two weeks. And it deleted more so that weeks 17, 18, 19 and 20 were all zeroed out. And now, instead of planning for 123 pieces in week 18, the backward and forward consumption has allowed us to not overplan. Because we have this 100 piece order, while we were expecting to get orders at a rate of 23 per week, we can't always tell when those orders are going to come in. So, thankfully, by changing those parameters, MRP will now, again, replan for us, and we're not [00:09:00] expecting orders in week 17, 18, 19 and 20 because we just got this one order for 100. And it actually looks pretty good to me, right? I don't want to bring in my forecast and sales orders inventory. I want to just aggregate the whole plan and figure out how to proceed. So, one more thing that I think we should talk about is forecast bias. I'm not sure if you've experienced it, but generally speaking, forecast bias can be described as a tendency to either over forecast or under forecast, leading to a forecasting error. If a material is typically over forecast because the sales team is overly optimistic, I would probably weight my forward consumption periods more heavily. We don't know if those sales will materialize, so let's start reducing the future forecast as those orders come in. However, if a material is typically under forecasted, I would do the opposite and weight my backward consumption periods more heavily. Let me come back into MRP3 and just remind you where we're talking [00:10:00] about. So, when we see that, you want the system to keep driving in material to support those sales that will inevitably exceed the forecast because of that bias. So, I'm actually pretty confident that knowing how to properly leverage these fields will help you to smooth variability when you don't know exactly what day or week your orders will come in. And it gives you an opportunity to leverage standard SAP functionality in the best way possible for your specific business patterns. Whew! Okay. Welcome back. In today's chat, we covered a lot. We discussed the options for forecast consumption, and as a reminder, if backwards forwards consumption, the demand will be matched with the current period. Then work backwards. And lastly, work forward. We discussed how this helps to smooth the variability in timing and quantity. And, before I leave you, I just want to note the importance of thinking about consumption and maintenance, or the reorganization of the forecast. Both as key parts of [00:11:00] facilitating your demand management program. This is a great topic, and all that was just the tip of the iceberg. Okay, Patrick, thank you so much for taking this robust topic and really breaking it down for us in actionable steps. This is such a good start, guys. Go forward, be curious, and explore. Speaking of exploring, feel free to go check out our video catalog of all the different videos that exist. And of course, if you have a specific question, feel free to submit it below.