Comprehensive Community College: Budget Analysis Presentation

Laramie County Community College

BUDGET STUDY SESSION

Community College District’s Annual Budget For Fiscal Year

Beginning July 1, 2012, and Ending June 30, 2013

Presented to the Board of Trustees on April 4, 2012

TM

2012-13 OPERATING BUDGET

TABLE OF CONTENTS

MEMBERS

Board of Trustees ........................................................................................................................ 3

President’s Cabinet ..................................................................................................................... 3

INTRODUCTION

Memorandum from the President ............................................................................................... 4

Percent of Budget in Support of the Strategic Directions Pie Chart ........................................... 8

Enrollment................................................................................................................................... 9

Comparative Expenditures Per Student FTE ............................................................................ 10

Expenditures by Program ......................................................................................................... 11

Expenditures by Program / FY 2012 Budget ............................................................................ 12

Comparative Revenue Per Student FTE ................................................................................... 13

OPERATING FUNDS

Estimated Funds Available ....................................................................................................... 14

Proposed Distribution ............................................................................................................... 15

Proposed One-Time Expenses .................................................................................................. 17

Revenues ................................................................................................................................... 18

Expenditures ............................................................................................................................. 19

Pie Chart - Revenue and Expenditures ..................................................................................... 21

Summary ................................................................................................................................... 22

ONE MILL

Revenue..................................................................................................................................... 23

Expenditures ............................................................................................................................. 24

Pie Chart – Revenue and Expenditures ..................................................................................... 25

Summary ................................................................................................................................... 26

AUXILIARY FUND

Revenue..................................................................................................................................... 27

Expenditures ............................................................................................................................. 28

Pie Chart – Revenue and Expenditures ..................................................................................... 29

Summary ................................................................................................................................... 30

FY 2012-13 Operating Budget 2 April 4, 2012

FIVE MILL

Revenue..................................................................................................................................... 31

Expenditures ............................................................................................................................. 31

Summary ................................................................................................................................... 32

RESTRICTED FUNDS

Revenue Detail .......................................................................................................................... 33

Revenue..................................................................................................................................... 34

Expenditures ............................................................................................................................. 35

Pie Chart – Revenue and Expenditures ..................................................................................... 36

Summary ................................................................................................................................... 37

ENDOWMENT FUND

Revenue..................................................................................................................................... 38

Expenditures ............................................................................................................................. 38

Pie Chart – Revenue and Expenditures ..................................................................................... 39

Summary ................................................................................................................................... 40

PLANT FUND

Revenue..................................................................................................................................... 41

Expenditures ............................................................................................................................. 42

Pie Chart – Revenue.................................................................................................................. 44

Summary ................................................................................................................................... 45

FUND BUDGET SUMMARY

Summary ................................................................................................................................... 46

Pie Chart.................................................................................................................................... 47

FY 2012-13 Operating Budget 3 April 4, 2012

BOARD OF TRUSTEES

Greg Thomas, Chairman

Carol Merrell, Vice Chairwoman

Ed Mosher, Treasurer

Dr. Kevin Kilty, Secretary

Bill Dubois

John R. Kaiser

Brenda Lyttle

PRESIDENT’S CABINET

Dr. Joseph Schaffer, President

Dr. Marlene Tignor, Vice President, Instructional Services

Carol Hoglund, Vice President, Administration and Finance

Dr. Grant Wilson, Interim Vice President, Student Services

Stan Torvik, Vice President, Workforce and Community Development

Lisa Murphy, Executive Director of Public and Governmental Relations

Peggie Kresl-Hotz, Executive Director, Human Resources

Tom Bradley, Executive Director, Foundation

FY 2012-13 Operating Budget 4 April 4, 2012

MEMORANDUM

To: Laramie County Community College Board of Trustees

From: Dr. Joe Schaffer, President

Date: March 28, 2012

RE: Proposed FY13 Budget

On behalf of the faculty, staff, and students at Laramie County Community College (LCCC), it is my

pleasure to present you with our proposed budget for the 2012/2013 Fiscal Year. In the next few pages

of this memorandum, I want to share with you the broad context in which we developed this budget, as

well as illustrating how it adheres to the parameters of our social, fiscal, and political environments,

meets your expectations and priorities, and ultimately aligns with your strategic plan and the direction

you provided me early in my tenure here at LCCC.

State Context

Over the past decade, the Wyoming state standard budget has nearly doubled. In his budget proposal 1 ,

Governor Matt Mead stated this rapid growth “needs to be reversed and funding stabilized at a

sustainable level.” This is the same tenor in which the Joint Appropriations Committee (JAC) took up

its work in mid-January. Unfortunately, as a result of projected decreases in the price of natural gas, an

estimated decrease of $100 million in State revenue prompted the Governor to recommend $64 million

in cuts to his original budget.

The Governor’s original budget proposed a relatively flat standard budget for Wyoming’s community

colleges, as well as $14.4 million in enrollment growth funding. As a result of the decreased revenue

estimates, he recommended the JAC reduce that amount to $8.8 million. The JAC completely

eliminated all enrollment growth funding in the budget it advanced to the Legislature. However, the

Legislature restored $7.5 million of enrollment growth funding in the budget bill it passed, which was

signed by the Governor.

Throughout and since the Legislature has convened, it has been clear that the expectations have been to

hold the standard budget, and hold State-funded employee salaries, with only modest allowances for

performance and market adjustments. Even with the restoration of enrollment growth funding, the

Legislature’s expectations are that those resources should be applied to the variable costs associated with

enrollment growth over the past years, and not pay raises or salary adjustments.

Given the budget passed by the Legislature, and after consideration for the tuition increases approved by

the Wyoming Community College Commission (WCCC), and finally as a result of the workings of the

WCCC funding formula, we estimated LCCC will have approximately $2 million in additional revenue

in FY13.

1 2013-2014 Biennium State Budget Requests: Requests and Recommendations. Available at

http://ai.state.wy.us/budget/20132014Budget.aspx

FY 2012-13 Operating Budget 5 April 4, 2012

Institutional Context

Shortly after I started at LCCC, I entered mid-stream into the development of this budget. Fortunately,

the campus and its able staff were already building a budget that was in line with the institutional

context. This was no small feat, given the multiple parameters the institution was – and is – working

within. First, and probably least significant, was the transition in the College’s presidential leadership.

Second was the institution’s strategic and campus master plans. Third was the Organizational

Assessment and the recommendations provided from the College Brain Trust (CBT). Finally, and

probably most significant, was the general direction from you, the Trustees.

Since becoming part of the budget process, I have worked closely with the College’s leadership to

ensure your priorities are incorporated into the proposed FY13 budget. My interpretation of these, and I

will admit some massaging of my own based on my first few months on the ground at LCCC, has led us

to focus this budget on the following:

 the analysis, adaptation, and implementation of the recommendations within the Organizational Assessment;

 a purposeful investment into instruction and faculty;

 establishment of a strong, centralized human resources structure at the College that addresses the elements in the Organizational Assessment as well as existing institutional challenges while

managing the human resources at LCCC;

 setting aside resources for planning associated with capital projects identified as priorities in the campus master plan;

 moving base budget commitments from One Mill funding to the General Fund; and

 providing flexibility and stability within the College’s fiscal resources to help the institution navigate unanticipated opportunities and challenges in the near future.

Although some of these priorities will take multiple fiscal years and accompanying budgets to be fully

satisfied, I believe the proposed FY13 budget is a good start. In the remainder of this memorandum I

will provide more specific examples to describe what is, and what is not within this budget that may

substantiate this claim.

What is in the FY13 Budget

Included in this budget are numerous examples of how we have addressed the broader state context, as

