Stay informed! Sign up for home email.

Question or comment? Email Negotiations

Lunchtime Meetings Email Negotiations

Updated Contract Offer Impact Calculator - See how Boeing's contract offers impact your paycheck.

SPEEA revised its contract offer impact calculator to show how Boeing’s latest offer compares to the Sept. 13 offer, and an extension of the 2008 - 2012 Puget Sound Prof & Tech contracts.

What this calculator does:

  • Based on variable input, this calculator will determine the incremental annual value of the changes in Boeing’s offers and compare them to the 2008 - 2012 SPEEA Puget Sound Prof & Tech contracts.

  • This calculator models annual gains due to changes in base salary, medical and dental plan premiums, incentives for participation in health risk assessment/biometric surveys and penalties for smoking. 

How to use the calculator:

  • This calculator works best on a PC using MS Excel. It should also work on a MAC. It will not work using Google Docs.

  • The calculator works for either the Prof or Tech unit member.

  • Change any number or variable that is highlighted green.  If you are salaried, type in your annual base salary.  If you are an hourly employee, type in your annual base earnings (hourly rate x 2080).

  • The spreadsheet is locked, but without a password.  To unlock, click on “review”, then “unprotect sheet”. If you break the spreadsheet, you can download another and start from scratch.

  • Columns B-G contains data used for the analysis.  Medical plan premiums used are from the Boeing offers that includes general Boeing assumptions. Dental premiums used are current costs for dental times 8% trend per year. Feel free to browse the formulas.

What the calculator assumes:

  • This model assumes that you will receive the entire “salary pool” amount, and that is not always the case.   With fewer funds available to reward high performers, it is not unreasonable to assume that more individuals will receive less than the “salary pool” amount than in the past 4 years.

  • This model assumes Washington state medical and dental premiums.  Separate spreadsheets will be developed for Oregon and Utah at a later date.

  • The calculator assumes salaries are increased 1/1 of each year, so it will not match your actual annual income, but it is valid for high level comparison purposes.  

  • The calculator does not have the option for the scheduled dental plan.  The scheduled dental plan is to be eliminated in 2014, and premiums for dental do not start until 2016.

What the Contract Offer Impact calculator does not do:

  • This calculator ignores overtime.

  • This calculator ignores EIP.  EIP is in your current contract and in the company offer.  Since there is no change, it is not modeled.

  • The calculator ignores inflation.  Inflation will happen regardless of which contract you receive, and it will reduce the “utility” of future money.

This calculator ignores the effects of the reduced healthcare benefits in Boeing’s offers.  Deductibles, co-pays and coinsurance have all changed, reducing your benefit when you actually use the healthcare.