Loading...
HomeMy WebLinkAboutDec 21 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 100% 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 4,565,875.66 10,271,000.12 10,271,000.00 (0.12) 100.00% Total Property Taxes 4,565,875.66 10,271,000.12 10,271,000.00 (0.12) 100.00% Total Taxes 4,565,875.66 10,271,000.12 10,271,000.00 (0.12) 100.00% State Shared Revenue 335002 - Vehicle/Aircraft Excise 365,078.46 741,141.60 741,142.00 0.40 100.00% 335007 - Commercial Vehicle Excise 85,147.69 170,295.56 170,297.00 1.44 100.00% Total State Shared Revenue 450,226.15 911,437.16 911,439.00 1.84 100.00% Total Intergovernmental Revenue 450,226.15 1,111,437.16 1,111,439.00 1.84 100.00% Total Nonbusiness Licenses & Permits 52.50 253.00 201.00 (52.00) 125.87% Total Licenses & Permits 52.50 253.00 201.00 (52.00) 125.87% Charges for Services Culture & Recreation 347001 - Swimming Pool 165.10 56,575.17 56,410.00 (165.17) 100.29% 347002 - Picnic Site Rental 33.68 6,033.13 6,000.00 (33.13) 100.55% 347003 - Golf Season Pass (656.00) 217,546.77 224,000.00 6,453.23 97.12% 347004 - Golf Green Fees (14,573.12) 770,126.98 791,530.00 21,403.02 97.30% 347005 - Golf Cart Rentals 2,176.36 384,592.18 384,400.00 (192.18) 100.05% 347006 - Golf Pro Shop Retail 1,647.83 76,129.41 74,500.00 (1,629.41) 102.19% 347007 - Golf Driving Range - 33,649.97 34,000.00 350.03 98.97% 347008 - Golf Gift Certificate 1,065.47 1,070.47 - (1,070.47) 0.00% 347010 - Concession Sales - 54,694.23 55,500.00 805.77 98.55% 347011 - Recreational Programming (27,681.61) 338,556.45 377,369.00 38,812.55 89.71% 347012 - Food Sales 78.15 67,104.83 67,227.00 122.17 99.82% 347013 - Nonalcoholic Beverage 104.14 40,816.51 41,543.00 726.49 98.25% 347014 - Alcoholic Beverage Sales 508.83 148,601.07 148,120.00 (481.07) 100.32% 347015 - Lease of Stadium - 100,000.00 75,000.00 (25,000.00) 133.33% 347016 - East Race Waterway 244.00 52,144.42 52,060.00 (84.42) 100.16% 347017 - Ice Skating 167,157.25 330,055.55 300,000.00 (30,055.55) 110.02% 347018 - Skate Rental - - - - 0.00% 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% 347026 - Room Rental 11,520.31 74,807.42 65,650.00 (9,157.42) 113.95% 347030 - Merch Sales 1,455.86 3,620.68 2,000.00 (1,620.68) 181.03% 347040 - Pavilion Rental 201.60 33,049.36 33,446.00 396.64 98.81% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347051 - Park Reservations - 100.00 100.00 - 100.00% 347100 - Concessions-Employee Discounts - (3,528.54) - 3,528.54 0.00% 347101 - Room Rental-Employee Discounts - (71.46) - 71.46 0.00% Total Culture & Recreation 174,524.67 2,922,964.89 2,892,612.00 (30,352.89) 101.05% Total Charges for Services 174,524.67 2,922,964.89 2,892,612.00 (30,352.89) 101.05% Fines, Forefeitures, Fees 351002 - Bad Checks Fines - 12.00 - (12.00) 0.00% Total Fines, Forfeitures, Fees - 12.00 - (12.00) 0.00% Miscellaneous Revenue 360000 - Miscellaneous 2.15 3,845.83 4,000.00 154.17 96.15% 360001 - Sale of Scrap Metal 31.60 1,177.16 1,177.00 (0.16) 100.01% 361000 - Interest Earnings 538.55 20,757.88 20,758.00 0.12 100.00% 362000 - Rental of Property 5,415.75 74,156.50 75,000.00 843.50 98.88% 367000 - Donations from Private Sources 60,000.00 912,899.00 912,899.00 - 100.00% Total Miscellaneous Revenue 65,988.05 1,012,836.37 1,013,834.00 997.63 99.90% Refunds & Reimbursements 380000 - Misc Reimbursements 489.42 28,442.16 17,463.00 (10,979.16) 162.87% 380007 - Energy Rebates - 962.27 962.00 (0.27) 100.03% 396000 - Refunds - 6,301.52 5,267.00 (1,034.52) 119.64% December 31, 2021 Total Refunds & Reimbursements 489.42 35,705.95 23,692.00 (12,013.95) 150.71% Other Sources 391000 - Interfund Transfers In 102,711.00 1,232,541.00 1,232,541.00 - 100.00% 392000 - Gain/Loss on Sale of Asset - 17,250.00 17,250.00 - 100.00% Total Other Sources 102,711.00 1,249,791.00 1,249,791.00 - 100.00% Total Revenue 5,359,867.45 16,604,000.49 16,562,569.00 (41,431.49) 100.25% 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 211,211.04 2,815,687.01 - 2,815,687.01 2,901,568.00 85,880.99 97.04% 410002 - Teamster Wages 107,439.72 1,434,865.94 - 1,434,865.94 1,469,405.00 34,539.06 97.65% 410003 - Permanent Part Time 46,384.12 727,424.74 - 727,424.74 764,186.00 36,761.26 95.19% 410004 - Extra & Overtime 4,386.69 110,004.82 - 110,004.82 124,332.00 14,327.18 88.48% 410005 - Seasonal & Interns 33,901.06 702,806.95 - 702,806.95 761,189.00 58,382.05 92.33% 410007 - Longevity Pay - 8,050.00 - 8,050.00 11,050.00 3,000.00 72.85% 410014 - Contract Add Pays - 955.98 - 955.98 4,000.00 3,044.02 23.90% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 0.00% Total Salaries & Wages 403,322.63 5,799,795.44 - 5,799,795.44 6,036,930.00 237,134.56 96.07% Employee Benefits 411001 - FICA Regular 30,679.02 434,615.01 - 434,615.01 454,631.00 20,015.99 95.60% 411004 - PERF Regular 35,011.46 479,069.20 - 479,069.20 496,040.00 16,970.80 96.58% 411005 - PERF Union 1,288.90 18,333.90 - 18,333.90 21,366.00 3,032.10 85.81% 411007 - Unemployment Comp 101.70 1,360.83 - 1,360.83 1,550.00 189.17 87.80% 411008 - Health Insurance 82,495.22 1,040,339.88 - 1,040,339.88 1,087,633.00 47,293.12 95.65% 411009 - Life Insurance 810.00 10,265.00 - 10,265.00 10,945.00 680.00 93.79% 411014 - Parental Leave 1,152.33 15,256.53 - 15,256.53 16,267.00 1,010.47 93.79% 411015 - Other Fringe Benefits - 1,600.00 - 1,600.00 1,600.00 - 100.00% 411201 - Tool Allowance 476.60 4,572.13 - 4,572.13 5,001.00 428.87 91.42% 411203 - Job Readiness Allow. - 15,300.00 - 15,300.00 15,300.00 - 100.00% 411204 - Auto Allowance 266.66 3,199.92 - 3,199.92 3,200.00 0.08 100.00% 411206 - Cell Phone Allowance 1,100.00 13,915.00 - 13,915.00 15,850.00 1,935.00 87.79% Total Employee Benefits 153,381.89 2,037,827.40 - 2,037,827.40 2,129,383.00 91,555.60 95.70% Total Personnel Expenditures 556,704.52 7,837,622.84 - 7,837,622.84 8,166,313.00 328,690.16 95.98% Supplies Expenditures Office Supplies 421000 - General Office Supplies 343.17 6,838.40 - 6,838.40 8,102.89 1,264.49 84.39% 421002 - Stationary & Printing 648.13 11,350.68 - 11,350.68 23,095.82 11,745.14 49.15% Total Office Supplies 991.30 18,189.08 - 18,189.08 31,198.71 13,009.63 58.30% Operating Supplies 422000 - Other Operating Supplies 19,096.97 329,416.40 - 329,416.40 369,937.76 40,521.36 89.05% 422001 - C.S. Gasoline 10,254.70 159,713.27 - 159,713.27 160,486.00 772.73 99.52% 422002 - Diesel/CNG - 11,036.84 - 11,036.84 12,597.00 1,560.16 87.61% 422003 - Gasoline 138.11 9,834.99 - 9,834.99 14,511.00 4,676.01 67.78% 422005 - Uniforms 2,742.48 9,154.83 - 9,154.83 14,028.00 4,873.17 65.26% 422006 - Computer Supplies & Equipment 37.44 357.37 - 357.37 2,620.00 2,262.63 13.64% 422007 - Cleaning Supplies - 1,317.82 - 1,317.82 1,433.00 115.18 91.96% 422008 - Medical/Safety Supplies 937.75 20,747.95 - 20,747.95 23,747.19 2,999.24 87.37% 422009 - Recreation Supplies 15,543.63 187,007.85 - 187,007.85 257,458.22 70,450.37 72.64% 422010 - Plants Chemicals Seed & Fertilizer 10,203.32 137,207.30 - 137,207.30 155,112.77 17,905.47 88.46% 422013 - Promotional Supplies 921.28 4,667.16 - 4,667.16 6,649.00 1,981.84 70.19% 422014 - Concessions Inventory 828.10 111,698.68 - 111,698.68 127,788.00 16,089.32 87.41% 422016 - Inventory For Sale 2,653.87 43,497.49 - 43,497.49 46,470.00 2,972.51 93.60% Total Operating Supplies 63,357.65 1,025,657.95 - 1,025,657.95 1,192,837.94 167,179.99 85.98% Repair & Maintenance Supplies 423000 - Other R&M Supplies 9,188.67 160,934.17 - 160,934.17 166,267.82 5,333.65 96.79% 423001 - Building Materials 2,036.48 42,535.49 - 42,535.49 44,499.51 1,964.02 95.59% 423006 - Small Tools & Equipment 1,750.56 62,492.36 - 62,492.36 63,742.00 1,249.64 98.04% 423009 - Repair Parts 3,133.86 62,233.15 - 62,233.15 70,984.50 8,751.35 87.67% Total Repair & Maintenance Supplies 16,109.57 328,195.17 - 328,195.17 345,493.83 17,298.66 94.99% Total Supplies Expenditures 80,458.52 1,372,042.20 - 1,372,042.20 1,569,530.48 197,488.28 87.42% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 4,560.50 90,581.06 - 90,581.06 131,091.96 40,510.90 69.10% 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 - 227.48 - 227.48 275.00 47.52 82.72% 431019 - Security Services 682.10 23,104.06 - 23,104.06 23,925.00 820.94 96.57% Total Professional Services 5,242.60 114,457.81 - 114,457.81 155,893.96 41,436.15 73.42% Communication & Transportation 432002 - Mailing 11.20 923.06 - 923.06 4,433.00 3,509.94 20.82% 432003 - Travel 2.00 4,688.77 - 4,688.77 20,491.00 15,802.23 22.88% 432004 - Telecommunications 191.40 3,138.70 - 3,138.70 3,842.01 703.31 81.69% 432005 - Mileage Reimb 242.85 434.37 - 434.37 6,519.00 6,084.63 6.66% Total Communication & Transportation 447.45 9,184.90 - 9,184.90 35,285.01 26,100.11 26.03% Printing & Advertising 433001 - Outside Printing Services 175.00 9,925.30 - 9,925.30 18,226.00 8,300.70 54.46% 433002 - Publication of Legal Notice - 945.94 - 945.94 1,577.74 631.80 59.96% 433003 - Promotional 5,867.88 144,764.10 - 144,764.10 182,154.84 37,390.74 79.47% Total Printing & Advertising 6,042.88 155,635.34 - 155,635.34 201,958.58 46,323.24 77.06% Utilties 435001 - Electric 28,359.84 492,717.43 - 492,717.43 544,894.00 52,176.57 90.42% 435002 - Natural Gas 23,974.63 155,568.93 - 155,568.93 178,544.00 22,975.07 87.13% 435004 - Water 7,422.29 281,827.87 - 281,827.87 329,074.00 47,246.13 85.64% Total Utilities 59,756.76 930,114.23 - 930,114.23 1,052,512.00 122,397.77 88.37% Repairs & Maintenance 436000 - Other R&M 16,064.40 81,160.43 - 81,160.43 114,408.59 33,248.16 70.94% 436001 - Building R&M 11,657.94 119,666.22 - 119,666.22 129,583.62 9,917.40 92.35% 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 636,276.50 - 636,276.50 682,909.21 46,632.71 93.17% Rentals 437002 - Equipment Rental - 556.00 - 556.00 650.00 94.00 85.54% 437005 - Parking Space Rental - 12,000.00 - 12,000.00 12,000.00 - 100.00% 437006 - Recreation Space Rental - 1,200.00 - 1,200.00 1,900.00 700.00 63.16% Total Rentals - 13,756.00 - 13,756.00 14,550.00 794.00 94.54% Debt Service 438100 - Principal - 452,897.72 - 452,897.72 461,923.00 9,025.28 98.05% 438200 - Interest - 26,619.80 - 26,619.80 32,286.00 5,666.20 82.45% 438300 - Paying Agent Fees - 4,400.00 - 4,400.00 5,000.00 600.00 88.00% Total Debt Service - 483,917.52 - 483,917.52 499,209.00 15,291.48 96.94% Other Charges & Services 439000 - Misc Charges & Svcs 6,726.95 352,734.45 - 352,734.45 398,692.51 45,958.06 88.47% 439001 - Other Contractual Services 5,879.73 17,725.81 - 17,725.81 31,752.26 14,026.45 55.83% 439002 - Licenses & Permits 275.00 9,095.57 - 9,095.57 11,161.00 2,065.43 81.49% 439003 - Subscriptions 62.94 3,440.38 - 3,440.38 3,866.00 425.62 88.99% 439004 - Dues & Memberships 1,973.00 6,939.15 - 6,939.15 10,922.00 3,982.85 63.53% 439005 - Bank & Credit Card Fees 9,948.14 80,907.70 - 80,907.70 91,897.00 10,989.30 88.04% 439006 - Education & Training 719.03 15,826.77 - 15,826.77 25,273.00 9,446.23 62.62% 439009 - Trash Removal 4,395.77 35,729.17 - 35,729.17 45,503.77 9,774.60 78.52% 439012 - Uniform Services 1,564.97 10,941.08 - 10,941.08 11,196.00 254.92 97.72% 439099 - Cashier Over/Short (5.68) 2,940.99 - 2,940.99 4,065.00 1,124.01 72.35% 439100 - Refunds/Awards/Indemnities 6,463.90 27,184.36 - 27,184.36 33,836.00 6,651.64 80.34% 439300 - Grants & Subsidies - 715,000.00 - 715,000.00 715,000.00 - 100.00% 439999 - Bad Debt Expense - - - - - - 0.00% Total Other Services & Charges 38,003.75 1,278,465.43 - 1,278,465.43 1,383,164.54 104,699.11 92.43% Total Services & Charges Expenditures 167,065.44 3,621,807.73 - 3,621,807.73 4,025,482.30 403,674.57 89.97% Capital Outlay Buildings 443001 - Building Improvements - 68,352.12 - 68,352.12 71,550.00 3,197.88 95.53% Total Buildings - 68,352.12 - 68,352.12 71,550.00 3,197.88 95.53% 444000 - Land Improvements 118,386.62 392,464.99 - 392,464.99 396,815.42 4,350.43 98.90% 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 118,386.62 474,789.61 - 474,789.61 482,338.06 7,548.45 98.44% Other Uses 452002 - Allocations-Admin Cost 57,573.00 690,877.00 - 690,877.00 690,877.00 - 100.00% 452003 - Allocations-IT 54,596.00 655,149.00 - 655,149.00 655,149.00 - 100.00% 452004 - Allocations-Liability Insurance 18,500.00 221,988.00 - 221,988.00 221,988.00 - 100.00% 452008 - Allocations-Payroll Cost 6,680.00 80,156.00 - 80,156.00 80,156.00 - 100.00% 452009 - Allocations-Facilities Mgmt 1,654.00 19,845.00 - 19,845.00 19,845.00 - 100.00% Total Other Uses 139,003.00 1,668,015.00 - 1,668,015.00 1,668,015.00 - 100.00% Total Expenditures 1,061,618.10 14,974,277.38 - 14,974,277.38 15,911,678.84 937,401.46 94.11%