Wage and Benefits Survey Form - Labor Contract

morrisg

We are preparing for our labor contract negotiations and part of that involves conducting an area wage and benefits survey. I would prefer to do this using email and an attached form that could be easily completed, saved and sent back to me. In the past I have sent out Excel Sheets and asked people to complete, and save before sending back to me, but they often fail to save before returning and thus I receive a blank form. While I am an HR Manager myself, I even find some HR Managers who have trouble working through an Excel sheet. I guess it’s that right brain stuff.  I think I would get a better response if my form looked more professional and easier to use.

Is anyone aware of a simple way that I could develop a form that makes it easy for people to complete and save before retuning to me? Does anyone have something like this already that they would be willing to share?

Most of what I ask is “fill in the blank” type questions, such as Who their medical carrier is, amount employees pay for medical, the amount of deductible, percentage amount of wage increase for each year of the contract, number of holidays etc.