{"uid":"cap_xBByQLvTZxYMdGun-sh7U","slug":"brainiac-inventory-excess-detection-fef92bc5","name":"BRAINIAC Inventory Excess Detection","description":"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.","url":"https://www.brainiac.software/api/v1/inventory-intelligence/excess-detect?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"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":{"type":"number","maximum":1000000000,"minimum":0},"sku":{"type":"string","maxLength":80},"supplierId":{"type":"string","maxLength":80},"leadTimeDays":{"type":"number","maximum":3650,"minimum":0}},"additionalProperties":false},"maxItems":200},"reviewDays":{"type":"number","maximum":365,"minimum":0},"historyDays":{"type":"integer","maximum":3650,"minimum":1},"forecastDays":{"type":"integer","maximum":365,"minimum":1},"serviceLevelZ":{"type":"number","maximum":5,"minimum":0},"excessDaysCover":{"type":"number","maximum":3650,"minimum":1}}},"responseSchema":{"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}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.04","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.04/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.04","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.04","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_yknlS8WCULrvbLA9-L_nD","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.04","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Analyzes inventory levels against sales history and supplier data to identify SKUs with excess stock beyond a configurable days-cover threshold","exampleAgentPrompt":"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.","exampleUseCases":[{"title":"Pre-season clearance planning","prompt":"Before we bring in spring stock, check which of our winter products are overstocked — I'll share the product list with on-hand counts and 6 months of sales data. Use a 45-day cover threshold and flag anything with more than 10 excess units so we know what to put on clearance."},{"title":"Warehouse capacity audit","prompt":"Our warehouse is getting full and I need to know which SKUs are sitting on too much stock. Here's our inventory CSV with on-hand units, supplier lead times, and 60 days of weekly sales — flag any item with over 30 days of cover and tell me how many units are excess so I can plan transfers."},{"title":"Monthly inventory health report","prompt":"Run a monthly excess inventory check on our product catalog — I have 90 days of sales history and current on-hand counts for 150 SKUs. Use a 60-day cover threshold and a slow-moving flag for items selling fewer than 5 units over 90 days, and give me a full breakdown with reasons for each flagged SKU."}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-12T12:34:20.057Z","isFirstParty":false,"canonicalSlug":"brainiac-inventory-excess-detection-fef92bc5"}