well as your priorities and our belief in what is needed to advance LCCC into the future. Here are some

examples:

 We propose reallocating nearly $1 million of existing funds into instruction, human resources, and targeted operations increases.

 We propose investing in instruction. The proposed FY13 budget includes the addition of five new faculty lines and moves three faculty positions off of soft money onto the General Fund.

 We propose establishing a strong, centralized Human Resources department and structure through the addition of three new Human Resources personnel, filling one existing vacancy, and

funding the use of strategic consulting services.

 We propose increasing our operating reserves to approximately 1% of the current operating budget to ensure adequate resources are available should we experience budget reductions, lower

than estimated enrollment, and/or strategic opportunities over the coming year.

FY 2012-13 Operating Budget 6 April 4, 2012

 We are proposing to set aside more than $175,000 for facilities planning, in addition to revenues carried over from the current year that would be utilized similarly.

 We are proposing to increase our investment in, and thus partnership with the LCCC Foundation by increasing our support by nearly $150,000.

 We are proposing to start addressing the College’s restructuring, while also adopting the CBT’s recommendation to improve planning, assessment, and information technology through the

addition of an Associate Vice President for Institutional Effectiveness.

 We are proposing to address the deferred maintenance and facilities/grounds improvements identified in the campus master plan through more than $2 million of investments in facilities

projects across campus.

 We are proposing to improve opportunities for our students to utilize campus recreational facilities, engage in intramural sports, and more strongly connect the College to the community

through recreation and athletics by investing in a full-time athletic director position.

What isn’t in the FY13 Budget

It is evident there is much in the proposed FY13 budget that will help move the College forward. But I

also want to point out what isn’t in the budget.

 While we are proposing a modest amount for compensation commitments awarded for educational advancements, there are no pay increases for steps, cost of living adjustments,

bonuses, or other compensation adjustments. We firmly believe that to keep the taxpayers’ and

legislature’s trust in our campus, we must hold true to the expectations they have set for other

State agencies and their employees. We value our people at LCCC, but while others are

tightening their belts, we must do our part as well and show our commitment to the State’s

position in this regard.

 Although I, and many of you, want to see an investment in Student Services to continue our improvement in this area, the proposed FY13 budget actually proposes a decrease overall in this

area. This will help us prepare and work on planned improvements over the coming year, and

will position the campus to make a strategic, and substantial investment into Student Services as

the budget allows in coming fiscal years.

The Strategic Plan

We are committed to working toward the strategic directions and goals identified within your Strategic

Plan for LCCC. I believe the proposed FY13 budget continues to do just that. Many, if not most, of our

proposed reallocations and investments are targeted toward the plan and should have significant impact

in helping us achieve the goals set forth within.

 Our proposed investment in instruction will help us move toward the achievement of many goals associated with Strategic Direction 1: Maximize learning opportunities that foster student

success.

 Our proposed addition of a full time athletic director, and subsequent improvements to recreational and athletic programming will help us meet the goals within Strategic Direction 2:

Engage the community through collaborations that are mutually beneficial.

 We will meet Strategic Direction 3: Ensure institutional effectiveness and Strategic Direction 4: Manage resources to support a dynamic organization by establishing a continuous improvement

model through the creation of an office of Institutional Effectiveness and hiring an associate vice

president who will integrate planning, assessment, and information technology campus-wide.

FY 2012-13 Operating Budget 7 April 4, 2012

 We will meet the goals within Strategic Direction 5: Strengthen the College through increased collaboration and communication by investing in and establishing a strong, centralized human

resources office and structure.

Conclusion

Under your guidance, leadership, and support, LCCC is making good progress. We are fortunate to live

in a state and community that supports higher education both in voice and in funding. The proposed

FY13 budget doesn’t do everything, but it does help us sustain, and perhaps even accelerate, momentum

on the good work that we simply must do to better serve our students and ultimately our community.

Our budgets are our value statements – say what we will, what we believe in is evidenced by what we

invest in. I believe the proposed FY13 budget is an investment in institutional effectiveness and student

success. I hope you will join me in that belief.

FY 2012-13 Operating Budget 8 April 4, 2012

Strategic Directions

1. Maximize learning opportunities that foster student success

2. Engage the community through collaborations that are mutually beneficial

3. Ensure institutional effectiveness

4. Manage resources to support a dynamic organization

5. Strengthen the College through increased collaboration and communication

47%

6% 9%

32%

6%

Percent of Budget in Support of the

Strategic Directions

1

2

3

4

5

FY 2012-13 Operating Budget 9 April 4, 2012

ENROLLMENT

Both headcount and full-time equivalency (FTE) have increased since the beginning of the College. Over the last

ten years, headcount has increased 52.3% and FTE has increased 70.4%. For fiscal year 2010-2011, headcount

increased 2.4% and FTE increased 4.0%.

Full-time students comprise 36.5% and part-time students comprise 63.5% of the student population. The gender

ratio remains similar to past years at 60% women versus 40% men.

FY 2012-13 Operating Budget 10 April 4, 2012

LARAMIE COUNTY COMMUNITY COLLEGE

COMPARATIVE EXPENDITURES PER STUDENT FTE

LCCC expends less per Student FTE than the average of Wyoming’s other community colleges.

In FY11, LCCC spent more than the average of Wyoming’s other community colleges in two categories: Academic Support and

Scholarships.

-

5,000.00

10,000.00

15,000.00

20,000.00

25,000.00

FY07 FY08 FY09 FY10 FY11

Comparative Expenditures per Student FTE

FY07 - FY11

LCCC Average WY CC

-

500.00

1,000.00

1,500.00

2,000.00

2,500.00

3,000.00

3,500.00

4,000.00

Comparative FY11 Expenditures per FTE, by

Program

LCCC Average WY CC

FY 2012-13 Operating Budget 11 April 4, 2012

LARAMIE COUNTY COMMUNITY COLLEGE

EXPENDITURES BY PROGRAM

FY2009 FY2010 FY2011 FY2012 FY2013

%

Change

FY12-

FY13

4.39%

1.79%

3.47%

-3.11%

4.45%

0.01%

0.20%

$18,421,920 Instruction

$301,333

Public Service

$4,752,543

Academic Support

$3,785,814

Student Services

$7,589,224

Institutional Support

$5,361,032

Plant Maintenance

$2,062,400

Scholarships

FY 2012-13 Operating Budget 12 April 4, 2012

EXPENDITURES BY PROGRAM / FY2012 BUDGET

Instruction

47.48%

Public

Service

.45%

Academic

Support

10.58%

Student

Services

7.70%

Institutional

Support

17.67%

Plant

Maintenance

12.91%

Scholarships

3.20%

CASPER

Instruction

38.91%

Public

Service

.87% Academic

Support

12.78%

Student

Services

8.18%

Institutional

Support

20.62%

Plant

Maintenance

14.69%

Scholarships

3.96%

CENTRAL

Instruction

37.74%

Public

Service

.69% Academic

Support

8.90%

Student

Services

11.19%

Institutional

Support

24.23%

Plant

Maintenance

11.39% Scholarships

5.86%

EASTERN

Instruction

42.91%

Public

Service

.72% Academic

Support

11.17%

Student

Services

9.50%

Institutional

Support

17.67%

Plant

Maintenance

13.03%

Scholarships

5.00%

LCCC

Instruction

41.09%

Public

Service

0.06% Academic

Support

9.99%

Student

Services

12.33%

Institutional

Support

20.56%

Plant

Maintenance

11.68%

Scholarships

4.29%

NORTHERN

Instruction

42.88%

Public

Service

0.46%

Academic

Support

9.48%

Student

Services

11.71%

Institutional

Support

19.89%

Plant

Maintenance

11.45% Scholarships

