COGS & Waste Analysis

flowchart TD subgraph Product_Setup ["Product R&D & COGS Setup (Admin)"] direction TB A(("1 Admin
Start R&D")) --> B(["2 Admin
Admin Conducts R&D
Determine Recipe"]) B --> C(["3 Admin
Log in to Production Panel"]) C --> D(["4 Admin
Create New Product"]) D --> E(["5 Admin
Add Ingredients/item"]) E --> F(["6 Admin
Set Quantity per item"]) F --> G[["7 System
System Calculates
Unit COGS"]] G --> SET_OPS(["7c Admin
Set Operational Coef
(e.g. Service/Tax/Packaging)"]) SET_OPS --> CALC_PRICE[["7b System
Calculate Base Price
(COGS x Ops Coef)"]] CALC_PRICE --> SET_MARGIN(["7a Admin
Set Pricing Coefficient
(e.g. 2 for 2x Markup)"]) SET_MARGIN --> CALC_FINAL[["7d System
Calculate Final Price
(Base Price x Pricing Coef)"]] CALC_FINAL --> IS_DIVIDE{"Divide/Portion?"} IS_DIVIDE -- Yes --> SET_DIVISOR(["7e Admin
Set Divisor
(e.g. /8 Slices)"]) SET_DIVISOR --> CALC_PORTION[["7f System
Calculate Portion Price"]] CALC_PORTION --> MANUAL_CHECK{"Manual Adjust?"} IS_DIVIDE -- No --> MANUAL_CHECK MANUAL_CHECK -- Yes --> SET_MANUAL(["7g Admin
Set Manual Price
(Market Override)"]) SET_MANUAL --> CALC_VAR[["7h System
Calc Variance
(Manual - System)"]] CALC_VAR --> H MANUAL_CHECK -- No --> H[["8 System
Product Master Created
(Resep & Harga)"]] H --> IS_SEMI{"Is Semi-Finished
(Intermediate)?"} IS_SEMI -- Yes --> MARK_ING["8a System
Register as Ingredient"] MARK_ING -.->|Available for Selection| E IS_SEMI -- No --> DONE_PROD((Done)) end subgraph Daily_Tracking ["Daily Operations & Usage Tracking"] direction TB I(("9 OUTLET
Daily Sales")) --> J["10 Finance
System Retrieves
Import from POS"] J --> K["11 System
Calculate Theoretical Usage
(Sold Qty x Recipe)"] L(("12 OUTLET
End of Day")) --> M(["13 Head Section
Perform Stock Opname"]) M --> N["14 System
Calculate Actual Usage
(Opening + Incoming) - (Closing)"] end subgraph Waste_Analysis ["Waste Determination"] direction TB K --> O{"15 System
Compare Usage"} N --> O O --> P(["16 System
Calculate Difference
Actual - Theoretical"]) P --> Q{"17 System
Is Difference > 5%?"} Q -- Yes --> R(["18 System
Waste/Loss Detected"]) Q -- No --> S(["19 System
Efficient Usage"]) R --> T1(["20 System
Log Item Difference"]) T1 --> T2(["21 System
Calculate Cost of Waste
(Difference x Unit Cost)"]) T2 --> T3[["22 System
Compile Daily
Waste Report"]] S --> T3 end H -.-> K subgraph Cost_Update ["Dynamic Cost Management (PO Driven)"] direction TB PO_NEW[("A Purchasing
New PO Approved
(Price Change)")] UPDATE_COST["B System
Update Ingredient
Master Cost"] CHECK_VAR{"Price Variance?"} PO_NEW --> UPDATE_COST UPDATE_COST --> CHECK_VAR CHECK_VAR -- "Increase" --> ALERT_RED((Red Dot
Alert)) CHECK_VAR -- "Stable (30d)" --> ALERT_GREY((Grey Dot
Stable)) ALERT_RED --> RECALC["C System
Auto-Recalculate
Product COGS"] ALERT_GREY --> RECALC RECALC --> DASHBOARD[["D Dashboard
Update COGS &
Show Alerts"]] end DASHBOARD -.->|Updates| G click MARK_ING call toggleIngredientPopover() click SET_MANUAL call toggleManualPricePopover() click CALC_VAR call toggleVariancePopover() classDef styleStart fill:#E3F2FD,stroke:#1976D2,stroke-width:1px,color:#1976D2 classDef styleSubmit fill:#FFFFFF,stroke:#808080,stroke-width:1px,color:#6a6a6a classDef styleDecision fill:#FFF3E0,stroke:#FF8C00,stroke-width:1px,color:#FF8C00 classDef styleError fill:#FFEBEE,stroke:#F44336,stroke-width:1px,color:#F44336 classDef styleEnd fill:#c1fabd,stroke:#35c454,stroke-width:1px,color:#0c6d12 classDef styleSystem fill:#e9ecef,stroke:#495057,stroke-width:1px,color:#495057 classDef styleLink fill:#b3e3ff,stroke:#5fb3e3,stroke-width:1px,color:#06293d class A,I,L styleStart class B,C,D,E,F,J,K,M,N,P,T1,T2,MARK_ING,UPDATE_COST,RECALC,SET_MARGIN,CALC_PRICE,SET_OPS,CALC_FINAL,SET_DIVISOR,CALC_PORTION,SET_MANUAL,CALC_VAR styleSubmit class O,Q,IS_SEMI,CHECK_VAR,IS_DIVIDE,MANUAL_CHECK styleDecision class G,T,S,T3,DASHBOARD styleEnd class R,ALERT_RED styleError class H styleLink class PO_NEW styleStart class ALERT_GREY styleSystem class MARK_ING interactive-node class SET_MANUAL interactive-node class CALC_VAR interactive-node style Product_Setup fill:none,stroke:#333,stroke-width:2px,stroke-dasharray: 5 5 style Daily_Tracking fill:none,stroke:#333,stroke-width:2px,stroke-dasharray: 5 5 style Waste_Analysis fill:none,stroke:#333,stroke-width:2px,stroke-dasharray: 5 5 style Cost_Update fill:none,stroke:#333,stroke-width:2px,stroke-dasharray: 5 5