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
~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 -
Bookmarks