ERP Consulting: The Retailer Who Discovered His “Best” Store Was Actually Losing Money

Ray ran a clothing retailer with three stores in neighboring towns. Every month he did the same ritual: he added each store’s sales, subtracted its rent and staff, and declared Store A the winner. It made $38,000 a month, while Store C limped along at $9,000.

The problem was that his simple math missed nearly everything that actually costs money. When ERP Consulting mapped the real expenses, the results turned his ranking upside down — Store A was losing $4,000 a month once the true costs landed on it, and Store C quietly made $11,000.

Why the simplest numbers lied so badly

Ray’s stores were far from independent. Staff from Store B regularly covered shifts at Store A, and their time was never recharged. Inventory flowed between all three stores almost weekly, but the transfers weren’t recorded — so Store A kept credit for goods it had sold months ago. Then there were the shared costs: the district manager’s salary, the delivery van, the marketing spend, and the software fees were all sitting in the “general” pile, never allocated to anyone.

The ERP Consulting review found that 38 percent of Store A’s apparent profit came from those unallocated costs and unreported transfers. Accounting for them changed every store’s story.

What a true per-store profit statement looks like

  • Every hour a Store B employee works in Store A gets charged to Store A’s labor line that same week.
  • Every unit moved between stores is logged as an inter-store transfer with the original cost attached, so profit follows the product to the store that actually sells it.
  • Shared costs — manager salary, van, advertising, software — are split by each store’s share of revenue, calculated once a month and reviewed by the owner in ten minutes.

With those three rules in place, the first true statement took about six hours to build. The second month took ninety minutes because the data collection was already happening.

The move that changed everything

Once Ray could see the real numbers, he made two decisions in a single week. He moved his best-selling product line from Store B to Store C and cut Store A’s hours, which saved $3,200 in labor without hurting sales. By the end of the quarter, Store C was the profitable anchor, and the combined profit of all three stores was up 22 percent — with zero new inventory bought.

Here’s your ten-minute test: take a store that looks strong and ask what costs are allocated to it. If the answer is “just rent and staff,” you’re seeing the same illusion Ray saw. Run a rough allocation of every shared dollar and see if your best store is still your best store. ERP Consulting can walk you through building a per-store statement, but the first step is deciding you want to see the truth.