Talk to an expert →

Demand Forecasting and Inventory Planning for Spire

Prevent overstocks, avoid stockouts, optimise your ROI, and boost profits

Align supply with future customer demand

GMDH Streamline advises you how much to purchase and when. It utilizes either a periodic replenishment strategy or a min/max replenishment strategy. It generates replenishment proposal and creates a purchase plan based on demand forecast. Purchase plan can be exported into Spire as a set of automatically created purchase orders. Learn more about inventory replenishment strategies at the user guide.

Ensure optimal use of capital

GMDH Streamline ensures that you are not overbuying, storing, and tying up capital unnecessarily while also ensuring you have enough inventory to prevent stockouts. Safety stock is calculated based on desired service level (per SKU or per company), forecast error, and lead time variability. This approach maintains optimal safety stock. Streamline highlights issues with low or excess inventory and then provides purchasing recommendations. The projected inventory level also highlight exceptions, such as shortfalls, potential stockouts, and excess stock.

Seamless integration

In order to import your Spire data into GMDH Streamline, just enter your Spire account credentials and database name. Learn more how to import data from Spire at the user guide.

Still relining on manual work in Excel for sales and operations planning (S&OP)?

See what Streamline can do for you

  • Achieve optimal 95-99% inventory availability, ensuring you can meet customer demand consistently.
  • Attain up to 99% forecast accuracy, getting more reliable planning and decision-making.
  • Experience up to a 98% reduction in stockouts, minimizing missed sales opportunities and customer dissatisfaction.
  • Cut excess inventory by up to 50%, freeing up valuable capital and storage space.
  • Increase margins by 1-5 percentage points, boosting overall profitability.
  • Enjoy up to 56 times ROI within one year, with a 100% ROI achievable in the first three months.
  • Reduce the time spent on forecasting, planning, and ordering by up to 90%, allowing your team to focus on strategic activities.

Watch how quickly and easily you can connect Streamline to Spire

The solution provides bi-directional integrations with Spire

Key benefits

1. Fast and intuitive user interface

Streamline software is efficient and effective. Therefore you can concentrate on long terms goals and business development.

2. Seamless integration of company data sources

Bidirectional connectivity allows you to pull in data from your sales system into Streamline, as well as automatically export the forecasted order information back to your ERP system.

3. The smooth and fast implementation process

A successful implementation requires the coordination of many variable factors. The Streamline team is well aware of the gamut of sales and ERP systems available on the market nowadays. Thus, they will make sure you and your team are ready to go on promptly.

4. The ideal fit of the business process in your company

Spire Integration with Streamline needs to be aligned with your business goals and all of your company’s other processes.

There are many factors to consider when choosing the Spire Integration with Streamline system for your company. These might include the total cost of ownership of the selected solution, reliability, high-quality support, and finally, your ability to evaluate all features before making the decision.

5. Syncing ordering dates across SKUs

What do you do if your Min/Max replenishment strategy built-in into the ERP system throws a purchasing signal for one SKU, but other SKUs of the same supplier do not need replenishment yet? Min/Max ordering signals come per item while businesses issue purchase orders per supplier. So you either ignore the alert and have a shortage later or purchase a full container excessively. As opposed to ERP methods, Streamline raises purchasing signals per supplier. Streamline software predicts all purchasing signals during the next order cycle via a discrete-event simulation and purchases beforehand to have a smooth purchasing process with constant order cycle, or purchasing full containers (order cycle is variable), or EOQ.

6. Replacing formulas with Discrete-event simulation

Inventory replenishment is based on calculating future inventory levels during the next lead time and sometimes beyond that. That means your formula needs to account for numerous upcoming consumption and replenishment events. Sometimes it’s doable, but once you start dealing with event schedules like a shipment schedule or multiple orders in transit Excel gives up almost immediately.

While our competitors usually simplify calculations without colliding events realistically, Streamline creates a timeline with a one-day resolution and puts all schedules onto the timeline. Then Streamline executes the event sequence giving us the most accurate information about the company’s inventory levels with one-day precision. Sometimes it’s just a more precise method compared to replenishment formulas, but in many cases, it’s the only way to accommodate for the real-world supply chain complexity.

7. Using AI (Artificial intelligence) to forecast demand

Estimating seasonality, price elasticity, or top-down forecasting is not enough nowadays. Market changes very dynamically, and it’s hard to predict if your history of sales is yet relevant enough to the current situation and can be used to extrapolate into the future. That’s an area where we use our proprietary AI, so we only apply time series forecasting techniques, predictors, and level changes if AI says it’s appropriate to apply – just like if you are keeping an eye on every SKU every day.