4.13%

NORTHWEST

Instruction

41.83%

Public

Service

0.24% Academic

Support

8.81%

Student

Services

9.36%

Institutional

Support

22.47%

Plant

Maintenance

13.00%

Scholarships

4.30%

WESTERN

FY 2012-13 Operating Budget 13 April 4, 2012

LARAMIE COUNTY COMMUNITY COLLEGE

COMPARATIVE REVENUE PER STUDENT FTE

-

5,000.00

10,000.00

15,000.00

20,000.00

25,000.00

FY07 FY08 FY09 FY10 FY11

Comparative Revenue per Student FTE

FY07 - FY11

LCCC Average WY CC

-

1,000.00

2,000.00

3,000.00

4,000.00

5,000.00

6,000.00

7,000.00

Tuition & Fees State

Appropriations

Local

Appropriations

Other Sources

Comparative Revenue Distribution per FTE

FY11

LCCC Average WY CC

FY 2012-13 Operating Budget 14 April 4, 2012

FY13 ESTIMATED FUNDS AVAILABLE

New Funds:

State Aid $800,607

Reduction in Variable Cost Funding (Low Enrollee Success Rate) -64,838

Enrollment Growth Funding 836,850

Reduction in Enrollment Growth Funding (Low Enrollee Success Rate) -5,580

Local Appropriation 96,069

Tuition Increase (5.64% increase in tuition rates) 350,000

One Mill 75,000

Subtotal

$2,088,108

Internal Funds Available:

Positions include salary and benefits

One-time Monies $250,000

Operating Reserve 117,314

In-House Counsel 90,361

Coordinator, International and Diversity Services 51,733

Instructor (Medical Lab Technician) (New Position-FY2010) 59,996

Director, Counseling and Campus Wellness 98,493

Administrative Assistant, Counseling and Campus Wellness 46,122

Equine Show Team Coach (50%) 29,038

Foundation Budget 156,077

Legal Services Operating Budget 21,178

Balance of International Students Operating Budget 18,000

Subtotal

$938,312

Total Funds Available for FY2013

$3,026,420

FY 2012-13 Operating Budget 15 April 4, 2012

PROPOSED DISTRIBUTION

All positions include salary and benefits

Compensation Package:

Educational Advancements $45,000

Subtotal

$45,000

Instruction

New Positions/Services:

Instructor, English (ACC) $73,000

Instructor, Spanish/ESL 73,000

Instructor, Biology 73,000

Instructor, Communication 73,000

Instructor/Coord., Diagnostic Medical Sonography (Currently funded by Higher Ed.

Endowment) 73,595

Continuation of Services:

Adjunct/overtime/part-time ESS (salaries and benefits) 45,781

Operating Expenses 174,943

Subtotal

$586,319

Workforce and Community Development

New Positions/Services:

Instructor/Program Director, CTEC Apprenticeship (Funded by SESP grant until

02/01/13) $37,917

Instructor, Wind Energy Technology (Currently funded by Auxiliary Fund) 73,000

Instructor, Diesel Technology 73,000

Continuation of Services:

Adjunct/overtime/part-time ESS (salaries and benefits) 97,692

Operating Expenses 28,646

Subtotal

$310,255

Student Services

New Positions/Services:

Athletic Director $100,000

Continuation of Services:

Overtime/part-time ESS (salaries and benefits) 27,970

Operating Expenses -28,321

Subtotal

$99,649

Administration and Finance

Continuation of Services:

Overtime/part-time ESS (salaries and benefits) $7,888

Operating Expenses 120,434

Subtotal

$128,322

FY 2012-13 Operating Budget 16 April 4, 2012

PROPOSED DISTRIBUTION (Continued) President

New Positions/Services:

Associate Vice President of Institutional Effectiveness (6 months) $68,250

Human Resources Support Technician/Administrative Assistant 44,000

Compliance/Compensation Analyst (New Position-FY2010) (Difference from original

budget) 9,812

Human Resource Information Systems (HRIS) Specialist 58,500

Human Resource Development (HRD) Specialist 58,500

Continuation of Services:

Foundation Contract Services 306,077

Overtime/part-time ESS (salaries and benefits) -24,545

Operating Expenses 71,494

Subtotal

$592,088

Reserve Account

Operating Reserve (Approximately 1% of revenue) $426,455

Facilities Planning 175,436

One-Time Expenses (See separate list) 662,896

Subtotal

$1,264,787

Total Proposed Distribution

$3,026,420

FY 2012-13 Operating Budget 17 April 4, 2012

LARAMIE COUNTY COMMUNITY COLLEGE

PROPOSED ONE-TIME EXPENSES

FY2013 Instructional Services: Computers and furniture for new faculty $19,400

Marimba 10,000

Darkroom Drawers 1,000

Ten Flip Videos 1,000

Subtotal

$31,400*

Workforce and Community Development: Vehicle Alignment Equipment $20,000

MegaCode Kelly Advanced Manikin

11,498

Thermal Imager

7,500

Ten Lenovo ThinkPad Tablets 6,000

Fire Safe Cabinets

3,500

Crash Kelly Manikin

2,779

Eight Adult CPR Manikins 810

Subtotal

$52,087

Student Services: Resurface Gym Floor/Renovate the Gym $50,000

Soccer Goals (Two Pair) 15,000

Printer/copier/fax/scanner 3,044

Subtotal

$68,044

Administration and Finance Services: Redundant Nexus Core-Cisco (5 year lease) ($69,465 per year) $69,465

Datatel Consulting 50,000

Minivan 25,000

Follow-up Timekeeping Equipment 15,000

Update computers in Accounting and Payroll 7,250

Subtotal

$166,715

President: Expert Services for ongoing HR efforts on policy/procedures $100,000

Expert Services to assist/support ongoing HR efforts on a contemporary organization position

development/analysis/control model

100,000

Conduct national searches for the VP of Student Services/VP of Academic Affairs 75,000

Computers and furniture for new Human Resources employees 19,050

Expert Services to draft/support finalization of Summary Plan Document for TIAA/CREF

Retirement Plan plus facilitate process to ensure "Qualified Plan" determination for IRS

18,000

Replace twelve lap top computers for the Board of Trustees 8,000

Nikon D4 Camera and Lenses 12,600

Expert Services to draft/support finalization of Summary Plan Documents for various employee

education benefits; ensure SPDs are in compliance with IRS regulations

12,000

Subtotal

$344,650

GRAND TOTAL

$662,896

*The College invested over $.5 million in FY12, lowering the request for FY13

FY 2012-13 Operating Budget 18 April 4, 2012

UNRESTRICTED OPERATING FUND -- REVENUES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM REVENUES REVENUES REVENUES

FY2012-

FY2013

Tuition and Fees $10,403,814 $10,345,388 $10,695,388 $350,000

Tuition-In State $3,747,712 $3,689,038 $3,819,038 $130,000

Tuition-Out of District 1,763,486 1,769,594 1,872,594 103,000

Tuition-Out of State 648,141 654,663 691,663 37,000

Tuition-WUE 1,008,765 989,591 1,069,591 80,000

Community Services 159,336 120,000 120,000 0

Business Training 576,410 370,000 370,000 0

Course/High Tech Fees 2,274,964 2,512,502 2,512,502 0

Other Fees 225,000 240,000 240,000 0

State Appropriations $24,155,734 $25,100,531 $27,017,336 $1,916,805

General Fund $21,128,977 $21,816,230 $23,383,269 $1,567,039

Wyoming Investment in Nursing 362,280 372,812 372,812 0

Health Insurance Appropriation 2,664,477 2,911,489 3,261,255 349,766

Local Appropriations $4,489,810 $4,373,477 $4,469,546 $96,069

