Inventory Planning Blog
Investing in smart solutions that improve your inventory planning is an important business decision and necessary in today’s global and troubled economy. Sometimes the concept of spending money to save money is very hard to accept. There are no guarantees the investment will pay off, so there is some level of risk involved. But, is it any riskier to do nothing? To maintain the status quo?
The basic purpose of Material Requirements Planning (MRP) is determining how much of which products needs to be either manufactured or purchased based on it being a component or ingredient of another item. MRP also determines when the product is required. Every item can have either Independent Demand or Dependent Demand.
Comparison to Spreadsheets
Spreadsheets are manual, time consuming. They do not provide intelligent part mix management and part specific forecasts. In addition, spreadsheets are extremely difficult to update and maintain current data effectively, plus they normally cannot be interfaced directly with enterprise and customer relationship software. Conducting quality assurance on the calculations and models is also difficult and based on a study by a leading international consulting firms over 90% of spreadsheets they audited contained significant errors. These errors led to the loss of millions of dollars.
Comparison with Standard Inventory Management other or Control Systems
Almost every inventory solution is a transaction (accounting) type system. This means they keep track of the physical movement of items on and off the shelf. These are “dumb” systems, meaning they are static and cannot intelligently determine what to stock, project demand, or create a complete replenishment plan. These systems are based on 40 year old plus, methods using ABC as the only part classification technique. They do not have leading-edge Exception Management capabilities which provide "alerts" to the User for unusually occurrences.
What Inventory Management Software can do:
• keep basic part information like: part number, description, cost, dimensions, etc.
• track parts movement: received, on order, on shelf, removed from the shelf, etc.
• provide a basic reorder point and min/max settings
• record the different bin locations where parts are stored
• provide an order for new parts needed, using standard reorder point, min/max, and safety stock
What Inventory Management Software cannot do:
• provide a system generated forecast or offer multiple advanced forecasting methods
• manage repair parts and their repair cycle (reverse logistics)
• provide an optimal inventory mix to improve service level while reducing cost
• offer multiple stocking and reordering policies
• manage parts specifically required for PM (preventative maintenance) schedules
• help to reduce overstock and excess part inventory
• manage by exception and provide key user alerts.
What Advanced Inventory Planning Solutions CAN DO:
• forecast parts demand with multiple models appropriate for different demand patterns
• plan for unlimited part and location combinations (scalable)
• provide advanced calculations for calculating shelf stock and reorder points
• calculate the optimal mix based on dynamic demand changes
• provide time phased plans and order for both new and repair items
• manage by exception and provide alerts to the planner
• identify overstock and excess inventory and provide redeployment strategies
• plan parts for preventative maintenance schedules
• multi-echelon or theatre planning - can plan at every stocking level both real and virtual
(from master warehouse to stock kept with a field or service engineer)
• plan part life cycle, substitutes and supercedes, and end-of-life parts
Combining Transaction Systems + Advanced Planning Solutions
Advanced planning solutions do not replace the existing transaction systems. Instead, they are designed to complement and improve existing software. The best of all worlds is to add an advanced planning solution to an existing transaction system. This provides a more complete, robust system that dynamically plans based on what is happening now and projected for the future. Download our free whitepaper to find out more!
Multi-location planning adds complexity.
Service Parts Planning Concepts
Service or spare parts inventory management is a prime candidate for advanced inventory planning, i.e. service management software. With many parts to manage and a lack of power tools, most companies with parts inventories have too many of the wrong parts. The result is unnecessary inventory expense, while still suffering service-limiting stock-outs.
The Business Problem
Until recently, Small and Mid-size Enterprises (SME) did not have affordable, easy to use software tools to help them effectively manage and balance their inventory investment. Software solutions that forecast, plan and optimize an inventory are found in widespread acceptance in large enterprise companies but these solutions can cost between hundreds of thousands of dollars to millions and are generally not affordable by SMEs.
In most cases, spreadsheets are the common tool in use! They are time-consuming to build and maintain, are usually static data repositories, and according to a study by a major consulting firm over 90% of them contain significant errors.
For organizations that carry an inventory, like manufacturers, wholesalers and retailers, that investment is often their largest asset. The cost of carrying excess and obsolete stock, as well as not having sufficient saleable inventory to meet demand is enormously high. It is common to find excess and obsolete stock representing 30% - 60% of inventory and to find that 5% - 40% of the time, customer demand cannot be met. The latter often results in expediting vendor orders at a premium cost that cannot be passed through (based on Valogix’s research and experience).
Maximize Your Profits and Competitive Advantage at the Same Time
Congratulations! You have survived another challenging year. In some cases you survived by holding off investing in much needed hardware and software. Now may be the time to surpass surviving and start thriving again.
Why it pays to invest in inventory solutions
There are many reasons or excuses for not upgrading to a modern, easy to use advanced inventory tool. Which Category do you fall in?
Discover an affordable, seamlessly integrated inventory planning optimization solution to SAP Business One for small and midsize businesses. A solution that frees up your resources (including cash), reduces losses from obsolescence, and increases service levels. The tools you need to forecast, plan, and optimize inventory, manage your business more efficiently and meet the demands of customers and suppliers are powerful and affordable.
Tags: Inventory Planning, SAP, SAP Business One, inventory optimization, Forecasting Inventory, advanced inventory planning solutions, cloud computing, Demand Planning, replenishment planning, Wholesale Distribution, Supply Chain, Partner Awards, Valogix, inventory management
Did you know that certain inventory planning solutions are easier to use than ever? Until recently Small and Mid-size Businesses (SMB) did not have affordable, easy to use software tools to help them effectively manage and balance their inventory investment. Software solutions that forecast, plan and optimize an inventory are found in widespread acceptance in large enterprise companies but these solutions can cost between hundreds of thousands to millions of dollars, take months to implement and are generally not affordable or usable by SMBs.
Tags: Inventory Planning, SAP, inventory optimization, Forecasting Inventory, optimization, cloud computing, NetSuite, Demand Planning, replenishment planning, Wholesale Distribution, Supply Chain, inventory management
In our final installment of our series on The State of Inventory Planning, we explore the results of inventory planning and optimization solutions. Companies that implement these solutions often find the results surprising. Many thought their old Excel spreadsheets were doing a fine job, only to discover a whole new world of information at their fingertips, allowing them to make informed decisions that really do affect the bottom line!
In our fourth installment in our series, we explore ways to improve replenishment planning.