Dear Experts,
I need your help regarding timeline, i have below data from style to last date and i want to calculate day wise quantities according to below criteria.
1.5 Change over days are constant and days required are calculated =4000/800 >> 5 +C/O days >> 6.5 days.
1st Day Plan: 25% of P/D target2nd Day Plan: 50% of P/D target
3rd Day Plan: 75% of P/D target
rest all days: 100% of P/D target
Last day:Remaining Balance Percentage from plan qty
<tbody>
</tbody>
I need your help regarding timeline, i have below data from style to last date and i want to calculate day wise quantities according to below criteria.
1.5 Change over days are constant and days required are calculated =4000/800 >> 5 +C/O days >> 6.5 days.
1st Day Plan: 25% of P/D target2nd Day Plan: 50% of P/D target
3rd Day Plan: 75% of P/D target
rest all days: 100% of P/D target
Last day:Remaining Balance Percentage from plan qty
Style # | Plan Qty | P/D Tgt. | C/O Days | Days Req. | First Plan | Last Date | 19/4 | 20/4 | 22/4 | 23/4 | 24/4 | 25/4 | 26/4 | 27/4 | 29/4 | 30/4 |
AVA-0652NM | 4000 | 800 | 1.5 | 6.50 | 19/4 | 26/4 | 200 | 400 | 600 | 800 | 800 | 800 | 400 | |||
AVA3501F1 | 1200 | 900 | 1.5 | 2.8 | 27/4 | 30/4 | 225 | 450 | 525 |
<tbody>
</tbody>