Finance Committee Agenda and Packet 2012 04 16

Home Browse Search

of Period 739.20 ( 1,395.45) 2,530.81 739.20 ( 312.09) Interest Earned during Period 739.20 2,957.92 Total Interest Earned during Period Total Adjustments from Premiums and Discounts Total Capital Gains or Losses Total Earnings during Period 24,393.15 -4,160.04 0.00 76,756.57 -13,184.22 572.50 20,233.11 64,144.85 Portfolio LSVL Data Updated: FUNDSNAP: 04/09/2012 10:27 AP Run Date: 04/09/2012 -10:27 No fiscal year history available PM (PRF_PM6) SymRept 6.42 76 City of Louisville Amortization Schedule Davidson Fixed Income Mgmt March 1, 2012 -March 31, 2012 Sorted By Fund -Fund Original Premium or Discount Maturity Date Current Rate Beginning Par Value Ending Book Value Amount Amortized Fund Amort. Date This Period Amounts Amortized And Unamortized As of 03/01/2012 Amt Amortized Through 03/31/2012 Amount Unamortized Through 03/31/2012 Investment # Issuer Purchase Principal City of Louisville LS0080 1,000,000.00 3,000.00 2.250 04/24/2012 1,000,060.58 -2,860.40 139.60 100 1,003,000.00 -79.02 60.58 FFCB -2,939.42 LS0085 1,000,000.00 30,670.00 4.250 12/04/2012 1,004,236.96 -25,909.96 4,760.04 100 1,030,670.00 -523.08 4,236.96 FFCB -26,433.04 LSVL0330 1,000,000.00 -1,500.00 0.970 03/21/2016 998,501.05 0.00 -1,500.00 100 998,500.00 1.05 -1,498.95 FFCB (Callable -Cont.) 1.05 LS0075 1,000,000.00 59,810.00 5.000 03/09/2012 0.00 -59,489.73 320.27 100 1,059,810.00 -320.27 0.00 FHLB -59,810.00 LSVL0300 1,500,000.00 -150.00 0.400 02/28/2014 1,499,856.68 0.42 -149.58 100 1,499,850.00 6.26 -143.32 FHLB (Callable -NC1yr 1X) 6.68 LS0225 1,000,000.00 -820.00 0.625 10/30/2012 999,699.33 476.18 -343.82 100 999,180.00 43.15 -300.67 FHLMC 519.33 LSVL0280 1,500,000.00 20,640.00 1.000 08/27/2014 1,519,882.36 -68.88 20,571.12 100 1,520,640.00 -688.76 19,882.36 FHLMC -757.64 LSVL0320 1,500,000.00 5,046.00 0.625 12/23/2013 1,504,950.49 0.00 5,046.00 100 1,505,046.00 -95.51 4,950.49 FHLMC -95.51 LSVL0290 1,500,000.00 -3,000.00 0.550 02/27/2015 1,497,091.75 8.34 -2,991.66 100 1,497,000.00 83.41 -2,908.25 FHLMC (Callable-NC2yr1X) 91.75 LSVL0305 1,500,000.00 -750.00 0.750 09/28/2015 1,499,251.79 0.00 -750.00 100 1,499,250.00 1.79 -748.21 FHLMC (Callable-NC2yr1X) 1.79 LS0115 1,000,000.00 82,100.00 4.375 07/17/2013 1,023,689.54 -56,885.39 25,214.61 100 1,082,100.00 -1,525.07 23,689.54 FNMA -58,410.46 LS0155 1,500,000.00 165.00 1.250 06/22/2012 1,500,017.07 -141.61 23.39 100 1,500,165.00 -6.32 17.07 FNMA -147.93 LS0190 1,500,000.00 -375.00 1.050 09/03/2013 1,499,822.22 186.81 -188.19 100 1,499,625.00 10.41 -177.78 FNMA 197.22 LS0205 1,000,000.00 19,670.00 1.750 02/22/2013 1,008,407.55 -10,476.70 9,193.30 100 1,019,670.00 -785.75 8,407.55 FNMA -11,262.45 LS0220 1,000,000.00 4,100.00 1.250 08/20/2013 1,002,283.37 -1,679.35 2,420.65 100 1,004,100.00 -137.28 2,283.37 FNMA -1,816.63 LSVL0260 1,000,000.00 8,320.00 1.300 11/17/2014 1,006,542.58 -1,569.94 6,750.06 100 1,008,320.00 -207.48 6,542.58 FNMA -1,777.42 LSVL0285 1,000,000.00 6,190.00 0.750 12/19/2014 1,005,982.04 -24.47 6,165.53 100 1,006,190.00 -183.49 5,982.04 FNMA -207.96 Portfolio LSVL Data Updated: FUNDSNAP: 04/09/2012 10:27 AP Run Date: 04/09/2012 -10:27 No fiscal year history available AS (PRF_ASW) SymRept 6.42 Report Ver. 5.00 77 Original Premium or Discount Maturity Date Current Rate March 1, 2012 -March 31, 2012 Beginning Par Value Ending Book Value Amount Amortized Fund Amort. Date This Period Amortization Schedule Page 2 City of Louisville Amounts Amortized And Unamortized As of 03/01/2012 Amt Amortized Through 03/31/2012 Amount Unamortized Through 03/31/2012 Investment # Issuer Purchase Principal City of Louisville LSVL0325 1,000,000.00 23,970.00 1.500 09/08/2014 1,023,888.28 0.00 23,970.00 100 1,023,970.00 -81.72 23,888.28 FNMA -81.72 LSVL0275 1,000,000.00 -1,500.00 0.300 03/07/2012 0.00 1,450.00 -50.00 100 998,500.00 50.00 0.00 GEN ELEC CAP CRP 1,500.00 LSVL0310 1,000,000.00 -2,391.11 0.320 12/07/2012 997,777.78 0.00 -2,391.11 100 997,608.89 168.89 -2,222.22 GEN ELEC CAP CRP 168.89 LSVL0295 1,000,000.00 -2,031.25 0.125 09/30/2013 998,081.01 3.51 -2,027.74 100 997,968.75 108.75 -1,918.99 US T-NOTE 112.26 Subtotal 251,163.64 22,590,022.43 -156,981.17 -4,160.04 94,182.47 24,751,163.64 -161,141.21 90,022.43 251,163.64 22,590,022.43 -156,981.17 -4,160.04 94,182.47 Total 24,751,163.64 -161,141.21 90,022.43 Portfolio LSVL Data Updated: FUNDSNAP: 04/09/2012 10:27 AP Run Date: 04/09/2012 -10:27 No fiscal year history available AS (PRF_ASW) SymRept 6.42 Report Ver. 5.00 78 City of Louisville GASB 40 Report Sorted by Fund Davidson Fixed Income Mgmt Through 03/31/2012 Security ID Issuer Book Value Par Value Market Value Current Yield Duration Days to Modified S&P Moody's Reported Value Maturity Date Maturity Investment # % of Portfolio City of Louisville SYSLS0002 LS0002 CSAFE 580,337.80 580,337.80 580,337.80 580,337.80 AAAM Aaa 2.00 0.200 1 0.000 31331GNQ8 LS0080 FFCB 1,000,000.00 1,000,060.58 1,001,264.00 1,001,264.00 AA+ Aaa 3.44 1.995 23 04/24/2012 0.063 31398AP71 LS0155 FNMA 1,500,000.00 1,500,017.07 1,503,663.00 1,503,663.00 AA+ Aaa 5.17 0.760 82 06/22/2012 0.224 3134G1VG6 LS0225 FHLMC 1,000,000.00 999,699.33 1,002,509.00 1,002,509.00 AA+ Aaa 3.45 0.192 212 10/30/2012 0.578 31331YGE4 LS0085 FFCB 1,000,000.00 1,004,236.96 1,027,316.00 1,027,316.00 AA+ Aaa 3.53 0.199 247 12/04/2012 0.663 36959HM79 LSVL0310 GEN ELEC CAP CRP 1,000,000.00 997,777.78 997,777.78 997,777.78 A-1+ P-1 3.43 0.325 250 12/07/2012 0.683 31398AE24 LS0205 FNMA 1,000,000.00 1,008,407.55 1,013,147.00 1,013,147.00 AA+ Aaa 3.48 0.273 327 02/22/2013 0.886 31359MSL8 LS0115 FNMA 1,000,000.00 1,023,689.54 1,051,962.00 1,051,962.00 AA+ Aaa 3.62 0.349 472 07/17/2013 1.261 3134G2SQ6 LSVL0255 FHLMC (StrNt -Callable 1x) 1,300,000.00 1,300,000.00 1,299,968.80 1,299,968.80 AA+ Aaa 4.47 0.402 481 07/26/2013 1.311 31398AX31 LS0220 FNMA 1,000,000.00 1,002,283.37 1,012,434.00 1,012,434.00 AA+ Aaa 3.48 0.350 506 08/20/2013 1.374 31398A3A8 LS0190 FNMA 1,500,000.00 1,499,822.22 1,512,807.00 1,512,807.00 AA+ Aaa 5.20 0.447 520 09/03/2013 1.411 912828RK8 LSVL0295 US T-NOTE 1,000,000.00 998,081.01 997,460.94 997,460.94 AA+ Aaa 3.43 0.295 547 09/30/2013 1.494 313373ME9 LSVL0235 FHLB (Callable -NC1yr 1X) 1,000,000.00 1,000,000.00 1,000,517.00 1,000,517.00 AA+ Aaa 3.44 0.967 572 10/25/2013 1.544 3134G3BF6 LSVL0320 FHLMC 1,500,000.00 1,504,950.49 1,505,727.00 1,505,727.00 AA+ Aaa 5.18 0.403 631 12/23/2013 1.715 313378H87 LSVL0300 FHLB (Callable -NC1yr 1X) 1,500,000.00 1,499,856.68 1,499,886.00 1,499,886.00 AA+ Aaa 5.16 0.404 698 02/28/2014 1.898 313378QE4 LSVL0315 FHLB (Callable -Cont.) 1,500,000.00 1,500,000.00 1,502,700.00 1,502,700.00 AA+ Aaa 5.17 0.409 726 03/28/2014 1.980 31331KKQ2 LSVL0240 FFCB 1,000,000.00 1,000,000.00 1,009,603.00 1,009,603.00 AA+ Aaa 3.47 0.692 771 05/12/2014 2.078 3136FRPJ6 LSVL0265 FNMA (StrNt -Callable 1x) 1,000,000.00 1,000,000.00 1,000,753.00 1,000,753.00 AA+ Aaa 3.44 0.541 796 06/06/2014 2.164 3137EACV9 LSVL0280 FHLMC 1,500,000.00 1,519,882.36 1,519,395.00 1,519,395.00 AA+ Aaa 5.23 0.459 878 08/27/2014 2.375 31398A3G5 LSVL0325 FNMA 1,000,000.00 1,023,888.28 1,019,849.00 1,019,849.00 AA+ Aaa 3.51 0.677 890 09/08/2014 2.391 3136FPWZ6 LSVL0260 FNMA 1,000,000.00 1,006,542.58 1,019,006.00 1,019,006.00 AA+ Aaa 3.50 0.570 960 11/17/2014 2.573 3135G0FY4 LSVL0285 FNMA 1,000,000.00 1,005,982.04 1,004,335.00 1,004,335.00 AA+ Aaa 3.45 0.589 992 12/19/2014 2.680 3134G3PD6 LSVL0290 FHLMC (Callable-NC2yr1X) 1,500,000.00 1,497,091.75 1,498,345.50 1,498,345.50 AA+ Aaa 5.15 0.588 1,062 02/27/2015 2.877 3134G3SD3 LSVL0305 FHLMC (Callable-NC2yr1X) 1,500,000.00 1,499,251.79 1,498,293.00 1,498,293.00 AA+ Aaa 5.15 0.783 1,275 09/28/2015 3.439 3133EAJA7 LSVL0330 FFCB (Callable -Cont.) 1,000,000.00 998,501.05 1,001,732.00 1,001,732.00 AA+ Aaa 3.45 0.926 1,450 03/21/2016 3.887 Subtotal 28,880,337.80 28,970,360.23 29,080,788.82 29,080,788.82 100.00 0.552 638 1.728 Portfolio LSVL AP Page 1 Data Updated: FUNDSNAP: 04/09/2012 10:27 Run Date: 04/09/2012 -10:27 G4 (PRF_G4) SymRept 6.42 Report Ver. 5.00 79 Report Total 28,880,337.80 28,970,360.23 29,080,788.82 29,080,788.82 100.00 0.552 639 1.72828 80 COUNCIL COMMUNICATION TO: MAYOR AND CITY COUNCIL FROM: MALCOLM FLEMING CITY MANAGER DATE: APRIL 16, 2012 SUBJECT: LIST OF BILLS SCHEDULED FOR COUNCIL APPROVAL ON APRIL 17, 2012 ORIGINATING DEPARTMENT: FINANCE SUMMARY: Attached is the list of bills scheduled for Council approval at the April 17, 2012 regular Council Meeting. SUBJECT Lis t of Bill s AGENDA ITEM 81 03/29/12 09:12:15 BATCH: 78706 City of Louisville Page 1 ap215-ls PERIOD:03/29/12 CASH DISBURSEMENTS EDIT dianek FOR BANK ACCOUNT: 4 FIRST NATIONAL BANK OF COLORADO Control Disbursement Account Inv No. Description Inv Dt Due Dt Disc Dt Inv Amt Disc Amt Pay Amt Check Amt ------------------------------------------------------------------------------------------------------------------ -----------------6272 BOULDER CTY CLERK & RECORDER 032212 RECORD FEES MAINT AG 03/22/12 04/21/12 03/22/12 70.00 .00 70.00 70.00 13250 CPHRA 032712 2012 MEMBERSHIP DUES 03/27/12 04/26/12 03/27/12 150.00 .00 150.00 150.00 9750 LEGALSHIELD 032512 #22554 MAR 12 EMPLOY 03/25/12 04/24/12 03/25/12 233.25 .00 233.25 233.25 7735 LINCOLN FINANCIAL GROUP LIFE0412 000010008469 APR 12 04/01/12 05/01/12 04/01/12 4,442.66 .00 4,442.66 LTD0412 000010008470 APR 12 04/01/12 05/01/12 04/01/12 2,716.06 .00 2,716.06 7,158.72 7 AARON DEJONG 031712 TRAVEL REIMBURSE ECO 03/17/12 04/16/12 03/17/12 1,653.54 .00 1,653.54 1,653.54 7 JUDI KELLER 032112 TRAVEL REIMBURSE ECO 03/21/12 04/20/12 03/21/12 204.82 .00 204.82 204.82 4 GLENN E HERRMANN MD PC 032212 REFUND DUPLICATE STX 03/22/12 04/21/12 03/22/12 25.00 .00 25.00 25.00 3735 PETTY CASH -TERRY WATSON 032312 PETTY CASH FRONT DES 03/23/12 04/22/12 03/23/12 308.95 .00 308.95 032312 PETTY CASH FRONT DES 03/23/12 04/22/12 03/23/12 12.21 .00 12.21 032312 PETTY CASH FRONT DES 03/23/12 04/22/12 03/23/12 12.21 .00 12.21 032312 PETTY CASH FRONT DES 03/23/12 04/22/12 03/23/12 16.00 .00 16.00 032312 PETTY CASH FRONT DES 03/23/12 04/22/12 03/23/12 66.00 .00 66.00 415.37 55 BOULDER CREEK TAKODA LLC U!00000771 17168:UTILITY REFUND 03/23/12 03/23/12 03/23/12 11.63 .00 11.63 U!00000771 17168:UTILITY REFUND 03/23/12 03/23/12 03/23/12 13.56 .00 13.56 U!00000771 17168:UTILITY REFUND 03/23/12 03/23/12 03/23/12 3.87 .00 3.87 29.06 55 RYLAND HOMES U!00000772 17249:UTILITY REFUND 03/23/12 03/23/12 03/23/12 14.36 .00 14.36 U!00000772 17249:UTILITY REFUND 03/23/12 03/23/12 03/23/12 16.76 .00 16.76 U!00000772 17249:UTILITY REFUND 03/23/12 03/23/12 03/23/12 4.78 .00 4.78 U!00000772 17249:UTILITY REFUND 03/23/12 03/23/12 03/23/12 14.36 .00 14.36 50.26 55 RYLAND HOMES U!00000773 17305:UTILITY REFUND 03/23/12 03/23/12 03/23/12 7.43 .00 7.43 U!00000773 17305:UTILITY REFUND 03/23/12 03/23/12 03/23/12 8.67 .00 8.67 U!00000773 17305:UTILITY REFUND 03/23/12 03/23/12 03/23/12 2.48 .00 2.48 U!00000773 17305:UTILITY REFUND 03/23/12 03/23/12 03/23/12 7.43 .00 7.43 26.01 82 03/29/12 09:12:15 BATCH: 78706 City of Louisville Page 2 ap215-ls PERIOD:03/29/12 CASH DISBURSEMENTS EDIT dianek FOR BANK ACCOUNT: 4 FIRST NATIONAL BANK OF COLORADO Control Disbursement Account Inv No. Description Inv Dt Due Dt Disc Dt Inv Amt Disc Amt Pay Amt Check Amt ------------------------------------------------------------------------------------------------------------------ -----------------55 RYLAND HOMES U!00000774 17233:UTILITY REFUND 03/27/12 03/27/12 03/27/12 4.28 .00 4.28 U!00000774 17233:UTILITY REFUND 03/27/12 03/27/12 03/27/12 23.69 .00 23.69 U!00000774 17233:UTILITY REFUND 03/27/12 03/27/12 03/27/12 7.29 .00 7.29 U!00000774 17233:UTILITY REFUND 03/27/12 03/27/12 03/27/12 4.28 .00 4.28 39.54 55 LOUISVILLE DENTAL ASSOC U!00000775 4535:UTILITY REFUND 03/29/12 03/29/12 03/29/12 28.70 .00 28.70 U!00000775 4535:UTILITY REFUND 03/29/12 03/29/12 03/29/12 33.49 .00 33.49 U!00000775 4535:UTILITY REFUND 03/29/12 03/29/12 03/29/12 9.56 .00 9.56 71.75 8442 VISION SERVICE PLAN VSP0412 12 059727 0001 APR 1 03/20/12 04/19/12 03/20/12 2,464.38 .00 2,464.38 2,464.38 -----------------------------------------------TOTAL PAYMENTS 12,591.70 .00 12,591.70 12,591.70 83 04/05/12 11:04:19 BATCH: 78799 City of Louisville Page 1 ap215-ls PERIOD:04/05/12 CASH DISBURSEMENTS EDIT dianek FOR BANK ACCOUNT: 4 FIRST NATIONAL BANK OF COLORADO Control Disbursement Account Inv No. Description Inv Dt Due Dt Disc Dt Inv Amt Disc Amt Pay Amt Check Amt ------------------------------------------------------------------------------------------------------------------ -----------------13640 CHILD SUPPORT ENFORCE OFFICE 033012 EMPLOYEE GARNISHMENT 03/30/12 04/29/12 03/30/12 255.23 .00 255.23 255.23 5255 FAMILY SUPPORT REGISTRY 033012 EMPLOYEE GARNISHMENT 03/30/12 04/29/12 03/30/12 202.38 .00 202.38 202.38 12819 FRANCOTYP-POSTALIA INC 101014213 POSTAGE METER AGREEM 03/13/12 04/12/12 03/13/12 599.40 .00 599.40 599.40 13185 MACHOL & JOHANNES LLC 033012 EMPLOYEE GARNISHMENT 03/30/12 04/29/12 03/30/12 46.44 .00 46.44 46.44 5399 RECREONICS INC 517888 LIFEGUARD CHAIR DEPO 03/30/12 04/29/12 03/30/12 4,603.99 .00 4,603.99 4,603.99 12712 UNITED STATES TREASURY 033012 EMPLOYEE GARNISHMENT 03/30/12 04/29/12 03/30/12 112.50 .00 112.50 112.50 55 TRANSWESTERN U!00000776 9804:UTILITY REFUND 04/04/12 04/04/12 04/04/12 11.40 .00 11.40 11.40 -----------------------------------------------TOTAL PAYMENTS 5,831.34 .00 5,831.34 5,831.34 84 04/12/12 09:12:15 BATCH: 78866 City of Louisville Page 1 ap215-ls PERIOD:04/12/12 CASH DISBURSEMENTS EDIT dianek FOR BANK ACCOUNT: 4 FIRST NATIONAL BANK OF COLORADO Control Disbursement Account Inv No. Description Inv Dt Due Dt Disc Dt Inv Amt Disc Amt Pay Amt Check Amt ------------------------------------------------------------------------------------------------------------------ -----------------11264 CDPHE 031312 NORTH END LIFT STATI 03/13/12 04/12/12 03/13/12 3,700.00 .00 3,700.00 031312-1 N END LIFT STATION A 03/13/12 04/12/12 03/13/12 5,804.00 .00 5,804.00 9,504.00 4206 GOODYEAR TIRE & RUBBER CO 900014979 TIRES PD 03/30/12 04/29/12 03/30/12 4,856.70 .00 4,856.70 4,856.70 22 DAVID WIEH 2865 STEEL TOE BOOTS 04/09/12 05/09/12 04/09/12 74.99 .00 74.99 74.99 3815 POSTMASTER 033012 BULK MAIL PERMIT #15 03/30/12 04/29/12 03/30/12 190.00 .00 190.00 190.00 -----------------------------------------------TOTAL PAYMENTS 14,625.69 .00 14,625.69 14,625.69 85 04/12/12 07:40:37 BATCH: 78863 City of Louisville Page 1 ap215-ls PERIOD:04/17/12 CASH DISBURSEMENTS EDIT dianek FOR BANK ACCOUNT: 4 FIRST NATIONAL BANK OF COLORADO Control Disbursement Account Inv No. Description Inv Dt Due Dt Disc Dt Inv Amt Disc Amt Pay Amt Check Amt ------------------------------------------------------------------------------------------------------------------ -----------------4630 3M COMPANY OF51292 SERVICE AGREEMENT LI 03/13/12 04/12/12 03/13/12 12,265.00 .00 12,265.00 12,265.00 1 A WAY OF LIFE FITNESS CONSULT 1217001-2 CONTRACTOR FEES WEIG 04/19/12 05/19/12 04/19/12 361.20 .00 361.20 361.20 8791 ACA DENVER BOILER C641322 HVAC PREVENTIVE MAIN 03/07/12 04/06/12 03/07/12 505.25 .00 505.25 C641323 HVAC PREVENTIVE MAIN 03/07/12 04/06/12 03/07/12 220.25 .00 220.25 C641324 HVAC PREVENTIVE MAIN 03/07/12 04/06/12 03/07/12 365.50 .00 365.50 1,091.00 5369 ACCUTEST MOUNTAIN STATES INC D3-24755 LAB ANALYSIS FEES IP 03/21/12 04/20/12 03/21/12 284.00 .00 284.00 D3-24756 LAB ANALYSIS FEES 03/21/12 04/20/12 03/21/12 378.00 .00 378.00 D3-24757 LAB ANALYSIS FEES 03/21/12 04/20/12 03/21/12 44.00 .00 44.00 D3-24758 LAB ANALYSIS FEES 03/21/12 04/20/12 03/21/12 15.00 .00 15.00 721.00 11249 AGGREGATE INDUSTRIES WR INC 703398361 ASPHALT 03/19/12 04/18/12 03/19/12 49.00 .00 49.00 703407630 ASPHALT 03/26/11 04/25/11 03/26/11 49.00 .00 49.00 98.00 1006 ALL CURRENT ELECTRIC INC 2630 INSTALL OUTSIDE RECE 03/29/12 04/28/12 03/29/12 125.24 .00 125.24 2633 ELECTRICAL WORK LIB 04/03/12 05/03/12 04/03/12 447.50 .00 447.50 572.74 9319 AMERICAN DATA GROUP INC 8864 HP9050 PRINTER SIGNA 03/30/12 04/29/12 03/30/12 310.00 .00 310.00 310.00 6113 AMERICAN TRAFFIC SAFETY SERV 90053998 TRAFFIC CONTROL RECE 02/27/12 03/28/12 02/27/12 125.00 .00 125.00 125.00 12162 ANALYTICA GROUP 134248 MONTHLY TESTING 03/22/12 04/21/12 03/22/12 1,924.00 .00 1,924.00 134253 MONTHLY TESTING 03/23/12 04/22/12 03/23/12 149.00 .00 149.00 134435 MONTHLY BACTERIA TES 03/28/12 04/27/12 03/28/12 126.00 .00 126.00 134661 MONTHLY BACTERIA TES 03/28/12 04/27/12 03/28/12 126.00 .00 126.00 134678 MONTHLY TESTING 04/05/12 05/05/12 04/05/12 630.00 .00 630.00 2,955.00 1192 ARBOR OCCUPATIONAL MEDICINE 6094 PHYSICAL/DRUG SCREEN 04/02/12 05/02/12 04/02/12 135.00 .00 135.00 135.00 13614 ATKINS NORTH AMERICA INC 1136714 HWY42 STATION/CORRID 03/26/12 04/25/12 03/26/12 38,855.15 .00 38,855.15 38,855.15 7636 BAKER AND TAYLOR-CONT ACCT 5011871406 ADULT REFERENCE CONT 02/23/12 03/24/12 02/23/12 92.13 .00 92.13 5011871407 ADULT REFERENCE CONT 02/23/12 03/24/12 02/23/12 51.84 .00 51.84 86 04/12/12 07:40:37 BATCH: 78863 City of Louisville Page 2 ap215-ls PERIOD:04/17/12 CASH DISBURSEMENTS EDIT dianek FOR BANK ACCOUNT: 4 FIRST NATIONAL BANK OF COLORADO Control Disbursement Account Inv No. Description Inv Dt Due Dt Disc Dt Inv Amt Disc Amt Pay Amt Check Amt ------------------------------------------------------------------------------------------------------------------ -----------------5011871408 ADULT REFERENCE CONT 02/23/12 03/24/12 02/23/12 36.61 .00 36.61 5011871409 ADULT REFERENCE CONT 02/23/12 03/24/12 02/23/12 35.75 .00 35.75 5011880856 ADULT REFERENCE CONT 02/29/12 03/30/12 02/29/12 57.93 .00 57.93 274.26 8049 BATES ENGINEERING INC 031712 3MG TANK SHORING CON 03/17/12 04/16/12 03/17/12 1,155.00 .00 1,155.00 031712A 3MG TANK STRUCTURAL 03/17/12 04/16/12 03/17/12 10,477.50 .00 10,477.50 11,632.50 13425 BOOK WHOLESALES INC 266044D CHILDRENS BOOKS AND 02/21/12 03/22/12 02/21/12 25.17 .00 25.17 25.17 640 BOULDER COUNTY 033112 MAR 12 BOULDER COUNT 03/31/12 04/30/12 03/31/12 23,710.92 .00 23,710.92 23,710.92 12880 BOYAGIAN CONSULTING LLC 040312 MAR 12 PROFESSIONAL 04/03/12 05/03/12 04/03/12 4,375.00 .00 4,375.00 4,375.00 7706 BRANNAN SAND & GRAVEL CO 77781 ASPHALT 03/30/12 04/29/12 03/30/12 186.38 .00 186.38 186.38 13534 CARLTON ELECTRIC INC 32181 LIGHT FIXTURES LRC 03/31/12 04/30/12 03/31/12 653.00 .00 653.00 653.00 10773 CENTRIC ELEVATOR CORP 217345 APR 12 ELEVATOR MAIN 04/01/12 05/01/12 04/01/12 226.93 .00 226.93 217346 APR 12 ELEVATOR MAIN 04/01/12 05/01/12 04/01/12 407.43 .00 407.43 217347 APR 12 ELEVATOR MAIN 04/01/12 05/01/12 04/01/12 239.84 .00 239.84 217348 APR 12 ELEVATOR MAIN 04/01/12 05/01/12 04/01/12 244.23 .00 244.23 1,118.43 10495 CENTURYLINK 12095 QWEST FRAME RELAY SW 04/04/12 05/04/12 04/04/12 130.93 .00 130.93 130.93 825 CH DIAGNOSTIC & CONSULTING INC 20120104 ALGAE TESTING 03/23/12 04/22/12 03/23/12 270.00 .00 270.00 270.00 4785 CINTAS CORPORATION #66 066413258 UNIFORM SERVICE WWTP 04/02/12 05/02/12 04/02/12 45.25 .00 45.25 066413260 UNIFORM RENTAL WTP 04/02/12 05/02/12 04/02/12 91.08 .00 91.08 066417449 UNIFORM RENTAL WTP 04/09/12 05/09/12 04/09/12 91.08 .00 91.08 227.41 9524 CITY OF BOULDER AV013646 2012 OVERDRIVE LICEN 02/26/12 03/27/12 02/26/12 762.00 .00 762.00 762.00 1205 COLORADO DEPT OF REVENUE 1QSTX2012 1Q 2012 REC CENTER S 03/31/12 04/30/12 03/31/12 223.00 .00 223.00 223.00 87 04/12/12 07:40:37 BATCH: 78863 City of Louisville Page 3 ap215-ls PERIOD:04/17/12 CASH DISBURSEMENTS EDIT dianek FOR BANK ACCOUNT: 4 FIRST NATIONAL BANK OF COLORADO Control Disbursement Account Inv No. Description Inv Dt Due Dt Disc Dt Inv Amt Disc Amt Pay Amt Check Amt ------------------------------------------------------------------------------------------------------------------ -----------------1245 COLORADO MOSQUITO CONTROL INC 12-114 MAR 12 MOSQUITO CONT 03/31/12 04/30/12 03/31/12 1,378.00 .00 1,378.00 1,378.00 10164 COLORADO MOTOR VEHICLES 033112 DEFAULT JUDGMENT FEE 03/31/12 04/30/12 03/31/12 135.00 .00 135.00 135.00 1250 COLORADO MUNICIPAL LEAGUE 1939 MUNICIPAL CAUCUS LUN 02/20/12 03/21/12 02/20/12 13.00 .00 13.00 2030 MUNICIPAL CAUCUS LUN 03/22/12 04/21/12 03/22/12 13.00 .00 13.00 2047 MUNICIPAL CAUCUS LUN 01/25/12 02/24/12 01/25/12 13.00 .00 13.00 2048 MUNICIPAL CAUCUS LUN 02/06/12 03/07/12 02/06/12 13.00 .00 13.00 2049 MUNICIPAL CAUCUS LUN 01/16/12 02/15/12 01/16/12 13.00 .00 13.00 65.00 1063 COLORADO SENIOR SOFTBALL ASSOC 040212 SR LEAGUE FEES/BALLS 04/02/12 05/02/12 04/02/12 651.00 .00 651.00 651.00 13617 COMMUSA 142428 POLICE PORTABLE RADI 03/22/12 04/21/12 03/22/12 2,438.00 .00 2,438.00 2,438.00 11492 COMPLETE WIRELESS TECHNOLOGIES 82277 RADIO CHARGERS 03/19/12 04/18/12 03/19/12 474.23 .00 474.23 474.23 845 CPRA 3653625 MEMBERSHIP DUES JONE 03/01/12 03/31/12 03/01/12 72.00 .00 72.00 3654422 MEMBERSHIP DUES PERE 03/01/12 03/31/12 03/01/12 72.00 .00 72.00 3655447 MEMBERSHIP DUES BEAS 03/02/12 04/01/12 03/02/12 72.00 .00 72.00 3656012 AGENCY/DIRECTOR DUES 03/02/12 04/01/12 03/02/12 260.00 .00 260.00 3657587 MEMBERSHIP DUES EVAN 03/02/12 04/01/12 03/02/12 72.00 .00 72.00 3661505 MEMBERSHIP DUES JARB 03/04/12 04/03/12 03/04/12 72.00 .00 72.00 3663475 MEMBERSHIP DUES DEGR 03/05/12 04/04/12 03/05/12 72.00 .00 72.00 3687743 MEMBERSHIP DUES SMIT 03/08/12 04/07/12 03/08/12 72.00 .00 72.00 3697481 MEMBERSHIP DUES FEEN 03/11/12 04/10/12 03/11/12 72.00 .00 72.00 3713293 MEMBERSHIP DUES COLE 03/14/12 04/13/12 03/14/12 72.00 .00 72.00 3761363 MEMBERSHIP DUES SEYD 03/26/12 04/25/12 03/26/12 72.00 .00 72.00 3761988 MEMBERSHIP DUES LICH 03/26/12 04/25/12 03/26/12 72.00 .00 72.00 3763366 MEMBERSHIP DUES JOHN 03/26/12 04/25/12 03/26/12 72.00 .00 72.00 1,124.00 13370 CRIBARI LAW FIRM, PC 032712 PROSECUTING ATTORNEY 03/27/12 04/26/12 03/27/12 2,073.75 .00 2,073.75 2,073.75 7479 CUSTOM AUTOMATION 1223 SCADA REPAIR 04/01/12 05/01/12 04/01/12 2,031.50 .00 2,031.50 1223-1 SCADA MATERIALS 04/01/12 05/01/12 04/01/12 45.18 .00 45.18 1226 SCADA UPGRADE NWTP 03/30/12 04/29/12 03/30/12 10,600.00 .00 10,600.00 12,676.68 13488 DAVID LEWIS 041112 TRAVEL ADVANCE 5/6/1 04/11/12 05/11/12 04/11/12 293.25 .00 293.25 293.25 88 04/12/12 07:40:37 BATCH: 78863 City of Louisville Page 4 ap215-ls PERIOD:04/17/12 CASH DISBURSEMENTS EDIT dianek FOR BANK ACCOUNT: 4 FIRST NATIONAL BANK OF COLORADO Control Disbursement Account Inv No. Description Inv Dt Due Dt Disc Dt Inv Amt Disc Amt Pay Amt Check Amt ------------------------------------------------------------------------------------------------------------------ -----------------1130 DEPARTMENT OF LABOR 547926 BOILER INSPECTIONS L 03/20/12 04/19/12 03/20/12 110.00 .00 110.00 110.00 13392 DESIGN MECHANICAL INC 4041619 HVAC SERVICE PD 03/30/12 04/29/12 03/30/12 224.00 .00 224.00 4041659 HVAC MAINTENANCE LIB 04/01/12 05/01/12 04/01/12 487.00 .00 487.00 711.00 1505 DPC INDUSTRIES INC 7370095712 CHLORINE/CALCIUM HYP 03/27/12 04/26/12 03/27/12 1,726.00 .00 1,726.00 1,726.00 5295 DRY CREEK DAVIDSON DITCH CO 031712 2012 DITCH ASSESSMEN 03/17/12 04/16/12 03/17/12 420.00 .00 420.00 420.00 11562 ENDRESS AND HAUSER 6001523990 FLOW METER REMOTE CA 03/20/12 04/19/12 03/20/12 397.63 .00 397.63 397.63 10774 ESSENTIAL SAFETY PRODUCTS 339336 SAFETY VESTS 03/18/12 04/17/12 03/18/12 219.57 .00 219.57 219.57 6761 FARIS MACHINERY CO B00597 MICRO SWITCH UNIT 34 03/30/12 04/29/12 03/30/12 34.62 .00 34.62 B00605 REEL SPEED CONTROL U 03/30/12 04/29/12 03/30/12 675.00 .00 675.00 709.62 13098 G4S SECURE SOLUTIONS INC 6153014 BAILIFF SERVICES 3/1 03/25/12 04/24/12 03/25/12 104.00 .00 104.00 104.00 2405 HACH COMPANY 7688533 HACH EQUIP SERVICE C 03/30/12 04/29/12 03/30/12 17,938.00 .00 17,938.00 7693471 ULTRASONIC HEAD/CABL 04/03/12 05/03/12 04/03/12 1,135.99 .00 1,135.99 19,073.99 13596 HARRIS COMPUTER SYSTEMS MN14040125 MAY 12 WANTS/WARRANT 03/25/12 04/24/12 03/25/12 156.50 .00 156.50 156.50 13565 HATCH MOTT MACDONALD LLC IV142876 FACILITIES PLAN WORK 03/22/12 04/21/12 03/22/12 16,509.02 .00 16,509.02 16,509.02 13142 HAYNES MECHANICAL SYSTEMS INC 185949 HVAC MAINT LRC 03/21/12 04/20/12 03/21/12 582.67 .00 582.67 582.67 13162 HD SUPPLY WATERWORKS LTD 4532370 VALVE BOX KITS 03/20/12 04/19/12 03/20/12 903.90 .00 903.90 903.90 2475 HILL PETROLEUM 0307572-IN UNLEADED/BIODIESEL F 03/23/12 04/22/12 03/23/12 15,096.68 .00 15,096.68 15,096.68 89 04/12/12 07:40:37 BATCH: 78863 City of Louisville Page 5 ap215-ls PERIOD:04/17/12 CASH DISBURSEMENTS EDIT dianek FOR BANK ACCOUNT: 4 FIRST NATIONAL BANK OF COLORADO Control Disbursement Account Inv No. Description Inv Dt Due Dt Disc Dt Inv Amt Disc Amt Pay Amt Check Amt ------------------------------------------------------------------------------------------------------------------ -----------------6265 IACP 1001026517 MODEL POLICY SUBSCRI 03/12/12 04/11/12 03/12/12 30.00 .00 30.00 30.00 2615 INGRAM BOOK COMPANY 03275449 CHILDRENS BOOKS AND 02/01/12 03/02/12 02/01/12 615.23 .00 615.23 03296266 CHILDRENS BOOKS AND 02/02/12 03/03/12 02/02/12 247.08 .00 247.08 03296267 CHILDRENS BOOKS AND 02/02/12 03/03/12 02/02/12 178.77 .00 178.77 03312775 CHILDRENS BOOKS AND 02/03/12 03/04/12 02/03/12 518.02 .00 518.02 03323561 CHILDRENS BOOKS AND 02/05/12 03/06/12 02/05/12 45.57 .00 45.57 03340345 CHILDRENS BOOKS AND 02/06/12 03/07/12 02/06/12 446.69 .00 446.69 03358410 CHILDRENS BOOKS AND 02/07/12 03/08/12 02/07/12 94.64 .00 94.64 03404266 CHILDRENS BOOKS AND 02/09/12 03/10/12 02/09/12 399.33 .00 399.33 03429388 CHILDRENS BOOKS AND 02/12/12 03/13/12 02/12/12 285.20 .00 285.20 03446910 CHILDRENS BOOKS AND 02/13/12 03/14/12 02/13/12 490.20 .00 490.20 03446911 CHILDRENS BOOKS AND 02/13/12 03/14/12 02/13/12 279.26 .00 279.26 03463406 CHILDRENS BOOKS AND 02/14/12 03/15/12 02/14/12 142.00 .00 142.00 03471823 CHILDRENS BOOKS AND 02/14/12 03/15/12 02/14/12 52.13 .00 52.13 03484039 CHILDRENS BOOKS AND 02/15/12 03/16/12 02/15/12 133.90 .00 133.90 03502233 CHILDRENS BOOKS AND 02/16/12 03/17/12 02/16/12 47.44 .00 47.44 03553156 CHILDRENS BOOKS AND 02/20/12 03/21/12 02/20/12 155.69 .00 155.69 03570937 CHILDRENS BOOKS AND 02/21/12 03/22/12 02/21/12 115.79 .00 115.79 03617698 CHILDRENS BOOKS AND 02/23/12 03/24/12 02/23/12 112.90 .00 112.90 03645932 CHILDRENS BOOKS AND 02/26/12 03/27/12 02/26/12 91.11 .00 91.11 03706623 CHILDRENS BOOKS AND 02/29/12 03/30/12 02/29/12 711.49 .00 711.49 5,162.44 8881 INGRAM BOOK COMPANY 03275448 ADULT BOOKS AND MEDI 02/01/12 03/02/12 02/01/12 223.72 .00 223.72 03312774 ADULT BOOKS AND MEDI 02/03/12 03/04/12 02/03/12 6.17 .00 6.17 03340344 ADULT BOOKS AND MEDI 02/06/12 03/07/12 02/06/12 328.99 .00 328.99 03385023 ADULT BOOKS AND MEDI 02/08/12 03/09/12 02/08/12 489.01 .00 489.01 03385024 ADULT BOOKS AND MEDI 02/08/12 03/09/12 02/08/12 124.70 .00 124.70 03417365 ADULT BOOKS AND MEDI 02/10/12 03/11/12 02/10/12 24.23 .00 24.23 03423794 ADULT BOOKS AND MEDI 02/10/12 03/11/12 02/10/12 389.80 .00 389.80 03446909 ADULT BOOKS AND MEDI 02/13/12 03/14/12 02/13/12 157.26 .00 157.26 03463405 ADULT BOOKS AND MEDI 02/14/12 03/15/12 02/14/12 43.36 .00 43.36 03510405 ADULT BOOKS AND MEDI 02/16/12 03/17/12 02/16/12 387.42 .00 387.42 03535304 ADULT BOOKS AND MEDI 02/19/12 03/20/12 02/19/12 39.73 .00 39.73 03553155 ADULT BOOKS AND MEDI 02/20/12 03/21/12 02/20/12 302.45 .00 302.45 03617697 ADULT BOOKS AND MEDI 02/23/12 03/24/12 02/23/12 97.12 .00 97.12 03687253 ADULT BOOKS AND MEDI 02/28/12 03/29/12 02/28/12 260.64 .00 260.64 03687254 ADULT BOOKS AND MEDI 02/28/12 03/29/12 02/28/12 146.20 .00 146.20 3,020.80 11267 INSIDE OUT HEALTH AND FITNESS 1210042-1 CONTRACTOR FEES REAC 03/07/12 04/06/12 03/07/12 610.05 .00 610.05 610.05 13648 INSTRUMENT & SUPPLY WEST INC 0000287-IN PRV INTERCONNECT CON 03/30/12 04/29/12 03/30/12 2,913.79 .00 2,913.79 2,913.79 13471 INTEGRATED CONTROL SYSTEMS INC 12-36 POLICE/COURT BLDG AU 01/09/12 02/08/12 01/09/12 5,587.80 .00 5,587.80 5,587.80 90 04/12/12 07:40:37 BATCH: 78863 City of Louisville Page 6 ap215-ls PERIOD:04/17/12 CASH DISBURSEMENTS EDIT dianek FOR BANK ACCOUNT: 4 FIRST NATIONAL BANK OF COLORADO Control Disbursement Account Inv No. Description Inv Dt Due Dt Disc Dt Inv Amt Disc Amt Pay Amt Check Amt ------------------------------------------------------------------------------------------------------------------ -----------------9761 INTERMOUNTAIN SWEEPER CO 87117 SWEEPER GUTTER BROOM 03/30/12 04/29/12 03/30/12 160.06 .00 160.06 160.06 10558 INTERMOUNTAIN VALVE & CONTROLS 10028699 VALVE ACTUATORS/ADAP 03/28/12 04/27/12 03/28/12 2,341.68 .00 2,341.68 2,341.68 13346 ISS FACILITY SERVICES DENVER 282567 MAR 12 JANITORIAL SE 03/21/12 04/20/12 03/21/12 14,060.84 .00 14,060.84 282567 MAR 12 JANITORIAL SE 03/21/12 04/20/12 03/21/12 819.08 .00 819.08 282567 MAR 12 JANITORIAL SE 03/21/12 04/20/12 03/21/12 160.00 .00 160.00 15,039.92 10013 K&J POWER SWEEPING & STRIPING 1203126