budget spreadsheet example

Document Sample
budget spreadsheet example Powered By Docstoc
					                EXAMPLE - PAGE 1 - CALL IF YOU WANT THE WHOLE DOCUMENT                                                                                                                                          Comparision Trust Recommendations vs. Conference Committee 5/14/02
                                                                                                                                                                                                                                for FY03 Mental Health Appropriation




      A            B C                           D                         E      F     G         H           I       J          K        L      M         N          O     P        Q           R       S       T        U          V     W              X        Y     Z          AA           AB      AC      AD        AE         A     AG             AH           A     AJ         AK           AL      AM      AN        AO         A     AQ           AR           AS             AT           AU         AX         A    AZ             BA
1                                                                                                                    TRUST REC's (amended 2/8/02)                                  Governor's Request (12/15/01)                                                                         HB404 (HFin 2/11/02)                                                                        SENATE SCS CSHB404(FIN) (4/26/02)                                                     Conference Committee (5/14/02)
                                                                                                                                                Other                                                           Other                                                                                            FY03                                                                                                 FY03
               Amended 9/7




                                                                          FY02                                                  FY03    FY03 Sources                                            FY03    FY03 Source                        Diff                                                 FY03    FY03    Other                       Diff                                                     FY03    FY03    Other                       Diff                                                 FY03                      Diff
                                                                          Conf        MHTAAR    GF/MH        FY03               Other   Other  Federal                     FY03                 Other   Other     s                      TOTALS                                                 Other   Other  Sources      FY03          TOTALS                                                     Other   Other  Sources      FY03          TOTALS                                                 Other                  TOTALS
                                                                         Comm          Incrm/   Incrm/      MHTAA    FY03      Sources Sources   &        FY03            MHTAA     FY03       Sources Sources Federal    FY03            Gov v.                    FY03            FY03       Sources Sources Federal & MH Bill          HB404 v.                           FY03       FY03        Sources Sources Federal & MH Bill           Sen v.                    FY03           FY03        Sources     FY03        Conf Com
2    Trust #                  DEPARTMENT/ BRU/COMPONENT                  Base          Decrm    Decrm         R     GF/MH       Sum      GF    AHFC      TOTAL              R      GF/MH        Sum      GF      &     TOTAL              Trust       Comments     MHTAAR          GF/MH        Sum      GF     AHFC TOTAL                 Trust       Comments             MHTAAR     GF/MH         Sum      GF     AHFC TOTAL                 Trust     Comments       MHTAAR         GF/MH         Sum       TOTAL         v. Trust      Comments
3              DEPT ADMINISTRATION
4                            Commissioner's Office
                                                                                                                                                                                                                                                                                                                                                     Yr3 GF/MH                                                                                                                                                                            Conf Comm
                                                                                                                                                                                                                                                                                                                                                     labor costs, Sen                                                                                    Sen reverses                                                                     reverses Hse
5                             HFin: Unallocated Reduction                                                                                                                                                                                                                                0.0                                    0.0           0.0 reverses                                    0.0                                    0.0           0.0 Hse action                              0.0                     0.0          0.0 action
6                            Alaska Longevity Programs
7                             Pioneers Homes (Base)                      ######                       0.0           10,340.8                             10,340.8                  10,340.8                            10,340.8                0.0                                 10,340.8                              10,340.8             0.0                                      10,340.8                               10,340.8             0.0                                   10,340.8              10,340.8             0.0

                                                                                                                                                                                                                                                                                                                                                     HFin adjusts                                                                                        HFin adjusts                                                                     HFin adjusts
                                                                                                                                                                                                                                                                                                                                                     GF/MH in                                                                                            GF/MH in                                                                         GF/MH in
