Calculate Inventory Level: Determine stock levels based on demand, reorder points, and lead times. Plan orders efficiently for optimal inventory management.

Calculate Inventory Level

Purpose

The Calculate Inventory Level function helps you determine the optimal inventory level based on your demand, current stock, reorder point, reorder quantity, lead time, time horizon, and frequency of calculation.

Use Cases

• Planning inventory levels to meet demand
• Optimizing stock levels to reduce stockouts and excess inventory

How to Use

1. Enter the required input values in the respective fields.
2. Click on the "Calculate" button to generate the inventory level results.

Input Values

1. Demand - The quantity of items needed per year (default unit is unit/yr)
2. Current Stock - The current quantity of items in stock
3. Reorder Point - The minimum quantity of items that triggers a reorder
4. Reorder Quantity - The quantity of items ordered when stock reaches the reorder point
5. Lead Time - The time it takes for an order to be delivered (default unit is days)
6. Time Horizon - The planning period for inventory calculation (default unit is years)
7. Calculate Every - The frequency at which inventory level should be recalculated (default unit is weeks)

Output Values

1. Return Value - A chart showing the inventory level over the specified time horizon with key indicators such as current stock, order placed, goods received, reorder point, and stock promised.

Any other Instruction

• Ensure to input accurate values for demand, current stock, reorder point, reorder quantity, lead time, time horizon, and frequency of calculation for optimal results.

Steps of Calculation

1. Determine the demand, current stock, reorder point, reorder quantity, lead time, time horizon, and calculation frequency.
2. Calculate the inventory level based on the provided inputs and generate a chart showing the stock status over the specified time period.

Technical Parameters

demand, current_stock, reorder_point, reorder_quantity, lead_time, time_horizon, calculate_every, chart_columns, chart_units, show

Return Values

results

Example Expressions

You can use the following expressions to directly evaluate in a non-interactive manner using eval():

invlevel(demand='1500.0 unit/yr', current_stock='200.0 unit', reorder_point='100.0 unit', reorder_quantity='300.0 unit', lead_time='20.0 d', time_horizon='2.0 yr', calculate_every='2.0 wk')
invlevel(demand='1000.0 unit/yr', current_stock='300.0 unit', reorder_point='50.0 unit', reorder_quantity='200.0 unit', lead_time='15.0 d', time_horizon='3.0 yr', calculate_every='1.0 wk')

Click on Help icon to open the help page on a separate window.