Skip to content
abees.meCase study

Case study 02 — Operations platform · Published

MW Supply Platform

Period
2024 – 2025
Role
Sole developer — data model, backend, dashboard
Stack
Python · FastAPI · React · Supabase · PostgreSQL

Problem

A bottled-water operation tracked customers, daily deliveries, bottle inventory, and payments by hand. Bottles went missing, settlements lagged, and the owner had no operational picture.

Constraints

  • 01Daily delivery cadence — the system must keep up with round trips
  • 02Bottle-level inventory: every container tracked in and out
  • 03Payment status visible at a glance for collections
  • 04Operators primarily on phones in the field

Architecture

Field entrydeliveries · returns · paymentsOwner dashboarddaily operational pictureFastAPIledgers · billing rulesCustomer ledgerbalances · historyBottle inventoryevery container tracked
Field operations feeding a single FastAPI + Postgres ledger with dashboard views.

What was built

  • Customer ledgers with delivery history and balances
  • Bottle movement tracking across fills, deliveries, and returns
  • Billing and payment monitoring with settlement views
  • One operational dashboard for daily decisions

Outcome

Impact

Reduced manual tracking across water-supply workflows

Status

Published and in operation