Loading...
HomeMy WebLinkAboutAug 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 471.00 285,540.19 221,898.00 (63,642.19) 128.68% 347004 - Golf Green Fees 124,410.55 588,439.66 785,529.00 197,089.34 74.91% 347005 - Golf Cart Rentals 58,055.39 269,140.30 392,284.00 123,143.70 68.61% 347006 - Golf Pro Shop Retail 10,850.65 62,701.48 77,652.00 14,950.52 80.75% 347007 - Golf Driving Range 4,777.00 32,032.00 34,323.00 2,291.00 93.33% 347009 - Golf Outings 1,277.76 10,157.09 - (10,157.09) 0.00% 347012 - Food Sales 11,156.99 53,787.83 68,447.00 14,659.17 78.58% 347013 - Nonalcoholic Beverage 7,686.06 32,301.47 41,633.00 9,331.53 77.59% 347014 - Alcoholic Beverage Sales 28,851.52 130,910.13 151,573.00 20,662.87 86.37% 347026 - Room Rental 2,055.00 2,755.00 7,572.00 4,817.00 36.38% 347100 - Concessions-Employee Discounts (387.10) (1,804.13) - 1,804.13 0.00% Total Culture & Recreation 249,204.82 1,465,961.02 1,780,911.00 314,949.98 82.32% Total Charges for Services 249,204.82 1,465,961.02 1,780,911.00 314,949.98 82.32% Miscellaneous Revenue 360000 - Miscellaneous 1,679.01 4,003.20 1,483.00 (2,520.20) 269.94% Total Miscellaneous Revenue 1,679.01 4,003.20 1,483.00 (2,520.20) 269.94% Refunds & Reimbursements 380000 - Misc Reimbursements - 4,524.82 - (4,524.82) 0.00% Total Refunds & Reimbursements - 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 250,883.83 1,474,489.04 2,218,394.00 743,904.96 66.47% 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,200.79 268,158.85 - 268,158.85 434,369.00 166,210.15 61.74% 410002 - Teamster Wages - 3,387.25 - 3,387.25 90,248.00 86,860.75 3.75% 410003 - Permanent Part Time 52,109.66 242,304.80 - 242,304.80 295,201.00 52,896.20 82.08% 410004 - Extra & Overtime 319.19 2,973.65 - 2,973.65 2,550.00 (423.65) 116.61% 410005 - Seasonal & Interns 1,533.00 7,803.00 - 7,803.00 41,576.00 33,773.00 18.77% 410007 - Longevity Pay - - - - 600.00 600.00 0.00% Total Salaries & Wages 82,162.64 524,627.55 - 524,627.55 864,544.00 339,916.45 60.68% Employee Benefits 411001 - FICA Regular 10,866.56 44,225.06 - 44,225.06 66,330.00 22,104.94 66.67% 411004 - PERF Regular 3,579.40 30,368.05 - 30,368.05 59,369.00 29,000.95 51.15% 411005 - PERF Union - 25.52 - 25.52 1,426.00 1,400.48 1.79% 411007 - Unemployment Comp 3.15 26.16 - 26.16 633.00 606.84 4.13% 411008 - Health Insurance 6,100.74 50,148.52 - 50,148.52 126,094.00 75,945.48 39.77% 411009 - Life Insurance 70.00 565.00 - 565.00 1,080.00 515.00 52.31% 411010 - Med/Surgical/Dental 87.54 716.63 - 716.63 - (716.63) 0.00% 411014 - Parental Leave 113.67 964.04 - 964.04 1,847.00 882.96 52.19% 411015 - Other Fringe Benefits - 200.00 - 200.00 200.00 - 100.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 440.00 - 440.00 660.00 220.00 66.67% August 31, 2023 Total Employee Benefits 20,876.06 127,678.98 - 127,678.98 259,289.00 131,610.02 49.24% Total Personnel Expenses 103,038.70 652,306.53 - 652,306.53 1,123,833.00 471,526.47 58.04% Supplies Expenses Office Supplies 421000 - General Office Supplies 63.48 903.14 - 903.14 1,500.00 596.86 60.21% Total Office Supplies 63.48 903.14 - 903.14 1,500.00 596.86 60.21% Operating Supplies 422000 - Other Operating Supplies 7,358.25 83,092.59 6,311.43 89,404.02 99,699.80 10,295.78 89.67% 422002 - Diesel/CNG 1,895.86 6,475.09 1,988.50 8,463.59 10,936.00 2,472.41 77.39% 422003 - Gasoline 2,113.47 13,393.48 631.50 14,024.98 27,314.50 13,289.52 51.35% 422005 - Uniforms 488.78 3,833.13 - 3,833.13 3,631.00 (202.13) 105.57% 422008 - Medical/Safety Supplies - - - - 500.00 500.00 0.00% 422010 - Plants Chemicals Seed & Fertilizer 4,930.13 102,974.46 5,002.74 107,977.20 144,019.00 36,041.80 74.97% 422014 - Concessions Inventory 31,039.55 104,540.92 1,359.96 105,900.88 87,780.96 (18,119.92) 120.64% 422016 - Inventory For Sale 1,111.73 60,570.62 2,205.31 62,775.93 69,742.21 6,966.28 90.01% Total Operating Supplies 48,937.77 374,880.29 17,499.44 392,379.73 443,623.47 51,243.74 88.45% Repair & Maintenance Supplies 423000 - Other R&M Supplies 2,184.76 32,109.62 5,446.51 37,556.13 46,197.93 8,641.80 81.29% 423006 - Small Tools & Equipment - 368.08 - 368.08 369.00 0.92 99.75% 423009 - Repair Parts 1,221.28 5,476.49 - 5,476.49 6,354.00 877.51 86.19% Total Repair & Maintenance Supplies 3,406.04 37,954.19 5,446.51 43,400.70 52,920.93 9,520.23 82.01% Total Supplies Expenses 52,407.29 413,737.62 22,945.95 436,683.57 498,044.40 61,360.83 87.68% Services & Charges Expenses Professional Services 431000 - Other Professional Services 4,576.36 27,254.03 6,818.00 34,072.03 34,062.00 (10.03) 100.03% 431019 - Security Services 507.79 3,091.01 - 3,091.01 4,200.00 1,108.99 73.60% Total Professional Services 5,084.15 30,345.04 6,818.00 37,163.04 38,262.00 1,098.96 97.13% Communication & Transportation 432002 - Mailing - 165.50 108.70 274.20 571.00 296.80 48.02% 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 - 857.49 496.54 1,354.03 2,073.13 719.10 65.31% Printing & Advertising 433003 - Promotional 3,514.00 44,205.67 2,000.00 46,205.67 57,000.00 10,794.33 81.06% Total Printing & Advertising 3,514.00 44,205.67 2,000.00 46,205.67 57,000.00 10,794.33 81.06% Utilties 435001 - Electric 8,688.53 50,942.37 - 50,942.37 68,664.00 17,721.63 74.19% 435002 - Natural Gas 479.02 14,861.94 - 14,861.94 26,645.00 11,783.06 55.78% Total Utilities 9,167.55 65,804.31 - 65,804.31 95,309.00 29,504.69 69.04% Repairs & Maintenance 436000 - Other R&M - 9,234.15 - 9,234.15 22,998.00 13,763.85 40.15% 436005 - Other Equip R&M - - - - 1,050.00 1,050.00 0.00% Total Repairs & Maintenance - 9,234.15 - 9,234.15 24,048.00 14,813.85 38.40% Rentals 437002 - Equipment Rental 5,275.46 9,096.90 - 9,096.90 8,407.00 (689.90) 108.21% Total Rentals 5,275.46 9,096.90 - 9,096.90 8,407.00 (689.90) 108.21% Debt Service 438100 - Principal 58,015.42 95,184.68 - 95,184.68 120,091.00 24,906.32 79.26% 438200 - Interest 19,730.79 21,589.23 - 21,589.23 12,243.00 (9,346.23) 176.34% 438300 - Paying Agent Fees 250.00 250.00 - 250.00 - (250.00) 0.00% Total Debt Service 77,996.21 117,023.91 - 117,023.91 132,334.00 15,310.09 88.43% Other Charges & Services 439000 - Misc Charges & Svcs 1,259.17 3,015.85 - 3,015.85 9,146.00 6,130.15 32.97% 439002 - Licenses & Permits - 697.24 - 697.24 3,268.00 2,570.76 21.34% 439003 - Subscriptions 72.99 3,351.92 - 3,351.92 3,633.00 281.08 92.26% 439004 - Dues & Memberships 479.99 1,066.98 - 1,066.98 2,000.00 933.02 53.35% 439005 - Bank & Credit Card Fees 6,337.42 37,410.80 - 37,410.80 46,390.00 8,979.20 80.64% 439006 - Education & Training - 344.00 - 344.00 850.00 506.00 40.47% 439009 - Trash Removal 305.66 6,115.12 291.37 6,406.49 10,066.74 3,660.25 63.64% 439018 - Demolition & Clearance - 17,100.00 900.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (72.90) 361.70 - 361.70 - (361.70) 0.00% 439100 - Refunds/Awards/Indemnities - 12.38 - 12.38 1,757.00 1,744.62 0.70% Total Other Services & Charges 8,382.33 69,475.99 1,191.37 70,667.36 95,110.74 24,443.38 74.30% Total Services & Charges Expenses 109,419.70 346,043.46 10,505.91 356,549.37 452,543.87 95,994.50 78.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 - 44,634.00 - 44,634.00 89,268.00 44,634.00 50.00% 452003 - Allocations-IT - 40,243.50 - 40,243.50 80,487.00 40,243.50 50.00% 452004 - Allocations-Liability Insurance - 7,045.98 - 7,045.98 14,092.00 7,046.02 50.00% 452009 - Allocations-Facilities Mgmt - 1,800.00 - 1,800.00 3,600.00 1,800.00 50.00% Total Other Uses - 93,723.48 - 93,723.48 187,447.00 93,723.52 50.00% Total Expenses 264,865.69 1,505,811.09 33,451.86 1,539,262.95 2,697,868.27 1,158,605.32 57.05%