8                             Gov: Change in Labor Costs                                                                                                                              234.1                               234.1            234.1                                      234.1                                 234.1           234.1    Unalloc Reduc                          0.0                                    0.0             0.0   Unalloc Reduc                        0.0                   0.0             0.0 Unalloc Reduc
9                             AK Longevity Prgms Mgt (Base)                64.3                       0.0               64.3                                 64.3                      64.3                                64.3              0.0                                       64.3                                  64.3             0.0                                          64.3                                   64.3             0.0                                       64.3                  64.3             0.0
10                                          Total AK Longevity Prgms                                  0.0           10,405.1                             10,405.1                  10,639.2                            10,639.2                                                    10,639.2                              10,639.2                                                      10,405.1                               10,405.1             0.0                                   10,405.1              10,405.1             0.0
11                           Senior Svcs.                                                                                                                                                                                                                                                                                                                                                                                                          0.0                                                                              0.0
12                            Protec, Comm Svcs, Admin (PCSA)(Base        910.6                       0.0             910.6                                910.6                     910.6                                910.6                0.0                                   910.6                                  910.6             0.0                                        910.6                                   910.6             0.0                                      910.6                  910.6            0.0
13                                                    MHTAAR Base         779.7          -1.4                                                                                                                                                                                                                                                 0.0                                                                                                  0.0                                                                              0.0
14    0081                          Rural LTC Development (Yr 5 of 5)                     0.0                97.3                                           97.3            97.3                                           97.3                0.0                       97.3                                                97.3             0.0                             97.3                                                97.3             0.0                      97.3                                    97.3            0.0
15    0270                             QA Unit Development (Yr 3 of 3)                    0.0               175.0                                          175.0           175.0                                          175.0                0.0                      175.0                                               175.0             0.0                            175.0                                               175.0             0.0                     175.0                                   175.0            0.0

                                                                                                                                                                                                                                                                                                                                                     Gov: 491.0 in
                                                                                                                                                                                                                                                                                                                                                     GF, HFin: Does                                                                                      Gov: Both
                                                                                                                                                                                                                                                     Gov: GF                                                                                         not trnsfr 491.0                                                                                    491.0 & 364.3                                                                    Gov: Both 491.0
                                                                                                                                                                                                                                                     incrm in GF                                                                                     from MHTAAR                                                                                         in GF, Sen                                                                       & 364.3 in GF,
16    0303 am                  Assis Liv Rate Increase - DOA (Yr3of 3)                 -491.0    491.0                491.0     364.3    364.3             855.3                         0.0    491.0 491.0               491.0           -364.3     Bill               491.0            0.0      0.0                       491.0          -364.3    to GF/MH                  0.0            0.0    855.3   855.3               855.3             0.0   agrees              0.0               0.0    855.3        855.3            0.0 Legis agrees
17    0326                        Bd Dev-Rural Issues ACoA(Yr2of3)`                       0.0                15.0                                           15.0            15.0                                           15.0              0.0                         15.0                                                15.0             0.0                             15.0                                                15.0             0.0                      15.0                                    15.0            0.0
                                                                                                                                                                                                                                                     Gov: does                                                                                       HFin does not                                                                                       Sen does not                                                                     Gov/Legis does
18    0349 am                         Assisted Living Licensing - DOA                            150.0                150.0                                150.0                         0.0                                   0.0        -150.0 not accept                              0.0                                    0.0        -150.0 accept                                      0.0                                    0.0        -150.0 accept                                  0.0                     0.0       -150.0 not accept
                                                                                                                                                                                                                                                     Gov: does                                                                                       HFin does not                                                                                       Sen does not                                                                     Gov/Legis does
19    0350 am                                        Gero-Psychiatrist                           250.0                250.0                                250.0                         0.0                                   0.0        -250.0     not accept                          0.0                                    0.0        -250.0    accept                                   0.0                                    0.0        -250.0   accept                                0.0                     0.0       -250.0 not accept
                                                                                                                                                                                                                                                     Gov: does                                                                                       HFin does not                                                                                       Sen does not                                                                     Gov/Legis does
20    0352 am                        Delegation of APS in Rural Areas                            150.0                150.0                                150.0                         0.0                                   0.0        -150.0 not accept                              0.0                                    0.0        -150.0 accept                                      0.0                                    0.0        -150.0 accept                                  0.0                     0.0       -150.0 not accept
                                                                                                                                                                                                                                                                                                                                                     accept                                                                                                                                                                               Gov/Legis
21    0394 am                                  ACoA Planner (Yr1of7)                     75.5                75.5                                              75.5         75.5                                              75.5             0.0                           0.0                                                0.0         -75.5    MHTAAR p                 75.5                                                 75.5            0.0 Sen accepts          75.5                                    75.5            0.0 accepts
                                                                                                                                                                                                                                                                                                                                                     MHTAAR for                                                                                                                                                                           Gov/Legis
22                            Gov: Yr2 labor costs                                                                                                                           1.4                                               1.4             1.4                           1.4                                                1.4           1.4    labor costs               1.4                                                   1.4           1.4 Sen accepts              1.4                                    1.4          1.4 accepts
                                                                                                                                                                                                                                                                                                                                                     HFin adjusts                                                                                                                                                                         Legis does not
                                                                                                                                                                                                                                                                                                                                                     GF/MH in                                                                                            Sen does not                                                                     accept 3.5
23                            Gov: Yr3 labor costs                                                                                                                           2.5       3.6                                  6.1                6.1                        2.5          3.6                                    6.1             6.1    Unalloc Reduc             2.5         0.0                                      2.5            2.5 accept                2.5              0.0                    2.5            2.5 GF/MH
24                                                          Total PCSA                 -416.9   1,041.0     362.8    1,951.6    364.3                     2,678.7          366.7     914.2      491.0                   1,771.9                                         782.2        914.2        0.0                     1,696.4                                            366.7       910.6                                  1,277.3                                    366.7            910.6                1,277.3




                Example of Budget Spreadsheet.xls                                                                                                                                                                                                                      Page 1                                                                                                                                                                                                         Revised 6/6/02 by BH (Printed on 12/3/2002 9:42 AM)

				
DOCUMENT INFO
Description: business information budget spreadsheet example