Tag: technology

Forecasting 101: Yes, your forecast is wrong….now what?

If you didn’t know, no forecast is 100% accurate. At their core, forecasts are the best guess of what will happen, an educated guess. But it’s still a guess of human behavior which is difficult under the best of circumstances.

And yes, the accuracy of a forecast can improve with time. A myriad of models, formulas and theories can be applied to drive improvements. But what happens when you don’t have the time because the delta between forecast and actual is too large and/or the results impact business today?

First, keep working on the forecast. Forecasts drive multiple aspects of business, so work to improve the accuracy by:

  1. Reviewing accuracy monthly – Set up a monthly review to compare the forecast to what happened.
  2. Figure out where the miss occurred – Analyze the formulas/data/assumptions included in the original forecast to determine where the misalignment occurred.
  3. Adjust the forecast where needed – If you identify formulas/data/assumptions are the cause, adjust where needed.

In the meantime, here are three things you can do right now to mitigate the impact of forecast accuracy challenges:

  1. Use historical demand – Include a review of 12- or 3-month demand. Ideally, you would pick one or the other to reduce complexity and the possibility of someone picking whatever number they like.
  2. Use inventory analysis to categorize – Analyze your inventory, assign volume and volatility categories to each item. Determine your high volume items using (A.B,C analysis) and your high volatility (X,Y,Z analysis).
  3. Create a service level matrix based on categorization. – Create a matrix based on business needs for coverage. For example:
  1. If you have a high volume, low volatility item (A,X) you may want a high service level, and set it up with a smaller safety stock with consistent deliveries.
  2. If you have a low volume, high volatility item (C,Z) you may want a lower service level, and set it as on demand only or carry a set amount and only replace as needed.

Questions? Feel free to reach out.

Bill of Materials 101: Manufacturing BOM vs Planning BOM

Bill of Materials (BOM) are an important part of any manufacturing process. Bills of Materials contain all the parts (including assemblies and sub-assemblies), raw materials, and components to manufacture a product. Keeping these lists correct ensures accuracy in the production process, and provide supporting (procurement, planning, etc.) functions critical information.

While Bills of Materials can be used in various applications, two of the most common types are Manufacturing and Planning. Both types contain parts, raw materials, and components but have different structures and uses.

Manufacturing Bills of Material (BOM) –

Contents: Manufacturing BOM’s contain all the parts (including assemblies and sub-assemblies), raw materials and components to manufacture a product.

Structure: They are structured to reflect the actual manufacturing process on the production floor.

Use: Used to manufacture products.

Planning Bills of Materials (BOM) –

Contents: Planning BOM’s contain all the parts raw materials and components to manufacture a product. They generally don’t include the manufacturing structures (assemblies and sub-assemblies).

Structure: They are structured to reflect the material forecasting process.

Use: Used for Material Requirements Planning.

Questions? Feel free to reach out.