# Days of Supply Calculator MCP > Days of Supply Calculator analyzes your entire stockroom's health in one place. It instantly tells you if specific items are running low, how much cash is tied up in excess inventory, and which product groups need attention. Stop guessing about risk—get calculated coverage metrics for every SKU. ## Overview - **Category:** inventory-management - **Price:** Free - **Tags:** inventory, stockout, overstock, supply-chain, sku-analysis ## Description Inventory planning used to mean juggling five different systems: the sales dashboard, the warehouse management tool, the financial ledger, and three separate spreadsheets just to get a single picture of health. Now, you don't have to do that anymore. This MCP gives your agent the visibility needed to manage risk across your entire product catalog. Instead of manually checking every category performance chart or running separate reports for overstock versus understock, this tool aggregates all that data into immediate, actionable insights. You can immediately check a single item's precise supply duration, review overall group health, and calculate the true financial cost of carrying too much stock. It’s like having a full-time inventory auditor on call, accessible through Vinkius, letting you make decisions based on hard math, not gut feelings. ## Tools ### get_category_health_summary Provides an aggregated performance view of inventory health for a specified group of items. ### calculate_financial_exposure_by_tier Calculates the total monetary value of inventory based on different coverage levels (e.g., overstock, critical). ### get_sku_supply_metrics Calculates the specific supply duration and risk status for a single product number (SKU). ## Prompt Examples **Prompt:** ``` Check the supply metrics for SKU 'S123' with 50 units in stock and a daily demand of 5. ``` **Response:** ``` The `get_sku_supply_metrics` tool shows that SKU 'S123' has 10 days of supply, which is considered a stable level. ``` **Prompt:** ``` Calculate the financial exposure for my inventory list. ``` **Response:** ``` The `calculate_financial_exposure_by_tier` tool has processed your items and identified the total value in critical, stable, and excess tiers. ``` **Prompt:** ``` Summarize the health of category 'Electronics'. ``` **Response:** ``` Using `get_category_health_summary`, the Electronics category shows 5 items at risk of stockout and 2 items in overstock. ``` ## Capabilities ### Assess single item risk Calculate the exact number of days an individual product can sell before running out. ### Get group performance view View aggregated inventory health metrics across a defined group or category of products. ### Quantify financial risk Determine the total monetary value of your stock that is considered overstocked, stable, or critical. ## Use Cases ### A buyer needs to know which products to pull from the next shipment. The buyer asks their agent, 'Which 10 SKUs are most at risk of stockout?' The agent runs `get_sku_supply_metrics` on a list of candidates and returns only those items with low days of supply, prioritizing immediate action. ### The CFO needs to know the cash impact of slow-moving goods. Instead of reviewing general sales reports, the agent runs `calculate_financial_exposure_by_tier`. The result immediately shows the total dollar amount tied up in overstock inventory that needs clearance. ### The Category Manager needs a quick status check on an entire department. They prompt, 'Summarize the health of our Accessories category.' The agent uses `get_category_health_summary` and reports back: 8 items are at risk, 4 are overstocked. ### The Operations Manager needs to adjust staffing based on potential supply chain issues. They ask the system to analyze inventory for three major product lines. The combined view from `get_category_health_summary` shows a critical dip in certain groups, allowing them to preemptively shift labor. ## Benefits - Stop guessing about cash flow. By using `calculate_financial_exposure_by_tier`, you instantly know the dollar value trapped in overstock, allowing finance to make better capital decisions. - Never panic about a single SKU again. The `get_sku_supply_metrics` tool calculates precise supply duration and flags risk status for every product number you check. - Skip dashboard hopping. If you need an overview of how 'Electronics' or 'Apparel' are doing, `get_category_health_summary` gives a single health report instead of dozens of individual metrics. - Speed up planning cycles. Instead of pulling data from four different sheets, running these tools gives you the necessary inventory status in seconds. - Improve purchasing decisions. Seeing category-wide performance via `get_category_health_summary` helps buyers balance risk across multiple product lines simultaneously. ## How It Works The bottom line is you get a single source of truth about physical stock levels and financial risk simultaneously. 1. Start by defining what you need to analyze: a single product number, an entire category group, or a financial risk assessment. 2. Your agent calls the appropriate tool using your inventory data and current demand figures. 3. You get back concrete metrics, including remaining days of supply for specific items or total dollar values tied up in excess stock. ## Frequently Asked Questions **How do I use get_sku_supply_metrics to check one item?** You provide the agent with a specific SKU number. The tool returns how many days that single product can sell at current demand rates, giving you immediate risk status. **What does calculate_financial_exposure_by_tier tell me?** It calculates the total cash value of your entire stock and breaks it down into tiers: how much is overstocked, stable, or at critical levels. This helps finance know where to cut losses. **Is get_category_health_summary better than looking at individual SKUs?** It's better for high-level planning. While `get_sku_supply_metrics` gives depth on one item, this tool aggregates that data to show systemic problems across a whole group of items. **Can I combine get_category_health_summary and calculate_financial_exposure_by_tier?** Yes. You can first use the summary function to identify an area of concern, and then feed that category data into the financial exposure tool for a deeper monetary dive. **If I run `get_sku_supply_metrics` with an incorrect SKU, what response should I expect?** The tool sends a clear validation error. It specifies exactly which part of the input data failed, helping you pinpoint and fix your feed issues quickly without manual checks. **For `calculate_financial_exposure_by_tier`, does it require specific cost basis information for inventory items?** Yes. The financial exposure calculation needs an associated unit cost or current market value. You must include this monetary metric in your input data to get accurate total values. **What are the performance limitations when running `get_category_health_summary` on massive item groups?** The tool handles thousands of items, but extremely large categories might require batch processing. We recommend dividing massive lists into smaller segments for optimal speed and reliability. **What is the proper format for providing daily demand when I use `get_sku_supply_metrics`?** Daily demand must be provided as a single, positive numerical value. If your source data varies in format, make sure it's standardized to an integer or float number before running the tool. **What is the purpose of this MCP?** It calculates how many days your current stock will last based on daily demand, helping you prevent stockouts and reduce overstock. **How does it identify stockout risks?** The tool flags any item where the calculated supply duration is less than 7 days as a critical risk. **Can I analyze financial impact?** Yes, using `calculate_financial_exposure_by_tier`, you can see the monetary value of inventory held in different coverage tiers.