Docstoc

Case Study Examples - Excel

Document Sample
Case Study Examples - Excel Powered By Docstoc
					Scenario 4 April
Headline uplifts: 2.75%, 2.4%, 2.25%
Band 1 - changes in Year 2 - remove spine point 1
Band 5 - remove spine point 21 in Year 3 and and increase top by 0.33% in Years 2, 3 and 4
Flat cash - in Year 3 - £420 to points 1 to 13

                                                                                   Without headline uplift or flat cash                                                           With headline uplift and flat cash                                  Percentage increase between points

                                             Year 1                 Year 2                           Year 3               Year 4                Year 1                  Year 2                                         Year 3                         Year 1        Year 2        Year 3
                                             2008/09                2009/10                          2010/11              2011/12               2008/09                 2009/10                                        2010/11                        2008/09       2009/10       2010/11


                                                                                                                                                                                                                              % increase                                          % increase
                                                      % increase         % increase % incr -          % increase % incr -         % increase              % increase           % increase % incr -                            on           % incr -   % increase    % increase    on
                                             2007/08 on previous 2007/08 on previous removed 2007/08 on previous removed 2007/08 on previous              on previous          on previous removed                            previous     removed    on previous   on previous   previous
Spine point 2007/08 pay       Bands           pay     year        pay    year         point   pay     year        point   pay     year            2.75%   year           2.40% year         point  Flat cash            2.25% year          point     point         point         point
          1      12,182          1             12,182       0.00%                                                                                12,517         2.75%
          2      12,577         1,2            12,577       0.00% 12,577       0.00%    3.24% 12,577        0.00%          12,577       0.00%    12,923         2.75%    13,233        2.40%     5.72%         420      13,653     3.17%                    3.24%
          3      12,914         1,2            12,914       0.00% 12,914       0.00%           12,914       0.00%          12,914       0.00%    13,269         2.75%    13,588        2.40%                   420      14,008     3.09%                    2.68%         2.68%        2.60%
          4      13,253         1,2            13,253       0.00% 13,253       0.00%           13,253       0.00%          13,253       0.00%    13,617         2.75%    13,944        2.40%                   420      14,364     3.01%                    2.63%         2.63%        2.55%
          5      13,647          2             13,647       0.00% 13,647       0.00%           13,647       0.00%          13,647       0.00%    14,022         2.75%    14,359        2.40%                   420      14,779     2.93%                    2.97%         2.97%        2.89%
          6      14,042          2             14,042       0.00% 14,042       0.00%           14,042       0.00%          14,042       0.00%    14,428         2.75%    14,774        2.40%                   420      15,194     2.84%                    2.89%         2.89%        2.81%
          7      14,437         2,3            14,437       0.00% 14,437       0.00%           14,437       0.00%          14,437       0.00%    14,834         2.75%    15,190        2.40%                   420      15,610     2.76%                    2.81%         2.81%        2.74%
          8      14,945         2,3            14,945       0.00% 14,945       0.00%           14,945       0.00%          14,945       0.00%    15,356         2.75%    15,725        2.40%                   420      16,145     2.67%                    3.52%         3.52%        3.42%
          9      15,523         2,3            15,523       0.00% 15,523       0.00%           15,523       0.00%          15,523       0.00%    15,950         2.75%    16,333        2.40%                   420      16,753     2.57%                    3.87%         3.87%        3.77%
         10      15,870          3             15,870       0.00% 15,870       0.00%           15,870       0.00%          15,870       0.00%    16,306         2.75%    16,698        2.40%                   420      17,118     2.52%                    2.24%         2.24%        2.18%
         11      16,332          3             16,332       0.00% 16,332       0.00%           16,332       0.00%          16,332       0.00%    16,781         2.75%    17,184        2.40%                   420      17,604     2.44%                    2.91%         2.91%        2.84%
         12      16,853         3,4            16,853       0.00% 16,853       0.00%           16,853       0.00%          16,853       0.00%    17,316         2.75%    17,732        2.40%                   420      18,152     2.37%                    3.19%         3.19%        3.11%
         13      17,257         3,4            17,257       0.00% 17,257       0.00%           17,257       0.00%          17,257       0.00%    17,732         2.75%    18,157        2.40%                   420      18,577     2.31%                    2.40%         2.40%        2.34%
         14      17,893          4             17,893       0.00% 17,893       0.00%           17,893       0.00%          17,893       0.00%    18,385         2.75%    18,826        2.40%                            19,250     2.25%                    3.69%         3.69%        3.62%
         15      18,528          4             18,528       0.00% 18,528       0.00%           18,528       0.00%          18,528       0.00%    19,038         2.75%    19,494        2.40%                            19,933     2.25%                    3.55%         3.55%        3.55%
         16      19,105          4             19,105       0.00% 19,105       0.00%           19,105       0.00%          19,105       0.00%    19,630         2.75%    20,102        2.40%                            20,554     2.25%                    3.11%         3.11%        3.11%
         17      19,683         4,5            19,683       0.00% 19,683       0.00%           19,683       0.00%          19,683       0.00%    20,224         2.75%    20,710        2.40%                            21,176     2.25%                    3.03%         3.03%        3.03%
         18      20,261         4,5            20,261       0.00% 20,261       0.00%           20,261       0.00%          20,261       0.00%    20,818         2.75%    21,318        2.40%                            21,797     2.25%                    2.94%         2.94%        2.94%
         19      20,801          5             20,801       0.00% 21,054       1.22%           21,066       0.06%          21,077       0.06%    21,373         2.75%    22,152        3.64%                            22,663     2.31%                    2.67%         3.91%        3.97%
         20      21,494          5             21,494       0.00% 21,878       1.79%           21,902       0.11%          21,926       0.11%    22,085         2.75%    23,019        4.23%                            23,563     2.36%                    3.33%         3.91%        3.97%
         21      22,187          5             22,187       0.00% 22,187       0.00%                                                             22,797         2.75%    23,344        2.40%                                                                3.22%         1.41%
         22      22,823          5             22,823       0.00% 22,823       0.00%           22,823       0.00%   2.87% 22,823        0.00%    23,451         2.75%    24,013        2.40%                            24,554     2.25%     5.18%          2.87%         2.87%        4.21%
         23      23,458         5,6            23,458       0.00% 23,600       0.61%           23,676       0.32%          23,728       0.22%    24,103         2.75%    24,831        3.02%                            25,471     2.58%                    2.78%         3.40%        3.74%
         24      24,383         5,5            24,383       0.00% 24,548       0.68%           24,616       0.28%          24,684       0.28%    25,054         2.75%    25,829        3.09%                            26,483     2.53%                    3.94%         4.02%        3.97%
         25      25,424         5,6            25,424       0.00% 25,509       0.33%           25,593       0.33%          25,678       0.33%    26,123         2.75%    26,839        2.74%                            27,534     2.59%                    4.27%         3.91%        3.97%
         26      26,464          6             26,464       0.00% 26,464       0.00%           26,464       0.00%          26,464       0.00%    27,192         2.75%    27,844        2.40%                            28,471     2.25%                    4.09%         3.74%        3.40%
         27      27,388          6             27,388       0.00% 27,388       0.00%           27,388       0.00%          27,388       0.00%    28,141         2.75%    28,817        2.40%                            29,465     2.25%                    3.49%         3.49%        3.49%
         28      28,313         6,7            28,313       0.00% 28,313       0.00%           28,313       0.00%          28,313       0.00%    29,092         2.75%    29,790        2.40%                            30,460     2.25%                    3.38%         3.38%        3.38%
         29      29,237         6,7            29,237       0.00% 29,237       0.00%           29,237       0.00%          29,237       0.00%    30,041         2.75%    30,762        2.40%                            31,454     2.25%                    3.26%         3.26%        3.26%
         30      30,277         6,7            30,277       0.00% 30,277       0.00%           30,277       0.00%          30,277       0.00%    31,110         2.75%    31,856        2.40%                            32,573     2.25%                    3.56%         3.56%        3.56%
         31      31,779         6,7            31,779       0.00% 31,779       0.00%           31,779       0.00%          31,779       0.00%    32,653         2.75%    33,437        2.40%                            34,189     2.25%                    4.96%         4.96%        4.96%
         32      32,704          7             32,704       0.00% 32,704       0.00%           32,704       0.00%          32,704       0.00%    33,603         2.75%    34,410        2.40%                            35,184     2.25%                    2.91%         2.91%        2.91%
         33      33,744          7             33,744       0.00% 33,744       0.00%           33,744       0.00%          33,744       0.00%    34,672         2.75%    35,504        2.40%                            36,303     2.25%                    3.18%         3.18%        3.18%
         34      34,899          7             34,899       0.00% 34,899       0.00%           34,899       0.00%          34,899       0.00%    35,859         2.75%    36,719        2.40%                            37,546     2.25%                    3.42%         3.42%        3.42%
         35      36,112        7,8a            36,112       0.00% 36,112       0.00%           36,112       0.00%          36,112       0.00%    37,105         2.75%    37,996        2.40%                            38,851     2.25%                    3.48%         3.48%        3.48%
         36      37,326        7,8a            37,326       0.00% 37,326       0.00%           37,326       0.00%          37,326       0.00%    38,352         2.75%    39,273        2.40%                            40,157     2.25%                    3.36%         3.36%        3.36%
         37      38,828         8a             38,828       0.00% 38,828       0.00%           38,828       0.00%          38,828       0.00%    39,896         2.75%    40,853        2.40%                            41,772     2.25%                    4.02%         4.02%        4.02%
         38      40,330         8a             40,330       0.00% 40,330       0.00%           40,330       0.00%          40,330       0.00%    41,439         2.75%    42,434        2.40%                            43,388     2.25%                    3.87%         3.87%        3.87%
         39      42,064       8a,8b            42,064       0.00% 42,064       0.00%           42,064       0.00%          42,064       0.00%    43,221         2.75%    44,258        2.40%                            45,254     2.25%                    4.30%         4.30%        4.30%
         40      43,335       8a,8b            43,335       0.00% 43,335       0.00%           43,335       0.00%          43,335       0.00%    44,527         2.75%    45,595        2.40%                            46,621     2.25%                    3.02%         3.02%        3.02%
         41      45,530         8b             45,530       0.00% 45,530       0.00%           45,530       0.00%          45,530       0.00%    46,782         2.75%    47,905        2.40%                            48,983     2.25%                    5.07%         5.07%        5.07%
         42      48,072         8b             48,072       0.00% 48,072       0.00%           48,072       0.00%          48,072       0.00%    49,394         2.75%    50,579        2.40%                            51,717     2.25%                    5.58%         5.58%        5.58%
         43      50,616       8b,8c            50,616       0.00% 50,616       0.00%           50,616       0.00%          50,616       0.00%    52,008         2.75%    53,256        2.40%                            54,454     2.25%                    5.29%         5.29%        5.29%
         44      52,002       8b,8c            52,002       0.00% 52,002       0.00%           52,002       0.00%          52,002       0.00%    53,432         2.75%    54,714        2.40%                            55,945     2.25%                    2.74%         2.74%        2.74%
         45      54,313         8c             54,313       0.00% 54,313       0.00%           54,313       0.00%          54,313       0.00%    55,807         2.75%    57,146        2.40%                            58,432     2.25%                    4.44%         4.44%        4.44%
         46      56,856         8c             56,856       0.00% 56,856       0.00%           56,856       0.00%          56,856       0.00%    58,420         2.75%    59,822        2.40%                            61,168     2.25%                    4.68%         4.68%        4.68%
         47      60,669       8c,8d            60,669       0.00% 60,669       0.00%           60,669       0.00%          60,669       0.00%    62,337         2.75%    63,833        2.40%                            65,270     2.25%                    6.71%         6.71%        6.71%
         48      62,402       8c,8d            62,402       0.00% 62,402       0.00%           62,402       0.00%          62,402       0.00%    64,118         2.75%    65,657        2.40%                            67,134     2.25%                    2.86%         2.86%        2.86%
         49      65,003         8d             65,003       0.00% 65,003       0.00%           65,003       0.00%          65,003       0.00%    66,791         2.75%    68,394        2.40%                            69,932     2.25%                    4.17%         4.17%        4.17%
         50      68,180         8d             68,180       0.00% 68,180       0.00%           68,180       0.00%          68,180       0.00%    70,055         2.75%    71,736        2.40%                            73,350     2.25%                    4.89%         4.89%        4.89%
         51      71,646        8d,9            71,646       0.00% 71,646       0.00%           71,646       0.00%          71,646       0.00%    73,616         2.75%    75,383        2.40%                            77,079     2.25%                    5.08%         5.08%        5.08%
         52      75,114        8d,9            75,114       0.00% 75,114       0.00%           75,114       0.00%          75,114       0.00%    77,180         2.75%    79,032        2.40%                            80,810     2.25%                    4.84%         4.84%        4.84%
         53      78,718          9             78,718       0.00% 78,718       0.00%           78,718       0.00%          78,718       0.00%    80,883         2.75%    82,824        2.40%                            84,687     2.25%                    4.80%         4.80%        4.80%
         54      82,497          9             82,497       0.00% 82,497       0.00%           82,497       0.00%          82,497       0.00%    84,766         2.75%    86,800        2.40%                            88,753     2.25%                    4.80%         4.80%        4.80%
         55      86,457          9             86,457       0.00% 86,457       0.00%           86,457       0.00%          86,457       0.00%    88,835         2.75%    90,967        2.40%                            93,013     2.25%                    4.80%         4.80%        4.80%
         56      90,607          9             90,607       0.00% 90,607       0.00%           90,607       0.00%          90,607       0.00%    93,099         2.75%    95,333        2.40%                            97,478     2.25%                    4.80%         4.80%        4.80%
                                                                                           This spreadsheet shows the combined value (uplift & increments) for
