Spreadsheet: dc6c929c-da23-40b6-b641-220540722d30
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Community and Technical Colleges
Report of Fundable Operating Expenses, FY2010
Summary of Statewide Costs per Contact Hour
 |  |  | Departmental
 |  | Faculty | Operating |  | FY 2010 | FY 2009 | [NAME]
Fund | Program | Salaries | Expenses | Allocated
1 | Agriculture | 3.158170600451741 | 1.593662285688299 | 3.602811342953104 | 8.354644229093143 | 8.945787398468497 | -0.06608061907178302
2 | Architecture and Precision Production Trades | 3.775979694024524 | 1.773057088467739 | 3.602811342953104 | 9.151848125445367 | 9.894837101004043 | -0.07508855052128993
3 | Biology, Physical Sciences, and Science Technology | 2.790953369707635 | 1.030881091362113 | 3.602811342953104 | 7.424645804022852 | 7.786754703340096 | -0.04650318561620014
4 | Business Management, Marketing, and Administrative Services | 2.833386048937411 | 1.10977516154896 | 3.602811342953104 | 7.545972553439475 | 7.951243778014932 | -0.05096953833764051
5 | Career Pilot | 8.540473718327473 | 19.58891827240238 | 3.602811342953104 | 31.73220333368296 | 35.06381068882362 | -0.09501555277911047
6 | Communications | 2.527752181070881 | 2.411031346944261 | 3.602811342953104 | 8.541594870968245 | 8.913350001102012 | -0.04170767781897993
7 | Computer and Information Sciences | 3.855283718095996 | 1.55109560591764 | 3.602811342953104 | 9.00919066696674 | 9.877173938990769 | -0.08787769430662853
8 | Construction Trades | 3.583221177647144 | 1.963892917648288 | 3.602811342953104 | 9.149925438248536 | 10.67359938065823 | -0.1427516518158591
9 | Consumer and Homemaking Education | 2.606687136314951 | 1.324513323116535 | 3.602811342953104 | 7.53401180238459 | 7.778353162405833 | -0.0314129938458166
10 | Engineering | 5.103414250221723 | 1.862795655978903 | 3.602811342953104 | 10.56902124915373 | 11.27700058107739 | -0.06278081896276896
11 | Engineering Related | 2.638827482962787 | 1.912216705929116 | 3.602811342953104 | 8.153855531845007 | 8.426232442942066 | -0.03232487507809086
12 | English Language, Lit, Philosophy, Humanities, & Interdisciplinary | 3.352121288861774 | 0.8779114315345928 | 3.602811342953104 | 7.832844063349471 | 8.259177727904454 | -0.05161938374501524
13 | Foreign Languages | 2.914015111296218 | 0.608908772413797 | 3.602811342953104 | 7.125735226663118 | 7.528338409346348 | -0.05347835880802092
14 | Health Occupations - Dental Assist., [NAME]. Lab, & Assoc. Degree Nursing | 6.391504742669827 | 2.11677875061008 | 3.602811342953104 | 12.11109483623301 | 12.21429335844396 | -0.008448996530740972
15 | Health Occupations - Dental Hygiene | 9.911716566464923 | 4.118575191522732 | 3.602811342953104 | 17.63310310094076 | 17.74375701472493 | -0.006236216698208195
16 | Health Occupations - Other | 4.174513556445544 | 1.81422336996446 | 3.602811342953104 | 9.591548269363107 | 9.953055212712012 | -0.03632120345189983
17 | Health Occupations - Respiratory Therapy | 7.637661750598304 | 1.836871301816837 | 3.602811342953104 | 13.07734439536824 | 12.49843337480997 | 0.04631868676637887
18 | Health Occupations - Vocational Nursing | 4.792480120775231 | 1.15743916686113 | 3.602811342953104 | 9.552730630589465 | 9.681757028994646 | -0.01332675443297905
19 | Mathematics | 2.911615535516305 | 0.7079149634711914 | 3.602811342953104 | 7.2223418419406 | 7.5965569113082 | -0.04926114208537623
20 | Mechanics and Repairers - Automotive | 4.042684747266517 | 1.834809447269356 | 3.602811342953104 | 9.480305537488977 | 10.07637713657209 | -0.05915534829672819
21 | Mechanics and Repairers - Diesel, Aviation Mech, & Transport . Workers | 3.383708716948154 | 2.954096294941365 | 3.602811342953104 | 9.940616354842623 | 10.2214789235638 | -0.02747768408284772
22 | Mechanics and Repairers - Electronics | 3.413622036064177 | 1.806910407496805 | 3.602811342953104 | 8.823343786514085 | 9.31545973581067 | -0.05282787573057537
23 | Physical Education and Fitness | 3.929246777774115 | 1.380234364202746 | 3.602811342953104 | 8.912292484929965 | 9.346500393125556 | -0.04645673673912802
24 | Protective Services and Public Administration | 2.610327948646002 | 1.894201258653962 | 3.602811342953104 | 8.107340550253067 | 8.593643922245361 | -0.05658872724915417
25 | Psychology, Social Sciences, and History | 2.644757532047987 | 0.5022295820261214 | 3.602811342953104 | 6.749798457027213 | 7.074075438312902 | -0.04584019270269844
26 | Visual and Performing Arts | 4.094581092943127 | 1.452405259815107 | 3.602811342953104 | 9.149797695711337 | 9.697977513166265 | -0.05652516895514581
NOTES
These rates are "all funds" and will be adjusted to remove tuition before use in the formula runs.
Hours used in this study are from fall 09, spring 10 and summer 10.
The rates are calculated by dividing the total hours by the total costs.