 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / January 2008varying 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 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 >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 [quoted text clipped - 6 lines] > level 1;10 hours at level 2 and another 8 at level 3. Can someone > please help me figure this out 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...@optusnet.com.au> wrote: > Ok, your maths does not make any sense. > First, they worked 19, so I figure that's level 1 all sown up [quoted text clipped - 30 lines] > > level 1;10 hours at level 2 and another 8 at level 3. Can someone > > please help me figure this out 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. >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... [quoted text clipped - 59 lines] >> > 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 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 > 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... [quoted text clipped - 59 lines] >> > level 1;10 hours at level 2 and another 8 at level 3. Can someone >> > please help me figure this out |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.