Loading...
HomeMy WebLinkAboutNov 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 - 162,676.20 165,000.00 2,323.80 1.41% 347004 - Golf Green Fees 31,628.50 794,697.01 550,000.00 (244,697.01) (44.49%) 347005 - Golf Cart Rentals 15,756.31 357,119.62 330,000.00 (27,119.62) (8.22%) 347006 - Golf Pro Shop Retail 2,165.88 52,734.07 60,000.00 7,265.93 12.11% 347007 - Golf Driving Range 773.00 31,874.18 30,530.00 (1,344.18) (4.40%) 347008 - Golf Gift Certificate (39.74) 517.53 260.00 (257.53) (99.05%) 347012 - Food Sales 2,006.56 47,876.49 60,000.00 12,123.51 20.21% 347013 - Nonalcoholic Beverage 1,137.37 30,527.00 30,000.00 (527.00) (1.76%) 347014 - Alcoholic Beverage Sales 4,295.72 108,683.60 90,000.00 (18,683.60) (20.76%) 347026 - Room Rental 75.00 75.00 - (75.00) 0.00% 347999 - Cash Over/Short 3.92 619.51 - (619.51) 0.00% Total Culture & Recreation 57,802.52 1,587,400.21 1,315,790.00 (271,610.21) (20.64%) Total Charges for Services 57,802.52 1,587,400.21 1,315,790.00 (271,610.21) (20.64%) Miscellaneous Revenue 360000 - Miscellaneous 29.48 6,175.88 6,270.00 94.12 1.50% Total Miscellaneous Revenue 29.48 6,175.88 6,270.00 94.12 1.50% Refunds & Reimbursements 380000 - Misc Reimbursements - 92.00 92.00 - 0.00% Total Refunds & Reimbursements - 92.00 92.00 - 0.00% Total Revenue 57,832.00 1,593,668.09 1,322,152.00 (271,516.09) (20.54%) 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 24,283.53 301,316.92 - 301,316.92 314,481.00 13,164.08 4.19% 410002 - Teamster Wages 6,419.21 77,034.02 - 77,034.02 83,012.00 5,977.98 7.20% 410003 - Permanent Part Time 14,529.19 209,079.29 - 209,079.29 231,000.00 21,920.71 9.49% 410004 - Extra & Overtime 37.62 4,467.50 - 4,467.50 4,550.00 82.50 1.81% 410005 - Seasonal & Interns 3,599.35 44,875.28 - 44,875.28 42,950.00 (1,925.28) (4.48%) 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 0.00% Total Salaries & Wages 48,868.90 637,373.01 - 637,373.01 676,593.00 39,219.99 5.80% Employee Benefits 411001 - FICA Regular 3,601.28 47,331.28 - 47,331.28 51,936.00 4,604.72 8.87% 411004 - PERF Regular 3,096.95 42,025.92 - 42,025.92 45,131.00 3,105.08 6.88% 411005 - PERF Union 96.85 1,198.12 - 1,198.12 1,317.00 118.88 9.03% 411007 - Unemployment Comp 3.07 38.06 - 38.06 40.00 1.94 4.85% 411008 - Health Insurance 7,736.07 85,932.87 - 85,932.87 92,883.00 6,950.13 7.48% 411009 - Life Insurance 70.00 850.00 - 850.00 960.00 110.00 11.46% 411014 - Parental Leave 107.57 1,330.26 - 1,330.26 1,402.00 71.74 5.12% 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 605.00 - 605.00 660.00 55.00 8.33% Total Employee Benefits 14,766.79 180,692.88 - 180,692.88 195,979.00 15,286.12 7.80% Total Personnel Expenditures 63,635.69 818,065.89 - 818,065.89 872,572.00 54,506.11 6.25% Supplies Expenditures November 30, 2020 Office Supplies 421002 - Stationary & Printing - 322.87 - 322.87 650.00 327.13 50.33% Total Office Supplies - 322.87 - 322.87 650.00 327.13 50.33% Operating Supplies 422000 - Other Operating Supplies 6,170.38 75,466.85 9,389.04 84,855.89 85,375.00 519.11 0.61% 422001 - C.S. Gasoline - 3,309.92 - 3,309.92 3,900.00 590.08 15.13% 422002 - Diesel/CNG - 3,142.40 - 3,142.40 3,510.00 367.60 10.47% 422003 - Gasoline - 11,934.72 503.00 12,437.72 14,005.00 1,567.28 11.19% 422005 - Uniforms - 2,574.00 991.50 3,565.50 4,145.00 579.50 13.98% 422010 - Plants Chemicals Seed & Fertilizer 487.90 84,363.93 523.71 84,887.64 86,755.00 1,867.36 2.15% 422014 - Concessions Inventory 6,257.25 73,767.13 8,865.12 82,632.25 84,940.00 2,307.75 2.72% 422016 - Inventory For Sale 2,274.57 34,051.83 - 34,051.83 34,000.00 (51.83) (0.15%) Total Operating Supplies 15,190.10 288,610.78 20,272.37 308,883.15 316,630.00 7,746.85 2.45% Repair & Maintenance Supplies 423000 - Other R&M Supplies 342.76 35,716.02 1,092.41 36,808.43 40,334.00 3,525.57 8.74% 423001 - Building Materials - 389.90 - 389.90 500.00 110.10 22.02% 423009 - Repair Parts 145.74 5,603.47 1,042.41 6,645.88 7,660.00 1,014.12 13.24% Total Repair & Maintenance Supplies 488.50 41,709.39 2,134.82 43,844.21 48,494.00 4,649.79 9.59% Total Supplies Expenditures 15,678.60 330,643.04 22,407.19 353,050.23 365,774.00 12,723.77 3.48% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 1,537.10 4,478.66 1,477.65 5,956.31 5,770.00 (186.31) (3.23%) 431009 - Computer & Technology - 58.48 - 58.48 100.00 41.52 41.52% 431019 - Security Services 505.46 3,521.84 - 3,521.84 6,643.00 3,121.16 46.98% Total Professional Services 2,042.56 8,058.98 1,477.65 9,536.63 12,513.00 2,976.37 23.79% 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 3,410.65 53,068.91 - 53,068.91 55,556.00 2,487.09 4.48% 435002 - Natural Gas 84.12 15,533.09 - 15,533.09 18,519.00 2,985.91 16.12% Total Utilities 3,494.77 68,602.00 - 68,602.00 74,075.00 5,473.00 7.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 965.00 1,118.90 - 1,118.90 1,183.00 64.10 5.42% Total Rentals 965.00 1,118.90 - 1,118.90 1,183.00 64.10 5.42% Debt Service 438100 - Principal 79.98 62,235.27 - 62,235.27 62,235.00 (0.27) (0.00%) 438200 - Interest 4.15 11,590.71 - 11,590.71 11,591.00 0.29 0.00% Total Debt Service 84.13 73,825.98 - 73,825.98 73,826.00 0.02 0.00% Other Charges & Services 439000 - Misc Charges & Svcs 2,039.06 23,735.84 1,039.98 24,775.82 43,744.00 18,968.18 43.36% 439001 - Other Contractual Services 29.24 289.70 333.80 623.50 1,300.00 676.50 52.04% 439003 - Subscriptions - 443.18 - 443.18 465.00 21.82 4.69% 439004 - Dues & Memberships - 1,755.00 - 1,755.00 4,000.00 2,245.00 56.13% 439005 - Bank & Credit Card Fees 2,022.91 28,328.04 - 28,328.04 30,185.00 1,856.96 6.15% 439006 - Education & Training - 258.35 - 258.35 350.00 91.65 26.19% 439009 - Trash Removal - 3,534.78 1,898.80 5,433.58 9,360.00 3,926.42 41.95% 439100 - Refunds/Awards/Indemnities - - - - 200.00 200.00 100.00% Total Other Services & Charges 4,091.21 58,344.89 3,272.58 61,617.47 89,604.00 27,986.53 31.23% Total Services & Charges Expenditures 10,677.67 211,222.39 4,750.23 215,972.62 253,491.00 37,518.38 14.80% Other Uses 452002 - Allocations-Admin Cost 4,770.00 52,468.00 - 52,468.00 57,238.00 4,770.00 8.33% 452009 - Allocations-Facilities Mgmt 233.00 2,565.00 - 2,565.00 2,798.00 233.00 8.33% Total Other Uses 5,003.00 55,033.00 - 55,033.00 60,036.00 5,003.00 8.33% Total Expenditures 94,994.96 1,414,964.32 27,157.42 1,442,121.74 1,551,873.00 109,751.26 7.07%