Varible Salary Function
 

Hi,

I would like to come up with [U][B]a[/B][/U] simplified function not (a computer code) to determine a variable salary according to the following rules.

* If work hours are 20 hours or less, the salary will be $200 per hour

* If work hours are between 20 hours to 40 hours per week the salary will be a variable amount starting at $200/h for 20-hours/week and linearly decreasing to $100/h for 40-hours/week

Thanks in advance.:smile:

200/hr for 20 hrs is $4000. 100/hr for 40 hrs is $4000.

So, you want to pay someone $200/hr for their first 20 hrs, and then 0/hr for their next 20?

[QUOTE=VBCurtis;442868]200/hr for 20 hrs is $4000. 100/hr for 40 hrs is $4000.

So, you want to pay someone $200/hr for their first 20 hrs, and then 0/hr for their next 20?[/QUOTE]

working 20 hours per week you would make 20x200=$4000
working 40 hours per week you would make 20x200+20x100=$6000
working 30 hours per week you would make 20x200+10*150=$5500

For hours <= 20: 200 * hours

For 20 < hours <= 40: -2.5 * hours^2 + 297.5 * hours - 950

For 40 < hours: 100 * hours + 2950

[QUOTE=VBCurtis;442868]200/hr for 20 hrs is $4000. 100/hr for 40 hrs is $4000.

So, you want to pay someone $200/hr for their first 20 hrs, and then 0/hr for their next 20?[/QUOTE]

That was my first thought, until I decided he means that the pay for the 40th hour is $100, not that at 40 hours, the pay must be such that the average rate is $100/hr.

My function should match the following table (generated by a python script I wrote):

[CODE]20 4000
21 4195
22 4385
23 4570
24 4750
25 4925
26 5095
27 5260
28 5420
29 5575
30 5725
31 5870
32 6010
33 6145
34 6275
35 6400
36 6520
37 6635
38 6745
39 6850
40 6950
41 7050
42 7150
[/CODE]

[QUOTE=a1call;442869]working 20 hours per week you would make 20x200=$4000
working 40 hours per week you would make 20x200+20x100=$6000
working 30 hours per week you would make 20x200+10*150=$5500[/QUOTE]

Note under your example you're offering $500 for the 31st-40th hours, which is $50/hr.
39 hrs = 4000 + 19*105 = $5995. 40 hrs = 6000. $5 for that 40th hour, eh?

Here is a more complete set:

1 200 -- $200/h
2 400 -- $200/h
3 600 -- $200/h
4 800 -- $200/h
5 1000 -- $200/h
6 1200 -- $200/h
7 1400 -- $200/h
8 1600 -- $200/h
9 1800 -- $200/h
10 2000 -- $200/h
11 2200 -- $200/h
12 2400 -- $200/h
13 2600 -- $200/h
14 2800 -- $200/h
15 3000 -- $200/h
16 3200 -- $200/h
17 3400 -- $200/h
18 3600 -- $200/h
19 3800 -- $200/h
20 4000 -- $200/h
-
21 4000+1x195=4195 -- $199.76/h
22 4000+2x190=4380 -- $199.09/h
23 4000+3*185=4555 -- $198.04/h
24 4000+4*180=4720 -- $196.67/h
25 4000+5x175=4875 -- $195/h
26 4000+6x170=5020 -- $193.08/h
27 4000+7x165=5155 -- $190.93/h
28 4000+8x160=5280 -- $188.57/h
29 4000+9x155=5395 -- $186.03/h
30 4000+10x150=5500 -- $183.33/h
31 4000+11x145=5595 -- $180.48/h
32 4000+12x140=5680 -- $177.50/h
33 4000+13x135=5755 -- $174.39/h
34 4000+14x130=5820 -- $171.76/h
35 4000+15x125=5875 -- $167.86/h
36 4000+16x120=5920 -- $164.44/h
37 4000+17x115=5955 -- $160.95/h
38 4000+18x110=5980 -- $157.37/h
39 4000+19x105=5995 -- $153.72/h
40 4000+20x100=6000 -- $150/h

Post to notify that I added salary per hour in the above post for clarity,

I get the following formula for the 21 Hours and up:



I am looking for the simplest general form to actually offer an HR dept. With different actual rates but same concept.
I do not want to overwhelm them by a complicated looking formula.

On the table you just created, look at the additional amount from 21 to 22, 22 to 23, etc. The average pay rate is meaningless- when you've already worked 22 hours, you'd like to know what you'll make for the next hour. Your method decreases the pay for hours already worked- if I've worked 35 hours already, why should the 36th reduce the rate I get for the previous 15 hours? Perhaps you should wiki "marginal revenue" for additional reading.

If you're looking for a simple formula, try 200/hr for the first 20 and some other flat rate for hours above 20. But don't most places encourage more labor per week, rather than less? Your entire concept is the opposite of overtime; the employer is incented to pile on as much work as possible, while the worker gets less and less for doing more and more work. Your 39th hour pays $15, your 40th pays $5, and your 41st would reduce the weekly wage- the worker would pay the employer for working the 41st hour!

[QUOTE=VBCurtis;442878]On the table you just created, look at the additional amount from 21 to 22, 22 to 23, etc. The average pay rate is meaningless- when you've already worked 22 hours, you'd like to know what you'll make for the next hour. Your method decreases the pay for hours already worked- if I've worked 35 hours already, why should the 36th reduce the rate I get for the previous 15 hours? Perhaps you should wiki "marginal revenue" for additional reading.

If you're looking for a simple formula, try 200/hr for the first 20 and some other flat rate for hours above 20. But don't most places encourage more labor per week, rather than less? Your entire concept is the opposite of overtime; the employer is incented to pile on as much work as possible, while the worker gets less and less for doing more and more work. Your 39th hour pays $15, your 40th pays $5, and your 41st would reduce the weekly wage- the worker would pay the employer for working the 41st hour![/QUOTE]

I am actually dealing with a real scenario.
I work under contract with a company and the contract has a fixed hourly rate (say $200 [I wish]) with guaranteed 20 hours of work per week.
Lately the work has been plentiful and I have ended up working near full-time. Now the company is offering me full-time employment at a rate of say $100. I am trying to give a counter offer that would make sense to the company. I would still have my minimum guaranteed salary and would make more if the company needs me at a reduced rate, ending up equal to what they offer me.
The setup would make sense to me and the company.

[QUOTE=a1call;442881]...
the contract has a fixed hourly rate (say $200 [I wish]) with guaranteed 20 hours of work per week.
...
the company is offering me full-time employment at a rate of say $100.[/QUOTE]There is a problem with the figures you give : at the moment you get 20 * 200 = 4000 a week plus some more if you work longer hours...
Their proposition is 4000 for a 40 hour week, meaning 100 per hour. There is no increase for all the hours between 20 and 40.

The only point in that new proposition is that they guarantee 40 hours. Is that security enough for accepting the reduction in rate.

Or is it that you would become an employee instead of a contractor ? In that case you have to weight the (dis-)advantages of that change (perhaps security, health-care, retirement fund, other perks...

Jacob