What_If, Goal_Seeker, Solver???

A

aeiou

I am trying to find the *smallest increase* of % in fees collected to
get a breakeven in sales using these 3 functions i suppose. I have
tried several times and feel that Solver is the function to use, but i
am having problem with the contrictions! Is there anyway to put in a
constriction such that i can have the *SAME* percentage increase for
all Customers' fees? E.g. 20% increase for all customers' fees?

Please help :( :( . If solver is not the function please guide me
along....Thanks a bunch!!
 
M

MrShorty

How's your spreadsheet set up? It seems to me that the easiest wa
might be to choose an out of the way cell and place the % increas
there. Then link the % increase for each customer to that one cell
 
R

Roger Govier

Is it not just a straight calculation? Suppose
A1 = Last year's fee income
B1 = This year increase in Costs
C1 = B1/A1 Format>Cell>Number>Percentage

Multiply each Customer's This year's fees by (1+C1)
 
Top