Orlando or Bust…How To Make The Cost Attractive!

Last week I posted about all of the great deals that were available to you if you signed up early for next year’s SolidWorks WORLD. Even though those are great deals you may still get some resistance from your management because of the price that is still there. This week I am going to show what I used last year to analyze the cost of the event compared to the productivity gains that you will come back with after SolidWorks WORLD.

Below is a screen shot with generic numbers that I put in for this post. This is a simple Microsoft Excel spreadsheet that I created that I gave to the owners of my company so that they could compute their return on investment for sending me to SolidWorks WORLD.

The 2 manual input boxes that you can fill in are the Hourly Wage cell and the SolidWorks WORLD Productivity Increase (Percentage) cell. The Hourly Wage cell is self explanatory, fill it in with your hourly wage. The SolidWorks WORLD Productivity Increase (Percentage) cell is the one that you can adjust to make the Amount In Saved Wages cell come out to would they would like to see.

Here are the calculations I used to generate all of my numbers that you see.

Total Hours Worked Per Week (Non Overtime) = 52 x 40 (weeks per year*hours per week)

Hourly Wage = Manual Input

Pre Tax Wages Paid Per Year = Total Hours Worked Per Week (Non OT) x Hourly Wage

SolidWorks WORLD Productivity Increase (Percentage) = Manual Input

Total Hours Worked After Productivity Increase = Total Hours Worked Per Week – (Total Hours Worked Per Week x Productivity Increase)

Pre Tax Wages Paid Per Year After Productivity Increase = Total Hours Worked After Productivity Increase x Hourly Wage

Amount In Saved Wages = Pre Tax Wages Paid Per Year – Pre Tax Wages Paid Per Year After Productivity Increase

I think all of this is pretty self explanatory. This tool is great for those that need to see specific numbers in front of them to show their return on investment. I definitely helped me last year in my attempts to convince management to send me to SolidWorks WORLD 2008 in San Diego, California.

Feel free to use my spreadsheet for your own use. You can find it here: SolidWorks WORLD Productivity Increase Cost Analysis. You will need Microsoft Excel 97 or newer to view it. To unlock the cells so that you can see my formulas the password is rocksolid.

If you have any additional questions feel free to email me. I am here to help you get to Orlando this coming February for SolidWorks WORLD 2009.