Forecasting Metrics and KPIs

Your dashboards are green but your problems keep getting worse. You're tracking revenue per employee, units produced, and efficiency percentages. All trending upward. But customers still complain about quality. Equipment still breaks down unexpectedly.   Operators still struggle with changeovers. Here's why most metrics miss the mark: They measure what happened yesterday. Not what will happen tomorrow. They focus on outputs. Not the inputs that create those outputs. These 8 KPIs actually predict and prevent problems: 1. OEE (Overall Equipment Effectiveness) Shows equipment reality, not just availability 2. First Pass Yield Reveals true process capability 3. Total Cost of Quality** Captures the real price of problems 4. Employee Suggestion Implementation Rate Measures engagement that drives improvement 5. Setup/Changeover Time Determines your flexibility advantage 6. Supplier Quality Performance Prevents problems at the source 7. Safety Leading Indicators Predicts incidents before they happen 8. Customer Complaint Resolution Time Shows responsiveness that builds loyalty Each metric drives specific behaviors. OEE pushes systematic waste elimination. First Pass Yield forces quality at the source. Cost of Quality makes prevention profitable. The best manufacturing teams measure fewer things. But they measure the right things. And they act on every single number. Stop measuring your past. Start predicting your future. Question for you: If you could only track one KPI for the next 90 days, which would drive the biggest change?

“𝗢𝘂𝗿 𝗳𝗼𝗿𝗲𝗰𝗮𝘀𝘁 𝗮𝗰𝗰𝘂𝗿𝗮𝗰𝘆 𝗶𝘀 𝟴𝟱%.” A great metric to track — but do you know what's behind that number? In supply chain planning, 𝗳𝗼𝗿𝗲𝗰𝗮𝘀𝘁 𝗮𝗰𝗰𝘂𝗿𝗮𝗰𝘆 isn't just a KPI — it's a reflection of how well your decisions align with reality. And like most metrics, it depends heavily on how it’s measured. Different scenarios call for different approaches — using the right metric helps you:  • Evaluate planning effectiveness  • Build trust in numbers  • Drive better inventory and service outcomes Here’s a breakdown of the 3 most common and useful forecast performance metrics: 𝟭. 𝗠𝗔𝗣𝗘 (𝗠𝗲𝗮𝗻 𝗔𝗯𝘀𝗼𝗹𝘂𝘁𝗲 𝗣𝗲𝗿𝗰𝗲𝗻𝘁𝗮𝗴𝗲 𝗘𝗿𝗿𝗼𝗿) Formula: MAPE = (|Forecast – Actual| / Actual) * 100 > Simple to interpret > Can be sensitive when actual demand is low 𝟮. 𝗪𝗔𝗣𝗘 (𝗪𝗲𝗶𝗴𝗵𝘁𝗲𝗱 𝗔𝗯𝘀𝗼𝗹𝘂𝘁𝗲 𝗣𝗲𝗿𝗰𝗲𝗻𝘁𝗮𝗴𝗲 𝗘𝗿𝗿𝗼𝗿) Formula: WAPE = Σ|Forecast – Actual| / ΣActual > Stable across portfolios with high demand variability > Common in CPG, retail, and multi-SKU environments 𝟯. 𝗙𝗼𝗿𝗲𝗰𝗮𝘀𝘁 𝗕𝗶𝗮𝘀 Formula: Bias = Σ(Forecast – Actual) > Indicates whether forecasts consistently lean high or low > Key to understanding planning behavior 𝗕𝗲𝘀𝘁 𝗣𝗿𝗮𝗰𝘁𝗶𝗰𝗲: Use 𝗪𝗔𝗣𝗘 for a realistic measure of error, 𝗕𝗶𝗮𝘀 to monitor forecast tendencies, and 𝗠𝗔𝗣𝗘 when demand is stable and volumes are meaningful. 𝗙𝗼𝗿𝗲𝗰𝗮𝘀𝘁 𝗮𝗰𝗰𝘂𝗿𝗮𝗰𝘆 𝗶𝘀𝗻’𝘁 𝗮𝗯𝗼𝘂𝘁 𝗽𝗲𝗿𝗳𝗲𝗰𝘁𝗶𝗼𝗻 — 𝗶𝘁’𝘀 𝗮𝗯𝗼𝘂𝘁 𝗰𝗹𝗮𝗿𝗶𝘁𝘆, 𝗰𝗼𝗻𝘀𝗶𝘀𝘁𝗲𝗻𝗰𝘆, 𝗮𝗻𝗱 𝗰𝗼𝗻𝘁𝗶𝗻𝘂𝗼𝘂𝘀 𝗶𝗺𝗽𝗿𝗼𝘃𝗲𝗺𝗲𝗻𝘁. #SupplyChain #Demandforecasting #Accuracy #InventoryManagement #DemandPlanning #CostOptimization #Logistics #Procurement #InventoryControl #LeanSixSigma #Cost #OperationalExcellence #BusinessExcellence #ContinuousImprovement #ProcessExcellence #Lean #OperationsManagement

