# Cost table input

### General assumptions

| Code | Description                                     | Input   | Default value |
| ---- | ----------------------------------------------- | ------- | ------------- |
| 0    | B.T.W. laag tarief (%)                          | Integer | 9             |
| 1    | B.T.W. hoog tarief (%)                          | Integer | 21            |
| 2    | Kosten gas vast (€/jaar)                        | Integer | 257.58        |
| 3    | Kosten gas variabel (€/m3)                      | Integer | 0.774         |
| 4    | Kosten elektriciteit vast (€/jaar)              | Integer | 317.6         |
| 5    | Kosten elektriciteit variabel (€/kWh)           | Integer | 0.223         |
| 6    | Kosten warmte vast (€/jaar)                     | Integer | 493.13        |
| 7    | Kosten warmte variabel (€/GJ)                   | Integer | 0.2709        |
| 8    | Looptijd (jaar)                                 | Integer | 25            |
| 9    | Jaarlijkse stijging gasprijs (%)                | Integer | 3             |
| 10   | Jaarlijkse stijging elektriciteitsprijs (%)     | Integer | 2             |
| 11   | Jaarlijkse stijging warmteprijs (%)             | Integer | 3             |
| 12   | Rente op besparingen (%)                        | Integer | 1.7           |
| 13   | Heffingskorting (€/jaar)                        | Integer | 527.17        |
| 14   | Isolatie aanpassingen B.T.W. tarief arbeid hoog | Integer | 0             |
| 15   | Overige aanpassingen B.T.W. tarief arbeid hoog  | Boolean | 1             |
| 21   | Kosten biomassa vast (€/jaar)                   | Integer | 0             |
| 22   | Kosten biomassa variabel (€/kg)                 | Integer | 0.3           |
| 23   | Jaarlijkse stijging biomassaprijs (%)           | Integer | 3             |

#### Input schema

```
    "custom_costs": [
      {
        "code": 0,
        "value": 0
      }
```

### Improvement costs per measure

All numbers from Material are Euro values, excluded of VAT. Download PDF for all possible default values to overwrite for the measures.

Note: all costs for insulation and glass are per square meter(m2).

| Code  | Description                                     | Material | Work | Saving Material | Saving Work |
| ----- | ----------------------------------------------- | -------- | ---- | --------------- | ----------- |
| 10001 | Wall insulation to type ''Matig/na-insulation'' | 22       | 14   | 20              | 13          |

{% file src="<https://1172273446-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Lw4gk5ARKsgVHFCdPZw%2Fuploads%2F8ftcwrKqrUt81kiNKhTM%2FSustainability%20API%20-%20Input%20cost%20table%20-%20Improvement%20costs%20per%20measure.pdf?alt=media&token=09f80eac-a440-4a7e-8054-4bb1b8c2552c>" %}
Default improvement costs per measure from 1 January 2024
{% endfile %}

<details>

<summary>Default improvement costs code per measure from 1st January 2024</summary>

