mrice,

I've tried to do an IF function, but i've run into difficulty with that. I have the corresponding demand from the random number vlookup table, and then a column for a total demand that includes an IF function for if there is excess demand from the previous week. However, i cant seem to get it to consider that the demand might carry over for several weeks if the supply is not high enough