Cost Loading with Stored Period Actuals, Scenario 3
Cost loading a schedule using resources that are set up to auto calculate $ from Units. Each unit is equal to $ value. The resources are assigned to multiple Activities and we will store period performance
- Financial Periods need to be defined by your P6 Admin. They can be defined weekly, Monthly, Quarterly whatever meets your reporting needs (but only one set per database).
- Resources Created with $ Associated
- In the Activities window, select the activity to be cost loaded and assign the resources adjusting the budgeted units to the desired $ amount along with the duration of resource usage and the lag. (Lag begins count days from the start of the activity.)
- The cost curves are displayed based on a flat curve per resource assignment.
- You can do individual curves and reports or group them together
- In the Resource Assignments window, the cost assignments can be grouped by resource or cost account to display the $ as desired.
- The Timescale can be adjusted as required and the $ will be allocated based on the timeframe of the resource loading
- The Activity Usage Spreadsheet can also be used to see and report on the cost spread. It also is linked to the timescale. Many reports can be created and run monthly to show this info if required they can also dump this data into csv file which you open in Excel.
- Once the progress is entered, you can report on the Actual this period $ (see column 4‐6 above).
- After reporting is complete and before the next update you should store the period performance in the correct Financial Period. It is in the Tools menu.
- After the “store period performance” utility is run you will see the This Period column go to zero.