On projects that last longer than a year, it is likely that resource rates will increase over the life of a project due to inflation and other factors. The Escalation Rate function in MPM can automatically calculate rate escalation across any specific time period. You can also de-escalate rates by entering a negative annual percent.
When you escalate rates, you can specify if MPM should escalate the rates in monthly, quarterly, semi-annually, or annual steps.
Monthly causes the rates to change each month.
Quarterly causes the rates to change every three months, etc.
The months are counted off starting with the month entered in the From field in the Escalate Rates dialog box.
To escalate rates, complete the following steps:
If you want, select an entire row by clicking the row number in the first column, or select a range of cells. You can escalate values for only one resource at a time.
Display the Escalate Rates dialog box by doing one of the following:
Click 
Escalate
Rates
Click Tools » Escalate Rates
Press Ctrl+E
If you selected cells, the dates of the first and last cells selected will automatically be filled in for the From and Through fields.
Enter the base amount as you want it to display in the grid. This value will be entered in the date (column) designated in the From field in the dialog box. Enter only numbers.
Enter the annual percent. Enter this amount as a whole number. For example, enter 15% as 15, not .15. If you enter an annual percent of zero, MPM will fill the same base amount in all cells. This has the same effect as using the Fill Right feature.
If necessary, change the dates specified in the From and Through fields.
Select the step for incrementing the rates: Monthly, Quarterly, Semi-Annually, or Annually.
Enter a Precision of 1 to 8. This represents the number of decimal places used to calculate the escalated rate. It does not affect the number of decimal places used to display the rates in the grid.
To execute the escalation, click OK.
Entering Rate Table Information