Mill Levy $3,802,722 $3,759,615 $3,782,457 $22,842

Motor Vehicle Fees 687,089 613,862 687,089 73,227

Other Income Sources $241,891 $91,996 $91,996 $0

Investment Income $53,867 $50,000 $50,000 $0

Miscellaneous Income 188,024 41,996 41,996 0

SUBTOTAL $39,291,249 $39,911,392 $42,274,266 $2,362,874

Other Funding Sources $0 $1,216,150 $0 -$1,216,150

Carryover Budget $0 $1,216,150 $0 -$1,216,150

Non Mandatory Transfer (One-Time

Funding) $2,237,262 $0 $0 0

TOTAL REVENUES $41,528,511 $41,127,542 $42,274,266 $1,146,724

FY 2012-13 Operating Budget 19 April 4, 2012

UNRESTRICTED OPERATING FUND -- EXPENDITURES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM ACTUALS BUDGET BUDGET

FY2012-

FY2013

INSTRUCTION $15,169,302 $16,941,889 $17,693,199 $751,310

Salaries * $9,535,029 $10,496,107 $11,319,618 $823,511

Benefits 3,382,224 3,817,779 3,959,460 141,681

Operating Expenses 2,028,058 2,576,938 2,333,721 -243,217

Capital Outlay 223,991 51,065 80,400 29,335

*Includes Operating Reserve of $426,455 for FY2013

INSTRUCTION - Continuing Education $476,960 $209,789 $248,969 $39,180

Salaries $149,673 $79,766 $86,766 $7,000

Benefits 12,946 11,163 12,143 980

Operating Expenses 314,340 118,860 150,060 31,200

Capital Outlay 0 0 0 0

INSTRUCTION - ABE/GED/ESL $420,325 $494,989 $479,752 -$15,237

Salaries $325,209 $332,261 $337,698 $5,437

Benefits 79,972 115,128 125,390 10,262

Operating Expenses 15,145 47,600 16,664 -30,936

Capital Outlay 0 0 0 0

PUBLIC SERVICE $336,541 $296,024 $301,333 $5,309

Salaries $191,687 $208,081 $212,356 $4,275

Benefits 56,148 67,165 68,577 1,412

Operating Expenses 88,707 20,778 20,400 -378

Capital Outlay 0 0 0 0

ACADEMIC SUPPORT $4,801,876 $4,593,053 $4,752,543 $159,490

Salaries $2,629,417 $2,645,767 $2,698,517 $52,750

Benefits 935,605 1,042,217 1,076,040 33,823

Operating Expenses 1,045,612 880,069 977,986 97,917

Capital Outlay 191,243 25,000 0 -25,000

STUDENT SERVICES $3,677,217 $3,907,363 $3,785,814 -$121,549

Salaries $2,126,698 $2,264,127 $2,170,548 -$93,579

Benefits 879,371 1,024,306 997,223 -27,083

Operating Expenses 664,457 618,930 553,043 -65,887

Capital Outlay 6,690 0 65,000 65,000

INSTITUTIONAL SUPPORT $6,876,954 $7,265,815 $7,589,224 $323,409

Salaries $3,264,330 $3,463,197 $3,557,902 $94,705

Benefits 1,181,693 1,374,301 1,500,060 125,759

Operating Expenses 2,136,155 2,403,317 2,493,662 90,345

Capital Outlay 294,776 25,000 37,600 12,600

FY 2012-13 Operating Budget 20 April 4, 2012

UNRESTRICTED OPERATING FUND – EXPENDITURES (Continued)

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM ACTUALS BUDGET BUDGET

FY2012-

FY2013

PLANT OPERATIONS $4,878,123 $5,360,286 $5,361,032 $746

Salaries $1,703,392 $1,836,446 $1,861,437 $24,991

Benefits 696,610 817,755 813,332 -4,423

Operating Expenses 2,460,563 2,706,085 2,686,263 -19,822

Capital Outlay 17,558 0 0 0

SCHOLARSHIPS $2,703,070 $2,058,334 $2,062,400 $4,066

Operating Expenses $2,703,070 $2,058,334 $2,062,400 $4,066

TOTAL EXPENDITURES $39,340,369 $41,127,542 $42,274,266 $1,146,724

FY 2012-13 Operating Budget 21 April 4, 2012

LARAMIE COUNTY COMMUNITY COLLEGE

OPERATING FUNDS

FY2013

State Appropriations

63.91%

Tuition and Fees

25.30%

Local Appropriations

10.57%

Other Income

Sources

0.22%

Revenues

Instruction

43.58%

Public Service

0.71% Academic Support

11.24%

Student Services

8.96%

Institutional Support

17.95%

Plant Operations

12.68%

Scholarships

4.88%

Expenditures by Program

Salaries

51.61%

Benefits

20.23%

Operating Expenses

26.72%

Operating Reserve

1.01% Capital Outlay

0.43%

Expenditures by Series

FY 2012-13 Operating Budget 22 April 4, 2012

UNRESTRICTED OPERATING FUND -- SUMMARY

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM SUMMARY SUMMARY SUMMARY

FY2012-

FY2013

REVENUES

TUITION AND FEES $10,403,814 $10,345,388 $10,695,388 $350,000

STATE APPROPRIATIONS 24,155,734 25,100,531 27,017,336 1,916,805

LOCAL APPROPRIATIONS 4,489,810 4,373,477 4,469,546 96,069

OTHER INCOME SOURCES 241,891 91,996 91,996 0

SUBTOTAL $39,291,249 $39,911,392 $42,274,266 $2,362,874

OTHER FUNDING SOURCES 0 1,216,150 0 -1,216,150

NON MANDATORY TRANSFER 2,237,262 0 0 0

TOTAL REVENUES $41,528,511 $41,127,542 $42,274,266 $1,146,724

EXPENDITURES BY PROGRAM

INSTRUCTION $16,066,587 $17,646,667 $18,421,920 $775,253

PUBLIC SERVICE 336,541 296,024 301,333 5,309

ACADEMIC SUPPORT 4,801,876 4,593,053 4,752,543 159,490

STUDENT SERVICES 3,677,217 3,907,363 3,785,814 -121,549

INSTITUTIONAL SUPPORT 6,876,954 7,265,815 7,589,224 323,409

PLANT OPERATIONS 4,878,123 5,360,286 5,361,032 746

SCHOLARSHIPS 2,703,070 2,058,334 2,062,400 4,066

TOTAL EXPENDITURES $39,340,369 $41,127,542 $42,274,266 $1,146,724

EXPENDITURES BY SERIES

SALARIES $19,925,434 $21,192,938 $21,818,387 $625,449

BENEFITS 7,224,569 8,269,814 8,552,225 282,411

OPERATING EXPENSES 11,456,106 11,430,911 11,294,199 -136,712

CAPITAL OUTLAY 734,260 101,065 183,000 81,935

OPERATING RESERVE 0 132,814 426,455 293,641

TOTAL EXPENDITURES $39,340,369 $41,127,542 $42,274,266 $1,146,724

FY 2012-13 Operating Budget 23 April 4, 2012

ONE MILL FUND -- REVENUES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM REVENUES REVENUES REVENUES

FY2012-

FY2013

One Mill Levy $950,680 $903,192 $953,192 $50,000

Motor Vehicle Fees 171,772 190,177 215,177 25,000

Carryover Budget 0 0 0 0

TOTAL REVENUES $1,122,453 $1,093,369 $1,168,369 $75,000

FY 2012-13 Operating Budget 24 April 4, 2012

ONE MILL FUND -- EXPENDITURES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM ACTUALS BUDGET BUDGET

FY2012-

FY2013

INSTRUCTION - Eastern Laramie County $84,308 $116,262 $132,475 $16,213

