Finance

Calculating cost and margin for each order

Many companies know their total revenue but not which orders make money and which lose it. How to calculate cost and profit per order to make the right decisions.

Mr. Dan
Mr. Dan10+ years of export experience

The article on calculating FOB prices helps you quote. This one helps you check after the order is complete: how much did you really make?

The real cost of an order

  • Raw materials: actual consumption and actual purchase prices.
  • Direct labour.
  • Allocated production overheads: electricity, water, depreciation, factory management.
  • Packaging and labels.
  • Logistics: inland transport, port charges, freight (for CFR and CIF) and insurance.
  • Documents, testing, certification and C/O.
  • Selling costs: commissions, samples, travel and allocated trade fair costs.
  • Finance costs: bank fees, interest and exchange-rate differences.
  • Unexpected costs: claims, discounts and demurrage.

Analysis

  • Compare the real cost with the cost you estimated when quoting. Where was the difference?
  • Calculate gross and net margins by order, customer, product and market.

Decisions

  • High-margin, steady customers: prioritise and grow them.
  • Low-margin but high-volume customers: renegotiate or cut costs.
  • Customers that regularly lose money: adjust prices or terms, or stop working with them.
  • High-margin products: push them harder.

Tools

A simple spreadsheet with a standard template for each order is enough to start. As you grow, consider business management software.

Advice

Do this consistently for every order. After a year, you'll have valuable data to quote more accurately and focus on the customers and products that really make money.