Skip to Content
  2. Mailing Lists
  3. Contributors
  4. Re: Manufacturing advice needed - materials of measured units being consumed partially

Archives

Contributors

Re: Manufacturing advice needed - materials of measured units being consumed partially

Re: Manufacturing advice needed - materials of measured units being consumed partially

Hi,

Yes. It is a well known problem. The 2D PaperCutting Problem, a lot less complex than the 3D one, aka Travelling Salesperson.

As for where it goes. I don't know. As I say, I solved differently. Using Unbuild style you start from the raw material so it was never an issue. But to start you can just use a rule of thumb.

On Thu, Jan 27, 2022 at 9:37 PM Radovan Skolnik <radovan@skolnik.info> wrote:
Graeme,

this is what I was looking for and sort of confirms my suspicion that without 
special handling Odoo would sum contents of all lots of same kind into one 
(which perfectly makes sense when dealing with units, weights, volumes and 
such that can be added/joined).

Question though if I may: where should that pseudo-code fit in? Is that 
supposed to be extension somewhere in MRP BoM process where appropriate 
materials are being looked for when manufacturing the final product? Dumb 
question maybe but haven't had much experience with MRP yet.

Your algorithm actually reminds me very much of a thing I was doing just not a 
year ago as a favour to a friend who builds pergolas using alluminium joists 
of certain fixed size. From the design you receive required cutting sizes and 
you need to optimize how to cut the source material with the least waste.

But that was written in Excel and Visual Basic :-) However it is basically the 
same as what you have outlined.

Best regards

	Radovan

P.S.: BTW, have you had a chance to have a look at my comment regarding 
variant_seller_ids for product.[template|product]? Is till consider that thing 
broken and not following the desired design...

On štvrtok 27. januára 2022 9:17:06 CET Graeme Gellatly wrote:
by Graeme Gellatly - 10:05 - 27 Jan 2022

Reference

  • Manufacturing advice needed - materials of measured units being consumed partially 
    Hello,

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
    by Radovan Skolnik - 09:36 - 26 Jan 2022