MRO Stock Forecasting
Calculate optimal minimum and maximum inventory levels for your maintenance, repair, and operations stock
System Configuration
Select your ERP system for proper min/max calculations
Item Details
Brief description of the MRO item
Number of units issued each time (minimum issue quantity)
How often the item is typically issued
Enable for items with high daily consumption rates
= Issues per month × units per issue (Daily=30, Weekly=4, Fortnightly=2, Monthly=1)
Time from order to receipt
Cost per unit in dollars
Impact if item is out of stock
Cost Parameters
Cost to place and process one purchase order
Annual holding cost as percentage of unit price
Advanced Parameters
Automatically set based on criticality: Low/Medium=95%, High=97%, Critical=99%
Historical supplier performance
-
Minimum Stock
-
-
Maximum Stock
-
Safety Stock (Units)
-
Days of Coverage
Based on current usage rate
-
Order Quantity
-
Inventory Value
-
Annual Turnover
-
Months of Stock
Based on Maximum Stock Level
-
Annual Purchase Orders
-
Annual PO Cost
Expected orders & costs per year
Smart Recommendations
i
Current Calculation Parameters
ERP System Type:
-
Ordering Cost per Purchase Order:
$50
Annual Holding Cost Rate:
25% of unit price
Service Level Target:
95% (Auto-set by criticality)
EOQ Formula:
sqrt(2 * Annual Demand * Order Cost / Holding Cost)
ERP Logic:
-
? Calculation Commentary