Loading...
HomeMy WebLinkAboutFeb 21 Fin 4South Bend Venues, Parks and Arts Golf: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected Charges for Services Culture & Recreation 347003 - Golf Season Pass 11,617.85 136,952.10 175,000.00 38,047.90 21.74% 347004 - Golf Green Fees - - 684,000.00 684,000.00 100.00% 347005 - Golf Cart Rentals - - 350,000.00 350,000.00 100.00% 347006 - Golf Pro Shop Retail 26.99 46.99 60,000.00 59,953.01 99.92% 347007 - Golf Driving Range - - 25,000.00 25,000.00 100.00% 347008 - Golf Gift Certificate (729.15) (10,509.42) - 10,509.42 0.00% 347012 - Food Sales - - 65,000.00 65,000.00 100.00% 347013 - Nonalcoholic Beverage - - 48,000.00 48,000.00 100.00% 347014 - Alcoholic Beverage Sales - 14.01 100,000.00 99,985.99 99.99% Total Culture & Recreation 10,915.69 126,503.68 1,507,000.00 1,380,496.32 91.61% Total Charges for Services 10,915.69 126,503.68 1,507,000.00 1,380,496.32 91.61% Miscellaneous Revenue 360000 - Miscellaneous 0.01 4.93 5,000.00 4,995.07 99.90% Total Miscellaneous Revenue 0.01 4.93 5,000.00 4,995.07 99.90% Refunds & Reimbursements 396000 - Refunds 3,263.85 3,263.85 - (3,263.85) 0.00% Total Refunds & Reimbursements 3,263.85 3,263.85 - (3,263.85) 0.00% Total Revenue 14,179.55 129,772.46 1,512,000.00 1,382,227.54 91.42% 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 25,477.44 50,954.86 - 50,954.86 329,507.00 278,552.14 84.54% 410002 - Teamster Wages 6,483.20 12,966.41 - 12,966.41 83,842.00 70,875.59 84.53% 410003 - Permanent Part Time 824.57 1,182.83 - 1,182.83 245,500.00 244,317.17 99.52% 410004 - Extra & Overtime 258.32 273.52 - 273.52 2,550.00 2,276.48 89.27% 410005 - Seasonal & Interns 1,051.56 1,468.94 - 1,468.94 30,450.00 28,981.06 95.18% 410007 - Longevity Pay - - - - 600.00 600.00 100.00% Total Salaries & Wages 34,095.09 66,846.56 - 66,846.56 692,449.00 625,602.44 90.35% Employee Benefits 411001 - FICA Regular 2,465.75 4,894.35 - 4,894.35 53,149.00 48,254.65 90.79% 411004 - PERF Regular 3,614.69 8,142.58 - 8,142.58 46,907.00 38,764.42 82.64% 411005 - PERF Union 101.12 211.35 - 211.35 1,330.00 1,118.65 84.11% 411007 - Unemployment Comp 3.22 6.42 - 6.42 124.00 117.58 94.82% 411008 - Health Insurance 8,808.94 17,610.88 - 17,610.88 82,943.00 65,332.12 78.77% 411009 - Life Insurance 80.00 160.00 - 160.00 960.00 800.00 83.33% 411014 - Parental Leave 112.80 224.70 - 224.70 1,458.00 1,233.30 84.59% 411015 - Other Fringe Benefits - 400.00 - 400.00 - (400.00) 0.00% 411201 - Tool Allowance - - - - 800.00 800.00 100.00% 411203 - Job Readiness Allow. - 850.00 - 850.00 850.00 - 0.00% 411206 - Cell Phone Allowance 55.00 110.00 - 110.00 660.00 550.00 83.33% Total Employee Benefits 15,241.52 32,610.28 - 32,610.28 189,181.00 156,570.72 82.76% Total Personnel Expenditures 49,336.61 99,456.84 - 99,456.84 881,630.00 782,173.16 88.72% Supplies Expenditures Office Supplies February 28, 2021 421000 - Other Office Supplies 534.37 820.25 - 820.25 - (820.25) 0.00% Total Office Supplies 534.37 820.25 - 820.25 - (820.25) 0.00% Operating Supplies 422000 - Other Operating Supplies 2,692.69 6,335.95 885.00 7,220.95 38,385.00 31,164.05 81.19% 422003 - Gasoline 562.75 562.75 - 562.75 23,503.00 22,940.25 97.61% 422005 - Uniforms - - - - 2,200.00 2,200.00 100.00% 422010 - Plants Chemicals Seed & Fertilizer - - 56.77 56.77 90,056.77 90,000.00 99.94% 422014 - Concessions Inventory - - - - 85,500.00 85,500.00 100.00% 422016 - Inventory For Sale - - 30,771.06 30,771.06 35,000.00 4,228.94 12.08% Total Operating Supplies 3,255.44 6,898.70 31,712.83 38,611.53 274,644.77 236,033.24 85.94% Repair & Maintenance Supplies 423000 - Other R&M Supplies 1,941.42 5,903.16 663.80 6,566.96 40,000.00 33,433.04 83.58% 423001 - Building Materials - 393.64 - 393.64 - (393.64) 0.00% 423006 - Small Tools & Equipment - 31,175.00 - 31,175.00 31,175.00 - 0.00% 423009 - Repair Parts 216.75 1,074.98 161.24 1,236.22 858.23 (377.99) (44.04%) Total Repair & Maintenance Supplies 2,158.17 38,546.78 825.04 39,371.82 72,033.23 32,661.41 45.34% Total Supplies Expenditures 5,947.98 46,265.73 32,537.87 78,803.60 346,678.00 267,874.40 77.27% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 978.00 1,130.00 1,477.65 2,607.65 1,477.65 (1,130.00) (76.47%) 431015 - Laboratory Water Testing 15.00 15.00 - 15.00 - (15.00) 0.00% 431019 - Security Services 440.30 655.10 - 655.10 1,000.00 344.90 34.49% Total Professional Services 1,433.30 1,800.10 1,477.65 3,277.75 2,477.65 (800.10) (32.29%) Communication & Transportation 432004 - Telecommunications 80.87 80.87 9.13 90.00 400.00 310.00 77.50% Total Communication & Transportation 80.87 80.87 9.13 90.00 400.00 310.00 77.50% Utilties 435001 - Electric 4,287.69 8,470.90 - 8,470.90 52,667.00 44,196.10 83.92% 435002 - Natural Gas 2,870.02 4,364.54 - 4,364.54 22,519.00 18,154.46 80.62% Total Utilities 7,157.71 12,835.44 - 12,835.44 75,186.00 62,350.56 82.93% Debt Service 438100 - Principal 80.94 241.86 - 241.86 65,326.00 65,084.14 99.63% 438200 - Interest 3.19 10.54 - 10.54 8,480.00 8,469.46 99.88% Total Debt Service 84.13 252.40 - 252.40 73,806.00 73,553.60 99.66% Other Charges & Services 439000 - Misc Charges & Svcs 112.58 267.58 971.28 1,238.86 31,539.43 30,300.57 96.07% 439001 - Other Contractual Services - - 333.80 333.80 333.80 - 0.00% 439002 - Licenses & Permits 222.55 2,232.55 - 2,232.55 2,000.00 (232.55) (11.63%) 439003 - Subscriptions - 64.99 - 64.99 - (64.99) 0.00% 439004 - Dues & Memberships - - - - 3,700.00 3,700.00 100.00% 439005 - Bank & Credit Card Fees 2,790.94 3,128.70 - 3,128.70 29,800.00 26,671.30 89.50% 439009 - Trash Removal - 107.58 - 107.58 5,200.00 5,092.42 97.93% 439099 - Cashier Over/Short 0.10 0.10 - 0.10 - (0.10) 0.00% Total Other Services & Charges 3,126.17 5,801.50 1,305.08 7,106.58 72,573.23 65,466.65 90.21% Total Services & Charges Expenditures 11,882.18 20,770.31 2,791.86 23,562.17 224,442.88 200,880.71 89.50% Other Uses 452002 - Allocations-Admin Cost 6,281.00 12,562.00 - 12,562.00 75,372.00 62,810.00 83.33% 452004 - Allocations-Liability Insurance 859.00 1,717.00 - 1,717.00 10,307.00 8,590.00 83.34% 452009 - Allocations-Facilities Mgmt 218.00 435.00 - 435.00 1,056.00 621.00 58.81% Total Other Uses 7,358.00 14,714.00 - 14,714.00 86,735.00 72,021.00 83.04% Total Expenditures 74,524.77 181,206.88 35,329.73 216,536.61 1,539,485.88 1,322,949.27 85.93%