1) I am asked to find the smallest percentage fee increase needed to get
a surplus instead of a deficit (to 1 decimal place).

2) What is the smallest percentage increase in fees needed to turn
deficit into surplus if you waive the discount and the maximum fee? (Do
not change the formulas)

*Discount are given to children with siblings
*All fees are to increase by the same percentage
*The Maximum and Minimum Fees are to increase by the same percent.

'EXCEL FILE'
(http://s9.yousendit.com/d.aspx?id=16...L2JFU26V1482JV )

~Please try to limit the functions within Solver, Goal Seeker and What
If.



Thanks a million!! I've been trying to solve this prob for days :( :(
-


--
aeiou
------------------------------------------------------------------------
aeiou's Profile: http://www.excelforum.com/member.php...o&userid=25595
View this thread: http://www.excelforum.com/showthread...hreadid=392402

Try taking a peek at Goal Seek under Tools Goal Seek.

aeiou wrote:
1) I am asked to find the smallest percentage fee increase needed to get
a surplus instead of a deficit (to 1 decimal place).

2) What is the smallest percentage increase in fees needed to turn
deficit into surplus if you waive the discount and the maximum fee? (Do
not change the formulas)

*Discount are given to children with siblings
*All fees are to increase by the same percentage
*The Maximum and Minimum Fees are to increase by the same percent.

'EXCEL FILE'
(http://s9.yousendit.com/d.aspx?id=16...L2JFU26V1482JV )

~Please try to limit the functions within Solver, Goal Seeker and What
If.



Thanks a million!! I've been trying to solve this prob for days :( :(
-


--
aeiou
------------------------------------------------------------------------
aeiou's Profile: http://www.excelforum.com/member.php...o&userid=25595
View this thread: http://www.excelforum.com/showthread...hreadid=392402

Goal seek? I've tried that. The "Changing_Cell" is only for a single
cell and the cell needs to be a VALUE rather than with formulas in it.
Hence, it seems that i am only able to find the percentage change in
the total fees earned. I need to get the percentage increase for 1
child's fees.(All children's fees are to increase by the same %)


--
aeiou
------------------------------------------------------------------------
aeiou's Profile: http://www.excelforum.com/member.php...o&userid=25595
View this thread: http://www.excelforum.com/showthread...hreadid=392402