“What should I do to improve in my planning career?”
That’s a question I receive often.
And I get it. I’m the same way.
We all strive to deliver better results and exceed expectations.
While career paths can vary, I have outlined the core fundamentals to learn and master.
They will help you build a solid foundation for your career to take off and thrive.
I have posted this infographic on LinkedIn that shows step by step the actions to take.
Let’s walk through each stage with practical examples and what you need to learn to thrive at every level.
Step 1: The Foundations
At the beginning, the focus should be on mastering the fundamentals of demand planning and inventory management.
There isn’t a single role in supply chain that doesn’t connect to inventory.
We live and breathe it.
It’s important to get hands-on with ERP systems.
From my experience, many large companies use SAP and many mid-sized companies use NetSuite.
Learning how to check stock levels, find open purchase orders, and interpret demand history are critical.
Example: A sales team member asks, “Do you know when we’ll get more of Product X?”
To answer this, planners need to know how to review on-hand inventory, track open purchase orders, and check planned receipts in the ERP system.
The ability to respond accurately builds credibility and establishes planners as reliable problem-solvers.
Step 2: Basic Forecast & Inventory
Once planners are comfortable navigating the system, the next step is to strengthen Excel skills.
Yes, that’s right: Excel.
It remains the number one tool for planning, and in many organizations, it’s still the backbone of forecasting and inventory analysis.
In my view, spreadsheets will be around for years to come.
That’s why planners gain a significant advantage when they master Excel.
Forecasting typically begins with historical data: cleaning it, building pivot tables, and identifying trends.
It is helpful for planners to be familiar with formulas such as AVERAGE, IF, and VLOOKUP, and begin automating repetitive tasks using tools like Power Query.
Example: A manager requests a 12-month rolling forecast for the top 20 items.
This requires organizing past sales data, identifying seasonal patterns, and applying techniques such as moving averages or exponential smoothing to project future demand.
Step 3: Reporting & Execution
At this stage, planners are fully engaged in the execution engine.
Key responsibilities include managing planning calendars, tracking open orders, and calculating safety stock and reorder points.
Planners also create reports that inform procurement, production, and sales teams, enabling timely decisions.
Cross-functional collaboration becomes critical; especially when defining what to include in the reports and how frequently they should be updated.
The ease of updating or running a report is also an important factor, as overly complex reports can slow down decision-making.
Example: A weekly report is developed to flag when key SKUs fall below safety stock thresholds. This report triggers replenishment actions and helps prevent stockouts across the supply chain.
Step 4: Demand and Supply Reviews
At this stage, planners move beyond producing data.
They begin presenting it to tell the story.
Forecast variances, customer insights, and market events are discussed in cross-functional meetings.
This is where planners start building influence and contributing to decision-making.
Example: Marketing announces a new promotion.
The planner analyzes the expected demand uplift and collaborates with the supply planning team to ensure that sufficient production capacity is in place to support it.
Step 5: Tools to Anticipate; Proactive Approach
Planners who advance more quickly often develop forecasting tools that go beyond Excel.
At this stage, visualization platforms like Power BI become essential.
These tools allow planners to build dashboards that present data at different levels of granularity; for example, by product, customer, region, or time period.
Power BI offers a wide range of visualization formats to support better decisions.
One of my favorite visualizations is the waterfall chart, which breaks down the differences between forecast and actuals step by step.
For example, it can show how promotional uplift, seasonality, or supply issues contributed to a forecast variance.
These visual insights help stakeholders to see what happened and understand why.
By shifting from static spreadsheets to dynamic dashboards, planners make it easier for teams to interact with the data, spot anomalies early, and respond proactively.
Example: A dashboard is built to flag when actual sales deviate from forecasts by more than 15%.
A waterfall chart is used to explain the drivers behind the variance.
Sales and operations teams now use this tool weekly to identify root causes and course-correct in real time.
Step 6: Scenario Planning
This step is vital in today’s dynamic environment. Scenario planning becomes a critical capability; evaluating “what-if” situations to prepare for uncertainty and minimize risk.
This involves modeling the impact of different variables such as demand surges, supplier delays, capacity constraints, or raw material shortages.
The goal is to understand trade-offs and develop mitigation strategies in advance, rather than scrambling when disruptions occur.
Scenario planning also strengthens collaboration across functions. Finance may request margin impacts, procurement may need to explore alternative suppliers, and manufacturing may evaluate overtime or shift changes.
Planners act as the bridge by connecting the dots and quantifying the operational and financial implications of each scenario.
Example: A scenario is created to assess the impact of ocean freight lead times increasing from 4 to 6 weeks.
The analysis shows which SKUs are at risk of stockouts, how much additional safety stock would be required, and what the cash flow impact would be.
This insight helps leadership make timely decisions and avoid service disruptions.
Step 7: S&OP for Strategic Decision-Making
Here planners evolve from analysts into strategic business partners. The focus shifts to leading or supporting the Sales and Operations Planning (S&OP) process.
S&OP goes beyond balancing demand and supply. It is a forum where decisions are made to align operations with financial goals.
Planners now contribute to cross-functional discussions that integrate demand forecasts, supply constraints, inventory targets, and financial projections.
The role expands beyond operational accuracy to shaping strategy: identifying risks, presenting trade-offs, and helping executives make informed decisions.
Strong communication, business acumen, and the ability to tell the story behind the numbers become just as important as the technical skills.
Example: The commercial team proposes launching a new product line in Q4. After reviewing production capacity and inventory levels, the planner models several scenarios.
One shows that the launch would displace higher-margin items due to line limitations.
The S&OP discussion leads to a revised plan that balances profitability, capacity, and service levels; driven by insights from the planning team.
Conclusion:
By mastering the fundamentals, embracing new tools, and stepping into broader conversations, planners can grow into some of the most critical decision-makers in the organization, shaping the future of the business.
