David Segura
ES
Back to gallery

Panzerottis el Rey — Inventory

Stock and cost control for an Italian-style restaurant

LaravelPHPMySQLViteFreelanceRestaurantInventory

Panzerottis el Rey — Inventory

A freelance backend for a family-owned panzerotti restaurant in Colombia. The owner needed visibility into ingredient stock, daily prep counts, and per-dish food cost so they could price competitively without bleeding margin.

What it covers

  • Ingredient catalog with purchase units and recipe units (e.g. flour bought in 25kg sacks, used in grams).
  • Recipe sheets that compute per-dish cost from current ingredient prices.
  • Daily prep log with low-stock warnings before the lunch rush.
  • Owner dashboard with weekly cost trends and margin per item.
// Recipe cost recomputed on every ingredient price change
public function computeCost(): float {
    return $this->ingredients
        ->sum(fn ($i) => $i->quantity * $i->ingredient->latest_price);
}

Built with Laravel + MySQL + Vite front-end views. Boring stack on purpose — the client's local developer needs to maintain it after handoff.

Project gallery

Panzerottis el Rey — Inventory — image 1Panzerottis el Rey — Inventory — image 2Panzerottis el Rey — Inventory — image 3