Item Coversheet


City Council Agenda Request
February 20, 2018


AGENDA REQUEST NO: VI.B.

AGENDA OF: City Council Meeting

INITIATED BY: Justin Alderete, Budget Officer

PRESENTED BY: Justin Alderete, Budget Officer

RESPONSIBLE DEPARTMENT: Budget

AGENDA CAPTION:
FIRST AND FINAL CONSIDERATION: Consideration of and action on CITY OF SUGAR LAND ORDINANCE NO. 2127 AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF SUGAR LAND, TEXAS, AMENDING THE FISCAL YEAR 2017-2018 BUDGET FOR THE CITY OF SUGAR LAND, TEXAS, TO PROVIDE THAT THE REVISED BUDGET ADDRESS FUNDS RELATING TO CERTAIN CAPITAL AND OPERATING BUDGET MATTERS AND THAT THIS AMENDMENT BE ADOPTED AS THE BUDGETED AMOUNT FOR THOSE FUNDS.
RECOMMENDED ACTION:

Consideration and approval of first and final reading of Ordinance No. 2127 amending the FY18 budget as presented.

EXECUTIVE SUMMARY:

The City’s budget is adopted by one reading of an ordinance each year by City Council as stipulated by the City Charter. After the budget is adopted, additional appropriations that are needed require City Council approval through a budget ordinance. To streamline the process, the Budget Office consolidates amendment requests into a single budget ordinance and brings them forward on a semi-annual basis, or as needed. This budget amendment is for carry-overs from FY2017, and formalizes budget amendments and actions approved by City Council since October.

 

As part of actively managing the budget the second amendment typically occurs at or near the end of the last accounting period for the fiscal year, which allows the City to constrain its carry-overs to the available net funding remaining in the prior year. This method more clearly presents the activity that occurred on a budgetary basis in the prior year.

 

The agenda item illustrates the City’s commitment to financial resiliency, and highlights the importance of actions that management takes throughout the year to ensure a balanced budget. Throughout FY2017, the organization faced revenue and expenditure challenges, as well as a record setting natural disaster. The City recognized mid-way through FY2017 that sales tax revenue was beginning to decline, and the ability of the City to fully fund all budgeted expenditures would likely not be feasible. In order to ensure the City ended the year in the black, management turned to the Financial Management Policy Statements for guidance. This important set of statements provided direction to management on how declining revenues should be managed relative to expenditures. These statements directed that the action necessary to rebalance the budget was a reduction in the transfer to the Capital Projects Fund for rehabilitation work. As a result, the City reduced nearly two million dollars in sales tax revenue, and approximately the same amount in transfers out for rehabilitation work. These proactive responses are an indication of the importance of the Financial Management Policy statements and how critical they are in upholding the City's commitment to strong financial management.

 

This agenda item is divided into two major sections. The first section describes the carry-over funding that is included for each fund, and the next section describes the formalization of all previous council actions. The formalization of each previous action has either a full or nearly full revenue that supports the additional reappropriations. The table at the end of this agenda summarizes the variance to budget.

 

Carry-Over Requests

Carry-overs are expenditures that were budgeted in the prior year, but the receipt of those goods did not occur until the current fiscal year. Because appropriations lapse at fiscal year-end, and funds may not be spent unless they are appropriated, Council must formally re-authorize the expenditure of these funds. In all cases where carry-over funding is requested, the operating funds ended the year better than anticipated, largely due to these expenditures occurring in the next fiscal year. The carry-over requests for each fund are outlined below.

The General Fund FY17 unaudited ending budgetary fund balance of $21.96M is $2.59M greater than the budgeted ending fund balance. The variance within this fund is primarily the result of savings from non-departmental expenditures, such as salary savings and rebates and assignments, but it is also impacted by slightly higher net operating revenues.  

 

