Monte Carlo Simulation Help

Hi everyone,

I'm having some trouble with running a Monte Carlo simulation. I'm at a complete loss on where I should go next. The situation is a variable demand based on a randbetween function. However, the simulation is representing a business where if supply for a perishable good (say, a loaf of bread) > demand for the good, the excess perishable goods for that week are able to carry over and be sold the next week. However, if the excess is kept two weeks or more, it must be disposed of. I've worked on it for a few hours, trying different formulas but I can't seem to get anywhere.

I've attached an example of what I'm working on.

View attachment Monte Carlo.xlsx

Need to describe the info a bit. I can't follow what you want done.
B2:C8 is historical demand. So if a year is simulated this distribution must be returned. (I don't think you are maintaining this rule as a side note.)

Your supply is always E24? Fixed supply every week, should this not be variable?

Then I would change E14 (and below) to be
=B14-D14+IF(E13<0,0,MIN(B13,E13))
i.e. this week surplus and the surplus from last week provided it was less than the new supply last week. Assuming a first in first out

Sorry, let me be a little clearer.

- B2:C8 is historical demand and you're right, over a year the distribution should approximate that historical demand. The supply of 62 is the amount reordered each week. This is a very simple simulation, so I'm not worried about simulating for a whole year, just 10 weeks.

Say, for example in week 1 we order 62 loaves of bread and our variable demand is 61. We carry over the loaf of bread that wasn't sold into week 2, so no week two will have 63 loaves available to sell (the 62 we order + the one held from week 1). Say demand in week 2 is 62. Well, we have that one loaf of bread that wasn't sold since the demand wasn't there. So now I need a way to identify these loaves that are held over one week but not sold.

I've attached a screenshot of the excel file I'm working with, the attachment I uploaded earlier wasn't exactly right

Andddd that image wasn't right either. Sorry, guys.