Re: Labor costs for estimates

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

Hi

the get_bacon@xxxxxxxx is a fake
How disappointing<vbg>

All that is needed is to remove NOSPAM
--
Regards

Roger Govier


"CIL" <Get_bacon@xxxxxxxx> wrote in message
news:WIush.13378$8U4.12870@xxxxxxxxxxxxxxx
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
    ... overhead costs are a % that is in a cell and can be changed ... Profit is at 15% of direct labor +overhead. ...
    (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 $ ... 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)