How to Allocate Utility Costs by Production Line in ERP—Without Overhead Guesses

Utility costs are the last thing you allocate by guesswork—and that’s the problem

When you split electricity, water or gas bills across production lines, you’re usually doing one of two things: dividing by floor space or by headcount. Neither works. Floor space ignores that a dyehouse uses ten times the water of a stitching line in the same square metres. Headcount misses that a single automated loom draws more power than five operators combined. By the time you reconcile the year-end accounts, those guesses have turned into lost margins—or worse, false efficiency gains that hide waste.

Facteno allocates utility costs by actual meter readings tied to machines, batches and shifts. That means you know which line is burning power at 3am, which pump is leaking water overnight, and which boiler is running at half load. No more spreading the bill like peanut butter.

Start with the right cost drivers—or your allocation will fail in three months

Most plants pick one of three methods to split utilities:

• Divide the total bill by the number of machines, then assign each machine an equal share.
• Use floor area to weight the split, assuming bigger lines use more.
• Allocate based on labour hours, assuming more workers mean more consumption.

All three break when production changes. A new order on Line 3 might double its output overnight, but its “share” of the bill stays the same. Or a machine fails and sits idle for a week—its allocated cost doesn’t drop, but its actual usage does. By month three, your allocations look nothing like reality.

The fix is to tie utility costs to what actually moves them. For electricity, that’s kilowatt-hours per machine per shift. For water, it’s litres per batch per dye cycle. For gas, it’s BTUs per boiler per hour. Facteno lets you set these drivers per line, then updates them automatically when meter readings change.

Illustration: Say your own scrap rate is 3 per cent on Line 1, and you reprocess scrap through a grinder that uses 0.8kWh per kilo. If Line 1 runs 500 kilos this week, its true electricity cost includes:

1. Direct production: 485 kilos × 2.1kWh/kilo = 1,018.5kWh
2. Scrap reprocessing: 15 kilos × 0.8kWh/kilo = 12kWh
3. Total: 1,030.5kWh (not the 1,050kWh you’d get by dividing the bill by machine count).

That 1.9 per cent difference adds up over a year. On a $50,000 monthly bill, it’s $11,400 misallocated—enough to hide a small efficiency gain or blame the wrong line for poor margins.

Meter readings alone won’t work—you need batch-level tracking

Even with smart meters, you’ll over-allocate if you only tie costs to machines. A loom might run for eight hours, but not all of that power goes to the current batch. Some heats idle motors, some powers conveyors for the next order, and some covers standby losses. Without linking meters to batches, you’re still guessing.

Facteno solves this by recording:

• The exact start and end time of each batch on a machine (from the production module).
• The meter reading at batch start and end (auto-pulled or manually logged).
• Any auxiliary usage (e.g., cooling water for a loom that isn’t part of the batch).

For example, if Batch #472 runs from 8am to 10am on Loom X, and the meter goes from 12,450kWh to 12,780kWh in that time, Facteno assigns 330kWh to that batch—not the 500kWh Loom X might have used over a full shift. The rest (170kWh) goes to standby, setup or the next batch.

This matters when you audit a line’s true cost. Without batch-level data, you can’t tell if a “high-cost” batch is actually efficient (using more power because it’s denser) or wasteful (idling while waiting for dye mix).

Hidden utility costs eat margins—here’s where they hide

Your electricity bill has three parts: the energy you use, the demand charge (for peak usage), and fixed fees. Water bills often include sewerage charges tied to flow rate. Gas bills may have a “capacity charge” for pipeline access. Most plants allocate only the energy portion—and miss the rest.

Here’s what you’re missing, and how to capture it:

Facteno splits these costs too. Demand charges go to the line that caused the peak (e.g., the stitching line that fired up all its motors at once). Standby losses are spread across all lines using that transformer. Fixed fees are prorated by meter count.

Illustration: If your 500kVA transformer has a $200 monthly demand charge, and Lines 1–3 share it equally, each line’s true cost includes $66.67—even if Line 1 only ran for two hours this month. Without this, Line 1’s P&L looks artificially lean.

Reconcile utility bills against ERP records—or the data will drift

Three months in, your allocated utility costs will no longer match the bills. A meter might be misread. A batch card might be logged late. A line supervisor might override the system to “balance” the month. Before you know it, your costing is 5 per cent off—and you don’t know which line is over- or under-charged.

Facteno prevents drift with:

• A monthly reconciliation screen that compares the ERP’s allocated costs to the actual bill, line by line.
• Alerts when a line’s usage spikes by more than 15 per cent from its average (flagging leaks or inefficiency).
• Audit trails showing who changed what, and when (useful when a foreman “adjusts” the numbers).

The key is to reconcile before closing the month. If Line 2’s allocated water cost is $1,200 but the bill shows $1,100, you investigate immediately—was the meter tampered with? Did someone log a batch twice? Or is the line actually more efficient than planned?

Most plants reconcile once a year. Facteno users do it weekly. The difference is knowing which lines are truly efficient—and which need attention.

What to do next week: Pick one line and prove the method

Don’t try to allocate utilities across the whole plant at once. Start with the line that:

• Uses the most power/water/gas (usually dyeing, finishing or a high-speed loom).
• Has the most variable output (so you’ll spot inefficiencies quickly).
• Is already tracked in your ERP (no manual batch cards).

Here’s the step-by-step for Week 1:

1. Log meter readings: Note the start and end readings for electricity, water and gas at shift start/end for that line.
2. Link to batches: In Facteno’s production module, attach each batch to its meter readings. Use the “auxiliary usage” field for non-batch-related consumption (e.g., boiler warm-up).
3. Run a test allocation: Compare the ERP’s split to your old method. The numbers will differ—this is expected.
4. Check for leaks: If the ERP shows Line X used 20 per cent less water than your old estimate, ask why. Is there a leak? Or was the old method overestimating?
5. Reconcile the first bill: By Week 4, run the reconciliation report and adjust any discrepancies. If the ERP’s numbers are closer to the bill, the method works.

Once proven on one line, expand to others. The goal isn’t perfection—it’s consistency. If every line uses the same rules, you’ll spot trends: which lines are getting more efficient, which are wasting utilities, and where hidden costs are buried.

Related reading: How ERP Reveals and Cuts Hidden Costs in Fabric Finishing.