In this article, we will review the “suggested orders” functionality in Epicor BisTrack, explain its limitations, and summarize how Smart Inventory Planning & Optimization (Smart IP&O) can help reduce inventory & minimize stock-outs by accurately assessing the tradeoffs between stockout risks and inventory costs.

Automating Replenishment in Epicor BisTrack
Epicor BisTrack’s “Suggested Ordering” can manage replenishment by suggesting what to order and when via reorder point-based policies such as min-max and/or manually specified weeks of supply. BisTrack contains some basic functionality to compute these parameters based on average usage or sales, supplier lead time, and/or user-defined seasonal adjustments. Alternatively, reorder points can be specified completely manually. BisTrack will then present the user with a list of suggested orders by reconciling incoming supply, current on hand, outgoing demand, and stocking policies.

How Epicor BisTrack “Suggested Ordering” Works
To get a list of suggested orders, users specify the methods behind the suggestions, including locations for which to place orders and how to determine the inventory policies that govern when a suggestion is made and in what quantity.

First, the “method” field is specified from the following options to determine what kind of suggestion is generated and for which location(s):

Purchase – Generate purchase order recommendations.

1. Centralized for all branches – Generates suggestions for a single location that buys for all other locations.
2. By individual branch – Generates suggestions for multiple locations (vendors would ship directly to each branch).
3. By source branch – Generates suggestions for a source branch that will transfer material to branches that it services (“hub and spoke”).
4. Individual branches with transfers – Generates suggestions for an individual branch that will transfer material to branches that it services (“hub and spoke”, where the “hub” does not need to be a source branch).

Manufacture – Generate work order suggestions for manufactured goods.

1. By manufacture branch.
2. By individual branch.

Transfer from source branch – Generate transfer suggestions from a given branch to other branches.

Next, the “suggest order to” is specified from the following options:

1. Minimum – Suggests orders “up to” the minimum on hand quantity (“min”). For any item where supply is less than the min, BisTrack will suggest an order suggestion to replenish up to this quantity.
2. Maximum when less than min – Suggests orders “up to” a maximum on-hand quantity when the minimum on-hand quantity is breached (e.g. a min-max inventory policy).

3. Based on cover (usage) – Suggests orders based on coverage for a user-defined number of weeks of supply with respect to a specified lead time. Given internal usage as demand, BisTrack will recommend orders where supply is less than the desired coverage to cover the difference.

4. Based on over (sales) – Suggests orders based on coverage for a user-defined number of weeks of supply with respect to a specified lead time. Given sales orders as demand, BisTrack will recommend orders where supply is less than the desired coverage to cover the difference.

5. Maximum only – Suggests orders “up to” a maximum on-hand quantity where supply is less than this max.

Finally, if allowing BisTrack to determine the reorder thresholds, users can specify additional inventory coverage as buffer stock, lead times, how many months of historical demand to consider, and can also manually define period-by-period weighting schemes to approximate seasonality. The user will be handed a list of suggested orders based on the defined criteria. A buyer can then generate POs for suppliers with the click of a button.

Limitations

Rule-of-thumb Methods

While BisTrack enables organizations to generate reorder points automatically, these methods rely on simple averages that do not capture seasonality, trends, or the volatility in an item’s demand. Averages will always lag behind these patterns and are unable to pick up on trends. Consider a highly seasonal product like a snow shovel—if we take an average of Summer/Fall demand as we approach the Winter season instead of looking ahead, then the recommendations will be based on the slower periods instead of anticipating upcoming demand. Even if we consider an entire years’ worth of history or more, the recommendations will overcompensate during the slower months and underestimate the busy season without manual intervention.

Rule of thumb methods also fail when used to buffer against supply and demand variability.  For example, the average demand over the lead time might be 20 units.  However, a planner would often want to stock more than 20 units to avoid stocking out if lead times are longer than expected or demand is higher than the average.  BisTrack allows users to specify the reorder points based on multiples of the averages.  However, because the multiples don’t account for the level of predictability and variability in the demand, you’ll always overstock predictable items and understock unpredictable ones.   Read this article to learn more about why multiples of the average fail when it comes to developing the right reorder point.

