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.