Taking into account lead times when ordering

You need to supply more details about what you mean. It is best to upload a sample workbook (desensitized data) that duplicates the structure of your real workbook and contains representative data and an example of your desired results.

Thanks Palmetto,

Attached is the model. The Small and large servers (columns B & C) are at the moment ordered everyother week. The lead time for the large server is 5 weeks, and that of the small server is 1 week.

It affects production/capacity when it arrives.At the moment the formula's for the lead times were done manually and incorporated into columns F & G just so I could see the total figure but I need to automate it hence the creation of the 2 empty columns, D & E.

Is this enough info?

At the moment the formula's for the lead times were done manually and incorporated into columns F & G just so I could see the total figure but I need to automate it hence the creation of the 2 empty columns, D & E.

It's not clear to me just exactly what the expected result should be in either column D or E nor what the relationship is to F & G. Some cells in F & G contain formula, others have only a value.

In order to not waste time and to give a precise answer, please clarify what the results should be. Show them manually in the workbook and clarify the relationships.

Originally Posted by Palmetto

It's not clear to me just exactly what the expected result should be in either column D or E nor what the relationship is to F & G. Some cells in F & G contain formula, others have only a value.

In order to not waste time and to give a precise answer, please clarify what the results should be. Show them manually in the workbook and clarify the relationships.

Ok, attached is a V5 which should hopefully be clearer.

The relationship is this :

When a small or large server is purchased - Col B & C, they arrive 1 week and 5 weeks later respectively - Col D & E. Col B & C affect purchase cost in Col J, while Col D & E when they are received affect the total small & large servers in col F & G, hence affect production and running cost.

The result should work like this version where when small or large servers are purchased, they automatically reflect 1 or 5 weeks later. Here, i've used the offset function and manually started from 5 weeks later for large and 1 week for small which is not good enough. It also doesn't link to the lead times in column T in the decisions variables box.

Basically the result would be an automated process as shown with the offset function and preferably linked to the lead time in the decision variable box, and if not, at least only neatly automated. I considered using vba but not sure how...

Thanks again ( is this clear enough??)