Loading...
HomeMy WebLinkAboutDec 22 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 900.00 270,522.20 172,000.00 (98,522.20) 157.28% 347004 - Golf Green Fees 1,169.00 853,864.32 805,000.00 (48,864.32) 106.07% 347005 - Golf Cart Rentals 605.54 397,434.48 365,000.00 (32,434.48) 108.89% 347006 - Golf Pro Shop Retail 2,647.41 76,797.52 59,500.00 (17,297.52) 129.07% 347007 - Golf Driving Range - 41,429.00 30,000.00 (11,429.00) 138.10% 347008 - Golf Gift Certificate - 35.00 - (35.00) 0.00% 347009 - Golf Outings - 7,808.89 - (7,808.89) 0.00% 347012 - Food Sales 3.50 74,066.61 53,277.00 (20,789.61) 139.02% 347013 - Nonalcoholic Beverage 4.68 40,580.71 31,500.00 (9,080.71) 128.83% 347014 - Alcoholic Beverage Sales 22.67 155,154.11 110,900.00 (44,254.11) 139.90% 347026 - Room Rental 75.00 19,266.49 10,000.00 (9,266.49) 192.66% 347100 - Concessions-Employee Discounts - (1,909.84) - 1,909.84 0.00% Total Culture & Recreation 5,427.80 1,935,049.49 1,637,177.00 (297,872.49) 118.19% Total Charges for Services 5,427.80 1,935,049.49 1,637,177.00 (297,872.49) 118.19% Fines, Forefeitures, Fees 351002 - Bad Checks Fines - 24.00 - (24.00) 0.00% Total Fines, Forfeitures, Fees - 24.00 - (24.00) 0.00% Miscellaneous Revenue 360000 - Miscellaneous 261.37 3,839.97 2,500.00 (1,339.97) 153.60% 367000 - Donations from Private Sources - 1,772.62 - (1,772.62) 0.00% Total Miscellaneous Revenue 261.37 5,612.59 2,500.00 (3,112.59) 224.50% Refunds & Reimbursements 380000 - Misc Reimbursements - 4,056.44 4,008.00 (48.44) 101.21% 396000 - Refunds - 8,611.40 5,673.00 (2,938.40) 151.80% Total Refunds & Reimbursements - 12,667.84 9,681.00 (2,986.84) 130.85% Total Revenue 5,689.17 1,953,353.92 1,649,358.00 (303,995.92) 118.43% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenses Salaries & Wages 410001 - Salaried Wages 27,374.80 344,954.13 - 344,954.13 363,677.00 18,722.87 94.85% 410002 - Teamster Wages 6,779.82 65,069.97 - 65,069.97 86,090.00 21,020.03 75.58% 410003 - Permanent Part Time 7,407.26 331,140.15 - 331,140.15 331,141.00 0.85 100.00% 410004 - Extra & Overtime 311.08 5,991.40 - 5,991.40 5,992.00 0.60 99.99% 410005 - Seasonal & Interns 18.00 51,638.38 - 51,638.38 51,639.00 0.62 100.00% 410007 - Longevity Pay - 250.00 - 250.00 600.00 350.00 41.67% Total Salaries & Wages 41,890.96 799,044.03 - 799,044.03 839,139.00 40,094.97 95.22% Employee Benefits 411001 - FICA Regular 3,067.79 60,608.18 - 60,608.18 64,409.00 3,800.82 94.10% 411004 - PERF Regular 3,825.96 47,360.77 - 47,360.77 56,557.00 9,196.23 83.74% 411005 - PERF Union 51.28 711.87 - 711.87 1,371.00 659.13 51.92% 411007 - Unemployment Comp 3.52 417.17 - 417.17 804.00 386.83 51.89% 411008 - Health Insurance 9,060.94 101,527.48 - 101,527.48 121,999.00 20,471.52 83.22% 411009 - Life Insurance 80.00 895.00 - 895.00 1,080.00 185.00 82.87% 411014 - Parental Leave 120.72 1,463.31 - 1,463.31 1,759.00 295.69 83.19% 411015 - Other Fringe Benefits - 290.00 - 290.00 300.00 10.00 96.67% December 31, 2022 411201 - Tool Allowance - - - - 800.00 800.00 0.00% 411203 - Job Readiness Allow. - 425.00 - 425.00 1,050.00 625.00 40.48% 411206 - Cell Phone Allowance 55.00 660.00 - 660.00 660.00 - 100.00% Total Employee Benefits 16,265.21 214,358.78 - 214,358.78 250,789.00 36,430.22 85.47% Total Personnel Expenses 58,156.17 1,013,402.81 - 1,013,402.81 1,089,928.00 76,525.19 92.98% Supplies Expenses Office Supplies 421000 - General Office Supplies 13.90 1,804.12 - 1,804.12 840.00 (964.12) 214.78% Total Office Supplies 13.90 1,804.12 - 1,804.12 840.00 (964.12) 214.78% Operating Supplies 422000 - Other Operating Supplies 6,792.16 74,327.83 - 74,327.83 69,655.20 (4,672.63) 106.71% 422002 - Diesel/CNG 2,349.00 14,113.45 - 14,113.45 11,811.00 (2,302.45) 119.49% 422003 - Gasoline 1,721.05 24,669.48 - 24,669.48 72,885.50 48,216.02 33.85% 422005 - Uniforms - 1,796.79 - 1,796.79 1,359.00 (437.79) 132.21% 422008 - Medical/Safety Supplies - 49.93 - 49.93 371.00 321.07 13.46% 422010 - Plants Chemicals Seed & Fertilizer 24,483.59 116,448.79 - 116,448.79 173,579.00 57,130.21 67.09% 422013 - Promotional Supplies - 499.80 - 499.80 500.00 0.20 99.96% 422014 - Concessions Inventory - 118,889.65 - 118,889.65 81,318.04 (37,571.61) 146.20% 422016 - Inventory For Sale 4,756.37 58,073.99 - 58,073.99 42,178.79 (15,895.20) 137.69% Total Operating Supplies 40,102.17 408,869.71 - 408,869.71 453,657.53 44,787.82 90.13% Repair & Maintenance Supplies 423000 - Other R&M Supplies 122.70 59,623.95 - 59,623.95 54,903.70 (4,720.25) 108.60% 423009 - Repair Parts - 2,555.80 - 2,555.80 2,700.00 144.20 94.66% Total Repair & Maintenance Supplies 122.70 62,179.75 - 62,179.75 57,603.70 (4,576.05) 107.94% Total Supplies Expenses 40,238.77 472,853.58 - 472,853.58 512,101.23 39,247.65 92.34% Services & Charges Expenses Professional Services 431000 - Other Professional Services 1,600.90 44,098.91 - 44,098.91 44,211.00 112.09 99.75% 431019 - Security Services 274.77 4,312.44 - 4,312.44 4,314.00 1.56 99.96% Total Professional Services 1,875.67 48,411.35 - 48,411.35 48,525.00 113.65 99.77% Communication & Transportation 432002 - Mailing 188.24 197.49 - 197.49 199.00 1.51 99.24% 432004 - Telecommunications - - - - 355.00 355.00 0.00% Total Communication & Transportation 188.24 197.49 - 197.49 554.00 356.51 35.65% Printing & Advertising 433001 - Outside Printing Services - 3,492.73 - 3,492.73 3,500.00 7.27 99.79% 433003 - Promotional 714.75 33,180.83 - 33,180.83 33,182.00 1.17 100.00% Total Printing & Advertising 714.75 36,673.56 - 36,673.56 36,682.00 8.44 99.98% Utilties 435001 - Electric 4,616.64 65,948.31 - 65,948.31 69,667.00 3,718.69 94.66% 435002 - Natural Gas 2,594.98 19,090.45 - 19,090.45 22,519.00 3,428.55 84.77% Total Utilities 7,211.62 85,038.76 - 85,038.76 92,186.00 7,147.24 92.25% Repairs & Maintenance 436000 - Other R&M 3,651.45 10,271.02 - 10,271.02 26,614.54 16,343.52 38.59% 436001 - Building R&M 80.81 80.81 - 80.81 81.00 0.19 99.77% 436005 - Other Equip R&M - 524.70 - 524.70 1,000.00 475.30 52.47% Total Repairs & Maintenance 3,732.26 10,876.53 - 10,876.53 27,695.54 16,819.01 39.27% Rentals 437002 - Equipment Rental 950.82 1,507.32 - 1,507.32 1,508.00 0.68 99.95% Total Rentals 950.82 1,507.32 - 1,507.32 1,508.00 0.68 99.95% Debt Service 438100 - Principal - 67,578.98 - 67,578.98 67,579.00 0.02 100.00% 438200 - Interest - 5,237.43 - 5,237.43 5,238.00 0.57 99.99% Total Debt Service - 72,816.41 - 72,816.41 72,817.00 0.59 100.00% Other Charges & Services 439000 - Misc Charges & Svcs - 4,374.60 - 4,374.60 6,359.00 1,984.40 68.79% 439002 - Licenses & Permits 2,000.00 5,493.63 - 5,493.63 5,501.00 7.37 99.87% 439003 - Subscriptions 64.99 1,725.38 - 1,725.38 1,731.00 5.62 99.68% 439004 - Dues & Memberships - 1,171.33 - 1,171.33 3,471.00 2,299.67 33.75% 439005 - Bank & Credit Card Fees 317.70 46,634.11 - 46,634.11 46,835.00 200.89 99.57% 439006 - Education & Training - 1,180.92 - 1,180.92 1,181.00 0.08 99.99% 439009 - Trash Removal 366.22 14,590.63 - 14,590.63 14,694.41 103.78 99.29% 439099 - Cashier Over/Short (0.04) (543.78) - (543.78) - 543.78 0.00% 439100 - Refunds/Awards/Indemnities - 960.81 - 960.81 962.00 1.19 99.88% Total Other Services & Charges 2,748.87 75,587.63 - 75,587.63 80,734.41 5,146.78 93.63% Total Services & Charges Expenses 17,422.23 331,109.05 - 331,109.05 360,701.95 29,592.90 91.80% Capital Outlay Machinery & Equipment 445006 - Computer Equip/Network - 17,007.12 - 17,007.12 17,011.00 3.88 99.98% Total Machinery & Equipment - 17,007.12 - 17,007.12 17,011.00 3.88 99.98% Total Capital Expenses - 17,007.12 - 17,007.12 17,011.00 3.88 99.98% Other Uses 452002 - Allocations-Admin Cost 9,924.00 59,544.00 - 59,544.00 59,544.00 - 100.00% 452003 - Allocations-IT 11,189.34 67,136.00 - 67,136.00 67,136.00 - 100.00% 452004 - Allocations-Liability Insurance 1,741.84 10,451.00 - 10,451.00 10,451.00 - 100.00% 452009 - Allocations-Facilities Mgmt 590.50 3,543.00 - 3,543.00 3,543.00 - 100.00% Total Other Uses 23,445.68 140,674.00 - 140,674.00 140,674.00 - 100.00% Bad Debt Expense 490000 - Bad Debt Expense - 100.00 - 100.00 - (100.00) 0.00% Total Bad Debt Expense - 100.00 - 100.00 - (100.00) 0.00% Total Expenses 139,262.85 1,975,146.56 - 1,975,146.56 2,120,416.18 145,269.62 93.15%