Loading...
HomeMy WebLinkAboutJune 21 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 50% 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,705,124.46 5,705,124.46 9,247,389.00 3,542,264.54 61.69% Total Property Taxes 5,705,124.46 5,705,124.46 9,247,389.00 3,542,264.54 61.69% Total Taxes 5,705,124.46 5,705,124.46 9,247,389.00 3,542,264.54 61.69% State Shared Revenue 335002 - Vehicle/Aircraft Excise 376,063.14 376,063.14 752,272.00 376,208.86 49.99% 335007 - Commercial Vehicle Excise 85,147.87 85,147.87 154,422.00 69,274.13 55.14% Total State Shared Revenue 461,211.01 461,211.01 906,694.00 445,482.99 50.87% Total Intergovernmental Revenue 661,211.01 661,211.01 1,106,694.00 445,482.99 59.75% Total Nonbusiness Licenses & Permits 28.00 58.00 58.00 - 100.00% Total Licenses & Permits 28.00 58.00 58.00 - 100.00% Charges for Services Culture & Recreation 347001 - Swimming Pool 21,760.06 21,760.06 20,000.00 (1,760.06) 108.80% 347002 - Picnic Site Rental 1,310.25 3,599.57 3,300.00 (299.57) 109.08% 347003 - Golf Season Pass 6,314.00 226,065.85 93,000.00 (133,065.85) 243.08% 347004 - Golf Green Fees 137,742.45 339,328.36 795,000.00 455,671.64 42.68% 347005 - Golf Cart Rentals 62,020.97 151,625.47 360,000.00 208,374.53 42.12% 347006 - Golf Pro Shop Retail 13,239.26 35,437.15 59,500.00 24,062.85 59.56% 347007 - Golf Driving Range 5,645.00 15,516.97 30,000.00 14,483.03 51.72% 347008 - Golf Gift Certificate 1,636.66 (11,077.08) - 11,077.08 0.00% 347010 - Concession Sales 12,487.65 22,570.96 31,000.00 8,429.04 72.81% 347011 - Recreational Programming 37,261.54 217,963.27 361,500.00 143,536.73 60.29% 347012 - Food Sales 10,569.56 26,745.58 53,277.00 26,531.42 50.20% 347013 - Nonalcoholic Beverage 7,346.36 15,512.93 33,398.00 17,885.07 46.45% 347014 - Alcoholic Beverage Sales 23,495.53 58,910.95 110,000.00 51,089.05 53.56% 347015 - Lease of Stadium 15,000.00 55,000.00 75,000.00 20,000.00 73.33% 347016 - East Race Waterway 8,680.55 9,835.55 55,000.00 45,164.45 17.88% 347017 - Ice Skating - 162,898.30 300,000.00 137,101.70 54.30% 347018 - Skate Rental - - - - 0.00% 347019 - Site Mowing 1,227.59 1,227.59 95,000.00 93,772.41 1.29% 347021 - Tree Maintenance 886.00 35,368.40 120,000.00 84,631.60 29.47% 347023 - Graffiti Removal 1,482.15 1,482.15 102,529.00 101,046.85 1.45% 347026 - Room Rental 7,923.16 33,156.25 9,000.00 (24,156.25) 368.40% 347030 - Merch Sales 41.19 799.19 2,500.00 1,700.81 31.97% 347040 - Pavilion Rental 4,320.72 21,839.12 22,446.00 606.88 97.30% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347100 - Concessions-Employee Discounts (622.29) (1,376.55) - 1,376.55 0.00% 347101 - Room Rental-Employee Discounts - (71.46) - 71.46 0.00% Total Culture & Recreation 379,768.36 1,448,006.53 2,731,450.00 1,283,443.47 53.01% Total Charges for Services 379,768.36 1,448,006.53 2,731,450.00 1,283,443.47 53.01% Miscellaneous Revenue 360000 - Miscellaneous 541.75 2,569.56 25,000.00 22,430.44 10.28% 360001 - Sale of Scrap Metal 245.35 399.59 - (399.59) 0.00% 361000 - Interest Earnings 30.47 9,115.73 40,000.00 30,884.27 22.79% 362000 - Rental of Property 10,831.50 47,078.75 60,000.00 12,921.25 78.46% 367000 - Donations from Private Sources 16,000.00 746,029.00 1,805,000.00 1,058,971.00 41.33% Total Miscellaneous Revenue 27,649.07 805,192.63 1,930,000.00 1,124,807.37 41.72% Refunds & Reimbursements 380000 - Misc Reimbursements 19,612.00 35,856.21 38,572.00 2,715.79 92.96% 380007 - Energy Rebates - 962.27 - (962.27) 0.00% 396000 - Refunds (15,845.00) 5,837.91 5,267.00 (570.91) 110.84% Total Refunds & Reimbursements 3,767.00 42,656.39 43,839.00 1,182.61 97.30% Other Sources 391000 - Interfund Transfers In 102,711.00 616,275.00 1,234,486.00 618,211.00 49.92% June 30, 2021 Total Other Sources 102,711.00 616,275.00 1,234,486.00 618,211.00 49.92% Total Revenue 6,880,258.90 9,278,524.02 16,293,916.00 7,015,391.98 56.94% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenditures Salaries & Wages 410001 - Salaried Wages 216,358.94 1,446,901.82 - 1,446,901.82 2,812,332.00 1,365,430.18 51.45% 410002 - Teamster Wages 113,109.82 727,499.73 - 727,499.73 1,437,385.00 709,885.27 50.61% 410003 - Permanent Part Time 72,857.60 318,953.16 - 318,953.16 670,035.00 351,081.84 47.60% 410004 - Extra & Overtime 10,766.83 44,397.57 - 44,397.57 61,639.00 17,241.43 72.03% 410005 - Seasonal & Interns 98,541.40 237,600.05 - 237,600.05 839,760.00 602,159.95 28.29% 410007 - Longevity Pay 650.00 5,300.00 - 5,300.00 8,050.00 2,750.00 65.84% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 0.00% Total Salaries & Wages 512,284.59 2,780,652.33 - 2,780,652.33 5,830,401.00 3,049,748.67 47.69% Employee Benefits 411001 - FICA Regular 38,068.64 208,512.31 - 208,512.31 449,080.00 240,567.69 46.43% 411004 - PERF Regular 37,015.50 243,558.23 - 243,558.23 489,666.00 246,107.77 49.74% 411005 - PERF Union 1,420.36 9,325.69 - 9,325.69 22,866.00 13,540.31 40.78% 411007 - Unemployment Comp 491.21 683.37 - 683.37 1,278.00 594.63 53.47% 411008 - Health Insurance 87,364.82 531,698.09 - 531,698.09 988,554.00 456,855.91 53.79% 411009 - Life Insurance 860.00 5,220.00 - 5,220.00 10,320.00 5,100.00 50.58% 411014 - Parental Leave 1,178.70 7,773.56 - 7,773.56 15,159.00 7,385.44 51.28% 411015 - Other Fringe Benefits - 1,600.00 - 1,600.00 1,600.00 - 100.00% 411201 - Tool Allowance - 774.79 - 774.79 3,200.00 2,425.21 24.21% 411203 - Job Readiness Allow. - 15,300.00 - 15,300.00 15,300.00 - 100.00% 411204 - Auto Allowance 266.66 1,599.96 - 1,599.96 3,200.00 1,600.04 50.00% 411206 - Cell Phone Allowance 1,155.00 7,205.00 - 7,205.00 17,820.00 10,615.00 40.43% Total Employee Benefits 167,820.89 1,033,251.00 - 1,033,251.00 2,018,043.00 984,792.00 51.20% Total Personnel Expenditures 680,105.48 3,813,903.33 - 3,813,903.33 7,848,444.00 4,034,540.67 48.59% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 611.39 3,818.28 28.50 3,846.78 2,899.89 (946.89) 132.65% 421002 - Stationary & Printing 3,376.95 4,689.80 307.30 4,997.10 25,598.00 20,600.90 19.52% Total Office Supplies 3,988.34 8,508.08 335.80 8,843.88 28,497.89 19,654.01 31.03% Operating Supplies 422000 - Other Operating Supplies 28,170.04 189,818.08 43,588.35 233,406.43 263,221.78 29,815.35 88.67% 422001 - C.S. Gasoline 17,512.51 72,985.26 - 72,985.26 164,871.00 91,885.74 44.27% 422002 - Diesel/CNG 4,228.84 5,400.64 - 5,400.64 10,947.00 5,546.36 49.33% 422003 - Gasoline 1,156.00 6,102.08 - 6,102.08 16,961.00 10,858.92 35.98% 422005 - Uniforms - 2,421.22 186.62 2,607.84 13,428.00 10,820.16 19.42% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 320.00 0.07 99.98% 422007 - Cleaning Supplies 193.96 426.02 - 426.02 233.00 (193.02) 182.84% 422008 - Medical/Safety Supplies 1,009.58 9,210.40 - 9,210.40 17,087.19 7,876.79 53.90% 422009 - Recreation Supplies 17,869.03 71,057.66 6,744.14 77,801.80 302,343.82 224,542.02 25.73% 422010 - Plants Chemicals Seed & Fertilizer 3,909.38 78,458.12 21,489.15 99,947.27 156,833.77 56,886.50 63.73% 422013 - Promotional Supplies 870.13 1,512.53 - 1,512.53 - (1,512.53) 0.00% 422014 - Concessions Inventory 26,093.03 48,687.86 5,562.10 54,249.96 104,848.00 50,598.04 51.74% 422016 - Inventory For Sale - 30,857.92 7,888.42 38,746.34 38,000.00 (746.34) 101.96% Total Operating Supplies 101,012.50 517,257.72 85,458.78 602,716.50 1,089,094.56 486,378.06 55.34% Repair & Maintenance Supplies 423000 - Other R&M Supplies 22,983.23 81,214.76 4,920.21 86,134.97 256,805.86 170,670.89 33.54% 423001 - Building Materials 3,735.56 12,588.73 13,430.98 26,019.71 67,757.51 41,737.80 38.40% 423006 - Small Tools & Equipment 5,369.09 46,450.03 3,269.33 49,719.36 56,748.00 7,028.64 87.61% 423009 - Repair Parts 3,657.23 32,482.65 17,914.50 50,397.15 76,411.53 26,014.38 65.95% Total Repair & Maintenance Supplies 35,745.11 172,736.17 39,535.02 212,271.19 457,722.90 245,451.71 46.38% Total Supplies Expenditures 140,745.95 698,501.97 125,329.60 823,831.57 1,575,315.35 751,483.78 52.30% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 10,908.96 38,573.32 32,013.59 70,586.91 135,141.96 64,555.05 52.23% 431001 - Legal Services - 195.00 - 195.00 195.00 - 100.00% 431015 - Laboratory Water Testing - 175.00 - 175.00 175.00 - 100.00% 431019 - Security Services - 17,343.16 - 17,343.16 184,204.00 166,860.84 9.42% Total Professional Services 10,908.96 56,286.48 32,013.59 88,300.07 319,715.96 231,415.89 27.62% Communication & Transportation 432002 - Mailing 2.07 163.30 - 163.30 5,019.00 4,855.70 3.25% 432003 - Travel 442.21 442.21 - 442.21 23,866.00 23,423.79 1.85% 432004 - Telecommunications 207.03 1,916.09 3,803.72 5,719.81 11,049.81 5,330.00 51.76% 432005 - Mileage Reimb - - - - 7,744.00 7,744.00 0.00% Total Communication & Transportation 651.31 2,521.60 3,803.72 6,325.32 47,678.81 41,353.49 13.27% Printing & Advertising 433001 - Outside Printing Services 1,580.72 6,670.68 1,080.00 7,750.68 31,906.00 24,155.32 24.29% 433002 - Publication of Legal Notice 121.70 408.64 89.88 498.52 2,322.74 1,824.22 21.46% 433003 - Promotional 14,783.94 69,938.69 43,608.59 113,547.28 248,702.90 135,155.62 45.66% Total Printing & Advertising 16,486.36 77,018.01 44,778.47 121,796.48 282,931.64 161,135.16 43.05% Utilties 435001 - Electric 47,914.06 249,186.89 - 249,186.89 371,794.00 122,607.11 67.02% 435002 - Natural Gas 6,482.86 107,289.46 - 107,289.46 127,082.00 19,792.54 84.43% 435004 - Water 37,734.56 111,853.37 - 111,853.37 198,000.00 86,146.63 56.49% Total Utilities 92,131.48 468,329.72 - 468,329.72 696,876.00 228,546.28 67.20% Repairs & Maintenance 436000 - Other R&M 10,167.00 25,761.50 51,629.66 77,391.16 61,178.12 (16,213.04) 126.50% 436001 - Building R&M 3,854.94 70,741.85 38,427.17 109,169.02 123,828.44 14,659.42 88.16% 436003 - Auto Equip R&M 59,754.41 215,090.33 5,778.05 220,868.38 327,991.00 107,122.62 67.34% 436005 - Other Equip R&M - - 159.00 159.00 159.00 - 100.00% 436006 - Radio Equip R&M 3,365.00 6,771.12 - 6,771.12 5,155.00 (1,616.12) 131.35% 436011 - Exterminating 1,472.00 4,762.64 8,335.00 13,097.64 18,739.00 5,641.36 69.90% Total Repairs & Maintenance 78,613.35 323,127.44 104,328.88 427,456.32 537,050.56 109,594.24 79.59% Rentals 437002 - Equipment Rental - - - - 1,200.00 1,200.00 0.00% 437005 - Parking Space Rental - 12,000.00 - 12,000.00 12,000.00 - 100.00% 437006 - Recreation Space Rental - - 700.00 700.00 700.00 - 100.00% Total Rentals - 12,000.00 700.00 12,700.00 13,900.00 1,200.00 91.37% Debt Service 438100 - Principal 262.50 277,609.67 - 277,609.67 461,923.00 184,313.33 60.10% 438200 - Interest 6.06 22,332.36 - 22,332.36 32,286.00 9,953.64 69.17% Total Debt Service 268.56 299,942.03 - 299,942.03 494,209.00 194,266.97 60.69% Other Charges & Services 439000 - Misc Charges & Svcs 23,551.95 103,423.89 122,270.35 225,694.24 215,125.80 (10,568.44) 104.91% 439001 - Other Contractual Services 1,083.66 5,124.70 4,124.26 9,248.96 43,578.26 34,329.30 21.22% 439002 - Licenses & Permits 130.89 8,672.16 - 8,672.16 8,562.00 (110.16) 101.29% 439003 - Subscriptions 12.95 475.75 - 475.75 1,926.00 1,450.25 24.70% 439004 - Dues & Memberships 204.00 4,275.94 - 4,275.94 18,975.00 14,699.06 22.53% 439005 - Bank & Credit Card Fees 11,834.66 38,735.43 - 38,735.43 62,275.00 23,539.57 62.20% 439006 - Education & Training - 3,117.84 1,269.00 4,386.84 26,582.00 22,195.16 16.50% 439009 - Trash Removal 1,901.16 11,080.20 16,201.81 27,282.01 35,688.18 8,406.17 76.45% 439012 - Uniform Services - 3,851.13 - 3,851.13 3,852.00 0.87 99.98% 439099 - Cashier Over/Short (124.24) (173.85) - (173.85) - 173.85 0.00% 439100 - Refunds/Awards/Indemnities 2,467.23 9,734.55 - 9,734.55 32,218.00 22,483.45 30.21% 439300 - Grants & Subsidies - 715,000.00 - 715,000.00 715,000.00 - 100.00% Total Other Services & Charges 41,062.26 903,317.74 143,865.42 1,047,183.16 1,163,782.24 116,599.08 89.98% Total Services & Charges Expenditures 240,122.28 2,142,543.02 329,490.08 2,472,033.10 3,556,144.21 1,084,111.11 69.51% Capital Outlay Buildings 443001 - Building Improvements - 1,741.25 71,708.75 73,450.00 74,000.00 550.00 99.26% Total Buildings - 1,741.25 71,708.75 73,450.00 74,000.00 550.00 99.26% 444000 - Land Improvements 26,923.11 164,740.29 326,804.86 491,545.15 1,501,978.91 1,010,433.76 32.73% Machinery & Equipment 445000 - Motor Equipment - - 10,866.86 10,866.86 - (10,866.86) 0.00% 445003 - Park Equipment 13,972.50 13,972.50 10,527.50 24,500.00 400,000.00 375,500.00 6.13% Total Machinery & Equipment 13,972.50 13,972.50 21,394.36 35,366.86 400,000.00 364,633.14 8.84% Total Capital Expenditures 40,895.61 180,454.04 419,907.97 600,362.01 1,975,978.91 1,375,616.90 30.38% Other Uses 452002 - Allocations-Admin Cost 57,573.00 345,439.00 - 345,439.00 690,877.00 345,438.00 50.00% 452003 - Allocations-IT 54,596.00 327,573.00 - 327,573.00 655,149.00 327,576.00 50.00% 452004 - Allocations-Liability Insurance 18,500.00 110,988.00 - 110,988.00 221,988.00 111,000.00 50.00% 452008 - Allocations-Payroll Cost 6,680.00 40,076.00 - 40,076.00 80,156.00 40,080.00 50.00% 452009 - Allocations-Facilities Mgmt 1,654.00 9,921.00 - 9,921.00 19,845.00 9,924.00 49.99% Total Other Uses 139,003.00 833,997.00 - 833,997.00 1,668,015.00 834,018.00 50.00% Total Expenditures 1,240,872.32 7,669,399.36 874,727.65 8,544,127.01 16,623,897.47 8,079,770.46 51.40%