Skip to content
ProjectControls.com
Oracle Primavera - PM6

Earned Value - Forecast

In the Open Standard
Joseph OBrienMember for 16 years 6 months
Created
7
2
0
Hello,

My colleague is requesting if i can get a Period earned value forecast to the end of the job for each site,
The Closest i can get to this is in the resource assignments using cumalative budgeted cost, but this does not seem to take into account items with a Physical % complete greater than 0%.

Can anyone help me in getting the Earned Value period forecast to the end of the job if you can,

Thanks,

Joe
Save Follow Follow forum Report
Reply New topic

7 replies

Oldest first
  1. 0
    Anbin Ponnith ·
    #1
    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
    Report
  2. 0
    Joseph OBrien ·
    #2
    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
    Report
  3. 0
    Rodel Marasigan ·
    #3
    Joseph,
    The right field to use is At Completion which is the combination of Actual and Estimate to complete and you don’t need to merge to have one output.
    Report
  4. 0
    Joseph OBrien ·
    #4
    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
    Report
  5. 0
    Rodel Marasigan ·
    #5
    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.
    Report
  6. 0
    Joseph OBrien ·
    #6
    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
    Report
  7. 0
    Rodel Marasigan ·
    #7
    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.
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?