After the last mediation session, there were a lot of questions from our membership about what all the numbers mean between what the city is proposing and what our union is attempting to maintain. Well, our amazing Luke Cotton took it upon himself to create a document that allows us to input specifics (for example: job title, family or single medical, full or part time employee status and wage step of position) so that we can see the difference between the proposals/supposals. It’s not perfect, but a lot of work has been put into it. It doesn’t include all the economic items, but does give a rough idea.

For folks who want to play with this calculator, you will need Excel 2010+. You’ll notice that there is a monthly breakdown of fiscal year three down at the bottom, this is to help illustrate the HSA. The medical is an estimate based off of what we pay currently. Just make your changes in the Orange boxes to reflect what you would like to see and let Luke know if you have any questions!

Click on the link below to open the calculator.




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s