Loading...
HomeMy WebLinkAboutJuly 22 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 58% Parks General Fund: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected Taxes Property Taxes 311000 - Civil City Property Taxes -5,801,007.69 10,580,413.00 4,779,405.31 54.83% Total Property Taxes - 5,801,007.69 10,580,413.00 4,779,405.31 54.83% Total Taxes - 5,801,007.69 10,580,413.00 4,779,405.31 54.83% Total Intergovernmental Revenue - 427,491.38 953,848.00 526,356.62 44.82% Licenses & Permits Nonbusiness Licenses & Permits 322050 - Park Food Sales Permit 26.25 186.25 250.00 63.75 74.50% Charges for Services Culture & Recreation 347001 - Swimming Pool 13,504.80 29,134.26 40,213.00 11,078.74 72.45% 347002 - Picnic Site Rental 522.04 2,946.64 -(2,946.64)0.00% 347003 - Golf Season Pass 1,382.00 268,494.20 172,000.00 (96,494.20)156.10% 347004 - Golf Green Fees 148,057.42 471,427.03 805,000.00 333,572.97 58.56% 347005 - Golf Cart Rentals 67,707.12 211,417.40 365,000.00 153,582.60 57.92% 347006 - Golf Pro Shop Retail 12,996.84 42,875.43 59,500.00 16,624.57 72.06% 347007 - Golf Driving Range 7,545.00 24,830.00 30,000.00 5,170.00 82.77% 347008 - Golf Gift Certificate -35.00 -(35.00)0.00% 347009 - Golf Outings 2,548.91 6,827.74 -(6,827.74)0.00% 347010 - Concession Sales 8,196.29 39,972.05 69,000.00 29,027.95 57.93% 347011 - Recreational Programming 41,589.04 317,331.98 523,565.00 206,233.02 60.61% 347012 - Food Sales 12,285.43 38,686.02 53,277.00 14,590.98 72.61% 347013 - Nonalcoholic Beverage 7,646.23 22,720.81 31,500.00 8,779.19 72.13% 347014 - Alcoholic Beverage Sales 27,707.45 86,858.80 110,900.00 24,041.20 78.32% 347015 - Lease of Stadium 15,000.00 45,000.00 75,000.00 30,000.00 60.00% 347016 - East Race Waterway 22,545.05 36,647.85 60,000.00 23,352.15 61.08% 347017 - Ice Skating -197,057.38 300,000.00 102,942.62 65.69% 347019 - Site Mowing --222,839.00 222,839.00 0.00% 347021 - Tree Maintenance 32,133.04 114,266.38 120,000.00 5,733.62 95.22% 347026 - Room Rental 2,864.90 74,572.65 56,000.00 (18,572.65)133.17% 347030 - Merch Sales 162.40 1,598.98 -(1,598.98)0.00% 347040 - Pavilion Rental 4,087.92 25,171.75 15,000.00 (10,171.75)167.81% 347100 - Concessions-Employee Discounts (318.62)(1,100.94)-1,100.94 0.00% Total Culture & Recreation 428,163.26 2,056,771.41 3,108,794.00 1,052,022.59 66.16% Total Charges for Services 428,163.26 2,056,771.41 3,108,794.00 1,052,022.59 66.16% Miscellaneous Revenue 360000 - Miscellaneous 2,115.17 8,048.82 9,500.00 1,451.18 84.72% 360001 - Sale of Scrap Metal -846.32 -(846.32)0.00% 361000 - Interest Earnings 3,396.00 11,597.08 15,000.00 3,402.92 77.31% 362000 - Rental of Property 11,231.50 44,056.00 60,000.00 15,944.00 73.43% 367000 - Donations from Private Sources -640,828.93 1,061,000.00 420,171.07 60.40% Total Miscellaneous Revenue 16,742.67 705,377.15 1,145,500.00 440,122.85 61.58% Refunds & Reimbursements 380000 - Misc Reimbursements 251.72 18,071.29 18,253.00 181.71 99.00% 380007 - Energy Rebates -808.98 809.00 0.02 100.00% 381000 - Misc Reimbursements -4,916.40 245,441.00 240,524.60 2.00% 396000 - Refunds 2,463.90 45,747.67 43,284.00 (2,463.67)105.69% Total Refunds & Reimbursements 2,715.62 69,544.34 307,787.00 238,242.66 22.59% Other Sources 391000 - Interfund Transfers In 9,935.00 69,546.00 119,221.00 49,675.00 58.33% 393000 - Capital Lease Proceeds -1,290,000.00 1,290,000.00 -100.00% Total Other Sources 9,935.00 1,359,546.00 1,409,221.00 49,675.00 96.48% Total Revenue 457,582.80 10,419,924.22 17,505,813.00 7,085,888.78 59.52% EXPENDITURES July 31, 2022 Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenses Salaries & Wages 410001 - Salaried Wages 215,566.80 1,626,378.27 -1,626,378.27 3,049,049.00 1,422,670.73 53.34% 410002 - Teamster Wages 114,789.89 823,431.91 -823,431.91 1,542,175.00 718,743.09 53.39% 410003 - Permanent Part Time 106,363.57 490,013.44 -490,013.44 1,038,670.00 548,656.56 47.18% 410004 - Extra & Overtime 16,605.82 81,155.77 -81,155.77 95,975.00 14,819.23 84.56% 410005 - Seasonal & Interns 138,980.87 437,672.90 -437,672.90 834,551.00 396,878.10 52.44% 410007 - Longevity Pay 200.00 5,045.83 -5,045.83 8,450.00 3,404.17 59.71% 410014 - Contract Add Pays ------0.00% 410017 - Stand By Pay 385.64 1,675.12 -1,675.12 3,500.00 1,824.88 47.86% 410022 - Park Board Stipend ----1,200.00 1,200.00 0.00% Total Salaries & Wages 592,892.59 3,465,373.24 - 3,465,373.24 6,573,570.00 3,108,196.76 52.72% Employee Benefits 411001 - FICA Regular 43,994.55 271,080.39 -271,080.39 506,363.00 235,282.61 53.53% 411004 - PERF Regular 36,822.86 289,628.05 -289,628.05 530,630.00 241,001.95 54.58% 411005 - PERF Union 1,332.83 11,022.98 -11,022.98 26,912.00 15,889.02 40.96% 411007 - Unemployment Comp 581.76 3,932.73 -3,932.73 7,520.00 3,587.27 52.30% 411008 - Health Insurance 88,159.08 604,869.60 -604,869.60 1,192,876.00 588,006.40 50.71% 411009 - Life Insurance 835.00 5,740.00 -5,740.00 10,560.00 4,820.00 54.36% 411014 - Parental Leave 1,203.80 8,843.24 -8,843.24 16,447.00 7,603.76 53.77% 411015 - Other Fringe Benefits -1,490.00 -1,490.00 1,500.00 10.00 99.33% 411201 - Tool Allowance -2,923.62 -2,923.62 4,800.00 1,876.38 60.91% 411203 - Job Readiness Allow.-14,875.00 -14,875.00 19,425.00 4,550.00 76.58% 411204 - Auto Allowance 266.66 1,866.62 -1,866.62 3,200.00 1,333.38 58.33% 411206 - Cell Phone Allowance 1,045.00 7,370.00 -7,370.00 12,820.00 5,450.00 57.49% Total Employee Benefits 174,241.54 1,223,642.23 - 1,223,642.23 2,333,053.00 1,109,410.77 52.45% Total Personnel Expenses 767,134.13 4,689,015.47 - 4,689,015.47 8,906,623.00 4,217,607.53 52.65% Supplies Expenses Office Supplies 421000 - General Office Supplies 2,128.76 9,880.54 4.49 9,885.03 23,529.18 13,644.15 42.01% Total Office Supplies 2,128.76 9,880.54 4.49 9,885.03 23,529.18 13,644.15 42.01% Operating Supplies 422000 - Other Operating Supplies 37,662.02 199,968.13 41,310.98 241,279.11 296,554.02 55,274.91 81.36% 422001 - C.S. Gasoline 32,084.94 140,515.45 -140,515.45 165,000.00 24,484.55 85.16% 422002 - Diesel/CNG -1,886.00 3,546.27 5,432.27 4,000.00 (1,432.27)135.81% 422003 - Gasoline -10,462.61 4,969.82 15,432.43 25,905.00 10,472.57 59.57% 422004 - Oil -35.30 -35.30 50.00 14.70 70.60% 422005 - Uniforms 1,178.16 7,494.93 1,218.25 8,713.18 21,695.00 12,981.82 40.16% 422006 - Computer Supplies & Equipment -319.93 -319.93 500.00 180.07 63.99% 422007 - Cleaning Supplies 132.84 1,664.75 -1,664.75 4,950.00 3,285.25 33.63% 422008 - Medical/Safety Supplies 602.48 11,759.38 -11,759.38 14,756.00 2,996.62 79.69% 422009 - Recreation Supplies 21,082.51 76,514.83 33,855.78 110,370.61 253,301.60 142,930.99 43.57% 422010 - Plants Chemicals Seed & Fertilizer 13,144.90 130,654.08 29,623.55 160,277.63 182,575.00 22,297.37 87.79% 422014 - Concessions Inventory 18,918.53 82,351.10 10,840.09 93,191.19 84,205.00 (8,986.19)110.67% 422016 - Inventory For Sale 4,452.66 37,269.28 -37,269.28 34,035.00 (3,234.28)109.50% Total Operating Supplies 129,259.04 700,895.77 125,364.74 826,260.51 1,087,526.62 261,266.11 75.98% Repair & Maintenance Supplies 423000 - Other R&M Supplies 38,930.72 164,811.22 29,574.36 194,385.58 259,265.04 64,879.46 74.98% 423001 - Building Materials 8,576.22 45,300.73 8,835.10 54,135.83 90,000.00 35,864.17 60.15% 423006 - Small Tools & Equipment 3,686.39 14,503.35 -14,503.35 25,573.00 11,069.65 56.71% 423009 - Repair Parts 2,974.65 38,593.39 2,515.00 41,108.39 82,429.03 41,320.64 49.87% Total Repair & Maintenance Supplies 54,167.98 263,208.69 40,924.46 304,133.15 457,267.07 153,133.92 66.51% Total Supplies Expenses 185,555.78 973,985.00 166,293.69 1,140,278.69 1,568,322.87 428,044.18 72.71% Services & Charges Expenses Professional Services 431000 - Other Professional Services 30,153.32 85,130.73 40,701.34 125,832.07 142,377.00 16,544.93 88.38% 431009 - Computer & Technology -31.83 -31.83 500.00 468.17 6.37% 431014 - Collection Costs -23.75 11.25 35.00 50.00 15.00 70.00% 431019 - Security Services 5,794.77 23,480.84 10,362.00 33,842.84 33,540.00 (302.84)100.90% Total Professional Services 35,948.09 108,667.15 51,074.59 159,741.74 176,467.00 16,725.26 90.52% Communication & Transportation 432002 - Mailing 589.79 1,006.31 -1,006.31 4,875.00 3,868.69 20.64% 432003 - Travel -2,732.03 5,035.70 7,767.73 27,950.00 20,182.27 27.79% 432004 - Telecommunications 350.88 1,477.34 3,153.80 4,631.14 10,003.80 5,372.66 46.29% 432005 - Mileage Reimb 112.35 415.67 469.96 885.63 3,705.00 2,819.37 23.90% Total Communication & Transportation 1,053.02 5,631.35 8,659.46 14,290.81 46,533.80 32,242.99 30.71% Printing & Advertising 433001 - Outside Printing Services 3,311.42 10,785.98 1,091.52 11,877.50 23,780.00 11,902.50 49.95% 433002 - Publication of Legal Notice -495.60 894.10 1,389.70 2,000.00 610.30 69.49% 433003 - Promotional 20,877.84 225,982.48 67,401.14 293,383.62 389,614.06 96,230.44 75.30% Total Printing & Advertising 24,189.26 237,264.06 69,386.76 306,650.82 415,394.06 108,743.24 73.82% Utilties 435001 - Electric 46,865.35 302,279.73 -302,279.73 452,847.00 150,567.27 66.75% 435002 - Natural Gas 6,234.89 140,278.33 -140,278.33 113,457.00 (26,821.33)123.64% 435004 - Water 48,371.19 133,354.96 -133,354.96 214,000.00 80,645.04 62.32% Total Utilities 101,471.43 575,913.02 - 575,913.02 780,304.00 204,390.98 73.81% Repairs & Maintenance 436000 - Other R&M 4,173.72 18,566.02 20,921.14 39,487.16 83,600.53 44,113.37 47.23% 436001 - Building R&M 7,854.78 146,260.00 28,071.88 174,331.88 206,994.82 32,662.94 84.22% 436003 - Auto Equip R&M 23,484.33 188,286.03 -188,286.03 297,000.00 108,713.97 63.40% 436005 - Other Equip R&M -1,309.67 108.00 1,417.67 6,800.00 5,382.33 20.85% 436006 - Radio Equip R&M 2,316.15 8,583.59 -8,583.59 3,500.00 (5,083.59)245.25% 436011 - Exterminating -3,416.00 746.00 4,162.00 8,334.00 4,172.00 49.94% Total Repairs & Maintenance 37,828.98 366,421.31 49,847.02 416,268.33 606,229.35 189,961.02 68.67% Rentals 437002 - Equipment Rental 560.00 560.00 -560.00 -(560.00)0.00% 437005 - Parking Space Rental -12,000.00 -12,000.00 12,000.00 -100.00% 437006 - Recreation Space Rental -1,200.00 -1,200.00 1,200.00 -100.00% Total Rentals 560.00 13,760.00 - 13,760.00 13,200.00 (560.00) 104.24% Debt Service 438100 - Principal 133,096.72 316,842.88 -316,842.88 387,682.81 70,839.93 81.73% 438200 - Interest 3,114.38 17,545.26 -17,545.26 23,339.19 5,793.93 75.18% 438300 - Paying Agent Fees -4,400.00 -4,400.00 5,000.00 600.00 88.00% Total Debt Service 136,211.10 338,788.14 - 338,788.14 416,022.00 77,233.86 81.44% Other Charges & Services 439000 - Misc Charges & Svcs 134,158.91 366,407.27 164,052.44 530,459.71 689,255.29 158,795.58 76.96% 439001 - Other Contractual Services 4,653.99 5,933.38 3,500.00 9,433.38 11,000.00 1,566.62 85.76% 439002 - Licenses & Permits 2,111.03 11,891.54 -11,891.54 12,625.00 733.46 94.19% 439003 - Subscriptions 710.54 2,571.12 -2,571.12 3,720.00 1,148.88 69.12% 439004 - Dues & Memberships 1,039.36 9,107.37 -9,107.37 18,010.00 8,902.63 50.57% 439005 - Bank & Credit Card Fees 10,076.23 58,214.31 -58,214.31 75,835.00 17,620.69 76.76% 439006 - Education & Training 704.95 12,994.89 2,998.73 15,993.62 26,525.00 10,531.38 60.30% 439009 - Trash Removal 7,306.98 33,176.53 9,862.92 43,039.45 52,434.41 9,394.96 82.08% 439012 - Uniform Services 1,970.27 9,190.57 -9,190.57 8,200.00 (990.57)112.08% 439018 - Demolition & Clearance --18,000.00 18,000.00 18,000.00 -100.00% 439099 - Cashier Over/Short (157.66)680.84 -680.84 2,300.00 1,619.16 29.60% 439100 - Refunds/Awards/Indemnities 1,583.28 18,002.40 -18,002.40 30,485.00 12,482.60 59.05% 439300 - Grants & Subsidies -715,000.00 -715,000.00 715,000.00 -100.00% Total Other Services & Charges 164,157.88 1,243,170.22 198,414.09 1,441,584.31 1,663,389.70 221,805.39 86.67% Total Services & Charges Expenses 501,419.76 2,889,615.25 377,381.92 3,266,997.17 4,117,539.91 850,542.74 79.34% Capital Outlay Buildings 443001 - Building Improvements -100,948.75 1,501.25 102,450.00 102,450.00 -100.00% Total Buildings - 100,948.75 1,501.25 102,450.00 102,450.00 - 100.00% 444000 - Land Improvements -216,716.38 892,321.32 1,109,037.70 1,294,470.49 185,432.79 85.68% Machinery & Equipment 445000 - Motor Equipment -10,866.95 -10,866.95 10,866.86 (0.09)100.00% 445003 - Park Equipment -7,062.50 143,215.00 150,277.50 686,027.50 535,750.00 21.91% 445006 - Computer Equip/Network 17,007.12 17,007.12 -17,007.12 17,011.00 3.88 99.98% 445100 - Lease Purchase/Motor Equip --513,394.53 513,394.53 1,290,000.00 776,605.47 39.80% Total Machinery & Equipment 17,007.12 34,936.57 656,609.53 691,546.10 2,003,905.36 1,312,359.26 34.51% Total Capital Expenses 17,007.12 352,601.70 1,550,432.10 1,903,033.80 3,400,825.85 1,497,792.05 55.96% Other Uses 452002 - Allocations-Admin Cost 61,510.58 430,574.10 -430,574.10 738,127.00 307,552.90 58.33% 452003 - Allocations-IT 57,450.84 402,155.80 -402,155.80 689,410.00 287,254.20 58.33% 452004 - Allocations-Liability Insurance 24,384.42 170,690.90 -170,690.90 292,613.00 121,922.10 58.33% 452008 - Allocations-Payroll Cost 6,895.25 48,266.75 -48,266.75 82,743.00 34,476.25 58.33% 452009 - Allocations-Facilities Mgmt 2,296.25 16,073.75 -16,073.75 27,555.00 11,481.25 58.33% Total Other Uses 152,537.34 1,067,761.30 - 1,067,761.30 1,830,448.00 762,686.70 58.33% Bad Debt Expense 490000 - Bad Debt Expense 1,000.00 1,000.00 -1,000.00 -(1,000.00)0.00% Total Bad Debt Expense 1,000.00 1,000.00 - 1,000.00 - (1,000.00) 0.00% Total Expenses 1,624,654.13 9,973,978.72 2,094,107.71 12,068,086.43 19,823,759.63 7,755,673.20 60.88%