Manual Entry
Speaking of seasonality referenced earlier, BisTrack does allow the user to approximate it through the use of manually entered “weights” for each period. This forces the user to have to decide what that seasonal pattern looks like—for every item. Even beyond that, the user must dictate how many extra weeks of supply to carry to buffer against stockouts, and must specify what lead time to plan around. Is 2 weeks extra supply enough? Is 3 enough? Or is that too much? There is no way to know without guessing, and what makes sense for one item might not be the right approach for all items.

Intermittent Demand
Many BisTrack customers may consider certain items “unforecastable” because of the intermittent or “lumpy” nature of their demand. In other words, items that are characterized by sporadic demand, large spikes in demand, and periods of little or no demand at all. Traditional methods—and rule-of-thumb approaches especially—won’t work for these kinds of items. For example, 2 extra weeks of supply for a highly predictable, stable item might be way too much; for an item with highly volatile demand, this same rule might not be enough. Without a reliable way to objectively assess this volatility for each item, buyers are left guessing when to buy and how much.

Reverting to Spreadsheets
The reality is most BisTrack users tend to do the bulk of their planning off-line, in Excel. Spreadsheets aren’t purpose-built for forecasting and inventory optimization. Users will often bake in user-defined rule of thumb methods that often do more harm than good.  Once calculated, users must input the information back into BisTrack manually. The time consuming nature of the process leads companies to infrequently compute their inventory policies – Many months and on occasion years go by in between mass updates leading to a “set it and forget it” reactive approach, where the only time a buyer/planner reviews inventory policy is at the time of order.  When policies are reviewed after the order point is already breached, it is too late.  When the order point is deemed too high, manual interrogation is required to review history, calculate forecasts, assess buffer positions, and to recalibrate.  The sheer volume of orders means that buyers will just release orders rather than take the painstaking time to review everything, leading to significant excess stock.  If the reorder point is too low, it’s already too late.  An expedite may now be required, driving up costs, assuming the customer doesn’t simply go elsewhere.

Epicor is Smarter
Epicor has partnered with Smart Software and offers Smart IP&O as a cross platform add-on to its ERP solutions including BisTrack, a speciality ERP for the Lumber, hardware, and building material industry.  The Smart IP&O solution comes complete with a bidirectional integration to BisTrack.  This enables Epicor customers to leverage built-for-purpose best of breed inventory optimization applications.  With Epicor Smart IP&O you can generate forecasts that capture trend and seasonality without manual configurations.  You will be able to automatically recalibrate inventory policies using field proven, cutting-edge statistical and probabilistic models that were engineered to accurately plan for intermittent demand.   Safety stocks will accurately account for demand and supply variability, business conditions, and priorities.  You can leverage service level driven planning so you have just enough stock or turn on optimization methods that prescribe the most profitable stocking policies and service levels that consider the real cost of carrying inventory. You can support commodity buys with accurate demand forecasting over longer horizons, and run “what-if” scenarios to assess alternative strategies before execution of the plan.

Smart IP&O customers routinely realize 7 figure annual returns from reduced expedites, increased sales, and less excess stock, all the while gaining a competitive edge by differentiating themselves on improved customer service. To see a recorded webinar hosted by the Epicor Users Group that profiles Smart’s Demand Planning and Inventory Optimization platform, please register here.

​In a highly configurable manufacturing environment, forecasting finished goods can become a complex and daunting task. The number of possible finished products will skyrocket when many components are interchangeable. A traditional MRP would force us to forecast every single finished product which can be unrealistic or even impossible. Several leading ERP solutions introduce the concept of the “Planning BOM”, which allows the use of forecasts at a higher level in the manufacturing process. In this article, we will discuss this functionality in ERP, and how you can take advantage of it with Smart Inventory Planning and Optimization (Smart IP&O) to get ahead of your demand in the face of this complexity.

Why Would I Need a Planning BOM?

Traditionally, each finished product or SKU would have a rigidly defined bill of materials. If we stock that product and want to plan around forecasted demand, we would forecast demand for those products and then feed MRP to blow this forecasted demand from the finished good level down to its components via the BOM.

