FY12 Shortfall Impact (Draft) by idz16791

VIEWS: 11 PAGES: 2

									IMPACT OF PROJECTED FY 12 SHORTFALL ON DEPARTMENT BUDGETS
The purpose of this spreadsheet is to show how the projected budget shortfall for FY 12 will impact departments that depend on discretionary General Fund revenue for their financing. Formulas imbedded in the spreadsheet distribute the shortfall to each department in proportion to that department's discretionary FY 10 General Fund to total FY 10 discretionary General Fund. The report uses the projected shortfall from the Base-Line Projection Report required by R.S. 39:174 and develops scenarios using different assumptions about revenue and expenditures from
the Five-Year Base-Line Budget Report. Another function of this spreadsheet is to show how difficult it is to protect higher education and health care from budget cuts because of the size of their general fund appropriations and the amount of such appr opriation that is discretionary spending. The spreadsheet is designed to allow some or all of a department's discretionary budget to be exempted from budget cuts and will reallocate whatever amount that is exempted to the remaining departments in the ratio that their discretionary budget is to the total discretionary
budget. Determine how much of a department's budget is to be protected and place that amount in the row for the department as a negative amount in Column E and the formula will redistribute that amount to other departments.

The Five-Year Base Line Budget Report required by R.S. 39: 171 - 175 projects that the FY 12 State General Fund budget shortfall will be $1,931,085,595. The major factors driving this projection are the termination of the federal stimulus program, the unfavorable match rate changes in the Medicaid, and inflation. The federal stimulus funding will end in FY 12 and the unfavorable match rate changes will begin
in FY 11. The 5-year base-line budget projections indicates a budget shortfall of $716,477,353 which means that nearly half of the projected FY 12 cut will have to take place in FY 11. However, in order to show the cumulative impact that the loss of federal stimulus funding and the change in Medicaid match rates will have on departmental budgets the FY 12 shortfall projection is being used.
Oil Price Change Scenario
The FY 12 Official Forecast is based on an average oil price of $68.74 for that fiscal year. The state nets about $12.5 mil lion for each $ increase in the price of oil so if the the price for FY 12 were to increase to $69.74 revenues would increase by $12.5 million and the projected shortfall would decrease by a like amount. You can test your own assumption about the price of oil by placing the assumed price in cell B60. The formula will adjust the projected shortfall accordingly and redistribute the cuts to the various departments of government in Column J. You
may assume any price of oil for purposes of this scenario so if you think the price might be below $65.17 any lower number wi ll increase the projected shortfall above the amount in the 5-year base-line projection.


                                                             Projected Shortfall      Assumed New Price             Per bbl over Off. Price       Additional new $                                                                 Adjusted Shortfall
Assumed new FY 12 oil price                                   $     (1,931,085,595) $             80.00           $                   11.26   $       140,750,000                                                            $              (1,790,335,595)
Other Additional Revenue                                     Enter Amount
Tax Receipts Grow by 10%                                      $         435,000,000
Feds don't reduce FMAP rate                                   $         500,000,000
                                                                                                                                                                                                                                                                                          SCENARIO 1                                                 No new revenue (only    SCENARIO 2                                              With Increase to     SCENARIO 3                                               With Increase                       SCENARIO 4 - With Increase to Oil, 10% growth, Feds don't
                                                                                                                                                                                                                                                                                                                         school Closures)                                                              Oil and School Closures                                            to Oil, 10 % growth, and school closures                                                  reduce FMAP, and School Closures
                                                                        TOTAL                Discretionary                                           Exempted               Remaining                Percentage of                   Remaining Discr              Percentage of                  Allocation of                                                                      Allocation of                                                                Allocation of                                                                            Allocation of
                          Department                                 General Fund            General Fund              Non-Discretionary            Departments            Discretionary          Remaining Gen. Fund                 General Fund             Remaining Gen. Fund            Reduction Needed                Percentage               Remaining SGF              Reduction Needed              Percentage          Remaining SGF              Reduction Needed          Percentage           Remaining SGF                             Reduction Needed       Percentage        Remaining SGF
                                                                  Executive Bud. FY 10    Executive Bud. FY 10        Executive Bud. FY 10          General Fund           General Fund           After Column H Cuts            w/ closed school taken out    After Column H Cuts            To Bal. FY 12 Fcst.              Reduction               After Reduction           To Bal. FY 12 Fcst.            Reduction           After Reduction           To Bal. FY 12 Fcst.         Reduction           After Reduction                          To Bal. FY 12 Fcst.       Reduction       After Reduction
