2011-12 State Funding Worksheet
A B C D E F G H I J K L M N O P
Provider Base Funding Performance  Funding Total Allocation Comparison 2010-11 Provider % of Total Allocation
Enrollment Poverty Supplemental Nutrition Assistance Program (SNAP) Institutional Grant Total Base Outcomes Targets Total PBF  New Allocation (Base + PBF) 2011-12 Actual State Allocation (2010-11) Difference  Percent Difference Base as % of Total Allocation PBF as % of Total Allocation
Notes: Programs' % of state's two year rolling average for enrollment (Enrollment WS, column I)  multiplied by the enrollment allocation (D39) Programs' % of state's poverty (Need WS, column D) multiplied by the poverty allocation (D40) Programs' % of state's SNAP (Need WS, column F) multiplied by the SNAP allocation (D41) Flat grant amount (D43-D46) awarded to programs based on enrollment size (rows 43-46).  Sum of Enrollment + Need (poverty, SNAP) + Institutional Grant (B+C+D+E) Programs' % of state's two year rolling average for outcomes (Outcomes Ave for 2 years) multiplied by the Outcomes allocation (D49) Programs' % of state target points (TargetPoints recent year) multiplied by the Targets allocation (D50) Sum of Outcomes + Targets (G+H) New formula allocations. Sum of Total Base + PBF (F+I)   New formula allocation minus actual 2010-11 allocation (J-K) Funding difference b/w new formula allocation and actual 2010-11 allocation, divided by actual allocation (L/K) Notes: Columns N-P are for analysis only (F/J) (I/J)
Anaconda  $             1,865  $                 533  $                 513  $                   -    $            2,911  $               654  $            6,000  $            6,653  $            9,564  $            5,305 4,259 80% Anaconda 30% 70%
Billings  $           64,916  $              5,595  $              6,652  $                   -    $          77,163  $          23,737  $            3,077  $          26,814  $        103,977  $          92,677 11,300 12% Billings 74% 26%
Bitterroot - LVA  $             6,483  $              2,114  $              2,095  $                   -    $          10,692  $            1,757  $            3,077  $            4,834  $          15,526  $          20,916 (5,390) -26% Bitterroot - LVA 69% 31%
Bozeman  $           24,555  $              4,755  $              2,062  $                   -    $          31,372  $            9,152  $            3,524  $          12,676  $          44,048  $          42,492 1,556 4% Bozeman 71% 29%
Butte  $           10,568  $              1,639  $              2,052  $                   -    $          14,260  $            2,676  $            1,026  $            3,702  $          17,961  $          25,194 (7,233) -29% Butte 79% 21%
CDKC  $             3,819  $                 411  $                 881  $                   -    $            5,110  $               511  $                   -    $               511  $            5,621  $          10,412 (4,791) -46% CDKC 91% 9%
Deer Lodge  $             1,465  $                 416  $                 274  $                   -    $            2,155  $               715  $          11,538  $          12,253  $          14,408  $            3,921 10,487 267% Deer Lodge 15% 85%
Forsyth  $                977  $                 411  $                 881  $                   -    $            2,268  $               102  $            2,154  $            2,256  $            4,524  $            3,607 917 25% Forsyth 50% 50%
FVCC  $           29,128  $              3,960  $              4,827  $                   -    $          37,916  $          10,377  $            4,214  $          14,591  $          52,507  $          52,249 258 0% FVCC 72% 28%
Glendive Dawson  $             8,214  $                 384  $                 254  $                   -    $            8,852  $            1,267  $            2,051  $            3,318  $          12,170  $          14,762 (2,592) -18% Glendive Dawson 73% 27%
Hardin  $             5,817  $                 874  $              1,634  $                   -    $            8,325  $            1,348  $            3,077  $            4,425  $          12,750  $          12,444 306 2% Hardin 65% 35%
Havre  $             4,929  $              1,019  $              1,396  $                   -    $            7,344  $            1,185  $            2,330  $            3,515  $          10,858  $          10,243 615 6% Havre 68% 32%
Helena  $           23,800  $              2,161  $              2,525  $                   -    $          28,485  $            6,660  $            2,430  $            9,090  $          37,575  $          49,438 (11,863) -24% Helena 76% 24%
Lewistown  $             6,261  $                 640  $                 396  $                   -    $            7,297  $            2,472  $            4,786  $            7,258  $          14,555  $          13,823 732 5% Lewistown 50% 50%
Livingston  $             6,172  $                 792  $                 609  $                   -    $            7,573  $            2,288  $            2,051  $            4,339  $          11,912  $          14,110 (2,198) -16% Livingston 64% 36%
MCC  $             7,016  $                 543  $                 461  $                   -    $            8,020  $            3,452  $            4,102  $            7,555  $          15,574  $          15,109 465 3% MCC 51% 49%
Missoula  $           50,264  $              7,103  $              5,719  $                   -    $          63,085  $          18,201  $            3,264  $          21,465  $          84,550  $          74,127 10,423 14% Missoula 75% 25%
SKC  $           12,299  $              1,896  $              2,211  $                   -    $          16,407  $            3,697  $            1,026  $            4,723  $          21,130  $          28,376 (7,246) -26% SKC 78% 22%
Skyline (GFCOT)  $           20,203  $              4,129  $              3,934  $                   -    $          28,266  $            4,249  $            3,273  $            7,522  $          35,788  $          35,793 (5) 0% Skyline (GFCOT) 79% 21%
MSP  $                   -    $                    -    $                    -    $                   -    $                   -    $                   -    $                   -    $                   -    $                   -    $                   -   0   MSP
State Totals  $        288,749  $           39,375  $           39,375  $                   -    $       367,499  $          94,500  $          63,000  $       157,499  $       524,998  $       524,998  $                  (0)   State Totals
Control Panel        
   
State Funding       $         524,998 from margaret 5/1/2011
Admin      
Total Funding      $         524,998  
MSP Allocation      $                    -    
Total Formula Funding     $         524,998  
   
  % of Total Funds  $ Amounts   
Base Funding   70%  $       367,499  
Enrollment   55.0%  $       288,749  
Poverty (Need) 7.5%  $         39,375  
SNAP (Need) 7.5%  $         39,375  
Institutional Grant   0.0%  $               -    
Enrollment Tier 1 0 50  $               -    
Enrollment Tier 2 51 100  $               -    
Enrollment Tier 3 101 200  $               -    
Enrollment Tier 4 201    $               -    
   
Performance Funding 30%  $       157,499  
Outcomes   18.0%  $         94,500  
Target Points   12.0%  $         63,000  
   
TOTAL 100% 100%  $       524,998  
Control Panel cells in red font can be changed to manipulate model assumptions