Salaries $51,390 $72,370 $84,186 $11,816

Benefits 16,365 21,080 22,177 1,097

Operating Expenses 16,553 22,812 26,112 3,300

ACADEMIC SUPPORT - Integrated Technology Support $563,476 $902,107 $846,619 -$55,488

Salaries $211,270 $290,469 $228,288 -$62,181

Benefits 81,666 112,699 93,361 -19,338

Operating Expenses 259,665 420,675 493,470 72,795

Capital Outlay 10,875 78,264 31,500 -46,764

ACADEMIC SUPPORT - Employee Development $105,759 $75,000 $75,000 $0

Salaries $0 $0 $0 $0

Benefits 0 0 0 0

Operating Expenses 105,759 75,000 75,000 0

INSTITUTIONAL SUPPORT-Reserve $0 $0 $114,275 $114,275

Operating Expenses $0 $0 $114,275 $114,275

Capital Outlay 0 0 0 0

TOTAL EXPENDITURES $753,543 $1,093,369 $1,168,369 $75,000

A reserve has been established to begin to address the Board’s expectation of moving ongoing expenditures from One-Mill

funding.

FY 2012-13 Operating Budget 25 April 4, 2012

LARAMIE COUNTY COMMUNITY COLLEGE

ONE MILL FUND

FY2013

One Mill Levy

82%

Motor Vehicle Fees

18%

Revenues

Instruction-Eastern

Laramie County

11%

Academic Support

73%

Academic Support -

Professional

Development

6%

Institutional Support-

Reserve

10%

Expenditures by Program

Salaries

27%

Benefits

10% Operating Expenses

60%

Capital Outlay

3%

Expenditures by Series

FY 2012-13 Operating Budget 26 April 4, 2012

ONE MILL FUND -- SUMMARY

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM SUMMARY SUMMARY SUMMARY

FY2012-

FY2013

REVENUES

ONE MILL LEVY $1,122,453 $1,093,369 $1,168,369 $75,000

ONE MILL RESERVE 0 0 0 0

TOTAL REVENUES $1,122,453 $1,093,369 $1,168,369 $75,000

EXPENDITURES BY PROGRAM

INSTRUCTION $84,308 $116,262 $132,475 $16,213

PUBLIC SERVICE 0 0 0 0

ACADEMIC SUPPORT 669,235 977,107 921,619 -55,488

STUDENT SERVICES 0 0 0 0

INSTITUTIONAL SUPPORT 0 0 114,275 114,275

PLANT OPERATIONS 0 0 0 0

SCHOLARSHIPS 0 0 0 0

TOTAL EXPENDITURES $753,543 $1,093,369 $1,168,369 $75,000

EXPENDITURES BY SERIES

SALARIES $262,660 $362,839 $312,474 -$50,365

BENEFITS 98,031 133,779 115,538 -18,241

OPERATING EXPENSES 381,977 518,487 708,857 190,370

CAPITAL OUTLAY 10,875 78,264 31,500 -46,764

TOTAL EXPENDITURES $753,543 $1,093,369 $1,168,369 $75,000

FY 2012-13 Operating Budget 27 April 4, 2012

AUXILIARY FUND -- REVENUES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM REVENUES REVENUES REVENUES FY2012-FY2013

SALES AND SERVICES $2,967,148 $2,982,974 $3,297,262 $314,288

Bookstore $124,406 $92,000 $92,000 $0

Copy Center 160,326 40,000 40,000 0

Facilities Rental 163,449 134,049 371,701 237,652

Summer Housing 30,990 38,237 38,854 617

Residence Halls 1,814,084 1,832,954 1,914,839 81,885

CTE Training 0 0 31,148 31,148

Children's Discovery Center 673,892 845,734 808,720 -37,014

TOTAL REVENUES $2,967,148 $2,982,974 $3,297,262 $314,288

FY 2012-13 Operating Budget 28 April 4, 2012

AUXILIARY FUND -- EXPENDITURES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM ACTUALS BUDGET BUDGET FY2012-FY2013

BOOKSTORE $146,639 $92,000 $92,000 $0

Salaries $0 $0 $0 $0

Benefits 0 0 0 0

Operating Expenses 8,486 12,000 12,000 0

Scholarships 138,153 80,000 80,000 0

Capital Outlay 0 0 0 0

COPY CENTER $151,888 $40,000 $40,000 $0

Operating Expenses $14,158 $15,000 $15,000 $0

Capital Outlay 137,730 25,000 25,000 0

FACILITIES RENTAL $156,739 $134,049 $371,701 $237,652

Salaries $27,365 $24,774 $24,838 $64

Benefits 4,631 5,545 4,243 -1,302

Operating Expenses 124,744 103,730 117,620 13,890

Capital Outlay 0 0 225,000 225,000

SUMMER HOUSING $17,781 $38,237 $38,854 $617

Salaries $12,399 $13,922 $12,917 -$1,005

Benefits 1,972 2,690 1,937 -753

Operating Expenses 3,410 21,625 24,000 2,375

Capital Outlay 0 0 0 0

RESIDENCE HALLS $1,712,454 $1,832,954 $1,914,839 $81,885

Salaries $161,347 $171,512 $172,277 $765

Benefits 33,425 49,902 36,502 -13,400

Operating Expenses 1,517,682 1,611,540 1,706,060 94,520

Capital Outlay 0 0 0 0

CTE TRAINING $3,337 $0 $31,148 $31,148

Salaries $2,400 $0 $15,000 $15,000

Benefits 937 0 1,148 1,148

Operating Expenses 0 0 15,000 15,000

Capital Outlay 0 0 0 0

CHILDREN'S DISCOVERY CENTER $954,375 $845,734 $808,720 -$37,014

Salaries $638,992 $626,296 $566,768 -$59,528

Benefits 122,602 178,488 113,830 -64,658

Operating Expenses 192,781 40,950 128,122 87,172

Capital Outlay 0 0 0 0

TOTAL EXPENDITURES $3,143,213 $2,982,974 $3,297,262 $314,288

FY 2012-13 Operating Budget 29 April 4, 2012

LARAMIE COUNTY COMMUNITY COLLEGE

AUXILIARY FUND

FY2013

Salaries

24.01%

Benefits

4.78%

Operating Expenses

61.20%

Scholarships

2.43%

Capital Outlay

7.58%

Expenditures by Series

Residence Halls

58.07%

Children's Discovery

Center

24.53%

Facilities Rental

11.27%

Bookstore

2.79%

Copy Center

1.21%

Summer Housing

1.18%

CTE Training

0.94%

Revenues/Expenditures by Program

FY 2012-13 Operating Budget 30 April 4, 2012

AUXILIARY FUND -- SUMMARY

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM SUMMARY SUMMARY SUMMARY

FY2012-

FY2013

REVENUES

SALES & SERVICES $2,967,148 $2,982,974 $3,297,262 $314,288

TOTAL REVENUES $2,967,148 $2,982,974 $3,297,262 $314,288

EXPENDITURES BY PROGRAM

BOOKSTORE $146,639 $92,000 $92,000 $0

COPY CENTER 151,888 40,000 40,000 0

FACILITIES RENTAL 156,739 134,049 371,701 237,652

SUMMER HOUSING 17,781 38,237 38,854 617

RESIDENCE HALLS 1,712,454 1,832,954 1,914,839 81,885

CTE TRAINING 3,337 0 31,148 31,148

CHILDREN'S DISCOVERY

CENTER 954,375 845,734 808,720 -37,014

TOTAL EXPENDITURES $3,143,213 $2,982,974 $3,297,262 $314,288

EXPENDITURES BY SERIES

SALARIES $842,503 $836,504 $791,800 -$44,704

