search

frePPLe / frepple

frePPLe - open source supply chain planning
https://frepple.com
Other
524 stars 248 forks source link

Problem with Calendar Buckets #371

Open petrakozielova opened 3 years ago

petrakozielova commented 3 years ago

Hello,

I have problem with CalendarBuckets - There is one resource Petr Novak (it has owner Operator) and two other Resources Bruska01,Bruska02 (owner Bruska). When Petr Novak has same availibility Calendar as Bruska01, the demand is planned correctly. If I change his calendar to the same calendar as Bruska02 has, the frepple doesn´t plann the demand. Availability calendar´s hours for Bruska01 is 6-14, availability calendar´s hours for Bruska02 is 14-22. Except the calendar bucket, the resources are identical.

I sent files in attachment with the data.

obrazek obrazek

planned.xlsx not_planned.xlsx

jdetaeye commented 3 years ago

I can reproduce the case. What happens is that the manufacturing order is first created on a first "bruska" subresource and a first "operator" subresource. If there is no availability overlap at all between those resources, the manufacturing order is infeasible (ie we can't find any start and end date with the required available time between them) and gets rejected before the solver can evaluate alternative resources.

I'm afraid a correction isn't going to be simple, easy or quick.
The current solver code assumes we find available time on all combinations of alternate resources. Also, the algorithm isn't doing any complex matching of resources with enough overlap of available time.

My recommendation is to model availability only with a single calendar - either location or one of the resources.

petrakozielova commented 3 years ago

Thank you for explanation and your recommedation.

jdetaeye commented 3 years ago

Moving back the priority: I fully agree that the plan isn't correct in this case. However, things are working as designed & expected. The model configuration is just beyond what the algorithm can handle efficiently.