In one of my earlier roles in demand forecasting, our BI system used a very simple percentage error formula: (forecast - actuals)/forecast. At the time, I questioned whether dividing by the actuals might provide a more accurate picture of forecast performance, but like many things in practice, it wasn’t a high priority for discussion. Later, at another company, we used MAPE across all products, including those with highly intermittent demand. It was a consistent approach, but no one really questioned whether a different metric might better capture the nuances of different demand patterns. It wasn’t until my time back to university doing my PhD that I encountered the broader landscape of forecast accuracy metrics. That’s when I started asking a bigger question: which metric should be used for which purpose? Forecast accuracy seems simple until you try to measure it consistently across products, teams, or tools. Most people start with MAPE or RMSE because that’s what the software provides. But eventually, the questions come up: – Why does one model look better on RMSE but worse on MAPE? – Why do different teams report accuracy differently? – Why does it feel like the numbers don’t tell the full story? I wrote this article to help unpack those questions: what each accuracy metric emphasizes, when it’s most useful, and what happens when different metrics lead to different conclusions. It includes: – A breakdown of common metrics like RMSE, MAE, MAPE, sMAPE, MASE, and more – Practical examples of when each metric works best — and when it doesn’t – Guidance on how to choose the right metrics based on product portfolios and business goals I'm curious, which forecasting error measures are being used where you work? Are you using more than one?

The Best Forecast Metric is the One Everyone Understands The goal of a successful S&OP process is a shared reality – a common view of the potential future demand along with the risks and opportunities that exist within the planning horizon. A common obstacle to creating this shared reality is KPI’s that not all S&OP team members understand. Unless everyone sees how often and how much an item’s demand varies from its forecast, it is nearly impossible for the team to work together to find and resolve any issues. It is also important to understand that forecasts will always vary from actual demand, and how much variation is acceptable for your organization. This is why I am a huge fan of using forecast bias as a common metric for S&OP discussions. It is easy to calculate and explain, and it gives a clear picture of recent forecast performance. As a demand planner, I am supposed to be the expert in forecasting; expecting everyone on the S&OP team to be equally versed in the complexities of forecasting demand is, to me, not realistic. I think of it this way: everyone can understand if an item is over- or under shooting the forecast. And if an item consistently exceeds or falls short of the planned demand, it needs attention. The example below is the bias model I use. It looks at the last 3 months forecast performance and calculates a bias percent for the 3 months in total. (I’m actually allergic to measuring bias month-by-month, as this only shows how much noise the demand contains.) It also shows the variance by month, which allows for examining and explaining one-off large variations in specific periods – variations which can often be explained by unexpected purchases or promotions that were unplanned. The goal here is to quickly find and show the items with the largest consistent variation, so that the team can analyze these items and see if the forecast needs to be adjusted. This helps create the shared reality that everyone can understand and if necessary, agree that action is required.