Many companies, however, offer highly configurable products where customers can select options on the product they are buying. As an example, recall the last time you bought a personal computer. You chose a brand and model, but from there, you were likely presented with options: what speed of CPU do you want? How much RAM do you want? What kind of hard drive and how much space? If that business wants to have these computers ready and available to ship to you in a reasonable time, suddenly they are no longer just anticipating demand for that model—they must forecast that model for every type of CPU, for all quantities of RAM, for all types of hard drive, and all possible combinations of those as well! For some manufacturers, these configurations can compound to hundreds or thousands of possible finished good permutations.

There may be so many possible customizations that the demand at the finished product level is completely unforecastable in a traditional sense. Thousands of those computers may sell every year, but for each possible configuration, the demand may be extremely low and sporadic—perhaps certain combinations sell once and never again.

This often forces these companies to plan reorder points and safety stock levels mostly at the component level, while largely reacting to firm demand at the finished good level via MRP. While this is a valid approach, it lacks a systematic way to leverage forecasts that may account for anticipated future activity such as promotions, upcoming projects, or sales opportunities. Forecasting at the “configured” level is effectively impossible, and trying to weave in these forecast assumptions at the component level isn’t feasible either.

Planning BOM Explained

This is where Planning BOMs come in. Perhaps the sales team is working a big b2b opportunity for that model, or there’s a planned promotion for Cyber Monday. While trying to work in those assumptions for every possible configuration isn’t realistic, doing it at the model level is totally doable—and tremendously valuable.

The Planning BOM can use a forecast at a higher level and then blow demand down based on predefined proportions for its possible components. For example, the computer manufacturer may know that most people opt for 16GB of RAM, and far fewer opt for the upgrades to 32 or 64. The planning BOM allows the organization to (for example) blow 60% of the demand down to the 16GB option, 30% to the 32GB option, and 10% to the 64GB option. They could do the same for CPUs, hard drives, or any other customizations available.  

The business can now focus their forecast at this model level, leaving the Planning BOM to figure out the component mix. Clearly, defining these proportions requires some thought, but Planning BOMs effectively allow businesses to forecast what would otherwise be unforecastable.

The Importance of a Good Forecast

Of course, we still need a good forecast to load into an ERP system. As explained in this article, while ERP  can import a forecast, it often cannot generate one and when it does it tends to require a great deal of hard to use configurations that don’t often get revisited resulting in inaccurate forecasts.  It is therefore up to the business to come up with their own sets of forecasts, often manually produced in Excel. Forecasting manually generally presents a number of challenges, including but not limited to:

• The inability to identify demand patterns like seasonality or trend
• Overreliance on customer or sales forecasts
• Lack of accuracy or performance tracking

No matter how well configured the MRP is with your carefully considered Planning BOMs, a poor forecast means poor MRP output and mistrust in the system—garbage in, garbage out. Continuing along with the “computer company” example, without a systematic way of capturing key demand patterns and/or domain knowledge in the forecast, MRP can never see it.

Extend ERP  with Smart IP&O

Smart IP&O is designed to extend your ERP system with a number of integrated demand planning and inventory optimization solutions. For example, it can generate statistical forecasts automatically for large numbers of items, allows for intuitive forecast adjustments, tracks forecast accuracy, and ultimately allows you to generate true consensus-based forecasts to better anticipate the needs of your customers.

Thanks to highly flexible product hierarchies, Smart IP&O is perfectly suited to forecasting at the Planning BOM level so you can capture key patterns and incorporate business knowledge at the levels that matter most. Furthermore you can analyze and deploy optimal safety stock levels at any level of your BOM.

In this article, we will review the inventory ordering functionality in Epicor P21, explain its limitations, and summarize how Smart Inventory Planning & Optimization (Smart IP&O) can help reduce inventory, minimize stock-outs and restore your organization’s trust in your ERP by providing robust predictive analytics, consensus-based forecasting, and what-if scenario planning.

Replenishment Planning Features within Epicor Prophet 21
Epicor P21 can manage replenishment by suggesting what to order and when via reorder point-based or forecast-driven inventory policies.  Users may compute these policies externally or generate them dynamically within P21.  Once the policies and forecasts have been specified, P21’s Purchase Order Requirements Generator (PORG) will create automated order suggestions of what to replenish and when by reconciling incoming supply, current on hand, outgoing demand, stocking policies, and demand forecasts.

Epicor P21 has 4 Replenishment Methods
In the item maintenance screen of Epicor P21, users can choose from one of four replenishment methods for each stock item.

