Loading...
HomeMy WebLinkAboutSept 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 5,000.00 45,000.00 75,000.00 30,000.00 40.00% 347019 - Site Mowing 19,968.00 95,078.40 95,000.00 (78.40) (0.08%) 347021 - Tree Maintenance 796.20 52,516.06 160,000.00 107,483.94 67.18% 347023 - Graffiti Removal - - 102,529.00 102,529.00 100.00% Total Culture & Recreation 25,764.20 192,594.46 432,529.00 239,934.54 55.47% Total Charges for Services 25,764.20 192,594.46 432,529.00 239,934.54 55.47% Miscellaneous Revenue 360000 - Miscellaneous 66.24 2,756.37 10,000.00 7,243.63 72.44% Total Miscellaneous Revenue 66.24 2,756.37 10,000.00 7,243.63 72.44% Refunds & Reimbursements 380000 - Misc Reimbursements 68,124.99 909.62 - (909.62) 0.00% 381000 - Misc Reimbursements - 1,055.99 1,056.00 0.01 0.00% Total Refunds & Reimbursements 68,124.99 1,965.61 1,056.00 (909.61) (86.14%) Other Sources 392000 - Gain/Loss on Sale of Asset 2,162.00 2,162.00 - (2,162.00) 0.00% 392005 - Sale of Non-Capital Assets 11,270.00 11,270.00 - (11,270.00) 0.00% Total Other Sources 13,432.00 13,432.00 - (13,432.00) 0.00% Total Revenue 107,387.43 210,748.44 443,585.00 232,836.56 52.49% 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,514.62 579,165.50 - 579,165.50 849,449.00 270,283.50 31.82% 410002 - Teamster Wages 106,697.50 1,012,462.48 - 1,012,462.48 1,340,141.00 327,678.52 24.45% 410003 - Permanent Part Time 26,264.38 268,527.80 - 268,527.80 290,000.00 21,472.20 7.40% 410004 - Extra & Overtime 5,179.79 48,851.79 - 48,851.79 56,300.00 7,448.21 13.23% 410005 - Seasonal & Interns 31,770.40 181,027.86 - 181,027.86 233,000.00 51,972.14 22.31% 410007 - Longevity Pay 700.00 5,550.00 - 5,550.00 7,450.00 1,900.00 25.50% Total Salaries & Wages 229,126.69 2,095,585.43 - 2,095,585.43 2,776,340.00 680,754.57 24.52% Employee Benefits 411001 - FICA Regular 16,801.63 155,529.43 - 155,529.43 214,256.00 58,726.57 27.41% 411004 - PERF Regular 18,699.51 180,772.79 - 180,772.79 255,106.00 74,333.21 29.14% 411005 - PERF Union 1,312.87 12,787.18 - 12,787.18 21,335.00 8,547.82 40.06% 411007 - Unemployment Comp 17.28 164.91 - 164.91 225.00 60.09 26.71% 411008 - Health Insurance 48,834.62 430,470.07 - 430,470.07 545,689.00 115,218.93 21.11% 411009 - Life Insurance 480.02 4,245.18 - 4,245.18 5,640.00 1,394.82 24.73% 411014 - Parental Leave 598.26 5,754.35 - 5,754.35 7,887.00 2,132.65 27.04% 411200 - Clothing Allowance - 123.04 - 123.04 200.00 76.96 38.48% 411201 - Tool Allowance 196.86 762.65 427.61 1,190.26 4,228.00 3,037.74 71.85% 411203 - Job Readiness Allow. - 13,918.75 - 13,918.75 14,450.00 531.25 3.68% 411206 - Cell Phone Allowance 495.00 4,675.00 - 4,675.00 5,940.00 1,265.00 21.30% Total Employee Benefits 87,436.05 809,203.35 427.61 809,630.96 1,074,956.00 265,325.04 24.68% Total Personnel Expenditures 316,562.74 2,904,788.78 427.61 2,905,216.39 3,851,296.00 946,079.61 24.57% September 30, 2020 Supplies Expenditures Office Supplies 421000 - Other Office Supplies 135.48 400.25 70.00 470.25 500.00 29.75 5.95% 421002 - Stationary & Printing - - - - 5,000.00 5,000.00 100.00% Total Office Supplies 135.48 400.25 70.00 470.25 5,500.00 5,029.75 91.45% Operating Supplies 422000 - Other Operating Supplies 9,452.49 124,357.73 36,155.83 160,513.56 172,931.00 12,417.44 7.18% 422001 - C.S. Gasoline 9,385.06 86,078.93 - 86,078.93 165,000.00 78,921.07 47.83% 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 63.28 5,806.61 113.84 5,920.45 6,573.00 652.55 9.93% 422010 - Plants Chemicals Seed & Fertilizer 6,020.25 39,104.65 9,575.45 48,680.10 75,990.00 27,309.90 35.94% Total Operating Supplies 24,921.08 267,859.50 45,845.12 313,704.62 446,790.00 133,085.38 29.79% Repair & Maintenance Supplies 423000 - Other R&M Supplies 16,757.16 46,952.51 73,066.80 120,019.31 156,429.00 36,409.69 23.28% 423001 - Building Materials 391.29 54,329.35 5,456.32 59,785.67 89,868.00 30,082.33 33.47% 423006 - Small Tools & Equipment 108.58 16,248.56 99.99 16,348.55 30,053.00 13,704.45 45.60% 423009 - Repair Parts 1,079.97 43,213.04 9,229.81 52,442.85 65,179.00 12,736.15 19.54% Total Repair & Maintenance Supplies 18,337.00 160,743.46 87,852.92 248,596.38 341,529.00 92,932.62 27.21% Total Supplies Expenditures 43,393.56 429,003.21 133,768.04 562,771.25 793,819.00 231,047.75 29.11% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 1,544.00 2,465.86 976.34 3,442.20 1,000.00 (2,442.20) (244.22%) 431009 - Computer & Technology - 403.44 - 403.44 500.00 96.56 19.31% 431014 - Collection Costs - - 75.00 75.00 500.00 425.00 85.00% Total Professional Services 1,544.00 2,869.30 1,051.34 3,920.64 2,000.00 (1,920.64) (96.03%) 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 - 148.32 89.00 237.32 1,733.00 1,495.68 86.31% 433002 - Publication of Legal Notice - 277.97 1,871.52 2,149.49 3,000.00 850.51 28.35% Total Printing & Advertising - 426.29 1,960.52 2,386.81 4,733.00 2,346.19 49.57% Utilties 435001 - Electric 1,060.30 338,304.46 - 338,304.46 424,093.00 85,788.54 20.23% 435002 - Natural Gas 55.88 61,961.66 - 61,961.66 100,556.00 38,594.34 38.38% 435004 - Water 37,135.59 156,049.11 41,950.37 197,999.48 198,000.00 0.52 0.00% Total Utilities 38,251.77 556,315.23 41,950.37 598,265.60 722,649.00 124,383.40 17.21% Repairs & Maintenance 436000 - Other R&M 6,141.58 64,150.34 15,139.24 79,289.58 67,308.00 (11,981.58) (17.80%) 436001 - Building R&M 4,412.30 43,385.51 6,970.18 50,355.69 87,284.00 36,928.31 42.31% 436002 - Office Equip R&M - - - - 8,500.00 8,500.00 100.00% 436003 - Auto Equip R&M 26,413.36 297,100.50 - 297,100.50 240,000.00 (57,100.50) (23.79%) 436005 - Other Equip R&M - 999.80 - 999.80 6,710.00 5,710.20 85.10% 436006 - Radio Equip R&M 1,558.51 8,891.32 - 8,891.32 16,500.00 7,608.68 46.11% 436011 - Exterminating 532.50 2,742.50 3,658.50 6,401.00 7,500.00 1,099.00 14.65% Total Repairs & Maintenance 39,058.25 417,269.97 25,767.92 443,037.89 433,802.00 (9,235.89) (2.13%) Debt Service 438100 - Principal 493.62 156,612.72 - 156,612.72 297,875.00 141,262.28 47.42% 438200 - Interest 11.94 4,082.31 - 4,082.31 11,978.00 7,895.69 65.92% Total Debt Service 505.56 160,695.03 - 160,695.03 309,853.00 149,157.97 48.14% Other Charges & Services 439000 - Misc Charges & Svcs 19,137.83 257,763.13 101,182.61 358,945.74 359,037.00 91.26 0.03% 439001 - Other Contractual Services 277.40 1,325.82 3,709.46 5,035.28 - (5,035.28) 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 525.00 6,438.99 - 6,438.99 15,075.00 8,636.01 57.29% 439009 - Trash Removal 1,014.10 15,764.57 6,587.67 22,352.24 32,973.00 10,620.76 32.21% Total Other Services & Charges 20,954.33 281,618.49 111,479.74 393,098.23 409,705.00 16,606.77 4.05% Total Services & Charges Expenditures 100,313.91 1,421,453.02 182,209.89 1,603,662.91 1,892,492.00 288,829.09 15.26% 444000 - Land Improvements Other Uses 452002 - Allocations-Admin Cost 30,041.00 270,367.00 - 270,367.00 360,490.00 90,123.00 25.00% 452009 - Allocations-Facilities Mgmt 1,195.00 10,757.00 - 10,757.00 14,342.00 3,585.00 25.00% Total Other Uses 31,236.00 281,124.00 - 281,124.00 374,832.00 93,708.00 25.00% Total Expenditures 491,506.21 5,036,369.01 316,405.54 5,352,774.55 6,912,439.00 1,559,664.45 22.56%