Loading...
HomeMy WebLinkAboutJune 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 7,920.00 278,373.19 221,898.00 (56,475.19) 125.45% 347004 - Golf Green Fees 123,477.29 297,328.19 785,529.00 488,200.81 37.85% 347005 - Golf Cart Rentals 56,982.99 134,894.17 392,284.00 257,389.83 34.39% 347006 - Golf Pro Shop Retail 12,102.67 35,895.57 77,652.00 41,756.43 46.23% 347007 - Golf Driving Range 6,782.00 18,920.00 34,323.00 15,403.00 55.12% 347009 - Golf Outings 3,107.03 6,669.33 - (6,669.33) 0.00% 347012 - Food Sales 11,356.70 27,987.59 68,447.00 40,459.41 40.89% 347013 - Nonalcoholic Beverage 6,881.54 15,155.89 41,633.00 26,477.11 36.40% 347014 - Alcoholic Beverage Sales 25,567.42 67,801.83 151,573.00 83,771.17 44.73% 347026 - Room Rental 200.00 700.00 7,572.00 6,872.00 9.24% 347100 - Concessions-Employee Discounts (385.12) (958.29) - 958.29 0.00% Total Culture & Recreation 253,992.52 882,767.47 1,780,911.00 898,143.53 49.57% Total Charges for Services 253,992.52 882,767.47 1,780,911.00 898,143.53 49.57% Miscellaneous Revenue 360000 - Miscellaneous 591.46 1,556.12 1,483.00 (73.12) 104.93% Total Miscellaneous Revenue 591.46 1,556.12 1,483.00 (73.12) 104.93% Refunds & Reimbursements 380000 - Misc Reimbursements 26.07 4,524.82 - (4,524.82) 0.00% Total Refunds & Reimbursements 26.07 4,524.82 - (4,524.82) 0.00% 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 254,610.05 888,848.41 2,218,394.00 1,329,545.59 40.07% 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 28,084.38 181,693.80 - 181,693.80 434,369.00 252,675.20 41.83% 410002 - Teamster Wages - 3,387.25 - 3,387.25 90,248.00 86,860.75 3.75% 410003 - Permanent Part Time 53,602.85 137,526.53 - 137,526.53 295,201.00 157,674.47 46.59% 410004 - Extra & Overtime 923.31 1,687.53 - 1,687.53 2,550.00 862.47 66.18% 410005 - Seasonal & Interns 1,992.00 4,704.00 - 4,704.00 41,776.00 37,072.00 11.26% 410007 - Longevity Pay - - - - 600.00 600.00 0.00% Total Salaries & Wages 84,602.54 328,999.11 - 328,999.11 864,744.00 535,744.89 38.05% Employee Benefits 411001 - FICA Regular 6,392.14 24,692.88 - 24,692.88 66,330.00 41,637.12 37.23% 411004 - PERF Regular 3,151.60 20,739.77 - 20,739.77 59,369.00 38,629.23 34.93% 411005 - PERF Union - 25.52 - 25.52 1,426.00 1,400.48 1.79% 411007 - Unemployment Comp 2.69 17.52 - 17.52 633.00 615.48 2.77% 411008 - Health Insurance 5,961.54 37,181.44 - 37,181.44 126,094.00 88,912.56 29.49% 411009 - Life Insurance 60.00 370.00 - 370.00 1,080.00 710.00 34.26% 411010 - Med/Surgical/Dental 87.54 541.55 - 541.55 - (541.55) 0.00% 411014 - Parental Leave 98.10 646.26 - 646.26 1,847.00 1,200.74 34.99% 411015 - Other Fringe Benefits - 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 330.00 - 330.00 660.00 330.00 50.00% June 30, 2023 Total Employee Benefits 15,808.61 84,744.94 - 84,744.94 259,089.00 174,344.06 32.71% Total Personnel Expenses 100,411.15 413,744.05 - 413,744.05 1,123,833.00 710,088.95 36.82% Supplies Expenses Office Supplies 421000 - General Office Supplies 264.15 723.13 - 723.13 1,400.00 676.87 51.65% Total Office Supplies 264.15 723.13 - 723.13 1,400.00 676.87 51.65% Operating Supplies 422000 - Other Operating Supplies 7,087.88 65,107.52 5,504.79 70,612.31 109,339.80 38,727.49 64.58% 422002 - Diesel/CNG - 1,463.65 1,767.98 3,231.63 4,936.00 1,704.37 65.47% 422003 - Gasoline 1,690.50 9,684.51 631.50 10,316.01 27,314.50 16,998.49 37.77% 422005 - Uniforms 186.68 1,843.75 1,249.50 3,093.25 3,631.00 537.75 85.19% 422008 - Medical/Safety Supplies - - - - 500.00 500.00 0.00% 422010 - Plants Chemicals Seed & Fertilizer 3,990.22 97,048.93 2,211.00 99,259.93 163,219.00 63,959.07 60.81% 422014 - Concessions Inventory 32,514.91 58,526.96 5,957.86 64,484.82 87,780.96 23,296.14 73.46% 422016 - Inventory For Sale 17,695.11 59,458.89 2,205.31 61,664.20 40,725.21 (20,938.99) 151.42% Total Operating Supplies 63,165.30 293,134.21 19,527.94 312,662.15 437,446.47 124,784.32 71.47% Repair & Maintenance Supplies 423000 - Other R&M Supplies 5,525.17 27,473.51 3,016.51 30,490.02 54,197.93 23,707.91 56.26% 423009 - Repair Parts 1,340.81 2,948.87 - 2,948.87 5,000.00 2,051.13 58.98% Total Repair & Maintenance Supplies 6,865.98 30,422.38 3,016.51 33,438.89 59,197.93 25,759.04 56.49% Total Supplies Expenses 70,295.43 324,279.72 22,544.45 346,824.17 498,044.40 151,220.23 69.64% Services & Charges Expenses Professional Services 431000 - Other Professional Services 11,449.74 17,586.43 6,818.00 24,404.43 38,337.00 13,932.57 63.66% 431019 - Security Services 336.04 2,285.43 - 2,285.43 6,200.00 3,914.57 36.86% Total Professional Services 11,785.78 19,871.86 6,818.00 26,689.86 44,537.00 17,847.14 59.93% Communication & Transportation 432002 - Mailing 21.00 112.30 458.70 571.00 550.00 (21.00) 103.82% 432003 - Travel - 691.99 378.71 1,070.70 1,093.00 22.30 97.96% 432004 - Telecommunications - - 9.13 9.13 409.13 400.00 2.23% Total Communication & Transportation 21.00 804.29 846.54 1,650.83 2,052.13 401.30 80.44% Printing & Advertising 433003 - Promotional 5,053.71 39,102.67 4,000.00 43,102.67 57,000.00 13,897.33 75.62% Total Printing & Advertising 5,053.71 39,102.67 4,000.00 43,102.67 57,000.00 13,897.33 75.62% Utilties 435001 - Electric 6,736.95 29,003.30 - 29,003.30 68,664.00 39,660.70 42.24% 435002 - Natural Gas 647.56 14,142.14 - 14,142.14 26,645.00 12,502.86 53.08% Total Utilities 7,384.51 43,145.44 - 43,145.44 95,309.00 52,163.56 45.27% Repairs & Maintenance 436000 - Other R&M 1,735.62 5,142.42 - 5,142.42 23,214.00 18,071.58 22.15% 436005 - Other Equip R&M - - - - 1,050.00 1,050.00 0.00% Total Repairs & Maintenance 1,735.62 5,142.42 - 5,142.42 24,264.00 19,121.58 21.19% Rentals 437002 - Equipment Rental 1,215.40 2,130.58 - 2,130.58 916.00 (1,214.58) 232.60% Total Rentals 1,215.40 2,130.58 - 2,130.58 916.00 (1,214.58) 232.60% Debt Service 438100 - Principal - 37,169.26 - 37,169.26 120,091.00 82,921.74 30.95% 438200 - Interest - 1,858.44 - 1,858.44 12,243.00 10,384.56 15.18% Total Debt Service - 39,027.70 - 39,027.70 132,334.00 93,306.30 29.49% Other Charges & Services 439000 - Misc Charges & Svcs 147.06 1,536.62 - 1,536.62 9,146.00 7,609.38 16.80% 439002 - Licenses & Permits 48.84 550.72 - 550.72 4,839.00 4,288.28 11.38% 439003 - Subscriptions 72.99 3,205.94 - 3,205.94 3,133.00 (72.94) 102.33% 439004 - Dues & Memberships 275.00 572.00 - 572.00 4,000.00 3,428.00 14.30% 439005 - Bank & Credit Card Fees 6,548.30 22,629.16 - 22,629.16 39,990.00 17,360.84 56.59% 439006 - Education & Training - 344.00 - 344.00 800.00 456.00 43.00% 439009 - Trash Removal 959.10 3,349.55 - 3,349.55 14,466.74 11,117.19 23.15% 439018 - Demolition & Clearance - 17,100.00 900.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short 123.29 (329.01) - (329.01) - 329.01 0.00% 439100 - Refunds/Awards/Indemnities - 12.38 - 12.38 1,757.00 1,744.62 0.70% Total Other Services & Charges 8,174.58 48,971.36 900.00 49,871.36 96,131.74 46,260.38 51.88% Total Services & Charges Expenses 35,370.60 198,196.32 12,564.54 210,760.86 452,543.87 241,783.01 46.57% 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 - 29,756.00 - 29,756.00 89,268.00 59,512.00 33.33% 452003 - Allocations-IT - 26,829.00 - 26,829.00 80,487.00 53,658.00 33.33% 452004 - Allocations-Liability Insurance - 4,697.32 - 4,697.32 14,092.00 9,394.68 33.33% 452009 - Allocations-Facilities Mgmt - 1,200.00 - 1,200.00 3,600.00 2,400.00 33.33% Total Other Uses - 62,482.32 - 62,482.32 187,447.00 124,964.68 33.33% Total Expenses 206,077.18 998,702.41 35,108.99 1,033,811.40 2,697,868.27 1,664,056.87 38.32%