01-Executive Dept.                                                      $156,170,658             $133,031,492                 $23,139,166     $                    -   $         133,031,492                         4.37%   $                 133,031,492                    4.37%       $               (84,307,355)                     -63.37%            $71,863,303    $               (78,162,490)            -58.75%               $78,008,168    $              (59,171,256)                  -44.48%                      $96,999,402    $                     (37,342,250)     -28.07%        $118,828,408
03-Dept. of Veterans Affairs                                             $11,022,288               $6,744,816                  $4,277,472     $                    -   $           6,744,816                         0.22%   $                   6,744,816                    0.22%       $                (4,274,459)                     -63.37%             $6,747,829    $                (3,962,908)            -58.75%                $7,059,380    $               (3,000,036)                  -44.48%                       $8,022,252    $                      (1,893,286)     -28.07%          $9,129,002
04-Dept. of State                                                        $23,159,212              $19,852,126                  $3,307,086     $                    -   $          19,852,126                         0.65%   $                  19,852,126                    0.65%       $               (12,581,083)                     -63.37%            $10,578,129    $               (11,664,092)            -58.75%               $11,495,120    $               (8,830,054)                  -44.48%                      $14,329,158    $                      (5,572,538)     -28.07%         $17,586,674
04-Dept. of Justice                                                       $7,490,792               $5,963,886                  $1,526,906     $                    -   $           5,963,886                         0.20%   $                   5,963,886                    0.20%       $                (3,779,552)                     -63.37%             $3,711,240    $                (3,504,074)            -58.75%                $3,986,718    $               (2,652,685)                  -44.48%                       $4,838,107    $                      (1,674,077)     -28.07%          $5,816,715
04-Lt. Gov.                                                               $1,494,289               $1,289,695                    $204,594     $                    -   $           1,289,695                         0.04%   $                   1,289,695                    0.04%       $                  (817,331)                     -63.37%               $676,958    $                  (757,759)            -58.75%                  $736,530    $                 (573,645)                  -44.48%                         $920,644    $                        (362,020)     -28.07%          $1,132,269
04-Treasury                                                                 $620,060                 $620,060                          $0     $                    -   $             620,060                         0.02%   $                     620,060                    0.02%       $                  (392,957)                     -63.37%               $227,103    $                  (364,315)            -58.75%                  $255,745    $                 (275,797)                  -44.48%                         $344,263    $                        (174,052)     -28.07%            $446,008
04-Public Serv. Comm.                                                             $0                       $0                          $0     $                    -   $                 -                           0.00%   $                         -                      0.00%       $                       -                          0.00%                     $0    $                       -                                              $0    $                      -                       0.00%                               $0    $                             -          0.00%                  $0
04-Dept. of Ag. and Forestry                                             $15,553,228              $15,553,228                          $0     $                    -   $          15,553,228                         0.51%   $                  15,553,228                    0.51%       $                (9,856,700)                     -63.37%             $5,696,528    $                (9,138,280)            -58.75%                $6,414,948    $               (6,917,941)                  -44.48%                       $8,635,287    $                      (4,365,827)     -28.07%         $11,187,401
04-Dept. of Insurance                                                             $0                       $0                          $0     $                    -   $               -                        0.00%        $                         -                      0.00%       $                       -                          0.00%                     $0    $                       -                 0.00%                        $0    $                      -                       0.00%                               $0    $                             -          0.00%                  $0
05-Dept. of Economic Dev.                                                $16,564,015              $16,337,124                    $226,891     $                    -   $        16,337,124                      0.54%        $                  16,337,124                    0.54%       $               (10,353,486)                     -63.37%             $6,210,529    $                (9,598,857)            -58.75%                $6,965,158    $               (7,266,611)                  -44.48%                       $9,297,404    $                      (4,585,869)     -28.07%         $11,978,146
06-Dept. of Culture Rec. and Tour.                                       $26,172,610              $23,551,497                  $2,621,113     $                    -   $        23,551,497                      0.77%        $                  23,551,497                    0.77%       $               (14,925,522)                     -63.37%            $11,247,088    $               (13,837,653)            -58.75%               $12,334,957    $              (10,475,502)                  -44.48%                      $15,697,108    $                      (6,610,960)     -28.07%         $19,561,650
07-Dept of Transportation                                                         $0                       $0                          $0     $                    -   $               -                        0.00%        $                         -                      0.00%       $                       -                          0.00%                     $0    $                       -                                              $0    $                      -                       0.00%                               $0    $                             -          0.00%                  $0
08-Dept. of Corrections                                                 $445,120,129              $93,936,330                $351,183,799     $                    -   $        93,936,330                      3.08%        $                  93,936,330                    3.08%       $               (59,531,194)                     -63.37%           $385,588,935    $               (55,192,176)            -58.75%              $389,927,953    $              (41,782,066)                  -44.48%                     $403,338,063    $                     (26,368,147)     -28.07%        $418,751,982
08-Dept. of Public Safety                                                $35,167,597              $35,167,597                          $0     $                    -   $        35,167,597                      1.15%        $                  35,167,597                    1.15%       $               (22,287,107)                     -63.37%            $12,880,490    $               (20,662,679)            -58.75%               $14,504,918    $              (15,642,243)                  -44.48%                      $19,525,354    $                      (9,871,627)     -28.07%         $25,295,970
08-Office of Youth Development                                          $134,422,794             $130,855,274                  $3,567,520     $                    -   $       130,855,274                      4.29%        $                 130,855,274                    4.29%       $               (82,928,199)                     -63.37%            $51,494,595    $               (76,883,856)            -58.75%               $57,538,938    $              (58,203,293)                  -44.48%                      $76,219,501    $                     (36,731,381)     -28.07%         $97,691,413
09-Dept. of Health and Hospitals                                      $1,474,647,316           $1,095,005,516                $379,641,800                              $     1,095,005,516                     35.94%        $               1,095,005,516                   35.94%       $              (693,948,611)                     -63.37%           $780,698,705    $              (643,369,151)            -58.75%              $831,278,165    $             (487,048,972)                  -44.48%                     $987,598,344    $                    (307,370,605)     -28.07%      $1,167,276,711
10-Dept. of Social Services                                             $176,316,920             $114,871,106                 $61,445,814     $                    -   $       114,871,106                      3.77%        $                 114,871,106                    3.77%       $               (72,798,395)                     -63.37%           $103,518,525    $               (67,492,378)            -58.75%              $108,824,542    $              (51,093,673)                  -44.48%                     $125,223,247    $                     (32,244,588)     -28.07%        $144,072,332
11-Dept. of Natural Resources                                             $4,971,451               $2,758,393                  $2,213,058     $                    -   $         2,758,393                      0.09%        $                   2,758,393                    0.09%       $                (1,748,104)                     -63.37%             $3,223,347    $                (1,620,690)            -58.75%                $3,350,761    $               (1,226,909)                  -44.48%                       $3,744,542    $                        (774,287)     -28.07%          $4,197,164
12-Dept. of Revenue and Taxation                                         $12,572,885               $7,634,832                  $4,938,053     $                    -   $         7,634,832                      0.25%        $                   7,634,832                    0.25%       $                (4,838,497)                     -63.37%             $7,734,388    $                (4,485,836)            -58.75%                $8,087,049    $               (3,395,907)                  -44.48%                       $9,176,978    $                      (2,143,115)     -28.07%         $10,429,770
13-Dept. of Environmental Qual.                                           $5,432,289               $3,836,060                  $1,596,229     $                    -   $         3,836,060                      0.13%        $                   3,836,060                    0.13%       $                (2,431,064)                     -63.37%             $3,001,225    $                (2,253,872)            -58.75%                $3,178,417    $               (1,706,246)                  -44.48%                       $3,726,043    $                      (1,076,791)     -28.07%          $4,355,498
14-Dept. of Labor                                                                 $0                       $0                          $0     $                    -   $               -                        0.00%        $                         -                      0.00%       $                       -                          0.00%                     $0    $                       -                                              $0    $                      -                       0.00%                               $0    $                             -          0.00%                  $0
16-Dept. of Wildlife and Fisheries                                                $0                       $0                          $0     $                    -   $               -                        0.00%        $                         -                      0.00%       $                       -                          0.00%                     $0    $                       -                                              $0    $                      -                       0.00%                               $0    $                             -          0.00%                  $0
17-Dept. of Civil Service                                                 $5,157,533               $4,353,943                    $803,590     $                    -   $         4,353,943                      0.14%        $                   4,353,943                    0.14%       $                (2,759,267)                     -63.37%             $2,398,266    $                (2,558,154)            -58.75%                $2,599,379    $               (1,936,596)                  -44.48%                       $3,220,937    $                      (1,222,162)     -28.07%          $3,935,371
19A-Higher Education*                                                 $989,903,546             $949,317,501                  $40,586,045                               $    949,317,501                      31.15% $                       949,317,501                   31.15% $                 (601,620,313)                     -63.37%             $388,283,233 $               (557,770,336)              -58.75%             $432,133,210 $                 (422,248,204)                   -44.48%                  $567,655,342 $                    (266,475,639)            -28.07%     $723,427,907
19B-Other Education*                                                     $186,025,101              $20,859,285                $165,165,816    $                    -   $        20,859,285                       0.68%       $                  20,859,285                          $
                                                                                                                                                                                                                                                                                  0.68%                   (13,219,360)                     -63.37%            $172,805,741   $               (12,255,848)            -58.75%               $173,769,253   $                (9,278,030)                 -44.48%                     $176,747,071    $                      (5,855,250)     -28.07%        $180,169,851
