SCG Decor

Governed Copilot & Reasoning

Audit-Ready AI · Certified Citations, Math Transparency & Data Lineage

Certified
Entity SCGCE ThailandCutoff 16 Nov 2027 09:00 BKKMode Certified Financial (SAP CORE v3)sha256:4a8b9c...

Explain the -฿2.4M energy variance in Wall Tile Saraburi and break down the calculation formula.

09:04 · Finance Controller

AI Analysis · Grounded in Certified SAP CORE & Odoo MES

Confidence 99.4%Audit Ready

Natural gas unit price surged 34.6% during daytime peak hours (10:00–18:00) alongside +8.8% volume.

Formula

Total Energy Variance = (Actual MMBtu × Actual Rate) − (Budget MMBtu × Budget Rate)

Rate Variance

+฿1,165,500

Volume Variance

+฿1,234,500

Total Adverse

฿2,400,000

  1. 1GL 512000 posted actual gas cost above budget at cutoff
  2. 2Kiln 2 meter logged 185,000 MMBtu, 8.8% above plan
  3. 3Peak-hour tariff applied to 71% of consumption, driving the rate effect
  4. 4Rate + volume reconcile to ฿2,400,000 with zero residual

09:04 · Certified answer · citations verified against certified sources