Pay proposals 2008/09 to 2010/11                                                           RCN members on spine points 7, 19, 20, 25, 27 and 34.

NOTE: "07/08 pay is POST incremental progression in 07/08, whereas "08/09 pay" etc are PRE incremental progression in those years

Healthcare Assistant middle of Band 2 or bottom of Band 3 (Spine
point 7)                                                                                                 Healthcare Assistant (Band 2/3)
                                                                £
07/08 pay                                              14,437.00
                                                                                   17,000.00
08/09 increase (2.75%)                                     397.02
08/09 pay                                              14,834.02                   16,500.00
with incremental rise                                  15,356.00                   16,000.00
09/10 increase (2.4%)                                      368.54                  15,500.00
09/10 pay                                              15,724.54                   15,000.00
with incremental rise                                  16,333.00
10/11 increase (flat cash)                                 420.00
                                                                                   14,500.00
10/11 pay                                              16,753.00                   14,000.00
                                                                                   13,500.00
Overall increase (£)                                        2,316.00               13,000.00
% increase                                                     16.04
                                                                                                   07/08 pay         08/09 pay       09/10 pay        10/11 pay




Band 5 Newly Qualified Nurse - (Spine point 19)
                                                                  £
                                                                                                         Newly qualified nurse (Band 5)