As part of this amendment Council will be reappropriating carry-over funding and formalizing other council approved items, which total $1.13M. As part of this process there is also the need to recognize $302K in additional revenue from grants, donations, and the additional transfers in from the debt reduction fund that support the annexation related carry-over expenditures.

 

Carry-over requests in the General Fund total $933,658 as shown below. The carry-over revenues total $113,911, of which $7,542 is from Bulletproof Vest Grant Funds and $106,369 is a transfer from the debt reduction funds to cover annexation related carry-over expenditures.  After carryovers and appropriations approved by City Council, the fund is $1.75M over the policy requirement for FY18, of which a portion of funds are restricted for traffic safety and public education communications (PEG funds).

 

Carry-overs in the General Fund include: 

 

Department

Description

Annexation

Non -Annexation

Total Amount

Communications

PEG Funding (Council Chamber & Cane Room Upgrades)

$ 366,909

$ 366,909

Fire

Ladder 2 Repairs

86,199

86,199

City Attorney

Contract Legal Services

69,803

69,803

Public Works

Asset Management Program

48,839

48,839

OSI

PD Organizational Assessment Contract

43,979

43,979

HR

Property Coverage Insurance Premiums

38,623

38,623

ENS

Animal Shelter Size & Scope Contract

29,502

29,502

IT

GIS Services - Annexation

28,950

-

28,950

Engineering

2017 Emergency Action Plan Update

24,500

24,500

IT

SAN Disks Expansion - Annexation

20,000

20,000

Public Works

CityWorks

16,391

16,391

Communications

Citizen Survey

15,600

15,600

Engineering

Concept Plans Illustrating Street Scape

11,192

11,192

City Manager

Agenda Management Software

12,656

12,656

HR

Increase to Risk Management Insurance Premiums Related to Annexation

10,818

-

10,818

Multiple

All other request (Less than $10,000 each)

46,601

63,097

109,698

Total General Fund

$ 106,369

$ 827,289

$ 933,658

 

 

The Sugar Land Development Corporation has an FY17 unaudited ending fund balance of $2.34M, which is $1.04M greater than the budgeted ending fund balance. Revenues were $94,302 lower than anticipated, and expenditures were $1.13M less than anticipated. Carry-Over requests in the Sugar Land Development Corporation total $408,468 and include $4,000 in operating expenses, and $404,468 in CIP project funding. This fund is $627,876 higher than budgeted, which includes savings from operations. All SLDC funds are restricted.

The Sugar Land 4B Corporation ended the year $2.80M higher than anticipated. The FY17 unaudited ending fund balance is $5.09M. Revenues were $104,012 lower than anticipated, and expenditures were $2.90M less than anticipated. Carry-Over requests in the Sugar Land 4B Corporation total $2.24M and include $66,623 for operating expenses, and $2.17M for ongoing capital improvement projects. This fund is $563,578 higher than budgeted, which includes savings from operations. All SL4B funds are restricted.

The Tourism Fund has an FY17 unaudited ending fund balance of $876,066, which is $357,392 greater than the budgeted ending fund balance. Revenues were $153,051 greater than anticipated, and expenditures were $204,341 less than anticipated. Carry-over requests in the Tourism Fund total $145,186 and includes funding for work on the visitor’s center, tourism & promotion, and events & sponsorship. This fund is $212,206 higher than budgeted, which includes savings from operations. All Tourism funds are restricted.

The CDBG Fund has $19,606 in revenues and expenditures that are restricted and need to carry-over to FY18. These funds will be added to the budget allocation for the current fiscal year, and support existing projects.

The Employee Benefits Fund has $14,685 in revenues and expenditures that need to carry-over to FY18. These funds will be added to the budget allocation for the current fiscal year, and are related to revenues received from Cigna that must be spent on wellness related activities.

The High Tech Replacement Fund ended the year better than anticipated with an unaudited ending fund balance of $2.16M. Revenues were $3,054 less than anticipated, and expenditures were $43,173 less than anticipated. The High Tech Replacement Fund includes $17,297 in carry-overs for 3 Tier Wireless parts, which were ordered but not received in FY17. This fund is $22,822 higher than budgeted.


