Loading...
HomeMy WebLinkAboutApr 22 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 - - 75,000.00 75,000.00 0.00% 347019 - Site Mowing - - 222,839.00 222,839.00 0.00% 347021 - Tree Maintenance 2,605.68 52,120.46 120,000.00 67,879.54 43.43% Total Culture & Recreation 2,605.68 52,120.46 417,839.00 365,718.54 12.47% Total Charges for Services 2,605.68 52,120.46 417,839.00 365,718.54 12.47% Miscellaneous Revenue 360000 - Miscellaneous - - 2,000.00 2,000.00 0.00% 360001 - Sale of Scrap Metal - 211.75 - (211.75) 0.00% 367000 - Donations from Private Sources - 7,867.50 - (7,867.50) 0.00% Total Miscellaneous Revenue - 8,079.25 2,000.00 (6,079.25) 403.96% Refunds & Reimbursements 380000 - Misc Reimbursements 48.29 123.06 - (123.06) 0.00% 380007 - Energy Rebates 808.98 808.98 - (808.98) 0.00% 381000 - Misc Reimbursements - 4,916.40 245,441.00 240,524.60 2.00% 396000 - Refunds 165.32 37,603.17 - (37,603.17) 0.00% Total Refunds & Reimbursements 1,022.59 43,451.61 245,441.00 201,989.39 17.70% Other Sources 393000 - Capital Lease Proceeds - - 269,000.00 269,000.00 0.00% Total Other Sources - - 269,000.00 269,000.00 0.00% Total Revenue 3,628.27 103,651.32 934,280.00 830,628.68 11.09% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenses Salaries & Wages 410001 - Salaried Wages 91,635.59 269,369.10 - 269,369.10 820,100.00 550,730.90 32.85% 410002 - Teamster Wages 154,142.69 484,346.25 - 484,346.25 1,284,700.00 800,353.75 37.70% 410003 - Permanent Part Time 27,026.34 74,878.80 - 74,878.80 205,000.00 130,121.20 36.53% 410004 - Extra & Overtime 7,973.63 31,799.00 - 31,799.00 56,300.00 24,501.00 56.48% 410005 - Seasonal & Interns 26,808.04 47,035.57 - 47,035.57 300,000.00 252,964.43 15.68% 410007 - Longevity Pay 1,450.00 3,945.83 - 3,945.83 7,450.00 3,504.17 52.96% 410014 - Contract Add Pays 604.92 604.92 - 604.92 - (604.92) 0.00% Total Salaries & Wages 309,641.21 911,979.47 - 911,979.47 2,673,550.00 1,761,570.53 34.11% Employee Benefits 411001 - FICA Regular 23,076.18 77,212.10 - 77,212.10 206,584.00 129,371.90 37.38% 411004 - PERF Regular 26,793.35 95,198.42 - 95,198.42 245,889.00 150,690.58 38.72% 411005 - PERF Union 1,821.48 6,747.03 - 6,747.03 20,541.00 13,793.97 32.85% 411007 - Unemployment Comp 436.96 1,170.36 - 1,170.36 3,472.00 2,301.64 33.71% 411008 - Health Insurance 48,512.56 195,470.70 - 195,470.70 582,882.00 387,411.30 33.54% 411009 - Life Insurance 460.00 1,830.00 - 1,830.00 5,160.00 3,330.00 35.47% 411014 - Parental Leave 895.16 2,763.69 - 2,763.69 7,594.00 4,830.31 36.39% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance 500.00 2,923.62 - 2,923.62 4,000.00 1,076.38 73.09% 411203 - Job Readiness Allow. - 14,450.00 - 14,450.00 15,750.00 1,300.00 91.75% 411206 - Cell Phone Allowance 440.00 1,760.00 - 1,760.00 5,940.00 4,180.00 29.63% Total Employee Benefits 102,935.69 400,725.92 - 400,725.92 1,099,012.00 698,286.08 36.46% Total Personnel Expenses 412,576.90 1,312,705.39 - 1,312,705.39 3,772,562.00 2,459,856.61 34.80% April 30, 2022 Supplies Expenses Office Supplies 421000 - General Office Supplies 388.71 1,547.33 - 1,547.33 5,000.00 3,452.67 30.95% Total Office Supplies 388.71 1,547.33 - 1,547.33 5,000.00 3,452.67 30.95% Operating Supplies 422000 - Other Operating Supplies 10,735.56 44,004.48 53,270.87 97,275.35 151,581.45 54,306.10 64.17% 422001 - C.S. Gasoline 16,851.17 62,190.83 - 62,190.83 165,000.00 102,809.17 37.69% 422003 - Gasoline - - 50.00 50.00 2,405.00 2,355.00 2.08% 422004 - Oil - 35.30 - 35.30 50.00 14.70 70.60% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 500.00 180.07 63.99% 422007 - Cleaning Supplies 12.57 15.25 - 15.25 50.00 34.75 30.50% 422008 - Medical/Safety Supplies 14.54 4,761.81 - 4,761.81 12,480.00 7,718.19 38.16% 422010 - Plants Chemicals Seed & Fertilizer 20,171.76 21,726.73 24,154.27 45,881.00 68,975.00 23,094.00 66.52% Total Operating Supplies 47,785.60 133,054.33 77,475.14 210,529.47 401,041.45 190,511.98 52.50% Repair & Maintenance Supplies 423000 - Other R&M Supplies 12,824.02 64,902.75 56,457.90 121,360.65 233,674.41 112,313.76 51.94% 423001 - Building Materials 1,514.14 25,701.12 - 25,701.12 90,000.00 64,298.88 28.56% 423006 - Small Tools & Equipment 1,489.82 7,488.54 300.07 7,788.61 25,573.00 17,784.39 30.46% 423009 - Repair Parts 11,078.88 24,233.35 683.63 24,916.98 79,729.03 54,812.05 31.25% Total Repair & Maintenance Supplies 26,906.86 122,325.76 57,441.60 179,767.36 428,976.44 249,209.08 41.91% Total Supplies Expenses 75,081.17 256,927.42 134,916.74 391,844.16 835,017.89 443,173.73 46.93% Services & Charges Expenses Professional Services 431000 - Other Professional Services 779.00 1,021.00 11,070.00 12,091.00 12,500.00 409.00 96.73% 431009 - Computer & Technology - 31.83 - 31.83 500.00 468.17 6.37% 431014 - Collection Costs 6.25 12.50 - 12.50 50.00 37.50 25.00% 431019 - Security Services - 15,557.60 - 15,557.60 16,218.00 660.40 95.93% Total Professional Services 785.25 16,622.93 11,070.00 27,692.93 29,268.00 1,575.07 94.62% Communication & Transportation 432003 - Travel 212.08 2,012.21 3,347.89 5,360.10 6,400.00 1,039.90 83.75% 432004 - Telecommunications - 844.84 2,867.41 3,712.25 8,997.41 5,285.16 41.26% Total Communication & Transportation 212.08 2,857.05 6,215.30 9,072.35 15,397.41 6,325.06 58.92% Printing & Advertising 433001 - Outside Printing Services - - 500.00 500.00 2,000.00 1,500.00 25.00% 433002 - Publication of Legal Notice - 495.60 529.40 1,025.00 2,000.00 975.00 51.25% Total Printing & Advertising - 495.60 1,029.40 1,525.00 4,000.00 2,475.00 38.13% Utilties 435001 - Electric 35,285.46 154,370.99 - 154,370.99 403,180.00 248,809.01 38.29% 435002 - Natural Gas 16,978.41 105,264.35 - 105,264.35 90,938.00 (14,326.35) 115.75% 435004 - Water 8,517.64 24,363.05 - 24,363.05 214,000.00 189,636.95 11.38% Total Utilities 60,781.51 283,998.39 - 283,998.39 708,118.00 424,119.61 40.11% Repairs & Maintenance 436000 - Other R&M 2,228.00 9,560.46 2,275.43 11,835.89 95,328.99 83,493.10 12.42% 436001 - Building R&M 15,287.07 55,648.89 96,146.72 151,795.61 181,994.82 30,199.21 83.41% 436003 - Auto Equip R&M 32,836.63 123,242.92 - 123,242.92 318,000.00 194,757.08 38.76% 436006 - Radio Equip R&M 622.00 3,033.59 - 3,033.59 2,500.00 (533.59) 121.34% 436011 - Exterminating 279.00 2,768.00 1,394.00 4,162.00 13,334.00 9,172.00 31.21% Total Repairs & Maintenance 51,252.70 194,253.86 99,816.15 294,070.01 611,157.81 317,087.80 48.12% Debt Service 438100 - Principal - - - - 51,161.00 51,161.00 0.00% 438200 - Interest - - - - 6,408.00 6,408.00 0.00% Total Debt Service - - - - 57,569.00 57,569.00 0.00% Other Charges & Services 439000 - Misc Charges & Svcs 119.73 43,772.31 148,645.11 192,417.42 581,561.50 389,144.08 33.09% 439002 - Licenses & Permits - 1,150.00 - 1,150.00 1,150.00 - 100.00% 439003 - Subscriptions - 125.00 - 125.00 1,220.00 1,095.00 10.25% 439004 - Dues & Memberships 120.00 120.00 - 120.00 2,375.00 2,255.00 5.05% 439006 - Education & Training - 6,143.00 2,075.00 8,218.00 11,000.00 2,782.00 74.71% 439009 - Trash Removal 1,852.78 12,048.51 16,740.29 28,788.80 32,420.75 3,631.95 88.80% 439012 - Uniform Services 2,051.22 5,602.30 - 5,602.30 4,200.00 (1,402.30) 133.39% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 4,143.73 83,961.12 167,460.40 251,421.52 648,927.25 397,505.73 38.74% Total Services & Charges Expenses 117,175.27 582,188.95 285,591.25 867,780.20 2,074,437.47 1,206,657.27 41.83% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - 10,866.95 - 10,866.95 10,866.86 (0.09) 100.00% 445003 - Park Equipment - - 108,002.34 108,002.34 386,027.50 278,025.16 27.98% 445100 - Lease Purchase/Motor Equip - - - - 269,000.00 269,000.00 0.00% Total Machinery & Equipment - 10,866.95 108,002.34 118,869.29 665,894.36 547,025.07 17.85% Total Capital Expenses - 10,866.95 108,002.34 118,869.29 665,894.36 547,025.07 17.85% Other Uses 452002 - Allocations-Admin Cost 31,642.25 126,569.00 - 126,569.00 379,707.00 253,138.00 33.33% 452003 - Allocations-IT 12,805.67 51,222.64 - 51,222.64 153,668.00 102,445.36 33.33% 452004 - Allocations-Liability Insurance 11,013.08 44,052.36 - 44,052.36 132,157.00 88,104.64 33.33% 452009 - Allocations-Facilities Mgmt 2,001.00 8,004.00 - 8,004.00 24,012.00 16,008.00 33.33% Total Other Uses 57,462.00 229,848.00 - 229,848.00 689,544.00 459,696.00 33.33% Total Expenses 662,295.34 2,392,536.71 528,510.33 2,921,047.04 8,037,455.72 5,116,408.68 36.34%