budget workshop 2015-16 - johnson county community college€¦ · the fy 2015-16 budget will be...

Board of Trustees Budget WorkshopFisca l Year 2015-2016

Table of Contents

Mission, Vision, & Values ........................................................... 1

Budget Guidelines ..................................................................... 2

Historical & Current Data Summaries & Graphs ........................ 3

Enrollment ........................................................................... 3

Assessed Valuation/Mill Levy .............................................. 4

General/PTE Funds Revenues .............................................. 5

General/PTE Funds Expenses ............................................... 6

General/PTE Funds Unencumbered Cash ............................ 7

Number of Positions 10 Year History ................................... 8

Estimated Taxes for Average Residence .............................. 9

Impact on Students ............................................................ 10

Public Two Year Colleges Tuition & Fees ........................... 11

Budget Spreadsheets ............................................................... 12

Budget Summary ............................................................... 12

Comparative Budget General/PTE .................................... 13

Comparative Budget Auxiliary ........................................... 14

Five Year Budget Projection ............................................... 15

Budget by Fund ........................................................................ 26

General/PTE Fund .............................................................. 26

Capital Outlay Fund ........................................................... 35

Adult Supplementary Education Fund ............................... 36

Motorcycle Driver Safety Fund .......................................... 38

Truck Driver Training Fund ................................................ 40

Auxiliary Enterprise Fund ................................................... 42

Student Activity Fund ........................................................ 45

Capital Expenditures ................................................................ 47

Schedule of Capital Expenses ............................................ 47

Detail of Capital Expenses .................................................. 48

Mission, Vision & Values From JCCC’s Strategic Plan, Adopted 2014

Mission

JCCC inspires learning to transform lives and strengthen communities.

Vision

JCCC will be a national leader through educational excellence and innovation.

Values

Integrity - We hold ourselves accountable for decisions and actions.

Collaboration - We respect diversity of thought in building a culture of collaboration.

Responsiveness - We respond to the needs of our students and communities through relevant offerings.

Leadership - We pursue leadership roles in our communities and higher education.

1

BOARD OF TRUSTEES PROPOSED GUIDELINES FOR THE 2015-2016 BUDGET

December 18, 2014

1. Unencumbered Cash Balances Unencumbered cash balances will be maintained in accordance with board policy ¶ 210.07. The ending unencumbered cash balance for FY 2015-16 in the General/PTE funds will be greater than the beginning balance.

2. Changes to Staffing Authorization Table

There will be no additional full-time faculty and staff positions. This does not preclude appropriate reallocation of positions.

3. Staff to Recommend Budget Priorities

College staff will recommend budget priorities to the Board of Trustees for consideration within the framework of these assumptions and Prioritizing the Budget Strategically (PBS) for FY 2015-16. All budgeted line items will be supported by the appropriate justification. Key Performance Indicators (KPI’s) identified by the college and the developing Strategic Plan will assist in setting priorities.

4. Base Budgets

The FY 2014-15 budgeted expenditure amounts in the various college funds will not serve as base budgets for the various college funds in the FY 2015-16 budget. The PBS process will be used to determine the proposed budget amounts.

5. Assessed Valuation and Enrollment

The FY 2015-16 budget will be prepared on the assumption that the county’s assessed valuation will increase by 4%. College staff will update the Board of Trustees Management Committee throughout the year on the county’s assessed valuation. The FY 2015-16 budget will be prepared using the following assumptions:

Assessed Valuation 4% increase Delinquency rate on taxes collected 2% Student credit hours No change

6. State Aid

The FY 2015-16 budget will reflect no change to State Aid. 7. Cost per Credit Hour

Tuition for the FY 2015-16 budget will increase by $3 per credit hour for in-state students and $8 per credit hour for out-of-state students.

8. Capital and Operating Budgets

Capital budgets and operating expense budgets will be subject to PBS. 9. Capital Outlay Fund

The FY 2015-16 budget will include .500 mills. This is the third year of the current five year capital outlay mill levy.

2

Credit Hours % Change Annual FTE2006-07 341,317 1.5% 11,3772007-08 339,368 -0.6% 11,3122008-09 346,990 2.2% 11,5662009-10 375,671 8.3% 12,5222010-11 379,896 1.1% 12,6632011-12 369,562 -2.7% 12,3192012-13 353,239 -4.4% 11,7752013-14 338,743 -4.1% 11,291

Est. 2014-15 338,897 0.0% 11,297Est. 2015-16 338,897 0.0% 11,297

Data Source: JCCC IR - Day 20 Student ODS

JOHNSON COUNTY COMMUNITY COLLEGEFY 2015-16 BUDGET

ENROLLMENT 10-YEAR HISTORY

310,000

320,000

330,000

340,000

350,000

360,000

370,000

380,000

390,000

2006-07 2007-08 2008-09 2009-10 2010-11 2011-12 2012-13 2013-14 2014-15 2015-16

Credit Hours

3

Assessed Valuation % Increase Mill Levy % Increase2006 7,733,096,457 7.73% 8.872 0.98%2007 8,168,949,925 5.64% 8.749 -1.39%2008 8,231,306,706 0.76% 8.768 0.22%2009 7,969,528,237 -3.18% 8.784 0.18%2010 7,535,717,941 -5.44% 8.799 0.17%2011 7,551,985,565 0.22% 8.776 -0.26%2012 7,520,503,387 -0.42% 8.785 0.10%2013 7,630,978,170 1.47% 9.551 8.72%2014 8,084,290,606 5.94% 9.461 -0.94%

Est. 2015 8,617,853,786 6.60% 9.461 0.00%

FY 2015-16 BUDGETJOHNSON COUNTY COMMUNITY COLLEGE

ASSESSED VALUATION/MILL LEVY

0.0002.0004.0006.0008.000

10.00012.000

2006 2007 2008 2009 2010 2011 2012 2013 2014 2015

Mill Levy

7,000,000,000

7,500,000,000

8,000,000,000

8,500,000,000

9,000,000,000

2006 2007 2008 2009 2010 2011 2012 2013 2014 2015

Assessed Valuation

4

1. On December 18, 2014 a 4% change in assessed valuation was approved by the Board for developing the FY 2015-16 budget. This has been updated to a 6.6% increase.2. The total mill levy for FY 2015-16 will remain the same.3. Student cost per credit hour will increase by $3 for in-county students.4. Student credit hours are projected to remain flat.5. The state operating grant revenues have been updated and are projected to decrease by an additional 5%.6. Motor vehicle revenue is projected to remain unchanged.


GENERAL/POST-SECONDARY TECHNICAL EDUCATION (PTE) FUNDS REVENUES

Ad Valorem Taxes 54%

Local Motor Vehicle Taxes

5%

State Grant 16%

Other 2%

Tuition 23%

2014-2015

Ad Valorem Taxes 55%

Local Motor Vehicle Taxes 5%

State Grant 15%

Other 2%

Tuition 23%

2015-2016

5

Budget Proposed Budget2014-15 2015-16

Salaries and Benefits $109,303,733 $106,280,239Current Operating 24,750,656 25,572,030Capital & Debt Service 6,053,337 6,923,029

$140,107,726 $138,775,298


GENERAL/PTE FUNDS EXPENSES

Salaries and Benefits 78%

Current Operating 18%

Capital 4%

2014-2015

Salaries and Benefits 77%

Current Operating 18%

Capital 5%

2015-2016

6

Unencumbered UCB as a % Unencumbered UCB as a % Unencumbered UCB as a %Month Cash Balance of Exp Budget of Month Cash Balance of Exp Budget of Month Cash Balance of Exp Budget ofEnding FY 13 $139,617,630 Ended FY 14 $137,701,764 Ended FY 15 $140,107,7266/30/2012 55,947,003$ 40.07%7/31/2012 44,697,446$ 32.01% 7/31/2013 42,184,724$ 30.63% 7/31/2014 48,035,177$ 34.28%8/31/2012 55,521,923$ 39.77% 8/31/2013 54,775,609$ 39.78% 8/31/2014 59,598,519$ 42.54%9/30/2012 50,395,457$ 36.10% 9/30/2013 49,577,519$ 36.00% 9/30/2014 55,394,778$ 39.54%

10/31/2012 42,536,229$ 30.47% 10/31/2013 39,537,172$ 28.71% 10/31/2014 46,261,118$ 33.02%11/30/2012 33,772,783$ 24.19% 11/30/2013 30,305,906$ 22.01% 11/30/2014 36,426,191$ 26.00%12/31/2012 24,344,857$ 17.44% 12/31/2013 21,552,525$ 15.65% 12/31/2014 27,684,798$ 19.76%

1/31/2013 67,623,283$ 48.43% 1/31/2014 68,430,451$ 49.69% 1/31/2015 78,620,491$ 56.11%2/28/2013 59,418,371$ 42.56% 2/28/2014 60,455,512$ 43.90% 2/28/2015 69,497,036$ 49.60%3/31/2013 52,121,183$ 37.33% 3/31/2014 54,136,621$ 39.31% 3/31/2015 63,193,418$ 45.10%4/30/2013 43,113,079$ 30.88% 4/30/2014 45,145,019$ 32.78% 4/30/2015 53,993,418$ 38.54%5/31/2013 32,861,996$ 23.54% 5/31/2014 35,345,169$ 25.67% 5/31/2015 43,893,418$ 31.33%6/30/2013 53,851,076$ 38.57% 6/30/2014 59,988,104$ 43.56% 6/30/2015 62,038,684$ 44.28%

$ 0

$ 10,000,000

$ 20,000,000

$ 30,000,000

$ 40,000,000

$ 50,000,000

$ 60,000,000

$ 70,000,000

$ 80,000,000

$ 90,000,000

FY13

FY14

FY15

General/PTE Funds - Unencumbered Cash 3 Yrs

7

Bargaining Full Time Full Time Part Time Part Time HourlyUnit Hourly Temporary Regular Temporary Technical

2015 348 236 328 38 424 520 0 1,8942014 348 239 344 30 427 514 0 1,9022013 360 242 366 30 455 544 0 1,9972012 374 251 381 28 469 585 0 2,0882011 374 236 391 23 466 630 0 2,1202010 367 254 375 20 484 623 35 2,1582009 366 252 378 21 466 592 35 2,1102008 365 246 372 18 471 553 33 2,0582007 354 223 349 16 476 702 33 2,1532006 348 212 332 32 478 564 27 1,993

Comparison 2015 to 2006 0 24 (4) 6 (54) (44) (27) (99)Comparison 2015 to 2014 0 (3) (16) 8 (3) 6 0 (8)

* 2015 Full-Time Temporary includes 28 grant funded positions.

Total


NUMBER OF POSITIONS 10 YEAR HISTORY/ALL FUNDS

Year Salaried

8

2014 Mean Appraised Value - All Residential $238,000 *

Residential Assessment Rate 11.5%Assessed Value $27,370JCCC Mill Levy 9.461

Taxes Levied $258.95

2015 Mean Appraised Value - All Residential $250,000 *

Residential Assessment Rate 11.5%Assessed Value $28,750JCCC Mill Levy 9.461

Taxes Levied $272.00

* Source: Office of the County Appraiser


ESTIMATED TAXES FOR AN AVERAGE RESIDENCE

9

Residence Cost per Cr. Hr. 30 Cr. Hrs. Cost per Cr. Hr. 30 Cr. Hrs.Johnson County $88 $2,640 $91 $2,730Other Kansas County $103 $3,090 $106 $3,180Out of State $206 $6,180 $214 $6,420

For comparative purposes, the following is provided:

University of KansasIn State $318 $9,540Out of State $828 $24,840Additional Fees $900

Kansas StateIn State $274 $8,220Out of State $727 $21,810Additional Fees $812

Metropolitan CCIn District $95 $2,850Out of District $175 $5,250Out of State $229 $6,870

Kansas City, Kansas CCIn State $93 $2,790Out of State $237 $7,110


IMPACT ON STUDENTS

2014-2015 2015-2016

10

PUBLIC TWO-YEAR COLLEGESAverage Published Tuition and Fees in Current Dollars, by State, 2009-10 to 2014-15Sorted High to Low for 2014-15 Cost

In Current Dollars 2009-10 2010-11 2011-12 2012-13 2013-14 2014-151-Year %

Change5-Year %

ChangeVermont $6,070 $6,250 $6,520 $6,790 $7,090 $7,320 3% 21%New Hampshire $5,892 $6,271 $6,724 $6,736 $6,736 $6,500 -4% 10%South Dakota $4,314 $4,585 $4,943 $5,468 $5,797 $5,683 -2% 32%Minnesota $4,739 $4,939 $5,161 $5,369 $5,406 $5,391 0% 14%Massachusetts $4,291 $4,594 $4,817 $5,114 $5,144 $5,325 4% 24%New York $3,871 $3,961 $4,253 $4,453 $4,655 $4,851 4% 25%Pennsylvania $3,448 $3,470 $3,927 $4,200 $4,407 $4,695 7% 36%South Carolina $3,481 $3,646 $3,717 $4,248 $4,408 $4,632 5% 33%Oregon $3,611 $3,745 $4,021 $4,222 $4,441 $4,555 3% 26%Virginia $3,087 $3,585 $3,983 $4,192 $4,349 $4,549 5% 47%Iowa $3,701 $3,912 $4,111 $4,251 $4,396 $4,541 3% 23%Ohio $3,495 $3,732 $3,953 $4,208 $4,362 $4,484 3% 28%Kentucky $3,759 $3,900 $4,051 $4,201 $4,321 $4,461 3% 19%New Jersey $3,794 $3,922 $4,111 $4,160 $4,274 $4,434 4% 17%Wisconsin $3,507 $3,623 $3,829 $4,030 $4,173 $4,307 3% 23%Washington $3,153 $3,360 $3,814 $4,243 $4,304 $4,291 0% 36%Alabama $2,839 $3,417 $4,010 $4,088 $4,143 $4,237 2% 49%North Dakota $3,878 $3,880 $3,926 $3,969 $4,106 $4,192 2% 8%Indiana $3,279 $3,441 $3,538 $3,660 $3,809 $4,152 9% 27%Maryland $3,394 $3,567 $3,708 $3,886 $3,988 $4,122 3% 21%Alaska $3,622 $3,699 $3,765 $3,995 $4,032 $4,064 1% 12%Rhode Island $3,376 $3,652 $3,676 $3,950 $3,950 $3,950 0% 17%Tennessee $2,971 $3,196 $3,552 $3,659 $3,762 $3,948 5% 33%Colorado $2,768 $3,122 $3,394 $3,577 $3,774 $3,902 3% 41%Connecticut $3,200 $3,408 $3,490 $3,598 $3,786 $3,866 2% 21%Idaho $2,418 $2,554 $2,791 $3,114 $3,686 $3,761 2% 56%Louisiana $2,049 $2,212 $2,701 $3,001 $3,307 $3,683 11% 80%Georgia $2,596 $2,800 $3,125 $3,315 $3,609 $3,576 -1% 38%Illinois $2,729 $3,010 $3,152 $3,249 $3,378 $3,526 4% 29%Oklahoma $2,704 $2,832 $3,024 $3,163 $3,290 $3,493 6% 29%Hawaii $2,443 $2,710 $2,965 $3,097 $3,254 $3,492 7% 43%Maine $3,236 $3,260 $3,329 $3,333 $3,397 $3,482 3% 8%Delaware $2,763 $2,889 $3,086 $3,113 $3,274 $3,471 6% 26%West Virginia $2,632 $2,524 $2,707 $2,923 $3,096 $3,468 12% 32%Utah $2,710 $2,867 $3,017 $3,149 $3,311 $3,449 4% 27%Michigan $2,527 $2,694 $2,861 $3,042 $3,215 $3,365 5% 33%Montana $2,978 $3,029 $3,054 $3,094 $3,158 $3,213 2% 8%Florida $2,553 $2,773 $2,985 $3,091 $3,140 $3,174 1% 24%Arkansas $2,378 $2,525 $2,663 $2,794 $2,960 $3,101 5% 30%Missouri $2,580 $2,580 $2,736 $2,888 $2,983 $3,096 4% 20%Nebraska $2,294 $2,412 $2,491 $2,601 $2,683 $2,749 2% 20%Wyoming $2,164 $2,223 $2,327 $2,440 $2,604 $2,719 4% 26%Nevada $2,022 $2,243 $2,513 $2,700 $2,700 $2,700 0% 34%Kansas $2,121 $2,281 $2,362 $2,517 $2,584 $2,628 2% 24%Mississippi $1,855 $2,119 $2,205 $2,265 $2,386 $2,526 6% 36%Arizona $1,918 $1,979 $2,151 $2,204 $2,323 $2,438 5% 27%North Carolina $1,600 $1,776 $2,070 $2,162 $2,242 $2,305 3% 44%Texas $1,746 $1,858 $2,040 $2,146 $2,222 $2,286 3% 31%New Mexico $1,208 $1,325 $1,499 $1,593 $1,696 $1,645 -3% 36%California $817 $819 $1,119 $1,419 $1,424 $1,429 0% 75%SOURCE: The College Board, Annual Survey of Colleges.Note: Average tuition and fee prices are weighted by full-time enrollment. This table was prepared in October 2014.

11

JOHNSON COUNTY COMMUNITY COLLEGEFY 2015-16 BUDGET SUMMARY

