Originally Posted by
azii
applying your formula will result 89 days in column E
It's not my formula, it's YOUR formula from post #1.
actually question is what should be the Demand Plan (value in B) for 90 days (value in E)
But you gave a formula for that in post #1
OK, so the value in column B is a variable that is supposed to be solved such that column E will be 90. That was not clear in post #1.
The formula for B is
Values as displayed
|
A |
B |
C |
D |
E |
F |
G |
1 |
Opening (1 May) |
Demand Plan |
DN Forecast |
Closing Stock |
Days |
DN Forecast |
DN Forecast |
2 |
1412.65 |
3367.35 |
1270 |
3510 |
90 |
1170 |
900 |
3 |
2056.6 |
2508.4 |
800 |
3765 |
90 |
1255 |
989.5 |
4 |
2714.85 |
155.15 |
1070 |
1800 |
90 |
600 |
800 |
Underlying formulas
|
A |
B |
C |
D |
E |
F |
G |
1 |
Opening (1 May) |
Demand Plan |
DN Forecast |
Closing Stock |
Days |
DN Forecast |
DN Forecast |
2 |
1412.65 |
=90*F2/30-A2+C2 |
1270 |
=A2+B2-C2 |
=D2/(F2/30) |
1170 |
900 |
3 |
2056.6 |
=90*F3/30-A3+C3 |
800 |
=A3+B3-C3 |
=D3/(F3/30) |
1255 |
989.5 |
4 |
2714.85 |
=90*F4/30-A4+C4 |
1070 |
=A4+B4-C4 |
=D4/(F4/30) |
600 |
800 |
Bookmarks