Hi,
I have an optimization problem, that I'm trying to solve in Excel, but it keeps getting too complex (too many columns/iterations), and I hope someone in the forum may be able to give some pointers.
On a given day, at a given timeslot, I have 6 production lines, each with different production capacity, and being able to produce either the same or 6 different products. Production is for direct consumption (=real time) - there is no warehouse.
Due to different constraints, production for all 6 lines will now be limited to 60%.
It is easy to predict the loss in sale - each time demand/sales has surpassed 60% of the capacity of the given line. However - if we were to optimize production lines, and let multiple lines produce the same product, and hence only the least demanded product would stop being produced - how can we limit the loss?
Take this simple example with 3 lines, with a capacity of 100, 50 and 25 respectively, now being limited to 60, 30 and 15 respectively:
<tbody>
</tbody>
in example 1, we would let line 2 produce the same product as line 1 to optimize. In example 2 we would let line 2 product the same product as line 1, and move product2 to line 3
is there a simple way of solving this type of iterative problem solving? (it doesn't always cascade down from line 1)
I appreciate any help you can provide.
Thanks,
Erik
I have an optimization problem, that I'm trying to solve in Excel, but it keeps getting too complex (too many columns/iterations), and I hope someone in the forum may be able to give some pointers.
On a given day, at a given timeslot, I have 6 production lines, each with different production capacity, and being able to produce either the same or 6 different products. Production is for direct consumption (=real time) - there is no warehouse.
Due to different constraints, production for all 6 lines will now be limited to 60%.
It is easy to predict the loss in sale - each time demand/sales has surpassed 60% of the capacity of the given line. However - if we were to optimize production lines, and let multiple lines produce the same product, and hence only the least demanded product would stop being produced - how can we limit the loss?
Take this simple example with 3 lines, with a capacity of 100, 50 and 25 respectively, now being limited to 60, 30 and 15 respectively:
Example | Line1Sales | Line2Sales | Line3Sales | SimpleLoss | Optimized loss |
1 | 90 | 20 | 25 | 40 | 30 |
2 | 90 | 20 | 10 | 30 | 15 |
<tbody>
</tbody>
in example 1, we would let line 2 produce the same product as line 1 to optimize. In example 2 we would let line 2 product the same product as line 1, and move product2 to line 3
is there a simple way of solving this type of iterative problem solving? (it doesn't always cascade down from line 1)
I appreciate any help you can provide.
Thanks,
Erik