Forecast accuracy is one of the most overrated metrics in supply chain. I say that as someone who likes modeling and believes forecasting matters. But too many organizations quietly turn the forecast into the goal instead of treating it as an input into a decision. That is where things go sideways. A lower MAPE looks impressive in a review deck, but the business does not get paid for pretty error metrics. It gets paid for better allocation of inventory, capacity, and capital under uncertainty. I have made this point repeatedly… supply chain should be judged in economic terms, and optimizing proxy metrics can drift far away from optimizing the actual business. Let’s explore a simple example… Imagine two SKUs. One is a cheap, low-margin item with steady demand. The other is a high-margin item with lumpy demand and painful stockout consequences. A team can improve overall forecast accuracy by getting better on the easy SKU while still making poor replenishment decisions on the one that actually matters economically. The KPI improves, the slide looks better, and the business may still be worse off. That is exactly why I do not believe forecast accuracy should sit at the center of supply chain thinking. The decision is the center. The forecast is only valuable insofar as it improves the decision. Items compete for scarce capital, so the real question is which decision deserves the next dollar, not which forecast looks nicest in aggregate. This is also why I am aligned with Joannes Vermorel in the fact that supply chain is much closer to applied economics than most people admit. Once capital is limited, truck space is limited, shelf space is limited, and demand is uncertain, the problem becomes “how do I make better tradeoffs?” In that world, a metric can be dangerous if it creates the illusion of control while hiding the actual ranking of decisions. Decisions should be assessed by their economic return over time under uncertainty, not by tradition or local KPIs that merely look scientific. That is why I have become increasingly skeptical of teams that obsess over forecast accuracy in isolation. I am not against better forecasts. I am against mistaking a cleaner prediction for a better business. If your forecast KPI improves but your capital is still flowing into the wrong products, then the KPI is not helping you think.

Most companies look at revenue once a year. Strong operators review the right numbers every month. The reality? 🚫 Total revenue alone hides real problems 🚫 Growth can look strong while churn increases 🚫 New sales mean little without retention 🚫 Wrong metrics lead to wrong decisions Here are revenue KPIs to review every month: 1. Check Total Revenue ↬ See if the business is actually moving forward ↬ Flat numbers signal hidden issues 2. Track Monthly Recurring Revenue ↬ Predictable income shows stability ↬ Strong MRR makes growth easier to plan 3. Measure New Revenue ↬ Shows if acquisition efforts work ↬ No new revenue means pipeline weakness 4. Watch Expansion Revenue ↬ Upsells and upgrades show customer trust ↬ Existing customers should grow over time 5. Monitor Churn ↬ Lost customers reveal retention problems ↬ High churn destroys long-term growth 6. Know Average Revenue Per Customer ↬ Helps guide pricing and targeting ↬ Higher value customers improve efficiency 7. Calculate Customer Acquisition Cost ↬ Shows how expensive growth really is ↬ CAC must stay lower than customer value 8. Track Customer Lifetime Value ↬ Reveals long-term revenue potential ↬ Strong LTV supports sustainable scaling 9. Review Revenue Growth Rate ↬ Percentage growth shows real momentum ↬ Slow growth early becomes big later 10. Check Revenue Concentration Risk ↬ Too few customers create danger ↬ Diversified revenue protects stability Revenue leadership is not guessing. It is reviewing the right numbers every month. Growth becomes predictable when metrics are clear. 👉 Start with the Growth & Profitability Scorecard https://lnkd.in/ekcgYfGe

The Pipeline Problem: 4 KPIs to Increase Pipeline Predictability and Revenue 80% of sales orgs miss forecasts by over 10%. Why? It’s not lack of lead volume — it’s the wrong GTM metrics. First Principles tell us predictable pipeline comes from measuring what drives revenue, not chasing (vanity) metrics like MQLs. The solution? Hyper-aligned Sales, Marketing, and Revenue Operations on KPIs that identify inefficiencies and drive unified GTM execution. Below, I share 4 KPIs that IMHO increase pipeline predictability, which I define as the ability to accurately forecast volume, quality, and timing of opportunities that will convert into revenue. Yes, there are many roads to Rome regarding ideal B2B recurring revenue KPIs, but here are four that I like to ameliorate a pipeline problem. 1) Bowtie Funnel Conversion Rates: In addition to lead volumes, track the % of opportunities moving from MQL to SQL to SAL and the rest of the opportunity funnel. A good benchmark for scaleups? 20-25% MQL-to-SQL. Below 15% — find the leakage — likely misaligned lead scoring or weak ICP fit. 2) Cost Per Qualified Opportunity: Measure the cost of generating a mid-stage opportunity. Look at this over a trailing-twelve-months. Start by benchmarking against yourself. If you feel your measurement is high, your demand gen or ABM may be burning cash on low-intent or non-ICP prospects. 3) Active Open Opportunities (AOOs): Identify opportunities with a meeting in the last 30 days and buyer communication in the last 14 days (thank you, Mark Kosoglow). Where possible, I like to centrally help reps identify targets. AOO keeps them focused on high-intent pursuits. 4) CAC Payback Period: How long to recover acquisition costs? Best-in-class is 12-18 months. Over 24 months? Your pipeline’s too thin, or deals are stalling. By adopting these four buyer-centric KPIs, SaaS scaleups can transform unpredictable pipelines into more reliable revenue engines, aligning teams, optimizing spend, and more effectively hitting forecasts — ultimately driving sustainable growth and greater board confidence. Measuring your GTM organization with these KPIs is a starting point to driving aligned execution and improved pipeline predictability. What’s your go-to KPI for pipeline predictability? What’s your biggest forecasting challenge? I share Winning by Design's Bowtie Funnel below. One of my favorite tools to drive alignment on GTM investment. #firstprinciples #winningbydesign #revops