19D-Dept. of Education                                                $3,242,408,588             $249,856,786              $2,992,551,802     $                    -   $       249,856,786                       8.20%       $                 249,856,786                          $
                                                                                                                                                                                                                                                                                  8.20%                  (158,344,198)                     -63.37%          $3,084,064,390   $              (146,803,049)            -58.75%             $3,095,605,539   $              (111,134,135)                 -44.48%                   $3,131,274,453    $                     (70,135,383)     -28.07%      $3,172,273,205
19E-Health Care Services Div.                                            $79,575,475              $51,884,681                 $27,690,794                              $        51,884,681                       1.70%       $                  51,884,681                          $
                                                                                                                                                                                                                                                                                  1.70%                   (32,881,389)                     -63.37%             $46,694,086   $               (30,484,781)            -58.75%                $49,090,694   $               (23,077,857)                 -44.48%                      $56,497,618    $                     (14,564,151)     -28.07%         $65,011,324
20-Other Requirements                                                   $404,815,521              $63,845,524                $340,969,997     $                    -   $        63,845,524                       2.10%       $                  63,845,524                          $
                                                                                                                                                                                                                                                                                  2.10%                   (40,461,452)                     -63.37%            $364,354,069   $               (37,512,360)            -58.75%               $367,303,161   $               (28,397,936)                 -44.48%                     $376,417,585    $                     (17,921,588)     -28.07%        $386,893,933