BENEFITS 163,567 236,625 157,660 -78,965

OPERATING EXPENSES 1,861,261 1,804,845 2,017,802 212,957

SCHOLARSHIPS 138,153 80,000 80,000 0

CAPITAL OUTLAY 137,730 25,000 250,000 225,000

TOTAL EXPENDITURES $3,143,213 $2,982,974 $3,297,262 $314,288

FY 2012-13 Operating Budget 31 April 4, 2012

FIVE MILL FUND -- REVENUES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM REVENUES REVENUES REVENUES

FY2012-

FY2013

Five Mill Levy $0 $0 $0 $0

Motor Vehicle Fees 0 0 0 0

Carryover Budget 0 213,151 213,151 0

TOTAL REVENUES $0 $213,151 $213,151 $0

FIVE MILL FUND -- EXPENDITURES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM ACTUALS BUDGET BUDGET

FY2012-

FY2013

Campus Renewal Projects

Year 2010-2011

No Projects $0 $0 $0 $0

Year 2011-2012

UW/LCCC Building-Level Two Study 0 213,151 0 -213,151

Year 2012-2013

Level One Studies 0 0 213,151 213,151

TOTAL EXPENDITURES $0 $213,151 $213,151 $0

FY 2012-13 Operating Budget 32 April 4, 2012

FIVE MILL FUND -- SUMMARY

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM SUMMARY SUMMARY SUMMARY

FY2012-

FY2013

REVENUES

FIVE MILL LEVY $0 $0 $0 $0

MOTOR VEHICLE FEES 0 0 0 0

CARRYOVER BUDGET 0 213,151 213,151 0

TOTAL REVENUES $0 $213,151 $213,151 $0

EXPENDITURES BY PROGRAM

Campus Renewal Projects

Year 2010-2011

No Projects $0 $0 $0 $0

Year 2011-2012

UW/LCCC Building-Level Two Study 0 213,151 0 -213,151

Year 2012-2013

Level One Studies 0 0 213,151 213,151

TOTAL EXPENDITURES $0 $213,151 $213,151 $0

EXPENDITURES BY SERIES

CAPITAL OUTLAY $0 $213,151 $213,151 $0

TOTAL EXPENDITURES $0 $213,151 $213,151 $0

FY 2012-13 Operating Budget 33 April 4, 2012

RESTRICTED FUND -- DETAIL

ITEM 2012-2013

SUMMARY

FEDERAL GRANTS & CONTRACTS

PELL $5,000,000

Direct Loans 3,700,000

TRIO-SSS 247,584

College Work Study 70,000

SEOG 55,000

TOTAL FEDERAL GRANTS AND CONTRACTS $9,072,584

FEDERAL GRANTS & CONTRACTS PASSED THROUGH OTHER AGENCIES

GEAR UP $397,440

Perkins Allocation 310,161

Growing a New Generation 287,815

State Energy Sector Partnership 200,000

ABE 130,878

INBRE 46,050

Homeland Security 35,000

WIA Youth 16,000

EL/Civics 13,009

TOTAL FEDERAL GRANTS/CONTRACTS PASSED THROUGH OTHER AGENCIES $1,436,353

STATE GRANTS & CONTRACTS

Hathaway Scholarship Fund $1,000,000

Other for FY 2012-2013 500,000

Higher Education Endowment 255,830

State ABE Contribution (TANF) 220,133

Library Materials Funding 200,000

Adelante-the Center for Getting Ahead 140,000

TOTAL STATE GRANTS & CONTRACTS $2,315,963

PUBLIC GRANTS & CONTRACTS

Cheyenne Regional Medical Center Nursing Support $73,000

TOTAL PUBLIC GRANTS & CONTRACTS $73,000

PRIVATE GRANTS & CONTRACTS

League for Innovation $20,000

TOTAL PUBLIC GRANTS & CONTRACTS $20,000

TOTAL RESTRICTED FUND REVENUES $12,917,900

FY 2012-13 Operating Budget 34 April 4, 2012

RESTRICTED FUND -- REVENUES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM REVENUES REVENUES REVENUES FY2012-FY2013

FEDERAL GRANTS AND

CONTRACTS $9,493,211 $9,658,367 $10,508,937 $850,570

STATE GRANTS AND

CONTRACTS 2,174,980 2,423,716 2,315,963 -107,753

LOCAL GRANTS AND

CONTRACTS 94,729 80,137 73,000 -7,137

PRIVATE GRANTS AND

GRANTS 6,900 0 20,000 20,000

TOTAL REVENUES $11,769,820 $12,162,220 $12,917,900 $755,680

FY 2012-13 Operating Budget 35 April 4, 2012

RESTRICTED FUND -- EXPENDITURES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM ACTUALS BUDGET BUDGET FY2012-FY2013

INSTRUCTION $2,151,198 $2,140,000 $2,040,000 -$100,000

Salaries $996,318 $1,000,000 $1,000,000 $0

Benefits 238,763 240,000 240,000 0

Operating Expenses 864,683 800,000 700,000 -100,000

Capital Outlay 51,435 100,000 100,000 0

PUBLIC SERVICE $34,859 $48,250 $0 -$48,250

Salaries $3,000 $3,000 $0 -$3,000

Benefits 230 250 0 -250

Operating Expenses 31,630 45,000 0 -45,000

Capital Outlay 0 0 0 0

ACADEMIC SUPPORT $964,200 $1,125,000 $1,030,000 -$95,000

Salaries $432,410 $450,000 $450,000 $0

Benefits 118,798 150,000 130,000 -20,000

Operating Expenses 412,992 450,000 450,000 0

Capital Outlay 0 75,000 0 -75,000

STUDENT SERVICES $8,651 $9,900 $22,900 $13,000

Salaries $6,057 $7,200 $0 -$7,200

Benefits 463 700 0 -700

Operating Expenses 2,131 2,000 22,900 20,900

Capital Outlay 0 0 0 0

INSTITUTIONAL SUPPORT $153,841 $175,070 $0 -$175,070

Salaries $70,849 $90,000 $0 -$90,000

Benefits 22,151 25,070 0 -25,070

Operating Expenses 60,841 60,000 0 -60,000

Capital Outlay 0 0 0 0

PLANT OPERATIONS $0 $0 $0 $0

Salaries $0 $0 $0 $0

Benefits 0 0 0 0

Operating Expenses 0 0 0 0

Capital Outlay 0 0 0 0

SCHOLARSHIPS $6,226,773 $8,664,000 $9,825,000 $1,161,000

Salaries $74,367 $80,000 $70,000 -$10,000

Benefits 1,758 2,000 1,000 -1,000

Operating Expenses 6,150,648 8,582,000 9,754,000 1,172,000

NON-MANDATORY TRANSFER $2,230,299 $0 $0 $0

TOTAL EXPENDITURES $11,769,820 $12,162,220 $12,917,900 $755,680

FY 2012-13 Operating Budget 36 April 4, 2012

LARAMIE COUNTY COMMUNITY COLLEGE

RESTRICTED FUNDS

FY2013

Federal Grants and

Contracts

81.35%

State Grants and

Contracts

17.93%

Local Grants and

Contracts

0.57% Private Grants and

Contracts

0.15%

Revenues

Scholarships

76.06%

Instruction

15.79%

Academic Support

7.97%

Student Services

0.18%

Expenditures by Program

Operating Expenses

84.59%

Salaries

11.77%

Benefits

2.87%

Capital Outlay

0.77%

Expenditures by Series

FY 2012-13 Operating Budget 37 April 4, 2012

RESTRICTED FUND -- SUMMARY

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM SUMMARY SUMMARY SUMMARY

FY2012-

FY2013

