Re: varying pay rates

you are correct i may have been off with the numbers. The important
issue i am having is getting my totals. I should have elaborated...
when my sub-contractor crosses a pay rate they don't assume the higher
pay rate on the previous hours. see example below:

Rate table:
Client | Subcontractor | rate 1|rate 2|rate 3
Joe Sample|Joe Professional|50|60|70
-----------------------------------------------------------
Joe Professional's rates are established as 50/60/70
I established with joe P that with THIS client:
first 20 hours will be 50/hr
second 10 hours (20-30) will be 60/hr
30+ hours will be 70/hr

Joe Pro worked 35 hours on this client and needs to be billed as
follows
20*50=500
10*60=600
5*70=350
----------------------
tot 1450

now i need a query to build in this logic correctly

Thanks!


On Jan 29, 7:40 pm, "Dominic Vella" <dominic.ve...@xxxxxxxxxxxxxxx>
wrote:
Ok, your maths does not make any sense.
First, they worked 19, so I figure that's level 1 all sown up
They work another 20, so I figure that's 10 more at level 2
and 10 more at level 3

your example says if 20 more, then
level 1: 1hr
level 2: 10hr
level 3: 8hr

I realise that adds up to 19, not 39 (19+20). If we are adding up the
initial 19, then what had the 20 to do with any of this?.
Also, why is there 1hr at level 1 at all when 19 hours had already been
satisfied.

You can't figure this out because, to me, your question didn't make any
sense.

Dominic Vella

<sam...@xxxxxxxxx> wrote in message

news:455dd227-c490-4d57-8a3f-a4beed0145bb@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I am developing a db and i have 3 rate levels. the subcontractor
begins at level1 (1-19 hours). when she performs 20-29 hours they fall
into level 2 and 30+ falls into level 3. I have the payrates in a
table attached to the client because of fluctuation of pay rates
between clients. i need to spit out total amount owed to the
subcontractor.
my problem is this. If they currently have 19 hours and they performed
an additional 20 during this period i will need to bill 1 hour at
level 1;10 hours at level 2 and another 8 at level 3. Can someone
please help me figure this out


.

Relevant Pages

  • Re: varying pay rates
    ... You should be able to figure out how to calculate subcontractor cost ... Your rate table structure falls apart when the client has more than ... issue i am having is getting my totals. ... Joe Sample|Joe Professional|50|60|70 ...
    (comp.databases.ms-access)
  • Re: Projects with All Big Clients: SharePoint Expert ()
    ... Pay Rate: $open ... Client needs a SharePoint Expert with 1-2 implementations with MOSS ... Plus Point if the Consultant is a MVP ...
    (microsoft.public.sharepoint.portalserver)