Plant overview
About the Dashboard
The Dashboard is a read-only aggregated view of every other module - production, QC, inventory, finance. It refreshes from the same MongoDB collections the operational modules write to, so what you see here is the same data, summarised. It's the first screen supervisors open at the start of each shift.
- Reads from: Job Orders, Production batches, QC results, Inventory, Vouchers
- Refresh: live (polled every 15 s) for line status; hourly for finance metrics
- Used by: Plant Manager, Shift Supervisor, Production Planner
Production trend
Recent activity
- just nowPRODBatch
JO-2026-0418closed on Line A · 1,284 units - 3m agoQCQC sample passed for
JO-2026-0418 - 11m agoINVRM
SUGAR-Xreceived · qty 2,400 kg - 22m agoACCVoucher
BPV-2103posted · AED 8,420.50 - 38m agoPRODJob order
JO-2026-0419opened - 1h agoDSPDispatch
DA-1042printed
Job orders
About Job Orders
A Job Order (JO) is the production planning record - a customer order, internal stock build, or forecast triggers a JO for a specific product, quantity, and line. The JO carries through the entire lifecycle: picking sheet → mixing → filling → packaging → QC → dispatch. Every batch produced is linked to a JO.
- Inputs: Customer order, sales forecast, or stock build
- Workflow: Draft → Released → In Production → Closed
- Outputs: Picking sheet PDF, Production batches, QC records, FG to inventory
- Integrations: Recipes (BOM), Inventory (stock reservation), Sage (COGS on close)
Job orders list
| JO # | Customer | Product | Qty | Unit cost | Total | Line | Status | |
|---|---|---|---|---|---|---|---|---|
JO-DEMO-1 | Demo Customer Ltd | Sample Beverage 500 mL | 4,800 cs | AED 8.45 | AED 40,560 | Line A | In Production | |
JO-DEMO-2 | Acme Beverages | Sample Beverage 1 L | 3,200 cs | AED 11.20 | AED 35,840 | Line A | Queued | |
JO-DEMO-3 | Placeholder FZE | Sample Beverage 250 mL | 6,000 cs | AED 5.90 | AED 35,400 | Line B | Closed | |
JO-DEMO-4 | Sample Distribution Co | Sample Beverage 500 mL | 2,400 cs | AED 8.45 | AED 20,280 | Line A | Draft |
JO-DEMO-1 · header
- Customer
- Demo Customer Ltd
- Product
- Sample Beverage 500 mL
- Recipe
- Recipe-A1 · v1
- Order qty
- 4,800 cases
- Planned start
- 2026-05-13 08:00
- Line
- Line A
- Estimated cost
- AED 40,560
- Status
- In Production
Picking sheet
JO-DEMO-1| RM | Description | Req | Stock | Cost |
|---|---|---|---|---|
RM-WATER | Demo Water | 2,400 L | 8,400 L | AED 1,560 |
RM-SUGAR | Demo Sugar | 385 kg | 1,150 kg | AED 1,232 |
RM-FLAVOR | Demo Flavor X | 18.5 L | 245 L | AED 340 |
RM-PREFORM | PET preform 500 mL | 115,200 pcs | 92,400 pcs | AED 9,216 |
RM-CAP | Bottle cap | 115,200 pcs | 184,000 pcs | AED 4,608 |
RM-LABEL | Shrink label | 115,200 pcs | 156,000 pcs | AED 5,760 |
Production control
About Production Control
The live nerve-centre during a shift. Operators record output, downtime, and quality holds against the active Job Order. The system computes OEE in real time (Availability × Performance × Quality), publishes batch records, and closes-out the JO when the planned quantity is reached.
- Reads: Active JO, Recipe, Line capacity
- Writes: Production batches, Downtime events, OEE snapshots
- Outputs: Batch record, OEE report, hand-off to QC
Line A · live status
- Blow molder · running
- Filler · running
- Checkmate · idle
- Variopac FS · running
- Palletizer · running
Batch close form
Batches today
| Batch | JO | Product | Qty | Reject | OEE | Status |
|---|---|---|---|---|---|---|
DEMO-0001 | JO-DEMO-1 | Sample Beverage 500 mL | 4,820 | 38 | 82% | Closed |
DEMO-0002 | JO-DEMO-2 | Sample Beverage 1 L | 3,180 | 52 | 78% | In progress |
Recipe library
About Recipes
The bill-of-materials and process steps for each product. Versioned - only one version is "released" per product at a time. Picking sheets, mixing operations, costing and QC specs all derive from the released version.
- Workflow: Draft → Review → Released (older versions archived)
- Drives: Picking sheet, Mixing instructions, Cost estimate, QC spec ranges
Recipe-A1 · Sample Beverage 500 mL
| Step | Ingredient | Qty | UoM |
|---|---|---|---|
| 1 | Demo Water | 0.42 | L |
| 2 | Demo Sugar | 0.080 | kg |
| 3 | Demo Flavor X | 3.8 | mL |
| 4 | Demo Preservative | 0.5 | mL |
| 5 | Demo CO₂ | 4.2 | g |
Recipe-B2 · Sample Beverage 1 L
| Step | Ingredient | Qty | UoM |
|---|---|---|---|
| 1 | Demo Water | 0.86 | L |
| 2 | Demo Sugar | 0.165 | kg |
| 3 | Demo Flavor Y | 7.5 | mL |
| 4 | Demo Preservative | 1.0 | mL |
| 5 | Demo CO₂ | 8.4 | g |
Mixing tanks & CIP
About Mixing & CIP
Tracks each mixing tank's contents, temperature, and lifecycle: charge → mix → hold → transfer → CIP. CIP (Clean-in-Place) cycles are sanitation washes; the system records each step and time so audits can trace any batch back to a clean tank.
- States: Idle · Charging · Mixing · Hold · Transferring · CIP · Ready
- Outputs: Mixing operations PDF, Tank CIP PDF (audit evidence)
Tank board
QC batch records
About Quality Control
Every production batch generates QC checks against the Recipe's spec ranges. The QC module captures sample measurements (Brix, pH, net content, cap torque, seam, carbonation, micro), flags out-of-spec results, and produces a Certificate of Analysis (QC Batch Report).
- Reads from: Production batches, Recipe QC spec
- Outputs: QC Batch Report PDF (Certificate of Analysis), seam check PDF, sample PDF
- Approvals: Two-level - QC Analyst → QC Manager
Batch DEMO-0001 · QC sheet
| Check | UoM | Min | Max | Measured | Result |
|---|---|---|---|---|---|
| Brix | °Bx | 10.2 | 10.8 | 10.55 | PASS |
| pH | - | 3.20 | 3.50 | 3.32 | PASS |
| Net content | mL | 498 | 502 | 499.6 | PASS |
| Cap torque | lb·in | 12 | 18 | 14.2 | PASS |
| Seam thickness | mm | 1.18 | 1.28 | 1.24 | PASS |
| Carbonation | vol | 3.4 | 3.7 | 3.71 | REVIEW |
Mixing checks
- Ingredients verified
- Temperature in spec
- Mixing time recorded
- Operator sign-off pending
Tank CIP
- Pre-rinse complete
- Caustic cycle complete
- Acid cycle in progress
- Final rinse pending
Yield analysis
About Yield
Compares theoretical yield (from the Recipe) against actual produced quantity (from Production batches). Variance is broken down into mixing loss, fill loss, packaging loss, and rejects. Used by production planning to refine recipes and cost models.
Yield by batch · last 5
| Batch | Product | Theoretical | Actual | Variance | Yield % |
|---|---|---|---|---|---|
DEMO-0001 | Sample Beverage 500 mL | 4,858 | 4,820 | -38 | 99.2% |
DEMO-0002 | Sample Beverage 1 L | 3,232 | 3,180 | -52 | 98.4% |
DEMO-0003 | Sample Beverage 250 mL | 5,994 | 5,970 | -24 | 99.6% |
DEMO-0004 | Sample Beverage 500 mL | 2,407 | 2,395 | -12 | 99.5% |
DEMO-0005 | Sample Beverage 1 L | 2,828 | 2,810 | -18 | 99.4% |
Raw materials & finished goods
About Inventory
Live stock balance for every Raw Material and Finished Good. Reservations are made automatically when a Job Order is released. Movements (GRN, picking, transfer, dispatch) post here; values are FIFO. Reorder points trigger alerts and feed RM Order suggestions.
- Costing: FIFO
- Reads from: GRN (in), Picking (out to production), Dispatch (out to customer)
- Writes to: Inventory ledger, Sage Inventory account
Stock items
| Code | Description | Type | On hand | Reserved | UoM | Unit cost | Value |
|---|---|---|---|---|---|---|---|
RM-WATER | Demo Water | RM | 8,400 | 2,400 | L | AED 0.65 | AED 5,460 |
RM-SUGAR | Demo Sugar | RM | 1,150 | 480 | kg | AED 3.20 | AED 3,680 |
RM-FLAVOR | Demo Flavor X | RM | 245 | 60 | L | AED 18.40 | AED 4,508 |
RM-PREFORM | PET preform 500 mL | RM | 92,400 | 18,200 | pcs | AED 0.08 | AED 7,392 |
RM-CAP | Bottle cap | RM | 184,000 | 28,400 | pcs | AED 0.04 | AED 7,360 |
RM-LABEL | Shrink label | RM | 156,000 | 24,800 | pcs | AED 0.05 | AED 7,800 |
FG-500ML | Sample Beverage 500 mL | FG | 1,840 | 0 | case | AED 8.45 | AED 15,548 |
FG-1L | Sample Beverage 1 L | FG | 920 | 0 | case | AED 11.20 | AED 10,304 |
| Inventory value | AED 62,052 | ||||||
Goods Receipt Notes (GRN)
About GRN
The Goods Receipt Note records incoming materials from a supplier against an open PO. QC inspects and accepts/rejects; accepted qty posts to Inventory at the PO price (or actual invoice price if it differs).
GRN list
| GRN # | Date | PO # | Supplier | Items | Value | Status |
|---|---|---|---|---|---|---|
GRN-0001 | 2026-05-13 | PO-DEMO-1 | Demo Supplier Co | 5 items | AED 18,420 | Posted |
GRN-0002 | 2026-05-12 | PO-DEMO-2 | Acme Materials | 3 items | AED 9,840 | Awaiting QC |
Raw material reorder
About RM Orders
Suggests reorder quantities by combining current stock, reorder point, lead time, and demand forecast. The output is a draft Purchase Order per supplier, ready for review and release.
Suggested reorders
| RM | Stock | Reorder pt | Lead time | Suggested qty | Supplier |
|---|---|---|---|---|---|
RM-SUGAR | 1,150 kg | 800 kg | 7 days | 1,500 kg | Demo Supplier Co |
RM-FLAVOR | 245 L | 200 L | 14 days | 500 L | Acme Materials |
Customer quotations
About Quotations
Customer pricing quotes generated against current cost + margin policy. Accepted quotes convert directly into Performa Invoices and Job Orders.
Quotations
| Quote # | Date | Customer | Product | Qty | Unit | Total | Status |
|---|---|---|---|---|---|---|---|
QT-0001 | 2026-05-13 | Demo Customer Ltd | Sample Beverage 500 mL | 4,800 cs | AED 8.45 | AED 40,560 | Sent |
QT-0002 | 2026-05-12 | Acme Beverages | Sample Beverage 1 L | 3,200 cs | AED 11.20 | AED 35,840 | Accepted |
Performa invoices
About Performa Invoice
A pro-forma invoice issued before goods ship - confirms what will be billed once the order is fulfilled. Used by the customer for advance payment, by us for AR forecasting.
PI list
| PI # | Date | Customer | Items | Total | Status | |
|---|---|---|---|---|---|---|
PI-0001 | 2026-05-13 | Demo Customer Ltd | 4,800 cs | AED 40,560 | Issued |
Outbound dispatch
About Dispatch
Plans the outbound load - links FG cases to a vehicle, prints a Delivery Advice + Gate Pass + Packing List, and posts the inventory movement. Drivers receive a printed gate pass; reception scans on arrival at customer.
Dispatch DA-0001
- Customer
- Demo Customer Ltd
- Address
- Plot 1, Demo Industrial Area
- Vehicle
- DEMO-1
- Driver
- Driver One
- Loaded qty
- 4,800 cases
- Invoice
PI-0001· AED 40,560- Status
- Loading
Supplier master
About Suppliers
Vendor master - contact, payment terms, lead time, materials supplied, qualification status. Drives PO defaults and RM Order suggestions.
Suppliers
| Code | Name | Materials | Lead time | Payment | Status |
|---|---|---|---|---|---|
SUP-001 | Demo Supplier Co | RM-SUGAR, RM-WATER | 7 days | Net 30 | Active |
SUP-002 | Acme Materials | RM-FLAVOR, RM-PREFORM | 14 days | Net 60 | Active |
SUP-003 | Placeholder Supply | RM-CAP, RM-LABEL | 21 days | Advance | Inactive |
Purchase orders
About Purchase Orders
Procurement orders sent to suppliers. Generated from RM Order suggestions or manually. Open POs drive expected GRNs and AP commitments.
POs
| PO # | Date | Supplier | Items | Total | Status |
|---|---|---|---|---|---|
PO-DEMO-1 | 2026-05-13 | Demo Supplier Co | 5 items | AED 18,420 | Received |
PO-DEMO-2 | 2026-05-12 | Acme Materials | 3 items | AED 9,840 | Partial |
Vouchers
About Accounts & Vouchers
Bank Payment Voucher (BPV), Cash Payment Voucher (CPV), Bank Receipt Voucher (BRV), Cash Receipt Voucher (CRV), Journal Voucher (JV). Each draft can be edited; once posted, it generates a Sage entry pair (debit/credit) and updates the running balances.
Bank Payment Voucher
- Date
- 2026-05-13
- Pay to
- Demo Supplier Co
- Account
- Bank Demo · ****0001
- Amount
- AED 18,420
- Reference
- PI-0001 / GRN-0001
- Status
- Draft
Cash Payment Voucher
- Date
- 2026-05-13
- Pay to
- Petty Cash
- Account
- Cash on hand
- Amount
- AED 1,250
- Reference
- EXP-0001
- Status
- Posted
Sage draft entries
About Sage Entries
Staging layer between the operational modules and the Sage accounting system. Whenever a JO closes, a GRN posts, a voucher is approved, or a dispatch invoices, the system generates draft journal entries here. The accounts team batches them and exports a Sage-compatible CSV daily.
Draft entries
| Ref | Date | Account | Description | Debit | Credit |
|---|---|---|---|---|---|
SE-0001 | 2026-05-13 | 5000 · Demo COGS | JO-DEMO-1 closing | AED 28,392 | - |
SE-0001 | 2026-05-13 | 1300 · Demo Inventory | JO-DEMO-1 closing | - | AED 28,392 |
SE-0002 | 2026-05-13 | 2100 · AP - Demo Supplier | BPV-0001 | AED 18,420 | - |
SE-0002 | 2026-05-13 | 1010 · Bank Demo | BPV-0001 | - | AED 18,420 |
Demand forecast
About Forecast
Monthly demand forecast per SKU, by region. Combines historical sales, customer orders on hand, and seasonality factors. Drives production planning and raw-material reorder suggestions.
Forecast by SKU
| SKU | Last month | Forecast | Bookings | Coverage |
|---|---|---|---|---|
| FG-500ML | 22,400 cs | 26,000 cs | 24,250 cs | 93% |
| FG-1L | 14,800 cs | 16,500 cs | 15,890 cs | 96% |
| FG-250ML | 9,200 cs | 10,800 cs | 9,640 cs | 89% |
Customs & FTA exports
About Customs & FTA
Generates the regulatory exports required by the UAE FTA - excise goods declarations, internal-transfer movements, VAT-relevant records. Outputs are validated against the FTA templates before submission.
Excise declarations
| Period | Items | Excise qty | Excise value | Status |
|---|---|---|---|---|
| 2026-05 | 3 SKUs | 180,400 L | AED 90,200 | Draft |
| 2026-04 | 3 SKUs | 164,800 L | AED 82,400 | Submitted |
Document library
About Documents
Every PDF the system generates - job orders, picking sheets, QC reports, vouchers, invoices, dispatches, Sage batches - is stored here and linked to the originating record. The buttons below open each PDF template so you can preview and print/save as PDF.
Available document templates
Operational reports
About Reports
Pre-built reports that aggregate the operational modules: production by line, OEE breakdown, QC pass-rates, inventory value movement, AP/AR aging. Each report can export to PDF or CSV.
Output by day
OEE - Line A
- Availability · 91%
- Performance · 94%
- Quality · 96%
Configuration
About Settings
Admin module - user accounts & roles, line configuration, document templates, system parameters, audit log. Role-based access control: Operator, Supervisor, QC, Accounts, Admin.
Users & roles
| User | Role | Status |
|---|---|---|
| demo.user | Supervisor | Active |
| demo.qc | QC Analyst | Active |
| demo.acc | Accountant | Active |
| demo.admin | Admin | Active |
Lines
| Line | Speed | Status |
|---|---|---|
| Line A | 9,600 bph | Running |
| Line B | 7,200 bph | Idle |
| Line C | 4,800 bph | Down |