Azure DevOps Demo Models · main

inventory_reorder.py

manufacturing/inventory-reorder-optimization/src/inventory_reorder.py · 498 bytes · read-only public source view

from __future__ import annotations
import math

annual_demand=85000
order_cost=240
unit_cost=18.75
holding_rate=0.22
lead_time_days=18
daily_std_dev=42
z=1.645
holding_cost=unit_cost*holding_rate
eoq=math.sqrt(2*annual_demand*order_cost/holding_cost)
safety_stock=z*daily_std_dev*math.sqrt(lead_time_days)
reorder_point=(annual_demand/365)*lead_time_days+safety_stock
print(f'economic_order_quantity={eoq:.2f}')
print(f'safety_stock={safety_stock:.2f}')
print(f'reorder_point={reorder_point:.2f}')