Hi everyone. I have a bit of a convoluted question, hoping someone can help me out or point me in the right direction.
We sell coffee beans, but we only keep them for 2 weeks from their roast date. Thereafter, they go on sale at a discounted price.
We have a supplier who only roasts once a week, on a Wednesday. We order from them on a Monday, and receive the stock the following Monday. The problem we have is estimating how much to order each week so that we not only have enough to fulfil current orders, but also have enough to fulfil some of the ones that come in before the next purchase order (buffer stock). Currently, we are more or less just estimating how much buffer to order to hold us over for the week, but this means that when we get it wrong, a customer can end up waiting more than a week for dispacth, depending on how soon after Monday morning they order (this is when we do the weekly order). If we over-order, we end up having to sell more than we'd like at a discount. So essentially we are trying to balance it between not making customers wait too long and not have to discount too much of it.
I'm sorry if this is not clear, please let me know if I can clarify anything. Also, if this is not the sub for this kind of question, can anyone please point me toward a sub where it would be more appropriate.
Thanks for reading