G Gaia

Switch factory

CYTO-11 — Balakong Jaya CTSB CYTO-29 CTSB CYTOWELL-54 — Taming Jaya PIC/S CTWSB CYTOCNGZ-602 — Guangzhou CTCNGZ

Only factories you are granted appear here (Filament tenant menu).

Leo Lim

leo@navi.my · Owner / Admin

Profile settings Change password

Theme

Sign out
RetailSellR&DMakeBuyStockPlanItemsGMPAdminInsights
Requests Formulations Lab trials
← Formulations / F-0007 — Collagen Peach Boost

F-0007 — Collagen Peach Boost

Stability v3 · current
enabled when Status = Approved

Materials per serving · v3

Same variants + item pool as production BOMs; costs ride the live moving-average. Promote to BOM copies these lines to recipe rows scaled per-serving → per-unit.
Material Qty per serving UoM Avg cost MYR / uom Cost per serving
Marine Collagen 11,000 mg 0.00007 0.77 MYR
Apple Flavor CK-1647 · replaced Peach Flavor in v3 450 mg 0.0001 0.05 MYR
Ascorbic Acid ITS-Luwei 300 mg 0.000036 0.01 MYR
Stevia 120 mg 0.00045 0.05 MYR
Maltodextrin carrier 3,130 mg 0.00031 0.96 MYR
Est. cost / serving (15 g) 1.84 MYR

Versions

GMP trail · read-only
Ver Date Changed by Change note
v3 current 2026-06-25 Jason Peach Flavor → Apple Flavor CK-1647 after TRL-26-013 bitter fail
v2 2026-05-30 Jason Ascorbic dose down 400→300 mg; stevia up
v1 2026-05-12 Jason Initial draft from customer brief RND-2026-00007

Version on every post-trial edit — NPRA/GMP wants the trail even when the paper BMR is the official record. Versions are immutable.

Lab trials · 4 trials

Trial # Ver Result By Date
TRL-26-014 v3 Pass — sensory 8.2/10 Jason 2026-07-01
TRL-26-013 v2 Fail — flavor bitter at pH 3.8 Jason 2026-06-20
TRL-26-008 v1 Fail — dissolution slow Jason 2026-05-22
TRL-26-006 v1 Fail — too sweet Jason 2026-05-14

Info

Code
F-0007
Serving
15 g
Target product
Collagen Drink 15g x 15 sachets
Owner
Jason
Updated
2026-07-02
R&D request
RND-2026-00007
Quote
Q-2026-031

Status workflow

  • Draft
  • Lab trial
  • Stability · current

    stability hold started 2026-07-02 — 4 weeks

  • Approved
  • Promoted to BOM

Approved requires a Pass trial on the current version + stability sign-off. Archived possible at any point.

Promote to BOM

Copies formulation_lines → recipe rows on the target variant, scaled per-serving → per-unit. The formulation stays immutable as the R&D record; the BOM lives its own life. Stores formulation_version_id so production traces back.

Project Gaia — static mockup in Filament v3 idiom. No backend. F-0007 v3 worked example — ties to rnd-formulations.html row, TRL-26-013/014, RND-2026-00007 and Q-2026-033 (snapshot 2026-07-07).

Formulation detail — field manifest

FieldFilament componentTypeSourceFK target
Formulation headerTextEntry / badge (ViewRecord)mixedstored: formulations — code, name, target_item_id nullable, serving_qty, serving_uom, owner_user_id, rnd_request_id nullable, status enumitems.id · users.id · rnd_requests.id
VersionsRelationManager (read-only table)child tablestored: formulation_versions — version, created_at, changed_by_user_id, change_note. Immutable — a new row on every post-trial edit (GMP/NPRA trail)formulations.id · users.id
Materials per servingRelationManager (formulation_lines)child tablestored: formulation_lines — variant_id, qty_per_serving, uom (admin-locked units); avg cost + cost/serving derived live from the inventory moving-average. SAME variants pool as production BOMsformulation_versions.id · variants.id · units
Lab trialsRelationManager → LabTrialResourcechild tablestored: lab_trials — code, formulation_version_id, result enum (Pass / Fail), sensory_score, by_user_id, trial_date, notes. Trial consumption is NOT stock-tracked (founder decision)formulation_versions.id · users.id
Status workflowBadge + Advance-status Actionenumstored: formulations.status — Draft → Lab trial → Stability → Approved → Promoted to BOM / Archived. Stability→Approved gated on a Pass trial on the current version + stability sign-off—
Promote to BOMAction ->disabled(fn: status != Approved)actioncopies formulation_lines → recipe rows on the target variant (per-serving → per-unit) and stores formulation_version_id on the BOMvariants.id · recipes

Engine notes

  • ViewRecord page of FormulationResource — the worked-example read screen for F-0007 v3.
  • Versions are immutable: every post-trial edit writes a new formulation_versions row; the prior lines/costs stay frozen (NPRA/GMP trail even though the paper BMR is the official record).
  • Promote to BOM is the ONLY bridge from R&D into production BOMs: it copies formulation_lines → recipe rows scaled per-serving → per-unit and stamps formulation_version_id so production traces back. Enabled only when status = Approved.
  • Trial consumption is not stock-tracked: costs ride the live moving-average; no reservation, no movement (founder decision).