Category Archives: Forecasts

Pre-Defined Forecasting Models — Are They Worth It?

It seems all of the inventory management and service management platforms these days are touting the myriad of forecasting models in their latest and greatest release, but are they worth it?

It’s a hard question to answer. Here are some of the main arguments from both sides of the fence. You be the judge.

Supporter: You should check out this great new software for inventory and service management (SISM) from Hyper Yard Product Engineering (HYPE). It supports time series, casual, and combined forecasting models that allows you to define forecast types, horizons, target replacement rates, smoothing constants, variance parameters, seasons and trends, target costs, target fill rates, thresholds, and a slew of other parameters. It will save your buyers a lot of time, experts and novices alike.

Detractor: I don’t know. Sounds like a bunch of hoopla to me. Not only do most “experts” believe that only their models are the right models, they are likely to be suspicious of the results unless they can tweak every parameter and analyze the assumptions and algorithm in detail. And even then, if the resulting curve doesn’t adhere to their intuition, they are likely to call it a pile of junk and override it with a manual forecast. As for novices, it’s not very useful either as they aren’t likely to have the competence necessary to understand the inputs or outputs or the reason why one method is preferable to another for a given commodity or category and will likely choose the wrong method and screw-up the parameters.

Supporter:Oh no, not hoopla at all. It’s extremely useful to both parties. It’s a great help to novices as it automatically selects the right model given the commodity or category, sets the parameters based on contract data and historical inventory patterns, and correlates to similar commodities in the system. It greatly increases the accuracy of their results. And since it provides dozens of algorithms, where each parameter and assumption can be overridden, experts will love it as it will contain their algorithm, allow them to tweak the parameters, and override results with a manually derived model where needed.

Detractor:So, the expert can override the system at any time and the novice doesn’t have to choose anything?

Supporter:Correct. An expert can even define a fully manual forecast if the situation is unusual (such as a one of a kind promotion or rapid uptick in the economy) and a novice doesn’t have to do anything.

Detractor:So, the novice gets a free ride until the black swan decides to attack and cause a major catastrophe, and the expert gets to bypass the system entirely. In the first case it’s misused, as no system can compensate for human intelligence and every forecast needs a sanity check, and in the second case it’s not used at all. Sounds like a waste of money to me.

Supporter:No, no. You miss the point. By automating the process, it gives the user time to focus on learning the category so that she can tweak the parameters when she notices an unusual uptick or downtick and so that she can focus on analyzing the forecast and performing the sanity check instead of wasting hours or days trying to manipulate formulas and software to produce the forecast. And since it has so much power, the expert won’t need to override with a manual forecast very often.

Detractor:In theory, yes, but in practice no. Human nature is what it is. Most novices are tactical procurement personnel who don’t understand the math behind forecasting and don’t want to. They’ll drive whatever forecast the system spits out until they drive off the cliff. And most experts are arrogant know-it-alls who don’t believe a dumb system can ever come close to their years of experience and massive ego. They’ll tweak or override every forecast even if there isn’t a compelling reason and even if the forecast is probably right (because only they can be right) and tweaking it makes it wrong. Both ways, the company loses. Not only does it lose the investment in the system, but it loses out when it gets stuck with excess inventory or fails to meet demand.

Supporter:Well, you have to use the system properly to take advantage of its power.

Detractor:Right. And neither party will. Furthermore, if forecasting really was a science and if these tools always worked as advertised, the world would be an easy place. But the reality is that most demand is impulse and spike driven and most forecasting is nothing more than dumb luck in the end. As a result, all those continuous and curve fitting algorithms turn out to be worthless as they can’t model spikes. The reality is that you can get as much accuracy from a kindergartener’s hand drawn curve, especially if it looks “close” to historical demand curves.

Supporter:That’s why these tools also have extensive comparative graphing capabilities that allow you to compare current forecasts against past behavior for similar horizons. You can see whether or not the forecast is in line with what normally happens and whether or not there are any spikes consistent with your expert’s “gut feeling”.

DetractorThat’s nothing more than warm fuzzies, and warm fuzzies mean nothing. It’s as useful as Wall Street’s “risk” algorithms. Heck of a lot of good they did us.

