Loading...
HomeMy WebLinkAboutCCAC February 5, 2007 General Ledger Expense vs Budget By Dept User: mrustman Printed: 02105107 10:57:44 Period 01 - 13 Fiscal Year 2006 - 2006 2006 2006 2006 2006 2006 2006 2005 Account Number Description Budget MTD YTD Avail % Avail Est. P.YTD 2130 Community Center 44000 Community Center Salaries & Benefits 2130-44000-60110 Salaries - Regular 200,502.00 71,184.76 71,184.76 129,317.24 64.50 0.00 148,957.17 2130-44000-60210 FICA 12,431.00 4,275.87 4,275.87 8,155.13 65.60 0.00 8,068.13 2130-44000-60220 Medicare 2,907.00 1,000.07 1,000.07 1,906.93 65.60 0.00 1,886.94 2130-44000-60310 Health Insurance 12,956.00 7,046.04 7,046.04 5,909.96 45.62 0.00 11,793.77 2130-44000-60320 Dental Insurance 784.00 367.39 36i39 416.61 53.14 0.00 744.65 2130-44000-60330 Life Insurance 32.00 22.14 22.14 9.86 30.81 0.00 46.03 2130-44000-60340 Long-Term Disability 261.00 156.88 156.88 104.12 39.89 0.00 265.71 2130-44000-60410 PERA 12,030.00 3,903.73 3,903.73 8,126.27 67.55 0.00 5,537.15 2130-44000-60520 Workers Camp 2,506.00 2,506.00 2,506.00 0.00 0.00 0.00 2,146.00 2130-44000-60990 Inter-City Labor Allocation 10,205.00 0.00 0.00 10,205.00 100.00 0.00 0.00 Salaries & Benefits 254,614.00 90,462.88 90,4Q2.88 164,151.12 64.47 0.00 179,445.55 Departmental 2130-44000-61005 Supplies - General 3,000.00 612.91 612.91 2,387.09 79.57 0.00 2,543.92 2130-44000-61020 Supplies - Operating 17,500.00 14,169.27 14,169.27 3,330.73 19.03 0.00 28,154.68 2130-44000-61025 Supplies - Cleaning 5,000.00 0.00 0.00 5,000.00 100.00 0.00 971.83 2130-44000-61050 Supplies - Diesel Fuel 0.00 145.69 145.69 -145.69 0.00 0.00 0.00 2130-44000-61105 R & M Supplies - General 5,000.00 6.38 6.38 4,993.62 99.87 0.00 3,089.35 2130-44000-61120 R & M Supplies - Building 0.00 -96.91 -96.91 96.91 0.00 .0.00 3,594.68 2130-44000-61205 Small & Expend - Small Tools 2,500.00 1,680.88 1,680.88 819.12 32.76 0.00 506.29 2130-44000-61210 Small & Expend - Office Equipm 0.00 473.61 473.61 -473.61 0.00 0.00 790.23 2130-44000-61310 Meals I Lodging 1,000.00 0.00 0.00 1,000.00 100.00 0.00 1,093.45 2130-44000-61320 Annual Dues I Licenses 600.00 135.00 135.00 465.00 77.50 0.00 10.00 2130-44000-61410 Transportation I Mileage 600.00 103.24 103.24 496.76 82.79 0.00 352.25 Departmental 35,200.00 17,230.07 17,230.07 17,969.93 51.05 0.00 41,106.68 Operating 2130-44000-62005 Electric 175,000.00 132,759.87 132,759.87 42,240.13 24.14 0.00 124,973.53 2130-44000-62010 Water & Sewer Service 6,000.00 5,095.01 5,095.01 904.99 15.08 0.00 3,018.04 2130-44000-62015 Natural Gas 110,000.00 156,781.14 156,781.14 -46,781.14 -42.53 0.00 149,112.82 2130-44000-62020 Refuse Collection 2,200.00 4,038.22 4,038.22 -1,838.22 -83.56 0.00 3,108.75 2130-44000-62030 Telephone 4,600.00 5,439.78 5,439.78 -839.78 -18.26 0.00 4,772.33 2130044000-62100 Insurance 10,300.00 10,300.00 10,300.00 0.00 0.00 0.00 10,000.00 2130-44000-62200 Rentals 0.00 742.59 742.59 -742.59 0.00 0.00 8,213.49 2130-44000-62205 Central Equipment Services 3,605.00 3,605.00 3,605.00 0.00 0.00 0.00 3,500.00 2130-44000-62300 Equipment Maintenance Contract 0.00 4,666.91 4,666.91 -4,666.91 0.00 0.00 365.00 2130-44000-62305 Software Maintenance Contracts 0.00 481.18 481.18 -481.18 0.00 0.00 450.00 2006 2006 2006 2006 2006 2006 2005 Account Number Description Budget MTD YTD Avail % A vail Est. P-YTD Operating 311,705.00 323,909.70 323,909.70 -12,204.70 -3.92 0.00307,513.96 Professional Services 2130-44000-63005 Professional Services 5,000.00 2,258.50 2,258.50 2,741.50 54.83 0.00 1,440.00 2130-44000-63010 Contractual Services 5,000.00 8,366.91 8,366.91 -3,366.91 -67.34 0.00 1,188.21 2130-44000-63025 Publishiug 5,000.00 747.00 747.00 4,253.00 85.06 0.00 318.00 2130-44000-63030 Printing 0.00 7,491.83 7,491.83 -7,491.83 0.00 0.00 105.44 2130-44000-63105 R & M Labor - Building 0.00 3,342.88 3,342.88 -3,342.88 0.00 0.00 6,203.48 Professional Services 15,000.00 22,207.12 22,207.12 -7,207.12 -48.05 0.00 9,255.13 44000 Community Center 616,519.00 453,809.77 453,809.77 162,709.23 26.39 0.00 537,321.32 2006 2006 2006 2006 2006 2006 2005 Account Number Description Budget MTD YTD Avail % Avail Est. P- YTD 44100 Concessions Salaries & Benefits 2130-44100-60110 Salaries - Regular 0.00 43,526.70 43,526.70 -43,526.70 0.00 0.00 9,559.77 2130-44100-60210 FICA 0.00 2,658.73 2,658.73 -2,658.73 0.00 0.00 572.20 2130-44100-60220 Medicare 0.00 621.80 621.80 -621.80 0.00 0.00 133.87 2130-44100-60320 Dental Insurance 0.00 0.Q7 0.07 -0.07 0.00 0.00 0.00 2130-44100-60330 Life Insurance 0.00 0.01 0.01 -0.01 0.00 0.00 0.00 2130-44100-60410 PERA 0.00 1,035.66 1,035.66 -1,035.66 0.00 0.00 0.00 Salaries & Benefits 0.00 47,842.97 47,842.97 -47,842.97 0.00 0.00 10,265.84 Departmental 2130-44100-61005 Supplies - General 0.00 335.20 335.20 -335.20 0.00 0.00 655.94 2130-44100-61020 Supplies - Operating 0.00 9,568.63 9,568.63 -9,568.63 0.00 0.00 5,645.00 2130-44100-61025 Supplies - Cleaning 0.00 5.33 5.33 -5.33 0.00 0.00 0.00 2130-44100-61205 Small & Expend - Small Tools 0.00 420.00 420.00 -420.00 0.00 0.00 1,304.28 2130-44100-61210 Small & Expend - Office Equipm 0.00 403.60 403.60 -403.60 0.00 0.00 0.00 2130-44100-61245 Items for Resale 0.00 49,027.97 49,027.97 -49,027.97 0.00 0.00 16,245.62 2130-44100-61320 Annual Dues I Licenses 0.00 600.00 600.00 -600.00 0.00 0.00 938.50 Departmental 0.00 60,360.73 60,360.73 -60,360.73 0.00 0.00 24,789.34 Operating 2130-44100-62005 Electric 0.00 8,474.04 8,474.04 -8,474.04 0.00 0.00 5,265.64 2130-44100-62010 Water & Sewer Service 0.00 325.22 325.22 -325.22 0.00 0.00 60.96 2130-44100-62020 Refuse Collection 0.00 1,344.88 1,344.88 -1,344.88 0.00 0.00 379.00 2130-44100-62200 Rentals 0.00 1,671.51 1,671.51 -1,671.51 0.00 0.00 0.00 Operating 0.00 11,815.65 11,815.65 -11,815.65 0.00 0.00 5,705.60 Professional Services 2130-44100-63010 Contractual Services 0:00 1,573.31 1,573.31 -1,573.31 0.00 0.00 0.00 2130-44100-63100 R & M Labor - General 0.00 611.18 611.18 -611.18 0.00 0.00 194.50 Professional Services 0.00 2,184.49 2,184.49 -2,184.49 0.00 0.00 194.50 44100 Concessions 0.00 122,203.84 122,203.84 -122,203.84 0,00 0.00 40,955.28 2006 2006 2006 2006 2006 2006 2005 Account Number Description Budget MTD YTD A vail % Avail Est. P- YTD 44200 Pro Shop Departmental 2130-44200-61005 Supplies - General 0.00 290.62 290.62 -290.62 0.00 0.00 0.00 2130-44200-61020 Supplies - Operating 0.00 1,794.80 1,794.80 -1,794.80 0.00 0.00 0.00 2130-44200-61245 Items for Resale 0.00 796.34 796.34 -796.34 0.00 0.00 206.70 Departmental 0.00 2,881.76 2,881.76 -2,881.76 0.00 0.00 206.70 44200 Pro Shop 0.00 2,881.76 2,881.76 -2,881.76 0.00 0.00 206.70 2006 2006 2006 2006 2006 2006 2005 Account Number -Description Budget MTD YTD Avail % Avail Est. P-YTD 44300 Ice Arena Salaries & Benefits 2130-44300-60110 Salaries - Regular 0.00 97,979.74 97,979.74 -97,979.74 0.00 0.00 0.00 2130-44300-60210 FICA 0.00 5,786.15 5,786.15 -5,786.15 0.00 0.00 0.00 2130-44300-60220 Medicare 0.00 1,353.34 1,353.34 -1,353.34 0.00 0.00 0.00 2130-44300-60310 Health Insurance 0.00 5,230.05 5,230.05 -5,230.05 0.00 0.00 0.00 2130-44300-60320 Dental Insurance 0.00 437.80 437.80 -437.80 0.00 0.00 0.00 2130-44300-60330 Life Insurance 0.00 26.40 26.40 -26.40 0.00 0.00 0.00 2130-44300-60340 Long-Term Disability 0.00 185.32 185.32 -185.32 0.00 0.00 0.00 2130-44300-60410 . PERA 0.00 4,722.70 4,722.70 -4,722.70 0.00 0.00 0.00 Salaries & Benefits 0.00 115,721.50 115,721.50 -115,721.50 0.00 0.00 0.00 Departmental 2130-44300-61005 Supplies - General 0.00 454.14 454.14 -454.14 0.00 0.00 0.00 2130-44300-61020 Supplies - Operating 0.00 6,291.62 6,291.62 -6,291.62 0.00 0.00 0.00 2130-44300-61105 R & M Supplies - General 0:00 318.67 318.67 -318.67 0.00 0.00 0.00 2130-44300-61120 R & M Supplies - Building 0.00 754.48 754.48 -754.48 0.00 0.00 0.00 2130-44300-61310 Meals I Lodging 0.00 562.32 562.32 -562.32 0.00 0.00 0.00 2130-44300-61315 Continuing Education 0.00 500.00 500.00 -500.00 0.00 0.00 0.00 2130-44300-61410 Transportation I Mileage 0.00 5.00 5.00 -5.00 0.00 0.00 0.00 Departmental 0.00 8,886.23 8,886.23 -8,886.23 0.00 0.00 0.00 Professional Services 2130-44300-63005 Professional Services 0.00 3,230.00 3,230.00 -3,230.00 0.00 0.00 0.00 2130-44300-63010 Contractual Services 0.00 750.00 750.00 -750.00 0.00 0.00 0.00 2130-44300-63025 Publishing 0.00 200.00 200.00 -200.00 0.00 0.00 0.00 2130-44300-63100 R & M Labor - General 0.00 3,738.73 3,738.73 -3,738.73 0.00 0.00 0.00 2130-44300-63105 R & M Labor - Building 0.00 3,106.11 3,106.11 -3,106.11 0.00 0.00 0.00 Professional Services 0.00 11,024.84 11,024.84 -11,024.84 0.00 0.00 0.00 44300 Ice Arena 0.00 135,632.57 135,632.57 -135,632.57 0.00 0.00 0.00 2006 2006 2006 2006 2006 2006 2005 Account Number Descriptiou Budget MTD YTD Avail % Avail Est. P-YTD 44400 Fieldhouse Salaries & Benefits 2130-44400-60110 Salaries - Regular 0.00 18,256.96 18,256.96 -18,256.96 0.00 0.00 0.00 2130-44400-60210 FlCA 0.00 1,099.50 1,099.50 -1,099.50 0.00 0.00 0.00 2130-44400-60220 Medicare 0.00 257.23 257.23 -257.23 0.00 0.00 0.00 2130-44400-60410 PERA 0.00 3.23 3.23 -3.23 0.00 0.00 0.00 Salaries & Benefits 0.00 19,616.92 19,616.92 -19,616.92 0.00 0.00 0.00 Departmental 2130-44400-61005 Supplies - General 0.00 95.78 95.78 -95.78 0.00 0.00 0.00 2130-44400-61020 Supplies - Operating 0.00 8,040.22 8,040.22 -8,040.22 0.00 0.00 0.00 2130-44400-61120 R & M Supplies - Building 0.00 338.17 338.17 -338.17 0.00 0.00 0.00 2130-44400-61205 Small & Expend - Small Tools 0.00 2,454.83 2,454.83 -2,454.83 0.00 0.00 0.00 Departmental 0.00 10,929.00 10,929.00 -10,929.00 0.00 0.00 0.00 Operating 2130-44400-62200 Rentals 0.00 780.85 780.85 -780.85 0.00 0.00 0.00 Operating 0.00 780.85 780.85 -780.85 0.00 0.00 0.00 Professional Services 2130-44400-63005 Professional Services 0.00 2,137.00 2,137.00 -2,137.00 0.00 0.00 0.00 Professional Services 0.00 2,137.00 2,137.00 -2,137.00 0.00 0.00 0.00 44400 Fieldhouse 0.00 33,463.77 33,463.77 -33,463.77 0.00 0.00 0.00 2006 2006 2006 2006 2006 2006 2005 Account Number Description Budget MTD YTD Avail % Avail Est. P-YTD 44900 Comm Clf - Mise Other Financing Uses 2130-44900-67101 Operating Transfers Out 284,013.00 284,013.00 284,013.00 0.00 0.00 0.00 0.00 Other Financing Uses 284,013.00 284,013.00 284,013.00 0.00. 0.00 0.00 0.00 44900 Comm Clf - Mise 284,013.00 284,013.00 284,013.00 0.00 0.00 0.00 0.00 2006 2006 2006 2006 2006 2006 2005 Account Number Description Budget MTD YTD Avail % Avail Est. P-YTD 2130 Community Center 900,532.00 1,032,004.71 1,032,004.71 -131,472.71 -14.60 0.00 578,483.30 Expense Total 900,532.00 1,032,004.71 1,032,004.71 -131,472.71 -14.60 0.00 578,483.30 4 General Ledger Revenue vs Budget By Dept User: mrustman Printed: 02/05/0711:01:44 Period 01 - 13 Fiscal Year 2006 - 2006 2006 2006 2006 2006 2006 2006 2005 Account Number Description Budget MTD YTD Avail % Avail Est P.YTD 2130 Community Center 44000 Community Center Charges for Services 2130-44000-55505 Ice Rental 0.00 0.00 0.00 0.00 0.00 0.00 -275,443.53 2130-44000-55506 Ice Rental - Taxable 0.00 0.00 0.00 0.00 0.00 0.00 -22,576.16 2130-44000-55510 Open Skate 0.00 0.00 0.00 0.00 0.00 0.00 -6,738.60 2130-44000-55520 Fieldhouse Rental 0.00 -150.00 -150.00 150.00 0.00 0.00 -13,562.28 2130-44000-55521 Fieldhouse Rental - Taxable 0.00 0.00 0.00 0.00 0.00 0.00 -4,890.07 2130-44000-55522 Open Fieldhouse 0.00 0.00 0.00 0.00 0.00 0.00 -5,483.36 2130-44000-55530 Fee Admissions 0.00 0.00 0.00 0.00 0.00 0.00 -12,217.75 2130-44000-55550 Equipment Rental 0.00 -578.00 -578.00 578.00 0.00 0.00 -2,208.75 2130-44000-55570 Vending Machines -15,000.00 -10,083.33 -10,083.3 3 -4,916.67 32.78 0.00 -6,316.21 2130-44000-55580 Advertising 0.00 0.00 0.00 0.00 0.00 0.00 -7,415.67 Charges for Services "15,000.00 -10,811.33 -10,811.33 -4,188.67 27.92 0.00 -356,852.38 Miscellaneous Revenue 2130-44000-58100 Refunds & Reimbursements -60,000.00 -78,688.11 -78,688.11 18,688.11 -31.15 0.00 -38,677.20 2130-44000-58105 Rent 0.00 0.00 0.00 0.00 0.00 0.00 -288.83 Miscellaneous Revenue -60,000.00 -78,688.11 -78,688.11 18,688.11 -31.15 0.00 -38,966.03 44000 Community Center -75,000.00 -89,499.44 -89,499.44 14,499.44 -19.33 0.00 -395,818.41 2006 2006 2006 2006 2006 2006 2005 Account Number Description Budget MTD YTD Avail % Avail Est P-YTD 44100 Concessions Charges for Services 2130-44100-55540 Concessions -25,000.00 -108,032.89 -108,032.89 83,032.89 -332.13 0.00 -39,520.83 Charges for Services -25,000.00 -108,032.89 -108,032.89 83,032.89 -332.13 0.00 -39,520.83 44100 Concessions -25,000.00 -108,032,89 -108,032.89 83,032.89 -332.13 0.00 -39,520,83 2006 2006 2006 2006 2006 2006 2005 Account Number Description Budget MTD YTD Avail % Avail Est P-YTD 44200 Pro Shop Charges for Services 2130-44200-55515 Skate Sharpening -2,000.00 -1,599.00 -1,599.00 -401.00 20.05 0.00 0.00 2130-44200-55516 Merchandise 0.00 -2,561.50 -2,561.50 2,561.50 0.00 0.00 . -1,196.00 Charges for Services -2,000.00 -4,160.50 -4,160.50 2,160.50 -108.03 0.00 -1,196.00 44200 Pro Shop -2,000.00 -4,160.50 -4,160.50 2,160.50 -108.03 0.00 -1,196.00 2006 2006 2006 2006 2006 2006 2005 Account Number Description Budget MTD YTD Avail % Avail Est P-YTD 44300 Ice Arena Charges for Services 2130-44300-55505 Ice Rental -274,000.00 -258,325.50 -258,325.50 -15,674.50 5.72 0.00 0.00 2130-44300-55506 Ice Rental - Taxable 0.00 -36,171.53 -36,171.53 36,171.53 0.00 0.00 0.00 2130-44300-55510 Open Skate -10,000.00 -21,154.66 -21,154.66 11,154.66 -111.55 0.00 0.00 2130-44300-55530 Fee Admissions -9,000.00 -11,053.00 -11,053.00 2,053.00 -22.81 0.00 0.00 2130-44300-55570 Vending Machines 0.00 -1,848.77 -1,848.77 1,848.77 0.00 0.00 0.00 2130-44300-55580 Advertising -35,000.00 -12,090.50 -12,090.50 -22,909.50 65.46 0.00 0.00 Charges for Services -328,000.00 -340,643.96 -340,643.96 12,643.96 -3.85 0.00 0.00 Miscellaneous Revenue 2130-44300-58100 Refunds & Reimbursements -24,400.00 -24,441.30 -24,441.30 .41.30 -0.17 0.00 0.00 2130-44300-58130 Donations - Restricted 0.00 -1,150.00 -1,150.00 1,150.00 0.00 0.00 0.00 Miscellaneous Revenue -24,400.00 -25,591.30 -25,591.30 1,191.30 -4.88 0.00 0.00 44300 Ice Arena -352,400.00 -366,235.26 -366,235.26 13,835.26 -3.93 0.00 0.00 2006 2006 2006 2006 2006 2006 2005 Account Number Description Budget MTD YTD Avail %. A vail Est P-YTD 44400 Fieldhouse Charges for Services 2130-44400-55520 Fieldhouse Rental -40,000.00 -70,112.70 -70,112.70 30,112.70 -75.28 0.00 0.00 2130-44400-55521 Fieldhouse Rental - Taxable 0.00 -26,879.26 -26,879.26 26,879.26 0.00 0.00 0.00 2130-44400-55522 Open Fieldhouse 0.00 -18,483.78 -18,483.78 18,483.78 0.00 0.00 0.00 2130-44400-55570 Vending Machines 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2130-44400-55580 Advertising 0.00 -2,941.43 -2,941.43 2,941.43 0.00. 0.00 0.00 Charges for Services -40,000.00 -118,417.17 -118,417.17 78,417.17 -196.04 0.00 0.00 Miscellaneous Revenue 2130-44400-58100 Refunds & Reimbursements 0.00 -639.28 -639.28 639.28 0.00 0.00 0.00 2130-44400-58130 Donations - Restricted 0.00 -750.00 -750.00 750.00 0.00 0.00 0.00 Miscellaneous Revenue 0.00 -1,389.28 -1,389.28 1,389.28 0.00 0.00 0.00 44400 Fieldhouse -40,000.00 -119,806.45 -119,806.45 79,806.45 -199.52 0.00 0.00 2006 2006 2006 2006 2006 2006 2005 Account Number Description Budget MTD YTD Avail % Avail Est P-YTD 44900 Comm Ctr - Misc Investment Income 2130-44900-56910 Interest Earned -2,000.00 20,584.34 20,584.34 -22,584.34 1,129.22 0.00 -3,109.29 Investment Income -2,000.00 20,584.34 20,584.34 -22,584.34 1,129.22 0.00 -3,109.29 Miscellaneous Revenue 2130-44900-58100 Refunds' & Reimbursements 0.00 639.28 639.28 -639.28 0.00 0.00 0.00 2130-44900-58105 Rent 0.00 -1,417.14 -1,417.14 1,417.14 0.00 0.00 0.00 2130-44900-58130 Donations - Restricted -50,000.00 -71,139.57 -71,139.57 21,139.57 -42.28 0.00 -97,645.61 Miscellaneous Revenue -50,000.00 -71,917.43 -71,917.43 21,917.43 -43.83 0.00 -97,645.61 44900 Comm Ctr - Mise -52,000.00 -51,333.09 -51,333.09 -666.91 1.28 0.00 -100,754.90 2006 2006 2006 2006 2006 2006 2005 AccountNumber Description Budget MTD YTD Avail % Avail Est P-YTD 2130 Community Center -546,400.00 -739,067.63 -739,067.63 192,667.63 -35.26 0.00 -537,290.14 Revenue Total -546,400.00 -739,067.63 -739,067.63 192,667.63 35.26 0.00 -537,290.14