Go to Frank's home page by clicking below

Tuesday, January 11, 2011

Where Have I been?

you are probably wondering why I haven't posted a blog in months. Well, I forgot and lost my sign in information and couldn't get on here to post anything. Brilliant, Huh?

Well here is some usefull stuff . . .

I've recently read some on-line comments from contractors regarding the issue of employees complaining about fees that they have to charge customers. . . Here is what I have to say about that . . .

First . . . if you need to show your folks what things cost, here is a great tool for you to use. You may want to print these directions. (you must have MS Excel for it to work)

1.Go to my website www.frankpresents.com, click on Tools & Tips.
2.Click on "Hourly Rate Calculator"
3.You may want to save it, remember where you saved it.
4.Add up all of your monthly overhead costs, rent, utilities, office staff, management, benefits costs of office and management, advertising, charity, phone, office equipment, office supplies, etc. etc. Divide it by the number of fulltime technicians and installers and put that number in line number 42, column B.
5.Starting at the top, in column B, begin entering the per technician installer dollar amounts as indicated from column A.
6.Do not enter anything in the red column
7.On number 38, enter the average billed hours per year per technician. Typically this will be in the range of 1350 to 1550 per tech per year. (there are 2080 potential billable hours per year)
8.On line 46 enter what net profit you would like to make per hour.
9.The amount on line 48 indicates what you need to charge per hour.
10.Save this info, you may now create an Excel sheet for each person that works for you by entering their individual pay and billed hours into the program.
Keep in mind that the "Hourly Rate Calculator" program does not take into consideration overtime, parts & product sales or trip charges. Should you have any questions or comments, please email me at frankpresents@gmail.com

No comments:

Post a Comment