# BRAINIAC Inventory Excess Detection

> BRAINIAC Inventory Excess Detection is a paid API for AI agents from www.brainiac.software, paid per call via x402, $0.04/call, status unknown (last checked 2026-11-12).

Analyzes inventory levels against sales history and supplier data to identify SKUs with excess stock beyond a configurable days-cover threshold

## Facts

- Endpoint: POST https://www.brainiac.software/api/v1/inventory-intelligence/excess-detect?utm_source=zero.xyz
- Price: $0.04/call
- Payment: x402
- Status: unknown
- Last checked: 2026-11-12
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/brainiac-inventory-excess-detection-fef92bc5
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_xBByQLvTZxYMdGun-sh7U

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability brainiac-inventory-excess-detection-fef92bc5 -d '<json body>'
```

Example prompt: Can you check our inventory for excess stock? I'll give you our product list with on-hand quantities and 90 days of sales history — flag any SKU with more than 30 days of cover and tell me how many excess units each one has.

## When to prefer this

Use this endpoint when you need a transparent, auditable excess inventory calculation grounded strictly in supplied data — no hallucinated lead times, invented demand, or external system access. Ideal when you want explicit assumptions and limitations returned alongside results, and when you need per-SKU reasoning codes (days_cover_over_threshold, within_threshold) for downstream decision-making. Prefer this over general-purpose LLM analysis when auditability and deterministic rules (reorder point, safety stock formula) matter.

## Known failure modes

- Missing or empty products/sales arrays returns no meaningful analysis
- SKUs with no sales history default to zero demand, potentially flagging all stock as excess
- Missing supplier lead times trigger a 'lead_time missing' finding and are excluded from safety stock calculation
- Malformed dates in sales or purchase records may cause incorrect history window calculations
- Exceeding maxItems limits (200 products, 2000 sales, 500 purchases) will truncate input data
- CSV or JSON text input that cannot be parsed may result in empty analysis

## How this service works

Pay-per-call APIs for AI agents: OFAC sanctions screening, compliance checks, token security, and Base chain data via x402. No account. Fixed USDC price. MCP-ready.

## Output

Returns a list of items with excess flag (true/false), on-hand quantity, days of cover, excess units, average daily demand, and reason code per SKU; plus a summary of excess count, assumptions made (service level, forecast days, history window), limitations, and audit flags confirming no data was invented and no purchase orders were created.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "csv": {
   "type": "string",
   "maxLength": 200000
  },
  "asOf": {
   "type": "string",
   "maxLength": 40
  },
  "file": {
   "type": "object",
   "required": [
    "mediaType",
    "fileBase64"
   ],
   "properties": {
    "filename": {
     "type": "string",
     "maxLength": 180,
     "minLength": 1
    },
    "mediaType": {
     "enum": [
      "text/plain",
      "text/csv",
      "application/json"
     ],
     "type": "string"
    },
    "fileBase64": {
     "type": "string",
     "maxLength": 12000000,
     "minLength": 1
    }
   },
   "additionalProperties": false
  },
  "json": {
   "type": "string",
   "maxLength": 200000
  },
  "text": {
   "type": "string",
   "maxLength": 200000
  },
  "sales": {
   "type": "array",
   "items": {
    "type": "object",
    "properties": {
     "sku": {
      "type": "string",
      "maxLength": 80
     },
     "date": {
      "type": "string",
      "maxLength": 40
     },
     "units": {
      "type": "number",
      "maximum": 1000000000,
      "minimum": 0
     }
    },
    "additionalProperties": false
   },
   "maxItems": 2000
  },
  "products": {
   "type": "array",
   "items": {
    "type": "object",
    "properties": {
     "sku": {
      "type": "string",
      "maxLength": 80
     },
     "name": {
      "type": "string",
      "maxLength": 160
     },
     "onHand": {
      "type": "number",
      "maximum": 1000000000,
      "minimum": 0
     },
     "onOrder": {
      "type": "number",
      "maximum": 1000000000,
      "minimum": 0
     },
     "unitCost": {
      "type": "number",
      "maximum": 1000000000,
      "minimum": 0
     }
    },
    "additionalProperties": false
   },
   "maxItems": 200
  },
  "slowDays": {
   "type": "number",
   "maximum": 3650,
   "minimum": 1
  },
  "purchases": {
   "type": "array",
   "items": {
    "type": "object",
    "properties": {
     "sku": {
      "type": "string",
      "maxLength": 80
     },
     "date": {
      "type": "string",
      "maxLength": 40
     },
     "units": {
      "type": "number",
      "maximum": 1000000000,
      "minimum": 0
     },
     "unitPrice": {
      "type": "number",
      "maximum": 1000000000,
      "minimum": 0
     }
    },
    "additionalProperties": false
   },
   "maxItems": 500
  },
  "slowUnits": {
   "type": "number",
   "maximum": 1000000000,
   "minimum": 0
  },
  "suppliers": {
   "type": "array",
   "items": {
    "type": "object",
    "properties": {
     "moq
… (truncated)
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "items": [
   {
    "sku": "SKU-1",
    "name": "Widget",
    "excess": true,
    "onHand": 500,
    "reason": "days_cover_over_threshold",
    "daysCover": 250,
    "excessUnits": 440,
    "thresholdDays": 30,
    "demandSupplied": true,
    "daysCoverSupplied": true,
    "averageDailyDemand": 2
   },
   {
    "sku": "SKU-2",
    "name": "Gadget",
    "excess": false,
    "onHand": 20,
    "reason": "within_threshold",
    "daysCover": 4,
    "excessUnits": 0,
    "thresholdDays": 30,
    "demandSupplied": true,
    "daysCoverSupplied": true,
    "averageDailyDemand": 5
   }
  ],
  "status": "detected",
  "findings": [
   {
    "code": "lead_time",
    "kind": "missing",
    "detail": "No supplier lead time was supplied for this SKU. Lead time was not invented.",
    "subject": "SKU-1"
   },
   {
    "code": "lead_time",
    "kind": "missing",
    "detail": "No supplier lead time was supplied for this SKU. Lead time was not invented.",
    "subject": "SKU-2"
   }
  ],
  "checkedAt": "2026-11-04T19:00:00.000Z",
  "assumptions": [
   "serviceLevelZ=1.65 (explicit normal z factor for safety stock)",
   "reviewDays=0",
   "historyDays=5",
   "forecastDays=30",
   "excessDaysCover=30",
   "slowUnits=5 over slowDays=90",
   "Daily demand average fills missing days in the history window with zero when a history end date exists.",
   "Seasonality is not added. Only variation already present in the supplied history affects the standard deviation."
  ],
  "excessCount": 1,
  "limitations": [
   "Products, sales, supplier lead times, and purchases are copied only from labeled fields supplied by the caller.",
   "Reorder point = average daily demand × (lead time days + review days) + safety stock.",
   "Safety stock = service-level z × daily demand standard deviation × square root of lead time days.",
   "Demand forecasts use a simple average of available history only. Seasonality is not modeled unless present in that history.",
   "Lead times, demand, and purchase prices are never invented. No purchase order is created and no inventory system is accessed."
  ],
  "priceInvented": false,
  "demandInvented": false,
  "excessDaysCover": 30,
  "leadTimeInvented": false,
  "purchaseOrderCreated": false,
  "inventorySystemAccessed": false
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/brainiac-inventory-excess-detection-fef92bc5/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from www.brainiac.software](https://www.zero.xyz/host/www.brainiac.software/llms.txt)
