Re: Labor costs for estimates

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Roger,
the get_bacon@xxxxxxxx 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" <roger@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:Od%23bOqMPHHA.1248@xxxxxxxxxxxxxxxxxxxxxxx
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
get_bacon@xxxxxxxx ??

--
Regards

Roger Govier


"CIL" <Get_bacon@xxxxxxxx> wrote in message
news:QMtsh.65210$kn7.798@xxxxxxxxxxxxxxx
Thanks Roger for the quick and accurate help.

Thanks again and hope you have a good weekend.


"Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OUpsJSMPHHA.448@xxxxxxxxxxxxxxxxxxxxxxx
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" <Get_bacon@xxxxxxxx> wrote in message
news:X9tsh.4129$Yu6.1574@xxxxxxxxxxxxxxx
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









.

Relevant Pages

  • Re: Labor costs for estimates
    ... Roger Govier ... Profit uplift of 15% ... overhead costs are a % that is in a cell and can be ... Profit is at 15% of direct labor ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Labor costs for estimates
    ... overhead costs are a % that is in a cell and can be changed ... Profit is at 15% of direct labor ... profit to still be able to be changed and show me what the Direct ...
    (microsoft.public.excel.worksheet.functions)
  • Labor costs for estimates
    ... 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 ... Profit is at 15% of direct labor +overhead. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Labor costs for estimates
    ... Total Hourly Rate $ 45.75 ... I have the sheet as above with a known value for direct labor of $31.70, ... Profit is at 15% of direct labor +overhead. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Labor costs for estimates
    ... Total Hourly Rate $ ... Profit is at 15% of direct labor +overhead. ...
    (microsoft.public.excel.worksheet.functions)