Contributors mailing list archives

Browse archives


Manufacturing advice needed - materials of measured units being consumed partially

Data Dance s.r.o., Radovan Skolnik
- 26/01/2022 21:30:46

sorry for asking stupid questions here but I hope someone can provide some wisdom here that I am missing.

Let's imagine this scenario: I produce Ethernet cables of various lengths - i.e. 25m, 50m, 75m, 100m, ... Each such final cable requires 2 connectors and that particular amount of "raw" cable. I can only buy raw cable in rolls of 1000m.

So when I buy a new roll and produce one final 50m cable, 950m of raw cable remains. When I produce another of 100m length, 850m of raw cable remains. When my remaining raw cable on certain roll is 50m I cannot produce 100m final cable and need to order another raw cable roll.

So the idea is tracking remaining quantity of somethings (products? lots? ...) that is bought at certain size and is being gradually consumed. There can of course be more of these (i.e. I have bought 3 rolls at the same time).

Is there a way on how to model this? Manufacturing is not really my domain and looking through code of various modules I didn't find anything that would resemble such thing.

Thank you very much. Best regards

	Radovan Skolnik