21-Ancillary Programs                                                              $0                       $0                          $0    $                    -   $               -                         0.00%       $                         -                            $
                                                                                                                                                                                                                                                                                  0.00%                           -                          0.00%                      $0   $                       -                 0.00%                         $0   $                       -                      0.00%                               $0    $                             -          0.00%                  $0
22-Non-Appropriated Requirements                                         $433,349,119                       $0                $433,349,119    $                    -   $               -                         0.00%       $                         -                            $
                                                                                                                                                                                                                                                                                  0.00%                           -                          0.00%            $433,349,119   $                       -                 0.00%               $433,349,119   $                       -                      0.00%                     $433,349,119    $                             -          0.00%        $433,349,119
23-Judicial Expense                                                      $128,895,700                       $0                $128,895,700    $                    -   $               -                         0.00%       $                         -                            $
                                                                                                                                                                                                                                                                                  0.00%                           -                          0.00%            $128,895,700   $                       -                 0.00%               $128,895,700   $                       -                      0.00%                     $128,895,700    $                             -          0.00%        $128,895,700
24-Legislative Expense                                                    $67,870,885                       $0                 $67,870,885    $                    -   $               -                         0.00%       $                         -                            $
                                                                                                                                                                                                                                                                                  0.00%                           -                          0.00%             $67,870,885   $                       -                 0.00%                $67,870,885   $                       -                      0.00%                      $67,870,885    $                             -          0.00%         $67,870,885