GENERAL/ CAPITAL SPECIAL ADULT MOTOR TRUCK AUXILIARY STUDENT RESTRICTEDPTE OUTLAY ASSESS. SUPP. ED. CYCLE DRIVING ENTERPRISE ACTIVITY & OTHER TOTAL

Beginning unencumbered cash balance 7/1/15 62,038,684 3,665,199 92,019 1,374,679 369,214 122,164 3,480,290 84,547 0 71,226,796

Revenue: AdValorem/Motor Vehicle 82,771,540 4,642,663 315,283 87,729,486 Tuition and Fees 31,422,817 4,219,069 162,839 868,200 36,672,925 State Grant 20,486,593 28,463 20,515,056 Other Income 3,279,469 1,405,000 97,132 4,781,601 Investment Income 77,099 1,000 3,278 5,000 328 86,705 Gifts, Grants & Rest. Rev. 40,703,670 40,703,670 Auxiliary Sales 12,700,067 12,700,067 Credit Hour Fee 2,371,201 3,050,073 5,421,274

138,037,518 4,643,663 315,283 5,627,347 191,302 868,200 12,705,067 2,468,661 43,753,743 208,610,784

Expense: Salaries and Benefits 106,280,239 2,896,506 57,602 5,288,691 563,385 3,500,000 118,586,423 Current Operating 25,335,030 305,000 4,244,307 16,400 868,200 7,163,793 787,247 1,500,000 40,219,977 Capital 5,932,546 1,750,000 105,800 10,800 622,778 27,500 1,000,000 9,449,424 Debt Service 990,483 250,000 250,000 2,753,743 4,244,226 Grants 237,000 1,424,348 35,000,000 36,661,348

138,775,298 2,000,000 305,000 7,246,613 84,802 868,200 13,325,262 2,802,480 43,753,743 209,161,398

Projected usage 98% 100% 100% 75% 92% 92% 98% 90% 100%Ending unencumbered cash balance 6/30/16 64,076,410 6,308,862 102,302 1,567,066 482,498 191,620 3,126,600 30,976 0 75,886,335

Mill Levy 8.926 .501 .034 -- -- -- -- -- -- 9.461

12

Actual Actual Budget Estimated Proposed Budget EstimatedFY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2016

Revenue: AdValorem/Motor Vehicle 69,133,908$ 75,274,879$ 78,027,555$ 78,027,555$ 82,771,540$ 82,771,540$ Tuition and Fees 30,805,650 29,674,358 30,547,183 30,547,183 31,422,817 31,422,817 State Grant 22,474,636 22,332,394 20,475,361 20,475,361 20,486,593 20,486,593 Other Income 1,957,665 2,925,363 3,226,532 3,226,532 3,279,469 3,279,469 Investment Income 68,492 60,827 74,134 74,134 77,099 77,099

124,440,351 130,267,821 132,350,765 132,350,765 138,037,518 138,037,518

Expense: Salaries and Benefits 102,189,337$ 99,975,269$ 109,303,733$ 101,652,472$ 106,280,239$ 104,154,634$ Current Operating 22,221,933 21,381,128 24,750,656 23,018,110 25,572,030 25,060,589 Capital 4,586,178 3,910,265 6,053,337 5,629,603 6,923,029 6,784,568

128,997,448 125,266,662 140,107,726 130,300,185 138,775,298 135,999,792

Contribution to/(Use of) Reserves (4,557,097)$ 5,001,159$ (7,756,961)$ 2,050,580$ (737,780)$ 2,037,726$ *assumes 93% *assumes 98%

expenditure rate expenditure rate

JOHNSON COUNTY COMMUNITY COLLEGEFY 2015-16 COMPARATIVE BUDGET

GENERAL/PTE FUNDS

13

Actual Actual Budget Proposed BudgetFY 2013 FY 2014 FY 2015 FY 2016

Revenue:Auxiliary Sales 12,348,243$ 12,572,632$ 14,397,160$ 12,700,067$ Investment Income 9,489 6,702 5,000 5,000

12,357,732 12,579,334 14,402,160 12,705,067

Expense: Salaries and Benefits 4,802,942$ 5,185,985$ 5,419,763$ 5,288,691$ Current Operating 7,428,676 6,628,517 8,318,443 7,163,793 Capital 2,929,204 429,319 1,210,949 872,778

15,160,822 12,243,821 14,949,155 13,325,262

Projected usage 90% 98%

Contribution to/(Use of) Reserves (2,803,090)$ 335,513$ (492,296)$ (353,690)$

*FY 2013 Capital expenses included baseball field improvements

JOHNSON COUNTY COMMUNITY COLLEGEFY 2015-16 COMPARATIVE BUDGET

AUXILIARY ENTERPRISE FUND

14

JCCC FIVE YEAR BUDGET PROJECTIONA S S U M P T I O N S

YEARS ENDING JUNE 30, 2016 TO 2020

4/7/2015 Budget2013/14 2014/15 2015/16 2016/17 2017/18 2018/19 2019/20

CONTROL OR INFLUENCE

Revenue

1 Mill Levy General/PTE 9.016 8.917 8.926 8.926 8.927 8.927 8.927 Capital Outlay 0.501 0.500 0.501 0.501 0.500 0.500 0.500 Special Assessment 0.034 0.034 0.034 0.034 0.034 0.034 0.034

9.551 9.451 9.461 9.461 9.461 9.461 9.461 Additional mill adjustment needed - included above 0.000 0.000 0.000 0.000 0.000Net Change 0.010 0.000 0.000 0.000 0.000

2 Tuition per cr. hr. (in state) $72 $75 $78 $81 $84 $873 Activity Fee per cr. hr. $7 $7 $7 $7 $7 $74 Other Fee per cr. hr. $6 $6 $6 $6 $6 $65 Campus Development Fee $3 $3 $3 $3 $3 $36 Total in state cost per credit hour $88 $91 $94 $97 $100 $103

7 Tuition per cr. hr. (out of state) $190 $198 $206 $214 $222 $2308 Tuition per cr. hr.(out district additional assessment) $15 $15 $15 $15 $15 $159 Credit Hours Increase 0.0% 0% 0% 0% 0% 0%

10 Adult Supplementary Ed Revenue Increase 2% 2% 2% 2% 2% 2%11 Motorcycle Driver Safety Revenue Increase 0.8% 2.0% 2% 2% 2% 2%12 Truck Driver Training Revenue Increase 158.0% 0.0% 0% 0% 0% 0%

Expense

1 Annual Salary Adjustment 2.50% 2.50% 2.50% 2.50% 2.50% 2.50%2 Staff Authorization Level - Regular & PT/General (FTE positions) -2,624,502 -2,019,447 0 0 0 03 Staff Authorization Level - Regular/Adult Supp Ed -218,543 -405,813 0 0 0 04 Staff Authorization Level - Regular/Motorcycle Driver -869 929 0 0 0 05 Staff Authorization Level - Auxiliary -117,318 -266,566 0 0 0 06 Staff Authorization Level - Student Activity 2,543 -54,394 0 0 0 07 Operating Expense Increase 1.33% 3.32% 1.00% 1.00% 1.00% 1.00%8 Employee Benefits Expense Increase 1.073% -10.6% 4.0% 4.0% 4.0% 4.0%9 Adult Supplementary Ed Operating Expense Increase 3.1% -1.0% 2% 2% 2% 2%

10 Motorcycle Driver Operating Expense Increase 18% 2% 0% 0% 0% 0%11 Truck Driver Training Expense Increase 156% -1% 0% 0% 0% 0%12 Student Activity Operating Expense Increase -2% -4% 0% 0% 0% 0%

Portion of budgeted revenue actually received - Auxiliary 90.0% 100.0% 100.0% 100.0% 100.0% 100.0%

WORKINGDRAFT

Projected Budget

15

JCCC FIVE YEAR BUDGET PROJECTIONA S S U M P T I O N S


4/7/2015 Budget2014/15 2015/16 0 2016/17 0 2017/18 0 2018/19 0 2019/20

NO CONTROL OR INFLUENCE

Revenue

1 Assessed Valuation Increase 6.1% 6.6% 3% 3% 3% 3%Portion from new construction 2.1% 3% 2% 2% 2% 2%Portion used from reappraisal 4.0% 1% 1% 1% 1% 1%

2 Motor Vehicle Increase 15% 0% 0% 0% 0% 0%3 LAVTR 0% 0% 0% 0% 0% 0%4 State Aid Reimbursable Credit Hour Rate, General -5.00% -5.00% 0.00% 0.00% 0.00% 0.00%5 Auxiliary Revenue Increase -1% 2% 2% 2% 2% 2%6 Investment Interest Increase 3% 4% 4% 4% 4% 4%7 Other Revenues Increase 2% 2% 2% 2% 2% 2%8 Delinquency Rate 2% 2% 2% 2% 2% 2%9 Tuition Forfeiture (% of tuition calculated, added) 6.2% 6.2% 6.2% 6.2% 6.2% 6.2%

Expense

1 Auxiliary Operating Increase -1% -14% 2% 2% 2% 2%2 0 0 0 0 0 03 Portion of budgeted expense actually expended

General/PTE 93% 98% 98% 98% 98% 98% Adult Supplementary Ed 70% 75% 75% 75% 75% 75% Motorcycle Driver Safety 92% 92% 92% 92% 92% 92% Truck Driver Training 92% 92% 92% 92% 92% 92% Auxiliary 90% 98% 98% 98% 98% 98% Student Activity 85% 90% 90% 90% 90% 90%

Other

1 Property, Plant, & Equipment Additions -(see schedule)2 Long Term Debt and Interest Expense- (see schedule)

To Reflect Changes to 2014/15 Beginning Balances due to 2013/14 Year End Adjustments General/PTE 5,917,715 Adult Supplementary Ed -199,804 Motorcycle Driver Safety 26,414 Truck Driver Training 8,251 Auxiliary -136,733 Student Activity 36,080 Capital Outlay 50,153To Adjust 6-30-15 Ending Cash Based on Estimated Actuals General/PTE (includes Employee Benefits) 0 Adult Supplementary Ed Motorcycle Driver Safety Truck Driver Training Auxiliary Student Activity 0 credit hour adjustment 0.00% Capital Outlay

Projected Budget

WORKINGDRAFT

16

JCCC FIVE YEAR BUDGET PROJECTIONSTATEMENTS OF REVENUES AND EXPENSES


4/7/2015 Budget2014/15 2015/16 2016/17 2017/18 2018/19 2019/20

REVENUES AND OTHER ADDITIONSGeneral/PTE Beginning Balance $ 59,988,104 $ 62,038,684 $ 64,076,408 $ 65,453,675 $ 66,386,604 $ 65,219,878

Ad Valorem Property Taxes 78,027,555 82,771,540 85,035,259 87,376,227 89,779,272 92,253,566 Tuition and Fees 30,547,183 31,422,817 32,643,552 33,864,287 35,085,022 36,305,757 State Grant 20,475,361 20,486,593 20,486,593 20,486,593 20,486,593 20,486,593 Investments 74,134 77,099 80,183 83,391 86,726 90,195 Other 3,226,532 3,279,469 3,345,058 3,411,959 3,480,198 3,549,802 Current Year Revenues 132,350,765 138,037,518 141,590,646 145,222,457 148,917,812 152,685,913

192,338,869 200,076,202 205,667,054 210,676,132 215,304,415 217,905,791Adult Supplementary Ed Beginning Balance 1,372,055 1,374,679 1,567,066 1,799,692 2,026,580 2,247,339 Tuition and Fees 5,648,093 4,219,069 4,303,450 4,389,519 4,477,310 4,566,856 Investments 3,152 3,278 3,409 3,546 3,687 3,835 Other 1,920,716 1,405,000 1,433,100 1,461,762 1,490,997 1,520,817

8,944,016 7,002,026 7,307,026 7,654,519 7,998,574 8,338,847Motorcycle Driver Safety Beginning Balance 304,826 369,214 482,498 594,604 709,254 826,493 Tuition and Fees 124,964 162,839 166,096 169,418 172,806 176,262 Investments 210 0 0 0 0 0 Other 28,004 28,463 29,033 29,613 30,206 30,810

458,004 560,516 677,627 793,635 912,266 1,033,565Truck Driver Training Beginning Balance 38,427 122,164 191,620 261,076 330,532 399,988 Tuition and Fees 964,988 868,200 868,200 868,200 868,200 868,200 Investments 0 0 0 0 0 0 Other 0 0 0 0 0 0

1,003,415 990,364 1,059,820 1,129,276 1,198,732 1,268,188Auxiliary Beginning Balance 3,972,585 3,480,290 3,126,600 2,757,128 2,615,915 2,456,965 Sales 14,397,160 12,700,067 12,954,068 13,213,150 13,477,413 13,746,961 Investments 5,000 5,000 5,200 5,408 5,624 5,849

18,374,745 16,185,357 16,085,868 15,975,686 16,098,952 16,209,776Student Activity Beginning Balance 65,590 84,547 30,976 -15,316 -72,606 -141,178 Fees 2,398,494 2,371,201 2,371,201 2,371,201 2,371,201 2,371,201 Investments 315 328 341 354 369 383 Other 95,564 97,132 99,075 101,056 103,077 105,139

2,559,963 2,553,208 2,501,592 2,457,295 2,402,041 2,335,545Total Current Unrestricted Less Beginning Balances 157,937,425 159,898,095 163,823,818 167,835,684 171,918,701 176,082,226

Total Revenues w/ Beg. Bal. $ 223,679,012 $ 227,367,672 $ 233,298,987 $ 238,686,543 $ 243,914,979 $ 247,091,711

Capital Outlay Beginning Balance $ 1,815,933 $ 3,665,199 $ 6,308,862 $ 9,082,430 $ 11,978,224 $ 15,008,395 Ad Valorem Property Taxes 4,353,256 4,642,663 4,772,569 4,894,794 5,029,171 5,167,109 Investments 1,000 1,000 1,000 1,000 1,000 1,000

$ 6,170,189 $ 8,308,862 $ 11,082,430 $ 13,978,224 $ 17,008,395 $ 20,176,504

Note 1: Beginning Balance = unencumbered cash

WORKINGDRAFT

Projected Budget

17

JCCC FIVE YEAR BUDGET PROJECTIONSTATEMENTS OF REVENUES AND EXPENSES


4/7/2015 Budget2014/15 2015/16 2016/17 2017/18 2018/19 2019/20

EXPENDITURES AND OTHER DEDUCTIONS

General/PTE Salaries and Wages w/o Emp. Ben. $ 80,711,044 $ 80,709,373 $ 82,727,107 $ 84,795,285 $ 86,915,167 $ 89,088,046 Employee Benefits Portion 28,592,689 25,570,867 26,593,702 27,657,450 28,763,748 29,914,298 Current Operating 24,750,656 25,572,030 25,827,750 26,086,028 26,346,888 26,610,357 Capital 6,053,337 6,923,029 7,926,317 8,695,450 11,121,684 11,092,680

140,107,726 138,775,299 143,074,876 147,234,213 153,147,487 156,705,381Adult Supplementary Ed Salaries and Wages 3,221,775 2,896,506 2,968,919 3,043,142 3,119,221 3,197,201 Current Operating 4,285,437 4,244,307 4,329,193 4,415,777 4,504,093 4,594,174 Capital 61,000 105,800 45,000 45,000 45,000 45,000

7,568,212 7,246,613 7,343,112 7,503,919 7,668,313 7,836,375Motorcycle Driver Safety Salaries and Wages 55,291 57,602 59,042 60,518 62,031 63,582 Current Operating 16,100 16,400 16,400 16,400 16,400 16,400 Capital 11,800 10,800 14,800 14,800 14,800 14,800

83,191 84,802 90,242 91,718 93,231 94,782Truck Driver Training Salaries and Wages 0 0 0 0 0 0 Current Operating 873,970 868,200 868,200 868,200 868,200 868,200 Capital 0 0 0 0 0 0

873,970 868,200 868,200 868,200 868,200 868,200Auxiliary Salaries and Wages w/ Emp. Ben 5,419,763 5,288,691 5,420,908 5,556,431 5,695,342 5,837,725 Current Operating 8,318,443 7,163,793 7,307,069 7,453,210 7,602,274 7,754,320 Capital 960,949 622,778 622,778 622,778 622,778 622,778 Debt Payments 250,000 250,000 250,000 0 0 0

14,949,155 13,325,262 13,600,755 13,632,419 13,920,394 14,214,823Student Activity Salaries and Wages 602,711 563,385 577,469 591,906 606,704 621,871 Current Operating 2,295,043 2,211,595 2,211,595 2,211,595 2,211,595 2,211,595 Capital 14,500 27,500 7,500 7,500 7,500 7,500

2,912,254 2,802,480 2,796,564 2,811,001 2,825,799 2,840,966

Total Current Unrestricted 166,494,508 163,102,657 167,773,751 172,141,470 178,523,425 182,560,528

Revenues with Beginning Balances Over/Under Expenses $ 57,184,504 $ 64,265,016 $ 65,525,236 $ 66,545,072 $ 65,391,555 $ 64,531,183

Capital Outlay Fund Payments and Expenses $ 2,504,990 $ 2,000,000 $ 2,000,000 $ 2,000,000 $ 2,000,000 $ 2,000,000