I’ve talked before about Planning Season and the opportunity that analytics offer as a true force-multiplier for a company during the planning process. One thing that still surprises me is that many product and growth teams struggle in setting clear goals, such as defining a specific KPI value to aim to achieve by a certain date. In other cases, those who have actually set goals, they are defined in a somewhat random manner. 🤔 Clearly, it’s quite difficult to define success if you don’t set these goals. That’s why the best product companies in the world are investing significant efforts in the process - I know this first-hand from my days at Google. Defining goals should rely on two different methods that eventually converge: Top-Down and Bottom-Up: 👉 Top-Down - This method is based on company management setting goals for the company, for example achieving 30% year-over-year growth. The Product and Growth teams should then identify the biggest levers and define the KPIs that will enable the company to achieve this 30% growth, such as conversion, retention, engagement, revenue per user, etc. 👉 Bottom Up - Here, we map out all our initiatives and estimate the size of the impact. A good bottom-up will include: ☑️ The forecast of the KPI based on the current trend - aka the ”do nothing” scenario. ☑️ Then, adding the initiatives, the launch date(s), and estimated impact by the goal date. 💡 It may sound like a complex process, but assuming you have the right infrastructure, it’s quite straightforward. It also enables you to set your team up for success, gives you the ability to measure yourself and learn from the process, and helps you create a predictable and structured growth process. #ProductAnalytics #CausalML Loops

I used to think forecasting was all about crunching numbers. Boy, was I wrong. The game-changer? Integrating non-financial data. Here's what I've learned: 1. Employee satisfaction scores → predict productivity trends 2. Website traffic patterns → indicate future sales 3. Supplier performance metrics → forecast potential disruptions By combining these with traditional financial data, we've improved forecast accuracy by 35%. It's not just about better numbers. It's about making smarter decisions. What non-financial data has surprised you with its predictive power? #FinancialForecasting #CFOStrategy #FractionalCFO #StartupFinance #Growth #CFOInsights #CFOServices #Strategy #SMBgrowth #StrategicFinance #SmallBusinessSupport #StartupFinance #SMBfinance #ScalingUp

Most leaders track KPIs that tell them what already happened. Revenue. Churn. Profit margin. ✅ Important? Yes. ❌ Predictive? Not even close. Traditional KPIs are like looking in the rearview mirror while driving 80 mph. You’ll see where you’ve been but you’ll miss the curve ahead. Forward-looking KPIs change that. 💡 They measure momentum, adaptability, and readiness, not just results. 🔹 Instead of “Revenue,” track Pipeline Velocity (how fast qualified deals move). 🔹 Instead of “Employee Turnover,” track Capability Growth Rate (how fast your team’s skills evolve). 🔹 Instead of “Profit Margin,” track Automation ROI Velocity (how long innovation takes to pay off). These metrics tell you if you’re building a business that can sustain growth, not just report it. Because in a world where markets shift overnight, the question isn’t “How did we do?” It’s “Are we ready for what’s next?” ⚡ When leaders make that shift from lagging to leading indicators, they stop reacting and start anticipating. They gain clarity. They allocate better. They make decisions with confidence. I just created a new infographic to help you in this transition. 📊 “12 Forward-Looking KPIs for the Next Decade of Leadership” It breaks down the metrics innovative companies are already tracking across strategy, people, finance, and operations. Save it. Share it with your team. Use it to reimagine what success looks like in your organization. Download a PDF from our website under Resources https://5ftview.com/ Because the future isn’t measured in what’s happened. 🤯 It’s measured in what’s about to. Shoutout to a mentor, former leader of mine and friend for teaching me about forward-looking KPIs a loooonng time ago Michele Friedman #Leadership #Strategy #KPI #BusinessGrowth #FractionalLeadership #AI #FutureOfWork #5FTView