Loading...
HomeMy WebLinkAboutNov 20 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 - 45,000.00 75,000.00 30,000.00 40.00% 347019 - Site Mowing 9,331.20 118,310.40 95,000.00 (23,310.40) (24.54%) 347021 - Tree Maintenance 708.49 152,006.13 160,000.00 7,993.87 5.00% 347023 - Graffiti Removal - - 102,529.00 102,529.00 100.00% Total Culture & Recreation 10,039.69 315,316.53 432,529.00 117,212.47 27.10% Total Charges for Services 10,039.69 315,316.53 432,529.00 117,212.47 27.10% Miscellaneous Revenue 360000 - Miscellaneous 31.07 2,856.71 10,000.00 7,143.29 71.43% 367000 - Donations from Private Sources - 4,000.00 - (4,000.00) 0.00% Total Miscellaneous Revenue 31.07 6,856.71 10,000.00 3,143.29 31.43% Refunds & Reimbursements 380000 - Misc Reimbursements - 3,823.12 - (3,823.12) 0.00% 381000 - Misc Reimbursements - 1,055.99 1,056.00 0.01 0.00% Total Refunds & Reimbursements - 4,879.11 1,056.00 (3,823.11) (362.04%) Other Sources 392000 - Gain/Loss on Sale of Asset - 2,162.00 2,162.00 - 0.00% 392005 - Sale of Non-Capital Assets - 11,270.00 11,270.00 - 0.00% Total Other Sources - 13,432.00 13,432.00 - 0.00% Total Revenue 10,070.76 340,484.35 457,017.00 116,532.65 25.50% 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,485.81 725,516.38 - 725,516.38 799,449.00 73,932.62 9.25% 410002 - Teamster Wages 108,498.68 1,279,137.78 - 1,279,137.78 1,340,141.00 61,003.22 4.55% 410003 - Permanent Part Time 26,028.51 333,883.80 - 333,883.80 290,000.00 (43,883.80) (15.13%) 410004 - Extra & Overtime 3,604.54 58,106.27 - 58,106.27 71,300.00 13,193.73 18.50% 410005 - Seasonal & Interns 14,246.37 235,801.89 - 235,801.89 233,000.00 (2,801.89) (1.20%) 410007 - Longevity Pay 350.00 6,850.00 - 6,850.00 7,450.00 600.00 8.05% Total Salaries & Wages 211,213.91 2,639,296.12 - 2,639,296.12 2,741,340.00 102,043.88 3.72% Employee Benefits 411001 - FICA Regular 15,398.66 195,944.55 - 195,944.55 214,756.00 18,811.45 8.76% 411004 - PERF Regular 18,673.66 227,492.26 - 227,492.26 254,336.00 26,843.74 10.55% 411005 - PERF Union 1,305.63 16,046.95 - 16,046.95 21,335.00 5,288.05 24.79% 411007 - Unemployment Comp 17.14 207.29 - 207.29 225.00 17.71 7.87% 411008 - Health Insurance 48,917.96 528,157.65 - 528,157.65 580,689.00 52,531.35 9.05% 411009 - Life Insurance 475.02 5,200.22 - 5,200.22 5,690.00 489.78 8.61% 411014 - Parental Leave 597.11 7,235.49 - 7,235.49 7,887.00 651.51 8.26% 411200 - Clothing Allowance - 123.04 - 123.04 200.00 76.96 38.48% 411201 - Tool Allowance 1,591.07 3,345.42 827.61 4,173.03 4,228.00 54.97 1.30% 411203 - Job Readiness Allow. - 13,918.75 - 13,918.75 14,450.00 531.25 3.68% 411206 - Cell Phone Allowance 495.00 5,665.00 - 5,665.00 6,160.00 495.00 8.04% Total Employee Benefits 87,471.25 1,003,336.62 827.61 1,004,164.23 1,109,956.00 105,791.77 9.53% Total Personnel Expenditures 298,685.16 3,642,632.74 827.61 3,643,460.35 3,851,296.00 207,835.65 5.40% November 30, 2020 Supplies Expenditures Office Supplies 421000 - Other Office Supplies 281.78 682.03 70.00 752.03 500.00 (252.03) (50.41%) 421002 - Stationary & Printing - - 3,001.77 3,001.77 5,000.00 1,998.23 39.96% Total Office Supplies 281.78 682.03 3,071.77 3,753.80 5,500.00 1,746.20 31.75% Operating Supplies 422000 - Other Operating Supplies 11,272.20 147,497.75 37,360.84 184,858.59 172,931.00 (11,927.59) (6.90%) 422001 - C.S. Gasoline 8,468.20 104,135.60 - 104,135.60 165,000.00 60,864.40 36.89% 422003 - Gasoline - - - - 3,196.00 3,196.00 100.00% 422004 - Oil - 957.85 - 957.85 1,000.00 42.15 4.22% 422005 - Uniforms - 11,360.45 - 11,360.45 22,000.00 10,639.55 48.36% 422007 - Cleaning Supplies - 193.28 - 193.28 100.00 (93.28) (93.28%) 422008 - Medical/Safety Supplies 1,061.99 7,096.40 113.84 7,210.24 6,573.00 (637.24) (9.69%) 422010 - Plants Chemicals Seed & Fertilizer 14,470.90 55,816.72 4,902.83 60,719.55 75,990.00 15,270.45 20.10% Total Operating Supplies 35,273.29 327,058.05 42,377.51 369,435.56 446,790.00 77,354.44 17.31% Repair & Maintenance Supplies 423000 - Other R&M Supplies 1,910.76 54,054.84 69,289.09 123,343.93 156,429.00 33,085.07 21.15% 423001 - Building Materials 2,939.36 58,650.73 4,958.78 63,609.51 89,868.00 26,258.49 29.22% 423006 - Small Tools & Equipment 2,389.04 19,333.06 1,075.86 20,408.92 30,053.00 9,644.08 32.09% 423009 - Repair Parts 6,237.88 53,656.13 5,751.06 59,407.19 65,179.00 5,771.81 8.86% Total Repair & Maintenance Supplies 13,477.04 185,694.76 81,074.79 266,769.55 341,529.00 74,759.45 21.89% Total Supplies Expenditures 49,032.11 513,434.84 126,524.07 639,958.91 793,819.00 153,860.09 19.38% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 4,843.60 7,863.80 4,253.54 12,117.34 1,000.00 (11,117.34) (1111.73%) 431009 - Computer & Technology - 403.44 - 403.44 500.00 96.56 19.31% 431014 - Collection Costs - 75.00 50.50 125.50 500.00 374.50 74.90% Total Professional Services 4,843.60 8,342.24 4,304.04 12,646.28 2,000.00 (10,646.28) (532.31%) Communication & Transportation 432000 - Other Communication/Transp. - 24.00 - 24.00 - (24.00) 0.00% 432002 - Mailing - 8.40 - 8.40 500.00 491.60 98.32% 432003 - Travel - 842.64 - 842.64 2,250.00 1,407.36 62.55% 432004 - Telecommunications - 1,383.67 - 1,383.67 7,000.00 5,616.33 80.23% Total Communication & Transportation - 2,258.71 - 2,258.71 9,750.00 7,491.29 76.83% Printing & Advertising 433001 - Outside Printing Services - 237.32 - 237.32 1,733.00 1,495.68 86.31% 433002 - Publication of Legal Notice 56.32 334.29 1,990.04 2,324.33 3,000.00 675.67 22.52% Total Printing & Advertising 56.32 571.61 1,990.04 2,561.65 4,733.00 2,171.35 45.88% Utilties 435001 - Electric 23,157.14 378,941.26 - 378,941.26 424,093.00 45,151.74 10.65% 435002 - Natural Gas 4,646.40 66,818.29 - 66,818.29 100,556.00 33,737.71 33.55% 435004 - Water 17,773.21 205,485.19 (66,542.65) 138,942.54 198,000.00 59,057.46 29.83% Total Utilities 45,576.75 651,244.74 (66,542.65) 584,702.09 722,649.00 137,946.91 19.09% Repairs & Maintenance 436000 - Other R&M 16,801.80 80,952.14 26,358.24 107,310.38 67,308.00 (40,002.38) (59.43%) 436001 - Building R&M 1,816.64 49,768.59 3,462.74 53,231.33 87,284.00 34,052.67 39.01% 436002 - Office Equip R&M - - - - 8,500.00 8,500.00 100.00% 436003 - Auto Equip R&M 14,707.20 341,837.19 356.00 342,193.19 240,000.00 (102,193.19) (42.58%) 436005 - Other Equip R&M - 999.80 - 999.80 6,710.00 5,710.20 85.10% 436006 - Radio Equip R&M 2,547.85 13,417.91 1,996.00 15,413.91 16,500.00 1,086.09 6.58% 436011 - Exterminating 572.50 3,847.50 2,553.50 6,401.00 7,500.00 1,099.00 14.65% Total Repairs & Maintenance 36,445.99 490,823.13 34,726.48 525,549.61 433,802.00 (91,747.61) (21.15%) Debt Service 438100 - Principal 111.10 261,329.01 - 261,329.01 297,875.00 36,545.99 12.27% 438200 - Interest 3.63 6,426.95 - 6,426.95 11,978.00 5,551.05 46.34% Total Debt Service 114.73 267,755.96 - 267,755.96 309,853.00 42,097.04 13.59% Other Charges & Services 439000 - Misc Charges & Svcs 45,238.25 326,543.69 89,754.45 416,298.14 359,037.00 (57,261.14) (15.95%) 439001 - Other Contractual Services 306.47 1,911.82 3,122.86 5,034.68 - (5,034.68) 0.00% 439002 - Licenses & Permits - 131.98 - 131.98 - (131.98) 0.00% 439003 - Subscriptions - 65.00 - 65.00 745.00 680.00 91.28% 439004 - Dues & Memberships - 129.00 - 129.00 1,875.00 1,746.00 93.12% 439006 - Education & Training 1,001.00 7,994.99 1,100.00 9,094.99 15,075.00 5,980.01 39.67% 439009 - Trash Removal 335.92 16,772.02 5,580.22 22,352.24 32,973.00 10,620.76 32.21% Total Other Services & Charges 46,881.64 353,548.50 99,557.53 453,106.03 409,705.00 (43,401.03) (10.59%) Total Services & Charges Expenditures 133,919.03 1,774,544.89 74,035.44 1,848,580.33 1,892,492.00 43,911.67 2.32% 444000 - Land Improvements - 120,892.89 - 120,892.89 120,893.00 0.11 0.00% Other Uses 452002 - Allocations-Admin Cost 30,041.00 330,449.00 - 330,449.00 360,490.00 30,041.00 8.33% 452009 - Allocations-Facilities Mgmt 1,195.00 13,147.00 - 13,147.00 14,342.00 1,195.00 8.33% Total Other Uses 31,236.00 343,596.00 - 343,596.00 374,832.00 31,236.00 8.33% Total Expenditures 512,872.30 6,274,208.47 201,387.12 6,475,595.59 6,912,439.00 436,843.41 6.32%