25-Special Appropriatons                                                           $0                       $0                          $0    $                    -   $               -                         0.00%       $                         -                            $
                                                                                                                                                                                                                                                                                  0.00%                           -                          0.00%                      $0   $                       -                 0.00%                         $0   $                       -                      0.00%                               $0    $                             -          0.00%                  $0
26-Capital Outlay                                                                  $0                       $0                          $0    $                    -   $               -                         0.00%       $                         -                            $
                                                                                                                                                                                                                                                                                  0.00%                           -                          0.00%                      $0   $                       -                 0.00%                         $0   $                       -                      0.00%                               $0    $                             -          0.00%                  $0
                                                                                                                                                                                                                             $                         -                            $                             -                          0.00%                      $0   $                       -                                               $0   $                       -                      0.00%                               $0    $                             -          0.00%                  $0
TOTAL                                                         $       8,084,900,001 $            3,047,126,752 $              5,037,773,249 $                   -    $         3,047,126,752                   100.00% $                       3,047,126,752                100.00% $                  (1,931,085,595)                                      $6,153,814,406   $            (1,790,335,594)                                $6,294,564,407   $            (1,355,335,594)                 -44.48%                   $6,729,564,407    $                    (855,335,593)     -28.07%      $7,229,564,408
* The Office of Student Financial Assistance has been moved from Higher Education to the Other Education to reflect the current statutory organization of government
                                                                                                                                                                                                                             #REF!
 Eliminate College Campuses To Reduce Shortfall Scenario
 There has been some discussion about reducing the number of institutions of higher education in order to generate savings that would help reduce the projected $1.93 billion FY 12 shortfall. The next part of this spreadsheet provides users the option of picking whatever campuses that wish to eliminate and the formula will allocate that cut to higher education and recacculate the cuts that need to be made to the discretionary budgets of the various departments of government in order to address what ever remains of the $1.93 projected FY 10 shortfall. To use this
 scenario just place the number 1 in the column C next to the row containing the campus to be eliminated. This scenario assumes that the elimination of a campus will result in the TOTAL SAVINGS OF THE STATE GENERAL FUND APPROPRIATION FOR THAT CAMPUS which, while unrealistic, is sufficient to make the point that closing campuses, even on a large scale basis, will not appreciably reduce the projected shortfall for FY 12.

                                                                                                    SCENARIO 1                                            No   SCENARIO 2                                          No new SCENARIO 3                                             With Increase to                                                                             SCENARIO 4 - With Increase to Oil, 10% growth, Feds don't
                                                                               Enter number "1" to              new revenue (only school Closures)                             revenue (Only School Closures)                              Oil, 10 % growth, and school closures                                                                                                       reduce FMAP, and School Closures
                                                             Estimated 2009-10       eliminate     Proposed Budget Cut       FY2012          % Change to Total Proposed Budget                             % Change to Total Proposed Budget Cut                             % Change to Total                                                                               Proposed Budget Cut                FY2012           % Change to Total
Institution                                                  SGF *                 institution(s)     Using Prorata            SGF                 SGF         Cut Using Prorata        FY2012 SGF              SGF             Using Prorata           FY2012 SGF                  SGF                                                                                         Using Prorata                    SGF                  SGF
Board of Regents                                                          41,750,228                                           (26,458,783)             15,291,446                         -63%          (24,530,296)                            17,219,933                       -59%                  (18,570,140)                23,180,088                       -44%                  (11,719,387)         30,030,842                        -28%
LA Universities Marine Consortium                                          2,465,233                                            (1,562,316)
                                                                                                                                         0                 902,917
                                                                                                                                                                 0                         -63%           (1,448,445)
                                                                                                                                                                                                                   0                              1,016,788
                                                                                                                                                                                                                                                          0                       -59%                   (1,096,514)
                                                                                                                                                                                                                                                                                                                  0                  1,368,719
                                                                                                                                                                                                                                                                                                                                             0                       -44%                     (691,997)
                                                                                                                                                                                                                                                                                                                                                                                                     0           1,773,236
                                                                                                                                                                                                                                                                                                                                                                                                                         0                        -28%
