By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,505 Members | 1,511 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,505 IT Pros & Developers. It's quick & easy.

varying pay rates

P: n/a
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
Jan 29 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

<sa****@gmail.comwrote in message
news:45**********************************@d4g2000p rg.googlegroups.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

Jan 30 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.