Mathematical Question

Hi,

Im really hoping that someone from this forum could help me arrive with an excel formula for my problem. Here's the Problem.

I have 10 apple pickers and each of them are expected to pick 20 apples a day, they receive $1 for each apple picked, but they can not get more than $20 even if they have picked more than 20 apples in a day.

I sell the apples for $1.5 each, with 10 employees picking 20 apples a day I expect to get a net income of $100 a day.
Net income = (10 apple pickers * 20 apples a day * $1.5) - (10 apple pickers * $20)

But my employees do not meet their target of 20 apples a day, on an average they can only pick 18 apples each a day.

I need a formula that would help me compute for how many extra employees do i need so i can always meet my net income of $100 a day given that my employees can only pick 18 apples a day.


Regards.

Fire all your apple pickers! I will gladly pick apples if you are goining to pay a dollar per apple.

Each of your apple pickers income is governed by the following equation:

=if(apples >= 20, employeeIncome = 20, employeeIncome = apples)

You would next sum the total of all apple pickers income

=sum(applePickersIncome)

Income you expect to make = $100

Income made from selling apples = $1.50 * total apples picked

How much more income required = $100 - income made from selling apples.

I just created a much simpler example than my real problem. I have picked some ideas on how to solve my problem from the ideas that you have given.

Thanks a lot

Salam