Announcing o11's backing from Y Combinator.
AI Supply Chain Tracking in Google Sheets
Supply chain operations run on spreadsheets. Not because supply chain managers love spreadsheets, but because no ERP or WMS covers every edge case. The vendor who emails delivery updates in a PDF that someone manually enters into a tracker. The warehouse that reports stock levels in a format that does not match your system. The freight forwarder whose shipment status lives in a shared Google Sheet because their portal is unreliable.
The result is a network of interconnected spreadsheets that represent the real state of your supply chain more accurately than any single system. Inventory levels in one tab, purchase orders in another, vendor scorecards in a third, shipment tracking in a fourth. Each one is maintained by a different person, updated at a different cadence, and formatted in a different way.
Getting a unified view of supply chain health from these spreadsheets is a full-time job. Identifying exceptions, the late shipment, the vendor whose quality is slipping, the SKU that is three days from stocking out, requires cross-referencing multiple tabs and applying business logic that lives in someone’s head rather than in a formula.
o11 For Google Sheets reads across your supply chain workbooks and applies that business logic on demand.
Inventory Reorder Point Analysis From Stock Level Data
The difference between a smooth-running supply chain and one that lurches from stockout to emergency order often comes down to reorder point accuracy. In theory, every SKU has a reorder point based on average daily demand, supplier lead time, and a safety stock buffer. In practice, most teams calculate these once, enter them into a spreadsheet, and rarely update them because the recalculation is tedious.
o11 recalculates reorder points dynamically using your actual consumption data and current lead times.
“Using the Stock Levels tab and the Consumption History tab, recalculate the reorder point for every SKU. Use the average daily consumption over the last 90 days, the lead time from the Vendor Master tab, and a 14-day safety stock buffer. Flag any SKU where current stock is below the new reorder point.”
This analysis joins three separate data sources, something that in a manual workflow means building multi-sheet lookup formulas and maintaining them as vendors change or new SKUs are added. o11 handles the cross-referencing natively and delivers a prioritized action list.
The dynamic recalculation also catches problems that static reorder points miss.
“Identify SKUs where the 30-day average consumption has increased more than 25% compared to the 90-day average. These are trending up and may need reorder point adjustments. Show current stock, current reorder point, and recommended new reorder point.”
Demand shifts happen constantly. A product gets featured by an influencer, a competitor stocks out and your sales spike, a seasonal trend starts earlier than expected. Without dynamic reorder point analysis, these shifts result in stockouts before anyone notices the trend.
Vendor Performance Scorecards From Delivery Metrics
Managing vendors by gut feel works until it does not. Most supply chain teams have the data to build proper vendor scorecards, delivery dates versus promised dates, quality rejection rates, invoice accuracy, but assembling that data into a usable scorecard from raw delivery records is a manual reporting exercise that gets deprioritized.
o11 builds vendor scorecards from your existing tracking data.
“Using the Delivery Log tab, calculate on-time delivery rate for each vendor over the last 6 months. Define on-time as delivery within 2 days of the promised date. Cross-reference with the Quality tab to add defect rates. Rank vendors by a composite score: 60% on-time delivery, 25% quality, 15% invoice accuracy from the AP tab.”
This scorecard pulls from three different tabs, applies a weighted scoring model, and produces a ranked vendor list. In a manual workflow, building this report for 30 vendors takes a full day. With o11, the scorecard updates whenever you need it.
The scorecard also supports vendor review conversations with concrete data.
“For our bottom 3 vendors by composite score, show the trend over the last 6 months. Is performance improving or declining? List specific late deliveries and quality incidents.”
Walking into a vendor review with a trend analysis and specific incidents documented changes the conversation. Instead of vague complaints about “late deliveries,” you have dates, PO numbers, and measurable performance against agreed SLAs.
Shipment Exception Tracking and Escalation
In any supply chain with more than a handful of active shipments, exceptions are the norm rather than the exception. Delayed departures, customs holds, missed connections, partial deliveries. The tracking spreadsheet captures these events, but identifying which exceptions need immediate attention versus which will resolve themselves requires scanning hundreds of rows and applying judgment about severity and impact.
o11 applies exception logic to your tracking data and surfaces the items that need action.
“Scan the Shipment Tracker tab. Flag shipments that are more than 3 days past their estimated arrival date. For flagged shipments, check if the contained SKUs appear on the Critical Items list in the Reorder tab. Categorize exceptions as Critical (contains critical SKU), High (value over $50K), or Standard.”
This tiered alerting means your team focuses on the exceptions that matter most. A delayed shipment containing a critical SKU that is approaching stockout gets treated differently than a delayed shipment of a well-stocked commodity item.
For escalation, o11 connects the analysis to action.
“For all Critical exceptions, create a summary table with the vendor name, PO number, days late, affected SKUs, and current stock coverage in days. Sort by lowest stock coverage first.”
That summary table is your escalation brief. It tells you exactly which vendor to call first and what the business impact is if the shipment does not arrive soon. Building this view manually from a shipment tracker with 200 active rows and cross-referencing it against inventory levels is a 30-minute exercise that should happen daily but usually happens weekly because of the effort involved.
Before and After: Weekly Supply Chain Operations
Before o11:
- Reorder points calculated once per quarter, using outdated demand averages
- Vendor scorecards built manually once per year for annual reviews
- Shipment exceptions identified by scanning tracker rows one at a time
- Cross-referencing inventory impact of late shipments done manually
- Exception escalation based on whoever notices the problem first
- Monthly supply chain review deck assembled manually from multiple spreadsheets
After o11:
- Reorder points recalculated dynamically based on actual consumption trends
- Vendor scorecards available on demand with composite scoring and trend data
- Shipment exceptions automatically flagged and categorized by business impact
- Inventory impact of exceptions assessed instantly with stock coverage data
- Escalation priorities clear: Critical items surfaced with days-of-coverage context
- Review presentations flow directly from Sheets analysis into Google Slides
Why o11 Instead of a Standalone Supply Chain Platform
Dedicated supply chain platforms like Kinaxis, o9 Solutions, or Blue Yonder are powerful, but they cost six or seven figures, take months to implement, and require your data to flow through their systems. For mid-market companies or teams managing specific supply chain functions, the ROI calculation often does not justify the investment. The spreadsheet remains the tool of choice because it is available now and adapts to your specific workflow without a consulting engagement.
o11 does not replace your ERP or WMS. It makes the spreadsheet layer, where your supply chain team actually makes decisions, significantly more capable. It reads across the tabs and workbooks your team already maintains, applies the analytical logic that would otherwise require manual formula construction, and connects the results to Google Slides and Docs for stakeholder communication.
The data stays in your Google Workspace. The analysis happens where the decisions happen. And the operational intelligence that used to require a half-day of spreadsheet work becomes available in minutes.
