Central Kitchen database running in WAL mode.
Just nowWelcome to Smart Central Kitchen ERP ✦
Centralized commissary operations platform for multi-branch order scheduling, BOM explosion, and inventory management with high precision.
Operations Overview
Real-time production tracking, BOM explosion engine, and branch distribution ledger.
Weekly Demand Velocity
Aggregated daily ingredient & product consumption trend
Stock Health & Reorder Compliance
Real-time safety stock threshold verification
Automated safety threshold monitor. Generates procurement warnings when stock falls below reorder points.
Live BOM Batch Simulator
Manufactured Products Master
5 ProductsFinished commissary goods, real-time center stock vs active branch requirements
| Product Code | Manufactured Product (PA) | Category | Center Stock | Branch Demand | Coverage | Action |
|---|---|---|---|---|---|---|
| Loading finished goods master data... | ||||||
Select a product to inspect and control
BOM Batch Production & Deduction Simulator
Center Finished Stock Adjustment
📜 Center Finished Stock Transaction Log
Aggregated Demand by Product
| Product | Total Units | Branches | Unit Cost | Total Cost |
|---|
Individual Branch Orders Log
| # | Branch | Date | Order Status | Items Ordered | Est. Value | Actions |
|---|
No branch orders found matching criteria
Manual Branch Order Entry
| Item | Qty | Unit | Total | ✕ |
|---|
Import & Aggregate Branch Excel
CK Products (BOM)
5 BOM Recipes—
Central Commissary PrepCentral Kitchen Recipe, Material Breakdown & Live Branch Demand
| Ingredient / Raw Material | Ratio / Unit | UOM | Unit Price | Waste % | Line Cost |
|---|
Enter Batch Size to Produce:
Calculates consumed materials and checks inventory stock before deduction
| Raw Material | Standard Ratio | Total Consumed | Current Stock | Stock After | Coverage Status |
|---|
📊 Executive Monthly Production & Dispatch Matrix
Daily breakdown of manufactured items across the active month
🧪 Daily Production BOM Requirements
Raw materials needed to cover today
| Item Code | Ingredient | Category | Base Required | + Waste Qty | Total Required | Unit Price | Total Cost | In Stock | Status |
|---|
🍔 Burger Sauce Logs
Track burger sauce batch logs and branch shipments
| Date | Produced Qty (Kg) | Receiving Branches | Notes | Action |
|---|
No burger sauce logged for this month
📦 Real-Time Stock vs Production Needs (200 Materials)
Shortages and live deductions are automatically calculated from recipes
| Code | Ingredient | Department | Current Stock | Safety Stock | Required Today | Status | Stock Level | Edit |
|---|
🛒 Purchase Orders Management
Orders generated from shortages; inventory auto-updated upon receipt
| PO # | Ingredient | Quantity | UOM | Est. Cost | Supplier | Priority | Status | Actions |
|---|
Excellent! No shortages detected in inventory
Supplier Invoices Ledger
Invoices are logged automatically upon warehouse receipt
| Invoice # | PO # | Ingredient | Qty Received | UOM | Invoice Value | Supplier | Received Date | Payment |
|---|
No invoices yet — they appear here after receiving shipments
🗑️ Log New Waste / Spoilage
📜 Waste Ledger & Analytics
Track monetary loss from spillage and waste
| Date | Ingredient | Qty Wasted | UOM | Unit Price | Total Loss | Reason | Action |
|---|
Great! No waste recorded for this filter
📦 Daily Branch Shipments Register
Total products sent to branches daily, exported from branch orders — Excel export ready
🧴 Taztiki Sauce Register — Separate Manual Entry
Entered separately as it comes via special channel — exported in its own sheet
| Date | Burger Sauce (Kg) | Receiving Branches | Notes |
|---|
No Taztiki records yet — click Add Row to log a shipment
📊 Advanced Comparison Analytics
Compare performance, demand, & waste across months, days, and branches
Branch Orders Comparison
Total UnitsWaste Loss Comparison
USD ($)Top CK Products Usage
Qty ComparisonCost vs Waste Breakdown
Cost RatioDetailed Comparison Matrix & Growth Indicators
| Metric / Branch | Month 1 | Month 2 | Difference | % Change | Status Indicator |
|---|