calculate_order_need
Determine MRP order requirements by analyzing inventory, forecasts, and delivery schedules to optimize stock levels and meet demand accurately.
Instructions
Calculate MRP order need based on forecast, inventory, and delivery schedule
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| analysis_date | Yes | ||
| batch_sizes | No | ||
| current_balance | Yes | ||
| delivery_schedule | Yes | ||
| forecast_periods | Yes | ||
| must_order_point | Yes | ||
| open_orders | Yes | ||
| sku_location | Yes |
Input Schema (JSON Schema)
{
"properties": {
"analysis_date": {
"type": "string"
},
"batch_sizes": {
"items": {
"type": "number"
},
"type": "array"
},
"current_balance": {
"type": "number"
},
"delivery_schedule": {
"properties": {
"first_delivery": {
"type": "string"
},
"lead_time": {
"type": "number"
},
"second_delivery": {
"type": "string"
}
},
"type": "object"
},
"forecast_periods": {
"items": {
"properties": {
"end_date": {
"type": "string"
},
"quantity": {
"type": "number"
},
"start_date": {
"type": "string"
}
},
"type": "object"
},
"type": "array"
},
"must_order_point": {
"type": "number"
},
"open_orders": {
"items": {
"properties": {
"delivery_date": {
"type": "string"
},
"quantity": {
"type": "number"
}
},
"type": "object"
},
"type": "array"
},
"sku_location": {
"properties": {
"location": {
"type": "string"
},
"sku": {
"type": "string"
}
},
"required": [
"sku",
"location"
],
"type": "object"
}
},
"required": [
"sku_location",
"analysis_date",
"must_order_point",
"current_balance",
"open_orders",
"delivery_schedule",
"forecast_periods"
],
"type": "object"
}