Increase/Decrease in Unencumbered Cash General/PTE $ 2,050,580 $ 2,037,725 $ 1,377,267 $ 932,928 $ -1,166,726 $ -885,360 Adult Supplementary Ed 2,624 192,387 232,625 226,888 220,760 214,226 Motorcycle Driver Safety 64,388 113,284 112,106 114,650 117,239 119,872 Truck Driver Training 83,737 69,456 69,456 69,456 69,456 69,456 Auxiliary -492,296 -353,690 -369,472 -141,213 -158,949 -177,717 Student Activity 18,957 -53,571 -46,292 -57,290 -68,572 -80,147 Capital Outlay 1,849,266 2,643,663 2,773,569 2,895,794 3,030,171 3,168,109

WORKING DRAFT

Projected Budget

18

JCCC FIVE YEAR BUDGET PROJECTIONSCHEDULE OF CAPITAL AND ADDITIONS


4/7/2015 Budget2014/15 2015/16 2016/17 2017/18 2018/19 2019/20

ASSET ADDITIONS

General/PTE $ 5,040,016 $ 5,932,546 $ 6,964,346 $ 7,919,346 $ 10,369,346 $ 10,369,346 Adult Supplementary Ed 61,000 105,800 45,000 45,000 45,000 45,000 Motorcycle Driver Safety 11,800 10,800 14,800 14,800 14,800 14,800 Truck Driver Training 0 0 0 0 0 0 Auxiliary 960,949 622,778 622,778 622,778 622,778 622,778 Student Activity 14,500 27,500 7,500 7,500 7,500 7,500

$ 6,088,265 $ 6,699,424 $ 7,654,424 $ 8,609,424 $ 11,059,424 $ 11,059,424

Detail: Remodeling and Renovation 54020 $ 1,285,000 $ 1,902,979 $ 2,857,979 $ 3,812,979 $ 6,262,979 $ 6,262,979 Non capital furniture and fixtures 54030 2,146,790 3,099,412 3,099,412 3,099,412 3,099,412 3,099,412 Library Book Acq. 54040 88,033 89,354 89,354 89,354 89,354 89,354 Rental Textbooks 54045 800,000 0 0 0 0 0 Furniture, fixtures, and equip. 54050 1,183,011 1,545,676 1,545,676 1,545,676 1,545,676 1,545,676 Audiovisual Materials 54060 10,000 3,000 3,000 3,000 3,000 3,000 Library Book Acq. - cont. 54070 58,131 59,003 59,003 59,003 59,003 59,003 Building/Land improvements 54080 54090 487,000 0 0 0 0 0 Mandatory Transfer 57400 Systems Furniture 54010 2,300 0 0 0 0 0 Art Acquisitions/Installation 54065 54066 28,000 0 0 0 0 0

$ 6,088,265 $ 6,699,424 $ 7,654,424 $ 8,609,424 $ 11,059,424 $ 11,059,424

WORKINGDRAFT

Projected Budget

19

JCCC FIVE YEAR BUDGET PROJECTIONSCHEDULE OF DEBT


4/7/2015 Budget2014/15 2015/16 2016/17 2017/18 2018/19 2019/20

DEBT SCHEDULE

TOTAL -Current General/PTE Fund Payments $ 1,013,321 $ 990,483 $ 961,971 $ 776,104 $ 752,338 $ 723,334 Auxiliary Payments 250,000 250,000 250,000 0 0 0

$ 1,263,321 $ 1,240,483 $ 1,211,971 $ 776,104 $ 752,338 $ 723,334

Other fees 7,463 5,810Balance at

Detail: 6-30-14

ITEM #1 - 0 c Principal 0 0 0 0 0 0 Interest 0 0 0 0 0 0 Total Payments 0 0 0 0 0 0

ITEM #2 - PEI 1,985,017 Principal - General c 161,673 161,673 161,671 0 0 Principal - Auxiliary c 250,000 250,000 250,000 0 0 Principal - Capital Outlay p 250,000 250,000 250,000 0 0 Total Payments 661,673 661,673 661,671 0 0 0

ITEM #3 - 2009 COP's 9,485,000 Principal p 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 Principal c 490,000 520,000 555,000 595,000 640,000 685,000 Interest c 354,185 303,000 245,300 181,104 112,338 38,334 Total Payments 1,844,185 1,823,000 1,800,300 1,776,104 1,752,338 1,723,334

ITEM #4 - 06 Rev Bonds 5,525,000 p Principal MEMO 600,000 630,000 650,000 675,000 700,000 730,000

Interest 199,923 169,173 143,673 123,798 100,547 73,552Total Payments 799,923 799,173 793,673 798,798 800,547 803,552

ITEM #5 - 11 Rev Bonds 9,670,000 p MEMO Principal 45,000 50,000 50,000 50,000 50,000 55,000 Interest 364,325 363,375 362,250 360,938 359,500 357,925 Total Payments 409,325 413,375 412,250 410,938 409,500 412,925

ITEM #6 - 12 Rev Bonds 4,680,000 p Principal MEMO 455,000 460,000 485,000 485,000 495,000 505,000 Interest 87,913 79,900 70,450 60,750 50,950 40,950Total Payments 542,913 539,900 555,450 545,750 545,950 545,950

MEMO - does not affect current unrestricted funds.

WORKINGDRAFT

Projected Budget

20

JCCC FIVE YEAR BUDGET PROJECTIONSCHEDULE OF ADDITIONAL FINANCIAL DATA


4/7/2015 Budget2014/15 2015/16 2016/17 2017/18 2018/19 2019/20

Motor Vehicle $ 7,739,661 $ 7,739,661 $ 7,739,661 $ 7,739,661 $ 7,739,661 $ 7,739,661LAVTR 0 0 0 0 0 0

7,739,661 7,739,661 7,739,661 7,739,661 7,739,661 7,739,661

Credit Hours 338,743 338,743 338,743 338,743 338,743 338,743Reimbursable Credit Hours (for State Aid)Out of District Credit Hours 60,296 60,296 60,296 60,296 60,296 60,296

State Grant 20,475,361 20,486,593 20,486,593 20,486,593 20,486,593 20,486,593Fall Headcount Enrollment 18,902 18,902 18,902 18,902 18,902 18,902

Fall FTE 11,353 11,012 11,012 11,012 11,012 11,012 11,012

Assessed Valuation 8,093,371,876 8,627,534,420 8,886,360,452 9,152,951,266 9,427,539,804 9,710,365,998Assessed Valuation - Portion used 8,417,106,751 8,886,360,452 9,152,951,266 9,427,539,804 9,710,365,998

Authorized tax levy reduction 0 8,986 0 0 0 0 mil reduction 0.107 0.000 0.000 0.000 0.000 0.000% out of state credit hours 8.00% 8.00% 8.00% 8.00% 8.00% 8.00%% out of district credit hours 17.80% 17.80% 17.80% 17.80% 17.80% 17.80%

One Mil is equal to: 8,093,372 8,627,534 8,886,360 9,152,951 9,427,540 9,710,366One Dollar of Tuition is equal to: 338,743 338,743 338,743 338,743 338,743 338,743Cost per Credit Hour (Exp/credit hours) 414 410 422 435 452 463Average Home Value 238,160 240,542 242,947 245,376 247,830 250,309Average Tax per Home 258.83 261.71 264.33 266.97 269.64 272.34Tax per Home as % of Home Value 0.11% 0.11% 0.11% 0.11% 0.11% 0.11%Commercial Value - Change Estimated 4.33% 10.39%

Projected Budget

WORKING DRAFT

21

JCCC FIVE YEAR BUDGET PROJECTIONHISTORY OF ASSUMPTION FACTORS and OTHER FINANCIAL DATA

FOR JUNE 30, 2008 TO 2015Current

4/7/2015 Budget Projected2008/09 2009/10 2010/11 2011/12 2012/13 2013/14 2014/15 2015/16

CONTROL OR INFLUENCE

Revenue1 Mill Levy 8.768 8.784 8.799 8.776 8.785 9.551 9.451 9.4612 Tuition per cr. hr. (in state) $51 $55 $60 $66 $69 $69 $72 $753 Tuition/State Aid per cr. hr. (out district) $0 $0 $0 $0 $0 $0 $0 $04 Activity Fee per cr. hr. $6 $6 $6 $6 $6 $7 $7 $75 Other Fee per cr. hr. $8 $8 $9 $9 $9 $9 $9 $96 Tuition per cr. hr. (out of state) $135 $145 $158 $174 $182 $182 $190 $1987 Tuition per cr. hr. (out district add. assessment) $15 $15 $15 $15 $15 $15 $15 $15

8 Credit Hours Increase 2.2% 8.3% 1.1% -2.7% -4.4% -4.1% 0.0% 0.0%

9 Adult Supplementary Ed Revenue Increase -6.82% 3.90% -13.90% 1.24% -8.38% 7.77% 2.00% 2.00%

Expense1 Annual Salary Adjustment 4.35% 1.25% 0.00% 1.00% 2.00% 2.50% 2.50% 2.50%

2 Staff Authorization Level - Regular/Gen. & Voc. 2,265,566 -681,764 5,464,943 742,825 -443,418 -2,898,195 -2,624,502 -2,019,447

3 Staff Authorization Level - Regular/adult supp ed. 459,745 -463,490 -21,857 -144,484 153,041 -482,777 -218,543 -405,813

4 Staff Authorization Level - Regular/motorcycle 24,874 4,182 0 -869 929

5 Staff Authorization Level - Regular/auxiliary 39,056 23,982 397,998 839,725 -142,977 358,837 -117,318 -266,566

6 Staff Authorization Level - Regular/student act. 54,477 29,525 4,122 5,983 800 -104,745 2,543 -54,394

7 Operating Expense Increase -1.27% -6.57% 5.97% 2.59% 2.85% -2.00% 1.33% 3.32%

8 Employee Benefits/Expense Increase 18.26% 0.77% -6.45% 3.14% -0.09% -4.81% 1.07% -10.57%

9 Adult Suppl Ed Operating Expense Increase -1.88% -11.15% -6.57% -0.97% 0.56% 1.33% 3.1% -1.0%

10 Student Activity Operating Expense Increase 8.23% -2.88% 9.93% 14.89% -22.47% 2.89% -2.0% -3.6%

11 Average Home Value 245,826 240,316 236,903 233,942 228,000 229,000 238,160 240,54212 Average Tax per Home 247.87 242.76 239.72 236.10 230.34 251.53 258.85 261.7113 Tax per Home as % of Home Value 0.10% 0.10% 0.10% 0.10% 0.10% 0.11% 0.11% 0.11%

NO CONTROL OR INFLUENCE

Revenue1 Assessed Valuation Increase 0.76% -3.18% -5.44% 0.22% -0.30% 1.70% 6.06% 6.60%

2 Motor Vehicle Increase -4.45% -2.90% 0.00% 0.00% 0.00% 0.00% 15% 0%

3 LAVTR 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0% 0%

4 State Grant 5.17% -5.69% -4.62% 8.35% 10.10% -0.63% -5.00% -5.00%

5 Auxiliary Revenue Increase -0.64% 6.00% -1.99% 5.81% -12.19% 1.65% -1% 2%

6 Investment Interest Increase -63.64% -89.91% -15.78% -47.26% 20.91% -16.20% 3% 4%

7 Other Revenues Increase -17.29% 33.37% 9.86% -57.89% -4.55% 20.95% 2% 2%

8 % of Total Revenue - Gen. Fund - BgtAd Valorem Property Taxes 57% 56% 54% 54% 54% 57% 59% 60%Tuition and Fees 17% 20% 24% 26% 26% 23% 23% 23%State Grant 17% 15% 15% 17% 17% 17% 15% 15%Investments and Other 9% 8% 7% 3% 3% 3% 2% 2%

9 Delinqency Rate 3% 3% 3% 3% 3% 2% 2% 2%10 Tuition Forfeiture ( %of tuition calc. Add) 6.1% 6.1% 6.1% 6.1% 6.1% 6.2% 6.2% 6.2%11 Portion of budgeted revenue actually rec. - Aux. 85.3% 89.2% 85.6% 91.3% 82.7% 86.2% 90.0% 98.0%

Expense1 Auxiliary Operating Increase 7.95% 12.84% 3.07% 5.27% -8.95% -7.91% -1.0% -14%

2 Portion of budget actually used

General/PTE 93.8% 93.5% 92.6% 95.6% 94.0% 91.6% 93% 98%

Adult Supplementary Ed 67% 60% 65% 69.5% 69.9% 70.9% 70% 75%

Motorcycle 92.3% 92.7% 73.0% 81.0% 92% 92%

Auxiliary 81.8% 90.1% 87.0% 89.9% 80.0% 82.4% 90% 98%

Employee Benefits 94.7% 86.8% 83.2% 94.8% 91.4% 86.6% 93% 98%

Student Activity 86.2% 80.1% 84.6% 89.5% 76.1% 84.4% 85% 90%

WORKING DRAFT

22

JCCC FIVE YEAR BUDGET PROJECTIONRESERVE ANALYSIS


4/7/2015 BudgetGeneral Fund/PTE 2014/15 2015/16 2016/17 2017/18 2018/19 2019/20 Beginning Balance 59,988,104 62,038,684 64,076,408 65,453,675 66,386,604 65,219,878

Total Expenses 140,107,726 138,775,299 143,074,876 147,234,213 153,147,487 156,705,381

Reserve: Minimum 10% 14,010,773 13,877,530 14,307,488 14,723,421 15,314,749 15,670,538 16.5% - Note 1 23,117,775 22,897,924 23,607,355 24,293,645 25,269,335 25,856,388

Estimated Reserve at 12/31: Beginning Balance at 7/1 59,988,104 62,038,684 64,076,408 65,453,675 66,386,604 65,219,878

Differential at 22% of Expense 30,823,700 30,530,566 31,476,473 32,391,527 33,692,447 34,475,18429,164,404 31,508,118 32,599,936 33,062,149 32,694,157 30,744,694

Amount Over: Minimum 10% 15,153,632 17,630,588 18,292,448 18,338,727 17,379,408 15,074,156 16.5% - Note 1 6,046,629 8,610,194 8,992,581 8,768,503 7,424,821 4,888,306

Unrestricted Fund Balances as a % of Total Revenues: 42% 42% 42% 42% 42% 40%

Unrestricted Fund Balances as a % of Total Expenses: 40% 41% 41% 41% 40% 38%

Note 1 - per League of Municipalities guidelines.Note 2 - Other UnrestrictedCash Balances: Adult Supplemental 1,372,055 1,374,679 1,567,066 1,799,692 2,026,580 2,247,339 Auxiliary 3,972,585 3,480,290 3,126,600 2,757,128 2,615,915 2,456,965 Student Activity 65,590 84,547 30,976 -15,316 -72,606 -141,178Note 3 - Cash used - General Fund -2,050,580 -2,037,725 -1,377,267 -932,928 1,166,726 885,360

Projected Budget

WORKING DRAFT

23

4/7/2015 BudgetRevenues 2014/15 2015/16 2016/17 2017/18 2018/19 2019/20Ad Valorem $ 78,027,555 $ 82,771,540 $ 85,035,259 $ 87,376,227 $ 89,779,272 $ 92,253,566

5.7% 2.7% 2.7% 2.7% 2.7%

Tuition 30,547,183 31,422,817 32,643,552 33,864,287 35,085,022 36,305,7573% 4% 4% 3% 3%

State Aid 20,475,361 20,486,593 20,486,593 20,486,593 20,486,593 20,486,5930.1% 0.0% 0% 0% 0%

Interest 74,134 77,099 80,183 83,391 86,726 90,1954% 4% 4% 4% 4%

Other 3,226,532 3,279,469 3,345,058 3,411,959 3,480,198 3,549,8022% 2% 2% 2% 2%

132,350,765 138,037,518 141,590,646 145,222,457 148,917,812 152,685,913

ExpensesSalary/Benefits 109,303,733 106,280,240 109,320,809 112,452,735 115,678,915 119,002,344

-2.8% 2.8% 2.8% 2.8% 2.8%

Operating 24,750,656 25,572,030 25,827,750 26,086,028 26,346,888 26,610,3573% 1% 1% 1% 1%

Capital 6,053,337 6,923,029 7,926,317 8,695,450 11,121,684 11,092,68013% 13% 9% 22% 0%

140,107,726 138,775,299 143,074,877 147,234,213 153,147,487 156,705,381Estimated amount used 130,300,185 135,999,793 140,213,379 144,289,529 150,084,538 153,571,273Revenues over Expenses $ 2,050,580 $ 2,037,725 $ 1,377,267 $ 932,928 $ -1,166,726 $ -885,360

YE Capital Outlay Balance 3,665,199 6,308,862 9,082,430 11,978,224 15,008,395 18,176,504Reserve at 12/31 29,164,404 31,508,118 32,599,936 33,062,149 32,694,157 30,744,694Total Tuition and Fees - In County 88 91 94 97 100 103Percentage Usage 93% 98% 98% 98% 98% 98%

Estimated Actual

JCCC FIVE YEAR BUDGET PROJECTIONSTATEMENTS OF REVENUES AND EXPENSES - GENERAL/PTE FUNDS


Projected Budget

24

JCCC FIVE YEAR BUDGET PROJECTIONSCHEDULE OF UNENCUMBERED CASH RESERVES - GENERAL/PTE FUNDS


0

10,000,000

20,000,000

30,000,000

