Fill in these first
- Site type and hours: [e.g. a garment workshop, 10 machines, open 9 am to 8 pm, six days a week]
- Monthly bills: [paste rows: month, units consumed (kWh), maximum demand (kVA or kW), fixed or demand charge, energy charge, taxes and duties, total amount]
- Sanctioned or contract load: [e.g. 25 kVA]
- Time-of-day tariff, if any: [e.g. peak 6 pm to 10 pm at a higher rate, or none]
- Main equipment: [paste rows: item, count, rated power, hours used per day]
- Average outdoor temperature by month, if known: [paste, or skip]
Task
Find where the money goes on these bills and what would cut it, ranked by return.
Output format
- | Month | Units | Max demand | Fixed share of bill | Cost per unit | Change from last year |
- Effective cost per unit for the year, and how much of the bill is fixed whatever is used.
- Months where maximum demand went above the sanctioned load, with the likely penalty.
- Estimated usage by equipment from the list given, as a share of total units, checked against the billed units.
- Savings list: | Action | Units saved per month | Money saved per month | Rough cost | Payback in months |, covering load shifting out of peak hours, demand control, equipment replacement and power factor if it appears on the bill.
- A one-paragraph summary for the owner.
Rules
- Use the tariff figures on the bills, not assumed national rates.
- Mark every equipment estimate as an estimate and say how far it differs from the billed units.
- Never recommend changing the sanctioned load without noting that the utility must approve it.






