bot packet 062210

7/27/2019 BOT Packet 062210

1/258

Rock Valley College Board of Trustees

Community College District No. 511

June 22, 2010

Trustees Study Session at 5:15 p.m. WTC 141

Regular Meeting at 6:00 p.m. WTC 117/119/121

Regular Meeting Agenda

A. Call to OrderB. Roll CallC. Minutes: May 8, 2010; May 25, 2010D. Communications and PetitionsE. Recognition of Visitors

1. RVC Womens Softball Team and All AmericansF. General Presentations

1. GFOA Budget Award Presentation: Sam Overton, Stacie Talbert2. FY11 Tentative Budget Presentation

G. Reports1. Vital Signs

a. Payroll,Healthcare Costs,Cash,JCSM (Jacobs Center for Science & Math), FY10Surplus List

b. Freedom of Information Act (FOIA) Report2. Presidents Report

a. BR #6711 Claims Sheet #656 (Check Register) (Checks over $10,000)b. BR #6712 Purchase Report #634c. BR #6713 Personnel Report #624d. BR #6714 Tentative Budget for FY 2011 Attachmente. BR #6715 Resource Allocation Management Plan (RAMP) Arts Instructional Center (AIC

1. Board of Trustees Matching Funds Commitment2. RAMP Complete Submittal

f. BR #6716 Out of School Youth Program (WIA Funding)g. BR #6717 Asphalt and Parking Lot Renovations: Attachment A; Attachment Bh. BR #6718 Land Sale and Easements at Stenstrom Center for Career Education (SCCE)

3. Attorneys Reportsa. AR #258 Resolution Adopting Tentative Budget and Setting Hearing Date for Budget

b. AR #259 Resolution Ascertaining Prevailing Wagesc. AR #260 Resolution for Sanitary Sewer Easement (JCSM)d. AR #261 Resolution Granting a Perpetual Easement for Water Mains (JCSM)e. AR #262 Resolution to Sell Land and to Grant Temporary Construction Easement and

Permanent Easement (Stenstrom Center for Career Education)f. AR #263 Resolution to Confirm and Ratify Learning and Opportunity Center Lease

4. ICCTA Report5. Student Trustee Report6. Board Committee Reports

H.New BusinessI. Trustee Comments

SEE OTHER SIDE

7/27/2019 BOT Packet 062210

2/258

J. Presidents Comments1. Accolades

a. Phi Theta Kappa2. Announcements from Presidents Leadership Team

K. Adjourn to Closed Session to discuss pending litigation, hiring and retention of specific employees,collective bargaining matters, and Closed Session contractual matters. Following Closed Session, theBoard may take action regarding employee hiring and retention.

L. Reconvene Open SessionM.Unfinished Business

1. Recommendation for Dismissal of a Faculty MemberN. Date of Next Meeting: July 27, 2010: Study Session at 5:15 p.m. in WTC 141/142; Regular Meeting,

6:00 p.m., WTC 117/119/121O. Adjourn

Katherine M. Kelley, Board Chair

7/27/2019 BOT Packet 062210

3/258

Board of Trustees Minutes of May 8, 2010 Page #1 of 3 pages

Strategic Meeting Board Retreat

The Strategic Meeting of the Board of Trustees of Community College District No.511, Winnebago, Boone, DeKalb, McHenry, Stephenson and Ogle Counties, Illinois,convened in the Support Services Building room 1309 on the main campus on Saturday,May 8, 2010 at 8:00 a.m. Chair Katherine Kelley called the meeting to order.

The following members of the Board were present:

Mr. Ted Biondo Dr. Stephanie RaachMs. Katherine Kelley Mr. Randy SchaeferMr. Mike Olson Mr. Ken NelsonRev. K. Edward Copeland Ms. Gloria Wiekert, student trustee

Also in attendance: Dr. Jack Becherer, President; Dr. Diane Nyhammer, Provost/ChiefAcademic Officer; Ms. Suzanne Berger, Vice President of Institutional Advancement andExecutive Vice President of RVC Foundation; Ms. Amy Diaz, Associate Vice President ofStudent Development; Ms. Ann Kerwitz, Assistant to the President; Mr. Sam Overton, Jr.,

Vice President of Administrative Services; Mr. Mike Mastroianni, Associate Vice Presidentof Outreach and Planning; Mr. Greg Wear, Associate Vice President of Academic Affairs;Ms. Susan Busenbark, Dean of Academic Development and Instructional Support; Ms.Marrisa Mora, incoming student trustee.

Minutes

Capacity and Space Utilization

Mr. Greg Wear presented a summary of the room capacity and space utilizationstudies completed during the fall 2009 semester and spring 2010 semester to record andanalyze the usage of every classroom and lab available for academic scheduling. Using a

chart of six sample class times, Mr. Wear explained how many of the colleges buildings areeffectively scheduled and enrolled, while others could be scheduled more effectively. Henoted that the new class schedule matrix is based on student needs, and he and the associatedeans are scheduling classes to utilize all available space.

Arts Instructional Center (AIC) Academic Programming

Mr. Greg Wear explained the process currently being implemented for design of theArts Instructional Center (AIC). Using drawings created by the architects following morethan 14 hours of meetings with faculty and staff, Mr. Wear described the desired features ofthe building including theaters and related areas, specialized art studios, and classroom space.

Trustee questions regarding how to balance academic programming with performance

venues led to a discussion of the need to establish principles that would guide design of thebuilding. Dr. Diane Nyhammer explained that Academic Affairs is focused on expanding thenumber of course offerings in the arts, thus emphasizing the instructional part of thefacilitys title, yet honoring the Colleges mission to be a leader in cultural enrichment andcommunity involvement.

Following discussion of possible guiding principles for the AIC, trustees agreed toconsider the following: 1) The building will have multiple purposes and uses, and include

7/27/2019 BOT Packet 062210

4/258


areas for students to study, relax and conduct co-curricular activities; 2) The primary focus ofthe building will be on academic programming to expand music and visual arts theory andgeneral education offerings while maintaining current studio art offerings; The secondaryfocus will be on performance; 3) The AIC will be built with an understanding thatinstructional space will be shared between credit and non-credit programs.

Mr. Wear and the architects are beginning to research facilities at other communitycolleges to identify comparable models. Mr. Sam Overton added that a request for a marketanalysis of regional and local performing arts venues, including the Rockford Area VenueEntertainment (RAVE), as well as art galleries and exhibit space, will appear on the MayPurchase Report.

Information Technology Leadership Outsourcing

Following a short break, Dr. Jack Becherer updated trustees on the plan to outsourceInformation Technology (IT) management for the ensuing year. Since recent financial reportsindicate reduced EAV revenues, the IT Leadership Outsourcing committee has agreed that amore affordable model is needed. Highlights include:

A new Request for Proposal (RFP) will be created requesting an executivecoach to serve as consultant and mentor to the existing IT management.

Dr. Diane Nyhammer will be responsible for supervision and oversight of IT. Two or three high-impact technology projects from a recently prioritized list

will be identified and outsourced.

A small advisory group of faculty, staff and administrative personnel will beformed to provide oversight in IT and ensure IT outcomes are value-added.

Options to Balance the FY11 Budget

Mr. Sam Overton reviewed the FY 2011 budget timeline, noting a possible $1 milliondeficit due to a decline in Equalized Assessed Valuation (EAV). Although the state of Illinoisis current in its payments, the Colleges portion is declining and receipt of future payments isuncertain. Mr. Overton indicated that Administration is reviewing options to reduceexpenditures in both FY2010 and FY2011, and the College will budget for zero EAV growthand manage the current tax rate of $0.45. Discussion followed regarding budget reductionideas including those suggested by RVC faculty and staff at a recent Presidents Councilmeeting.

Learning and Opportunity Center

Ms. Amy Diaz, Dr. Diane Nyhammer and Mr. Sam Overton updated trustees on thetimeline, guiding principles and student models for the Learning and Opportunity Center.Ms. Diaz and Dr. Nyhammer are leading focus groups to identify student cohort models andproposed curriculum, respectively, while Dr. Becherer and Mr. Overton have led efforts toidentify possible locations. The implementation team will meet soon to review the overallplan for operating the facility. In addition, Ms. Suzanne Berger and her staff will design amarketing plan and work with Ms. Diaz to quickly begin recruiting students.

In response to trustees questions, discussion followed on budgeting issues, locationcriteria, recruiting methods, hours of operation, parking availability and possible courseofferings.

Other Discussion Topics

7/27/2019 BOT Packet 062210

5/258


Following discussion, trustees agreed to begin the regular meeting at 5:15 p.m. onMay 25, 2010 and go immediately to closed session. A study session will not be held.

Mr. Sam Overton announced that the Colleges new Physical Education Center (PEC)has won gold-level certification for sustainable and green design. The Leadership in Energyand Environmental Design (LEED) recognition is awarded by the U.S. Green BuildingCouncil.

Next Meeting

The date of the next regularly scheduled meeting is Tuesday, May 25, 2010. Theregular meeting will begin at 5:15 p.m. in WTC 117/119/121. A study session will not bescheduled.

Adjournment

On a motion by Mr. Randy Schaefer seconded by Mr. Mike Olson, and unanimousvoice vote, the meeting was adjourned at 12:35 p.m.

Submitted by Ann Kerwitz

Mr. Michael D. Olson, Secretary Ms. Katherine M. Kelley, Chair

7/27/2019 BOT Packet 062210

6/258

Boa rd of Trust ees Minutes of May 25, 2010 Pa ge 1 of 7

Regular Meeting

The Meeting of the Board of Trustees of Community College District No. 511, Winnebago,Boone, DeKalb, McHenry, Ogle, and Stephenson Counties, Illinois, convened in the WoodwardTechnology Center Room 117/119/121 on the main campus on Tuesday, May 25, 2010 at 5:15 p.m.Chairperson Katherine Kelley called the meeting to order.

Roll Call


Mr. Mike Olson Ms. Katherine KelleyMr. Ken Nelson Mr. Randy SchaeferMr. Ted Biondo Dr. Stephanie RaachRev. K. Edward Copeland Ms. Marrisa Mora, incoming student

trustee

Also in attendance: Dr. Jack Becherer, President; Dr. Diane Nyhammer, Provost/Chief

Academic Officer; Mr. Sam Overton, Jr., Vice President of Administrative Services; Ms. AnnKerwitz, Assistant to the President.

Adjourn to Closed Session

On a motion by Mr. Randy Schaefer, seconded by Mr. Mike Olson, and unanimous roll callvote, the meeting was adjourned to closed session at 5:15 p.m. for the purpose of discussing thefollowing items pursuant to the appropriate sections of the Illinois Open Meetings Act:

Appointment, employment, compensation, discipline, performance, or dismissal ofspecific employees or legal counsel - Section 2 (c) (1)

Collective bargaining matters and salary deliberations - Section 2 (c) (2) Discussions regarding the lease or purchase of real property for College use Section 2

(c) (5)

Reconvene Open Session