40,000,000

50,000,000

60,000,000

70,000,000

2014/15 2015/16 2016/17 2017/18 2018/19 2019/20

Unencumbered Cash and Estimated Cash Reserve

Beginning Unencumbered Cash Estimated Cash Reserve 12/31

25

ORG ORGANIZATION NAMESALARIES

& BENEFITSCURRENT

OPERATING CAPITALDEBT

SERVICE GRANTS TOTALSALARIES

& BENEFITSCURRENT


SERVICE GRANTS TOTAL%

CHANGE1101 Business Administration 767,249 4,799 - - - 772,048 789,120 5,000 - - - 794,120 2.9%1102 Journalism & Media Comm 309,113 8,717 3,500 - - 321,330 234,816 1,000 - - - 235,816 -26.6%1103 Fine Arts 532,013 15,500 7,900 - - 555,413 514,746 16,000 8,660 - - 539,406 -2.9%1104 English 3,466,165 24,070 - - - 3,490,235 3,226,321 28,900 - - - 3,255,221 -6.7%1105 Foreign Languages 873,419 3,000 - - - 876,419 774,247 3,000 - - - 777,247 -11.3%1106 Speech 970,528 3,650 - - - 974,178 976,969 3,850 - - - 980,819 0.7%1107 Debate - 1,843 - - - 1,843 - 1,800 - - - 1,800 -2.3%1108 Theater 269,327 34,875 - - - 304,202 257,510 34,800 - - - 292,310 -3.9%1109 Music 435,697 8,200 - - - 443,897 450,060 7,500 - - - 457,560 3.1%1110 Architecture 151,823 1,680 - - - 153,503 143,888 1,800 - - - 145,688 -5.1%1111 Mathematics 3,045,760 26,581 - - - 3,072,341 3,204,651 27,081 - - - 3,231,732 5.2%1112 Engineering 85,827 500 - - - 86,327 86,576 500 - - - 87,076 0.9%1113 Humanities 857,785 3,500 - - - 861,285 842,475 3,500 - - - 845,975 -1.8%1115 Sciences 3,687,224 135,658 19,650 - - 3,842,532 310,461 15,430 - - - 325,891 -91.5%1117 Health, Phys Ed & Rec 837,395 37,150 14,860 - - 889,405 810,103 32,000 4,140 - - 846,243 -4.9%1119 History 875,400 3,650 - - - 879,050 759,987 4,500 - - - 764,487 -13.0%1120 Political Science 244,057 1,500 - - - 245,557 237,133 1,910 - - - 239,043 -2.7%1121 Anthropology 245,651 4,300 - - - 249,951 248,028 4,000 - - - 252,028 0.8%1122 Psychology 805,748 3,000 - - - 808,748 767,286 3,000 - - - 770,286 -4.8%1123 Sociology 655,184 3,500 - - - 658,684 638,147 3,500 - - - 641,647 -2.6%1124 Internatl Archaeological Field Sch - 7,000 - - - 7,000 - 7,000 - - - 7,000 0.0%1125 Reading 528,491 3,000 - - - 531,491 432,067 2,200 - - - 434,267 -18.3%1126 Economics 644,970 2,800 - - - 647,770 694,856 2,600 - - - 697,456 7.7%1127 Human Sciences 752,587 4,300 600 - - 757,487 743,951 4,300 1,300 - - 749,551 -1.0%1128 Biology - - - - - - 1,495,354 56,500 27,300 - - 1,579,154 1129 Chemistry - - - - - - 1,230,321 40,000 - - - 1,270,321 1130 Geosciences - - - - - - 199,048 100 - - - 199,148 1131 Organismal Biology - - - - - - 16,483 3,000 - - - 19,483 1132 Physics - - - - - - 304,892 2,500 3,600 - - 310,992 1201 Fashion Merchandising & Design 368,333 8,858 - - - 377,191 354,643 7,900 - - - 362,543 -3.9%1202 Accounting 818,984 6,780 - - - 825,764 768,649 6,600 - - - 775,249 -6.1%1203 Marketing Management 202,359 1,335 - - - 203,694 239,839 2,350 - - - 242,189 18.9%1204 Business Office Technology 237,937 4,500 - - - 242,437 208,520 4,100 - - - 212,620 -12.3%1205 Hospitality Management 1,200,016 156,261 2,979 - - 1,359,256 1,149,325 192,850 - - - 1,342,175 -1.3%1206 Paralegal 403,679 3,570 - - - 407,249 281,118 2,800 - - - 283,918 -30.3%1207 Information Systems 739,363 1,775 - - - 741,138 817,542 1,775 - - - 819,317 10.5%1208 Graphic Design 523,317 20,975 - - - 544,292 518,151 17,200 - - - 535,351 -1.6%1209 Interactive Media 102,815 2,500 - - - 105,315 - - - - - - -100.0%1210 Automotive Technology 436,230 17,500 7,300 - - 461,030 376,018 17,500 - - - 393,518 -14.6%1211 Computer Drafting & Design 275,717 11,180 - - - 286,897 266,237 11,180 - - - 277,417 -3.3%1212 Electronics Technology 170,357 14,470 - - - 184,827 144,982 14,700 - - - 159,682 -13.6%1214 Fire Science 132,709 27,380 - - - 160,089 129,750 22,620 - - - 152,370 -4.8%1215 Admiistration. of Justice 223,928 1,635 - - - 225,563 233,763 1,300 - - - 235,063 4.2%1216 Police Academy 123,708 26,972 - - - 150,680 123,088 24,200 - - - 147,288 -2.3%

FY 2014-15 Budget


ORGANIZATION SUMMARY BY ACCOUNT CODE

FY 2015-16 Budget Proposed

GENERAL/PTE FUND

26


& BENEFITSCURRENT



& BENEFITSCURRENT



CHANGE

FY 2014-15 Budget




GENERAL/PTE FUND

1218 Dental Hygiene 477,284 53,850 - - - 531,134 464,241 49,600 - - - 513,841 -3.3%1219 Nursing 1,306,056 86,800 44,723 - - 1,437,579 1,187,251 87,300 - - - 1,274,551 -11.3%1220 Emergency Medical Science 659,629 74,781 - - - 734,410 672,462 89,500 - - - 761,962 3.8%1221 Dental Health on Wheels 80,818 4,100 - - - 84,918 79,219 4,400 - - - 83,619 -1.5%1223 Interior Merchandising & Design 313,809 15,680 - - - 329,489 300,012 15,750 - - - 315,762 -4.2%1224 Fine Art Photography 178,501 13,500 - - - 192,001 207,387 13,500 - - - 220,887 15.0%1225 HVAC 242,587 25,770 - - - 268,357 268,089 26,000 - - - 294,089 9.6%1226 Metal Fab (Welding) Technology 219,575 27,460 - - - 247,035 215,030 30,000 350 - - 245,380 -0.7%1229 Industrial Technology 91,896 700 - - - 92,596 96,696 700 - - - 97,396 5.2%1231 Personal Computer Applications 404,185 1,450 - - - 405,635 343,244 1,450 - - - 344,694 -15.0%1237 Desktop Publishing 164,758 750 - - - 165,508 174,546 750 - - - 175,296 5.9%1238 Polysomnography/Sleep Tech 83,379 6,025 - - - 89,404 82,337 5,900 35,000 - - 123,237 37.8%1241 Respiratory Care 189,285 74,338 2,300 - - 265,923 192,735 73,550 - - - 266,285 0.1%1243 Practical Nursing/Health Occup 833,367 66,625 - - - 899,992 775,856 58,750 2,000 - - 836,606 -7.0%1244 Cosmetology 578,715 59,877 - - - 638,592 549,527 67,649 720 - - 617,896 -3.2%1247 Entrepreneurship 153,246 1,600 - - - 154,846 132,289 1,120 - - - 133,409 -13.8%1253 Biotechnology 139,249 19,128 - - - 158,377 78,765 18,728 - - - 97,493 -38.4%1259 Web Applications 241,717 1,450 - - - 243,167 307,762 2,400 - - - 310,162 27.6%1262 Healthcare Information Systems - - - - - - 155,222 43,000 - - - 198,222 1263 Sustainable Agriculture 5,253 2,000 - - - 7,253 3,000 2,000 2,654 - - 7,654 5.5%1267 Medical Info Revenue Mgmt 78,607 1,000 - - - 79,607 133,128 900 - - - 134,028 68.4%1272 Vocational Capital Outlay - - 328,858 - - 328,858 - - 328,858 - - 328,858 0.0%1273 Technology Equipment Grant - - 38,962 - - 38,962 - - 38,962 - - 38,962 0.0%1274 Horticulture 195,269 14,428 - - - 209,697 134,147 14,428 - - - 148,575 -29.1%1275 Construction Management Tech 98,321 760 - - - 99,081 85,845 200 - - - 86,045 -13.2%1277 Railroad Industrial Technology 606,594 6,460 72,800 - - 685,854 824,966 7,300 84,915 - - 917,181 33.7%1278 Information Technology 490,742 20,103 - - - 510,845 535,408 16,335 - - - 551,743 8.0%1279 Electrical Technology 162,955 19,200 - - - 182,155 149,977 19,500 - - - 169,477 -7.0%1280 Education 207,478 7,565 - - - 215,043 195,347 9,350 - - - 204,697 -4.8%1281 Dir Career Pathways & Co-op Program 160,423 39,900 - - - 200,323 81,453 38,586 - - - 120,039 -40.1%1283 Railroad Mechanical Operations 530,086 2,317 - - - 532,403 411,305 2,317 - - - 413,622 -22.3%1286 NARS 42,637 1,212,243 - - - 1,254,880 42,637 1,409,560 - - - 1,452,197 15.7%1287 Game Development 159,088 1,453 - - - 160,541 178,568 1,453 - - - 180,021 12.1%1288 Animation 118,930 705 - - - 119,635 205,371 3,400 - - - 208,771 74.5%1289 Industrial Maintenance - 1,960 - - - 1,960 23,000 8,000 75,000 - - 106,000 5308.2%1291 Interpreting for Professions 31,500 - - - - 31,500 31,000 - - - - 31,000 -1.6%1404 Transportation-Continuing Ed 144,185 2,400 - - - 146,585 126,040 2,400 - - - 128,440 -12.4%1405 Professional Education 139,055 - - - - 139,055 107,199 - - - - 107,199 -22.9%1407 Business Workshops/Seminars - - - - - - 65,917 - - - - 65,917 1410 CC Programming - Box Office 109,432 - - - - 109,432 110,517 - - - - 110,517 1.0%1412 Health & Human Services 37,062 - - - - 37,062 68,313 - - - - 68,313 84.3%1419 Global English Institute 82,523 600 - - - 83,123 82,523 - - - - 82,523 -0.7%1420 Cont Ed & Comm Serv Event Managem 104,918 12,000 - - - 116,918 105,774 925 - - - 106,699 -8.7%1421 ABE/GED/ESL 193,068 9,500 - - - 202,568 194,009 9,500 - - - 203,509 0.5%

27


& BENEFITSCURRENT



& BENEFITSCURRENT



CHANGE

FY 2014-15 Budget




GENERAL/PTE FUND

1440 Supply Chain and Logistics 34,525 - - - - 34,525 16,380 - - - - 16,380 -52.6%1441 CC Sales and Marketing 139,978 - - - - 139,978 146,983 - - - - 146,983 5.0%1442 CC Operations 435,890 3,000 - - - 438,890 549,598 - - - - 549,598 25.2%1443 CC Art Education 84,547 - - - - 84,547 84,544 - - - - 84,544 0.0%1465 Marketing - - - - - - 103,149 - - - - 103,149 1477 Leadership and LSS (Lean Six Sigma) 65,917 - - - - 65,917 - - - - - - -100.0%1488 Sports Clinics 12,448 - - - - 12,448 12,444 - - - - 12,444 0.0%1492 JCAE Bridges - - - - - - 43,000 3,000 - - - 46,000 1501 Academic Achievement Center 289,294 2,635 - - - 291,929 311,675 2,685 - - - 314,360 7.7%1502 Math Resource Center 229,435 1,800 - - - 231,235 241,436 1,800 - - - 243,236 5.2%1503 College Now - 1,542,798 - - - 1,542,798 2,450 2,091,762 - - - 2,094,212 35.7%1504 Writing Center 337,155 2,108 - - - 339,263 351,042 1,500 - - - 352,542 3.9%1505 ASL English Interpreter Prep 400,450 5,569 - - - 406,019 368,172 8,700 - - - 376,872 -7.2%1506 Learning Strategies 119,494 2,600 - - - 122,094 120,548 2,650 - - - 123,198 0.9%1516 Anatomy Open Lab - - - - - - 31,832 - - - - 31,832 1517 Science Resource Center - - - - - - 124,087 1,000 - - - 125,087 3103 KSBDC 110,132 46,781 - - - 156,913 110,024 46,781 - - - 156,805 -0.1%3317 Community Based Learning 98,600 5,600 - - - 104,200 103,635 3,000 - - - 106,635 2.3%3321 Professional Recital Series 300 10,900 - - - 11,200 - 11,200 - - - 11,200 0.0%3342 Kansas Studies Institute - - - - - - 20,000 15,000 - - - 35,000 3348 American Indian Studies - 20,000 - - - 20,000 - 20,000 - - - 20,000 0.0%4101 Director of Library Services 104,203 4,481 - - - 108,684 104,203 3,850 - - - 108,053 -0.6%4102 Library 1,144,392 456,621 156,164 - - 1,757,177 1,030,442 466,724 151,357 - - 1,648,523 -6.2%4202 Nerman Museum 518,163 289,425 - - - 807,587 505,363 270,615 - - - 775,978 -3.9%4301 Publications 628,823 73,190 - - - 702,013 628,746 66,490 700 - - 695,936 -0.9%4302 Document Services 527,089 686,300 - - - 1,213,389 517,814 623,250 - - - 1,141,064 -6.0%4303 Administrative Photography 49,552 5,000 - - - 54,552 50,268 4,650 - - - 54,918 0.7%4305 Web Communications 291,430 4,150 - - - 295,580 246,548 3,675 - - - 250,223 -15.3%4311 Audio Visual Services 306,855 71,325 229,520 - - 607,700 306,761 42,275 197,680 - - 546,716 -10.0%4312 Video Services 775,497 56,900 24,000 - - 856,397 774,140 46,900 7,000 - - 828,040 -3.3%4313 Director Video Production & Service - 17,000 - - - 17,000 - 2,000 - - - 2,000 -88.2%4314 Educational Technology Center 401,565 29,100 - - - 430,665 394,698 29,100 19,867 - - 443,665 3.0%4315 Director, Educational Tech Center 133,761 2,800 - - - 136,561 133,761 2,500 - - - 136,261 -0.2%4321 College Information 519,396 823,946 - - - 1,343,342 342,491 806,845 39,998 - - 1,189,334 -11.5%4401 Academic Technology Services 2,717,844 432,546 - - - 3,150,390 2,556,781 393,190 - - - 2,949,971 -6.4%4408 Inst Information Technology Plans - 390,778 609,487 - - 1,000,264 - 250,264 750,000 - - 1,000,264 0.0%4601 VP Academic Affairs / CAO 567,153 47,350 - - - 614,503 422,954 51,300 - - - 474,254 -22.8%4602 Dean of Technology 215,448 31,000 - - - 246,448 290,235 31,000 - - - 321,235 30.3%4603 Dean, Curriculum & Academic Quality 53,479 3,000 - - - 56,479 54,129 3,000 - - - 57,129 1.2%4604 Dean of Business 225,872 3,532 - - - 229,404 222,422 6,250 - - - 228,672 -0.3%4605 Dean, Arts, Humanities&Soc Sciences 250,934 14,000 - - - 264,934 285,635 11,300 - - - 296,935 12.1%4606 Dean Health Care Profsns & Wellness 182,566 3,500 - - - 186,066 171,099 3,350 - - - 174,449 -6.2%4607 Physical Education & Athletic 216,400 16,925 28,903 - - 262,227 217,186 17,187 28,684 - - 263,057 0.3%4608 VP Continuing Education - 7,649 - - - 7,649 - 4,725 - - - 4,725 -38.2%

28


& BENEFITSCURRENT



& BENEFITSCURRENT



CHANGE

FY 2014-15 Budget




GENERAL/PTE FUND

