Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Item 06 Financial Reports for March 31, 2007
AGENDA ITEM SUMMARY SPRINGFIELD Meeting Date: Meeting Type: Department: Staff Contact: Phone No.: Estimated Time: May 07, 2007 Regular Session Finance Bob Duey ~ D 726-3740 Consent Calendar CITY COUNCIL ITEM TITLE: FINANCIAL REPORTS FOR MARCH 31,2007 ACTION REQUESTED: Approval of the following motion to: Accept the Financial Reports for March 31, 2007. ISSUE STATEMENT: The Financial Reports for March 31,2007 are attached for your review and approval. ATTACHMENTS: Financial Reports for March 31, 2007 DISCUSSION/ FINANCIAL IMPACT: Following are revenue highlights of the 3rd quarter ended March 31, 2007: ~ Local sanitary sewer user fees totaled $1,103,000. ~ Local storm sewer user fees totaled $953,000. ~ SDC fees totaled $637,000. ~ Property tax payments totaled $1,050,000. ~ ODOT made highway apportionment payments of$62l,000. ~ Ambulance payments totaled $606,000. ~ Transient room tax payments totaled $141,000. ~ Local fuel tax payments totaled $246,000. ~. Franchise fee payments totaled $451,000 ~ Fire protection contract payments totaled $921,000. ~ Municipal Court revenues totaled $293,000. ~ The city earned 5.03% in January, 5.14% in February, and 5.16% in March on its investments. Total: $1,200,000. Report ID: SPRG506 From Period: 1 To period: FUND: 100 GENERAL FUND 9 City Of Springfield . STATUS OF RIlVIlNUIlS MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 1 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE % RIlC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 411111 Current Taxes 13,994,129 13,994,129 506,871. 63 13,767,355.95 226,773.05 98 411211 Delinquent Taxes 410,000 410,000 10,190.01 278,362.76 131,637.24 68 420101 Sanipac Franchise 314,000 314,000 0.00 149,707.64 164,292.36 48 420111 Comcast Franchise 434,000 434,000 0.00 348,619.12 85,380.88 80 420121 QWest Franchise 260,000 422,000 0.00 201,725.34 220,274.66 48 * 420131 NW Natural Gas Franchise 470,000 470,000 0.00 328,856.53 141,143.47 70 * 420141 Sprint Franchise 22,000 22,000 0.00 21,205.81 794.19 96 420161 EPUD Right-Of-way Fees 0 0 490.58 1,272.12 -1,272.12 0 421101 Library Receipts 27,000 27,000 2,110.45 17,596.63 9,403.37 65 421111 Library Photocopy Charges 1,000 1,000 0.00 140.00 860.00 14 423141 Animal Licenses/Impound 22,000 22,000 2,500.00 18,500.00 3,500.00 84 423142 Police Impound Fees 124,200 124,200 14,190.00 119,474.00 4,726.00 96 424001 Fire Code Permits 102,785 102,785 2,304.93 102,447.29 337.71 100 424002 FLS Safety Systems Plan Review 34,000 34,000 2,768.70 23,117.97 10,882.03 68 * 424003 Fire Marshal Reinspection Fee 10,000 10,000 0.00 25.00 9,975.00 0 * 424004 Fire Marshal Referral 21,000 21,000 0.00 0.00 21,000.00 0 * 424005 FLS New Constr Sq Footage Fee 55,000 55,000 5,872.50 40,766.60 14,233.40 74 425002 Planning Fees 1,125,000 1,136,288 126,188.76 1,004,531.71 131,756.29 88 425505 DSD Postage Fees 9,000 18,650 1,900.00 13,000.00 5,650.00 70 * 425605 Technology Fee. 111,740 111,740 11,700.47 67,656.03 44,083.97 61 * 426606 Court Conviction Surcharge 0 0 -116.00 -116.00 116.00 0 426702 Code Requirement Fees 41,000 41,000 1,505.00 7,486.00 33,514.00 18 * 428020 Land Alt. And Fill Permit 13,000 13,000 0.00 0.00 13,000.00 0 * 431186 Team Spfld Bicycle Patrol 10,000 10,000 0.00 11,499.00 -1,499.00 115 431200 Urban Renewal District 22,000 22,000 0.00 0.00 22,000.00 0 431217 Ilm Preparedness & Response 0 0 0.00 1,284.53 -1,284.53 0 433411 Liquor Apportionment 556,641 556,641 77,757.98 444,698.75 111,942.25 80 433412 Cigarette Apportionment 89,220 89,220 0.00 61,659.78 27,560.22 69 * 433413 State Revenue Sharing 384,083 384,083 0.00 332,003.98 52,079.02 86 433513 State Conflagration Funds 0 62,242 0.00 74,021. 04 -11,779.04 119 435516 Lane County Laura Street 0 1,420 0.00 0.00 1,420.00 0 * 435553 Dist 19-Dare Support 0 0 0.00 15,129.68 -15;129.68 0 435556 District 19-5chool Res. Prog. 118,026 118,026 0.00 93,942.77 24,083.23 80 435911 SUB In-Lieu-Of-Tax 1,736,000 1,736,000 149,201.83 1,311,413.35 424,586.65 76 435912 EWIlB In-Lieu-Of-Tax 556,000 556,000 34,335.61 410,507.14 145,492.86 74 * 435913 Electric Co-ops In-Lieu-Of-Tax 0 0 0.00 7,582.02 -7,582.02 0 440005 Int Telephone Cbgs 7,629 7,629 41.67 375.03 7,253.97 5 440007 Int Facility Rent 211,972 211,972 17,250.43 157,096.89 54,875.11 74 440009 Int Data Process Chgs 4,997 4,997 647.67 5,829.03 -832.03 117 440011 Int Bldg Maint Chgs 183,705 183,705 11,770.58 135,975.72 47,729.28 74 440013 Int Vehicle Maint Cbgs 135,933 135,933 11,327.76 101,949.84 33,983.16 75 Report 10: SPRG506 From Period: 1 To period: FUND: 100 GENERAL FUND 9 City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 2 Run Date 04/10/2007 Run Time 09:07:15 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE t REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 443005 Police Srvcs U of 0 20,000 20,000 0.00 17,283.31 2,716.69 86 443006 Police Srvcs Dist 19 3,000 3,000 0.00 0.00 3,000.00 0 444007 Rainbow Fire Protection 881,804 881,804 233,202.50 699,604.50 182,199.50 79 444008 Glenwood Fire Protection 152,056 152,056 0.00 79,778.00 72,278.00 52 * 444009 Willakenzie Fire Protecti 267,558 267,558 0.00 142,029.00 125,529.00 53 445017 will Collection Fee 34,000 34,000 1,561.16 11,509.16 22,490.84 34 * 446001 Library Services 1,200 1,200 0.00 2,741.66 -1,541. 66 228 446002 Library Automation 44,300 44,300 0.00 37,907.84 6,392.16 86 448031 Staff Reimbursement 0 25,450 20,891.11 35,467.29 -10,017.29 139 451111- Muni Court Revenues 776,458 776,458 91,456.62 749,165.44 27,292.56 96 451112 Muni Court- Delinquencies 177 , 794 177,794 0.00 0.00 177,794.00 0 * 451115 Library Fines 24,000 24,000 2,224.20 17,813.10 6,186.90 74 * 451311 Restitution 400 400 300.00 805.01 -405.01 201 452112 Federal Forfeitures 0 0 0.00 18,703.86 -18,703.86 0 452113 State Forfeit/Deq 25,000 25,000 13,207.00 13,207.00 11,793.00 53 452118 Drug Forfeits Post 1/1/02 0 0 11,901. 00 53,679.00 -53,679.00 0 461001 Interest Income 275,000 275,000 55,607.38 361,352.06 -86,352.06 131 461002 Variance in FMV of Investments 0 0 0.00 109,483.66 -109,483.66 0 461003 Unsegregated Tax Interest 5,000 5,000 -1,085.94 -5,977.36 10,977.36 120 461103 County Assess Interest 0 0 3,300.92 38,534.61 -38,534.61 0 463011 Lease Income 0 0 0.00 6,970.25 -6,970.25 0 464001 Equipment Sales 10,000 10,000 0.00 0.00 10,000.00 0 464003 Vehicle Sales 0 0 700.00 4,450.00 -4,450.00 0 465031 Library Gift Funds 15,000 15,000 0.00 14,163.00 837.00 94 465032 Hulda Durham Trust Donati 25 25 7.32 20.52 4.48 82 465033 Lib.Scholarship Donation 2,500 2,500 0.00 0.00 2,500.00 0 * 480211 W.C. Time LOSS Reeov. 0 0 0.00 8,950.90 -8,950.90 0 480311 Cash OVer/Short 0 0 -72.45 -706.05 706.05 0 481001 Miscellaneous Receipts 35,000 54,960 24,400.89 96,120.02 -41,160.02 175 481003 Training Program 0 0 0.00 495.49 -495.49 0 481004 Testing 3,000 4,350 765.00 2,115.00 2,235.00 49 481008 Muni Court -lnt on Delinq 0 0 9,849.70 54,826.20 -54,826.20 0 491101 Indirect Chgs: Fund 201 433,605 433,605 0.00 217,765.00 215,840.00 50 * 491104 Indirect Chgs: Fund 204 0 0 0.00 2,358.00 -2,358.00 0 491105 Indirect Chgs: Fund 305 2,650 2,650 0.00 1,325.00 1,325.00 50 * 491110 Indirect Chgs: Fund 210 16,604 16,604 0.00 12,261. 95 4,342.05 74 * 491111 Indirect Chgs: Fund 611 254,667 254,667 0.00 127,333.50 127,333.50 50 491112 Indirect Chgs: Fund 612 266,988 266,988 0.00 167,499.15 99,488.85 63 491115 Indirect Chgs: Fund 615 289,166 289,166 0.00 144,583.00 144,583.00 50 * 491117 Indirect Chgs: Fund 617 408,500 408,500 0.00 204,250.00 204,250.00 50 491119 Indirect Chgs Fund 419 11,925 11,925 0.00 5,962.50 5,962.50 50 * Report ID: SPRG506 From Period: 1 To Period: FUND: 100 GENERAL FUND 9 City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 3 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE '" RIlC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 491122 Indirect Chge: Fund 222 36,439 36,439 2,600.69 32,165.56 4,273..44 88 491124 Indirect Chge: Fund 224 147,209 147,209 0.00 73,604.50 73,604.50 50 491191 Indirect Chge: Fund 719 54,064 54,064 0.00 27,032.00 27,032.00 50 * 491205 XFR From Fund 305 300,000 300,000 0.00 300,000.00 0.00 100 491208 XFR From Fund 208 385,493 385,493 23,033.03 315,517.20 69,975.80 82 491218 XFR From Fund 618 375,162 375,162 3,304.75 29,742.75 345,419.25 8 * 491219 XFR From Fund 419 10,000 10,000 0.00 10,000.00 0.00 100 491238 Xfr from Fund 224 47,673 47,673 3,972.75 35,754.75. 11,918.25 75 491629 XfR from Fund 629 12,000 12,000 0.00 12,000.00 0.00 100 499999 Beginning Caeh Balance 7,028,558 7,357,907 0.00 7,357,907.42 -0.42 100 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 100 GENERAL FUND 34,450,858 35,073,567 1,491,938.19 31,324,253.80 3,749,313.20 89 ===~================================================================================================================================================================================= Report 10: SPRG506 From Period: 1 To Period: FUND: 201 STREET FUND 9 ACCOUNT DESCRIPTION 417001 425002 428030 428060 428070 431218 433421 433422 433511 435510 435511 435917 448011 448021 448023 448030 461001 461002 463011 481001 481002 491200 499999 Local Fuel Tax Planning Fees Engineering Fees ROW Permit Fees Sidewalk Cafe Permit STP Planning Highway Apportionment Bicycle Apportionment OR Sig Maint Contract Lane County OTIA III Lane Urban Transition LTD Maintenance Contract Street Repair Fees Weyco Traf Sig Maint Geo Info System Fee Int Engineering Fees Interest Income Variance in FMV of Investments Lease Income Miscellaneous Receipts Prior-Year Engineering Revenue XFR From Fund 100 Beginning Cash Balance TOTAL FUND: 201 STREET FUND ADOPTED BUDGET 1,061,373 112,690 3,750 27,302 25 80,000 3,042,191 30,422 30,750 o 505,000 25,875 o o o 32,500 57,229 o 8,000 24,287 30,000 10,000 1,797,028 6,878,422 City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED REVISED BUDGET CURRENT RECEIVED 1,061,373 112,690 3,750 27,302 25 80,000 3,042,191 30,422 30,750 o 505,000 25,875 o o o 32,500 57,229 o 8,000 24,287 30,000 10,000 1,967,679 51,592.06 0.00 0.00 2,610.00 0.00 0.00 185,092.68 1,869.62 0.00 0.00 494,203.22 0.00 224.45 0.00 230.00 0.00 3,690.44 0.00 0.00 3,384.36 0.00 0.00 0.00 7,049,073 742,896.83 YTD RECEIVED 712,280.22 0.00 0.00 22,327.05 0.00 32,263.09 1,758,042.99 17,758.01 71,433.54 98,074.79 494,203.22 9,504.53 10,478.41 12,313.88 1,163.00 0.00 40,492.14 14,653.20 8,000.00 38,844.32 5,292.27 0.00 1,967,679.04 5,314,803.70 BALANCE 349,092.78 112,690.00 3,750.00 4,974.95 25.00 47,736.91 1,284,148.01 12,663.99 -40,683.54 -98,074.79 10,796.78 16,370.47 -10,478.41 -12,313.88 -1,163.00 32,500.00 16,736.86 -14,653.20 0.00 -14,557.32 24,707.73 10,000.00 -0.04 1,734,269.30 Page No. 4 Run Date 04/10/2007 Run Time 09:07:15 , REC 67 o o 82 o 40 58 58 232 o 98 37 o o o o 71 o 100 160 18 o 100 75 FLAG * * * * * * * * * * * * Report ID: SPRG506 From Period: 1 To Period: FUND: 202 JAIL OPERATIONS 9 City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 5 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE \ RIlC FLAG 426606 461001 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Court Conviction Surcharge Interest Income o o 24,000 1,000 4,211.00 86.11 27,249.00 137.66 -3,249.00 862.34 114 14 * ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 202 JAIL OPERATIONS o 25,000 4,297.11 27,386.66 -2,386.66 110 =========~=================================================================================================================~========================================================= Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 204 SPECIAL REVENUE FUND City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 6 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE t REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 414115 Transient Room Tax 15,000 15,000 0.00 15,000.00 0.00 100 418011 911 Tax 375,000 375,000 0.00 142,133.51 232,866.49 38 431137 HUD Home Grants 0 0 0.00 0.00 0.00 0 431162 SHPO Grant 05-06 3,000 3,000 0.00 3,000.00 0.00 100 431163 SHPO 06-07 0 3,000 0.00 0.00 3,000.00 0 * 431172 Child Advocacy Center Grant 86,228 86,228 0.00 47,798.09 38,429.91 55 * 431196 STOP Grant 50,508 50,508 0.00 0.00 50,508.00 0 * 431198 BJA Bullet Proof Vest 0 5,162 0.00 0.00 5,162.00 0 431204 2004 Domestic Prep EQ 0 64,938 0.00 64,938.00 0.00 100 431217 Em Preparedness & Response 50,000 50,000 0.00 0.00 50,000.00 0 * 431219 04 Secure OUr Schools 0 20,000 0.00 12,492.50 7,507.50 62 * 431222 Justice Assistance Grant 18,132 39,030 0.00 20,863.85 18,166.15 53 * 431225 COPS ICTP 0 225,000 0.00 0.00 225,000.00 0 * 433278 Child Srvc Imp Grant 05-06 0 2,882 0.00 2,881.62 0.38 100 433279 Child Srvc Imp Grant 06-07 10,077 13,442 0.00 6,831.80 6,610.20 51 * 433515 DEQ BRING Grant 30,000 30,000 0.00 7,188.50 22,811. 50 24 433516 State PAL pgm 0 0 0.00 1,420.39 -1,420.39 0 435520 Lane County DAO 0 9,476 0.00 18,079.00 -8,603.00 191 465020 Canine Donations 0 1,330 0.00 6,008.00 -4,678.00 452 480206 Vandalism Fund Donations 0 1,000 0.00 1,000.00 0.00 100 481001 Miscellaneous Receipts 0 6,679 0.00 6,703.58 -24.58 100 482138 Windermere Foundation Grant 0 1,240 0.00 1,240.00 0.00 100 486001 Wal-Mart Foundation #3239 0 0 0.00 5,000.00 -5,000.00 0 486002 Fireman's Fund Heritage 0 0 5,000.00 5,000.00 -5,000.00 0 491210 XFR From Fund 210 0 6,339 0.00 0.00 6,339.00 0 * 499999 Beginning Cash Balance 30,242 -67,436 0.00 -67,435.76 -0.24 100 . TOTAL FUND: 204 SPECIAL REVENUE FUND 668,187 941,818 5,000.00 300,143.08 641,674.92 32 * ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 7 Run Date 04/10/2007 Run Time 09:07:15 Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 208 TRANSIENT ROOM TAX FUND ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE 9; REC FLAG 414115 461001 461002 499999 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Transient Room Tax Interest Income Variance in FMV of Investments Beginning Cash Balance 650,000 2,350 o 53,071 657,975 2,350 o 44,182 42,280.24 479.19 0.00 0.00 562,285.63 3,668.85 535.29 44,181.13 95,689.37 -1,318.85 -535.29 0.87 85 156 o 100 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 208 TRANSIENT ROOM TAX FUND 705,421 704,507 42,759.43 610,670.90 93,836.10 87 ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 210 COMMUNlTY DEVELOPMENT FUND City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 8 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED ym RECEIVED BALANCE , REC FLAG 431111 CDBG Federal Grants 629,375 1,120,515 160,162.99 909,740.30 210,774.70 81 431112 EDI Federal Grant 300,000 318,289 0.00 0.00 318,289.00 0 * 431137 HUn Home Grants 446,802 2,065,848 551,725.26 940,753.20 1,125,094.80 46 * 461001 Interest Income 0 0 0.00 -56.08 56.08 0 463011 Lease Income 0 735 0.00 0.00 735.00 0 * 467012 Interim Loan Repayments 0 163,407 0.00 0.00 163,407.00 0 * 467013 Home Loan Repay 250,000 643,971 0.00 0.00 643,971.00 0 * 467015 House Rehab Loan Pay 60,000 193,784 17,472.15 79,747.33 114,036.67 41 467017 Rehab Loan Fee Repay 4,200 13,539 1,315.11 5,433.21 8,105.79 40 481001 Miscellaneous Receipts 0 25 0.00 0.00 25.00 0 482138 Windermere Foundation Grant 0 0 0.00 0.00 0.00 0 499999 Beginning Cash'Balance 0 -118,626 0.00 -118,625.48 -0.52 100 TOTAL FUND: 210 COMMUNITY DEVELOPMENT FUN 1,690,377 4,401,487 730,675.51 1,816,992.48 2,584,494.52 41 Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 222 RIVERBEND DEVELOPMENT FUND City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 9 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALllNCE it RIlC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 425004 Planning Fees peacehealth 652,350 1,074,271 0.00 530,437.46 543,833.54 49 461001 Interest Income 0 0 -152.81 -5,838.02 5,838.02 0 461002 Variance in FMV of Investments 0 0 0.00 0.00 0.00 0 481001 Miscellaneous Receipts 0 56,843 0.00 0.00 56,843.00 0 499999 Beginning Cash Balance 0 -151,921 0.00 -151,920.57 -0.43 100 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 222 RIVERBEND DEVELOPMENT FUN 652,350 979,193 -152.81 372,678.87 606,514.13 38 * ==================================================================================================================================================================================== Report 10: SPRG506 From Period: ~ To Period: 9 FUND: 224 BUILDING CODE FUND City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 3~, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. ~O Run Date 04/~0/2007 Run Time 09:07:~5 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE t REC FLAG 425602 Building Fees ~,500,000 ~,500,000 ~04,724.0~ 734,438.89 765,56~.~~ 49 * 425603 Plumbing Fees 148,000 148,000 ~3,052.40 92,750.58 55,249.42 63 * 425604 Mechanical Fees 68,000 68,000 4,949.50 36,287.00 31,713.00 53 * 426~02 Electrical Inspection Fee 157,000 ~57,OOO '~6,784.45 ~~~,998.45 45,001. 55 71 * 426605 Bldg Fee Admin 138,000 138,000 9,~09.80 64,830.53 73, ~69 .47 47 * 46~00~ Interest Income 90,000 90,000 6,758.~9 69,623.87 20,376.13 77 46~002 Variance in FMV of Investments 0 0 0.00 ~3,935.42 -13,935.42 0 480211 W.C. Time Loss Recov. 0 0 0.00 3,893.90 -3,893.90 0 48~00~ Miscellaneous Receipts 0 0 69.00 624.00 -624.00 0 499999 Beginning Cash Balance 2,429,975 2,O~4,588 0.00 2,O~4,588.20 -0.20 ~OO TOTAL FUND: 224 BUILDING CODE FUND 4,530,975 4,~~5,588 ~55,447.35 3,~42,970.84 972,6~7.~6 76 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 11 Run Date 04/10/2007 Run Time 09:07:15 Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 235 FIRE LOCAL OPTION LEVY ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTU RECEIVED BALANCE t REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 411111 Current Taxes 1,062,778 1,062,778 38,657.24 1,049,985.84 12,792.16 99 411211 Delinquent Taxes 16,000 16,000 675.06 18,783.26 -2,783.26 117 433513 State Conflagration Funds 0 2,511 0.00 0.00 2,511.00 0 * 444007 Rainbow Fire Protection 51,000 51,000 0.00 0.00 51,000.00 0 * 444008 Glenwood Fire Protection 7,500 7,500 0.00 0.00 7,500.00 0 * 444009 Willakenzie Fire Protecti 16,500 16,500 0.00 0.00 16,500.00 0 * 461001 Interest Income 12,000 12,000 3,323.75 20,080.89 -8,080.89 167 461002 Variance in FMV of Investments 0 0 0.00 4,719.78 -4,719.78 0 481001 Miscellaneous Receipts 0 0 0.00 1,147.84 -1,147.84 0 499999 Beginning Cash Balance 273,132 389,484 0.00 389,483.39 0.61 100 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 235 FIRE LOCAL OPTION LEVY 1,438,910 1,557,773 42,656.05 1,484,201.00 73,572.00 95 ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 236 POLICE LOCAL OPTION LEVY City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 12 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE '" REC FLAG 411111 Current Taxes 1,948,426 1,948,426 70,871. 61 1,924,974.03 23,451. 97 99 411211 Delinquent Taxes 30,000 30,000 1,237.62 34,435.96 -4,435.96 115 461001 Interest Income 31,000 31,000 9,428.21 65,060.61 -34,060.61 210 461002 Variance in FMV of Investments 0 0 0.00 12,433.20 -12,433.20 0 481001 Miscellaneous Receipts 0 0 0.00 1,808.30 -1,808.30 0 499999 Beginning Cash Balance 745,442 1,467,851 0.00 1,467,850.71 0.29 100 TOTAL FUND: 236 POLICE LOCAL OPTION LEVY 2,754,868 3,477,277 81.537.44 3,506,562.81 -29,285.81 101 ACCOUNT DESCRIPTION ---------------.---------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 13 Run Date 04/10/2007 Run Time 09:07:15 Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 305 BANCROFT REDEMPTION FUND ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE 't REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 411111 Current Taxes 0 0 0.00 0.00 0.00 0 411211 Delinquent Taxes 0 0 34.10 92.64 -92.64 0 461001 Interest Income 50,000 50,000 7,065.65 63,483.33 -13,483.33 127 461002 Variance in FMV of Investments 0 0 0.00 16,655.10 -16,655.10 0 461111 Pre Bond Assess Interest 0 0 0.00 2,334.36 -2,334.36 0 461125 1997 Series One Interest 0 0 0.00 654.42 -654.42 0 462112 Series U Financed Sales 10,000 10,000 0.00 0.00 10,000.00 0 * 462116 Series Z Financed Sales 0 0 0.00 1,586.20 -1,586.20 0 471111 Pre Bond Assessments 75,000 75,000 0.00 16,159.49 58,840.51 22 * 471125 1997 Series One Assess 0 0 0.00 10,942.40 -10,942.40 0 491219 XFR From Fund 419 25,447 25,447 0.00 0.00 25,447.00 0 * 499999 Beginning Cash Balance 1,958,720 2,094,215 0.00 2,094,214.19 0.81 100 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 305 BANCROFT REDEMPTION FUND 2,119.167 2,254,662 7,099.75 2,206,122.13 48,539.87 98 ============================================~=============~==========================~=============================================================================================== Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 306 BOND SINKING FUND City Of Springfield STATUS OF REVENUES MONTH IlNDING MARCH 31, 2007 . 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 14 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVIlD YTD RECEIVIlD BALANCE '" REC FLAG 411111 Current Taxes 1,121,519 1,121,519 31,473.44 854,863.48 266,655.52 76 411211 Delinquent Taxes 20,000 20,000 793.73 21,732.28 -1,732.28 109 461001 Interest Income 15,000 15,000 4,051.22 22,083.85 -7,083.85 147 461002 Variance in FMV of Investments 0 0 0.00 6,055.21 -6,055.21 0 491304 Justice Center Bond Proceeds 388,591 388,591 0.00 0.00 388,591. 00 0 * 491440 XFR From Fund 440 25,649 25,649 0.00 25,649.00 0.00 100 491443 XFR From Fund 443 45,662 45,662 0.00 45,662.00 0.00 100 491446 XFR From Fund 446 10,374 10,374 0.00 10,374.00 0.00 100 499999 Beginning Cash Balance 337,800 365,458 0.00 365,457.13 0.87 100 TOTAL FUND: 306 BOND SINKING FUND 1,964,595 1,992,253 36,318.39 1,351,876.95 640,376.05 68 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS E~PSED Page No. 15 Run Date 04/10/2007 Run Time 09:07:15 Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 409 SANITARY SEWER CAPITAL FUND ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE \ REC FLAG 461001 461002 491211 499999 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Interest Income Variance in FMV of Investments XFR From Fund 611 Beginning Cash Balance 66,509 o 1,452,292 2,037,352 66,509 o 1,452,292 3,048,473 14,462.13 0.00 363,073.00 0.00 121,330.71 21,673.57 1,089,219.00 3,048,473.44 -54,821.71 -21,673.57 363,073.00 -0.44 182 o 75 100 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 409 SANITARY SEWER CAPITAL FlJ 3,556,153 4,567,274 377,535.13 4,280,696.72 286,577.28 94 =========~=============~============================================================================================================================================================= Report ID: SPRG506 From period: 1 To Period: 9 FUND: 419 DEVELOPMENT ASSESSMENT CAPITAL City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 16 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRllNT RECEIVED YTD RECEIVED BALANCE \ RIlC FLAG 461001 Interest Income 30,000 30,000 5,667.84 51,787.25 -21,787.25 173 461002 Variance in FMV of Investments 0 0 0.00 9,955.50 -9,955.50 0 461101 Unbonded Assessment Inter 5,000 5,000 105.06 1,717.84 3,282.16 34 * 471101 Unbonded Assessments 15,000 15,000 169.94 5,182.64 9,817.36 35 * 471111 Pre Bond Assessments 75,000 75,000 0.00 50,425.72 24,574.28 67 * 491200 XFR From Fund 100 40,250 40,250 0.00 0.00 40,250.00 0 * 499999 Beginning Cash Balance 1,398,321 1,450,756 0.00 1,450,755.13 0.87 100 TOTAL FUND: 419 DEVELOPMENT ASSESSMENT CA 1,563,571 1,616,006 5,942.84 1,569,824.08 46,181. 92 97 Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 420 DEVELOPMENT PROJECTS City Of Springfield STATUS OF REVENUES MONTI! ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 17 Run Date 04/10/2007 Run Time 09:07:15 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ACCOUNT DESCRIPTION ADOPTED BUDGET . REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE , REC !I:i'G ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 431223 STP-U MPO Frkln Planning 0 225,000 0.00 0.00 225,000.00 0 431224 STP-U MPO G/B Planning 0 165,625 0.00 0.00 165,625.00 0 * 435517 Lane County 42nd/126 200,000 0 0.00 0.00 0.00 0 435559 Flood Map Modernization Study 0 10,000 0.00 0.00 10,000.00 0 * 435918 LTD Planning for GateBelt 25,000 24,562 0.00 141.03 24,420.97 1 * 435919 LTD Planning for Franklin Blvd 25,000 25,000 0.00 0.00 25,000.00 0 * 461001 Interest Income 148,000 148,000 16,378.07 208,991.15 -60,991.15 141 461002 Variance in FMV of Investments 0 0 0.00 63,574.26 -63,574.26 0 465025 Springfield Sign Contribution 0 15,000 0.00 15,000.00 0.00 100 471161 Developer Jasper Rd Sewer 2,400,000 2,400,000 0.00 0.00 2,400,000.00 0 471166 B-line/Gateway Intersection PH 5,500,000 7,000,000 0.00 0.00 7,000,000.00 0 471168 PH NW Drainage 0 450,293 0.00 450,292.59 0.41 100 471171 S. 48th Connection M to Daisy 175,000 175,000 0.00 0.00 175,000.00 0 * 480200 Arbitrage Overpayment Refund 0 117,660 0.00 0.00 117,660.00 0 481001 Miscellaneous Receipts 0 0 0.00 65.00 -65.00 0 491200 XFR From Fund 100 0 162,000 0.00 0.00 162,000.00 0 491201 XFR From Fund 201 0 1,005 0.00 0.00 1,005.00 0 491205 XFR From Fund 305 0 100,187 0.00 0.00 100,187.00 0 491307 BLM/Forest Service Facility 4,090,000 5,000,000 0.00 0.00 5,000,000.00 0 * 499999 Beginning Cash Balance 6,570,969 6,910,545 0.00 6,910,544.85 0.15 100 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 420 DEVELOPMENT PROJECTS 19,133,969 22,929,877 16,378.07 7,648,608.88 15,281,268.12 33 * ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 425 STORM DRAINAGE CAPITAL FUND City Of Springfield STATUS OF REVIlNUIlS MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSIID Page No. 18 Run Date 04/10/2007 Run Time 09:07:15 ----------------------------------------------------------~-------------------------------------------------------------------------------------------------------------------------- ACCOUNT DESCRIPTION 461001 461002 491217 499999 Interest Income Variance in FMV of Investments XFR from fund 617 Beginning Cash Balance TOTAL FUND: 425 STORM DRAINAGE CAPITAL FU ADOPTIID BUDGET 33,800 o 620,000 955,110 1,608,910 REVISIID BUDGET CURRENT RECEIVED YTD RECEIVED 54,757.58 8,435.68 465,000.00 1,405,891.81 1,934,085.07 BALANCE -20,957.58 -8,435.68 155,000.00 0.19 125,606.93 % RIlC FLAG 162 o 75 100 ===================================================================================================================================================================================== 94 33,800 o 620,000 1,405,892 6,636.38 0.00 155,000.00 0.00 2,059,692 161,636.38 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 19 Run Date 04/10/2007 Run Time 09:07:15 Report 10: SPRG506 From Period: 1 To Period: 9 FUND: 427 GO BOND CAPITAL PROJECTS ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE t REC FLAG 461001 499999 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Interest Income Beginning Cash Balance 580 29,316 580 20,480 81. 68 0.00 806.57 20,479.52 -226.57 0.48 139 100 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 427 GO BOND CAPITAL PROJECTS 29,896 21,060 81. 68 21,286.09 -226.09 101 ===================================================================================================================================================================================== Report ID: SPRG506 From period: 1 To Period: 9 FUND: 428 POLICE BUILDING BOND CAP PROJ ACCOUNT DESCRIPTION 461001 491304 499999 Interest Income Justice Center Bond Proceeds Beginning Cash Balance TOTAL FUND: 428 POLICE BUILDING BOND CAP ADOPTED BUDGET 200,000 24,261,409 1,860,883 26,322,292 City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED REVISED BUDGET CURRENT RECEIVED 200,000 24,261,409 3,453,672 9,860.57 493,000.00 0.00 27,915,081 502,860.57 YTD RECEIVED 114,693.88 493,000.00 3,453,672.12 4,061,366.00 BALANCE 85,306.12 23,768,409.00 -0.12 23,853,715.00 Page No. 20 Run Date 04/10/2007 Run Time 09:07:15 'Ii REC FLAG 57 2 100 * 15 * ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 21 Run Date 04/10/2007 Run Time 09:07:15 Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 429 SEDA CAPITAL PROJECT FUND ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE t REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 411111 Current Taxes 92,700 92,700 6,886.13 187,034.00 -94,334.00 202 411211 Delinquent Taxes 0 0 43.32 1,174.96 -1,174.96 0 461001 Interest Income 5,000 5,000 592.64 3,325.60 1,674.40 67 * 461002 Variance in FMV of Investments 0 0 0.00 416.73 -416.73 0 461003 Unsegregated Tax Interest 0 0 0.00 0.00 0.00 0 464008 Property Sale 1,683,800 1,683,800 0.00 0.00 1,683,800.00 0 * 491220 XFR From Fund 420 1,046,500 1,046,500 0.00 0.00 1,046,500.00 0 * 499999 Beginning Cash Balance 0 0 0.00 39,505.02 -39,505.02 0 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 429 SEDA CAPITAL PROJECT FUND 2,828,000 2,828,000 7,522.09 231,456.31 2,596,543.69 8 ===================================================================================================================================================================================== Report 10: SPRG506 From Period: 1 To Period: 9 FUND: 433 REGIONAL WASTEWATER CAPITAL FD city Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 22 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG 431221 EPA - Grant MWMC infrastructur 0 190,000 0.00 210,119.00 -20,119.00 111 435551 County Service District 0 24,000 0.00 24,000.00 0.00 100 461001 Interest Income 0 0 99,772.31 609,196.16 -609,196.16 0 461021 Capital Interest 421,334 421,334 0.00 69,294.34 352,039.66 16 461023 Equipment Replace Interes 269,679 269,679 0.00 59,258.49 210,420.51 22 * 461030 MWMC LGIP Interest 0 0 57,279.31 328,659.19 -328,659.19 0 461031 MWMC Bond Proceed Inv Int 0 0 122,618.54 158,510.90 -158,510.90 0 480215 Claims Recovery 0 0 0.00 325,000.00 -325,000.00 0 491212 XFER From Fund 612 3,226,569 3.226,569 268,880.75 2,419,926.75 806,642.25 75 491222 XFR From Fund 612 OP-EQ Repl 365,199 365,199 30,433.25 273,899.25 91,299.75 75 491223 XFR From Fund 612 OP-Vehicle 209,549 209,549 17,462.42 157,161. 78 52,387.22 75 491224 XFR From Fund 612 OP-Computer 28,329 28,329 2,360.75 21,246.75 7,082.25 75 491305 Revenue Bond Sale 40,000,000 50,000,000 0.00 50,398,674.50 -398,674.50 101 499999 Beginning Cash Balance 18,998,701 15,873,021 0.00 15,873,020.21 0.79 100 TOTAL FUND: 433 REGIONAL WASTEWATER CAPIT 63,519,360 70,607,680 598,807.33 70,927,967.32 -320,287.32 100 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 23 Run Date 04/10/2007 Run Time 09:07:15 Report ID: SPRG506 From Period: 1 To period: 9 FOND: 434 STREET CAPITAL FOND ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE % RIlC FLAG -------------------------------------------------------------------------------------------------------------------------------------------- 461001 Interest Income 62,510 62,510 11,443.56 105,709.30 461002 Variance in FMV of Investments 0 0 0.00 19,720.56 491201 XFR From Fund 201 750,000 750,000 0.00 750,000.00 491440 XFR From Fund 440 0 200,000 0.00 0.00 499999 Beginning Cash Balance 2,570,208 2,308,089 0.00 2,308,089.12 -43,199.30 -19,720.56 0.00 200,000.00 -0.12 169 o 100 o 100 * ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FOND: 434 STREET CAPITAL FOND 3,382,718 3,320,599 11,443.56 3,183,518.98 137,080.02 96 ======================================================~============================================================================================================================== Report ID: SPRG506 From period: 1 To Period: 9 FUND: 440 STORM DRAINAGE SDC FUND ACCOUNT DESCRIPTION 448028 461001 461002 499999 SDC Storm Interest Income Variance in FMV of Investments Beginning Cash Balance TOTAL FUND: 440 STORM DRAINAGE SDC FUND ADOPTED BUDGET 145,067 89,944 o 2,712,846 2,947,857 City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED REVISED BUDGET CURRENT RECEIVED YTD RECEIVED 272,172.22 106,067.78 21,684.09 2,943,417.90 3,343,341. 99 BALANCE -127,105.22 -16,123.78 -21,684.09 0.10 -164,912.99 Page No. 24 Run Date 04/10/2007 Run Time 09:07:15 % REC FLAG 145,067 89,944 o 2,943,418 49,539.83 11,766.53 0.00 0.00 188 118 o 100 =============~======================================================================================================================================================================= 105 3,178,429 61,306.36 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 25 Run Date 04/10/2007 Run Time 09:07:15 Report ID: SPRG506 From period: 1 To Period: 9 FUND: 442 SANITARY SEWER REIMB SDC FUND ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE t REC FLAG 448024 461001 461002 499999 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SDC Sanitary Sewer-Reimb Interest Income Variance in FMV of Investments Beginning Cash Balance 98,117 13,008 o 444,206 98,117 13,008 o 522,365 15,486.10 2,518.20 0.00 0.00 156,761.54 21,347.19 4,094.41 522,365.01 -58,644.54 -8,339.19 -4,094.41 -0.01 160 164 o 100 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 442 SANITARY SEWER REIMB SDC 555,331 633,490 18,004.30 704,568.15 -71,078.15 111 ====~=============================================================================================================================================~================================== Report ID: SPRG506 From period: 1 To period: 9 FUND: 443 SANITARY SEWER IMPROVEMENT SDC ACCOUNT DESCRIPTION 448025 461001 461002 499999 SDC Sanitary Sewer-Imp Interest Income Variance in FMV of Investments Beginning Cash Balance TOTAL FUND: 443 SANITARY SEWER IMPROVEMEN ADOPTED BUDGET 198,000 36,000 o 1,179,169 1,413,169 City Of Springfield STATlJS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED REVISED BUDGET CURRENT RECEIVED 198,000 36,000 o 1,343,573 13,964.43 5,418.15 0.00 0.00 1,577,573 19,382.58 YTD RECEIVED 127,958.01 48,959.40 9,609.19 1,343,573.40 1,530,100.00 BALANCE 70,041. 99 -12,959.40 -9,609.19 -0.40 47,473.00 Page No. 26 Run Date 04/10/2007 Run Time 09:07:15 t REC FLAG 65 136 o 100 * 97 ACCOUNT DESCRIPTION ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 27 Run Date 04/10/2007 Run Time 09:07:15 Report ID: SPRG506 From Period: 1 To period: 9 FUND: 444 SDC REGIONAL WASTEWATER REIMB ADOPTED BUDGET REVISED BUDGET CURRBNT RECBIVED YTD RECBIVlID BALANCE , REC FLAG 448024 461001 461024 499999 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SDC Sanitary Sewer-Reimb Interest Income Regional SDC Reimb. Interest Beginning Cash Balance 165,000 o 117,900 4,753,885 165,000 o 117,900 4,839,349 19,338.30 0.00 19,193.47 0.00. 89,041. 31 0.00 207,478.78 4,839,348.78 75,958.69 0.00 -89,578.78 0.22 54 o 176 100 * ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 444 SDC REGIONAL WASTEWATER R 5,036,785 5,122,249 38,531. 77 5,135,868.87 -13,619.87 100 ====~===========~==================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To period: 9 FUND: 445 SDC REGIONAL WASTEWATER IMP ACCOUNT DESCRIPTION 448025 461001 461027 499999 SDC Sanitary Sewer-Imp Interest Income Improvement SDC Interest Beginning Cash Balance TOTAL FUND: 445 SDC REGIONAL WASTEWATER I ADOPTED BUDGET 1,703,800 o 97,200 3,137,472 4,938,472 City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED REVISED BUDGET CURRENT RECEIVIID 1,703,800 o 97,200 4,254,158 193,318.82 0.00 19,471.53 0.00 6,055,158 212,790.35 YTD RECEIVIID 850,073.77 0.00 191,136.30 4,254,157.51 5,295,367.58 BALANCE 853,726.23 0.00 -93,936.30 0.49 759,790.42 Page No. 28 Run Date 04/10/2007 Run Time 09:07:15 t REC FLAG 50 o 197 100 87 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield STATUS OF REVENUIlS MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 29 Run Date 04/10/2007 Run Time 09:07:15 Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 446 SDC TRANSPORTATION REIMBURSEME ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE 't REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 448026 SDC Transportation-Reimb 111,309 111,309 10,477.44 77,436.13 33,872.87 70 461001 Interest Income 13,311 13,311 1,723.90 16,547.29 -3,236.29 124 461002 Variance in FMV of Investments 0 0 0.00 5,037.75 -5,037.75 0 481002 Prior Year Engineering Revenue 0 0 0.00 188.72 -188.72 0 499999 Beginning Cash Balance 792,293 719,537 0.00 719,537.07 -0.07 100 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 446 SDC TRANSPORTATION REIMBU 916,913 844,157 12,201. 34 818,746.96 25,410.04 97 ========================================================================~============================================================================================================ Report ID: SPRG506 From period: 1 To period: 9 FUND: 447 SDC TRANSPORTATION IMPROVEMENT City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 30 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE t REC FLAG 448027 SDC Transportation-Improvement 472,238 472,238 47,304.48 380,022.57 92,215.43 80 461001 Interest Income 54,297 54,297 11,444.03 103,337.92 -49,040.92 190 461002 Variance in FMV of Investments 0 0 0.00 21,544.18 -21,544.18 0 491446 XFR From Fund 446 0 110,000 0.00 0.00 110,000.00 0 499999 Beginning Cash Balance 2,546,000 2,849,674 0.00 2,849,674.48 -0.48 100 TOTAL FUND: 447 SDC TRANSPORTATION IMPROV 3,072,535 3,486,209 58,748.51 3,354,579.15 131,629.85 96 ===================================================================================================================================================================================== ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 31 Run Date 04/10/2007 Run Time 09:07:15 Report ID: SPRG506 From Period: 1 To period: 9 FUND: 611 SANITARY SIlWER OPERATIONS FUND ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE % REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 425002 Planning Fees 112,690 112,690 0.00 0.00 112,690.00 0 * 426604 SDC Admin Fee 3,000 3,000 170.00 1,660.00 1,340.00 55 * 428030 Engineering Fees 10,000 10,000 0.00 0.00 10,000.00 0 * 448023 Geo Info System Fee 0 0 0.00 15.00 -15.00 0 448030 Int Engineering Fees 15,000 15,000 0.00 0.00 15,000.00 0 * 448031 Staff Reimbursement 50,000 50,000 0.00 0.00 50,000.00 0 * 449011 Local Sewer User Fees 4,266,000 4,266,000 410,501.51 2,848,601. 45 1,417,398.55 67 * 449013 Regional Sewer User Fees 5,000 5,000 0.00 0.00 5,000.00 0 * 461001 Interest Income 50,600 50,600 5,554.65 49,495.38 1,104.62 98 461002 Variance in FMV of Investments 0 0 0.00 10,973.09 -10,973.09 0 463011 Lease Income 10,500 10,500 950.00 3,150.00 7,350.00 30 * 480211 W.C. Time Loss Reeov. 0 0 0.00 2,523.45 -2,523.45 0 481001 Miscellaneous Receipts 0 0 0.00 2,408.55 -2,408.55 0 481002 Prior Year Engineering Revenue 30,000 30,000 0.00 9,102.08 20,897.92 30 499999 Beginning Cash Balance 1,255,629 1,493,762 0.00 1,493,762.46 -0.46 100 ---------------------------------------------------------------~---------------------------------------------------------------------~----------------------------------------------- TOTAL FUND: 611 SANITARY SIlWER OPERATIONS 5,808,419 6,046,552 417,176.16 4,421,691.46 1,624,860.54 73 ================~~=======================================~========================================~================================================================================== Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 612 REGIONAL WASTEWATER FUND City of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 32 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE t REC FLAG ------------------~------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- 428040 Pretreatment Permits 9,135 9,135 0.00 0.00 9,135.00 0 * 448030 Int Engineering Fees 0 290,000 0.00 434,673.46 -144,673 .46 150 449013 Regional Sewer User Fees 16,854,000 16,854,000 2,675,464.97 11,493,453.47 5,360,546.53 68 * 449015 Septage Revenue 420,000 420,000 0.00 150,701.00 269,299.00 36 * 451315 Permit Fines 2,500 2,500 0.00 0.00 2,500.00 0 451316 Pretreatment Fines 2,500 2,500 0.00 2,018.00 482.00 81 461001 Interest Income 0 0 0.00 -2,178.56 2,178.56 0 461002 Variance in FMV of Investments 0 0 0.00 28,178.42 -28,178.42 0 461022 Operations Interest 271,000 271,000 19,708.13 179,615.50 91,384.50 66 463011 Lease Income 14,980 14,980 2,539.28 24,920.47 -9,940.47 166 480220 Eugene Working Capital 500,000 500,000 0.00 0.00 500,000.00 0 481001 Miscellaneous Receipts 15,500 15,500 561.00 8,367.65 7,132.35. 54 * 491221 XFR from fund 433 4,000,000 0 0.00 0.00 0.00 0 499999 Beginning Cash Balance 4,552,144 5,247,283 0.00 5,247,283.39 -0.39 100 TOTAL FUND: 612 REGIONAL WASTEWATER FUND 26,641,759 23,626,898 2,698,273.38 17,567,032.80 6,059,865.20 74 * ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To Period: FUND: 615 AMBULANCE FUND 9 City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 33 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE 't REC FLAG ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 433513 State Conflagration Funds 0 2,418 0.00 499.70 1,918.30 21 440101 Bad Debt Recovery 20,000 20,000 1,032.70 13,505.25 6,494.75 68 444106 Springfield Pinpoint 2,868,000 2,868,000 183,097.77 1,693,620.91 1,174,379.09 59 444111 PM Membership Fees 600,000 600,000 416.00 546,667.00 53,333.00 91 444113 Ambulance User Fees 0 243,537 0.00 0.00 243,537.00 0 444117 PM Adm Srvs Reimbursement 125,000 125,000 91,902.42 117,335.39 7,664.61 94 444121 Billing Service Fees 440,000 440,000 36,912.50 269,584.02 170,415.98 61 * 444125 Rural Life Support Fees 5,300 5,300 0.00 5,592.00 -292.00 106 461001 Interest Income 25,000 25,000 2,680.80 30,775.62 -5,775.62 123 461002 Variance in FMV of Investments 0 0 0.00 6,272.80 -6,272.80 0 465021 Firemed Donations 200 200 0.00 367.50 -167.50 184 480211 W.C. Time Loss Recov. 0 0 0.00 2,368.59 -2,368.59 0 481001 Miscellaneous Receipts 2,500 2,500 87.40 1,778.13 721.87 71 499999 Beginning Cash Balance 635,020 516,048 0.00 516,047.74 0.26 100 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 'TOTAL FUND: 615 AMBULANCE FUND 4,721,020 4,848,003 316,129.59 3,204,414.65 1,643,588.35 66 ===================================================================================================================================================================================== Report 10: SPRG506 From Period: 1 To period: 9 FUND: 617 STORM DRAINAGE OPERATIONS FUND City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 34 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE % REC FLAG 425002 Planning Fees 149,620 149,620 0.00 0.00 149,620.00 0 * 428020 Land Alt. And Fill Permit 110,000 110,000 5,475.00 80,145.00 29,855.00 73 * 428030 Engineering Fees 6,000 6,000 0.00 0.00 6,000.00 0 448030 Int Engineering Fees 60,000 60,000 0.00 0.00 60,000.00 0 448031 Staff Reimbursement 45,000 45,000 0.00 0.00 45,000.00 0 * 449017 Drainage User Fees 3,949,297 3,949,297 322,608.20 2,545,363.44 1,403,933.56 64 * 461001 Interest Income 21,100 21,100 4,034.51 35,399.96 -14,299.96 168 461002 Variance in FMV of Investments 0 0 0.00 7,627.84 -7,627.84 0 463011 Lease Income 2,500 2,500 0.00 0.00 2,500.00 0 * 480211 W.C. Time Loss Recov. 0 17,140 0.00 10,150.24 6,989.76 59 * 481001 Miscellaneous Receipts 0 2,000 250.00 2,803.01 -803.01 140 481002 Prior Year Engineering Revenue 30,000 30,000 0.00 0.00 30,000.00 0 499999 Beginning Cash Balance 602,419 967,540 0.00 967,539.89 0.11 100 TOTAL FUND: 617 STORM DRAINAGE OPERATIONS 4,975,936 5,360,197 332,367.71 3,649,029.38 1,711,167.62 68 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield STATUS OF REVENUES MONTH ENDING MARCR 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 35 Run Date 04/10/2007 Run Time 09:07:15 Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 618 BOOTIl-KELLY FUND ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE % REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 461001 Interest Income 45,000 45,000 5,535.25 47,717.98 -2,717.98 106 461002 Variance in FMV of Investments 0 0 0.00 8,979.79 -8,979.79 0 463011 Lease Income 60,000 60,000 3,981.51 38,268.14 21,731. 86 64 * 463021 B-Kelly Leases-Rent 525,000 525,000 45,454.15 401,446.08 123,553.92 76 463022 B-Kelly Leases-Utilities 16,000 16,000 1,461.25 10,351. 25 5,648.75 65 * 463023 B-Kelly Leases-Taxes 39,000 39,000 1,724.44 16,955.78 22,044.22 43 463024 B-Kelly Leases-Insurance 8,000 8,000 664.16 6,017.32 1,982.68 75 499999 Beginning Cash Balance 1,147,096 1,219,855 0.00 1,219,854.88 0.12 100 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 618 BOOTIl-KELLY FUND 1,840,096 1,912,855 58,820.76 1,749,591.22 163,263.78 91 =========================================================~=========================================================================================================================== Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 629 REGIONAL FIBER CONSORTIUM ACCOUNT DESCRIPTION 461001 461002 463011 499999 Interest Income Variance in FMV of Investments Lease Income Beginning Cash Balance TOTAL FUND: 629 REGIONAL FIBER CONSORTIUM ADOPTED BUDGET 2,600 o 15,000 124,394 141,994 City of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED REVISED BUDGET CURRENT RECEIVED YID RECEIVED 1,169.06 405.23 0.00 50,266.95 51,841. 24 BALANCE 1,430.94 -405.23 15,000.00 148,254.05. 164,279.76 Page No. 36 Run Date 04/10/2007 Run Time 09:07:15 % REC FLAG 2,600 o 15,000 198,521 83.20 0.00 0.00 0.00 45 o o 25 * 216,121 83.20 24 * ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To Period: FUND: 707 INSURANCE FUND 9 City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 37 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE '" REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 435521 OR EmploY-At-Injury 30,000 30,000 10,451.68 11,213.53 18,786.47 37 440025 Int Insurance Chgs 718,875 718,875 59,458.68 536,849.10 182,025.90 75 * 440026 Internal Benefits Charges 349,850 349,850 28,939.81 261,262.29 88,587.71 75 * 440027 Workers Camp Chgs 810,750 810,750 72,790.01 680,457.95 130,292.05 84 452111 Flexible Spending Forfeit 2,300 2,300 0.00 68.77 2,231. 23 3 * 461001 Interest Income 88,000 88,000 11,928.22 97,782.55 -9,782.55 111 461002 Variance in FMV of Investments 0 0 0.00 19,107.27 -19,107.27 0 480212 W.C. Prem Refunds & Dividends 0 0 0.00 60,706.21 -60,706.21 0 480215 Claims Recovery 42,000 42,000 10,856.68 15,404.98 26,595.02 37 481001 Miscellaneous Receipts 10,000 10,380 0.00 0.00 10,380.00 0 * 491161 Employee Benefits 10,868,300 10,868,300 813,174.10 6,393,074.47 4,475,225.53 59 * 491162 HRA Benefit 680,000 680,000 60,500.00 537,775.00 142,225.00 79 499999 Beginning Cash Balance 2,103,156 2,333,902 0.00 2,333,902.08 -0.08 100 ----------~-------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 707 INSURANCE FUND 15,703,231 15,934,357 1,068,099.18 10,947,604.20 4,986,752.80 69 * ====~=~================================================================================~============================================================================================= Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 713 VEHICLE & EQUIPMENT FUND City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 38 Run Date 04/10/2007 Run Time 09:07:15 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG 440015 Int Computer Eq Chgs 240,846 240,846 19,861. 00 178,749.00 62,097.00 74 * 440018 Fire Engine Lease 41,953 41,953 0.00 0.00 41,953.00 0 440021 Int Tele Lease Contr 9,124 9,124 652.05 5,868.45 3,255.55 64 * 440022 Int Microsoft Enterprise Chrg 101,460 101,460 8,455.00 76,095.00 25,365.00 75 440028 Internal Lease Charges 17,764 18,911 1,480.33 13,322.97 5,588.03 70 * 444029 Int Equipment Chgs 603,027 603,027 50,252.25 452,270.25 150,756.75 75 461001 Interest Income 200,000 200,000 21,705.50 191,076.18 8,923.82 96 461002 Variance in FMV of Investments 0 0 0.00 36,993.71 -36,993.71 0 464003 Vehicle Sales 0 0 6,264.00 6,264.00 -6,264.00 0 499999 Beginning Cash Balance 5;039,692 5,180,603 0.00 5,180,603.17 -0.17 100 TOTAL FUND: 713 VEHICLE & EQUIPMENT FUND 6,253,866 6,395,924 108,670.13 6,141,242.73 254,681.27 96 ACCOUNT DESCRIPTION -----------------~------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 39 Run Date 04/10/2007 Run Time 09:07:15 Report ID: SPRG506 From Period: 1 To Period: 9 FUND: 719 SDC ADMINISTRATION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE 'Ii RIlC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 426604 SDC Admin Fee 45,065 151,642 8.,470.63 67,981.12 83,660.88 45 * 440016 Int Admin Fee 421,000 421,000 105,260.00 315,780.00 105,220.00 75 461001 Interest Income 4,015 4,015 391. 79 2,389.98 1,625.02 60 461002 Variance in FMV of Investments 0 0 0.00 1,057.46 -1,057.46 0 499999 Beginning Cash Balance 148,302 41,725 0.00 41,725.40 -0.40 100 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 719 SOC ADMINISTRATION 618,382 618.382 114,122.42 428,933.96 189,448.04 69 * =~=================================================================================================================================================================================== Report 10: SPRG506 From Period: 1 TO period: 9 FUND: 719 SDC ADMINISTRATION ACCOUNT DESCRIPTION ADOPTED BUDGET Grand Total: 265,384,764 City Of Springfield STATUS OF REVENUES MONTH ENDING MARCH 31, 2007 75.0 PERCENT OF FISCAL YEAR HAS ELAPSED REVISED BUDGET CURRENT RECEIVED 284,294,021 -10,557,388.63 End of Report YTD RECEIVED -213,661,427.01 BALANCE 497,955,448.01 Page No. 40 Run Date 04/10/2007 Run Time 09:08:36 'Ii RllC FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 1 Run Date 04/10/2007 Run Time 08:57:53 Report ID: SPRG508.SQR FUND : 100 General Fund ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG . -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 1,160,491 1,252,941 96,221.02 857,146.94 395,794.06 68 Court 1,254,096 1,254,096 108,380.91 935,381.01 318,714.99 75 HR 411,075 424,425 32,315.93 307,917.82 116,507.18 73 Finance 815,051 830,051 60,149.81 586,635.54 243,415.46 71 IT 1,256,219 1,256,219 115,938.04 912,353.17 343,865.83 73 Fire 8,345,487 8,499,729 778,464.87 6,469,302.33 2,030,426.67 76 **** Police 10,848,019 10,913,019 829,021.36 8,075,268.67 2,837,750.33 74 Library 1,259,006 1,286,662 114,024.27 919,578.09 367,083.91 71 Public Works 878,289 878,289 64,818.35 599,919.00 278,370.00 68 DSD 1,525,463 1,591,391 124,217.27 1,027,077.97 564,313.03 65 Departmental Operating: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 27,753,196 28,186,822 2,323,551. 83 20,690,580.54 7,496,241.46 Capital Projects o o 0.00 0.00 0.00 o ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 40,250 202,250 0.00 0.00 202,250.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 800,000 800,000 0.00 0.00 800,000.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 5,857,412 5,884,495 0.00 0.00 5,884,495.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Non Departmental: 6,697,662 6,886,745 0.00 0.00 6,886,745.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 34,450,858 35,073,567 2,323,551.83 20,690,580.54 14,382,986.46 Report ID: SPRG508.SQR FUND : 201 street Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 2 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING tEXP FLAG CMO 11,069 11,069 0.00 11,069.00 0.00 100 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 4,833,253 4,899,001 370,946.27 3,378,163.30 1,520,837.70 69 DSD 50,209 50,209 3,980.68 38,039.24 12,169.76 76 **** **** Departmental Operating: 4,894,531 4,960,279 374,926.95 3,427,271.54 1,533,007.46 Capital Projects o o 0.00 0.00 0.00 o Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0..00 0 Interfund Transfers 750,000 751,005 0.00 750,000.00 1,005.00 100 **** Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 1,233,891 1,337,789 0.00 0.00 1,337,789.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 1,983,891 2,088,794 0.00 750,000.00 1,338,794.00 Total Fund: 6,878,422 7,049,073 374,926.95 4,177,271. 54 2,871,801.46 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 3 Run Date 04/10/2007 Run Time 08:57:53 Report ID: SPRG508.SQR FUND : 202 Jail Operations ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING 'kEXP FLAG ----------------------------------------------------- CMO Court HR Finance IT Fire Police Library Public Works DSD --------------------------------------------------------------------------------------------------------------------------- 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 Departmental Operating: ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 0.00 0.00 0.00 Capital Projects o o 0.00 0.00 0.00 o ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 0 25,000 0.00 0.00 25,000.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Non Departmental: o 25,000 0.00 0.00 25,000.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- o 25,000 0.00 0.00 25,000.00 Report ID: SPRG50B.SQR FUND : 203 Museum Fund city Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 4 Run Date 04/10/2007 Run Time OB:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING 'kEXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: o o 0.00 0.00 0.00 Capital Projects o o 0.00 0.00 0.00 o Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 0 0 0.00 0.00 0.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: o. o 0.00 0.00 0.00 Total Fund: o o 0.00 0.00 0.00 Report ID: SPRG508.SQR FUND : 204 Special Revenue Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 5 Run Date 04/10/2007 Run Time 08:57:53 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 33,166 33,166 0.00 33,166.00 0.00 100 **** Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 30,000 30,000 0.00 7,220.99 22,779.01 24 IT 0 0 0.00 0.00 0.00 0 Fire 50,000 56,679 0.00 5,000.00 51,679.00 9 Police 527,313 772,313 23,457.74 529,162.57 243,150.43 69 Library 10,746 16,324 510.21 4,536.39 11,787.61 28 Public Wo~ks 0 1,000 0.00 0.00 1,000.00 0 DSD 1,962 17,336 1,469.72 5,457.59 11,878.41 31 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Departmental Operating: 653,187 926,818 25,437.67 584,543.54 342,274.46 Capital Projects o o 0.00 0.00 0.00 o ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 15,000 15,000 0.00 0.00 15,000.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Non Departmental: 15,000 15,000 0.00 0.00 15,000.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 668,187 941,818 25,437.67 584,543.54 357,274.46 Report ID: SPRG508.SQR FUND : 208 Transient Room Tax Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 6 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING 'tEXP FLAG CMO 194,467 194,467 6,037.78 115,049.44 79,417.56 59 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 police 0 0 0.00 0.00 0.00 0 Library 49,050 48,136 2,505.36 17,271.48 30,864.52 36 Public Works 26,405 26,405 4,075.40 19,266.68 7,138.32 73 DSD 49,974 49,974 3,833.40 31,325.20 18,648.80 63 Departmental Operating: 319,896 318,982 16,451. 94 182,912.80 136,069.20 Capital Projects o o 0.00 0.00 0.00 o Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 385,493 385,493 23,033.03 315,517.20 69,975.80 82 **** Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 32 32 0.00 0.00 32.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 385,525 385,525 23,033.03 315,517.20 70,007.80 Total Fund: 705,421 704,507 39,484.97 498,430.00 206,077.00 ------------------------------------------------~------------------------------------------------------------------------------------------------------------------------------- City Of Springfield BUDGET 1\ND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 7 Run Date 04/10/2007 Run Time 08:57:53 Report ID: SPRG508.SQR FUND : 210 Community Development Fund ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING tEXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO Court HR Finance IT Fire Police Library Public Works DSD Departmental Operating: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 15,754 15,754 1,299.48 11,762.51 3,991.49 75 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 815,881 2,157,071 28,804.32 489,713.01 1,667,357.99 23 831,635 2,172,825 30,103.80 501,475.52 1,671,349.48 Capital Projects 858,742 2,222,323 11,898.38 1,873,216.01 349,106.99 84 **** ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 858,742 2,222,323 11,898.38 1,873,216.01 349,106.99 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 0 6,339 0.00 0.00 6,339.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Non Departmental: o 6,339 0.00 0.00 6,339.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 1,690,377 4,401,487 42,002.18 2,374,691.53 2,026,795.47 Report ID: SPRG508.SQR FUND : 222 RiverBend Development Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 8 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 38,977 95,820 4,103.82 11,487.41 84,332.59 12 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 613,373 883,373 51,962.31 472,661.34 410,711. 66 54 DSD 0 0 0.00 119.90 -119.90 0 .*** Departmental Operating: 652,350 979,193 56,066.13 484,268.65 494,924.35 Capital Projects o o 0.00 0.00 0.00 o Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 0 0 0.00 0.00 0.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: o o 0.00 0.00 0.00 Total Fund: 652,350 979,193 56,066.13 484,268.65 494,924.35 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 9 Run Date 04/10/2007 Run Time 08:57:53 Report ID: SPRG508.SQR FUND : 224 Building COde Fund ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING \EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 2,198,474 2,198,474 169,040.59 1,412,232.46 786,241. 54 64 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 2,198,474 2,198,474 169,040.59 1,412,232.46 786,241.54 Departmental Operating: Capital Projects o o 0.00 0.00 0.00 o ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 47,673 47,673 3,972.75 35,754.75 11,918.25 75 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 2,284,828 1,869,441 0.00 0.00 1,869,441.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 2,332,501 1,917,114 3,972.75 35,754.75 1,881,359.25 Total Non Departmental: Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 4,530,975 4,115,588 173,013.34 1,447,987.21 2,667,600.79 Report ID: SPRG508.SQR FUND : 235 Fire Local Option Levy City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 10' Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 1,124,311 1,126,822 121,856.12 810,211.82 316,610.18 72 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 1,124,311 1,126,822 121,856.12 810,211. 82 316,610.18 Capital Projects o o 0.00 0.00 0.00 o Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 314,599 430,951 0.00 0.00 430,951.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 314,599 430,951 0.00 0.00 430,951.00 Total Fund: 1,438,910 1,557,773 121,856.12 810,211. 82 747,561.18 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield BUDGET AND ACTUAL REPORT BY FUND /DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 11 Run Date 04/10/2007 Run Time 08:57:53 Report ID: SPRG508.SQR FUND : 236 Police Local Option Levy ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 0 0 0.00 0.00 0.00 0 Court 202,109 202,109 9,926.20 96,223.40 105,885.60 48 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 1,762,758 1,762,758 135,138.51 1,224,051. 82 538,706.18 69 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 1,964,867 1,964,867 145,064.71 1,320,275.22 644,591.78 Departmental Operating: Capital Projects o o 0.00 0.00 0.00 o ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 790,001 1,512,410 0.00 0.00 1,512,410.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ------------------------------------------------------------------------------------'---------------------------------------------------------------------- 790,001 1,512,410 0.00 0.00 1,512,410.00 Total Non Departmental: Total Fund: ----------------------------------------------------------------------------------------------------------------------------------------------------------- 2,754,868 3,477,277 145,064.71 1,320,275.22 2,157,001.78 Report ID: SPRG508.SQR FUND : 305 Bancroft Redemption Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 12 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 25,447 25,447 644.85 13,201. 66 12,245.34 52 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 25,447 25,447 644.85 13,201. 66 12,245.34 Capital Projects o o 0.00 0.00 0.00 o Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 375,000 475,187 0.00 350,425.72 124,761. 28 74 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 1,718,720 1,754,028 0.00 0.00 1,754,028.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 2,093,720 2,229,215 0.00 350,425.72 1,878,789.28 Total Fund: 2,119,167 2,254,662 644.85 363,627.38 1,891,034.62 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 13 Run Date 04/10/2007 Run Time 08:57:53 Report ID: SPRG508.SQR FUND : 306 Bond Sinking Fund ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 0.00 0.00 0.00 Departmental Operating: Capital Projects o o 0.00 0.00 0.00 o ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 1,398,135 1,398,135 0.00 272,408.70 1,125,726.30 19 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 388,591 388,591 12,500.00 12,500.00 376,091. 00 3 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 177,869 177,869 0.00 0.00 177,869.00 0 Reserves 0 27,658 0.00 0.00 27,658.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 1,964,595 1,992,253 12,500.00 284,908.70 1,707,344.30 Total Non Departmental: Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 1,964,595 1,992,253 12,500.00 284,908.70 1,707,344.30 Report ID: SPRG508.SQR FUND : 409 Sanitary Sewer Capital Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 14 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: o o 0.00 0.00 0.00 Capital Projects 3,458,654 4,019,654 253,668.85 497,350.79 3,522,303.21 12 Total Capital Projects: 3,458,654 4,019,654 253,668.85 497,350.79 3,522,303.21 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 97,499 547,620 0.00 0.00 547,620.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 97,499 547,620 0.00 0.00 547,620.00 Total Fund: 3,556,153 4,567,274 253,668.85 497,350.79 4,069,923.21 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 15 Run Date 04/10/2007 Run Time 08:57:53 Report ID: SPRG508.SQR FUND : 416 SDC Capital Projects Fund ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 0.00 0.00 0.00 Departmental Operating: Capital Projects o o 0.00 0.00 0.00 o ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 0 0 0.00 0.00 0.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Non Departmental: o o 0.00 0.00 0.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 0.00 0.00 0.00 Report ID: SPRG508.SQR FUND : 419 Development Assessment Capital City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED ADOPTED BUDG YTD EXPEND REMAINING REVISED BUDG CURRENT PD %EXP CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 91,451 91,451 3,692.58 58,300.59 33,150.41 64 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 91,451 91,451 3,692.58 58,300.59 33,150.41 Capital Projects 74,000 74,000 248.42 31,023.87 42,976.13 Total Capital Projects: 74,000 74,000 248.42 31,023.87 42,976.13 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 35,447 35,447 0.00 10,000.00 25,447.00 28 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Mise Fiscal Transactions 20,000 20,000 0.00 0.00 20,000.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 1,342,673 1,395,108 0.00 0.00 1,395,108.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 10,000.00 1,440,555.00 1,398,120 1,450,555 0.00 Total Fund: 1,616,006 1,516,681.54 3,941.00 99,324.46 1,563,571 Page No. 16 Run Date 04/10/2007 Run Time 08:57:53 FLAG 42 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 17 Run Date 04/10/2007 Run Time 08:57:53 Report ID: SPRG508.SQR FUND . 420 Development Projects ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 46,240 0.00 0.00 46,240.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Departmental Operating: o 46,240 0.00 0.00 46,240.00 Capital Projects 15,855,916 19,546,716 230,795.74 3,692,861.16 15,853,854.84 19 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 15,855,916 19,546,716 230,795.74 3,692,861.16 15,853,854.84 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 1,100,000 1,500,000 0.00 0.00 1,500,000.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 2,178,053 1,836,921 0.00 0.00 1,836,921.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 3,278,053 3,336,921 0.00 0.00 3,336,921.00 Total Non Departmental: Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 19,133,969 22,929,877 230,795.74 3,692,861.16 19,237,015.84 Report ID: SPRG508.SQR FUND : 425 Storm Drainage Capital Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 18 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: o o 0.00 0.00 0.00 Capital Projects 837,835 1,177,748 3,544.10 60,118.24 1,117,629.76 5 Total Capital Projects: 837,835 1,177,748 3,544.10 60,118.24 1,117,629.76 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 771,075 881,944 0.00 0.00 881,944.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 771,075 881,944 0.00 0.00 881,944.00 Total Fund: 1,608,910 2,059,692 3,544.10 60,118.24 1,999,573.76 Report ID: SPRG508.SQR FUND : 427 GO Bond Capital Projects City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 19 Run Date 04/10/2007 Run Time 08:57:53 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Departmental Operating: o o 0.00 0.00 0.00 Capital Projects 29,896 21,060 0.00 0.00 21,060.00 o ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 29,896 21,060 0.00 0.00 21,060.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 0 0 0.00 0.00 0.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 0.00 0.00 0.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 29,896 21,060 0.00 0.00 21,060.00 Report ID: SPRG508.SQR FUND : 428 Police Building Bond Cap proj City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 20 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 1,456,557 1,766,557 11,163.76 1,280,555.60 486,001.40 72 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 1,456,557 1,766,557 11,163.76 1,280,555.60 486,001.40 Capital Projects 24,565,735 25,848,524 0.00 76,369.48 25,772,154.52 o Total Capital Projects: 24,565,735 25,848,524 0.00 76,369.48 25,772,154.52 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 300,000 300,000 0.00 0.00 300,000.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 300,000 300,000 0.00 0.00 300,000.00 Total Fund: 26,322,292 27,915,081 11,163.76 1,356,925.08 26,558,155.92 Report ID: SPRG508.SQR FUND : 429 SEDA Capital Project Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 21 Run Date 04/10/2007 Run Time 08:57:53 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 403,000 403,000 26,059.30 58,354.75 344,645.25 14 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 ------------------------------------------------->--------------------------------------------------------------------------------------------------------- 403,000 403,000 26,059.30 58,354.75 344,645.25 Departmental Operating: Capital Projects 2,317,000 2,317,000 0.00 49,700.00 2,267,300.00 2 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 2,317,000 2,317,000 0.00 49,700.00 2,267,300.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 108,000 108,000 0.00 0.00 108,000.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 0 0 0.00 0.00 0.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Non Departmental: 108,000 108,000 0.00 0.00 108,000.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 2,828,000 2,828,000 26,059.30 108,054.75 2,719,945.25 Report ID: SPRG508.SQR FUND : 433 Regional Wastewater Capital Fd City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 22 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 573,335 854,015 10,255.49 164,599.86 689,415.14 19 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 573,335 854,015 10,255.49 164,599.86 689,415.14 Capital Projects 45,253,276 46,945,089 816,245.93 8,132,579.22 38,812,509.78 17 Total Capital Projects: 45,253,276 46,945,089 816,245.93 8,132,579.22 38,812,509.78 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 4,000,000 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 762,500 762,500 0.00 350,485.08 412,014 . 92 46 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 12,930,249 22,046,076 0.00 0.00 22,046,076.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 17,692,749 22,808,576 0.00 350,485.08 22,458,090.92 Total Fund: 63,519,360 70,607,680 826,501. 42 8,647,664.16 61,960,015.84 Report ID: SPRG508.SQR FUND : 434 Street Capital Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 23 Run Date 04/10/2007 Run Time 08:57:53 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 0 0 0.00 0.00 0.00 Court 0 0 0.00 0.00 0.00 HR 0 0 0.00 0.00 0.00 Finance 0 0 0.00 0.00 0.00 IT 0 0 0.00 0.00 0.00 Fire 0 0 0.00 0.00 0.00 Police 0 0 0.00 0.00 0.00 Library 0 0 0.00 0.00 0.00 Public Works 0 0 0.00 0.00 0.00 DSD 0 0 0.00 0.00 0.00 Departmental Operating: ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o o o o o o o o o o o 0.00 0.00 0.00 Capital Projects 2,653,573 3,113,903 22,927.16 226,366.74 2,887,536.26 7 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 2,653,573 3,113,903 22,927.16 226,366.74 2,887,536.26 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 729,145 206,696 0.00 0.00 206,696.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 729,145 206,696 0.00 0.00 206,696.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 3,382,718 3,320,599 22,927.16 226,366.74 3,094,232.26 Report ID: SPRG508.SQR FUND : 435 Transportation SDC Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 24 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: o o 0.00 0.00 0.00 Capital Projects o o 0.00 0.00 0.00 o Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 0 0 0.00 0.00 0.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: o o 0.00 0.00 0.00 Total Fund: o o 0.00 0.00 0.00 Report ID: SPRG508.SQR FUND : 436 Sewer SDC Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FllND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 25 Run Date 04/10/2007 Run Time 08:57:53 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO Court HR Finance IT Fire Police Library Public Works DSD --------------------------------------------------------------------------------------------------------------------------- Departmental Operating: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 o o 0.00 0.00 0.00 Capital Projects o o 0.00 0.00 0.00 o ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 0 0 0.00 0.00 0.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total NonDepartmental: ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 0.00 0.00 0.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 0.00 0.00 0.00 Report ID: SPRG508.SQR FUND : 437 Regional Wastewater SDC Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 26 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: o o 0.00 0.00 0.00 Capital Projects o o 0.00 0.00 0.00 o Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 0 0 0.00 0.00 0.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: o o 0.00 0.00 0.00 Total Fund: o o 0.00 0.00 0.00 C' -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 27 Run Date 04/10/2007 Run Time 08:57:53 Report ID: SPRG508.SQR FUND : 440 Storm Drainage SDC Fund ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 67,761 67,761 16,940.00 50,820.00 16,941.00 75 DSD 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Departmental Operating: 67,761 67,761 16,940.00 50,820.00 16,941. 00 Capital Projects 1,058,500 1,478,010 0.00 168,949.54 1,309,060.46 11 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 1,058,500 1,478,010 0.00 168,949.54 1,309,060.46 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers .25,649 225,649 0.00 25,649.00 200,000.00 11 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 1,795,947 1,407,009 0.00 0.00 1,407,009.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 1,821,596 1,632,658 0.00 25,649.00 1,607,009.00 Total Non Departmental: Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 2,947,857 3,178,429 16,940.00 245,418.54 2,933,010.46 Report ID: SPRG508.SQR FUND : 442 Sanitary Sewer Reimb SDC Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 28 Run Date 04/10/2007 Run Time 08:57:53 ~ . -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 45,831 45,831 11,460.00 34,380.00 11,451. 00 75 **** DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 45,831 45,831 11,460.00 34,380.00 11,451.00 Capital Projects 150,000 120,192 0.00 0.00 120,192.00 o Total Capital Projects: 150,000 120,192 0.00 0.00 120,192.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 359,500 467,467 0.00 0.00 467,467.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 359,500 467,467 0.00 0.00 467,467.00 Total Fund: 555,331 633,490 11,460.00 34,380.00 599,110.00 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 29 Run Date 04/10/2007 Run Time 08:57:53 Report ID: SPRG508.SQR FUND : 443 Sanitary Sewer Improvement SDC ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 34,831 34,831 8,710.00 26,130.00 8,701.00 75 **** DSD 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 34,831 34,831 8,710.00 26,130.00 8,701.00 Departmental Operating: Capital Projects 1,240,557 1,389,089 4,989.20 45,327.96 1,343,761.04 3 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 1,240,557 1,389,089 4,989.20 45,327.96 1,343,761. 04 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 45,662 45,662 0.00 45,662.00 0.00 100 **** Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 92,119 107,991 0.00 0.00 107,991.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Non Departmental: 137,781 153,653 0.00 45,662.00 107,991.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 1,413,169 1,577,573 13,699.20 117,119.96 1,460,453.04 Report ID: SPRG508.SQR FUND : 444 SDC Regional Wastewater Reimb City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 30 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 416.70 1,863.37 -1,863.37 0 **.* DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: o o 416.70 1,863.37 -1,863.37 Capital Projects 3,775,000 3,796.321 0.00 111,830.65 3,684,490.35 3 Total Capital Projects: 3,775,000 3,796,321 0.00 111,830.65 3,684,490.35 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Mise Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 1,261,785 1,325,928 0.00 0.00 1,325,928.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 1,261,785 1,325,928 0.00 0.00 1,325,928.00 Total Fund: 5,036,785 5,122,249 416.70 113,694.02 5,008,554.98 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield BUDGET AND ACTUAL REPORT BY FUND /DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 31 Run Date 04/10/2007 Run Time 08:57:53 Report ID: SPRG508.SQR FUND : 445 SDC Regional Wastewater Imp ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0_.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 63.62 284.74 -284.74 0 **** DSD 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Departmental Operating: o o 63.62 284.74 -284.74 Capital Projects 2,120,000 2,869,899 0.00 21,935.53 2,847,963.47 1 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 2,120,000 2,869,899 0.00 21,935.53 2,847,963.47 Interfund Loans 0 0 0.00 0.00 0'.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 2,818,472 3,185,259 0.00 0.00 3,185,259.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total' Non Departmental: 2,818,472 3,185,259 0.00 0.00 3,185,259.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 4,938,472 6,055,158 63.62 22,220.27 6,032,937.73 Report ID: SPRG508.SQR FUND : 446 SDC Transportation Reimburseme City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 32 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 51,993 51,993 13,000.00 39,000.00 12,993.00 75 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 51,993 51,993 13,000.00 39,000.00 12,993.00 Capital Projects 672,700 592,782 1,532.93 318,843.35 273,938.65 54 Total'Capital Projects: 672,700 592,782 1,532.93 318,843.35 273,938.65 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 10,374 120,374 0.00 10,374.00 110,000.00 9 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Mise Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 181,846 79,008 0.00 0.00 79,008.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 192,220 199,382 0.00 10,374.00 189,008.00 Total Fund: 916,913 844,157 14,532.93 368,217.35 475,939.65 Report ID: SPRG508.SQR FUND : 447 SDC Transportation Improvement City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 33 Run Date 04/10/2007 Run Time 08:57:53 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 220,584 220,584 55,150.00 165,450.00 55,134.00 75 **** DSD 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Departmental Operating: 220,584 220,584 55,150.00 165,450.00 55,134.00 Capital Projects 2,767,760 3,004,238 44,241. 03 254,169.88 2,750,068.12 8 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 2,767,760 3,004,238 44,241. 03 254,169.88 2,750,068.12 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 84,191 261,387 0.00 0.00 261,387.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Non Departmental: 84,191 261,387 0.00 0.00 261,387.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 3,072,535 3,486,209 99,391.03 419,619.88 3,066,589.12 Report ID: SPRG508.SQR FUND : 611 Sanitary Sewer Operations Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 34 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 8,797 8,797 624.59 6,155.88 2,641.12 70 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 2,699,374 2,721,634 188,386.58 1,693,712.29 1,027,921.71 62 DSD 20,751 20,751 1,079.78 14,051. 08 6,699.92 68 Departmental Operating: 2,728,922 2,751,182 190,090.95 1,713,919.25 1,037,262.75 Capital Projects o o 0.00 0.00 0.00 o Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 1,452,292 1,452,292 363,073.00 1,089,219.00 363,073.00 75 Debt Service 603,562 603,562 0.00 357,309.06 246,252.94 59 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 1,023,643 1,239,516 0.00 0.00 1,239,516.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 3,079,497 3,295,370 363,073.00 1,446,528.06 1,848,841. 94 Total Fund: 5,808,419 6,046,552 553,163.95 3,160,447.31 2,886,104.69 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 35 Run Date 04/10/2007 Run Time 08:57:53 Report ID: SPRG508.SQR FUND : 612 Regional Wastewater Fund ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 0 0 0.00 . '0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 124,069 124,069 5,142.30 59,151.56 64,917.44 48 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 12,910,965 13,186,388 887,298.35 8,576,311.80 4,610,076.20 65 DSD 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Departmental Operating: 13,035,034 13,310,457 892,440.65 8,635,463.36 4,674,993.64 Capital Projects o o 0.00 0.00 0.00 o ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 3,829,646 3,829,646 319,137.17 2,872,234.53 957,411.47 75 **** Debt Service 1,473,431 1,200,000 0.00 0.00 1,200,000.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 8,303,648 5,286,795 0.00 0.00 5,286',795.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Non Departmental: 13 ,606,725 10,316,441 319,137.17 2,872,234.53 7,444,206.47 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 26,641,759 23,626,898 1,211,577.82 11,507,697.89 12,119,200.11 Report ID: SPRG508.SQR FUND : 615 Ambulance Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 36 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 4,218,182 4,488,487 338,704.13 2,751,965.63 1,736,521.37 61 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 4,218,182 4,488,487 338,704.13 2,751,965.63 1,736,521.37 Capital Projects o o 0.00 0.00 0.00 o Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 502,838 359,516 0.00 0.00 359,516.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 502,838 359,516 0.00 0.00 359,516.00 Total Fund: 4,721,020 4,848,003 338,704.13 2,751,965.63 2,096,037.37 Report ID: SPRG508.SQR FUND : 617 Storm Drainage Operations Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Y~ar 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 37 Run Date 04/10/2007 Run Time 08:57:53 ------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO Court HR Finance IT Fire Police Library Public Works DSD ------------------------------------------------------------------------------------------------------------------------------------------- 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 8,797 8,797 624.26 6,155.53 2,641.47 70 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 0 0 0.00 0.00 0.00 0 3,827,824 3,911,484 304,274.65 2,426,539.66 1,484,944.34 62 33,690 33,690 2,463.84 24,115.65 9,574.35 72 Departmental Operating: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 3,870,311 3,953,971 307,362.75 2,456,810.84 1,497,160.16 Capital Projects o o 0.00 0.00 0.00 o ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 620,000 620,000 155,000.00 465,000.00 155,000.00 75 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 485,625 786,226 0.00 0.00 786,226.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 1,105,625 1,406,226 155,000.00 465,000.00 941,226.00 Total Non Departmental: Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 4,975,936 5,360,197 462,362.75 2,921,810.84 2,438,386.16 Report ID: SPRG508.SQR FUND : 618 Booth-Kelly Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 38 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 13,458 21,658 2,617.54 14,910.42 6,747.58 69 DSD 343,414 335,214 27,926.11 269,025.65 66,188.35 80 **** Departmental Operating: 356,972 356,872 30,543.65 283,936.07 72,935.93 Capital Projects 245,000 245,000 8,172.49 8,172.49 236,827.51 3 Total Capital Projects: 245,000 245,000 8,172.49 8,172.49 236,827.51 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 39,657 375,162 3,304.75 29,742.75 345,419.25 8 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 1,198,567 935,821 0.00 0.00 935,821.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 1,238,224 1,310,983. 3,304.75 29,742.75 1,281,240.25 Total Fund: 1,840,096 1,912,855 42,020.89 321,851. 31 1,591,003.69 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 39 Run Date 04/10/2007 Run Time 08:57:53 Report ID: SPRG508.SQR FUND : 629 Regional Fiber Consortium ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 17,000 22,000 0.00 17,853.05 4,146.95 81 **** DSD 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 17,000 22,000 0.00 17,853.05 . 4,146.95 Departmental Operating: Capital Projects o o 0.00 0.00 0.00 o ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 12,000 12,000 0.00 12,000.00 0.00 100 **** Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 6,500 6,500 0.00 0.00 6,500.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 106,494 175,621 0.00 0.00 175,621. 00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 124,994 194,121 0.00 12,000.00 182,121.00 Total Non Departmental: Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 141,994 216,121 0.00 29,853.05 186,267.95 Report ID: SPRG508.SQR FUND : 707 Insurance Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 40 Run Date 04/10/2007 Run Time 08:57:53 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 654,953 655,333 40,245.44 400,636.53 254,696.47 61 Finance 0 0 0.00 0.00 0.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 0 0 0.00 0.00 0.00 0 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 654,953 655,333 40,245.44 400,636.53 254,696.47 Capital Projects o o 0.00 0.00 0.00 o Total Capital Projects: 0 .0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 12,668,589 12,668,589 958,981.10 7,756,593.51 4,911,995.49 61 Mise Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 2,379,689 2,610,435 0.00 0.00 2,610,435.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non.Departmental: 15,048,278 15,279,024 958,981.10 7,756,593.51 7,522,430.49 Total Fund: 15,703,231 15,934,357 999,226.54 8,157,230.04 7,777,126.96 Report ID: SPRG508.SQR FUND : 713 Vehicle & Equipment Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 41 Run Date 04/10/2007 Run Time 08:57:53 ------------------------------------------------------------------------------------------------------------------------------------------------------~------------------------- ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 3,600. 3,600 0.00 1,231.40 2,368.60 34 Court 0 O. 0.00 1,181.01 -1,181. 01 0 HR 3,400 3,400 1,147.80 4,623.92 -1,223.92 136 **** Finance 10,600 10,600 0.00 4,984.22 5,615.78 47 IT 203,960 213,960 55,243.47 63,214.51 150,745.49 30 Fire 2,700 219,246 0.00 45,996.65 173,249.35 21 Police 150,000 332,000 23,261. 99 254,798.69 77,201. 31 77 **** Library 4,400 12,400 0.00 4,707.08 7,692.92 38 Public Works 411,025 412,586 13,957.93 88,363.54 324,222.46 21 DSD 13,400 13,400 0.00 1,534.97 11,865.03 11 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Departmental Operating: 803,085 1,221,192 93,611.19 470,635.99 750,556.01 Capital Projects o o 0.00 0.00 0.00 o ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0;00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 36,422 44,341 908.42 4,865.84 39,475.16 11 Statutory Payments 0 0 0.00 0.00 0.00 0 Mise Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 5,414,359 5,130,391 0.00 0.00 5,130,391.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Non Departmental: 5,450,781 5,174,732 908.42 4,865.84 5,169,866.16 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 6.253,866 6,395,924 94,519.61 475,501. 83 5,920,422.17 Report ID: SPRG508.SQR FUND : 719 SDC Administration City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2007 and Period 9 75 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 42 Run Date 04/10/2007 Run Time 09:15:27 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %EXP FLAG CMO 0 0 0.00 0.00 0.00 0 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 23,063 23,063 1,624.11 16,357.47 6,705.53 71 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 436,478 452,350 17,671.82 192,831.19 259,518.81 43 DSD 101,928 101,928 6,524.23 69,313.18 32,614.82 68 Departmental Operating: 561,469 577,341 25,820.16 278,501.84 298,839.16 Capital Projects o o 0.00 0.00 0.00 o Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 0 0 0.00 0.00 0.00 0 Debt Service 0 0 0.00 0.00 0.00 0 Statutory Payments 0 0 0.00 0.00 0.00 0 Misc Fiscal Transactions 0 0 0.00 0.00 0.00 0 Contingencies 0 0 0.00 0.00 0:00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 56,913 41,041 0.00 0.00 41,041. 00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 56,913 41,041 0.00 0.00 41,041. 00 Total Fund: 618,382 618,382 25,820.16 278,501. 84 339,880.16 Grand Total : 265,384,764 284,294,021 8,577,049.41 78,650,991. 27 205,643,029.73 End of Report