Inventory Modeling Spreadsheet Calculations

The system uses the following calculations when modeling inventory on the Inventory Modeling spreadsheet. Columns not in this list do not have a calculation applied to them.

Column

Formula / Calculation

Grand Total Inventory Model

Grand Total Inventory Model (w overrides)

Same as above calculation except any product with a quantity loaded in the Minimum Qty field is used instead of the calculated value.

Total Cost (w overrides)

Sum of all values in Total Cost (accounting for overrides) columns. This value results from adding all values in the AC column, from AC7 to the final row.

Inventory Budget

Current Budget Remaining

Total On-Hand

On-Hand$

Calc'd cost

Inv$ Diff

PIL$

Safe Days

Safety days for inventory modeling are determined based on lead time:

If the Lead Time is...	The base Lead Time Safety Days calculation is...
less than 15 days
greater than 15 but less than 60 days
greater than 60 days

Lead Time

The system does not have a single lead time calculation. For a full description, see How the System Calculates Lead Time in the purchasing documentation.

Demand Per Day

Monthly Hits