A stock ticker board of green and red numbers
Plex · FP&A · Hub

AI Agents for
Plex FP&A

A plant running at plan with four bad work orders looks identical to a plant running badly across the board. The average cannot tell you which you have.

Key takeaways
  • Report the variance distribution and the named tail, not the plant average. The average starts the argument and the tail ends it.
  • A stale standard dominates every variance and hides the operational signal underneath. Five comparisons per period find it, and they are the work that gets skipped.
  • In a worked 184,000 variance on one part family, 75,000 was an out of date bill of material and an unrevised routing. That is engineering maintenance, not plant performance.
  • Check bill and routing effective dates against the order release date before attributing usage variance to production. Skipping it is how a plant manager stops trusting finance.
  • An agent can build the entire cost model. Volume is a commercial judgement and it is not in the finance system.

AI agents for Plex FP&A build the manufacturing variance distribution from operation level records rather than from a monthly summary, name the work orders carrying the unfavourable tail, and split each one into usage, rate, labour, absorption and scrap components that add back to the reported total. ChatFin checks bill of material and routing effective dates against the order release date before attributing anything to production.

That last check is the difference between a report a plant accepts and one it disputes. In a worked quarter, 75,000 of a 184,000 unfavourable variance came from a bill of material never updated after a process change and a routing never revised after the line was rebalanced. Both look exactly like overuse in a total, and the plant manager was right to argue.

PlexManufacturing financeFP&AStandard costingWork order varianceScrapAbsorptionForecastingAI agents for finance
01

A plant average tells you nothing. The distribution tells you everything

Manufacturing FP&A reports averages because that is what a summary export produces. A plant running at plan with four bad work orders looks identical to a plant running badly across the board, and the two need completely different responses.

Rank work orders by absolute variance, not percentage. A 40 percent variance on a small order is noise. The tail carrying real money is the list.
Most unfavourable variance sits in a small number of orders. Identifying them is the whole of the analysis and it is mechanical.
Split each order into its components. An order bad on usage and fine on labour goes to a different person than the reverse.
Compare the distribution period to period. A widening tail is a process drifting. A shifting mean is something else entirely.
Report the distribution and the named tail, not the plant average. The average is the number that starts the argument and the tail is the number that ends it.
In ChatFin

ChatFin builds the variance distribution from operation level records rather than from a monthly export, and names the orders in the tail with their movements attached.

02

A stale standard drowns every other signal

Standard costing only works if the standard is close to reality. When it is years old, every variance is dominated by the gap between the standard and current cost, and the operational signal underneath is invisible.

SymptomWhat it usually meansCheck
Variance stable and large every periodThe standard is wrong, not the operationCompare the standard to the trailing actual by part
Purchase price variance always unfavourableStandard set before the last renegotiationContract price against standard on every receipt
Labour variance always favourableRouting hours above actualRouting against actual hours by operation
Absorption swinging with volumeA volume question, not a spending oneApplied against actual spend and actual volume separately
One part family dominatingA single stale standardVariance by part, ranked

None of that needs a model. It needs someone to run five comparisons every period, which is exactly the kind of work that gets skipped when the close is late.

In ChatFin

ChatFin runs the standard against trailing actuals by part every period and reports the parts where the two have drifted apart. Resetting a standard is a decision, and it stays with the cost accountant.

03

A worked plant variance, 184,000 on one part family

One part family carries 184,000 of unfavourable variance for the quarter and the plant manager disputes it, which is the normal state of this conversation. Rebuilt from work orders it is five things.

ComponentAmountWork ordersEvidence
Scrap at one operation78,00034One operation, one reason code, one shift pattern
Bill of material out of date44,00061Issue quantity consistently above the bill since a process change
Routing hours below actual31,00058Routing never updated after the line was rebalanced
Substitution to a higher cost part26,0009Documented substitutions during a supply shortage
Orders left open with residual cost9,0004Production complete, order not closed
Total184,000 Adds back to the reported variance

The bill of material and the routing together are 75,000 and they are engineering maintenance rather than plant performance. The plant manager was right to dispute the number and had no way to show it.

A stock ticker board of green and red numbers
Two of the five components are records that were never updated after a process change.
04

Costing scrap where it happened, not on average

Scrap is usually reported as a quantity and a percentage. Neither is a number finance can prioritise with, and both hide the thing that matters.

