2009 IPG Employee Benefits and Compensation Survey Input
Instructions for Survey Input
Download your electronic input forms for the 2009 IPG Employee Benefits and Compensation Survey here. The forms come together in a zipped file, which you can unzip on your own PC. Be sure to read "Which Forms to Complete" before you start entering data into the forms.
If you need assistance in downloading the forms, or have questions about them, call Winnie Skeates at 603-924-7750, or email wskeates@ipgbenefits.com.
Files in the Downloadable Zip file:
- IPG 2009 Organization Information (MS Excel) - For inputting data about your organization and some HR trends.
- IPG 2009 Benefits (MS Excel) - For reporting your benefit plan provisions and costs.
- IPG 2009 Compensation (MS Excel) - For reporting your pay policies and practices, and pay rates for jobs.
- IPG 2009 Job Descriptions & Input Instructions (Adobe PDF) - Contains descriptions for the survey jobs, and instructions on how to enter data into the spreadsheet. Print this document if you are participating in the compensation section of the survey.
A note about the Excel files: These files contain macros, which were created to help you navigate easily from worksheet to worksheet. If you disable the macros, the input forms are usable, but the navigation buttons on the worksheets will not work.
Be sure to save each file with a new file name that includes the name of your organization.
Input Dates
Please report all data in effect as of April 1, 2009. Return your completed files to IPG by email (survey@ipgbenefits.com) or on disk no later than Monday, May 4.
Which Forms to Complete
- If you are participating in the entire survey, print "IPG 2009 Job Descriptions & Input Instructions" for reference, and complete "IPG 2009 Organization Information," "IPG 2009 Benefits" and "IPG 2009 Compensation."
- If you are participating only in the benefits section, complete "IPG 2009 Organization Information" and "IPG 2009 Benefits."
- If you are participating only in the compensation section, print "IPG 2009 Job Descriptions & Input Instructions" for reference, and complete "IPG 2009 Organization Information" and "IPG 2009 Compensation."
About the Survey
The survey covers employee benefit programs and direct pay. The benefits portion includes comprehensive data on program features and costs for health and dental plans, disability plans, life insurance, retirement plans, holidays, vacation and combined time-off plans. The compensation section provides pay rates for over 90 jobs commonly found in local organizations, including breakouts by geographic region and organization revenue size. In addition to pay rates, the survey also includes pay increases and budgets, salary ranges and FLSA exemption, on-call pay, shift differentials, work schedules and hours.
>> See complete list of jobs included
The survey covers the geographic region from the Hanover, New Hampshire area, south to Keene, NH and Brattleboro, VT on both sides of the Connecticut River; east into New Hampshire as far as Peterborough and Hillsborough, and west into Vermont to include Brattleboro, Springfield and towns like Grafton and Chester.
Organizations may choose to participate in either:
- The entire benefits and compensation survey, which includes a final report of over 230 pages of useful benefits and compensation information,
- The benefits section only, or
- The compensation section only.
The survey participation fee is the same, regardless of the option chosen. If an organization chooses to participate in only the benefits section or only the compensation section, the organization will receive only that portion of the survey report for which it provided data (except for small companies--see below). For example, if you provide input data for only the benefits questions, your final survey report will include only the benefits portion of the survey.
A note about participating organization size: We typically find that smaller organizations either do not have benchmark jobs, or pay them significantly lower or higher rates than larger organizations, which can skew the survey results. For this reason, we ask that organizations with fewer than 75 employees provide data input only in the benefits section of the survey. These organizations will receive the entire survey report, including the compensation information.
The survey report is published in August.
Who Participates
Past participants include more than 90 manufacturers, technology companies, healthcare providers, printers/publishers, banks, and other organization types.
>> See list of participating organizations
Pricing
The 2009 survey participation fee is $275, which includes a final report of more than 250 pages of useful benefits and compensation information. Participants will be invoiced when the survey report is published. Non-participants will be able to purchase the survey report for a price of $550.