Team 14

RainCheck Restock

A shopping agent that helps small coffee shops decide when to wait or buy emergency supplies as rainy-day demand and delivery estimates change—with supplier comparisons and an auditable purchase-order draft.

Check your own project

Community votes recognize the build and do not affect official judging.

Review the project

Start with the source code, then open the demo or video if available.

View GitHub repository
Project description
Rain can reduce a coffee shop’s demand while also delaying deliveries. Reacting only to a delayed shipment can cause unnecessary spending; waiting too long can cause a stockout. RainCheck Restock combines inventory, demand assumptions, incoming orders and supplier quotes to decide whether to wait or purchase emergency supplies. Airbyte’s Google Sheets connector, run through PyAirbyte, reads four business-data streams. Our backend loads the records into SingleStore, queries them for evaluation, and stores immutable snapshots, decisions, purchase-order drafts and audit events. A deterministic engine calculates shortages, adds a safety buffer, rounds to whole packs, and compares supplier availability, delivery time and total cost including shipping. Claude uses read-only tools to explain the results. In our demo, 300 cups cover five days of assumed rainy-day demand. A shipment arriving in four days requires no emergency purchase. Changing its ETA to six days triggers a recommendation to buy 200 cups for $26 from the cheapest supplier meeting the arrival constraint. Users can create a draft without placing a real order. Sponsor integrations are live; business data, weather effects and delivery scenarios are synthetic. Weather/news ingestion and learning from historical outcomes are future work.
Tools used