Hi R.Michael thanks for the speedy response. Please note that I can not open the document in the above link, could you attach to an e-mail and send? My e-mail address is [email protected].
To answer your question above, the calculator I am requesting is for a staffing organization and will be used for candidate pricing, salary negotiation and profit/loss evaluation. The idea for the calculator is to allow for speedy calculation of data points involving pay, burden, GP, and markup. For example, if I wanted to provide pricing for a Programmer for one of my clients, I would input a pay rate, bill rate, and fixed burden of lets say 20%, I would need for the calculator to tell me my expected GP earnings per hour (40 hour work week), my GP% and the markup for the deal. In addition to that, it would be nice to see what the overtime figures would look like as well, considering the standard time and a half model (1.5hr). So adding in an overtime input of 1.5, I would expect you to create the following calculator imbedded in an excel spread:
Pay Rate: $31.00 Hr.
Bill Rate: $50.00
Burden: 20% (Fringe Benefits)
GP Hourly with Overtime:
Thank you and I look forward to your reply!
PC Guy only
I received your response with regard to the GP Calculator, thanks. Could you please take a look at your Markup outputs on the spreadsheet. My math place the markup's much higher than your figures. Also, could you please replace the GP/Hour + overtime column with Bill Rate w/OT. For example if the Bill Rate is $100hr, please auto populate the BR w/OT column for $150hr. Last, I need for the % marked off by 2 decimal spaces, for example please populate 23.94% instead of 24%. Thanks
Hi, please take a look at the example calculator on the attached link to make better sense of what I am looking for, just "plug and play" to create the data points. The only difference is that I will need to calculate overtime. Thank you