Phillyman2633
Legendary Member
- Messages
- 1,098
For anyone curious to see what your pay increases amount to when compared to inflation, I made this spreadsheet. For the preloaded example, I used Level 11 base pay (no locality, CIP, or COLA included) for someone who was certified on January 1st, 2012 when the last increase to the Pay Bands in the Red Book took effect. The example includes the Congressional pay raises every January as well as the contractual CBA raises every June. Also, keep in mind we have not gotten our June 1.6% raise for 2023 yet so the final number will be skewed until that happens.
You can enter your own info to determine your realized raises by entering your Base Pay for the first year in which you were fully certified on January 1st in the orange column for that year. Then, go to the CPI Calculator link, enter your base pay for the January of that year and get the output for the "Same buying power as" for April 2023. Divide the "same buying power as" number by your starting base pay you entered in the orange column to get the percentage for F18. In this example, $98,731 in Jan 2012 had the same buying power as $132,139 in April of 2023. 132139/98731=1.3383....., so that's 33.83% that you then enter into box F18. Change the number of years you want to divide by in F22 to get your YOY results.
As you can see from the example, the average realized raise YOY since 2011 is less than .6% when adjusted for inflation.
The absurdity of passing a 5 year CBA extension with no attempt made to negotiate for increased raises becomes abundantly clear when you actually look at the numbers.
You can enter your own info to determine your realized raises by entering your Base Pay for the first year in which you were fully certified on January 1st in the orange column for that year. Then, go to the CPI Calculator link, enter your base pay for the January of that year and get the output for the "Same buying power as" for April 2023. Divide the "same buying power as" number by your starting base pay you entered in the orange column to get the percentage for F18. In this example, $98,731 in Jan 2012 had the same buying power as $132,139 in April of 2023. 132139/98731=1.3383....., so that's 33.83% that you then enter into box F18. Change the number of years you want to divide by in F22 to get your YOY results.
As you can see from the example, the average realized raise YOY since 2011 is less than .6% when adjusted for inflation.
The absurdity of passing a 5 year CBA extension with no attempt made to negotiate for increased raises becomes abundantly clear when you actually look at the numbers.