1. Min/Max
2. Order Point/Order Quantity
3. EOQ
4. Up To

There are additional settings and configurations for determining lead times and accounting for order modifiers such as supplier-imposed minimum and maximum order quantities.  Min/Max and Order Point/Order Quantity are considered “static” policies.  EOQ and Up To are considered “dynamic” policies and computed within P21.

Min/Max
The reorder point is equal to the Min.  Whenever on hand inventory drops below the Min (reorder point) the PORG report will create an order suggestion up to the Max (for example, if on hand after the breach is 20 units and the Max is 100 then the order quantity will be 80).  Min/Max is considered a static policy and once entered into P21 will remain unchanged unless overridden by the user.  Users often run spreadsheets to compute the Min/Max values and update them from time to time.

Order Point/Order Quantity
This is the same as the Min/Max policy except instead of ordering up to the Max, an order will be suggested for a fixed quantity defined by the user (for example, always order 100 units when the order point is breached). OP/OQ is considered a static policy and will remain unchanged unless overridden by the user.  Users often run spreadsheets to compute OP/OQ values and update them from time to time.

EOQ
The EOQ policy is a reorder point-based method.  The reorder point is dynamically generated based on P21’s forecast of demand over lead time + demand over the review period + safety stock.  The order quantity is based on an Economic Order Quantity calculation that considers holding costs and ordering costs and attempts to recommend an order size that minimizes total cost.  When on hand inventory breaches the reorder point, the PORG report will kick out an order equal to the computed EOQ.

Up To
The Up To method is another dynamic policy that relies on a reorder point.  It is computed the same way as the EOQ method using P21’s forecasted demand over the lead time + demand over review period + safety stock.   The order quantity suggestion is based on whatever is needed to replenish stock back “up to” the reorder point.  This tends to equate to an order quantity that is consistent with the lead time demand because as demand drives stock below the reorder point, orders will be suggested “up to” the reorder point.

P21’s Item Maintenance Screen where users can specify the desired inventory policy and configure other settings such as safety stock and order modifiers.

Limitations

Forecast Methods
There are two forecast modes in P21:  Basic and Advanced.  Each use a series of averaging methods and require manual configurations and user determined classification rules to generate a demand forecast.  Neither mode is designed with an out-of-the-box expert system that automatically generates forecasts that account for underlying patterns such as trend or seasonality.  Lots of configuration is required that tends to inhibit user adoption and modification of the assumed forecasting rules defined in the initial implementation that may no longer be relevant.  There isn’t a way to easily compare the forecast accuracy of different configurations.  For example, is it better to use 24 months of history or 18 months?  Is it more accurate to assume a trend should be applied when an item grows by 2% per month or should it be 10%?  Is it better to assume the item is seasonal if 80% or more of it’s demand occurs in 6 months of the year or  4 months of the year? As a result, it is common for classification rules to be too broad or specific resulting in problems such as application of an incorrect forecasting model, using too much or too little history, or over/understating the trend and seasonality.   To learn more about how this works, check out this blog post (coming soon)

Forecast Management & Consensus Planning
P21 lacks forecast management features that enable organizations to plan at multiple hierarchy levels such as product family, region, or by customer.  Forecasts must be created at the lowest level of granularity (product by location) where demand is often too intermittent to get a good forecast.  There isn’t a way to share forecasts, collaborate, review, or create forecasts at aggregate levels, and agree on the consensus plan. It is difficult to incorporate business knowledge, assess forecasts at higher levels of aggregation, and track whether overrides are improving or hurting forecast accuracy. This makes forecasting too one-dimensional and dependent on the initial math configurations.  

Intermittent Demand
Many P21 customers rely on static methods (Min/Max and OP/OQ) because of the prevalence of intermittent demand.  Otherwise known as “lumpy”, intermittent demand is characterized by sporadic sales, large spikes in demand, and many periods with no demand at all. When demand is intermittent, traditional forecasting and safety stock methods just don’t work.  Since distributors don’t have the luxury of stocking only high movers with consistent demand, they need specialized solutions that are engineered to effectively plan intermittently demanded items. 80% or more of a distributor’s parts will have intermittent demand.  The stocking policies that are generated using traditional methods such as those available in P21 and other planning applications will result in incorrect estimates of what to stock to achieve the targeted service level.  As illustrated in the graph below, it isn’t possible to consistently forecast the spikes.  You are stuck with a forecast that is effectively an average of the prior periods.

