Hope someone can help me understand this. Xcel Energy in Sioux Falls is pro-rating a 25-day billing cycle by multiplying the demand charge by 25/30 instead of dividing. So instead of reducing the charge for the shorter period, they're actually increasing it. A $3,000 demand charge becomes $2,500 instead of the expected $2,500. Wait, that doesn't make sense. Let me recalculate... Actually, $3,000 × 25/30 = $2,500, but $3,000 × 30/25 = $3,600. I think they're using 30/25 instead of 25/30. Has anyone seen utilities get the proration fraction backwards like this?
Xcel proration calculation seems backwards
Kent, yes that's exactly backwards! The proration should reduce charges for shorter periods, not increase them. Xcel should be using (actual days)/(standard days) not the reverse. So 25/30 = 0.833, meaning the customer should pay 83.3% of the standard demand charge, not 120%. This is a basic billing system error that's costing customers serious money.
Diane, that's what I thought too. The customer is getting charged 120% instead of 83% - that's a massive difference. On a $3,000 monthly demand charge, they're overpaying $1,100 per month. I've documented three months of this backwards calculation. How do I escalate this to someone at Xcel who actually understands mathematics?
Kent, this is a billing system programming error that probably affects multiple customers. Contact Xcel's industrial customer service manager directly - don't waste time with regular customer service. Also file a complaint with the South Dakota PUC immediately. This kind of systematic overcharging is exactly what utility regulators exist to prevent.
Sandra's absolutely right - this needs regulatory attention ASAP. Document everything with screenshots of the bills showing the incorrect calculations. We had a similar billing system error at MLGW where the programmers coded the formula backwards. It took regulatory pressure to get them to fix it and issue retroactive credits. Don't let Xcel brush this off as a "minor calculation adjustment."
Filed the PUC complaint yesterday with detailed calculations showing the error. Also reached out to Xcel's industrial services manager who seemed genuinely surprised by the backwards formula. He's escalating to their billing systems team for review. The customer has been overpaying about $1,100/month for three months, so we're looking at $3,300 in credits if this gets resolved correctly.
Kent, make sure they check for other customers with similar short billing periods. If their system is programmed backwards, every customer with cycles under 30 days is getting overcharged. This could be a huge settlement if it's affecting hundreds or thousands of accounts across their territory.
Diane, that's exactly what I'm pushing for. The billing systems manager admitted they found the programming error and it does affect all customers with non-standard billing cycles. They're now reviewing their entire customer base to identify affected accounts. Could be looking at millions in overcharges if this has been running for months or years.
This is why systematic billing audits are so important. One customer's complaint uncovered what sounds like a territory-wide billing error. Make sure you get credit for discovering this - utilities sometimes try to minimize the role of auditors in finding their mistakes. Document your involvement in case there's a settlement or regulatory action.
Great advice Sandra. Xcel's preliminary review found over 2,800 accounts affected by the backwards proration formula, dating back 14 months. Total overcharges estimated at $4.2 million. They're working on automated credit processing and have agreed to pay interest on all corrections. The PUC is monitoring the remediation process closely.
Kent, that's an incredible find - $4.2 million in overcharges from one backwards formula. This is exactly why our profession exists. Utilities have hundreds of complex calculations and when they get one wrong, it can affect thousands of customers. Make sure you document this case study for future reference. It's a perfect example of how billing system errors compound over time.
Update: Customer received their $3,300 credit plus $180 in interest yesterday. Xcel is also implementing new quality control procedures for billing system updates to prevent similar errors. The PUC praised our documentation and said it significantly accelerated their investigation. Sometimes one sharp-eyed audit can benefit thousands of customers.
Fantastic outcome Kent! This case should be required reading for new auditors. Shows how important it is to question calculations that don't make intuitive sense. A shorter billing period should never result in higher charges, but billing systems can be programmed incorrectly. Always trust your instincts when something seems backwards.
Diane's absolutely right. This case perfectly illustrates why we always need to verify that proration calculations follow logical principles. Kent's persistence in questioning the backwards formula saved customers millions of dollars. It's a reminder that even basic mathematical errors can have massive financial impacts when applied systematically across a utility's customer base. Well done!