Dashboard
Overview of today's operations
May 17, 2024
Running Batches
8
▲ +2 from yesterday
Pending QC
14
▲ +4 from yesterday
Waiting Approval
6
— 1 from yesterday
Material Shortage
5
▲ +3 from yesterday
FG Produced (Today)
1,250 kg
▲ +320 kg from yesterday
Production Timeline (Today)
08:00
MixingBatch B240517-001
Completed
09:20
HeatingBatch B240517-001
In Progress
11:00
QC InspectionBatch B240517-001
Pending
13:00
PackagingBatch B240517-001
Pending
15:30
Finished GoodsBatch B240517-001
Pending
Running BatchesView all
| Batch No. | Product | Stage | Progress |
|---|---|---|---|
| B240517-001 | Whitening Cream | Heating | 68% |
| B240517-002 | Vitamin Serum | Mixing | 45% |
| B240517-003 | Body Lotion | Cooling | 30% |
| B240517-004 | Sunscreen SPF50 | Mixing | 20% |
Inventory AlertsView all
Vitamin B3Low Stock90 kg left
GlycerinLow Stock120 kg left
NiacinamideNear Expiry15 days left
Salicylic AcidOut of Stock0 kg left
Pending QC
Bulk12batches
Finished Goods5batches
Raw Material2lots
Recent ActivitiesView all
JDJohn Doe approved Formula WF-004 (Version 4)2 min ago
SWSarah White completed QC for Batch B240516-01015 min ago
MTMike Taylor received Raw Material Vitamin C (LOT240515)1 hr ago
ALAnna Lee created Production Order PO240517-0062 hr ago
Top Used Raw Materials (Today)
Water450 kg (36%)
Glycerin200 kg (16%)
Niacinamide150 kg (12%)
Vitamin B3130 kg (10%)
Others330 kg (26%)
Whitening Cream (Version 4)
Released
Approved on May 10, 2024 by Dr. Wipada (R&D Head)
Formula Information
Ingredients
Documents
History
Approvals
| No. | Raw Material | INCI Name | Function | % w/w | Unit |
|---|---|---|---|---|---|
| 1 | Water | Aqua | Solvent | 64.90 | % |
| 2 | Glycerin | Glycerin | Humectant | 5.00 | % |
| 3 | Niacinamide | Niacinamide | Active | 2.00 | % |
| 4 | Vitamin B3 | Niacinamide | Active | 2.00 | % |
| 5 | Carbomer | Carbomer | Thickener | 0.30 | % |
| 6 | Triethanolamine | Triethanolamine | pH Adjuster | 0.20 | % |
| 7 | Phenoxyethanol | Phenoxyethanol | Preservative | 0.80 | % |
| 8 | Fragrance | Parfum | Fragrance | 0.20 | % |
| 9 | Emulsifier Blend + Others | — | Base | 24.60 | % |
| Total | 100.00 | % |
Notes: Stable pH range 5.5 – 6.5 · Approved version is locked as an immutable record — changes require a new version through the approval workflow.
Version History
Version 4May 10, 2024 · Used by 6 batchesApproved
Version 3Apr 28, 2024 · SupersededApproved
Version 2Apr 15, 2024 · SupersededApproved
Version 1Mar 30, 2024 · Failed stability testDraft
Production
Production orders across all work centers
Production Orders
Batches
Work Centers
All Status
Planning (2)
PO240517-001
Whitening Cream
PO240517-002
Vitamin Serum
Running (3)
PO240517-003
Whitening Cream
PO240517-004
Body Lotion
PO240517-005
Sunscreen SPF50
QC (1)
PO240517-006
Vitamin Serum
In QC
Finished (2)
PO240517-007
Body Lotion
Completed
PO240517-008
Whitening Cream
Completed
Inventory › Raw Material
Raw Material
Lot-controlled raw material inventory
Total Items
342
Near Expiry
12
Low Stock
8
Out of Stock
5
All Categories
All Status
| Raw Material | Category | Unit | Current Stock | Reserved | Available | Near Expiry | Status |
|---|---|---|---|---|---|---|---|
| Vitamin B3 (Niacinamide) | Active | kg | 120.00 | 30.00 | 90.00 | 15 days | Low Stock |
| Glycerin | Humectant | kg | 200.00 | 50.00 | 150.00 | — | In Stock |
| Carbomer | Thickener | kg | 80.00 | 10.00 | 70.00 | — | In Stock |
| Salicylic Acid | Active | kg | 0.00 | 0.00 | 0.00 | — | Out of Stock |
| Vitamin C | Active | kg | 25.00 | 5.00 | 20.00 | 10 days | Low Stock |
| Phenoxyethanol | Preservative | kg | 64.50 | 12.00 | 52.50 | — | In Stock |
Production › Batches › B240517-001
Batch B240517-001
Whitening Cream
In Progress
Production Order PO240517-003 · Formula WF-004 (Version 4)
Overview
Ingredients & Weighing
Process
QC
Documents
History
Planned Qty
500 kg
Produced Qty
340 kg
Operator
Mike Taylor
May 17, 08:40
Machine
Mixer-02
Work Center A
Progress68%
Current Step
Heating
Temperature65 °C
Start Time09:20
Duration40 min
Target70 °C · 60 min
Process Steps
WeighingCompleted
MixingCompleted
HeatingIn Progress
CoolingPending
HomogenizerPending
Bulk FinishedPending
QC Gate: Bulk inspection is required after "Bulk Finished" — the system locks Filling & Packaging until QC status is Passed.
Reports › Production Summary
Production Summary
Production performance across all work centers
May 1, 2024 – May 17, 2024
All Products
All Work Centers
Total Produced
12,450 kg
Total Batches
28 batches
Average Yield
92.5%
Rejected Qty
320 kg
Production by Day (kg)
May 1357911131517
Top Products
Whitening Cream45%
Body Lotion25%
Vitamin Serum16%
Sunscreen SPF509%
Others5%
Master Data
Central reference data shared across every module
Raw Material342 itemsManage →
Packaging128 itemsManage →
Supplier46 companiesManage →
Customer32 brandsManage →
Warehouse4 locationsManage →
Storage Location58 binsManage →
Machine12 machinesManage →
Unit18 unitsManage →
Product Category14 categoriesManage →
SuppliersView all
| Supplier | Contact | Phone | Materials Supplied | Status |
|---|---|---|---|---|
| Chemipan Corporation | K. Somsak | 02-XXX-1188 | Actives, Preservatives | Active |
| Thai Cosmo Ingredients | K. Pranee | 02-XXX-3350 | Emulsifiers, Thickeners | Active |
| Siam Pack Co., Ltd. | K. Wichai | 02-XXX-7742 | Jars, Bottles, Pumps | Active |
| Global Fragrance Ltd. | K. Anong | 02-XXX-9061 | Fragrance, Essential Oils | On Hold |
Production Planning
Weekly plan, material requirement and reservation
Production Plan — Week 20 (May 13–19)
Week 20
| Order | Product | Qty | Planned Date | Status |
|---|---|---|---|---|
| PO240517-001 | Whitening Cream | 500 kg | May 18 | Confirmed |
| PO240517-002 | Vitamin Serum | 300 kg | May 19 | Draft |
| PO240517-003 | Whitening Cream | 500 kg | May 17 | Released |
| PO240517-004 | Body Lotion | 800 kg | May 17 | Released |
| PO240517-005 | Sunscreen SPF50 | 600 kg | May 17 | Released |
Material Requirement — PO240517-0011 Shortage
| Raw Material | Required | Available | Shortage |
|---|---|---|---|
| Water | 324.5 kg | — | — |
| Glycerin | 25.0 kg | 150.0 kg | — |
| Niacinamide | 10.0 kg | 90.0 kg | — |
| Salicylic Acid | 2.5 kg | 0.0 kg | 2.5 kg |
| Phenoxyethanol | 4.0 kg | 52.5 kg | — |
Shortage: Purchasing is handled outside this system (confirmed out of scope) — the order can be reserved once the received lot passes RM inspection.
Packaging BOM
Bill of materials for filling & packing, version controlled
BOM List
Whitening Cream 30 gFG F001CE001 · Version 2Approved
Vitamin Serum 30 mlFG F001SE003 · Version 1Approved
Body Lotion 250 mlFG F002LO001 · Version 3Draft
Sunscreen SPF50 50 mlFG F003CE002 · Version 1Approved
Whitening Cream 30 g — F001CE001 · Version 2
Approved · May 8, 2024
| Component | Code | Type | Qty / Unit | Loss % |
|---|---|---|---|---|
| Jar 30 g (frosted) | PK-0042 | Primary | 1 pc | 1.0 |
| Inner Lid | PK-0043 | Primary | 1 pc | 1.0 |
| Outer Box (print v.2) | PK-0058 | Secondary | 1 pc | 2.0 |
| Label Sticker | PK-0071 | Secondary | 1 pc | 3.0 |
| Shrink Film | PK-0090 | Tertiary | 1 pc | 2.0 |
Bulk source: BCE-001 (Whitening Cream base) · Fill weight 30 g ± 0.5 g · Approved BOM versions are immutable — packing orders always reference the exact version used.
Quality Control
Three inspection gates — RM receiving, Bulk, Finished Goods
May 17, 2024
RM Inspection (2)
Bulk Inspection (3)
FG Inspection (1)
Bulk Inspection Queue
| Bulk Lot | Product | Batch | Received | Status |
|---|---|---|---|---|
| BSE-014 | Vitamin Serum | B240517-002 | 10:40 | Testing |
| BCE-021 | Whitening Cream | B240517-001 | 11:20 | Waiting |
| BLO-009 | Body Lotion | B240516-008 | Yesterday | Micro 48 h |
BSE-014 — Vitamin SerumHold
Appearance (color / odor)Pass
Viscosity — 8,400 cpsPass
pH (spec 5.5–6.5)Awaiting lab
Microbial (Total Plate Count)48 h
QC Gate: Filling for batch B240517-002 stays locked by the system until every checklist item passes — enforced in business logic, not just a warning.
CRM
Customer requirements, quotations and orders
Open Inquiries
6
Quotes Awaiting Approval
2
Orders This Month
4
Quote Hit Rate
58%
Inquiry PipelineView all
| Inquiry | Customer | Requirement | Product Check | Status |
|---|---|---|---|---|
| IQ-2405-014 | Aura Beauty | Vitamin C Serum 30 ml | FG + BOM ready | Quoted |
| IQ-2405-015 | Bloom Labs | Herbal Shampoo 250 ml | Formula only — BOM needed | Reviewing |
| IQ-2405-016 | Nara Organics | Anti-aging Cream 50 g | New product — R&D | New |
| IQ-2405-011 | Aura Beauty | Lip Tint 5 g | FG + BOM ready | Won |
| IQ-2405-009 | CoCo Care | Body Scrub 200 g | FG + BOM ready | Lost |
Product check: An inquiry matching an approved FG + BOM can be quoted immediately — missing pieces route to BOM creation or an R&D request instead.
Sales ActivitiesView all
| Type | Detail | When |
|---|---|---|
| Call | Confirm jar color with customer | Today 10:30 |
| Visit | Factory tour + hand over samples | May 20 |
| Follow-up | Send quotation for IQ-2405-016 | Due May 21 |
| Call | Payment terms — Bloom Labs | May 16 |
Idle inquiries raise a notification after 5 days without activity.
Quotation QT-2405-0087 — Aura BeautyVersion 2Issued
Customer
Aura Beauty (001)Linked Inquiry
IQ-2405-014Valid Until
May 31, 2024Approved By
K. Supansa (Sales Manager)| Item | Reference | Qty | Unit Price | Amount |
|---|---|---|---|---|
| F001SE003 — Vitamin C Serum 30 ml | WF-004 v4 · BOM v3 | 5,000 | ฿48.50 | ฿242,500 |
| F001LP001 — Lip Tint 5 g | WF-011 v2 · BOM v1 | 3,000 | ฿22.00 | ฿66,000 |
| Subtotal | ฿308,500 | |||
| VAT 7% | ฿21,595 | |||
| Grand Total | ฿330,095 | |||
Quotation lock: Issued quotations are immutable — the same rule as approved formulas. A price change creates Version 3 through the approval workflow, and orders always reference the exact accepted version.
Requirement-to-delivery trace
Inquiry
IQ-2405-014Quotation
QT-2405-0087 v2Customer Order
CO-2405-0031Production Order
PO240517-003Batch
B240517-002FG Lot
FG-2405-0027Delivery Note
DN-2405-0102Customer
Aura BeautyRecall: The trace now answers "which customers received this lot" — not just "which lots are affected". A delivery note ships released FG only, enforced the same way as the QC gates.
Sales / Incentive
Incentive rules and period summary — final rules to be confirmed in Milestone 1
Incentive Rules4 Active
| Product Category | Type | Rate | Effective | Status |
|---|---|---|---|---|
| Cream (CE) | % of order value | 3.0% | Jan 2024 | Active |
| Serum (SE) | % of order value | 4.0% | Jan 2024 | Active |
| Lotion (LO) | % of order value | 2.5% | Jan 2024 | Active |
| New Customer Bonus | Fixed / order | ฿2,000 | Mar 2024 | Active |
Rule engine supports % of order value, fixed amount and tiered rates — the exact calculation model will be confirmed with the sales team during Milestone 1.
Incentive Summary — May 2024
| Salesperson | Orders | Sales Value | Incentive | Status |
|---|---|---|---|---|
| Anna Lee | 8 | ฿1,240,000 | ฿41,700 | Calculated |
| Korn P. | 6 | ฿980,000 | ฿31,400 | Calculated |
| Meena S. | 5 | ฿702,500 | ฿22,880 | Pending Review |
| Total | 19 | ฿2,922,500 | ฿95,980 |
Administration
Users, roles, running numbers and audit trail
UsersView all
| Name | Role | Department | Last Login | Status |
|---|---|---|---|---|
| John Doe | Production Manager | Production | Today 08:02 | Active |
| Dr. Wipada | R&D Head | R&D | Today 07:45 | Active |
| Sarah White | QC Officer | Quality | Today 08:15 | Active |
| Mike Taylor | Warehouse Officer | Warehouse | Yesterday | Active |
| Anucha K. | Operator | Production | May 12 | Suspended |
Roles & PermissionsEdit matrix
Administrator 2
R&D 4
Warehouse 6
Production 12
QC 3
Sales 3
Viewer 5
Code issuing rights follow factory practice — R&D issues RM / Bulk / FG codes, Warehouse issues PK codes. Enforced by RBAC.
Running Number ConfigurationFactory standard
| Code Type | Pattern | Example | Meaning | Issued By |
|---|---|---|---|---|
| Raw Material | R + Form + Storage + ### | RLC003 | Liquid · Cool place (22–25 °C) · No. 3 | R&D |
| Bulk Product | B + Type(2) + ### | BSF-001 | Bulk · Shower/Shampoo type · No. 1 | R&D |
| Finished Goods | F + Cust(3) + Type(2) + ### | F001SE003 | Customer 001 · Serum · No. 3 | R&D |
| Packaging | PK + #### | PK-0042 | Running number | Warehouse |
| Batch | B + YYMMDD + ### | B240517-001 | Production date · Daily sequence | System |
| Production Order | PO + YYMMDD + ### | PO240517-003 | Order date · Daily sequence | System |
| Quotation | QT + YYMM + #### | QT-2405-0087 | Month · Monthly sequence | Sales |
Patterns are configurable — the platform adopts the factory's existing coding standard (Form: P/S/L/G · Storage: R/C/A/F · Cosmetic type: CE, FR, GE, LO, LP, LQ, PO, MK, MS, OL, SE, SF, OR, OT).
Audit LogView all
| Time | User | Action | Module | Detail |
|---|---|---|---|---|
| 08:20:14 | John Doe | Approve | R&D | Formula WF-004 → Version 4 approved |
| 08:05:41 | Sarah White | Update | QC | BSE-014 viscosity result 8,400 cps (Pass) |
| 07:58:03 | Mike Taylor | Create | Inventory | Goods receipt GR-2405-0291 · Vitamin C LOT240515 |
| 07:41:22 | Admin | Suspend | Administration | User "Anucha K." suspended (policy) |