Forecasts of intermittent demand can’t predict the spikes and require safety stock buffers to protect against stockouts.

Second, P21’s safety stock methods allow you to set a target service level but the underlying logic mistakenly assumes that the demand is normally distributed.  With intermittent demand, the demand isn’t “normal” and therefore the estimate of safety stock will be wrong.   Here is what wrong means: when setting a service level of, for example 98%, the expectation is that 98% of the time the stock on hand will fill 100% of what the customer needs from the shelf.  Using a normal distribution to compute safety stocks will result in large deviations between the targeted service level and actual service level achieved.  It is not uncommon to see situations where the actual service level misses the target by 10% or more (i.e., targeted 95% but only achieved 85%).

In this figure you can see the demand history of an intermittently demanded part and two distributions based on this demand history. The first distribution was generated using the same “normal distribution: logic employed by P21. The second is a simulated distribution based on Smart Software’s probabilistic forecasting. The “normal” P21 distribution recommends that 46 units is needed to achieve the 99% service level but when compared to actuals far more inventory was needed. Smart accurately predicted that 63 units was required to achieve the service level.

This blog explains how you can test your system’s service level accuracy.

Reliance on Spreadsheets & Reactive Planning
P21 customers tell us that they rely heavily on the use of spreadsheets to manage stocking policies and forecasting.  Spreadsheets aren’t purpose-built for forecasting and inventory optimization. Users will often bake in user-defined rule of thumb methods that often do more harm than good.  Once calculated, users must input the information back into P21 via manual file imports or even manual entry.  The time consuming nature of the process leads companies to infrequently compute their inventory policies – Many months and on occasion years go by in between mass updates leading to a “set it and forget it” reactive approach, where the only time a buyer/planner reviews inventory policy is at the time of order.  When policies are reviewed after the order point is already breached, it is too late.  When the order point is deemed too high, manual interrogation is required to review history, calculate forecasts, assess buffer positions, and to recalibrate.  The sheer volume of orders means that buyers will just release orders rather than take the painstaking time to review everything, leading to significant excess stock.  If the reorder point is too low, it’s already too late.  An expedite is now required driving up costs and even then, you’ll still lose sales if the customer goes elsewhere.

Limited What If Planning
Since features for modifying reorder points and order quantities are baked into P21 it is not possible to make wholesale changes across groups of items and assess predicted outcomes before deciding to commit.  This forces users to adopt a “wait and see” process when it comes to modifying parameters. Planners will make a change and then monitor actuals until they are confident the change improved things.  Managing this at scale—many planners are dealing with tens of thousands of items—is extremely time consuming and the end result is infrequent recalibration of inventory policy. This also contributes to reactive planning whereby planners will only review settings after a problem has occurred.

Epicor is Smarter
Epicor has partnered with Smart Software and offers Smart IP&O as a cross platform add-on to Prophet 21 complete with a bidirectional API-based integration.  This enables Epicor customers to leverage built-for-purpose best of breed forecasting and inventory optimization applications.  With Epicor Smart IP&O you can generate forecasts that capture trend and seasonality without having to first apply manual configurations.  You will be able to automatically recalibrate policies every planning cycle using field proven, cutting-edge statistical and probabilistic models that were engineered to accurately plan for intermittent demand.   Safety stocks will accurately account for demand and supply variability, business conditions, and priorities.  You can leverage service level driven planning so you have just enough stock or turn on optimization methods that prescribe the most profitable stocking policies and service levels that consider the real cost of carrying inventory. You can build consensus demand forecasts that blend business knowledge with statistics, better assess customer and sales forecasts, and confidently upload forecasts and stocking policies to Epicor with a few mouse-clicks.

Smart IP&O customers routinely realize 7 figure annual returns from reduced expedites, increased sales, and less excess stock, all the while gaining a competitive edge by differentiating themselves on improved customer service. To see a recorded webinar hosted by the Epicor Users Group that profiles Smart’s Demand Planning and Inventory Optimization platform, please register here: https://smartcorp.com/epicor-smart-inventory-planning-optimization/