The Utility Fund has an FY17 unaudited ending fund balance of $4.59M, which is $406,439 greater than anticipated. Revenues were $525,666 less than anticipated, and expenditures were $932,105 less than anticipated. The Utilities Fund has expenditures that require carry-over funding for items ordered, but not received within the current fiscal year, and for water quality management and improvements. Carry-over requests for the Utilities Fund total $156,400. This fund is $250,039 higher than budgeted.

The Surface Water Fund has an FY17 unaudited ending fund balance of $11.50M, which is $1,664,776 greater than anticipated. Revenues were $135,442 greater than anticipated, and expenditures were $1,529,334 less than anticipated. There is one Carry-over request for the Surface Water fund that totals $489,000 and is for the Integrated Water Resource Plan. The budget amendment for this work was approved late in FY17 and the work will be ongoing through FY18. After carryovers and adding the repayment of the inter-fund loan from the Airport ($1.04M), this fund is $2,219,173 higher than budgeted.


The Airport Fund has an FY17 unaudited ending fund balance of $5.69M, which is $814,342 greater than the budgeted ending fund balance. Revenues were $67,496 greater than anticipated, and expenditures were $746,846 less than anticipated. Carry-over requests total $33,240 and are for the Old Terminal renovation work not completed in FY17. This fund is expected to be $262,295 lower than budgeted, as a result of an additional appropriation for the repayment of the inter-fund load to the Surface Water Fund. This will be highlighted in the appropriations section of the agenda.

The Solid Waste Fund has an FY17 unaudited ending fund balance of $470,754, which is $76,353 greater than anticipated. Revenues were $632,877 less than anticipated, and expenditures were $709,230 less than anticipated. This variance is primarily associated with planned Hurricane Harvey debris removal that came in less than anticipated. Carry-over requests total $81,610 and include $5,111 in funding for the solid waste campaign in the annexed areas, $6,188 for Harvey related debris removal, and $70,311 for contractual services to remove contamination from an illicit discharge which was not completed in FY17. The illicit discharge will be reimbursed to City and the solid waste annexation campaign will be funded from debt reduction funds. This fund is $76,353 higher than budgeted.

The Annexation Debt Reduction Fund- Greatwood has an FY17 unaudited ending fund balance of $3.89M, which is $613,500 greater than the budgeted ending fund balance. Revenues were $15,243 greater than anticipated, and expenditures were $598,257 less than anticipated. The carry-over request of $55,740 is to cover 50% of General Fund and Solid Waste Fund annexation related carry over expenditures. This fund is $557,760 higher than budgeted.

The Annexation Debt Reduction Fund- New Territory has an FY17 unaudited ending fund balance of $4.29M, which is $623,039 greater than the budgeted ending fund balance. Revenues were $24,782 greater than anticipated, and expenditures were $598,257 less than anticipated. Carry-over request of $55,740 is to cover 50% of General Fund and Solid Waste Fund annexation related carry over expenditures. This fund is $567,300 higher than budgeted.

 

Formalized Budget Appropriations

 

In addition to the carry-overs included above, this ordinance will formalize certain actions that Council has approved. These items include the addition of both revenues and expenditures for grants, donations, and reimbursements.


The following table illustrates the General Fund items needing to be formalized through ordinance:

 

Description

Amount

2017 Bulletproof Vest Grant Award

29,438

CPAAA Cash Donation

44,952

Ladder 4 Repairs

126,760

Total General Fund

$201,150

 

The State Seizures Fund includes the formalization of appropriations of $91,894 to purchase equipment for law enforcement use including a TCOLE Certified ID Card Machine, 20 SWAT Rifles, and other law enforcement equipment needed for the build-out of the new Mobile Command Post Vehicle. These funds are restricted and can only be used for certain law enforcement purchases.

