varying pay rates

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

Re: varying pay rates

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

wrote in message
news:455dd227-c490-4d57-8a3f-a4beed0145bb@d4g2000prg.googleg roups.com...
>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

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"
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
>
> wrote in message
>
> news:455dd227-c490-4d57-8a3f-a4beed0145bb@d4g2000prg.googleg roups.com...
>
> >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

Re: varying pay rates

I believe you need to rethink your scenerio,
all 35 hours are billed at 50 per hour = 1750
15 hours (35-20) are at 10 per hour premium = 150
5 hours are (35-30) are at an additional 10 per hour premium = 50
total = 1950
You should be able to figure out how to calculate subcontractor cost
from this.

Your rate table structure falls apart when the client has more than
one project under seperate contracts using the same subcontractor but
different rate schedules. e.g.
Client | Subcontractor | rate 1|rate 2|rate 3|rate 4
Joe Sample|Joe Professional|40|60|80|100
Looks like some more normalization needs done to this section of your
DB.

On Wed, 30 Jan 2008 10:22:33 -0800 (PST), sammyl@gmail.com wrote:

>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"
>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
>>
>> wrote in message
>>
>> news:455dd227-c490-4d57-8a3f-a4beed0145bb@d4g2000prg.googleg roups.com...
>>
>> >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
>

Have a nice day. ldpoos@NOPANTS.juno.com

Remove NOPANTS. To reply by direct E-Mail;
Support: The Right to Privacy and Anti-SPAM projects

Re: varying pay rates

I hope this helps

Sub CalcPay( intHours as Integer) as Currency
Dim curResult as Currency

curResult = intHours * 50
intHours= intHours - 20
If intHours > 0 Then
curResult = curResult + (intHours * 10)
intHours = intHours - 10
If intHours > 0 Then
curResult = curResult + (intHours * 10)
End If
End If

CalcPay = curResult
End Sub


Dom

wrote in message
news:ef14c276-702f-49a1-ae20-e562a6ba6ad3@e10g2000prf.google groups.com...
> 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"
> 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
>>
>> wrote in message
>>
>> news:455dd227-c490-4d57-8a3f-a4beed0145bb@d4g2000prg.googleg roups.com...
>>
>> >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
>
>