The meeting reconvened at 6:30 p.m. No action was taken during Closed Session.


Mr. Mike Olson Ms. Katherine KelleyMr. Ken Nelson Mr. Randy Schaefer

Mr. Ted Biondo Dr. Stephanie RaachRev. K. Edward Copeland Ms. Marrisa Mora, incoming student

trustee

7/27/2019 BOT Packet 062210

7/258


Also in attendance: Dr. Jack Becherer, President; Dr. Diane Nyhammer, Provost/Chief AcademicOfficer; Ms. Suzanne Berger, Vice President of Institutional Advancement and Executive VicePresident of RVC Foundation; Ms. Amy Diaz, Associate Vice President of Student Development;Ms. Ann Kerwitz, Assistant to the President; Mr. Mike Mastroianni, Associate Vice President ofOutreach and Planning; Mr. Sam Overton, Jr., Vice President of Administrative Services; Mr. GregWear, Associate Vice President of Academic Affairs; Ms. Susan Busenbark, Dean of AcademicDevelopment and Instructional Support; Mr. Peter Kostantacos, College Attorney.

Minutes

On a motion by Mr. Mike Olson, seconded by Dr. Stephanie Raach, the minutes of theApril 27, 2010 meeting were approved by unanimous roll call vote.

Communications and Petitions

No communications or petitions were presented.

Recognition of Visitors

Ms. Marrisa Mora was sworn in as student trustee for 2010-2011 by College Attorney PeterKostantacos. Ms. Mora thanked trustees and indicated shes looking forward to her tenure asstudent trustee.

General Presentations

Professor Michelle Rotert presented information on her upcoming sabbatical in Japan andKorea where she will study in preparation for teaching a non-Western philosophy class at RVC.

Mr. Sam Overton provided for information purposes a status update of the FY2011 budget.Following a review of projected revenue streams and expenses as well as anticipated enrollmentgrowth, Mr. Overton indicated that the tentative FY11 budget to be presented in June will bebalanced and will include raises for faculty and ESP/PSA/Administration as well as expenses forthe Learning and Opportunity Center.

Reports

Vital Signs

Vital signs for payroll, healthcare costs, cash, JCSM (Jacobs Center for Science and Math),

the FY10 surplus list and the Freedom of Information Act (FOIA) Report were accepted aspresented.

Presidents Reports

BR #6701 ESP/PSA/Administration Salaries 2010-2011 (FY11) (TABLED April 27, 2010)It is recommended that the Board of Trustees approve the salary increase structure for non-

faculty employees in grades 4 to 25 effective July 1, 2010 as outlined in Board Report #6701.

7/27/2019 BOT Packet 062210

8/258

7/27/2019 BOT Packet 062210

9/258


$ 15,757.92 City Rockford

$ 11,901.52 Constellation New Energy

$ 655,117.73 TOTALBR #6707, Claims Sheet #655 was approved by unanimous roll call vote on a motion by Mr.

Mr. Mike Olson, seconded by Mr. Randy Schaefer.

BR #6708 Purchase Report #633

It is recommended that the Board of Trustees approve the marked items for purchase.

$ 65,717.77 A. Condensed Curriculum Int'l, Fairfield, NJ$ 17,167.08 B. Perceptive Software, Shawnee, KS

$ 35,936.25 C. Datatel, Inc, Fairfax, VA

$ 209,860.00 D. Datatel, Inc, Fairfax, VA

$ 10,000.00 E. Workforce Investment Board, Rockford, IL

$ 10,591.45 F. Steiner Electric, Loves Park, IL

$ 20,000.00 G. Booth Hansen, Rockford, IL$ 15,834.00 H. Stratton Charters, Cuba, WI

$ 386,662.00 I. Liberty Mutual Group, Carol Stream

$ 14,700.00 J. Critical Systems Service, Lake Zurich, IL

$ 29,999.00 K. Telcom Innovations Group, Itasca, IL

$ 303,673.00 L. Miller Engineering, Rockford, IL

$ 11,910.00 M. Nelson Systems, Springfield, IL$ 72,153.00 N. Addendum to Purchase Order B05123, Constellation New Energy,

Chicago, IL$ 10,000.00 O. Addendum to Purchase Order B05225, Regional Office of Education,

Rockford, IL$ 2,000.00 P. Addendum to Purchase Order B5279, Rockford Register Star, Rockford

$ 72,153.00 Q. Addendum to Purchase Order B05225, Saavedra Gehlhausen, Rockford

$ 1,288,356.55 TOTAL

Mr. Randy Schaefer made a motion, seconded by Dr. Stephanie Raach, to approve BoardReport #6708, Purchase Report #633.

In response to a question from Trustee Biondo, Mr. Sam Overton explained that PartialFY11 Budget noted on item B indicates that the payment covers a portion of FY10 (May 15, 2010through June 30, 2010) and a portion of FY11 (July 1, 2010 through May 31, 2011).

Motion approved by unanimous roll call vote.

BR #6709 Personnel Report #623It is recommended that the Board of Trustees acknowledge the items of personnel as

presented.In response to a question from Trustee Biondo, Dr. Diane Nyhammer explained that a Salary

Lane Change is the result of additional course work completed by faculty.The report was acknowledged and entered into the record.

7/27/2019 BOT Packet 062210

10/258


BR #6710 Learning and Opportunity Center (LOC)It is recommended that the Board of Trustees authorize Rock Valley College to establish the

Learning and Opportunity Center, which can be viewed with pride by the College and communityas attractive, conveniently located and conducive to learning.

On a motion by Mr. Mike Olson., seconded by Rev. K. Edward Copeland, Board Report#6710 was approved by unanimous roll call vote.

Attorneys Report

AR #255 Resolution Authorizing Application to the Illinois Community CollegeBoard for Approval of Locally Funded Capital Projects (Additional Parking Spaces atStenstrom Center for Career Education)

On a motion by Mr. Mike Olson, seconded by Mr. Randy Schaefer, AR #255 wasapproved by unanimous roll call vote.

AR #256 Resolution Authorizing Application for Utilization of Existing Funds forProtection, Health or Safety (Asbestos Abatement at Stenstrom Center for Career Education)

On a motion by Mr. Ken Nelson, seconded by Mr. Randy Schaefer, AR #256 was approved

by unanimous roll call vote.

AR #257 Resolution Regarding Learning and Opportunity Center LeaseOn a motion by Mr. Mike Olson, seconded by Rev. K. Edward Copeland, AR #257 was

approved by unanimous roll call vote.

College Attorney Peter Kostantacos asked for a motion to correct a scriveners error onBoard Report #6700 originally presented on the April 27, 2010 regular meeting agenda as PersonnelReport #621.

Mr. Mike Olson moved to correct the Personnel Report presented to the Board April 27,2010 to read Personnel Report #622, seconded by Dr. Stephanie Raach. The motion was approved

by unanimous roll call vote.

ICCTA Report

There was no ICCTA Report. However, Trustee Mike Olson noted that a bill to reducefunding to higher education in Illinois failed in committee today.

Student Trustee ReportMs. Marissa Mora reviewed recent on-campus Student Government Association (SGA)

activities as well as the Commencement ceremony held May 14. She will attend the ICCB StudentLeadership Institute in Springfield in early June.

Board Committee Reports

There were no Board committee reports.

Unfinished Business

There was no unfinished business.

7/27/2019 BOT Packet 062210

11/258


New Business

There was no new business.

Trustee Comments

There were no trustee comments.

Presidents Comments

Accolades: The Omicron Eta Chapter of Phi Theta Kappa Honor Society at Rock Valley Collegehas been named a Five Star Chapter at the Societys recent annual convention.

Announcements from Presidents Leadership Team

Dr. Diane Nyhammer updated trustees on faculty involvement in summer school, staffsearch committees and curriculum alignment workshops through the Rockford Alliance

collaboration with District 205.Mr. Greg Wear announced that the RVC Students in Free Enterprise (SIFE) team earned

first place in the National Entrepreneurship Topic competition held in Minneapolis May 12. Theteam also earned the title of Regional Champion for the sixth year in a row, which qualified them tocompete at the nationals.

Mr. Mike Mastroianni announced this years Fast Pitch event will be held at NIU-Rockford on June 22, also the date of the next Board meeting. He also announced that the StarlightTheatre season opens next week featuring Chicago, Aida, Annie and Rent.

Ms. Susan Busenbark announced that the new Learning Management System (LMS)administrator has begun working at the College and training sessions are being scheduled.

Ms. Suzanne Berger thanked Mr. Dave Arnold for his many years of service as the RVC

Foundation liaison to the Board of Trustees. A new liaison will be appointed for FY2011.Ms.Berger also announced that Ms. Wendy Young and Mr. Jim Cox will be leaving the FoundationBoard in June and five new Board members will be appointed in July.

Ms. Amy Diaz acknowledged the letter from the executive director of Phi Theta Kappa (inthe Accolades section) announcing that the local Omicron Eta Chapter has been named a Five StarChapter. The local chapter will be hosting a regional conference June 3-5.

Ms. Diaz also presented an updated enrollment report, noting that Credit Hours (CH) andHead Count (HC) are tracking well for the three summer sessions as well as the fall semester.

Adjourn to Closed Session

On a motion by Mr. Randy Schaefer, seconded by Mr. Mike Olson, and unanimous roll callvote, the meeting was adjourned to closed session at 7:15 p.m. for the purpose of discussing thefollowing items pursuant to the appropriate sections of the Illinois Open Meetings Act:

Appointment, employment, compensation, discipline, performance, or dismissal ofspecific employees or legal counsel - Section 2 (c) (1)

Collective bargaining matters and salary deliberations - Section 2 (c) (2) Discussions regarding the lease or purchase of real property for College use Section 2

(c) (5)

7/27/2019 BOT Packet 062210

12/258


Reconvene Open Session

The meeting reconvened at 7:40 p.m. No action was taken during Closed Session.

Possible Action Items as a Result of Closed Session

No action was taken during Closed Session.

Next Meeting

The next regular meeting will be held June 22, 2010 with a Study Session at 5:15 p.m. inWTC 141/142. The regular meeting will begin at 6:00 p.m. in WTC 117/119/121.

Adjournment

On a motion by Mr. Mike Olson, seconded by Mr. Randy Schaefer, and unanimous voicevote, the meeting was adjourned at 7:40 p.m.

Submitted by Ann Kerwitz

Mr. Michael D. Olson, Secretary Ms. Katherine M. Kelley, Chair

7/27/2019 BOT Packet 062210

13/258

15000000

20000000

25000000

30000000

Rock Valley Col legeDollars by Payroll Year-To-Date

07/15 07/31 08/15 08/31 09/15 09/30 10/15 10/31 11/15 11/30 12/15 12/31 01/15 01/31 02/15 02/28 03/15 03/31

FY 06 Paid - Year to Date 1000470.64 2001133.52 2838385.57 3753691.47 4717610.17 5749364.52 6780286.42 7794088.62 8824289.24 9832348 10835137.98 11797659.34 12726895.94 13901165.93 14867898.34 15874022.17 17028761.27 1804853