4609 Dir., Continuing Education - 4,137 - - - 4,137 - 4,137 - - - 4,137 0.0%4610 Professor/Dean, Communications 186,684 13,822 - - - 200,506 208,714 13,700 - - - 222,414 10.9%4611 Staff Development 550,869 363,787 - - - 914,656 549,990 365,315 - - - 915,305 0.1%4613 Dean, Continuing Education 44,391 4,000 - - - 48,391 44,391 4,000 - - - 48,391 0.0%4614 Director RR Operations 95,776 6,877 - - - 102,653 95,354 11,270 - - - 106,624 3.9%4615 Artistic Director, Performing Arts 102,669 - - - - 102,669 102,662 - - - - 102,662 0.0%4616 Professor/Dean, English 67,864 4,600 - - - 72,464 51,765 4,000 - - - 55,765 -23.0%4619 Asst. Dean Industrial Technology 158,153 8,510 - - - 166,663 136,781 9,000 - - - 145,781 -12.5%4625 Asst. Dean Comp Sci/Info Tech 66,778 7,200 - - - 73,978 119,593 13,600 - - - 133,193 80.0%4627 Director Nursing 153,199 1,750 - - - 154,949 152,909 1,750 - - - 154,659 -0.2%4628 Director Dental Hygiene 137,538 1,250 - - - 138,788 123,945 1,750 - - - 125,695 -9.4%4629 Director, Emergency Med. Science 131,157 2,090 - - - 133,247 131,157 3,509 - - - 134,666 1.1%4630 Dean, Mathematics 111,897 1,365 - - - 113,262 116,711 2,865 - - - 119,576 5.6%4631 Dean Science 476,437 1,500 - - - 477,937 435,636 18,400 - - - 454,036 -5.0%4632 Director, Resp Therapy/Polysom Prog 130,382 1,800 - - - 132,182 130,382 2,050 - - - 132,432 0.2%4633 Assoc Vice President, Instruction 170,473 27,600 - - - 198,073 171,204 3,100 - - - 174,304 -12.0%4634 Assoc Prof/Director HPER 38,691 - - - - 38,691 38,691 - - - - 38,691 0.0%4635 Community Outreach - Credit Inst 184,324 8,490 - - - 192,814 177,223 29,258 - - - 206,481 7.1%4636 Director, LPN & Health Occupations 90,355 1,850 - - - 92,205 90,355 1,925 - - - 92,280 0.1%4637 Dean, Academic Support 188,937 25,750 - - - 214,687 180,026 25,750 - - - 205,776 -4.2%4638 Dir Operations, Cont Ed & Comm Serv 129,615 - - - - 129,615 129,615 - - - - 129,615 0.0%4639 Director, Distance Learning 94,863 12,500 - - - 107,363 94,863 11,000 - - - 105,863 -1.4%4640 Director, Accelerated Programs 31,365 12,000 - - - 43,365 - - - - - - -100.0%4642 Learner Engagement & Success 225,940 35,247 - - - 261,187 206,333 22,600 - - - 228,933 -12.3%4644 Grants Leadership & Development 219,273 8,700 - - - 227,973 214,081 18,457 - - - 232,538 2.0%4645 OHEC Building Manager 126,785 750 - - - 127,535 147,214 750 - - - 147,964 16.0%4646 Dean, Career & Tech Educ Transition - 4,000 - - - 4,000 108,666 2,850 - - - 111,516 2687.9%4710 Outcomes Assessment 125,016 15,700 - - - 140,716 125,021 27,770 - - - 152,791 8.6%4801 Developing Programs 47,186 103,750 - - - 150,936 3,000 203,700 - - - 206,700 36.9%5101 Student Success & Engagement 475,926 60,034 30,000 - - 565,960 270,842 101,677 5,750 - - 378,269 -33.2%5102 Student Services & Success 158,006 178,477 - - - 336,483 158,126 217,680 - - - 375,806 11.7%5103 Success Center 375,779 8,655 - - - 384,434 312,043 6,800 - - - 318,843 -17.1%5104 Admissions 710,761 30,701 - - - 741,462 718,343 32,500 3,900 - - 754,743 1.8%5105 Records 694,149 23,787 - - - 717,936 697,610 23,442 - - - 721,052 0.4%5106 International & Immigrant Stu Serv 264,567 9,993 - - - 274,560 262,718 10,187 - - - 272,905 -0.6%5111 Access Services 957,937 165,049 - - 34,313 1,157,299 974,821 54,900 2,250 - 104,000 1,135,971 -1.8%5112 CLEAR 157,929 5,381 - - - 163,310 163,660 6,241 - - - 169,901 4.0%5116 International Education 155,126 63,381 - - - 218,507 154,488 63,381 - - - 217,869 -0.3%5141 Model U.N. - 10,000 - - - 10,000 - 10,000 - - - 10,000 0.0%5201 Student Activities 208,609 4,805 - - - 213,414 327,199 2,450 - - - 329,649 54.5%5207 Athletics 946,706 185,667 5,845 - - 1,138,218 1,071,133 183,695 7,675 - - 1,262,503 10.9%5214 Honors 186,817 17,475 - - - 204,292 174,770 16,675 - - - 191,445 -6.3%5301 Career Development Center 440,776 37,130 - - - 477,906 432,783 16,100 2,250 - - 451,133 -5.6%5302 Testing & Assessment Services 421,184 82,930 - - - 504,114 438,331 80,060 106,950 - - 625,341 24.0%

29


& BENEFITSCURRENT



& BENEFITSCURRENT



CHANGE

FY 2014-15 Budget




GENERAL/PTE FUND

5303 Counseling 2,249,342 49,063 9,750 - - 2,308,155 2,177,801 33,215 5,500 - - 2,216,516 -4.0%5401 Student Financial Aid 1,039,584 46,737 - - 129,000 1,215,321 1,074,173 47,000 - - 133,000 1,254,173 3.2%6101 Board of Trustees Office - 399,838 - - - 399,838 - 215,358 - - - 215,358 -46.1%6102 Presidents Office 1,041,790 557,566 - - - 1,599,356 2,546,288 270,000 - - - 2,816,288 76.1%6104 Exec VP, Finance and Admin Services 224,104 109,681 - - - 333,784 223,247 196,561 - - - 419,808 25.8%6108 General Counsel 281,942 295,808 - - - 577,750 282,302 240,700 - - - 523,002 -9.5%6109 College Operations & Continuing Edu 201,313 99,231 - - - 300,544 182,313 355,900 - - - 538,213 79.1%6111 Institutional Research 228,921 53,190 - - - 282,111 289,105 57,240 - - - 346,345 22.8%6115 Archivist 30,444 7,080 - - - 37,524 30,444 5,000 - - - 35,444 -5.5%6118 Institutional Effectiveness 120,554 43,500 - - - 164,054 122,847 34,150 - - - 156,997 -4.3%6120 Strategic Plan Initiatives - - - - - - - 621,000 - - - 621,000 6201 Financial Services 277,669 649,169 - - - 926,838 291,676 659,200 - - - 950,876 2.6%6203 Employee Benefits 28,592,689 430,000 - - - 29,022,689 26,215,000 370,000 - - - 26,585,000 -8.4%6204 Accounting Services 417,223 17,700 - - - 434,923 389,161 15,200 - - - 404,361 -7.0%6205 Audit and Advisory Services 271,989 79,275 - - - 351,264 262,130 128,260 - - - 390,390 11.1%6206 Bursar Operations 516,887 740,920 26,500 - - 1,284,307 492,642 696,150 - - - 1,188,792 -7.4%6210 Accounts Payable 215,714 6,900 - - - 222,614 214,492 7,550 - - - 222,042 -0.3%6222 Budget Reallocation Pool 719,490 - - - - 719,490 460,497 - - - - 460,497 -36.0%6302 Human Resources 809,363 300,823 - - - 1,110,186 792,561 272,450 - - - 1,065,011 -4.1%6303 Wellness 12,056 5,000 - - - 17,056 14,400 5,000 - - - 19,400 13.7%6311 Cont Ed & Comm Serv Scheduling 37,208 - - - - 37,208 37,208 - - - - 37,208 0.0%6320 Exec Director Sustainability 78,661 58,800 - - - 137,461 89,701 48,100 - - - 137,801 0.2%6321 Chief, Police Department 1,659,601 105,600 - - - 1,765,201 1,632,161 86,500 21,618 - - 1,740,279 -1.4%6322 Environmental Services - 36,574 - - - 36,574 - 27,850 - - - 27,850 -23.9%6323 Bloodborne Pathogen Control - 33,400 - - - 33,400 - 33,400 - - - 33,400 0.0%6324 Insurance and Risk Management 352,710 588,301 - - - 941,011 188,061 555,516 - - - 743,577 -21.0%6325 Security Access Control Systems 129,895 18,275 - - - 148,170 133,295 25,791 18,900 - - 177,986 20.1%6329 College Emergency Response Plan - 18,000 - - - 18,000 - 18,000 - - - 18,000 0.0%6331 Procurement Services 481,208 22,830 - - - 504,038 470,166 19,460 - - - 489,626 -2.9%6332 Maintenance Pool - 749,400 - - - 749,400 - 650,000 - - - 650,000 -13.3%6333 Equipment Replacement Pool - - - - - - - - 1,016,676 - - 1,016,676 6334 Warehouse / Receiving 158,511 9,335 - - - 167,846 151,105 3,850 - - - 154,955 -7.7%6341 Transportation 75,303 151,233 400 - - 226,936 73,598 155,647 - - - 229,245 1.0%6352 Postal Services 129,465 525,150 - - - 654,615 125,583 437,750 - - - 563,333 -13.9%6356 Emergency Preparedness 97,363 35,118 4,380 - - 136,861 91,704 13,211 4,050 - - 108,965 -20.4%6358 Enterprise Risk Management - 7,500 - - - 7,500 - - - - - - -100.0%6359 Assoc. VP, Business Services 62,536 6,700 - - - 69,236 62,416 6,000 - - - 68,416 -1.2%6401 Dir., Admin. Computer Services 2,698,860 2,971,232 - - - 5,670,092 2,494,790 2,893,190 135,845 - - 5,523,825 -2.6%6403 Chief Information Officer 190,692 110,240 - - - 300,932 178,274 79,750 - - - 258,024 -14.3%6404 Admin Information Technology Plans - 329,044 219,595 - - 548,639 - 322,050 222,195 - - 544,245 -0.8%6405 Dir., Client Support Services 1,187,223 135,935 - - - 1,323,158 1,176,361 116,790 - - - 1,293,151 -2.3%6531 Institutional Advancement 456,775 55,675 - - - 512,450 395,562 44,925 - - - 440,487 -14.0%6706 Cont Ed & Comm Serv Registration 124,170 - - - - 124,170 124,175 - - - - 124,175 0.0%7101 Dir., Facility Planning - 57,350 - - - 57,350 - - - - - - -100.0%

30


& BENEFITSCURRENT



& BENEFITSCURRENT



CHANGE

FY 2014-15 Budget




GENERAL/PTE FUND

7102 Dir., Campus Services 245,004 646,138 1,722,500 - - 2,613,642 245,361 617,403 1,251,000 - - 2,113,764 -19.1%7201 Maintenance 1,237,355 401,993 - - - 1,639,348 1,196,182 408,694 16,280 - - 1,621,156 -1.1%7202 Interior Services - 35,160 354,488 - - 389,648 - 29,100 555,693 - - 584,793 50.1%7301 Housekeeping Services 2,395,916 1,021,656 29,442 - - 3,447,014 2,189,397 1,094,490 14,000 - - 3,297,887 -4.3%7401 Utilities - 3,241,731 - - - 3,241,731 - 3,248,000 - - - 3,248,000 0.2%7501 Grounds 425,995 109,754 2,000 - - 537,749 406,779 88,510 11,150 - - 506,439 -5.8%7714 ADA Campus Modifications - - - - - - - 22,610 5,890 - - 28,500 7745 Information Technlgy Infrastructure - - 1,042,611 - - 1,042,611 - 300,000 716,229 - - 1,016,229 -2.5%7820 Series 09 COP P&I (OHEC) - - - 846,685 - 846,685 - - - 825,500 - 825,500 -2.5%7821 PEI Infrastructure Fin - Principal - - - 166,636 - 166,636 - - - 164,983 - 164,983 -1.0%9104 Child Development Center 341,682 - - - - 341,682 338,222 - - - - 338,222 -1.0%9113 Dental Hygiene Products for Resale - - - - - - - 150 - - - 150

TOTAL 109,303,733 24,587,343 5,040,016 1,013,321 163,313 140,107,726 106,280,240 25,335,030 5,932,546 990,483 237,000 138,775,298 -1.0%

31

ACCOUNTCODE

FY 2014-15BUDGET

FY 2015-16BUDGET

PROPOSEDINCREASE/

<DECREASE>%

CHANGE

SALARIES & BENEFITSFT Reg. AMS 52010 12,169,015 12,137,322 -31,693 -0.3%FT Reg. AMT 52015 5,174,881 5,107,197 -67,684 -1.3%FT Reg. Faculty 52020 25,355,925 24,571,295 -784,630 -3.1%FT Reg. Office & Technical 52030 6,190,318 5,955,720 -234,598 -3.8%FT Reg. HT 52035 1,528,186 1,579,071 50,884 3.3%FT Reg. Maintenance & Service 52040 4,360,203 4,137,705 -222,498 -5.1%FT Temp. AMS 52050 156,188 182,745 26,556 17.0%FT Temp. Faculty 52060 418,531 501,913 83,382 19.9%FT Temp. Office & Technical 52070 26,204 26,096 -108 -0.4%Vacation Adjustment Expense 52090 400,000 400,000 - 0.0%Early Retirement Expense 52091 200,000 200,000 - 0.0%PT Credit Instruction 52110 12,158,773 11,679,948 -478,825 -3.9%PT Noncredit Instruction 52130 55,952 91,415 35,463 63.4%Overload Credit Instruction 52140 1,567,914 1,581,505 13,591 0.9%Substitute Pay 52141 179,453 160,297 -19,156 -10.7%PT Reg. Non-Instruction 52150 5,952,877 5,804,005 -148,872 -2.5%PT Reg. Salaried Faculty 52151 133,148 91,466 -41,682 -31.3%PT Reg. Technical 52155 758,503 674,241 -84,262 -11.1%PT Temp. Non-Instruction 52160 1,837,341 2,084,145 246,805 13.4%PT Temp. Non-Instructional Salaried 52161 481,631 205,600 -276,031 -57.3%Temporary Office Aides 52170 33,671 12,830 -20,841 -61.9%Overtime 52180 532,557 510,837 -21,720 -4.1%Overtime Charge-backs 52181 - -25,000 -25,000Consultants, JCCC Employees 52190 466,247 583,386 117,139 25.1%College Work Study 52210 15,000 68,000 53,000 353.3%AMS Spotlight Awards 52310 10,500 10,500 - 0.0%Distinguished Status, Faculty 52320 50,000 50,000 - 0.0%EXCEL Awards 52330 10,500 10,500 - 0.0%Tuition Reimb (non-JCCC courses) 52340 60,000 - -60,000 -100.0%Severance Pay 52350 50,000 130,000 80,000 160.0%IRS Listed Property Stipend 52410 72,960 78,855 5,895 8.1%Sabbatical Replacement Pool 52680 136,000 160,000 24,000 17.6%Salaries Contingency 52690 628,051 1,947,780 1,319,728 210.1%Medicare/OASDI Employer 52910 7,400,000 6,800,000 -600,000 -8.1%KPERS Employer 52915 80,000 50,000 -30,000 -37.5%Medical/Dental Insurance 52920 10,802,689 11,300,000 497,311 4.6%OPEB Costs 52925 450,000 -400,000 -850,000 -188.9%Life Insurance 52930 600,000 500,000 -100,000 -16.7%Health and Wellness 52935 300,000 - -300,000 -100.0%Tax Sheltered Annuity 52940 4,300,000 4,100,000 -200,000 -4.7%Worker's Compensation 52950 250,516 85,867 -164,649 -65.7%Unemployment Compensation 52960 150,000 150,000 - 0.0%Flex Plan Cash Out Option 52971 5,000,000 4,200,000 -800,000 -16.0%Other Employee Benefits 52975 100,000 85,000 -15,000 -15.0%Employee Ben Redistribution 52998 -1,300,000 -1,300,000 - 0.0%

Subtotal 109,303,733 106,280,240 -3,023,494 -2.8%

FY 2015-16 BUDGET

ACCOUNT CODE SUMMARYGENERAL/PTE FUND

JOHNSON COUNTY COMMUNITY COLLEGE

32

ACCOUNTCODE

FY 2014-15BUDGET

FY 2015-16BUDGET

PROPOSEDINCREASE/

<DECREASE>%

CHANGE

FY 2015-16 BUDGET



CURRENT OPERATINGConsultants 53010 443,273 331,909 -111,364 -25.1%Event Officials 53020 53,166 50,777 -2,389 -4.5%Legal Services 53030 267,808 225,000 -42,808 -16.0%Lobbyist Services 53035 75,270 28,258 -47,012 -62.5%Audit Services 53040 102,805 68,160 -34,645 -33.7%Collection Costs 53045 105,000 105,000 - 0.0%Insurance, Property/Casualty & Rel 53050 573,224 542,302 -30,922 -5.4%Other Contracted Services 53060 6,882,399 7,975,194 1,092,795 15.9%SB 155 Shared Funding Payments 53065 - 518,000 518,000Overnight Travel 53110 752,621 727,046 -25,574 -3.4%Lobbyist Travel & Other 53115 8,600 8,600 - 0.0%Travel - AQIP 53116 5,000 4,900 -100 -2.0%Staff Development Travel 53120 567,557 261,000 -306,557 -54.0%Faculty Continuing Ed Grants 53121 15,000 15,000 - 0.0%Tuition Reimbursement 53122 - 350,000 350,000Same Day Travel 53130 142,273 120,012 -22,261 -15.6%Supplies and Materials 53150 3,549,926 3,036,263 -513,663 -14.5%Micro-Computer Software 53160 944,563 686,384 -258,178 -27.3%Computer Software Licenses 53161 1,885,471 2,066,480 181,009 9.6%Technical Training Travel 53170 132,623 116,950 -15,673 -11.8%Recruiting Travel 53190 55,211 47,666 -7,545 -13.7%Printing, Binding & Publications 53210 113,050 104,342 -8,708 -7.7%Advertising and Promotions 53220 785,033 741,000 -44,033 -5.6%Memberships 53230 250,512 334,054 83,542 33.3%Accreditation Expenses 53231 54,935 51,511 -3,424 -6.2%Bad Debt Expense 53270 525,000 570,000 45,000 8.6%Electric 53310 2,970,000 3,050,000 80,000 2.7%Water 53320 236,731 165,000 -71,731 -30.3%Natural Gas 53330 35,000 33,000 -2,000 -5.7%Telephone 53340 312,505 278,836 -33,669 -10.8%Gasoline 53350 94,774 96,651 1,877 2.0%Subscriptions-Continuing 53420 55,000 15,000 -40,000 -72.7%Rentals and Leases 53610 953,414 990,273 36,859 3.9%Repairs 53620 246,388 222,268 -24,120 -9.8%Freight 53630 131,194 110,100 -21,094 -16.1%Special Events 53640 275,518 289,893 14,375 5.2%Retirement Recognitions 53641 10,000 6,000 -4,000 -40.0%Postage 53650 472,000 390,000 -82,000 -17.4%Contingency 53690 504,500 600,000 95,500 18.9%Income Tax 55610 - 2,200 2,200

