Matvey Zakharov
RU

Nobody knows which products or jobs lose money

Costs are incomplete or aggregated, so loss-making work is discovered late or not at all.

One job, two cost cards

A small urgent run, priced at its estimate times two. Before, the card holds the estimate; after, the actual costs of the same job, known after it was done, in days: 2 to 4.

Before
Cost cardestimate
Small urgent run
  • MaterialsRUB 4,800
  • SubcontractorsRUB 3,200
CostRUB 8,000
PriceRUB 16,000
Margin50%
After
Cost cardactual costs
Small urgent run
  • MaterialsRUB 5,300
  • SubcontractorsRUB 2,900
  • WorkRUB 6,600
  • RedoingRUB 3,600
  • DeliveryRUB 1,600
CostRUB 20,000
PriceRUB 16,000
Margin-25%
The price is the same on both cards: what the job was sold for.

Loss-making jobs taken before anyone knew

Every small urgent run of the year, in the order taken. Loss-making before: 56 of 65, none of them seen as such. After, the price rule was fixed; jobs taken before the fix: 3.

Before
Loss-making: 56 of 65. The kind's margin for the year: -16%.
After
Loss-making: 3 of 65. The kind's margin for the year: 18%.
Lost moneyMade money
A domino is a job; a fallen one lost money. After the change, each job's actual cost is known within days.
SOLUTION

Job/product profitability control

  1. I close the actual cost of every job: materials, subcontractors, hours, redoing and delivery.
  2. Each job's actual margin is known days after it is done, and a kind of job that keeps losing money is flagged.
  3. The price rule of a flagged kind is corrected from its full cost.

What an engagement produces

  • Actual cost and margin of every job
  • Estimate against actual, by kind of job
  • Alerts for loss-making jobs and kinds of job
  • Price rules corrected from full cost
  • Setup in your tools, or oversight if you set it up yourself

Rules, thresholds, scripts and automation logic are engagement deliverables and are not published here.

Find out whether this is actually your constraint.

Explore another problem