Loading...
HomeMy WebLinkAboutJan 23 Fin 4South Bend Venues, Parks and Arts Golf: Revenues and Expenditures REVENUES Current YTD Total Estimated Under/(Over) Percent of Account String Month Revenue Revenues Budget Budget Charges for Services Culture & Recreation 347003 - Golf Season Pass 156,974.94 156,974.94 221,898.00 64,923.06 70.74% 347004 - Golf Green Fees 519.00 519.00 785,529.00 785,010.00 0.07% 347005 - Golf Cart Rentals - - 392,284.00 392,284.00 0.00% 347006 - Golf Pro Shop Retail 934.08 934.08 77,652.00 76,717.92 1.20% 347007 - Golf Driving Range - - 34,323.00 34,323.00 0.00% 347012 - Food Sales - - 68,447.00 68,447.00 0.00% 347013 - Nonalcoholic Beverage - - 41,633.00 41,633.00 0.00% 347014 - Alcoholic Beverage Sales - - 151,573.00 151,573.00 0.00% 347026 - Room Rental 100.00 100.00 7,572.00 7,472.00 1.32% Total Culture & Recreation 158,528.02 158,528.02 1,780,911.00 1,622,382.98 8.90% Total Charges for Services 158,528.02 158,528.02 1,780,911.00 1,622,382.98 8.90% Miscellaneous Revenue 360000 - Miscellaneous 330.00 330.00 1,483.00 1,153.00 22.25% Total Miscellaneous Revenue 330.00 330.00 1,483.00 1,153.00 22.25% Other Sources 393000 - Capital Lease Proceeds - - 436,000.00 436,000.00 0.00% Total Other Sources - - 436,000.00 436,000.00 0.00% Total Revenue 158,858.02 158,858.02 2,218,394.00 2,059,535.98 7.16% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent of Account String Month Expenses Encumbrances w/ Encumb. Budget Budget Budget Personnel Expenses Salaries & Wages 410001 - Salaried Wages 27,229.61 27,229.61 - 27,229.61 434,369.00 407,139.39 6.27% 410002 - Teamster Wages 3,387.25 3,387.25 - 3,387.25 90,248.00 86,860.75 3.75% 410003 - Permanent Part Time 1,440.10 1,440.10 - 1,440.10 295,201.00 293,760.90 0.49% 410004 - Extra & Overtime 7.98 7.98 - 7.98 2,550.00 2,542.02 0.31% 410005 - Seasonal & Interns 24.00 24.00 - 24.00 41,776.00 41,752.00 0.06% 410007 - Longevity Pay - - - - 600.00 600.00 0.00% Total Salaries & Wages 32,088.94 32,088.94 - 32,088.94 864,744.00 832,655.06 3.71% Employee Benefits 411001 - FICA Regular 2,359.43 2,359.43 - 2,359.43 66,330.00 63,970.57 3.56% 411004 - PERF Regular 3,409.05 3,409.05 - 3,409.05 59,369.00 55,959.95 5.74% 411005 - PERF Union 25.52 25.52 - 25.52 1,426.00 1,400.48 1.79% 411007 - Unemployment Comp 2.99 2.99 - 2.99 633.00 630.01 0.47% 411008 - Health Insurance 7,205.74 7,205.74 - 7,205.74 126,094.00 118,888.26 5.71% 411009 - Life Insurance 70.00 70.00 - 70.00 1,080.00 1,010.00 6.48% 411010 - Med/Surgical/Dental 103.85 103.85 - 103.85 - (103.85) 0.00% 411014 - Parental Leave 107.09 107.09 - 107.09 1,847.00 1,739.91 5.80% 411015 - Other Fringe Benefits 200.00 200.00 - 200.00 - (200.00) 0.00% 411201 - Tool Allowance - - - - 800.00 800.00 0.00% 411203 - Job Readiness Allow. - - - - 850.00 850.00 0.00% 411206 - Cell Phone Allowance 55.00 55.00 - 55.00 660.00 605.00 8.33% Total Employee Benefits 13,538.67 13,538.67 - 13,538.67 259,089.00 245,550.33 5.23% Total Personnel Expenses 45,627.61 45,627.61 - 45,627.61 1,123,833.00 1,078,205.39 4.06% Supplies Expenses Office Supplies January 31, 2023 421000 - General Office Supplies - - - - 1,000.00 1,000.00 0.00% Total Office Supplies - - - - 1,000.00 1,000.00 0.00% Operating Supplies 422000 - Other Operating Supplies 1,086.08 1,086.08 26,021.84 27,107.92 110,870.80 83,762.88 24.45% 422002 - Diesel/CNG - - - - 3,472.00 3,472.00 0.00% 422003 - Gasoline - - 631.50 631.50 27,314.50 26,683.00 2.31% 422005 - Uniforms - - - - 2,200.00 2,200.00 0.00% 422008 - Medical/Safety Supplies - - - - 500.00 500.00 0.00% 422010 - Plants Chemicals Seed & Fertilizer - - 21.00 21.00 164,983.00 164,962.00 0.01% 422014 - Concessions Inventory - - 1,359.96 1,359.96 87,780.96 86,421.00 1.55% 422016 - Inventory For Sale - - 45,555.71 45,555.71 40,725.21 (4,830.50) 111.86% Total Operating Supplies 1,086.08 1,086.08 73,590.01 74,676.09 437,846.47 363,170.38 17.06% Repair & Maintenance Supplies 423000 - Other R&M Supplies - - 8,967.48 8,967.48 54,197.93 45,230.45 16.55% 423009 - Repair Parts - - - - 5,000.00 5,000.00 0.00% Total Repair & Maintenance Supplies - - 8,967.48 8,967.48 59,197.93 50,230.45 15.15% Total Supplies Expenses 1,086.08 1,086.08 82,557.49 83,643.57 498,044.40 414,400.83 16.79% Services & Charges Expenses Professional Services 431000 - Other Professional Services - - - - 35,337.00 35,337.00 0.00% 431019 - Security Services - - - - 6,200.00 6,200.00 0.00% Total Professional Services - - - - 41,537.00 41,537.00 0.00% Communication & Transportation 432002 - Mailing - - 550.00 550.00 550.00 - 100.00% 432004 - Telecommunications - - 9.13 9.13 409.13 400.00 2.23% Total Communication & Transportation - - 559.13 559.13 959.13 400.00 58.30% Printing & Advertising 433003 - Promotional - - - - 57,000.00 57,000.00 0.00% Total Printing & Advertising - - - - 57,000.00 57,000.00 0.00% Utilties 435001 - Electric 4,422.59 4,422.59 - 4,422.59 68,664.00 64,241.41 6.44% 435002 - Natural Gas 2,896.92 2,896.92 - 2,896.92 26,645.00 23,748.08 10.87% Total Utilities 7,319.51 7,319.51 - 7,319.51 95,309.00 87,989.49 7.68% Repairs & Maintenance 436000 - Other R&M - - - - 27,630.00 27,630.00 0.00% 436005 - Other Equip R&M - - - - 1,050.00 1,050.00 0.00% Total Repairs & Maintenance - - - - 28,680.00 28,680.00 0.00% Debt Service 438100 - Principal - - - - 120,091.00 120,091.00 0.00% 438200 - Interest - - - - 12,243.00 12,243.00 0.00% Total Debt Service - - - - 132,334.00 132,334.00 0.00% Other Charges & Services 439000 - Misc Charges & Svcs 48.37 48.37 - 48.37 9,839.00 9,790.63 0.49% 439002 - Licenses & Permits 150.00 150.00 - 150.00 4,867.00 4,717.00 3.08% 439003 - Subscriptions - - - - 3,000.00 3,000.00 0.00% 439004 - Dues & Memberships - - - - 4,000.00 4,000.00 0.00% 439005 - Bank & Credit Card Fees 4,121.56 4,121.56 - 4,121.56 39,995.00 35,873.44 10.31% 439006 - Education & Training - - - - 800.00 800.00 0.00% 439009 - Trash Removal 513.51 513.51 - 513.51 14,466.74 13,953.23 3.55% 439018 - Demolition & Clearance - - 18,000.00 18,000.00 18,000.00 - 100.00% 439100 - Refunds/Awards/Indemnities - - - - 1,757.00 1,757.00 0.00% Total Other Services & Charges 4,833.44 4,833.44 18,000.00 22,833.44 96,724.74 73,891.30 23.61% Total Services & Charges Expenses 12,152.95 12,152.95 18,559.13 30,712.08 452,543.87 421,831.79 6.79% Capital Outlay Machinery & Equipment 445108 - Lease Purchase/Other Equip - - - - 436,000.00 436,000.00 0.00% Total Machinery & Equipment - - - - 436,000.00 436,000.00 0.00% Total Capital Expenses - - - - 436,000.00 436,000.00 0.00% Other Uses 452002 - Allocations-Admin Cost - - - - 89,268.00 89,268.00 0.00% 452003 - Allocations-IT - - - - 80,487.00 80,487.00 0.00% 452004 - Allocations-Liability Insurance - - - - 14,092.00 14,092.00 0.00% 452009 - Allocations-Facilities Mgmt - - - - 3,600.00 3,600.00 0.00% Total Other Uses - - - - 187,447.00 187,447.00 0.00% Total Expenses 58,866.64 58,866.64 101,116.62 159,983.26 2,697,868.27 2,537,885.01 5.93%