Wirt Atmar wrote:
>
> Efran writes:
>
> > The criteria is as follows:
> >  An employee gets a bonus if he misses less than
> >  160 Hours (a year).  With a max. Amount of
> > $1500.00 and a Min. Amount of $500.00
>
> For a simple straightline calculation
>
>            bonus = 1500 - 1000/160 * h
>
> where h = hours missed and the "1000/160" is the slope
> of the line (delta y divided by delta x).

Wirt, one thing that you have not taken into account is
the max of $75000 over 80 employees (a constraint from
an earlier posting).  Your equation would work from the
data given in this post, but since there are 80 employees
and a maximum of $75000, if all of the employees missed
0 hours, it would cost the company $120,000.  So, the
amount in total needs to be factored into the calculations.

--

Buz          (8

+--------------------------------------------------------------+
|  Life is a grindstone, it will either grind you down or      |
|    polish you, depending on what you are made of.            |
|    -- Rev. Curt Dalaba                                       |
+---------------------------------------+----------------------+
| This is official written notice:      | My real address is:  |
|   Please remove me from your mailing  |   lnuslad dot dzvg41 |
|   list.                               |    at eds dot com    |
+---------------------------------------+----------------------+