07/08 pay                                                 20,801.00
08/09 increase (2.75%)                                       572.03               25,000.00
08/09 pay                                                 21,373.03               24,000.00
with incremental rise                                     22,085.00
                                                                                  23,000.00
09/10 increase (4.23%)                                       934.20
09/10 pay                                                 23,019.20               22,000.00
with incremental rise                                     23,344.00               21,000.00
10/11 increase (5.18% - 2.25% & move up a point)           1,209.22               20,000.00
10/11 pay                                                 24,553.22
                                                                                  19,000.00
Overall increase (£)                                        3,752.22              18,000.00
% increase                                                     18.04                              07/08 pay          08/09 pay      09/10 pay         10/11 pay
Band 5 Nurse (Spine point 20)

07/08 pay
                                                      £
                                              21,494.00
                                                                    Band 5 Nurse - 1yr post
08/09 increase (2.75%)
08/09 pay
                                                 591.09
                                              22,085.09
                                                          26,000.00      qualification
with incremental rise
09/10 increase (2.4%)
                                              22,797.00
                                                 547.13
                                                          24,000.00
09/10 pay                                     23,344.13   22,000.00
with incremental rise                         24,013.00
10/11 increase (2.25%)                           540.29   20,000.00
10/11 pay                                     24,553.29
                                                          18,000.00
