Loading...
HomeMy WebLinkAboutMay 20 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 42% 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 - - 9,340,797.00 9,340,797.00 100.00% Total Property Taxes - - 9,340,797.00 9,340,797.00 100.00% Total Taxes - - 9,340,797.00 9,340,797.00 100.00% Intergovernmental Revenue State Shared Revenue 335002 - Vehicle/Aircraft Excise - - 700,000.00 700,000.00 100.00% 335007 - Commercial Vehicle Excise - - 145,000.00 145,000.00 100.00% Total State Shared Revenue - - 845,000.00 845,000.00 100.00% Other Intergovernmental Revenue 337001 - Local Govt Grants - 648,098.00 - (648,098.00) 0.00% Total Other Intergovernmental - 648,098.00 - (648,098.00) 0.00% Total Intergovernmental Revenue - 648,098.00 845,000.00 196,902.00 23.30% Charges for Services Culture & Recreation 347001 - Swimming Pool - - 46,000.00 46,000.00 100.00% 347002 - Picnic Site Rental - 210.00 3,300.00 3,090.00 93.64% 347003 - Golf Season Pass - 124,571.15 165,000.00 40,428.85 24.50% 347004 - Golf Green Fees - 8,109.75 550,000.00 541,890.25 98.53% 347005 - Golf Cart Rentals - 3,528.55 330,000.00 326,471.45 98.93% 347006 - Golf Pro Shop Retail - 719.33 60,000.00 59,280.67 98.80% 347007 - Golf Driving Range - - 20,000.00 20,000.00 100.00% 347008 - Golf Gift Certificate - 260.00 5,500.00 5,240.00 95.27% 347009 - Golf Outings - - 5,000.00 5,000.00 100.00% 347011 - Special Events 1,700.00 247,786.18 941,465.00 693,678.82 73.68% 347012 - Food Sales - 361.70 102,000.00 101,638.30 99.65% 347013 - Nonalcoholic Beverage - 555.49 68,000.00 67,444.51 99.18% 347014 - Alcoholic Beverage Sales - 2,292.99 90,000.00 87,707.01 97.45% 347015 - Lease of Stadium 15,000.00 15,000.00 75,000.00 60,000.00 80.00% 347016 - East Race Waterway - - 50,000.00 50,000.00 100.00% 347017 - Ice Skating 90.00 148,838.02 123,500.00 (25,338.02) (20.52%) 347018 - Skate Rental - - 2,000.00 2,000.00 100.00% 347019 - Site Mowing - - 95,000.00 95,000.00 100.00% 347021 - Tree Maintenance 6,077.00 42,770.00 160,000.00 117,230.00 73.27% 347023 - Graffiti Removal - - 102,529.00 102,529.00 100.00% 347024 - Sponsorship Income - 4,000.00 - (4,000.00) 0.00% 347040 - Pavilion Rental - 170.00 17,500.00 17,330.00 99.03% 347041 - Picnic Shelter - 4,600.00 25,000.00 20,400.00 81.60% 347999 - Cash Over/Short - 181.48 - (181.48) 0.00% Total Culture & Recreation 22,867.00 603,954.64 3,036,794.00 2,432,839.36 80.11% Total Charges for Services 22,867.00 603,954.64 3,036,794.00 2,432,839.36 80.11% Miscellaneous Revenue 360000 - Miscellaneous 148.66 9,360.48 22,500.00 13,139.52 58.40% 361000 - Interest Earnings 104.84 (2,617.92) 87,861.00 90,478.92 102.98% 362000 - Rental of Property - 16,247.25 60,000.00 43,752.75 72.92% 367000 - Donations from Private Sources - 520,750.00 1,215,000.00 694,250.00 57.14% Total Miscellaneous Revenue 253.50 543,739.81 1,385,361.00 841,621.19 60.75% Refunds & Reimbursements 380000 - Misc Reimbursements 23,998.83 72,335.15 - (72,335.15) 0.00% 380007 - Energy Rebates - 3,040.05 - (3,040.05) 0.00% Total Refunds & Reimbursements 23,998.83 75,375.20 - (75,375.20) 0.00% May 31, 2020 Other Sources 391000 - Interfund Transfers In 66,667.00 333,331.00 800,000.00 466,669.00 58.33% Total Other Sources 66,667.00 333,331.00 800,000.00 466,669.00 58.33% Total Revenue 113,786.33 2,204,498.65 15,407,952.00 13,203,453.35 85.69% EXPENDITURES Current YTD Total YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenditures Salaries & Wages 410001 - Salaried Wages 350,886.80 1,306,468.77 - 1,306,468.77 3,174,690.00 1,868,221.23 58.85% 410002 - Teamster Wages 170,953.90 612,027.03 - 612,027.03 1,423,153.00 811,125.97 56.99% 410003 - Permanent Part Time 72,506.05 346,104.13 - 346,104.13 715,176.00 369,071.87 51.61% 410004 - Extra & Overtime 778.23 21,666.12 - 21,666.12 59,850.00 38,183.88 63.80% 410005 - Seasonal & Interns 27,189.32 57,616.53 - 57,616.53 865,665.00 808,048.47 93.34% 410007 - Longevity Pay 500.00 4,300.00 - 4,300.00 8,050.00 3,750.00 46.58% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 100.00% Total Salaries & Wages 622,814.30 2,348,182.58 - 2,348,182.58 6,247,784.00 3,899,601.42 62.42% Employee Benefits 411001 - FICA Regular 46,451.56 174,741.53 - 174,741.53 481,017.00 306,275.47 63.67% 411004 - PERF Regular 58,016.12 214,710.41 - 214,710.41 529,678.00 314,967.59 59.46% 411005 - PERF Union 2,091.17 7,951.08 - 7,951.08 22,652.00 14,700.92 64.90% 411007 - Unemployment Comp 52.36 194.46 - 194.46 511.00 316.54 61.95% 411008 - Health Insurance 91,702.39 455,355.35 - 455,355.35 1,114,598.00 659,242.65 59.15% 411009 - Life Insurance 935.04 4,655.20 - 4,655.20 11,520.00 6,864.80 59.59% 411014 - Parental Leave 1,830.51 6,803.49 - 6,803.49 16,408.00 9,604.51 58.54% 411200 - Clothing Allowance - - - - - - 0.00% 411201 - Tool Allowance - 749.47 - 749.47 5,228.00 4,478.53 85.66% 411203 - Job Readiness Allow. - 14,768.75 - 14,768.75 15,300.00 531.25 3.47% 411204 - Auto Allowance 266.66 1,333.30 - 1,333.30 3,200.00 1,866.70 58.33% 411206 - Cell Phone Allowance 1,375.00 7,095.00 - 7,095.00 17,820.00 10,725.00 60.19% Total Employee Benefits 202,720.81 888,358.04 - 888,358.04 2,217,932.00 1,329,573.96 59.95% Total Personnel Expenditures 825,535.11 3,236,540.62 - 3,236,540.62 8,465,716.00 5,229,175.38 61.77% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 456.01 456.01 - 456.01 - (456.01) 0.00% 421002 - Stationary & Printing 175.75 3,042.90 - 3,042.90 22,762.00 19,719.10 86.63% Total Office Supplies 631.76 3,498.91 - 3,498.91 22,762.00 19,263.09 84.63% Operating Supplies 422000 - Other Operating Supplies 46,878.32 121,961.31 - 121,961.31 266,037.00 144,075.69 54.16% 422001 - C.S. Gasoline 6,244.20 38,987.34 - 38,987.34 165,000.00 126,012.66 76.37% 422003 - Gasoline - 1,632.26 - 1,632.26 8,196.00 6,563.74 80.08% 422005 - Uniforms - 11,545.54 - 11,545.54 33,310.00 21,764.46 65.34% 422007 - Cleaning Supplies 97.77 97.77 - 97.77 - (97.77) 0.00% 422008 - Medical/Safety Supplies 1,792.88 3,122.11 - 3,122.11 11,663.00 8,540.89 73.23% 422009 - Recreation Supplies 14,487.07 78,328.93 - 78,328.93 271,057.00 192,728.07 71.10% 422010 - Plants Chemicals Seed & Fertilizer 14,402.21 78,954.94 - 78,954.94 154,650.00 75,695.06 48.95% 422013 - Promotional Supplies 91.84 91.84 - 91.84 - (91.84) 0.00% 422014 - Concessions Inventory - 8,296.59 - 8,296.59 111,700.00 103,403.41 92.57% 422016 - Inventory For Sale - 5,671.26 - 5,671.26 58,858.00 53,186.74 90.36% Total Operating Supplies 83,994.29 348,689.89 - 348,689.89 1,080,471.00 731,781.11 67.73% Repair & Maintenance Supplies 423000 - Other R&M Supplies 1,625.33 29,564.60 - 29,564.60 227,136.00 197,571.40 86.98% 423001 - Building Materials 4,337.87 30,696.89 - 30,696.89 69,868.00 39,171.11 56.06% 423006 - Small Tools & Equipment 3,578.00 10,170.59 - 10,170.59 30,053.00 19,882.41 66.16% 423009 - Repair Parts 6,442.68 25,876.91 - 25,876.91 65,179.00 39,302.09 60.30% Total Repair & Maintenance Supplies 15,983.88 96,308.99 - 96,308.99 392,236.00 295,927.01 75.45% Total Supplies Expenditures 100,609.93 448,497.79 - 448,497.79 1,495,469.00 1,046,971.21 70.01% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 30,428.30 136,442.72 - 136,442.72 288,044.00 151,601.28 52.63% 431009 - Computer & Technology 78.87 78.87 - 78.87 - (78.87) 0.00% 431014 - Collection Costs - - - - 500.00 500.00 100.00% 431019 - Security Services - 219.56 - 219.56 5,160.00 4,940.44 95.74% Total Professional Services 30,507.17 136,741.15 - 136,741.15 293,704.00 156,962.85 53.44% Communication & Transportation 432000 - Other Communication/Transp. - - - - - - 432002 - Mailing 21.96 1,511.68 - 1,511.68 5,375.00 3,863.32 71.88% 432003 - Travel - 1,987.15 - 1,987.15 28,500.00 26,512.85 93.03% 432004 - Telecommunications - 1,705.31 - 1,705.31 10,200.00 8,494.69 83.28% 432005 - Mileage Reimb - 94.88 - 94.88 6,422.00 6,327.12 98.52% Total Communication & Transportation 21.96 5,299.02 - 5,299.02 50,497.00 45,197.98 89.51% Printing & Advertising 433001 - Outside Printing Services - 5,210.75 - 5,210.75 32,229.00 27,018.25 83.83% 433002 - Publication of Legal Notice - 186.00 - 186.00 2,000.00 1,814.00 90.70% 433003 - Promotional 13,121.95 39,943.00 - 39,943.00 232,979.00 193,036.00 82.86% Total Printing & Advertising 13,121.95 45,339.75 - 45,339.75 267,208.00 221,868.25 83.03% Utilties 435001 - Electric 8,070.58 197,748.40 - 197,748.40 379,834.00 182,085.60 47.94% 435002 - Natural Gas 4,154.35 83,786.40 - 83,786.40 96,297.00 12,510.60 12.99% 435004 - Water 5,929.93 34,387.64 - 34,387.64 198,000.00 163,612.36 82.63% Total Utilities 18,154.86 315,922.44 - 315,922.44 674,131.00 358,208.56 53.14% Repairs & Maintenance 436000 - Other R&M 2,105.00 46,044.00 - 46,044.00 67,308.00 21,264.00 31.59% 436001 - Building R&M 10,186.67 20,986.80 - 20,986.80 99,284.00 78,297.20 78.86% 436002 - Office Equip R&M - - - - 8,500.00 8,500.00 100.00% 436003 - Auto Equip R&M 17,983.87 170,026.68 - 170,026.68 240,000.00 69,973.32 29.16% 436005 - Other Equip R&M - - - - 7,010.00 7,010.00 100.00% 436006 - Radio Equip R&M 741.44 3,743.67 - 3,743.67 16,500.00 12,756.33 77.31% 436011 - Exterminating - - - - 7,500.00 7,500.00 100.00% Total Repairs & Maintenance 31,016.98 240,801.15 - 240,801.15 446,102.00 205,300.85 46.02% Rentals 437006 - Recreation Space Rental - 400.00 - 400.00 1,200.00 800.00 66.67% Total Rentals - Debt Service 438100 - Principal 121,337.95 299,788.40 - 299,788.40 528,634.00 228,845.60 43.29% 438200 - Interest 17,668.94 33,328.21 - 33,328.21 47,472.00 14,143.79 29.79% 438300 - Paying Agent Fees - 4,400.00 - 4,400.00 4,400.00 - 0.00% Total Debt Service 139,006.89 337,516.61 - 337,516.61 580,506.00 242,989.39 41.86% Other Charges & Services 439000 - Misc Charges & Svcs 52,782.42 233,503.23 - 233,503.23 563,170.00 329,666.77 58.54% 439001 - Other Contractual Services 466.50 466.50 - 466.50 - (466.50) 0.00% 439003 - Subscriptions 2,237.00 2,564.00 - 2,564.00 1,745.00 (819.00) (46.93%) 439004 - Dues & Memberships 129.00 4,678.75 - 4,678.75 20,335.00 15,656.25 76.99% 439005 - Bank & Credit Card Fees (3,066.76) 3,606.47 - 3,606.47 8,000.00 4,393.53 54.92% 439006 - Education & Training 2,565.00 6,665.97 - 6,665.97 36,199.00 29,533.03 81.59% 439009 - Trash Removal - 12,680.40 - 12,680.40 41,873.00 29,192.60 69.72% 439100 - Refunds/Awards/Indemnities - 6,085.06 - 6,085.06 19,200.00 13,114.94 68.31% 439300 - Grants & Subsidies 350,000.00 715,000.00 - 715,000.00 715,000.00 - 0.00% 439999 - Bad Debt Expense - 4,637.12 - 4,637.12 4,100.00 (537.12) (13.10%) Total Other Services & Charges 405,113.16 989,887.50 - 989,887.50 1,409,622.00 419,734.50 29.78% Total Services & Charges Expenditures 636,942.97 2,071,507.62 - 2,071,507.62 3,721,770.00 1,650,262.38 44.34% Capital Outlay Buildings 443001 - Building Improvements - 72,105.79 - 72,105.79 72,106.00 0.21 0.00% Total Buildings - 72,105.79 - 72,105.79 72,106.00 0.21 0.00% 444000 - Land Improvements 10.00 740,951.64 - 740,951.64 950,895.00 209,943.36 22.08% Total Capital Expenditures - 72,105.79 - 72,105.79 72,106.00 0.21 0.00% Other Uses 452002 - Allocations-Admin Cost 54,385.00 271,911.00 - 271,911.00 652,606.00 380,695.00 58.33% 452003 - Allocations-IT 40,874.00 204,370.00 - 204,370.00 490,488.00 286,118.00 58.33% 452004 - Allocations-Liability Insurance 15,093.00 75,459.00 - 75,459.00 181,110.00 105,651.00 58.34% 452008 - Allocations-Payroll Cost 6,579.00 32,894.00 - 32,894.00 78,947.00 46,053.00 58.33% 452009 - Allocations-Facilities Mgmt 1,505.00 7,534.00 - 7,534.00 18,069.00 10,535.00 58.30% Total Other Uses 118,436.00 592,168.00 - 592,168.00 1,421,220.00 829,052.00 58.33% Total Expenditures 1,681,534.01 7,162,171.46 - 7,162,171.46 16,128,376.00 8,966,204.54 55.59%