FY 07 Paid - Year to Date 1014568.53 2008995.39 2852696.07 3811859.76 4778975.01 5835519.68 6892211.64 7957847.53 9029761.41 10084606.74 11131144.66 12118527.61 13077189.11 14309154.92 15289706.2 16353229.63 17564350.74 1863825



FY 10 Budget Year to Date 1244562 2489124 3733686 4978248 6222810 7467372 8711934 9956496 11201058 12445620 13690182 14934744 16179306 17423868 18668430 19912992 21157554 224021


0

5000000

10000000

15000000

20000000

25000000

30000000

Rock Valley Col legeDollars by Payroll Year-To-Date

7/27/2019 BOT Packet 062210

14/258

7/27/2019 BOT Packet 062210

15/258

Rock Valley CollegeVital Signs-Payroll (Dollars)

Reviewed by: Sam Overton, 06/01/2010xplanation of major increases in Dollars by PayrollY 095/15/2009 50% Spring Overload $184,545

6/15/2009 Summer Interim I $132,481

6/30/2009 50% Summer School $357,353

Y 107/15/2009 NonContractualRaises; 25%SummerSchool$178,6777/31/2009 25%SummerSchool$178,6778/15/2009 Summer Interim III $56,759 (paid on 08/31 in FY08)

8/31/2009 Faculty Salary increases; begin Adjunct pay for Fall semester; Adjunct paid 4 weeks earlier than prior year

8/31/2009 Checkcountishigherthanpreviousyears'duetoAdjunctpaystarting4weekssooner(DatatelAssignmentContractandadditional1/31/2010 100% of Fall Overload $406,243; Spring Overload estimated at $455,254

1/31/2010 Begin Adjunct & Community/Continuing Ed Instructor pay in increase in payroll and check count

3/15/2010 50% Spring Overload $225,912, remainder due 05/15

5/15/2010 50% Spring Overload $223,693

5/31/2010 Check count is higher than previous years' due to Adjunct pay extending over 9 pay periods (Datatel Assignment Contracts)

ayroll Dollars (Cash Basis)

racking similar to previous years

Conclusion: Currently over budget, due to increased enrollment/credit hours instruc tor payroll

ay-07 FY 07 YTD is exceeding FY 06 YTD by about 4%; FY 07 YTD is 98% of straight line budget, with $536k toward Overload

un-07 FY 07 YTD is exceeding FY 06 YTD by about 3%; FY 07 YTD is 98% of straight line budget, with $514k toward Surplus

ay-08 FY 08 YTD is exceeding FY 07 YTD by about 5%; FY 08 YTD is 99% of straight line budget, with $178k toward Surpluun-08 FY 08 YTD is exceeding FY 07 YTD by about 5%; FY 08 YTD is 100% of straight line budget, with $71k toward Surplu

ay-09 FY 09 YTD is exceeding FY 08 YTD by 7%; FY 09 YTD is 102% of straight line budget, with ($546k) deficiun-09 FY 09 YTD is exceeding FY 08 YTD by 7%; FY 09 YTD is 103% of straight line budget, with ($805k) defici

ar-10 FY 10 YTD is exceeding FY 09 YTD by 7%; FY 09 YTD is 100% of straight line budget, with $46k positive variancpr-10 FY 10 YTD is exceeding FY 09 YTD by 7%; FY 09 YTD is 100% of straight line budget, with $11k positive varianc

ay-10 FY 10 YTD is exceeding FY 09 YTD by 7%; FY 09 YTD is 101% of straight line budget, with ($237k) deficit

7/27/2019 BOT Packet 062210

16/258

7/27/2019 BOT Packet 062210

17/258

7/27/2019 BOT Packet 062210

18/258

7/27/2019 BOT Packet 062210

19/258

7/27/2019 BOT Packet 062210

20/258

ROCK VALLEY COLLEGE

Vital Signs - Health Care Costs / BenefitsUpdated by Barb Woodsmall, HR, 6-9-10

Reviewed by Sam Overton, Admin, 06/09/2010

Health Care costs represent 87% or $5,987,459 of the $6,847,232 Total Benefits Expenditure

Other Benefits include Life Insurance, Employer FICA, Grant SURS, Tuition Waivers & Reimbursements,

Sabbatical, Wellness, Moving Expenses

These are the Health Care costs ONLY. In FY 10, we aggressive budgeted health cos ts to balance the budget.

Conclusion: Current month above target, YTD trend above budget

J une 2008 is below straight line budget, YTD Actual is below both the YTD Budget and below FY 07 YTD Actual

J une 2009 is above the straight line budget, YTD Actual is below the YTD Budget, but above FY 07 & 08 YTD Actual

February 2010 is below the straight line budget, YTD Actual is above the YTD Budget,