8. Group EOQ (Economic order quantity)

Are you using EOQ in your work? If not, it is worth giving EOQ a closer look as this inventory planning concept significantly reduces your holding and ordering costs. Unfortunately, classic EOQ is calculated per SKU and not a group of SKUs. In a real-world supply chain, purchase orders contain several SKUs, if not hundreds. While Streamline supports classic EOQ calculation, it also offers group EOQ that goes far beyond the traditional approach making EOQ applicable to purchase orders with groups of SKUs.

That becomes possible thanks to the ability of Streamline to sync the order date for a group of items. Then Streamline moves the synchronization barrier back and forth to find the best order cycle for the group of SKUs and automatically minimizes the combination of holding and ordering costs.

Price: Request pricing.

Demo: Get a demo.

Inventory planning in Streamline

Let us take a closer look at Streamline features specific to inventory planning:

Download and evaluate GMDH Streamline or contact us to learn how to streamline the inventory replenishment process in your company.

Still relining on manual work in Excel for sales and operations planning (S&OP)?

See what Streamline can do for you

  • Achieve optimal 95-99% inventory availability, ensuring you can meet customer demand consistently.
  • Attain up to 99% forecast accuracy, getting more reliable planning and decision-making.
  • Experience up to a 98% reduction in stockouts, minimizing missed sales opportunities and customer dissatisfaction.
  • Cut excess inventory by up to 50%, freeing up valuable capital and storage space.
  • Increase margins by 1-5 percentage points, boosting overall profitability.
  • Enjoy up to 56 times ROI within one year, with a 100% ROI achievable in the first three months.
  • Reduce the time spent on forecasting, planning, and ordering by up to 90%, allowing your team to focus on strategic activities.

Watch the inventory planning capabilities video

Learn and see in action the key features and benefits of GMDH Streamline software.

Spire Integration with Streamline Features

Accurate Demand Forecast

Is demand forecast driving your inventory level?

Streamline looks at your historical sales data and automatically chooses the best statistical model to determine consumer demand in the future.

You can also manage, re-evaluate, and modify the forecast based on the additional information known internally by the management team or provided by your vendors and suppliers.

Projected Inventory Levels

Do you know the most efficient quantity of each item to carry in your inventory? Having too much or too little inventory has an associated cost and is not making the best use of your inventory investment.

The Streamline’s Projected Inventory Level feature calculates and displays the inventory level for future periods. These projected inventory levels are based on the current inventory, incoming supply, and forecasted demand, determined by your inventory targets and forecast needs.

The periods with future inventory level shortages are marked in red and overstocks in green. This allows you to ensure you are not overbuying, storing, and tying up capital needlessly while also providing sufficient inventory to prevent stockouts.

Order Planning

Do you always know when and which products to order based on your demand forecast and the constraints imposed by your suppliers and/or manufacturers?

You can create the perfect order instantly while maintaining your targeted inventory levels and ensuring the most effective use of your inventory investment. Streamline automatically generates the replenishment suggestions and creates the Order plan. The software calculates and provides your purchasing system (e.g., MRP systems) with an optimized order proposal. A reorder point, a minimum level, and a maximum level are also available for compatibility with MRP systems.

Stockout/Overstock alerts

Do you think a high degree of automation and alert-driven inventory planning is vital to your business?

The software highlights any issues with short or excess inventory. Additionally, it provides and then provides recommendations on how to optimize your inventory. The projected inventory level settings can also mark exceptions such as shortfall, potential stockouts, and excess stock.

Inventory Optimization

How do you define your optimal inventory level?

Streamline prevents the situation of short or excess inventory. Usage of inventory optimization tool will help you target service levels, reduce inventory, and make the best use of your inventory investment.

New Products Forecasting

Do you have new units that replace discontinued products or any very new commodity with limited market history?

Not a big deal! Streamline can link such profiles to the sales history of similar, existing products (substitutions) or set seasonal coefficients. This approach allows you to get a reliable forecast for those fresh items as well.

Spire Integration with Streamline Definitions

What is demand forecasting?

