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.

var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-8359999-9']); _gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); })();

Inventory Analysis

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.

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**

"> This Financial Calculator requires a Browser with Java™ applet Support. If you are seeing this message you will need to download SUN's Java™ Plug-in. This can be done simply, and automatically, by clicking the link below:

Get the Java™ Plug-in!

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.