2010 IPG Employee Benefits and Compensation Survey Input

Instructions for Survey Input

Download your electronic input forms for the 2010 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,” and note the improvements to the pay input sheets 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.

>>Download the Zip file

Files in the Downloadable Zip file:

  1. IPG 2010 Organization Information (MS Excel) – For inputting data about your organization and some HR trends.
  2. IPG 2010 Benefits (MS Excel) – For reporting your benefit plan provisions and costs.
  3. IPG 2010 Compensation (MS Excel) – For reporting your pay policies and practices, and pay rates for jobs.
  4. IPG 2010 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 May 1, 2010. Return your completed files to IPG by email (survey@ipgbenefits.com) or on disk no later than Friday, June 4.

Which Forms to Complete

  • If you are participating in the entire survey, print "IPG 2010 Job Descriptions & Input Instructions" for reference, and complete "IPG 2010 Organization Information," "IPG 2010 Benefits" and "IPG 2010 Compensation."
  • If you are participating only in the benefits section, complete "IPG 2010 Organization Information" and "IPG 2010 Benefits."
  • If you are participating only in the compensation section, print "IPG 2010 Job Descriptions & Input Instructions" for reference, and complete "IPG 2010 Organization Information" and "IPG 2010 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 more than 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.

NEW THIS YEAR: PERCENTILE PAY REPORTING

In a change from prior years, organizations will now be reporting pay information for each job incumbent. That means that if you have four employees in the job, you will enter four rows of pay information. This provides two important benefits:

  • You can more easily cut and paste data from a payroll/HRIS download into the Excel input sheet.
  • The improved survey report will include percentiles as well as average pay.

>> See complete list of jobs included

The survey covers the geographic region from the Upper Valley area of New Hampshire and Vermont, south to Keene, NH and Brattleboro, VT on both sides of the Connecticut River; east into New Hampshire as far as Peterborough and Hillsborough.

Organizations may choose to participate in:

  • The entire benefits and compensation survey, which includes a final report of more than 200 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 September.

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 2010 survey participation fee is $275, which includes a final report of more than 200 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.