Forum Discussion
PBrabander
Oct 08, 2022Copper Contributor
Delivery time and production time
Hi fellow Excellers, I am currently working on a production list. As an example, I have made the following delivery overview of a type of chair. Week 12 13 14 15 16 17 18...
PeterBartholomew1
Oct 08, 2022Silver Contributor
Maybe assume that you need a 4-week lead to enter production but split the amount entering final steps between 1- and 2-weeks lead depending on what one assumes the delivery day to be.
EnterProduction
= XLOOKUP(Week+4, Week, Amount, 0)
FinalProduction
= ROUND(
( 3*XLOOKUP(Week+2, Week, Amount, 0)
+ 2*XLOOKUP(Week+1, Week, Amount, 0)
) / 5,
0 )