Talk to an expert →

How Streamline reduced materials inventory by 40-50% in pharmaceutical industry

Key Results:

  • Materials inventory reduction opportunity in the range of 40% to 50% during the following 4-6 months
  • Service level to customers was improved
  • Full visibility of inventory excess and stockouts was achieved by using the KPIs dashboard
  • The process was standardized for all buyers aligned to best practices.

About the company

Success story provided by a GMDH’s Implementation Partner, Logyt. Logyt is the strategic partner that collaborates with clients to optimize the Value Chain of their business through practical, flexible, and sustainable solutions, with the ability to deploy and operate them.

“In addition to being very competent, Logyt has a high ethical level that favors projects success” Supply Chain Director


The complicated supply planning process and the challenge of the excess inventory

Logyt`s client from the pharmaceutical industry had faced the challenge of the excess inventory and complicated supply planning process. The supply Planning process is performed by the buyers in Excel spreadsheets, starting from a forecast produced in ForecastPro by the planning area. Excel spreadsheets were not standardized, and the quantities placed in purchase orders are subject to the buyer criteria and experience. Logyt identified a big opportunity for reducing inventories in this company. The mid-term strategy was to implement SAP planning modules, but the reducing of the inventories was urgent.


The solution proposal consisted of a full redesign of the Supply Planning process (MPS, MRP) and implementation of a pilot test with a selected contract manufacturer through a transitional tool that enables process standardization and alignment with best practices. The new tool has been possible to implement in Excel or specialized software Streamline that allows visibility of the inventory reduction potential. The company decided to go with the Streamline solution. The implementation of the project took 5 months ( from October 2019 till March 2020).

“Good job with the MRP developed for the Supply Chain Director” CFO



“Good team by Logyt, on one hand, a lot of experience, and on the other someone young with the desire to contribute” Key User

Supply Planning Process re-engineering and the implementation of an already developed commercial tool Streamline has resulted in the following benefits:

  • Materials inventory reduction opportunity in the range of 40% to 50% during the following 4-6 months, maintaining or improving service level to customers.
  • Standardized process for all buyers aligned to best practices.
  • Process and tool replication capability with the remaining local contract manufacturers, and eventually on the global level.
  • KPI’s integrated into the selected tool that among many other features, provide visibility of inventory excess and stockouts, as well as the corrections needed in the plan to avoid them.
  • Capability to replace ForecastPro functionality with Streamline and integrate Demand/Supply Planning in a single tool.
  • Ability to feed Streamline directly from other systems, in particular from the company’s ERP (SAP).

Do you want to test Streamline on your company’s data?

Get started with Streamline »

Now available for macOS and Windows.

Further Reading:

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.