InFeb,wediscoveredwewerenotinlcudingtheHealthAdminfeeandhaveadjustedretroactively($512kAsofFebruary,wearestillowedstoplossreimbursements totaling$440k.If the stop loss reimbursement were received, we would be at the YTD Budget amount

March 2010 is below the straight line budget, YTD Actual is above the YTD Budget,

Stop Loss Reimbursement is still outstanding

April 2010 is below the straight line budget, YTD Actual is below the YTD Budget,

Stop Loss Reimbursement is received

May 2010 is above the straight line budget, YTD Actual is above the YTD Budget,

7/27/2019 BOT Packet 062210

21/258

7/27/2019 BOT Packet 062210

22/258

$4,000,000

$6,000,000

$8,000,000

$10,000,000

$12,000,000

$14,000,000

$16,000,000

$18,000,000

$20,000,000

Operating FundsNet Investments & Cash

July August September October November December January February March

FY 06 Operating Investments 7891911.08 7895000.41 7914538.22 7915833.64 9418888.71 9457219.27 9482137.37 9480931.12 9518815.72

FY 07 Operating Investments 9600183 9604784 9674584.06 11682294.02 11685290.43 11755545 11756221.2 11756223.72 11871545.14

FY 08 Operating Investments 12156736 12169453 12178422 12810521 12889232 12981815 12999592.25 13010592.52 13173111.12

FY 09 Operating Investments 13338516 13356126 13374504 13412250 13433325 13460406 13487318 13530590 13585940

FY 10 Operating Investments 13684849 13700117 13703865 13707203 13711565 13717639 13725285 13735894 13739584

FY 06 Operating Cash 7686792 7102193 11592499 10786654 7809666 9087607 7568172 4179249 5020551





$0

$2,000,000

$4,000,000

$6,000,000

$8,000,000

$10,000,000

$12,000,000

$14,000,000

$16,000,000

$18,000,000

$20,000,000

Operating FundsNet Investments & Cash

7/27/2019 BOT Packet 062210

23/258

7/27/2019 BOT Packet 062210

24/258

napshot - AXIS 225FD Network Camera

ttp://10.1.4.20/view/snapshot.shtml?picturepath=/jpg/image.jpg&timestamp=1276360559955&width=640 [6/12/2010 11:37:20 AM]

7/27/2019 BOT Packet 062210

25/258

7/27/2019 BOT Packet 062210

26/258

Localvs.NonLocalParticpation

Karl J.Jacobs CenterforScienceandMath

$18,321,735.00

82%

oca art c pat on

NonLocalParticpation

$4,070,673.0

18%

7/27/2019 BOT Packet 062210

27/258

7/27/2019 BOT Packet 062210

28/258

J une 12, 2010

Karl J. Jacobs Center for Science and Math

Milestones and expectations:

April 10 CLI Temp entrance/exit, temp pathway from Parking Lot 3 footbridge,Construction fencing, some tree removal, start excavation,

May 10 Concrete footings and foundation, continued excavation for Perimeter Roadconnection, New Parking Lot, additional tree removal (IN Bat habitat?), startstructural steel

May 20th Official Groundbreaking Ceremony

Thursday 10:00 AM, refreshment in ERC, Amcore Commons

Jun 10 Connecting road & new parking lot excavation & backfilling, geothermaldrilling (grant approved, City & County permits), structural steel (Phase I,

start Phase II), lower level plumbing, additional creek clean-up (treeremoval)

J uly 10 Geothermal drilling, structural steel (Phase II, start Phase III), lower level slab,connecting road and Parking Lot #6 curb and gutter

Aug 10 Geothermal drilling, structural steel (Phase III, penthouse), level 1 & 2 slab,framing, connecting road and Parking Lot #6 base layer of asphalt

Sept 10 Masonry, penthouse framing, Tyvek,

Sept 10 JCSM tour and celebration with cont ractors

Dec 10 Building enclosure, decision on Fall 2011 class locations

May-Aug 11 Parking Lot 3 to J CSM enhancements

J une 11 Substantial completion

August 11 Start of Fall Classes

Sept 11 Landscaping

7/27/2019 BOT Packet 062210

29/258

The FY Surplus List utilizes the next FY Budgeted items as the first and primary source for desired and prioritized

expenditures, such as equipment replacements or planned consultant efforts to improve operating efficiencies,those expenditures are pulled forward to expedite agreed upon initiatives and helps balance the next FY Budget.

Logical plan to spend down estimated FY 10 Surplus/Contingency:

Estimates /

P.O. Month P.O. $

IT Support VCX (telephone phase II invoiced in J uly) 09 Apr N 21,8

Facilities PEC Tunnel Remediation (Advantage Restoration) Sep G 12,6

Facilities PEC Tunnel Remediation (McDermaid Insulation) Sep H 15,6

IT/Student CDW-G (3Com Wireless Access Points) Sep I 17,4

Administration Gallagher/Liberty Mutual (Work Comp Audit Add'l Premium) Oct B 26,9

IT Support Entre Computers (HP Pro Curve Switches $ above budget) Oct E 35,3

IT Support VSD Technologies (Hitachi SAM Storage) Oct F 33,6IT/Student Datatel Licenses - additional seats for student registration support, scanning Nov A 20,8

Facilities SCCE Boiler Repairs Nov E 17,9

Facilities PEC Drainage Nov G 21,5

Academics Angel Software - new LearningCourse Management System Dec E 140,2

Academics SCCE Science Lab equipment & supplies - VWR Int'l Dec G 21,4

Academics SCCE Science Lab equipment & supplies - Fisher Scientific Dec H 11,6

Academics SCCE Science Lab equipment & supplies - Flinn Scientific Dec I 15,6

Facilities Electric Vault Relief Drain - Pkg lot 3 supporting SSB Dec J 10,9

Academics SCCE Science Lab computers - CDW-G Dec P 21,8

Academics/Admin X25 software - space utilization J an D 27,9

Comm Outreach CDW-G (10 Laptops for BPI) J an H 31,2

Inst./Student Perceptive Software - Digital Imaging Phase II Feb B 71,6

Inst./Academics Sherlock Systems - HP Blade Server (Sharepoint, Informer, Doc Imaging) Feb F 40,9Inst./Academics CDW-G - 360 PCs & 195 flat screens - FY 11 Computer replacements Mar B 363,4

Academics CDW-G - 47 laptop for SCCE computer lab and SCCE 141 - FY 11 replacem Mar C 59,2

Academics CDW-G - 15 computer lab printers - FY 11 replacements Mar D 20,8

Academics CDW-G - 27 smartroom data projectors - FY 11 replacements Mar E 21,7

Academics Apple - 20 iMac & 3 MacBook laptops - FY 11 replacements Mar F 35,2

Academics Apple - Editing Suite workstations for Mass Comm Not Approved Apr D -

Academics CDW-G - Thin Clients for CIS Division and replacements Not Approved Apr F -

IT Support SCCM PC Imaging software Not Approved Apr J -

IT Support Servers to run the SCCM PC Imaging software Not Approved Apr K -

IT Support HP ProCurve Switches for SCCE Not Approved Apr L -

IT Suppor t CDW-G Servers f or SCCM PC Imaging sof tware IT Budget Jun H -

Academics Msi - Thin Cl ients for CIS (WTC 220) Perkins Fund Jun J -

IT Support HP ProCurve Switches for SCCE IT Budget Jun K -

-

-

TOTAL Surplus/Contingency Expenditures Li st 1,117,9$

Rock Valley College

FY 10 Surplus List

During FY 06 we utilized a strategy to spend down the surplus in the amount of approximately $1,345k,




Prepared by: Sam Overton

Dated: 6/11/2010 Page 1 of 1 \\Vmsrvfileshares\common\ADSFIS\Sam\Financial Planning\FPM10\FY 10 Surplus List.xls\May 10 (Jun BoT)

7/27/2019 BOT Packet 062210

30/258

Rock Valley College

Freedom of Information Act (FOIA) Report

May 16, 2010 - June 15, 2010

DateReceived

FOIA # Requestor Request Result

5/18/2010 113 Robert Branda All documents in PublicSafety in which he isnamed

Redacted documentprovided for pick-up

J une 1.6/1/2010 114 Leslie Ellis,

ServiceEmployeesInternational

Union

For all RVC employees:Name; Home zip code;

J ob title; Work Location;Department; FT, PT,

Temp Status; Employeeorganization thatrepresents employees forcollective bargaining

6/2/10 providedspreadsheetelectronically withrequested informatio

7/27/2019 BOT Packet 062210

31/258

ROCK VALLEY COLLEGE Board Report #6711June 22, 2010

Claims Sheet #656

Recommendation: It is recommended that the Board of Trustees approve thefollowing claims sheets, from Datatel, dated May 31, 2010.The total is $2,596,380.23.

Jack Becherer, Ed.D.President

Attachments

Board Approval: ______________________________Secretary for Board of Trustees

7/27/2019 BOT Packet 062210

32/258

7/27/2019 BOT Packet 062210

33/258

7/27/2019 BOT Packet 062210

34/258

7/27/2019 BOT Packet 062210

35/258

7/27/2019 BOT Packet 062210

36/258

7/27/2019 BOT Packet 062210

37/258

7/27/2019 BOT Packet 062210

38/258

7/27/2019 BOT Packet 062210

39/258

7/27/2019 BOT Packet 062210

40/258

7/27/2019 BOT Packet 062210

41/258

7/27/2019 BOT Packet 062210

42/258

7/27/2019 BOT Packet 062210

43/258

7/27/2019 BOT Packet 062210

44/258

7/27/2019 BOT Packet 062210

45/258

7/27/2019 BOT Packet 062210

46/258

7/27/2019 BOT Packet 062210

47/258

7/27/2019 BOT Packet 062210

48/258

7/27/2019 BOT Packet 062210

49/258

7/27/2019 BOT Packet 062210

50/258

7/27/2019 BOT Packet 062210

51/258

7/27/2019 BOT Packet 062210

52/258

7/27/2019 BOT Packet 062210

53/258

7/27/2019 BOT Packet 062210

54/258

7/27/2019 BOT Packet 062210

55/258

7/27/2019 BOT Packet 062210

56/258

7/27/2019 BOT Packet 062210

57/258

7/27/2019 BOT Packet 062210

58/258

7/27/2019 BOT Packet 062210

59/258

7/27/2019 BOT Packet 062210

60/258

7/27/2019 BOT Packet 062210

61/258

7/27/2019 BOT Packet 062210

62/258

7/27/2019 BOT Packet 062210

63/258

7/27/2019 BOT Packet 062210

64/258

7/27/2019 BOT Packet 062210

65/258

7/27/2019 BOT Packet 062210

66/258

7/27/2019 BOT Packet 062210

67/258

7/27/2019 BOT Packet 062210

68/258

7/27/2019 BOT Packet 062210

69/258

7/27/2019 BOT Packet 062210

70/258

7/27/2019 BOT Packet 062210

71/258

7/27/2019 BOT Packet 062210

72/258

7/27/2019 BOT Packet 062210

73/258

7/27/2019 BOT Packet 062210

74/258

7/27/2019 BOT Packet 062210

75/258

7/27/2019 BOT Packet 062210

76/258

7/27/2019 BOT Packet 062210

77/258

7/27/2019 BOT Packet 062210

78/258

7/27/2019 BOT Packet 062210

79/258

7/27/2019 BOT Packet 062210

80/258

7/27/2019 BOT Packet 062210

81/258

7/27/2019 BOT Packet 062210

82/258

7/27/2019 BOT Packet 062210

83/258

7/27/2019 BOT Packet 062210

84/258

7/27/2019 BOT Packet 062210

85/258

7/27/2019 BOT Packet 062210

86/258

7/27/2019 BOT Packet 062210

87/258

7/27/2019 BOT Packet 062210

88/258

7/27/2019 BOT Packet 062210

89/258

7/27/2019 BOT Packet 062210

90/258

7/27/2019 BOT Packet 062210

91/258

7/27/2019 BOT Packet 062210

92/258

7/27/2019 BOT Packet 062210

93/258

7/27/2019 BOT Packet 062210

94/258

7/27/2019 BOT Packet 062210

95/258

7/27/2019 BOT Packet 062210

96/258

7/27/2019 BOT Packet 062210

97/258

7/27/2019 BOT Packet 062210

98/258

7/27/2019 BOT Packet 062210

99/258

7/27/2019 BOT Packet 062210

100/258

7/27/2019 BOT Packet 062210

101/258

7/27/2019 BOT Packet 062210

102/258

7/27/2019 BOT Packet 062210

103/258

7/27/2019 BOT Packet 062210

104/258

7/27/2019 BOT Packet 062210

105/258

7/27/2019 BOT Packet 062210

106/258

Report Date: 6/9/2010 Page 1 of

Checks Over $10,000 issued between 5/1/10 and 5/31/10

Month: 05/2010

Check No Check Date Check Amount Vendor

AA*0634982 5/6/2010 0316143 - BALLARD COMPANIES$13,472.50

Notes Board Report #6621, Dated 6/30/2009, Co-Gen Testing and Generator Asset Optimization Model - Fund 02 (Partial Payment).

AA*0635000 5/6/2010 0289599 - C D W GOVERNMENT$10,269.80

Notes Board Report #6621, Dated 6/30/2009, Miscellaneous IT Hardware and Software - Fund 01 (Partial Payment).

AA*0635014 5/6/2010 0310222 - CONSTELLATION NEW ENERGY$11,833.67

Notes Board Report #6621, Dated 6/30/2009, Electric Service, April 2010, SCCE - Fund 02 (Partial Payment).

AA*0635074 5/6/2010 0334253 - MECHANICAL$29,317.76

Notes Board Report #6621, Dated 6/30/2009, HVAC Boilerhouse Management and Service - Fund 02 (Partial Payment).

AA*0635075 5/6/2010 0289878 - MID CITY OFFICE PRODUCTS$11,621.08

Notes Board Report #6621, Dated 6/30/2009, Office Supplies, April 2010 - All Funds (Partial Payment).

AA*0635100 5/6/2010 0289925 - POSTMASTER$35,000.00

Notes Board Report #6621, Dated 6/30/2009, Mail Permit #4119 - Fund 01 (Partial Payment).

AA*0635105 5/6/2010 0331852 - ROBBINS, SCHWARTZ, NICHOLAS,$21,152.26

Notes Board Report #6621, Dated 6/30/2009, Legal Services Rendered - Funds 01, 12 (Partial Payment).

AA*0635125 5/6/2010 0373226 - SCOTT HEALTH SAFETY$19,980.24

Notes Board Report #6676, Dated 1/26/2010, SCOTT AIR-PAK 75 for Fire Safety Program - Fund 30.

AA*0635158 5/6/2010 0298197 - BANK AMERICA$60,279.88

Notes Board Report #6621, Dated 6/30/2009, Purchase Card Usage, April 2010 - All Funds (Partial Payment).


Notes Board Reports #6621 & #6693, Dated 6/30/2009 & 3/23/2010, Annual Computer Replacement and Miscellaneous IT Hardware andSoftware - Fund 01 (Partial Payment).


Notes Board Reports #6621 & #6693, Dated 6/30/2009 & 3/23/2010, Laptops and Miscellaneous IT Hardware and Software - Fund 01.

AA*0635536 5/20/2010 0332495 - KIMCO$32,412.55

Notes Board Report #6621, Dated 6/30/2009, May Cleaning Services - Fund 02 (Partial Payment).

7/27/2019 BOT Packet 062210

107/258

Report Date: 6/9/2010 Page 2 of

Checks Over $10,000 issued between 5/1/10 and 5/31/10

Month: 05/2010

Check No Check Date Check Amount Vendor

AA*0635615 5/20/2010 0313275 - SAAVEDRA GEHLHAUSEN$40,361.60

Notes Board Reports #6570 & #6621, Dated 1/27/2009 & 6/30/2009, Consultation for Parking Lots 2, 7, 8, JCSM and Various RVCProjects - Funds 02, 03 (Partial Payment).

AA*0635623 5/20/2010 0295189 - SJOSTROM SONS$790,803.83

Notes Board Reports #6631 & #6693, Dated 7/28/2009 & 3/23/2010, Foot Bridge Replacement and JCSM - Fund 03 (Partial Payment).

AA*0635669 5/27/2010 0289674 - CITY ROCKFORD$15,757.92

Notes Board Report #6639, Dated 8/25/2009, June Rent, 303 N Main St Location - Fund 06 (Partial Payment).


Notes Board Report #6621, Dated 6/30/2009, Electric Service, March 2010, Main Campus - Fund 02 (Partial Payment).


Notes Board Report #6621, Dated 6/30/2009, Electric Service, May 2010, SCCE - Fund 02 (Partial Payment).

AA*0635708 5/27/2010 0289733 - HMO ILLINOIS$55,329.88

Notes Board Report #6621, Dated 6/30/2009, June Premium, HMO Insurance - Fund 05 (Partial Payment).

Between 5/1/10 and 5/31/10: 18 checks totaling $1,627,157.96 out of $2,596,380.23 or 62.67%

7/27/2019 BOT Packet 062210

108/258


Purchase Report #634

Recommendation: Board approval for items marked with asterisk

A. Maintenance for Software (Education Fund Library, Maintenance Service SoftwareSupport)

ExLibris, Des Plaines, IL 39,000.00*(1)

(1) This yearly expense is from July 1, 2010 to June 30, 2011. This maintenance costcovers update, upgrade, and technical support from the company and covers thefollowing service:

1. Library automation system-Voyager

2. Annual license fee for OPAC (Online Public Access Catalog)3. Annual license fee for staff clients (staff module of circulation, serials,cataloging, statistics)4. Maintenance for Oracle which is the operation system that makes libraryautomation system work (like Windows for our computers)

B. Library System to Facilitate and Expand Access to and Delivery of InformationResources - (Education Fund Library, Other Contractual Services)

Lincoln Trail Libraries System, Champaign, IL 14,300.00*(2)

(2) This expense is from July 1, 2010 to June 30, 2011. ILLINET/OCLC (IllinoisNetwork for the library/Online Computer Library Center) charges for Cataloging andMetadata, Resource Sharing and Interlibrary Loan, Digital Collection Services, Referenceand Collection Analysis and Custom Quote Services. OCLC has been providing thecataloging information about the books throughout the world (WorldCat) and ILLINET isthe major force of Interlibrary

C. Reimbursement - (Auxiliary Enterprises Fund - Global Trade Park, PublicSrv/Customized Training)

Ring Container, Rockford, IL 12,934.00*(3)

(3) Reimbursement for Global Trade Park dollars that remained open at the end of lastyear. The Director of City Services instructed BPI to refund all the remaining dollars toRing Container. The City will pay Rock Valley $14,934 which includes a $2,000administrative fee for RVC.

7/27/2019 BOT Packet 062210

109/258


Purchase Report #634/2

D. RX3600 Server - (Education Fund IT-Administration, IT Capital Equipment)

Logicalis, Lisle, IL 55,682.49*(4)

(4) Only one bidder responded to the bid. This is a refurbished server that is replacingthe RP3440 which is critical to running all the campus systems. This is an FY11 expense.

E. Building Information Modeling (BIM) (Operations and Maintenance - Restricted Fund Science & Math Building, Professional Services)

Mechanical Incorporated, Freeport, IL 12,640.00*(5)

(5) Building Information Modeling (BIM) is an integrated process that vastly improves

project understanding and allows for predictable outcomes. It helps to ensure projectsuccess by enabling all project team members to stay coordinated, improve accuracy,reduce waste, and make informed decisions. It contributes to clear, conciseunderstanding between architects, engineers, construction professionals, facilitymanagers, and owners.

The following items will be included in the BIM model:

Complete model of the structural steel to be used to facilitate building coordination. Complete model of the reflected ceiling plan. Incorporating 2D fire protection coordinated drawings supplied by Absolute Fire

Protection.

Incorporating 2D electrical and cable tray coordinated drawings supplied by SpecialPower. Conduit runs 2 and less will be excluded from the model. Utilizing BIM to run clash detection between all MEP systems, including the above,

to facilitate precise and prompt coordination of trades. Utilizing BIM to run clash detection between all MEP systems, including the above,

against the building structural steel and ceilings to facilitate precise and promptcoordination of trades.

The A&E fees to complete the BIM model will be paid from the JCSM contingency notthe Sjostrom and Sons project contingency.

F. Inspection and Maintenance - (Auxiliary Enterprises Fund Starlight 2010, Other

Contractual Services)

Uni-Systems LLC, Minneapolis, MN 10,600.00*(6)

(6) Yearly inspection and mandatory maintenance for the BST roof system.

7/27/2019 BOT Packet 062210

110/258



G. SCCE Parking Lot Expansion and Campus Parking Lot Renovation (Operations andMaintenance - Restricted Fund - SCCE Visioning - Phase II&III, Site Improvements)

Stenstrom Companies, Rockford, IL 448,850.00*(7)William Charles Construction, Loves Park, IL 448,880.29Northern IL Service Co, Rockford, IL 479,363.00Larson & Larson, Loves Park, IL 515,970.00Sjostrom & Sons, Rockford, IL 535,478.00

(7) SCCE currently has four hundred sixteen (416) parking stalls ten (10) of which, areADA stalls. In an effort to eliminate the parking congestion, we propose adding a one-hundred and thirty four (134) stall parking lot to the east of the building. Twenty five (25)of these stalls will be gated parking for faculty and staff. The proposed site of the parking

is currently mowed lawn between the building and Jefferson High Schools soccer field.

The SCCE parking lot expansion project will consist of adding a new blacktop parkinglot with gated parking and widening of the existing road that currently functions as a passthrough from the main parking lot to the parking lot located at the back of the building.We will also extend the existing sidewalks from the east side of the building to theexisting road. This portion totals $374,850 including $60,000 contingency.

The second piece to this project is parking lot renovation at the main campus and theSCCE. Areas in Parking Lot 1, 8a, 8b, perimeter road and the parking lot at the SCCEwill be cut out and replaced. These repairs are a short term fix until the parking lots canbe completely removed and replaced. Areas in Parking Lot 3 & 4 will have crackscleaned and filled. This portion totals $74,000 including $20,000 contingency.

Due to the number of summer projects currently in progress and internal staff changes theCollege desires to award the contract to the overall low bidder, Stenstrom.

H. Servers for SCCM (Education Fund IT-Administration and Academic, IT CapitalEquipment

CDW-G, Vernon Hills, IL 20,992.00*(8)

(8) Two Servers to run System Center Configuration Manager (SCCM) providingorganizations end-to-end visibility across the software purchase, deployment, usage andcompliance cycle. Included in budget for FY10.

7/27/2019 BOT Packet 062210

111/258



I. Consultant Services (Restricted Purpose Fund - Prof/Tech: DCEO Entrepreneurship,Consultant Srvs)

Management Resource Services, Rockford, IL 18,125.00*(9)

(9) Blanket purchase order for RRVEC director from 7/1/10 through 9/30/10.

J. HP Citrix Servers (Education Fund IT-Academics, IT Capital Equipment)

Msi, Peoria, IL 25,820.22RK Dixon, Davenport, IA 25,840.88*(10)Sherlock System, Buffalo Grove, IL 29,060.00Netrix, Bannockburn, IL 29,426.00

EDC Systems 31,246.00Twotrees Technology, Wichita, KS 32,785.38CDW, Lake Forest IL 33,330.00Integreat Technology, Carol Stream, IL 35,336.00EZClover, Stratford, CT 35,490.00

Not approved HP VendorsDell, Round Rock, TX 20,437.72

(10) These Citrix Servers will manage the thin clients which will be installed in WTC220. Perkins funds will support $10,000 of this purchase; the rest of the cost comes fromFY10 IT budget. Msi withdrew their bid due to pricing change.

K. HP ProCurve Switches for SCCE (Education Fund IT-Administration, IT CapitalEquipment)

CDW-G, Vernon Hills, IL 59,632.00*(11)Entre, Machesney Park, IL 59,765.18Artemis, Itasca, IL 64,232.10EDC Systems 64,935.00Ginn Telecom, Carlsbad, CA 74,614.02IPC, Rockford, IL 78,765.07Balanced IT 78,949.93

Not approved HP VendorsStewart Staffing, New Rochelle, NY 51,292.00Northland Systems 52,791.00SCW, Marietta, GA 56,121.19

(11) Replacement of 17 old 3Com network switches with new HP switches in order toimprove network performance and management at Stenstrom Center for CareerEducation. Reallocation of the FY10 IT Budget

7/27/2019 BOT Packet 062210

112/258



L. Building F Silo Restoration and Bldg G Siding Replacement (Operations andMaintenance - Restricted Fund Bldg F Silo/Bldg G, Remodeling - Prof Services)

Larson & Larson, Loves Park, IL 145,474.00*(12)Sjostrom & Sons, Rockford, IL 160,200.00Swanson Construction, German Valley, IL 171,075.00Stenstrom Construction, Rockford, IL 171,260.00

Noncompliant BidBig Foot Construction, Chicago, IL 90,500.00

(12) There are several areas around the silo of Building F that are experiencing waterintrusion due to the deterioration of the silo. The following repairs will be made to restore

the silo: Sandblast silo removing current paint and caulk. Silicone caulk all joints. Paint silo using Dow All-guard, silicone based paint. Replace shingles on silo roof. Remove ladder enclosure, seal areas where enclosure meets roof and silo, and re-

install enclosure

The scope of Building G siding replacement would include the demolition of thegreenhouse, a complete removal of existing siding, gutters, fascia and flashing. Newplywood sheathing, board insulation, air infiltration barrier and fiber-cement siding will

be installed on the entire building. All fascia board and trim will be replaced along withnew gutters and flashing.

Big Foot Construction has been in business for nine months which does not meet thethree-year experience requirement for installation of fiber cement siding as indicatedwithin the bid specification; this information would eliminate their bid.

M. Addendum To Purchase Order B5164 Plant Operations and Maintenance (Operations &Maintenance Fund various accounts)

Stillman Valley Nursery, Stillman Valley, IL 2,979.50*(13)

Original Amount 7,500.00Addendum 2,979.50

New Total $10,297.50

(13) The additional costs include spring cleanup, fertilizing service, seed and Junemowing.

7/27/2019 BOT Packet 062210

113/258



N. Addendum To Purchase Order B5101 Human Resources (Auxiliary Enterprises Fund Benefits, Ins - Health HMO IL)

HMO Illinois, Chicago, IL 40,000.00*(14)

Original Amount 325,000.00Previous Addendum 265,000.00New addendum 40,000.00

New Total $630,000.00

(14) The increase to cover increased enrollment in FY10.

O. Addendum To Purchase Order B5164 Plant Operations and Maintenance (Operations &Maintenance Fund Boiler House, Maintenance Srvs PlantOpEquip)

Miller Engineering, Rockford, IL 17,975.92*(15)

Original Amount 9,500.00Addendum 17,975.92

New Total $27,475.92

(15) Miller is a unit bidder. This expenditure is for repairs for HVAC. This is labor andmaterial to install two chilled water pumps in the boiler house which were furnished byRVC.

Dr. Jack Becherer, Ed.D.President

Board Approval: ____________________________________Secretary Board of Trustees

7/27/2019 BOT Packet 062210

114/258

7/27/2019 BOT Packet 062210

115/258



Budget Area & Acct. Number Budget Amount

MARKETING

01 83010 Advertising 125,000.00*Rockford Register StarCumulus BroadcastingWIFR-TV23WREX TelevisionWTVO TVWQRF TVComcastLamar Outdoor Advertising

Charter Cable

INFORMATION TECHNOLOGY

01 88000 Contractual Services 208,000.00*Datatel Hewlett PackardCDW-GLogicalisDLT SolutionsPerceptive SoftwareMoran TechnologiesImprivataCollegenetJamie Brannen

01 88000 Equipment 30,000.00*CDW-GThe Apple Store

01 88000 Software 25,000.00*Datatel

01 88000 Materials 35,000.00*CDW-GCommunication Supply Corp.

01 88000 Capital Outlay 165,000.00*CDW-GThe Apple StoreEntre

7/27/2019 BOT Packet 062210

116/258





01 24000 Contractual Services 190,000.00*CDW-GANGEL/BlackboardDatatel

01 24000 Software 25,000.00*Datatel

01 24000 Equipment 10,000.00*

The Apple StoreCDW-G

01 24000 Materials 15,000.00*CDW-G

SUCCESS CENTER

01 32700 Testing Center 25,000.00*CollegeBoard

HUMAN RESOURCES

01 84100 Employee Recruitment Advertising 25,000.00*Rockford Register Star

01 84100 Legal Services 89,000.00*Robbins, Schwartz, Nicholas, Lifton

01 86000 Legal Services 30,000.00*Kostantacos Law Firm

BUSINESS SERVICES

01 84500 Office Supplies 150,000.00*Mid City

01 86082 Copier Chargeback 290,000.00*IKON

01 86087 Cellular Phones 34,000.00*Verizon

7/27/2019 BOT Packet 062210

117/258




BUSINESS SERVICES

01 84900 Other Contractual 650,000.00*Bank of America (P Card Program)

MAIL AND DISTRIBUTION

01 86085 Supplies 148,000.00*IKONScantron CorporationApperson

MidCity

01 86085 Maintenance Services 14,600.00*Pitney BowesVideo Jet

01 86085 Postage 285,000.00*PostmasterUPSMidwest MailworksPitney Bowes Reserve AccountFedex

PRINT SERVICES

01 86086 Rental-Equipment 70,000.00*Xerox Color

OPERATIONS AND MAINTENANCE FUND


02 88200 Contractual 15,000.00*CDW-G3Com

02 88200 Telephone 200,000.00*AT&TVerizon NorthComcast CableAccess2GoICN/CMS

7/27/2019 BOT Packet 062210

118/258




PLANT OPERATIONS & MAINTENANCE

02 71000 Uniform Services 11,500.00*Aramark

02 72000/79070 Maintenance Services 432,500.00*Schumacher Elevator ServiceKimcoSkyline Windows

02 72000/76100/79050 Maintenance Supplies 122,800.00*

Helsley SupplyQuality MatsRichard HauriganSteiner ElectricEESCO

02 75000 Maintenance Supplies 52,200.00*Smith OilExxon MobilB.P.R J Daniels

02 76100/79250/79070 Maintenance Services 284,284.00*Ballard ElectricRush PowerSimplex GrinnellMechanical IncAutomatic FireNational International Roofing

02 76100/79050 Utilities 1,202,000.00*Commonwealth EdisonNICORCity of RockfordRock River Water ReclamationConstellation New Energy Gas/ElectricRock River DisposalPaper Recovery

7/27/2019 BOT Packet 062210

119/258




PLANT OPERATIONS & MAINTENANCE

02 79050/79070 Maintenance Services 59,500.00*Morgan CleaningStillman Valley Nursery

02 71000 Contractual Service (Unit Bid) 75,000.00*Ron Carlson ElectricMiller Engineering

02 78100/03 79000 Protection Health Safety and Bond 44,000.00*

Saavedra Gehlhausen ArchitectsReister EngineeringFurst StaffingCarnow Conibear

AUXILIARY ENTERPRISES FUND

TRAFFIC SAFETY

05 44278 Instructional Supplies 100,000.00*National Safety Council

CENTER FOR LEARNING IN RETIREMENT

05 44287 Contractual Services 19,000.00*Van Galder Bus CompanyRockford Charter Coach

BUSINESS OUTREACH PROGRAMS

05 42775/42776 Manufacturing Tech 31,000.00*Pam Scantlin

05 42776 Vendor Training Alliances 52,000.00*Lydell ManningPremier Training & Consulting LLCSoftley, Inc

7/27/2019 BOT Packet 062210

120/258




AUXILIARY ENTERPRISES FUND

CONTINUING EDUCATION

05 41015 Vendor Training Alliances 50,000.00*Education to GoGatlin Education ServicesProtrain LLC

HUMAN RESOURCES

05 86700 Supplemental Life 50,000.00*Arthur J Gallagher & Co

05 86700 Insurance Health HMO IL 630,000.00*HMO Illinois Inc.

05 86700 Insurance Long Term Disability 38,000.00*Reliance Standard

RESTRICTED PURPOSE FUND

06 42211 Consultant Srvs 27,250.00*Ann E Johns

LIABILITY, PROTECTION & SETTLEMENT FUND

12 86220/86230 Property & Casualty 341,158.50*R J Galla

12 86230 Legal Services 28,000.00*Kostantacos Law Firm

12 86250 Unemployment Insurance 50,000.00*IL Dept of Employment Security

12 86260 Athletics Insurance 39,170.00*First Agency Inc

7/27/2019 BOT Packet 062210

121/258



DEPARTMENT OF PUBLIC SAFETY

12 74000 Contractual Services 33,800.00*Lexis Nexis PeoplewiseCommunications Revolving FundA-Fire Extinguisher

12 74000 Other Supplies 15,000.00*Uniform Den East

12 74000 Other Materials 18,000.00*Anixter, IncExline Signal

12 74000 Other Capital Outlay 30,000.00*ITG Solutions, Inc

7/27/2019 BOT Packet 062210

122/258

Rock Valley College Board Report #6713

June 22, 2010

Personnel Report #624

Recommendation: The Board of Trustees acknowledges the following personnel actions:

A.

APPOINTMENTS.

#Jeremy Chamberlain (0418275), Faculty, Mathematics, full-time with benefits, Lane IV,Step 1, effective August 21, 2010, $47,763/9 months, account # 01-11660-51310 (vacancydue to retirement).

Paul Gunsul (0404036), Faculty, Mathematics, full-time with benefits, Lane VII, Step 2,effective August 21, 2010, $51,402/9 months, account #01-11660-51310 (vacancy due toresignation).

#Jeannette Mays (0144782), Administrative Assistant I, Aviation Maintenance, grade 6, part-

time without benefits, (SURS), effective May 17, 2010, $12.50/hour, account #01-13200-51620 (vacancy due to resignation).

#William Starks, Officer, Public Safety, grade 9, part-time without benefits, $15.11/hour,effective June 14, 2010, account # 12-74000-51630.

B. TEMPORARY APPOINTMENT, FALL 2010 SEMESTER.#Brian Wagner (0417921), Philosophy Instructor, Social Science and Humanities, full-timewithout benefits, (SURS), Lane II, Step 1, effective August 21-December 17, 2010,$21,001/semester, account #01-11400-51370 (vacancy due to sabbatical).

C. PROMOTION.Milana Caruthers (0078993), from Coordinator, Financial Aid, grade 11, to Manager,Financial Aid, grade 13, full-time with benefits, $45,653/year, effective July 1, 2010, account#01-34000-51210.

D. RESIGNATIONS.Michael Lambrecht (0188718), Director of Compensation, Benefits and Employee Relations,effective June 30, 2010.

Mark Maneval (0397279), Associate Dean, Fitness, Wellness and Sport, effective June 15,2010.

E. RETIREMENT.Suzanne Berger (0282566), Vice President, Institutional Advancement, Executive VicePresident, Rock Valley College Foundation, effective October 31, 2010.

7/27/2019 BOT Packet 062210

123/258

Board Report #6713/2PR #624

June 22, 2010

F. SALARY LANE CHANGES.Amanda Benney (0102327), Faculty, Speech, from Lane II, Step 10, to Lane III, Step 10,$53,779/9 months, due to completion of graduate credit, effective Summer 2010.

Sharon Cooper (0152123), Faculty, Business, from Lane IV, Step 11 to Lane V, Step 11,$59,625/9 months, due to completion of graduate credit, effective Summer 2010.

G. TRANSFERS.Patti Linden (0139535), from Counselor, Advising/Counseling, to Director of StudentDevelopment, Student Development, grade 14, full-time with benefits, no change in grade orsalary, effective July 1, 2010, account #01-39200-51210.

Michael Youngblood (0002663), from Interim Associate Dean, Social Science and

Humanities, to full-time faculty, Economics, $85,775/9 months, effective August 16, 2010,account #01-11400-51310.

H. REVISION, BR #6709, PR #623, ITEM B.Should Read:

Michael Phillips (0403243), Director, Facilities Planning, Plant Operations & Maintenance,effective June 30, 2010.

I. REVISION, BR #6661, PR #616, ITEM F.EXTENSION OF APPOINTMENT.

Michael Youngblood (0002663), Interim Associate Dean, Social Science and Humanities,grade 18, account #01-28430-51110, effective August 13, 2008 June 30, 2010, is extendedthrough August 15, 2010 at the current salary.

Jack J. Becherer, Ed.D.President

#Biographical Sketch Attached.

7/27/2019 BOT Packet 062210

124/258

Board Report #6713/3PR #624

June 22, 2010

BACKGROUND INFORMATION:

Jeremy Chamberlain has a Bachelor of Science in Physics, a Master of Science inMathematics, and is pursuing his PhD in Mathematics. He has served as a teaching assistant at

NIU, as adjunct for Waubonsee Community College, and in a staff position at the FermiNational Accelerator Laboratory. He joins us with both teaching and applied experience inMathematics.

Jeannette Mays flies into the Aviation maintenance Technology Program as the administrativeassistant. Jeannettes 22 years of office experience in manufacturing, real estate, and educationhave given her the training to maintain a professional and positive attitude.

William Starks is a 1982 graduate of Rockford East High School and a U.S. Marine CorpReserve veteran. He is currently employed with the Winnebago County Sheriffs office as aCorrections Officer.

Brian Wagner received his Bachelors degree in Philosophy in 2007, and Masters degree inPhilosophy in 2009 from Northern Illinois University.

7/27/2019 BOT Packet 062210

125/258

C:\Documents and Settings\e0122697\Desktop\Board\June 22 2010\2010-06-22 (BR 6714) Tentative Budget For FY2011.docx Page 1 of 16/17/2010

Rock Valley College Board Report #6714

June 22, 2010

TENTATIVE BUDGET FOR FY 2011

Background: The Tentative Budget for Fiscal Year 2011 is submitted with this report, as part of theFinancial Planning Model (FPM 11).

As requested, the FY 11 Operating Budget is balanced. There are explanations of therisks and opportunities associated with this budgeting process which will requirereporting either on a quarterly basis with the Financial Report or on an as needed basis.

FY 11 operating revenues and expenditures represent an 11% increase over the FY 10budget numbers.

FY 11 revenues total $68.5million, up almost $9.9 million over FY 10 Budget including a$4.6 million increase in Federal (Student Financial Aid) revenue and a $3.3 millionincrease in Student Tuition and Fees and enrollment growth. In addition, State Revenueincludes $3.5 million State on Behalf of SURS, $1.4 million CPPRT reclassified to Local

Revenues with a zero (-0-%) equalized assessed valuation growth.

FY 11 Payroll grew by $1.5 million ($900k raises, $400k new positions, and $200kadditional adjuncts) Benefits grew by $3.9 million ($3.5 million State on behalf of SURSand $400k increase in health care claims) and Financial Aid grew by $4.6 millionallowing for little or no growth in other expenditure areas (utilities, contractual sourcesand general materials and supplies). The new Learning & Opportunities Center isincluded by reducing consulting services and small operating capital outlay budgets.

The Capital Budget consists of bond principal and interest payments, Life Safety projectsand the JCSM project. Approved capital project expenditures are $20 million mainly

from Capital Bonds.

Recommendation: It is recommended that the Board of Trustees review the tentative budget and submit anyquestions to Mr. Sam Overton or President Jack Becherer. The public hearing will bescheduled for 6:00 p.m. on August 24, 2010.

Jack Becherer, Ed.D.President

Attachment: Final Financial Plan Model FYs 11, 12, 13 including the Tentative Fiscal Year 2011Budget (35 pages)

Board Approval: _____________________________Secretary Board of Trustees

7/27/2019 BOT Packet 062210

126/258

3301 North Mulford Road

Rockford, IL 61114

State of Illinois

Community College District 511

Financial Plan Model FYs 11, 12, & 13

Rock Valley College

FINAL

FPM11-FINAL-06162010.xlsx\Cover

Prepared by: Cynthia Haggard

Director of Financial Services

Presented by: Sam E. Overton, J r.

VP of Administrative Services & Treasurer

Dated: J une 16, 2010

Public Hearing by the Board of Trustees: August 24, 2010

Fiscal Year 2011 BudgetBeginning J uly 1, 2010 - Ending J une 30, 2011

Submitted to the Board of Trustees: J une 22, 2010

FPM11-FINAL-06162010.xlsx\Cover

7/27/2019 BOT Packet 062210

127/258

Page #

Cover Sheet 1Table of Contents 2All Funds Review

Net by Fund by Year 3Chart - Operating Net 4Comparison Year by Year 5Financial Planning Model and FY 11 Budget Processes 6

Operating FundsFPM-Operating 7Revenue Comparison by FY 8Graph - Operating Revenue by Source 9Revenue Explanation 10Expenditure Comparison by FY 11

Graph - Object Expense by Source 12Expenditure Explanation 13Graph - Function Expense by Source 14Local Government - Equalized Assessed Valuation w/ Graph 15-16Property Tax Rate graph 17Credit Hours by Year and Tuition Calculation w/ Graph 18NEW Positions FY 11 19Payroll Comparison 20Benefits Calculation 21

Capital FundsFPM-Capital 22

Large Capital Projects for tracking purposes 23Capital Expenditures Detail by Project 24Proposed Levy Year Bond Debt Chart 25Actual Fiscal Year Bond Debt Chart 26Bond Debt Data 27

Trust & Agency FundsFPM-Trust & Agency 28Student Activity Fee Budget Comparison 29

ICCB Official documents 30Supporting documentation by Fund with Fund 01 details 31-33

FY 11 Budget 34-35

Table of Contents

Rock Valley CollegeStatement of Revenues and Expenses (Budgetary)

Page 2 of 35 FPM11-FINAL-06162010.xlsx\Contents

7/27/2019 BOT Packet 062210

128/258

7/27/2019 BOT Packet 062210

129/258

Rock Valley College FPM11-FINAL-06162010.xlsx

1,000,000

2,000,000

3,000,000

4,000,000

5,000,000

RockValleyCollegeOperatingFundsNetbyYear

Page 4 of 35 FPM11-F

(5,000,000)

(4,000,000)

(3,000,000)

(2,000,000)

(1,000,000)

7/27/2019 BOT Packet 062210

130/258

FY 2005 FY 2006 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011Actual Actual Actual Actual Actual Budget Budget

Revenue 59,584,562 61,730,435 66,056,475 66,446,958 70,606,935 100,991,114 81,601,028Expense 68,317,913 59,700,510 62,584,848 64,509,021 69,704,686 85,899,334 106,987,254Contingency - - - - - - -Net (8,733,351) 2,029,926 3,471,627 1,937,937 902,249 15,091,780 (25,386,226)

Ftnd Balance 156,285,948 50,796,055 54,267,651 56,205,588 57,107,837 72,199,617 46,813,391Cash 13,339,310 13,471,402 11,196,029 19,160,802 14,147,174 - -Investments 20,818,263 25,335,155 26,384,937 29,620,835 26,878,787 - -


Revenue 49,523,759 51,976,559 53,583,936 55,955,834 60,490,421 58,634,006 68,553,482Expense 48,045,288 49,894,066 53,159,124 54,813,603 59,953,329 58,630,008 68,540,240Contingency - - - - - - -Net 1,478,471 2,082,493 424,812 1,142,231 537,092 3,998 13,242

Ftnd Balance 13,378,598 14,103,349 14,528,161 15,670,392 16,207,484 16,211,482 16,224,724

COMPARISON

Total (ALL Ftnds)

Operating (01, 02, 05, 06, 11, & 12)

Page 5 of 35 FPM11-FINAL-06162010.xlsx\Comparison

Cash 7,983,231 6,584,234 4,324,902 6,216,001 5,527,983

Investments 5,445,987 9,451,765 12,099,314 11,778,439 11,975,734


Revenue 8,451,105 8,014,879 10,001,450 9,527,989 9,701,756 40,762,193 11,410,045Expense 19,216,472 8,726,013 7,828,092 8,020,410 8,502,698 25,709,685 37,082,563Contingency - - - - - - -Net (10,765,367) (711,134) 2,173,358 1,507,579 1,199,058 15,052,508 (25,672,518)

Ftnd Balance 29,935,634 29,237,272 31,410,630 32,918,209 34,117,267 49,169,775 23,497,257Cash 4,679,289 6,197,521 6,082,785 12,035,903 7,583,394

Investments 9,329,560 9,019,171 6,729,367 11,041,729 8,980,480


Revenue 1,609,696 1,738,984 2,471,089 963,135 414,758 1,594,915 1,637,501Expense 1,056,151 1,080,430 1,597,632 1,675,008 1,248,659 1,559,641 1,364,451Contingency - - - - - - -Net 553,545 658,554 873,457 (711,873) (833,901) 35,274 273,050

Fund Balance 6,796,849 7,455,403 8,328,860 7,616,987 6,783,086 6,818,360 7,091,410Cash 676,790 689,647 788,342 908,898 1,035,797 - -Investments 6,042,716 6,864,219 7,556,256 6,800,667 5,922,573 - -

Capital (03, 04, 08, & 09)

Trust & Agency (10 & 30)

Page 5 of 35 FPM11-FINAL-06162010.xlsx\Comparison

7/27/2019 BOT Packet 062210

131/258

FY 2011 Budget Process:The Financial Planning Model (FPM) utilizes the Strategic Planning Initiatives to provide

the new College Initiatives, thenThe FPM is developed using a Bottom-Up approach

Summarized Global calculations

Revenues - Local Property Tax, State Government, Federal Government, Tuition & Fees

This process is not a Rollover Budgeting process. Each new position is evaluated againstthe College Mission, Goals and Initiatives, then prioritized before inclusion.

These details were reviewed by the appropriate Dean and/or Leadership Team Member and

summarized for this FY 11 Tentative Budget

This Bottom-Up approach requests Budget Officers to provide line item detail for each

Department/Function of their responsibility, including explanations of increases or

decreases from prior years

As requested, we are presenting an FY 2011 balanced operating budget. Included are

explanations of the associated risks and opportunities.The FY 2011 Capital Budget Detail by Project is also included.

Page 6 of 35 FPM11-FINAL-06162010.xlsx\Words

Expenditures - estimated Payroll, Benefits, Utilities and Student Financial Aid Expenditures

Revenue % comparison provides a reasonableness testA consistent and detailed approach to revenue projection

Expense % comparison provides a reality check

Better expenditure controls (checks and balances) on expensesDatatel can provide object line control on requisitions, if desiredMonthly Checks over $10,000 trace to approved Purchase Reports

Continued refinement for requesting new or replacement EmployeesSign-off process, tracing to Budget for Full-time, Part-timeTemporary and Student Workers

RISKS:

A 0% (nil) Equalized Assessed Valuation growth is budgeted

An 8% Enrollment (credit hour) growth is budgetedState of Illinois Operating Budget funding levels for Higher Education

Payroll, but mainly Benefit (Health Claims) expenses exceeding budget parameters

Contingency(s) budget has been reduced to $-0-

OPPORTUNITIES:

Review underperforming areas for internal reallocation to higher prioritiesFuture Tuition increases can be allocated to higher priority initiatives

Page 6 of 35 FPM11-FINAL-06162010.xlsx\Words

7/27/2019 BOT Packet 062210

132/258

7/27/2019 BOT Packet 062210

133/258

Rock Valley CollegeStatement of Revenues

OPERATING (01, 02, 05, 06, 11, 12)Actual Actual Budget Budget %

Revenues by Source FY 08 FY 09 FY 10 FY 11 Rev 08/09 09/10 10/1

41 Local Government 19,515,054 23,002,024 21,430,413 22,316,048 33% 18% -7% 442 State Government 12,070,544 10,311,868 10,047,883 10,839,716 16% -15% -3% 8

43 Federal Governmental 8,567,536 10,216,604 9,687,526 15,023,582 22% 19% -5% 5544 Student Tuition & Fees 12,048,724 13,734,368 13,555,768 16,949,605 25% 14% -1% 2545 Sales & Services Fees 1,606,465 1,393,993 2,312,836 1,909,060 3% -13% 66% -1746 Facilities Revenue 200 - - - 0% 0% 0% 047 Investment Revenue 931,646 384,516 337,000 141,341 0% -59% -12% -5848 Gifts, Grants, & Bequests 238,012 207,948 151,100 151,100 0% -13% -27% 049 Other Sources 977,653 1,239,100 1,111,480 1,223,030 2% 27% -10% 10

Total Revenues 55,955,834 60,490,421 58,634,006 68,553,482 100% 8% -3% 174.4% 8.1% -3.1% 16.9%

CAPITAL (03, 04, 08, 09)Actual Actual Budget Budget %

Revenues by Source FY 08 FY 09 FY 10 FY 11 Rev 08/09 09/10 10/1

41 Local Government (11,639,381) 9,253,074 10,289,193 10,602,288 93% -179% 11% 342 State Government - - - - 0% 0% 0% 043 Federal Governmental - - - 413,211 4% 0% 0% #DIV/44 Student Tuition & Fees - - - - 0% 0% 0% 045 Sales & Services Fees - - - - 0% 0% 0% 046 Facilities Revenue - - - - 0% 0% 0% 047 Investment Revenue 666,614 379,687 223,000 144,546 1% -43% -41% -3548 Gifts, Grants, & Bequests 582,851 - 250,000 250,000 2% 0% #DIV/0! 049 Other Sources 19,917,905 68,995 30,000,000 - 0% -100% 43381% 0

Total Revenues 9,527,989 9,701,756 40,762,193 11,410,045 100% 2% 320% -72-4.7% 1.8% 320.2% -72.0%

TRUST & AGENCY (10 & 30)Actual Actual Budget Budget %Revenues by Source FY 08 FY 09 FY 10 FY 11 Rev 08/09 09/10 10/1

41 Local Government - - - - 0% 0% 0% 042 State Government - - - - 0% 0% 0% 043 Federal Governmental - - - - 0% 0% 0% 044 Student Tuition & Fees 281,750 285,441 242,129 275,717 17% 1% -15% 1445 Sales & Services Fees 5,156 1,831 22,102 17,450 1% -64% 1107% -2146 Facilities Revenue - - - - 0% 0% 0% 047 Investment Revenue (248,779) (909,939) 318,810 368,464 23% 266% -135% 1648 Gifts, Grants, & Bequests 550,843 621,971 645,074 611,070 37% 13% 4% -549 Other Sources 374,165 415,454 366,800 364,800 22% 11% -12% -1

Total Revenues 963,135 414,758 1,594,915 1,637,501 100% -57% 285% 3

-61.0% -56.9% 284.5% 2.7%

Inc/Dec over prior yea



Page 8 of 35 FPM11-FINAL-06162010.xlsxRevenues

7/27/2019 BOT Packet 062210

134/258


10%

15%

20%

25%

30%

35%

40%

OperatingRevenuebySourceasa%ofTotal

Page 9 of 35 FPM11-FI

FY2003 FY2004 FY2005 FY2006 FY2007 FY2008 FY2010

LocalGovernment 35% 35% 32% 33% 35% 35% 37%

StateGovernment 21% 22% 21% 22% 21% 22% 17%

FederalGovernment 16% 14% 17% 15% 14% 15% 17%

StudentTuition&Fees 21% 22% 22% 22% 23% 22% 23%

Sales&ServiceFees 5% 4% 4% 4% 3% 3% 4%

InvestmentRevenue 1% 0% 0% 1% 1% 2% 1%

OtherRevenue 2% 3% 3% 2% 1% 2% 2%

0%

5%

7/27/2019 BOT Packet 062210

135/258

Rock Valley CollegeStatement of OPERATING Revenues (Budgetary)

FY 2008 FY 20Actual Actua

41 Local Government 19,515,054 23,002

105% 1

Economic Assessed Valuation (EAV) roughly 1/3 Fair Market Value times tax rate

+ 1.0% EAV growth @ $.45/$100 rate equates to $311,000 split between future Fiscal Years

+ Current Tax Rate target is $.4500/$100 EAV. A $.01/$100 EAV tax rate change equates to $691k

- CPPRT payments ($1.4 million) are reclassed from State Revenues, but are no longer growing,

42 State Government - 12,070,544 10,311

State on-behalf of payments (SURS/CIP) 2,270,804 3,014,

9,799,740 7,297,

100%

CCB provided estimates for FY 11 Base Operating Grants (Credit Hour, Square Footage), Equalization

- CPPRT payments are reclassed to Local Revenues $1.4 million- Preliminary estimates are down to L/Y revenues. Smaller piece of a fixed amount

+ Grants with cuts have been adjusted

43 Federal Government 8,567,536 10,216

111% 1

Mainly PELL, SEOG, Work Study, Dislocated Workers, Stafford Loans

Offsetting expenditures are recorded in 59 - Other expenditures

44 Student Tuition & Fees 12,048,724 13,734

98% 1

+ Effective Fall 2010, RVC Tuition & Universal Fee will $74/credit hour (Tuition $66 + Technology Fee $5 + Stud+ FY 11 Budget assumes a 8% growth in Credit Hours, at approved Tuition rates

Note RVC is still well below the state average and contiguous colleges for tuition & fees.

Note: Tuition and Fees now regularly exceeds State Government support

Total Revenues 55,955,834 60,490

104% 1

EAV as of Levy Year 2009 over $6.9 billion, Levy Year 2009 did NOT grow, future Levy Years growth rates are

Page 10 of 35 FFPM

7/27/2019 BOT Packet 062210

136/258

Rock Valley CollegeStatement of Expenditures

OPERATING (01, 02, 05, 06, 11, 12)Ac Actual Actual Budget Budget %

Expenses by Source FY 08 FY 09 FY 10 FY 11 Exp 08/09 09/10 10/

51 Salaries 26,204,380 27,946,962 29,869,479 31,272,246 46% 7% 7%52 Employee Benefits 8,454,858 8,873,802 6,847,232 10,798,127 16% 5% -23% 5

53 Contractual Services 3,348,316 4,073,816 3,939,153 3,718,341 5% 22% -3% -54 General Materials & Supplies 4,398,856 4,752,130 3,901,330 4,152,151 6% 8% -18%55 Travel & Conf/Mtg Expense 626,518 687,367 711,633 658,409 1% 10% 4% -

56 Fixed Charges 843,222 1,042,146 1,103,047 1,274,251 2% 24% 6% 157 Utilities 1,542,326 1,485,609 1,515,635 1,454,270 2% -4% 2% -58 Capital Outlay 1,019,330 969,453 673,000 509,000 1% -5% -31% -259 Other Expenditures 8,375,797 10,122,044 10,069,499 14,703,445 21% 21% -1% 4

Total Expenses 54,813,603 59,953,329 58,630,008 68,540,240 100% 9% -2% 13.1% 9.4% -2.2% 16.9%

CAPITAL (03, 04, 08, 09)Ac Actual Actual Budget Budget %


51 Salaries - - - - 0% 0% 0%52 Employee Benefits - - - - 0% 0% 0%53 Contractual Services 361,762 157,618 2,400 2,000 0% -56% -98% -1

54 General Materials & Supplies - - - - 0% 0% 0%55 Travel & Conf/Mtg Expense - - - - 0% 0% 0%56 Fixed Charges 2,157,729 2,356,769 6,709,485 10,269,110 28% 9% 185% 557 Utilities - - - - 0% 0% 0%58 Capital Outlay 5,500,919 5,970,788 18,997,800 26,811,453 72% 9% 218% 4

59 Other Expenditures - 17,523 - - 0% #DIV/0! 0%

Total Expenses 8,020,410 8,502,698 25,709,685 37,082,563 100% 6% 202% 42.5% 6.0% 202.4% 44.2%

TRUST & AGENCY (10 & 30)Ac Actual Actual Budget Budget %


51 Salaries 594 - - - 0% 0% 0%52 Employee Benefits - - - - 0% 0% 0%53 Contractual Services 200,532 261,054 249,572 265,480 19% 30% -4%54 General Materials & Supplies 122,550 84,387 144,202 132,017 10% -31% 71% -55 Travel & Conf/Mtg Expense 68,377 108,027 32,185 50,957 4% 58% -70% 556 Fixed Charges 200 900 600 600 0% 350% -33%57 Utilities - - - - 0% 0% 0%58 Capital Outlay - 7,499 - - 0% #DIV/0! 0%

59 Other Expenditures 1,282,755 786,792 1,133,082 915,397 67% -39% 44% -1Total Expenses 1,675,008 1,248,659 1,559,641 1,364,451 100% -25% 25% -1

4.8% -25.5% 24.9% -12.5%

Page 11 of 35 FPM11-FINAL-06162010.xlsx\Expenditures

7/27/2019 BOT Packet 062210

137/258


10%

20%

30%

40%

50%

60%

OperatingObjectExpensebySourceasa%ofT

Page 12 of 35 FPM11-F

FY2003 FY2004 FY2005 FY2006 FY2007 FY2008 FY20

Salaries 51% 52% 49% 48% 47% 48% 51%

EmployeeBenefits 10% 12% 11% 13% 16% 15% 12%

ContractualServices 9% 7% 9% 7% 7% 6% 7%

GeneralMaterials&Supplies 8% 8% 7% 9% 8% 8% 7%

Travel&Conf/MtgExpense 1% 1% 1% 1% 1% 1% 1%

FixedCharges 2% 2% 1% 1% 1% 2% 2%

Utilities 3% 3% 3% 3% 2% 3% 3%

CapitalOutlay 4% 1% 1% 1% 3% 2% 1%

OtherExpenditures 12% 14% 18% 15% 15% 15% 17%

0%

7/27/2019 BOT Packet 062210

138/258

Rock Valley CollegeStatement of OPERATING Expenses (Budgetary)

FY 2007 FY 2008 FYActual Actual A

51 Salaries 24,845,003 26,204,380 27104% 105%

--+ Non-contractual pay increases include across the board and merit based on performance, estimated FY 11 Budge+ Additional FY 11 Budget dollars have been allocated for Adjunct Faculty, for increased pay and increase in numbe+ Continued improvements in planning for Temporary Employees (Adjunct, Staff & Student Workers) will help monito

52 Employee Benefits 8,748,245 8,454,858 8State on-behalf of payments (SURS/CIP) 1,676,745 2,270,804 3

7,071,500 6,184,054 5131% 87%

- FY 11 Budget approximates FY 10 annualized claims rate and is considered an"aggressive" target+

Note: Payroll and Employee Benefits represent an increasing percentage of expenditures

53 Contractual Services 3,639,915 3,348,316 4101% 92%

+ FY 11 includes the IT Mentoring/Coaching Consulting estimate ($50k)

54 General Materials 4,069,863 4,398,856 489% 108%

59 Other Expenditures 7,866,757 8,375,797 10102% 106%

+ Mainly the Federal Government Grants - PELL, etc. from 43 Federal Government Revenues

Total Expenses by Object 53,159,124 54,813,603 59107% 103%

New positions include 8 full time, total $420k or 1.3% of FY 11 BudgetFY 11 Head count target 490, FY 10 Payroll cost overrun anticipated to be $250k due to increase enrollment and A

FY 11 estimates include increased benefit costs, offset by saving due to joining the ECOH network With Self Insur

expected claims and aggregate insurance was made for Health Claims (IBNR) Reserves (Incurred But Not Reporte

benefit accruals.

Page 13 of 35 FP

7/27/2019 BOT Packet 062210

139/258


10%

15%

20%

25%

30%

35%

OperatingFunctionExpensebySourceasa%of

Page 14 of 35 FPM11-FIN

FY2003 FY2004 FY2005 FY2006 FY2007 FY2008 FY20

Instruction 31% 32% 33% 32% 32% 32% 33%

AcademicSupport 4% 6% 5% 7% 7% 7% 7%

Student

Services 4% 5% 4% 5% 5% 5% 6%PublicService/ContinuingEd 13% 9% 14% 14% 13% 13% 12%

AuxiliaryServices 8% 7% 2% 2% 1% 1% 1%

Operations&MtceofPlant 9% 10% 10% 11% 12% 12% 11%

InstitutionalSupport 19% 20% 17% 16% 16% 16% 15%

Scholarships,Grants,Waivers 11% 12% 15% 14% 13% 13% 15%

0%