Littlefield War Room

Why

Littlefield Labs is an operations simulator that teaches across process analysis, capacity management, forecasting, production control, inventory control, queueing, and lead time management. Our team wanted a more accesible data intelligence tool to forecast and plan strategies.

Design

Littlefield operations simulation with Monte Carlo simulations and Gemini on-demand processing. Created with React 18, Tailwind CSS, Chart.js, SheetJS, Lucide Icons, and Google Apps Script. Hosted on Cloudflare via GitHub using Node.js Express, Cloudflare Pages Functions on the serverless edge, and the Gemini API.

How it works

The visual dashboard is synced with Google Sheets to provide team members with options for loading data (either directly in Sheets or via drag-and-drop on the visualization). The Sheet has the core formulas that we learned in class (M/M/1 queuing, Little’s Law, etc), and the hosted visuals take that to the next level.

┌───────────────────────────────────────────────────────────────────────────┐ │ SHARED GOOGLE DRIVE (“Littlefield Simulation”) │ │ Teammate drops latest “Consolidate Data-Daily Data Day X.xlsx” here │ └─────────────────────────────────────┬─────────────────────────────────────┘ │ ┌───────────────────────────┴───────────────────────────┐ ▼ (Path A: Cloud Sync) ▼ (Path B: Direct Drag & Drop) ┌───────────────────────────────────────────────────┐ ┌───────────────────────────────────────────────────┐ │ DELIVERABLE 1 & 2: DATA & STRATEGY HUB │ │ DELIVERABLE 3: LAYER 2 INTERACTIVE WEB SIMULATOR │ │ 1. Python-Built Master 6-Tab Workbook (.xlsx) │ │ • 3-Lever Sliders: Machines, Contracts, EOQ/ROP │ │ (100% pre-populated, converted to Sheets) │◄──┤ • Non-Linear Queueing & Contract Cliff Charts │ │ 2. Lean 2-Tab Live Google Sheet + Apps Script │ │ • Day 50–56 Backlog Drain & Switch Timer │ │ • Auto-ingests newest Drive .xlsx file │ │ • Day 217 “Single-Shot” Endgame Calculator │ │ • Acts as secure Gemini API Proxy (doPost) │ │ • Embedded Gemini Advisor (Telemetry-Injected) │ └───────────────────────────────────────────────────┘ └───────────────────────────────────────────────────┘

┌────────────────────────────────────────────────────────────────────────────────────────┐ │ LAYER 2 WEB APPLICATION (CLIENT-SIDE REACT SPA) │ │ │ │ ┌──────────────────────┐ ┌──────────────────────────┐ ┌──────────────────────┐ │ │ │ 1. DATA INGESTION │ │ 2. SIMULATION ENGINE │ │ 3. GEMINI AI ADVISOR │ │ │ │ • Default Day 1–50 ├───►│ • Erlang-C M/M/c Solver ├───►│ • Live JSON Context │ │ │ │ • Drag & Drop .xlsx │ │ • Backlog Drain ODE │ │ • 4 Quick Briefings │ │ │ │ • Google Sheet Sync │ │ • EOQ & Day-217 Solver │ │ • Direct API / Proxy │ │ │ └──────────────────────┘ └────────────┬─────────────┘ └──────────────────────┘ │ │ │ │ │ ┌────────────▼─────────────┐ │ │ │ 4. VISUALIZATION DECK │ │ │ │ • 4 Interactive Charts │ │ │ │ • 3-Lever Control Panel │ │ │ │ • Competitor Forensics │ │ │ └──────────────────────────┘ │ └────────────────────────────────────────────────────────────────────────────────────────┘