Loading...
HomeMy WebLinkAboutMay 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 22,438.00 270,453.19 221,898.00 (48,555.19) 121.88% 347004 - Golf Green Fees 113,860.50 173,850.90 785,529.00 611,678.10 22.13% 347005 - Golf Cart Rentals 52,532.40 77,911.18 392,284.00 314,372.82 19.86% 347006 - Golf Pro Shop Retail 11,907.69 23,792.90 77,652.00 53,859.10 30.64% 347007 - Golf Driving Range 6,720.00 12,138.00 34,323.00 22,185.00 35.36% 347009 - Golf Outings 1,532.30 3,562.30 - (3,562.30) 0.00% 347012 - Food Sales 11,786.62 16,630.89 68,447.00 51,816.11 24.30% 347013 - Nonalcoholic Beverage 5,658.64 8,274.35 41,633.00 33,358.65 19.87% 347014 - Alcoholic Beverage Sales 30,974.63 42,234.41 151,573.00 109,338.59 27.86% 347026 - Room Rental 100.00 500.00 7,572.00 7,072.00 6.60% 347100 - Concessions-Employee Discounts (368.77) (573.17) - 573.17 0.00% Total Culture & Recreation 257,142.01 628,774.95 1,780,911.00 1,152,136.05 35.31% Total Charges for Services 257,142.01 628,774.95 1,780,911.00 1,152,136.05 35.31% Miscellaneous Revenue 360000 - Miscellaneous 490.64 964.66 1,483.00 518.34 65.05% Total Miscellaneous Revenue 490.64 964.66 1,483.00 518.34 65.05% Refunds & Reimbursements 380000 - Misc Reimbursements - 4,498.75 - (4,498.75) 0.00% Total Refunds & Reimbursements - 4,498.75 - (4,498.75) 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 257,632.65 634,238.36 2,218,394.00 1,584,155.64 28.59% 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.43 153,609.42 - 153,609.42 434,369.00 280,759.58 35.36% 410002 - Teamster Wages - 3,387.25 - 3,387.25 90,248.00 86,860.75 3.75% 410003 - Permanent Part Time 46,289.66 83,923.68 - 83,923.68 295,201.00 211,277.32 28.43% 410004 - Extra & Overtime 594.99 764.22 - 764.22 2,550.00 1,785.78 29.97% 410005 - Seasonal & Interns 1,494.00 2,712.00 - 2,712.00 41,776.00 39,064.00 6.49% 410007 - Longevity Pay - - - - 600.00 600.00 0.00% Total Salaries & Wages 76,463.08 244,396.57 - 244,396.57 864,744.00 620,347.43 28.26% Employee Benefits 411001 - FICA Regular 5,769.56 18,300.74 - 18,300.74 66,330.00 48,029.26 27.59% 411004 - PERF Regular 3,151.60 17,588.17 - 17,588.17 59,369.00 41,780.83 29.63% 411005 - PERF Union - 25.52 - 25.52 1,426.00 1,400.48 1.79% 411007 - Unemployment Comp 2.67 14.83 - 14.83 633.00 618.17 2.34% 411008 - Health Insurance 5,961.54 31,219.90 - 31,219.90 126,094.00 94,874.10 24.76% 411009 - Life Insurance 60.00 310.00 - 310.00 1,080.00 770.00 28.70% 411010 - Med/Surgical/Dental 87.54 454.01 - 454.01 - (454.01) 0.00% 411014 - Parental Leave 98.06 548.16 - 548.16 1,847.00 1,298.84 29.68% 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 275.00 - 275.00 660.00 385.00 41.67% May 31, 2023 Total Employee Benefits 15,185.97 68,936.33 - 68,936.33 259,089.00 190,152.67 26.61% Total Personnel Expenses 91,649.05 313,332.90 - 313,332.90 1,123,833.00 810,500.10 27.88% Supplies Expenses Office Supplies 421000 - General Office Supplies 50.60 458.98 - 458.98 1,050.00 591.02 43.71% Total Office Supplies 50.60 458.98 - 458.98 1,050.00 591.02 43.71% Operating Supplies 422000 - Other Operating Supplies 15,513.06 58,019.64 16,871.80 74,891.44 109,689.80 34,798.36 68.28% 422002 - Diesel/CNG - 1,463.65 - 1,463.65 4,936.00 3,472.35 29.65% 422003 - Gasoline 5,663.07 7,994.01 631.50 8,625.51 27,314.50 18,688.99 31.58% 422005 - Uniforms 161.21 1,657.07 1,249.50 2,906.57 3,631.00 724.43 80.05% 422008 - Medical/Safety Supplies - - - - 500.00 500.00 0.00% 422010 - Plants Chemicals Seed & Fertilizer 89,722.69 93,058.71 2,211.00 95,269.71 163,219.00 67,949.29 58.37% 422014 - Concessions Inventory 7,904.56 26,012.05 12,836.47 38,848.52 87,780.96 48,932.44 44.26% 422016 - Inventory For Sale 5,393.76 41,763.78 35,628.82 77,392.60 40,725.21 (36,667.39) 190.04% Total Operating Supplies 124,358.35 229,968.91 69,429.09 299,398.00 437,796.47 138,398.47 68.39% Repair & Maintenance Supplies 423000 - Other R&M Supplies 3,456.23 21,948.34 3,946.45 25,894.79 54,197.93 28,303.14 47.78% 423009 - Repair Parts 737.55 1,608.06 - 1,608.06 5,000.00 3,391.94 32.16% Total Repair & Maintenance Supplies 4,193.78 23,556.40 3,946.45 27,502.85 59,197.93 31,695.08 46.46% Total Supplies Expenses 128,602.73 253,984.29 73,375.54 327,359.83 498,044.40 170,684.57 65.73% Services & Charges Expenses Professional Services 431000 - Other Professional Services 1,723.05 6,136.69 17,000.00 23,136.69 38,337.00 15,200.31 60.35% 431019 - Security Services 501.41 1,949.39 - 1,949.39 6,200.00 4,250.61 31.44% Total Professional Services 2,224.46 8,086.08 17,000.00 25,086.08 44,537.00 19,450.92 56.33% Communication & Transportation 432002 - Mailing 91.30 91.30 458.70 550.00 550.00 - 100.00% 432003 - Travel - 691.99 378.71 1,070.70 400.00 (670.70) 267.68% 432004 - Telecommunications - - 9.13 9.13 409.13 400.00 2.23% Total Communication & Transportation 91.30 783.29 846.54 1,629.83 1,359.13 (270.70) 119.92% Printing & Advertising 433003 - Promotional 5,137.41 34,048.96 6,000.00 40,048.96 57,000.00 16,951.04 70.26% Total Printing & Advertising 5,137.41 34,048.96 6,000.00 40,048.96 57,000.00 16,951.04 70.26% Utilties 435001 - Electric 2,496.17 22,266.35 - 22,266.35 68,664.00 46,397.65 32.43% 435002 - Natural Gas 1,307.07 13,494.58 - 13,494.58 26,645.00 13,150.42 50.65% Total Utilities 3,803.24 35,760.93 - 35,760.93 95,309.00 59,548.07 37.52% Repairs & Maintenance 436000 - Other R&M 1,500.00 3,406.80 - 3,406.80 23,542.00 20,135.20 14.47% 436005 - Other Equip R&M - - - - 1,050.00 1,050.00 0.00% Total Repairs & Maintenance 1,500.00 3,406.80 - 3,406.80 24,592.00 21,185.20 13.85% Rentals 437002 - Equipment Rental 327.18 915.18 - 915.18 588.00 (327.18) 155.64% Total Rentals 327.18 915.18 - 915.18 588.00 (327.18) 155.64% Debt Service 438100 - Principal 37,169.26 37,169.26 - 37,169.26 120,091.00 82,921.74 30.95% 438200 - Interest 1,858.44 1,858.44 - 1,858.44 12,243.00 10,384.56 15.18% Total Debt Service 39,027.70 39,027.70 - 39,027.70 132,334.00 93,306.30 29.49% Other Charges & Services 439000 - Misc Charges & Svcs 634.56 1,363.49 - 1,363.49 9,839.00 8,475.51 13.86% 439002 - Licenses & Permits 97.68 501.88 - 501.88 4,872.00 4,370.12 10.30% 439003 - Subscriptions 72.99 3,132.95 - 3,132.95 3,100.00 (32.95) 101.06% 439004 - Dues & Memberships - 297.00 - 297.00 4,000.00 3,703.00 7.43% 439005 - Bank & Credit Card Fees 6,305.18 16,080.86 - 16,080.86 39,990.00 23,909.14 40.21% 439006 - Education & Training - 344.00 - 344.00 800.00 456.00 43.00% 439009 - Trash Removal 288.09 2,390.45 - 2,390.45 14,466.74 12,076.29 16.52% 439018 - Demolition & Clearance - 17,100.00 900.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (38.68) (452.30) - (452.30) - 452.30 0.00% 439100 - Refunds/Awards/Indemnities - 12.38 - 12.38 1,757.00 1,744.62 0.70% Total Other Services & Charges 7,359.82 40,770.71 900.00 41,670.71 96,824.74 55,154.03 43.04% Total Services & Charges Expenses 59,471.11 162,799.65 24,746.54 187,546.19 452,543.87 264,997.68 41.44% 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 279,722.89 792,599.16 98,122.08 890,721.24 2,697,868.27 1,807,147.03 33.02%