Spreadsheet: 64751d1265605074-saving_calculation-saving_calculation
Sheet: Sheet1

Circles | Saving/Month/Site |  | Annual Plan for  Cost Reduction
 |  | [NAME] 10 Exit | April 10 | May 10 | June 10 | July 10 | Aug 10 | Sep 10 | Oct 10 | Nov 10 | Dec 10 | Jan 11 | Feb 11 | Mar
State 1 | 23000 | 6 | 5.188732394366197 | 4.53456555954639 | 4.094292803970223 | 3.722084367245658 | 3.349875930521092 | 2.977667493796526 | 2.977667493796526 | 2.977667493796526 | 2.977667493796526 | 2.977667493796526 | 2.977667493796526 | 2.977667493796526
State 2 | 9000 | 220 | 190.2535211267606 | 166.2674038500343 | 150.1240694789082 | 136.4764267990075 | 122.8287841191067 | 109.1811414392059 | 109.1811414392059 | 109.1811414392059 | 109.1811414392059 | 109.1811414392059 | 109.1811414392059 | 109.1811414392059
State 3 | 7000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
State 4 | 13000 | 295 | 255.112676056338 | 222.9494733443642 | 201.302729528536 | 183.0024813895782 | 164.7022332506204 | 146.4019851116625 | 146.4019851116625 | 146.4019851116625 | 146.4019851116625 | 146.4019851116625 | 146.4019851116625 | 146.4019851116625
State 5 | 13000 | 61 | 52.75211267605634 | 46.10141652205497 | 41.62531017369727 | 37.84119106699752 | 34.05707196029777 | 30.27295285359801 | 30.27295285359801 | 30.27295285359801 | 30.27295285359801 | 30.27295285359801 | 30.27295285359801 | 30.27295285359801
State 6 | 13000 | 113 | 97.72112676056338 | 85.40098470479035 | 77.1091811414392 | 70.09925558312655 | 63.08933002481389 | 56.07940446650122 | 56.07940446650122 | 56.07940446650122 | 56.07940446650122 | 56.07940446650122 | 56.07940446650122 | 56.07940446650122
State 7 | 20000 | 8 | 6.918309859154929 | 6.04608741272852 | 5.459057071960297 | 4.962779156327544 | 4.466501240694789 | 3.970223325062034 | 3.970223325062034 | 3.970223325062034 | 3.970223325062034 | 3.970223325062034 | 3.970223325062034 | 3.970223325062034
State 8 | 22000 | 17 | 14.70140845070422 | 12.84793575204811 | 11.60049627791563 | 10.54590570719603 | 9.491315136476427 | 8.436724565756823 | 8.436724565756823 | 8.436724565756823 | 8.436724565756823 | 8.436724565756823 | 8.436724565756823 | 8.436724565756823
State 9 | 23000 | 45 | 38.91549295774648 | 34.00924169659793 | 30.70719602977667 | 27.91563275434244 | 25.12406947890819 | 22.33250620347394 | 22.33250620347394 | 22.33250620347394 | 22.33250620347394 | 22.33250620347394 | 22.33250620347394 | 22.33250620347394
State 10 | 37000 | 27 | 23.34929577464789 | 20.40554501795876 | 18.42431761786601 | 16.74937965260546 | 15.07444168734491 | 13.39950372208436 | 13.39950372208436 | 13.39950372208436 | 13.39950372208436 | 13.39950372208436 | 13.39950372208436 | 13.39950372208436
State 11 | 29000 | 14 | 12.10704225352113 | 10.58065297227491 | 9.553349875930522 | 8.684863523573203 | 7.816377171215882 | 6.94789081885856 | 6.94789081885856 | 6.94789081885856 | 6.94789081885856 | 6.94789081885856 | 6.94789081885856 | 6.94789081885856
 | Total
 |  | Circles | Saving on reducing sites
 |  |  | April 10 | May 10 | June 10 | July 10 | Aug 10 | Sep 10 | Oct 10 | Nov 10 | Dec 10 | Jan 11 | Feb 11 | Mar
 |  | State 1
 |  | State 2
 |  | State 3
 |  | State 4
 |  | State 5
 |  | State 6
 |  | State 7
 |  | State 8
 |  | State 9
 |  | State 10
 |  | State 11
 |  | Total
 | In [NAME] end, we have 806 sites. Intent is to reduce it to 400 sites by Mar 11. There by reducing about 406 sites.
 | Month-on-Month Plan for reduction of sites is attached. What I need is to calculate the saving achieved by reduction of 406 sites in a year.
 | Things to consider is that if we reduce 109 sites in Apr'10, we would have the saving on these sites for rest of 11 months. Similarly on 88 sites in May'10, we would have
 | saving for rest of 10 months. I am unable to arrive at any logic/formulae to calculate the saving accuring for the whole year for different states.