Loading...
HomeMy WebLinkAboutJuly 20 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 2,759.50 159,368.20 165,000.00 5,631.80 3.41% 347004 - Golf Green Fees 159,224.65 398,187.80 550,000.00 151,812.20 27.60% 347005 - Golf Cart Rentals 71,634.76 171,105.47 330,000.00 158,894.53 48.15% 347006 - Golf Pro Shop Retail 10,413.41 24,790.87 60,000.00 35,209.13 58.68% 347007 - Golf Driving Range 6,036.55 16,184.72 20,000.00 3,815.28 19.08% 347008 - Golf Gift Certificate 321.61 1,161.93 5,500.00 4,338.07 78.87% 347009 - Golf Outings - - 5,000.00 5,000.00 100.00% 347012 - Food Sales 10,263.04 22,749.19 60,000.00 37,250.81 62.08% 347013 - Nonalcoholic Beverage 7,156.67 15,598.73 30,000.00 14,401.27 48.00% 347014 - Alcoholic Beverage Sales 19,976.26 50,454.87 90,000.00 39,545.13 43.94% 347026 - Room Rental 200.00 200.00 - (200.00) 0.00% 347999 - Cash Over/Short 170.83 398.19 - (398.19) 0.00% Total Culture & Recreation 288,157.28 860,199.97 1,315,500.00 455,300.03 34.61% Total Charges for Services 288,157.28 860,199.97 1,315,500.00 455,300.03 34.61% Miscellaneous Revenue 360000 - Miscellaneous 346.24 3,381.48 2,500.00 (881.48) (35.26%) Total Miscellaneous Revenue 346.24 3,381.48 2,500.00 (881.48) (35.26%) Refunds & Reimbursements 380000 - Misc Reimbursements 92.00 92.00 - (92.00) 0.00% Total Refunds & Reimbursements 92.00 92.00 - (92.00) 0.00% Total Revenue 288,595.52 863,673.45 1,318,000.00 454,326.55 34.47% 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,219.30 189,144.66 - 189,144.66 314,481.00 125,336.34 39.85% 410002 - Teamster Wages 6,419.20 48,144.01 - 48,144.01 83,012.00 34,867.99 42.00% 410003 - Permanent Part Time 32,280.12 92,593.50 - 92,593.50 253,000.00 160,406.50 63.40% 410004 - Extra & Overtime 1,276.70 2,003.89 - 2,003.89 2,550.00 546.11 21.42% 410005 - Seasonal & Interns 9,249.00 14,250.71 - 14,250.71 22,950.00 8,699.29 37.91% 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 0.00% Total Salaries & Wages 74,444.32 346,736.77 - 346,736.77 676,593.00 329,856.23 48.75% Employee Benefits 411001 - FICA Regular 5,564.57 25,614.42 - 25,614.42 51,936.00 26,321.58 50.68% 411004 - PERF Regular 3,575.42 26,812.00 - 26,812.00 45,131.00 18,319.00 40.59% 411005 - PERF Union 99.73 747.87 - 747.87 1,317.00 569.13 43.21% 411007 - Unemployment Comp 3.20 23.84 - 23.84 40.00 16.16 40.40% 411008 - Health Insurance 7,833.60 54,835.20 - 54,835.20 92,883.00 38,047.80 40.96% 411009 - Life Insurance 80.00 560.00 - 560.00 960.00 400.00 41.67% 411014 - Parental Leave 111.53 832.62 - 832.62 1,402.00 569.38 40.61% 411201 - Tool Allowance - 531.37 - 531.37 800.00 268.63 33.58% 411203 - Job Readiness Allow. - 850.00 - 850.00 850.00 - 0.00% 411206 - Cell Phone Allowance 55.00 385.00 - 385.00 660.00 275.00 41.67% Total Employee Benefits 17,323.05 111,192.32 - 111,192.32 195,979.00 84,786.68 43.26% Total Personnel Expenditures 91,767.37 457,929.09 - 457,929.09 872,572.00 414,642.91 47.52% July 31, 2020 Supplies Expenditures Office Supplies 421002 - Stationary & Printing - 322.87 - 322.87 1,550.00 1,227.13 79.17% Total Office Supplies - 322.87 - 322.87 1,550.00 1,227.13 0.79 Operating Supplies 422000 - Other Operating Supplies 6,976.76 41,770.44 15,827.74 57,598.18 63,675.00 6,076.82 9.54% 422001 - C.S. Gasoline - 1,785.60 - 1,785.60 1,800.00 14.40 0.80% 422002 - Diesel/CNG 710.40 710.40 - 710.40 - (710.40) 0.00% 422003 - Gasoline 4,682.75 7,403.01 - 7,403.01 20,000.00 12,596.99 62.98% 422005 - Uniforms 400.00 1,074.00 991.50 2,065.50 4,500.00 2,434.50 54.10% 422010 - Plants Chemicals Seed & Fertilizer 6,712.01 71,552.63 7,365.51 78,918.14 111,565.00 32,646.86 29.26% 422014 - Concessions Inventory 19,731.75 34,391.74 11,777.64 46,169.38 70,040.00 23,870.62 34.08% 422016 - Inventory For Sale 5.54 19,236.69 - 19,236.69 45,000.00 25,763.31 57.25% Total Operating Supplies 39,219.21 177,924.51 35,962.39 213,886.90 316,580.00 102,693.10 32.44% Repair & Maintenance Supplies 423000 - Other R&M Supplies 3,925.72 28,640.78 1,426.40 30,067.18 44,034.00 13,966.82 31.72% 423001 - Building Materials - 389.90 - 389.90 1,000.00 610.10 61.01% 423009 - Repair Parts 106.20 696.82 2,857.97 3,554.79 2,610.00 (944.79) (36.20%) Total Repair & Maintenance Supplies 4,031.92 29,727.50 4,284.37 34,011.87 47,644.00 13,632.13 28.61% Total Supplies Expenditures 43,251.13 207,974.88 40,246.76 248,221.64 365,774.00 117,552.36 32.14% Services & Charges Expenditures Professional Services 431000 - Other Professional Services - 480.70 - 480.70 700.00 219.30 31.33% 431009 - Computer & Technology 29.24 58.48 - 58.48 100.00 41.52 41.52% 431019 - Security Services 1,242.64 1,576.00 - 1,576.00 4,200.00 2,624.00 62.48% Total Professional Services 1,271.88 2,115.18 - 2,115.18 5,000.00 2,884.82 57.70% Communication & Transportation 432003 - Travel - 433.92 - 433.92 500.00 66.08 13.22% 432004 - Telecommunications - 87.72 - 87.72 400.00 312.28 78.07% Total Communication & Transportation - 521.64 - 521.64 900.00 378.36 42.04% Printing & Advertising 433001 - Outside Printing Services - - - - 590.00 590.00 100.00% Total Printing & Advertising - - - - 590.00 590.00 100.00% Utilties 435001 - Electric 15,045.25 36,599.07 - 36,599.07 55,556.00 18,956.93 34.12% 435002 - Natural Gas 1,767.22 14,968.10 - 14,968.10 18,519.00 3,550.90 19.17% Total Utilities 16,812.47 51,567.17 - 51,567.17 74,075.00 22,507.83 30.39% Repairs & Maintenance 436005 - Other Equip R&M - 750.00 - 750.00 800.00 50.00 6.25% Total Repairs & Maintenance - 750.00 - 750.00 800.00 50.00 6.25% Rentals 437002 - Equipment Rental - 153.90 - 153.90 200.00 46.10 23.05% Total Rentals - 153.90 - 153.90 200.00 46.10 23.05% Debt Service 438100 - Principal 78.72 61,917.26 - 61,917.26 62,235.00 317.74 0.51% 438200 - Interest 5.41 11,572.21 - 11,572.21 11,591.00 18.79 0.16% Total Debt Service 84.13 73,489.47 - 73,489.47 73,826.00 336.53 0.46% Other Charges & Services 439000 - Misc Charges & Svcs 1,759.35 13,360.61 10,301.82 23,662.43 66,450.00 42,787.57 64.39% 439001 - Other Contractual Services 29.24 172.74 450.76 623.50 1,300.00 676.50 52.04% 439003 - Subscriptions 233.18 352.18 - 352.18 200.00 (152.18) (76.09%) 439004 - Dues & Memberships - 1,755.00 - 1,755.00 4,000.00 2,245.00 56.13% 439005 - Bank & Credit Card Fees 5,266.40 11,043.21 - 11,043.21 19,000.00 7,956.79 41.88% 439006 - Education & Training 60.47 159.41 - 159.41 150.00 (9.41) (6.27%) 439009 - Trash Removal 573.90 2,219.08 1,156.39 3,375.47 7,000.00 3,624.53 51.78% Total Other Services & Charges 7,922.54 29,062.23 11,908.97 40,971.20 98,100.00 57,128.80 58.24% Total Services & Charges Expenditures 26,091.02 157,659.59 11,908.97 169,568.56 253,491.00 83,922.44 33.11% Other Uses 452002 - Allocations-Admin Cost 4,770.00 33,388.00 - 33,388.00 57,238.00 23,850.00 41.67% 452009 - Allocations-Facilities Mgmt 233.00 1,633.00 - 1,633.00 2,798.00 1,165.00 41.64% Total Other Uses 5,003.00 35,021.00 - 35,021.00 60,036.00 25,015.00 41.67% Total Expenditures 166,112.52 858,584.56 52,155.73 910,740.29 1,551,873.00 641,132.71 41.31%