| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Labor costs for estimates
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Labor costs for estimates
Hi
With the headings in A1:A5 and the formulae in B1:B5 Assuming cell B2 holds the O/H uplift of 25% and D2 holds the Profit uplift of 15% B1 =B3/(1+C2) B2 =B3-B1 B3 =B5-B4 B4 =B5-B5/(1+D2) B5 Enter the Amount you wish to Bid 50 and B1 will return 34.64 and B2 8.83 with a Profit in B4 of 6.52 -- Regards Roger Govier "CIL" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Labor costs for estimates
Thanks Roger for the quick and accurate help.
Thanks again and hope you have a good weekend. "Roger Govier" wrote in message ... Hi With the headings in A1:A5 and the formulae in B1:B5 Assuming cell B2 holds the O/H uplift of 25% and D2 holds the Profit uplift of 15% B1 =B3/(1+C2) B2 =B3-B1 B3 =B5-B4 B4 =B5-B5/(1+D2) B5 Enter the Amount you wish to Bid 50 and B1 will return 34.64 and B2 8.83 with a Profit in B4 of 6.52 -- Regards Roger Govier "CIL" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Labor costs for estimates
|
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Labor costs for estimates
Hi
the is a fake How disappointing<vbg All that is needed is to remove NOSPAM -- Regards Roger Govier "CIL" wrote in message ... Hi Roger, the is a fake as you probably know. I once accidentally forgot to make an alias for the groups and used my real address and I was swamped with all types of spam. I removed the NOSPAM4u on your address and it was returned, what did I miss? cil "Roger Govier" wrote in message ... Hi You're very welcome. Thanks for the feedback letting me know it worked. As a former UK pig producer, I am fascinated by your email address ?? -- Regards Roger Govier "CIL" wrote in message ... Thanks Roger for the quick and accurate help. Thanks again and hope you have a good weekend. "Roger Govier" wrote in message ... Hi With the headings in A1:A5 and the formulae in B1:B5 Assuming cell B2 holds the O/H uplift of 25% and D2 holds the Profit uplift of 15% B1 =B3/(1+C2) B2 =B3-B1 B3 =B5-B4 B4 =B5-B5/(1+D2) B5 Enter the Amount you wish to Bid 50 and B1 will return 34.64 and B2 8.83 with a Profit in B4 of 6.52 -- Regards Roger Govier "CIL" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
