Loading...
HomeMy WebLinkAboutItem 08 Financial Reports for September 2007 AGENDA ITEM SUMMARY SPRINGFIELD Meeting Date: Meeting Type: Department: Staff Contact: Phone No.: Estimated Time: March 3, 2008 Regular Session Finance r:')~ Bob Duey ~ 726-3740 Consent Calendar CITY COUNCIL ITEM TITLE: FINANCIAL REPORTS FOR SEPTEMBER 30, 2007 ACTION REQUESTED: Approval of the following motion to: Accept the Financial Reports for September 30, 2007. ISSUE STATEMENT: The Financial Reports for September 30, 2007 are attached for your review and approval. ATTACHMENTS: Financial Reports for September 30,2007 DISCUSSION/ FINANCIAL IMPACT: Following are revenue highlights of the 1st quarter ended September 30,2007: ~ Local sanitary sewer user fees totaled $1,027,000. ~ Local storm sewer user fees totaled $957,000. ~ SDC fees totaled $993,000. ~ Property tax payments totaled $162,000. ~ ODOT made highway apportionment payments of$612,000. ~ Ambulance payments totaled $397,000. ~ Transient room tax payments totaled $217,000. ~ Local fuel tax payments totaled $295,000. ~ Franchise fee payments totaled $403,000 ~ Municipal Court revenues totaled $252,000. ~ The city earned 5.20% in July, 5.24% in August, and 5.33% in September on its investments. Total: $1,006,000. Report ID: SPRG506 From period: 1 To Period: FUND:, 100 GENERAL FUND 3 City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 1 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE %- REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 411111 Current Taxes 14,659,487 14,659,487 0.00 0.00 14,659,487.00 0 411211 Delinquent Taxes 410,000 410,000 46,354.61 93,314.50 316,685.50 23 420101 Sanipac Franchise 335,000 335,000 0.00 0.00 335,000.00 0 420111 Comcast Franchise 452,000 452,000 0.00 127,258.98 324,741. 02 28 420121 QWeet Franchise 380,000 380,000 0.00 95,880.83 284,119.17 25 420131 NW Natural Gas Franchise 527,000 527,000 0.00 108,700.76 418,299.24 21 .420141 Sprint Franchise 22,000 22,000 0.00 0.00 22,000.00 0 .420151 ATG Right-Of-Way Feee 0 0 0.00 0.00 0.00 0 .420161 EPUD Right-Of-Way Feee 45,000 45,000 425.50 854.76 44,145.24 2 420202 Telecom Licenses 0 0 0.00 1,200.00 -1,200.00 0 421101 Library Receipts 27,000 27,000 1,374.95 4,982.68 22,017.32 18 421111 Library Photocopy Charges 1,000 1,000 0.00 90.00 910.00 9 423141 Animal Licensee/Impound 22,000 22,000 1,800.00 6,100.00 15,900.00 28 423142 Police Impound Fees 128,000 128,000 9,570.00 34,374.00 93,626.00 27 424001 Fire Code Permits 102,000 102,000 12,175.00 97,679.95 4,320.05 96 424002 FLS Safety Systems Plan Review 34,000 34,000 506.34 5,067.18 28,932.82 15 424003 Fire Marshal Reinspection Fee 250 250 0.00 0.00 250.00 0 * 424004 Fire Marshal Referral 500 500 0.00 0.00 500.00 0 * 424005 FLS New Conetr Sq Footage Fee 55,000 55,000 3,135.30 12,167.10 42,832.90 22 * 425002 Planning Fees 855,000 855,000 197,816.11 333,148.59 521,851. 41 39 425005 Peer Review Riverbend 0 0 -5.40 -5.40 5.40 0 425505 DSD Postage Fees 13,450 13,450 1,810.00 3,878.00 9,572.00 29 ,425602 Building Fees 0 0 1,120.00 3,694.00 -3,694.00 0 425605 Technology Fee 111,000 111,000 16,125.26 38,134.22 72,865.78 34 426702 Code Requirement Fees 42,000 42,000 1,395.00 3,869.00 38,131.00 9 428020 Land Alt. And Fill Permit 14,000 14,000 0.00 0.00 14,000.00 0 431186 Team Spfld Bicycle Patrol 10,000 10,000 0.00 0.00 10,000.00 0 431200 Urban Renewal District 60,000 60,000 0.00 0.00 60,000.00 0 433411 Liquor Apportionment 564,991 564,991 0.00 48,563.51 516,427.49 9 * 433412 Cigarette Apportionment 90,558 90,558 9,313.43 17,258.87 73,299.13 19 433413 State Revenue Sharing 389,844 389,844 0.00 112,937.48 276,906.52 29 435556 Dietrict 19-5chool Ree. Prog. 122,000 122,000 0.00 28,666.47 93,333.53 23 435911 SUB In-Lieu-Of-Tax 1,796,000 1,796,000 149,201. 83 447,605.49 1,348,394.51 25 435912 EWEB In-Lieu-Of-Tax 621,000 621,000 59,555.66 91,838.30 529,161. 70 15 435913 Electric Co-ope In-Lieu-Of-Tax 7,582 7,582 0.00 0.00 7,582.00 0 435915 HACSA Mckenzie Vill. In-Lieu-O 0 0 0.00 9,318.61 -9,318.61 0 440005 Int Telephone Chgs 500 500 0.00 33.34 466.66 7 * 440007 Int Facility Rent 207,045 207,045 16,945.42 51,082.00 155,963.00 25 * 440009 Int Data Process Chgs 3,238 3,238 0.00 518.14 2,719.86 16 440011 Int Bldg Maint Chgs 238,098 238,098 19,234.76 58,189.68 179,908.32 24 440013 Int Vehicle Maint Chgs 145,204 145,204 12,100.36 36,301. 08 108,902.92 25 Report ID: SPRG506 From Period: 1 To Period: FUND: 100 GENERAL FUND 3 ACCOUNT DESCRIPTION 443005 443006 443016 444007 444008 444009 445017 446001 446002 448031 451111 451115 451311 452113 452118 452120 461001 461002 461003 ,464001 464003 465031 465032 480311 481001 481004 481008 491101 491105 491110 491111 491112 491115 491117 491119 491122 491124 491191 491201 491205 491208 Police Srvcs U of 0 Police Srvcs Dist 19 EnterpriBe Zone Ext. Fee Rainbow Fire Protection Glenwood Fire Protection Willakenzie Fire Protecti will Collection Fee Library Services Library Automation Staff Reimbursement Muni Court Revenues Library Fines Restitution State Forfeit/Deq Drug Forfeits Post 1/1/02 Unclaimed/Forfeited Property Interest Income Variance in FMV of Investments Unsegregated Tax IntereBt Equipment Sales Vehicle Sales Library Gift Funds Hulda Durham Trust Donati Cash Over/Short Miscellaneous Receipts Testing Muni Court -Int on Delinq Indirect Chgs: Fund.201 Indirect Chgs: Fund 305 Indirect Chgs: Fund 210 Indirect ChgB: Fund 611 Indirect Chgs: Fund 612 Indirect ChgB: Fund 615 Indirect Chgs: Fund 617 Indirect ChgB Fund 419 Indirect ChgB: Fund 222 Indirect ChgB: Fund 224 Indirect Chgs: Fund 719 XFR From Fund 201 XFR From Fund 305 XFR From Fund 208 ADOPTED BUDGET 20,000 3,000 53,960 960,788 156,618 292,580 20,000 2,000 40,000 10,000 1,045,000 24,000 400 25,000 o o 375,000 o o 2,000 o o o o 50,000 1,.500 60,000 488,029 2,502 7,000 297,877 281,475 299,999 441,325 10,981 24,325 180,839 66,442 15,025 300,000 423,089 City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED REVISED BUDGET CURRENT RECEIVED 20,000 3,000 53,960 960,788 156,618 292,580 20,000 2,000 40,000 10,000 1,045,000 24,000 400 25,000 o o 375,000 o o 2,000 o o o o 50,000 1,500 60,000 488,029 2,502 7,000 297,877 281,475 299,999 441,325 10,981 24,325 180,839 66,442 15,025 300,000 423,089 2,938.08 0.00 0.00 0.00 0.00 0.00 2,946.06 0.00 0.00 0.00 75,295.87 1,927.30 0.00 0.00 3,496.80 3,964.20 43,873.23 0.00 -8,627.30 247.60 100.00 6,995.00 0.00 9.91 2,261.28 750.00 8,124.94 122,007.25 625.50 16,604.00 74,469.25 69,418.72 74,999.75 110,331.25 2,745.25 0.00 45,209.75 16,610.50 0.00 0.00 45,461. 32 YTD RECEIVED 2,938.08 0.00 53,960.00 0.00 0.00 0.00 4,013.32 0.00 0.00 0.00 251,584.94 5,776.70 1,496.95 0.00 3,496.80 3,964.20 98,650.75 7,059.81 -10,248.86 247.60 100.00 8,772.00 3.65 13.71 6,715.71 750.00 23,924.32 122,007.25 625.50 16,604.00 74,469.25 69,418.72 74,999.75 110,331. 25 2,745.25 0.00 45,209.75 16,610.50 0.00 0.00 118,802.11 BALANCE 17,061. 92 3,000.00 0.00 960,788.00 156,618.00 292,580.00 15,986.68 2,000.00 40,000.00 10,000.00 793,415.06 18,223.30 -1,096.95 25,000.00 -3,496.80 -3,964.20 276,349.25 -7,059.81 10,248.86 1,752.40 -100.00 -8,772.00 -3.65 -13 .71 43,284.29 750.00 36,075.68 366,021.75 1,876.50 -9,604.00 223,407.75 212,056.28 224,999.25 330,993.75 8,235.75 24,325.00 135,629.25 49,831. 50 15,025.00 300,000.00 304,286.89 Page No. 2 Run Date 10/12/2007 Run Time 09:41:38 'Ii REC FLAG 15 o 100 o o o 20 o o o 24 24 374 o o o 26 o o 12 o o o o 13 50 40 25 25 237 25 25 25 25 25 o 25 25 o o 28 * * * Report ID: SPRG506 From Period: 1 To period: FUND: 100 GENERAL FUND 3 City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR ~ ELAPSED Page No. 3 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE %- REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 491211 XFR From Fund 611 8,498 8,498 0.00 0.00 8,498.00 0 491212 XFER From Fund 612 9,145 9,145 0.00 0.00 9,145.00 0 491215 XFR From Fund 615 4,995 4,995 0.00 0.00 4,995.00 0 491217 XFR from fund 617 13,641 13,641 0.00 0.00 13,641. 00 0 * 491218 XFR From Fund 618 438,996 438,996 36,583.00 109,749.00 329,247.00 25 491219 XFR From Fund 419 10,000 10,000 0.00 0.00 10,000.00 0 * 491238 Xfr from Fund 224 52,451 52,451 4,370.92 13,112.76 39,338.24 25 491629 XfR from Fund 629 12,000 12,000 0.00 0.00 12,000.00 0 491719 XFR From Fund 719 1,930 1,930 0.00 0.00 1,930.00 0 499999 Beginning Cash Balance 7,264,283 7,264,283 0.00 8,189,658.47 -925,375.47 113 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 100 GENERAL FUND 36,288,440 36,288,440 1,323,693.56 11,300,265.36 24,988,174.64 31 .===========================================~================~=================================~====================================================================================== .Report ID: SPRG506 From Period: 1 To Period: FUND: 201 STREET FUND 3 City Of Springfield STATUS.OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 4 Run Date 10/12/2007 Run Time 09:41:38 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE % REC FLAG . . ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 417001 Local Fuel Tax 1,151,662 1.151,662 105,697.87 197,511.98 954,150.02 17 425002 Planning Fees 58,300 58,300 0.00 0.00 58,300.00 0 428030 Engineering Fees 3,750 3,750 0.00 0.00 3,750.00 0 428060 ROW Permit Fees 28,484 28,484 3,333.82 7,798.82 20,685.18 27 428070 Sidewalk Cafe Permit 0 0 0.00 25.00 -25.00 0 431218 STP Planning 106,233 106,233 0.00 0.00 106,233.00 0 433421 Highway Apportionment 2,994,889 2,994,889 218,553.88 392,813.14 2,602,075.86 13 * 433422 Bicycle Apportionment 30,251 30,251 2,207.62 3,967.81 26,283.19 13 433511 OR Sig Maint Contract 108,315 108,315 0.00 0.00 108,315.00 0 435917 LTD Maintenance Contract 23,789 23,789 0.00 12,237.74 11,551. 26 51 448021 Weyco Traf Sig Maint 0 0 0.00 0.00 0.00 0 448023 Geo Info System Fee 0 0 584.00 1,628.00 -1,628.00 0 448030 Int Engineering Fees ' 16,250 16,250 0.00 220.62 16,029.38 1 461001 Interest Income 59,532 59,532 7,184.10 15,316.46 44,215.54 26 461002 Variance in FMV of Investments 0 0 0.00 616.71 -616.71 0 463011 Lease Income 8,000 8,000 0.00 0.00 8,000.00 0 481001 Miscellaneous Receipts 69,193 69,193 200.00 8,834.51 60,358.49 13 481002 Prior Year Engineering Revenue 35,292 35,292 0.00 0.00 35,292.00 0 499999 Beginning Cash Balance 1,441,704 1,441,704 0.00 1,698,346.19 -256,642.19 118 TOTAL FUND: 201 STREET FUND 6,135,644 6,135,644 337,761. 29 2,339,316.98 3,796,327.02 38 ===================================================================================================================================================;================================= Report ID: SPRG506 From Period: 1 To Period: FUND: 202 JAIL OPERATIONS 3 City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR RAS ELAPSED Page No. 5 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ---------------------------------------------------------------------------------~-----------------~--------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE % REC FLAG 426606 461001 461002 499999 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Court Conviction Surcharge Interest Income Variance in FMV of Investments Beginning Cash Balance o o o o o o o o 3,487.24 227.15 0.00 0.00 12,918.80 472.70 14.85 42,948.68 -12,918.80 -472.70 -14.85 -42,948.68 o o o o ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 202 JAIL OPERATIONS o o 3,714.39 56,355.03 -56,355.03 o ===================================================================================================================;===============;================================================= Report ID: SPRG506 From period: 1 To Period: 3 FUND: 204 SPECIAL REVENUE FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 6 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE %- REC FLAG 418011 911 Tax 275,000 275,000 0.00 0.00 275,000.00 0 431172 Child Advocacy Center Grant 173,217 173,217 0.00 0.00 173,217.00 0 431196 STOP Grant 0 0 1,569.00 1,569.00 -1,569.00 0 431198 BJA Bullet Proof Vest 2,580 2,580 0.00 0.00 2,580.00 0 431222 Justice Assistance Grant 0 0 0.00 0.00 0.00 0 431226 Justice Assistance Grant 06 0 0 0.00 0.00 0.00 0 431227 Justice Assistance Grant 07 18,166 18,166 0.00 0.00 18,166.00 0 431228 2008 Olympic Trials Grant 0 0 0.00 1,008.00 -1,008.00 0 433279 Child Srvc Imp Grant 06-07 10,418 10,418 0.00 0.00 10,418.00 0 433280 Child Srvc Imp Grant 07-08 6,908 6,908 0.00 0.00 6,908.00 0 433515 DEQ BRING Grant 20,000 20,000 0.00 3,231.30 16,768.70 16 435520 Lane County DAO 53,927 53,927 0.00 -1,569.00 55,496.00 3 465020 Canine Donations 0 0 2,400.00 2,400.00 -2,400.00 0 465032 Hulda Durham Trust Donati 20 20 0.00 0.00 20.00 0 465033 Lib Scholarship Donation 15,000 15,000 0.00 0.00 15,000.00 0 491200 XFR From Fund 100 41,519 41,519 0.00 0.00 41,519.00 0 499999 Beginning Cash Balance 0 0 0.00 40,578.52 -40,578.52 0 * * TOTAL FUND: 204 SPECIAL REVENUE FUND 616,755 616,755 3,969.00 47,217.82 569,537.18 8 ===================================================================================================================================================================================== Report ID: SPRG506 From period: 1 To Period: 3 FUND, 208 TRANSIENT ROOM TAX FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 7 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG 414115 461001 461002 499999 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Transient Room Tax Interest Income Variance in FMV of Investments Beginning Cash Balance 761,560 3,000 o 33,473 761,560 3,000 o 33;473 83,058.94 828.22 0.00 0.00 154,891. 53 1,729.20 70.54 233,626.64 606,668.47 1,270.80 -70.54 -200,153.64 20 58 o 698 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 208 TRANSIENT ROOM TAX FUND 798,033 798,033 83,887.16 390,317.91 407,715.09 49 =======================================~============================================================================================================================================= Report ID: SPRG506 From Period: 1 To period: 3 FUND: 210 COMMUNITY DEVELOPMENT FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 8 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE %-REC FLAG 431111 CDBG Federal Grants 628,865 628,865 78,723.03 -48,290.00 677,155.00 8 * 431112 EDI Federal Grant 0 0 0.00 -297,000.00 297,000.00 0 431137 HOO Home Grants 460,070 460,070 0.00 -279,530.65 739,600.65 61 467015 House Rehab Loan Pay 0 0 0.00 21,434.97 -21,434.97 0 467017 Rehab Loan Fee Repay 0 0 0.00 1,522.76 -1,522.76 0 499999 Beginning Cash Balance 0 0 0.00 35,468.06 -35,468.06 0 TOTAL FUND: 210 COMMUNITY DEVELOPMENT FUN 1,088,935 1,088,935 78,723.03 -566,394.86 1,655,329.86 -52 ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To Period: 3 FUND: . 222 RIVERBEND DEVELOPMENT FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 9 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE %- REC FLAG 425004 461001 499999 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Planning Fees Peacehealth Interest Income Beginning Cash Balance 545,047 o o 545,047 o o -150,242.88 -457.73 0.00 -8,538.93 -1,203.85 0.00 553,585.93 1,203.85 0.00 2 o o ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FuND: 222 RIVERBEND DEVELOPMENT FUN 545,047 545,047 -150,700.61 -9,742.78 554,789.78 -2 ===================================================================================================================================================================================== 'I. .' I Report ID: SPRG506 From Period: 1 To Period: ~ 3 FUND: 224 BUILDING CODE FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 10 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YID RECEIVED BALANCE %- REC FLAG 425005 Peer Review Riverbend 0 0 -64.00 -64.00 64.00 0 425602 Building Fees 1,350,000 1,350,000 54,830.84 345,696.34 1,004,303.66 26 425603 Plumbing Fees 133,200 133,200 12,191.00 32,543.90 100,656.10 24 425604 Mechanical Fees 61,200 61,200 4,637.00 14,657.50 46,542.50 24 426102 Electrical Inspection Fee 141,300 141,300 10,844.00 49,146.75 92,153.25 35 426605 Bldg Fee Admin 124,200 124,200 7,439.45 29,796.67 94,403.33 24 461001 Interest Income 76,250 76,250 9,338.36 19,926.26 56,323.74 26 461002 Variance in FMV of Investments 0 0 0.00 943.17 -943.17 0 499999 Beginning Cash Balance 1,789,978 1,789,978 0.00 1,806,040.13 -16,062.13 101 TOTAL FUND: 224 BUILDING CODE FUND 3,676,128 3,676,128 99,216.65 2,298.,686.72 1,377,441.28 63 ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 229 SEnA GENERAL FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 11 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION -------------------------------------------------------------------------------------------------------------~----------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE % REC FLAG ,------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 411111 411211 461001 Current Taxes Delinquent Taxes Interest Income 1,196,400 1,333 5,200 1,196,400 1,333 5,200 0.00 0.00 0.00 0.00 0.00 0.00 1,196,400.00 1,333.00 5,200.00 o o o * ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL .FUND: 229 SEDA GENERAL FUND 1,202,933 1,202,933 0.00 0.00 1,202,933.00 o ===================================================================================================================================================================================== J Report ID: SPRG506 From Period: 1 TO period: 3 FUND: 235 FIRE LOCAL OPTION LEVY City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 12 Run Date 10/12/2007 Run Time 09:41:38 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE %- REC FLAG -----------------------------------------------------------------------,-------------------------------------------------------------------------------------------------------------- 411111 Current Taxes 1,243,366 1,243,366 0.00 0.00 1,243,366.00 0 411211 Delinquent Taxes 20,000 20,000 3,981.48 7,79L99 12,208.01 39 461001 Interest Income 20,000 20,000 866.25 1,908.23 18,091.77 10 461002 Variance in FMV of Investments 0 0 0.00 389.31 -389.31 0 499999 Beginning Cash Balance 415,728 415,728 0.00 238,200.15 177,527.85 57 TOTAL FUND: 235 FIRE LOCAL OPTION LEVY 1,699,094 1,699,094 4,847.73 248,289.68 1,450,804.32 15 ========================================================================================~============================================================================================ Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 236 POLICE LOCAL OPTION LEVY City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 13 Run Date 10/12/2007 Run Time 09:41:38 ---------------------------------------------------------------------------------------------------------------------------------------------- ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE %- REC FLAG ---------------------------------------------------------------------------------------------------------------------------~--------------------------------------------------------- 411111 Current Taxes 0 0 0.00 0.00 0.00 0 411211 Delinquent Taxes 35,000 35,000 7,299.38 14,285.32 20,714.68 41 461001 Interest Income 40,000 40,000 8,015.28 17,552.65 22,447.35 44 461002 Variance in FMV of Investments 0 0 0.00 1,228.53 -1,228.53 0 499999 Beginning Cash Balance 1,914,639 1,914,639 0.00 1,854,697.34 59,941. 66 97 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 236 POLICE LOCAL OPTION LEVY 1,989,639 1,989,639 15,314.66 1,887,763.84 101,875.16 95 =================~~~~~====~~~~===================================~~~~~~==========================================~===============================================~=================== Report ID: SPRG506 From Period: 1. TO period: 3 FUND: 305 BANCROFT REDEMPTION FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 14 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG 411211 Delinquent Taxes 0 0 0.00 0.10 -0.10 0 461001 Interest Income 50,000 50,000 8,228.65 17,266.32 32,733.68 35 461002 Variance in FMV of Investments 0 0 0.00 987.36 -987.36 0 461111 Pre Bond As Bess Interest 0 0 1,992.77 2,297.21 -2,297.21 0 461125 1997 Series One Interest 0 0 0.00 11. 90 -11. 90 0 471111 Pre Bond Assessments 75,000 75,000 10,000.00 11,135.32 63,864.68 15 471125 1997 Series One Assess 0 0 0.00 361. 83 -361.83 0 491219 XFR From Fund 419 23,025 23,025 0.00 0.00 23,025.00 0 499999 Beginning Cash Balance 1,811,014 1,811,014 0.00 1,812,774.24 -1,760.24 100 TOTAL FUND: 305 BANCROFT REDEMPTION FUND 1,959,039 1,959,039 20,221. 42 1,844,834.28 114,204.72 94 ===================================================================================================================================================================================== Report ID: SPRG506 From period: 1 To Period: 3 FUND: 306 BOND SINKING FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 15 Run Date 10/12/2007 Run Time 09:41:38 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG 411111 Current Taxes 3,291,982 3,291,982 0.00 0.00 3,291,982.00 0 411211 Delinquent' Taxes 20,000 20,000 3,393.84 6,991. 73 13,008.27 35 461001 Interest Income 25,000 25,000 1,163.05 -1,335.14 26,335.14 5 461002 Variance in FMV of Investments 0 0 0.00 420.04 -420.04 0 491440 XFR From Fund 440 25,649 25,649 0.00 0.00 25,649.00 0 491443 XFR From Fund 443 45,662 45,662 0.00 0.00 45,662.00 0 491446 XFR From Fund 446 10,374 10,374 0.00 0.00 10,374.00 0 499999 Beginning Cash Balance 216,527 216,527 0.00 257,639.46 -41,112.46 119 TOTAL FUND: 306 BOND SINKING FUND 3,635,194 3,635,194 4,556.89 263,716.09 3,371,477.91 7 ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To period: 3 FUND: 312 REGIONAL WASTEWATER DEBT SERVI City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 16 Run Date 10/12/2007 Run Time 09:41:38 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- * ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG 491212 491244 491245 XFER From Fund 612 XFR from Fund 444 XFER from Fund 445 ----------------------------------------------------------------------------------------------------------------------------------------------------------------- 1,234,029 1,234,029 1,234,030 1,234,029 1,234,029 1,234,030 0.00 0.00 0.00 0.00 0.00 0.00 1,234,029.00 1,234,029.00 1,234,030.00 o o o TOTAL FUND: 312 REGIONAL WASTEWATER DEBT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- * 3,702,088 3,702,088 0.00 0.00 3,702,088.00 o ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 409 SANITARY SEWER CAPITAL FOND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 17 Run Date 10/12/2007 Run Time 09:41:38 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE '" REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 448051 In Lieu Of Assessments 0 0 4,320.00 4,320.00 -4,320.00 0 461001 Interest Income 66,509 66,509 15,353.26 33,303.10 33,205.90 50 461002 Variance in FMV of Investments 0 0 0.00 1,988.25 -1,988.25 0 491211 XFR From Fund 611 1,349,750 1,349,750 337,437.50 337,437.50 1.012,312.50 25 491303 SRF Loan Proceeds 1,555,000 1,555,000 0.00 0.00 1,555,000.00 0 499999 Beginning Cash Balance 934,554 934,554 0.00 3,417,686.52 -2,483,132.52 366 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 409 SANITARY SEWER CAPITAL FU 3,905,813 3,905,813 357,110.76 3,794,735.37 111,077.63 97 ===================~=====================~=========~===========~==========~================================~==========~============================================================== Report ID: SPRG506 From period: 1 To Period: 3 FUND: 412 REG WASTEWATER REV BOND CAP PR City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 18 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTEo BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 461001 Interest Income 0 0 5,616.95 5,616.95 -5,616.95 0 461030 MWMC LGIP Interest 900,000 900,000 137,582.01 137,582.01 762,417.99 15 461031 MWMC Bond Proceed Inv Int 0 0 43,312.63 43,312.63 -43,312.63 0 491221 XFR from fund 433 33,548,216 33,548,216 0.00 38,212,655.33 -4,664,439.33 114 491305 Revenue Bond Sale 50,000,000 50,000,000 0.00 0.00 50,000,000.00 0 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 412 REG WASTEWATER REV BOND C 84,448,216 84,448,216 186,511.59 38,399,166.92 46,049,049.08 45 =======~==================================================================================================================================~========================================== Report ID: SPRG506 From period: 1 To Period: 3 FUND: 419 DEVELOPMENT ASSESSMENT CAPITAL City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL-YEAR HAS ELAPSED Page No. 19 Run Date 10/12/2007 Run Time 0~:41:38 ACCOUNT DESCRIPTION --------------------------------------------------------------------------------------------------------------------------------------------,----------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE %- REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 461001 Interest Income 30,000 30,000 6,783.98 14,495.74 15,504.26 48 461002 Variance in FMV of Investments 0 0 0.00 789.51 -789.51 0 - 461101 Unbonded Assessment Inter 2,000 2,000 0.00 224.19 1,775.81 11 471101 Unbonded Assessments 5,000 5,000. 0.00 13,213.12 -8,213 .12 264 471111 Pre Bond Assessments 50,000 50,000 50,425.72 50,425.72 -425.72 101 481001 Miscellaneous Receipts 0 0 50.00 50.00 -50.00 0 491200 XFR From Fund 100 40,250 40,250 0.00 0.00 40,250.00 0 499999 Beginning Cash Balance 1,402,210 1,402,210 0.00 1,487,364.93 -85,154.93 106 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 419 DEVELOPMENT ASSESSMENT CA 1,529,460 1,529,460 57,259.70 1,566,563.21 -37,103.21 102 ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To period: 3 FUND: 420 DEVELOPMENT PROJECTS City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 20 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE 'Ii REC FLAG 431223 STP-U MPO Frkln Planning 125,000 125,000 0.00 0.00 125,000.00 0 431224 STP-U MPO G/B Planning 50,000 50,000 0.00 0.00 50,000.00 0 435919 LTD Planning for Franklin Blvd 20,000 20,000 0.00 0.00 20,000.00 0 461001 Interest Income 300,000 300,000 13,580.33 30,290.06 269,709.94 10 461002 Variance in FMV of Investments 0 0 0.00 -1,691.92 1,691.92 0 461032 BLM Project Interest Income 0 0 12,679.64 14,077.33 -14,077.33 0 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 5,500,000 0.00 0.00 5,500,000.00 0 * 471171 S. 48th Connection M to Daisy 175,000 175,000 0.00 0.00 175,000.00 0 480200 Arbitrage Overpayment Refund 0 0 117,659.40 117,659.40 -117,659.40 0 481001 Miscellaneous Receipts 0 0 0.00 35.10 -35.10 0 491200 XFR From Fund 100 189,519 189,519 0.00 0.00 189,519.00 0 491205 XFR From Fund 305 250,000 250,000 0.00 0.00 250,000.00 0 499999 Beginning Cash Balance 8,649,325 8,649,325 0.00 9,020,464.38 -371,139.38 104 TOTAL FUND: 420 DEVELOPMENT PROJECTS 17,658,844 17,658,844 143,919.37 9,180,834.35 8,478,009.65 52 Report ID: SPRG506 From period: 1 To Period: 3 FUND: 425 STORM DRAINAGE CAPITAL FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 21 Run Date 10/12/2007 Run Time 09:41:38 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED -------------------------------------------------------------------------------------------------------------------------------------------------------- BALANCE 461001 461002 491217 499999 Interest Income Variance in FMV of Investments XFR from fund 617 Beginning Cash Balance 40,000 o 340,000 1,392,963 40,000 o 340,000 1,392,963 8,385.80 0.00 85,000.00 0.00 18,301.50 971.76 85,000.00 1,835,445.75 21,698.50 -971.76 255,000.00 -442,482.75 '!; REC FLAG 46 o 25 132 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 425 STORM DRAINAGE CAPITAL FU 1,772,963 1,772,963 93,385.80 1,939,719.01 -166,756.01 109 ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 427 GO BOND CAPITAL PROJECTS ACCOUNT DESCRIPTION 461001 461002 499999 Interest Income Variance in FMV of Investmente Beginning Cash Balance TOTAL FUND: 427 GO BOND CAPITAL PROJECTS ADOPTED BUDGET City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED REVISED BUDGET CURRENT RECEIVED o o o o o o 0.00 0.00 0.00 o o 0.00 YTD RECEIVED BALANCE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Page No. 22 Run Date 10/12/2007 Run Time 09:41:38 lr REC FLAG o o o o Report ID: SPRG506 From Period: 1 To period: 3 FUND: 428 POLICE BUILDING BOND CAP PROJ City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 23 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG 461001 461002 499999 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Interest Income Variance in FMV of Investments Beginning Cash Balance 960,000 o 22,552,436 960,000 o 22,552,436 113,176.46 0.00 0.00 322,867.16 6,553.76 26,269,420.63 637,132.84 -6,553.76 -3,716,984.63 34 o 116 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 428 POLICE BUILDING BOND CAP 23,512,436 23,512,436 113,176.46 26,598,841.55 -3,086,405.55 113 ======================================================================================================================.============================================================== Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 429 SEDA CAPITAL PROJECT FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR lIAS ELAPSED ACCOUNT DESCRIPTION ADOPTED BUDGET CURRENT RECEIVED REVISED BUDGET YTD RECEIVED BALANCE 411111 Current Taxes 0 0 0.00 0.00 0.00 411211 Delinquent Taxes 0 0 505.44 953.91 -953.91 435915 IlACSA Mckenzie vill. In-Lieu-O 0 0 0.00 589.20 -589.20 461001 Interest Income 0 0 330.81 637.75 -637.75 461002 Variance in FMV of Investments 0 0 0.00 65.46 -65.46 464008. Property Sale 1,646,000 1,646,000 0.00 0.00 1,646,000.00 491229 XFR From Fund 229 604,719 604,719 0.00 0.00 604,719.00 499999 Beginning Cash Balance 53,281 53,281 0.00 .73,416.82 -20,135.82 TOTAL FUND: 429 SEDA CAPITAL PROJECT FUND 75,663..14 2,304,000 2,304,000 836.25 2,228,336.86 Page No. 24 Run Date 10/12/2007 Run Time 09:41:38 " REC FLAG o o o o o o o 138 3 Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 433 REGIONAL WASTEWATER CAPITAL FD City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR BAS ELAPSED Page No. 25 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG --------------------------------------------------------------------------------------------------------------------------------------~---------------------------------------------- 435551 County Service District 1,000 1,000 0.00 0.00 1,000.00 0 461001 Interest Income 0 0 100,079.74 214,122.41 -214,122.41 0 461002 Variance in FMV of Investments 0 0 0.00 -318,112.11 318,112.11 0 461021 Capital Interest 231,000 231,000 0.00 0.00 231,000.00 0 * 461023 Equipment Replace Interes 230,000 230,000 0.00 0.00 230,000.00 0 461030 MWMC LGIP Interest 0 0 -68,189.20 69,392.81 -69,392.81 0 461031 MWMC Bond Proceed Inv Int 0 0 -43,312.63 0.00 0.00 0 491212 XFER From Fund 612 4,000,000 4,000,000 333,333.33 999,999.99 3,000,000.01 25 491222 XFR From Fund 612 OP-EQ Repl 436,536 436,536 36,378.00 109,134.00 327,402.00 25 491223 XFR From Fund 612 OP-Vehicle 242,034 242,034 20,169.50 60,508.50 181,525.50 25 491224 XFR From Fund 612 OP-Computer 18,253 18,253 1,521.08 4,563.24 13,689.76 25 499999 Beginning Cash Balance 52,918,677 52,918,677 0.00 58,335,246.13 -5,416,569.13 110 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 433 REGIONAL WASTEWATER CAPIT 58,077,500 58,077,500 379,979.82 59,474,854.97 -1,397,354.97 102 ===================================================================================================================================================================================== Report ID: SPRG506 From period: 1 To Period: 3 FUND: 434 STREET CAPITAL FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 26 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG 461001 Interest Income 62,000 62,000 10,369.75 24,194.92 37,805.08 39 461002 Variance in FMV of Investments 0 0 0.00 1,589.81 -1,589.81 0 481001 Miscellaneous Receipts 0 0 0.00 768.96 -768.96 0 491201 XFR From Fund 201 400,000 400,000 0.00 0.00 400,000.00 0 499999 Beginning Cash Balance 990,362 990,362 0.00 2,522,678.21 -1,532,316.21 255 TOTAL FUND: 434 STREET CAPITAL FUND 1,452,362 1,452,362 10,369.75 2,549,231.90 -1,096,869.90 176 ==============================================================================================================================================================================~====== Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 440 STORM DRAINAGE SDC FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 27 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 448028 461001 461002 499999 SDC Storm Interest Income Variance in FMV of Investments Beginning Cash Balance 186,436 65,887 o 2,318,786 186,436 65,887 o 2,318,786 20,675.54 14,089.73 0.00 0.00 89,045.05 30,504.67 1,669.33 3,107,328.66 97,390.95 35,382.33 -1,669.33 -788,542.66 48 46 o 134 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 440 STORM DRAINAGE SDC FUND 2,571,109 2,571,109 34,765.27 3,228,547.71 -657,438.71 126 ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To period: 3 FUND: 442 SANITARY SEWER REIMB SDC FUND ACCOUNT DESCRIPTION 448024 461001 461002 499999 SDC Sanitary Sewer-Reimb Interest Income . Variance in FMV of Investments Beginning Cash Balance TOTAL FUND: 442 SANITARY SEWER REIMB SDC ADOPTED BUDGET 131,264 19,382 o 217,402 368,048 City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED REVISED BUDGET CURRENT RECEIVED YTD RECEIVED 46,546.44 9,001.44 364.26 917,510.03 973,422.17 BALANCE 84,717.56 10,380.56 -364.26 -700,108.03 -605,374.17 Page No. 28 Run Date 10/12/2007 Run Time 09:41:38 " REC FLAG 131,264 19,382 o 217,402 16,728.54 4,229.99 0.00 0.00 35 46 o 422 ===================================================================================================================================================================================== 264 368,048 20,958.53 Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 443 SANITARY SEWER IMPROVEMENT SDC City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 29 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG 448025 461001 461002 499999 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SDC Sanitary Sewer-Imp Interest Income Variance in FMV of Investments Beginning Cash Balance 99,761 10,048 o 98,216 99,761 10,048 o 98,216 12,627.04 5,639.37 0.00 0.00 35,299.89 12,399.90 765.50 1,307,518.76 64,461.11 -2,351.90 -765.50 -1,209,302.76 35 123 o u* ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 443 SANITARY SEWER IMPROVEMEN 208,025 208,025 18,266.41 1,355,984.05 -1,147,959.05 652 =====================================================================================================================~==============================================================~ Report ID: SPRG506 From Period: 1 To period: 3 'FUND: 444 SDC REGIONAL WASTEWATER REIMB ACCOUNT DESCRIPTION 448024 461002 461024 499999 SDC Sanitary Sewer-Reimb Variance in FMV of Investments Regional SDC Reimb. Interest Beginning Cash Balance TOTAL FUND: 444 SDC REGIONAL WASTEWATER R ADOPTED BUDGET 155,000 o 220,000 5,039,799 5,414,799 City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED REVISED BUDGET CURRENT RECEIVED 155,000 o 220,000 5,039,799 .15,683.01 0.00 24,321.10 0.00 5,414,799 40,004.11 YTD RECEIVED 47,368.96 2,688.79 51,444.95 5,341,142.35 5,442,645.05 BALANCE 107,631.04 -2,688.79 168,555.05 -301,343.35 -27,846.05 Page No. 30 Run Date 10/12/2007 Run Time 09:41:38 " REC FLAG 31 o 23 106 101 Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 445 SDC REGIONAL WASTEWATER IMP City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 31 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE % REC FLAG ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SDC Sanitary Sewer-Imp Variance in FMV of Investments Improvement SDC Interest Beginning Cash Balance 1,615,000 o 221,000 5,777,958 1,615,000 o 221,000 5,777,958 171,777 .24 0.00 31,723.40 0.00 487,928.33 2,811.56 66,337.44 6,796,832.22 1,127;071.67 -2,811.56 154,662.56 -1,018,874.22 30 o 30 118 448025 461002 461027 499999 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 445 SDC REGIONAL WASTEWATER I 7,613,958 7,613,958 203,500.64 7,353,909.55 260,048.45 97 ===================================================================================================================================================================================== Report ID: SPRG506 From period: 1 To Period: 3 FUND: 446 SDC TRANSPORTATION REIMBURSEME ACCOUNT DESCRIPTION 448026 461001 461002 499999 SDC Transportation-Reimb Interest Income Variance in FMV of Investments Beginning Cash Balance TOTAL FUND: 446 SDC TRANSPORTATION REIMBU ADOPTED BUDGET 164,296 17,000 o 480,171 661,467 City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED REVISED BUDGET CURRENT RECEIVED YTD RECEIVED 17,769.16 7,853.98 247.93 782,717.61 808,588.68 BALANCE 146,526.84 9,146.02 -247.93 -302,546.61 -147,121.68 Page No. 32 Run Date 10/12/2007 Run Time 09:41:38 " REC FLAG 164,296 17,000 o 480,171 6,350.13 3,619.23 0.00 0.00 11 46 o 163 ===================================================================================================================================================================================== 122 661,467 9,969.36 Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 447 SDC TRANSPORTATION IMPROVEMENT City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 33 Run Date 10/12/2007 Run Time 09:41;38 ------------------------------------------------------------------------------------------------------------------------------------------------------------------ ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE % REC FLAG ----------------------------------------------------------------------------------------------------------~-------------------------------------------------------------------------- 448027 461001 461002 499999 SDC Transportation-Improvement Interest Income Variance in FMV of Investments Beginning Cash Balance 685,586 113,000 o 3,489,322 685,586 113,000 o 3,489,322 28,011.47 18,598.25 0.00 0.00 78,384.19 41,467.88 1,615.96 4,085,177.42 607,201.81 71,532.12 -1,615.96 -595,855.42 11 37 o 117 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 447 SDC TRANSPORTATION IMPROV 4,287,908 4,287,908 46,609.72 4,206,645.45 81,262.55 98 ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To period: 3 FUND: 611 SANITARY SEWER OPERATIONS FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 34 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION BALANCE ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- FLAG ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED " REC ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 425002 Planning Fees 125,000 125,000 0.00 0.00 125,000.00 426604 SDC Admin Fee 3,000 3,000 220.00 570.00 2,430.00 428030 Engineering Fees 20,000 20,000 0.00 0.00 20,000.00 448030 Int Engineering Fees 20,000 20,000 0.00 0.00 20,000.00 449011 Local Sewer User Fees 4,567,180 4,567,180 370,966.47 701,754.76 3,865,425.24 461001 Interest Income 55,000 55,000 7,091.38 14,422.83 40,577.17 461002 Variance in FMV of Investments 0 0 0.00 784.15 -784.15 463011 Lease Income 10,500 10,500 950.00 2,850.00 7,650.00 481001 Miscellaneous Receipts 0 0 0.00 8.44 -8.44 481002 Prior Year Engineering Revenue 30,000 30,000 0.00 0.00 30,000.00 499999 Beginning Cash Balance 1,075,354 1,075,354 0.00 1,653,370.34 -578,016.34 TOTAL FUND: 611 SANITARY SEWER OPERATIONS 5,906,034 5,906,034 379,227.85 2,373,760.52 3,532,273.48 =======================================================.================================================================================================~============================= 40 o 19 o o 15 26 o 27 o o 154 Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 612 REGIONAL WASTEWATER FUND : City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 35 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 428040 Pretreatment Permits 9,135 9,135 0.00 435.00 8,700.00 5 448030 lnt Engineering Fees 850,000 850,000 0.00 79,981.19 770,018.81 9 * 449013 Regional Sewer User Feesi 18,635,400 18,635,400 1,607,047.19 3,145,964.70 15,489,435.30 17 * 449015 Septage Revenue 453,600 453,600 31,263.59 31,263.59 422,336.41. 7 449018 Right of way - WPCF 0 0 184,250.00 184,250.00 -184,250.00 0 451316 Pretreatment Fines 2,500 2,500 100.00 100.00 2,400.00 4 461002 Variance in FMV of Investment's 0 0 0.00 2,826.21 -2,826.21 0 461022 Operations Interest 221,000 221,000 26,783.52 52,143.26 168,856.74 24 463011 Lease Income 15,000 15,000 879.13 17,486.93 -2,486.93 117 480220 Eugene Working Capital 700,000 700,000 0.00 0.00 700,000.00 0 481001 Miscellaneous Receipts 15,000 15,000 0.00 2,034.43 12,965.57 14 499999 Beginning Cash Balance 7,133,629 7,133,629 0.00 6,573,824.90 559,804.10 92 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 612 REGIONAL WASTEWATER FUND 28,035,264 28,035,264 1,850,323.43 10,090,310.21 17,944,953.79 36 =======================================================================================================================~============================================================= Report ID: SPRG506 From period: 1 To Period: FUND: 615 AMBULANCE FUND 3 City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 36 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG 440101 Bad Debt Recovery 20,000 20,000 2,006.70 9,598.37 10,401. 63 48 444106 Springfield Pinpoint 2,787,000 2,787,000 175,292.50 396,929.10 2,390,070.90 14 444111 PM Membership Fees 582,920 582,920 -668,570.50 147,462.82 435,457.18 25 444117 PM Adm Srvs Reimbursement 401,090 401,090 0.00 0.00 401,090.00 0 444121 Billing Service Fees 470,300 470,300 40,925.37 79,648.21 390,651. 79 17 444125 Rural Life Support Fees 5,300 5,300 0.00 4,158.00 1,142.00 78 444126 Firemed Event Registrations 0 0 425.00 650.00 -650.00 0 461001 Interest Income 30,000 30,000 3,884.43 8,359.06 21,640.94 28 461002 Variance in FMV of Investments 0 0 0.00 342.53 -342.53 0 465021 Firemed Donations 700 700 3,321.00 3,321.00 -2,621. 00 474 481001 Miscellaneous Receipts 2,500 2,500 95.00 410.00 2,090.00 16 499999 Beginning Cash Balance 379,419 379,419 0.00 163,321. 28 216,097.72 43 TOTAL FUND: 615 AMBULANCE FUND 4,679,229 4,679,229 -442,620.50 814,200.37 3,865,028.63 17 Report ID: SPRG506 From Period: 1 To period: 3 FUND: 617 STORM DRAINAGE OPERATIONS FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 37 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE If REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 425002 Planning Fees 152,000 152,000 0.00 0.00 152,000.00 0 428020 Land Alt. And Fill Permit 135,000 135,000 13,615.00 44,080.00 90,920.00 33 428030 Engineering Fees 10,000 10,000 0.00 0.00 10,000.00 0 448030 lnt Engineering Fees 35,000 35,000 0.00 0.00 35,000.00 0 449017 Drainage User Fees 3,988,790 3,988,790 325,654.07 649,400.62 3,339,389.38 16 * 461001 Interest Income 30,000 30,000 5,308.06 10,709.82 19,290.18 36 461002 Variance in FMV of Investments 0 0 0.00 528.35 -528.35 0 463011 Lease Income 2,500 2,500 0.00 0.00 2,500.00 0 481001 Miscellaneous Receipts 2,000 2,000 250.00 750.00 .1,250.00 38 481002 Prior Year Engineering Revenue 25,000 25,000 0.00 0.00 25,000.00 0 499999 Beginning Cash Balance 745,108 745,108 0.00 1,155,233.68 -410,125.68 155 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 617 STORM DRAINAGE OPERATIONS 5,125,398 5,125,398 344,827.13 1,860,702.47 3,264,695.53 36 ========================================~========~============================================~========~============================================================================= Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 618 BooTII-KELLY FUND City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 38 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE '" REC FLAG 461001 Interest Income 46,000 46,000 4,566.31 10,028.05 35,971.95 22 * 461002 variance in FMV of Investments 0 0 0.00 777.84 -777 . 84 0 463011 Lease Income 120,000 10,000 814.00 1,628.00 8,372.00 16 463015 Carter Building Lease 0 110,000 18,667.96 20,055.92 89,944.08 18 463021 B-Kelly Leases-Rent 557,000 557,000 50,732.53 129,868.57 427,131. 43 23 463022 B-Kelly Leases-Utilities 16,000 16,000 2,349.09 4,409.09 11,590.91 28 463023 B-Kelly Leases-Taxes 39,000 39,000 2,942.94 7,279.02 31,720.98 19 463024 B-Kelly Leases-Insurance 8,000 8,000 860.76 2,300.18 5,699.82 29 481001 Miscellaneous Receipts 0 0 0.00 2,409.58 -2,409.58 0 499999 Beginning Cash Balance 1,062,210 1,062,210 0.00 987,081.22 75,128.78 93 TOTAL FUND: 618 BooTII-KELLY FUND 1,848,210 1,848,210 80,933.59 1,165,837.47 682,372.53 63 Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 629 REGIONAL FIBER CONSORTIUM City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 39 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE % REC FLAG 461001 461002 463011 499999 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Interest Income Variance in FMV of Investments Lease Income Beginning Cash Balance 1,400 o 22,000 30,967 1,400 o 22,000 30,967 112.12 0.00 0.00 0.00 237.35 10.66 0.00 24,712.14 1,162.65 -10.66 22,000.00 6,254.86 17 o o 80 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 629 REGIONAL FIBER CONSORTIUM 54,367 54,367 112.12 24,960.15 29,406.85 46 ===================================================================================================================================================================================== Report ID: SPRG506 From period: 1 To Period: FUND: 707 INSURANCE FUND 3 City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 40 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG 435521 OR Employ-At-Injury 30,000 30,000 0.00 4,672.96 25,327.04 16 440025 Int Insurance Chgs 786,300 786,300 65,185.60 195,786.26 590,513.74 25 440026 Internal Benefits Charges 370,500 370,500 30,768.63 92,414 .43 278,085.57 25 440027 Workers Comp Chgs 854,000 854,000 81,891. 79 239,166.66 614,833.34 28 452111 Flexible Spending Forfeit 2,000 2,000 0.00 0.00 2,000.00 0 461001 Interest Income 146,500 146,500 14,485.98 30,528.42 115,971.58 21 461002 Variance in FMV of Investments 0 0 0.00 1,730.54 -1,730.54 0 480212 W.C. prem Refunds & Dividends 0 0 0.00 13,400.80 -13,400.80 0 480215 Claims Recovery 20,000 20,000 5,780.80 5,780.80 14,219.20 29 481001 Miscellaneous Receipts 2,000 2,000 0.00 2,000.00 0.00 100 491161 Employee Benefits 10,765,700 10,765,700 840,444.41 1,837,409.10 8,928,290.90 17 491162 HRA Benefit 802,000 802,000 61,800.00 183,725.00 618,275.00 23 499999 Beginning Cash Balance 2,812,397 2,812,397 0.00 3,199,241.21 -386,844.21 114 TOTAL FUND: 707 INSURANCE FUND 16,591,397 16,591,397 1,100,357.21 5,805,856.18 10,785,540.82 35 City Of Springfield Report ID: SPRG506 STATUS OF REVENUES Page No. 41 From period: 1 To Period: 3 MONTH ENDING SEPTEMBER 30, 2007 Run Date 10/12/2007 FUND: 713 VEHICLE & EQUIPMENT FUND 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Run Time 09:41:38 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE % REC FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 440015 Int Computer Eq Chgs 251,344 251,344 20,911.48 62,734.44 188,609.56 25 440018 Fire Engine Lease 36,422 36,422 3,035.17 9,105.51 27,316.49 25 440021 Int Tele Lease Contr 9,019 9,019 711.46 2,139.52 6,879.48 24 440022 Int Microeoft Enterprise Chrg 106,500 106,500 8,875.00 26,625.00 79,875.00 25 440028 Internal Lease Chargee 18,528 18,528 1,544.00 4,632.00 13 , 896.00 25 444029 Int Equipment Chgs : 455,047 455,047 37,920.58 113,761.74 341,285.26 25 461001 Interest Income 250,400 250,400 26,849.63 56,925.15 193,474.85 23 461002 Variance in FMV of Investments 0 0 0.00 3,041.20 -3,041.20 0 464003 Vehicle Sales 0 0 5,828.00 5,828.00 -5,828.00 0 499999 Beginning Cash Balance' 5,184,310 5,184,310 0.00 5,867,123.51 -682,813.51 113 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TOTAL FUND: 713 VEHICLE & EQUIPMENT FUND 6,311,570 6,311,570 105,675.32 6,151,916.07 159,653.93 97 ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 719 SDC ADMINISTRATION City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 42 Run Date 10/12/2007 Run Time 09:41:38 ACCOUNT DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG 426604 SDC Admin Fee 63 ,400 63,400 5,537.25 19,952.67 43,447.33 31 440016 Int Admin Fee 461,000 461,000 151,510.00 224,030.00 236,970.00 49 461001 Interest Income 3,460 3,460 1,735.24 3,656.61 -196.61 106 461002 Variance in FMV of Investments 0 0 0.00 70.09 -70.09 0 499999 Beginning Cash Balance 131,506 131,506 0.00 337,966.89 -206,460.89 257 TOTAL FUND: 719 SDC ADMINISTRATION 659,366 659,366 158,782.49 585,676.26 73,689.74 89 ===================================================================================================================================================================================== Report ID: SPRG506 From Period: 1 To Period: 3 FUND: 719 SDC ADMINISTRATION City Of Springfield STATUS OF REVENUES MONTH ENDING SEPTEMBER 30, 2007 25.0 PERCENT OF FISCAL YEAR BAS ELAPSED Page No. 43 Run Date 10/12/2007 Run Time 09:43:09 ACCOUNT ---------------------------------~--------------------------------------------------------------------------------------------------------------------------------------------------- , DESCRIPTION ADOPTED BUDGET REVISED BUDGET CURRENT RECEIVED YTD RECEIVED BALANCE " REC FLAG -------------------------------------------------------------------------------------------------------------------------- , . ===================================================================================================================================================================================== Grand Total: 348,334,712 348,334,712 -7,119,447.35 -215,923,198.85 564,257,910.85 ===================================================================================================================================================================================== End of Report Report ID: SPRG508.SQR FUND : 100 General Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 1 Run Date 10/12/2007 Run Time 09:41:07 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING "EXP FLAG CMO Court HR Finance IT Fire Police Library Public Works DSD ----------------------------------------------------------------------------------------------------------------------------------------------------------- 1,232,427 1,232,427 73,357.56 402,283.08 830,143.92 33 **** 1,347,364 1,347,364 107,228.93 304,859.59 1,042,504.41 23 559,490 559,490 33,961. 06 100,422.85 459,067.15 18 808,040 808,040 78,510.27 224,919.05 583,120.95 28 **** 1,349,620 1,349,620 202,330.58 418,633.59 930,986.41 31 **** 8,986,201 8,986,201 726,112.63 2,128,395.22 6,857,805.78 24 10,971,426 10,971,426 981,824.89 2,738,349.36 8,233,076.64 25. 1,259,043 1,259,043 85,960.40 311,179.75 947,863.25 25 965,469 965,469 74,934.08 212,468.25 753,000.75 22 1,673,021 1,673,021 133,286.77 381,128.80 1,291,892.20 23 Departmental Operating: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 29,152,101 29,152,101 2,497,507.17 7,222,639.54 21,929,461. 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 271,288 271,288 0.00 0.00 271,288.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 600,000 600,000 0.00 0.00 600,000.00 0 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 0 Reserves 6,265,051 6,265,051 0.00 0.00 6,265,051.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: ------------------------------------------------------------~------------------------------------------------------------,--------------------------------- 7,136,339 7,136,339 0.00 0.00 7,136,339.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 36,288,440 36,288,440 2,497,507.17 7,222,639.54 29,065,800.46 Report ID: SPRG508.SQR FUND : 201 Street Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 2 Run Date 10/12/2007 Run Time 09:41:07 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING "EXP FLAG CMO 11,069 11,069 0.00 0.00 11,069.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 5,289,873 5,289,873 484,815.70 1,224,836.58 4,065,036.42 23 DSD 55,245 55,245 5,595.75 13,662.29 41,582.71 25 Departmental Operating: 5,356,187 5,356,187 490,411. 45 1,238,498.87 4,117,688.13 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 415,025 415,025 0.00 0.00 415,025.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 364,432 364,432 0.00 0.00 364,432.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 779,457 779,457 0.00 0.00 779,457.00 Total F\llld: 6,135,644 6,135,644 490,411.45 1,238,498.87 4,897,145.13 Report.ID: SPRG508.SQR FUND : 202 Jail Operations City Of Springfield BUDGET AND AcTuAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 3 Run Date 10/12/2007 Run Time 09:41:07 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 : 203 Museum P\llld City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED ADOPTED BUDG REVISED BUDG REMAINING "EXP CURRENT PD YTD EXPEND 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 <i 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 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 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 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 Page No. 4 Run Date 10/12/2007 Run Time 09:41:07 FLAG o " Report ID: SPRG508.SQR FUND : 204 Special Revenue Fund City Of Springfield BUDGET AND ACTUAL REPORT BY.FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 5 Run Date 10/12/2007 Run Time 09:41:07 ADOPTED BUDG REMAINING %EXP -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- **** REVISED BUDG CURRENT PD YTD EXPEND FLAG ---------------------------------------------------------------------------------------------------------~---------------------------------------------------------------------- CMO 33,166 33,166 15,000.00 15,000.00 18,166.00 45 Court 0 0 0.00 0.00 0.00 0 HR 0 0 0.00 0.00 0.00 0 Finance 25,000 25,000 0.00 0.00 25,000.00 0 IT 0 0 0.00 0.00 0.00 0 Fire 0 0 0.00 0.00 0.00 0 Police 487,312 487,312 8,832.99 33,595.14 453,716.86 7 Library 25,740 25,740 876.05 3,115.64 22,624.36 12 Public Works 1,000 1,000 0.00 0.00 1,000.00 0 DSD 3,000 3,000 0.00 1,839.39 1,160.61 61 Departmental Operating: 521,667.83 ---------------------------------------------------------------------------------------------------------------------------------------------------------- **** 575,218 575,218 24,709.04 53,550.17 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 41,537 41,537 0.00 0.00 41,537.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ---------------------------------------------------------------------------------------------------------------------------------------------------- Total Non Departmental: 41,537 41,537 0.00 0.00 41,537.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Fund: 616,755 616,755 24,709.04 53,550.17 563,204.83 Report ID: SPRG508.SQR FUND : 208 Transient Room Tax Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 6 Run Date 10/12/2007 Run Time 09:41:07 ADOPTED BUDG REMAINING -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- FLAG REVISED BUDG CURRENT PD YTD EXPEND CMO 210,502 210,502 14,880.70 49,985.46 160,516.54 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 46,042 46,042 2,649.09 9,362.71 36,679.29 Public Works 27,881 27,881 912.62 3,012.09 24,868.91 DSD 46,125 46,125 3,755.22 11,267.33 34,857.67 Departmental Operating: 330,550 330,550 22,197.63 73,627.59 256,922.41 Capital Projects o o 0.00 0.00 0.00 Total Capital Projects: 0 0 0.00 0.00 0.00 Interfund Loans 0 0 0.00 0.00 0.00 Interfund Transfers 423,089 423,089 45,461. 32 118,802.11 304,286.89 Debt Service 0 0 0.00 0.00 0.00 Statutory Payments 0 0 0.00 0.00 0.00 Mise Fiscal Transactions 0 0 0.00 0.00 0.00 Contingencies 0 0 0.00 0.00 0.00 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 Reserves 44,394 44,394 0.00 0.00 44,394.00 Balance Available 0 0 0.00 0.00 0.00 Total Non Departmental: 467,483 467,483 45,461.32 118,802.11 348,680.89 . . ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Fund: 798,033 798,033 67,658.95 192,429.70 605,603.30 "EXP 24 o o o o o o 20 11 24 o o 28 **** o o o o o o o Report ID: SPRG508.SQR FUND : 210 Community Development Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 7 Run Date 10/12/2007 Run Time 09:41:07 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 15,917 15,917 1,258.46 5,752.51 10,164.49 36 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 469,182 469,182 96,527.20 188,641.13 280,540.87 40 **** ---------------------------------------------------------------------------------------------------------------------------------------------------------- Departmental Operating: 485,099 485,099 97,785.66 194,393.64 290,705.36 Capital Projects 603,836 603,836 51,449.54 51,974.54 551,861. 46 9 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 603,836 603,836 51,449.54 51,974.54 551,861.46 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 F\llld: 1,088,935 1,088,935 149,235.20 246,368.18 842,566.82 Report ID: SPRG508.SQR FUND : 222 RiverBend Development Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 8 Run Date 10/12/2007 Run Time 09:41:07 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 39,629 39,629 263.48 1,592.37 38,036.63 4 Police 0 0 0.00 0.00 0.00 0 Library 0 0 0.00 0.00 0.00 0 Public Works 505,418 505,418 31,787.10 51,156.65 454,261.35 10 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 545,047 545,047 32,050.58 52,749.02 492,297.98 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 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 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: 545,047 545,047 32,050.58 52,749.02 492,297.98 Report ID: SPRG508.SQR FUND : 224 Building Code Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED --------------------------------------------------- Page No. 9 Run Date 10/12/2007 .Run Time 09:41:07 ADOPTED BUDG REMAINING ----------------------------------------------------------------------------------------------------------------------------- FLAG ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ REVISED BUDG CURRENT PD YTD EXPEND 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 2,410,195 2,410,195 214,595.34 395,218.63 2,014,976.37 %-EXP o o o o o o o o o 16 Departmental Operating: 2,014,976.37 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 2,410,195 2,410,195 214,595.34 395,218.63 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 Interfund Transfers 52,451 52,451 4,370.92 13,112.76 39,338.24 Debt Service 0 0 .0.00 0.00 0.00 Statutory Payments 0 0 0.00 0.00 0.00 Mise Fiscal Transactions 0 0 0.00 0.00 0.00 Contingencies 0 0 0.00 0.00 0.00 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 Reserves 1,213,482 1,213,482 0.00 0.00 1,213,482.00 Balance Available 0 0 0.00 0.00 0.00 o 25 **** o o o o o o o Total Non Departmental: 1,252,820.24 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 1,265,933 1,265,933 4,370.92 13,112.76 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Fund: 3,676,128 3,676,128 218,966.26 408,331.39 3,267,796.61 Report ID: SPRG508.SQR FUND : 229 SEDA General P\llld City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 10 Run Date 10/12/2007 Run Time 09:41:07 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %-EXP FLAG CMO 440,214 440,214 474.22 2,437.78 437,776.22 1 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: 440,214 440,214 474.22 2,437.78 437,776.22 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 604,719 604,719 0.00 0.00 604,719.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 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 50,000 50,000 0.00 0.00 50,000.00 0 Baiance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 762,719 762,719 0.00 0.00 762,719.00 Total Fund: 1,202,933 1,202,933 474.22 2,437.78 1,200,495.22 ,I Report ID: SPRG508.SQR FUND : 235 Fire Lccal Option Levy City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 11 Run Date 10/12/2007 Run Time 09:41:07 ADOPTED BUDG 'lEXP -------------------------------------------------------------------------------------------------------------------------------------------- FLAG REVISED BUDG CURRENT PD YTD EXPEND REMAINING ------------------------------------------------------------------------------------------------------------------------------------------ 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 1,181,530 1,181,530 100,759.88 269,259.81 912,270.19 23 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: 912,270.19 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 1,181,530 1,181,530 100,759.88 269,259.81 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 517,564 517,564 0.00 0.00 517,564.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 517,564.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 517,564 517,564 0.00 0.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Fund: 1,699,094 1,699,094 100,759.88 269,259.81 1,429,834.19 Report ID: SPRG508.SQR FUND : 236 Police Local Option Levy City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED ADOPTED BUDG REVISED BUDG CURRENT PD REMAINING %-EXP YTD EXPEND CMO 0 0 0.00 0.00 0.00 0 Court 201,321 201,321 11,723.62 36,068.91 165,252.09 18 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,788,318 1,788,318 137,832.54 411;574.23 1,376,743.77 23 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,989,639 1,989,639 149,556.16 447,643.14 1,541,995.86 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 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 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: 1,989,639 1,989,639 149,556.16 447,643.14 1,541,995.86 ~ Page No. 12 Run Date 10/12/2007 Run Time 09:41:07 FLAG Report ID: SPRG508.SQR FUND : 305 Bancroft Redemption P\llld City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 13 Run Date 10/12/2007 Run Time 09:41:07 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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,025 23,025 1,713.94 4,195.17 18,829.83 18 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: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 23,025 23,025 1,713 .94 4,195.17 18,829.83 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 600,000 600,000 50,425.72 50,425.72 549,574.28 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 Rese.rves 1,336,014 1,336,014 0.00 0.00 1,336,014.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: -------------------------------------------------------------------------------~-------------------------------------------------------------------------- 1,936,014 1,936,014 50,425.72 50,425.72 1,885,588.28 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 1,959,039 1,959,039 52,139.66 54,620.89 1,904,418.11 Report ID: SPRG508.SQR FUND : 306 Bond Sinking Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 14 Run Date 10/12/2007 Run Time 09:41:07 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 3,304,414 3,304,414 0.00 0.00 3,304,414.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 330,780 330,780 0.00 0.00 330,780.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: 3,635,194 3,635,194 0.00 0.00 3,635,194.00 Total Fund: 3,635,194 3,635,194 0.00 0.00 3,635,194.00 Report ID: SPRG508.SQR FUND : 409 Sanitary Sewer Capital Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 15 Run Date 10/12/2007 Run Time 09:41:07 ADOPTED BUDG REMAINING %-EXP -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- FLAG REVISED BUDG CURRENT PD YTD EXPEND -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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: 0.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 0.00 0.00 Capital Projects 1,860,000 1,860,000 839,021.00 958,449.60 901,550.40 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Capital Projects: 1,860,000 1,860,000 839,021.00 958,449.60 901,550.40 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 2,045,813 2,045,813 0.00 0.00 2,045,813 .00 0 Balance Available 0 0 0.00 0.00 0.00 0 52 .... Total Non Departmental: 2,045,813.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 2,045,813 2,045,813 0.00 0.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total F\llld: 3,905,813 3,905,813 839,021. 00 958,449.60 2,947,363.40 Report ID: SPRG508.SQR FUND : 412 Reg Wastewater Rev Bond Cap pr City Of Springfield BUD.GET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 16 Run Date 10/12/2007 Run Time 09:41:07 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING 'lEXP 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 76,226,346 76,226,346 1,442,841.18 2,145,486.06 74,080,859.94 3 Total Capital Projects: 76,226,346 76,226,346 1,442,841.18 2,145,486.06 74,080,859.94 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 O' 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 8,221,870 8,221,870 0.00 0.00 8,221,870.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 8,221,870 8,221,870 0.00 0.00 8,221,870.00 Total Fund: 84,448,216 84,448,216 1,442,841.18 2,145;486.06 82,302,729.94 Report ID: SPRG508.SQR FUND : 416 SDC Capital Projects Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 17 Run Date 10/12/2007 Run Time 09:41:07 ADOPTED BUDG %-EXP -------------------------------------------------------------------------------------------------------------------------------------- FLAG REVISED BUDG CURRENT PD YTD EXPEND REMAINING ------------------------------------------------------------------------------------------------------------------------------------------- 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: 0.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 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 Payment~ 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: 0.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 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 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 18 Run Date 10/12/2007 Run Time 09:41:07 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 89,288 89,288 7,253.93 18,634.57 70,653.43 21 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: 89,288 89,288 7,253.93 18,634.57 70,653.43 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 33,025 33,025 0.00 0.00 33,025.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,407,147 1,407,147 0.00 0.00 1,407,147.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 1,440,172 1,440,172 0.00 0.00 1,440,172.00 Total Fund: 1,529,460 1,529,460 7,253.93 18,634.57 1,510,825.43 Report ID: SPRG508.SQR FUND : 420 Development Projects City Of Springfield BUDGET AND ACTUAL REPORT.BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 19 Run Date 10/12/2007 Run Time 09:41:07 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 3,554.77 13,466.04 -13,466.04 0 **** DSD 0 .0 0.00 0.00 0.00 0 Departmental Operating: o o 3,554.77 13,466.04 -13,466.04 Capital Projects 14,541,949 14,541,949 160,197.78 445,427.95 14,096,521.05 3 Total Capital Projects: 14,541,949 14,541,949 160,197.78 445,427.95 14,096,521.05 Interf\llld Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 1,500,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 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,616,895 1,616,895 0.00 0.00 1,616,895.00 0 Balance Available 0 0 0.00 0.00 0.00 . 0 Total Non Departmental: 3,116,895 3,116,895 0.00 0.00 3,116,895.00 Total Fund: 17,658,844 17,658,844 163,752.55 458,893.99 17,199,950.01 Report ID: SPRG508.SQR FUND : 425 Storm Drainage Capital Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 20 Run Date 10/12/2007 Run Time 09:41:07 ADOPTED BUDG REMAINING %-EXP -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- FLAG REVISED BUDG CURRENT PD YTD EXPEND -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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: 0.00 . . ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 0.00 0.00 Capital Projects 1,409,025 1,409,025 19,027.33 33,301. 34 1,375,723.66 Total Capital Projects: 1,409,025 1,409,025 19,027.33 33,301. 34 1,375,723.66 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 363,938 363,938 0.00 0.00 363,938.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 363,938 363,938 0.00 0.00 363,938.00 Total Fund: 1,772,963 1,772,963 19,027.33 33,301. 34 1,739,661.66 2 Report ID: SPRG508.SQR FUND : 427 GO Bond Capital Projects City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 21 Run Date 10/12/2007 Run Time .09:41:07 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 : 428 Police Building Bond Cap proj City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %-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 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 477,079 477,079 47,064.40 94,373.63 382,705.37 20 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 477,079 477,079 47,064.40 94,373.63 382,705.37 Capital Projects 22,551,357 22,551,357 357,954.78 775,802.28 21,775,554.72 Total Capital Projects: 22,551,357 22,551,357 357,954.78 775,802.28 21,775,554.72 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 484,000 484,000 0.00 0.00 484,000.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 484,000 484,000 0.00 0.00 484,000.00 Total Fund: 23,512,436 23,512,436 405,019.18 870,175.91 22,642,260.09 Page No. 22 Run Date 10/12/2007 Run Time 09:41:07 FLAG 3 Report ID: SPRG508.SQR FUND : 429 SEDA Capital Project Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 23 Run Date 10/12/2007 Run Time 09:41:07 ADOPTED BUDG REMAINING %-EXP --------~----------------------------------------------------------------------------------------------------------------------------------------------------------------------- FLAG REVISED BUDG CURRENT PD YTD EXPEND -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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: 0.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 0.00 0.00 Capital Projects 2,304,000 2,304,000 273.20 273.20 2,303,726.80 ---------------------------------------------------------------------------------------------------------------------------------------------------------- o Total Capital Projects: 2,304,000 2,304,000 273.20 273.20 2,303,726.80 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 0 0 0.00 0.00 0.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 0.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 0.00 0.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total F\llld: 2,304,000 2,304,000 273.20 273 .20 2,303,726.80 Report ID: SPRG508.SQR FUND : 433 Regional Wastewater Capital Fd City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 24 Run Date 10/12/2007 Run Time 09:41:07 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 756,534 756,534 24,339.47 24,352.97 732,181.03 3 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 756,534 756,534 24,339.47 24,352.97 732,181.03 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 33,548,216 33,548,216 0.00 38,212,655.33 -4,664,439.33 114 **** 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 23,772,750 23,772,750 0.00 0.00 23,772,750.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 57,320,966 57,320,966 0.00 38,212,655.33 19,108,310.67 Total F\llld: 58,077,500 58,077,500 24,339.47 38,237,008.30 19,840,491.70 Report ID: FUND : 434 SPRG508.SQR Street Capital Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 25 Run Date 10/12/2007 Run Time 09:41:07 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 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 1,391,997 1,391,997 350,616.83 829,812.38 562,184.62 60 Total Capital Projects: 1,391,997 1,391,997 350,616.83 829,812.38 562,184.62 Interf\llld 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 60,365 60,365 0.00 0.00 60,365.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 60,365 60,365 0.00 0.00 60,365.00 Total Fund: 1,452,362 1,452,362 350,616.83 829,812.38 622,549.62 Report ID: SPRG508.SQR FUND : 435 Transportation SDC Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED ADOPTED BUDG REVISED BUDG CURRENT PD REMAINING %-EXP ---------------------------------------------------------------------------------------------------------------------------------------------------------------------~---------- FLAG YTD EXPEND 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 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 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 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 Page No. 26 Run Date 10/12/2007 Run Time 09:41:07 o Report ID: SPRG508.SQR FUND : 436 Sewer SDC Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 27 Run Date 10/12/2007 Run Time 09:41:07 ADOPTED BUDG REMAINING \EXP ------------------------------------------------------------------------------------------------------------------------------------------- FLAG REVISED BUDG CURRENT PD YTD EXPEND -------------------------------------------------------------------------------------------------------------------------------------------------------- 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: 0.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- o o 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 F\llld: 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 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING 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 0.00 0.00 0.00 Capital Projects o o 0.00 0.00 0.00 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 Mise Fiscal Transactions 0 0 0.00 0.00 0.00 0 Conti.ngencies 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 Page No. 28 Run Date 10/12/2007 Run Time 09:41:07 %-EXP FLAG o o o o o o o o o o o Report ID: SPRG508.SQR FUND : 440 Storm Drainage SDC Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 29 Run Date 10/12/2007 Run Time 09:41:07 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 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 74,201 74,201 24,733.42 37,100.26 37,100.74 50 0 0 0.00 0.00 0.00 0 Departmental Operating: 74,201 74,201 24,733.42 37,100.26 37,100.74 Capital Projects 961,620 961,620 2,697.45 105,503.17 856,116.83 11 Total Capital Projects: 961,620 961,620 2,697.45. 105,503.17 856,116.83 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 25,649 25,649 0.00 0.00 25,649.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,509,639 1,509,639 0.00 0.00 1,509,639.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 1,535,288 1,535,288 0.00 0.00 1,535,288.00 Total Fund: 2,571,109 2,571,109 27,430.87 142,603.43 2,428,505.57 Report ID: SPRG508.SQR FUND : 442 Sanitary Sewer Reimb SDC Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008. and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 30 Run Date 10/12/2007 Run Time 09:41:07 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 50,191 50,191 16,730.08 25,095.24 25,095.76 50 ***. DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 50,191 50,191 16,730.08 25,095.24 25,095.76 Capital Projects 205,000 205,000 0.00 0.00 205,000.00 o Total Capital Projects: 205,000 205,000 0.00 0.00 205,000.00 Interfund Loans 0 0 0.00 0.00 0.00 Interfund Transfers 0 0 0.00 0.00 0.00 Debt Service 0 0 0.00 0.00 0.00 Statutory Payments 0 0 0.00 0.00 0.00 Mise Fiscal Transactions 0 0 0.00 0.00 0.00 Contingencies 0 0 0.00 0.00 0.00 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 Reserves 112,857 112,857 0.00 0.00 112,857.00 Balance Available 0 0 0.00 0.00 0.00 o o o o o o o o o Total Non Departmental: 112,857 112,857 0.00 0.00 112,857.00 Total F\llld: 368,048 368,048 16,730.08 25,095.24 342,952.76 Report ID: SPRG508.SQR FUND : 443 Sanitary Sewer Improvement SDC City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 31 Run Date 10/12/2007 Run Time 09:41:07 ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING 'lEXP 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 38,151 38,151 12,716.75 19,075.25 19,075.75 50 0 0 0.00 0.00 0.00 0 Departmental Operating: 38,151 38,151 12,716.75 19,075.25 19,075.75 Capital Projects 110,000 110,000 10,335.53 92,066.49 17,933.51 84 Total Capital Projects: 110,000 110,000 10,335.53 92,066.49 17,933.51 Interf\llld Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 45,662 45,662 0.00 0.00 45,662.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 O. 0.00 0.00 0.00 0 Reserves 14,212 14,212 0.00 0.00 14,212.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 59,874 59,874 0.00 0.00 59,874.00 Total Fund: 208,025 208,025 23,052.28 111,141. 74 96,883.26 Report ID: SPRG508.SQR FUND : 444 SDC Regional Wastewater Reimb City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 32 Run Date 10/12/2007 Run Time 09:41:07 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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,500 1,500 35.60 981. 48 518.52 65 **** DSD 0 0 0.00 0.00 0.00 0 -----------------------------------------------------------------------.----------------------------------------------------------------------------------- Departmental Operating: 1,500 1,500 35.60 981.48 518.52 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 Interfund Transfers 1,234,029 1,234,029 0.00 0.00 1,234,029.00 Debt Service 0 0 0.00 0.00 0.00 Statutory Payments 0 0 0.00 0.00 0.00 Mise Fiscal Transactions 0 0 0.00 0.00 0.00 Contingencies 0 0 0.00 0.00 0.00 Unappropriated Fund Balan 0 0 0.00 0.00 0.00 Reserves 4,179,270 4,179,270 0.00 0.00 4,179,270.00 Balance Available 0 0 0.00 0.00 0.00 o o o o o o o o o Total Non Departmental: 5,413,299 5,413,299 0.00 0.00 5,413,299.00 Total Fund: 5,414,799 5,414,799 35.60 981. 48 5,413,817.52 Report ID: SPRG508.SQR FUND : 445 SDC Regional Wastewater Imp City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 33 Run Date 10/12/2007 Run Time 09:41:07 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 4,500 4,500 148.84 ' 240.80 4,259.20 5 DSD 0 0 0.00 0.00 0.00 0 ----------------------------------------------------------------------------------------------------------------------------- Departmental Operating: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 4,500 4,500 148.84 240.80 4,259.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 1,234,030 1,234,030 0.00 0.00 1,234,030.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 6,375,428 6,375,428 0.00 0.00 6,375,428.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 7,609,458 7,609,458 0.00 0.00 7,609,458.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 7,613 ,958 7,613,958 148..84 240.80 7,613,717.20 Report ID: SPRG508.SQR FUND : 446 SDC Transportation Reimburseme City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 34 Run Date 10/12/2007 Run Time 09:41:07 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 O. 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 18,562.75 27,228.25 24,764.75 52 ***. DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 51,993 51,993 18,562.75 27,228.25 24,764.75 Capital Projects 362,700 362,700 0.00 0.00 362,700.00 o Total Capital Projects: 362,700 362,700 0.00 0.00 362,700.00 Interf\llld Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 10,374 10,374 0.00 0.00 10,374.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 236,400 236,400 0.00 0.00 236,400.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 246,774 246,774 0.00 0.00 246,774.00 Total Fund: 661;467 661,467 18,562.75 27,228.25 634,238.75 Report ID: SPRG508.SQR FUND : 447 SDC Transportation Improvement City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 35 Run Date 10/12/2007 Run Time 09:41:07 ADOPTED BUDG REMAINING %-EXP -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- FLAG REVISED BUDG CURRENT PD YTD EXPEND -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 78,767.00 115,531. 00 105,053.00 52 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: 105,053.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 220,584 220,584 78,767.00 115,531. 00 Capital Projects 2,922,730 2,922,730 74,920.80 75,423.12 2,847,306.88 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 3 Total Capital Projects: 2,922,730 2,922,730 74,920.80 75,423.12 2,847,306.88 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 1,144,594 1,144,594 0.00 0.00 1,144,594.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 1,144,594.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- 1,144,594 1,144,594 0.00 0.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Fund: 4,287,908 4,287,908 153,687.80 190,954.12 4,096,953.88 Report ID: SPRG508.SQR FUND : 611 Sanitary Sewer Operations .Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 36 Run Date 10/12/2007 Run Time 09:41:07 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 9,290 9,290 1,001.56 2,309.72 6,980.28 25 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 3,050,662 3,050,662 252,560.06 582,049.18 2,468,612.82 19 DSD 21,833 21,833 2,230.61 5,289.00 16,544.00 24 Departmental Operating: 3,081,785 3,081,785 255,792 .23 589,647.90 2,492,137.10 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,358,248 1,358,248 337,437.50 337,437.50 1,020,810.50 25 Debt Service 738,752 738,752 0.00 150,007.73 588,744.27 20 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 727,249 727,249 0.00 0.00 727,249.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 2,824,249 2,824,249 337,437.50 487,445.23 2,336,803.77 Total Fund: 5,906,034 5,906,034 593,229.73 1,077,093.13 4,828,940.87 Report ID: SPRG508.SQR FUND : 612 Regional Wastewater Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 .25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 37 Run Date 10/12/2007 Run Time 09:41:07 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 120,712 120,712 6,600.71 19,755.27 100,956.73 16 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,647,094 13,647,094 1,297,727.16 2,538,722.64 11,108,371.36 19 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 13,767,806 13,767,806 1,304,327.87 2,558,477.91 11,209,328.09 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 5,939,997 5,939,997 391,401.91 1,174,205.73 4,765,791.27 20 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 8,327,461 8,327,461 0.00 0.00 8,327,461.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 14,267,458 14,267,458 391,401.91 1,174.,205.73 13,093,252.27 Total Fund: --------------------------------------------------------------------------------------------------------------------------------------------------.-------- 28,035,264 28,035,264 1,695,729.78 3,732,683.64 24,302,580.36 Report ID: SPRG508.SQR FUND : 615 Ambulance Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 38 Run Date 10/12/2007 Run Time 09:41:07 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,500,562 4,500,562 376,112.52 984,204.14 3,516,357.86 22 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,500,562 4,500,562 376,112.52 984,204.14 3,516,357.86 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 4,995 4,995 0.00 0.00 4,995.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 173,672 173,672 0.00 0.00 173,672.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 178,667 178,667 0.00 0.00 178,667.00 Total Fund: 4,679,229 4,679,229 376,112.52 984,204.14 3,695,024.86 Report ID: SPRG508.SQR FUND : 617 Storm Drainage Operations Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 39 Run Date 10/12/2007 Run Time 09:41:07 --------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUOG REVISED BUDG CURRENT PD YTD EXPEND REMAINING 'IrEXP 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 9,288 9,288 1,001.39 2,309.21 6,978.79 25 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,029,655 4,029,655 348,282.44 813,275.41 3,216,379.59 20 DSD 33,367 33,367 4,214.35 10,504.15 22,862.85 31 **** Departmental Operating: -------------------------------------------------------------------~------------------------------------------------------------------'-------------------- 4,072,310 4,072,310 353,498.18 826,088.77 3,246,221.23, 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 353,641 353,641 85,000.00 85,000.00 268,641.00 24 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 699,447 699,447 0.00 0.00 699,447.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 1,053,088 1,-053,088 85,000.00 85,000.00 968,088.00 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total F\llld: 5,125,398 5,125,398 438,498.18 911,088.77 4,214,309.23 ( Report ID: FUND : 618 City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED SPRG508.SQR Booth-Kelly Fund ADOPTED BUDG REVISED BUDG REMAINING CURRENT PD YTD EXPEND 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 11,596 11,596 1,246.96 5,389.11 6,206.89 DSD '324,486 324,486 19,040.45 45,164.24 279,321.76 Departmental Operating: 336,082 336,082 20,287.41 50,553.35 285,528.65 Capital Projects 155,000 155,000 0.00 421. 00 154,579.00 Total Capital Projects: 155,000 155,000 0.00 421.00 154,579.00 Interfund Loans 0 0 0.00 0.00 0.00 0 Interfund Transfers 438,996 438,996 36;583.00 109,749.00 329,247.00 25 Debt.Service 90,000 90,000 7,024.41 21,073.23 68,926.77 23 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 828,132 828,132 0.00 0.00 828,132.00 0 'Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 1,357,128 1,357,128 43,607.41 130,822.23 1,226,305.77 Total Fund: 1,848,210 1,848,210 63,894.82 181,796.58 1,666,413 .42 Page No. 40 Run Date 10/12/2007 Run Time 09:41:07 %-EXP FLAG o o o o o o o o 46 **** 14 o Report ID: SPRG508.SQR FUND : 629 Regional Fiber Consortium City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 41 Run Date 10/12/2007 Run Time 09:41:07 --------------------------------------------------------------------------------------------------------------------------------------------------- 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,500 17,500 0.00 0.00 17,500.00 0 DSD 0 0 0.00 0.00 0.00 0 Departmental Operating: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 17,500 17,500 0.00 0.00 17,500.00 Capital Projects o o 0.00 0.00 0.00 o 'J ---------------------------------------------------------------------------------------------------------------------------------------------------------- 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 0.00 12,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 24,867 24,867 0.00 0.00 24,867.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 36,867 36,867 0.00 0.00 36,867.00 Total Fund: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 54,367 54,367 0.00 0.00 54,367.00 / Report ID: SPRG508.SQR FUND : 707 Insurance Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 42 Run Date 10/12/2007 Run Time 09:41:07 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 704,445 704,445 44,322.33 111,188.42 593,256.58 16 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: 704,445 704,445 44,322.33 111,188.42 593,256.58 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,737,953 12,737,953 1,042,331.60 2,608,053.64 10,129,899.36 20 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 3,148,999 3,148,999 0.00 0.00 3,148,999.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 15,886,952 15,886,952 1,042,331.60 2,608,053.64 13,278,898.36 Total F\llld: 16,591,397 16,591,397 1,086,653.93 2,719,242.06 13,872,154.94 Report ID: SPRG508.SQR FUND : 713 Vehicle & Equipment Fund City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED Page No. 43 Run Date 10/12/2007 Run Time 09:41:07 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ADOPTED BUDG REVISED BUDG CURRENT PD YTD EXPEND REMAINING %:EXP FLAG -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CMO 2,200 2,200 2,030.95 2,030.95 169.05 92 **** Court 0 0 0.00 0.00 0.00 0 HR 6,200 6,200 3,516.00 4,373.99 1,826.01 71 **** Finance 3,000 3,000 0.00 0.00 3,000.00 0 IT 212,500 212,500 928.99 928.99 211,571.01 0 Fire 50,650 50,650 0.00 0.00 50,650.00 0 Police 208,700 208,700 8,423.75 10,271.66 198,428.34 5 Library 0 0 0.00 0.00 0.00 0 Public Works 678,688 678,688 1,073.79 41,484.38 637,203.62 6 DSD 25,600 25,600 0.00 0.00 25,600.00 0 Departmental Operating: ---------------------------------------------------------------------------------------------------------------------------------------------------------- 1,187,538 1,187,538 15,973.48 59,089.97 1,128,448.03 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 43,958 43,958 635.72 1,927.10 42,030.90 4 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,080,074 5,080,074 0.00 0.00 5,080,074.00 0 Balance Available 0 0 0.00 0.00 0.00 0 ----------------------------------------------------------------------------------------------------------------------------------------------------- Total Non Departmental: 5,124,032 5,124,032 635.72 1,927.10 5,122,104.90 ---------------------------------------------------------------------------------------------------------------------------------------------------------- Total Fund: 6,311,570 6,311,570 16,609.20 61,017.07 6,250,552.93 Report ID: SPRG508.SQR FUND : 719 SDC Administration City Of Springfield BUDGET AND ACTUAL REPORT BY FUND/DEPT As Of Year 2008 and Period 3 25 PERCENT OF FISCAL YEAR HAS ELAPSED ADOPTED BUDG REVISED BUDG REMAINING %-EXP CURRENT PD YTD EXPEND 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,286 23,286 2,431.94 8,029.97 15,256.03 34 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 525,981 525,981 34,294.80 78,156.96 447,824.04 15 DSD 103,559 103,559 9,853.84 23,199.46 80,359.54 22 Departmental Operating: 652,826 652,826 46,580.58 109,386.39 543,439.61 Capital Projects o o 0.00 0.00 0.00 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,930 1,930 0.00 0.00 1,930.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 4,610 4,610 0.00 0.00 4,610.00 0 Balance Available 0 0 0.00 0.00 0.00 0 Total Non Departmental: 6,540 6,540 0.00 0.00 6,540.00 Total Fund: 659,366 46,580.58 659,366 109,386.39. 549,979.61 Grand Total : 344,632,624 11,592,570.20 344,632,624 64,015,320.68 280,617,303.32 End of Report Page No. 44 Run Date 10/12/2007 Run Time 09:55:16 FLAG o