2011-12 Federal 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 Fed 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  $             3,351  $              1,032  $                 993  $            8,000  $          13,375  $            1,265  $          11,612  $          12,877  $          26,253  $          10,163 16,090 158% Anaconda 51% 49%
Billings  $        116,646  $            10,829  $            12,874  $                   -    $        140,349  $          45,941  $            5,955  $          51,896  $        192,245  $        187,438 4,807 3% Billings 73% 27%
Bitterroot - LVA  $           11,649  $              4,092  $              4,055  $                   -    $          19,795  $            3,400  $            5,955  $            9,355  $          29,150  $          37,235 (8,085) -22% Bitterroot - LVA 68% 32%
Bozeman  $           44,121  $              9,203  $              3,991  $                   -    $          57,315  $          17,712  $            6,821  $          24,533  $          81,849  $          51,183 30,666 60% Bozeman 70% 30%
Butte  $           18,989  $              3,173  $              3,972  $                   -    $          26,134  $            5,179  $            1,985  $            7,164  $          33,298  $          48,312 (15,014) -31% Butte 78% 22%
CDKC  $             6,862  $                 795  $              1,704  $            8,000  $          17,361  $               988  $                   -    $               988  $          18,349  $          23,100 (4,751) -21% CDKC 95% 5%
Deer Lodge  $             2,633  $                 805  $                 530  $            8,000  $          11,967  $            1,384  $          22,331  $          23,714  $          35,682  $            8,097 27,585 341% Deer Lodge 34% 66%
Forsyth  $             1,755  $                 795  $              1,704  $            8,000  $          12,254  $               198  $            4,168  $            4,366  $          16,620  $          19,978 (3,357) -17% Forsyth 74% 26%
FVCC  $           52,339  $              7,664  $              9,343  $                   -    $          69,346  $          20,084  $            8,155  $          28,240  $          97,586  $        105,595 (8,009) -8% FVCC 71% 29%
Glendive Dawson  $           14,760  $                 743  $                 491  $                   -    $          15,994  $            2,451  $            3,970  $            6,421  $          22,415  $          29,297 (6,882) -23% Glendive Dawson 71% 29%
Hardin  $           10,452  $              1,692  $              3,162  $                   -    $          15,306  $            2,609  $            5,955  $            8,564  $          23,870  $          24,807 (937) -4% Hardin 64% 36%
Havre  $             8,856  $              1,972  $              2,701  $            8,000  $          21,530  $            2,293  $            4,509  $            6,802  $          28,332  $          32,114 (3,782) -12% Havre 76% 24%
Helena  $           42,765  $              4,182  $              4,887  $                   -    $          51,833  $          12,889  $            4,704  $          17,593  $          69,426  $          90,010 (20,584) -23% Helena 75% 25%
Lewistown  $           11,250  $              1,239  $                 767  $                   -    $          13,255  $            4,784  $            9,263  $          14,047  $          27,302  $          27,971 (669) -2% Lewistown 49% 51%
Livingston  $           11,090  $              1,532  $              1,179  $                   -    $          13,802  $            4,428  $            3,970  $            8,398  $          22,199  $          35,879 (13,679) -38% Livingston 62% 38%
MCC  $           12,606  $              1,052  $                 892  $                   -    $          14,549  $            6,682  $            7,940  $          14,621  $          29,171  $          29,833 (662) -2% MCC 50% 50%
Missoula  $           90,317  $            13,746  $            11,068  $                   -    $        115,131  $          35,227  $            6,317  $          41,544  $        156,675  $        149,614 7,061 5% Missoula 73% 27%
SKC  $           22,100  $              3,670  $              4,279  $                   -    $          30,050  $            7,156  $            1,985  $            9,141  $          39,191  $          56,196 (17,005) -30% SKC 77% 23%
Skyline (GFCOT)  $           36,302  $              7,990  $              7,614  $                   -    $          51,907  $            8,224  $            6,335  $          14,559  $          66,466  $          67,046 (580) -1% Skyline (GFCOT) 78% 22%
MSP  $                   -    $                    -    $                    -    $                   -    $                   -    $                   -    $                   -    $                   -    $                   -    $                   -   0   MSP
State Totals  $        518,843  $           76,206  $           76,206  $          40,000  $       711,254  $       182,894  $       121,929  $       304,823  $    1,016,078  $    1,033,867  $        (17,790)   State Totals
Control Panel        
   
Federal Funding       $      1,284,020  
state admin 5%      $           64,201  
Leadership 12.5%      $         160,503  
Total Funding      $      1,059,317    $    1,059,317
MSP Allocation      $         (43,239)   524998
Total Formula Funding     $      1,016,078    $    1,584,315
   
  % of Total Funds  $ Amounts    2.5%
Base Funding   70%  $       711,254  
Enrollment   51.1%  $       518,843  
Poverty (Need) 7.5%  $         76,206  
SNAP (Need) 7.5%  $         76,206  
Institutional Grant   3.9%  $         40,000  
Enrollment Tier 1 0 50  $          8,000  
Enrollment Tier 2 51 100  $               -    
Enrollment Tier 3 101 200  $               -    
Enrollment Tier 4 201    $               -    
   
Performance Funding 30%  $       304,823  
Outcomes   18.0%  $       182,894  
Target Points   12.0%  $       121,929  
   
TOTAL 100% 100%  $    1,016,078  
Control Panel cells in red font can be changed to manipulate model assumptions