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.