Sales with different dates
Posted: Monday 18 January, 2016 - 14:28
Hello,
I'm writing my master thesis atm and I'm using ED for it to model a chicken supply chain. The idea is to see the difference between a 'normal' use by date and a dynamic shelf life date, based on the time and temperature the product has experienced and with that indirectly the bacterial growth. The chain runs from packaging untill the final sales in the supermarket.
But for this last part, I want to model the behaviour of customers, a certain percentage buying LEFO(last to expire first out) and the rest buying FEFO(first to expire first out). I know there are a few ways of doing it, the most used is to have different queues with different use by dates and to model the customers by having an order picked. The problem now is that I will have so many different dates because of variations in time and temperature that is unfeasible to make different queues for each use by date.
The idea that I have so far is to make 2 different queues, one queue being a LEFO queue(with items sorted by use by date) and the other a FEFO. But the problem is how to get these products in there in the right way. What in my eyes would be easiest, is to have a queue ordered in a certain way(either LEFO or FEFO) and if there would be a send to code that would say 'the first ...% is sent to channel 1 and the rest is sent to channel 2'. But the different codes that are present as the 'send to' rules in ED don't really do this. The 'by percentage' sends a certain percentage to channel 1 and the rest to channel 2, but does this in a random order. Round robin sends the 1st product to the first channel, the 2nd to the second channel, the 3rd again to the first. Conditionally also doesn't work as it isn't the case that for example LEFO buyers would only buy products that have a use by date of no less than .. days.
I also tried to do this via order picking, to have different orders for LEFO and for FEFO, but I can give the orders the right label, but (as far as I see) can't give the products then a label that matches the LEFO or FEFO order so they can be splitted to go to different queues.
I really hope that someone has an idea of how to do this, or some ideas that I can try.
I'm writing my master thesis atm and I'm using ED for it to model a chicken supply chain. The idea is to see the difference between a 'normal' use by date and a dynamic shelf life date, based on the time and temperature the product has experienced and with that indirectly the bacterial growth. The chain runs from packaging untill the final sales in the supermarket.
But for this last part, I want to model the behaviour of customers, a certain percentage buying LEFO(last to expire first out) and the rest buying FEFO(first to expire first out). I know there are a few ways of doing it, the most used is to have different queues with different use by dates and to model the customers by having an order picked. The problem now is that I will have so many different dates because of variations in time and temperature that is unfeasible to make different queues for each use by date.
The idea that I have so far is to make 2 different queues, one queue being a LEFO queue(with items sorted by use by date) and the other a FEFO. But the problem is how to get these products in there in the right way. What in my eyes would be easiest, is to have a queue ordered in a certain way(either LEFO or FEFO) and if there would be a send to code that would say 'the first ...% is sent to channel 1 and the rest is sent to channel 2'. But the different codes that are present as the 'send to' rules in ED don't really do this. The 'by percentage' sends a certain percentage to channel 1 and the rest to channel 2, but does this in a random order. Round robin sends the 1st product to the first channel, the 2nd to the second channel, the 3rd again to the first. Conditionally also doesn't work as it isn't the case that for example LEFO buyers would only buy products that have a use by date of no less than .. days.
I also tried to do this via order picking, to have different orders for LEFO and for FEFO, but I can give the orders the right label, but (as far as I see) can't give the products then a label that matches the LEFO or FEFO order so they can be splitted to go to different queues.
I really hope that someone has an idea of how to do this, or some ideas that I can try.