REVENUES

FEDERAL GRANTS AND CONTRACTS $9,493,211 $9,658,367 $10,508,937 $850,570

STATE GRANTS AND CONTRACTS 2,174,980 2,423,716 2,315,963 -107,753

LOCAL GRANTS AND CONTRACTS 94,729 80,137 73,000 -7,137

PRIVATE GRANTS AND GRANTS 6,900 0 20,000 20,000

TOTAL REVENUES $11,769,820 $12,162,220 $12,917,900 $755,680

EXPENDITURES BY PROGRAM

INSTRUCTION $2,151,198 $2,140,000 $2,040,000 -$100,000

PUBLIC SERVICE 34,859 48,250 0 -48,250

ACADEMIC SUPPORT 964,200 1,125,000 1,030,000 -95,000

STUDENT SERVICES 8,651 9,900 22,900 13,000

INSTITUTIONAL SUPPORT 153,841 175,070 0 -175,070

PLANT OPERATIONS 0 0 0 0

SCHOLARSHIPS 6,226,773 8,664,000 9,825,000 1,161,000

NON-MANDATORY TRANSFER 2,230,299 0 0 0

TOTAL EXPENDITURES $11,769,820 $12,162,220 $12,917,900 $755,680

EXPENDITURES BY SERIES

SALARIES $1,583,000 $1,630,200 $1,520,000 -$110,200

BENEFITS 382,162 418,020 371,000 -47,020

OPERATING EXPENSES 7,522,924 9,939,000 10,926,900 987,900

CAPITAL OUTLAY 51,435 175,000 100,000 -75,000

NON-MANDATORY TRANSFER 2,230,299 0 0 0

TOTAL EXPENDITURES $11,769,820 $12,162,220 $12,917,900 $755,680

FY 2012-13 Operating Budget 38 April 4, 2012

ENDOWMENT FUND -- REVENUES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM REVENUES REVENUES REVENUES

FY2012-

FY2013

State of Wyoming Challenge Match Appropriation $843,526 $500,000 $750,000 $250,000

Investment Income 823,479 500,000 750,000 250,000

TOTAL REVENUES $1,667,005 $1,000,000 $1,500,000 $500,000

ENDOWMENT FUND -- EXPENDITURES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM ACTUALS BUDGET BUDGET

FY2012-

FY2013

Endowed Scholarships $111,785 $960,000 $1,425,000 $465,000

Operating Expenses 51,359 40,000 75,000 35,000

TOTAL EXPENDITURES $163,144 $1,000,000 $1,500,000 $500,000

FY 2012-13 Operating Budget 39 April 4, 2012

LARAMIE COUNTY COMMUNITY COLLEGE

ENDOWMENT FUND

FY2013

State of Wyoming

Challenge Match

Appropriation

50%

Investment Income

50%

Revenues

Endowed

Scholarships

95%

Operating Expenses

5%

Expenditures

FY 2012-13 Operating Budget 40 April 4, 2012

ENDOWMENT FUND -- SUMMARY

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM SUMMARY SUMMARY SUMMARY

FY2012-

FY2013

REVENUES

STATE OF WYOMING CHALLENGE

MATCH APPROPRIATION $843,526 $500,000 $750,000 $250,000

INVESTMENT INCOME 823,479 500,000 750,000 250,000

TOTAL REVENUES $1,667,005 $1,000,000 $1,500,000 $500,000

EXPENDITURES BY PROGRAM

SCHOLARSHIPS $163,144 $1,000,000 $1,500,000 $500,000

TOTAL EXPENDITURES $163,144 $1,000,000 $1,500,000 $500,000

EXPENDITURES BY SERIES

SALARIES $0 $0 $0 $0

BENEFITS 0 0 0 0

OPERATING EXPENSES 163,144 1,000,000 1,500,000 500,000

CAPITAL OUTLAY 0 0 0 0

TOTAL EXPENDITURES $163,144 $1,000,000 $1,500,000 $500,000

FY 2012-13 Operating Budget 41 April 4, 2012

PLANT FUND -- REVENUES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM REVENUES REVENUES REVENUES

FY2012-

FY2013

WCCC Contingency Reserve $294,427 $294,400 $315,116 $20,716

WCCC Contingency Reserve Carryover 0 394,333 547,559 153,226

Major Maintenance Funds 0 0 2,243,732 2,243,732

Major Maintenance Carryover 328,499 929,976 433,179 -496,797

Health Sciences Building Carryover 0 291,190 257,671 -33,519

Lease Revenue Bonds for RH/Dining Hall Facility

Carryover 2,298,737 830,749 817,057 -13,692

Facilities Fee Improvements 712,636 706,000 706,000 0

State Fiscal Stabilization Funds for Major

Maintenance 1,703,799 0 0 0

SFSF for Major Maintenance Carryover 0 1,360,890 0 -1,360,890

TOTAL REVENUES $5,338,097 $4,807,538 $5,320,314 $512,776

FY 2012-13 Operating Budget 42 April 4, 2012

PLANT FUND -- EXPENDITURES

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM ACTUALS BUDGET BUDGET FY2012-

FY2013

Bond Funds and State Appropriation

Health Sciences Building Third Floor $0 $291,190 $257,671 -$33,519

Lease Revenue Bonds

Residence Hall Project 2,298,737 830,749 817,057 -13,692

Major Maintenance Projects

Infrastructure 0 0 0 0

Annual Asphalt Repair 65,964 0 0 0

Athletic Field and PE Irrigation 58,899 0 0 0

Auto Diesel-CDC North Entry Ramp 2,497 0 0 0

EEC Common Area 34,121 0 0 0

ARP-CDC Renewal 78,063 0 0 0

Replace Lighting in PE Building 11,492 0 0 0

Renew Science/FA Arcade 2,700 0 0 0

Renew Science/PE Arcade 3,240 0 0 0

Renew Auto Diesel/Business Arcade 3,960 0 0 0

Replace EEC/CCC Arcade Roof 33,086 0 0 0

Replace PE West Water Heater 34,477 0 0 0

Replace Boiler Burners in Plant Operations Building 0 60,000 0 -60,000

Replace Arcade Roofs 0 56,000 0 -56,000

Replace UPS in Fine Arts 0 81,000 0 -81,000

Replace Server Room Air Conditioner in Fine Arts 0 54,000 0 -54,000

Replace Pool Deck 0 75,000 0 -75,000

Upgrade Physical Education Electrical Service 0 84,400 0 -84,400

Upgrade Auto Body/Career & Tech. Elec. Service 0 65,000 0 -65,000

Replace Emergency Cables 0 27,800 0 -27,800

Repair/Restore Administration Pergola 0 125,000 0 -125,000

Replace HVAC Controls in Arp 0 35,000 0 -35,000

Replace HVAC Controls in Library 0 30,000 0 -30,000

Improve Site Lighting 0 75,000 0 -75,000

Small Maintenance Projects 0 141,776 250,000 108,224

Landscape Improvements 0 20,000 100,000 80,000

Fire Alarm Upgrade 0 0 325,000 325,000

Replace Stall Building Roof 0 0 250,000 250,000

Replace Plant Operations Vaporizer 0 0 40,000 40,000

Repair EEC-CCC Arcade Exterior 0 0 88,000 88,000

Replace BAS Controls in Arp 0 0 50,000 50,000

Replace BAS Controls in the Library 0 0 45,000 45,000

Replace BAS Controls in CCI 0 0 40,000 40,000

Upgrade Illuminated Signage 0 0 75,000 75,000

Renew Fine Arts Restroom 0 0 70,000 70,000

Replace Part of Library Roof 0 0 178,000 178,000

Renew the Arena Lobby and Restroom 0 0 50,000 50,000

