omni_open_to_buy_otb_budget
Calculate monthly Open-to-Buy retail and wholesale purchasing budgets from planned sales, markdowns, inventory, and open orders to prevent over-buying and meet sales targets.
Instructions
Open-to-Buy (OTB) Retail Inventory Budget Calculator. Calculate exact monthly retail Open-to-Buy (OTB) purchasing budgets at retail and wholesale cost to prevent over-buying while meeting seasonal sales targets. Discipline: ECOMMERCE. Governing mathematical model / formula: OTB (Retail) = Planned Sales + Planned Markdowns + Planned End Inventory - Beginning Inventory - On Order.
USAGE GUIDELINES:
WHEN TO USE: Invoke for deterministic calculation of otb_retail_budget (Open-to-Buy Budget (Retail)), otb_cost_budget (Open-to-Buy Budget (Wholesale Cost)), total_inventory_demand (Total Monthly Merchandise Demand), purchasing_status (Merchandise Buying Status) using planned_monthly_sales (Planned Monthly Retail Sales in $), planned_monthly_markdowns (Planned Promotional Markdowns in $), planned_end_of_month_inventory (Target End-of-Month (EOM) Inventory in $), beginning_inventory_on_hand (Beginning Inventory (BOM) on Hand in $), outstanding_purchase_orders (Inventory Currently on Order in $), target_markup_pct (Average Initial Markup (IMU %) in %). Guarantees exact machine floating-point precision, eliminating LLM arithmetic mistakes and formula hallucinations.
WHEN NOT TO USE: Do not use for qualitative evaluations or unquantified reasoning. All input parameters must be valid numerical values.
DISAMBIGUATION & BOUNDARIES:
Use this dedicated specialist tool for 'Open-to-Buy (OTB) Retail Inventory Budget Calculator' rather than generic dispatchers like omni_universal_query.
For multi-calculation chained jobs, use 'omni_batch_calculate'.
To inspect schema fields, see 'omni_describe_solver'.
BEHAVIOR & SAFETY:
Pure deterministic computation with machine floating-point precision.
Read-only, idempotent, and stateless. Zero side effects or persistent state mutations.
Input validation: All arguments are validated against physical and domain bounds. Out-of-bounds inputs return a safe diagnostic error status without throwing runtime exceptions.
RETURNS:
Structured JSON object containing:
status (string): "success" on valid execution or "error" if validation fails
calculator (string): "open-to-buy-otb-budget"
category (string): "ecommerce"
name (string): "Open-to-Buy (OTB) Retail Inventory Budget Calculator"
formula (string): Governing mathematical formula string
inputs (object): Echoed input parameter dictionary with applied defaults
metrics (object): Dictionary of computed outputs:
metrics.otb_retail_budget (Open-to-Buy Budget (Retail)): Formatted display string (e.g. '$213,000')
metrics.otb_cost_budget (Open-to-Buy Budget (Wholesale Cost)): Formatted display string (e.g. '$95,850')
metrics.total_inventory_demand (Total Monthly Merchandise Demand): Formatted display string (e.g. '$688,000')
metrics.purchasing_status (Merchandise Buying Status): Formatted display string (e.g. 'Open Budget Available')
execution_time_ms (number): Latency in milliseconds.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "omni_open_to_buy_otb_budget"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| target_markup_pct | No | Average Initial Markup (IMU %) (%). Standard markup percentage applied to wholesale cost. Default: 55. Min: 20. Max: 85. | |
| planned_monthly_sales | No | Planned Monthly Retail Sales ($). Forecasted sales revenue for the month. Default: 250000. Min: 10000. Max: 10000000. | |
| planned_monthly_markdowns | No | Planned Promotional Markdowns ($). Planned price discounts and promotional allowances. Default: 18000. Min: 0. Max: 1000000. | |
| beginning_inventory_on_hand | No | Beginning Inventory (BOM) on Hand ($). Actual on-hand inventory valuation at retail at month start. Default: 380000. Min: 20000. Max: 20000000. | |
| outstanding_purchase_orders | No | Inventory Currently on Order ($). Committed POs already placed with vendors arriving this month. Default: 95000. Min: 0. Max: 5000000. | |
| planned_end_of_month_inventory | No | Target End-of-Month (EOM) Inventory ($). Stock required at month end to support following month sales. Default: 420000. Min: 20000. Max: 20000000. |