Inventory Analysis

This calculator helps you determine how much inventory you should hold, and when you should place inventory orders. The calculation attempts to keep your inventory level as efficient as possible, while maintaining adequate safety stock.

This Financial Calculator requires SUN's Java™ Plug-in. If you see this message you will need to download SUN's Java™ Plug-in. This can be done automatically by clicking the yellow bar at the top of your browser and choosing “Install ActiveX Control”.

    You can also get SUN's Java™ Plug-in here: Get the Java™ Plug-in!

    For more information about this Plug-in please visit: SUN's Java™ Plug-in
    For more information about these financial calculators please visit: Financial Calculators from KJE Computer Solutions, LLC

Definitions

Initial demand per week
Your initial expected demand per week.

Annual growth rate
What you expect your annual sales growth to be over the next year.

Safety stock
Expressed as a percent of your sales, this is the level of inventory you require as safety stock. This stock is used to protect against out of stock situations.

Order lead time in weeks
How long it takes an order for more inventory to be received into inventory. This calculator assumes orders arrive in one batch with a known lead time, arriving just as stock is exhausted.

Starting inventory
Amount of inventory you currently have on hand.