A AION Academy

Lesson 5 of 5 · 6 min read

Cost flow & GL impact

The complete raw-material-to-finished-goods cost flow, the variance reports that tell you where margin is leaking, and the ROI of running P2M on real data instead of estimates.

The cost flow, end to end

Purchase Receipt


Raw Material Inventory (1200)
   │ [Material Issue]

Work in Process (1210)
   │ [Completion at standard cost]

Finished Goods Inventory (1220)
   │ [Shipment to customer]

Cost of Goods Sold (5100)

Four inventory buckets. One cost, flowing through. At each transition, AION’s SLA engine posts a balanced journal entry. The trial balance reflects the physical reality of your shop floor, in real time.

Every account’s role

AccountWhen it growsWhen it shrinks
1200 Raw Material InventoryPurchase receipt postsMaterial issued to a job order
1210 Work in ProcessMaterial issued to a jobCompletion posted (FG produced) or scrap posted or job closed
1220 Finished Goods InventoryJob order completionCustomer shipment (triggers COGS via O2C)
5100 Cost of Goods SoldCustomer shipmentRare (returns)

Three manufacturing variance accounts sit alongside:

AccountMeaning
5200 Mfg Variance — ScrapProduction waste (bottles failed QA, batches rejected)
5210 Mfg Variance — YieldDifference between planned and actual output
5220 Mfg Variance — PriceRaw material cost drift (actuals vs. standard)

These are your margin leakage detectors.

Reports AION ships

ReportAnswersMenu
Job Order Cost SheetWhat did this batch actually cost?Manufacturing → Reports → Cost Sheet
Production Variance AnalysisWhere is margin leaking?Manufacturing → Reports → Variance Analysis
Yield Trend by ProductIs our yield getting better or worse?Manufacturing → Reports → Yield Trend
Scrap Report by Line / ShiftWhere does scrap concentrate?Manufacturing → Reports → Scrap
WIP AgingAny open jobs that should have closed?Manufacturing → Reports → WIP Aging
Formula Cost Roll-upWhat does this SKU’s cost look like at today’s prices?Manufacturing → Reports → Formula Cost
Batch TraceabilityWhat went into this FG lot?Inventory → Lots → Where Used
Capacity UtilizationAre we using Line 2 efficiently?Manufacturing → Reports → Capacity

KPIs to watch

KPITargetWhere
Yield %> 96% (category-specific)Production Variance Report
Scrap %< 2%Scrap Report
WIP turnoverDays WIP sits openWIP Aging
Unit cost trend by SKUStable ± 2% month over monthFormula Cost Roll-up
Material price varianceNear zero (if rising, renegotiate with supplier)Variance Analysis
Capacity utilization75-90%Capacity Report
Recall trace time< 1 minuteTest: pick any lot, click Where Used

The real-dollar ROI

Before AION (typical 20M SAR factory)

  • Margin reporting is roughly right at best; in F&B the blind spots (yield, scrap, FX variance) typically hide 3-8% of gross margin erosion
  • On 20M SAR revenue at 35% gross margin = 7M SAR gross profit
  • Missing 5% of that = 350,000 SAR of margin you don’t see
  • Recall trace time: 4-8 hours per query (using cold storage receipts + paper records + tribal knowledge)
  • Formula changes: verbal, not documented; QA can’t defend a batch under audit

After AION

  • Variance reports show exactly where the 3-8% goes — and your team can fix what they can now see
  • Typical recovery after 6 months of tight variance monitoring: 2-4% gross margin — worth 140-280K SAR/year
  • Recall trace time: < 1 minute
  • Formula changes: versioned, approved, documented; audit-defensible

Typical recurring benefit: 200,000+ SAR/year in recovered margin, plus the defensive value of audit-ready batch records (priceless when an auditor or customer actually asks).

What you should do now

  1. Do the mango batch lab in Lesson 4 if you haven’t.
  2. Open the Production Variance Analysis report in the demo and look at what a real variance analysis looks like.
  3. Open the Formula Cost Roll-up for mango juice 500ml — see the unit cost build up from raw materials through packaging.
  4. Think about your own top 3 SKUs — what’s your unit cost today? Where might the 3-8% be hiding?

The next course — Record-to-Report — covers the financial close cycle, where these production costs, the sales from O2C, and the payables from P2P all roll up into a monthly trial balance.