```
"improvement_costs": [
    {
        "code": 10001,
        "material": 14,
        "work": 9,
        "saving_material": 13,
        "saving_work": 8
    },
    {
        "code": 10002,
        "material": 46,
        "work": 70,
        "saving_material": 42,
        "saving_work": 65
    },
    {
        "code": 10003,
        "material": 91,
        "work": 65,
        "saving_material": 85,
        "saving_work": 60
    },
    {
        "code": 20002,
        "material": 10,
        "work": 16,
        "saving_material": 9,
        "saving_work": 15
    },
    {
        "code": 20003,
        "material": 22,
        "work": 27,
        "saving_material": 20,
        "saving_work": 25
    },
    {
        "code": 30002,
        "material": 84,
        "work": 148,
        "saving_material": 77,
        "saving_work": 137
    },
    {
        "code": 30003,
        "material": 119,
        "work": 168,
        "saving_material": 111,
        "saving_work": 155
    },
    {
        "code": 40002,
        "material": 25,
        "work": 64,
        "saving_material": 23,
        "saving_work": 60
    },
    {
        "code": 40003,
        "material": 52,
        "work": 70,
        "saving_material": 48,
        "saving_work": 66
    },
    {
        "code": 50001,
        "material": 57,
        "work": 128,
        "saving_material": 53,
        "saving_work": 119
    },
    {
        "code": 50002,
        "material": 53,
        "work": 110,
        "saving_material": 50,
        "saving_work": 100
    },
    {
        "code": 50003,
        "material": 134,
        "work": 34,
        "saving_material": 124,
        "saving_work": 32
    },
    {
        "code": 50102,
        "material": 135,
        "work": 320,
        "saving_material": 124,
        "saving_work": 295
    },
    {
        "code": 50103,
        "material": 361,
        "work": 94,
        "saving_material": 334,
        "saving_work": 86
    },
    {
        "code": 50203,
        "material": 361,
        "work": 94,
        "saving_material": 334,
        "saving_work": 86
    },
    {
        "code": 60001,
        "material": 1639,
        "work": 1661,
        "saving_material": 1518,
        "saving_work": 1538
    },
    {
        "code": 60002,
        "material": 2880,
        "work": 2681,
        "saving_material": 2667,
        "saving_work": 2482
    },
    {
        "code": 60003,
        "material": 3647,
        "work": 1689,
        "saving_material": 3378,
        "saving_work": 1564
    },
    {
        "code": 60004,
        "material": 4155,
        "work": 2339,
        "saving_material": 3848,
        "saving_work": 2165
    },
    {
        "code": 80004,
        "material": 6782,
        "work": 6755,
        "saving_material": 6281,
        "saving_work": 6254
    },
    {
        "code": 80104,
        "material": 2668,
        "work": 2354,
        "saving_material": 2470,
        "saving_work": 2180
    },
    {
        "code": 80204,
        "material": 2203,
        "work": 1363,
        "saving_material": 2040,
        "saving_work": 1262
    },
    {
        "code": 80305,
        "material": 4739,
        "work": 2076,
        "saving_material": 4388,
        "saving_work": 1923
    },
    {
        "code": 80406,
        "material": 2837,
        "work": 1243,
        "saving_material": 2627,
        "saving_work": 1152
    },
    {
        "code": 80506,
        "material": 2837,
        "work": 1243,
        "saving_material": 2627,
        "saving_work": 1152
    },
    {
        "code": 80006,
        "material": 10276,
        "work": 8841,
        "saving_material": 9516,
        "saving_work": 8186
    },
    {
        "code": 80106,
        "material": 5651,
        "work": 3738,
        "saving_material": 5232,
        "saving_work": 3461
    },
    {
        "code": 80306,
        "material": 4486,
        "work": 2329,
        "saving_material": 4154,
        "saving_work": 2157
    },
    {
        "code": 80007,
        "material": 25410,
        "work": 8416,
        "saving_material": 23527,
        "saving_work": 7793
    },
    {
        "code": 80107,
        "material": 18839,
        "work": 6087,
        "saving_material": 17445,
        "saving_work": 5635
    },
    {
        "code": 80407,
        "material": 18543,
        "work": 5991,
        "saving_material": 17170,
        "saving_work": 5547
    },
    {
        "code": 80008,
        "material": 9618,
        "work": 4640,
        "saving_material": 8906,
        "saving_work": 4297
    },
    {
        "code": 80108,
        "material": 10352,
        "work": 5199,
        "saving_material": 9585,
        "saving_work": 4814
    },
    {
        "code": 80408,
        "material": 10979,
        "work": 5514,
        "saving_material": 10165,
        "saving_work": 5105
    },
    {
        "code": 80009,
        "material": 13983,
        "work": 6731,
        "saving_material": 12948,
        "saving_work": 6233
    },
    {
        "code": 80109,
        "material": 10400,
        "work": 2476,
        "saving_material": 9629,
        "saving_work": 2292
    },
    {
        "code": 80209,
        "material": 9278,
        "work": 1608,
        "saving_material": 8590,
        "saving_work": 1489
    },
    {
        "code": 80029,
        "material": 18845,
        "work": 7515,
        "saving_material": 17449,
        "saving_work": 6958
    },
    {
        "code": 80129,
        "material": 19029,
        "work": 6627,
        "saving_material": 17619,
        "saving_work": 6136
    },
    {
        "code": 80529,
        "material": 19541,
        "work": 6115,
        "saving_material": 18093,
        "saving_work": 5662
    },
    {
        "code": 80030,
        "material": 10595,
        "work": 6888,
        "saving_material": 9810,
        "saving_work": 6378
    },
    {
        "code": 80130,
        "material": 7901,
        "work": 2295,
        "saving_material": 7317,
        "saving_work": 2124
    },
    {
        "code": 80430,
        "material": 5940,
        "work": 2376,
        "saving_material": 5500,
        "saving_work": 2200
    },
    {
        "code": 80031,
        "material": 11288,
        "work": 5205,
        "saving_material": 10452,
        "saving_work": 4820
    },
    {
        "code": 80131,
        "material": 11810,
        "work": 4683,
        "saving_material": 10935,
        "saving_work": 4337
    },
    {
        "code": 80431,
        "material": 11810,
        "work": 4683,
        "saving_material": 10935,
        "saving_work": 4337
    },
    {
        "code": 80010,
        "material": 2949,
        "work": 916,
        "saving_material": 2730,
        "saving_work": 848
    },
    {
        "code": 70000,
        "material": 140,
        "work": 164,
        "saving_material": 128,
        "saving_work": 153
    },
    {
        "code": 94001,
        "material": 547,
        "work": 111,
        "saving_material": 506,
        "saving_work": 103
    }
]
```

</details>

#### Column descriptions

| Input            | Format  | Description                                                                | Translation                                                                          |
| ---------------- | ------- | -------------------------------------------------------------------------- | ------------------------------------------------------------------------------------ |
| material         | integer | Total investment cost per unit for material (excluding VAT).               | Kosten totale investering per eenheid voor materiaal (exclusief BTW).                |
| work             | integer | Total investment cost per unit for the labor (excluding VAT)               | Kosten besparingsdeel van de investering per eenheid voor arbeid (exclusief BTW).    |
| saving\_material | integer | Cost-saving part of the investment per unit for material (excluding VAT).  | Kosten besparingsdeel van de investering per eenheid voor materiaal (exclusief BTW). |
| saving\_work     | integer | Cost-saving part of the investment per unit for the labor (excluding VAT). | Kosten besparingsdeel van de investering per eenheid voor de arbeid (exclusief BTW). |

#### Input schema

```
"improvement_costs": [
      {
        "code": 0,  # code of a certain type measure, see General assumptions
        "material": integer,
        "work": integer,  
        "saving_material": integer,  
        "saving_work": integer 
      },
      ...
    ]
```

**Input example**

```
"improvement_costs": [
        {
            "code": 50001,
            "material": 57,
            "work": 128,
            "saving_material": 53,
            "saving_work": 119
        },
      ...
    ]
```

### Saving work and -material numbers explained

The *saving\_material* and *saving\_work* variables per part concern the saving part of the investment, split into material and labour. This affects the final calculation of CO2 emissions and the ELG.

**saving\_material**: cost saving part of the investment per unit for material (excluding VAT). **saving\_work**: cost saving part of the investment per unit for labor (excluding VAT).

As a rule, the savings share is on average 92.5% (between 90 and 94%) of the investment in material and labour.