Subtotal 24,587,343 25,335,030 747,687 3.0%

33

ACCOUNTCODE

FY 2014-15BUDGET

FY 2015-16BUDGET

PROPOSEDINCREASE/

<DECREASE>%

CHANGE

FY 2015-16 BUDGET



CAPITALSystems Furniture 54010 2,300 - -2,300 -100.0%Remodeling and Renovations 54020 1,270,000 1,902,979 632,979 49.8%Non-Capital Furniture & Equipment 54030 2,010,841 2,332,534 321,693 16.0%Library Books 54040 88,033 89,354 1,321 1.5%Furniture and Equipment 54050 1,150,711 1,545,676 394,965 34.3%Audio Visual Holdings 54060 10,000 3,000 -7,000 -70.0%Library Books-Continuing 54070 58,131 59,003 872 1.5%Building Improvements 54080 450,000 - -450,000 -100.0%

Subtotal 5,040,016 5,932,546 892,530 17.7%

DEBT SERVICEPrincipal Payments 57810 651,673 681,673 30,000 4.6%Interest Payments 57820 354,185 303,000 -51,185 -14.5%Fee Payments 57830 7,463 5,810 -1,653 -22.1%

Subtotal 1,013,321 990,483 -22,838 -2.3%

GRANTSGrants 56010 34,313 104,000 69,687 203.1%Foster Care & Killed on Duty Grant 56018 60,000 70,000 10,000 16.7%Federal SEOG Match 56032 69,000 63,000 -6,000 -8.7%

Subtotal 163,313 237,000 73,687 45.1%

TOTAL 140,107,726 138,775,298 -1,332,428 -1.0%

34

FY 2014-15 BUDGET

FY 2015-16BUDGET

PROPOSED

REVENUEAdValorem Tax $ 4,353,256 $ 4,642,663Investment Income 1,000 1,000

Total Revenue 4,354,256 4,643,663

EXPENSES4321 College Information 20,000 -6333 Equipment Replacement Pool 711,050 -6401 Dir., Admin. Computer Services 285,000 -7102 Dir., Campus Services 989,900 1,750,0007202 Interior Services 220,540 -7714 ADA Campus Modifications 28,500 -7821 PEI Infrastructure Fin - Principal 250,000 250,000

Total Expenses 2,504,990 2,000,000

Projected Usage 100% 100%

Revenue Over <Under> Expense 1,849,266 2,643,663

Beginning Unencumbered Cash Balance 1,815,933 Adjusted 3,665,199

Ending Unencumbered Cash Balance $ 3,665,199 $ 6,308,862


CAPITAL OUTLAY FUNDORGANIZATION SUMMARY

35

FY 2014-15 BUDGET

FY 2015-16BUDGET

PROPOSED

REVENUETuition and Fees $ 5,648,093 $ 4,219,069Other Income 1,920,716 1,405,000Investment Income 3,152 3,278

Total Revenue 7,571,961 5,627,347

EXPENSES1403 Community Education 20,379 20,3791404 Transportation-Continuing Ed 101,645 91,1631405 Professional Education 359,480 196,9721406 Youth Programs 128,506 124,2001407 Business Workshops/Seminars 415,990 398,4641409 Microcomputer Training 1,184,215 1,066,7791410 CC Programming - Box Office 66,400 61,5001412 Health & Human Services 421,769 304,8481413 Personal Enrichment 147,887 158,0001414 ASE Developing Programs 131,956 685,6701415 Public Safety Training 87,864 66,0001416 Continuing Education 112,297 108,6901417 Special Events 32,706 14,3501439 CE - NARS 507,000 682,9451440 Supply Chain and Logistics 249,352 296,7061441 CC Sales and Marketing 1,181,906 1,215,9451442 CC Operations 60,660 118,6091443 CC Art Education 92,710 90,1701465 Marketing 582,661 418,1091477 Leadership and LSS (Lean Six Sigma) 281,148 21,3891486 Cosponsored Events 4,082 7,2821487 Community Career Services 14,591 -1488 Sports Clinics 349,449 154,1001489 Visual Art Education 14,471 10,9424612 AVP Continuing Education 206,703 154,9474613 Dean, Continuing Education 132,959 129,7594638 Dir Operations, Cont Ed & Comm Serv 38,043 24,2004707 Benchmarking/Market Research 367,200 367,5666311 Cont Ed & Comm Serv Scheduling 45,015 44,0156706 Cont Ed & Comm Serv Registration 19,169 17,9146707 Cont Ed & Comm Serv Marketing 210,000 195,000

Total Expenses 7,568,212 7,246,613


Revenue Over <Under> Expense 2,624 192,387



ADULT SUPPLEMENTARY EDUCATION FUNDORGANIZATION SUMMARY


36

ACCOUNTCODE

FY 2014-15BUDGET

FY 2015-16BUDGET

PROPOSED

INCREASE/<DECREASE>

%CHANGE

SALARIES & BENEFITSFT Reg. AMS 52010 1,116,925 1,116,926 1 0.0%FT Reg. Office & Technical 52030 362,698 287,591 -75,107 -20.7%PT Noncredit Instruction 52130 1,389,775 1,237,451 -152,324 -11.0%PT Reg. Non-Instruction 52150 134,503 132,621 -1,882 -1.4%PT Temp. Non-Instruction 52160 187,651 99,521 -88,130 -47.0%PT Temp. Non-Instructional Salaried 52161 5,374 4,329 -1,045 -19.4%Temporary Office Aides 52170 12,449 6,028 -6,421 -51.6%Overtime 52180 1,903 1,900 -3 -0.2%Consultants, JCCC Employees 52190 1,500 - -1,500 -100.0%IRS Listed Property Stipend 52410 8,996 10,139 1,143 12.7%

Subtotal 3,221,775 2,896,506 -325,269 -10.1%

CURRENT OPERATINGConsultants 53010 783,855 740,126 -43,729 -5.6%Other Contracted Services 53060 1,481,690 1,756,572 274,882 18.6%Overnight Travel 53110 93,163 104,825 11,662 12.5%Same Day Travel 53130 22,630 19,105 -3,525 -15.6%Supplies and Materials 53150 648,098 581,080 -67,018 -10.3%Micro-Computer Software 53160 34,102 8,903 -25,199 -73.9%Printing, Binding & Publications 53210 585,906 468,488 -117,418 -20.0%Advertising and Promotions 53220 283,650 297,000 13,350 4.7%Memberships 53230 31,233 38,796 7,563 24.2%Bad Debt Expense 53270 5,000 5,000 - 0.0%Rentals and Leases 53610 28,000 43,000 15,000 53.6%Repairs 53620 5,000 5,300 300 6.0%Special Events 53640 150,441 105,136 -45,305 -30.1%Postage 53650 126,669 68,976 -57,693 -45.5%Income Tax 55610 6,000 2,000 -4,000 -66.7%

Subtotal 4,285,437 4,244,307 -41,130 -1.0%

CAPITALNon-Capital Furniture & Equipment 54030 61,000 105,800 44,800 73.4%

Subtotal 61,000 105,800 44,800 73.4%

TOTAL 7,568,212 7,246,613 -321,599 -4.2%


ACCOUNT CODE SUMMARYADULT SUPPLEMENTARY EDUCATION FUND

37

FY 2014-15 BUDGET

FY 2015-16BUDGET

PROPOSED

REVENUETuition and Fees $ 124,964 $ 162,839Other Income 28,004 28,463Investment Income 210

Total Revenue 153,178 191,302

EXPENSES1404 Transportation-Continuing Ed 83,191 84,802

Total Expenses 83,191 84,802



Beginning Unencumbered Cash Balance 304,826 Adjusted 369,214

Ending Unencumbered Cash Balance $ 369,214 $ 482,498


MOTORCYCLE DRIVER SAFETY FUNDORGANIZATION SUMMARY

38

ACCOUNTCODE

FY 2014-15BUDGET

FY 2015-16BUDGET

PROPOSED

INCREASE/<DECREASE>

%CHANGE

SALARIES & BENEFITSPT Noncredit Instruction 52130 46,968 57,602 10,634 22.6%PT Temp. Non-Instruction 52160 7,823 - -7,823 -100.0%Consultants, JCCC Employees 52190 500 - -500 -100.0%

Subtotal 55,290 57,602 2,312 4.2%

CURRENT OPERATINGConsultants 53010 - 500 500Same Day Travel 53130 200 - -200 -100.0%Supplies and Materials 53150 5,000 5,000 - 0.0%Printing, Binding & Publications 53210 2,500 2,500 - 0.0%Repairs 53620 8,000 8,000 - 0.0%Special Events 53640 400 400 - 0.0%

Subtotal 16,100 16,400 300 1.9%

CAPITALNon-Capital Furniture & Equipment 54030 11,800 10,800 -1,000 -8.5%

Subtotal 11,800 10,800 -1,000 -8.5%

TOTAL 83,190 84,802 1,612 1.9%


MOTORCYCLE DRIVER SAFETY FUNDACCOUNT CODE SUMMARY

39

FY 2014-15 BUDGET

FY 2015-16BUDGET

PROPOSED

REVENUETuition and Fees $ 964,988 $ 868,200

Total Revenue 964,988 868,200

EXPENSES1404 Transportation-Continuing Ed 873,970 868,200

Total Expenses 873,970 868,200






TRUCK DRIVER TRAINING FUNDORGANIZATION SUMMARY

40

ACCOUNTCODE

FY 2014-15BUDGET

FY 2015-16BUDGET

PROPOSED

INCREASE/<DECREASE>

%CHANGE

CURRENT OPERATINGOther Contracted Services 53060 839,970 840,000 30 0.0%Overnight Travel 53110 2,000 1,000 -1,000 -50.0%Same Day Travel 53130 500 200 -300 -60.0%Supplies and Materials 53150 25,000 25,000 - 0.0%Printing, Binding & Publications 53210 5,000 1,000 -4,000 -80.0%Special Events 53640 1,500 1,000 -500 -33.3%

Subtotal 873,970 868,200 -5,770 -0.7%

TOTAL 873,970 868,200 -5,770 -0.7%


TRUCK DRIVER TRAINING FUNDACCOUNT CODE SUMMARY

41

FY 2014-15 BUDGET

FY 2015-16BUDGET

PROPOSED

REVENUE1205 Hospitality Management $ 3,000 $ 5,000 4304 Printing 350,000 325,000 9101 Dining Services 2,470,000 2,470,000 9102 Vending 435,000 501,000 9103 Bookstore 9,323,000 7,607,200 9104 Child Development Center 742,235 782,867 9105 Auto Technology Project 10,200 2,500 9109 Concessions & Special Events 10,000 10,000 9110 Cosmetology Products for Resale 55,500 40,000 9112 Espresso Bars 645,000 645,000 9113 Dental Hygiene Products for Resale 3,000 3,000 9114 Pastry/Baking Store 45,000 45,000 9116 HVAC Auxiliary Account 3,225 2,500 9117 Museum Cafe 250,000 260,000 9118 Campus Farm 9,000 6,000 9119 Radio Bach 48,000 -

Total Revenue 14,402,160 12,705,067

EXPENSES1103 Fine Arts 3,000 - 1205 Hospitality Management 5,000 - 4304 Printing 342,655 313,596 6203 Employee Benefits 1,300,000 1,300,000 7102 Dir., Campus Services 12,000 448,600 7821 PEI Infrastructure Fin - Principal 250,000 250,000 9101 Dining Services 2,484,767 2,486,516 9102 Vending 446,256 430,853 9103 Bookstore 7,767,791 5,923,797 9104 Child Development Center 1,119,788 1,110,976 9105 Auto Technology Project 10,200 2,000 9109 Concessions & Special Events 10,000 10,000 9110 Cosmetology Products for Resale 55,500 36,097 9112 Espresso Bars 593,489 555,579 9113 Dental Hygiene Products for Resale 4,000 1,280 9114 Pastry/Baking Store 45,100 45,000 9116 HVAC Auxiliary Account 3,225 1,000 9117 Museum Cafe 229,887 223,372 9118 Campus Farm 9,000 5,400 9119 Radio Bach 48,000 - 9150 Auxiliary Services 144,496 131,196 9151 Auxiliary Construction 65,000 50,000

Total Expenses 14,949,155 13,325,262


Revenue Over <Under> Expense -492,296 -353,690




AUXILIARY ENTERPRISE FUNDORGANIZATION SUMMARY

42

ACCOUNTCODE

FY 2014-15BUDGET

FY 2015-16BUDGET

PROPOSED

INCREASE/<DECREASE>

%CHANGE

COST OF SALESCost of Sales-Fruit/Vegetables 51520 100,000 100,000 - 0.0%Cost of Sales-Beverage 51530 81,000 90,000 9,000 11.1%Cost of Sales-Other Groceries 51540 645,000 600,000 -45,000 -7.0%Cost of Sales-Dairy 51550 110,000 110,000 - 0.0%Cost of Sales-Bakery 51560 21,000 17,000 -4,000 -19.0%Cost of Sales-Cold Beverage 51650 4,000 7,000 3,000 75.0%Cost of Sales-New Books 51710 4,000,000 3,500,000 -500,000 -12.5%Cost of Sales-Trade Books 51730 25,000 12,000 -13,000 -52.0%Cost of Sales-Class 51740 475,000 300,000 -175,000 -36.8%Cost of Sales-Soft Goods 51750 200,000 100,000 -100,000 -50.0%Cost of Sales-Miscellaneous 51760 200,000 150,000 -50,000 -25.0%Cost of Sales-Electronics 51770 700,000 500,000 -200,000 -28.6%Cost of Sales-Software 51780 50,000 20,000 -30,000 -60.0%Cost of Sales-Cards & Gifts 51790 35,000 15,000 -20,000 -57.1%Cost of Sales-Cosmetology Products 51810 45,000 28,597 -16,403 -36.5%Cost of Sales-Dental Hygiene Prod 51812 3,000 1,280 -1,720 -57.3%Cost of Sales-Food 51910 205,000 210,000 5,000 2.4%Cost of Sales-Hot Beverage 51920 132,000 132,000 - 0.0%Cost of Sales-Cold Beverage 51930 190,000 170,000 -20,000 -10.5%Cost of Sales-Miscellaneous 51940 3,500 1,000 -2,500 -71.4%

Subtotal 7,224,500 6,063,877 -1,160,623 -16.1%

SALARIES & BENEFITSFT Reg. AMS 52010 524,821 514,803 -10,018 -1.9%FT Reg. Office & Technical 52030 1,114,366 1,114,365 -1 0.0%FT Reg. Maintenance & Service 52040 972,361 972,611 250 0.0%PT Reg. Non-Instruction 52150 1,033,537 996,532 -37,005 -3.6%PT Temp. Non-Instruction 52160 377,879 310,000 -67,879 -18.0%Temporary Office Aides 52170 500 - -500 -100.0%Overtime 52180 93,000 70,500 -22,500 -24.2%Overtime Charge-backs 52181 - 8,000 8,000IRS Listed Property Stipend 52410 3,300 1,880 -1,420 -43.0%Employee Ben Redistribution 52998 1,300,000 1,300,000 - 0.0%

Subtotal 5,419,763 5,288,691 -131,072 -2.4%

CURRENT OPERATINGOther Contracted Services 53060 195,775 232,500 36,725 18.8%Overnight Travel 53110 18,124 29,124 11,000 60.7%Staff Development Travel 53120 1,000 1,000 - 0.0%Same Day Travel 53130 4,955 3,600 -1,355 -27.3%Supplies and Materials 53150 369,604 335,000 -34,604 -9.4%Micro-Computer Software 53160 22,000 12,000 -10,000 -45.5%Computer Software Licenses 53161 2,630 2,630 - 0.0%Printing, Binding & Publications 53210 12,400 16,200 3,800 30.6%Advertising and Promotions 53220 5,500 7,000 1,500 27.3%Memberships 53230 8,372 7,022 -1,350 -16.1%


AUXILIARY ENTERPRISE FUNDACCOUNT CODE SUMMARY

43

ACCOUNTCODE

FY 2014-15BUDGET