LSU Board of Supervisors                                                   8,449,120                                            (5,354,544)              3,094,576                         -63%           (4,964,270)                             3,484,850                       -59%                   (3,758,095)                 4,691,025                       -44%                   (2,371,688)          6,077,432                        -28%
LSU Baton Rouge                                                          141,041,431                                           (89,383,573)             51,657,858                         -63%          (82,868,720)                            58,172,711                       -59%                  (62,734,007)                78,307,424                       -44%                  (39,590,659)        101,450,772                        -28%
LSU Alexandria                                                             7,323,045                                            (4,640,905)              2,682,140                         -63%           (4,302,646)                             3,020,399                       -59%                   (3,257,227)                 4,065,818                       -44%                   (2,055,596)          5,267,449                        -28%
University of New Orleans                                                 42,761,559                                           (27,099,703)             15,661,856                         -63%          (25,124,502)                            17,637,057                       -59%                  (19,019,971)                23,741,588                       -44%                  (12,003,270)         30,758,290                        -28%
LSU Health Sciences Center - New Orleans                                  69,456,165                                           (44,017,138)             25,439,027                         -63%          (40,808,885)                            28,647,280                       -59%                  (30,893,501)                38,562,664                       -44%                  (19,496,508)         49,959,657                        -28%                                   Please Note:
LSU Health Sciences Center - Shreveport                                   45,255,633                                           (28,680,297)             16,575,336                         -63%          (26,589,892)                            18,665,741                       -59%                  (20,129,314)                25,126,319                       -44%                  (12,703,362)         32,552,271                        -28%                                   *Based off of prorata distribution of expected non-discretionary 2009-10 SGF
E A Conway Medical Center                                                 10,462,716                                            (6,630,640)              3,832,076                         -63%           (6,147,356)                             4,315,360                       -59%                   (4,653,725)                 5,808,990                       -44%                   (2,936,909)          7,525,807                        -28%
Huey P Long Medical Center                                                11,300,863                                            (7,161,807)              4,139,056                         -63%           (6,639,808)                             4,661,055                       -59%                   (5,026,526)                 6,274,337                       -44%                   (3,172,179)          8,128,684                        -28%
LSU - Eunice                                                               5,653,238                                            (3,582,682)              2,070,556                         -63%           (3,321,553)                             2,331,685                       -59%                   (2,514,512)                 3,138,727                       -44%                   (1,586,877)          4,066,361                        -28%
LSU - Shreveport                                                          10,703,564                                            (6,783,275)              3,920,289                         -63%           (6,288,866)                             4,414,698                       -59%                   (4,760,853)                 5,942,712                       -44%                   (3,004,515)          7,699,049                        -28%
LSU Agricultural Center                                                   67,394,546                                           (42,710,608)             24,683,938                         -63%          (39,597,583)                            27,796,963                       -59%                  (29,976,510)                37,418,035                       -44%                  (18,917,806)         48,476,739                        -28%
Paul M. Hebert Law Center                                                  5,962,149                                            (3,778,451)              2,183,698                         -63%           (3,503,054)                             2,459,096                       -59%                   (2,651,912)                 3,310,237                       -44%                   (1,673,589)          4,288,560                        -28%
Pennington Biomedical Research Center                                     13,169,037                                            (8,345,743)
                                                                                                                                         0               4,823,294
                                                                                                                                                                 0                         -63%           (7,737,452)
                                                                                                                                                                                                                   0                              5,431,585
                                                                                                                                                                                                                                                          0                       -59%                   (5,857,474)
                                                                                                                                                                                                                                                                                                                  0                  7,311,563
                                                                                                                                                                                                                                                                                                                                             0                       -44%                   (3,696,579)
                                                                                                                                                                                                                                                                                                                                                                                                     0           9,472,458
                                                                                                                                                                                                                                                                                                                                                                                                                         0                        -28%