Renew Building Facades 0 0 500,000 500,000

Replace High Bay Lighting in Career & Tech. Build. 0 0 140,000 140,000

Replace Lighting in Plant Operations 0 0 170,000 170,000

Replace Lighting in Auto Diesel 0 0 56,000 56,000

Replace Lighting in Auto Body 0 0 88,000 88,000

Repair/Replace Raised Floor in Library 0 0 100,000 100,000

To be determined 0 0 61,911 61,911

FY 2012-13 Operating Budget 43 April 4, 2012

PLANT FUND -- EXPENDITURES (Continued)

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM ACTUALS BUDGET BUDGET

FY2012-

FY2013

State Fiscal Stabilization Funds for Major

Maintenance

Replace Roof on Science Building $405,579 $0 $0 $0

Remodel Restroom in Career and Technical Building 24,641 0 0 0

Remodel Restroom in Auto Body Area 36,794 0 0 0

Remodel Restroom in Plant Operations Building 25,339 2,031 0 -2,031

Replace Roof on Auto Diesel 227,111 144,095 0 -144,095

Replace Auto Body HVAC Unit 15,914 140,086 0 -140,086

Replace Lighting in PE Building 166,548 58,300 0 -58,300

Replace Roof on PE Building West Addition and

MPR 527,183 386,317 0 -386,317

Replace Chemistry Lab Halon Fire Suppression

System 50,534 5,277 0 -5,277 Replace ACC Roof-Top Heat Recovery Units/Re-Pipe

Heat Pumps 93,273 68,297 0 -68,297

Upgrade Fire Alarm System 115,767 196,840 0 -196,840

Repair and Resurface Science Lab Floors 1,826 20,379 0 -20,379

Replace Pool AHU in PE Building 11,466 79,643 0 -79,643

Replace Science/Dental Hygiene Raised Floor 1,825 159,625 0 -159,625

Renew CCC/EEC Arcade 0 100,000 0 -100,000

WCCC Contingency Reserve Projects

Replace Carpet and Wall Coverings in FA west 2,280 81,369 0 -81,369

Renew East Locker Rooms in PE Building 11,303 87,197 0 -87,197

Renew Training Center Well System 0 150,000 0 -150,000

Remodel Children's Discovery Center in Arp 0 117,000 0 -117,000

Replace Lighting Controls in CCI 0 30,000 0 -30,000

Interior Lighting Improvements 0 50,000 0 -50,000

To be determined 0 173,167 237,675 64,508

Improve Campus Main Entries 0 0 375,000 375,000

Replace RTU's 0 0 250,000 250,000

Facilities Fee Improvement

Lease Payment 645,173 676,000 676,000 0

Operating Expenses 0 30,000 30,000 0

TOTAL EXPENDITURES $4,989,791 $4,807,538 $5,320,314 $512,776

FY 2012-13 Operating Budget 44 April 4, 2012

LARAMIE COUNTY COMMUNITY COLLEGE

PLANT FUND

6% 10%

42% 8%

5%

16%

13%

FY 2013 Tentative Revenue

WCCC Contingency Reserve

Account

WCCC Contingency Reserve

Carryover

Major Maintenance Funds

Major Maintenance Carryover

Health Sciences Building

Carryover

Lease Revenue Bonds for

Residence Hall/Kitchen, Dining

Hall Facility

Facilities Fee

6% 8%

20%

6%

17%

15%

28%

FY 2012 Adopted Revenue

WCCC Contingency Reserve

Account

WCCC Contingency Reserve

Carryover

Major Maintenance Carryover

Health Sciences Building Carryover

Lease Revenue Bonds for Residence

Hall/Kitchen, Dining Hall Facility

Facilities Fee

State Fiscal Stabilization Funds

FY 2012-13 Operating Budget 45 April 4, 2012

PLANT FUND -- SUMMARY

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM SUMMARY SUMMARY SUMMARY

FY2012-

FY2013

REVENUES

WCCC CONTINGENCY RESERVE ACCOUNT $294,427 $294,400 $315,116 $20,716

WCCC CONTINGENCY RESERVE CARRYOVER 0 394,333 547,559 153,226

MAJOR MAINTENANCE FUNDS 0 0 2,243,732 2,243,732

MAJOR MAINTENANCE CARRYOVER 328,499 929,976 433,179 -496,797

HEALTH SCIENCES BUILDING CARRYOVER 0 291,190 257,671 -33,519 LEASE REVENUE BONDS RH/DINING HALL

CARRYOVER 2,298,737 830,749 817,057 -13,692

FACILITIES FEE IMPROVEMENTS 712,636 706,000 706,000 0 STATE FISCAL STABILIZATION FUNDS/MAJOR

MAINTENANCE 1,703,799 0 0 0

SFSF FOR MAJOR MAINTENANCE CARRYOVER 0 1,360,890 0 -1,360,890

TOTAL REVENUES $5,338,097 $4,807,538 $5,320,314 $512,776

EXPENDITURES BY PROGRAM

WCCC CONTINGENCY RESERVE PROJECTS $13,583 $688,733 $862,675 $173,942

MAJOR MAINTENANCE PROJECTS 328,499 929,976 2,676,911 1,746,935

HEALTH SCIENCES BUILDING PROJECT 0 291,190 257,671 -33,519 RESIDENCE HALL/KITCHEN/DINING HALL FACILITY

PROJECT 2,298,737 830,749 817,057 -13,692

FACILITIES FEE IMPROVEMENTS 645,173 706,000 706,000 0 STATE FISCAL STABILIZATION FUNDS MAJOR

MAINTENANCE 1,703,799 1,360,890 0 -1,360,890

TOTAL EXPENDITURES $4,989,791 $4,807,538 $5,320,314 $512,776

EXPENDITURES BY SERIES

CAPITAL OUTLAY $4,989,791 $4,807,538 $5,320,314 $512,776

TOTAL EXPENDITURES $4,989,791 $4,807,538 $5,320,314 $512,776

FY 2012-13 Operating Budget 46 April 4, 2012

FUND BUDGET SUMMARY

ACTUAL ADOPTED TENTATIVE INCREASE/

2010-2011 2011-2012 2012-2013 DECREASE

ITEM SUMMARY SUMMARY SUMMARY

FY2012-

FY2013

UNRESTRICTED OPERATING FUND $39,340,369 $41,127,542 $42,274,266 $1,146,724

ONE MILL FUND 753,543 1,093,369 1,168,369 75,000

UNRESTRICTED & ONE MILL

FUND $40,093,912 $42,220,911 $43,442,635 $1,221,724

AUXILIARY FUND $3,143,213 $2,982,974 $3,297,262 $314,288

RESTRICTED FUND 11,769,820 12,162,220 12,917,900 755,680

LCCC CURRENT FUND BUDGET $55,006,946 $57,366,105 $59,657,797 $2,291,692

FIVE MILL FUND $0 $213,151 $213,151 $0

ENDOWMENT FUND 163,144 1,000,000 1,500,000 500,000

PLANT & CONSTRUCTION FUND 4,989,791 4,807,538 5,320,314 512,776

$5,152,935 $6,020,689 $7,033,465 $1,012,776

TOTAL LCCC BUDGET $60,159,881 $63,386,794 $66,691,262 $3,304,468

FY 2012-13 Operating Budget 47 April 4, 2012

LARAMIE COUNTY COMMUNITY COLLEGE

FUND BUDGET SUMMARY

FY2013

Operating Fund

63.39%

Restricted Fund

19.37%

Plant and

Construction Fund

7.98%

Auxiliary Fund

4.94%

One Mill Fund

1.75% Endowment Fund

2.25%

Five Mill Fund

0.32%

Fund Budget Summary