Supporter:That’s why the tools allow you to update the forecasts at any time to take into account the latest changes in demand.

DetractorSo what? Spikes are, by their very nature, unpredictable. All you can do is “smooth” the curve to the new data. An unexpected spike is an unexpected spike is an unexpected spike and you lose millions in sales because of it. Just ask Apple or Nintendo or Sony who seriously underestimated initial demand for a number of their recent products.

Supporter:Look, we both know that no tool will solve all your problems and that spikes only occur in a few categories. For example, for many consumer goods, and many consumables in particular, demand is relatively constant year after year. Some brands or models may sell a little more or less than predicted, but most categories of household goods rise steadily with the population. We’re not going to suddenly start washing our clothes twice as often, start drinking twice as much coffee a day, or buying twice as many CDs. You need to start somewhere, and a tool that’s likely to get most of it mostly right out of the box is a great time saver. Plus, the best way to detect a spike or a drop is to instantly be able to see whether or not demand is following the plan. That’s the true power of these tools.

DetractorMaybe, but if that’s the case, what do you need all the advanced modeling for? Wouldn’t a simple time series with the ability to fully define a forecast by hand be just as good?

Share This on Linked In

Five Common Inventory Management Mistakes from Demand Solutions

Demand Solutions recently released a white paper on managing inventory for optimal advantage (registration required) that overviewed 10 common inventory mistakes and how to correct them. Of these, the following five can cost an organization dearly if not corrected.

  • Forecast Management without a Process

    All stakeholders have to agree on the process and the forecast that results and someone needs to own the process to insure it’s implemented properly. Otherwise the budget will be padded and the end result will be obsolete inventory and associated losses.

  • Not Talking to Customers

    Good inventory management is more than just the right volume, it’s the right volume at the right time in the right place. Be sure to understand what is driving customer replenishment patterns to insure that production is synched to customer needs. Otherwise, inventory can build up for months at a time, which will incur additional storage costs.

  • Forcing the Budget

    Don’t overlay the budget on top of the sales forecast. Both are approximations and both need to change to reflect reality. Attempting to synch them will result in production patterns that don’t match actual demands.

  • Too Many SKUs in Too Many Places

    This greatly decreases warehouse efficiency and increases fulfillment costs.

  • Never Trying New Things

    New technology provides better capability for ongoing, collaborative improvement. Avoiding new technology will limit operational efficiency and cost savings opportunities.

Share This on Linked In

If You Want to Control the Bullwhip …

… and its effects that can be very detrimental to your inventory levels, associated costs, and overall supply chain revenue, don’t do any of the following:

  1. Second Guess the System and Overcorrect

    This typically happens when a buyer orders early, thinks he needs more “just in case” inventory, or believes that the system has under-estimated inventory requirements. When this happens at each stage of the supply chain, the original order requirements end up increasing significantly. For example, if a buyer at a retail store adds 10%, then a buyer at the local warehouse adds 10%, then a buyer at the central warehouse adds 10%, and then the distributor adds 10%, the supplier will get an order for 146.4% of the original order volume and the supply chain will become saturated with excess inventory.

  2. Last-Minute Unplanned Promotions

    This goes for both buyers and sellers. Buyers, don’t allow marketing or sales to do last-minute unplanned promotions that were not taken into consideration during the forecasts. Without re-running all the forecasts, you can’t know how much more inventory you’ll need, and you’ll over-order “to be safe”. Furthermore, this surprise over-order will cause bullwhip second-guesses up the chain. Suppliers, don’t offer last-minute enticements to get a buyer to buy more. The net effect will be that your buyers will have too much stock, and then drastically cut their orders next time around. These unexpected cuts across the board will result in distributors overcorrecting downward, and then there won’t be enough inventory in the system and sales, and revenue, will be lost by all.

  3. Tweak the Order

    If you have a good, modern, forecasting and inventory management system that can make use of all of your historical data, multiple forecasting algorithms, and run multiple what if scenarios that can take into account multiple assumptions, then, as long as the forecast and inventory plan was generated by a seasoned pro, on average, it’s going to be much better than anything your gut tells you. Tweaking just leads to uncontrolled overcorrections throughout the supply chain.

  4. Increase the Batch Size

    Just because you can get an additional volume discount on order volume or shipping doesn’t mean that you can arbitrarily increase the batch size without consequences. Total cost of ownership, which will have been minimized by your inventory management or strategic sourcing decision optimization system, can involve dozens of variables. For example, there’s the inventory storage cost which could exceed the volume discount, especially if your warehousing cost is high. If you’re currently at FTL, it might put you over to FTL and LTL, and the LTL costs could be much higher. And, of course, the over-order will be followed by an under-order, which could lead to two devastating over-corrections by your distributor who was unprepared for the large swings up and down in order sizes.