Where in the routing matters more than how much. A part scrapped at the first operation has lost its material cost. The same part scrapped at the last operation has lost material plus every hour applied since. Same quantity, different cost.
Reason codes are captured and mostly unused. Plex records them at the event. Costing by reason code turns a total into a ranked list of specific problems.
Rework recorded as production overstates output. It also inflates apparent material usage, and both errors come from one recording decision on the floor.
The containment event has a cost nobody assembles. Sorting, extra inspection, expedited freight and premium replacement material are each recorded somewhere and almost never added up against the event.
Rank reason codes by cost, not by frequency. The most frequent reason code is rarely the most expensive one, and the plant usually already knows about the frequent one.
In ChatFin

ChatFin costs each scrap event at the operation where it occurred and ranks reason codes by cost. That ranking is the output a plant can act on.

05

Forecasting a manufacturer, and the part that is real

The mechanical half of a manufacturing forecast is assembly and an agent is good at it. Demand is not in the finance system and never will be.

TaskAgentWhy
Cost per unit by part from actualsStrongArithmetic over a real history
Material cost at current contract pricesStrongContracts and receipts it can read
Absorption at a given volumeStrongMechanical once volume is supplied
Committed material on open ordersStrongOrders and receipts, calculable exactly
VolumeNoA commercial and operational judgement
Which scenario to plan toNoThe CFO's call, never a default

Given a volume assumption from someone who owns it, everything else can be built and traced. The honest framing is that an agent produces the cost model and a person supplies the demand.

In ChatFin

ChatFin labels every input as observed or supplied. A volume assumption inherited without anyone noticing is how a manufacturing forecast becomes confidently wrong.

06

Where this underperforms on Plex

Three, and all three are prerequisites.

Standards are years old. Every variance is then dominated by the stale standard. Resetting standards comes before analysis, not after it.
Bills of material and routings are not maintained. An agent comparing actual to a bill nobody updates attributes engineering drift to production every period, and the plant will rightly reject it.
Finance reads a monthly summary rather than transactions. A summary cannot be traced back to work orders, so no variance can be explained from it whatever tool reads it.
In ChatFin

ChatFin checks bill and routing effective dates against the order release date before attributing usage variance to production. Skipping that check is the fastest way to lose a plant manager's trust.

Deeper in Plex FP&A

Three use cases sit under this hub, in build and shown rather than linked.

Worked on this page
Natural language querying of finance data · Financial forecasting · Financial modeling

Covered as sections here
Variance analysis · Standard cost review · Scrap analysis · Absorption · Budget vs actual · Management commentary

Questions manufacturing finance teams ask first

Why does the plant always dispute the variance number?

Usually because a real part of it is not their doing. In a worked example of 184,000 of unfavourable variance on one part family, 44,000 came from a bill of material that was never updated after a process change and 31,000 from a routing never revised after the line was rebalanced. Both are indistinguishable from overuse in a total. ChatFin checks bill and routing effective dates against the order release date before attributing anything to production.

How do you tell whether the standard cost is the problem?

Run five comparisons every period. Standard against trailing actual by part, contract price against standard on every receipt, routing hours against actual hours by operation, absorption against actual spend and actual volume separately, and variance by part ranked. A variance that is stable and large every period is a standard problem rather than an operational one. None of that needs a model, it needs somebody to run it when the close is late.

Can an agent forecast a plant's cost?

It can build the entire cost model. Cost per unit by part from actuals, material at current contract prices, absorption at a given volume and committed material on open orders are all mechanical and traceable. Volume is not in the finance system and never will be. ChatFin produces the cost model and labels every input as observed or supplied, so a volume assumption is never inherited by accident.

How ChatFin works in Plex FP&A

One disputed average becomes a named tail with owners.

ChatFin reads production at operation level, builds the variance distribution rather than the average, and names the work orders carrying the unfavourable tail with their movements attached.

It separates engineering causes from plant performance, runs the standard against trailing actuals by part every period, and posts nothing.

Bring one quarter of plant variance the plant disputes. The comparison takes an hour.

Book a demo
AM
Ashok Manthena
CEO and co founder, ChatFin

Ashok Manthena is the CEO and co founder of ChatFin, an AI agent platform for enterprise finance that runs across NetSuite, Acumatica, JD Edwards, SAP and Dynamics 365. He works with CFOs and controllers on governed automation of the close, payables, receivables and reporting. Connect on LinkedIn.

Image credits. Header photograph: a stock ticker board of green and red numbers, sourced from Pexels and used under the Pexels licence.
All images are served from the Pexels content network. No third party product screenshots, vendor logos or licensed media are used on this page.
Get started

Bring the variance the plant disputes.

We will rebuild it work order by work order through ChatFin, split engineering causes from production ones, and show the movements behind every line.

✓Distribution and named tail, not a plant average
✓Bill and routing dates checked against order release
✓Standard tested against trailing actuals by part
Request a demo
Confidential & private