Southern Board of Supervisors                                              2,804,873                                            (1,777,559)              1,027,313                         -63%           (1,647,999)                             1,156,873                       -59%                   (1,247,583)                 1,557,290                       -44%                      (787,334)         2,017,538                        -28%
Southern Univ-Agricultural & Mechanical College                           30,767,014                                           (19,498,282)             11,268,732                         -63%          (18,077,121)                            12,689,893                       -59%                  (13,684,901)                17,082,113                       -44%                    (8,636,373)        22,130,641                        -28%
Southern University Law Center                                             4,527,930                                            (2,869,530)              1,658,401                         -63%           (2,660,380)                             1,867,550                       -59%                   (2,013,984)                 2,513,946                       -44%                    (1,271,001)         3,256,930                        -28%
Southern University - New Orleans                                          8,979,890                                            (5,690,914)              3,288,976                         -63%           (5,276,123)                             3,703,767                       -59%                   (3,994,177)                 4,985,713                       -44%                    (2,520,676)         6,459,214                        -28%
Southern University - Shreveport                                           5,218,677                                            (3,307,284)              1,911,394                         -63%           (3,066,227)                             2,152,450                       -59%                   (2,321,222)                 2,897,455                       -44%                    (1,464,895)         3,753,782                        -28%
SU Agricultural Research/Extension Center                                  3,081,751                                            (1,953,029)
                                                                                                                                         0               1,128,723
                                                                                                                                                                 0                         -63%           (1,810,679)
                                                                                                                                                                                                                   0                              1,271,072
                                                                                                                                                                                                                                                          0                       -59%                   (1,370,736)
                                                                                                                                                                                                                                                                                                                  0                  1,711,015
                                                                                                                                                                                                                                                                                                                                             0                       -44%                      (865,055)
                                                                                                                                                                                                                                                                                                                                                                                                      0          2,216,697
                                                                                                                                                                                                                                                                                                                                                                                                                         0                        -28%
BD of Suprs-Univ of LA System                                              8,244,401                                            (5,224,805)              3,019,596                         -63%           (4,843,988)                             3,400,413                       -59%                   (3,667,038)                 4,577,363                       -44%                   (2,314,223)          5,930,178                        -28%                                                                                            FY12 Budget Cut
Nicholls State University                                                 21,660,896                                           (13,727,373)              7,933,524                         -63%          (12,726,833)                             8,934,063                       -59%                   (9,634,579)                12,026,317                       -44%                   (6,080,264)         15,580,632                        -28%                                                            Projected Shortfall              $           (1,931,085,595)
Grambling State University                                                18,931,680                                           (11,997,760)              6,933,920                         -63%          (11,123,285)                             7,808,395                       -59%                   (8,420,647)                10,511,033                       -44%                   (5,314,167)         13,617,513                        -28%                                                            Additional Revenue
Louisiana Tech University                                                 38,745,929                                           (24,554,838)             14,191,090                         -63%          (22,765,123)                            15,980,806                       -59%                  (17,233,854)                21,512,075                       -44%                  (10,876,073)         27,869,856                        -28%                                                            Oil                              $                     140,750,000
McNeese State University                                                  27,024,454                                           (17,126,473)              9,897,981                         -63%          (15,878,185)                            11,146,269                       -59%                  (12,020,243)                15,004,211                       -44%                   (7,585,827)         19,438,627                        -28%                                                            Tax Receipts Grow by 10%         $                     435,000,000
University of Louisiana - Monroe                                          34,538,543                                           (21,888,451)             12,650,093                         -63%          (20,293,079)                            14,245,464                       -59%                  (15,362,445)                19,176,098                       -44%                   (9,695,050)         24,843,494                        -28%                                                            Feds don't reduce FMAP rate      $                     500,000,000
Northwestern State University                                             30,084,211                                           (19,065,563)             11,018,648                         -63%          (17,675,941)                            12,408,270                       -59%                  (13,381,197)                16,703,014                       -44%                   (8,444,708)         21,639,503                        -28%                                                            Revised Shortfall                $                    (855,335,595)
Southeastern Louisiana University                                         47,524,168                                           (30,117,958)             17,406,210                         -63%          (27,922,767)                            19,601,401                       -59%                  (21,138,338)                26,385,830                       -44%                  (13,340,145)         34,184,023                        -28%
University of Louisiana - Lafayette                                       56,375,107                                           (35,727,151)             20,647,956                         -63%          (33,123,125)                            23,251,982                       -59%                  (25,075,160)                31,299,948                       -44%                  (15,824,624)         40,550,483                        -28%                                                            School Closure                                                  0
                                                                                                                                         0                       0                                                 0                                      0                                                       0                          0                                                       0                   0