Share This on Linked In

MCA Solutions – Bringing the Aftermarket Forward, Part II

In Part I, we re-introduced you to MCA Solutions, a Philadelphia, PA company that specializes in after market service (and service parts) optimization, and noted that they were still going strong despite some recent shake-ups in the market (and the noteable acquisition of Servigistics and Click Commerce by Marlin Equity Partners, who also acquired Emptoris not too long ago). We noted that, in addition to completing a strong SAP integration, they’ve also added a considerable amount of new functionality in the last two years around reporting, plan analysis, and reporting management.

Since we covered their new reporting and plan analysis solution in the last part, today we’re going to cover their performance management solution. Since you can’t manage what you can’t measure, and the best way to measure is often with a balanced scorecard, it’s based on scorecards, but since managers don’t like columns of numbers, it’s implemented using a dashboard, but since MCA agrees with me that traditional dashboards are inherently dangerous and dysfunctional, they realized that the only way the application would be truly useful was if it clearly identified not what was right, but what was wrong (since a goal of after-market service is exception-based management so that you only expend resources where needed). More importantly, the scorecard dashboard would only be useful if it allowed you to quickly discern what was wrong and do something about it. So what MCA built is a dashboard scorecard that not only highlights any metric that is out of bounds in red, but an interactive graphical scorecard that allows you to drill down into the metric retrieve all of the data associated with that metric in a single click.

Just like you can drill into a spend cube, you can drill into any metric on the scorecard. The first level drill will bring up all of the metrics the high level dashboard is composed of, and highlight which metrics are a problem. You can then drill into those metrics and bring up all of the associated raw data. So, if you brought up the scorecard and saw on-time delivery was only 80%, when anything under 90% is unacceptable, you could drill in and see the problem ports are LA and New Orleans and that San Diego, Washington, Vancouver, Boston, and Halifax were all meeting or exceeding their on-time delivery targets. You could drill in again and see that at these ports, most of the late deliveries were from West Coast Warblers and East Cost Easies and instantly know that either these suppliers have performance problems or that you’re not allowing them enough time in your inventory network design to transport the parts require to replenish your North American stock from your foreign suppliers. But since you can also drill into the application and the underlying model associated with any part, location, or supplier you can quickly determine if it’s a performance problem or a network design flaw. For instance, lets say you only allow 14 days for replenishment of goods in your LA warehouses from Shenzhen. Considering that sailing time is typically 12-15 days, and that it probably takes at least a day to get your goods unloaded at the port, and another for them to clear customs, get loaded onto the truck, and transported to your warehouse, there’s no way you’re going to get that part in less than 14 days by sea and it’s probably going to take at least 17 days on average, especially if these carriers are running slower ships. Then you know you need to adjust your model, and measure the supplier against a more reasonable delivery time. But if you are allowing 21 days, and your third party carrier is consistently late, then you have a supplier performance problem.

Moreover, the scorecard dashboard is completely customizeable. Each component is actually a dashboard report, and with their new flexible reporting capability, you can build any report you want. So you can design the dashboard to focus only on reporting problems. That way you can ignore the 90% of your network that is running smoothly and dive right into the 10% that isn’t running right, analyze the situation, revise the model, analyze the revision, implement an improvement, and see if the situation improves over time. If not, you can dive right in and try again. And if everything looks too good, you can define more metrics, more sanity checks, and find new problems to work on. Which is precisely what an actionable scorecard should allow you to do!

