Example: Nordhavn Engros A/S

An invented wholesaler with about DKK 96 million in revenue. The page shows the kind of dashboard a client is handed.

The company does not exist, and no figure comes from a real client. Every figure is computed from the same dataset, so they agree with each other.

Revenue
DKK 96.0m
▲ 8.6 % versus last year
Gross margin
26.6 %
+0.7 pp versus last year
Inventory value, at year end
DKK 17.8m
▼ 9.2 % versus last year
On-time delivery
93.2 %
−1.8 pp against the 95% target
Revenue and gross margin
0.02.55.07.510.0 Jan: DKK 7.4mFeb: DKK 7.1mMar: DKK 8.3mApr: DKK 8.0mMay: DKK 8.6mJun: DKK 8.2mJul: DKK 5.9mAug: DKK 7.6mSep: DKK 8.9mOct: DKK 9.3mNov: DKK 9.6mDec: DKK 7.1m Jan: 25.8 %Feb: 26.1 %Mar: 26.4 %Apr: 26.0 %May: 26.9 %Jun: 27.1 %Jul: 25.2 %Aug: 26.3 %Sep: 27.0 %Oct: 27.4 %Nov: 27.2 %Dec: 26.6 % JanFebMarAprMayJunJulAugSepOctNovDec 24.0 %26.0 %28.0 %

Bars are revenue per month. The line is gross margin on the right axis. The dip in July is the summer holiday.

Inventory by age
6.9 0-30 4.6 31-60 3.6 61-90 2.8 90+ DKK m

Stock that has stood for over 90 days ties up capital. That is the last bar.

Receivables by age
9.1 Not due 3.2 1-30 1.3 31-60 0.6 60+ DKK m

Total outstanding, split by how long it has been overdue.

On-time delivery
90.0 %92.0 %94.0 %96.0 % Jan: 91.9 %Feb: 92.3 %Mar: 92.6 %Apr: 92.4 %May: 93.1 %Jun: 93.5 %Jul: 91.8 %Aug: 93.0 %Sep: 94.2 %Oct: 94.6 %Nov: 95.1 %Dec: 94.4 % Target 95% JanFebMarAprMayJunJulAugSepOctNovDec

The share of orders delivered on the promised date. The trend is up, but it still misses the target.

The five largest customers
Bygma Syd A/S 22.1 %Jysk Teknik ApS 23.4 %Fyns VVS Center 28.9 %Aarhus Industri A/S 27.6 %Kolding Byg og Anlæg 29.4 % Average 26.6 %

The bar is the customer gross margin. The dashed line is the average for the whole business.

What the numbers say

DKK 2.8m
Tied up in slow stock

Stock worth DKK 2.8m has sat on the shelf for more than 90 days. That is 15 % of inventory value, and it is money that could be in the bank instead.

22.7 %
The two largest customers

Bygma Syd A/S and Jysk Teknik ApS account for 22 % of revenue, but trade −3.9 pp below the average. Bringing those two up to the average is DKK 0.8m more on the bottom line.

DKK 0.6m
Overdue by more than 60 days

Customers take 54 days to pay on average, and DKK 0.6m has been overdue for more than two months. That is fixed by calling the customers.

What you are looking at

Four or five figures that run the business, laid out so you can see which of them is going wrong. The page ends with three sentences on what the figures say.

Revenue is growing, the margin has improved slightly and inventory is down. Even so, DKK 2.8 million of stock has not moved in three months, and the two largest customers trade below the average. In a spreadsheet those two lines would be hard to spot.

On your own figures the key figures would be different. A manufacturer would rather see yield and changeover time than receivables. That is what the first twenty minutes are spent finding out.

  • The period can be changed at the top, and the key figures are recomputed
  • Gross margin is weighted by revenue, not an average of months
  • The page loads nothing from elsewhere and sets no cookies

Want to see it on your own figures?

Send a line about what you would like to see. I will reply with a proposal and a fixed price.