Let me show you a quote from a furniture maker’s invoice: a dining table listed at $480, and a material cost of $210. The owner thought he was making a comfortable 56 percent margin. He was actually losing money on every single table, and had been for 14 months.
Why the textbook margin formula fails on the workshop floor
The owner only counted the wood, glue, and lacquer. He forgot that the workshop’s rent, the electric bill, machine depreciation, and a fair share of the 14 workers’ wages all had to sit somewhere on that table.
Here’s the math that changed his mind. When the ERPNext Consulting team ran a product-level cost check, they found the true total cost per table was $469. That left 11 dollars of gross profit before freight — and freight cost 18. So every table shipped was a small donation to the customer.
Two product lines were subsidizing six unprofitable ones. The owner had assumed a busy workshop meant a healthy workshop. Not true.
The shift that saved the business
ERPNext Consulting turned his production job cards into live costing records: which order consumed which materials, how many labor hours the table actually took, and how much overhead each job should absorb. The numbers that emerged changed what he sold and what he stopped selling.
- He dropped the entry-level table line entirely and raised the mid-range price by 14 percent, losing volume but gaining nine points of margin per unit.
- We set a simple rule: any new product must show a projected 25 percent margin in the costing sheet before it goes to a customer, or it never leaves the workshop.
A question of habit, not software
Within 90 days the shop cut its monthly operating loss from $6,400 to a profit of about $2,100, on the same number of tables shipped. Same workers, same machines, same customers. Different pricing, one honest costing view, and someone who asked: what does this product actually cost?
If you’re a manufacturer, your profit sits in product-level data. Find the product that loses with love — a price increase of 8 percent on your worst product can do more for your cash than a 20 percent volume push on your best one.