And your suppliers in China and Japan can use it too. The product is double-byte Unicode compliant and, in addition to a number of European languages, has also been translated into Mandarin and Japanese. With these recent improvements, you should be able to plug it right into your follow-the-sun operation and, once it’s configured and your data is complete, close the loop on your end-to-end after market service (parts) operation.

Share This on Linked In

MCA Solutions – Bringing the Aftermarket Forward, Part I

MCA Solutions, a Philadelphia, PA company that specializes in after market service (and service parts) optimization, is still going strong despite the recent struggles of a few of its direct competitors (namely Click Commerce and Servigistics who were recently acquired by Marlin Equity Partners). If anything, the recession (although it did considerably lengthen the sales cycle) only bolstered the need for after market service (as no one could afford new equipment) and optimization thereof (as everyone is strapped for cash and every penny counts).

As I indicated in my first post on MCA Solutions and their strategic service parts management platform, many large manufacturing, semiconductor, high-tech, aerospace, defense, and oil & gas companies often have tens of millions, if not hundreds of millions, of dollars tied up in inventory in their attempts to meet specified service levels, and every dollar in inventory costs them money in overhead. Since many of these companies typically have 10% to 20% more inventory than they need, they’re tying up tens of millions of dollars in working capital needlessly as well as throwing away millions of dollars in inventory holding costs — a situation which is easily remedied by a service level optimization platform that can optimize your multi-echelon parts inventory storage network such that your contracted service levels are met but your costs are minimized. Furthermore, as per the value of after market service in a down economy, done right, this optimization will also improve cash flow by roughly 10%, reduce inventory by 15% to 50%, and even improve service levels by 5% to 20%.

Since the last time I covered MCA in depth, which was almost two years ago, they’ve made a number of significant enhancements to their platform, the most notable being flex reporting, performance management, and plan analysis. Of these, flex reporting and plan analysis excite me the most, because the former lets you construct any report you can imagine (if you’re willing to write some SQL*) and the latter lets you build, optimize, and compare as many what-if scenarios as you want, which is the (one of the) most powerful feature(s) of any good optimization platform.

Their plan analysis tool not only allows you to define your service parts strategy (fill rates, inventory/investment caps, number of echelons to consider simultaneously in stock planning, etc.) and run an analysis on that strategy (to determine total cost and inventory distribution), and not only allows you to compare one strategy against another (how much do I save by sacrificing 1% of fill rate? how does inventory distribution change? etc.), but also allows you to define a rules-based sanity check that can be run against every model and the resulting inventory solution. For example, if the inventory levels change by more than 20%, the overall investment changes by more than 10%, shortages or excesses at any location exceed pre-defined maximums, etc., the product will immediately warn you that the new model might not be an acceptable replacement over the current one. Also, each of these rules can be defined by location, SKU (or family), or segment (or lane), which gives you a lot of flexibility in your analysis and sanity checks. (Other checks can include replacement rate, forecasting model [parameters], export mode, horizon, manual overrides, time factors, intermittence, thresholds, and other relevant measures tracked and/or computed by the platform.) Furthermore, they’ve also added the ability to generate plans by Average Customer Wait Times, which is becoming important in aerospace and defense, oil and gas, and other sectors where you have equipment that can’t be unavailable for more than a very short amount of time and service (availability) levels aren’t good enough.

While we’re talking analysis, they’ve also added a new multi-period budget report which is a system generated report that is very useful as it not only calculates total forecast, condemnation forecast, repair forecast, overall metrics, TSL, average inventory position, scheduled demand, new buy, and cost across your entire operation to anywhere between 12 and 36 months in the future, but does so using a successive series of automated optimizations where the output of one period is used as the input to the next. It will take anywhere from a few minutes to a few hours to run, but it clearly allows you to see the long term effects of any change to your aftermarket service (parts) strategy.

In the next post, we’ll talk about their new performance management solution.

* Yes, I’ll admit that I’m not your average user but I have to applaud them for acknowledging their expertise is not in the creation of report builders, that no set of canned reports, no matter how extensive, will please everyone, and that the right thing to do is expose the schema and let power users do what they want — which isn’t dangerous when you also give them the ability to make as many copies (partial or full) of the database as they want and to mess around with the copies, and not the production data.

Share This on Linked In