The Surface Water Fund includes the formalization appropriations of $86.45M in revenues and expenditures for General Obligation Refunding Bonds, series 2017, and $1.04M in revenue for inter-fund loan repayment from the Airport Fund.

The Airport Fund includes appropriations of $1.04M in expenditures for inter-fund loan repayment from to Surface Water Fund in accordance with Resolution 16-19. Rather than waiting for TXDOT grant funding to repay the loan, staff recommends appropriating the funds to make the payment as it is shown in the resolution.

The CIP Fund requires that actions that have previously been taken by council be formalized through the ordinance process. The drainage items listed below are items utilizing funding set aside for Hurricane Harvey related studies and work. The water and wastewater projects have come in under budget, and will result in an increase in the CIP fund balance. The table below represents the changes to the CIP budget.

 

Previous Council Actions

Description

Revenue

Expenditure

Net FB Change

DR-Brazos River Bank Erosion Study

-

125,000

(125,000)

DR-Drainage Studies at River Bend North, Plantation Bend and Oyster Creek (Dam # 3 to Dulles Av.)

-

79,510

(79,510)

DR-Drainage Studies at Elkins Road (Between Commonwealth Blvd. and University Blvd.) and Knightsbridge Blvd.

-

90,000

(90,000)

DR-Drainage studies at Chimneystone, Austin Park, Settler Park, and Sugar Lakes subdivisions.

-

170,700

(170,700)

DR-Business Park Storm Water Pump Station Improvements

-

(80,535)

80,535

WA-Mason Road Elevated Storage Tank Rehabilitation

-

(135,000)

135,000

WA-Lakeview and Sugar Creek Groundwater Plants Booster Pumps Replacement

-

(122,596)

122,596

WW-Lift Station Rehabilitation

-

(265,954)

265,954

 


The table below illustrates the variance between unaudited actuals, and the budget, as well as the impact of this item.

 

Budget Amendment Funding Summary

Fund

FY17 Budgeted Ending Balance

FY17 Unaudited Ending Balance

Variance

Carry-Over/Appropriations

Variance

Expenditures

Revenues

General Fund

19,373,236

21,961,145

2,587,909

(1,134,808)

301,802

1,754,903

SLDC

1,299,413

2,335,757

1,036,344

(408,468)

-

627,876

SL4B

2,292,816

5,092,904

2,800,088

(2,236,510)

-

563,578

CDBG

-

-

-

(19,606)

19,606

-

Tourism

518,673

876,066

357,392

(145,186)

-

212,206

Employee Benefits

498,947

498,079

(868)

(14,685)

14,685

(868)

High Tech

2,116,987

2,157,107

40,119

(17,297)

-

22,822

Utilities

4,185,663

4,592,102

406,439

(156,400)

-

250,039

Surface Water

9,836,599

11,501,375

1,664,775

(86,942,538)

87,496,935

2,219,173

Solid Waste

394,401

470,754

76,353

(81,610)

81,610

76,353

Airport

4,880,276

5,694,618

814,342

(1,076,637)

-

(262,295)

State Seizures

137,771

137,814

43

(91,894)

-

(91,851)

Debt Reduction Fund Greatwood

3,274,599

3,888,099

613,500

(55,740)

-

557,759

Debt Reduction Fund New Territory

3,663,461

4,286,501

623,039

(55,740)

-

567,300

*Additional Revenue includes carry-overs, grant funds, reimbursements, sponsorships, and donations

 

 


BUDGET

EXPENDITURE REQUIRED:  N/A

CURRENT BUDGET: N/A

ADDITIONAL FUNDING: N/A

FUNDING SOURCE:N/A

ATTACHMENTS:
DescriptionType
Ordinance No 2127 Amending The FY18 BudgetResolutions
Income StatementsOther Supporting Documents
Presentation - OR 6bPresentation