Loading...
HomeMy WebLinkAbout[04e] Treasuer's Reportrrr- or~r.~~~arH MEETING DATE: June 5, 2008 Council Agenda Item 4 e AGENDA ITEM: Treasurer's Report -Requested Action: Accept the April 2008 Treasurer's Report. SUBMITTED BY: Finance BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: None BACKGROUND INFORMATION: April 2008 reconciled cash/investment and budget to actual position for Council review. BUDGET/FISCAL IMPACT: None ATTACHMENTS: April 2008 Financial Reports REQUESTED COUNCIL ACTION: Accept the April 2008 Treasurer's Report as presented. CITY OF ST JOSEPH Cash and Investment- Council Report Current Period: Aprtl 2008 YTD YTD MTD MTD Current FUND FUND Descr Begin Yr Debit Credit Debit Credit Balance 101 General $718,994.10 $162,245.22 $866,415.87 $39,950.15 $209,997.57 $14,823.45 105 Fire Fund $463,459.20 $124,951.89 $84,740.67 $21,546.79 $6,958.89 $503,670.42 108 Cable Access Fee $10,899.41 $3,388.80 $1,519.52 $493.80 $0.00 $12,768.69 150 Economic Development $30,981.57 $1,280.84 $17,929.79 $562.55 $2,431.10 $14,332.62 155 TIF 1-3 Borgert (SKN) $4,877.97 $144.09 $68.50 $15.10 $1.79 $4,953.56 156 TIF 1~ St. Jce Developmen $39,643.59 $1,157.00 $547.31 $122.71 $14.54 $40,253.28 157 TIF 2-1 Millstream $10,778.20 $315.98 $4,999.75 $33.36 $4,853.95 $6,094.43 200 State Collected Sales Tax $398,283.22 $93,178.04 $12,559.92 $16,077.41 $7,513.56 $478,901.34 205 Park Dedication $60,418.08 $1,727.96 $4,105.65 $177.28 $90.56 $58,040.39 210 Recreation Center $45,913.82 $1,337.76 $632.38 $142.11 $16.84 $46,619.20 230 Lake Wobegon Trail $2.92 $20.02 $0.00 $0.02 $0.00 $22.94 232 City Beautification-College $59.11 $10,010.29 $1.22 $10.29 $1.22 $10,068.18 250 Revolving Loan Fund $50,121.12 $1,460.32 $690.32 $155.14 $18.39 $50,891.12 307 2004 Equipment Certificate $6,318.53 $1,012.38 $8.62 $22.44 $2.66 $7,322.29 320 2007 Refunding (98/99 St B $414,767.74 $12,125.45 $5,712.77 $1,283.92 $152.17 $421,180.42 321 Joseph Street Improvement $30,932.03 $1,263.02 $427.07 $96.89 $11.48 $31,767.98 322 City Hall Refunded, 2005 $449.50 $1,196.08 $0.20 $1.68 $0.20 $1,645.38 323 20041mprovements/Northla $184,621.02 $5,584.90 $2,543.48 $572.10 $67.80 $187,662.44 325 2002 Street Improvement $676,330.37 $19,092.80 $6,373.41 $1,485.16 $176.01 $689,049.76 328 2003 Liberty Pointe Street I $335,425.25 $18,796.24 $4,630.41 $1,065.70 $126.30 $349,591.08 329 2003 Maintenance Facility $405.57 $756.54 $0.14 $1.19 $0.14 $1,161.97 331 2003 Refunding Fire Hall $130,662.44 $34,593.66 $3,557.99 $10,884.75 $50.81 $161,698.11 332 2003 Cross Over (93 Street $180,854.04 $5,583.04 $2,491.47 $560.75 $66.46 $183,945.61 333 2005 Improve (HilUClover) $561,077.97 $16,679.69 $7,727.87 $1,737.65 $205.94 $570,029.79 335 Northland Heightslfrans Co $600,966.55 $53,184.03 $31,894.48 $4,019.71 $476.40 $622,256.10 337 2006 Equipment Certificate $5,517.17 $970.90 $78.03 $19.63 $2.33 $6,410.04 338 2006 Interior St Improveme $554,153.55 $29,616.70 $13,716.17 $2,901.92 $343.92 $570,054.08 341 2007 St Imprv-E Side/Jade/ $625,993.93 $92,651.48 $32,823.60 $29,341.35 $530.06 $685,821.81 342 2008 Equipment Certificate $0.00 $15,743.94 $3,552.50 $15,743.94 $3,552.50 $12,191.44 390 Debt Service Relief $60,516.25 $4,114.85 $1,788.71 $390.46 $46.28 $62,842.39 435 Northland Heightslfrans Co $702,669.96 $7,028.46 $28,903.89 $0.00 $14,823.54 $680,794.53 438 2006 Interior St Improveme $436,557.41 $0.00 $182,353.01 $0.00 $20,492.25 $254,204.40 441 2007 Street Impr (Jade Rd/ $826,249.63 $0.00 $71,412.25 $0.00 $52,799.30 $754,837.38 442 2008 Equipment Certificate $0.00 $325,771.13 $134,899.04 $274,310.00 $36,061.67 $190,872.09 490 Capital Outlay $274,834.83 $66,218.58 $86,170.86 $0.00 $0.00 $254,882.55 501 Water Extension $844,788.18 $24,614.09 $11,635.53 $2,614.82 $309.90 $857,766.74 502 Sewer Extension $828,794.42 $28,110.61 $13,288.39 $2,986.27 $353.92 $843,616.64 601 Water Fund $1,420,353.14 $170,364.55 $720,778.44 $42,352.83 $137,484.39 $869,939.25 602 Sewer Fund $1,000,465.47 $137,335.76 $169,298.16 $35,024.34 $39,295.96 $968,503.07 603 Refuse Collection $266,814.96 $98,782.99 $103,247.57 $33,996.78 $22,562.53 $262,350.38 651 Storm Water Utility $294,715.41 $43,237.38 $16,821.62 $12,690.65 $2,145.93 $321,131.17 $13,099,667.63 $1,615,647.46 $2,650,346.58 $12,064,968.51 05/27/08 4:15 PM Page 1 CITY OF ST JOSEPH Council Month End Revenue Summary Current Period: April 2008 2008 2008 YTD April 2008 2008 YTD °k of FUND FUND Descr Budget 2008 Amt YTD Amt Balance Budget 101 General $441,250.00 $16,269.69 $51,621.77 $389,628.23 11.70% 105 Fire Fund $246,800.00 $21,374.04 $73,469.00 $173,331.00 29.77% 108 Cable Access Fee $0.00 $493.80 $455.68 -$455.68 0.00% 150 Economic Development $3,000.00 $50.09 -$28.89 $3,028.89 -0.96% 155 TIF 1-3 Borgert (SKN) $0.00 $13.31 $15.11 -$15.11 0.00% 156 TIF 1-4 St. Jce Development $0.00 $108.17 $255.55 -$255.55 0.00% 157 TIF 2-1 Millstream $0.00 $29.41 $89.40 -$89.40 0.00% 200 State Collected Sales Tax $0.00 $8,563.85 $11,721.07 -$11,721.07 0.00% 205 Park Dedication $0.00 $156.27 -$4.93 $4.93 0.00% 210 Recreation Center $0.00 $125.27 $332.79 -$332.79 0.00% 230 Lake Wobegon Trail $0.00 $0.02 $20.02 -$20.02 0.00% 232 City Beautification-College Av $0.00 $9.07 $9.07 -$9.07 0.00% 250 Revolving Loan Fund $0.00 $136.75 $363.27 -$363.27 0.00% 307 2004 Equipment Certificates $0.00 $19.78 $48.83 -$48.83 0.00% 320 2007 Refunding (98/99 St Bon $0.00 $1,131.75 $2,825.64 -$2,825.64 0.00% 321 Joseph Street Improvement $0.00 $85.41 -$105.25 $105.25 0.00% 322 City Hall Refunded, 2005 $0.00 $1.48 $1.48 -$1.48 0.00% 323 20041mprovements/Northland $0.00 $504.30 $886.93 -$886.93 0.00% 325 2002 Street Improvement $0.00 $1,309.15 $5,996.11 -$5,996.11 0.00% 328 2003 Liberty Pointe Street Imp $0.00 $939.40 $9,826.81 -$9,826.81 0.00% 329 2003 Maintenance Facility $0.00 $1.05 $1.05 -$1.05 0.00% 331 2003 Refunding Fire Hall $43,070.00 $10,833.94 $31,274.99 $11,795.01 72.61°~ 332 2003 Cross Over (93 Streets) $0.00 $494.29 $914.86 -$914.86 0.00% 333 2005 Improve (HilUClover) $0.00 $1,531.71 $1,152.27 -$1,152.27 0.00% 335 Northland HeightslTrans Corri $0.00 $3,543.31 $7,008.37 -$7,008.37 0.00% 337 2006 Equipment Certificate $0.00 $17.30 $77.21 -$77.21 0.00% 338 2006 Interior St Improvements $0.00 $2,558.00 $6,325.25 -$6,325.25 0.00% 341 2007 St Imprv-E Side/Jade/8 $0.00 $28,811.29 $41,238.97 -$41,238.97 0.00% 342 2008 Equipment Certificates $0.00 $15,743.94 $15,743.94 -$15,743.94 0.00% 390 Debt Service Relief $0.00 $344.18 $1,151.58 -$1,151.58 0.00% 442 2008 Equipment Certificates $0.00 $274,310.00 $274,310.00 -$274,310.00 0.00% 501 Water Extension $0.00 $2,304.92 $5,917.65 -$5,917.65 0.00% 502 Sewer Extension $0.00 $2,632.35 $6,761.71 -$6,761.71 0.00% 601 Water Fund $473,250.00 $41,820.16 $52,848.99 $420,401.01 11.17°k 602 Sewer Fund $482,650.00 $34,644.69 -$36,836.44 $519,486.44 -7.63% 603 Refuse Collection $275,770.00 $32,369.54 $34,363.49 $241,406.51 12.46% 651 Slorm Water Utility $84,700.00 $12,579.57 $18,469.03 $66,230.97 21.81% $2,050,490.00 $515,861.25 $618,522.38 $1,431,967.62 30.16% 05/27/08 4:01 PM Page 1 CITY OF ST JOSEPH Council Month End Revenue -General Fund Current Period: April 2008 2008 Of FUND 2008 YTD April 2008 2008 YTD Budget FUND Descr SOURCE Descr Budget 2008 Amt YTD Amt Balance Remain FUND 1 01 General 101 General State Sales Tax $5,100.00 $3.15 $25.20 $5,074.80 99.51% 101 General Electric Franchise $45,000.00 $1,384.51 $4,142.61 $40,857.39 90.79% 101 General Beer $2,000.00 $66.64 $66.64 $1,933.36 96.67% 101 General Liquor $17,000.00 $33.34 $33.34 $16,966.66 99.80% 101 General Gambling Permits $0.00 $0.00 $50.00 -$50.00 0.00% 101 General AmusemenUHunting Permi $2,000.00 $0.00 $330.00 $1,670.00 83.50% 101 General Excavation Permit $1,000.00 $0.00 $100.00 $900.00 90.00% 101 General Building Permits $200,000.00 $1,786.83 $6,664.02 $193,335.98 96.67% 101 General Animal License $2,000.00 $250.00 $375.00 $1,625.00 81.25% 101 General Rental Housing Registratio $15,000.00 $100.00 $150.00 $14,850.00 99.00% 101 General State Aid, Municipal Funds $0.00 $0.00 $3,067.50 -$3,067.50 0.00% 101 General Zoning and Subdivision Fe $2,000.00 $0.00 $115.00 $1,885.00 94.25% 101 General Land Use Deposit Fee $20,000.00 $0.00 $1,500.00 $18,500.00 92.50% 101 General Sale of Maps and Publicati $500.00 $7.25 $31.75 $468.25 93.65% 101 General Assessments and research $5,000.00 $540.00 $1,297.00 $3,703.00 74.06% 101 General Special Hearing $4,000.00 $0.00 $1,350.00 $2,650.00 66.25% 101 General Administration Reimb $11,250.00 $4.00 -$16.00 $11,266.00 100.14% 101 General Park Fees $5,000.00 $330.00 $2,310.00 $2,690.00 53.80% 101 General Kennel Fees $1,000.00 $92.00 $285.00 $715.00 71.50% 101 General County Fines $45,000.00 $4,068.16 $12,494.69 $32,505.31 72.23% 101 General Policy Fines $27,000.00 $3,585.00 $7,135.00 $19,865.00 73.57% 101 General Accident Report Fee $1,500.00 $78.00 $283.50 $1,216.50 81.10% 101 General Seized Property $1,500.00 $125.00 $1,240.50 $259.50 17.30% 101 General Special Assessments $1,200.00 $0.00 $5.50 $1,194.50 99.54% 101 General Interest Earnings $25,000.00 $1,805.48 $4,361.31 $20,638.69 82.55% 101 General Interest Charges $300.00 $0.00 -$20.00 $320.00 106.67% 101 General Water Tower Antenna Leas $1,200.00 $25.36 $292.24 $907.76 75.65% 101 General Contributions -Parks $200.00 $16.63 $16.63 $183.37 91.69% 101 General Reimbursement $500.00 $1,968.34 $3,935.34 -$3,435.34 -687.07% FUND 101 General $441,250.00 $16,269.69 $51,621.77 $389,628.23 88.30% FUND 105 Fire Fund 105 Fire Fund Federal Grants -Other $0.00 $700.00 $700.00 -$700.00 0.00% 105 Fire Fund State Grants and Aids $50,000.00 $0.00 $3,000.00 $47,000.00 94.00% 105 Fire Fund Special Fire Service $178,800.00 $19,164.22 $65,004.19 $113,795.81 63.64% 105 Fire Fund Fire Hall Rental $3,000.00 $225.00 $1,250.00 $1,750.00 58.33% 105 Fire Fund Interest Earnings $15,000.00 $1,284.82 $3,514.81 $11,485.19 76.57% FUND 105 Fire Fund $246,800.00 $21,374.04 $73,469.00 $173,331.00 70.23% FUND 108 Cable Access Fee 108 Cable Access Cable Franchise Fee $0.00 $493.80 $455.68 -$455.68 0.00% FUND 108 Cable Acces s Fee $0.00 $493.80 $455.68 -$455.68 0.00% FUND 150 Economic Development 150 Economic Dev Interest Earnings $3,000.00 $50.09 -$28.89 $3,028.89 100.96% FUND 150 Economic Development $3,000.00 $50.09 -$28.89 $3,028.89 100.96% FUND 155 TIF 1-3 Borgert (SKN) 155 TIF 1-3 Gorge Interest Earnings $0.00 $13.31 $15.11 -$15.11 0.00% FUND 155 TIF 1-3 Borgert (SKN) $0.00 $13.31 $15.11 -$15.11 0.00% FUND 156 71F 1-4 St. Joe Development 156 TIF 1~ St. Jo Interest Earnings $0.00 $108.17 $255.55 -$255.55 0.00% FUND 156 TIF 1-4 St. Joe Development $0.00 $108.17 $255.55 -$255.55 0.00% 05/27/08 4:02 PM Page 1 CITY OF ST JOSEPH Council Month End Revenue -General Fund Current Period: April 2008 2008 of FUND 2008 YTD April 2008 2008 YTD Budget FUND Descr SOURCE Descr Budget 2008 Amt YTD Amt Balance Remain FUND 157 TIF 2-1 Millstream 157 TIF 2-1 Millstr Interest Earnings $0.00 $29.41 $89.40 -$89.40 0.00% FUND 157 TIF 2-1 Millstream $0.00 $29.41 $89.40 -$89.40 0.00% $691,050.00 $38,338.51 $125,877.62 $565,172.38 81.78% 05/27/08 4:02 PM Page 2 CITY OF ST JOSEPH Council Month End Expenditure -General Fund Current Period: Apri12008 2008 2008 2008 YTD April 2008 YTD % YTD Description DEPART Descr Budget 2008 Amt YTD Amt Balance Balance FUND 101 General General Council $50,715.00 $3,124.25 $22,588.99 $28,126.01 55.00% General Legislative Committie $6,040.00 $612.50 $961.51 $5,078.49 84.00% General Ordinance 8 Proceedi $8,000.00 $830.70 $1,889.86 $6,110.14 76.00% General Mayor $11,700.00 $581.56 $592.62 $11,107.18 95.00% General Salaries 8 Adminstrati $210,185.00 $16,330.27 $64,751.07 $145,433.93 69.00% General Acxounting $161,315.00 $11,547.48 $49,530.67 $111,784.33 69.00% General Audit Service $28,000.00 $10,000.00 $25,000.00 $3,000.00 11.00% General City Attorney $25,000.00 $2,900.40 $8,048.52 $16,951.48 68.00% General Planning and Zonning $4,000.00 $7,929.60 $7,929.60 -$3,929.60 -98.00% General Community Center $29,035.00 $3,694.12 $9,222.53 $19,812.47 68.00% General City Offices $27,050.00 $896.89 $5,142.12 $21,907.88 81.00% General Cable Access $9,435.00 $753.55 $2,498.02 $6,936.98 74.00% General Crime Control & Inves $763,430.00 $57,309.69 $240,382.87 $523,047.13 69.00% General Police Training $11,500.00 $595.90 $1,128.83 $10,371.17 90.00% General Communication Servic $9,500.00 $971.28 $7,531.97 $1,968.03 21.00% General Automotive Services $57,680.00 $5,062.21 $13,775.62 $43,904.38 76.00% General Building Inspec. Admi $135,050.00 $9,597.44 $27,822.44 $107,227.56 79.00% General Emergency Managem $1,850.00 $6.36 $758.68 $1,091.32 59.00% General Signal Lights $750.00 $64.65 $102.39 $647.61 86.00% General Animal Control $1,400.00 $55.49 $725.13 $674.87 48.00% General Street Maintanence $207,335.00 $26,114.80 $78,373.49 $128,961.51 62.00% General Ice 8 Snow Removal $50,360.00 $5,958.19 $29,511.48 $20,848.52 41.00% General Engineering Fee $40,000.00 $11,138.48 $15,120.99 $24,879.01 62.00% General Street Lighting $36,000.00 $5,233.76 $11,546.46 $24,453.54 68.00% General Street Cleaning $18,005.00 $2,540.84 $3,866.93 $14,138.07 79.00% General Ball Park and Skating $4,400.00 $316.42 $2,193.83 $2,206.17 50.00% General Maint Shop $21,700.00 $2,167.42 $8,127.59 $13,572.41 63.00% General Park Areas $146,260.00 $4,837.82 $39,869.05 $106,390.95 73.00% General Fire Protection $85,105.00 $0.00 $29,278.05 $55,826.95 66.00% FUND 101 General $2,160,800.00 $191,172.07 $708,271.51 $1,452,528.49 67.00% FUND 105 Fire Fund Fire Fund Fire Administration $2,800.00 $347.72 $2,488.59 $311.41 11.00% Fire Fund Fire Fighting $118,800.00 $565.72 $23,085.74 $95,714.26 81.00% Fire Fund Fire Training $5,000.00 $1,862.00 $10,108.05 -$5,108.05 -102.00% Fire Fund Fire Communications $4,000.00 $428.80 $1,808.92 $2,191.08 55.00% Fire Fund Medical Services $1,500.00 $45.18 $154.38 $1,345.62 90.00% Fire Fund Fire Station and Buildi $15,600.00 $3,535.72 $8,883.85 $6,716.15 43.00% Fire Fund Community Room $500.00 $0.00 $29.31 $470.69 94.00% FUND 105 Fire Fund $148,200.00 $6,786.14 $46,558.84 $101,641.16 69.00% FUND 150 Economic Development Economic De Economic Developme $38,450.00 $1,918.64 $14,813.24 $23,636.76 61.00% FUND 150 Economic Development $38,450.00 $1,918.64 $14,813.24 $23,636.76 61.00% 05/27/08 4:00 PM Page 1 $2,347,450.00 $199,876.85 $769,643.59 $1,577,806.41 67.00% CITY OF ST JOSEPH Council Month End Expenditure -Enterprise Funds Current Period: April 2008 2008 20pg 2008 YTD April 2008 YTD %YTD Description DEPART Descr Budget 2008 Amt YTD Amt Balance Balance FUND 601 Water Fund Water Fund Bond Payment (P ti I) $657,660.00 $49,280.00 -$355,555.00 $1,013,215.00 154.00% Water Fund Other Financing Uses $50,000.00 $0.00 $0.00 $50,000.00 100.00% Water Fund Power and Pumping $13,600.00 $1,151.26 $2,752.00 $10,848.00 80.00% Water Fund Purification $13,225.00 $3,679.90 $5,511.45 $7,713.55 58.00% Water Fund Purification-Plant 2 $39,600.00 $3,470.29 $18,993.69 $20,606.31 52.00% Water Fund Distribution $25,200.00 $0.00 $5,420.14 $19,779.86 78.00% Water Fund CIP-Treatment Plant $0.00 $51,256.00 -$3,377.58 $3,377.58 0.00% Water Fund CIP-Trunk Water Mains $0.00 $0.00 $0.00 $0.00 0.00% Water Fund CIP-Municipal Wells $0.00 $0.00 $0.00 $0.00 0.00% Water Fund CIP-Wellhead Protection $1,000.00 $0.00 $0.00 $1,000.00 100.00% Water Fund Storage $2,400.00 $267.16 $938.55 $1,461.45 61.00°~ Water Fund Storage-Tower 2 $0.00 $0.00 $16,750.00 -$16,750.00 0.00% Water Fund Wa Meter Installation $413,000.00 $0.00 $70,060.42 $342,939.58 83.00% Water Fund Administration and Gene $202,245.00 $27,847.11 $377,961.17 -$175,716.17 -87.00% Water Fund Depreciation Expense $0.00 $0.00 $0.00 $0.00 0.00% FUND 601 Water Fund $1,417,930.00 $136,951.72 $139,454.84 $1,278,475.16 90.00% FUND 602 Sewer Fund Sewer Fund Bond Payment (P 8 I) $48,690.00 $0.00 -$26,974.00 $75,664.00 155.00% Sewer Fund Other Financing Uses $50,000.00 $0.00 $0.00 $50,000.00 100.00% Sewer Fund Sanitary Sewer Maintena $157,585.00 $18,307.65 $24,968.49 $132,616.51 84.00% Sewer Fund Lift Station-Baker Street $4,000.00 $260.74 $1,711.18 $2,288.82 57.00% Sewer Fund Lift Station-DBL Labs Ar $3,500.00 $257.56 $1,670.22 $1,829.78 52.00% Sewer Fund Lift Station-Northland $2,800.00 $229.75 $1,554.72 $1,245.28 44.00% Sewer Fund Lift Station-CR 121 $3,000.00 $244.22 $2,870.18 $129.82 4.00% Sewer Fund Sewage Tneatment Plant $216,020.00 $14,095.28 $55,273.35 $160,746.65 74.00% Sewer Fund Administration and gener $45,255.00 $5,521.11 $16,656.95 $28,598.05 63.00% Sewer Fund Depreciation Expense $0.00 $0.00 $0.00 $0.00 0.00% FUND 602 Sewer Fund $530,850.00 $38,916.31 $77,731.09 $453,118.91 85.00°k FUND 603 Refuse Collection Refuse Colle Waste Collection $275,770.00 $20,935.29 $67,384.31 $208,385.69 76.00% Refuse Colle Other Financing Uses $0.00 $0.00 $0.00 $0.00 0.00% FUND 603 Refuse Collection $275,770.00 $20,935.29 $67,384.31 $208,385.69 76.00°~ FUND 651 Storm Water Utility Storm Water Other Financing Uses $69,275.00 $0.00 $0.00 $69,275.00 100.00% Storm Water Storm Water Administrate $3,300.00 $2,034.85 $12,627.60 -$9,327.60 -283.00% Storm Water Depreciation 6cpense $0.00 $0.00 $0.00 $0.00 0.00°~ FUND 651 Storm Water Utility $72,575.00 $2,034.85 $12,627.60 $59,947.40 83.00% 05/27108 4:01 PM Page 1 $2,297,125.00 $198,838.17 $297,197.84 $1,999,927.16 87.00% CITY OF ST JOSEPH Council Month End Revenue -Enterprise Funds Current Perlod: April 2008 2008 % of FUND 2008 YTD April 2008 2008 YTD Budget FUND Descr SOURCE Descr Budget 2008 Amt YTD Amt Balance Remain FUND 601 Water Fund 601 Water Fund Special Assessments $1,550.00 $0.00 -$10,542.96 $12,092.96 780.19% 601 Water Fund Interest Eamings $50,000.00 $2,720.40 $6,296.15 $43,703.85 87.41% 601 Water Fund Water Tower Antenna Lease $22,000.00 $471.71 $5,512.04 $16,487.96 74.95% 601 Water Fund Reimbursement $0.00 $0.00 -$704.00 $704.00 0.00% 601 Water Fund Rate Class One $300,000.00 $25,985.52 $32,296.54 $267,703.46 89.23% 601 Water Fund Bulk Water $0.00 $30.00 $30.00 -$30.00 0.00% 601 Water Fund Undesignated Funds $0.00 $760.07 $2,623.73 -$2,623.73 0.00% 601 Water Fund Penalties and Forfeited Disc $500.00 $375.57 $1,966.46 -$1,466.46 -293.29% 601 Water Fund Water Surcharge - (Monthly) $90,000.00 $10,220.65 $13,822.56 $76,177.44 84.64% 601 Water Fund MDS Test Fee $9,000.00 $1,141.45 $1,302.22 $7,697.78 85.53% 601 Water Fund State Sales Tax $200.00 $114.79 $246.25 -$46.25 -23.13% FUND 601 Water Fund $473,250.00 $41,820.16 $52,848.99 $420,401.01 88.83% FUND 602 Sewer Fund 602 Sewer Fund St. Benedict Sewer Charges $187,300.00 $0.00 -$61,068.84 $248,368.84 132.60% 602 Sewer Fund Special Assessments $555.00 $0.00 -$23,504.31 $24,059.31 t335.01% 602 Sewer Fund Sanitary Sewer Service $206,795.00 $23,685.10 $26,395.86 $180,399.14 87.24% 602 Sewer Fund Penalties and Forfeited Disc $2,000.00 $344.70 $1,306.80 $693.20 34.66% 602 Sewer Fund Sewer Line Charge $50,000.00 $7,791.12 $22,537.51 $27,462.49 54.92% 602 Sewer Fund Sewer Surcharge - (Monthly) $1,000.00 $0.00 -$11,740.46 $12,740.461274.05% 602 Sewer Fund Interest Eamings $35,000.00 $2,823.77 $9,237.00 $25,763.00 73.61 % FUND 602 Sewer Fund $482,650.00 $34,644.69 -$36,836.44 $519,486.44 107.63% FUND 603 Refuse Collection 603 Refuse Collec State Sales Tax $17,000.00 $1,512.81 -$1,312.30 $18,312.30 107.72% 603 Refuse Collec Licenses 8 Permits $8,000.00 $3,110.00 $3,110.00 $4,890.00 61.13% 603 Refuse Collec Refuse Collection Charges $237,170.00 $26,669.38 $30,167.26 $207,002.74 87.28% 603 Refuse Collec Penalties and Forfeifted Disc $2,000.00 $389.93 $1,883.53 $116.47 5.82% 603 Refuse Collec Special Assessments $1,600.00 $0.00 -$1,632.56 $3,232.56 202.04% 603 Refuse Collec Interest Eamings $10,000.00 $687.42 $2,147.56 $7,852.44 78.52% FUND 603 Refuse Collection $275,770.00 $32,369.54 $34,363.49 $241,406.51 87.54% FUND 651 Storm Water Utility 651 Storm Water Penalties and Forteifted Disc $500.00 $141.37 $556.97 -$56.97 -11.39% 651 Storm Water Special Assessments $1,200.00 $0.00 -$1,218.55 $2,418.55 201.55% 651 Storm Water Interest Earnings $3,000.00 $826.15 $3,692.15 -$692.15 -23.07% 651 Storm Water Rate Class One $80,000.00 $11,612.05 $15,438.46 $64,561.54 80.70% FUND 651 Storm Water Utility $84,700.00 $12,579.57 $18,469.03 $66,230.97 78.19% 05/27/08 4:02 PM Page 1 $1,316,370.00 $121,413.96 $68,845.07 $1,247,524.93 94.77% CITY OF ST JOSEPH Council Month End Expenditure Summary Current Period: April 2008 FUND Description 101 General 105 Fire Fund 150 Economic Development 205 Park Dedication 225 DARE 342 2008 Equipment Certificates 435 Northland Heights/Trans Corrid 438 2006 Interior St Improvements 441 2007 Street Impr (Jade Rd/E 442 2008 Equipment Certificates 490 Capital Outlay 601 Water Fund 602 Sewer Fund 603 Refuse Collection 651 Storm Water Utility 2008 2ooe 2008 YTD April 2008 YTD %YTD Budget 2008 Amt YTD Amt Balance Balance $2,160,800.00 $191,172.07 $708,271.51 $1,452,528.49 67.00% $148,200.00 $6,786.14 $46,558.84 $101,641.16 69.00°~ $38,450.00 $1,918.64 $14,813.24 $23,636.76 61.00% $0.00 $69.55 $208.65 -$208.65 0.00% $0.00 $0.00 $373.67 -$373.67 0.00% $0.00 $3,552.50 $3,552.50 -$3,552.50 0.00% $0.00 $14,823.54 -$66,879.77 $66,879.77 0.00% $0.00 $20,492.25 $85,711.43 -$85,711.43 0.00°k $0.00 $52, 799.30 -$27,109.61 $27,109.61 0.00% $76,650.00 $36,061.67 $83,437.91 -$6,787.91 -9.00% $14,715.00 $0.00 $19,952.28 -$5,237.28 -36.00% $1,351,705.00 $136,951.72 $139,454.84 $1,212,250.16 90.00% $442,615.00 $38,916.31 $77,731.09 $364,883.91 82.00% $257,515.00 $20,935.29 $67,384.31 $190,130.69 74.00% $2,300.00 $2,034.85 $12,627.60 -$10,327.60 -449.00% $4,492,950.00 $526,513.83 $1,166,088.49 $3,326,861.51 74.00% 05/27/08 3:59 PM Page 1