A customer wants 100 bicycles next month. You already have some finished bicycles in stock, wheels are arriving from a supplier, frames are stored somewhere else, and your production line is booked for the next two weeks. What should you buy, what should you build, what should you move—and when does each action need to happen? In this episode of M365 FM, Mirko Peters explains how Dynamics 365 Master Planning connects customer demand, inventory, purchasing, production, bills of materials, lead times, capacity, forecasts, and planned orders to create one connected supply plan.
WHAT IS DYNAMICS 365 MASTER PLANNING?
Dynamics 365 Master Planning is the part of Supply Chain Management that determines how future demand should be covered. Think of your business as an office building with a stockroom attached. Customer orders enter through one door. Inventory sits on shelves. Suppliers deliver materials. Production converts components into finished products. Master Planning looks across all of these activities instead of allowing each team to maintain its own disconnected plan. It combines current demand and available or expected supply, identifies shortages, and suggests actions for planners to review.
WHY A STOCK COUNT ISN'T ENOUGH
Imagine a customer orders 100 bicycles and your warehouse currently contains 30. You still need 70. But those 70 bicycles require frames, wheels, chains, seats, bolts, packaging, employees, machines, and enough production time. A simple inventory report tells you what exists now. It doesn't tell you whether the missing components can arrive before production needs them or whether the factory has enough time to complete the order. Master Planning connects quantity with time.
FROM SPREADSHEETS TO CONNECTED PLANNING
Without connected planning, sales might maintain customer orders in one system while warehouse employees check inventory somewhere else. Purchasing tracks supplier dates in spreadsheets and emails. Production maintains another schedule describing what the factory can build. Each individual list might be correct, but somebody still needs to connect everything to answer one question: Can we deliver what the customer ordered by the promised date? Dynamics 365 Master Planning brings these demand and supply signals together.
MASTER PLANNING VS A SPREADSHEET
Think of a spreadsheet as a photograph. It can provide a useful snapshot of inventory at a particular moment. Master Planning is closer to a forward-looking schedule. It considers quantities alongside dates, future demand, incoming supply, production requirements, and existing inventory. When one of those elements changes, the planning picture can change as well.
THE THREE PLANNING MODES
Dynamics 365 doesn't provide only one way to plan. The episode explains three different planning scenarios: Master Planning focuses on day-to-day and shorter-term requirements. Forecast Planning looks at expected future demand. Intercompany Master Planning connects demand and supply requirements between legal entities. Each starts with demand but answers a different planning question.
MASTER PLANNING AND NET REQUIREMENTS
Master Planning calculates net requirements. The basic concept is straightforward: Demand – Available or Expected Supply = Remaining Requirement Suppose a customer orders 100 units and the warehouse has 30 available. The remaining requirement is 70. If another 20 units are already scheduled to arrive from a supplier before the customer's required date, the uncovered requirement becomes smaller again. Dynamics 365 therefore doesn't simply suggest purchasing or producing the complete customer quantity. It considers supply that already exists or is expected to arrive.
WHY DATES CHANGE THE ANSWER
Having enough inventory eventually isn't the same as having enough inventory when it's required. Suppose 20 additional bicycles arrive from a supplier. If they arrive before the customer needs them, they can help satisfy the demand. If they arrive afterward, they don't solve this particular shortage. Master Planning therefore considers quantity and timing together. A total inventory number without dates can provide a misleading picture of whether customer demand can actually be fulfilled.
THE PLANNING HORIZON
The appropriate planning horizon depends on the business. A company purchasing simple products locally might only need to look several weeks ahead. A manufacturer using components with long supplier lead times may need to plan months ahead. The important principle is that planning needs to look far enough forward to identify shortages while there is still time to respond. Discovering a shortage after the required purchasing or production date has already passed provides very little value.
FORECAST PLANNING
Forecast Planning begins with expected demand rather than confirmed customer orders. A bicycle manufacturer might expect demand to increase during summer. A retailer might anticipate significantly higher sales during a pro...