General questions/worksheet functions

[Chrisgiann]

I am a Bank Area Manager in GREECE.
I have a total of 17 branches in my authority and I need
a formula for the following project:
I have to assign the branches a budget for the second
semester. The increase on the original Area total balance
(S1 - first semester) should be 20%
(S2 = S1 + 20%S1).
The total balance for 17 branches on June 30th was 1000.
The total balance on December 31st must be 1200.
(Increase= 20%)
I dont want to give equal increase for all brances.
What should the respective increase be for each branch,
given that the increase should be inversely proportional
to the outstanding balance (the branches with higher
balances need to have a smaller increase, whereas the
ones with lower balances need to have a larger increase)?
The minimum increase must be 10% and maximum 30%
Here are the balances of the 17 branches in the first
semester.

Nos Jun December
1 100 100 + ?
2 95 95 + ?
3 94 94 + ?
4 91 91 + ?
5 85 85 + ?
6 80 80 + ?
7 70 70 + ?
8 65 65 + ?
9 61 61 + ?
10 48 48 + ?
11 44 44 + ?
12 39 39 + ?
13 36 36 + ?
14 31 31 + ?
15 26 26 + ?
16 25 25 + ?
17 10 10 + ?
TOTAL 1000 1200
INCREASE : 200 (20%)

 

[anonymous]

-----Original Message-----
I am a Bank Area Manager in GREECE.
I have a total of 17 branches in my authority and I need
a formula for the following project:
I have to assign the branches a budget for the second
semester. The increase on the original Area total balance
(S1 - first semester) should be 20%
(S2 = S1 + 20%S1).
The total balance for 17 branches on June 30th was 1000.
The total balance on December 31st must be 1200.
(Increase= 20%)
I dont want to give equal increase for all brances.
What should the respective increase be for each branch,
given that the increase should be inversely proportional
to the outstanding balance (the branches with higher
balances need to have a smaller increase, whereas the
ones with lower balances need to have a larger increase)?
The minimum increase must be 10% and maximum 30%
Here are the balances of the 17 branches in the first
semester.

Nos Jun December
1 100 100 + ?
2 95 95 + ?
3 94 94 + ?
4 91 91 + ?
5 85 85 + ?
6 80 80 + ?
7 70 70 + ?
8 65 65 + ?
9 61 61 + ?
10 48 48 + ?
11 44 44 + ?
12 39 39 + ?
13 36 36 + ?
14 31 31 + ?
15 26 26 + ?
16 25 25 + ?
17 10 10 + ?
TOTAL 1000 1200
INCREASE : 200 (20%)

.

If you cant figure that out then why are you the manager?