Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Statement & Notes Support
Municipal SMar et Disc osure Information Cover Sheet IF THIS FILING RELATES TO A SINGLE BOND ISSUE: Provide name of bond issue exactly as it appears on the cover of the Official Statement Provide nine -digit CUSIP* numbers if available, to which the information relates: IF THIS FILING RELATES TO ALL SECURITIES ISSUED BY THE ISSUER OR ALL SECURITIES OF A SPECIFIC CREDIT OR ISSUED UNDER SINGLE INDENTURE: Issuer's Name (please include name of state where Issuer is located): City of Brooklyn Center, Minnesota Other Obligated Person's Name (if any): (Exactly as it appears on the Official Statement Cover) Provide six -digit CUSIP* number(s) if available, of Issuer: 113835 TYPE OF FILING: ® Electronic (number of pages attached) El Paper (number of pages attached) If information is also available on the Internet, give URL: B0201 Page 2 Issuer's Name: City of Brooklyn Center, Minnesota WHAT TYPE OF INFORMATION ARE YOU PROVIDING? (Check all that apply) A. ® Annual Financial Information and Operating Data pursuant to Rule 15c2 -12 Fiscal Period Covered: Fiscal year ending January 31, 2006 to December 31, 2006 B. ® Financial Statements or CAFR pursuant to Rule 15c2 -12 Fiscal Period Covered: Fiscal year ending January 31, 2006 to December 31, 2006 C. ❑ Notice of a Material Event pursuant to Rule 15c2 -12 (Check appropriate box) 1. ❑ Principal and interest payment delinquencies 6. ❑ Adverse tax opinions or events affecting the 2. ❑ Non - payment related defaults tax - exempt status of the security 3. ❑ Unscheduled draws on debt service reserves 7. ❑ Modifications to rights of security holders reflecting financial difficulties 8. ❑ Bond calls 4. ❑ Unscheduled draws on credit enhancements 9. ❑ Defeasances reflecting financial difficulties 10. El Release, substitution, or sale of property securing 5. ❑ Substitution of credit or liquidity providers, repayment of the securities or their failure to perform 11. ❑ Rating changes D. ❑ Notice of Failure to Provide Annual Financial Information as Required E. ❑ Other Secondary Market Information (Specify): I hereby represent that I am authorized by the issuer or obligor or its agent to distribute this information publicly: Issuer Contact: Name: Mr. Daniel Jordet Title: Finance Director Employer: City of Brooklyn Center Address: 6301 Shingle Creek Parkway City: Brooklyn Center State: MN Zip: 55430 Telephone: (763) 569 -3300 Fax: (763) 569 -3494 Email Address: djordet @ci.brooklyn - center.mn.us Issuer Web Site Address: http: / /www.ci.brooklyn- center.mn.us/ Dissemination Agent Contact, if any: Name: Willa T. Washington Title: Continuing Disclosure Specialist Employer: Springsted Incorporated Address: 380 Jackson Street, Suite 300 City: Saint Paul State: MN Zip Code: 55101 -2887 Telephone: (651) 223 -3038 Fax: (651) 223 -3046 Email Address: wwashington @springsted.com Relationship to Issuer: Financial Advisor Obligor Contact, if any: Name: Title: Employer: Address: City: State: Zip Code: Telephone: Fax: Email Address: Obligor Web Site Address: Investor Relations Contact, if any: Name: Title: Telephone: Email Address: 2006 Annual Report (Fiscal Period Covered: Januar 1, 2006 throu December 31, 2006) Cit of Brookl Center, Minnesota CUSIP # 113835 Prepared b Willa T. Washin Continuin Disclosure Specialist 380 Jackson Street, Suite 300 St. Paul, Minnesota 55101 -2887 Telephone: (651) 223-3038 Fax: (651) 223-3046 80201 CITY PROPERTY VALUES 2006 Indicated Market Value of Taxable Propert $ 2,38 3,535,1 35 *The indicated market value is calculated b dividin the Cit taxable market value of $2,113,915,200 b the 2006 sales ratio of 88.8 % for the Cit as determined b the State Department of Revenue. 2006 Taxable Net Tax Capacit $ 24,453,648 2006 Net Tax Capacit $ 25,293,171 Plus: Fiscal Disparit Distribution 4$1241277 Less: Captured Tax Increment (2,463,631) Fiscal Disparit Contribution (2,500,169) 2006 Taxable Net Tax Capacit $ 241453,648 ......................... 2006 Taxable Net Tax Capacit b Class of Propert Residential Homestead $ 15,436,568 63-13% Non-Homestead Residential 2,093,508 8.56% Commercial/Industrial, Public Utilit and Railroad* 676357374 27.13% A 5,000 0.02% Personal Propert 283,198 1.16% Total $ 241453,648 100-00% Includes net fiscal disparities and tax increment adjustments. Trend of Values Indicated Taxable Taxable Net Market Value Market Value Tax Capac 2006/07 $ 2,380,535,135 2,113,915,200 2414531648 2005106 2,210,769,673 1,960,952,700 22,319,064 2004105 2,17'1, 503, 981 11800,176,800 20,275,794 2003/04 2,033,985,982 1,625,154,800 18,588,859 2002103 1,847,358,801 1)479,734,400 17,426,504 Calculated b dividin the count assessoes estimated market value b the sales ratio determined for the Cit each y ear b the State Department of Revenue. Ten of the Lar Taxpa in the Cit of Brookl Center 2006 Net Tax Taxpaye T of Propell C acit Brooks Mall Properties LLC Commercial $ 261,190 Brookdale Corner LLC Commercial 208,050 Medtronic Inc. Industrial 197,970 Re Cinemas Inc Commercial 180,122 TLN Lanel A LTD Partnership Apartment 1711763 Wickes Furniture Compan Industrial 164,850 Tar Corporation T-0240 Commercial 154,850 Melrose Gates LLC Apartment 130,213 Cit Federal Credit Union Commercial 121,650 LTF Real Estate Compan Inc. Commercial 108,250 Total 1,698,908 (b) (a) The valuation of Brookdale Mall decrease in 2006 because part of it was reclassified as a separate parcel. (b) Represents 6.9% of the Cit 2006 taxable net tax capacit Pa 1 CITY INDEBTEDNESS Legal Debt Limit and Debt Margin Legal Debt Limit (2g6of Taxable Market Value) $ 42 Less: Outstanding Debt Subject toLimit Debt Margin eaof December 31,2OOG $ 37 General Obligation Debt Supported by Taxes Principal Date C}hginm| Final Outstanding of Issue Amount Purpose Maturity 12/31/06 01/01/04 $ 5 Police and Fire Building Refunding 02/01/13 $ 4 ~ This issue issubject tome legal debt limit. General Obligation Debt Supported Primarily bySpecial Assessments Principal Dote [)hgino< Final Outstanding of Issue Amount Purpose Maturity 12/31/06 11/01/86 $ 1 ,000 Improvements 02/01/07 $ 180 12/01/97 1 Improvements 02/01/08 200 12/01/88 1 Improvements 02/01/09 285 12/01/98 1 Improvements 02/01/10 815 12/01/00 735 Improvements 02/01/11 345.000 12/01/01 730 Improvements 02/01/12 410 01/01/03 1 Improvements 02/01/13 805 12/01/04 1 Improvements 02/01/15 880 12/15/06 1 Improvements 02/01/17 1 Total $ 5 General Obligation Debt Supported by Tax Increments Principal Date Original Final Outstanding of|amue Amount Purpose Matu 12/31/00 01/01/04 $ 2 Taxable Tax Increment Refunding 02/01/11 $ 2 12/01/04 17 Taxable Tax Increment 82/01/20 16 Total $ 18 Page Annual Calendar Year Debt Service GI}. Deb Supported G.O. Debt Supported Primarily ... b Taxes b S Assessments Principal Principal Year PZin &]gnterest P[incip I &_In1erest 2008 12131 (Paid) (Paid) (Paid) (Paid) 2007 $ 580.00O $ 714.890.00 $ 800.000 $ 1 2008 600 710.552.50 880 1 2009 61 O 703 785.000 876.351.25 2010 640.000 715.152.50 845.000 728.597.50 2011 640.000 695.632.50 485.000 546 2012 885.000 718.581.25 415.000 459.433.75 2013 700.000 711.725.00 340.000 370 2014 - - 230.000 249 2015 - - 225.000 238.550.00 2018 - - 130.000 134 2017 ' - 65000 6823500 Total $ 4 $ 4.971 5.180 (a) 5.858.458.98 G.[>. Debt Supported b ax Increments Principal Year P[in & 1n1erest. 2006 12/31 (Paid) (Paid) 2007 $ 1 $ 1 2008 1.030.000 1 2009 1 1 2010 1 1.830.280.00 2011 1 1.823 2012 800.000 1 2013 1 1.803.762.50 2014 1.305.000 1.808.818.75 2015 1.380.000 1.819.550.00 2018 1 1 2017 1 1 2018 1.610 1 2018 1 1 2020 1 1,846 Total $ 18 (b) $ 25.278 (a) 98.r%or this debt will be retired within ten years. M ao.amor this debt will ueretired within ten years. Page Indirect General Obligation Debt 2006 G.O. Debt Debt Applicable to Net as of Tax Capacity in City Taxi Unit (a) Tax Capacit 31- Dec -06 (b) Percent Amount Hennepin County $ 1,480,713,060 $ 426,035,000 1.7% $ 7,242,595 Hennepin County Regional Railroad 1,480,713,060 45,865,000 1.7% 779,705 Three Rivers Park District 1,105,871,333 69,975,000 2.2% 1,539,450 ISD 011 (Anoka- Hennepin) 44,688,167 177,245,000 7.2% 12,761,640 ISD 279 (Osseo) 150,011,324 186,300,000 5.6% 10,432,800 ISD 281 (Robbinsdale) 103,680,164 163,880,000 5.4% 8,849,520 ISD 286 (Brooklyn Center) 7,279,906 30,965,000 100.0% 30,965,000 Metropolitan Council 3,342,207,897 27,435,000 (c) 0.7% 192,045 Metropolitan Transit 2,711,740,994 147,310,000 (d) 0.9% 1,325,790 Total $ 74,088,545 (a) Only those units with general obligation debt outstanding are included here. (b) Excludes general obligation debt supported by revenues, revenue debt 8tate-aid road bonds, and grant and loan anticipation certificates. Includes annual appropriation lease obligations. (c) Excludes obligation debt supported by sanitary sewer reven ues, 999 user fees, and rental housing revenues and includes certificates ofparticipation, (d) Includes lease revenue bonds subject to annual appropriation, issued by the Bloomington Port Authority for constructing and equipping a transit station andparking ramp. G.0, G.O. Indirect Direct Debt and Direct Debt To 2006 Indicated Market Value W $2,380,535,935 1.17% 4.29% Per Capita (27,901 - 2006 State Demographer's Estimate) $1,002 $3,657 * excludes general obligation debt supported by revenues, revenue debt and includes lease obligations CITY TAX RATES, LEVIES AND COLLECTIONS Tax Capacity Rates 2006/07 For 2002103 2003/04 2004105 2005/06 Total Debt Onl Hennepin County 50.607 % 47.324 % 44.172 % 41.016 % 39.110 % 5.614 % City of Brooklyn Center (a) 54.021 53.693 51.723 48.069 45.366 0.000 ISD 286 (Brooklyn Center) 49.817 39.892 36.159 39.781 36.154 28.122 Special Districts 7.757 7.192 7.382 6.998 7,310 3199 Total 162.202 % 148.101 % 139.436 % 135.864 % 127.940 % 37.935 % (a) The City has a 2006A97 tax rate of 0.738021 spread on the market value of property in support of debt service. (b) Independent School District 286 ( Brooklyn Center) also has a 200610 7 rate of 0.084851 spread on the market value of property in support of an excess operating levy (c) Special districts include Metropolitan Council, Mosquito Control, !Metropolitan Transit, Hennepin Park Museum, Hennepin County Regional Rail Authority, and Three Rivers Park District. NOTE: Taxes are determined by multiplying the net tax capacity by the tax capacity rate, expressed as a percen tage. City Tax Levies and Collections Collected During Collection Year Collected as of 31- fray -07 Levy /Collect Net Levy (a) Amount Percent Amount Percent 2006/07 $ 11,959,248 $ 5,532,716 (b) 46.3% $ 5,532,716 (b) 46.3% 2005106 10,971,063 10,697,637 97.5% 10,803,078 98.5% 20€741135 10,586,264 10 98.3% 10,539,719 99.6% 2003/04 9,994,050 9,504,581 95.1% 9,956,463 99.6% 2002103 9,585,107 9,280,043 96.8% 9,523,574 99,4% (a) The net levy excludes state aid for property tax relief and fiscal disparities, if applicable, The net levy is the basis for computing fax capacity rates. (b) Reflects only first half tax collections. FUNDS ON HAND (Please reference 2006 Comprehensive Annual Financial Deport) 2006 BUDGET (Please reference 2006 Comprehensive Annual Financial Report) Page 4 COMPREHENSIVE ANNUAL FINANCIAL REPORT OF THE CITY OF BROOKLYNCENTER, MINNESOTA Cornelius L. Boganey City Manager Prepared By: FINANCE DIVISION DEPARTMENT OF FISCAL &SUPPORT SERVICES Daniel Jordet Director Clara Hilger Assistant Finance Director FOR THE YEAR ENDED DECEMBER 31, 2006 E7 (Member of Government Finance Officers Association of the United States and Canada) reported in City CAFR ARC Actual Interest on ARC Amort Amort Pension change in NPO UAAL normal UAAL Amort admin Contr NPO Adjust Period Factor Cost NPO Balance 1987 9 45,558 46,985 - 92,543 120,656 NA NA NA NA 92,543 (28,113) (28,113) 1988 9 59,759 40,642 - 100,401 110,731 (1 (3 12 8.8633 102 (8 (36,677) 1989 299,215 62 42,674 - 105,421 108,636 (1 (4 11 8.3064 108,003 (633) (37,310) 1990 145,597 62 42,674 - 105,421 110,268 (1 (4 10 7.7217 108,387 (1 (39,191) 1991 29,444 62 42,674 - 105,421 97,669 (1 (5 9 7.1078 108,975 11,306 (27,885) 1992 (66,422) 63,946 19,844 - 83,790 89,900 (1 (4 8 6.4632 86,710 (3 (31,075) 1993 46,636 63,946 19,844 - 83,790 91,829 (1 (5 7 5.7864 87,606 (4 (35,298) 1994 107 68,698 26,241 - 94,939 102,895 (1 (6 6 5.0757 100,128 (2 (38,065) 1995 (19,487) 68,698 (26,241) - 42 111 (1 (8 5 4.3295 49,346 (62,045) (100,110) 1996 (298,956) 68,698 (26,241) - 42 127,564 (5 (28,232) 4 3.5460 65,683 (61,881) (161,991) 1997 (278,834) 68,698 26,241 13,512 108,451 123,070 (12,149) (62,292) 3 2.6005 158,594 35,524 (126,467) 1998 (438,538) 75,000 3 17 95,176 107 (9 (70,433) 2 1.7956 156,124 48,909 (77,558) 1999 (789,400) 71,537 - 25,080 96,617 116,570 (5 (83,375) 1 0.9302 174 57,605 (19,953) 2000 (621,028) 45,795 - 11,084 56,879 120,175 (1 (2 19 9.9591 57,386 (62,789) (82,742) 2001 (316,809) 90,148 - 21,673 111 118,508 (6 (8 18 9.7060 114 (4 (87,110) 2002 (61,445) 90,148 - 21,673 111 118,508 (6 (9 17 9.4340 114,522 (3 (91,096) 2003 (309,010) 70,401 - - 70,401 124 (6 (9 16 9.1415 73,534 (50,589) (141,685) 2004 (594,854) 79,135 - - 79,135 158,991 (10,626) (16,051) 15 8.8271 84,560 (74,431) (216,116) 2005 (525,034) 70,409 - - 70,409 154,346 (12,967) (23,251) 14 9.2950 80,693 (73,653) (289,769) F 2006 (311,695) 79,135 (39,538) 19,562 59,159 161,019 (17,386) (32,732) 13 8.8527 74,505 (86,514) (376,283) 2007 (311,695) 100,667 (39,538) 21,689 82,818 137 (22,577) (44,882) 12 8.3838 105,123 (32,318) (408,601) 2008 - (24,516) (51,808) 11 7.8869 27 27 (381,309) 2009 - (22,879) (51,808) 10 7.3601 28,929 28,929 (352,380) 2010 - (21,143) (51,808) 9 6.8017 30,665 30,665 (321,715) 2011 - (19,303) (51,808) 8 6.2098 32,505 32,505 (289,210) 2012 - (17,353) (51,808) 7 5.5824 34 34 (254,755) 2013 - (15,285) (51,808) 6 4.9173 36,523 36,523 (218,232) 2014 - (13,094) (51,807) 5 4.2124 38,713 38,713 (179,519) 2015 - (10,771) (51,808) 4 3.4651 41,037 41,037 (138,482) 2016 - (8 (51,807) 3 2.6730 43,498 43,498 (94,984) 2017 - (5 (51,808) 2 1.8334 46,109 46,109 (48,875) 2018 - (2 (51,807) 1 0.9434 48,874 48,874 (1) Information taken from Notes in CAFRs to determine amortization period: Actuarials prior to 1999 stated that UAAL was to be fully funded by 1999 CAFR for 2002 (actuarial report for 2001) stated that there were 18 years remaining in the amortization period leaving 13 years for the 2006 actuarial report information Interest rates as follows: 1987 -1996 5.0 %; 1997 -2004 7.5 %; 2005- 6.0% City of Brooklyn Center Administrative Charge Allocation for the 2007 Budget year 2006 2007 2007 Allocation Budget Allocation TOTAL (in funds) TOTAL Mayor /Council 4 0.93% 4 City Manager 38 9.02% 39 Assistant City Manager 45 10.57% 46 Finance Department 195 45.60% 201 Human Resources 8740 2.04% 9 Information Technology 19 4.52% 19 Engineering 83748 19.51% 86 Streets (Maintenance) 33,516 7.81% 34539 429 442 442 instructions were to use same percent allocation from 2006 for 2007 administrative service charges - 2008 was more detailed in the allocation Allocation -non departmental Account General Ledger Number Account Description Balance 99 ps pw pr ed 48150 -6101 WAGES & SALARIES -FT EMPLOYEES 41 41 48150-6111 SEVERANCE PAY 209.57 209.57 48150 -6122 PERA COORDINATED PLAN 2 2 48150 -6125 FICA 2 2 48150 -6126 MEDICARE CONTRIBUTIONS 655.92 655.92 48150 -6131 CAFETERIA PLAN CONTRIBUTIONS 5 5 48150 -6151 WORKER'S COMP INSURANCE 274.81 274.81 48150 -6201 OFFICE SUPPLIES 17 17 48150 -6203 BOOKS /REFERENCE MATERIALS 101.09 101.09 48150 -6219 GENERAL OPERATING SUPPLIES 937.24 937.24 48150 -6242 MINOR EQUIPMENT - - 48150 -6307 PROFESSIONAL SERVICES 3.96 3.96 48150 -6321 TELEPHONE /PAGERS 9 1 1 1 1 1 48150 -6322 POSTAGE 37, 586.37 7 7 7 7 7 48150 -6331 TRAVEL EXPENSE /MILEAGE - - 48150 -6351 PRINTING 11, 031.90 2 2 2 2 48150 -6402 EQUIPMENT SERVICES 14, 757.92 2 2 2 2 2 48150 -6409 OTHER REPAIR & MAINT SVCS - - 48150 -6413 OFFICE EQUIPMENT 6 1 1 1 1 1 48150 -6421 SOFTWARE LICENSE - - - 48150 -6432 CONFERENCES AND SCHOOLS 3 604.00 604.00 604.00 604.00 604.00 48150 -6433 MEETING EXPENSES 786.50 267.41 259.55 259.55 48150 -6434 DUES & SUBSCRIPTIONS 1 242.13 242.13 242.13 242.13 242.13 48150 -6441 LICENSES, TAXES & FEES 35.00 35.00 48150 -6443 PRIZE AWARDS /EXPENSE REIMB - - 48150 -6446 CONTINGENCY ACCOUNT - - 48150 -6449 OTHER CONTRACTUAL SERVICE 19, 733.87 2 247.50 16, 000.00 569.22 - 48140 -6307 PROFESSIONAL SERVICES 10, 900.74 2 2 2 2 2 48140 -6361 GENERAL LIABILITY INSURANC 117 23 23 23 23 23 48140 -6362 PROPERTY INSURANCE 30, 749.94 6 6 6 6 6 48140 -6366 MACHINERY BREAKDOWN I N S U RA 5 1 1 1 1 1 48140 -6368 BONDS I N S U RAN C E 1 370.99 370.99 370.99 370.99 370.99 48140 -6442 COURT AWARDS /SETTLEMENTS 11, 926.55 2 2 2 2 2 354, 847.76 128, 506.47 50, 430.39 69, 200.42 53, 510.09 53, 200.42 City of Brooklyn Center Central Garage Activity December 31, 2007 Adjustment 12/31/2006 12/31/2007 needed Cash 5 4 (705, 538) Accounts receivable 14 7 (6 1 nventories 29 33 3 Land improvements 166 166 0 Departmental equipment 6 7 909 Accumulated depreciation (3 (3 174 Accounts payable (92,474) (73,105) 19 Accrued salaries and wages (6, 033) (5, 909) 124 Invested in capital assets (2 (3 (1 Unrestricted (4, 968, 763) (4 689 0 0 0 Interest (214, 785) Gain on sale of assets (88,508) capital donations 0 capital contributions 0 CIG transfer (57,459) 0 General government (345) Public safety (15,920) Public works (8 Recreation (4 Economic development (85) Water (1 Sanitary sewer (2 Storm Drainage (1 Liquor (123) Golf (632) 0 City of Brooklyn Center Compensated Absences Activity December 31, 2007 Adjustment 12/31/2006 1213112007 needed Cash 964 1 59 Internal balance 131 132 1 Comp ab payable (964 (1 (59 Unrestricted (131 (132 (1 0 0 Interest (46 General government 9,162 20.36% Public safety 23 51.62% Public works 7,595 16.88% Recreation 4 9.31% Economic development 823 1.83% 0 44 allocation in GW- Business Municipal liquor 389 23.79% Golf course 170 10.38% EBHC 487 29.77% Water utility 399 24.42% Sanitary sewer 104 6.37% Storm drainage 86 5.26% 1,635 HENNEPIN COUNTY TAXPAYER SERVICES DEPARTMENT PROPERTY TAX - TAX ACCOUNTING - SETTLEMENTS Direct and Overlapping Debt City of Brooklyn Center As of 12 -31 -2007 Portion of Tax Total Bonded Debt Gross Bonded Capacity in Percentage Amount of Net Debt Outstanding as of Debt Used for Net Less Sinking Fund Tax Capacity Used DISTRICT Used to Applicable to Applicable to 12/31/2007 Debt Calculation , Balance Net Debt to Calculate Rate Calculate Rate DISTRICT DISTRICT City of Brooklyn Center $25,410,000 $3,875,000 $1,163,306 $2,711,694 21,313,894 21,313,894 100.00% $2,711,694 Anoka Henn ISD 011 See Anoka County See Anoka County See Anoka County See Anoka Co See Anoka Co 2,655,182 See Anoka Co See Anoka Co Osseo ISD 279 $243,050,000 $237,815,000 $18,097,467 $219,717,533 150,358,956 7,179,334 4.77% $10,480,526 Robbinsdale ISD 281 $242,110,000 $242,110,000 $13,701,408 $228,408,592 95,760,343 4,870,197 5.09% $11,625,997 Earl Brown ISD 286 $29,855,000 $29,855,000 $252,257 $29,602,743 6,609,181 6,609,181 100.00% $29,602,743 Hennepin County $663,775,000 $468,405,000 $169,496 $468,235,504 1,471,442,337 21,313,894 1.45% $6,789,415 Henn Suburban Park District $89,860,000 $80,795,000 $7,392,895 $73,402,105 1,110,914,277 21,313,894 1.92% $1,409,320 Henn Regional RR Authority $44,900,000 $44,900,000 $322,531 $44,577,469 1,471,442,337 21,313,894 1.45% $646,373 Metropolitan Council $1,079,036,911 $181,150,000 $62,721,494 $118,428,506 3,247,288,594 21,313,894 0.66% $781,628 1 Excludes Revenue and Special Assessment Bonds WORKPAPER ONLY CITY OF BROOKLYN CENTER, MINNESOTA ENTERPRISE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31, 2007 Municipal Golf Earle Brown Water Sanitary Storm Recycling and Street Licht Totals Liquor Course Heritage Center Utility Sewer Drainage Refuse Utility 2007 INCREASE IN CASH AND CASH EQUIVALENTS CASH FLOWS FROM OPERATING ACTIVITIES: Receipts from customers and users 5,473,017 252,620 4,242,027 1,965,546 3,411,210 1,413,605 251,886 233,448 17,243,359 operating revenue 5,474,634 252,620 4,325,296 2,039,679 3,272,528 1,412,548 245,256 232,850 dec (inc) accounts receivable -1,578 0 - 83,269 - 80,274 44,871 1,057 6,630 598 dec (inc) dfog 0 0 0 0 93,811 0 0 0 inc (dec) deferred revenue -39 0 0 6,141 0 Deposits - - (22,570) 650 - - - - (21,920) Payments to suppliers (4,637,244) (148,086) (3,129,685) (703,222) (2,846,679) (302,502) (257,615) (163,835) (12,188,868) cost of sales - 4,125,816 0 - 2,162,075 operating expenses: other services - 157,556 - 76,455 - 534,008 - 385,303 - 2,179,409 - 291,957 - 255,290 - 22,509 supplies - 24,279 - 44,718 - 142,428 - 156,404 - 16,262 -9,627 -220 -822 insurance - 11,527 -6,600 - 48,179 - 12,589 -5,329 -2,780 -1,790 -1,291 utilities - 36,669 - 19,969 - 220,430 - 151,237 - 35,572 0 0 - 167,037 rent - 245,407 0 0 0 0 0 0 0 dec (inc) other assets -556 0 831 0 -4,922 0 0 0 inc (dec) inventories 2,762 -803 -3,719 2,579 0 0 0 0 inc (dec) accounts payable - 38,196 459 - 12,786 -268 - 605,185 1,862 -315 27,824 inc (dec) contracts payable 0 0 -6,891 0 0 0 0 0 Payments to employees (527,273) (139,027) (909,140) (423,676) (170,587) (85,590) - - (2,255,293) salaries and benefits - 529,966 - 139,344 - 909,332 - 425,869 - 169,781 - 85,786 0 0 inc (dec) accrued liabilities 2,693 317 192 2,193 -806 196 0 0 Miscellaneous revenue 13,275 118 4,812 5,556 1,984 - - 1,380 27,125 misc revenue 13,275 118 4,812 5,556 1,984 0 0 1,380 Net cash provided (used) by operating activities 321,775 (34,375) 185,444 844,854 395,928 1,025,513 (5,729) 70,993 2,804,403 CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: Principal repayments on advance Increase (decrease) in advances from other funds - - - - - - - - - 2006 0 792,488 2007 0 792,488 Transfers (125,000) - (230,000) 461,723 (26,810) 79,913 Special assessments received - - - (89,582) 426 - - - (89,156) special assessments revenue 0 0 18,695 166 0 dec (inc) spec assess receivable 0 0 0 - 108,277 260 0 0 0 2006 0 350,856 2,343 231 2007 0 0 459,133 2,083 231 Interfund receivable - - - - - - - - - dec (inc) interfund rec 0 0 Interfund payable - - - - - - inc (dec) interfund payable 0 0 Net cash provided (used ) by noncapital financing activities (125,000) - (230,000) (89,582) 462,149 - - (26,810) (9,243) WORKPAPER ONLY CITY OF BROOKLYN CENTER, MINNESOTA ENTERPRISE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31, 2007 Municipal Golf Earle Brown Water Sanitary Storm Recycling and Street Licht Totals Liquor Course Heritage Center Utility Sewer Drainage Refuse Utility 2007 CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES: Acquisition and construction of capital assets - - - (576,661) (436,649) (1,090,487) - - (2,103,797) 2006 fixed assets 303,938 1,929,766 13,055,793 19,131,126 17,208,643 18,587,839 2007 fixed assets 303,938 1,929,766 13,055,793 19,707,787 17,645,292 19,871,483 2007 contributions from developers /govs /funds 0 0 193,157 Transfers of assets (in) out 0 0 0 2007 disposals 0 0 0 Principal paid on revenue bonds - - - - - - - - - Interest and fiscal charges paid on bonds - - - - - - - - - interest per statement 8 +2006 accrual 0 -2007 accrual -2007 amort of bond discount Net cash used by capital and related financing activities - - - (576,661) (436,649) (1,090,487) - - (2,103,797) CASH FLOWS FROM INVESTING ACTIVITIES - Interest and dividends on investments 53,219 3,445 54,331 78,668 115,955 92,298 1,069 7,669 406,654 Net increase (decrease) in cash and cash equivalents 249,994 (30,930) 9,775 257 537,383 27,324 (4,660) 51,852 1,098,017 CASH AND CASH EQUIVALENTS AT BEGINNING OF YEAR 949,471 81,900 1,141,255 1,811,509 1,926,733 1,353,496 5,428 102,239 7,372,031 CASH AND CASH EQUIVALENTS AT END OF YEAR 1,199,465 50,970 1,151,030 2,068,788 2,464,116 1,380,820 768 154,091 8,470,048 Per Statements 6/26 1,199,465 50,970 1,151,030 2,068,788 2,464,116 1,380,820 768 154,091 8,470,048 Difference - - - - - - - - - WORKPAPER ONLY CITY OF BROOKLYN CENTER, MINNESOTA ENTERPRISE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31, 2007 Municipal Golf Earle Brown Water Sanitary Storm Recycling and Street Licht Totals Liquor Course Heritage Center Utility Sewer Drainage Refuse Utility 2007 RECONCILIATION OF OPERATING INCOME (LOSS) TO NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES Operating income (loss) 317,055 (61,636) (268,691) 321,815 340,520 287,873 (12,044) 41,191 966,083 ADJUSTMENTS TO RECONCILE OPERATING INCOME (LOSS) TO NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES Depreciation 26,359 27,170 577,535 586,462 525,655 734,525 - - 2,477,706 Change in assets and liabilities: Decrease (increase) in accounts receivable (1,578) - (83,269) (80,274) 44,871 1,057 6,630 598 (111,965) 2006 7,780 0 223,561 380,020 816,289 333,141 60,849 55,662 2007 9,358 0 306,830 460,294 771,418 332,084 54,219 55,064 Decrease (increase) in dfog - - - - 93,811 - - - 93,811 2006 0 0 0 0 93,811 0 0 0 2007 0 0 0 0 0 0 0 0 Decrease (increase) in inventories 2,762 (803) (3,719) 2,579 - - - - 819 2006 511,212 1,784 27,101 18,649 0 0 0 0 2007 508,450 2,587 30,820 16,070 0 0 0 0 Decrease (increase) in prepaid items (556) - 831 - (4,922) - - - (4,647) 2006 21,432 0 5,499 500 149,850 0 0 0 2007 21,988 0 4,668 500 154,772 0 0 0 Increase (decrease) in accounts payable (38,196) 459 (12,786) (268) (605,185) 1,862 (315) 27,824 (626,605) 2006 170,692 724 68,370 44,993 614,042 1,607 764 1,679 2007 132,496 1,183 55,584 44,725 8,857 3,469 449 29,503 Increase (decrease) in salaries payable 2,693 317 192 2,193 (806) 196 - - 4,785 2006 9,778 1,170 16,745 7,399 3,738 1,353 0 0 2007 12,471 1,487 16,937 9,592 2,932 1,549 0 0 Increase (decrease) in deposits payable - - ( 22,570) 650 - - - - (21,920) 2006 0 0 242,810 50 0 0 0 0 2007 0 0 220,240 700 0 0 0 0 Increase (decrease) in contracts payable - - ( 6,891) - - - - - (6,891) 2006 0 0 180,247 0 0 0 0 0 2007 0 0 173,356 0 0 0 0 0 Increase (decrease) in deferred revenue (39) - - 6,141 - - - - 6,102 2006 485 0 1,600 122,819 0 0 0 0 2007 446 0 1,600 128,960 0 0 0 0 Miscellaneous revenue 13,275 118 4,812 5,556 1,984 0 0 1,380 27,125 Total adjustments 4,720 27 454,135 523,039 55,408 737,640 6,315 29 1,838,320 Net cash provided (used) by operating activities 321,775 (34,375) 185,444 844,854 395,928 1,025,513 (5,729) 70,993 2,804,403 Operating activities cash balances - - - - - - - - - NONCASH INVESTING, CAPITAL, AND FINANCING ACTIVITIES Capital contributions - - - - - 193,157 - - 193,157 WORKPAPER N LY CITY OF ROOKLYN CENTER, MINNESOTA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31, 2007 Central EE Retirement EE Comp Garage Benefit Absences 2007 INCREASE IN CASH AND CASH EQUIVALENTS CASH FLOWS FROM OPERATING ACTIVITIES: Cash received from customers 1,459 - 100 1 operating revenue 1,453,167 - 100,468 dec (inc) in accounts receivable 6,621 - - Cash paid to supplier for goods and services (620,433) - - (620,433) supplies (148,053) - other services (392,966) - - insurance (55,102) - - utilities (1,870) - - inc (dec) in inventories (3,073) - - inc (dec) in accounts payable (19,369) - - Cash paid to employees for services (301,606) (87,019) (87,442) (476,067) personal services (301,482) (50,754) (146,900) inc (dec) accrued liabilities (124) - - dec (inc) in accounts receivable - (311) - inc (dec) in comp abs - - 59 inc (dec) in healy ins liab - (35,954) - Miscellaneous revenue 10 9 - 20 misc revenue 10,384 9 - Net cash provided (used) by operating activities 548 (77 13 483 CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: Transfers in 57,459 - - 57,459 Subsidy from County - - - - Net cash provided (used ) by noncapital financing activities 57 - - 579459 WORKPAPER N LY CITY OF ROOKLYN CENTER, MINNESOTA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31, 2007 Central EE Retirement EE Comp Garage Benefit Absences 2007 CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES: Acquisition and construction of capital assets (1,619,325) - - (1,619,325) 2006 fixed assets 6 2007 fixed assets 7 0 0 2007 contributions from developers /govs /funds 0 0 0 Transfers of assets (in) out 0 0 0 2007 disposals - 709 0 0 Proceeds from sale of capital assets 93,410 - - 93 Net cash used by capital and related financing activities (1 - - (1 CASH FLOWS FROM INVESTING ACTIVITIES: Interest and dividends on investments 214 71 46 332 Net increase (decrease) in cash and cash equivalents (705 (5 59 (652 CASH AND CASH EQUIVALENTS AT BEGINNING OF YEAR 5,022,951 1,501 964,248 7 CASH AND CASH EQUIVALENTS AT END OF YEAR 4 1 1 6 Per Statement 29 4,317,413 1,495,177 1,023,706 6,836 Difference - - - - WORKPAPER N LY CITY OF ROOKLYN CENTER, MINNESOTA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31, 2007 Central EE Retirement EE Comp Garage Benefit Absences 2007 RECONCILIATION OF OPERATING INCOME (LOSS) TO NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES Operating income (loss) 23 (50 (46 (73,385) ADJUSTMENTS TO RECONCILE OPERATING INCOME (LOSS) TO NET CASH PROVIDED (USED) BY OPERATING A CTI VI TIES Depreciation 529,893 - - 529 Change in assets and liabilities: Decrease (increase) in accounts receivable 6,621 (311) - 6 2006 14 423 0 2007 7, 727 734 0 Decrease (increase) in inventories (3,073) - - (3,073) 2006 29 0 0 2007 33,044 0 0 Increase (decrease) in accounts payable (19,369) - - (19,369) 2006 92,474 0 0 2007 73 0 0 Increase (decrease) in salaries payable (124) - - (124) 2006 6, 033 0 0 2007 5 0 0 Increase (decrease) in comp abs - - 59 59,458 2006 0 0 964 2007 0 0 1, 023, 706 Increase (decrease) in health ins liab - (35,954) - (35,954) 2006 0 2 0 2007 0 2 0 Miscellaneous revenue 10,384 9,842 0 20,226 Total adjustments 524 (26 59 557 Net cash provided (used) by operating activities 548 (77 13,026 483 Operating activities cash balances - - - - R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:29:29 AP Paid Voucher Detail Voucher only By Vendor Name Page - 1 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total 107198 LOGIS 3/29/2007PK 132048 1/31/2007 PV 66051 1,948.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 6,923.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 481.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 6,011.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 1,956.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 94.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 1,568.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 448.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 1,568.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 896.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 407.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 272.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 178.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 878.00 27840 JAN OPERATIONS 10536 3/29/2007PK 132048 1/31/2007 PV 66051 1,001.00 27840 JAN OPERATIONS 10536 24,629.00 3/29/2007PK 132048 1/31/2007 PV 66052 1,916.00 27840A SYSTEM DEVELOPMENT 10536 3/29/2007PK 132048 1/31/2007 PV 66052 6,788.00 27840A SYSTEM DEVELOPMENT 10536 3/29/2007PK 132048 1/31/2007 PV 66052 5,303.00 27840A SYSTEM DEVELOPMENT 10536 3/29/2007PK 132048 1/31/2007 PV 66052 1,476.00 27840A SYSTEM DEVELOPMENT 10536 3/29/2007PK 132048 1/31/2007 PV 66052 136.00 27840A SYSTEM DEVELOPMENT 10536 3/29/2007PK 132048 1/31/2007 PV 66052 2,239.00 27840A SYSTEM DEVELOPMENT 10536 3/29/2007PK 132048 1/31/2007 PV 66052 640.00 27840A SYSTEM DEVELOPMENT 10536 3/29/2007PK 132048 1/31/2007 PV 66052 2,239.00 27840A SYSTEM DEVELOPMENT 10536 3/29/2007PK 132048 1/31/2007 PV 66052 1,280.00 27840A SYSTEM DEVELOPMENT 10536 3/29/2007PK 132048 1/31/2007 PV 66052 689.00 27840A SYSTEM DEVELOPMENT 10536 3/29/2007PK 132048 1/31/2007 PV 66052 460.00 27840A SYSTEM DEVELOPMENT 10536 3/29/2007PK 132048 1/31/2007 PV 66052 230.00 27840A SYSTEM DEVELOPMENT 10536 3/29/2007PK 132048 1/31/2007 PV 66052 1,318.00 27840A SYSTEM DEVELOPMENT 10536 3/29/2007PK 132048 1/31/2007 PV 66052 4,454.00 27840A SYSTEM DEVELOPMENT 10536 29,168.00 3/29/2007PK 132048 1/31/2007 PV 66053 1,920.00 27840B NETWORK WELLNESS 10536 1,920.00 3/29/2007PK 132048 1/31/2007 PV 66054 480.00 27840C NETWORK WELLNESS 10536 480.00 3/29/2007PK 132048 1/31/2007 PV 66055 1,632.00 27840D NETWORK SERVICES 10536 1,632.00 3/29/2007PK 132048 1/31/2007 PV 66056 1,734.30 27840E VERISIGN CERT OF EXCHANGE SERV 10536 R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:29:29 AP Paid Voucher Detail Voucher only By Vendor Name Page - 2 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total Continued... 107198 LOGIS 1,734.30 3/29/2007PK 132048 2/28/2007 PV 66057 1,948.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 6,923.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 481.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 6,011.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 1,956.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 94.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 1,568.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 448.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 1,568.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 896.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 407.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 272.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 178.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 878.00 27961 FEB OPERATIONS 10536 3/29/2007PK 132048 2/28/2007 PV 66057 1,001.00 27961 FEB OPERATIONS 10536 24,629.00 3/29/2007PK 132048 2/28/2007 PV 66058 1,680.00 27961A NETWORK SERVICES 10536 1,680.00 3/29/2007PK 132048 2/28/2007 PV 66059 2,750.00 27961B VALUE NOTICES 2007 10536 2,750.00 3/29/2007PK 132048 2/28/2007 PV 66060 2,486.76 27961C WEBSENSE & PEST PATROL LICENSE 10536 2,486.76 3/29/2007PK 132048 2/28/2007 PV 66061 280.84 27961D WEBSENSE & PEST PATROL LICENSE 10536 280.84 3/29/2007PK 132048 2/28/2007 PV 66062 140.42 27961E WEBSENSE & PEST PATROL LICENSE 10536 140.42 3/29/2007PK 132048 2/28/2007 PV 66063 100.30 27961F WEBSENSE & PEST PATROL LICENSE 10536 100.30 3/29/2007PK 132048 2/28/2007 PV 66064 40.12 27961G WEBSENSE & PEST PATROL LICENSE 10536 40.12 4/26/2007PK 132525 3/31/2007 PV 67039 1,948.00 28065 MARCH OPERATIONS 10728 4/26/2007PK 132525 3/31/2007 PV 67039 6,923.00 28065 MARCH OPERATIONS 10728 4/26/2007PK 132525 3/31/2007 PV 67039 481.00 28065 MARCH OPERATIONS 10728 4/26/2007PK 132525 3/31/2007 PV 67039 6,011.00 28065 MARCH OPERATIONS 10728 4/26/2007PK 132525 3/31/2007 PV 67039 1,956.00 28065 MARCH OPERATIONS 10728 4/26/2007PK 132525 3/31/2007 PV 67039 94.00 28065 MARCH OPERATIONS 10728 4/26/2007PK 132525 3/31/2007 PV 67039 1,568.00 28065 MARCH OPERATIONS 10728 4/26/2007PK 132525 3/31/2007 PV 67039 448.00 28065 MARCH OPERATIONS 10728 R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:29:29 AP Paid Voucher Detail Voucher only By Vendor Name Page - 3 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total Continued... 107198 LOGIS 4/26/2007PK 132525 3/31/2007 PV 67039 1,568.00 28065 MARCH OPERATIONS 10728 4/26/2007PK 132525 3/31/2007 PV 67039 896.00 28065 MARCH OPERATIONS 10728 4/26/2007PK 132525 3/31/2007 PV 67039 407.00 28065 MARCH OPERATIONS 10728 4/26/2007PK 132525 3/31/2007 PV 67039 272.00 28065 MARCH OPERATIONS 10728 4/26/2007PK 132525 3/31/2007 PV 67039 178.00 28065 MARCH OPERATIONS 10728 4/26/2007PK 132525 3/31/2007 PV 67039 878.00 28065 MARCH OPERATIONS 10728 4/26/2007PK 132525 3/31/2007 PV 67039 1,001.00 28065 MARCH OPERATIONS 10728 24,629.00 4/26/2007PK 132525 3/31/2007 PV 67040 720.00 28139 NETWORK SERVICES 10728 4/26/2007PK 132525 3/31/2007 PV 67040 144.00 28139 NETWORK SERVICES 10728 864.00 6/7/2007 PK 133280 4/30/2007 PV 68625 1,948.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 6,923.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 481.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 6,011.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 1,956.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 94.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 1,568.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 448.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 1,568.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 896.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 407.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 272.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 178.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 878.00 28164 APRIL OPERATIONS 10981 6/7/2007 PK 133280 4/30/2007 PV 68625 1,001.00 28164 APRIL OPERATIONS 10981 24,629.00 6/7/2007 PK 133280 4/30/2007 PV 68626 240.00 28206 NETWORK SERVICES 10981 240.00 6/7/2007 PK 133280 4/30/2007 PV 68627 96.00 28206A CLASS E- CONNECT 10981 96.00 6/7/2007 PK 133280 4/30/2007 PV 68628 757.86 28229 VALUE NOTICES 2007 10981 757.86 6/7/2007 PK 133280 4/30/2007 PV 68629 1,199.25 28229A CJIS FOR MCD'S JAN -MAR 10981 1,199.25 7/12/2007PK 133970 5/31/2007 PV 70027 1,948.00 28254 MAY OPERATIONS 11196 7/12/2007PK 133970 5/31/2007 PV 70027 6,923.00 28254 MAY OPERATIONS 11196 7/12/2007PK 133970 5/31/2007 PV 70027 481.00 28254 MAY OPERATIONS 11196 7/12/2007PK 133970 5/31/2007 PV 70027 6,011.00 28254 MAY OPERATIONS 11196 R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:29:29 AP Paid Voucher Detail Voucher only By Vendor Name Page - 4 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total Continued... 107198 LOGIS 7/12/2007PK 133970 5/31/2007 PV 70027 1,956.00 28254 MAY OPERATIONS 11196 7/12/2007PK 133970 5/31/2007 PV 70027 94.00 28254 MAY OPERATIONS 11196 7/12/2007PK 133970 5/31/2007 PV 70027 1,568.00 28254 MAY OPERATIONS 11196 7/12/2007PK 133970 5/31/2007 PV 70027 448.00 28254 MAY OPERATIONS 11196 7/12/2007PK 133970 5/31/2007 PV 70027 1,568.00 28254 MAY OPERATIONS 11196 7/12/2007PK 133970 5/31/2007 PV 70027 896.00 28254 MAY OPERATIONS 11196 7/12/2007PK 133970 5/31/2007 PV 70027 407.00 28254 MAY OPERATIONS 11196 7/12/2007PK 133970 5/31/2007 PV 70027 272.00 28254 MAY OPERATIONS 11196 7/12/2007PK 133970 5/31/2007 PV 70027 178.00 28254 MAY OPERATIONS 11196 7/12/2007PK 133970 5/31/2007 PV 70027 878.00 28254 MAY OPERATIONS 11196 7/12/2007PK 133970 5/31/2007 PV 70027 1,001.00 28254 MAY OPERATIONS 11196 24,629.00 7/12/2007PK 133970 5/31/2007 PV 70096 500.00 28355 CLASS FINANCELINK /JDE INTERFAC 11196 500.00 7/12/2007PK 133970 5/31/2007 PV 70097 1,067.64 28324 CISCO NETWORK EQUIP MAINT 11196 1,067.64 7/12/2007PK 133970 5/31/2007 PV 70098 260.76 28324A CISCO NETWORK EQUIP MAINT 11196 260.76 7/12/2007PK 133970 5/31/2007 PV 70099 42.17 28324B CASS CERT FOR UTIL BILLING 11196 42.17 7/12/2007PK 133970 5/31/2007 PV 70100 1,296.00 28295 NETWORK SERVICES 11196 1,296.00 7/12/2007PK 133970 5/31/2007 PV 70101 384.00 28295A NETWORK SERVICES 11196 384.00 7/12/2007PK 133970 5/31/2007 PV 70102 864.00 28295B CLASS E- CONNECT 11196 864.00 7/26/2007PK 134264 6/30/2007 PV 70589 1,948.00 28363 JUNE OPERATIONS 11273 7/26/2007PK 134264 6/30/2007 PV 70589 6,923.00 28363 JUNE OPERATIONS 11273 7/26/2007PK 134264 6/30/2007 PV 70589 481.00 28363 JUNE OPERATIONS 11273 7/26/2007PK 134264 6/30/2007 PV 70589 6,011.00 28363 JUNE OPERATIONS 11273 7/26/2007PK 134264 6/30/2007 PV 70589 1,956.00 28363 JUNE OPERATIONS 11273 7/26/2007PK 134264 6/30/2007 PV 70589 94.00 28363 JUNE OPERATIONS 11273 7/26/2007PK 134264 6/30/2007 PV 70589 1,568.00 28363 JUNE OPERATIONS 11273 7/26/2007PK 134264 6/30/2007 PV 70589 448.00 28363 JUNE OPERATIONS 11273 7/26/2007PK 134264 6/30/2007 PV 70589 1,568.00 28363 JUNE OPERATIONS 11273 7/26/2007PK 134264 6/30/2007 PV 70589 896.00 28363 JUNE OPERATIONS 11273 7/26/2007PK 134264 6/30/2007 PV 70589 407.00 28363 JUNE OPERATIONS 11273 7/26/2007PK 134264 6/30/2007 PV 70589 272.00 28363 JUNE OPERATIONS 11273 7/26/2007PK 134264 6/30/2007 PV 70589 178.00 28363 JUNE OPERATIONS 11273 R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:29:29 AP Paid Voucher Detail Voucher only By Vendor Name Page - 5 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total Continued... 107198 LOGIS 7/26/2007PK 134264 6/30/2007 PV 70589 878.00 28363 JUNE OPERATIONS 11273 7/26/2007PK 134264 6/30/2007 PV 70589 1,001.00 28363 JUNE OPERATIONS 11273 24,629.00 7/26/2007PK 134264 6/30/2007 PV 70590 2,571.38 28404 SYMANTEC ANTIVIRUS LIC MAINT 11273 7/26/2007PK 134264 6/30/2007 PV 70590 84.40 28404 SYMANTEC ANTIVIRUS LIC MAINT 11273 7/26/2007PK 134264 6/30/2007 PV 70590 295.40 28404 SYMANTEC ANTIVIRUS LIC MAINT 11273 7/26/2007PK 134264 6/30/2007 PV 70590 147.70 28404 SYMANTEC ANTIVIRUS LIC MAINT 11273 7/26/2007PK 134264 6/30/2007 PV 70590 105.50 28404 SYMANTEC ANTIVIRUS LIC MAINT 11273 7/26/2007PK 134264 6/30/2007 PV 70590 42.20 28404 SYMANTEC ANTIVIRUS LIC MAINT 11273 3,246.58 7/26/2007PK 134264 6/30/2007 PV 70591 1,968.00 28437 NETWORK SERVICES 11273 7/26/2007PK 134264 6/30/2007 PV 70591 48.00 28437 NETWORK SERVICES 11273 2,016.00 8/30/2007PK 134904 7/31 /2007 PV 72015 1,948.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 7,048.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 481.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 6,011.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 1,956.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 95.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 1,570.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 449.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 1,570.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 897.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 413.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 276.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 185.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 894.00 28464 JULY OPERATIONS 11450 8/30/2007PK 134904 7/31 /2007 PV 72015 1,003.00 28464 JULY OPERATIONS 11450 24,796.00 8/30/2007PK 134904 7/31 /2007 PV 72016 1,199.25 28506 CJIS MCD'S APR -JUN 11450 1,199.25 8/30/2007PK 134904 7/31/2007 PV 72017 2,754.00 28529 NETWORK SERVICES 11450 8/30/2007PK 134904 7/31/2007 PV 72017 288.00 28529 NETWORK SERVICES 11450 3,042.00 8/30/2007PK 134904 6/30/2007 PV 72018 125.00 28363 JUNE OPERATIONS 11450 8/30/2007PK 134904 6/30/2007 PV 72018 1.00 28363 JUNE OPERATIONS 11450 8/30/2007PK 134904 6/30/2007 PV 72018 2.00 28363 JUNE OPERATIONS 11450 8/30/2007PK 134904 6/30/2007 PV 72018 1.00 28363 JUNE OPERATIONS 11450 8/30/2007PK 134904 6/30/2007 PV 72018 2.00 28363 JUNE OPERATIONS 11450 R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:29:29 AP Paid Voucher Detail Voucher only By Vendor Name Page - 6 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total Continued... 107198 LOGIS 8/30/2007PK 134904 6/30/2007 PV 72018 1.00 28363 JUNE OPERATIONS 11450 8/30/2007PK 134904 6/30/2007 PV 72018 6.00 28363 JUNE OPERATIONS 11450 8/30/2007PK 134904 6/30/2007 PV 72018 4.00 28363 JUNE OPERATIONS 11450 8/30/2007PK 134904 6/30/2007 PV 72018 7.00 28363 JUNE OPERATIONS 11450 8/30/2007PK 134904 6/30/2007 PV 72018 16.00 28363 JUNE OPERATIONS 11450 8/30/2007PK 134904 6/30/2007 PV 72018 2.00 28363 JUNE OPERATIONS 11450 167.00 9/27/2007PK 135437 8/31/2007 PV 73039 1,948.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 7,048.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 481.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 6,011.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 1,956.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 95.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 1,570.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 449.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 1,570.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 897.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 413.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 276.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 185.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 894.00 28560 AUG OPERATIONS 11585 9/27/2007PK 135437 8/31/2007 PV 73039 1,003.00 28560 AUG OPERATIONS 11585 24,796.00 9/27/2007PK 135437 8/31/2007 PV 73040 2,494.28 28599 METER READ CARDS 11585 2,494.28 9/27/2007PK 135437 8/31/2007 PV 73041 552.00 28617 NETWORK SERVICES 11585 9/27/2007PK 135437 8/31/2007 PV 73041 480.00 28617 NETWORK SERVICES 11585 1,032.00 9/27/2007PK 135437 8/31/2007 PV 73042 926.55 28643 ENTRUST UCC CERT FOR BC -EX 11585 926.55 9/27/2007PK 135437 8/31/2007 PV 73043 141.65 28643A NETMOTION LICENSE FOR POLICE 11585 141.65 11 /8/2007PK 136211 9/30/2007 PV 74631 1,948.00 28653 SEPT OPERATIONS 11789 11 /8/2007PK 136211 9/30/2007 PV 74631 7,048.00 28653 SEPT OPERATIONS 11789 11 /8/2007PK 136211 9/30/2007 PV 74631 481.00 28653 SEPT OPERATIONS 11789 11 /8/2007PK 136211 9/30/2007 PV 74631 6,011.00 28653 SEPT OPERATIONS 11789 11 /8/2007PK 136211 9/30/2007 PV 74631 1,956.00 28653 SEPT OPERATIONS 11789 11 /8/2007PK 136211 9/30/2007 PV 74631 95.00 28653 SEPT OPERATIONS 11789 11 /8/2007PK 136211 9/30/2007 PV 74631 1,570.00 28653 SEPT OPERATIONS 11789 R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:29:29 AP Paid Voucher Detail Voucher only By Vendor Name Page - 7 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total Continued... 107198 LOGIS 11 /8/2007PK 136211 9/30/2007 PV 74631 449.00 28653 SEPT OPERATIONS 11789 11 /8/2007PK 136211 9/30/2007 PV 74631 1,570.00 28653 SEPT OPERATIONS 11789 11 /8/2007PK 136211 9/30/2007 PV 74631 897.00 28653 SEPT OPERATIONS 11789 11 /8/2007PK 136211 9/30/2007 PV 74631 413.00 28653 SEPT OPERATIONS 11789 11 /8/2007PK 136211 9/30/2007 PV 74631 276.00 28653 SEPT OPERATIONS 11789 11 /8/2007PK 136211 9/30/2007 PV 74631 185.00 28653 SEPT OPERATIONS 11789 11 /8/2007PK 136211 9/30/2007 PV 74631 894.00 28653 SEPT OPERATIONS 11789 11 /8/2007PK 136211 9/30/2007 PV 74631 1,003.00 28653 SEPT OPERATIONS 11789 24,796.00 11/8/2007PK 136211 9/30/2007 PV 74632 598.56 28695 NETMOTION MAINT 11789 598.56 11 /29/200F?K 136524 10/31/2007 PV 75201 1,948.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 7,048.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 481.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 6,011.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 1,956.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 95.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 1,570.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 449.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 1,570.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 897.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 413.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 276.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 185.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 894.00 28720 OCTOBER OPERATIONS 11866 11 /29/200F?K 136524 10/31/2007 PV 75201 1,003.00 28720 OCTOBER OPERATIONS 11866 24,796.00 11 /29/200F?K 136524 10/31/2007 PV 75202 996.00 28791 CISCO NETWORK EQUIP MANT 11866 996.00 11 /29/200F?K 136524 10/31/2007 PV 75203 427.26 28791A UTILITY BILLING CONSULTING 11866 11 /29/200F?K 136524 10/31/2007 PV 75203 122.08 28791A UTILITY BILLING CONSULTING 11866 11 /29/200F?K 136524 10/31/2007 PV 75203 427.26 28791A UTILITY BILLING CONSULTING 11866 11 /29/200F?K 136524 10/31/2007 PV 75203 244.15 28791A UTILITY BILLING CONSULTING 11866 1,220.75 11 /29/200F?K 136524 10/31/2007 PV 75204 1,199.25 28791B CJIS FOR MCD'S JULY -SEPT 11866 1,199.25 11 /29/200F?K 136524 10/31/2007 PV 75205 1,158.00 28761 NETWORK SERVICES 11866 1,158.00 11 /29/200F?K 136524 10/31/2007 PV 75254 384.00 28761A NETWORK SERV - ASST WEBSITE 11866 R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:29:29 AP Paid Voucher Detail Voucher only By Vendor Name Page - 8 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total Continued... 107198 LOGIS 384.00 12/20/200F?K 136886 11 /30/2007 PV 76008 1,948.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 7,048.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 481.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 6,011.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 1,956.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 95.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 1,570.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 449.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 1,570.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 897.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 413.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 276.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 185.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 894.00 28820 NOV OPERATIONS 11986 12/20/200F?K 136886 11 /30/2007 PV 76008 1,003.00 28820 NOV OPERATIONS 11986 24,796.00 12/20/200F?K 136886 11/30/2007 PV 76009 215.25 28861 UTILITY BILLING CONSULTING 11986 12/20/200F?K 136886 11/30/2007 PV 76009 61.50 28861 UTILITY BILLING CONSULTING 11986 12/20/200F?K 136886 11/30/2007 PV 76009 215.25 28861 UTILITY BILLING CONSULTING 11986 12/20/200F?K 136886 11/30/2007 PV 76009 123.00 28861 UTILITY BILLING CONSULTING 11986 615.00 12/20/200F?K 136886 11/30/2007 PV 76010 552.00 28875 NETWORK SERVICES 11986 552.00 1/17/2008PK 137322 12/31/2007 PV 76763 1,948.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 7,048.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 481.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 6,011.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 1,956.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 95.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 1,570.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 449.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 1,570.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 897.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 413.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 276.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 185.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 894.00 28906 DEC OPERATIONS 12124 1/17/2008PK 137322 12/31/2007 PV 76763 1,003.00 28906 DEC OPERATIONS 12124 R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:29:29 AP Paid Voucher Detail Voucher only By Vendor Name Page - 9 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total Continued... 107198 LOGIS 24,796.00 1 /31 /2008PK 137574 12/31/2007 PV 77230 672.00 28969 NETWORK SERVICES 12169 672.00 107198 LOGIS 368,195.29 Report Total 368,195.29 OPEB ARC Actual Interest on ARC Amort Amort Pension change in NPO UAAL normal UAAL Amort admin Contr NPO Adjust Period Factor Cost NPO Balance 2008 3 176,464 124 13,529 314 162 - - 30 16.2889 314 151,918 151,918 2009 4 176,464 124 13,529 314 170,726 6 9 29 16.0219 311,538 140,812 292 2010 - 13,173 18,594 28 15.7429 (5 (5 287,309 2011 - 12,929 18,594 27 15.4513 (5 (5 281,644 2012 - 12,674 18,595 26 15.1466 (5 (5 275,723 2013 - 12 18,594 25 14.8282 (6 (6 269,537 2014 - 12 18,595 24 14.4955 (6 (6 263,071 2015 - 11,838 18,595 23 14.1478 (6 (6 256,314 2016 - 11,534 18,594 22 13.7844 (7 (7 249,254 2017 - 11 18,594 21 13.4047 (7 (7 241,876 2018 - 10,884 18,594 20 13.0079 (7 (7 234,166 2019 - 10,537 18,595 19 12.5933 (8 (8 226,108 2020 - 10,175 18,594 18 12.1600 (8 (8 217,689 2021 - 9 18,594 17 11.7072 (8 (8 208,891 2022 - 9 18,595 16 11.2340 (9 (9 199,696 2023 - 8 18,594 15 10.7395 (9 (9 190,088 2024 - 8 18,594 14 10.2228 (10,040) (10,040) 180,048 2025 - 8 18,595 13 9.6829 (10,493) (10,493) 169,555 2026 - 7 18,594 12 9.1186 (10,964) (10,964) 158,591 2027 - 7 18,595 11 8.5289 (11,458) (11,458) 147,133 2028 - 6 18,594 10 7.9127 (11,973) (11,973) 135,160 2029 - 6 18,595 9 7.2688 (12,513) (12,513) 122,647 2030 - 5 18,594 8 6.5959 (13,075) (13,075) 109,572 2031 - 4 18,595 7 5.8927 (13,664) (13,664) 95,908 2032 - 4 18,594 6 5.1579 (14,278) (14,278) 81,630 2033 - 3 18,595 5 4.3900 (14,922) (14,922) 66,708 2034 - 3 18,594 4 3.5875 (15,592) (15,592) 51 2035 - 2 18,595 3 2.7490 (16,295) (16,295) 34,821 2036 - 1 18,594 2 1.8727 (17,027) (17,027) 17 2037 - 801 18,595 1 0.9569 (17,794) (17,794) - R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:42:24 AP Paid Voucher Detail Voucher only By Vendor Name Page - 1 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total 106811 DELTA DENTAL 1/18/2007PK 130787 1/12/2007 PV 63624 6,069.40 011207 JAN INS PREM 10096 1 /18/2007PK 130787 1/12/2007 PV 63624 376.50 011207 JAN INS PREM 10096 6,445.90 2/8/2007 PK 131168 2/1/2007 PV 64294 6,069.40 020107 FEB INS PREM 10212 2/8/2007 PK 131168 2/1/2007 PV 64294 376.50 020107 FEB INS PREM 10212 6,445.90 3/1/2007 PK 131531 2/28/2007 PV 65076 5,602.15 022807 MARCH INS PREM 10349 3/1/2007 PK 131531 2/28/2007 PV 65076 376.50 022807 MARCH INS PREM 10349 5,978.65 3/29/2007PK 132009 3/26/2007 PV 65997 5,901.50 032607 APRIL INS PREM 10536 3/29/2007PK 132009 3/26/2007 PV 65997 376.50 032607 APRIL INS PREM 10536 6,278.00 5/3/2007 PK 132623 4/26/2007 PV 67327 5,901.50 042607 MAY INS PREM 10759 5/3/2007 PK 132623 4/26/2007 PV 67327 376.50 042607 MAY INS PREM 10759 6,278.00 5/24/2007PK 133006 5/23/2007 PV 68193 5,759.70 052307 MAY INS PREM 10873 5/24/2007PK 133006 5/23/2007 PV 68193 376.50 052307 MAY INS PREM 10873 6,136.20 7/12/2007PK 133943 7/5/2007 PV 69972 5,897.60 070507 JULY INS PREM 11196 7/12/2007PK 133943 7/5/2007 PV 69972 376.50 070507 JULY INS PREM 11196 6,274.10 8/9/2007 PK 134475 8/1/2007 PV 71136 5,864.10 080107 AUG INS PREM 11350 8/9/2007 PK 134475 8/1/2007 PV 71136 376.50 080107 AUG INS PREM 11350 6,240.60 9/13/2007PK 135137 9/11/2007 PV 72563 5,722.30 091107 SEPT INS PREM 11520 9/13/2007PK 135137 9/11/2007 PV 72563 343.00 091107 SEPT INS PREM 11520 6,065.30 10/4/2007PK 135532 10/1 /2007 PV 73269 5,990.70 100107 OCT INS PREM 11616 10/4/2007PK 135532 10/1 /2007 PV 73269 380.40 100107 OCT INS PREM 11616 6,371.10 11 /8/2007PK 136184 11/6/2007 PV 74611 5,923.50 110607 NOV INS PREM 11789 11 /8/2007PK 136184 11/6/2007 PV 74611 622.70 110607 NOV INS PREM 11789 6,546.20 12/13/200F?K 136712 12/7/2007 PV 75709 5,957.00 120707 DEC INS PREM 11948 12/13/200F?K 136712 12/7/2007 PV 75709 413.90 120707 DEC INS PREM 11948 6,370.90 106811 DELTA DENTAL 75,430.85 R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:42:24 AP Paid Voucher Detail Voucher only By Vendor Name Page - 2 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total 102944 MEDICA 1/18/2007PK 130825 1/17/2007 PV 63674 30,833.34 011707 JAN INS PREM 10096 1/18/2007PK 130825 1/17/2007 PV 63674 35,394.02 011707 JAN INS PREM 10096 1/1 8/2007PK 130825 1/17/2007 PV 63674 897.31 011707 JAN INS PREM 10096 1/18/2007PK 130825 1/17/2007 PV 63674 6,070.06 011707 JAN INS PREM 10096 1/1 8/2007PK 130825 1/17/2007 PV 63674 4,463.93 011707 JAN INS PREM 10096 1/18/2007PK 130825 1/17/2007 PV 63674 9,041.38 011707 JAN INS PREM 10096 86,700.04 2/8/2007 PK 131203 2/2/2007 PV 64368 33,063.58 020207 FEB INS PREM 10212 2/8/2007 PK 131203 2/2/2007 PV 64368 35,394.02 020207 FEB INS PREM 10212 2/8/2007 PK 131203 2/2/2007 PV 64368 897.31 020207 FEB INS PREM 10212 2/8/2007 PK 131203 2/2/2007 PV 64368 8,720.84 020207 FEB INS PREM 10212 2/8/2007 PK 131203 2/2/2007 PV 64368 6,489.78 020207 FEB INS PREM 10212 2/8/2007 PK 131203 2/2/2007 PV 64368 4,044.21 020207 FEB INS PREM 10212 88,609.74 3/8/2007 PK 131677 3/5/2007 PV 65319 35,420.82 030507 MARCH INS PREM 10411 3/8/2007 PK 131677 3/5/2007 PV 65319 30,764.39 030507 MARCH INS PREM 10411 3/8/2007 PK 131677 3/5/2007 PV 65319 897.31 030507 MARCH INS PREM 10411 3/8/2007 PK 131677 3/5/2007 PV 65319 9,842.49 030507 MARCH INS PREM 10411 3/8/2007 PK 131677 3/5/2007 PV 65319 6,976.66 030507 MARCH INS PREM 10411 3/8/2007 PK 131677 3/5/2007 PV 65319 3,557.33 030507 MARCH INS PREM 10411 87,459.00 3/29/2007PK 132052 3/28/2007 PV 66154 31,780.24 032807 APRIL INS PREM 10536 3/29/2007PK 132052 3/28/2007 PV 66154 32,261.24 032807 APRIL INS PREM 10536 3/29/2007PK 132052 3/28/2007 PV 66154 897.31 032807 APRIL INS PREM 10536 3/29/2007PK 132052 3/28/2007 PV 66154 8,153.25 032807 APRIL INS PREM 10536 3/29/2007PK 132052 3/28/2007 PV 66154 6,976.66 032807 APRIL INS PREM 10536 3/29/2007PK 132052 3/28/2007 PV 66154 3,557.33 032807 APRIL INS PREM 10536 83,626.03 5/3/2007 PK 132659 4/27/2007 PV 67354 33,810.96 042707 MAY INS PREM 10759 5/3/2007 PK 132659 4/27/2007 PV 67354 33,271.42 042707 MAY INS PREM 10759 5/3/2007 PK 132659 4/27/2007 PV 67354 897.31 042707 MAY INS PREM 10759 5/3/2007 PK 132659 4/27/2007 PV 67354 8,677.41 042707 MAY INS PREM 10759 5/3/2007 PK 132659 4/27/2007 PV 67354 6,976.66 042707 MAY INS PREM 10759 5/3/2007 PK 132659 4/27/2007 PV 67354 3,557.33 042707 MAY INS PREM 10759 87,191.09 6/7/2007 PK 133282 6/5/2007 PV 68660 32,943.56 060507 JUNE INS PREM 10981 6/7/2007 PK 133282 6/5/2007 PV 68660 31,371.72 060507 JUNE INS PREM 10981 R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:42:24 AP Paid Voucher Detail Voucher only By Vendor Name Page - 3 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total Continued... 102944 MEDICA 6/7/2007 PK 133282 6/5/2007 PV 68660 897.31 060507 JUNE INS PREM 10981 6/7/2007 PK 133282 6/5/2007 PV 68660 8,677.41 060507 JUNE INS PREM 10981 6/7/2007 PK 133282 6/5/2007 PV 68660 6,976.66 060507 JUNE INS PREM 10981 6/7/2007 PK 133282 6/5/2007 PV 68660 3,557.33 060507 JUNE INS PREM 10981 84,423.99 7/12/2007PK 133973 7/6/2007 PV 70032 32,598.80 070607 JULY INS PREM 11196 7/12/2007PK 133973 7/6/2007 PV 70032 30,526.95 070607 JULY INS PREM 11196 7/12/2007PK 133973 7/6/2007 PV 70032 897.31 070607 JULY INS PREM 11196 7/12/2007PK 133973 7/6/2007 PV 70032 8,677.41 070607 JULY INS PREM 11196 7/12/2007PK 133973 7/6/2007 PV 70032 6,976.66 070607 JULY INS PREM 11196 7/12/2007PK 133973 7/6/2007 PV 70032 3,557.33 070607 JULY INS PREM 11196 83,234.46 8/9/2007 PK 134529 8/3/2007 PV 71191 31,421.94 080307 AUG INS PREM 11350 8/9/2007 PK 134529 8/3/2007 PV 71191 31,424.26 080307 AUG INS PREM 11350 8/9/2007 PK 134529 8/3/2007 PV 71191 897.31 080307 AUG INS PREM 11350 8/9/2007 PK 134529 8/3/2007 PV 71191 8,677.41 080307 AUG INS PREM 11350 8/9/2007 PK 134529 8/3/2007 PV 71191 7,950.42 080307 AUG INS PREM 11350 8/9/2007 PK 134529 8/3/2007 PV 71191 3,557.33 080307 AUG INS PREM 11350 83,928.67 9/20/2007PK 135311 9/12/2007 PV 72727 31,731.40 091207 SEPT INS PREM 11561 9/20/2007PK 135311 9/12/2007 PV 72727 31,424.26 091207 SEPT INS PREM 11561 9/20/2007PK 135311 9/12/2007 PV 72727 897.31 091207 SEPT INS PREM 11561 9/20/2007PK 135311 9/12/2007 PV 72727 8,677.41 091207 SEPT INS PREM 11561 9/20/2007PK 135311 9/12/2007 PV 72727 6,976.66 091207 SEPT INS PREM 11561 9/20/2007PK 135311 9/12/2007 PV 72727 3,557.33 091207 SEPT INS PREM 11561 83,264.37 10/18/200F?K 135840 10/10/2007 PV 73865 34,784.72 101007 OCT INS PREM 11682 10/18/200F?K 135840 10/10/2007 PV 73865 31,424.26 101007 OCT INS PREM 11682 10/18/200F?K 135840 10/10/2007 PV 73865 897.31 101007 OCT INS PREM 11682 10/18/200F?K 135840 10/10/2007 PV 73865 8,356.95 101007 OCT INS PREM 11682 10/18/200F?K 135840 10/10/2007 PV 73865 7,463.54 101007 OCT INS PREM 11682 10/18/200F?K 135840 10/10/2007 PV 73865 2,417.15 101007 OCT INS PREM 11682 85,343.93 11 /8/2007PK 136214 11/6/2007 PV 74634 35,449.02 110607 NOV INS PREM 11789 11 /8/2007PK 136214 11/6/2007 PV 74634 31,424.26 110607 NOV INS PREM 11789 11 /8/2007PK 136214 11/6/2007 PV 74634 897.31 110607 NOV INS PREM 11789 11 /8/2007PK 136214 11/6/2007 PV 74634 8,356.95 110607 NOV INS PREM 11789 11 /8/2007PK 136214 11/6/2007 PV 74634 8,437.30 110607 NOV INS PREM 11789 11 /8/2007PK 136214 11/6/2007 PV 74634 2,749.99 110607 NOV INS PREM 11789 R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:42:24 AP Paid Voucher Detail Voucher only By Vendor Name Page - 4 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total Continued... 102944 MEDICA 87,314.83 12/13/200F?K 136752 12/10/2007 PV 75797 34,962.14 121007 DEC INS PREM 11948 12/13/200F?K 136752 12/10/2007 PV 75797 31,424.26 121007 DEC INS PREM 11948 12/13/200F?K 136752 12/10/2007 PV 75797 897.31 121007 DEC INS PREM 11948 12/13/200F?K 136752 12/10/2007 PV 75797 9,725.81 121007 DEC INS PREM 11948 12/13/200F?K 136752 12/10/2007 PV 75797 7,463.54 121007 DEC INS PREM 11948 12/13/200F?K 136752 12/10/2007 PV 75797 5,504.85 121007 DEC INS PREM 11948 89,977.91 102944 MEDICA 1,031,074.06 105615 PRUDENTIAL INSURANCE 1 /18/2007PK 130848 1/18/2007 PV 63712 2,186.99 011807 JAN INS PREM 10096 1 /18/2007PK 130848 1/18/2007 PV 63712 30.22 011807 JAN INS PREM 10096 1/1 8/2007PK 130848 1/18/2007 PV 63712 48.72 011807 JAN INS PREM 10096 2,265.93 2/15/2007PK 131359 2/13/2007 PV 64606 2,188.73 021307 FEB INS PREM 10255 2/15/2007PK 131359 2/13/2007 PV 64606 30.22 021307 FEB INS PREM 10255 2/15/2007PK 131359 2/13/2007 PV 64606 48.72 021307 FEB INS PREM 10255 2,267.67 3/15/2007PK 131821 3/13/2007 PV 65608 2,187.99 031307 MARCH INS PREM 10466 3/15/2007PK 131821 3/13/2007 PV 65608 44.56 031307 MARCH INS PREM 10466 3/15/2007PK 131821 3/13/2007 PV 65608 48.72 031307 MARCH INS PREM 10466 2,281.27 4/12/2007PK 132306 4/10/2007 PV 66629 2,310.79 041007 APRIL INS PREM 10630 4/12/2007PK 132306 4/10/2007 PV 66629 30.22 041007 APRIL INS PREM 10630 4/12/2007PK 132306 4/10/2007 PV 66629 14.34- 041007 APRIL INS PREM 10630 4/12/2007PK 132306 4/10/2007 PV 66629 48.72 041007 APRIL INS PREM 10630 2,375.39 5/10/2007PK 132818 5/8/2007 PV 67626 2,313.90 050807 MAY INS PREM 10809 5/10/2007PK 132818 5/8/2007 PV 67626 39.76 050807 MAY INS PREM 10809 5/10/2007PK 132818 5/8/2007 PV 67626 48.72 050807 MAY INS PREM 10809 2,402.38 6/14/2007PK 133446 6/8/2007 PV 68973 2,294.70 060807 JUNE INS PREM 11011 6/14/2007PK 133446 6/8/2007 PV 68973 30.22 060807 JUNE INS PREM 11011 6/14/2007PK 133446 6/8/2007 PV 68973 9.54- 060807 JUNE INS PREM 11011 6/14/2007PK 133446 6/8/2007 PV 68973 52.20 060807 JUNE INS PREM 11011 2,367.58 7/19/2007PK 134142 7/17/2007 PV 70431 2,296.44 071707 JULY INS PREM 11233 R55APPAID LOG21000VO CITY OF BROOKLYN CENTER 4/15/2008 12:42:24 AP Paid Voucher Detail Voucher only By Vendor Name Page - 5 1/1/2007 - 12/31/2007 Address Vendor Name PO Inv Date Type Doc Amount Vendor Invoice # Remark Batch # Ck Date Ck Number 1099 Total Continued... 105615 PRUDENTIAL INSURANCE 7/19/2007PK 134142 7/17/2007 PV 70431 69.05 071707 JULY INS PREM 11233 7/19/2007PK 134142 7/17/2007 PV 70431 48.37 071707 JULY INS PREM 11233 7/19/2007PK 134142 7/17/2007 PV 70431 52.20 071707 JULY INS PREM 11233 2,466.06 8/16/2007PK 134684 8/14/2007 PV 71542 2,286.21 081407 AUG INS PREM 11394 8/16/2007PK 134684 8/14/2007 PV 71542 70.79 081407 AUG INS PREM 11394 8/16/2007PK 134684 8/14/2007 PV 71542 52.20 081407 AUG INS PREM 11394 2,409.20 9/20/2007PK 135337 9/17/2007 PV 72876 2,286.21 091707 SEPT INS PREM 11561 9/20/2007PK 135337 9/17/2007 PV 72876 69.05 091707 SEPT INS PREM 11561 9/20/2007PK 135337 9/17/2007 PV 72876 52.20 091707 SEPT INS PREM 11561 2,407.46 10/18/200F?K 135865 10/15/2007 PV 73894 2,291.43 101507 OCT INS PREM 11682 10/18/200F?K 135865 10/15/2007 PV 73894 69.05 101507 OCT INS PREM 11682 10/18/200F?K 135865 10/15/2007 PV 73894 52.20 101507 OCT INS PREM 11682 2,412.68 11 /15/200F?K 136338 11/8/2007 PV 74821 2,338.44 110807 NOV INS PREM 11825 11 /15/200F?K 136338 11/8/2007 PV 74821 3.48- 110807 NOV INS PREM 11825 11 /15/200F?K 136338 11/8/2007 PV 74821 70.79 110807 NOV INS PREM 11825 11 /15/200F?K 136338 11/8/2007 PV 74821 5.22 110807 NOV INS PREM 11825 11 /15/200F?K 136338 11/8/2007 PV 74821 50.46 110807 NOV INS PREM 11825 2,461.43 12/20/200F?K 136916 12/18/2007 PV 76103 2,312.01 121807 DEC INS PREM 11986 12/20/200F?K 136916 12/18/2007 PV 76103 70.79 121807 DEC INS PREM 11986 12/20/200F?K 136916 12/18/2007 PV 76103 50.46 121807 DEC INS PREM 11986 2,433.26 105615 PRUDENTIAL INSURANCE 28,550.31 Report Total 1,135,055.22 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:00:38 DBA By Employee Name DBA Detail History Report Page - 1 1/1/2005 - 12/31/2005 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 116406 ABRAHAMSON, CHRISTIAN R 340.35 163.29 177.06 108174 ANDERSON GOFF, JEAN L 3,600.79 1,727.51 1,873.28 107786 ANDERSON, AMY M 35.06 16.82 18.24 108103 ANDERSON, DENNIS L 4,934.30 2,367.36 2,566.94 108215 ANDERSON, LYLE E 4,697.42 2,253.69 2,443.73 120651 ANDRADA, JOCELYN M 606.74 291.10 315.64 111801 ANDREWJESKI, STEVE 273.98 131.45 142.53 120345 ASTUTO, DANIEL J 79.78 38.28 41.50 108099 ATANASOFF, EDWARD E 5,683.56 2,726.82 2,956.74 119107 BALD, ADAM J 3,690.53 1,770.61 1,919.92 107779 BALLANGER, BRUCE J 6,231.86 2,989.90 3,241.96 107794 BARTLETT, KOREEN C 1,289.72 618.77 670.95 107802 BECHTEL, AMANDA J 832.55 399.44 433.11 107764 BECHTHOLD, SCOTT F 15,570.48 6,228.19 9,342.29 107796 BECK, LAURA J 118.69 56.94 61.75 108010 BECKER, CORINNE D 10,395.63 4,158.24 6,237.39 108317 BELLM, WARNER T 871.03 417.90 453.13 108011 BENNER, KEVIN J 12,403.36 4,961.30 7,442.06 107797 BENNY, CHRISTOPHER W 81.39 39.05 42.34 108111 BENTZEN, ANDREW J 4,974.03 2,386.43 2,587.60 108068 BENTZEN, DOUGLAS A 4,854.11 2,328.88 2,525.23 108121 BENTZEN, JOHN D 5,479.15 2,628.75 2,850.40 108104 BERG, TODD P 4,896.08 2,349.01 2,547.07 107781 BERGELAND, JUDITH L 7,610.86 3,651.47 3,959.39 119581 BERGER, JILL L 2,783.29 1,335.35 1,447.94 113592 BLOMSTROM, TODD A 10,621.69 5,096.02 5,525.67 120832 BOERBOOM, AMY J 191.78 92.01 99.77 113694 BOGANEY, CORNELIUS L 9,521.07 4,567.98 4,953.09 108264 BOIE, REBBECCA A 4,067.17 1,951.29 2,115.88 108012 BOI E, THOMAS C 12, 216.56 4,886.63 7,329.93 107769 BOMAN, RONALD L 13,167.33 5,266.98 7,900.35 107963 BOND, CHRISTINE M 135.01 64.77 70.24 108109 BOOTH, MARC E 5,164.69 2,477.87 2,686.82 107778 BOWEN, TERESA L 5,531.99 2,654.15 2,877.84 111017 BRENNA, JILL M 5,451.48 2,615.50 2,835.98 108161 BRINKMAN, ROBERT K 281.22 134.92 146.30 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:00:38 DBA By Employee Name DBA Detail History Report Page - 2 1/1/2005 - 12/31/2005 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 120971 BROWN - WHISTLER, SUSAN D 93.58 44.90 48.68 108013 BRUCE, BRIAN R 9,079.26 3,631.73 5,447.53 115629 BRUNELL, PATTY E 3,732.21 1,790.57 1,941.64 108045 BRYAN, BARBARA K 196.99 94.51 102.48 108129 BUBLITZ, THOMAS R 7,050.98 3,382.83 3,668.15 108127 BURDA, DANIEL J 4,860.02 2,331.72 2,528.30 108093 BURDA, KELLY S 3,783.88 1,815.40 1,968.48 107813 BURMEISTER, JUSTIN D 439.07 210.66 228.41 108065 BURNETTE, JAMES K 3,588.50 1,721.69 1,866.81 117037 BURNETTE, THOMAS L 3,258.40 1,563.30 1,695.10 108110 BUSHINGER, TRACY A 4,967.72 2,383.40 2,584.32 107814 CAHILL, STEVEN C 559.90 268.63 291.27 107815 CARLSON, JULIA M 236.82 113.62 123.20 108014 CARLSON, KEITH D 9,891.65 3,956.68 5,934.97 111957 CARMODY, KATHLEEN 832.64 416.32 416.32 118720 CARTER, STEVEN L 340.94 163.57 177.37 119629 CARTER, VIRGINIA L 2,599.94 1,247.36 1,352.58 120471 CARY, NANCY R 2,391.51 1,147.41 1,244.10 107994 CASTO, KAREN J 4,903.07 2,352.34 2,550.73 116627 CHASE, TIMOTHY T 913.28 438.16 475.12 108105 CHRISTOPHER, DOUG W 5,287.02 2,536.56 2,750.46 108015 COLEMAN, GARY L 10,737.90 4,295.15 6,442.75 115988 COLEMAN, MICHAEL T 1,155.64 554.44 601.20 114529 COMEAU, CHRISTINA L 11.15 5.35 5.80 108071 COMMERS, KRISTI M 2,339.38 1,122.39 1,216.99 107997 CRASS, REBECCA S 4,203.17 2,016.57 2,186.60 107989 CROCKER, SCOTT D 5,747.17 2,757.37 2,989.80 108139 DAHLBERG, CURTIS E 2,069.69 992.99 1,076.70 110138 DAVIS, ELIZABETH J 2,466.95 1,183.60 1,283.35 118953 DAVIS, URSULA E 70.31 33.73 36.58 108047 DESTICHE, JAMES R 7,809.65 3,123.85 4,685.80 108140 DUNN, LORI A 2,068.62 992.47 1,076.15 119070 EEKHOFF, HELGA E 2,256.27 1,082.50 1,173.77 108181 EICKHOLT, JACOB D 24.33 11.67 12.66 120829 EK, ROSE V 912.14 437.62 474.52 117408 ELLIS, KRISTI M 879.12 421.79 457.33 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:00:38 DBA By Employee Name DBA Detail History Report Page - 3 1/1/2005 - 12/31/2005 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 118606 EMMERT, MELINDA A 239.12 114.73 124.39 107773 ERICKSEN, JOEL D 6,231.84 2,989.89 3,241.95 108119 FIELDS, THOMAS P 3,692.39 1,771.46 1,920.93 107990 FILIPIAK, ANASTASIA 319.05 153.07 165.98 120881 FITZGIBBONS, CARMEN N 6.84 3.28 3.56 108116 FLESHER, KATHY 6,231.84 2,989.89 3,241.95 108017 FLESLAND, GARETT S 11,027.98 4,411.17 6,616.81 107991 FOGAL, SUE A 4,635.23 2,223.87 2,411.36 108018 FRENCH, JOHN K 9,574.58 3,829.87 5,744.71 120259 GABLER, RICHARD J 3,872.94 1,549.19 2,323.75 108019 GANNON, TIMOTHY P 12,652.26 5,060.89 7,591.37 120775 GEISSLER, WALTER A 75.62 36.28 39.34 118249 GILLIES, BARBARA J 3,770.53 1,808.98 1,961.55 108094 GILPIN, GARY F 5,634.11 2,703.13 2,930.98 107772 G LASO E, JAMES M 8,958.99 4,298.25 4,660.74 116388 GOODMAN, LAURA L 9,420.33 3,768.10 5,652.23 108049 GOULD, JEAN L 163.01 78.21 84.80 108020 GRUENIG, TONY L 11,350.65 4,540.25 6,810.40 108097 GULSETH, JOYCE A 4,609.04 2,211.36 2,397.68 115976 GUTKNECHT, MYLES J 98.21 47.12 51.09 108279 GUTKNECHT, STAFFORD G 754.98 362.21 392.77 108112 HANSEN, LARRY N 4,958.64 2,379.03 2,579.61 108219 HANSON, DENISE M 4,112.93 1,973.29 2,139.64 118650 HANSON, FRANCINE 2,476.16 1,187.99 1,288.17 120796 HANSON, JULIE L 1,050.25 503.88 546.37 108021 HANSSEN, DEBORA A 3,058.87 1,223.55 1,835.32 108163 HARENZA, DAVID L 991.68 475.78 515.90 107774 HARLOW, JOHN W 7,801.55 3,742.97 4,058.58 107776 HARTFIEL, MARK D 7,408.17 3,554.28 3,853.89 107992 HARTFIEL, ROBIN C 2,264.08 1,086.24 1,177.84 107999 HARTWIG, PATRICIA P 8,313.99 3,988.81 4,325.18 120774 HAUGEN, BRETT P 270.35 129.71 140.64 108164 HEDSTROM, GARY A 101.92 48.89 53.03 107860 HEDSTROM, SUZANNE M 4.66 2.24 2.42 108022 HEILMAN, ROBERT B 10,097.19 4,038.87 6,058.32 107767 HEISER, KIMBERLY M 260.91 125.18 135.73 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:00:38 DBA By Employee Name DBA Detail History Report Page - 4 1/1/2005 - 12/31/2005 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 110647 HENNING, CHRISTIE L 2,322.63 1,114.34 1,208.29 119619 HILGER, CLARAA 3,969.96 1,904.68 2,065.28 108185 HILL, JEFFREY A 152.56 73.19 79.37 107775 HOFFMAN, GEORGE B 9,068.93 4,351.01 4,717.92 108417 HOIEM, DONNA M 20.55 9.86 10.69 108023 HOLMSTROM, DWAYNE M 10,091.25 4,036.50 6,054.75 107868 HOLUB, JEAN A 627.33 300.97 326.36 108144 HOXTELL, BETH A 1,870.14 897.26 972.88 108053 HRNCIR, LEANN K 2,947.22 1,414.00 1,533.22 120795 IVERSON, DEREK E 1,264.90 606.87 658.03 107881 JANKOVICH, KIRSTEN E 1,245.71 597.65 648.06 107872 JARVIS, CHRISTOPHER S 1,344.21 644.90 699.31 108165 JENNRICH, GEORGE A 4,633.98 2,223.31 2,410.67 108186 JESPERSON, MARK D 493.69 236.86 256.83 121086 JOHNSON, BRUCE A 433.85 208.15 225.70 120257 JOHNSON, MYCHAL D 3,967.17 1,586.87 2,380.30 108147 JORANGER, JAMES A 491.74 235.92 255.82 118001 JORDAN, ERIK R 502.19 240.94 261.25 117548 JORDET, DANIEL A 10,167.85 4,878.25 5,289.60 116320 KARLSEN, SHERRY D 1,683.43 807.66 875.77 108128 KARLSON, GARY P 4,845.51 2,324.77 2,520.74 108005 KARRIS, STEVEN A 10,990.07 4,395.99 6,594.08 108151 KASSERA, CARRIE L 2,274.59 1,091.30 1,183.29 107982 KAUTH, MYRNA L 1,087.68 543.84 543.84 118320 KIISA, MARK H 71.55 34.33 37.22 120970 KING, MICHAEL A 692.80 332.39 360.41 108166 KLINGENSMITH, ROGER L 540.03 259.09 280.94 108024 KNIGHT, MELONEY S 9,790.19 3,916.11 5,874.08 107758 KNUTSON, SHARON L 6,401.51 3,071.22 3,330.29 108081 KOEGL, MATTHEW 5,436.07 2,608.08 2,827.99 108007 KONCAR, WILLIAM F 10,294.70 4,117.88 6,176.82 120256 KOSKI, DAVID W 2,374.01 1,138.99 1,235.02 108187 KRAEM ER, ANDREW P 1,356.05 650.60 705.45 107993 KUTZKE, SHARON M 1,849.25 887.22 962.03 108003 LABATT, PEGGY J 10, 916.90 4,366.76 6,550.14 108148 LACHANCE, JOHN B 5,508.14 2,642.72 2,865.42 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:00:38 DBA By Employee Name DBA Detail History Report Page - 5 1/1/2005 - 12/31/2005 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 108117 LACROSSE, SUSAN L 6,231.84 2,989.89 3,241.95 108150 LAROSE, ROBERT A 5,242.82 2,515.39 2,727.43 107983 LASMAN, KAY L 832.64 416.32 416.32 116824 LEONHARDT, THOMAS A 5,857.39 2,810.22 3,047.17 121019 LIU, EMMANUEL M 21.46 10.30 11.16 120449 LOGAN JR, THOMAS 743.52 356.73 386.79 108134 LOOMIS, JAMES E 5,510.51 2,643.80 2,866.71 118690 LORENTZ, STEVEN J 8,536.18 3,414.46 5,121.72 108096 LOVELACE, EDWARD J 5,632.13 2,702.18 2,929.95 108054 LU N D, JILL A 1,412.79 677.82 734.97 108190 MARKLOWITZ, SUSAN M 1,400.16 671.78 728.38 108132 MARSH JR, MICHAEL K 5,347.85 2,565.76 2,782.09 107771 MARTIN, LAURENCE W 6,826.18 3,275.01 3,551.17 115986 MATSEN, MICHAEL J 1,677.42 804.78 872.64 117069 MAY, KATHLEEN R 3, 665.82 1,758.75 1,907.07 107757 MCCAULEY, MICHAEL J 12,225.59 5,865.52 6,360.07 107900 MCDONALD, DIANE M 168.16 80.68 87.48 108291 MCDONALD, JESSICA A 282.46 135.52 146.94 108191 MCDONALD, TAYLOR J 3,390.44 1,626.69 1,763.75 117071 MCGRATH, SHARON A 988.04 474.04 514.00 108106 MEEHAN, DARRELL D 4,987.27 2,392.76 2,594.51 118608 MEISSNER, JOHN R 520.23 249.58 270.65 118745 MERTH, JOHN K 969.26 465.03 504.23 108028 MESSENBRINK, CLARK J 10,194.15 4,077.67 6,116.48 107877 MEYER, TARA S 3,753.46 1,800.80 1,952.66 108115 MICKELSON, DANNA J 3,600.79 1,727.51 1,873.28 108192 MILLER, BRUCE L 3,892.02 1,867.25 2,024.77 121058 MILLER, JEREMIAH E 69.95 33.56 36.39 108193 MILLER, STEVEN W 403.52 193.60 209.92 108212 MOE, J EAN N ETTE L 111.31 53.41 57.90 108008 MOEN, ANDREW F 3,622.30 1,448.91 2,173.39 107777 MUELLER, JEAN 7,243.69 3,475.29 3,768.40 120280 MYLES, SUSAN M 3,109.07 1,491.65 1,617.42 108029 NADEAU, SCOTT L 11,826.50 4,730.60 7,095.90 108120 NELSON, DWAYNE A 3,358.73 1,611.41 1,747.32 108057 NELSON, KAREN L 5,667.38 2,719.05 2,948.33 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:00:38 DBA By Employee Name DBA Detail History Report Page - 6 1/1/2005 - 12/31/2005 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 108002 NELSON, RICK A 5,767.27 2,766.98 3,000.29 108030 NELSON, TONYA M 9,507.22 3,802.93 5,704.29 108195 NELSON, WILLARD R 641.09 307.57 333.52 111958 NIESEN, DIANE 832.64 416.32 416.32 108196 NORENBERG, SHARON K 1,690.62 811.12 879.50 108136 NYLAND, JEFFREY A 5,625.38 2,698.91 2,926.47 108137 OXONEK, ROBERT A 5,448.61 2,614.10 2,834.51 120831 OGEH, DANIEL N 12.67 6.08 6.59 107914 OLSON, RYAN D 8.59 4.12 4.47 108031 OLSON, TERRANCE N 12,430.50 4,972.20 7,458.30 120776 PAGE, JESSICA L 38.62 18.53 20.09 108131 PAGE, PATRICIA A 4,410.51 2,116.04 2,294.47 108032 PASTOR, STEPHEN M 10,681.95 4,272.80 6,409.15 108033 PEARSON, MONA J 11,687.54 4,675.02 7,012.52 108034 PEARSON, TODD M 4,079.94 1,631.97 2,447.97 108058 PEASLEY, TROY M 9,345.51 3,738.21 5,607.30 107985 PEPPE, ROBERT T 27.22 13.61 13.61 111319 PETERS, BRIAN P 9,426.13 3,770.46 5,655.67 107780 PETERSON, DAVID L 8,177.35 3,923.28 4,254.07 120448 PETERSON, JOSHUA J 405.85 194.72 211.13 118252 PETERSON, MICHAEL A 3,361.93 655.96 711.28 797.89 1,196.80 117380 PETERSON, WILLIAM G 1,168.04 560.41 607.63 118649 PETROS, KENDRA L 365.04 175.14 189.90 108175 PFANN, JEANNINE L 3,974.47 1,906.81 2,067.66 108153 PHILLIPS, AMY D 2,523.10 1,210.51 1,312.59 108035 POTTER, KIMBERLY A 9,727.25 3,890.93 5,836.32 108199 QUIST, PETER H 447.81 214.86 232.95 108060 RASMUSSEN, PATRICIAA 1,499.35 719.34 780.01 108036 RATAJCZYK, JOHN D 10,589.80 4,235.92 6,353.88 108124 REINKING, MARK W 5,072.56 2,433.69 2,638.87 107987 REMJESKE, SUSAN L 3,613.67 1,733.69 1,879.98 117905 REMMERS, JENNIFER L 2,460.28 1,180.38 1,279.90 108009 REYNOLDS, MICHAEL J 10,974.99 4,389.97 6,585.02 108101 RICE, SUSAN J 4,175.85 2,003.47 2,172.38 108213 RI ETSCH EL, JOANNE C 365.33 175.27 190.06 116123 RIMER JR, RICHARD J 809.11 388.19 420.92 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:00:38 DBA By Employee Name DBA Detail History Report Page - 7 1/1/2005 - 12/31/2005 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 118911 RISING, SHANNON M 219.79 105.45 114.34 108133 ROBARGE, RANDALL P 5,780.20 2,773.18 3,007.02 108037 ROBINSON JR, STUART D 13,522.91 5,409.16 8,113.75 108038 ROGNSTAD, CHRISTOPHER A 10,942.84 4,377.13 6,565.71 119425 RONNING, SHERYL A 75.36 36.16 39.20 107988 ROSENBAUM, MARIA L 3,404.83 1,633.55 1,771.28 108200 ROSS, BONNIE J 683.29 327.83 355.46 108039 ROTH, FRANK J 11,320.31 4,528.14 6,792.17 120255 ROTH BAU ER-BI ERNAT, LISA 1,025.91 492.21 533.70 120344 RUUD, BRADLEY J 26.14 12.54 13.60 107763 SCHLOSSER, MICHAEL G 5,645.85 2,708.72 2,937.13 108201 SCHMIDT, MICHAEL A 1,925.60 923.87 1,001.73 108154 SCHOLL, EDWARD F 867.65 416.28 451.37 108040 SC H U LTZ, JAMES A 10,172.64 4,069.06 6,103.58 108102 SCHWANINGER, SHELLEY A 4,456.55 2,138.14 2,318.41 108155 SCOTT, DARLENE Y 249.14 119.53 129.61 108216 SMART, REGGIE S 4,692.46 2,251.30 2,441.16 120833 SMITH, CAMERON L 141.66 67.96 73.70 108214 SMITH, CHERYL L 315.41 151.32 164.09 108173 SMITH, RICHARD E 651.88 312.76 339.12 118607 SOUTHAVILAY, ANTHONY N 506.64 243.07 263.57 108176 SPAH, MARY J 4,772.73 2,289.87 2,482.86 119145 SPRINGFIELD, AMANDA E 4,228.25 2,028.60 2,199.65 108202 ST DRYDEN, BONNIE L 4,990.09 2,394.09 2,596.00 108061 STACY, CAROL A 314.11 150.70 163.41 108217 STADT, KEITH A 5,042.06 2,419.08 2,622.98 119654 STEWART, KRISTIN L 474.99 227.89 247.10 108062 STEWART, LAU RI E A 125.20 60.07 65.13 108156 SWANSON, TERRI J 1,435.18 688.56 746.62 107947 SYSLO, VICTORIA T 1,825.63 875.89 949.74 116940 TEACHOUT, SHAREE L 401.77 192.76 209.01 120835 THOMPSON, BETH A 27.08 12.99 14.09 111624 TOOHEY, PATRICK 8,147.69 3,259.08 4,888.61 108041 TRAXLER, ROBERT R 10,156.81 4,062.72 6,094.09 108042 TROUT, JOSEPH P 9,103.32 3,641.35 5,461.97 108206 TRUESDALE, MICHAEL D 3,273.43 1,570.48 1,702.95 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:00:38 DBA By Employee Name DBA Detail History Report Page - 8 1/1/2005 - 12/31/2005 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 120830 TURNER, PAMELA A 15.90 7.63 8.27 107954 ULMER DE RAMIREZ, NATALIE B 1,162.59 557.77 604.82 108001 VALKER, DAVID F 5,835.09 2,799.53 3,035.56 108043 VALLEAU, CHARLES D 11,370.00 4,548.00 6,822.00 116060 VESEY, BRETT T 1,468.46 704.52 763.94 108125 VETTER, WILLIAM J 4,983.24 2,390.83 2,592.41 117904 WALBY, JESSICA A 4,346.75 2,085.46 2,261.29 108100 WALL, KAREN E 4,550.46 2,183.19 2,367.27 107998 WARRENII, RONALD A 7,050.94 3,382.81 3,668.13 118651 WEGLEITNER, BRIAN D 323.05 154.99 168.06 108108 WHITING, JENNIFER K 3,877.55 1,860.30 2,017.25 108218 WHITMAN III, FRANK L 981.28 470.79 510.49 107996 WICK, KELLI K 8,042.10 3,858.36 4,183.74 120773 WILKINS, OMNI R 156.31 74.99 81.32 107768 WILLGOHS, DIANE M 6,493.76 3,115.57 3,378.19 108207 WILLIAMS, DAVID K 4,054.51 1,945.24 2,109.27 108123 WILLIAMS, STEVE J 4,920.56 2,360.76 2,559.80 120834 WILLIAMS, TRISHA A 33.65 16.14 17.51 107973 WILSON, KELLY M 789.74 378.89 410.85 107761 WOJ CI K, NANCY J 8,394.39 4,027.38 4,367.01 108044 WONG, CARLOS A 10,375.34 4,150.13 6,225.21 120984 WORLEY, ANNA C 548.67 263.24 285.43 Report Totals 1,090,079.39 301,467.17 326,885.99 183,245.46 274,867.95 1,806.41 1,806.41 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:01:47 DBA By Employee Name DBA Detail History Report Page - 1 1/1/2006 - 12/31/2006 1100 1200 -1205 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 121415 AGNES, THOMAS J 5,834.62 2,790.46 3,044.16 108174 ANDERSON GOFF, JEAN L 4,017.71 1,921.54 2,096.17 107786 ANDERSON, AMY M 124.55 72.06 52.49 108103 ANDERSON, DENNIS L 4,904.27 2,345.52 2,558.75 108215 ANDERSON, LYLE E 5,307.29 2,538.27 2,769.02 120651 ANDRADA, JOCELYN M 1,976.08 945.08 1,031.00 111801 ANDREWJESKI, STEVE 390.76 186.88 203.88 119107 BALD, ADAM J 4,279.88 2,046.91 2,232.97 107779 BALLANGER, BRUCE J 6,944.35 3,321.20 3,623.15 107794 BARTLETT, KOREEN C 1,582.00 756.60 825.40 107802 BECHTEL, AMANDA J 954.33 456.42 497.91 107764 BECHTHOLD, SCOTT F 18,106.70 7,242.67 10,864.03 107796 BECK, LAURA J 30.30 14.49 15.81 108010 BECKER, CORINNE D 13,380.86 5,352.36 8,028.50 108317 BELLM, WARNER T 808.90 386.86 422.04 122248 BELZ, LINDSEY D 998.22 477.42 520.80 108011 BENNER, KEVIN J 14,518.12 5,807.30 8,710.82 108111 BENTZEN, ANDREW J 2,020.91 966.52 1,054.39 108068 BENTZEN, DOUGLAS A 5,217.16 2,495.17 2,721.99 108121 BENTZEN, JOHN D 5,708.93 2,730.34 2,978.59 108104 BERG, TODD P 5,351.79 2,559.54 2,792.25 107781 BERGELAND, JUDITH L 8,688.18 4,155.26 4,532.92 119581 BERGER, JILL L 4,567.94 2,184.63 2,383.31 113592 BLOMSTROM, TODD A 11,898.99 5,690.81 6,208.18 108402 BOEHLKE, NICHOLAS J 2,068.62 989.34 1,079.28 120832 BOERBOOM, AMY J 880.16 420.94 459.22 113694 BOGANEY, CORNELIUS L 11,920.27 5,701.01 6,219.26 108264 BOI E, REBBECCA A 4,864.78 2,326.68 2,538.10 108012 BOIE, THOMAS C 13,673.37 5,469.38 8,203.99 107769 BOMAN, RONALD L 15,311.92 6,124.77 9,187.15 107963 BOND, CHRISTINE M 628.80 320.17 308.63 108109 BOOTH, MARC E 5,128.43 2,452.72 2,675.71 107778 BOWEN, TERESA L 6,291.34 3,008.86 3,282.48 111017 BRENNA, JILL M 6,371.93 3,047.46 3,324.47 108161 BRINKMAN, ROBERT K 236.79 113.25 123.54 120971 BROWN - WHISTLER, SUSAN D 556.22 266.03 290.19 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:01:47 DBA By Employee Name DBA Detail History Report Page - 2 1/1/2006 - 12/31/2006 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 108013 BRUCE, BRIAN R 9,418.15 3,767.26 5,650.89 115629 BRUNELL, PATTY E 4,320.59 2,066.36 2,254.23 108129 BUBLITZ, THOMAS R 7,849.63 3,754.13 4,095.50 108127 BURDA, DANIEL J 5,257.43 2,514.41 2,743.02 108093 BURDA, KELLY S 4,348.57 2,079.75 2,268.82 108366 BURMEISTER, JAMIE R 103.02 49.27 53.75 107813 BURMEISTER, JUSTIN D 472.34 225.90 246.44 108065 B U RN ETTE, JAMES K 4,106.69 1,964.10 2,142.59 117037 BURNETTE, THOMAS L 3,534.18 1,690.23 1,843.95 108110 BUSHINGER, TRACY A 5,212.91 2,493.12 2,719.79 107814 CAHILL, STEVEN C 736.33 352.17 384.16 107815 CARLSON, JULIA M 332.71 159.12 173.59 108014 CARLSON, KEITH D 11,417.92 4,567.19 6,850.73 111957 CARMODY, KATHLEEN 821.76 410.88 410.88 119629 CARTER, VIRGINIA L 4,189.72 2,003.79 2,185.93 120471 CARY, NANCY R 6,583.66 3,148.71 3,434.95 107994 CASTO, KAREN J 5,597.25 2,676.94 2,920.31 108105 CHRISTOPHER, DOUG W 5,374.70 2,570.50 2,804.20 107821 COLE, RENAE A 437.93 209.44 228.49 108015 COLEMAN, GARY L 13,674.66 5,469.88 8,204.78 115988 COLEMAN, MICHAEL T 4,629.26 353.66 385.81 1,555.92 2,333.87 108071 COMMERS, KRISTI M 4,652.45 2,225.14 2,427.31 121834 CRASS, KATIE J 1,922.40 919.40 1,003.00 107997 CRASS, REBECCA S 4,707.67 2,251.50 2,456.17 107989 CROCKER, SCOTT D 6,543.43 3,129.47 3,413.96 108139 DAHLBERG, CURTIS E 2,583.01 1,235.34 1,347.67 118953 DAVIS, URSULA E 450.28 238.72 211.56 108047 DESTICHE, JAMES R 10,791.63 4,316.64 6,474.99 120996 DORNSBACH, HELEN D 64.17 30.69 33.48 108140 DUNN, LORI A 2,442.81 1,168.30 1,274.51 120829 EK, ROSE V 4,087.44 1,954.87 2,132.57 117408 ELLIS, KRISTI M 1,291.68 617.76 673.92 121607 EPTING, TAHNEE M 3.26 1.56 1.70 107773 ERICKSEN, JOEL D 6,944.35 3,321.20 3,623.15 108119 FIELDS, THOMAS P 4,109.65 1,965.47 2,144.18 120881 FITZGIBBONS, CARMEN N 215.51 103.07 112.44 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:01:47 DBA By Employee Name DBA Detail History Report Page - 3 1/1/2006 - 12/31/2006 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 108116 FLESHER, KATHY 6,944.35 3,321.20 3,623.15 108017 FLESLAND, GARETT S 10,895.44 4,358.18 6,537.26 107991 FOGAL, SUE A 4,683.53 2,240.00 2,443.53 108018 FRENCH, JOHN K 5,674.50 2,269.77 3,404.73 120259 GABLER, RICHARD J 10,535.23 4,214.10 6,321.13 121835 GAGNON, KRISTEN M 2,054.38 982.52 1,071.86 107843 GANGL, ERIC L 91.06 43.55 47.51 108019 GANNON, TIMOTHY P 13,982.06 5,592.87 8,389.19 120775 GEISSLER, WALTER A 3,249.77 1,570.54 1,679.23 122283 GIESEKE, DAWN L 82.92 39.66 43.26 118249 GILLIES, BARBARA J 4,034.64 1,929.61 2,105.03 108094 GILPIN, GARY F 6,420.87 3,070.86 3,350.01 107772 G LASO E, JAMES M 9,983.02 4,774.53 5,208.49 108020 GRUENIG, TONY L 13,388.84 5,355.53 8,033.31 108097 GULSETH, JOYCE A 5,135.96 2,456.37 2,679.59 115976 GUTKNECHT, MYLES J 807.48 386.19 421.29 108279 GUTKNECHT, STAFFORD G 885.28 423.39 461.89 108112 HANSEN, LARRY N 5,250.38 2,511.06 2,739.32 108219 HANSON, DENISE M 4,652.45 2,225.14 2,427.31 120796 HANSON, JULIE L 4,183.99 2,001.06 2,182.93 108163 HARENZA, DAVID L 559.83 267.75 292.08 107774 HARLOW, JOHN W 8,255.23 3,948.14 4,307.09 107776 HARTFIEL, MARK D 8,254.80 3,947.97 4,306.83 107999 HARTWIG, PATRICIA P 9,495.84 4,541.53 4,954.31 120774 HAUGEN, BRETT P 351.57 168.14 183.43 108164 HEDSTROM, GARY A 146.58 72.56 74.02 108022 HEILMAN, ROBERT B 12,110.65 4,844.28 7,266.37 121932 HELD, RHONDA R 197.17 94.31 102.86 110647 HENNING, CHRISTIE L 3,076.78 1,471.51 1,605.27 119619 HILGER, CLARA A 7,612.73 3,640.85 3,971.88 107775 HOFFMAN, GEORGE B 10,105.47 4,833.03 5,272.44 108417 HOIEM, DONNA M 36.93 17.66 19.27 108023 HOLMSTROM, DWAYNE M 12,304.76 4,921.91 7,382.85 107868 HOLUB, JEAN A 742.95 355.32 387.63 108144 HOXTELL, BETH A 2,467.20 1,179.97 1,287.23 120795 IVERSON, DEREK E 1,077.08 515.12 561.96 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:01:47 DBA By Employee Name DBA Detail History Report Page - 4 1/1/2006 - 12/31/2006 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 107881 JANKOVICH, KIRSTEN E 1,412.95 675.75 737.20 107872 JARVIS, CHRISTOPHER S 2,129.48 1,018.44 1,111.04 108165 JENNRICH, GEORGE A 5,163.81 2,469.65 2,694.16 121086 JOHNSON, BRUCE A 8,708.24 4,164.81 4,543.43 120257 JOHNSON, MYCHAL D 10,001.80 4,000.72 6,001.08 121837 JONES, LISA L 869.77 415.98 453.79 110086 JONES, SARA 54.03 25.84 28.19 108147 JORANGER, JAMES A 516.76 247.15 269.61 118001 JORDAN, ERIK R 671.82 321.29 350.53 117548 JORDET, DANIEL A 11,330.16 5,418.74 5,911.42 116320 KARLSEN, SHERRY D 2,178.40 1,041.85 1,136.55 108128 KARLSON, GARY P 5,167.59 2,471.45 2,696.14 108005 KARRIS, STEVEN A 13,028.84 5,211.51 7,817.33 108151 KASSERA, CARRIE L 2,834.51 1,355.64 1,478.87 107982 KAUTH, MYRNA L 1,073.28 536.64 536.64 120970 KING, MICHAEL A 5,163.99 2,469.73 2,694.26 108166 KLINGENSMITH, ROGER L 45.19 21.61 23.58 108024 KNIGHT, M ELON EY S 10, 962.66 4,385.02 6,577.64 107758 KNUTSON, SHARON L 7,133.52 3,411.63 3,721.89 108081 KOEG L, MATTHEW 6,132.33 2,932.85 3,199.48 108007 KONCAR, WILLIAM F 12,062.01 4,824.81 7,237.20 120256 KOSKI, DAVID W 768.06 367.33 400.73 108187 KRAEMER, ANDREW P 914.94 437.58 477.36 107882 KROSCH, MEGHAN J 434.62 207.86 226.76 108003 LABATT, PEGGY J 13,407.41 5,362.96 8,044.45 107883 LABAU, KENNETH R 146.58 70.10 76.48 108148 LACHANCE, JOHN B 6,138.01 2,935.57 3,202.44 108117 LACROSSE, SUSAN L 6,944.35 3,321.20 3,623.15 108150 LAROSE, ROBERTA 6,075.29 2,905.58 3,169.71 107983 LASMAN, KAY L 821.76 410.88 410.88 122477 LAWRENCE, STEVEN M 159.18 76.13 83.05 121839 LEE, TRACIE L 886.59 424.02 462.57 116824 LEON HARDT, THOMAS A 6,385.94 3,054.13 3,331.81 122119 LEYK, SARA A 2,431.86 972.75 1,459.11 120449 LOGAN J R, THOMAS 1,986.24 949.95 1,036.29 108134 LOOMIS, JAMES E 6,129.37 2,931.42 3,197.95 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:01:47 DBA By Employee Name DBA Detail History Report Page - 5 1/1/2006 - 12/31/2006 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 118690 LORENTZ, STEVEN J 11,454.47 4,581.78 6,872.69 108096 LOVELACE, EDWARD J 2,163.78 1,034.85 1,128.93 122068 LUNDERBY, ALLEN D 111.43 53.29 58.14 108190 MARKLOWITZ, SUSAN M 1,438.77 688.10 750.67 108132 MARSH JR, MICHAEL K 6,018.58 2,878.45 3,140.13 107771 MARTIN, LAURENCE W 7,757.69 3,710.15 4,047.54 115986 MATSEN, MICHAEL J 588.61 281.51 307.10 117070 MATTISON, DANIEL J 444.16 212.42 231.74 117069 MAY, KATHLEEN R 3,972.94 1,900.12 2,072.82 107757 MCCAULEY, MICHAEL J 6,602.95 3,157.95 3,445.00 107900 MCDONALD, DIANE M 250.03 119.57 130.46 108291 MCDONALD, JESSICA A 399.49 191.07 208.42 108191 MCDONALD, TAYLOR J 3,802.89 1,818.79 1,984.10 117071 MCGRATH, SHARON A 1,444.31 690.75 753.56 108106 MEEHAN, DARRELL D 5,145.89 2,461.06 2,684.83 118608 MEISSNER, JOHN R 1,101.56 526.83 574.73 118745 MERTH, JOHN K 930.02 444.80 485.22 108028 MESSENBRINK, CLARK J 12,000.34 4,800.14 7,200.20 107877 MEYER, TARA S 4,225.96 2,021.14 2,204.82 108115 MICKELSON, DANNA J 4,013.84 1,919.69 2,094.15 108192 MILLER, BRUCE L 4,463.85 2,134.88 2,328.97 121058 MILLER, JEREMIAH E 472.93 226.20 246.73 108193 MILLER, STEVEN W 223.42 106.86 116.56 108212 MOE, J EAN N ETTE L 68.58 32.80 35.78 107777 MUELLER, JEAN 1,393.31 666.36 726.95 120280 MYLES, SUSAN M 6,316.53 3,020.96 3,295.57 108029 NADEAU, SCOTT L 14,503.36 5,801.39 8,701.97 121457 NAGBE, TODD S 1,642.50 785.54 856.96 108120 NELSON, DWAYNE A 3,628.11 1,735.18 1,892.93 108057 NELSON, KAREN L 3,697.15 1,768.21 1,928.94 108002 NELSON, RICK A 6,434.66 3,077.45 3,357.21 108030 NELSON, TONYA M 9,937.01 3,974.78 5,962.23 108195 NELSON, WILLARD R 636.64 304.49 332.15 111958 NIESEN, DIANE 821.76 410.88 410.88 108196 NORENBERG, SHARON K 1,994.38 953.83 1,040.55 108136 NYLAND, JEFFREY A 6,339.32 3,031.84 3,307.48 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:01:47 DBA By Employee Name DBA Detail History Report Page - 6 1/1/2006 - 12/31/2006 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 108137 OXONEK, ROBERT A 6,220.30 2,974.91 3,245.39 107914 OLSON, RYAN D 207.56 99.28 108.28 108031 OLSON, TERRANCE N 12,146.13 4,858.44 7,287.69 108131 PAGE, PATRICIA A 4,943.58 2,364.36 2,579.22 108032 PASTOR, STEPHEN M 13,820.37 5,528.14 8,292.23 108033 PEARSON, MONA J 13,619.06 5,447.61 8,171.45 108058 PEASLEY, TROY M 11,720.16 4,688.06 7,032.10 121357 PELTIER, JOSEPH L 29.35 14.04 15.31 111319 PETERS, BRIAN P 10,471.04 4,188.39 6,282.65 107780 PETERSON, DAVID L 9,111.79 4,357.76 4,754.03 120448 PETERSON, JOSHUA J 456.51 218.33 238.18 118252 PETERSON, MICHAEL A 10,340.30 4,136.13 6,204.17 117380 PETERSON, WILLIAM G 96.60 46.20 50.40 108175 PFAN N, J EAN N I N E L 4,539.64 2,171.08 2,368.56 121540 PHARO, CHRISTOPHER M 1,436.70 687.10 749.60 108153 PHILLIPS, AMY D 3,319.96 1,587.80 1,732.16 108035 POTTER, KIMBERLY A 11,179.80 4,471.88 6,707.92 108060 RASMUSSEN, PATRICIA A 1,820.36 870.62 949.74 108036 RATAJCZYK, JOHN D 12,096.90 4,838.76 7,258.14 108124 REINKING, MARK W 5,334.04 2,551.05 2,782.99 107987 REMJESKE, SUSAN L 4,257.69 2,036.31 2,221.38 108009 REYNOLDS, MICHAEL J 12,939.90 5,175.97 7,763.93 108101 RICE, SUSAN J 4,652.45 2,225.14 2,427.31 108213 RIETSCHEL, JOANNE C 507.26 242.60 264.66 116123 RIMER JR, RICHARD J 973.95 465.81 508.14 118911 RISING, SHANNON M 772.82 411.11 361.71 108133 RO BARG E, RAN DAL L P 2,160.61 1,033.33 1,127.28 108037 ROBINSON JR, STUART D 15,273.46 6,109.38 9,164.08 120997 ROBINSON, LYNESHIA F 316.89 151.56 165.33 122280 ROCKWELL, LESLIE S 48.49 23.19 25.30 108038 ROGNSTAD, CHRISTOPHER A 11,946.29 4,778.52 7,167.77 108200 ROSS, BONNIE J 874.79 418.38 456.41 108039 ROTH, FRANK J 13, 365.76 5,346.35 8,019.41 121788 RUED, JOHN P 2,753.48 1,316.88 1,436.60 120969 SCANLAN -BEER, AMY L 424.59 203.07 221.52 121982 SCHERER, THOMAS A 33.96 16.24 17.72 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:01:47 DBA By Employee Name DBA Detail History Report Page - 7 1/1/2006 - 12/31/2006 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 107763 SCHLOSSER, MICHAEL G 6,291.34 3,008.86 3,282.48 108201 SCHMIDT, MICHAEL A 2,529.61 1,209.81 1,319.80 108154 SCHOLL, EDWARD F 938.56 448.87 489.69 108040 SCHULTZ, JAMES A 11,826.07 4,730.41 7,095.66 108102 SCHWANINGER, SHELLEY A 5,057.29 2,418.70 2,638.59 108216 SMART, REGGIE S 5,215.45 2,494.34 2,721.11 120833 SMITH, CAMERON L 53.13 25.41 27.72 108214 SMITH, CHERYL L 325.21 155.54 169.67 108088 SORBY, GENE 1,587.99 759.47 828.52 118607 SOUTHAVILAY, ANTHONY N 527.50 251.88 275.62 108176 SPAH, MARY J 5,424.80 2,594.43 2,830.37 119145 SPRINGFIELD, AMANDA E 2,104.87 1,006.68 1,098.19 108202 ST DRYDEN, BONNIE L 5,563.05 2,660.63 2,902.42 108217 STADT, KEITH A 5,672.07 2,712.73 2,959.34 119654 STEWART, KRISTIN L 542.79 259.59 283.20 108156 SWANSON, TERRI J 1,895.75 906.66 989.09 107947 SYSLO, VICTORIA T 1,309.09 626.09 683.00 116940 TEACHOUT, SHAREE L 478.58 228.89 249.69 120835 THOMPSON, BETH A 27.61 13.21 14.40 111624 TOOHEY, PATRICK A 10,584.78 4,233.89 6,350.89 122282 TORRES, ROBERT M 68.16 32.60 35.56 108041 TRAXLER, ROBERT R 11,864.34 4,745.73 7,118.61 108042 TROUT, JOSEPH P 10,506.23 4,202.47 6,303.76 108206 TRUESDALE, MICHAEL D 3,658.46 1,749.69 1,908.77 107954 ULMER DE RAMIREZ, NATALIE B 1,072.40 512.89 559.51 108001 VALKER, DAVID F 6,384.32 3,053.37 3,330.95 108043 VALLEAU, CHARLES D 11,293.63 4,517.44 6,776.19 116060 VESEY, BRETT T 1,581.81 756.51 825.30 108125 VETTER, WILLIAM J 5,276.23 2,523.41 2,752.82 117904 WALBY, JESSICA A 2,925.05 1,398.94 1,526.11 108100 WALL, KAREN E 4,773.66 2,283.05 2,490.61 107998 WARRENII, RONALD A 7,857.20 3,757.75 4,099.45 108276 WESSMAN, PENNY L 215.83 103.21 112.62 108108 WHITING, JENNIFER K 4,320.59 2,066.36 2,254.23 121833 WHITTENBURG, JEREMY A 935.58 447.45 488.13 107996 WICK, KELLI K 9,176.34 4,388.69 4,787.65 R56DBA LOG20000 CITY OF BROOKLYN CENTER 4/17/2007 13:01:47 DBA By Employee Name DBA Detail History Report Page - 8 1/1/2006 - 12/31/2006 1100 1110 1210 1120 1220 Address Name Employee Total PERA Coord -EE PERA Coord -ER PERA P &F -EE PERA P &F -ER PERA DCP -EE PERA DCP -ER 107768 WILLGOHS, DIANE M 4,695.71 2,245.77 2,449.94 108207 WILLIAMS, DAVID K 4,404.25 2,106.33 2,297.92 121838 WILLIAMS, MOLLY E 813.69 389.16 424.53 108123 WILLIAMS, STEVE J 5,259.06 2,515.18 2,743.88 120834 WILLIAMS, TRISHA A 377.03 180.27 196.76 107973 WILSON, KELLY M 965.28 461.66 503.62 107761 WOJCIK, NANCY J 9,586.66 4,584.97 5,001.69 108044 WONG, CARLOS A 12,462.76 4,985.09 7,477.67 120984 WORLEY, ANNA C 4,495.66 2,150.11 2,345.55 121840 XU, QIAN TING 143.04 68.41 74.63 121836 YARPHEL, SONAM T 1,970.15 942.24 1,027.91 Report Totals 1,230,470.10 333,276.45 363,333.75 212,128.53 318,192.81 1,769.28 1,769.28 R56DBA LOG20000 CITY OF BROOKLYN CENTER 3/25/2008 9:33:53 DBA By Employee Name DBA Detail History Report Page - 1 1/1/2007 - 12/31/2007 1100 1110 1210 1120 1220 Address Name Employee Total *PERA -Cord PERA- Cord -ER *PERA- Police PERA- Pol -ER *PERA -DCP PERA - DCP -ER 121415 AGNES, THOMAS J 8,450.34 4,048.86 4,401.48 108174 ANDERSON GOFF, JEAN L 4,412.87 2,114.32 2,298.55 107786 ANDERSON, AMY M 3.68 1.76 1.92 123752 ANDERSON, BRENT 2,316.48 1,109.98 1,206.50 108215 ANDERSON, LYLE E 4,876.05 2,336.29 2,539.76 120651 ANDRADA, JOCELYN M 2,064.98 989.39 1,075.59 111801 ANDREWJESKI, STEVE 324.78 155.59 169.19 123169 BAKER, ANDREA D 960.48 460.23 500.25 119107 BALD, ADAM J 2,563.47 1,228.15 1,335.32 107779 BALLANGER, BRUCE J 7,452.00 3,570.48 3,881.52 107794 BARTLETT, KOREEN C 1,749.59 838.27 911.32 107802 BECHTEL, AMANDA J 656.68 314.60 342.08 107764 BECHTHOLD, SCOTT F 20,701.02 8,280.41 12,420.61 107796 BECK, LAURA J 191.13 91.58 99.55 108010 BECKER, CORINNE D 15,452.37 6,180.95 9,271.42 120969 BEER, AMY L 254.53 121.95 132.58 108317 BELLM, WARNER T 922.80 442.17 480.63 122248 BELZ, LINDSEY D 4,443.89 2,129.23 2,314.66 108011 BENNER, KEVIN J 16,716.40 6,686.62 10,029.78 108068 BENTZEN, DOUGLAS A 6,087.76 2,916.85 3,170.91 108121 BENTZEN, JOHN D 6,353.77 3,044.29 3,309.48 108104 BERG, TODD P 6,121.36 2,932.91 3,188.45 107781 BERGELAND, JUDITH L 9,327.68 4,469.21 4,858.47 119581 BERGER, JILL L 4,997.02 2,394.23 2,602.79 113592 BLOMSTROM, TODD A 12,768.52 6,117.78 6,650.74 108402 BOEHLKE, NICHOLAS J 5,323.49 2,550.63 2,772.86 120832 BOERBOOM, AMY J 983.54 471.26 512.28 113694 BOGANEY, CORNELIUS L 13,777.66 6,601.27 7,176.39 108264 BOIE, REBBECCA A 5,430.57 2,601.94 2,828.63 108012 BOIE, THOMAS C 15,653.23 6,261.31 9,391.92 107769 BOMAN, RONALD L 13,447.66 5,379.11 8,068.55 107963 BOND, CHRISTINE M 180.86 86.67 94.19 108109 BOOTH, MARC E 5,813.06 2,785.25 3,027.81 107778 BOWEN, TERESA L 6,360.44 3,047.51 3,312.93 111017 BRENNA, JILL M 6,882.78 3,297.82 3,584.96 108161 BRINKMAN, ROBERT K 300.64 144.06 156.58 R56DBA LOG20000 CITY OF BROOKLYN CENTER 3/25/2008 9:33:53 DBA By Employee Name DBA Detail History Report Page - 2 1/1/2007 - 12/31/2007 1100 1110 1210 1120 1220 Address Name Employee Total *PERA -Cord PERA- Cord -ER *PERA- Police PERA- Pol -ER *PERA -DCP PERA - DCP -ER 120971 BROWN - WHISTLER, SUSAN D 174.91 83.79 91.12 108013 BRUCE, BRIAN R 4,220.87 1,688.33 2,532.54 115629 BRUNELL, PATTY E 4,745.78 2,273.89 2,471.89 108129 BUBLITZ, THOMAS R 8,431.08 4,039.62 4,391.46 108127 BURDA, DANIEL J 5,861.65 2,808.49 3,053.16 108093 BURDA, KELLY S 1,638.34 784.89 853.45 108366 BURMEISTER, JAMIE R 74.15 35.52 38.63 107813 BURMEISTER, JUSTIN D 515.01 246.76 268.25 108065 BU RN ETTE, JAMES K 4,174.05 1,999.91 2,174.14 117037 BURNETTE, THOMAS L 3,912.28 1,874.52 2,037.76 108110 BUSHINGER, TRACY A 5,728.36 2,744.64 2,983.72 107814 CAHILL, STEVEN C 751.16 359.91 391.25 107815 CARLSON, JULIA M 455.45 218.22 237.23 108014 CARLSON, KEITH D 12,707.09 5,082.84 7,624.25 119629 CARTER, VIRGINIA L 4,720.29 2,261.62 2,458.67 120471 CARY, NANCY R 7,254.76 3,475.96 3,778.80 107994 CASTO, KAREN J 6,083.91 2,915.00 3,168.91 122913 CEG LA, KATHRYN M 116.99 56.06 60.93 108105 CHRISTOPHER, DOUG W 5,655.50 2,709.75 2,945.75 107821 COLE, RENAE A 51.55 24.68 26.87 108015 COLEMAN, GARY L 13,484.22 5,393.69 8,090.53 115988 COLEMAN, MICHAEL T 11,621.67 4,648.70 6,972.97 108071 COMMERS, KRISTI M 5,051.18 2,420.19 2,630.99 121834 CRASS, KATIE J 4,481.89 2,147.42 2,334.47 107997 CRASS, REBECCA S 5,132.58 2,459.19 2,673.39 107989 CROCKER, SCOTT D 7,207.01 3,453.14 3,753.87 108139 DAHLBERG, CURTIS E 2,635.95 1,262.97 1,372.98 122099 DAM ROW, TAM RA J 338.56 162.23 176.33 118953 DAVIS, URSULA E 69.89 33.48 36.41 108047 DESTICHE, JAMES R 12,376.70 4,950.68 7,426.02 108140 DUNN, LORI A 2,578.11 1,235.29 1,342.82 122735 EITEL, GARY 6, 388.75 3,061.25 3,327.50 120829 EK, ROSE V 4,814.27 2,306.71 2,507.56 117408 ELLIS, KRISTI M 1,348.33 646.02 702.31 107773 ERICKSEN, JOEL D 7,452.00 3,570.48 3,881.52 122769 ERICKSON, ALAN G 3,141.98 1,505.52 1,636.46 R56DBA LOG20000 CITY OF BROOKLYN CENTER 3/25/2008 9:33:53 DBA By Employee Name DBA Detail History Report Page - 3 1/1/2007 - 12/31/2007 1100 1110 1210 1120 1220 Address Name Employee Total *PERA -Cord PERA- Cord -ER *PERA- Police PERA- Pol -ER *PERA -DCP PERA - DCP -ER 108119 FIELDS, THOMAS P 5,013.69 2,402.28 2,611.41 122994 FINBERG, CHARLENE K 2,053.22 983.84 1,069.38 120881 FITZGIBBONS, CARMEN N 147.09 70.47 76.62 108116 FLESHER, KATHY 7,452.00 3,570.48 3,881.52 108017 FLESLAND, GARETT S 14,763.30 5,905.30 8,858.00 107991 FOGAL, SUE A 5,094.92 2,441.14 2,653.78 108018 FRENCH, JOHN K 1,336.62 534.65 801.97 122119 FRY, SARA A 10,629.67 4,251.88 6,377.79 120259 GABLER, RICHARD J 13,861.04 5,544.42 8,316.62 121835 GAGNON, KRISTEN M 4,503.41 2,157.73 2,345.68 107843 GANGL, ERIC L 278.38 133.38 145.00 108019 GANNON, TIMOTHY P 16,658.57 6,663.49 9,995.08 108075 GATLIN, LEE 4,681.53 1,872.64 2,808.89 120775 GEISSLER, WALTER A 3,788.89 1,815.38 1,973.51 107847 GENGLER, MICHAEL S 54.61 26.17 28.44 122283 GIESEKE, DAWN L 1,088.90 521.74 567.16 118249 GILLIES, BARBARA J 4,719.79 2,261.42 2,458.37 108094 GILPIN, GARY F 7,141.16 3,421.61 3,719.55 107772 G LASO E, JAMES M 10, 712.43 5,132.74 5,579.69 122279 GREEN, CHRISITA K 1,210.81 580.15 630.66 122704 GRIFFIN, NANDIN E 456.05 218.52 237.53 108020 GRUENIG, TONY L 16,777.28 6,710.91 10,066.37 108097 GULSETH, JOYCE A 4,236.43 2,029.78 2,206.65 115976 G UTKN ECHT, MYLES J 1,093.08 523.72 569.36 108279 GUTKNECHT, STAFFORD G 909.75 435.88 473.87 108112 HANSEN, LARRY N 5,703.23 2,732.62 2,970.61 108219 HANSON, DENISE M 4,992.74 2,392.17 2,600.57 120796 HANSON, JULIE L 4,645.79 2,225.93 2,419.86 108021 HANSSEN- ROBINSON, DEBORAA 3,570.81 1,711.00 1,859.81 122912 HARDY, VERLISA B 39.13 18.75 20.38 108163 HARENZA, DAVID L 885.12 424.12 461.00 107774 HARLOW, JOHN W 9,013.88 4,318.78 4,695.10 107776 HARTFIEL, MARK D 8,857.71 4,243.97 4,613.74 107999 HARTWIG, PATRICIA P 10,296.27 4,933.24 5,363.03 108142 HEARD, TONYA R 36.94 17.70 19.24 108164 HEDSTROM, GARY A 151.81 72.75 79.06 R56DBA LOG20000 CITY OF BROOKLYN CENTER 3/25/2008 9:33:53 DBA By Employee Name DBA Detail History Report Page - 4 1/1/2007 - 12/31/2007 1100 1110 1210 1120 1220 Address Name Employee Total *PERA -Cord PERA- Cord -ER *PERA- Police PERA- Pol -ER *PERA -DCP PERA - DCP -ER 108022 HEILMAN, ROBERT B 14,252.16 5,700.87 8,551.29 121932 HELD, RHONDA R 469.52 224.96 244.56 119619 HILGER, CLARA A 8,431.16 4,039.66 4,391.50 107775 HOFFMAN, GEORGE B 6,037.45 2,892.56 3,144.89 108417 HOIEM, DONNA M 1.29 .62 .67 108023 HOLMSTROM, DWAYNE M 13,505.81 5,402.31 8,103.50 107868 HOLUB, JEAN A 685.97 328.69 357.28 108144 HOXTELL, BETH A 2,620.08 1,255.38 1,364.70 108030 JACKSON, TONYA M 12,365.70 4,946.30 7,419.40 107881 JANKOVICH, KIRSTEN E 1,375.89 659.22 716.67 107872 JARVIS, CHRISTOPHER S 2,294.99 1,099.64 1,195.35 108165 JENNRICH, GEORGE A 5,541.19 2,654.96 2,886.23 121659 J ERZAK, DANIEL P 405.60 194.35 211.25 121086 JOHNSON, BRUCE A 10,111.43 4,844.81 5,266.62 126270 JOHNSON, LUCAS J 837.56 335.02 502.54 120257 JOHNSON, MYCHAL D 12,343.19 4,937.28 7,405.91 121837 JONES, LISA L 1,754.19 840.48 913.71 110086 JONES, SARA 425.48 203.87 221.61 108147 JORANGER, JAMES A 569.25 272.76 296.49 118001 JORDAN, ERIK R 897.09 429.86 467.23 117548 JORDET, DANIEL A 12,157.81 5,825.16 6,332.65 116320 KARLSEN, SHERRY D 2,775.69 1,329.95 1,445.74 108128 KARLSON, GARY P 5,724.34 2,742.71 2,981.63 108005 KARRIS, STEVEN A 15,362.98 6,145.19 9,217.79 108151 KASSERA, CARRIE L 2,950.43 1,413.66 1,536.77 120970 KING, MICHAEL A 5,654.51 2,709.26 2,945.25 108024 KNIGHT, M ELON EY S 13,408.63 5,363.43 8,045.20 107758 KNUTSON, SHARON L 7,654.38 3,667.51 3,986.87 108081 KOEGL, MATTHEW 6,673.59 3,197.47 3,476.12 108007 KONCAR, WILLIAM F 13,943.25 5,577.31 8,365.94 107882 KROSCH, MEGHAN J 1,980.59 948.97 1,031.62 108003 LABATT, PEGGY J 14,402.28 5,760.92 8,641.36 107883 LABAU, KENNETH R 109.76 52.59 57.17 108148 LACHANCE, JOHN B 6,659.15 3,190.62 3,468.53 108117 LACROSSE, SUSAN L 7,452.00 3,570.48 3,881.52 108150 LAROSE, ROBERTA 6,586.24 3,155.66 3,430.58 R56DBA LOG20000 CITY OF BROOKLYN CENTER 3/25/2008 9:33:53 DBA By Employee Name DBA Detail History Report Page - 5 1/1/2007 - 12/31/2007 1100 1110 1210 1120 1220 Address Name Employee Total *PERA -Cord PERA- Cord -ER *PERA- Police PERA- Pol -ER *PERA -DCP PERA - DCP -ER 107983 LASMAN, KAY L 821.76 410.88 410.88 122477 LAWRENCE, STEVEN M 5,203.84 2,493.34 2,710.50 121839 LEE, TRACIE L 1,917.74 918.86 998.88 122478 LENT, ERIC G 255.57 122.46 133.11 116824 LEONHARDT, THOMAS A 7,686.54 3,682.93 4,003.61 120449 LOGAN, THOMAS 873.92 418.68 455.24 108134 LOOMIS, JAMES E 6,553.04 3,139.82 3,413.22 118690 LORENTZ, STEVEN J 13,695.52 5,478.22 8,217.30 122068 LUNDERBY, ALLEN D 433.07 207.49 225.58 125085 MANGIMELI, CARIN A G 456.71 218.84 237.87 108190 MARKLOWITZ, SUSAN M 1,515.80 726.28 789.52 108132 MARSH, MICHAEL K 6,504.06 3,116.30 3,387.76 122787 MARTIN, BRANDY N 3,204.82 1,535.65 1,669.17 107771 MARTIN, LAURENCE W 6,643.73 3,183.18 3,460.55 117070 MATTISON, DANIEL J 438.84 210.25 228.59 117069 MAY, KATHLEEN R 4, 593.64 2,200.96 2,392.68 107900 MCDONALD, DIANE M 340.54 163.18 177.36 108291 MCDONALD, JESSICA A 414.60 198.66 215.94 108191 MCDONALD, TAYLOR J 4,069.10 1,949.64 2,119.46 117071 MCGRATH, SHARON A 2,104.07 1,008.14 1,095.93 107901 MCGUIRE, SARAH J 240.26 115.12 125.14 108106 MEEHAN, DARRELL D 5,682.28 2,722.58 2,959.70 118608 MEISSNER, JOHN R 1,696.03 812.64 883.39 118745 MERTH, JOHN K 186.27 89.24 97.03 108028 MESSENBRINK, CLARK J 13,823.77 5,529.52 8,294.25 107877 MEYER, TARA S 4,660.02 2,232.81 2,427.21 108115 MICKELSON, DANNA J 4,392.40 2,104.53 2,287.87 108192 MILLER, BRUCE L 4,692.98 2,248.59 2,444.39 125705 MINOR, DWAIN S 43.22 20.71 22.51 123191 MOORE, JULIAN K 84.73 40.60 44.13 120280 MYLES, SUSAN M 6,935.96 3,323.24 3,612.72 108029 NADEAU, SCOTT L 16,716.39 6,686.61 10,029.78 121457 NAGBE, TODD S 2,136.83 1,023.81 1,113.02 108120 NELSON, DWAYNE A 3,873.55 1,855.95 2,017.60 108002 NELSON, RICK A 6,957.92 3,333.78 3,624.14 108195 NELSON, WILLARD R 538.18 257.88 280.30 R56DBA LOG20000 CITY OF BROOKLYN CENTER 3/25/2008 9:33:53 DBA By Employee Name DBA Detail History Report Page - 6 1/1/2007 - 12/31/2007 1100 1110 1210 1120 1220 Address Name Employee Total *PERA -Cord PERA- Cord -ER *PERA- Police PERA- Pol -ER *PERA -DCP PERA - DCP -ER 108196 NORENBERG, SHARON K 1,921.81 920.84 1,000.97 124675 NOVY, JESSIE L 446.13 213.77 232.36 118830 NOWACKI, TAMMYMARIE J 266.06 127.48 138.58 108136 NYLAND, JEFFREY A 7,228.97 3,463.65 3,765.32 108137 OXONEK, ROBERT A 6,520.20 3,123.99 3,396.21 125098 OLEK, MICHELLE S 53.53 25.65 27.88 107914 OLSON, RYAN D 84.41 40.43 43.98 108031 OLSON, TERRANCE N 12,449.98 4,979.96 7,470.02 108131 PAGE, PATRICIA A 4,927.62 2,360.92 2,566.70 108032 PASTOR, STEPHEN M 15,024.63 6,009.84 9,014.79 108033 PEARSON, MONA J 15,684.11 6,273.66 9,410.45 108058 PEASLEY, TROY M 13,320.56 5,328.21 7,992.35 111319 PETERS, BRIAN P 14,498.21 5,799.30 8,698.91 107780 PETERSON, DAVID L 9,777.39 4,684.71 5,092.68 118252 PETERSON, MICHAEL A 13,022.59 5,209.03 7,813.56 108175 PFAN N, J EAN N I N E L 4,870.81 2,333.80 2,537.01 108153 PHILLIPS, AMY D 3,989.14 1,911.33 2,077.81 108035 POTTER, KIMBERLY A 13,234.23 5,293.69 7,940.54 107922 PREBLE, TANYA R 342.30 164.01 178.29 125302 PULLUM, DARNITA 25.19 12.07 13.12 108060 RASMUSSEN, PATRICIA A 2,444.75 1,171.38 1,273.37 108036 RATAJCZYK, JOHN D 13,623.88 5,449.55 8,174.33 108124 REI N KI NG, MARK W 6, 022.27 2, 885.46 3,136.81 107987 REMJESKE, SUSAN L 4,636.51 2,221.46 2,415.05 108009 REYNOLDS, MICHAEL J 16,963.39 6,785.35 10,178.04 108101 RICE, SUSAN J 4,992.74 2,392.17 2,600.57 108213 RIETSCHEL, JOANNE C 253.71 121.57 132.14 116123 RIMER, RICHARD J 140.01 67.06 72.95 118911 RISING, SHANNON M 9.49 4.55 4.94 120997 ROBINSON, LYNESHIA F 119.71 57.35 62.36 108037 ROBINSON, STUART D 15,923.49 6,369.39 9,554.10 122280 ROCKWELL, LESLIE S 584.65 280.10 304.55 108038 ROGNSTAD, CHRISTOPHER A 12,585.40 5,034.14 7,551.26 108200 ROSS, BONNIE J 921.82 441.70 480.12 108393 ROSS, JULIE R 1, 340.40 642.27 698.13 108039 ROTH, FRANK J 15,765.65 6,306.27 9,459.38 R56DBA LOG20000 CITY OF BROOKLYN CENTER 3/25/2008 9:33:53 DBA By Employee Name DBA Detail History Report Page - 7 1/1/2007 - 12/31/2007 1100 1110 1210 1120 1220 Address Name Employee Total *PERA -Cord PERA- Cord -ER *PERA- Police PERA- Pol -ER *PERA -DCP PERA - DCP -ER 121788 RUED, JOHN P 6,205.58 2,973.31 3,232.27 123220 SCHLEUNING, VICKIE S 3,492.80 1,673.63 1,819.17 107763 SCHLOSSER, MICHAEL G 6,750.74 3,234.53 3,516.21 124676 SCHMIDT, CORY J 537.03 257.32 279.71 108201 SCHMIDT, MICHAEL A 2,772.22 1,328.27 1,443.95 108154 SCHOLL, EDWARD F 1,003.21 480.66 522.55 123193 SCHOLL, TODD E 120.32 57.65 62.67 117825 SCH U LTZ, CAROLINE M 298.96 143.26 155.70 108040 SCHULTZ, JAMES A 13,227.20 5,290.89 7,936.31 108102 SCHWANINGER, SHELLEY A 5,726.83 2,743.92 2,982.91 108216 SMART, REGGIE S 5,445.85 2,609.27 2,836.58 108214 SMITH, CHERYL L 232.62 111.44 121.18 123171 SNELL, STEPHANIE L 796.49 381.65 414.84 108088 SORBY, GENE 5,341.64 2,559.35 2,782.29 118607 SOUTHAVILAY, ANTHONY N 144.16 69.05 75.11 108176 SPAH, MARY J 5,841.17 2,798.70 3,042.47 108202 ST DRYDEN, BONNIE L 6,116.12 2,930.47 3,185.65 108217 STADT, KEITH A 6,163.35 2,953.08 3,210.27 108156 SWANSON, TERRI J 19.93 9.53 10.40 107947 SYSLO, VICTORIA T 347.94 166.70 181.24 116940 TEACHOUT, SHAREE L 190.26 91.16 99.10 111624 TOO H EY, PATRICK A 13, 327.15 5,330.86 7,996.29 122282 TORRES, ROBERT M 517.87 248.13 269.74 108041 TRAXLER, ROBERT R 13,364.63 5,345.85 8,018.78 108042 TROUT, JOSEPH P 12,229.78 4,891.89 7,337.89 108206 TRUESDALE, MICHAEL D 4,083.91 1,956.72 2,127.19 107954 ULMER DE RAMIREZ, NATALIE B 1,293.62 619.82 673.80 108001 VALKER, DAVID F 6,923.84 3,317.44 3,606.40 108043 VALLEAU, CHARLES D 15,394.14 6,157.67 9,236.47 121775 VANG, THAO 827.81 396.65 431.16 116060 VESEY, BRETT T 3,344.04 611.85 665.21 826.80 1,240.18 108125 VETTER, WILLIAM J 5,755.51 2,757.65 2,997.86 108100 WALL, KAREN E 6,322.97 3,029.60 3,293.37 107998 WARREN, RONALD A 8,431.06 4,039.61 4,391.45 123245 WEIS, MARTIN 86.81 41.60 45.21 114389 WERNER, MICHAEL C 944.81 452.72 492.09 R56DBA LOG20000 CITY OF BROOKLYN CENTER 3/25/2008 9:33:53 DBA By Employee Name DBA Detail History Report Page - 8 1/1/2007 - 12/31/2007 1100 1110 1210 1120 1220 Address Name Employee Total *PERA -Cord PERA- Cord -ER *PERA- Police PERA- Pol -ER *PERA -DCP PERA - DCP -ER 108276 WESSMAN, PENNY L 124.95 59.87 65.08 108108 WHITING, JENNIFER K 4,636.51 2,221.46 2,415.05 121833 WHITTENBURG, JEREMY A 3,696.57 800.82 870.58 810.07 1,215.10 107996 WICK, KELLI K 10,093.34 4,836.07 5,257.27 108207 WILLIAMS, DAVID K 778.07 372.67 405.40 121838 WILLIAMS, MOLLY E 1,579.95 757.00 822.95 108123 WILLIAMS, STEVE J 5,764.51 2,761.96 3,002.55 107973 WILSON, KELLY M 837.46 401.24 436.22 107761 WOJCIK, NANCY J 10,296.27 4,933.24 5,363.03 108044 WONG, CARLOS A 10,681.86 4,272.74 6,409.12 120984 WORLEY, ANNA C 5,202.12 2,492.54 2,709.58 121840 XU, QIAN TING 224.96 107.77 117.19 121836 YARPHEL, SONAM T 1,647.30 789.12 858.18 122544 YELICH, MARK A 821.76 410.88 410.88 Report Totals 1,379,407.97 361,077.33 392,527.61 249,664.07 374,495.44 821.76 821.76 R55GLACT BC26000VO Activity by Co (pb), Subledger CITY OF BROOKLYN CENTER 4/15/2008 12:23:22 Ledger AA General Ledger Activity Page - 1 Business Unit 1/1/2007 - 12/31/2007 Object 6135 U Doc Doc No GL Date Rec /Ck# Account Number Description Debit Amount Credit Amount GL Explanation / Remark Address Name 70300 EMPLOYEE RETIREMENT BENEFIT FD Subledger 49961 EMPLOYEE RETIREMENT BENEFI FD PV 63674 1/18/2007 130825 49961 -6135 MEDICAL INSURANCE - RETIREES 6,070.06 JAN INS PREM 102944 MEDICA PV 63674 1/18/2007 130825 49961 -6135 MEDICAL INSURANCE - RETIREES 486.88 JAN INS PREM 102944 MEDICA PV 64368 2/8/2007 131203 49961 -6135 MEDICAL INSURANCE - RETIREES 6,489.78 FEB INS PREM 102944 MEDICA PV 64368 2/8/2007 131203 49961 -6135 MEDICAL INSURANCE - RETIREES 486.88 FEB INS PREM 102944 MEDICA PV 65319 3/8/2007 131677 49961 -6135 MEDICAL INSURANCE - RETIREES 6,976.66 MARCH INS PREM 102944 MEDICA PV 66154 3/29/2007 132052 49961 -6135 MEDICAL INSURANCE - RETIREES 6,976.66 APRIL INS PREM 102944 MEDICA PV 67354 5/3/2007 132659 49961 -6135 MEDICAL INSURANCE - RETIREES 6,976.66 MAY INS PREM 102944 MEDICA PV 68660 6/7/2007 133282 49961 -6135 MEDICAL INSURANCE - RETIREES 6,976.66 JUNE INS PREM 102944 MEDICA PV 70032 7/12/2007 133973 49961 -6135 MEDICAL INSURANCE - RETIREES 6,976.66 JULY INS PREM 102944 MEDICA PV 71191 8/9/2007 134529 49961 -6135 MEDICAL INSURANCE - RETIREES 7,950.42 AUG INS PREM 102944 MEDICA PV 72727 9/20/2007 135311 49961 -6135 MEDICAL INSURANCE - RETIREES 6,976.66 SEPT INS PREM 102944 MEDICA PV 73865 10/18/2007 135840 49961 -6135 MEDICAL INSURANCE - RETIREES 7,463.54 OCT INS PREM 102944 MEDICA PV 74634 11/8/2007 136214 49961 -6135 MEDICAL INSURANCE - RETIREES 8,437.30 NOV INS PREM 102944 MEDICA PV 75797 12/13/2007 136752 49961 -6135 MEDICAL INSURANCE - RETIREES 7,463.54 DEC INS PREM 102944 MEDICA JE 56939 12/31/2007 49961 -6135 MEDICAL INSURANCE - RETIREES 35,954.00 ADJUST OPEB LIAB ILITY 49961 -6135 Total 86,708.36 35,954.00 50,754.36 Net 49961 EMPLOYEE RETIREMENT BENEFIT FD 86,708.36 35,954.00 50,754.36 Net Total 86,708.36 35,954.00 50,754.3 Net 70300 EMPLOYEE RETIREMENT BENEFIT FD 86,708.36 35,954.00 50,754.36 Net City of Brooklyn Center Retirement Activity December 31, 2007 Adjustment Allocation 12131/2006 12/31/2007 needed basis Cash 1 1 (5 Accounts receivable 423 734 311 Insurance payable (2 (2 35 Unrestricted 1, 051, 756 1 (30 0 0 Interest & IGR (81 General government 0 0.00% Public safety 69749 80.44% 6,002.90 Public works 5 6.52% 486.88 Economic Development 5 6.52% 486.88 Liquor 5 6.52% 486.88 7,463.54 General government (2 Public safety (22 Public works (2 Parks and recreation (5 economic development (399) liquor (255) ebhc (680) water (665) 0 867708 City of Brooklyn Center Twin Lakes Business Park Amended TIF Note Dated May 26, 2002 Beginning Interest Date Principal at 8.0% Payments Ending Balance 360 Day Yr Balance May 28 , 2002 2 - 1 'i �aa�zQ 99 June 12, 2002 $ 2 August 1, 2002 25 August 7, 2002 68, 091.79 2, 381, 965.33 February 1, 2003 95 68, 091.81 2 August 1, 2003 95, 278.62 120, 396.70 2, 384, 034.06 February 1, 2004 94, 814.99 120, 396.78 2 August 1, 2004 94 111,115.92 2 February 1, 2005 93 103 2 February 28, 2005 7 2 August 1, 2005 92 126 2 February 1, 2006 91 126 2 August 1, 2006 90 126 2 February 1, 2007 88, 835.54 111 2,198, 590.56 August 1, 2007 87, 943.62 134, 942.16 2,151, 592.02