The short answer
A material variance that arrives as one number has no owner. Split it into price, mix, usage and yield and each part points at a different person: purchasing, the formulator, the line supervisor and the process owner. ManufacturingFlow 365 keeps the four apart and puts a cost sheet behind every batch.
Why one number hides the problem
A blended product comes in 685 over standard on materials. The controller calls a meeting and everyone arrives with a theory. Purchasing says the market moved. Production says the formula was followed. Quality says a filter blinded early. All three can be right, because one material variance is really four different events, happening in different places and fixed by different people.
The arithmetic is old and not the hard part. The hard part is that when a process batch is costed as if it were one item from one bill of materials, the difference tends to land in a single bucket and stay there. Finance sees the total. Nobody can see whose it is.
The cure is to ask four separate questions of every batch, and to name an owner for each answer.
The four variances in plain words
Each one answers a different question about the same batch.
| Variance | The question it answers | Who should own it | Typical causes |
|---|---|---|---|
| Price | Did we pay more or less per kilo than the standard? | Purchasing | Supplier increase, spot buy, freight |
| Mix | Did we use the ingredients in a different proportion from the formula? | Formulator or shift lead | Swapping to a dearer ingredient, rounding to whole bags |
| Usage | Did we put more material into the vessel than the formula called for? | Line supervisor | Over-dosing, spillage, scale drift |
| Yield | For the material we put in, did we get as much good product out as planned? | Process or production manager | Evaporation, trim, filter loss, product left in pipes |
Usage and yield are the pair people confuse. Usage is about what went in. Yield is about what came out. A line can weigh every ingredient perfectly and still lose product in the dryer, and the reverse is just as common. Finance teams define the split slightly differently, so settle your own definitions before you compare one plant with another.
A worked batch
Illustrative figures chosen to show the arithmetic; they are not customer data and not from our test runs.
The standard batch is 750 kg of ingredient A at 2.00 per kg and 500 kg of ingredient B at 4.00 per kg. That is 1,250 kg in, costing 3,500, for an expected 1,000 kg out (an 80% yield). The standard cost is therefore 3.50 per kg of finished product.
The actual batch used 700 kg of A bought at 2.30 and 600 kg of B bought at 4.00. That is 1,300 kg in, costing 1,610 plus 2,400, which is 4,010. It produced 950 kg. The standard cost of 950 kg is 3,325, so the batch is 685 over standard. Here is where the 685 comes from.
| Variance | Working | Amount (unfavourable) |
|---|---|---|
| Price | A cost 0.30 more per kg than standard, on 700 kg. B was bought at standard. | 210 |
| Mix | The 1,300 kg actually used, at standard prices, costs 3,800 (1,400 for A, 2,400 for B). The same 1,300 kg in the formula's 60/40 split would be 780 kg of A and 520 kg of B, costing 3,640. | 160 |
| Usage | 1,300 kg went in where the formula called for 1,250 kg. The extra 50 kg at the formula's average of 2.80 per kg. | 140 |
| Yield | 950 kg came out where 1,000 kg was expected from the planned input. The 50 kg shortfall at 3.50 per kg. | 175 |
| Total | 210 + 160 + 140 + 175 | 685 |
Check the total another way: actual cost of 4,010 less the standard cost of the output, 3,325, is 685. The two routes agree.
Read the result as an agenda
Of the 685, only 210 is a purchasing conversation. The other 475 happened inside the plant: 160 in how the ingredients were proportioned, 140 in how much was weighed in, 175 in what came out. Presented as one figure, this batch starts an argument with the supplier. Presented as four, it starts three smaller and more useful conversations, one at the formulation desk, one on the line and one with whoever runs the dryer.
It also shows why the order of the questions matters. Price is judged first, at actual quantities. Mix is then judged on the quantity actually used. Usage and yield come last, because they ask about quantity alone. Change the order and the same 685 divides differently, which is another reason to fix the method once and keep to it.
Materials are not the whole batch
Most process batches carry costs that no ingredient list shows: steam in a drying stage, water in a wash, time in a reactor. If those sit in a general overhead pool, the batch looks cheaper or dearer than it really was and the variances above are measured against an incomplete standard.
ManufacturingFlow 365 costs process drivers such as steam or water, carries stage costs, and works to a net standard cost, so the standard and the actual are built on the same footing. Where a batch makes more than one output, joint cost allocation decides how that cost is shared, and the co-product, by-product or waste question decides what is shared at all.
Giving each variance an owner
Naming owners is simple to write down and slow to do. A routine that works:
- Purchasing reviews price variance by ingredient, monthly, and is the only team asked about it.
- The formulator reviews mix variance per batch, because a mix variance is often a decision someone made, such as using an approved substitute.
- The line supervisor reviews usage per shift, where the cause is usually a person, a scale or a habit.
- The process owner reviews yield by stage, where the cause is usually equipment or conditions.
- The controller reviews the cost sheet and chases the largest of the four, not the oldest.
Start with the largest. In the batch above that is the price variance, but the plant owns more than half of the total between the other three.
In Business Central
- Separate price, mix, usage and yield variances in ManufacturingFlow 365, so the four are not folded into one.
- A batch cost sheet for every batch.
- Process drivers such as steam or water, and stage costs.
- A net standard cost to compare the batch against.
- Actual-cost allocation of joint cost when a batch has several outputs.
- With MESFlow 365 installed, the materials an operator records against an operation, so actual consumption comes from the floor rather than from an end-of-day entry.
Limits
The worked batch above is arithmetic, not output from the app. ManufacturingFlow 365 is designed from 63 identified gaps, of which 27 are implemented and 36 partly. Exports and some planning pages have not been run, so ask to see the specific variance report and cost sheet you would use. Both apps have been run in a UAT sandbox with demo data and no live customer is recorded. Conventions for splitting usage from yield differ, so check the definitions against your own finance policy.
See it on your process
Bring one real batch and its standard. We will walk through where the variance falls: book the dairy batch cost sheet scenario.
Keep reading: joint-cost allocation, four ways and co-product, by-product or waste.