FY 2015-16BUDGET

PROPOSED

INCREASE/<DECREASE>

%CHANGE


AUXILIARY ENTERPRISE FUNDACCOUNT CODE SUMMARY

Accreditation Expenses 53231 400 700 300 75.0%Bad Debt Expense 53270 25,000 56,500 31,500 126.0%Rentals and Leases 53610 37,000 34,500 -2,500 -6.8%Repairs 53620 375,932 350,400 -25,532 -6.8%Special Events 53640 8,900 8,800 -100 -1.1%Other Tax Assessments 55510 1,850 1,440 -410 -22.2%Income Tax 55610 4,500 1,500 -3,000 -66.7%

Subtotal 1,093,942 1,099,916 5,974 0.5%

CAPITALRemodeling and Renovations 54020 15,000 - -15,000 -100.0%Non-Capital Furniture & Equipment 54030 48,649 66,510 17,861 36.7%Rental Textbooks 54045 800,000 - -800,000 -100.0%Furniture and Equipment 54050 32,300 57,668 25,368 78.5%Art Acquisitions 54065 28,000 25,000 -3,000 -10.7%Building Improvements 54080 12,000 448,600 436,600 3638.3%Land Improvements 54090 25,000 25,000 - 0.0%

Subtotal 960,949 622,778 -338,171 -35.2%

DEBT SERVICEPrincipal Payments 57810 250,000 250,000 - 0.0%

Subtotal 250,000 250,000 - 0.0%

TOTAL 14,949,155 13,325,262 -1,623,893 -10.9%

44

FY 2014-15 BUDGET

FY 2015-16BUDGET

PROPOSED

REVENUEStudent Activities Fees $ 2,398,494 $ 2,371,201Other Income 95,564 97,132Investment Income 315 328

Total Revenue 2,494,373 2,468,661

EXPENSES5201 Student Activities 263,136 276,2895202 Campus Ledger 190,083 155,7295204 Student Life 516,709 475,6975205 Graduation 49,000 40,8905206 Intramurals 8,500 6,5005209 Center for Student Involvement 290,737 275,5835210 Student Senate 40,000 40,0005211 Cheerleaders 42,489 51,3885215 Phi Theta Kappa 7,275 6,8965216 Leadership Institute 18,575 12,9805217 Vocal Ensemble Showcase 18,730 11,1805701 Health Services 25,000 25,0008107 Student Activity Grants Account 1,442,020 1,424,348

Total Expenses 2,912,254 2,802,480


Revenue Over <Under> Expense 18,957 -53,571




STUDENT ACTIVITY FUNDORGANIZATION SUMMARY

45

ACCOUNTCODE

FY 2014-15BUDGET

FY 2015-16BUDGET

PROPOSED

INCREASE/<DECREASE>

%CHANGE

SALARIES & BENEFITSFT Reg. AMS 52010 142,089 142,089 - 0.0%FT Reg. Office & Technical 52030 39,296 39,296 - 0.0%PT Reg. Non-Instruction 52150 300,188 282,420 -17,768 -5.9%PT Temp. Non-Instruction 52160 4,701 1,500 -3,201 -68.1%PT Temp. Non-Instructional Salaried 52161 113,357 95,000 -18,357 -16.2%Consultants, JCCC Employees 52190 3,080 3,080 - 0.0%

Subtotal 602,711 563,385 -39,326 -6.5%

CURRENT OPERATINGConsultants 53010 9,830 9,171 -659 -6.7%Event Officials 53020 9,727 4,500 -5,227 -53.7%Other Contracted Services 53060 66,967 51,000 -15,967 -23.8%Overnight Travel 53110 18,004 9,032 -8,972 -49.8%Same Day Travel 53130 3,700 3,100 -600 -16.2%Team Travel 53140 493,301 479,023 -14,278 -2.9%Supplies and Materials 53150 91,172 74,630 -16,542 -18.1%Micro-Computer Software 53160 4,411 7,500 3,089 70.0%Recruiting Travel 53190 3,450 2,500 -950 -27.5%Printing, Binding & Publications 53210 27,113 22,777 -4,336 -16.0%Memberships 53230 1,949 699 -1,250 -64.1%Rentals and Leases 53610 21,975 21,975 - 0.0%Special Events 53640 101,424 101,340 -84 -0.1%

Subtotal 853,023 787,247 -65,776 -7.7%

CAPITALNon-Capital Furniture & Equipment 54030 14,500 11,000 -3,500 -24.1%Furniture and Equipment 54050 - 16,500 16,500

Subtotal 14,500 27,500 13,000 89.7%

GRANTSGrants 56010 1,126,514 1,108,843 -17,671 -1.6%Incentive Grant 56011 56,884 56,884 - 0.0%Supplemental Grant 56012 89,526 89,526 - 0.0%Book Grant 56013 119,526 119,526 - 0.0%Veteran's Grant 56014 49,570 49,569 -1 0.0%

Subtotal 1,442,020 1,424,348 -17,672 -1.2%

TOTAL 2,912,254 2,802,480 -109,774 -3.8%


STUDENT ACTIVITY FUNDACCOUNT CODE SUMMARY

46

FUND ACCOUNTCODE

DESCRIPTION FY 2014-15BUDGET

FY 2015-16BUDGET

PROPOSEDINCREASE/

<DECREASE>%

CHANGEStudent Activity (0101) 54030 Non-Capital Furniture & Equip. 14,500 11,000 -3,500 -24.1%

54050 Furniture and Equipment 16,500 16,500Subtotal 14,500 27,500 13,000 89.7%

General (0201) 54010 Systems Furniture 2,300 - -2,300 -100.0%54020 Remodeling and Renovations 1,270,000 1,902,979 632,979 49.8%54030 Non-Capital Furniture & Equip. 2,010,841 2,332,534 321,693 16.0%54050 Furniture and Equipment 1,150,711 1,545,676 394,965 34.3%54080 Building Improvements 450,000 - -450,000 -100.0%

Subtotal 4,883,852 5,781,189 897,337 18.4%

Adult Supp. Educ. (0601) 54030 Non-Capital Furniture & Equip. 61,000 105,800 44,800 73.4%Subtotal 61,000 105,800 44,800 73.4%

Motorcycle (0701) 54030 Non-Capital Furniture & Equip. 11,800 10,800 -1,000 -8.5%Subtotal 11,800 10,800 -1,000 -8.5%

Auxiliary (1302) 54020 Remodeling and Renovations 15,000 - -15,000 -100.0%54030 Non-Capital Furniture & Equip. 48,649 66,510 17,861 36.7%54045 Rental Textbooks 800,000 - -800,000 -100.0%54050 Furniture and Equipment 32,300 57,668 25,368 78.5%54080 Building Improvements 12,000 448,600 436,600 3638.3%54090 Land Improvements 25,000 25,000 - 0.0%

Subtotal 932,949 597,778 -335,171 -35.9%

Vocational Improv. (2219) 54030 Non-Capital Furniture & Equip. - 43,350 -43,35054050 Furniture and Equipment 331,905 108,000 -223,905 -67.5%

Subtotal 331,905 151,350 -180,555 -54.4%

Capital Outlay (7111) 54020 Remodeling and Renovations 270,540 - -270,540 -100.0%54030 Non-Capital Furniture & Equip. 5,890 - -5,890 -100.0%54050 Furniture and Equipment 966,050 - -966,050 -100.0%54080 Building Improvements 987,900 1,750,000 762,100 77.1%

Subtotal 2,230,380 1,750,000 -480,380 -21.5%

TOTAL 8,466,386 8,424,417 -41,970 -0.5%

*Schedule of Capital Expenses does not include library books, audio visual holdings, or art acquisitions.


SCHEDULE OF CAPITAL EXPENSES

47

Finance & Admin Services Branch (002000)

General Fund (0201)Remodeling and Renovations (54020)


1

1

1

1111

111

1

11

1

1

1

1

adhoc wire pulls

#575 - GEB 275 remove TAB mobile filing systemand remodel area#588 - CC 211 replace chalkboards with a whiteboard#656 - OCB 246, 248 & 257C - Paint walls#658 - RC 342 Paint walls#660 - GEB 351A Paint walls#672 - Remodel of OCB 3rd floor men's & women's restroomsClassroom paintingGEB 252 - Soundproof officeOCB vacated spaces remodel

Carpet Replacement - GYM 1st Floor Main CorridorCarpet Replacement - GYM 2nd Floor CorridorsCarpet Replacement - HCDC Corridors, Lobby and 3 ClassroomsCarpet Replacement - LIB 2nd Floor Main LIB Including Moving expenses.Carpet Replacement - LIB 314,342,344,346, and 352 ClassroomsCarpet Replacement - LIB 371, 372, and 373 Ed Tech Labs

Technology Infrastructure

$50,000.00

$16,500.00

$3,000.00

$3,000.00 $1,000.00 $1,000.00

$156,500.00

$5,000.00 $2,000.00

$1,063,000.00

$12,000.00

$25,000.00 $24,750.00

$94,000.00

$23,500.00

$6,500.00

$416,229.00

6401

7102

7202

7745

Dir., Admin. Computer Services

Dir., Campus Services

Interior Services

Information Technlgy Infrastructure

$50,000.00

$1,251,000.00

$185,750.00

$416,229.00

Total

Total

Total

Total

$1,902,979.00===============

Item Total Org Total

Remodeling and Renovations (54020)Total

48


General Fund (0201)Non-Capital Furniture & Equipment (54030)


18

3

10

25

6

1

4

1

12

2

10422

Classrooms -Complete RC Classroom Digitial to Analog Upgrade (18-1st & 2nd floor RC)-Replacement of Crestron control systems which are original to the building. Maintain Learning Studios - Analog to Digital( LIB353B, CC 229, GEB 238). Replacement -Classroom Podiums Continuing Education 10 Wood (RC 2nd floor).Replacement -Classroom Podiums Instruction (25) 14 Nova, 11 Wood (RC 3rd floor).Replacement -Conference Room TV Monitors -RC 323 Technology, CC 205B Audit, CC 207 Foundation, CC 115 police, COM 102 Student Life, NMOCA 214G Museum .Replacement -NMOCA 217/Hudson Technology Cont. Education (Crestron, Mics, Speakers, programming).Replacement -Smartboards (4) -Math Resource Center & Classrooms CLB 212A, CLB 212B, SCI 116, SCI 211.

ITP items-to be determined

Chair for new work station in dispatch.Harris police radio-XG-75 M/M7300, 764-870 MHz, half DPLX, P25 trunking with CH721 remotehead wiring harness and microphone.Outfit vehicle with police equipment (see KA-Comm invoice 128053 dated 12-17-14)

CamerasDVR's - InfinovaSargent electrified mortise locks w/RXSargent electrified panics w/RX

$20,880.00

$31,800.00

$30,000.00

$75,000.00

$14,400.00

$14,400.00

$11,200.00

$750,000.00

$725.00 $6,840.00

$14,052.50

$3,500.00 $12,000.00

$1,200.00 $2,200.00

4311

4408

6321

6325

6356

Audio Visual Services

Inst Information Technology Plans

Chief, Police Department

Security Access Control Systems

Emergency Preparedness

$197,680.00

$750,000.00

$21,617.50

$18,900.00

Total

Total

Total

Total


49




3

23

1

1111

1

11

6

11

11

4

1

Three additional AEDs for continued AED replacement and standardization to the Powerheart G3 AED Audo from Cardiac Science - three older style AED units are in need of replacement.

2 office chairsMICR Printer for check printing.

ITP items-to be determined

17" Drill press (JDP-17DX #841365)Flow hood/CFM testing meterGear sander (Festool Rotex R090 #571823)Orbital sander with vacuum (Festool ETS 125EQ #48571817)Ridgid K-1500 3/4hp sewer machine with added sewer cableScaffolding for Regnier Center (safety)Sliding compound miter saw (Festool Kapex #561287)Standing anti-fatigue mats

Classroom Furniture and Equipment TBDMesh Shades/Tinting to Replace Vertical Blinds in Classrooms and Public AreasReplace Walk-Off Grates at CLB/OCB EntrancesSignage Upgrade - Campus wide

Kaivac restroom cleaner

Deep root fertilizer gun for trees

$4,050.00

$1,500.00 $9,345.00

$222,195.00

$800.00 $4,900.00

$600.00 $1,000.00

$4,000.00

$1,500.00 $1,500.00

$1,980.00

$338,743.00 $20,000.00

$6,200.00 $5,000.00

$14,000.00

$400.00

6356

6401

6404

7201

7202

7301

7501

Emergency Preparedness


Admin Information Technology Plans

Maintenance

Interior Services

Housekeeping Services

Grounds

$4,050.00

$10,845.00

$222,195.00

$16,280.00

$369,943.00

$14,000.00

Total

Total

Total

Total

Total

Total


50


Academic Affairs & Operations (005700)



1

11311

1

3

1

11

1

1

2

25

6

High pressure spray gun for tree insecticide sprayingMotorized spreaderSnow blower - John Deere JCCC Inv 53460Stihl FS90R weed eaterStihl HT131 pole chain sawStihl MS291 chain saw

Office furniture/chairs

Lockers - six tier 12x12x12, 18 door units. Prioritized as critical by AHSS/VPAA.Powermatic 20" Planer, Model 209 - Replaces JCCC# NC5920. AHSS/VPAASawStop 3 Hp Cabinet Saw AHSS/VPAAVertical storage cage for welding gas bottles. AHSS/VPAA

Hammer Strength Linear Leg Press. Prioritized asCritical for HCPW/VPAA.

Centrifuge for Physiology. Prioritized as Critical for SCI/VPAA.Model - Cross section spinal cord. Prioritized as Critical for SCI/VPAA.

Microscopes for Microbiology. Current scopes areten years old and have heavy use. Prioritized as Critical for SCI/VPAA.

Force balances for Physics. Prioritized as Critical

$400.00

$3,500.00 $4,500.00 $1,050.00

$700.00 $600.00

$5,890.00

$1,200.00

$2,900.00

$3,500.00 $1,060.00

$4,140.00

$500.00

$800.00

$27,300.00

$3,600.00

7501

7714

1103

1117

1127

1128

1132

Grounds

ADA Campus Modifications

Fine Arts

Health, Phys Ed & Rec

Human Sciences

Biology

Physics

$11,150.00

$5,890.00

$8,660.00

$4,140.00

$1,300.00

$27,300.00

Total

Total

Total

Total

Total

Total


51



5

1

4

Student hand tools and boxes. Prioritized as Critical for TECH/VPAA.

RIT Bag - used to accomplish tasks that are vital in the rescue of a downed firefighter. Prioritized as Critical by AHSS/VPAA.

Cavitrons - Prioritized as Critical for SCI/VPAA.

$20,000.00

$1,600.00

$11,200.00


Total

Total

Total

$20,000.00

$1,600.00

$11,200.00

1

1

1

1

1

1

by SCI/VPAA.

Oxy-Acetylene welding cart. Current cart is unsafe. Prioritized as Critical by TECH/VPAA.

Refrigerator for OHEC. Prioritized as Critical for HCPW/VPAA

Equipro steamer and stand. Prioritized as Critical for CTE/VPAA.

Hand push seeder. Prioritized as Critical for SCI/VPAA.Rotary plow attachment for tractor. Prioritized as Critical for SCI/VPAA.

Miscellaneous ITPs for Instruction (to be determined)

$350.00

$2,000.00

$720.00

$1,325.00

$1,329.00

$276,258.00

1132

1226

1243

1244

1263

1272

Physics

Metal Fab (Welding) Technology

Practical Nursing/Health Occup

Cosmetology

Sustainable Agriculture

Vocational Capital Outlay

1210

1214

1218

Automotive Technology

Fire Science

Dental Hygiene

$3,600.00

$350.00

$2,000.00

$720.00

$2,654.00

Total

Total

Total

Total

Total


52



5

1

1

2

12

R410A Condensers, 1.5 Ton outdoor units to go with the furnaces and evaporators which were previously received. Prioritized as Critical for TECH/VPAA.R410A Heat pump units, 1.5 Ton outdoor unit to go with furnace and evaporator previously received. Prioritized as Critical for TECH/VPAA.

Belt grinder. Worn beyond repair. Machineis used daily by beginning, intermediate and advanced students. Prioritized as Critical by TECH/VPAA

Abrasive belt grinder complete with accessories. Needed to meet with increasing BNSF student class load. Prioritized as Critical for TECH/VPAA.

pH/conductivity meters for Chemistry lab. Prioritized as Critical for SCI/VPAA.

$8,500.00

$2,300.00

$3,000.00

$6,000.00

$18,000.00


Total

Total

Total

Total

$10,800.00

$3,000.00

$6,000.00

$18,000.00

1

17

1

Miscellaneous ITPs for Instruction (to be determined)

Complete welding machine package with all accessories for WLB. Machines are in use 42 wks/yr. Prioritized as Critical for TECH/VPAA.

GoPro HER04 Black Camera - Prioritized as

$20,962.00

$84,915.00

$500.00

1272

1273

1277

4314

Vocational Capital Outlay

Technology Equipment Grant

Railroad Industrial Technology

Educational Technology Center

1225

1226

1277

1115

HVAC


Railroad Industrial Technology

Sciences

$328,858.00

$38,962.00

$84,915.00

Total

Total

Total


53




1

2

1106

11

12

1

1