Demand forecasting is a process of understanding and predicting customer demand for a particular product or category. This process is based on the analysis of historical data of sales and market trends, with the following forecast based on the statistical forecast models such as seasonal, linear, or constant trend. The Supply chain management process depends on the future customer’s demand and the accuracy of trends prediction. That’s why demand planners take into account forecast accuracy and forecast error levels when doing demand forecasting. This is easy to get the most efficient levels using Streamline for demand forecasting. Streamline provides accurate demand forecast by using a build-in expert system that automatically analyzes each item for levels, seasonality, trends, and intermittency.

What is demand planning?

Demand planning is a business process of outlining and management of customer demand for products and services. Planning of a customer demand consists of a statistical forecast using the most appropriate model. As a result of the demand planning process, a company gets a sales plan that initiates a service-planning process, production, inventory planning, and revenue planning.

What is revenue planning?

Revenue planning is about the management of the resources in the company. In order to accomplish the expected revenue, the following things should be taken into account: analysis of existing resources, planning expected expenses and/or investments in your business. Streamline warns you about excess or lack of inventory by highlighting these items in the inventory report. It also calculates the turnover of each item and gives the trend in the future based on the forecast.

What is inventory planning & optimization?

Inventory planning means the process of managing on-hand items as well as making timely orders to determine the optimal quantity and to prevent overstocks and stockouts. The process of inventory optimization aims to balance between stock-keeping units (SKUs) and working capital to get the maximal income. Streamline has powerful capabilities for optimizing inventory levels, calculating safety stocks, and generating optimal purchasing plans. It also allows filtering items by supplier and road the order of different products to fit a container capacity the best.

What is material requirements planning?

Material requirements planning (MRP) is a process that includes a production planning, scheduling, and inventory control system used to manage manufacturing processes. In order to calculate what material is required and when an order can go into production, an MRP process takes into account information on the Bill of Materials (BOM), production plan, and material plan. Streamline allows you to generate a plan of material requirements based on the demand forecasts of finished products and a bill of materials (BoM).

What is the timeline for the implementation of Spire Integration with Streamline?

Overall, the process takes 9-12 weeks.

Implementation Roadmap

  1. Project Kick-off – Weeks 1-2
    • Identify stakeholders
    • Define roles and responsibilities
    • Create a timeline
    • Perform detailed requirement analysis
    • Define success criteria
    • Arrange a communication plan

  2. Deployment – Weeks 3-4
    • Server Installation
    • Server setup, configuration, and validation

  3. Data upload and verification – Weeks 5-8
  4. Connection, configuration, verification, stress testing, and use case validation for:

    • Transactions: sales history, provision history, etc.
    • Item information: Item list (SKUs, categories/families/groups, Locations, Channels)
    • Inventory: on hand, in transit
    • To Ship / To receive (open Sales Orders, Purchase Orders)
    • Bill of materials (BOMs)
    • Create Streamline project .gsl file
    • Users/Permissions setup
    • Supplier information: lead time, minimum order quantity, etc.
    • Other required functionality (e.g., promotions, inter-site transfers, replacement/substitution rules)

  5. Training – Weeks 9-11
    • General training for all stakeholders
    • In-depth live session: Demand Forecasting
    • In-depth live session: Inventory Planning
    • One-on-one Administrator training
    • Follow-on Q&A workshops
    • Overview of online course and User Guide

  6. Project review – Weeks 11-12
    • Forecast Review
    • Inventory Review
    • Purchase orders review
    • Transfer orders, Manufacture orders (if required) reviews
    • Reports and Dashboard Review

  7. Testing and Approval – Weeks 11-12
    • Post production test (PVT)
    • Project Deployment sign off
    • Complete roll out!

What our customers say about us

Eric Tewey

Streamline has made a major difference in our forecasting and manufacturing planning. The ease of use, flexibility, and accuracy has far exceeded our expectations. Streamline has helped take our forecasting accuracy from average to world-class; which has a very positive bottom line impact. In addition, to Streamline being a great tool for us, the customer service we receive is second to none: it’s impressive. The time invested in learning our business, our model, and our people has been greatly appreciated and shows in the results.

Vice President of IT at Swisher International
Jacob Shallman

GMDH Streamline is the small business demand forecasting dream come true. If you are too small for a huge ERP and big enough to need to track and forecast demand and reorders this is really the perfect tool. It integrates so nicely into QuickBooks and in one click runs your regular reports. It takes out all the hours and hours of manual updating. I love this tool.

See what Streamline can do for you

Overall Rating of Streamline

  • Ease of Use 5/5
  • Customer Service 5/5
  • Features & Functionality 5/5
  • Value for Money 5/5