HomeMy WebLinkAboutPackets - Budget and Finance Committee (37)
AGENDA
BUDGET AND FINANCE COMMISSION
REGULAR SESSION
SEPTEMBER 20, 2022
COUNCIL CHAMBERS
11000 N. LA CAÑADA DRIVE
REGULAR SESSION AT OR AFTER 4:00 PM
CALL TO ORDER
ROLL CALL
PLEDGE OF ALLEGIANCE
CALL TO AUDIENCE - at this time, any member of the public is allowed to address the Commission on any
issue not listed on today’s agenda. Pursuant to the Arizona open meeting law, individual Commission
members may ask Town staff to review the matter, ask that the matter be placed on a future agenda, or
respond to criticism made by speakers. However, the Commission may not discuss or take legal action on
matters raised during "Call to Audience." In order to speak during "Call to Audience", please specify what
you wish to discuss when completing the blue speaker card.
STAFF LIAISON REPORT
REGULAR SESSION AGENDA
1.REVIEW AND APPROVAL OF THE JUNE 21, 2022 REGULAR SESSION MEETING MINUTES
2.PRESENTATION AND POSSIBLE DISCUSSION OF THE TOWN'S FY 21/22 FINANCIAL UPDATE
THROUGH JUNE 2022 (Please reference attachments)
COUNCIL LIAISON COMMENTS
FUTURE AGENDA ITEMS
ADJOURNMENT
POSTED: 9/14/22 at 5 P.M. by D.T.
When possible, a packet of agenda materials as listed above is available for public inspection at least 24 hours prior
to the Commission meeting in the Town Clerk's Office 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 Commission meeting
at 229-4700.
INSTRUCTIONS TO SPEAKERS
Members of the public have the right to speak during any posted public hearing. However, those items not
listed as a public hearing are for consideration and action by the Commission during the course of their
business meeting. Members of the public may be allowed to speak on these topics at the discretion of the
Chair.
If you wish to address the Commission on any item(s) on this agenda, please complete a blue speaker card located
on the Agenda table at the back of the room and give it to the Recording Secretary. Please indicate on the
speaker card which item number and topic you wish to speak on, or if you wish to speak during “Call to
Audience,” please specify what you wish to discuss when completing the blue speaker card.
Please step forward to the podium when the Chair announces the item(s) on the agenda which you are interested in
addressing.
1. For the record, please state your name and whether or not you are a Town resident.
2. Speak only on the issue currently being discussed by the Commission. Please organize your speech, you will only
be allowed to address the Commission once regarding the topic being discussed.
3. Please limit your comments to 3 minutes.
4. During “Call to Audience”, you may address the Commission on any issue you wish.
5. Any member of the public speaking must speak in a courteous and respectful manner to those present.
Thank you for your cooperation.
“Notice of Possible Quorum of the Oro Valley Town Council, Boards, Commissions and Committees: In accordance
with Chapter 3, Title 38, Arizona Revised Statutes and Section 2-4-4 of the Oro Valley Town Code, a majority of the
Town Council, Board of Adjustment, Historic Preservation Commission, Parks and Recreation Advisory Board,
Stormwater Utility Commission, and Water Utility Commission may attend the above referenced meeting as a
member of the audience only.”
Budget and Finance Commission 1.
Meeting Date:09/20/2022
Submitted By:Alison Cote, Legal
SUBJECT:
REVIEW AND APPROVAL OF THE JUNE 21, 2022 REGULAR SESSION MEETING MINUTES
RECOMMENDATION:
Staff recommends approval
EXECUTIVE SUMMARY:
N/A
BACKGROUND OR DETAILED INFORMATION:
N/A
FISCAL IMPACT:
N/A
SUGGESTED MOTION:
"I move to approve (approve with changes) the June 21, 2022 regular session meeting minutes"
Attachments
Draft Minutes - 6/21/22
D R A F T
MINUTES
BUDGET AND FINANCE COMMISSION
REGULAR SESSION
JUNE 21, 2022
COUNCIL CHAMBERS
11000 N. LA CAÑADA DRIVE
REGULAR SESSION AT OR AFTER 4:00 PM
CALL TO ORDER - Acting Chair Mason called the meeting to order at 4:00 P.M.
ROLL CALL
Present: Michael Mason, Acting Chair
James Beasley, Commissioner
John Fortunato, Commissioner
Jack Longley, Commissioner
Absent:Cathy Solverson, Chair
Staff Present:David Gephart, Chief Financial Officer
Wendy Gomez, Finance and Budget Administrator
Chris Hutchison, Senior Budget Analyst
Joseph Winfield, Mayor
Joe Andrews, Chief Civil Deputy
PLEDGE OF ALLEGIANCE - Commissioner Fortunato led the group in the Pledge of Allegiance.
CALL TO AUDIENCE - No comments were received.
STAFF LIAISON REPORT
Chief Financial Officer David Gephart reported on the following:
- FY 2021/2022 is ending in one week.
- Budget for FY 2022/2023 was adopted at the last town council meeting.
- Class and compensation study.
- Condolences to John Latchford and his family.
REGULAR SESSION AGENDA
1.REVIEW AND APPROVAL OF THE MAY 17, 2022 REGULAR SESSION MEETING MINUTES
Motion by Commissioner James Beasley, seconded by Commissioner Jack Longley to approve the
May 17, 2022 meeting minutes as written.
Vote: 4 - 0 Carried
2.PRESENTATION AND POSSIBLE DISCUSSION OF THE TOWN'S FY 21/22 FINANCIAL UPDATE
THROUGH APRIL 2022
Finance and Budget Administrator Wendy Gomez presented on Agenda Item #2.
Discussion ensued amongst staff and commissioners.
3.PRESENTATION AND POSSIBLE DISCUSSION REGARDING THE TOWN'S FIVE-YEAR FINANCIAL
FORECAST THROUGH FY 2027/28
Finance and Budget Administrator Wendy Gomez presented on Agenda Item #3.
Discussion ensued amongst staff and commissioners.
4.PRESENTATION AND DISCUSSION OF THE TOWN FY2023 ADOPTED BUDGET
Chief Financial Officer David Gephart presented on Agenda Item #4.
Discussion ensued amongst staff and commissioners.
COUNCIL LIAISON COMMENTS
Mayor Joseph Winfield commented on the following:
- The next Town Council meeting is on July 6, 2022.
- The Class and Compensation Study will be on the agenda for the July 6, 2022 Town Council meeting.
FUTURE AGENDA ITEMS
No future agenda items were discussed.
ADJOURNMENT
Motion by Commissioner James Beasley, seconded by Commissioner Jack Longley to adjourn the
meeting at 5:05 P.M.
Vote: 4 - 0 Carried
I hereby certify that the foregoing minutes are a true and correct copy of the minutes of the regular session of the
Town of Oro Valley Budget and Finance Commission of Oro Valley, Arizona held on the 21 day of June, 2022. I
further certify that the meeting was duly called and held and that a quorum was present.
Dated this 23 day of June, 2022.
___________________________
Alison Cote
Legal Secretary
Budget and Finance Commission 2.
Meeting Date:09/20/2022
Submitted By:Christopher Hutchison, Finance
SUBJECT:
PRESENTATION AND POSSIBLE DISCUSSION OF THE TOWN'S FY 21/22 FINANCIAL UPDATE THROUGH
JUNE 2022 (Please reference attachments)
RECOMMENDATION:
N/A
EXECUTIVE SUMMARY:
Please reference attachments
BACKGROUND OR DETAILED INFORMATION:
Please reference attachments
FISCAL IMPACT:
N/A
SUGGESTED MOTION:
N/A
Attachments
Council Memo - June 2022 Financial Update
Attachment A - General Fund
Attachment B - Highway Fund
Attachment C-1 - Community Center Fund
Attachment C-2 Golf Contractor P&L
Attachment D - Summary All Funds
Attachment E - Gen Fund Local Sales Tax
Attachment F - Gen Fund State Shared Revenues
Town Manager’s Office
TOWN COUNCIL REPORT
DATE: September 21, 2022
TO: Mayor and Council
THRU: Mary Jacobs, Town Manager
FROM: David Gephart, Chief Financial Officer
SUBJECT: June 2022 Financial Update
This financial update is intended to provide an overview and status of revenues and expenditures for the
Town’s selected funds for fiscal year 2021/22 (July 2021 – June 2022). Funds included in this financial
update are the General Fund, Highway Fund and Community Center Fund. All amounts are preliminary,
un-audited and subject to change based upon adjusting entries, as necessary.
EXECUTIVE SUMMARY:
Staff is pleased to report that financial performance across all funds has exceeded expectations. In
addition, the Town’s major funds ended the year with expenditure savings. Further details on revenues
and expenditures are as follows.
General Fund
Overall, General Fund revenues and expenditures ended the fiscal year better than originally forecasted
(see attachment A). Revenues total $55.5 million or 117.9% of budget. Combined with expenditures ending
the fiscal year 4.7% below budget at $58.4 million, the General Fund preliminarily ended the fiscal year
with a use of fund balance of $2.9 million.
Highway Fund
Revenues and expenditures for the Highway Fund ended the fiscal year better than originally budgeted
(see attachment B). Revenues totaled approximately $4.0 million or 109.6% of budget, while expenditures
totaled $4.0 million or 98.7% of budget. The Highway Fund preliminarily ended the fiscal year with a use
of fund balance of $40,000.
Community Center Fund
Overall, year-end revenues and expenditures for the Community Center Fund performed better than
budgeted figures (see attachment C-1 & C-2). Revenues totaled $9.5 million or 128.3% of budget, while
expenditures totaled $6.3 million or 81.2% of budget. Due to strong revenues across the board, as well as
a reduced transfer out for debt service, the Community Center Fund preliminarily ended the fiscal year
with a surplus of $3.2 million.
BACKGROUND AND DETAILED INFORMATION:
GENERAL FUND
Attachment A shows General Fund revenues and expenditures through June 30, 2022. The preliminary
year-end amounts for the General Fund are as follows:
Revenues: $55,476,755
Less:
Expenditures: ($58,401,599)
Preliminary Estimated Decrease in Fund Balance: ($2,924,844)*
*Note that the budgeted decrease in fund balance for FY 21/22 is $14.2 million.
General Fund Revenues
• Local sales tax collections in the General Fund totaled $27.8 million or 131.4% of the budgeted
amount of $21.2 million, performing much better than anticipated. Retail collections totaled $8.9
million, which is $950,737 or 11.9% higher than collections from the prior fiscal year. Both
restaurant/bar collections as well as bed tax collections were up 38.6% and 132.9% respectively
compared to collections from the prior fiscal year. Construction sales tax collections totaled $6.9
million, which is $1,935,316 or 39.3% higher than collections from the prior fiscal year. Total local
sales tax revenue in the General Fund came in $6.6 million above budget due to strong
performance across most tax categories. Please see attachment E for detailed information on
General Fund local sales tax collections.
• License and permit revenues totaled $2.4 million or 129.3% of the budget amount of $1.8 million.
Single Family Residential (SFR) permits issued total 198 and are a large portion of this revenue
piece. This revenue category preliminarily came in $541,080 or 29.3% over budget due to
commercial building activity and rebounding residential permit issuances in the latter half of the
year.
• State shared revenues totaled $15.3 million or 111.6% of the budget amount of $13.7 million for
the fiscal year. These revenues sources are comprised of state shared sales taxes, state shared
income taxes, auto-lieu fees, and Smart and Safe shared taxes.
• Charges for services revenues totaled $2.7 million or 111.4% of the budget amount of $2.4 million
for the fiscal year. A large portion of these revenues are associated with Parks & Recreation
program revenues, which showed strong recovery.
General Fund Expenditures and Other Financing Uses
• General Fund outflows ended the fiscal year below budget by about $2.9 million, or 4.7%. This is
due to department savings in both personnel and O&M, capital project carry-over into next fiscal
year and transfers out.
• Transfers out of the General Fund were $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.
Preliminarily, the General Fund ended the fiscal year with a total fund balance of $29.5 million, or 54.7%
of budgeted expenditures.
HIGHWAY FUND
Highway Fund Revenues
• State shared highway user funds totaled about $4.0 million or 110.1% of the budget amount of $3.6
million for the fiscal year. This was anticipated as monthly distributions from the state remained
stronger than original projections. Overall, Highway Fund revenues ended the fiscal year with a
favorable budget variance of $352,000 or 9.6%.
Highway Fund Expenditures
• Highway Fund expenditures ended the fiscal year at $4.0 million or 98.7% of the adopted budget
of $4.1 million due to slight savings in personnel costs.
The Highway Fund preliminarily ended the fiscal year with a fund balance of approximately $1.2 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 totaled $9.5 million or 128.3% of the budget amount of
$7.4 million.
• Contracted operating revenues totaled about $4.7 million for the fiscal year which is $1.1 million or
30.5% higher than budgeted due to across-the-board outperformance. This is approximately
$755,000 or 19.0% higher than revenues from the time last fiscal year.
• Town operating revenues totaled $1.2 million, 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 ended the fiscal year with a favorable budget variance of $523,000 or 75.0%.
• Local sales tax revenues totaled $3.5 million, ending the fiscal year with a favorable budget
variance of nearly $603,000 or 20.6%.
Community Center Fund Expenditures and Other Financing Uses
• Outflows in the Community Center Fund totaled $6.3 million or 81.2% of the budgeted amount of
$7.8 million.
• Contracted operating expenditures totaled $4.7 million, or 100.1% of the budgeted amount of $4.7
million. Contracted expenditures ended the year slightly over budget due primarily to higher than
expected golf related revenue, resulting in higher cost of sales.
• Transfers out were $1.6 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.
• Preliminarily, the Community Center Fund ended the fiscal year with a surplus of $3.2 million and
a total fund balance of approximately $5.8 million.
The Town is not expecting any year-end sales tax support for golf operations. Contracted golf operations
have a preliminary net gain of $20,461 before HOA contributions of $159,050, and approximately $83,000
in local sales taxes generated from golf related operations.
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. See attachment D for a
fiscal year-to-date consolidated summary of all Town Funds. See attachment E and F for a breakdown of
monthly local sales tax collections and state shared revenue collections for the General Fund.
ATTACHMENT A
June YTD Financial Status
General Fund
% Budget Completion through June --- 100%
% Actuals YE % Variance
to Budget to Budget
REVENUES `
LOCAL SALES TAX 27,804,802 21,157,707 131.4% 27,804,802 31.4%
LICENSES & PERMITS 2,390,080 1,849,000 129.3% 2,390,080 29.3%
FEDERAL GRANTS 5,936,500 5,990,290 99.1% 5,936,500 -0.9%
STATE GRANTS 69,413 75,000 92.6% 69,413 -7.4%
STATE/COUNTY SHARED 15,317,760 13,729,923 111.6% 15,317,760 11.6%
OTHER INTERGOVERNMENTAL 1,674,819 1,344,500 124.6% 1,674,819 24.6%
CHARGES FOR SERVICES 2,660,066 2,387,776 111.4% 2,660,066 11.4%
FINES 132,636 125,000 106.1% 132,636 6.1%
INTEREST INCOME (778,663) 150,000 -519.1% (778,663) -619.1%
MISCELLANEOUS 269,342 264,000 102.0%269,342 2.0%
TOTAL REVENUES 55,476,755 47,073,196 117.9% 55,476,755 17.9%
% Actuals YE % Variance
to Budget to Budget
EXPENDITURES
CLERK 375,998 383,833 98.0% 375,998 -2.0%
COMMUNITY & ECON. DEV. 2,900,856 3,044,614 95.3% 2,900,856 -4.7%
COUNCIL 192,015 188,720 101.7% 192,015 1.7%
FINANCE 936,561 979,655 95.6% 936,561 -4.4%
GENERAL ADMINISTRATION 13,807,034 14,459,559 95.5% 13,807,034 -4.5%
HUMAN RESOURCES 480,631 535,390 89.8% 480,631 -10.2%
INNOVATION & TECHNOLOGY 4,042,073 4,346,583 93.0% 4,042,073 -7.0%
LEGAL 894,601 902,754 99.1% 894,601 -0.9%
MANAGER 1,074,627 1,115,224 96.4% 1,074,627 -3.6%
PARKS & RECREATION 3,460,952 3,446,361 100.4% 3,460,952 0.4%
POLICE 17,531,660 18,171,000 96.5% 17,531,660 -3.5%
PUBLIC WORKS 5,580,572 5,364,091 104.0% 5,580,572 4.0%
TOWN COURT 861,186 914,796 94.1% 861,186 -5.9%
TRANSFERS OUT 6,262,832 7,408,264 84.5%6,262,832 -15.5%
TOTAL EXPENDITURES 58,401,599 61,260,844 95.3% 58,401,599 -4.7%
CHANGE IN FUND BALANCE (2,924,844) (14,187,648) (2,924,844)
BEGINNING FUND BALANCE 32,408,542
Plus: Surplus / (Use of Fund Balance)(2,924,844)
ENDING FUND BALANCE **29,483,698
* Year-end estimates are subject to further revision
** Ending fund balance amounts are estimates and are subject to further revision
FY 2021/2022
Year End
Estimate *
Budget Year End
Estimate *
Actuals
thru 6/2022
Actuals
thru 6/2022
Budget
ATTACHMENT B
June YTD Financial Status FY 2021/2022
% Budget Completion through June --- 100%
Actuals
thru 6/2022 Budget % Actuals
to Budget
Year End
Estimate *
YE % Variance
to Budget
REVENUES -
LICENSES & PERMITS 28,838 25,000 115.4% 28,838 15.4%
STATE/COUNTY SHARED 3,979,751 3,614,922 110.1% 3,979,751 10.1%
INTEREST INCOME (16,304) 6,000 -271.7% (16,304) -371.7%
MISCELLANEOUS 7,261 2,000 363.1%7,261 263.1%
TOTAL REVENUES 3,999,546 3,647,922 109.6% 3,999,546 9.6%
Actuals
thru 6/2022 Budget % Actuals
to Budget
Year End
Estimate *
YE % Variance
to Budget
EXPENDITURES
TRANSPORTATION ENGINEERING 3,711,481 3,766,525 98.5% 3,711,481 -1.5%
STREET MAINTENANCE 324,058 324,000 100.0%324,058 0.0%
TOTAL EXPENDITURES 4,035,539 4,090,525 98.7% 4,035,539 -1.3%
CHANGE IN FUND BALANCE (35,993) (442,603) (35,993)
BEGINNING FUND BALANCE 1,242,978
Plus: Surplus / (Use of Fund Balance) (35,993)
ENDING FUND BALANCE ** 1,206,985
* Year-end estimates are subject to further revision
** Ending fund balance amounts are estimates and are subject to further revision
Highway Fund
ATTACHMENT C-1
June YTD Financial Status
% Budget Completion through June --- 100%
% Actuals YE % Variance
to Budget to Budget
REVENUES
CONTRACTED OPERATING REVENUES
Golf Revenues, Trail and Cart Fees 2,568,114 1,966,245 130.6% 2,568,114 30.6%
Member Dues 1,149,328 957,000 120.1% 1,149,328 20.1%
Food & Beverage 671,479 473,465 141.8% 671,479 41.8%
Merchandise & Other 337,423 225,675 149.5%337,423 49.5%
4,726,343 3,622,385 130.5% 4,726,343 30.5%
TOWN OPERATING REVENUES
Daily Drop-Ins 52,777 30,000 175.9% 52,777 75.9%
Member Dues 672,816 526,480 127.8% 672,816 27.8%
Recreation Programs 410,986 82,500 498.2% 410,986 398.2%
Swim Team/Swim Lessons - 8,000 0.0% - -100.0%
Facility Rental Income 84,069 50,500 166.5%84,069 66.5%
1,220,648 697,480 175.0% 1,220,648 75.0%
OTHER REVENUES
Local Sales Tax 3,535,507 2,932,798 120.6% 3,535,507 20.6%
Real Property Rental Income 19,502 19,502 100.0% 19,502 0.0%
Interest Income (174,959) 1,000 -17495.9% (174,959) -17595.9%
Miscellaneous 167,936 125,100 134.2%167,936 34.2%
3,547,986 3,078,400 115.3% 3,547,986 15.3%
TOTAL REVENUES 9,494,977 7,398,265 128.3% 9,494,977 28.3%
% Actuals YE % Variance
to Budget to Budget
EXPENDITURES
CONTRACTED OPERATING EXPENDITURES
Personnel 1,484,718 1,641,903 90.4% 1,484,718 -9.6%
Food & Beverage 630,508 445,441 141.5% 630,508 41.5%
Operations & Maintenance 2,454,978 2,429,634 101.0% 2,454,978 1.0%
Equipment Leases 135,678 184,550 73.5%135,678 -26.5%
4,705,882 4,701,528 100.1% 4,705,882 0.1%
TOWN OPERATING EXPENDITURES
Personnel 891,869 875,291 101.9% 891,869 1.9%
Operations & Maintenance 288,642 211,290 136.6%288,642 36.6%
1,180,511 1,086,581 108.6% 1,180,511 8.6%
CAPITAL OUTLAY 139,003 132,500 104.9% 139,003 4.9%
TRANSFERS OUT 296,346 1,868,519 15.9% 296,346 -84.1%
TOTAL EXPENDITURES 6,321,742 7,789,128 81.2% 6,321,742 -18.8%
CHANGE IN FUND BALANCE 3,173,235 (390,863) 3,173,235
BEGINNING FUND BALANCE 2,676,793
Plus: Surplus / (Use of Fund Balance)3,173,235
ENDING FUND BALANCE **5,850,028
* Year-end estimates are subject to further revision
** Ending fund balance amounts are estimates and are subject to further revision
FY 2021/2022
Actuals
thru 6/2022 Budget Year End
Estimate *
Community Center Fund
Actuals
thru 6/2022 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,587 1,800 787 2,156 431 Rounds ‐ Member 34,943 26,800 8,143 32,835 2,108
301 200 101 310 (9)Rounds ‐ Outing 7,969 3,980 3,989 4,061 3,908
1,908 1,200 708 3,261 (1,353)Rounds ‐ Public 54,199 45,070 9,129 49,810 4,389
====================================================================================================================================================================
4,796 3,200 1,596 5,727 (931)Total Rounds 97,111 75,850 21,261 86,706 10,405
Revenue
59,599 35,000 24,599 88,767 (29,168)Green Fees 2,238,443 1,684,975 553,468 1,916,178 322,265
23,007 19,045 3,962 22,626 381 Cart Fees 285,330 232,270 53,060 258,027 27,303
1,396 2,500 (1,104)3,680 (2,284)Driving Range 44,341 49,000 (4,659)50,432 (6,091)
0 0 0 0 0 Golf Cards/Passes 19,783 0 19,783 0 19,783
10,756 13,000 (2,244)8,797 1,959 Pro Shop Sales 240,598 201,600 38,998 218,420 22,178
22,977 8,100 14,877 21,421 1,556 Food (Food & Soft Drinks) 346,930 242,640 104,290 196,390 150,539
16,981 14,400 2,581 16,749 232 Beverages (Alcohol) 294,023 230,825 63,198 249,667 44,356
646 0 646 (695)1,341 Other Food & Beverage Revenue 30,526 0 30,526 2,725 27,801
1,083 250 833 1,136 (53)Other Golf Revenues (Club Rent, Handica 34,896 13,075 21,821 25,404 9,492
2,363 750 1,613 4,377 (2,013)Clinic / School Revenue 34,123 11,000 23,123 26,839 7,284
103,075 77,500 25,575 89,976 13,099 Dues Income ‐ Monthly Dues 1,149,328 959,500 189,828 1,021,503 127,825
(1,070)0 (1,070) (7,394)6,323 Miscellaneous Income and Discounts 8,023 0 8,023 5,278 2,744
================================================================================= ============================================================= ================
240,812 170,545 70,267 249,442 (8,630)Total Revenue 4,726,343 3,624,885 1,101,458 3,970,865 755,478
Cost of Sales
7,013 9,750 2,737 6,229 (784)COGS ‐ Pro Shop 162,001 148,680 (13,321)152,276 (9,725)
8,200 1,485 (6,715)8,704 504 COGS ‐ Food 100,729 64,330 (36,398)58,724 (42,005)
1,556 1,080 (476)1,256 (300)COGS ‐ Non‐Alcoholic Beverages 17,364 14,310 (3,054)14,935 (2,428)
4,380 4,320 (60)5,069 689 COGS ‐ Alcohol 88,136 69,248 (18,889)73,924 (14,213)
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
21,148 16,635 (4,513)21,257 109 Total Cost of Sales 368,230 296,568 (71,662)299,859 (68,371)
================================================================================= ============================================================= ================
219,663 153,910 65,753 228,185 (8,521)GROSS INCOME 4,358,113 3,328,317 1,029,796 3,671,006 687,108
Labor
25,301 21,238 (4,063)28,115 2,814 Golf Operation Labor 358,485 352,399 (6,086)304,492 (53,993)
32,304 10,213 (22,091)25,454 (6,850)General and Administrative 137,769 138,650 881 132,708 (5,060)
64,173 63,624 (549)68,953 4,780 Maintenance and Landscaping 704,456 778,707 74,251 687,148 (17,308)
20,298 14,653 (5,645)18,124 (2,174)F&B 272,355 216,391 (55,964)203,395 (68,960)
5,584 5,171 (413)5,282 (302)Sales and Marketing 76,843 69,555 (7,288)74,297 (2,545)
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
147,660 114,899 (32,761)145,927 (1,732)Total Direct Labor 1,549,907 1,555,702 5,795 1,402,041 (147,866)
13,040 10,915 (2,125)12,859 (181)Total Payroll Taxes 125,265 147,792 22,527 126,077 812
9,320 12,500 3,180 8,259 (1,061)Total Medical/Health Benefits 103,944 150,000 46,056 121,276 17,332
2,164 2,055 (109)1,738 (426)Total Workmans Comp 28,116 24,810 (3,306)20,677 (7,439)
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
24,524 25,470 946 22,857 (1,668)Total Payroll Burden 257,325 322,602 65,276 268,029 10,704
================================================================================= ============================================================= ================
172,184 140,369 (31,815)168,784 (3,400)Total Labor 1,807,232 1,878,304 71,071 1,670,070 (137,162)
Other Operational Expenses
5,156 3,375 (1,781)7,332 2,176 Golf Ops 94,324 60,230 (34,094)83,747 (10,577)
40,819 7,676 (33,143)55,441 14,622 G&A 180,132 131,101 (49,031)213,509 33,378
64,164 26,150 (38,014)43,993 (20,171)Maintenance 603,605 513,166 (90,439)485,703 (117,902)
67,322 4,235 (63,087)18,510 (48,812)F&B 101,765 61,145 (40,620)47,830 (53,935)
4,725 1,050 (3,675)640 (4,084)Sales and Marketing 23,942 22,875 (1,067)26,902 2,960
2,353 16,333 13,980 13,041 10,688 Golf Cart Leases 135,678 178,954 43,276 152,946 17,268
0 0 0 0 0 Equipment Leases 0 0 0 41,928 41,928
129,626 114,110 (15,516)114,467 (15,159)Utilities ‐ Maintenance 999,752 1,154,710 154,958 993,758 (5,994)
18,655 18,000 (655) (63,416) (82,071)Utilities ‐ G&A 186,987 166,880 (20,107)167,925 (19,062)
10,200 10,200 0 10,000 (200)Management Fees 122,400 122,400 0 120,000 (2,400)
0 0 0 0 0 Taxes ‐ Personal Property 4,599 0 (4,599)0 (4,599)
6,262 3,300 (2,962)3,380 (2,882)Insurance ‐ P&C 48,990 39,600 (9,390)51,418 2,428
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
349,282 204,429 (144,853)203,388 (145,894)Total Other Operational Expenses 2,502,174 2,451,061 (51,113)2,385,668 (116,506)
================================================================================= ============================================================= ================
521,466 344,798 (176,667)372,172 (149,294)Total Expenses 4,309,407 4,329,365 19,958 4,055,739 (253,668)
================================================================================= ============================================================= ================
(301,802)(190,888)(110,914)(143,987)(157,815)EBITDAR 48,706 (1,001,047)1,009,838 (384,733)940,776
================================================================================= ============================================================= ================
(301,802)(190,888)(110,914)(143,987)(157,815)EBITDA 48,706 (1,001,047)1,009,838 (384,733)940,776
Interest Expense/Dep&Amt
0 0 0 144,700 144,700 Other Expense (343)0 343 201,314 201,657
0 0 0 0 0 Capital Improvements/Cap Reserve 28,589 0 (28,589)0 (28,589)
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
0 0 0 144,700 144,700 Total Interest Expense 28,246 0 (28,246)201,314 173,068
================================================================================= ============================================================= ================
(301,802)(190,888)(110,914)(288,687)(13,115)Net Income 20,461 (1,001,047)1,038,084 (586,047)767,708
El Conquistador Golf Club
For the Month Ending June 30th, 2022
June YTD
ATTACHMENT DConsolidated Year-to-Date Financial Report through June 2022FY 2021/2022FundFY 21/22Beginning BalanceRevenueOther Fin Sources/Transfers InTotal In Personnel O&M CapitalDebt ServiceOther Fin Uses/ Transfers OutTotal OutFund Balance Through June 2022General Fund 32,408,542 55,476,755 55,476,755 30,011,951 21,515,210 611,606 6,262,832 58,401,599 29,483,698 Highway Fund 1,242,978 3,999,546 3,999,546 1,175,502 604,387 2,255,650 4,035,539 1,206,985 Grants and Contributions Fund - 163,440 100,000 263,440 26,182 64,393 90,575 172,865 Seizure & Forfeiture - Justice/State 266,810 102,014 102,014 123,461 123,461 245,363 Community Center Fund 2,676,793 9,494,977 9,494,977 2,376,587 3,374,128 139,003 432,024 6,321,742 5,850,028 Municipal Debt Service Fund 165,436 136,290 19,357,365 19,493,655 17,981,892 1,517,152 19,499,044 160,047 Oracle Road Debt Service Fund 4,194 104 104 4,298 4,298 - Water Resource System & Dev. Impact Fee Fund 18,744,638 687,900 294,224 982,124 150,000 1,439,606 319,207 1,908,813 17,817,949 Townwide Roadway Dev Impact Fee Fund 1,978,878 185,575 185,575 196,905 196,905 1,967,548 Parks & Recreation Impact Fee Fund 316,645 192,829 192,829 - 509,474 Police Impact Fee Fund 168,764 81,545 81,545 117,750 117,750 132,559 Capital Fund 2,504,029 1,258,214 30,583,500 31,841,714 110,407 368,549 9,573,593 201,067 10,253,616 24,092,127 PAG/RTA Fund 1,248,618 13,614 13,614 458,866 458,866 803,366 Water Utility 13,666,981 18,011,688 201,067 18,212,755 3,365,410 8,285,422 2,040,804 4,215,022 296,626 18,203,284 13,676,452 Stormwater Utility 1,001,740 1,483,587 1,483,587 844,909 313,509 1,158,418 1,326,909 Benefit Self Insurance Fund 2,379,019 3,740,677 3,740,677 3,275,441 3,275,441 2,844,255 Recreation In-Lieu Fee Fund 17,045 (428) (428) - 16,617 Total 78,791,109 95,028,327 50,536,156 145,564,483 37,884,766 56,018,181 16,780,426 6,051,381 7,314,597 124,049,351 100,306,241
ATTACHMENT EGeneral Fund Local Sales Tax Collections FY 2021/22CATEGORY JULYAUGSEPOCTNOVDECJANFEBMARAPRMAYJUNETOTALConstruction Sales Tax 441,038 419,552 651,924 906,165 509,231 436,821 829,833 525,234 491,178 601,856 466,142 582,006 6,860,980 Utility Sales Tax 321,489 383,548 329,545 323,173 285,048 238,499 253,620 474,092 115,418 252,114 234,820 261,849 3,473,215 Retail Sales Tax 675,726 647,693 641,711 682,029 727,762 814,794 1,015,258 701,089 686,381 818,648 793,639 718,525 8,923,255 Bed Tax 130,217 117,012 93,538 108,884 392,162 157,378 205,021 181,927 257,471 321,178 247,836 171,705 2,384,329 Restaurant & Bar Sales Tax 172,386 162,947 172,178 195,482 227,724 191,664 226,775 199,622 206,978 233,228 226,654 219,474 2,435,113 All Other Local Sales Tax *181,767 180,252 164,385 191,016 284,083 217,626 274,274 225,090 254,639 285,717 248,743 221,793 2,729,386 TOTAL 1,922,624$ 1,911,004$ 2,053,282$ 2,406,749$ 2,426,009$ 2,056,782$ 2,804,781$ 2,307,054$ 2,012,065$ 2,512,741$ 2,217,835$ 2,175,352$ 26,806,278$ 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 FGeneral Fund State Shared RevenuesFY 2021/22CATEGORY JULYAUGSEPOCTNOVDECJANFEBMARAPRMAYJUNETOTALState Shared Income Tax 500,637 500,637 517,313 517,313 517,313 517,313 517,313 517,313 517,313 517,313 517,313 517,313 6,174,404 State Shared Sales Tax 291,674 534,620 464,795 538,626 428,064 680,044 569,532 458,855 555,746 671,412 521,466 922,244 6,637,078 County Auto Lieu 100,364 178,439 214,084 179,539 176,572 183,593 166,138 185,396 187,906 231,739 168,035 298,521 2,270,326 Smart and Safe- - - - - 113,051 - 59 15 - - 122,828 235,953 TOTAL 892,675$ 1,213,696$ 1,196,192$ 1,235,478$ 1,121,949$ 1,494,001$ 1,252,983$ 1,161,623$ 1,260,980$ 1,420,464$ 1,206,814$ 1,860,906$ 15,317,760$ 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- - - - - - - - - - - 47,246 47,246 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,607,140$ 14,482,584$