Inventory modeling provides a way to future plan for your branch inventory budgets. This modeling process lets you test setup scenarios to see the effects on other areas before committing those changes to your system. The spreadsheet gives you access to key fields that you can adjust to forecast what your purchasing model should look like to maintain a specific budget by branch.
Use the Inventory Modeling tool to help answer the following types of questions:
What do I need to do to get my inventory to a specific number of turns?
What do I need to do to get my inventory if I want to keep to a specific order cycle?
The system uploads values of five specific fields from the Inventory Modeling spreadsheet program for a specific branch in your system. When you upload the value of these fields, you change this value for each product listed in the spreadsheet.
After extracting your purchasing and forecasting parameters from your Eclipse system, use it for modeling inventory settings. After setting up the model to support your particular budget, you can upload the key values back into your Eclipse system.
Before you begin, review the setup parameters required to use Inventory Modeling.
Note: If you do not have the inventory modeling program, all menu options related to inventory modeling will be grayed out.
Click here for a printable version of the Eclipse Inventory Modeling documentation.