Earned Value - Forecast
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Joseph,
First you have to create Financial Period first. (Admin-> Financial Periods, you can create a batch from Start to Finish of Project with any interval you required. i.e. weekly, monthly, yearly)
Next is select Edit-> Users Preferences-> Application tab-> columns then select financial period start and finish to show)
Once everything is defined Financial Periods fields will be available on Spreadsheet fields for selections.
Rodel,
Thanks much appreciated just to touch on one thing you mention store period performance i know how to store but have no clue in how to restore/ show the period performance i read on another post that it was in edit but doesnt seem to show as an option can you help?
Joe
Joseph,
Earned Value (BCWP)= Physical % Complete (Physical Progress) * BAC. Actual Cost (ACWP)= Actual Cost.
If you used Store Period Performance then you will have historical data. P6 have the Earned Value group consist of all EV fields (i.e. BAC, EV, AC, SV, CV, SPI, CPI etc...)
These fields are also available in Profile (S-Curve & Bar) and Spreadsheet value.
Rodel,
that would be ideal but does At completion give a historical view on just earned value, not actuals as the contract were on were not entering cost percentage complete only physical e.g on our actual cost/ units its either £0 or the full price we budgeted for on that item. so i have to get the earned value to work out on my phycial %/ Budgeted cost to give me the costs i need for historical and estimate to complete for future planning.
Does this sound right?
Joe
Joseph,
The right field to use is At Completion which is the combination of Actual and Estimate to complete and you dont need to merge to have one output.
Anbin,
Thanks for Your idea it lead me on onto another idea, In the Fields Use Cumalative Earned Value for the Historical and Cumalative Estimate to Complete, then ill just merge historical/current/and forecast to make one output.
Thanks.
Joe
Hai Joseph
U can try on This
Click on The Activity Usage Spreadsheet-> Spraedsheet Field Select Cum Remaining Total Cost->Set Timescale Date Interval Week r Month According to your Requirement
Copy it & Paste it
That is ur Forecast Cashflow for remaining Period
Regards
Anbin