Finance Committee (Meets 4th Tuesday of each month at 4:30 p.m.)

Finance Department Phone: (715) 395-7291 1316 N 14th Street Fax: (715) 395-7292 Superior, WI 54880 March 5, 2021 To: Councilor – Jack Sweeney (Chair) Councilor – Keith Kern Councilor – Tylor Elm (Co‐chair) Councilor – Ruth Ludwig (Alt) From: Deb Kamunen – Assistant Finance Director Finance Committee Mission Statement: To have broad oversight of financial policies and procedures, and to provide the City Council and management with such financial expertise, opinion, and recommendations as will be helpful for the Council to make decisions regarding the financial stability of the City of Superior. **** FINANCE COMMITTEE MEETING AGENDA **** An online Finance Committee meeting is scheduled for Thursday, March 11, 2021 at 4:00 p.m. Due to the current COVID‐19 emergency, the public may access this meeting online with Google Meet by pressing CTRL + click to follow the link or copying and pasting the address into a web browser: Join with Google Meet meet.google.com/nie-nzec-sfu Phone Numbers (US)+1 617-675-4444 PIN: 676 649 748 7105# The following items will be discussed at the Finance Committee Meeting. 1. Approval of the February 11, 2021 Finance Committee Meeting minutes. 2. Approval of the February 18, 2021 Special Finance Committee Meeting minutes. 3. Referred from the February 10, 2021 Festival Committee; Review and approve the Festival Committee Sponsorship Application. 4. Sailboats Inc. Financials – Receive and file. 5. SYO Tax Returns – Receive and file. 6. Golf Course Financials – Receive and file. 7. Review February, 2021 check registers (2020 and 2021 Expenditures) – Receive and file. 8. Review General Fund Financial Statements – 2020 and 2021 Expenditure vs. Budget Analysis – Receive and file. 9. General Financial Overview. a. Update on top 3 financial concerns or updates. 10. Other financial matters. If you are unable to attend this meeting, please contact Deb Kamunen at 715‐395‐7293. Cc: Mayor Jim Paine KDAL Radio Taylor Pedersen City Council Members WDSM Radio Peter Luke City Clerk’s Office WEBC Radio Kyle Hawley Bulletin Board Duluth News Tribune Department Heads Superior Telegram Notice is hereby given that a quorum of the City Council may be present. No action will be taken other than the items listed on this agenda. **************************************************************************************************************************** Pursuant to the Americans with Disabilities Act of 1990, if you are in need of an accommodation to participate in the public meeting process, please contact the City Clerk’s Office at (715) 395-7200 prior to the scheduled meeting. The City will attempt to accommodate any request depending on the amount of notice received. TDD (715) 395-7521. **************************************************************************************************************************** In compliance with Wisconsin Open Meetings Law, this agenda was: Posted: Government Center, Court House, Public Library, & Super One Foods Faxed to: Daily Telegram, Public Library, March 5, 2021 Media notified and mailing list: March 5, 2021 Superior Telegram to sign and fax verification of receipt to fax number (715‐395‐7292) __________________________________________________________ Name Date  Finance Committee Proceedings City of Superior February 11, 2021 Members Present: Tylor Elm, Jack Sweeney, Keith Kern and Ruth Ludwig Staff Present: Ashley Puetz, Jean Dotterwick, Deborah Kamunen, Nick Raverty, Linda Cadotte and Jim Paine Others Present: Jim Caesar, Eric Thomas, Shelly Nelson, Dustin Heckman, Taylor Pedersen, Michael Smisek, Tim Gilbertson, Doug Score and Jenny Van Sickle Members Excused: Jack Sweeney called the meeting to order at 4:30 pm with a quorum present. Attendance was done by sign in and virtual meeting. 1. Approval of the January 14, 2020 Finance Committee meeting minutes. Motion was made by Tylor Elm, seconded by Keith Kern and carried to approve the January 14, 2021 Finance Committee meeting minutes. 2. Presentation from SEK The Mayor introduced Michael Smisek of SEK Design. Smisek shared a presentation with the Committee which proposed different branding goals and ideas for marketing a new City/community logo and branding. The Mayor indicated there is no proposal at this time. The Mayor wanted the Committee to get a sense of what is available and to develop and formulate questions for a future discussion. Motion was made by Keith Kern, seconded by Tylor Elm and carried to receive and file the presentation from SEK. 3. Tabled from the December 10, 2020 Finance Committee meeting and the November 30, 2020 Special Finance Committee meeting – Request from Director Cadotte for approval of a five (5) year Professional Services Agreement Hayes Court Ballfield Complex Management with Superior Youth Organization (SYO), LL commencing on January 1, 2021 along with a related budget adjustment to cover the increased annual fees. Councilor Elm opened the discussion starting with the contract length. Discussion then progressed to the management agreement and what it entails. Sweeney requested SYO provide an annual list of equipment and other items owned by SYO, a list of volunteer time, and to include 990s with the year-end report. He also requested the “Little League Standards” be maintained and the City to provide annual plumbing, electrical and building inspections. Motion was made Keith Kern, seconded by Tylor Elm and carried to approve the five (5) year Professional Services Agreement Hayes Court Ballfield Complex Management with Superior Youth Organization (SYO), with a fee of $37,000 for the first year and the fee schedule to increase as outlined in the agreement along with the yearly list above, as requested by Councilor Sweeney. 4. Report from Eric Thomas, President of Sailboat’s Inc., on the capital improvement projects at Barker’s Island Marina for 2020. Eric Thomas informed the Committee that there were $97,000 of Capital Improvements done in 2020, which were described in the list provided. The new Travelift, to be delivered in early April, has generated calls from customers wanting to purchase bigger boats. Dockage was down, but storage increased, and broker boat sales were up.  Motion was made by Keith Kern, seconded by Tylor Elm and approved to receive and file the report from Eric Thomas, President of Sailboat’s Inc., on the capital improvement projects at Barker’s Island Marina for 2020. 5. Golf Course Financials – receive and file. Director Puetz informed the Committee that there was a year-end profit at the golf course. Motion was made by Keith Kern, seconded by Tylor Elm and approved to receive and file the Golf Course Financials. 6. 2020 4th Quarter reports from Travel Superior, TDF and Bong Museum – receive and file. Taylor Pedersen informed the Committee that tourism continued to gradually climb back to normal levels in the 4th quarter. Jim Caesar also gave an update on the TDF. Dustin Heckman also indicated the Bong Museum had a 49% decrease in attendance, but is in decent financial shape. Motion was made by Keith Kern, seconded by Tylor Elm and carried to receive and file the 2020 4th Quarter reports from Travel Superior, TDF and Bong Museum. 7. Review of Post-Issuance Debt Policy and Debt Procedures. Director Puetz indicated the City will monitor the policies and procedures to ensure compliance. Motion was made by Tylor Elm, seconded by Keith Kern and carried to receive and file the review of Post-Issuance Debt Policy and Debt Procedures. 8. Review January, 2021 check register. Motion was made by Tylor Elm, seconded by Keith Kern and carried to receive and file the January, 2021 check register. 9. Request from Councilor Sweeney to review 2020 year to date check register – receive and file. Motion was made by Tylor Elm, seconded by Keith Kern and carried to receive and file the 2020 year-to-date check register. 10. Review General Fund Financial Statements – 2020 & 2021 Expenditure vs. Budget Analysis. Motion was made by Tylor Elm, seconded by Keith Kern and carried to receive and file the General Fund Financial Statements – 2020 & 2021 Expenditure vs. Budget Analysis. 11. General Financial Overview Update on top 3 financial concerns or updates. a. The Finance department is working on the year-end wrap up. b. The audit will be a priority for the next few months. c. The projects that will then be worked on are the City wide fee schedule, the refund application and the grants and agreements. 12. Other financial matters. Having no other business, the Finance Committee Meeting adjourned at 6:18 p.m. Minutes respectfully submitted by Jean Dotterwick  Special Finance Committee Proceedings City of Superior February 18, 2021 Members Present: Tylor Elm, Jack Sweeney and Ruth Ludwig Staff Present: Ashley Puetz, Jean Dotterwick, Deborah Kamunen, Nick Raverty, Linda Cadotte, Todd Janigo and Jim Paine Others Present: Taylor Pedersen, Jenny Van Sickle, Nick Ledin Members Excused: Keith Kern Jack Sweeney called the meeting to order at 4:39 pm with a quorum present. Attendance was done by sign in and virtual meeting. 1. Request from Councilors Elm and Van Sickle to discuss and develop a template for streamlining the processes of city grants, leases, facility use permits, contracts and agreements. Van Sickle spoke to the new application’s accessibility and how organizations are excited about the process. Here are the suggestions for modifications to the base application: *Ludwig suggested removing, substituting or adding some wording into a few of the questions that would address specific organizations. She also recommended splitting out some questions for more detail. *Elm wants a grant definition attached to the package. *Sweeney wants wording for in kind services to be added to the grant application. The Mayor will be drafting an ordinance for grant applications. Motion was made by Tylor Elm, seconded by Ruth Ludwig and carried to approve moving forward with the grant application with the above modifications and to bring back to a future committee meeting. Having no other business, the Finance Committee Meeting adjourned at 5:39 p.m. Minutes respectfully submitted by Jean Dotterwick  EVENT SPONSORSHIP APPLICATION PROGRAM YEAR 2021 APPLICATION DEADLINE: 60 days prior to the event 1. About your organization/group/event Name of Event: Date(s) of Event: Will the majority of this event be held on public property? Yes No Name of Organization/Group: Address: Mailing address (if different from above): Main contact person: Phone(s): Email address: Do you have a board of directors? Yes No If so please attach a separate sheet listing board members Is your organization a non‐profit? Yes No Non‐profits, please list your EIN number EIN #: Please share your organization/group’s mission: Please share mission/objective of the event: Describe the event: How many participants did your event serve the last 2 years (if 2020: 2019: applicable)? 1 How many participants do you anticipate serving this year? What percentage of your participants are City of Superior residents? Estimate how many people will be attracted to the area with this event: Does your organization conduct fundraisers? If yes, please describe your fundraising activities for the last year, funds raised and your fundraising goals for this year. List any other sponsorships and amounts received by your organization last year, along with any grants that you anticipate receiving this year: Does your organization charge a registration fee for your program/event? Please indicate the amount of the fee(s). What does your organization do to help offset fees for participants that might not be able to afford the fees? What does your organization do to promote overnight stays and tourism for this event (if applicable)? Please describe any sales, advertising, and promotions you will conduct before and at the event: How does your event incorporate community equity and inclusivity? 2 How does your event incorporate technology? How does your event incorporate sustainability? What does your event do to enhance the quality of life in our community? 2. Grant Information Please list the sponsorship amount your organization is requesting: Is this sponsorship being requested for a one‐time event or for ongoing programming? Please explain. One of the primary goals of the Festival Committee is to support events with operational/logistical costs. What operational and/or logistical costs would this sponsorship be used for, if any? (e.g. electricity, fees/permits, barricades, auxiliary police, etc.) What other costs would this sponsorship be used for, if any? 3 Has this event receive a sponsorship from the City of Superior in previous years? Describe how the sponsorship money was used. How was the City of Superior recognized for its sponsorship in previous years (if applicable)? Please provide examples (pictures of t‐shirts, banners, signs, radio scripts, social media posts, etc.). If you received a sponsorship from the City of Superior last year and were not able to use it all due to COVID, how do you plan to use that money along with a potential sponsorship for 2021? How will your organization recognize the City of Superior as a sponsor this year if funds are received? (i.e. City logo on flyers, verbal recognition at events, banners, etc.) Please provide any other information you would like to committee to be aware of that was not asked above: 4 3. Program/Event Budget Summary (for most recent year) Earned Revenue $ amount Expenditures $ amount Admissions Salaries Memberships Office/administration Workshops/training Marketing/publicity Food/concessions Equipment Grants/donations Transportation Fundraisers Supplies Volunteer Hours Insurance (x $15/hr) In‐Kind Contributions Other (specify below) (please specify) Other (specify below) TOTAL TOTAL I, the undersigned, certify that the information provided in and with this statement is true and accurate. Submitted by (signature):_________________________________________ Printed name: _________________________________ Title: __________________________________ Date: ________________________________ 5  January 2021 Client Report To: Linda Cadotte, City of Superior, Dir. of Parks, Recreation and Forestry From: Steve Loomis, KemperSports VP of Operations Tom Beaudry, Head Golf Professional/GM CC: Laura Pinter, Jim Stegall and Ashley Puetz Overview: January is typically a slow financial month as the staff works on operational and event planning for the upcoming 2021 golf season. Revenues for the month outpace budget as we were fortunate to sell a set of clubs in the month. Payroll expense came in high due to an accrual issue that was not discovered until January. Overall NOI missed budget by $523. January 2021 Actual Budget Variance % Change FY 19 Actual % Change Nemadji Golf Course Total Revenue $ 1,600 $ - $ 1,600 #DIV/0! $ - #DIV/0! Merchandise COG's % -7% 0% -7% #DIV/0! 0% #DIV/0! F&B COG's % 0% 0% 0% #DIV/0! 0% #DIV/0! Payroll Expense $ 40,744 $ 32,607 $ 8,137 25.0% $ 20,375 100.0% Other Expense $ 18,108 $ 19,671 $ (1,563) -7.9% $ 15,504 16.8% EBITDA $ (57,266) $ (52,278) $ (4,988) 9.5% $ (35,879) 59.6% Management Fees $ 7,210 $ 7,210 $ - 0.0% $ 7,000 3.0% Net Operating Income $ (64,476) $ (59,488) $ (4,974) 8.4% $ (42,879) 50.4% Rounds - - - 0.0% - #DIV/0! Average GF/CF $ - $ - $ - 0.0% $ - #DIV/0! Key Performance Highlights: Course and grounds – Payroll over by 41% or $6,283. Overage came from annual bonus accured monthly vs in December, $417 and then a payroll retro mistake that attrubitued to an overpayment to Vince Dodge. This is being resolved over the next three pay periods and will even out by mid March. C&G repairs and maintenance expenses exceeded budget by $3,044 based on timing of needed repairs and supplies. Will work insure we do not exceed our annual budget for this line item. Carts – No financial activity to report. 1 500 Skokie Boulevard Suite 444 Northbrook, IL 60062 (847) 850-1818 www.kempersports.com Range – OPEX reflects new range baskets purchased that are budgeted for in May. We purchased early to insure delivery as we have seen many COVID production delays in the supply chain. Total annual budget is $5,000 so we still have $2,684 remaing for the remainder of the season. F&B – Payroll is skewed high by $1,751 due to annual bonus accural of $250 and an over accural amount in the December financials. Golf Shop – Sold a set of Callaway golf clubs driving all of January’s revenues. G&A – Payroll saving of $615 based on over accrual of 2020 bonus. OPEX finished under budget by 33% as we did not have to spend in January. Some of these dollars will need to be spent in the next few months. Marketing – Payroll is flat to budget. OPEX finished under for the month but expenses here are deferred and will be realized in future months. Key Performance Issues:  Working with the local community college for the walk-in cooler project, still have not received a documented plan or outline for scope of project  Met with trash company to reconcile overbilling Key Actions to Drive Performance:  2021 creative events schedule is in outline form and will be completed in February.  Currently reaching out to all past and potential event coordinators to book for 2021. See tournament booking pace report for more information  Promoting 2021 Annual Passes  Contacting all past seasonal staffers about returning for the 2021 season 2 500 Skokie Boulevard Suite 444 Northbrook, IL 60062 (847) 850-1818 www.kempersports.com Annual Membership Sales: Annual Memberships Type of Number Sold in Number Sold in Monthly Total Annual Membership Month Year Revenue Revenue Family 0 0 $ - $ - Adult 1 1 $ 729.86 $ 729.86 Adult Limited 0 0 $ - $ - Adult Couple 0 0 $ - $ - Senior 8 8 $ 4,587.68 $ 4,587.68 Senior Couple 2 2 $ 1,105.21 $ 1,105.21 Intermediate 0 0 $ - $ - Cart Pass 5 5 $ 1,710.89 $ 1,710.89 Cart Pass Lmtd 2 2 $ 364.93 $ 364.93 Last Yr Trail Fee 0 0 $ - $ - Junior (Under 15) 3 3 $ 156.39 $ 156.39 Junior 16-18 1 1 $ 208.53 $ 208.53 Players Card 1 1 $ 39.99 $ 39.99 Total 23 23 $ 8,903.48 $ 8,903.48 Membership sales are well ahead of last year at this time because we did not have the point of sale yet. Tournament Booking Pace Current Actual + Variance to Current Year to Date Analysis Month Booked Budget % of Budget Budget January2021 $ - $ - $ - Actual Total Number of MONTH Revenue Events Pipeline February2021 $ - $ - $ - January2021 $ - - $ - March2021 $ - $ - $ - February2021 $ - - $ - April2021 $ - $ - $ - March2021 $ - - $ - May2021 $ - $ 7,400 0% $ (7,400) April2021 $ - - $ - June2021 $ - $ 14,080 0% $ (14,080) May2021 $ - - $ 3,800 July2021 $ - $ 8,352 0% $ (8,352) June2021 $ - - $ - July2021 $ - - $ 9,880 August2021 $ - $ 10,776 0% $ (10,776) August2021 $ - - $ 1,387 September2021 $ - $ - $ - September2021 $ - - $ 3,600 October2021 $ - $ 2,400 0% $ (2,400) October2021 $ - - $ - November2021 $ - $ - $ - November2021 $ - - $ - December2021 $ - - $ - December2021 $ - $ - $ - Total $ - - $ 18,667 Total $ - $ 43,008 0% $ (43,008) 3 500 Skokie Boulevard Suite 444 Northbrook, IL 60062 (847) 850-1818 www.kempersports.com Kristen is reaching out to all past event coordinators, several have asked for us to hold dates and we reflect these in our pipeline. Once contracts are finalized these will move over and be reflected as booked events. Tom is spending time coaching Kristen to help set her up for a successful year. Going over scripts with potential events, how to build an effective to do list, how to prioritize a day, and goal setting. No activity to report for this month. Course NPS Overall Service Course Food Recommend # of Rating Rating Rating Rating Rating Surveys January N/A N/A N/A N/A N/A N/A N/A 2021 January N/A N/A N/A N/A N/A N/A N/A 2020 Y-T-D Course NPS Overall Service Course Food Recommend # of Rating Rating Rating Rating Rating Surveys Y-T-D N/A N/A N/A N/A N/A N/A N/A 2021 Y-T-D N/A N/A N/A N/A N/A N/A N/A 2020  KemperSports Net Promoter Score (NPS) company benchmark is 70.0 4 500 Skokie Boulevard Suite 444 Northbrook, IL 60062 (847) 850-1818 www.kempersports.com KemperSports Upcoming Key Initiatives: Green to a tee- Achieved Level I certification. Working to achieve level 2 by December of 2021. Safety National- 2020 results reviewed at SPS and goals set for 2021. True Service- Preparations for improving in 2021 through continued staff service training and review of operational practices. Player Development- Currently working on program schedules for the 2021 season. Weather:  Snow in January: 6” Golf Course Maintenance Highlights:  Finish employee evaluations for 2020 season.  Snow fence work on 5 East. Snowmobiles leaving trail and moving onto golf course.  Finalize order for spray rig apparatus.  Update inventories.  Order yardage plates for range tee.  Set up computer/phone for mechanic’s area  Meet with numerous seasonal staff returns for 2021 season.  Various snow removal chores  Shop work: o Oil change/lubrication of skid loader o Assemble Lely spreader o Assemble resurfaced foot brushes and bag racks. o Begin work grinding reels for other golf courses. Extra revenue upon completion and good training exercise for Brian.  Finalize bench order for April delivery  Create new scorecard pin position system.  Research new garbage containers for clubhouse and grooming units for putting greens.  Order custom drain grates to allow us to finish drainage work started in fall.  Finalize fertilizer order for 2021. 5 500 Skokie Boulevard Suite 444 Northbrook, IL 60062 (847) 850-1818 www.kempersports.com Personnel:  Per our plan and budget, Kristen Lilya was promoted from her hourly position into a full-time salary position as the Sales and Marketing Manager. Capital Plan Update:  Continued communication with WITC to facilitate the walk-in cooler installation as a class project. Frank Vidas, who is the lead HVAC instructor at WITC, is looking forward to working with us on this project and the great opportunity they will have to learn from this.  Once we have final numbers for the cooler project we will dedicate the rest to patio furniture Clubhouse Update:  Chef has met with US Foods regarding pricing of the new menu and will finalize in March  Merchandise orders have been placed and will continue to ongoing orders as needed.  Deep clean of entire clubhouse is scheduled for March Client and Team Member Relations Update:  First Golf Committee of 2021 meeting held on January 11th, in this meeting we also discussed potential 2021 / 2022 winter activities that could be held at the golf course. More to come as we continue to review these options.  Multiple meetings to prepare for the presentation for the City to review 2020 results  Strategic planning session held on January 15-17 with all key department staffers in attendance.  Steve Loomis, ROE, holds weekly one on one calls with GM Tom Beaudry, reviewing all operations, COVID-19 restrictions and discussing upcoming opportunities. Steve, Tom and Vince attended the monthly golf committee meeting on January 11th via zoom.  Monthly revenues calls with Regional Director of Sales and Marketing Ed Jackman, Steve Loomis, VP of Operations, Tom Beaudry and Kristen Lilya. In these calls we review outing booking pace reporting, current and future sales promotions, all marketing strategies, upcoming KemperSports marketing and player development iniativies and various other topics as needed. Monthly Financial Income Statement  Attached is January’s summary income statement which breaks down the categories including: revenues, payroll and operating expenses. Please let me know if you have any questions. Best Regards, Best Regards, Steve Loomis Tom Beaudry Steve Loomis, PGA Tom Beaudry, PGA Regional Operations Executive General Manager / Head Golf Professional KemperSports Nemadji Golf Course 6 500 Skokie Boulevard Suite 444 Northbrook, IL 60062 (847) 850-1818 www.kempersports.com  Nemadji Balance Sheet For the Month Ending January 31, 2021 01/31/21 12/31/20 01/31/20 ASSETS CURRENT ASSETS: Cash Cash - Operating 802,774 839,982 18,068 Cash - Payroll 5,097 31,538 39,304 Cash - Housebank & Other 2,500 2,500 0 Total Cash 810,371 874,020 57,371 Other Current Assets Inventory - Merchandise 24,934 22,897 0 Inventory - Food & Beverage 6,147 6,142 0 Prepaid Insurance 3,163 3,954 0 Total Other Current Assets 34,243 32,992 0 TOTAL CURRENT ASSETS 844,614 907,012 57,371 TOTAL ASSETS 844,614 907,012 57,371  Nemadji Balance Sheet For the Month Ending January 31, 2021 01/31/21 12/31/20 01/31/20 LIABILITIES AND STOCKHOLDERS' EQUITY CURRENT LIABILITIES: Accts Pay - Trade 3,032 (3,274) (684) Accrued Expenses 2,701 15,609 0 Accrued Payroll 1,106 3,314 6,724 Accrued Taxes 83,765 83,144 0 Deferred Revenue 48,912 38,644 0 TOTAL CURRENT LIBILITIES 139,516 137,437 6,040 LONG-TERM LIABILITIES: Long-term debt 701,527 701,527 159,671 TOTAL LONG-TERM LIABILITIES 701,527 701,527 159,671 TOTAL LIABILITIES 841,043 838,964 165,711 STOCKHOLDER'S EQUITY Retained Earnings 3,571 68,047 (108,340) Net Retained Earnings 3,571 68,047 (108,340) Stockholders Equity 3,571 68,047 (108,340) TOTAL STOCKHOLDER'S EQUITY 3,571 68,047 (108,340) TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY 844,614 907,012 57,371  Nemadji Standard Summary Income Statement For the Month Ending January 31, 2021 MTD % of MTD % of YTD % of YTD % of Annual Rolling Actual Budget Budget Prior Year PY Actual Budget Budget Prior Year PY Budget 12 Months REVENUES 0 0 0% 0 0% Green Fees & Cart Fees 0 0 0% 0 0% 1,307,059 1,218,709 1,600 0 0% 0 0% Merchandise 1,600 0 0% 0 0% 129,850 119,939 0 0 0% 0 0% Other Pro Shop 0 0 0% 0 0% 10,660 3,843 0 0 0% 0 0% Range 0 0 0% 0 0% 34,700 34,201 0 0 0% 0 0% Food and Beverage 0 0 0% 0 0% 310,455 273,225 1,600 0 0% 0 0% TOTAL REVENUE 1,600 0 0% 0 0% 1,792,724 1,649,918 COST OF SALES (112) 0 0% 0 0% Merchandise (112) 0 0% 0 0% 87,020 93,488 126 0 0% 0 0% Food & Beverage 126 0 0% 0 0% 104,401 91,535 14 0 0% 0 0% TOTAL COGS 14 0 0% 0 0% 191,421 185,022 -7.0% 0.0% 0.0% 0.0% 0.0% COGS - Merchandise % -7.0% 0.0% 0.0% 0.0% 0.0% 67.0% 581.8% 0.0% 0.0% 0.0% 0.0% 0.0% COGS - Food & Beverage % 0.0% 0.0% 0.0% 0.0% 0.0% 33.6% 379.8% PAYROLL 21,747 15,464 141% 10,191 213% Course and Grounds 21,747 15,464 141% 10,191 213% 373,298 338,576 0 0 0% 0 0% Carts, Range, Starters, Etc. 0 0 0% 0 0% 32,158 22,409 0 0 0% 513 0% Pro Shop 0 0 0% 513 0% 93,296 74,197 6,007 3,892 154% 0 0% Food and Beverage 6,007 3,892 154% 0 0% 97,311 89,477 9,132 9,747 94% 9,670 94% General and Administrative 9,132 9,747 94% 9,670 94% 123,978 120,261 3,858 3,503 110% 0 0% Marketing 3,858 3,503 110% 0 0% 43,976 18,876 40,744 32,607 125% 20,375 200% TOTAL PAYROLL 40,744 32,607 125% 20,375 200% 764,017 663,795 OPERATING EXPENSES 8,624 7,760 111% 6,865 126% Course and Grounds 8,624 7,760 111% 6,865 126% 289,497 299,358 2,316 0 0% 0 0% Carts, Range, Starters, Etc. 2,316 0 0% 0 0% 120,272 120,325 53 0 0% 0 0% Pro Shop 53 0 0% 0 0% 17,700 11,377 0 0 0% 0 0% Food and Beverage 0 0 0% 0 0% 17,100 15,599 6,501 9,711 67% 8,218 79% General and Administrative 6,501 9,711 67% 8,218 79% 152,060 145,261 614 2,200 28% 420 146% Marketing 614 2,200 28% 420 146% 22,500 12,668 18,108 19,671 92% 15,504 117% TOTAL OPERATING EXPENSES 18,108 19,671 92% 15,504 117% 619,129 604,588 58,866 52,278 113% 35,879 164% TOTAL EXPENSES 58,866 52,278 113% 35,879 164% 1,574,567 1,453,406 (57,266) (52,278) 110% (35,879) 160% EBITDA (57,266) (52,278) 110% (35,879) 160% 218,157 196,513 (7,210) (7,210) 100% (7,000) 103% MANAGEMENT FEES (7,210) (7,210) 100% (7,000) 103% (86,954) (84,602) (64,476) (59,488) 108% (42,879) 150% NET INCOME (64,476) (59,488) 108% (42,879) 150% 131,203 111,911 0 0 0% 0 0% Paid Rounds 0 0 0% 0 0% 36,720 30,033 0 0 0% 0 0% Member Rounds 0 0 0% 0 0% 5,731 14,716 0 0 0% 0 0% Other Rounds 0 0 0% 0 0% 0 327 0 0 0% 0 0% Total Rounds 0 0 0% 0 0% 42,451 45,076 0 0 0% 0 0% Revenue/Paid Rounds 0 0 0% 0 0% 49 391 0 0 0% 0 0% Revenue/Total Rounds 0 0 0% 0 0% 42 2,497 0 0 0% 0 0% Green Fees / Cart Fees per Paid Rounds 0 0 0% 0 0% 36 297 0 0 0% 0 0% Green Fees / Cart Fees per Total Rounds 0 0 0% 0 0% 31 1,311 0 0 0% 0 0% F&B Revenue/Total Rounds 0 0 0% 0 0% 7 40 0 0 0% 0 0% Merchandise Revenue/Total Rounds 0 0 0% 0 0% 3 1,140 Pivot Table Data Last Updated on February 26, 2021 Expenditure vs Budget Analysis Expenditure Budget Account Level Selected Year Selected Year Projection One Year Prior Two Years Prior Budget Budget Remaining Projected Remaining YTD Utilized Projected Utilized 2020 $27,372,259.47 $27,372,259.47 $27,161,306.48 $26,073,687.73 $30,797,000.00 $3,424,740.53 $3,424,740.53 89% 89% 101‐GENERAL FUND $27,372,259.47 $27,372,259.47 $27,161,306.48 $26,073,687.73 $30,797,000.00 $3,424,740.53 $3,424,740.53 89% 89% 101‐5110/GENERAL GOVERNMENT‐CITY COUNCIL $129,743.09 $129,743.09 $136,003.38 $124,148.08 $126,508.00 ‐$3,235.09 ‐$3,235.09 103% 103% 101‐5130/GENERAL GOVERNMENT‐CITY ATTORNEY $286,728.70 $286,728.70 $308,137.05 $272,848.85 $331,317.00 $44,588.30 $44,588.30 87% 87% 101‐5141/GENERAL GOVERNMENT‐MAYOR $218,464.53 $218,464.53 $231,698.27 $223,366.82 $227,547.00 $9,082.47 $9,082.47 96% 96% 101‐5142/GENERAL GOVERNMENT‐CITY CLERK $294,974.34 $294,974.34 $279,780.07 $272,966.79 $299,493.00 $4,518.66 $4,518.66 98% 98% 101‐5143/GENERAL GOVERNMENT‐HUMAN RESOURCES $281,783.30 $281,783.30 $313,536.33 $257,423.11 $293,868.00 $12,084.70 $12,084.70 96% 96% 101‐5144/GENERAL GOVERNMENT‐ELECTIONS $176,031.06 $176,031.06 $19,474.24 $64,926.10 $87,671.00 ‐$88,360.06 ‐$88,360.06 201% 201% 101‐5151/GENERAL GOVERNMENT‐FINANCE $696,483.67 $696,483.67 $675,060.39 $678,430.82 $714,257.00 $17,773.33 $17,773.33 98% 98% 101‐5153/GENERAL GOVERNMENT‐ASSESSOR $418,013.61 $418,013.61 $415,264.27 $356,804.85 $416,019.00 ‐$1,994.61 ‐$1,994.61 100% 100% 101‐5155/GENERAL GOVERNMENT‐PURCHASING $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 101‐5191/GENERAL GOVERNMENT‐ILLEGAL TAXES $0.00 $0.00 $22,416.69 $7,937.01 $0.00 $0.00 $0.00 101‐5192/GENERAL GOVERNMENT‐JUDGEMENTS & LOSSES $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 101‐5210/PUBLIC SAFETY‐POLICE DEPARTMENT $7,537,265.17 $7,537,265.17 $7,684,277.58 $7,358,675.32 $7,807,628.00 $270,362.83 $270,362.83 97% 97% 101‐5220/PUBLIC SAFETY‐FIRE DEPARTMENT $4,508,231.68 $4,508,231.68 $4,623,975.25 $4,352,134.14 $4,916,625.00 $408,393.32 $408,393.32 92% 92% 101‐5240/PUBLIC SAFETY‐BUILDING INSPECTION $576,776.20 $576,776.20 $595,324.14 $534,838.84 $579,786.00 $3,009.80 $3,009.80 99% 99% 101‐5310/PUBLIC WORKS‐ADMINISTRATION $368,408.26 $368,408.26 $375,008.47 $357,422.79 $388,516.00 $20,107.74 $20,107.74 95% 95% 101‐5323/PUBLIC WORKS‐SHOP OPERATIONS $1,747,525.17 $1,747,525.17 $1,672,769.26 $1,505,467.10 $1,728,621.00 ‐$18,904.17 ‐$18,904.17 101% 101% 101‐5327/PUBLIC WORKS‐BUILDINGS & GROUNDS $413,744.86 $413,744.86 $431,331.08 $429,889.45 $435,118.00 $21,373.14 $21,373.14 95% 95% 101‐5330/PUBLIC WORKS‐HWY & STREET MAINT & CONS $2,779,731.85 $2,779,731.85 $2,942,138.88 $2,627,301.02 $2,997,325.00 $217,593.15 $217,593.15 93% 93% 101‐5346/PUBLIC WORKS‐TRAFFIC SIGNALS & SIGNS $378,361.48 $378,361.48 $405,851.66 $351,767.82 $431,080.00 $52,718.52 $52,718.52 88% 88% 101‐5351/PUBLIC WORKS‐AIRPORT $94,771.56 $94,771.56 $104,942.68 $89,265.73 $92,163.00 ‐$2,608.56 ‐$2,608.56 103% 103% 101‐5352/PUBLIC WORKS‐MASS TRANSIT $1,601,424.60 $1,601,424.60 $1,372,059.76 $1,286,559.62 $1,390,000.00 ‐$211,424.60 ‐$211,424.60 115% 115% 101‐5410/HEALTH & HUMAN SERVICES‐ANIMAL SHELTER $147,154.79 $147,154.79 $152,481.10 $152,592.10 $153,330.00 $6,175.21 $6,175.21 96% 96% 101‐5452/HEALTH & HUMAN SERVICES‐GRANTS $43,700.00 $43,700.00 $48,700.00 $48,700.00 $43,700.00 $0.00 $0.00 100% 100% 101‐5512/CULTURE/REC/EDUCATION‐MUSEUM $155,000.00 $155,000.00 $170,600.00 $165,000.00 $155,000.00 $0.00 $0.00 100% 100% 101‐5520/CULTURE/REC/EDUCATION‐PARKS $843,699.08 $843,699.08 $863,663.79 $849,431.67 $844,212.00 $512.92 $512.92 100% 100% 101‐5530/CULTURE/REC/EDUCATION‐RECREATION $467,600.50 $467,600.50 $499,213.06 $477,936.63 $515,025.00 $47,424.50 $47,424.50 91% 91% 101‐5545/CULTURE/REC/EDUCATION‐ICE ARENAS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 101‐5630/CONSERVATION & DEVELOPMNT‐PLANNING $156,854.14 $156,854.14 $149,083.56 $146,421.98 $159,275.00 $2,420.86 $2,420.86 98% 98% 101‐5680/CONSERVATION & DEVELOPMNT‐GOVERNMENT AFFAIRS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 101‐5810/DEBT SERVICE‐DEBT SERVICE $0.00 $0.00 $0.00 $0.00 $2,109,675.00 $2,109,675.00 $2,109,675.00 0% 0% 101‐5820/DEBT SERVICE‐DEBT SERVICE $0.00 $0.00 $0.00 $0.00 $873,385.00 $873,385.00 $873,385.00 0% 0% 101‐5920/OTHER FINANCING USES‐TRANSFER TO OTHER FUNDS $3,049,787.83 $3,049,787.83 $2,668,515.52 $3,081,431.09 $2,679,856.00 ‐$369,931.83 ‐$369,931.83 114% 114% Grand Total $27,372,259.47 $27,372,259.47 $27,161,306.48 $26,073,687.73 $30,797,000.00 $3,424,740.53 $3,424,740.53 89% 89% Pivot Table Data Last Updated on February 26, 2021 Expenditure vs Budget Analysis Expenditure Budget Account Level Selected Year Selected Year Projection One Year Prior Two Years Prior Budget Budget Remaining Projected Remaining YTD Utilized Projected Utilized 2021 $3,384,027.96 $27,734,590.17 $0.00 $27,161,306.48 $31,461,700.00 $28,077,672.04 $3,727,109.83 11% 88% 101‐GENERAL FUND $3,384,027.96 $27,734,590.17 $0.00 $27,161,306.48 $31,461,700.00 $28,077,672.04 $3,727,109.83 11% 88% 101‐5110/GENERAL GOVERNMENT‐CITY COUNCIL $15,712.81 $113,610.36 $0.00 $136,003.38 $128,367.00 $112,654.19 $14,756.64 12% 89% 101‐5130/GENERAL GOVERNMENT‐CITY ATTORNEY $30,899.40 $236,977.60 $0.00 $308,137.05 $285,401.00 $254,501.60 $48,423.40 11% 83% 101‐5141/GENERAL GOVERNMENT‐MAYOR $25,115.34 $186,364.89 $0.00 $231,698.27 $194,569.00 $169,453.66 $8,204.11 13% 96% 101‐5142/GENERAL GOVERNMENT‐CITY CLERK $36,878.96 $253,507.89 $0.00 $279,780.07 $299,873.00 $262,994.04 $46,365.11 12% 85% 101‐5143/GENERAL GOVERNMENT‐HUMAN RESOURCES $35,468.70 $258,632.06 $0.00 $313,536.33 $382,623.00 $347,154.30 $123,990.94 9% 68% 101‐5144/GENERAL GOVERNMENT‐ELECTIONS $10,819.55 $53,504.93 $0.00 $19,474.24 $32,638.00 $21,818.45 ‐$20,866.93 33% 164% 101‐5151/GENERAL GOVERNMENT‐FINANCE $79,522.06 $570,562.41 $0.00 $675,060.39 $734,299.00 $654,776.94 $163,736.59 11% 78% 101‐5153/GENERAL GOVERNMENT‐ASSESSOR $50,333.39 $357,131.99 $0.00 $415,264.27 $435,368.00 $385,034.61 $78,236.01 12% 82% 101‐5155/GENERAL GOVERNMENT‐PURCHASING $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 101‐5191/GENERAL GOVERNMENT‐ILLEGAL TAXES $0.00 $7,472.23 $0.00 $22,416.69 $0.00 $0.00 ‐$7,472.23 101‐5192/GENERAL GOVERNMENT‐JUDGEMENTS & LOSSES $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 101‐5210/PUBLIC SAFETY‐POLICE DEPARTMENT $973,779.24 $6,792,728.51 $0.00 $7,684,277.58 $7,963,058.00 $6,989,278.76 $1,170,329.49 12% 85% 101‐5220/PUBLIC SAFETY‐FIRE DEPARTMENT $728,035.84 $4,704,814.15 $0.00 $4,623,975.25 $4,885,660.00 $4,157,624.16 $180,845.85 15% 96% 101‐5240/PUBLIC SAFETY‐BUILDING INSPECTION $62,510.10 $470,062.65 $0.00 $595,324.14 $596,370.00 $533,859.90 $126,307.35 10% 79% 101‐5310/PUBLIC WORKS‐ADMINISTRATION $40,687.84 $301,801.18 $0.00 $375,008.47 $395,925.00 $355,237.16 $94,123.82 10% 76% 101‐5323/PUBLIC WORKS‐SHOP OPERATIONS $221,516.82 $1,520,133.08 $0.00 $1,672,769.26 $1,597,965.00 $1,376,448.18 $77,831.92 14% 95% 101‐5327/PUBLIC WORKS‐BUILDINGS & GROUNDS $37,803.79 $308,043.50 $0.00 $431,331.08 $445,442.00 $407,638.21 $137,398.50 8% 69% 101‐5330/PUBLIC WORKS‐HWY & STREET MAINT & CONS $379,491.08 $2,629,692.06 $0.00 $2,942,138.88 $3,189,817.00 $2,810,325.92 $560,124.94 12% 82% 101‐5346/PUBLIC WORKS‐TRAFFIC SIGNALS & SIGNS $36,541.11 $294,063.71 $0.00 $405,851.66 $429,590.00 $393,048.89 $135,526.29 9% 68% 101‐5351/PUBLIC WORKS‐AIRPORT $16,920.86 $108,506.06 $0.00 $104,942.68 $101,108.00 $84,187.14 ‐$7,398.06 17% 107% 101‐5352/PUBLIC WORKS‐MASS TRANSIT $106,046.65 $918,151.20 $0.00 $1,372,059.76 $1,452,800.00 $1,346,753.35 $534,648.80 7% 63% 101‐5410/HEALTH & HUMAN SERVICES‐ANIMAL SHELTER $12,649.70 $105,792.99 $0.00 $152,481.10 $153,000.00 $140,350.30 $47,207.01 8% 69% 101‐5452/HEALTH & HUMAN SERVICES‐GRANTS $21,500.00 $109,655.95 $0.00 $48,700.00 $47,400.00 $25,900.00 ‐$62,255.95 45% 231% 101‐5512/CULTURE/REC/EDUCATION‐MUSEUM $35,840.00 $212,600.00 $0.00 $170,600.00 $165,000.00 $129,160.00 ‐$47,600.00 22% 129% 101‐5520/CULTURE/REC/EDUCATION‐PARKS $165,115.10 $1,005,352.35 $0.00 $863,663.79 $1,457,940.00 $1,292,824.90 $452,587.65 11% 69% 101‐5530/CULTURE/REC/EDUCATION‐RECREATION ‐$5,455.88 $142,697.26 $0.00 $499,213.06 $0.00 $5,455.88 ‐$142,697.26 101‐5545/CULTURE/REC/EDUCATION‐ICE ARENAS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 101‐5630/CONSERVATION & DEVELOPMNT‐PLANNING $23,180.70 $150,420.18 $0.00 $149,083.56 $165,176.00 $141,995.30 $14,755.82 14% 91% 101‐5680/CONSERVATION & DEVELOPMNT‐GOVERNMENT AFFAIRS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 101‐5810/DEBT SERVICE‐DEBT SERVICE $0.00 $2,105,683.00 $0.00 $0.00 $2,105,683.00 $2,105,683.00 $0.00 0% 100% 101‐5820/DEBT SERVICE‐DEBT SERVICE $0.00 $925,676.00 $0.00 $0.00 $925,676.00 $925,676.00 $0.00 0% 100% 101‐5920/OTHER FINANCING USES‐TRANSFER TO OTHER FUNDS $243,114.80 $2,890,952.00 $0.00 $2,668,515.52 $2,890,952.00 $2,647,837.20 $0.00 8% 100% Grand Total $3,384,027.96 $27,734,590.17 $0.00 $27,161,306.48 $31,461,700.00 $28,077,672.04 $3,727,109.83 11% 88%