Loading...
HomeMy WebLinkAboutOct 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 (75.00) 287,409.19 221,898.00 (65,511.19) 129.52% 347004 - Golf Green Fees 57,278.50 842,079.99 785,529.00 (56,550.99) 107.20% 347005 - Golf Cart Rentals 29,457.86 392,103.33 392,284.00 180.67 99.95% 347006 - Golf Pro Shop Retail 4,873.99 86,494.12 77,652.00 (8,842.12) 111.39% 347007 - Golf Driving Range 2,526.00 45,722.95 34,323.00 (11,399.95) 133.21% 347009 - Golf Outings - 13,493.40 - (13,493.40) 0.00% 347012 - Food Sales 5,570.76 68,349.60 68,447.00 97.40 99.86% 347013 - Nonalcoholic Beverage 2,567.30 40,226.06 41,633.00 1,406.94 96.62% 347014 - Alcoholic Beverage Sales 9,541.19 163,362.51 151,573.00 (11,789.51) 107.78% 347026 - Room Rental (571.00) 2,809.28 7,572.00 4,762.72 37.10% 347100 - Concessions-Employee Discounts (163.40) (2,228.59) - 2,228.59 0.00% Total Culture & Recreation 111,006.20 1,939,821.84 1,780,911.00 (158,910.84) 108.92% Total Charges for Services 111,006.20 1,939,821.84 1,780,911.00 (158,910.84) 108.92% Miscellaneous Revenue 360000 - Miscellaneous 1,241.11 6,119.99 1,483.00 (4,636.99) 412.68% Total Miscellaneous Revenue 1,241.11 6,119.99 1,483.00 (4,636.99) 412.68% 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 112,247.31 1,950,466.65 2,218,394.00 267,927.35 87.92% 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 338,369.90 - 338,369.90 434,369.00 95,999.10 77.90% 410002 - Teamster Wages 62,874.67 66,261.92 - 66,261.92 90,248.00 23,986.08 73.42% 410003 - Permanent Part Time 39,157.43 351,624.47 - 351,624.47 295,201.00 (56,423.47) 119.11% 410004 - Extra & Overtime 1,787.38 6,567.59 - 6,567.59 2,550.00 (4,017.59) 257.55% 410005 - Seasonal & Interns 750.00 10,668.00 - 10,668.00 41,576.00 30,908.00 25.66% 410007 - Longevity Pay 350.00 350.00 - 350.00 600.00 250.00 58.33% Total Salaries & Wages 133,003.86 773,841.88 - 773,841.88 864,544.00 90,702.12 89.51% Employee Benefits 411001 - FICA Regular 9,878.29 62,913.72 - 62,913.72 66,330.00 3,416.28 94.85% 411004 - PERF Regular 9,978.92 45,071.29 - 45,071.29 59,369.00 14,297.71 75.92% 411005 - PERF Union 516.85 542.37 - 542.37 1,426.00 883.63 38.03% 411007 - Unemployment Comp 9.95 40.15 - 40.15 633.00 592.85 6.34% 411008 - Health Insurance 25,684.94 81,795.00 - 81,795.00 126,094.00 44,299.00 64.87% 411009 - Life Insurance 230.00 855.00 - 855.00 1,080.00 225.00 79.17% 411010 - Med/Surgical/Dental 364.81 1,168.98 - 1,168.98 - (1,168.98) 0.00% 411014 - Parental Leave 325.44 1,436.67 - 1,436.67 1,847.00 410.33 77.78% 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. 531.25 531.25 - 531.25 850.00 318.75 62.50% 411206 - Cell Phone Allowance 55.00 550.00 - 550.00 660.00 110.00 83.33% October 31, 2023 Total Employee Benefits 47,575.45 195,104.43 - 195,104.43 259,289.00 64,184.57 75.25% Total Personnel Expenses 180,579.31 968,946.31 - 968,946.31 1,123,833.00 154,886.69 86.22% Supplies Expenses Office Supplies 421000 - General Office Supplies 87.15 1,124.39 - 1,124.39 1,500.00 375.61 74.96% Total Office Supplies 87.15 1,124.39 - 1,124.39 1,500.00 375.61 74.96% Operating Supplies 422000 - Other Operating Supplies 3,482.61 95,722.79 6,583.64 102,306.43 103,699.80 1,393.37 98.66% 422002 - Diesel/CNG 2,038.58 10,502.17 - 10,502.17 11,936.00 1,433.83 87.99% 422003 - Gasoline 1,496.50 14,889.98 2,233.40 17,123.38 27,314.50 10,191.12 62.69% 422005 - Uniforms 172.43 4,263.19 - 4,263.19 6,131.00 1,867.81 69.53% 422010 - Plants Chemicals Seed & Fertilizer 2,743.49 110,968.48 2,312.25 113,280.73 134,019.00 20,738.27 84.53% 422014 - Concessions Inventory 18,722.83 128,742.62 1,359.96 130,102.58 132,780.96 2,678.38 97.98% 422016 - Inventory For Sale 600.02 62,582.41 2,125.21 64,707.62 69,742.21 5,034.59 92.78% Total Operating Supplies 29,256.46 427,671.64 14,614.46 442,286.10 485,623.47 43,337.37 91.08% Repair & Maintenance Supplies 423000 - Other R&M Supplies 5,541.62 43,510.46 3,458.52 46,968.98 48,697.93 1,728.95 96.45% 423006 - Small Tools & Equipment 266.43 634.51 - 634.51 369.00 (265.51) 171.95% 423009 - Repair Parts 27.23 5,805.12 741.84 6,546.96 6,854.00 307.04 95.52% Total Repair & Maintenance Supplies 5,835.28 49,950.09 4,200.36 54,150.45 55,920.93 1,770.48 96.83% Total Supplies Expenses 35,178.89 478,746.12 18,814.82 497,560.94 543,044.40 45,483.46 91.62% Services & Charges Expenses Professional Services 431000 - Other Professional Services 1,519.84 30,523.87 9,458.00 39,981.87 43,797.00 3,815.13 91.29% 431019 - Security Services 297.79 3,724.84 - 3,724.84 5,200.00 1,475.16 71.63% Total Professional Services 1,817.63 34,248.71 9,458.00 43,706.71 48,997.00 5,290.29 89.20% Communication & Transportation 432002 - Mailing - 165.50 108.70 274.20 571.00 296.80 48.02% 432003 - Travel - 691.99 - 691.99 1,093.00 401.01 63.31% 432004 - Telecommunications - - 9.13 9.13 9.13 - 100.00% Total Communication & Transportation - 857.49 117.83 975.32 1,673.13 697.81 58.29% Printing & Advertising 433003 - Promotional 2,030.76 48,425.53 - 48,425.53 53,000.00 4,574.47 91.37% Total Printing & Advertising 2,030.76 48,425.53 - 48,425.53 53,000.00 4,574.47 91.37% Utilties 435001 - Electric 2,778.55 60,503.51 - 60,503.51 68,664.00 8,160.49 88.12% 435002 - Natural Gas 469.11 15,801.24 - 15,801.24 26,645.00 10,843.76 59.30% Total Utilities 3,247.66 76,304.75 - 76,304.75 95,309.00 19,004.25 80.06% Repairs & Maintenance 436000 - Other R&M 410.00 10,397.48 - 10,397.48 19,998.00 9,600.52 51.99% Total Repairs & Maintenance 410.00 10,397.48 - 10,397.48 19,998.00 9,600.52 51.99% Rentals 437002 - Equipment Rental - 11,212.50 - 11,212.50 13,407.00 2,194.50 83.63% Total Rentals - 11,212.50 - 11,212.50 13,407.00 2,194.50 83.63% Debt Service 438100 - Principal - 95,184.68 394,615.82 489,800.50 495,299.00 5,498.50 98.89% 438200 - Interest - 21,589.23 71,861.44 93,450.67 73,035.00 (20,415.67) 127.95% 438300 - Paying Agent Fees - 250.00 - 250.00 - (250.00) 0.00% Total Debt Service - 117,023.91 466,477.26 583,501.17 568,334.00 (15,167.17) 102.67% Other Charges & Services 439000 - Misc Charges & Svcs 188.59 4,131.22 90.00 4,221.22 8,146.00 3,924.78 51.82% 439002 - Licenses & Permits 48.84 746.08 - 746.08 2,268.00 1,521.92 32.90% 439003 - Subscriptions 72.99 3,497.90 - 3,497.90 3,633.00 135.10 96.28% 439004 - Dues & Memberships - 2,016.63 - 2,016.63 2,615.00 598.37 77.12% 439005 - Bank & Credit Card Fees 2,922.19 49,209.01 - 49,209.01 46,390.00 (2,819.01) 106.08% 439006 - Education & Training 455.65 816.64 76.11 892.75 850.00 (42.75) 105.03% 439009 - Trash Removal 1,661.64 9,916.96 - 9,916.96 11,066.74 1,149.78 89.61% 439018 - Demolition & Clearance - 18,000.00 - 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short 5.76 2,005.28 - 2,005.28 - (2,005.28) 0.00% 439100 - Refunds/Awards/Indemnities - 12.38 - 12.38 857.00 844.62 1.44% Total Other Services & Charges 5,355.66 90,352.10 166.11 90,518.21 93,825.74 3,307.53 96.47% Total Services & Charges Expenses 12,861.71 388,822.47 476,219.20 865,041.67 894,543.87 29,502.20 96.70% Other Uses 452002 - Allocations-Admin Cost 7,439.00 74,390.00 - 74,390.00 89,268.00 14,878.00 83.33% 452003 - Allocations-IT 6,707.25 67,072.50 - 67,072.50 80,487.00 13,414.50 83.33% 452004 - Allocations-Liability Insurance 1,174.33 11,743.30 - 11,743.30 14,092.00 2,348.70 83.33% 452009 - Allocations-Facilities Mgmt 300.00 3,000.00 - 3,000.00 3,600.00 600.00 83.33% Total Other Uses 15,620.58 156,205.80 - 156,205.80 187,447.00 31,241.20 83.33% Total Expenses 244,240.49 1,992,720.70 495,034.02 2,487,754.72 2,748,868.27 261,113.55 90.50%