HomeMy WebLinkAbout2-18-22 Workshop Packet
AGENDA
ORO VALLEY TOWN COUNCIL
WORKSHOP
February 18, 2022
WESTWARD LOOK RESORT
245 E. INA ROAD
CANYON ROOM & TERRACE
WORKSHOP AT OR AFTER 8:30 AM
WORKSHOP AGENDA
1.Discussions facilitated by a representative of The Bridge Group LLC regarding any and all aspects of Town
Operations. These discussions may include but not be limited to: reviewing current and projected data and
information on Town finances, operations, capital investments and facilities; evaluating short and long-term
issues impacting the community and organization; review of the Town Council’s FY21/22 – FY22/23
Strategic Leadership Plan, progress on the Your Voice, Our Future General Plan and any other Town
plans related to future planning and operations; discussion and input on priorities for the FY22/23 annual
budget and 10-year capital plan
ADJOURNMENT
*There will be no public comment during this all-day workshop.
POSTED: 2/16/22 at 5:00 p.m. by pp
When possible, a packet of agenda materials as listed above is available for public inspection at least 24 hours prior
to the Council meeting in the office of the Town Clerk between the hours of 8:00 a.m. – 5:00 p.m.
The Town of Oro Valley complies with the Americans with Disabilities Act (ADA). If any person with a disability needs
any type of accommodation, please notify the Town Clerk’s Office at least five days prior to the Council meeting at
229-4700.
CC-4333 1.
Town Council Study Session
Meeting Date:02/18/2022
Submitted By:Michelle Stine, Town Clerk's Office
Department:Town Clerk's Office
Information
SUBJECT:
Discussions facilitated by a representative of The Bridge Group LLC regarding any and all aspects of Town
Operations. These discussions may include but not be limited to: reviewing current and projected data and
information on Town finances, operations, capital investments and facilities; evaluating short and long-term issues
impacting the community and organization; review of the Town Council’s FY21/22 – FY22/23 Strategic Leadership
Plan, progress on the Your Voice, Our Future General Plan and any other Town plans related to future planning
and operations; discussion and input on priorities for the FY22/23 annual budget and 10-year capital plan
EXECUTIVE SUMMARY:
N/A
FISCAL IMPACT:
N/A
Attachments
December 2021 Financial Update
Town Manager’s Office
TOWN COUNCIL REPORT
DATE: February 18, 2022
TO: Mayor and Council
THRU: Mary Jacobs, Town Manager
FROM: David Gephart, Chief Financial Officer
SUBJECT: December 2021 Financial Update
This financial update is intended to provide an overview and status of revenues and expenditures for the
Town’s selected funds through the second quarter for fiscal year 2021/22. Funds included in this financial
update are the General Fund, Highway Fund and Community Center Fund. Also included are the two
enterprise funds, Water and Stormwater. All amounts are preliminary, un-audited and subject to change
based upon adjusting entries, as necessary.
EXECUTIVE SUMMARY:
Revenues are performing well compared to budget, and expenditures are trending as expected. A few
variances are noted at this time, which are discussed below.
General Fund
Overall, General Fund revenues are trending better than expected and expenditures are trending as
expected through December (see attachment A). Revenues total $26.1 million or 55.4% of budget, while
expenditures are at $31.2 million or 50.9% of the total budget.
Highway Fund
Revenues are trending better than expected and expenditures are trending as expected through December
(see attachment B). Revenues total $1.9 million or 52.6% of budget while expenditures total $2.4 million
or 58.8% of budget.
Community Center Fund
Revenues for the Community Center Fund are trending higher than expected and expenditures are largely
as expected through December (see attachment C-1 & C-2). Revenues total $4.1 million or 55.9% of
budget while expenditures total $3.0 million or 38.5% of budget.
Water Fund
Revenues for the Water Utility Fund are trending higher than expected and expenditures are largely as
expected through December (see attachment D). Revenues total $10.0 million or 57.7% of budget while
expenditures total $10.2 million or 49.5% of budget.
Stormwater Fund
Overall, the Town’s Stormwater Utility fund revenues and expenses are trending lower than expected
through December (see attachment E). Revenues total $765,000 or 44% of budget, while expenses are
below budget at $549,000 or 23.5% of budget.
BACKGROUND AND DETAILED INFORMATION:
GENERAL FUND
Attachment A shows General Fund revenues and expenditures through December, as well as year-end
estimates for each category. The estimated year-end projections in the General Fund are as follows:
Revenues: $50,674,505
Less:
Expenditures: ($60,087,209)
Preliminary Estimated Decrease in Fund Balance: ($9,412,704)*
*The estimated change in fund balance is primarily due to a one-time payment of $10 million to PSPRS to
pay down the unfunded liability.
General Fund Revenues
Local sales tax collections in the General Fund total $12.5 million or 59.2% of the budgeted amount
of $21.2 million and are performing better than anticipated. Retail collections total $4.2 million,
which is $473,511 or 12.7% higher than collections from the same time period last fiscal year. Both
restaurant/bar collections as well as bed tax collections are up 42.6% and 136% respectively
compared to collections from the same time period last fiscal year. Construction sales tax
collections total $3.4 million through December 2021, which is $543,661 or 19.3% higher than
collections from the same time period last fiscal year. Total local sales tax revenue is expected to
come in $2.6 million above budget due to strong performance across most tax categories. Please
see attachment G for detailed information on General Fund local sales tax collections.
License and permit revenues total $875,000 or 47.4% of the budget amount of $1.8 million. Single
Family Residential (SFR) permits issued through December total 79 and are a large portion of this
revenue piece. This revenue category is expected to come in $127,000 or 6.9% over budget at this
time due to upcoming commercial building activity.
State shared revenues total $7.2 million or 52.1% of the budget amount of $13.7 million. These
revenues sources are comprised of state shared sales taxes, state shared income taxes, auto-lieu
fees, and Smart and Safe shared taxes. At this point in time, these revenues are forecasted to
come in $457,000 or 3.3% over budget due to higher-than-expected collections.
Charges for services revenues total $1.3 million or 54.7% of the budget amount of $2.4 million. A
large portion of these revenues are associated with Parks & Recreation program revenues, which
are showing strong signs of recovery. Charges for services are forecasted to come in over budget
by $165,800, or 6.9%.
Please note that the year-end estimate for federal grant revenue has been revised to reflect the
amount of ARPA funds that will be recognized as revenue in FY 2021/22. The remaining funds that
the Town receives will post as deferred until spent.
General Fund Expenditures
General Fund expenditures are trending as expected through December. In General
Administration, the Town has recorded a one-time, budgeted $10.0 million payment to PSPRS to
pay down the unfunded liability. Transfers out of the General Fund are expected to be $1.1 million
less than budgeted due to the pension obligation bonds that were issued in July. The Town
budgeted a full debt service payment; however, only an interest payment is due this year.
The General Fund is expected to end the fiscal year with a total fund balance of $23.0 million, or 42.7%
of budgeted expenditures
HIGHWAY FUND
Highway Fund Revenues
State shared highway user funds total $1.9 million or 52.4% of the budget amount of $3.6 million.
At this point in time, these revenues are estimated to come in over budget by $255,000 or 7.1%.
The year-end estimate for miscellaneous revenue reflects an unexpected insurance recovery
received in the amount of $4,069.
All other revenue sources for the fund are expected to come in on budget at this time.
Highway Fund Expenditures
Highway Fund expenditures though December are at $2.4 million or 58.8% of the adopted budget
of $4.1 million. Expenditures reflect the pavement preservation program which is mostly complete
for the year. Highway Fund expenditures are estimated to come in on budget.
The Highway Fund is expected to end the fiscal year with a fund balance of approximately $1.1 million.
COMMUNITY CENTER FUND
Attachment C-1 shows the consolidated financial status of the Community Center Fund with all revenues
and expenditures from contracted and Town-managed operations.
Attachment C-2 shows the monthly line-item detail for the contractor-managed operations, specifically
revenues and expenditures associated with the golf, food and beverage operations. The totals in the
revenue and expenditure categories in attachment C-2 tie to the contracted operating revenues and
expenditures in attachment C-1.
Community Center Fund Revenues
Revenues in the Community Center Fund through December total $4.1 million or 55.9% of the
budget amount of $7.4 million.
Contracted operating revenues total about $1.9 million through December. This is approximately
$264,400 or 16% higher than revenues from the same time period last fiscal year. At this time,
contracted revenues are estimated to come in about $318,000 or 8.8% higher than budgeted due
to anticipated, across-the-board outperformance compared to budget.
Town operating revenues for December are $556,587, a significant increase from the same time
period last year, due primarily to a recovery in recreation program revenue and member dues.
Town operating revenues are expected to end the fiscal year $266,000 or 38.1% over budget.
Local sales tax revenues for December total $1.6 million or 55.5% of the budget amount of $2.9
million. These collections are currently estimated to come in $356,255 or 12.1% over budget.
Community Center Fund Expenditures
Expenditures in the Community Center Fund total $3.0 million or 38.5% of the budgeted amount of
$7.8 million.
Contracted operating expenditures total $2.3 million, or 48.2% of the budgeted amount of $4.7
million. Contracted expenditures are estimated to come in approximately $205,000 or 4.4% under
budget, due to anticipated O&M and personnel savings.
Transfers out are expected to be $1.7 million less than budget. This is due to the Town having
budgeted a full debt service payment for the newly issued Parks and Recreation bonds whereas
only an interest payment is due this year.
At this time, the Community Center Fund is projected to end the fiscal year with a total fund balance
of $5.1 million.
The year-end sales tax support for golf operations is estimated to be $347,157. This figure includes a
projected ($555,233) for contracted golf operations, $125,000 in outside HOA contributions, and
approximately $83,000 in local sales taxes generated from golf related operations.
WATER FUND
Water Fund Revenues
Water Sales represent the largest revenue source for the fund and total nearly $7.7 million, or
54.8% of budget through the first half of the fiscal year. Because of higher trending water sales and
charges, this revenue source is anticipated to end the fiscal year 2.0% or $273,000 above budgeted
levels.
Charges for Services account for revenues from various fees including the groundwater
preservation fee. Through December, this category is trending slightly above budget at $1.7 million
or 51.0% of budget and is expected to end the year 2.6% over budget.
Miscellaneous revenue includes collection of a $662,000 lien release, which was not budgeted.
Water Fund Expenses
Expenses for the Water fund are largely trending as expected through the first half of the fiscal
year. Other financing uses are related to scheduled transfers to take place later in the fiscal year.
STORMWATER FUND
Stormwater Fund Revenues
Overall, revenues for the Stormwater Fund are trending lower than expected through December
2021. Charges for Services represent the bulk of revenue for the fund and are currently trending
slightly above budget at $745,000 or 51.8%. Revenues are anticipated to end the fiscal year
$233,000, or 13.4% below budget. This is mainly due to Pima County taking over the Gravel Wash
capital project so the Town will not receive the $300,000 budgeted reimbursement.
Stormwater Fund Expenses
Through December, Stormwater expenses are trending below budget, but are anticipated to
increase as maintenance and projects increase in the second half of the fiscal year. Expenses are
anticipated to end the fiscal year under budget by $453,000, or 19.4% due to the budgeted Gravel
Wash capital project being taken over by Pima County.
Please see attachments A and B for additional details on the General Fund and Highway Fund. See
attachments C-1 and C-2 for additional details on the Community Center Fund. Attachments D and E
provide details related to the Town’s two enterprise funds. See attachment F for a fiscal year-to-date
consolidated summary of all Town Funds. See attachment G and H for a breakdown of monthly local sales
tax collections and state shared revenue collections for the General Fund.
ATTACHMENT A
December YTD Financial Status
General Fund
% Budget Completion through December --- 50%
% Actuals YE % Variance
to Budget to Budget
REVENUES:`
LOCAL SALES TAX 12,526,255 21,157,707 59.2% 23,880,002 12.9%
LICENSES & PERMITS 875,549 1,849,000 47.4% 1,976,497 6.9%
FEDERAL GRANTS 3,394,934 5,990,290 56.7% 6,068,448 1.3%
STATE GRANTS 37,935 75,000 50.6% 75,000 0.0%
STATE/COUNTY SHARED 7,153,990 13,729,923 52.1% 14,187,081 3.3%
OTHER INTERGOVERNMENTAL 561,831 1,344,500 41.8% 1,409,500 4.8%
CHARGES FOR SERVICES 1,306,750 2,387,776 54.7% 2,553,577 6.9%
FINES 65,166 125,000 52.1% 125,000 0.0%
INTEREST INCOME 128,570 150,000 85.7% 150,000 0.0%
MISCELLANEOUS 45,545 264,000 17.3%249,400 -5.5%
TOTAL REVENUES 26,096,525 47,073,196 55.4% 50,674,505 7.7%
% Actuals YE % Variance
to Budget to Budget
EXPENDITURES:
CLERK 171,643 383,833 44.7% 377,733 -1.6%
COMMUNITY & ECON. DEV. 1,276,598 3,044,614 41.9% 2,975,428 -2.3%
COUNCIL 127,346 188,720 67.5% 188,720 0.0%
FINANCE 401,265 979,655 41.0% 954,655 -2.6%
GENERAL ADMINISTRATION 11,331,006 14,459,559 78.4% 14,619,559 1.1%
HUMAN RESOURCES 205,373 535,390 38.4% 535,390 0.0%
INNOVATION & TECHNOLOGY 2,115,600 4,346,583 48.7% 4,346,583 0.0%
LEGAL 390,114 902,754 43.2% 877,754 -2.8%
MANAGER 490,632 1,115,224 44.0% 1,115,224 0.0%
PARKS & RECREATION 1,607,062 3,446,361 46.6% 3,408,923 -1.1%
POLICE 7,626,896 18,171,000 42.0% 18,171,000 0.0%
PUBLIC WORKS 2,383,788 5,364,091 44.4% 5,407,492 0.8%
TOWN COURT 381,977 914,796 41.8% 845,916 -7.5%
TRANSFERS OUT 2,685,314 7,408,264 36.2%6,262,832 -15.5%
TOTAL EXPENDITURES 31,194,614 61,260,844 50.9% 60,087,209 -1.9%
SURPLUS / (DEFICIT) (5,098,089) (14,187,648) (9,412,704)
BEGINNING FUND BALANCE **32,408,542
Plus: Surplus / (Deficit)(9,412,704)
ENDING FUND BALANCE **22,995,838
* Year-end estimates are subject to further revision
** Beginning and ending fund balance amounts are estimates and are subject to further revision
FY 2021/2022
Year End
Estimate *
Budget Year End
Estimate *
Actuals
thru 12/2021
Actuals
thru 12/2021
Budget
ATTACHMENT B
December YTD Financial Status FY 2021/2022
% Budget Completion through December --- 50%
Actuals
thru 12/2021 Budget % Actuals
to Budget
Year End
Estimate *
YE % Variance
to Budget
REVENUES:-
LICENSES & PERMITS 13,364 25,000 53.5% 25,000 0.0%
STATE/COUNTY SHARED 1,895,968 3,614,922 52.4% 3,870,000 7.1%
INTEREST INCOME 4,954 6,000 82.6% 6,000 0.0%
MISCELLANEOUS 4,171 2,000 208.6%6,069 203.5%
TOTAL REVENUES 1,918,457 3,647,922 52.6% 3,907,069 7.1%
Actuals
thru 12/2021 Budget % Actuals
to Budget
Year End
Estimate *
YE % Variance
to Budget
EXPENDITURES:
TRANSPORTATION ENGINEERING 2,224,417 3,766,525 59.1% 3,766,525 0.0%
STREET MAINTENANCE 182,554 324,000 56.3%324,000 0.0%
TOTAL EXPENDITURES 2,406,971 4,090,525 58.8% 4,090,525 0.0%
SURPLUS / (DEFICIT) (488,514) (442,603) (183,456)
BEGINNING FUND BALANCE **1,242,978
Plus: Surplus / (Deficit)(183,456)
ENDING FUND BALANCE **1,059,522
* Year-end estimates are subject to further revision
** Beginning and ending fund balance amounts are estimates and are subject to further revision
Highway Fund
ATTACHMENT C-1
December YTD Financial Status
% Budget Completion through December --- 50%
% Actuals YE % Variance
to Budget to Budget
REVENUES:
CONTRACTED OPERATING REVENUES
Golf Revenues, Trail and Cart Fees 958,678 1,966,245 48.8% 2,021,925 2.8%
Member Dues 550,749 957,000 57.5% 1,113,750 16.4%
Food & Beverage 275,551 473,465 58.2% 554,880 17.2%
Merchandise & Other 138,507 225,675 61.4%250,187 10.9%
1,923,485 3,622,385 53.1% 3,940,742 8.8%
TOWN OPERATING REVENUES
Daily Drop-Ins 23,730 30,000 79.1% 40,000 33.3%
Member Dues 355,796 526,480 67.6% 600,000 14.0%
Recreation Programs 131,420 82,500 159.3% 240,000 190.9%
Swim Team/Swim Lessons - 8,000 0.0% 8,000 0.0%
Facility Rental Income 45,641 50,500 90.4%75,000 48.5%
556,587 697,480 79.8% 963,000 38.1%
OTHER REVENUES
Local Sales Tax 1,628,702 2,932,798 55.5% 3,289,053 12.1%
Real Property Rental Income 19,502 19,502 100.0% 19,502 0.0%
Interest Income 7,797 1,000 779.7% 4,590 359.0%
Miscellaneous 58 125,100 0.0%125,100 0.0%
1,656,059 3,078,400 53.8% 3,438,245 11.7%
TOTAL REVENUES 4,136,131 7,398,265 55.9% 8,341,987 12.8%
% Actuals YE % Variance
to Budget to Budget
EXPENDITURES:
CONTRACTED OPERATING EXPENDITURES
Personnel 695,849 1,641,903 42.4% 1,591,540 -3.1%
Food & Beverage 239,804 445,441 53.8% 508,395 14.1%
Operations & Maintenance 1,251,882 2,429,634 51.5% 2,225,047 -8.4%
Equipment Leases 78,246 184,550 42.4%170,993 -7.3%
2,265,781 4,701,528 48.2% 4,495,975 -4.4%
TOWN OPERATING EXPENDITURES
Personnel 404,807 875,291 46.2% 891,376 1.8%
Operations & Maintenance 111,442 211,290 52.7%211,290 0.0%
516,249 1,086,581 47.5% 1,102,666 1.5%
CAPITAL OUTLAY 50,146 132,500 37.8% 132,500 0.0%
TRANSFERS OUT 168,519 1,868,519 9.0% 168,519 -91.0%
TOTAL EXPENDITURES 3,000,695 7,789,128 38.5% 5,899,660 -24.3%
SURPLUS / (DEFICIT) 1,135,436 (390,863) 2,442,327
BEGINNING FUND BALANCE **2,676,793
Plus: Surplus / (Deficit)2,442,327
ENDING FUND BALANCE **5,119,120
* Year-end estimates are subject to further revision
** Beginning and ending fund balance amounts are estimates and are subject to further revision
FY 2021/2022
Actuals
thru 12/2021 Budget Year End
Estimate *
Community Center Fund
Actuals
thru 12/2021 Budget Year End
Estimate *
ATTACHMENT C-2
Budget Last Year Budget Last Year
Actual Budget Variance Last Year Variance Actual Budget Variance Last Year Variance
Rounds
2,953 2,750 203 2,807 146 Rounds ‐ Member 14,533 12,500 2,033 13,623 910
604 380 224 287 317 Rounds ‐ Outing 2,878 1,560 1,318 1,475 1,403
5,083 4,515 568 3,915 1,168 Rounds ‐ Public 22,463 22,280 183 22,481 (18)
====================================================================================================================================================================
8,640 7,645 995 7,009 1,631 Total Rounds 39,874 36,340 3,534 37,579 2,295
Revenue
202,187 173,975 28,212 161,787 40,400 Green Fees 803,147 732,950 70,197 759,778 43,370
24,287 19,590 4,697 20,761 3,526 Cart Fees 135,870 115,775 20,095 119,046 16,824
3,601 5,000 (1,399)3,876 (275)Driving Range 19,661 24,000 (4,339)22,295 (2,633)
750 0 750 0 750 Golf Cards/Passes 9,182 0 9,182 0 9,182
31,756 24,600 7,156 26,258 5,498 Pro Shop Sales 102,275 98,200 4,075 97,518 4,757
24,146 34,565 (10,419)14,045 10,101 Food (Food & Soft Drinks) 147,068 89,565 57,503 62,299 84,769
24,159 24,250 (91)19,991 4,168 Beverages (Alcohol) 126,494 97,925 28,569 101,286 25,208
1,467 0 1,467 933 535 Other Food & Beverage Revenue 1,989 0 1,989 1,272 717
3,116 1,325 1,791 1,739 1,377 Other Golf Revenues (Club Rent, Handica 11,784 5,475 6,309 8,617 3,167
4,466 1,500 2,966 2,089 2,377 Clinic / School Revenue 12,959 3,500 9,459 7,666 5,292
98,773 82,500 16,273 87,318 11,455 Dues Income ‐ Monthly Dues 550,749 475,000 75,749 477,606 73,143
7,980 0 7,980 1,375 6,605 Miscellaneous Income and Discounts 2,307 0 2,307 1,692 615
================================================================================= ============================================================= ================
426,688 367,305 59,383 340,172 86,517 Total Revenue 1,923,485 1,642,390 281,095 1,659,075 264,410
Cost of Sales
22,301 18,380 (3,921)21,621 (680)COGS ‐ Pro Shop 74,611 73,510 (1,101)68,683 (5,929)
7,843 9,822 1,980 5,507 (2,336)COGS ‐ Food 41,757 21,999 (19,758)20,651 (21,106)
1,374 1,440 66 784 (590)COGS ‐ Non‐Alcoholic Beverages 6,305 6,870 565 7,932 1,628
6,959 7,275 316 5,944 (1,014)COGS ‐ Alcohol 38,620 29,378 (9,243)30,835 (7,785)
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
38,476 36,917 (1,558)33,856 (4,620)Total Cost of Sales 161,294 131,757 (29,537)128,101 (33,192)
================================================================================= ============================================================= ================
388,213 330,388 57,825 306,315 81,897 GROSS INCOME 1,762,191 1,510,633 251,558 1,530,974 231,217
Labor
29,374 34,134 4,760 25,627 (3,747)Golf Operation Labor 152,245 167,666 15,421 134,286 (17,959)
14,131 10,513 (3,618)14,642 511 General and Administrative 59,579 72,175 12,596 64,042 4,463
67,059 64,263 (2,796)65,354 (1,705)Maintenance and Landscaping 361,442 390,410 28,967 339,239 (22,203)
19,799 20,803 1,005 16,769 (3,030)F&B 115,917 99,921 (15,997)92,968 (22,949)
4,482 6,671 2,189 9,013 4,531 Sales and Marketing 38,707 33,528 (5,180)37,117 (1,590)
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
134,845 136,384 1,539 131,405 (3,440)Total Direct Labor 727,892 763,699 35,807 667,653 (60,239)
10,435 12,956 2,522 11,322 888 Total Payroll Taxes 56,846 72,551 15,706 59,076 2,230
(6,630)12,500 19,130 10,331 16,961 Total Medical/Health Benefits 35,894 75,000 39,106 62,214 26,320
2,310 2,080 (230)1,687 (624)Total Workmans Comp 11,969 12,380 411 10,121 (1,848)
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
6,115 27,536 21,421 23,340 17,225 Total Payroll Burden 104,709 159,931 55,222 131,410 26,701
================================================================================= ============================================================= ================
140,960 163,920 22,960 154,745 13,785 Total Labor 832,601 923,630 91,029 799,063 (33,538)
Other Operational Expenses
9,113 6,820 (2,293)8,906 (207)Golf Ops 43,665 31,395 (12,270)41,950 (1,715)
12,072 10,105 (1,967)17,383 5,311 G&A 63,667 62,285 (1,382)95,588 31,921
28,397 21,900 (6,497)20,443 (7,953)Maintenance 354,440 357,250 2,810 319,456 (34,984)
2,433 5,085 2,652 5,322 2,889 F&B 16,369 32,935 16,566 15,058 (1,311)
2,140 1,050 (1,090)910 (1,230)Sales and Marketing 11,924 11,300 (624)11,897 (26)
13,041 14,784 1,743 12,450 (591)Golf Cart Leases 78,246 88,704 10,458 74,700 (3,546)
0 0 0 0 0 Equipment Leases 0 0 0 41,928 41,928
32,545 51,800 19,255 47,111 14,566 Utilities ‐ Maintenance 516,480 684,000 167,520 591,417 74,936
15,023 14,775 (248)13,490 (1,533)Utilities ‐ G&A 93,673 84,980 (8,693)83,173 (10,500)
10,200 10,200 0 10,000 (200)Management Fees 61,200 61,200 0 60,000 (1,200)
3,681 3,300 (381)4,463 782 Insurance ‐ P&C 22,004 19,800 (2,204)26,778 4,775
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
128,644 139,819 11,175 140,478 11,834 Total Other Operational Expenses 1,261,669 1,433,849 172,180 1,361,946 100,277
================================================================================= ============================================================= ================
269,604 303,739 34,135 295,223 25,619 Total Expenses 2,094,270 2,357,479 263,209 2,161,009 66,739
================================================================================= ============================================================= ================
118,609 26,648 91,961 11,093 107,516 EBITDAR (332,079)(846,846)514,767 (630,035)297,956
================================================================================= ============================================================= ================
118,609 26,648 91,961 11,093 107,516 EBITDA (332,079)(846,846)514,767 (630,035)297,956
Interest Expense/Dep&Amt
0 0 0 450 450 Other Expense (343)0 343 13,040 13,383
0 0 0 0 0 Capital Improvements/Cap Reserve 10,560 0 (10,560)0 (10,560)
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
0 0 0 450 450 Total Interest Expense 10,217 0 (10,217)13,040 2,823
================================================================================= ============================================================= ================
118,609 26,648 91,961 10,643 107,966 Net Income (342,296)(846,846)504,550 (643,074)300,778
El Conquistador Golf Club
For the Month Ending December 31st, 2021
December YTD
ATTACHMENT D
December YTD Financial Status FY 2021/2022
Water Utility Fund
% Budget Completion through December --- 50%
% Actuals YE % Variance
to Budget to Budget
REVENUES:
CHARGES FOR SERVICES 1,658,491 3,255,000 51.0% 3,339,000 2.6%
INTEREST INCOME 29,693 100,000 29.7% 100,000 0.0%
MISCELLANEOUS 661,858 - 0.0% 662,000 0.0%
WATER SALES 7,656,427 13,974,000 54.8%14,247,000 2.0%
TOTAL REVENUES 10,006,469 17,329,000 57.7% 18,348,000 5.9%
% Actuals YE % Variance
to Budget to Budget
EXPENSES:
ADMINISTRATION 7,420,289 11,934,277 62.2% 11,934,277 0.0%
ENGINEERING & PLANNING 525,545 1,874,737 28.0% 1,874,737 0.0%
OPERATIONS 2,226,398 4,985,624 44.7% 4,985,624 0.0%
OTHER FINANCING USES 2,402 1,762,402 0.1%1,762,402 0.0%
TOTAL EXPENSES 10,174,634 20,557,040 49.5% 20,557,040 0.0%
SURPLUS/(DEFICIT) (168,165) (3,228,040) (2,209,040)
Excludes non-cash outlays for depreciation & amortization
* Year-end estimates are subject to further revision
Year End
Estimate *
Budget Year End
Estimate *
Actuals
thru 12/2021
Actuals
thru 12/2021
Budget
ATTACHMENT FConsolidated Year-to-Date Financial Report through December 2021FY 2021/2022FY 21/22 Capital Leases/Left in AccountsBegin Bal. Transfer OutThru Dec. 2021General Fund 32,408,542 26,096,525 26,096,525 2,685,314 13,320,400 14,985,243 203,657 31,194,614 27,310,453 Highway Fund 1,242,979 1,918,457 1,918,457 546,998 253,123 1,606,850 2,406,971 754,465 Grants and Contributions Fund - 146,998 146,998 25,372 40,611 65,983 81,015 Seizure & Forfeiture - Justice/State 266,810 22,074 22,074 80,743 80,743 208,141 Community Center Fund 2,676,793 4,136,131 4,136,131 246,765 1,100,656 1,603,128 50,146 3,000,695 3,812,229 Municipal Debt Service Fund 165,436 71,510 19,210,226 19,281,736 17,981,034 1,101,020 19,082,054 365,118 Oracle Road Debt Service Fund 4,194 13 13 - 4,207 Water Resource System & Dev. Impact Fee Fund 18,744,638 731,041 731,041 75,000 718,318 319,207 1,112,525 18,363,154 Townwide Roadway Dev Impact Fee Fund 1,978,878 152,110 152,110 46,905 46,905 2,084,083 Parks & Recreation Impact Fee Fund 316,645 49,145 49,145 - 365,790 Police Impact Fee Fund 168,764 34,260 34,260 117,750 117,750 85,274 Capital Fund 2,504,029 617,361 27,105,983 27,723,344 39,723 366,806 1,128,023 1,534,552 28,692,821 PAG/RTA Fund 1,248,618 17,890 17,890 254,756 254,756 1,011,752 Water Utility 13,666,981 10,006,469 10,006,469 2,402 1,543,735 3,928,073 485,402 4,215,022 10,174,634 13,498,816 Stormwater Utility 1,001,740 765,546 765,546 385,900 163,846 549,746 1,217,540 Benefit Self Insurance Fund 2,379,019 1,887,791 1,887,791 1,632,205 1,632,205 2,634,605 Recreation In-Lieu Fee Fund 17,045 55 55 - 17,100 Total 78,791,110 46,653,376 46,316,209 92,969,585 3,052,231 16,937,412 41,094,573 4,534,668 5,635,249 71,254,133 100,506,562 Fund RevenueOther Fin Sources/TfrsTotal InDebt Service Total OutPersonnel O&M Capital
ATTACHMENT E
December YTD Financial Status FY 2021/2022
Stormwater Utility Fund
% Budget Completion through December--50%
Actuals
thru 12/2021 Budget
%
Actuals
to
Budget
Year End
Estimate *
YE %
Variance
to Budget
REVENUES:
STATE GRANTS 16,906 300,000 5.6% 16,906 -94.4%
CHARGES FOR SERVICES 745,674 1,440,100 51.8% 1,490,000 3.5%
INTEREST INCOME 2,966 1,500 197.7%1,500 0.0%
TOTAL REVENUES 765,546 1,741,600 44.0% 1,508,406 -13.4%
Actuals
thru 12/2021 Budget
%
Actuals
to
Budget
Year End
Estimate *
YE %
Variance
to Budget
EXPENDITURES:
PERSONNEL 385,900 862,098 44.8% 862,098 0.0%
OPERATIONS & MAINTENANCE 163,846 617,935 26.5% 617,935 0.0%
CAPITAL - 857,374 0.0%404,000 -52.9%
TOTAL EXPENDITURES 549,746 2,337,407 23.5% 1,884,033 -19.4%
Does not include non-cash outlays for depreciation
SURPLUS / (DEFICIT) 215,800 (595,807) (375,627)
* Year-end estimates are subject to further revision
ATTACHMENT GGeneral Fund Local Sales Tax Collections FY 2021/22CATEGORY JULYAUGSEPOCTNOVDECJANFEBMARAPRMAYJUNETOTALConstruction Sales Tax 441,038 419,552 651,924 906,165 509,231 436,821 3,364,731 Utility Sales Tax 321,489 383,548 329,545 323,173 285,048 238,499 1,881,302 Retail Sales Tax 675,726 647,693 641,711 682,029 727,762 814,794 4,189,715 Bed Tax 130,217 117,012 93,538 108,884 392,162 157,378 999,191 Restaurant & Bar Sales Tax 172,386 162,947 172,178 195,482 227,724 191,664 1,122,382 All Other Local Sales Tax *181,767 180,252 164,385 191,016 284,083 217,626 1,219,129 TOTAL 1,922,624$ 1,911,004$ 2,053,282$ 2,406,749$ 2,426,009$ 2,056,782$ 12,776,451$ FY 2020/21CATEGORY JULYAUGSEPOCTNOVDECJANFEBMARAPRMAYJUNETOTALConstruction Sales Tax 643,435 471,705 517,101 483,032 384,176 321,621 305,338 241,562 254,568 450,343 409,924 442,859 4,925,664 Utility Sales Tax 267,771 337,260 350,040 360,019 286,715 249,286 245,891 271,681 241,698 227,632 221,458 205,402 3,264,853 Retail Sales Tax 647,068 579,089 560,008 613,570 607,315 709,153 889,306 606,222 620,243 748,368 700,138 692,038 7,972,518 Bed Tax 42,564 33,546 32,879 38,003 170,718 105,673 36,242 40,721 99,686 148,989 144,442 130,433 1,023,896 Restaurant & Bar Sales Tax 127,814 114,578 118,223 130,147 158,913 137,151 142,356 130,977 154,257 183,628 167,142 191,389 1,756,575 All Other Local Sales Tax *117,419 174,520 141,653 120,588 200,416 200,756 183,337 164,894 171,734 218,085 193,522 201,188 2,088,112 TOTAL 1,846,071$ 1,710,698$ 1,719,904$ 1,745,360$ 1,808,253$ 1,723,640$ 1,802,470$ 1,456,056$ 1,542,186$ 1,977,045$ 1,836,626$ 1,863,309$ 21,031,618$ * Note: Does not include cable franchise fees or sales tax audit revenues
ATTACHMENT HGeneral Fund State Shared RevenuesFY 2021/22CATEGORY JULYAUGSEPOCTNOVDECJANFEBMARAPRMAYJUNETOTALState Shared Income Tax 500,637 500,637 517,313 517,313 517,313 517,313 3,070,526 State Shared Sales Tax 291,674 534,620 464,795 538,626 428,064 680,044 2,937,823 County Auto Lieu 100,364 178,439 214,084 179,539 176,572 183,593 1,032,591 Smart and Safe- - - - - 113,051 TOTAL 892,675$ 1,213,696$ 1,196,192$ 1,235,478$ 1,121,949$ 1,494,001$ -$ -$ -$ -$ -$ -$ 7,153,990$ FY 2020/21CATEGORY JULYAUGSEPOCTNOVDECJANFEBMARAPRMAYJUNETOTALState Shared Income Tax 548,361 548,361 548,361 548,361 548,361 548,360 548,361 548,361 548,361 548,361 548,361 548,361 6,580,331 State Shared Sales Tax 243,577 413,638 354,744 490,371 357,106 523,608 454,947 376,182 433,435 572,504 533,021 709,210 5,462,343 County Auto Lieu 98,728 256,745 217,528 201,958 162,796 190,665 190,824 175,212 182,116 216,303 197,466 302,323 2,392,664 Smart and Safe- - - - - - - - - - - - - TOTAL 890,666$ 1,218,744$ 1,120,633$ 1,240,690$ 1,068,263$ 1,262,633$ 1,194,132$ 1,099,755$ 1,163,912$ 1,337,168$ 1,278,848$ 1,559,894$ 14,435,338$