Skip to main content
Glama
omnioperand-mcp

omnioperand-mcp

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

NameRequiredDescriptionDefault
target_markup_pctNoAverage Initial Markup (IMU %) (%). Standard markup percentage applied to wholesale cost. Default: 55. Min: 20. Max: 85.
planned_monthly_salesNoPlanned Monthly Retail Sales ($). Forecasted sales revenue for the month. Default: 250000. Min: 10000. Max: 10000000.
planned_monthly_markdownsNoPlanned Promotional Markdowns ($). Planned price discounts and promotional allowances. Default: 18000. Min: 0. Max: 1000000.
beginning_inventory_on_handNoBeginning Inventory (BOM) on Hand ($). Actual on-hand inventory valuation at retail at month start. Default: 380000. Min: 20000. Max: 20000000.
outstanding_purchase_ordersNoInventory Currently on Order ($). Committed POs already placed with vendors arriving this month. Default: 95000. Min: 0. Max: 5000000.
planned_end_of_month_inventoryNoTarget End-of-Month (EOM) Inventory ($). Stock required at month end to support following month sales. Default: 420000. Min: 20000. Max: 20000000.

Schema Changelog

Changes observed during successful MCP inspections.

  1. Addedv0.1.2

TDQS

Score is being calculated.

Deploy Server

Other Tools