HomeMy WebLinkAboutPackets - Budget and Finance Committee (38)
AGENDA
BUDGET AND FINANCE COMMISSION
REGULAR SESSION
DECEMBER 13, 2022
ORO VALLEY 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 NOVEMBER 15, 2022 REGULAR SESSION MEETING MINUTES
2.PRESENTATION AND POSSIBLE DISCUSSION OF THE TOWN'S FY 22/23 FINANCIAL UPDATE
THROUGH OCTOBER 2022 (Please reference attachments)
COUNCIL LIAISON COMMENTS
FUTURE AGENDA ITEMS
ADJOURNMENT
POSTED: 12/9/22 at 5 PM by dt
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:12/13/2022
Submitted By:Alison Cote, Legal
SUBJECT:
REVIEW AND APPROVAL OF THE NOVEMBER 15, 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 November 15, 2022 regular session meeting minutes."
Attachments
Draft Minutes - 11/15/22
D R A F T
MINUTES
BUDGET AND FINANCE COMMISSION
REGULAR SESSION
NOVEMBER 15, 2022
COUNCIL CHAMBERS
11000 N. LA CAÑADA DRIVE
REGULAR SESSION AT OR AFTER 4:00 PM
CALL TO ORDER - Chair Solverson called the meeting to order at 4:00 P.M.
ROLL CALL
Present: Cathy Solverson, Chair
Michael Mason, Vice Chair
James Beasley, Commissioner
John Fortunato, Commissioner
Staff Present:David Gephart, Chief Financial Officer
Wendy Gomez, Deputy Finance Director
Tobin Sidles, Legal Services Director
Joseph Winfield, Mayor
Milini Simms, Principle Planner
PLEDGE OF ALLEGIANCE - Chair Solverson 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:
- There are three openings for the Budget and Finance Commission.
- Interviews will be held for the openings next week.
REGULAR SESSION AGENDA
1.REVIEW AND APPROVAL OF THE OCTOBER 18, 2022 REGULAR SESSION MEETING MINUTES
Motion by Commissioner James Beasley, seconded by Commissioner John Fortunato to approve the
October 18, 2022 regular session meeting minutes as written.
Vote: 4 - 0 Carried
2.REVIEW, DISCUSSION AND POSSIBLE ACTION ON PROPOSED FINANCIAL AND BUDGETARY
2.REVIEW, DISCUSSION AND POSSIBLE ACTION ON PROPOSED FINANCIAL AND BUDGETARY
POLICIES
Chief Financial Officer David Gephart led the discussion regarding Agenda Item #2.
Discussion ensued amongst staff and commissioners.
Motion by Commissioner James Beasley, seconded by Chair Cathy Solverson to recommend the
proposed financial and budgetary policies be sent to the Oro Valley Town Council for approval.
Vote: 4 - 0 Carried
3.PRESENTATION AND POSSIBLE DISCUSSION OF THE TOWN'S FY 22/23 FINANCIAL UPDATE
THROUGH SEPTEMBER 2022 (Please reference attachments)
Deputy Finance Director Wendy Gomez presented on Agenda Item #3.
Discussion ensued amongst staff and commissioners.
4.PRESENTATION OF STATUS UPDATE ON VARIOUS PROJECTS
Chief Financial Officer David Gephart presented on Agenda Item #4.
Discussion ensued amongst staff and commissioners.
5.DISCUSSION REGARDING OPPORTUNITIES FOR THE COMMISSION TO PARTICIPATE IN THE
NEXT 10-YEAR GENERAL PLAN UPDATE.
Principle Planner Milini Simms presented on Agenda Item #5.
Discussion ensued amongst staff and commissioners.
COUNCIL LIAISON COMMENTS
Mayor Joseph Winfield left the meeting early and did not address the Commission.
FUTURE AGENDA ITEMS
No comments were received.
ADJOURNMENT
Motion by Vice Chair Michael Mason, seconded by Commissioner James Beasley to adjourn the
meeting at 5:10 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 15 day of November,
2022. I further certify that the meeting was duly called and held and that a quorum was present.
Dated this 22 day of November, 2022.
___________________________
Andrea Sirois
Executive Assistant to Town Manager, Mayor and Council
Budget and Finance Commission 2.
Meeting Date:12/13/2022
Submitted By:Christopher Hutchison, Finance
SUBJECT:
PRESENTATION AND POSSIBLE DISCUSSION OF THE TOWN'S FY 22/23 FINANCIAL UPDATE THROUGH
OCTOBER 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 - October 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: January 4, 2023
TO: Mayor and Council
THRU: Chris Cornelison, Interim Town Manager
FROM: David Gephart, Chief Financial Officer
SUBJECT: October 2022 Financial Update
This financial update is intended to provide an overview and status of revenues and expenditures for the
Town’s selected funds through October 2022 for fiscal year 2022/23. 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. Estimates reflected in monthly financial updates may not include
adjusting audit entries required at year-end.
EXECUTIVE SUMMARY:
Revenues are performing well compared to budget, and expenditures are trending as expected. Further
details on revenues and expenditures are as follows.
General Fund
In the General Fund (see attachment A), revenues total $16.6 million or 32.7% of budget, while
expenditures are at $21 million or 32.6% of the total budget.
Highway Fund
In the Highway Fund (see attachment B), revenues total $1,338,623 or 32.2% of budget, while
expenditures total $556,267 or 12% of budget.
Community Center Fund
In the Community Center Fund (see attachment C-1 & C-2), revenues total $2.5 million or 29% of budget,
while expenditures total $4.6 million or 34.8% of budget.
BACKGROUND AND DETAILED INFORMATION:
GENERAL FUND
Attachment A shows General Fund revenues and expenditures through October, as well as year-end
estimates for each category. The estimated year-end projections in the General Fund are as follows:
Revenues: $53,539,838
Less:
Expenditures: ($49,106,823)
Other Financing Uses ($16,446,977)
Preliminary Estimated Decrease in Fund Balance: ($12,013,962)*
*The estimated decrease in fund balance is due to a budgeted transfer of $13.5 million of fund balance to
the Capital Fund for CIP projects.
General Fund Revenues
• Local sales tax collections in the General Fund total $8.5 million or 33.7% of the budgeted amount
of $25.3 million and are performing better than anticipated. Retail collections total $2.8 million,
which is $154,487 or 5.8% higher than the same time period last fiscal year. Both restaurant/bar
collections and bed tax collections are up 9.7% and 18.2% respectively, compared to the same
time period last fiscal year. Construction sales tax collections total $2.2 million through October,
which is $198,158 or 8.2% less than collections from the same time period last fiscal year, due to
a large payment of back taxes in October of the prior year. Total local sales tax revenue is expected
to come in nearly $1.3 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 total $546,620 or 24.6% of the budget amount of $2.2 million. Single
Family Residential (SFR) permits issued through October total 59 and are a large portion of this
revenue piece. License and permit revenues are expected to come in $260,000 over budget, due
to revised permitting estimates from expected commercial development activity.
• State shared revenues total $5.7 million or 32.5% of the budget amount of $17.6 million. These
revenue 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 $956,000 over budget due to higher than expected state sales tax collections.
• Charges for services revenues total $973,597 or 32% of the budget amount of $3.0 million. Cost
allocation charges to the Town’s enterprise funds for services provided, as well as Parks &
Recreation fees, make up the bulk of this revenue category. Charges for services are forecasted
to come in $93,000 under budget at this time, due primarily to farebox revenues as fee waivers are
expected to continue through the end of the fiscal year.
• Miscellaneous revenue are forecast to come in $340,000 over budget due primarily to a rebate
received from the Arizona Municipal Risk Retention Pool (AMRRP).
General Fund Expenditures
• General Fund expenditures total $21 million or 32.6% of budget through October.
• Please note that the $885,000 Vistoso Trails Nature Preserve settlement payment is included in
the year-end estimates for General Administration. Strong revenue performance, combined with
other areas of expenditure savings, are expected to make up for the payment. Staff will continue to
closely monitor this and keep Council apprised.
• Transfers out of the General Fund are expected to end the fiscal year on budget. Note that actuals
through October reflect the budgeted transfer to debt service and 1/3 of the budgeted transfer to
the Capital Fund for CIP.
The General Fund is expected to end the fiscal year with a total fund balance of $18.4 million, or 38.2% of
budgeted expenditures, exceeding Council policy by $6.3 million.
HIGHWAY FUND
Highway Fund Revenues
• State shared highway user funds total $1.3 million or 31.4% of the budget amount of $4.1 million.
These revenues are projected to come in on budget at this time. Other minor revenue sources in
the Highway Fund are expected to come in at a favorable budget variance of $4,000 or 0.1% due
to a vendor refund of prior year invoice credits that was owed to the Town.
Highway Fund Expenditures
• Highway Fund expenditures though October are at $556,267 or 12% of the adopted budget of $4.7
million. The pavement preservation program began in October; however, the first invoices were
paid in November. Highway Fund expenditures are projected to come in on budget at this time.
The Highway Fund is expected to end the fiscal year with a fund balance of $721,897.
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 golf, and 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 October total $1.8 million or 29% of the budget
amount of $8.5 million.
• Contracted operating revenues total $1.1 million through October. This is approximately $33,000
or 3.1% more than revenues from the same time period last fiscal year due to higher memberships
and food & beverage sales. At this time, contracted revenues are estimated to be on budget.
Contractor revenues are expected to be less than the prior year due to planned course closures for
the irrigation project.
• Town operating revenues for October are $280,319 or 31.6% of the budget amount of $887,800.
Town operating revenues are expected to end the fiscal year about $5,000 higher than budget due
to stronger than expected daily drop-ins.
• Local sales tax revenues for October total $1.1 million or 31.5% of the budget amount of $3.5
million. These collections are currently projected to come in $127,000 over budget, due to positive
trends in retail, remote seller, and restaurant/bar collections.
Community Center Fund Expenditures
• Expenditures in the Community Center Fund total $4.6 million or 34.8% of the budgeted amount
of $13.2 million.
• Contracted operating expenditures total $1.7 million, or 36.1% of the budgeted amount of $4.7
million. Contracted expenditures are currently estimated to come in on budget.
• Town operating expenditures expenditures are currently estimated to come in approximately
$70,000 over budget due to Town operating personnel costs increases from full implementation of
the new pay plan earlier in the year.
• Transfers out are expected to end the year about $258,414, or 6.3% higher than budget due to the
Council directive to transfer all fund balance in excess of $1 million to the Capital Fund to be used
for the golf irrigation project. Note that actuals through October reflect the budgeted transfer out to
debt service.
• At this time, the Community Center Fund is projected to end the fiscal year with a total fund balance
of $1 million.
The year-end sales tax support for golf operations is estimated to be $464,419. This figure includes a
budgeted $743,469 loss for contracted golf operations, offset by $159,050 in outside HOA contributions
and approximately $120,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
October YTD Financial Status
General Fund
% Budget Completion through October --- 33.33%
% Actuals YE % Variance
to Budget to Budget
REVENUES `
LOCAL SALES TAX 8,523,910 25,270,959 33.7% 26,528,407 5.0%
LICENSES & PERMITS 546,620 2,223,824 24.6% 2,558,824 15.1%
FEDERAL GRANTS 134,781 380,000 35.5% 397,000 4.5%
STATE GRANTS 23,266 75,000 31.0% 95,000 26.7%
STATE/COUNTY SHARED 5,727,363 17,605,693 32.5% 18,560,279 5.4%
OTHER INTERGOVERNMENTAL 156,038 1,613,000 9.7% 1,613,000 0.0%
CHARGES FOR SERVICES 973,597 3,046,515 32.0% 2,953,483 -3.1%
FINES 33,359 125,000 26.7% 95,000 -24.0%
INTEREST INCOME 144,006 150,000 96.0% 150,000 0.0%
MISCELLANEOUS 348,591 249,000 140.0%588,845 136.5%
TOTAL REVENUES 16,611,531 50,738,991 32.7% 53,539,838 5.5%
% Actuals YE % Variance
to Budget to Budget
EXPENDITURES
CLERK 144,378 422,705 34.2% 422,705 0.0%
COMMUNITY & ECON. DEV. 1,030,808 3,280,764 31.4% 3,397,472 3.6%
COUNCIL 111,470 199,145 56.0% 199,145 0.0%
FINANCE 282,024 1,111,460 25.4% 1,083,460 -2.5%
GENERAL ADMINISTRATION 1,723,481 4,077,234 42.3% 4,924,234 20.8%
HUMAN RESOURCES 179,053 569,905 31.4% 569,905 0.0%
INNOVATION & TECHNOLOGY 1,818,464 4,797,809 37.9% 4,797,809 0.0%
LEGAL 295,018 1,015,753 29.0% 1,015,753 0.0%
MANAGER 345,093 1,160,173 29.7% 1,281,805 10.5%
PARKS & RECREATION 1,151,923 3,775,162 30.5% 3,775,162 0.0%
POLICE 5,500,728 20,403,472 27.0% 20,403,472 0.0%
PUBLIC WORKS 1,574,545 6,200,227 25.4% 6,176,227 -0.4%
TOWN COURT 308,739 1,059,674 29.1% 1,059,674 0.0%
TRANSFERS OUT 6,548,965 16,446,977 39.8%16,446,977 0.0%
TOTAL EXPENDITURES 21,014,691 64,520,460 32.6% 65,553,800 1.6%
CHANGE IN FUND BALANCE (4,403,159) (13,781,469) (12,013,962)
BEGINNING FUND BALANCE 30,390,425
Plus: Surplus / (Use of Fund Balance)(12,013,962)
ENDING FUND BALANCE **18,376,463
* Year-end estimates are subject to further revision
** Ending fund balance amounts are estimates and are subject to further revision
FY 2022/2023
Year End
Estimate *
Budget Year End
Estimate *
Actuals
thru 10/2022
Actuals
thru 10/2022
Budget
ATTACHMENT B
October YTD Financial Status FY 2022/2023
% Budget Completion through October --- 33.33%
Actuals
thru 10/2022 Budget % Actuals
to Budget
Year End
Estimate *
YE % Variance
to Budget
REVENUES -
LICENSES & PERMITS 10,548 25,000 42.2% 25,000 0.0%
STATE/COUNTY SHARED 1,295,810 4,127,100 31.4% 4,127,100 0.0%
INTEREST INCOME 26,363 8,000 329.5% 8,000 0.0%
MISCELLANEOUS 5,902 3,000 196.7%7,000 133.3%
TOTAL REVENUES 1,338,623 4,163,100 32.2% 4,167,100 0.1%
Actuals
thru 10/2022 Budget % Actuals
to Budget
Year End
Estimate *
YE % Variance
to Budget
EXPENDITURES
TRANSPORTATION ENGINEERING 396,889 4,192,089 9.5% 4,192,089 0.0%
STREET MAINTENANCE 159,378 460,100 34.6%460,100 0.0%
TOTAL EXPENDITURES 556,267 4,652,189 12.0% 4,652,189 0.0%
CHANGE IN FUND BALANCE 782,356 (489,089) (485,089)
BEGINNING FUND BALANCE 1,206,986
Plus: Surplus / (Use of Fund Balance) (485,089)
ENDING FUND BALANCE ** 721,897
* 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
October YTD Financial Status
% Budget Completion through October --- 33.33%
% Actuals YE % Variance
to Budget to Budget
REVENUES
CONTRACTED OPERATING REVENUES
Golf Revenues, Trail and Cart Fees 413,581 2,060,519 20.1% 2,060,519 0.0%
Member Dues 402,306 1,102,500 36.5% 1,102,500 0.0%
Food & Beverage 183,506 546,350 33.6% 546,350 0.0%
Merchandise & Other 74,582 270,780 27.5%270,780 0.0%
1,073,975 3,980,149 27.0% 3,980,149 0.0%
TOWN OPERATING REVENUES
Daily Drop-Ins 9,088 30,000 30.3% 35,000 16.7%
Member Dues 201,533 620,500 32.5% 620,500 0.0%
Recreation Programs 47,247 170,000 27.8% 170,000 0.0%
Facility Rental Income 22,451 67,300 33.4%67,300 0.0%
280,319 887,800 31.6% 892,800 0.6%
OTHER REVENUES
Local Sales Tax 1,096,320 3,477,236 31.5% 3,603,855 3.6%
Interest Income 19,886 3,000 662.9% 3,000 0.0%
Miscellaneous 15 159,150 0.0%159,150 0.0%
1,116,221 3,639,386 30.7% 3,766,005 3.5%
TOTAL REVENUES 2,470,515 8,507,335 29.0% 8,638,954 1.5%
% Actuals YE % Variance
to Budget to Budget
EXPENDITURES
CONTRACTED OPERATING EXPENDITURES
Personnel 502,355 1,728,134 29.1% 1,728,134 0.0%
Food & Beverage 161,988 487,863 33.2% 487,863 0.0%
Operations & Maintenance 999,133 2,344,939 42.6% 2,344,939 0.0%
Equipment Leases 43,024 162,682 26.4%162,682 0.0%
1,706,500 4,723,618 36.1% 4,723,618 0.0%
TOWN OPERATING EXPENDITURES
Personnel 322,985 920,274 35.1% 990,000 7.6%
Operations & Maintenance 215,461 775,299 27.8%775,299 0.0%
538,446 1,695,573 31.8% 1,765,299 4.1%
CAPITAL OUTLAY 312,105 2,666,700 11.7% 2,666,700 0.0%
TRANSFERS OUT 2,028,066 4,085,380 49.6% 4,343,794 6.3%
TOTAL EXPENDITURES 4,585,117 13,171,271 34.8% 13,499,411 2.5%
CHANGE IN FUND BALANCE (2,114,602) (4,663,936) (4,860,457)
BEGINNING FUND BALANCE 5,860,458
Plus: Surplus / (Use of Fund Balance)(4,860,457)
ENDING FUND BALANCE **1,000,000
* Year-end estimates are subject to further revision
** Ending fund balance amounts are estimates and are subject to further revision
FY 2022/2023
Actuals
thru 10/2022 Budget Year End
Estimate *
Community Center Fund
Actuals
thru 10/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
3,149 2,500 649 2,630 519 Rounds ‐ Member 11,099 7,300 3,799 8,567 2,532
38 100 (62)283 (245)Rounds ‐ Outing 708 550 158 1,154 (446)
2,084 1,200 884 2,394 (310)Rounds ‐ Public 8,980 4,000 4,980 11,516 (2,536)
====================================================================================== ==================================================================================
5,271 3,800 1,471 5,307 (36)Total Rounds 20,787 11,850 8,937 21,237 (450)
Revenue
90,034 52,000 38,034 91,428 (1,394)Green Fees 310,724 123,500 187,224 361,463 (50,740)
24,457 21,100 3,357 23,275 1,182 Cart Fees 94,706 84,250 10,456 88,531 6,175
5,012 2,500 2,512 4,887 125 Driving Range 8,151 7,000 1,151 12,951 (4,799)
00000Golf Cards/Passes 0 0 0 0 0
13,928 10,050 3,878 10,695 3,233 Pro Shop Sales 46,884 41,125 5,759 47,947 (1,063)
38,162 19,300 18,862 26,389 (1,093)Food (Food & Soft Drinks) 103,923 73,150 30,773 88,764 2,293
24,231 18,930 5,301 20,601 3,630 Beverages (Alcohol) 77,159 64,360 12,799 71,181 5,978
356 700 (344)737 (382)Other Food & Beverage Revenue 2,424 965 1,459 550 1,874
6,737 1,175 5,562 1,566 5,170 Other Golf Revenues (Club Rent, Handicap 10,668 3,925 6,743 5,077 5,591
2,624 2,500 124 3,154 (529)Clinic / School Revenue 10,168 5,050 5,118 6,744 3,424
111,050 88,500 22,550 90,483 20,566 Dues Income ‐ Monthly Dues 402,306 354,000 48,306 358,442 43,864
2,237 100 2,137 (1,024)3,261 Miscellaneous Income and Discounts 6,861 400 6,461 (472)7,333
==================================================================================== ===============================================================================
318,827 216,855 101,972 272,191 33,769 Total Revenue 1,073,975 757,725 316,250 1,041,178 19,930
Cost of Sales
10,035 7,035 (3,000)12,476 2,441 COGS ‐ Pro Shop 39,617 28,788 (10,829)39,067 (550)
9,992 5,561 (4,432)6,329 (3,663)COGS ‐ Food 30,508 20,823 (9,685)23,447 (7,061)
1,743 784 (959)1,027 (716)COGS ‐ Non‐Alcoholic Beverages 5,966 3,216 (2,750)3,889 (2,076)
6,147 5,798 (350)6,296 149 COGS ‐ Alcohol 20,324 19,615 (708)22,242 1,918
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
27,918 19,177 (8,741)26,129 (1,789)Total Cost of Sales 96,414 72,442 (23,972)88,645 (7,769)
==================================================================================== ===============================================================================
290,909 197,678 93,231 246,063 31,980 GROSS INCOME 977,561 685,283 292,277 952,533 12,162
Labor
35,014 26,231 (8,783)21,763 (13,251)Golf Operation Labor 120,551 101,555 (18,996)91,029 (29,522)
10,447 9,250 (1,197)9,211 (1,237)General and Administrative 40,775 37,000 (3,775)36,535 (4,240)
71,025 70,620 (406)64,034 (6,991)Maintenance and Landscaping 244,979 273,879 28,899 237,275 (7,704)
22,504 20,886 (1,618)20,395 (2,109)F&B 78,272 75,049 (3,223)74,894 (3,378)
6,479 7,417 937 5,457 (1,022)Sales and Marketing 20,269 24,567 4,298 21,828 1,559
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
145,470 134,403 (11,067)120,860 (24,610)Total Direct Labor 504,846 512,050 7,203 461,561 (43,286)
11,610 12,332 722 9,623 (1,987)Total Payroll Taxes 39,086 46,967 7,881 35,306 (3,780)
13,417 9,678 (3,739)8,649 (4,768)Total Medical/Health Benefits 43,652 42,142 (1,510)38,024 (5,628)
2,032 1,509 (523)1,808 (224)Total Workmans Comp 7,525 6,498 (1,027)7,799 274
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
27,059 23,519 (3,540)20,080 (6,979)Total Payroll Burden 90,263 95,607 5,344 81,129 (9,134)
==================================================================================== ===============================================================================
172,529 157,922 (14,607)140,940 (31,589)Total Labor 595,110 607,657 12,547 542,690 (52,420)
Other Operational Expenses
11,741 6,942 (4,799)6,942 (4,799)Golf Ops 20,691 15,719 (4,972)28,700 8,009
11,993 11,849 (144)12,369 376 G&A 44,649 35,155 (9,494)38,805 (5,844)
172,238 108,933 (63,305)101,080 (71,158)Maintenance 349,250 335,347 (13,903)301,250 (47,999)
3,559 3,655 96 3,915 357 F&B 12,436 10,545 (1,891)10,890 (1,546)
2,107 4,375 2,268 778 (1,328)Sales and Marketing 8,448 9,900 1,452 6,482 (1,966)
13,259 13,557 298 13,041 (218)Golf Cart Leases 42,129 54,228 12,099 52,164 10,035
298 0 (298)0 (298)Equipment Leases 895 0 (895)0 (895)
157,664 141,975 (15,689)146,645 (11,020)Utilities ‐ Maintenance 375,207 453,725 78,518 396,655 21,448
14,068 14,925 857 14,788 720 Utilities ‐ G&A 62,105 62,875 770 63,487 1,382
10,404 10,404 0 10,200 (204)Management Fees 41,616 41,616 0 40,800 (816)
6,668 2,914 (3,754)2,914 (3,754)Insurance ‐ P&C 30,051 14,444 (15,607)14,444 (15,607)
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
404,000 319,529 (84,471)312,673 (91,327)Total Other Operational Expenses 987,477 1,033,554 46,077 953,678 (33,798)
==================================================================================== ===============================================================================
576,529 477,451 (99,078)453,613 (122,916)Total Expenses 1,582,586 1,641,211 58,625 1,496,368 (86,218)
==================================================================================== ===============================================================================
(285,620) (279,773) (5,847) (207,550) (90,936)EBITDAR (605,026) (955,928)350,902 (543,835) (74,057)
==================================================================================== ===============================================================================
(285,620) (279,773) (5,847) (207,550) (90,936)EBITDA (605,026) (955,928)350,902 (543,835) (74,057)
Interest Expense/Dep&Amt
00000Other Expense 0 0 0 (343) (343)
0 0 0 0 0 Capital Improvements/Cap Reserve 27,500 0 (27,500)10,560 (16,940)
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
00000Total Interest Expense 27,500 0 (27,500)10,217 (17,283)
==================================================================================== ===============================================================================
(285,620) (279,773) (5,847) (207,550) (90,936)Net Income (632,526) (955,928)323,402 (554,052) (91,340)
El Conquistador Golf Club
For the Month Ending October 31st, 2022
October YTD
ATTACHMENT DConsolidated Year-to-Date Financial Report through October 2022FY 2022/2023FundFY 22/23Beginning BalanceRevenueOther Fin Sources/TransfersTotal In Personnel O&M CapitalDebt ServiceCapital Leases /Transfer OutTotal OutFund Balance Through October 2022General Fund 30,390,425 16,611,531 16,611,531 9,471,349 4,838,407 155,970 6,548,965 21,014,691 25,987,265 Highway Fund 1,206,986 1,338,623 1,338,623 350,342 205,167 758 556,267 1,989,342 Grants and Contributions Fund 208,250 5,417,497 5,417,497 31,234 31,234 5,594,513 Seizure & Forfeiture - Justice/State 237,863 3,648 3,648 33,675 33,675 207,836 Community Center Fund 5,860,458 2,470,515 2,470,515 825,340 1,376,582 312,105 2,071,090 4,585,117 3,745,856 Municipal Debt Service Fund 164,136 33,473 4,200,971 4,234,444 4,664 3,633,719 3,638,383 760,197 Water Resource System & Dev. Impact Fee Fund 17,544,433 1,001,457 1,001,457 79,500 155,985 333,327 568,812 17,977,078 Townwide Roadway Dev Impact Fee Fund 1,939,688 84,163 84,163 - 2,023,851 Parks & Recreation Impact Fee Fund 509,474 67,030 67,030 - 576,504 Police Impact Fee Fund 132,559 23,232 23,232 121,500 121,500 34,291 Capital Fund 24,110,390 456,853 4,500,000 4,956,853 49,721 105 7,437,953 7,487,779 21,579,464 PAG/RTA Fund 873,366 13,157 13,157 24,385 163,854 188,239 698,284 Water Utility 12,628,510 6,164,961 6,164,961 1,057,720 2,739,328 316,571 4,229,099 2,440 8,345,158 10,448,313 Stormwater Utility 1,125,140 504,399 504,399 249,928 105,188 22,820 377,936 1,251,603 Benefit Self Insurance Fund 2,869,952 1,418,471 1,418,471 1,548,257 1,548,257 2,740,166 Recreation In-Lieu Fee Fund 16,617 77 77 - 16,694 Total 99,818,247 35,609,087 8,700,971 44,310,058 12,004,400 10,986,492 8,566,016 8,196,145 8,743,995 48,497,048 95,631,257
ATTACHMENT EGeneral Fund Local Sales Tax Collections FY 2022/23CATEGORY JULYAUGSEPOCTNOVDECJANFEBMARAPRMAYJUNETOTALConstruction Sales Tax586,039 575,738 540,567 518,177 2,220,521 Utility Sales Tax317,210 371,973 356,012 334,868 1,380,063 Retail Sales Tax716,720 680,117 691,138 713,672 2,801,646 Bed Tax146,263 128,132 114,626 142,628 531,649 Restaurant & Bar Sales Tax186,438 180,577 199,405 204,482 770,902 All Other Local Sales Tax *210,893 199,992 202,571 205,672 819,129 Monthly Total 2,163,563$ 2,136,529$ 2,104,319$ 2,119,499$ 8,523,910$ Cumulative Total 2,163,563$ 4,300,092$ 6,404,411$ 8,523,910$ 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 Monthly 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$ Cumulative Total 1,922,624$ 3,833,628$ 5,886,910$ 8,293,659$ 10,719,668$ 12,776,451$ 15,581,231$ 17,888,285$ 19,900,350$ 22,413,091$ 24,630,926$ 26,806,278$ * Note: Does not include cable franchise fees or sales tax audit revenues
ATTACHMENT FGeneral Fund State Shared RevenuesFY 2022/23CATEGORY JULYAUGSEPOCTNOVDECJANFEBMARAPRMAYJUNETOTALState Shared Income Tax 756,893 756,894 756,893 756,893 3,027,573 State Shared Sales Tax 308,350 462,557 664,529 559,547 1,994,983 County Auto Lieu 97,269 201,901 209,941 195,695 704,806 Smart and Safe- - - - - Monthly Total 1,162,512$ 1,421,352$ 1,631,363$ 1,512,135$ 5,727,362$ Cumulative Total 1,162,512$ 2,583,864$ 4,215,227$ 5,727,362$ FY 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 Monthly 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$ Cumulative Total 892,675$ 2,106,371$ 3,302,563$ 4,538,040$ 5,659,989$ 7,153,990$ 8,406,973$ 9,568,596$ 10,829,576$ 12,250,040$ 13,456,854$ 15,317,760$