[NCnc2]

I need help with both manual calculations & excel problem setup. My Boss wants me to setup an input program in excel that would output a solution. I need to input an expected average reimbursement rate, but the program needs to output two information: the base Reimbursement Rate AND the Time-Half Reimbursement Rate, given a total hours of 60,000 as an example ( or any other number of hours).

CASE OR SITUATION:
1) I will bill client a base rate and an overtime rate.
2) I pay the employees a base rate and an overtime rate.
3) My current Billing Rate is $27 regular hours, and $40.5 in overtime
4) Our average payroll cost, based on the total hours worked is $30

DESIRE OUTCOME
1) I need to input an expected average billing rate per hour. For example $38
2) The program should tell me the split between a base and overtime billing rate. Meaning that I will input one number that is the average expected billing rate, and the program would tell me how much should be my base billing and my overtime billing.
If you need additional information, please let me know.

Thank you for any suggestions.

[NCnc2]

@Calvinus:

You have a twisted mind with numbers:), (in a good way of course). Studying your thought process, you have taken me to places so deep in extracting relationship between ratios that it hurts. You have definitely opened my mind to exploring the possibilities between sets of ratios that are not visually or easily understood. You are indeed very unique.

Thank you for everything.

[NCnc2]

@ Bobby


@Calvinus:

Thank you @Bobby and @Calvinus for you wonderful input. Our team has decided to utilize both of your formula. We have set them up in an excel and ready to go.

Thank you all for your wonderful and gracious responses.

Sincerely,
MS

[Anonymous]

Ha, I've known some really smart math/science people in college though.

The TA's in my physics and calculus classes could solve any problem in the textbook, and it was apparent they had not prepared at all and were seeing the problems for the first time. What b******ds.

[Author]

Replies