Loading...
HomeMy WebLinkAboutDec 21 Fin 3South Bend Venues, Parks and Arts Parks Maintenance: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected Charges for Services Culture & Recreation 347015 - Lease of Stadium - 100,000.00 75,000.00 (25,000.00) 133.33% 347019 - Site Mowing - 1,227.59 1,228.00 0.41 99.97% 347021 - Tree Maintenance 31,076.82 130,692.60 100,000.00 (30,692.60) 130.69% 347023 - Graffiti Removal - 1,482.15 2,529.00 1,046.85 58.61% Total Culture & Recreation 31,076.82 233,402.34 178,757.00 (54,645.34) 130.57% Total Charges for Services 31,076.82 233,402.34 178,757.00 (54,645.34) 130.57% Miscellaneous Revenue 360001 - Sale of Scrap Metal 31.60 1,177.16 1,177.00 (0.16) 100.01% 367000 - Donations from Private Sources - 26,190.00 26,190.00 - 100.00% Total Miscellaneous Revenue 31.60 27,367.16 27,367.00 (0.16) 100.00% Refunds & Reimbursements 380000 - Misc Reimbursements 6.42 241.40 241.00 (0.40) 100.17% 380007 - Energy Rebates - 962.27 962.00 (0.27) 100.03% 396000 - Refunds - 2,017.08 2,003.00 (14.08) 100.70% Total Refunds & Reimbursements 6.42 3,220.75 3,206.00 (14.75) 100.46% Other Sources 391000 - Interfund Transfers In 21,845.00 262,145.00 262,145.00 - 100.00% 392000 - Gain/Loss on Sale of Asset - 17,250.00 17,250.00 - 100.00% Total Other Sources 21,845.00 279,395.00 279,395.00 - 100.00% Total Revenue 52,959.84 543,385.25 488,725.00 (54,660.25) 111.18% 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 58,702.64 750,762.99 - 750,762.99 762,060.00 11,297.01 98.52% 410002 - Teamster Wages 103,890.04 1,360,983.95 - 1,360,983.95 1,389,331.00 28,347.05 97.96% 410003 - Permanent Part Time 22,193.13 285,964.37 - 285,964.37 288,771.00 2,806.63 99.03% 410004 - Extra & Overtime 4,356.29 99,174.48 - 99,174.48 112,552.00 13,377.52 88.11% 410005 - Seasonal & Interns 10,082.15 253,344.32 - 253,344.32 273,000.00 19,655.68 92.80% 410007 - Longevity Pay - 7,450.00 - 7,450.00 10,450.00 3,000.00 71.29% 410014 - Contract Add Pays - 955.98 - 955.98 4,000.00 3,044.02 23.90% Total Salaries & Wages 199,224.25 2,758,636.09 - 2,758,636.09 2,840,164.00 81,527.91 97.13% Employee Benefits 411001 - FICA Regular 15,180.95 206,810.32 - 206,810.32 212,405.00 5,594.68 97.37% 411004 - PERF Regular 18,086.36 244,819.55 - 244,819.55 248,645.00 3,825.45 98.46% 411005 - PERF Union 1,239.82 17,389.68 - 17,389.68 20,036.00 2,646.32 86.79% 411007 - Unemployment Comp 52.86 703.05 - 703.05 834.00 130.95 84.30% 411008 - Health Insurance 46,781.02 578,669.44 - 578,669.44 594,078.00 15,408.56 97.41% 411009 - Life Insurance 450.00 5,605.00 - 5,605.00 6,020.00 415.00 93.11% 411014 - Parental Leave 595.14 7,757.00 - 7,757.00 8,122.00 365.00 95.51% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance 476.60 4,171.19 - 4,171.19 4,600.00 428.81 90.68% 411203 - Job Readiness Allow. - 14,450.00 - 14,450.00 14,450.00 - 100.00% 411206 - Cell Phone Allowance 440.00 5,555.00 - 5,555.00 5,640.00 85.00 98.49% Total Employee Benefits 83,302.75 1,087,130.23 - 1,087,130.23 1,116,030.00 28,899.77 97.41% Total Personnel Expenditures 282,527.00 3,845,766.32 - 3,845,766.32 3,956,194.00 110,427.68 97.21% December 31, 2021 Supplies Expenditures Office Supplies 421000 - General Office Supplies - 696.72 - 696.72 697.00 0.28 99.96% 421002 - Stationary & Printing - 2,966.00 - 2,966.00 4,022.00 1,056.00 73.74% Total Office Supplies - 3,662.72 - 3,662.72 4,719.00 1,056.28 77.62% Operating Supplies 422000 - Other Operating Supplies 11,049.24 194,681.49 - 194,681.49 212,396.75 17,715.26 91.66% 422001 - C.S. Gasoline 10,254.70 158,540.07 - 158,540.07 158,586.00 45.93 99.97% 422003 - Gasoline 138.11 138.11 - 138.11 405.00 266.89 34.10% 422006 - Computer Supplies & Equipment 37.44 357.37 - 357.37 420.00 62.63 85.09% 422007 - Cleaning Supplies - 1,317.82 - 1,317.82 1,433.00 115.18 91.96% 422008 - Medical/Safety Supplies 937.75 19,623.17 - 19,623.17 21,207.19 1,584.02 92.53% 422010 - Plants Chemicals Seed & Fertilizer 8,424.00 48,663.06 - 48,663.06 53,161.00 4,497.94 91.54% 422013 - Promotional Supplies - 17.49 - 17.49 20.00 2.51 87.45% Total Operating Supplies 30,841.24 423,338.58 - 423,338.58 447,628.94 24,290.36 94.57% Repair & Maintenance Supplies 423000 - Other R&M Supplies 9,073.65 121,911.18 - 121,911.18 121,961.45 50.27 99.96% 423001 - Building Materials 2,036.48 42,141.85 - 42,141.85 44,105.51 1,963.66 95.55% 423006 - Small Tools & Equipment 1,750.56 31,317.36 - 31,317.36 32,567.00 1,249.64 96.16% 423009 - Repair Parts 3,133.86 57,864.86 - 57,864.86 66,493.27 8,628.41 87.02% Total Repair & Maintenance Supplies 15,994.55 253,235.25 - 253,235.25 265,127.23 11,891.98 95.51% Total Supplies Expenditures 46,835.79 680,236.55 - 680,236.55 717,475.17 37,238.62 94.81% Services & Charges Expenditures Professional Services 431000 - Other Professional Services - 6,120.10 - 6,120.10 8,183.00 2,062.90 74.79% 431001 - Legal Services - 195.00 - 195.00 195.00 - 100.00% 431009 - Computer & Technology - 243.96 - 243.96 300.00 56.04 81.32% 431014 - Collection Costs - 106.25 - 106.25 107.00 0.75 99.30% 431015 - Laboratory Water Testing - 160.00 - 160.00 160.00 - 100.00% 431019 - Security Services - 17,657.93 - 17,657.93 17,851.00 193.07 98.92% Total Professional Services - 24,483.24 - 24,483.24 26,796.00 2,312.76 91.37% Communication & Transportation 432002 - Mailing - 143.88 - 143.88 144.00 0.12 99.92% 432003 - Travel - - - - 106.00 106.00 0.00% 432004 - Telecommunications 87.72 1,832.59 - 1,832.59 2,180.59 348.00 84.04% Total Communication & Transportation 87.72 1,976.47 - 1,976.47 2,430.59 454.12 81.32% Printing & Advertising 433001 - Outside Printing Services - 89.00 - 89.00 500.00 411.00 17.80% 433002 - Publication of Legal Notice - 945.94 - 945.94 1,577.74 631.80 59.96% Total Printing & Advertising - 1,034.94 - 1,034.94 2,077.74 1,042.80 49.81% Utilties 435001 - Electric 26,578.24 427,322.69 - 427,322.69 474,359.00 47,036.31 90.08% 435002 - Natural Gas 22,372.94 141,148.90 - 141,148.90 145,290.00 4,141.10 97.15% 435004 - Water 7,422.29 281,827.87 - 281,827.87 329,074.00 47,246.13 85.64% Total Utilities 56,373.47 850,299.46 - 850,299.46 948,723.00 98,423.54 89.63% Repairs & Maintenance 436000 - Other R&M 16,064.40 52,792.52 - 52,792.52 85,186.13 32,393.61 61.97% 436001 - Building R&M 11,657.94 118,097.42 - 118,097.42 126,383.62 8,286.20 93.44% 436003 - Auto Equip R&M 27,929.66 410,887.32 - 410,887.32 410,981.00 93.68 99.98% 436005 - Other Equip R&M - 762.07 - 762.07 859.00 96.93 88.72% 436006 - Radio Equip R&M 528.00 13,536.82 - 13,536.82 13,772.00 235.18 98.29% 436011 - Exterminating 1,392.00 10,263.64 - 10,263.64 13,305.00 3,041.36 77.14% Total Repairs & Maintenance 57,572.00 606,339.79 - 606,339.79 650,486.75 44,146.96 93.21% Debt Service 438100 - Principal - 225,466.76 - 225,466.76 225,467.00 0.24 100.00% 438200 - Interest - 2,542.28 - 2,542.28 2,543.00 0.72 99.97% Total Debt Service - 228,009.04 - 228,009.04 228,010.00 0.96 100.00% Other Charges & Services 439000 - Misc Charges & Svcs 781.42 260,469.99 - 260,469.99 288,239.04 27,769.05 90.37% 439001 - Other Contractual Services 3,690.15 6,481.88 - 6,481.88 8,052.86 1,570.98 80.49% 439002 - Licenses & Permits 275.00 2,567.24 - 2,567.24 2,593.00 25.76 99.01% 439003 - Subscriptions - - - - 66.00 66.00 0.00% 439004 - Dues & Memberships - 125.00 - 125.00 375.00 250.00 33.33% 439006 - Education & Training 173.00 3,960.50 - 3,960.50 6,263.00 2,302.50 63.24% 439009 - Trash Removal 2,979.24 26,043.12 - 26,043.12 34,722.43 8,679.31 75.00% 439012 - Uniform Services 1,564.97 10,941.08 - 10,941.08 11,196.00 254.92 97.72% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 9,463.78 325,588.81 - 325,588.81 366,507.33 40,918.52 88.84% Total Services & Charges Expenditures 123,496.97 2,037,731.75 - 2,037,731.75 2,225,031.41 187,299.66 91.58% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - - - - 0.14 0.14 0.00% 445003 - Park Equipment - 13,972.50 - 13,972.50 13,972.50 - 100.00% Total Machinery & Equipment - 13,972.50 - 13,972.50 13,972.64 0.14 100.00% Total Capital Expenditures - 13,972.50 - 13,972.50 13,972.64 0.14 100.00% Other Uses 452002 - Allocations-Admin Cost 27,272.00 327,264.00 - 327,264.00 327,264.00 - 100.00% 452004 - Allocations-Liability Insurance 5,441.00 65,289.00 - 65,289.00 65,289.00 - 100.00% 452009 - Allocations-Facilities Mgmt 1,436.00 17,230.00 - 17,230.00 17,230.00 - 100.00% Total Other Uses 34,149.00 409,783.00 - 409,783.00 409,783.00 - 100.00% Total Expenditures 487,008.76 6,987,490.12 - 6,987,490.12 7,322,456.22 334,966.10 95.43%