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.

Over the WEEKS_OF_ANALYSIS weeks your average inventory needs are TARGET_AVERAGE_INVENTORY units.

Over the next WEEKS_OF_ANALYSIS weeks your average inventory needs are TARGET_AVERAGE_INVENTORY units. Your minimum inventory at any time during this period is projected at MINIMUM_INVENTORY units and your maximum inventory is MAXIMUM_INVENTORY units. This assumes an EXPECTED_ANNUAL_GROWTH annual growth rate with an initial demand for your product at CURRENT_DEMAND_PER_WEEK per week. **GRAPH**
Results for next WEEKS_OF_ANALYSIS weeks
Average inventory TARGET_AVERAGE_INVENTORY units
Maximum inventory MAXIMUM_INVENTORY units
Minimum inventory MINIMUM_INVENTORY units
Inventory ordered TOTAL_INVENTORY_ORDERED units
Number of orders TOTAL_NUMBER_OF_ORDERS
Starting safety stock STARTING_SAFETY_STOCK units
Ending safety stock ENDING_SAFETY_STOCK units
Input Summary
Starting inventory STARTING_INVENTORY
Ending inventory ENDING_INVENTORY
Initial demand per week CURRENT_DEMAND_PER_WEEK
Annual growth rate EXPECTED_ANNUAL_GROWTH
Order lead time in weeks ORDER_LEAD_TIME_IN_WEEKS
Safety stock percent SAFETY_STOCK

Inventory balances for WEEKS_OF_ANALYSIS weeks

**REPEATING GROUP**

Inventory Analysis 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.


The Best Financial Calculators Anywhere!

Put them on your website!

© 1998-2014 KJE Computer Solutions, LLC
Financial Calculators at http://www.dinkytown.net
(612) 331-2291
1730 New Brighton Blvd. PMB #111
Minneapolis, MN 55413