Loading...
HomeMy WebLinkAboutApr 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 18,578.00 203,736.85 93,000.00 (110,736.85) (119.07%) 347004 - Golf Green Fees 61,948.10 90,256.10 795,000.00 704,743.90 88.65% 347005 - Golf Cart Rentals 28,881.35 40,554.89 360,000.00 319,445.11 88.73% 347006 - Golf Pro Shop Retail 7,742.14 11,402.48 59,500.00 48,097.52 80.84% 347007 - Golf Driving Range 3,570.00 5,281.00 30,000.00 24,719.00 82.40% 347008 - Golf Gift Certificate (975.00) (11,868.89) - 11,868.89 0.00% 347012 - Food Sales 5,903.07 7,585.17 53,277.00 45,691.83 85.76% 347013 - Nonalcoholic Beverage 2,641.16 3,378.10 33,398.00 30,019.90 89.89% 347014 - Alcoholic Beverage Sales 10,972.44 14,335.30 110,000.00 95,664.70 86.97% 347026 - Room Rental - 100.00 - (100.00) 0.00% 347100 - Concessions-Employee Discounts (159.79) (191.14) - 191.14 0.00% Total Culture & Recreation 139,101.47 364,569.86 1,534,175.00 1,169,605.14 76.24% Total Charges for Services 139,101.47 364,569.86 1,534,175.00 1,169,605.14 76.24% Miscellaneous Revenue 360000 - Miscellaneous 136.00 1,039.24 5,000.00 3,960.76 79.22% Total Miscellaneous Revenue 136.00 1,039.24 5,000.00 3,960.76 79.22% Refunds & Reimbursements 396000 - Refunds - 3,263.85 - (3,263.85) 0.00% Total Refunds & Reimbursements - 3,263.85 - (3,263.85) 0.00% Total Revenue 139,237.47 368,872.95 1,539,175.00 1,170,302.05 76.03% 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 38,216.19 114,417.45 - 114,417.45 329,507.00 215,089.55 65.28% 410002 - Teamster Wages 12,691.47 32,143.33 - 32,143.33 83,842.00 51,698.67 61.66% 410003 - Permanent Part Time 27,676.39 30,909.47 - 30,909.47 245,500.00 214,590.53 87.41% 410004 - Extra & Overtime 45.76 334.48 - 334.48 2,550.00 2,215.52 86.88% 410005 - Seasonal & Interns 3,833.73 6,440.94 - 6,440.94 30,450.00 24,009.06 78.85% 410007 - Longevity Pay 250.00 600.00 - 600.00 600.00 - 0.00% Total Salaries & Wages 82,713.54 184,845.67 - 184,845.67 692,449.00 507,603.33 73.31% Employee Benefits 411001 - FICA Regular 6,199.64 13,646.96 - 13,646.96 53,149.00 39,502.04 74.32% 411004 - PERF Regular 5,325.10 17,068.72 - 17,068.72 46,907.00 29,838.28 63.61% 411005 - PERF Union 194.81 508.92 - 508.92 1,330.00 821.08 61.74% 411007 - Unemployment Comp 5.23 14.87 - 14.87 124.00 109.13 88.01% 411008 - Health Insurance 8,241.34 34,661.16 - 34,661.16 82,943.00 48,281.84 58.21% 411009 - Life Insurance 70.00 310.00 - 310.00 960.00 650.00 67.71% 411014 - Parental Leave 179.50 516.56 - 516.56 1,458.00 941.44 64.57% 411015 - Other Fringe Benefits - 400.00 - 400.00 400.00 - 0.00% 411201 - Tool Allowance - - - - 400.00 400.00 100.00% 411203 - Job Readiness Allow. - 850.00 - 850.00 850.00 - 0.00% 411206 - Cell Phone Allowance 55.00 220.00 - 220.00 660.00 440.00 66.67% Total Employee Benefits 20,270.62 68,197.19 - 68,197.19 189,181.00 120,983.81 63.95% Total Personnel Expenditures 102,984.16 253,042.86 - 253,042.86 881,630.00 628,587.14 71.30% April 30, 2021 Supplies Expenditures Office Supplies 421000 - Other Office Supplies - 833.54 - 833.54 834.00 0.46 0.06% Total Office Supplies - 833.54 - 833.54 834.00 0.46 0.06% Operating Supplies 422000 - Other Operating Supplies 8,117.03 29,521.11 2,952.40 32,473.51 37,551.00 5,077.49 13.52% 422002 - Diesel/CNG 1,171.80 1,171.80 - 1,171.80 - (1,171.80) 0.00% 422003 - Gasoline 1,345.00 4,946.08 - 4,946.08 23,503.00 18,556.92 78.96% 422005 - Uniforms - - 550.10 550.10 2,200.00 1,649.90 75.00% 422010 - Plants Chemicals Seed & Fertilizer 3,916.95 53,508.45 9,464.76 62,973.21 90,056.77 27,083.56 30.07% 422014 - Concessions Inventory 13,393.76 13,759.54 - 13,759.54 85,500.00 71,740.46 83.91% 422016 - Inventory For Sale 1,180.62 30,339.05 7,935.92 38,274.97 35,000.00 (3,274.97) (9.36%) Total Operating Supplies 29,125.16 133,246.03 20,903.18 154,149.21 273,810.77 119,661.56 43.70% Repair & Maintenance Supplies 423000 - Other R&M Supplies 1,319.89 11,058.83 2,563.92 13,622.75 39,073.00 25,450.25 65.14% 423001 - Building Materials - 393.64 - 393.64 394.00 0.36 0.09% 423006 - Small Tools & Equipment - 31,175.00 - 31,175.00 31,175.00 - 0.00% 423009 - Repair Parts - 1,228.40 161.24 1,389.64 1,391.23 1.59 0.11% Total Repair & Maintenance Supplies 1,319.89 43,855.87 2,725.16 46,581.03 72,033.23 25,452.20 35.33% Total Supplies Expenditures 30,445.05 177,935.44 23,628.34 201,563.78 346,678.00 145,114.22 41.86% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 1,643.94 4,625.59 - 4,625.59 2,607.65 (2,017.94) (77.39%) 431015 - Laboratory Water Testing - 15.00 - 15.00 15.00 - 0.00% 431019 - Security Services 267.28 2,043.95 - 2,043.95 1,656.00 (387.95) (23.43%) Total Professional Services 1,911.22 6,684.54 - 6,684.54 4,278.65 (2,405.89) (56.23%) Communication & Transportation 432002 - Mailing 12.10 12.10 - 12.10 - (12.10) 0.00% 432004 - Telecommunications - 80.87 9.13 90.00 400.00 310.00 77.50% Total Communication & Transportation 12.10 92.97 9.13 102.10 400.00 297.90 74.48% Utilties 435001 - Electric 4,366.22 19,093.90 - 19,093.90 52,667.00 33,573.10 63.75% 435002 - Natural Gas 2,213.89 9,482.41 - 9,482.41 22,519.00 13,036.59 57.89% Total Utilities 6,580.11 28,576.31 - 28,576.31 75,186.00 46,609.69 61.99% Repairs & Maintenance 436000 - Other R&M - - 8,697.00 8,697.00 - (8,697.00) 0.00% Total Repairs & Maintenance - - 8,697.00 8,697.00 - (8,697.00) 0.00% Debt Service 438100 - Principal 81.58 404.70 - 404.70 65,326.00 64,921.30 99.38% 438200 - Interest 2.55 15.96 - 15.96 8,480.00 8,464.04 99.81% Total Debt Service 84.13 420.66 - 420.66 73,806.00 73,385.34 99.43% Other Charges & Services 439000 - Misc Charges & Svcs 220.81 2,096.94 625.88 2,722.82 29,217.43 26,494.61 90.68% 439001 - Other Contractual Services - - 333.80 333.80 333.80 - 0.00% 439002 - Licenses & Permits 1,684.37 4,287.88 - 4,287.88 2,456.00 (1,831.88) (74.59%) 439003 - Subscriptions 64.99 259.96 - 259.96 65.00 (194.96) (299.94%) 439004 - Dues & Memberships - 623.04 - 623.04 3,700.00 3,076.96 83.16% 439005 - Bank & Credit Card Fees 1,900.28 5,439.11 - 5,439.11 29,800.00 24,360.89 81.75% 439009 - Trash Removal - 107.58 - 107.58 5,200.00 5,092.42 97.93% 439099 - Cashier Over/Short (46.03) (65.18) - (65.18) - 65.18 0.00% 439100 - Refunds/Awards/Indemnities 47.98 47.98 - 47.98 - (47.98) 0.00% Total Other Services & Charges 3,872.40 12,797.31 959.68 13,756.99 70,772.23 57,015.24 80.56% Total Services & Charges Expenditures 12,459.96 48,571.79 9,665.81 58,237.60 224,442.88 166,205.28 74.05% Other Uses 452002 - Allocations-Admin Cost 6,281.00 25,124.00 - 25,124.00 75,372.00 50,248.00 66.67% 452004 - Allocations-Liability Insurance 859.00 3,435.00 - 3,435.00 10,307.00 6,872.00 66.67% 452009 - Allocations-Facilities Mgmt 218.00 871.00 - 871.00 1,056.00 185.00 17.52% Total Other Uses 7,358.00 29,430.00 - 29,430.00 86,735.00 57,305.00 66.07% Total Expenditures 153,247.17 508,980.09 33,294.15 542,274.24 1,539,485.88 997,211.64 64.78%