Back to Excel models and data analysis
Work example (excerpt)

Profitability Analysis per project

Carpentry firm – Berge & Sønn Snekkerverksted (fictional)

2024
Analysis period
20
Projects
10
Customers
6
Job types

Financial overview

Total revenue
2.74M
Excl. VAT
Total costs
1.71M
Hours + materials
Gross margin
1.03M
+37.7% of revenue
Avg. per project
51 655
Gross margin (NOK)
37.7%
Margin
Gross margin: 1 033 097 kr
Costs: 1 705 512 kr

For every 100 kr in revenue, the firm retains 37.70 kr before fixed costs.

The firm has solid overall profitability, but margins vary significantly between job types (from 34.3% to 40.9%). This provides room for strategic prioritization of the most profitable jobs.

Profitability per job type

Overview of which types of jobs yield the best return. Sorted by gross margin percentage.

Most profitable
Terrassebygging
40.9% margin • 675 kr/hour • 2 projects
Least profitable
Vindusbytte
34.3% margin • 764 kr/hour • 5 projects
Gross margin per job type (%)
Terrassebygging
40.9%
Kjøkkenmontering
39.9%
Baderomsrehab
38.6%
Gulvlegging
35.5%
Takarbeid
35.2%
Vindusbytte
34.3%
Total gross margin per job type (NOK)
Baderomsrehab
441 906 kr
Kjøkkenmontering
177 379 kr
Takarbeid
159 292 kr
Vindusbytte
134 925 kr
Terrassebygging
95 953 kr
Gulvlegging
23 642 kr
Strategic recommendation

Terrassebygging and kjøkkenmontering should be prioritized for the highest margin. Baderomsrehab generates the most total profit due to volume. For vindusbytte: consider a price increase (5-10%) or efficiency improvements – this would significantly boost the margin given the high number of jobs.

All job types

Rank Job type Count Hours Revenue Costs Gross margin Margin % NOK/hour
1 Terrassebygging 2 142 234 752 kr 138 799 kr 95 953 kr
40.9%
675 kr
2 Kjøkkenmontering 4 166 445 081 kr 267 702 kr 177 379 kr
39.9%
1 070 kr
3 Baderomsrehab 5 592 1 146 050 kr 704 144 kr 441 906 kr
38.6%
747 kr
4 Gulvlegging 1 48 66 640 kr 42 998 kr 23 642 kr
35.5%
489 kr
5 Takarbeid 3 235 452 738 kr 293 446 kr 159 292 kr
35.2%
679 kr
6 Vindusbytte 5 177 393 348 kr 258 423 kr 134 925 kr
34.3%
764 kr

Customer profitability

Analysis of which customers yield the best return. Repeat customers with multiple projects are often more profitable due to lower acquisition costs.

Gross margin per customer (%)
Ved vannet Borettslag
45.1%
Handels bedr. Innlandet
41.4%
På Østlandet Byggforv.
40.2%
Byggeren Entreprenør
40.1%
Stedet Sameie
39.1%
Gamle Stranden Barneh.
37.4%
Norenga Hytteforening
35.7%
Hamar Familie
32.9%
Berge & Sønn
25.3%
10
Unique customers
2.0
Avg. projects/customer
103 310
Avg. margin/customer (NOK)

På Østlandet Byggforvaltning and Stedet Sameie are the most valuable customers measured by total margin (3-4 projects each). Corporate clients and housing cooperatives generally yield better margins than private customers.

Top 10 individual projects

Projects with the highest gross margin in NOK. Larger projects naturally generate higher margin in absolute terms.

# Project Customer Type Revenue Gross margin Margin %
1 Baderomsrehab - Stedet (P012) Stedet Sameie Baderomsrehab 274 245 kr 98 715 kr 36.0%
2 Baderomsrehab - Norenga (P009) Norenga Hytteforening Baderomsrehab 249 982 kr 94 318 kr 37.7%
3 Baderomsrehab - Østlandet (P016) På Østlandet Byggforvaltning Baderomsrehab 204 304 kr 90 405 kr 44.3%
4 Baderomsrehab - Stedet (P019) Stedet Sameie Baderomsrehab 208 693 kr 83 300 kr 39.9%
5 Baderomsrehab - Østlandet (P002) På Østlandet Byggforvaltning Baderomsrehab 208 826 kr 75 168 kr 36.0%
6 Takarbeid - Norenga (P010) Norenga Hytteforening Takarbeid 185 788 kr 62 425 kr 33.6%
7 Takarbeid - Hamar (P007) Hamar Familie Takarbeid 138 638 kr 55 764 kr 40.2%
8 Kjøkkenmontering - Østlandet (P008) På Østlandet Byggforvaltning Kjøkkenmontering 129 525 kr 52 397 kr 40.5%
9 Terrassebygging - Stedet (P006) Stedet Sameie Terrassebygging 124 358 kr 51 656 kr 41.5%
10 Kjøkkenmontering - Røros (P004) Handels bedriften Innlandet Kjøkkenmontering 120 601 kr 49 134 kr 40.7%

Time usage and efficiency

1 359
Total hours
68 h
Avg. per project
760
Avg. margin/hour (NOK)
Profit per hour (NOK) – by job type
Kjøkkenmontering
1 070 kr
Vindusbytte
764 kr
Baderomsrehab
747 kr
Takarbeid
679 kr
Terrassebygging
675 kr
Gulvlegging
489 kr

Interesting finding: Kjøkkenmontering has the highest profit per hour (1 070 kr), even though terrassebygging has the highest percentage margin. This is because kjøkkenmontering has a higher billing rate per hour. Vindusbytte has the second highest NOK/hour despite the lowest percentage margin – this indicates that the issue is material costs, not the hourly rate.

Recommendations and actions

Estimated impact

By increasing the price of vindusbytte by 7% and prioritizing 2 additional terrace projects per year, total gross margin can be increased by an estimated 80 000–120 000 kr annually without additional capacity requirements.

What the customer receives

Download Excel model

Need help with Excel models or data analysis?

Contact us

Back to Excel models and data analysis