Midlands  86.78% 2001 Annualization         49,843           24,922 SREB Salary
Formula/ 85.67% 2002 Annualization 0.001769 Conversion Factor
MRR Worksheet 86.19% 2003 Annualization
CIP 2001 2002 2003 2001 2002 2003 Credits Credit     FTE: Faculty FTE Student Instructional Empl Share Support Support Instruction  Library  Admin Student  Revenue Revenue OUT OF Indirect Direct Total Indirect Direct Total MRR State Funding per FTE Total State $ per Contact Hour  (CE Only)
Code Credits Credits Credits Annualized Annualized Annualized Funded FTE Lower Upper Ratio Faculty Credit Hrs Salaries 26% %   Total  Total  Total Services Deduct IND Deduct DIR State Stud MRR MRR MRR Per FTE Per FTE Per FTE  0.3171021  
1              0.00 0.00 0.00 0.00 0.00 8 12 12 0.00                -                    -                -        0.42                  -                    -                -                 -                    -                -                -                -                  -                  -                  -                -                -                -                -  
2       0.00 0.00 0.00 0.00 0.00 10 15 15 0.00                -                    -                -        0.42                  -                    -                -                 -                    -                -                -                -                  -                  -                  -                -                -                -                -  
3         0.00 0.00 0.00 0.00 0.00 10 15 15 0.00                -                    -                -        0.42                  -                    -                -                 -                    -                -                -                -                  -                  -                  -                -                -                -                -  
8 978.00 984.00 1,080.00 1,126.99 1,148.58 1,253.07 1,176.21 78.41 13 19 19 4.13      2,352.43         205,705       53,483      0.29           59,654         318,842       15,126      126,413           59,029      (39,033)      (38,878)        (4,890)       216,299       220,310       436,609         2,758         2,810         5,568         1,766
9        0.00 0.00 0.00 0.00 0.00 9 13 13 0.00                -                    -                -        0.28                  -                    -                -                 -                    -                -                -                -                  -                  -                  -                -                -                -                -  
10       0.00 0.00 0.00 0.00 0.00 9 13 13 0.00                -                    -                -        0.28                  -                    -                -                 -                    -                -                -                -                  -                  -                  -                -                -                -                -  
11       7,926.00 7,233.00 6,705.00 9,133.44 8,442.76 7,779.51 8,451.90 563.46 13 18 18 31.30     16,903.81      1,560,253      405,666      0.57         889,344      2,855,263      108,693      908,365         528,612     (365,252)     (294,888)      (35,140)     2,034,622     1,671,031     3,705,653         3,611         2,966         6,577         2,085
12       0.00 0.00 0.00 0.00 0.00 10 15 15 0.00                -                    -                -        0.22                  -                    -                -                 -                    -                -                -                -                  -                  -                  -                -                -                -                -  
13               0.00 0.00 0.00 0.00 0.00 12 17 17 0.00                -                    -                -        0.33                  -                    -                -                 -                    -                -                -                -                  -                  -                  -                -                -                -                -  
14 414.00 409.00 412.00 477.07 477.41 478.02 477.50 31.83 10 15 15 2.12         955.00         105,778       27,502      0.59           62,409         195,689         6,141        51,319           36,229      (23,415)      (19,992)        (1,985)       130,698       113,288       243,986         4,106         3,559         7,664         2,430
15 1,995.00 2,226.00 2,479.00 2,298.92 2,598.31 2,876.27 2,591.17 172.74 10 15 15 11.52      5,182.33         574,007      149,242      0.59         338,664      1,061,913       33,323      278,485         196,598     (127,060)     (108,487)      (10,773)       709,236       614,762     1,323,998         4,106         3,559         7,664         2,430
16 1,067.00 1,336.00 1,803.00 1,229.55 1,559.45 2,091.94 1,626.98 108.47 12 17 17 6.38      3,253.96         318,014       82,684      0.25           79,504         480,202       20,923      174,859           88,903      (54,628)      (60,105)        (6,764)       302,796       340,593       643,390         2,792         3,140         5,932         1,881
20  138.00 258.00 393.00 159.02 301.15 455.98 305.38 20.36 10 15 15 1.36         610.77           67,650       17,589      0.22           14,883         100,122         3,927        32,821           18,536      (10,525)      (12,786)        (1,270)         58,373         72,453       130,826         2,867         3,559         6,426         2,038
22 1,143.00 1,194.00 1,464.00 1,317.12 1,393.70 1,698.61 1,469.81 97.99 14 20 20 4.90      2,939.63         244,200       63,492      0.22           53,724         361,416       18,902      157,968           66,911      (44,626)      (46,154)        (6,111)       246,768       261,538       508,306         2,518         2,669         5,187         1,645
23  15,213.00 16,017.00 16,914.00 17,530.54 18,695.94 19,624.54 18,617.01 1,241.13 12 17 17 73.01     37,234.01      3,638,931      946,122      0.17         618,618      5,203,671      239,419   2,000,855         963,387     (573,342)     (687,758)      (77,402)     3,171,534     3,897,295     7,068,829         2,555         3,140         5,695         1,806
24  84.00 99.00 108.00 96.80 115.56 125.31 112.55 7.50 13 18 18 0.42         225.11           20,778         5,402      0.17             3,532           29,712         1,447        12,097             5,501        (3,387)        (3,927)           (468)         18,722         22,253         40,975         2,495         2,966         5,461         1,732
26 4,904.00 6,211.00 6,663.00 5,651.07 7,249.83 7,730.77 6,877.22 458.48 13 18 18 25.47     13,754.45      1,269,561      330,086      0.64         812,519      2,412,166       88,443      739,127         446,579     (313,000)     (239,947)      (28,593)     1,745,074     1,359,700     3,104,774         3,806         2,966         6,772         2,147
27 14,693.00 15,979.00 16,955.00 16,931.32 18,651.59 19,672.11 18,418.34 1,227.89 13 19 19 64.63     36,836.68      3,221,141      837,497      0.20         644,228      4,702,866      236,864   1,979,503         870,670     (559,690)     (608,796)      (76,576)     3,094,999     3,449,842     6,544,841         2,521         2,810         5,330         1,690
30 37.00 53.00 25.00 42.64 61.86 29.01 44.50 2.97 13 18 18 0.16           89.00             8,215         2,136      0.27             2,218           12,569            572          4,783             2,327        (1,485)        (1,553)           (185)           8,230           8,798         17,028         2,774         2,966         5,740         1,820
31       0.00 0.00 0.00 0.00 0.00 10 15 15 0.00                -                    -                -        0.22                  -                    -                -                 -                    -                -                -                -                  -                  -                  -                -                -                -                -  
32 2,061.00 1,623.00 2,397.00 2,374.97 1,894.46 2,781.13 2,350.19 156.68 9 14 14 11.19      4,700.37         557,811      145,031      0.25         139,453         842,295       30,224      252,585         155,939      (86,730)     (105,426)        (9,771)       481,700       597,416     1,079,116         3,074         3,813         6,887         2,184
33       0.00 0.00 0.00 0.00 0.00 9 14 14 0.00                -                    -                -        0.27                  -                    -                -                 -                    -                -                -                -                  -                  -                  -                -                -                -                -  
35 4,059.00 4,080.00 4,170.00 4,677.35 4,762.41 4,838.26 4,759.34 317.29 13 18 18 17.63      9,518.67         878,591      228,434      0.27         237,220      1,344,245       61,206      511,508         248,868     (158,820)     (166,054)      (19,787)       880,194       940,971     1,821,165         2,774         2,966         5,740         1,820
38 1,221.00 1,383.00 1,608.00 1,407.01 1,614.32 1,865.69 1,629.00 108.60 12 17 17 6.39      3,258.01         318,409       82,786      0.17           54,130         455,325       20,949      175,076           84,297      (50,168)      (60,179)        (6,773)       277,512       341,016       618,528         2,555         3,140         5,695         1,806
40 1,932.00 2,128.00 2,124.00 2,226.32 2,483.92 2,464.38 2,391.54 159.44 12 17 17 9.38      4,783.08         467,457      121,539      0.56         261,776         850,772       30,756      257,030         157,508     (106,061)      (88,349)        (9,943)       591,066       500,647     1,091,713         3,707         3,140         6,847         2,171
41       0.00 0.00 0.00 0.00 0.00 10 15 15 0.00                -                    -                -        0.56                  -                    -                -                 -                    -                -                -                -                  -                  -                  -                -                -                -                -  
42 4,647.00 5,127.00 5,358.00 5,354.92 5,984.52 6,216.64 5,852.03 390.14 17 24 24 16.26     11,704.06         810,230      210,660      0.35         283,581      1,304,471       75,258      628,944         241,504     (184,393)     (153,134)      (24,330)     1,020,564       867,757     1,888,321         2,616         2,224         4,840         1,535
43  867.00 927.00 972.00 999.08 1,082.05 1,127.77 1,069.63 71.31 14 20 20 3.57      2,139.26         177,712       46,205      0.22           39,097         263,014       13,756      114,958           48,693      (32,476)      (33,588)        (4,447)       179,581       190,329       369,911         2,518         2,669         5,187         1,645
44 456.00 573.00 604.00 525.47 668.84 700.79 631.70 42.11 14 20 20 2.11      1,263.40         104,953       27,288      0.22           23,090         155,331         8,124        67,892           28,757      (19,179)      (19,836)        (2,626)       106,057       112,405       218,462         2,518         2,669         5,187         1,645
45 7,788.00 8,269.00 7,977.00 8,974.42 9,652.04 9,255.35 9,293.94 619.60 13 18 18 34.42     18,587.87      1,715,695      446,081      0.22         377,453      2,539,229      119,522      998,862         470,103     (294,891)     (324,266)      (38,641)     1,632,408     1,837,510     3,469,918         2,635         2,966         5,600         1,776
46       0.00 0.00 0.00 0.00 0.00 10 15 15 0.00                -                    -                -        0.59                  -                    -                -                 -                    -                -                -                -                  -                  -                  -                -                -                -                -  
47 1,334.00 1,565.00 1,615.00 1,537.22 1,826.76 1,873.81 1,745.93 116.40 10 15 15 7.76      3,491.86         386,766      100,559      0.59         228,192         715,517       22,453      187,643         132,468      (85,613)      (73,099)        (7,259)       477,884       414,226       892,110         4,106         3,559         7,664         2,430
48 820.00 818.00 654.00 944.92 954.82 758.81 886.18 59.08 10 15 15 3.94      1,772.36         196,311       51,041      0.59         115,823         363,175       11,396        95,242           67,237      (43,455)      (37,103)        (3,684)       242,559       210,249       452,808         4,106         3,559         7,664         2,430
49       0.00 0.00 0.00 0.00 0.00 10 15 15 0.00                -                    -                -        0.59                  -                    -                -                 -                    -                -                -                -                  -                  -                  -                -                -                -                -  
50 2,210.00 2,945.00 3,453.00 2,546.67 3,437.57 4,006.36 3,330.20 222.01 8 12 12 18.50      6,660.40         922,151      239,759      0.28         258,202      1,420,112       42,827      357,912         262,914     (138,278)     (174,287)      (13,846)       769,731       987,624     1,757,354         3,467         4,448         7,916         2,510
51 8,120.00 8,793.00 9,299.00 9,356.99 10,263.68 10,789.20 10,136.63 675.78 5 7 7 96.54     20,273.26      4,811,809   1,251,070      0.38      1,828,487      7,891,366      130,359   1,089,430      1,460,976     (676,388)     (909,432)      (42,144)     3,790,720     5,153,447     8,944,167         5,609         7,626       13,235         4,197
52  7,895.00 7,192.00 7,799.00 9,097.72 8,394.91 9,048.82 8,847.15 589.81 13 19 19 31.04     17,694.30      1,547,258      402,287      0.29         448,705      2,398,250      113,776      950,844         444,002     (293,599)     (292,432)      (36,783)     1,626,945     1,657,113     3,284,058         2,758         2,810         5,568         1,766
TOTAL TEP 92,002.00 97,422.00 103,031.00 106,017.52 113,716.43 119,542.16 113,092.04 7,539.47       484.11   226,184.07     24,129,385   6,273,641        7,874,506     38,277,533   1,454,387  12,154,520      7,086,548  (4,285,494)  (4,560,454)     (470,193)   23,814,274   25,842,572   49,656,847         3,159         3,428         6,586         2,089
62 366,268.50 371,906.50 291,421.00 366,268.50 371,906.50 291,421.00 343,198.67 607.12 15 15 15 40.47     18,213.55      1,008,687      262,259      0.58         585,038      1,855,984      117,115      978,747                  -       (252,135)     (190,642)       1,428,765     1,080,304     2,509,069         2,353         1,779         4,133         1,311              2.32
63   408.00 0.00 0.00 408.00 0.00 136.00 0.24 15 15 15 0.02             7.22               400            104      0.58               232               736              46            388                  -             (100)             (76)                566              428              995         2,354         1,781         4,135         1,311              2.32
64   9,848.00 10,117.00 0.00 9,848.00 10,117.00 3,327.50 5.89 15 15 15 0.39         176.59             9,780         2,543      0.58             5,672           17,995         1,135          9,489                  -          (2,445)        (1,848)           13,852         10,475         24,327         1,177            890         2,066            655              1.16
65 36,431.00 17,323.00 96,377.50 36,431.00 17,323.00 96,377.50 25,021.92 44.26 15 15 15 2.95      1,327.91           73,541       19,121      0.58           42,654         135,316         8,539        71,358                  -        (18,383)      (13,899)         104,168         78,763       182,931         1,177            890         2,066            655              1.16
66       0.00 0.00 0.00 0.00 0.00 15 15 15 0.00                -                    -                -        0.58                  -                    -                -                 -                    -                -                -                    -                  -                  -                -                -                -                -                    -  
TOTAL CEP 402,699.50 399,485.50 397,915.50 402,699.50 399,485.50 397,915.50 371,684.08 657.51       43.83     19,725.27      1,092,408      284,027           633,596      2,010,031      126,836   1,059,983                  -       (273,062)     (206,465)              -       1,547,352     1,169,970     2,717,322         2,353         1,779         4,133         1,311              2.15
TOTAL ALL 6,845.84 7,201.49 7,572.65 7,780.21 8,287.78 8,673.39 8,196.98 8,196.98       527.94   245,909.34     25,221,793   6,557,668        8,508,102     40,287,564   1,581,223  13,214,503      7,086,548  (4,558,556)  (4,766,919)     (470,193)   25,361,627   27,012,542   52,374,169         3,094         3,295         6,389         2,026
CEP Conversion Factor 0.001769
Instructional       40,287,564
Library  $187      1,581,223
Student Services  $        661  (Uses headcount-Credit Prog. Only)       7,086,548
Indirect Cost Rate 6,720 Administration  $     1,562     13,214,503
FTE Credits 8,196.98 Revenue Deduct 0     (9,325,476)
FTE Rate 1108.251984 Plant Adjustment 0  
FTE Percentage 103.20%     52,844,362
Adj for Out of State Students        (470,193)
Headcount 10,382 Per Cent of Funding 31.71021%     52,374,169
24-May-07 TOTAL STATE MRR BASE  $ 16,607,961