Hi All
Need a bit of assistance with the below.
I'm in the process of building a very high level capacity model for our factory.
We have set run quantities and the frequency in which we want to run the set quantities.
The document uses our current stock on hand levels to determine when to first make stock, there after i need the set run qty to be run based on the frequency starting from the first production run. this will change weekly and the first production run can shift forward or further out and the weeks there after would need to change accordingly to ensure the frequency between runs remains the same.
i have attached a document, first table is what i would like the data to display as.
second table shows the yellow area where I'm battling to populate the data.
i can not attached the actual file as it contains confidential info.
Thanks!
Bookmarks