Overall increase (£)                           3,059.29
% increase                                        14.23               07/08   08/09   09/10 10/11 pay
                                                                       pay     pay     pay

Nurse at top of Band 5 - (Spine point 25)

07/08 pay                                     25,424.00
                                                                        Nurse at Top of Band 5
08/09 increase (2.75%)
08/09 pay
                                                 699.16
                                              26,123.16
                                                          28,000.00
with incremental rise                         26,123.16
09/10 increase (2.74%) includes extra 0.33%      715.77   27,000.00
09/10 pay                                     26,838.93
with incremental rise                         26,838.93   26,000.00
10/11 increase (2.59%) includes extra 0.33%      695.13
10/11 pay                                     27,534.06   25,000.00
Overall increase (£)                           2,110.06   24,000.00
% increase                                         8.30
Extra 0.33% to follow in 2011-12                                      07/08   08/09   09/10 10/11 pay
                                                                       pay     pay     pay
Band 6 Specialist ICU Nurse - (Spine point 27)

07/08 pay                                        27,388.00
                                                                           Band 6 Specialist ICU Nurse
08/09 increase (2.75%)                              753.17   32,000.00
08/09 pay                                        28,141.17
with incremental rise                            29,092.00   30,000.00
09/10 increase (2.4%)                               698.21
09/10 pay                                        29,790.21
with incremental rise                            30,762.00
                                                             28,000.00
10/11 increase (2.25%)                              692.15
10/11 pay                                        31,454.15
                                                             26,000.00
Overall increase (£)                              4,066.15   24,000.00
% increase                                           14.85
                                                                         07/08 pay 08/09 pay 09/10 pay 10/11 pay


Band 7 Nurse, Ward Manager - (Spine point 34)

07/08 pay                                        34,899.00
                                                                           Band 7 nurse - Ward Manager
08/09 increase (2.75%)
08/09 pay
                                                    959.72
                                                 35,858.72
                                                             45,000.00
with incremental rise                            37,105.00
09/10 increase (2.4%)                               890.52   40,000.00
09/10 pay                                        37,995.52
with incremental rise                            39,273.00
10/11 increase (2.25%)                              883.64   35,000.00
10/11 pay                                        40,156.64

Overall increase (£)                              5,257.64   30,000.00
% increase                                           15.07
                                                                         07/08 pay 08/09 pay 09/10 pay 10/11 pay

				
DOCUMENT INFO
Description: Case Study Examples document sample