My company manufacture linear lights which has a different dimensions, we need to change BOM based on the length of the lights. When we create BOM of this products for 1 meter in Odoo (V. 11) and you need to manufacture 10 meter some components will reserve more than it will be used in manufacturing!!!!!

For example: Components of the BOM is as bellow:

1- Body 1 meter (Variable based on length)

2- LED strip 1 meter (Variable based on length)

3- Clamp 2 Qty (Fixed even if the length changes)

4- End cap 2 Qty (Fixed even if the length changes)

When manufacturing order comes for 10 meters Odoo will reserve:

1- Body 10 meters

2-LED strip 10 meters

3- Clamp 20 Qty

4- End cap 20 Qty

But we just need 2 clamp and 2 end cap for 10 meters.

Would you please advise how can i set BOM for this kind of products to use fixed quantity of some components while some others will change?

Thanks,