LCTCS Board of Supervisors                                                 3,971,969                                            (2,517,195)              1,454,774                         -63%           (2,333,726)                             1,638,244                       -59%                   (1,766,698)                 2,205,272                       -44%                   (1,114,941)          2,857,028                        -28%
Baton Rouge Community College                                             13,945,088                                            (8,837,558)              5,107,530                         -63%           (8,193,419)                             5,751,669                       -59%                   (6,202,654)                 7,742,434                       -44%                   (3,914,419)         10,030,669                        -28%
Delgado Community College                                                 27,443,381                                           (17,391,964)             10,051,417                         -63%          (16,124,325)                            11,319,056                       -59%                  (12,206,578)                15,236,803                       -44%                   (7,703,421)         19,739,960                        -28%
Nunez Community College                                                    3,439,051                                            (2,179,464)              1,259,587                         -63%           (2,020,610)                             1,418,441                       -59%                   (1,529,660)                 1,909,391                       -44%                     (965,350)          2,473,701                        -28%
Bossier Parish Community College                                          10,177,076                                            (6,449,618)              3,727,458                         -63%           (5,979,529)                             4,197,547                       -59%                   (4,526,675)                 5,650,401                       -44%                   (2,856,729)          7,320,347                        -28%
South Louisiana Community College                                          5,071,582                                            (3,214,063)              1,857,518                         -63%           (2,979,802)                             2,091,780                       -59%                   (2,255,796)                 2,815,786                       -44%                   (1,423,605)          3,647,977                        -28%
River Parishes Community College                                           2,141,457                                            (1,357,127)                784,330                         -63%           (1,258,211)                               883,247                       -59%                     (952,502)                 1,188,956                       -44%                     (601,112)          1,540,345                        -28%
Louisiana Delta Community College                                          2,963,313                                            (1,877,969)              1,085,343                         -63%           (1,741,091)                             1,222,222                       -59%                   (1,318,056)                 1,645,257                       -44%                     (831,809)          2,131,504                        -28%
Louisiana Technical College                                               50,143,486                                           (31,777,924)             18,365,562                         -63%          (29,461,744)                            20,681,742                       -59%                  (22,303,388)                27,840,098                       -44%                  (14,075,394)         36,068,092                        -28%
SOWELA Technical Community College                                         5,148,177                                            (3,262,605)              1,885,572                         -63%           (3,024,805)                             2,123,372                       -59%                   (2,289,865)                 2,858,313                       -44%                   (1,445,105)          3,703,072                        -28%
L.E. Fletcher Technical Community College                                  3,214,868                                            (2,037,390)
                                                                                                                                         0               1,177,478
                                                                                                                                                                 0                         -63%           (1,888,892)
                                                                                                                                                                                                                   0                              1,325,976
                                                                                                                                                                                                                                                          0                       -59%                   (1,429,945)                 1,784,922
                                                                                                                                                                                                                                                                                                                                             0                       -44%                     (902,421)
                                                                                                                                                                                                                                                                                                                                                                                                     0           2,312,447
                                                                                                                                                                                                                                                                                                                                                                                                                         0                        -28%
Total Higher Education                                                   949,317,501                                         (601,620,313)             347,697,188                         -63%         (557,770,336)                           391,547,165                       -59%                 (422,248,204)               527,069,297                       -44%                 (266,475,639)        682,841,862                        -28%
Projected General Fund Adjustments FY 10*

Merit Increases                            $    48,364,579
Group Benefits Active and Retired          $    12,092,568
Medicaid Payments**                        $   258,637,436
MFP                                        $    27,967,257
Higher Education Formula (full funding)    $    17,069,609
Debt Service                               $    29,373,585
Enterprise Resource Planning               $    29,373,585
Local Housing of State Inmates             $    15,513,316
GO Grants                                  $     8,970,000
TOPS                                       $    12,078,262
           TOTAL                           $   459,440,197

* Source is La. Office of Budget and Planning
** FMAP rate change; annulization of Now Waiver Slots; medical inflation

								
To top