AnsweredAssumed Answered

Cost Plan Shift (Linear)

Question asked by navzjoshi00 Champion on Oct 31, 2011
Latest reply on Mar 28, 2013 by shammytaj
Dear Folks

We have a requirement wherein, we need to linear shift the cost plan (new cost plan, which will be created taking into account that a cost plan already exists)

Intital cost plan







Month
From CP
end CP
costs
start date cost
end date costs
#days
cost per day
M1
9-May-11
5-Jun-11
2,000
9-May-11
5-Jun-11
28
71
M2
6-Jun-11
3-Jul-11
2,000
6-Jun-11
3-Jul-11
28
71
M3
4-Jul-11
7-Aug-11
3,000
4-Jul-11
7-Aug-11
35
86
M4
8-Aug-11
4-Sep-11
4,000
8-Aug-11
4-Sep-11
28
143
M5
5-Sep-11
2-Oct-11
-
5-Sep-11
2-Oct-11
28
-
M6
3-Oct-11
6-Nov-11
-
3-Oct-11
6-Nov-11
35
-

Suppose that the project start date has changed to 15-jun-11

Month
From CP
End CP

start date costs
end date costs
#days
cost per period average cost per day previous next
M1
9-May-11
5-Jun-11



28







M2
6-Jun-11
3-Jul-11
2000
15-Jun-11
3-Jul-11
19
1,357
€ 71
19 days from M1

19
0
M3
4-Jul-11
7-Aug-11
2000
4-Jul-11
7-Aug-11
35
2,500
€ 71
9 days from M1 and 26 days from M2 9
26
M4
8-Aug-11
4-Sep-11
3000
8-Aug-11
4-Sep-11
28
2,371
€ 85
2 days from M2 and 26 days from M3 2
26
M5
5-Sep-11
2-Oct-11
4000
5-Sep-11
2-Oct-11
28
3,486
€ 124
9 days from M3 and 19 days from M4 9
19
M6
3-Oct-11
6-Nov-11

3-Oct-11
6-Nov-11
35
1,286
€ 37
9 days from M4

9
0
M7
7-Nov-11
4-Dec-11

7-Nov-11
4-Dec-11
28
-
€ -







Any ideas how we can achieve this ? Has anyone worked on such a requirement.

We can't figure out a definite formula for this shift

Any help is appreciated.

Regards
NJ

Outcomes