Lone Star Kettle Co. — Supplier Risk Dashboard

Why orders get missed · Potato supply reliability · H1 2025 (Jan–Jul)
4 suppliers · 104 delivery days · 501 customer orders

⚠️ Risk Alerts — what threatens the next miss

🚨 Live Miss-Risk Alert — check this week before it ships

Enter the load counts from the Monday-night Valley confirmations (Rio Grande Farms + Valley Fresh email you their truck counts the day before Tuesday delivery). This tool predicts whether customer orders are about to be shorted — and what to do about it — before the miss happens.

Rio Grande Valley · Tuesday
Panhandle region · backup capacity
Rule of thumb from H1 data: any Valley truck under ~85% of ordered cases has historically led to shorted customers within 1–3 days. 1 potato case ≈ 50 lb; the tool converts automatically.

📋 Supplier Scorecard

SupplierRegion / DayGrade Fill rateShort days ConsistencyWorst dayLbs short
Grade blends fill rate, share of short delivery days, and week-to-week consistency (volatility). Fill rate = potatoes actually received vs ordered, same-day (JIT = no buffer to wait for a backorder).

🔗 The real pattern: regional risk, not one bad supplier

When a Rio Grande Valley supplier falls short, orders get missed

Each bar = a week. Orange line = customer order misses that week. Misses spike exactly when the Rio Grande Valley suppliers (Rio Grande Farms + Valley Fresh, both Tuesday) drop together.

Miss rate by supply condition

The founder's hunch was "one weak supplier." The data says it's a correlated regional shortfall: both Valley suppliers share the same growing region and the same delivery day, so they fail together — with zero buffer to absorb it.

Misses by day of week

Tuesday (Valley delivery day) and the days right after carry nearly all the misses. Monday — before the Valley trucks — is clean.

Where the pain lands — cases lost by flavor

Shortfalls hit specific SKUs hardest, so a single Valley miss shorts multiple customers on the same flavors.

🛠️ What to fix — prioritized

🔍 Supplier detail — inspect the raw record

Supplier:
DateOrdered (lbs)Received (lbs)Same-day fillNotes