1

1

11

Critical for AS/VPAALulzBot TAZ 4 3D Printer Package - Prioritized asCritical for AS.

Athletic Trainers Therapy Unit Replaces 54538/54537Pole Vault Standards Replacement of 54818Uniform Replacements (Mens Basketball/Baseball)

Executive Desk Chair for Randy WeberMicrowave Oven - commerical quality, 1000 watts, low volume for the 3rd floor breakroom, SC 310, for use by 80 staff membersOffice Side Chair w/ arms, on wheels, and adjustable height control to replace 6 chairs in Randy Weber's office, 4 chairs in Paul Kyle's office, and 2 chairs by administrative assistants' desks

Graphic Elevator Clings and Banner for Baseball Field Fence

Standard JCCC Ergonomic Desk Chair for Carla DodgeStandard JCCC Ergonomic Desk Chair for Jenny MahieuStandard JCCC Ergonomic Desk Chair for Karen Miller

Standard for Track Replacement of 52621Utility Cart Yamaha Replacement of 52629

$2,367.00

$5,000.00

$3,650.00 $20,034.00

$1,200.00 $350.00

$4,200.00

$3,900.00

$750.00

$750.00

$750.00

$3,175.00 $4,500.00

4314

4607

5101

5104

5111

5207

5301


Physical Education & Athletic

Student Success & Engagement

Admissions

Access Services

Athletics

Career Development Center

$2,867.00

$28,684.00

$5,750.00

$3,900.00

$2,250.00

$7,675.00

Total

Total

Total

Total

Total

Total


54


Marketing Communications (003100)



1

1

1

7512

502

11111

1

33

Standard JCCC Ergonomic Desk Chair for Amy FisherStandard JCCC Ergonomic Desk Chair for Carol GardStandard JCCC Ergonomic Desk Chair for Carolyn Foster

Caper Task Chairs for LabsErgonomic Desk Chair for Sharon WirsigNova ADA Computer Desks for LabsNova Computer Desks for LabsNova Proctor Computer Desks for Labs

Ergonomic Chair for Alice BatyErgonomic Chair for Bruce HarveyErgonomic Chair for Jessica GarciaErgonomic Chair for Ron FrigaultFree standing ice maker for the 2nd floor break room, SC 238 - has 25lb. storage bin, tap touch on/off clean selector and recessed controls

Office Chair

Monitors for Digital Signage LG42" and LG 47"

$750.00

$750.00

$750.00

$30,000.00 $750.00

$3,000.00 $70,000.00

$3,200.00

$750.00 $750.00 $750.00 $750.00

$2,500.00

$700.00

$19,998.00

5301

5302

5303

4301

4321

Career Development Center

Testing & Assessment Services

Counseling

Publications

College Information

$2,250.00

$106,950.00

$5,500.00

$700.00

$19,998.00

Total

Total

Total

Total

Total

$2,332,533.50===============


Non-Capital Furniture & Equipment (54030)Total

55


General Fund (0201)Furniture and Equipment (54050)

1

1

1

1

1

1

1

1

1

1

Delta 14" Radial Arm Saw. Prioritized as Critical by AHSS/VPAA.Element 60-250 control console with dust cover, keyboard, mouse and mouse pad. Prioritized as Critical for AHSS/VPAA.

Treadmill. Prioritized as Critical for HCPW/VPAA.Treadmill. Prioritized as Critical for HCPW/VPAA.Treadmill. Prioritized as Critical for HCPW/VPAA.

Elmer IR spectrometer. One has been repaired, the other has a broken laser. Prioritized as Critical for SCI/VPAA.Elmer IR spectrometer. One has been repaired, the other has a broken laser. Prioritized as Critical for SCI/VPAA.

Tire Changer for current technology needs in Tires/Wheels. Prioritized as Critical by TECH/VPAA.

Monitor/Defribrillator - LifePak 12 replaces obsolete LifePak 11. Prioritized as Critical for EMS/HCPWVideo Layngosccope - this single item is replacing 5 of the old Karl Stores items; 52841, 52842, 52843, 52850 and 53025. Prioritzed as Critical by HCPW/VPAA

$6,000.00

$9,000.00

$6,500.00

$6,500.00

$6,500.00

$26,000.00

$26,000.00

$14,000.00

$18,000.00

$10,000.00


Total

Total

Total

Total

Total

$15,000.00

$19,500.00

$52,000.00

$14,000.00

$28,000.00

6333 Equipment Replacement Pool1108

1117

1129

1210

1220

Theater

Health, Phys Ed & Rec

Chemistry


Emergency Medical Science


56



1

1

1

1

1

1

1

1

1

1

1

1

1

350 Amp Welder power source for MIG welding system. Used daily. Prioritized as Critical by TECH/VPAA.350 Amp Welder power source for MIG welding system. Used daily. Prioritized as Critical by TECH/VPAA.350 Amp Welder power source for MIG welding system. Used daily. Prioritized as Critical by TECH/VPAA.350 Amp Welder power source for MIG welding system. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.

$5,000.00

$5,000.00

$5,000.00

$5,000.00

$7,000.00

$7,000.00

$7,000.00

$7,000.00

$7,000.00

$7,000.00

$7,000.00

$7,000.00

$7,000.00


6333 Equipment Replacement Pool1226 Metal Fab (Welding) Technology


57



1

1

1

1

1

1

1

1

1

1

1

1

375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.375 Amp TIG Welding machine. Current machine is 10 years old. Used daily. Prioritized as Critical by TECH/VPAA.Guided Bend Tester. Current machine is 14yrs old and used daily for AWS weld qulity certification testing. Prioritized as Critical for TECH/VPAA.

High Jump Pit

Pole Vault Landing Area Pit

Pole Vault Landing Area Pit

This is a scheduled replacement for the department's 2008 Crown Vic. We will purchase a new SUV.This is a scheduled replacement of the department's 2008 Ford Ranger pick-up. We will purchase a new full-size pick-up

$7,000.00

$7,000.00

$7,000.00

$7,000.00

$7,000.00

$7,000.00

$9,000.00

$5,835.00

$10,990.00

$8,650.00

$25,145.00

$20,939.00


Total

Total

Total

$134,000.00

$16,825.00

$8,650.00


4607

5207

6321


Physical Education & Athletic

Athletics



58



1

1

1

1

1

1

1

1

1

1

1

truck. This vehicle will be used by public safety officers for parking control daily activities.

Pick up truck #228

Pick up truck #233 - F250

Pick up truck #244 - F250

Pick up truck #255 F250

Ranger pick up truck - #209

Cisco UCS Blade Servers - Replacement of blade servers to improve capacity and performance for virtual servers. This represents replacing one half of the blade server capacity deferring the other half for the following fiscal year. Includes Inventory Numbers: 55557 55568 55553 5557055555 55565 55559 55556 55560 55554 55561 55562 55566 55552 55563 55558 55569 55564 55567 55551 NetApp Storage Area Network-Replace flash cache with flash pool storage to improved both read and write performance on this controller. Replace older disk trays that are nearing end of support. Includes Inventory Numbers: 55354, 55355, 55357 AND 55356.

EZ-GO go cart

EZ-GO go cart

Ranger pickup - #204 (JCCC Inv 54935)

Ranger pickup - #205

$27,000.00

$30,000.00

$30,000.00

$27,000.00

$25,000.00

$256,252.00

$60,315.00

$8,000.00

$8,000.00

$25,000.00

$25,000.00


Total

Total

Total

$46,084.00

$139,000.00

$316,567.00


6341

6401

7201


Transportation


Maintenance


59




1

1

1

1

1

1

1

1

1

1

Turf truck EZ-GO - #303

Pick up truck F250 replace with box truck

Rider sweeper extractor



Windsor auto scrubber




Riding lawn mower - John Deere 1445

$8,000.00

$40,000.00

$16,350.00

$16,350.00

$16,350.00

$5,500.00

$5,500.00

$5,500.00

$5,500.00

$42,000.00


Total

Total

Total

$74,000.00

$111,050.00

$42,000.00

1

1

1

1

1

Cisco Blade Servers for virtual server infrastructure NetApp flash drive storage acceleration

Technology Infrastructure

Brainwave Tracing System. It is planned that costcenter 1238 will be renamed to Neurodiagnistics in the near future. Prioritized as Critical for HCPW/VPAA.

Hydraulic Trainer complete hydraulic package withlab curriculum, trainer tools and supporting

$25,000.00

$50,000.00

$300,000.00

$35,000.00

$30,000.00

6333

6401

7745

1238

1289

Equipment Replacement Pool


Information Technlgy Infrastructure

Polysomnography/Sleep Tech

Industrial Maintenance

7201

7301

7501

Maintenance

Housekeeping Services

Grounds

$1,016,676.00

$75,000.00

$300,000.00

$35,000.00

Total

Total

Total

Total


60


Marketing Communications (003100)



1

1

1

1

1

2

components. Prioritized as Critical by TECH/VPAA.Mechanical Drives Trainer - complete trainer package with lab curriculum, trainer tools and supporting components. Prioritized as Critical by TECH/VPAA.Pneumatic Trainer complete trainer package with lab curriculum, trainer tools and supporting components. Prioritized as Critical by TECH/VPAA.

HD RF encoders: HD encoders and moldulators for Dish network. Prioritized as Critical by AS/VPAA.

Dedicated Classroom video recording package like One Button Studio - prioritized as Critical by AS/VPAA.zSpace System virtual reality display. Prioritized as Critical by AS/VPAA.

Digital Signage Kiosks, Free Standing or Wall Mounted Featuring Way Finding, Upcoing Events, Calendar, Ticket Purchase and Printer

$30,000.00

$15,000.00

$7,000.00

$10,000.00

$7,000.00

$20,000.00

1289

4312

4314

4321

Industrial Maintenance

Video Services


College Information

$75,000.00

$7,000.00

$17,000.00

$20,000.00

Total

Total

Total

Total

$1,545,676.00===============


Furniture and Equipment (54050)Total

61


Institutional Advancement (003000)

Adult Supplemental Education Fund (0601)Non-Capital Furniture & Equipment (54030)


50

1

6333

JCCC Standard PC with Monitor, Camera, and Touchscreeen

Supply Chain Logistics items for LPKC Partnership

Meyer MJF-212 wedge monitorsShure UR2/Beta 87-H4 wireless microphonesShure UR2/KSM9-H4 wireless microphonesShure UR4D+H4 Dual Receivers

$65,000.00

$3,000.00

$21,600.00 $3,600.00 $3,600.00 $9,000.00

1409

1414

1442

Microcomputer Training

ASE Developing Programs

CC Operations

$65,000.00

$3,000.00

$37,800.00

Total

Total

Total

$105,800.00===============



62


Motorcycle Driver Safety Fund (0701)Non-Capital Furniture & Equipment (54030)


5 Motorcycle Replacements $10,800.001404 Transportation-Continuing Ed

$10,800.00Total

$10,800.00===============



63



Auxiliary Enterprise Funds (1302)Non-Capital Furniture & Equipment (54030)


21

1

1

5

4122231

12

1

4

6

Campus Standard PC and MonitorCarving Station, Beverage Dispensers, Chafing DishesChina, Teaspoons, Dessert Spoons, Bouillons CupsFood Processors, Sauce Pans, Hand Mixers

Blackboard VR4101 Vending Readers

Blackout Shades for Technology AreaCoin CounterComputersIpads/TabletsPrinters, Black and WhitePrinters, Personal ColorRadio Equipment - 15 Radios, 1 Digital Repeater,Programming, and FCC LicenseVirtual PCs

Mazer Super Jolly Electronic Grinder

JCCC Standard PC Desktop - with Monitor, Speaker Bar, Camera - TouchscreenOptiflex 7020 Small Form Factor

$5,000.00 $6,186.46

$4,279.86

$4,081.19

$6,375.00

$4,000.00 $4,000.00 $2,600.00 $1,400.00 $3,000.00 $1,050.00 $7,742.42

$6,000.00

$1,335.00

$5,200.00

$4,260.00

9101

9102

9103

9112

9104

Dining Services

Vending

Bookstore

Espresso Bars

Child Development Center

$19,547.51

$6,375.00

$29,792.42

$1,335.00

$9,460.00

Total

Total

Total

Total

Total

$66,509.93===============



64


Auxiliary Enterprise Funds (1302)Furniture and Equipment (54050)


1

1

1

1

1

Alto-Shaam Model No. 1767-SK/III Cook Hold Oven Cabinet Smoker, ElectricConvection Steamer, Groen Model No. (2) HY5-EF Custom Model No. Garland Grill 3GAR024

Vending Machine 6 Wide 181 Glass Snack Machine w/Scrolling Prices, Dual LED 5 Snack, 1 Candy

LaMarzocco 2 Group Semi-Automatic Espresso Machine

$10,622.88

$19,763.44

$13,686.00

$5,100.00

$8,495.00

9101

9102

9112

Dining Services

Vending

Espresso Bars

$44,072.32

$5,100.00

$8,495.00

Total

Total

Total

$57,667.32===============



65


Auxiliary Enterprise Funds (1302)Building Improvements (54080)


111111

COM VAV box repair/replacementCOM dock repairsCOM door closers/hardwareCOM kitchen exhaust hoodCOM kitchen floor epoxyCOM painting of doors, frames & walls

$369,600.00 $25,000.00

$4,000.00 $10,000.00 $30,000.00 $10,000.00

7102 Dir., Campus Services

$448,600.00Total

$448,600.00===============


Building Improvements (54080)Total

66


Auxiliary Enterprise Funds (1302)Land Improvements (54090)


1 Landscape $25,000.009151 Auxiliary Construction

$25,000.00Total

$25,000.00===============


Land Improvements (54090)Total

67


Student Activity Fund (0101)Non-Capital Furniture & Equipment (54030)


1

1

1

1

1

1

1

1

Campus Standard Laptop - to replace BYHMFJ1 in Carlsen Center Welcome DeskCampus Standard PC Desktop - to replace 65DNMM1 - ID ComputerCampus Standard PC Desktop - to replace 7KPDNM1 - ID ComputerCampus Standard PC Desktop - to replace GDJ8LN1 - ID ComputerPrinter - B&W - Medium Workgroup to replace CNDY119924

Printer - B&W - Medium Workgroup to replace CNDY231160

Campus Standard PC Desktop - to replace 7VGTQH1Campus Standard PC Desktop - to replace HGKCBP1

$1,500.00

$1,300.00

$1,300.00

$1,300.00

$1,500.00

$1,500.00

$1,300.00

$1,300.00

5201

5202

5209

Student Activities

Campus Ledger

Center for Student Involvement

$6,900.00

$1,500.00

$2,600.00

Total

Total

Total

$11,000.00===============



68


Student Activity Fund (0101)Furniture and Equipment (54050)


111

ID Printer - replacing N93110ID Printer - replacing N95095ID Printer - replacing N95923

$5,500.00 $5,500.00 $5,500.00

5201 Student Activities

$16,500.00Total

$16,500.00===============



69


Vocational Improvements Grant (2219)Non-Capital Furniture & Equipment (54030)

10

1

2

1

Student hand tools and boxes. Prioritized as Critical for TECH/VPAA.

Commercial lawn mower. Prioritized as Critical for SCI/VPAA.Hot plates. Prioritized as Critical for SCI/VPAA.Varispeed recycler mower. Prioritized as Critical for SCI/VPAA.

$40,000.00

$2,000.00

$1,000.00

$350.00


Total

Total

$40,000.00

$3,350.00

1271 Vocational Improvements1210

1274


Horticulture

$43,350.00Total

$43,350.00===============



70


Vocational Improvements Grant (2219)Furniture and Equipment (54050)

1

2

2

2

Vehicle Sysems Trainer. Prioritized as Critical by TECH/VPAA.

Lucas Chest Compression System. Prioritized as Critical for HCPW/VPAA.iSimulate Advanced Medical Simulation Technology. Prioritized as Critical for HCPW/VPAA.

HAL S1030 Dynamic Airway & Lung compliance simulator. Prioritized as Criticalfor HCPW/VPAA.

$27,000.00

$30,000.00

$15,000.00

$36,000.00


Total

Total

Total

$27,000.00

$45,000.00

$36,000.00

1271 Vocational Improvements1210

1220

1241


Emergency Medical Science

Respiratory Care

$108,000.00Total

$108,000.00===============



71


Capital Outlay Fund (7111)Building Improvements (54080)


111111111111111111

Accounting/Procurement HVACBackflow preventersBlack iron paintingBuilding automation upgradeCSB chiller 1 overhaulClassroom/corridor paintingElevator cab refurbishFume hood repairsGreenhouse roofLighting upgradesMasonry repairsMetal door and frame paintingOCB Liebert 2PGGG tower sump heatersPaver repairRoof replacementsSCI roof GSCI roof G ceiling replacement

$54,000.00 $6,000.00

$50,000.00 $15,000.00 $65,000.00 $50,000.00 $24,000.00 $10,000.00 $75,000.00

$100,000.00 $141,200.00 $10,000.00 $80,000.00

$3,800.00 $25,000.00

$1,000,000.00 $21,000.00 $20,000.00

7102 Dir., Campus Services

$1,750,000.00Total

$1,750,000.00===============


Building Improvements (54080)Total

71

budget workshop 2015-16 - johnson county community college€¦ · the fy 2015-16 budget will be...

Documents