Direct Labor $ 31.70
Overhead $ 8.08
Total Cost $ 39.78
Profit $ 5.97
Total Hourly Rate $ 45.75


I have the sheet as above with a known value for direct labor of $31.70,
overhead costs are a % that is in a cell and can be changed currently they
are 25.5%, Profit is at 15% of direct labor +overhead.

I need to have a sheet set up with the same layout except that I will have a
known Total hour rate, I would like for the overhead and profit to still be
able to be changed and show me what the Direct labor would be.

In other words if I bid a job for $50 p/hour and had overhead cost of 25.5%
and profit at 15% of that total; what could I offer a potential employee to
work (direct labor)? I would be able to change the overhead and profit
individually and do a what / if.

Thanks in advance and hope all have a Great weekend,

cil