X
GO

News

The Hidden costs of using spreadsheets to plan your inventory

The Hidden costs of using spreadsheets to plan your inventory

Article by the Inventory Mentor

The vast majority of businesses use spreadsheets to do all or part of their inventory forecasting, planning, and purchasing. Even large businesses with very expensive ERP systems resort to extracting and manipulating data in order to generate forecasts, compute inventory levels, recommend orders, and track outstanding deliveries.

Excel has become the “tool of choice” because anyone can build a spreadsheet, populate it with data, and get an answer. Most people have used Excel to varying degrees; they feel confident building calculations with complex formulas, and they can easily disseminate information via email or shared drives.

The selection of Excel for planning inventory is driven by:

  • Its ease of use and availability
  • The familiarity most of us have with Excel
  • The ability to create fairly complex calculations
  • The lack of functionality in your ERP system
  • The difficulty in using the functionality in your ERP system
  • An unwillingness to understand and use the functionality available

The risks

Whatever the reason(s) for your business selecting Excel as your “planning tool of choice”, there are some hidden costs associated with its use that you need to make sure you are aware of. These include:

  • The risk associated with having one master of the spreadsheet: one individual who builds, extends, customises and populates the spreadsheet
  • Ensuring accurate and consistent data drives the spreadsheet, to minimise the risk of expensive mistakes
  • A level of sophistication in the computations so that optimal inventory levels are used to drive purchasing, resulting in the highest level of service to customers with the lowest possible inventory value
  • Incorporating supply chain complexity, including central warehouse structures, bills of materials and supersessions

Email us on info@advancenet.com  for more information as to how AdvanceNet can assist you with your Inventory optimisation .

Previous Article Qlik named as Leader in the 2018 Gartner Magic Quadrant
Next Article 11 Benefits for implementing an ERP system
Print
314

x

Categories

«August 2018»
MonTueWedThuFriSatSun
303112345
6789101112
13141516171819
20212223242526
272829303112
3456789