I hereby certify that the foregoing resolution was duly and regularly passed and adopted at a regular meeting of the City Council of the City of Buena Park held this _____ day of _______________ 2023.
_______________________________
City Clerk
SUNGARD PUBLIC SECTOR PAGE NUMBER: 1 DATE: 11/16/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:20:56 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MHR'
ALL CHECKS
PAYRUN: MHR
DATE: 11/13/2023
CHECK DEPOSIT CHECK
NUMBER AMOUNT AMOUNT MAN/VOID ----------EMPLOYEE---------- ID NUMBER 368818 .00 9.00 BEVINS, RONALD 9413 368819 .00 9.00 CHESSEN, DONNA 9428 368820 .00 159.00 DENNY, JOHNNIE 9440 368821 .00 159.00 FAIRMAN, ERIC 9451 368822 .00 159.00 GONZALES, ROBERT 9461 368823 .00 9.00 HAMBY, PAUL 9466 368824 .00 159.00 JACKSON, GARY 9482 368825 .00 159.00 KIMERY, ERIC 9012 368826 .00 21.00 LONG, LINDA 9664 368827 .00 9.00 MACIS, NORMA 9504 368828 .00 9.00 MAYS, MARY 9677 368829 .00 159.00 MCCAY, DONALD 9517 368830 .00 49.00 ROBLES, AMPARO 9550 368831 .00 159.00 SCHWENGEL, LLOYD 9558 368832 .00 9.00 SIGLER, CAROL 9620 368833 .00 159.00 STEWARD, GREGORY 9572 368834 .00 159.00 TAYLOR, ROBERT 9576 368835 .00 21.00 TRUJILLO, FRANK 9663 368836 .00 157.00 TUTHILL, LOREN 9581 368837 .00 9.00 WINNER, SAMUEL 9589 V368838 21.00 .00 AGUIRRE, RICHARD 9624 V368839 2,457.14 .00 BANKS, TAMRA 9687 V368840 21.00 .00 BECKER, LLOYD 9409 V368841 157.00 .00 BERRY, STEVE 9682 V368842 605.21 .00 BISBING, KRISTOPHER 9675 V368843 159.00 .00 BORREGARD, MICHAEL 9416 V368844 159.00 .00 BRANUM, TERRY 9418 V368845 1,658.42 .00 CARNEY, PATRICK 9014 V368846 49.00 .00 CIAMPA, LISA 9429 V368847 157.00 .00 CISNEROS, RUDY 9625 V368848 351.00 .00 CLARK, LAURENCE 9430 V368849 49.00 .00 CLEMENTS, THOMAS 9431 V368850 314.00 .00 CONN, SANDRA 9676 V368851 49.00 .00 COX, BARBARA 9435 V368852 9.00 .00 CRISP, BEVERLY 9612 V368853 159.00 .00 DASCENZI, PHILLIP 9438 V368854 49.00 .00 DESOUCY, DOLORES 9441 V368855 159.00 .00 DIXON, JAMES 9442 V368856 159.00 .00 DOCK, HENRY 9443 V368857 9.00 .00 EERNISSE, NOLA 9448 V368858 157.00 .00 FONCECA, ARTHUR 9456 V368859 1,422.22 .00 FORSYTH, RICHARD 9680 V368860 159.00 .00 FROST, FRANK 9458 V368861 312.00 .00 HAINLEY, LAWRENCE 9651 V368862 180.00 .00 HENEIN, NABIL 9662 V368863 159.00 .00 HESTER, KATHLEEN 9627 V368864 159.00 .00 HICKEN, GARY 9475 V368865 269.00 .00 HOLGUIN, ALEXANDER 9604 V368866 159.00 .00 HORNUNG, EDISON 9479 V368867 157.00 .00 JACKSON, TERESA 9628 SUNGARD PUBLIC SECTOR PAGE NUMBER: 2 DATE: 11/16/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:20:56 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MHR'
ALL CHECKS
V368868 159.00 .00 JONES, MICHAEL 9656 V368869 49.00 .00 JONES, SHIRLEY 9486 V368870 157.00 .00 JONES, WILLIAM 9485 V368871 49.00 .00 KELLY, ANDREA 9661 V368872 49.00 .00 KERBAUGH, MARILYN 9654 V368873 159.00 .00 KIRBY, GEORGE 9488 V368874 49.00 .00 KIRK, BRET 9490 V368875 850.90 .00 KOHANEK, WILLIAM 9669 V368876 9.00 .00 KYLE, LESLIE 9493 V368877 159.00 .00 LININGER, RODNEY 9497 V368878 21.00 .00 LITCHFIELD, WILLIAM 9630 V368879 157.00 .00 LOEHR, LOTHAR 9499 V368880 1,656.42 .00 LOVCHIK, MICHAEL 9684 V368881 49.00 .00 LOWRY, MARILYN 9501 V368882 159.00 .00 LUCENTI, THOMAS 9502 V368883 49.00 .00 MALOUFF, JOSEPHINE 9505 V368884 159.00 .00 MANNING, BRUCE 9506 V368885 49.00 .00 MARTIN, GLORIA 9508 V368886 49.00 .00 MARTINEZ, DAVID 9649 V368887 159.00 .00 MARTINEZ, MANUEL 9667 V368888 159.00 .00 MCNEILLY, MICHAEL 9522 V368889 21.00 .00 MEALER, JAMES 9523 V368890 159.00 .00 MONSON, THOMAS 9638 V368891 312.00 .00 MOTE, ROBERT 9600 V368892 49.00 .00 NUNEZ, RICHARD 9674 V368893 1,809.06 .00 PELTON, GREGORY 9699 V368894 159.00 .00 PENA, RICHARD 9598 V368895 159.00 .00 POTTER, BRUCE 9541 V368896 159.00 .00 POWELL, ROGER 9672 V368897 49.00 .00 REDDICK, SUZANNE 9655 V368898 157.00 .00 RILEY, MARGARET 9681 V368899 49.00 .00 ROGERS, REGINA 9631 V368900 49.00 .00 ROONEY, MARIAN 9622 V368901 159.00 .00 SANDERS, DARYL 9553 V368902 21.00 .00 SANDOVAL, SANTIAGO 9658 V368903 159.00 .00 SCHOALES, JAMES 9555 V368904 49.00 .00 SELLS, ROBIN 9659 V368905 269.00 .00 SHEA, KEVIN 9671 V368906 49.00 .00 SHEARN, WYNNETTE 9641 V368907 740.26 .00 SIANEZ, COREY 9690 V368908 159.00 .00 SWISHER, JOHN 9652 V368909 159.00 .00 SYLVESTER, DAVID 9574 V368910 21.00 .00 TEMPLETON, JOHN 9686 V368911 269.00 .00 VREDENBURGH, JOHN 9657 V368912 159.00 .00 WADELL, VERN 9584 V368913 687.04 .00 WARSINSKI, RICKY 9645 V368914 157.00 .00 WHITESIDE, JOHN 9668 V368915 49.00 .00 WHITLOCK, JOHN 9633 V368916 2,457.14 .00 WORRALL, GARY 9685 V368917 49.00 .00 WYMAN, GUADALUPE 9592
PAYRUN TOTAL
CHECK: 100 22,983.81 1,742.00
TOTAL
CHECKS: 100 22,983.81 1,742.00
RESOLUTION NO. ______
RESOLUTION OF THE CITY COUNCIL OF THE CITY OF BUENA PARK,
CALIFORNIA ALLOWING CERTAIN CLAIMS AND DEMANDS IN THE
SUM OF $943,677.10 COVERING REGULAR PAYROLL ENDING
NOVEMBER 10, 2023
NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF BUENA PARK DOES HEREBY RESOLVE, DETERMINE AND ORDER AS FOLLOWS:
SECTION 1: That in accordance with Section 37208 of the Government Code, the Director of Finance or his designated representative hereby certifies to the accuracy of the following demands and to the availability of funds for payment thereof.
__________________________________
Director of Finance
SECTION 2: The claims and demands in the sum of $943,677.10 set forth on this 8-page register attached to this resolution and made a part hereof have been audited as required by law and are hereby allowed in the amount set forth.
PASSED AND ADOPTED this _____ day of _______________ 2023 by the following called vote:
AYES:
NOES:
ABSENT:
ABSTAIN:
______________________________
Mayor
ATTEST:
__________________________
City Clerk
RESOLUTION NO. _______
I hereby certify that the foregoing resolution was duly and regularly passed and adopted at a regular meeting of the City Council of the City of Buena Park held this _____ day of _______________ 2023.
_____________________________
City Clerk
SUNGARD PUBLIC SECTOR PAGE NUMBER: 1 DATE: 11/16/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:35:39 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MH2'
ALL CHECKS
PAYRUN: MH2
DATE: 11/17/2023
CHECK DEPOSIT CHECK
NUMBER AMOUNT AMOUNT MAN/VOID ----------EMPLOYEE---------- ID NUMBER V368918 1,131.72 .00 CABRERA, AMBER 248 V368919 4,062.46 .00 COPPING, SARA 951 V368920 1,065.73 .00 DIAZ, MICHELLE 419 V368921 3,115.06 .00 DIEZ, KARINA 169 V368922 2,052.73 .00 ENGLEBRECHT, BRIDGET 261 V368923 2,611.61 .00 FEWER, JESSICA 580 V368924 6,838.39 .00 FRANCE, AARON 1650 V368925 2,688.62 .00 MEDINA, YARETZA 8 V368926 769.70 .00 AHN, JOYCE 263 V368927 647.49 .00 BROWN, ARTHUR 655 V368928 723.49 .00 CASTANEDA, JOSE 277 V368929 741.75 .00 SONNE, SUSAN 5161 V368930 504.81 .00 TRAUT, CONNOR 5399 V368931 899.69 .00 AVITIA, LISA 114 V368932 2,697.16 .00 BADILLO, ANNA PATRICIA 168 V368933 1,759.23 .00 GUERRA, SARAH 1470 V368934 5,116.94 .00 JIMENEZ, ADRIA 2297 V368935 881.94 .00 KIRK, RALPH 384 V368936 1,851.40 .00 LOPEZ, ANGELICA 2928 V368937 4,344.64 .00 FENTON, EDWARD 1564 V368938 1,489.68 .00 GONZALEZ, JACQUELINE 157 V368939 1,750.69 .00 KERN, DONNA 2574 V368940 2,286.29 .00 PREVO, DOREKA 390 V368941 3,244.31 .00 VALDEZ, REBECCA 5490 V368942 1,651.38 .00 BUENROSTRO, PATRICIA 227 V368943 6,330.74 .00 GARCIA, ADRIAN 1700 V368944 1,094.77 .00 GLAVIN, BARBARA 1768 V368945 1,880.62 .00 HERNANDEZ, GLORIA 2092 V368946 6,320.80 .00 HYUN, SUNG 2248 V368947 2,009.03 .00 KIM, MIN 2584 V368948 1,966.72 .00 LOVEJOY, REBEKAH 76 V368949 2,349.98 .00 MENDOZA, MARIA 3293 V368950 789.51 .00 OZAKI, GRACE 3881 V368951 1,806.39 .00 PAK, TIMOTHY 3955 V368952 2,552.23 .00 PEREZ, JESSICA 4111 V368953 2,410.05 .00 TOMASSETTI, JEEVANI 5623 V368954 1,970.02 .00 TRAN, KRYSTLE 242 V368955 4,032.81 .00 AVERELL, MARK 272 V368956 2,295.18 .00 COLES-GUZMAN, MARY 950 V368957 1,941.66 .00 KENNEDY, SEAN 111 V368958 1,691.43 .00 BELTRAN, CINDY 467 V368959 571.72 .00 CARDENAS, MARGARET 336 V368960 2,916.37 .00 CULL, ROBERT 1012 V368961 2,608.12 .00 LESTER, ALEXANDER 2868 V368962 1,733.50 .00 MACIAS, JUDITH 2996 V368963 2,201.86 .00 MAYORQUIN, RAYMUNDO 221 V368964 2,581.92 .00 TART, ANDRE 5235 V368965 3,928.67 .00 CAMACHO, MARIO 731 V368966 1,102.93 .00 CASTANEDA, GUADALUPE 280 V368967 2,357.86 .00 CATALDO, JOHN 766 SUNGARD PUBLIC SECTOR PAGE NUMBER: 2 DATE: 11/16/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:35:39 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MH2'
ALL CHECKS
V368968 712.05 .00 COHEN-DORON, JILL 841 V368969 1,990.27 .00 DAVIS-VALENTINE, SUZANNE 1085 V368970 2,358.72 .00 DE LA PAZ, TIANNA 297 V368971 5,994.40 .00 FOULKES, MATTHEW 9 V368972 3,446.87 .00 LUNA, HARALD 264 V368973 2,470.82 .00 MCALEESE, IAN 159 V368974 4,229.82 .00 MESHRAM, SWATI 3321 V368975 3,256.62 .00 NAVARRO, SANDRA 93 V368976 441.58 .00 SANCHEZ, VIVIANA 4616 V368977 2,428.18 .00 SANTOS, RUTH 4640 V368978 2,603.80 .00 SCHAETZL, RANA 431 V368979 1,567.27 .00 TAE, RAY 5196 V368980 2,303.41 .00 ZAPIEN, ERNESTINE 5777 V368981 2,295.10 .00 ARDAIZ, LANA 190 V368982 3,174.49 .00 DHAUW, MELISSA 1170 V368983 2,798.21 .00 SUAREZ, SARABETH 5169 V368984 2,886.60 .00 YOON, JIWON 91 V368985 2,254.15 .00 COTA, LORRAINE 954 V368986 5,340.02 .00 GEYER, BRADLEY 1692 V368987 6,806.22 .00 HONG, ALEX 2130 V368988 2,279.85 .00 MARTINEZ, JESSICA 2936 V368989 5,605.59 .00 NGUYEN, NGHIA 3755 V368990 6,486.97 .00 NUNES, FRANK 3813 V368991 2,139.67 .00 CHARNES, LANCE 783 V368992 7,779.38 .00 DIERINGER, RYAN 1145 V368993 3,627.70 .00 JIMENEZ, ROBERT 352 V368994 3,077.49 .00 KIM, HYUN 328 V368995 2,689.91 .00 LAM, DAVID 2790 V368996 439.33 .00 LOVCHIK, MICHAEL 6 V368997 4,059.36 .00 MIKIEWICZ, SIMON 3360 V368998 2,098.91 .00 NOVOTNY, MARY 3705 V368999 2,183.14 .00 SEMAAN, NADIA 4740 V369000 4,965.57 .00 TOMSICK, MARTIN 5360 V369001 5,951.21 .00 WEAVER, CHAD 5577 V369002 2,387.12 .00 ALCALA, BRITTANY 58 V369003 3,483.21 .00 BARAJAS, MAYRA 357 V369004 754.14 .00 BARR, LISA 366 V369005 2,025.57 .00 BINYON, ERIC 506 V369006 5,204.74 .00 BRANDSTETTER, JAMES 629 V369007 4,566.31 .00 BUTH, CATHERINE 561 V369008 3,774.51 .00 CARPENTER, SCARLET 1663 V369009 701.14 .00 CONN, SANDRA 961 V369010 581.68 .00 DIERINGER, REGINA 1515 V369011 2,623.26 .00 ESCOBEDO, STACEY 1530 V369012 3,384.82 .00 ESQUETINI, MARIA 1536 V369013 748.34 .00 ESTRELLA, CARL JOSEPH 415 V369014 1,938.41 .00 HERNANDEZ, ISABELLA 112 V369015 2,584.97 .00 MAERKER, ELIZABETH 3017 V369016 4,030.28 .00 MCGRATH, CODY 3220 V369017 748.34 .00 MENDOZA HERNANDEZ, STEPHANIE 427 V369018 899.68 .00 MEONO, ROBIN 351 V369019 1,665.39 .00 MORALES MALDONADO, IVETT 3490 V369020 2,667.24 .00 PALMA CARDENAS, DIANA 3970 V369021 684.14 .00 RAMIREZ, ARIANNA 86 V369022 852.81 .00 RODRIGUEZ VILLA, YARELI 205 V369023 2,219.63 .00 SAUCEDA, CATHLEEN 4645 SUNGARD PUBLIC SECTOR PAGE NUMBER: 3 DATE: 11/16/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:35:39 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MH2'
ALL CHECKS
V369024 2,871.59 .00 SHERIFF, SAMANTHA 2096 V369025 3,209.65 .00 TANIGUCHI, MELISSA 5230 V369026 668.74 .00 VELLANOWETH, KRISTINE 217 V369027 2,198.45 .00 FIORE, KATE 1560 V369028 2,623.18 .00 FOX, CHARITY 1641 V369029 754.33 .00 KUHN, MICHELLE 2730 V369030 743.35 .00 KUHN, TARI 2747 V369031 2,260.50 .00 LARA, KARON 103 V369032 2,622.84 .00 MEDINA, IVONNE 222 V369033 2,688.99 .00 MENDIVEL, CHRISTINA 3299 V369034 2,015.12 .00 NGO, CATHERINE 3752 V369035 2,510.18 .00 PENDLETON, SUN 4080 V369036 1,473.67 .00 TENG, LING-FEI 2871 V369037 1,902.52 .00 UMLAH, AMBER 5435 V369038 5,676.64 .00 BATES, PATRICK 378 V369039 4,387.14 .00 BELTRAN, CHRISTINA 13 V369040 7,084.68 .00 BERNAL, DAVID 480 V369041 4,442.49 .00 BOURNE, CLIFFORD 5612 V369042 4,586.22 .00 BOYD, ROBERT 584 V369043 5,434.91 .00 BOYER, CAMERON 585 V369044 5,229.43 .00 BOYINGTON, DEVIN 594 V369045 3,945.87 .00 BRAVO, ISABEL 420 V369046 3,456.89 .00 BURNETT, DEBORAH 110 V369047 3,062.11 .00 CAMPOS, LOLANI 728 V369048 4,452.84 .00 CARNEY, THOMAS 751 V369049 2,190.80 .00 CERDA, SERGIO 240 V369050 3,830.78 .00 CHAVEZ, ALEJANDRO 182 V369051 3,986.90 .00 CHAVEZ, ANTONY 246 V369052 3,802.32 .00 CHOI, JONATHON 827 V369053 3,995.95 .00 CHRISTIANSEN, ANDREW 97 V369054 2,158.07 .00 CURATOLA, ANTHONY 350 V369055 2,861.89 .00 DAVIS, JONATHAN 1083 V369056 2,847.80 .00 EK, CHRISTOPHER 1477 V369057 4,621.86 .00 ESCAMILLA, MARIO 1529 V369058 3,569.48 .00 ESCOBEDO, DOMINICK 1521 V369059 3,790.07 .00 FRANKLIN, KEVIN 1649 V369060 6,114.40 .00 GALOS, MICHAEL 1680 V369061 4,581.98 .00 GANO, KEVIN 1742 V369062 2,870.23 .00 GONZALEZ, LUIS 164 V369063 4,792.63 .00 GONZALEZ, OSCAR 1785 V369064 4,975.79 .00 HERST, RYAN 2102 V369065 1,875.62 .00 HOGAN, CHRISTIAN MICHAEL 138 V369066 4,529.17 .00 JIMENEZ, GUSTAVO 2285 V369067 4,580.22 .00 LEE, CONNOR 2861 V369068 6,349.61 .00 LEPE, SERGIO 2901 V369069 3,243.06 .00 LIRA, JOSEPH 133 V369070 3,319.85 .00 LOPEZ, GUILLERMO 2958 V369071 4,625.72 .00 LOVETERE, JOSEPH 2962 V369072 3,570.89 .00 MARTINEZ, JESUS 117 V369073 2,924.48 .00 MEDRANO, JULIAN 3223 V369074 3,515.41 .00 MOELLER, SARAH 3590 V369075 5,428.09 .00 MOON, DAVID 3479 V369076 4,700.27 .00 MUNOZ, OSCAR 3605 V369077 3,540.07 .00 MURILLO CASTRO, JULIAN 268 V369078 2,346.07 .00 NGUYEN, ANTHONY 258 V369079 5,015.37 .00 NYHUS, CHRISTOPHER 3808 SUNGARD PUBLIC SECTOR PAGE NUMBER: 4 DATE: 11/16/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:35:39 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MH2'
ALL CHECKS
V369080 5,630.56 .00 O'DETTE, DIRK 3823 V369081 4,974.08 .00 OH, WILLIAM 326 V369082 3,334.69 .00 PADILLA, VALERIE 108 V369083 8,338.25 .00 PINO, RICHARD 4171 V369084 4,784.20 .00 PROCEL, ANDY 4243 V369085 3,885.26 .00 RAMIREZ, ANGEL 4314 V369086 2,958.88 .00 RANGEL, PRISCILLA 4337 V369087 4,260.17 .00 REYES, HUGO 98 V369088 2,683.28 .00 RODRIGUEZ, CHRISTIAN 4476 V369089 3,740.72 .00 RODRIGUEZ CASTILLERO, JOSEPH 259 V369090 6,338.38 .00 RUBALCAVA, EFRAIN 4590 V369091 3,892.96 .00 TEWELL, MELISSA 5282 V369092 2,128.46 .00 TRAN, JENNIFER 9666 V369093 4,486.49 .00 TRAN, TUYET 5424 V369094 3,195.71 .00 TURNER, JERAMIAH 291 V369095 3,749.60 .00 VU, JEFFREY 5519 V369096 5,324.14 .00 WILLIAMS, JUDITH 5660 V369097 3,854.63 .00 YO, DANIEL 5752 V369098 5,301.95 .00 COLON, BOBBY 900 V369099 4,186.11 .00 JOHNSON, BRYAN 2300 V369100 1,948.49 .00 MAERTZ, DANA 3018 V369101 1,743.63 .00 RANGEL, JENNY 283 V369102 6,026.96 .00 RICE, JAMES 4408 V369103 3,136.80 .00 SALAZAR, RYAN 4626 V369104 6,041.70 .00 SHADDOW, JON-MICHAEL 4837 V369105 2,127.63 .00 SILVA, OSCAR 4886 V369106 2,168.31 .00 VAZQUEZ-CAMACHO, MARLENE 101 V369107 582.28 .00 BAIR, JOHN 284 V369108 541.59 .00 CASEY, DROUETT 771 V369109 687.59 .00 PATTON, DANA 4060 V369110 5,383.49 .00 BAILEY, JOHN 355 V369111 3,970.94 .00 BOUDREAU, CORY 583 V369112 2,108.79 .00 BOUDREAU, LAURA 2192 V369113 2,164.53 .00 CHAN, KARA 795 V369114 5,976.61 .00 DAVENPORT, JOSEPH 1094 V369115 4,528.48 .00 GENTNER, GEORGE 1765 V369116 3,714.08 .00 KALAGIAN, BRYANT 2436 V369117 2,524.28 .00 LOMELI, LISBETH 4516 V369118 2,851.41 .00 LOPEZ, VANESSA 2929 V369119 4,129.18 .00 LOPEZ, WILLYVALDO 2941 V369120 3,862.36 .00 LOWE, AUSTIN 2956 V369121 4,394.55 .00 MORALES, FRANK 3489 V369122 1,882.14 .00 O'DETTE, NANCY 1920 V369123 4,211.10 .00 ORTEGA, MICHAEL 104 V369124 4,215.12 .00 PANTOJA, DAVID 3986 V369125 5,552.31 .00 PLUMLEE, ROGER 4180 V369126 4,184.81 .00 SOLIS, DANIEL 5000 V369127 2,256.74 .00 SULLIVAN, STACEY 5160 V369128 3,086.76 .00 TREADWAY, SARA 4210 V369129 4,030.75 .00 VU, KRISTINE 63 V369130 23.70 .00 ARELLANO, PEDRO 391 V369131 2,533.59 .00 CAPISTRANO, FRANCES 74 V369132 23.70 .00 DESAI, PRADIP 1121 V369133 23.70 .00 FIGUEROA, NAYELI 403 V369134 23.70 .00 GARCIA, ALEXANDRA 414 V369135 1,808.77 .00 IBARRA, KRISTI 88 SUNGARD PUBLIC SECTOR PAGE NUMBER: 5 DATE: 11/16/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:35:39 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MH2'
ALL CHECKS
V369136 23.70 .00 JAMES, SAGIL 392 V369137 5,411.26 .00 MIKHAEL, MINA 3359 V369138 23.70 .00 ROBERTSON II, DANA 397 V369139 23.70 .00 RODDEN, MARK 406 V369140 23.70 .00 SINGHAL, ANNIE 4893 V369141 1,805.32 .00 ALMANZA, MINERVA 79 V369142 3,751.13 .00 ALQAM, NADER 71 V369143 3,549.89 .00 ARABOLU, DEEPTHI 178 V369144 2,522.67 .00 ESPARZA-ALMARAZ, AARON 383 V369145 3,436.02 .00 KIM, KENNETH 2587 V369146 2,934.57 .00 LANNAN, GREGORY 2791 V369147 3,066.98 .00 LEE, HYANG SUN 430 V369148 4,056.79 .00 ORTIZ, CESAR 92 V369149 2,745.73 .00 PENA, MANUEL 2933 V369150 372.68 .00 SYFRITT, MATTHEW-WAYNE 428 V369151 2,813.38 .00 TRAN, JASON 96 V369152 3,144.99 .00 WRAY, NORMAN 5725 V369153 2,615.28 .00 ZARAGOZA, EDUARDO 5788 V369154 2,819.12 .00 AUBUCHON, LAURIE 250 V369155 2,073.61 .00 GENERA, ELIZABETH 1685 V369156 4,143.49 .00 HUNT, JOSEPH 2249 V369157 1,758.15 .00 LUX, ANDREA 2972 V369158 574.98 .00 ARREOLA, ERIK 223 V369159 2,939.77 .00 BACA, ANDREW 315 V369160 1,211.92 .00 BANUELOS, CHRISTOPHER 345 V369161 2,789.46 .00 BRITO, MICHAEL 642 V369162 3,089.39 .00 ESCATEL-OROSCO, PEDRO 1537 V369163 2,403.07 .00 GONZALEZ, ALEJANDRO 1783 V369164 1,498.87 .00 GUZMAN, KEVIN 132 V369165 3,867.05 .00 LIBUNAO, NINO 2912 V369166 1,258.30 .00 LISCANO, CHRISTOPHER 850 V369167 1,621.74 .00 MARASCO, MATTHEW 289 V369168 1,472.28 .00 MUNOZ, GENE 3600 V369169 1,506.71 .00 MUNOZ, JOHNNY 144 V369170 138.02 .00 ORTIZ, DANIEL 3862 V369171 1,491.49 .00 ORTIZ, RAYMOND 309 V369172 1,211.91 .00 PRECIADO, CAMDEN 134 V369173 1,211.95 .00 REYNOLDS, BILLY 417 V369174 1,211.91 .00 RIOS, DANNY 282 V369175 2,415.89 .00 RIVERA, JOE 4450 V369176 1,073.64 .00 RODRIGUEZ, NATHANIAL 288 V369177 1,479.16 .00 RODRIGUEZ, OSCAR 131 V369178 2,167.26 .00 SERNA, JUAN 4728 V369179 2,272.30 .00 TORREZ, JAVIER 69 V369180 1,999.59 .00 VAZQUEZ, JOE 5473 V369181 2,233.52 .00 CARRILLO, EDWARD 765 V369182 2,313.03 .00 ELLS, ZACHARY 1500 V369183 1,737.60 .00 ENNIS, JOSEPH 262 V369184 3,285.42 .00 FINCH, BARRETT 1574 V369185 3,024.70 .00 HAGAN, KEVIN 1947 V369186 3,588.73 .00 KVENBO, SCOTT 2750 V369187 2,007.47 .00 MARTINEZ, MARCO 215 V369188 4,085.44 .00 MCGEE, MICHAEL 9306 V369189 2,157.98 .00 MENDOZA, JOHN 3292 V369190 2,282.02 .00 MILLER, DAVID 3390 V369191 4,295.09 .00 MOJARRO, ANDREW 3082 SUNGARD PUBLIC SECTOR PAGE NUMBER: 6 DATE: 11/16/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:35:39 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MH2'
ALL CHECKS
V369192 3,217.97 .00 MOORE, FRANK 3486 V369193 3,032.39 .00 ROMERO, FIDEL 4530 V369194 2,116.16 .00 SANCHEZ, JUAN 4617 V369195 2,103.16 .00 SPEAR, ANTHONY 5011 V369196 2,805.91 .00 STEPHENSON, MARK 5122 V369197 1,979.31 .00 TAVARES, JAMEY 5231 V369198 2,631.30 .00 VENEGAS MENDEZ, JAVIER 5491 V369199 1,073.64 .00 ALVAREZ, CARLOS 136 V369200 2,266.65 .00 DAHL, TERRY 1084 V369201 2,372.19 .00 GARCIA ORTEGA, JOSE 1636 V369202 2,146.88 .00 GRIMES, DAVID 1881 V369203 2,168.06 .00 KOSS, MICHAEL 2718 V369204 3,061.59 .00 MARTINEZ, GABRIEL 3139 V369205 2,401.98 .00 MELLADO, KIM 3289 V369206 2,543.94 .00 MERROW, MATTHEW 3316 V369207 1,995.36 .00 OTTEN, DAVID 3869 V369208 1,805.83 .00 PEREZ, ADRIAN 257 V369209 4,764.51 .00 PORTER, JEFFREY 4174 V369210 2,642.91 .00 RODRIGUEZ, EDWARD 4479 V369211 1,073.64 .00 RUIZ, ALEJANDRO 416 V369212 1,030.66 .00 SOLOMAN, CARLOS 4891 V369213 1,726.24 .00 TORRES, SALVADOR 234 V369214 2,072.22 .00 WELLS, ANTHONY 5610 V369215 831.76 .00 AVERELL, ANDREW 349 V369216 2,437.62 .00 CAMPIZTA, ADAM 225 V369217 2,927.86 .00 MACIAS, RAYMOND 2998 V369218 1,975.69 .00 MILLER-SPARKS, WILLIAM 216 V369219 2,433.43 .00 WEAR, JOHN 5606 V369220 6,126.20 .00 BOX, JAMES 576 V369221 1,944.49 .00 CHAVEZ, ARIANA 788 V369222 1,717.66 .00 CONTRERAS, SAUL 95 V369223 3,335.83 .00 KURATA, DALE 2749 V369224 2,205.20 .00 REYNOLDS, BRANDON 4384 V369225 989.98 .00 SANCHEZ, CHRISTOPHER 236 V369226 2,281.58 .00 SANCHEZ-REYES, KEVIN 83 V369227 3,106.92 .00 SAUCEDA, MARK 4642 V369228 961.89 .00 ALVARADO, ADRIAN 89 V369229 219.82 .00 BAHENA, PEDRO 148 V369230 514.29 .00 BARENG, KATHERINE 33 V369231 439.64 .00 BELCHER-HALL, JACOB 333 V369232 927.63 .00 CARNES, ALISSA 34 V369233 373.27 .00 CARVENTE, GIANJAVIER 334 V369234 993.04 .00 CISNEROS, MICHELLE 812 V369235 427.20 .00 CLARK-PRUDHOMME, MATTHEW 307 V369236 609.29 .00 DOWDLE, JACKSON 1386 V369237 665.15 .00 FERNANDEZ, GISSEL 330 V369238 439.64 .00 GARCIA, MICHELE 171 V369239 199.07 .00 GONZALEZ, ISAAC 294 V369240 658.99 .00 GONZALEZ, LUIS 1780 V369241 476.96 .00 GRANADOS, REGINA 145 V369242 571.25 .00 GRANDE, DANIELLE 124 V369243 817.77 .00 GUERRA, ATHZIRI 141 V369244 315.21 .00 GUILLEN, JAYDEN 339 V369245 655.01 .00 GUTIERREZ, MICHELLE 1925 V369246 556.01 .00 HERNANDEZ, KATE 2091 V369247 1,186.34 .00 HOLLOWAY, ELIZABETH 2185 SUNGARD PUBLIC SECTOR PAGE NUMBER: 7 DATE: 11/16/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:35:39 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MH2'
ALL CHECKS
V369248 801.89 .00 JUBRAN, NOAH 127 V369249 373.27 .00 LEWIS, ALEC 266 V369250 598.39 .00 MAGANA, ADAM 173 V369251 1,783.65 .00 MARTINEZ, SERENA 3147 V369252 692.92 .00 MEZA, ADRIAN 122 V369253 1,047.14 .00 MOLAR, BARBARA 3449 V369254 989.98 .00 MORENO, ANDREW 161 V369255 485.26 .00 NGHIEM, NATALIE 249 V369256 315.21 .00 NGUYEN, KEVIN 299 V369257 897.54 .00 NUNEZ, HAZEL 3806 V369258 213.97 .00 OLVERA, DAVID 3841 V369259 931.69 .00 ONTIVEROS, IZABELLA 3864 V369260 265.44 .00 RAY, SABRINA 286 V369261 707.26 .00 RIVERA GOMEZ, YAMILEX 4432 V369262 232.26 .00 RODRIGUEZ, MIKAYLA 295 V369263 232.26 .00 RONQUILLO, JAZZIE 172 V369264 505.99 .00 ROQUE, KATRINA 38 V369265 964.09 .00 RUSSELL, JEFFREY 150 V369266 765.82 .00 SALDANA, JONATHAN 4625 V369267 157.61 .00 SOLIMAN, MARSEL 322 V369268 33.18 .00 SOLTERO, JESSE 177 V369269 364.98 .00 SORIA, NOAH 5004 V369270 416.49 .00 STRICKLER, LINDA 5135 V369271 141.01 .00 TAPIA, ANGELICA 306 V369272 1,086.10 .00 THOMSEN, MATTHEW 194 V369273 132.72 .00 TOVAR, SOFIA 301 V369274 2,522.31 .00 VAN SICKLE, MICHELLE 2076 V369275 700.14 .00 VAZQUEZ, OSCAR 152 V369276 636.08 .00 VELOZ, SABRINA 146 V369277 514.29 .00 WONGSUPHAKPHAN, BRIANNA 337 V369278 320.41 .00 RODRIGUEZ, PERLA 4488 V369279 479.20 .00 SINGH, YASHPREET 48 V369280 537.70 .00 SMITH, JOHN 210 V369281 334.12 .00 ZAPATA, ALEXANDRIA 303 V369282 841.30 .00 AGUILAR, KALVIN 23 V369283 522.59 .00 BARTOLO, BRYAN 338 V369284 1,071.11 .00 BUSTAMANTE VALLADARES, DIANA 285 V369285 662.82 .00 CABUSAO, NINA MARINELLA 729 V369286 604.78 .00 CARDENAS, DIEGO 275 V369287 956.13 .00 CASTILLO, DARLENE 119 V369288 850.79 .00 CERVANTES, BRIANA 757 V369289 456.22 .00 CLARK-PRUDHOMME, MACKENZIE 206 V369290 2,198.81 .00 DAVIS, TANIKKA 1082 V369291 1,133.34 .00 DETERDING, CARSON 1132 V369292 1,955.72 .00 GILLIAM, VERONICA 218 V369293 795.85 .00 GUERRA, ROCCO 44 V369294 1,015.81 .00 HONG, YI 2189 V369295 3,198.38 .00 HURTADO, MARIA 353 V369296 809.64 .00 LARIZ RUBALCAVA, CARLOS 429 V369297 918.59 .00 MINIKEY, MOLLY 425 V369298 518.44 .00 MORISON, MATTHEW 243 V369299 2,242.31 .00 NIELSEN, ROSEMARY 3760 V369300 1,764.86 .00 NORIEGA, MICHELLE 3782 V369301 589.87 .00 ONTIVEROS, STEVEN 342 V369302 719.66 .00 ORTIZ, YAHAIRA 241 V369303 244.71 .00 PULIDO, MARLENE 39 SUNGARD PUBLIC SECTOR PAGE NUMBER: 8 DATE: 11/16/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:35:39 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MH2'
ALL CHECKS
V369304 241.39 .00 RUIZ, ANA 4591 V369305 378.09 .00 RUVALCABA, ALEXANDRA 305 V369306 208.24 .00 SAMPAT, SHREEYA 4627 V369307 560.07 .00 SERRATOS, DARIAN 160 V369308 552.62 .00 SOSA, ELIANNA 341 V369309 1,451.60 .00 SOTO, JOSE 229 V369310 265.09 .00 SOTO DONACIANO, ANGEL 287 V369311 728.31 .00 TAILOR, DIYA 175 V369312 886.23 .00 VALDEZ, NATALIA 46 V369313 174.20 .00 VEGA-MATA, PEDRO 278 V369314 574.97 .00 ZAZUETA, RYAN 267
PAYRUN TOTAL
CHECK: 397 943,677.10 .00
TOTAL
CHECKS: 397 943,677.10 .00
RESOLUTION NO. ______
RESOLUTION OF THE CITY COUNCIL OF THE CITY OF BUENA PARK,
CALIFORNIA ALLOWING CERTAIN CLAIMS AND DEMANDS IN THE
SUM OF $24,496.35 COVERING RETIREE PAYROLL ENDING
NOVEMBER 30, 2023.
NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF BUENA PARK DOES HEREBY RESOLVE, DETERMINE AND ORDER AS FOLLOWS:
SECTION 1: That in accordance with Section 37208 of the Government Code, the Director of Finance or his designated representative hereby certifies to the accuracy of the following demands and to the availability of funds for payment thereof.
__________________________________
Director of Finance
SECTION 2: The claims and demands in the sum of $24,496.35, set forth on the 2-page register attached to this resolution and made a part here of have been audited as required by law and are hereby allowed in the amount set forth.
PASSED AND ADOPTED this _____ day of _______________ 2023 by the following called vote:
AYES:
NOES:
ABSENT:
ABSTAIN:
______________________________
Mayor
ATTEST:
__________________________
City Clerk
RESOLUTION NO. _______
I hereby certify that the foregoing resolution was duly and regularly passed and adopted at a regular meeting of the City Council of the City of Buena Park held this _____ day of _______________ 2023.
_______________________________
City Clerk
SUNGARD PUBLIC SECTOR PAGE NUMBER: 1 DATE: 11/30/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:11:41 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MH3'
ALL CHECKS
PAYRUN: MH3
DATE: 11/24/2023
CHECK DEPOSIT CHECK
NUMBER AMOUNT AMOUNT MAN/VOID ----------EMPLOYEE---------- ID NUMBER 369315 .00 9.00 BEVINS, RONALD 9413 369316 .00 9.00 CHESSEN, DONNA 9428 369317 .00 159.00 DENNY, JOHNNIE 9440 369318 .00 159.00 FAIRMAN, ERIC 9451 369319 .00 159.00 GONZALES, ROBERT 9461 369320 .00 9.00 HAMBY, PAUL 9466 369321 .00 159.00 JACKSON, GARY 9482 369322 .00 159.00 KIMERY, ERIC 9012 369323 .00 21.00 LONG, LINDA 9664 369324 .00 9.00 MACIS, NORMA 9504 369325 .00 9.00 MAYS, MARY 9677 369326 .00 159.00 MCCAY, DONALD 9517 369327 .00 49.00 ROBLES, AMPARO 9550 369328 .00 159.00 SCHWENGEL, LLOYD 9558 369329 .00 9.00 SIGLER, CAROL 9620 369330 .00 159.00 STEWARD, GREGORY 9572 369331 .00 159.00 TAYLOR, ROBERT 9576 369332 .00 21.00 TRUJILLO, FRANK 9663 369333 .00 157.00 TUTHILL, LOREN 9581 369334 .00 9.00 WINNER, SAMUEL 9589 V369335 21.00 .00 AGUIRRE, RICHARD 9624 V369336 2,457.14 .00 BANKS, TAMRA 9687 V369337 21.00 .00 BECKER, LLOYD 9409 V369338 157.00 .00 BERRY, STEVE 9682 V369339 605.21 .00 BISBING, KRISTOPHER 9675 V369340 159.00 .00 BORREGARD, MICHAEL 9416 V369341 159.00 .00 BRANUM, TERRY 9418 V369342 1,658.42 .00 CARNEY, PATRICK 9014 V369343 49.00 .00 CIAMPA, LISA 9429 V369344 157.00 .00 CISNEROS, RUDY 9625 V369345 49.00 .00 CLARK, LAURENCE 9430 V369346 314.00 .00 CONN, SANDRA 9676 V369347 49.00 .00 COX, BARBARA 9435 V369348 9.00 .00 CRISP, BEVERLY 9612 V369349 159.00 .00 DASCENZI, PHILLIP 9438 V369350 49.00 .00 DESOUCY, DOLORES 9441 V369351 159.00 .00 DIXON, JAMES 9442 V369352 159.00 .00 DOCK, HENRY 9443 V369353 9.00 .00 EERNISSE, NOLA 9448 V369354 157.00 .00 FONCECA, ARTHUR 9456 V369355 1,422.22 .00 FORSYTH, RICHARD 9680 V369356 159.00 .00 FROST, FRANK 9458 V369357 312.00 .00 HAINLEY, LAWRENCE 9651 V369358 180.00 .00 HENEIN, NABIL 9662 V369359 159.00 .00 HESTER, KATHLEEN 9627 V369360 159.00 .00 HICKEN, GARY 9475 V369361 269.00 .00 HOLGUIN, ALEXANDER 9604 V369362 159.00 .00 HORNUNG, EDISON 9479 V369363 157.00 .00 JACKSON, TERESA 9628 V369364 159.00 .00 JONES, MICHAEL 9656 SUNGARD PUBLIC SECTOR PAGE NUMBER: 2 DATE: 11/30/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:11:41 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MH3'
ALL CHECKS
V369365 49.00 .00 JONES, SHIRLEY 9486 V369366 157.00 .00 JONES, WILLIAM 9485 V369367 49.00 .00 KELLY, ANDREA 9661 V369368 49.00 .00 KERBAUGH, MARILYN 9654 V369369 159.00 .00 KIRBY, GEORGE 9488 V369370 49.00 .00 KIRK, BRET 9490 V369371 850.90 .00 KOHANEK, WILLIAM 9669 V369372 9.00 .00 KYLE, LESLIE 9493 V369373 159.00 .00 LININGER, RODNEY 9497 V369374 21.00 .00 LITCHFIELD, WILLIAM 9630 V369375 157.00 .00 LOEHR, LOTHAR 9499 V369376 1,656.42 .00 LOVCHIK, MICHAEL 9684 V369377 49.00 .00 LOWRY, MARILYN 9501 V369378 159.00 .00 LUCENTI, THOMAS 9502 V369379 49.00 .00 MALOUFF, JOSEPHINE 9505 V369380 159.00 .00 MANNING, BRUCE 9506 V369381 49.00 .00 MARTIN, GLORIA 9508 V369382 49.00 .00 MARTINEZ, DAVID 9649 V369383 159.00 .00 MARTINEZ, MANUEL 9667 V369384 159.00 .00 MCNEILLY, MICHAEL 9522 V369385 21.00 .00 MEALER, JAMES 9523 V369386 159.00 .00 MONSON, THOMAS 9638 V369387 312.00 .00 MOTE, ROBERT 9600 V369388 49.00 .00 NUNEZ, RICHARD 9674 V369389 1,809.06 .00 PELTON, GREGORY 9699 V369390 159.00 .00 PENA, RICHARD 9598 V369391 159.00 .00 POTTER, BRUCE 9541 V369392 159.00 .00 POWELL, ROGER 9672 V369393 49.00 .00 REDDICK, SUZANNE 9655 V369394 157.00 .00 RILEY, MARGARET 9681 V369395 49.00 .00 ROGERS, REGINA 9631 V369396 49.00 .00 ROONEY, MARIAN 9622 V369397 159.00 .00 SANDERS, DARYL 9553 V369398 21.00 .00 SANDOVAL, SANTIAGO 9658 V369399 159.00 .00 SCHOALES, JAMES 9555 V369400 49.00 .00 SELLS, ROBIN 9659 V369401 269.00 .00 SHEA, KEVIN 9671 V369402 49.00 .00 SHEARN, WYNNETTE 9641 V369403 861.80 .00 SIANEZ, COREY 9690 V369404 159.00 .00 SWISHER, JOHN 9652 V369405 159.00 .00 SYLVESTER, DAVID 9574 V369406 21.00 .00 TEMPLETON, JOHN 9686 V369407 269.00 .00 VREDENBURGH, JOHN 9657 V369408 159.00 .00 WADELL, VERN 9584 V369409 687.04 .00 WARSINSKI, RICKY 9645 V369410 157.00 .00 WHITESIDE, JOHN 9668 V369411 49.00 .00 WHITLOCK, JOHN 9633 V369412 2,457.14 .00 WORRALL, GARY 9685 V369413 49.00 .00 WYMAN, GUADALUPE 9592
PAYRUN TOTAL
CHECK: 99 22,754.35 1,742.00
TOTAL
CHECKS: 99 22,754.35 1,742.00
RESOLUTION NO. ______
RESOLUTION OF THE CITY COUNCIL OF THE CITY OF BUENA PARK,
CALIFORNIA ALLOWING CERTAIN CLAIMS AND DEMANDS IN THE
SUM OF $976,617.78 COVERING REGULAR PAYROLL ENDING
NOVEMBER 24, 2023
NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF BUENA PARK DOES HEREBY RESOLVE, DETERMINE AND ORDER AS FOLLOWS:
SECTION 1: That in accordance with Section 37208 of the Government Code, the Director of Finance or his designated representative hereby certifies to the accuracy of the following demands and to the availability of funds for payment thereof.
__________________________________
Director of Finance
SECTION 2: The claims and demands in the sum of $976,617.78 set forth on this 8-page register attached to this resolution and made a part hereof have been audited as required by law and are hereby allowed in the amount set forth.
PASSED AND ADOPTED this _____ day of _______________ 2023 by the following called vote:
AYES:
NOES:
ABSENT:
ABSTAIN:
______________________________
Mayor
ATTEST:
__________________________
City Clerk
RESOLUTION NO. _______
I hereby certify that the foregoing resolution was duly and regularly passed and adopted at a regular meeting of the City Council of the City of Buena Park held this _____ day of _______________ 2023.
_____________________________
City Clerk
SUNGARD PUBLIC SECTOR PAGE NUMBER: 1 DATE: 11/30/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:22:02 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MI1'
ALL CHECKS
PAYRUN: MI1
DATE: 12/01/2023
CHECK DEPOSIT CHECK
NUMBER AMOUNT AMOUNT MAN/VOID ----------EMPLOYEE---------- ID NUMBER V396414 1,014.16 .00 CABRERA, AMBER 248 V396415 4,026.83 .00 COPPING, SARA 951 V396416 1,081.74 .00 DIAZ, MICHELLE 419 V396417 2,756.00 .00 DIEZ, KARINA 169 V396418 2,015.21 .00 ENGLEBRECHT, BRIDGET 261 V396419 2,522.37 .00 FEWER, JESSICA 580 V396420 6,826.79 .00 FRANCE, AARON 1650 V396421 2,688.62 .00 MEDINA, YARETZA 8 V396422 668.18 .00 AHN, JOYCE 263 V396423 648.57 .00 BROWN, ARTHUR 655 V396424 724.57 .00 CASTANEDA, JOSE 277 V396425 595.17 .00 SONNE, SUSAN 5161 V396426 505.56 .00 TRAUT, CONNOR 5399 V396427 937.31 .00 AVITIA, LISA 114 V396428 2,667.84 .00 BADILLO, ANNA PATRICIA 168 V396429 1,622.41 .00 GUERRA, SARAH 1470 V396430 4,997.93 .00 JIMENEZ, ADRIA 2297 V396431 771.93 .00 KIRK, RALPH 384 V396432 1,834.08 .00 LOPEZ, ANGELICA 2928 V396433 4,298.33 .00 FENTON, EDWARD 1564 V396434 1,503.30 .00 GONZALEZ, JACQUELINE 157 V396435 1,714.48 .00 KERN, DONNA 2574 V396436 2,207.87 .00 PREVO, DOREKA 390 V396437 3,167.94 .00 VALDEZ, REBECCA 5490 V396438 1,529.91 .00 BUENROSTRO, PATRICIA 227 V396439 3,842.96 .00 GARCIA, ADRIAN 1700 V396440 1,094.77 .00 GLAVIN, BARBARA 1768 V396441 1,861.03 .00 HERNANDEZ, GLORIA 2092 V396442 6,186.20 .00 HYUN, SUNG 2248 V396443 2,009.03 .00 KIM, MIN 2584 V396444 1,977.81 .00 LOVEJOY, REBEKAH 76 V396445 2,339.86 .00 MENDOZA, MARIA 3293 V396446 743.54 .00 OZAKI, GRACE 3881 V396447 1,812.04 .00 PAK, TIMOTHY 3955 V396448 2,608.94 .00 PEREZ, JESSICA 4111 V396449 2,373.54 .00 TOMASSETTI, JEEVANI 5623 V396450 1,970.02 .00 TRAN, KRYSTLE 242 V396451 4,032.81 .00 AVERELL, MARK 272 V396452 2,288.29 .00 COLES-GUZMAN, MARY 950 V396453 1,924.27 .00 KENNEDY, SEAN 111 V396454 1,677.77 .00 BELTRAN, CINDY 467 V396455 894.44 .00 CARDENAS, MARGARET 336 V396456 2,916.37 .00 CULL, ROBERT 1012 V396457 2,562.05 .00 LESTER, ALEXANDER 2868 V396458 1,727.09 .00 MACIAS, JUDITH 2996 V396459 2,151.48 .00 MAYORQUIN, RAYMUNDO 221 V396460 2,573.11 .00 TART, ANDRE 5235 V396461 3,947.82 .00 CAMACHO, MARIO 731 V396462 1,124.57 .00 CASTANEDA, GUADALUPE 280 V396463 2,174.34 .00 CATALDO, JOHN 766 SUNGARD PUBLIC SECTOR PAGE NUMBER: 2 DATE: 11/30/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:22:02 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MI1'
ALL CHECKS
V396464 694.22 .00 COHEN-DORON, JILL 841 V396465 1,939.89 .00 DAVIS-VALENTINE, SUZANNE 1085 V396466 2,358.72 .00 DE LA PAZ, TIANNA 297 V396467 452.03 .00 DINH, MICHELLE 433 V396468 5,898.90 .00 FOULKES, MATTHEW 9 V396469 3,446.87 .00 LUNA, HARALD 264 V396470 2,454.39 .00 MCALEESE, IAN 159 V396471 4,229.82 .00 MESHRAM, SWATI 3321 V396472 3,051.15 .00 NAVARRO, SANDRA 93 V396473 220.79 .00 SANCHEZ, VIVIANA 4616 V396474 2,417.30 .00 SANTOS, RUTH 4640 V396475 2,406.85 .00 SCHAETZL, RANA 431 V396476 1,550.00 .00 TAE, RAY 5196 V396477 2,088.52 .00 ZAPIEN, ERNESTINE 5777 V396478 2,172.91 .00 ARDAIZ, LANA 190 V396479 3,126.66 .00 DHAUW, MELISSA 1170 V396480 2,761.47 .00 SUAREZ, SARABETH 5169 V396481 2,896.59 .00 YOON, JIWON 91 V396482 2,254.15 .00 COTA, LORRAINE 954 V396483 5,311.33 .00 GEYER, BRADLEY 1692 V396484 5,225.46 .00 HONG, ALEX 2130 V396485 2,279.86 .00 MARTINEZ, JESSICA 2936 V396486 5,551.31 .00 NGUYEN, NGHIA 3755 V396487 6,400.48 .00 NUNES, FRANK 3813 V396488 1,632.92 .00 CHARNES, LANCE 783 V396489 6,964.90 .00 DIERINGER, RYAN 1145 V396490 3,408.00 .00 JIMENEZ, ROBERT 352 V396491 2,954.86 .00 KIM, HYUN 328 V396492 2,591.28 .00 LAM, DAVID 2790 V396493 413.71 .00 LOVCHIK, MICHAEL 6 V396494 3,892.06 .00 MIKIEWICZ, SIMON 3360 V396495 1,909.27 .00 NOVOTNY, MARY 3705 V396496 2,177.11 .00 SEMAAN, NADIA 4740 V396497 4,534.94 .00 TOMSICK, MARTIN 5360 V396498 4,964.17 .00 WEAVER, CHAD 5577 V396499 2,830.78 .00 ALCALA, BRITTANY 58 V396500 3,158.69 .00 BARAJAS, MAYRA 357 V396501 265.53 .00 BARR, LISA 366 V396502 1,994.60 .00 BINYON, ERIC 506 V396503 5,073.60 .00 BRANDSTETTER, JAMES 629 V396504 4,200.94 .00 BUTH, CATHERINE 561 V396505 3,863.08 .00 CARPENTER, SCARLET 1663 V396506 833.09 .00 CONN, SANDRA 961 V396507 293.61 .00 DIERINGER, REGINA 1515 V396508 3,248.70 .00 ESCOBEDO, STACEY 1530 V396509 3,960.72 .00 ESQUETINI, MARIA 1536 V396510 748.34 .00 ESTRELLA, CARL JOSEPH 415 V396511 2,395.89 .00 HERNANDEZ, ISABELLA 112 V396512 2,954.90 .00 MAERKER, ELIZABETH 3017 V396513 4,097.68 .00 MCGRATH, CODY 3220 V396514 748.34 .00 MENDOZA HERNANDEZ, STEPHANIE 427 V396515 748.83 .00 MEONO, ROBIN 351 V396516 1,955.78 .00 MORALES MALDONADO, IVETT 3490 V396517 2,677.11 .00 PALMA CARDENAS, DIANA 3970 V396518 699.55 .00 RAMIREZ, ARIANNA 86 V396519 852.81 .00 RODRIGUEZ VILLA, YARELI 205 SUNGARD PUBLIC SECTOR PAGE NUMBER: 3 DATE: 11/30/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:22:02 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MI1'
ALL CHECKS
V396520 2,303.80 .00 SAUCEDA, CATHLEEN 4645 V396521 4,371.42 .00 SHERIFF, SAMANTHA 2096 V396522 3,673.03 .00 TANIGUCHI, MELISSA 5230 V396523 714.96 .00 VELLANOWETH, KRISTINE 217 V396524 2,400.69 .00 FIORE, KATE 1560 V396525 3,434.66 .00 FOX, CHARITY 1641 V396526 754.33 .00 KUHN, MICHELLE 2730 V396527 670.17 .00 KUHN, TARI 2747 V396528 3,108.91 .00 LARA, KARON 103 V396529 2,787.54 .00 MEDINA, IVONNE 222 V396530 3,481.78 .00 MENDIVEL, CHRISTINA 3299 V396531 1,978.44 .00 NGO, CATHERINE 3752 V396532 2,280.16 .00 PENDLETON, SUN 4080 V396533 2,233.61 .00 TENG, LING-FEI 2871 V396534 2,424.65 .00 UMLAH, AMBER 5435 V396535 5,619.73 .00 BATES, PATRICK 378 V396536 4,401.37 .00 BELTRAN, CHRISTINA 13 V396537 5,589.55 .00 BERNAL, DAVID 480 V396538 4,155.56 .00 BOURNE, CLIFFORD 5612 V396539 5,923.52 .00 BOYD, ROBERT 584 V396540 3,994.12 .00 BOYER, CAMERON 585 V396541 5,002.74 .00 BOYINGTON, DEVIN 594 V396542 4,573.01 .00 BRAVO, ISABEL 420 V396543 4,268.06 .00 BURNETT, DEBORAH 110 V396544 4,479.00 .00 CAMPOS, LOLANI 728 V396545 5,147.10 .00 CARNEY, THOMAS 751 V396546 2,438.06 .00 CERDA, SERGIO 240 V396547 3,550.88 .00 CHAVEZ, ALEJANDRO 182 V396548 2,877.75 .00 CHAVEZ, ANTONY 246 V396549 5,072.15 .00 CHOI, JONATHON 827 V396550 4,884.33 .00 CHRISTIANSEN, ANDREW 97 V396551 2,265.60 .00 CURATOLA, ANTHONY 350 V396552 4,248.45 .00 DAVIS, JONATHAN 1083 V396553 3,660.80 .00 EK, CHRISTOPHER 1477 V396554 4,986.91 .00 ESCAMILLA, MARIO 1529 V396555 3,876.95 .00 ESCOBEDO, DOMINICK 1521 V396556 5,363.32 .00 FRANKLIN, KEVIN 1649 V396557 6,985.23 .00 GALOS, MICHAEL 1680 V396558 5,433.00 .00 GANO, KEVIN 1742 V396559 3,439.90 .00 GONZALEZ, LUIS 164 V396560 4,808.44 .00 GONZALEZ, OSCAR 1785 V396561 4,565.57 .00 HERST, RYAN 2102 V396562 2,140.53 .00 HOGAN, CHRISTIAN MICHAEL 138 V396563 5,627.15 .00 JIMENEZ, GUSTAVO 2285 V396564 5,957.64 .00 LEE, CONNOR 2861 V396565 6,515.26 .00 LEPE, SERGIO 2901 V396566 5,786.11 .00 LIRA, JOSEPH 133 V396567 4,229.79 .00 LOPEZ, GUILLERMO 2958 V396568 3,616.67 .00 LOVETERE, JOSEPH 2962 V396569 3,881.50 .00 MARTINEZ, JESUS 117 V396570 4,129.50 .00 MEDRANO, JULIAN 3223 V396571 4,937.37 .00 MOELLER, SARAH 3590 V396572 3,508.31 .00 MOON, DAVID 3479 V396573 4,671.55 .00 MUNOZ, OSCAR 3605 V396574 4,943.95 .00 MURILLO CASTRO, JULIAN 268 V396575 2,957.19 .00 NGUYEN, ANTHONY 258 SUNGARD PUBLIC SECTOR PAGE NUMBER: 4 DATE: 11/30/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:22:02 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MI1'
ALL CHECKS
V396576 8,531.33 .00 NYHUS, CHRISTOPHER 3808 V396577 6,096.52 .00 O'DETTE, DIRK 3823 V396578 4,650.17 .00 OH, WILLIAM 326 V396579 4,813.82 .00 PADILLA, VALERIE 108 V396580 8,741.67 .00 PINO, RICHARD 4171 V396581 5,774.27 .00 PROCEL, ANDY 4243 V396582 4,676.25 .00 RAMIREZ, ANGEL 4314 V396583 3,597.94 .00 RANGEL, PRISCILLA 4337 V396584 5,363.09 .00 REYES, HUGO 98 V396585 3,444.61 .00 RODRIGUEZ, CHRISTIAN 4476 V396586 4,021.15 .00 RODRIGUEZ CASTILLERO, JOSEPH 259 V396587 3,659.95 .00 RUBALCAVA, EFRAIN 4590 V396588 4,372.34 .00 TEWELL, MELISSA 5282 V396589 2,128.46 .00 TRAN, JENNIFER 9666 V396590 5,023.00 .00 TRAN, TUYET 5424 V396591 3,868.53 .00 TURNER, JERAMIAH 291 V396592 4,618.36 .00 VU, JEFFREY 5519 V396593 6,421.86 .00 WILLIAMS, JUDITH 5660 V396594 3,878.64 .00 YO, DANIEL 5752 V396595 7,042.94 .00 COLON, BOBBY 900 V396596 4,577.06 .00 JOHNSON, BRYAN 2300 V396597 2,448.50 .00 MAERTZ, DANA 3018 V396598 2,061.87 .00 RANGEL, JENNY 283 V396599 7,901.56 .00 RICE, JAMES 4408 V396600 4,343.71 .00 SALAZAR, RYAN 4626 V396601 7,675.74 .00 SHADDOW, JON-MICHAEL 4837 V396602 1,917.82 .00 SILVA, OSCAR 4886 V396603 2,257.08 .00 VAZQUEZ-CAMACHO, MARLENE 101 V396604 258.80 .00 BAIR, JOHN 284 V396605 207.04 .00 CASEY, DROUETT 771 V396606 5,289.34 .00 BAILEY, JOHN 355 V396607 4,079.56 .00 BOUDREAU, CORY 583 V396608 2,035.53 .00 BOUDREAU, LAURA 2192 V396609 2,164.53 .00 CHAN, KARA 795 V396610 5,522.92 .00 DAVENPORT, JOSEPH 1094 V396611 5,223.56 .00 GENTNER, GEORGE 1765 V396612 3,014.21 .00 KALAGIAN, BRYANT 2436 V396613 2,516.87 .00 LOMELI, LISBETH 4516 V396614 3,105.68 .00 LOPEZ, VANESSA 2929 V396615 4,482.20 .00 LOPEZ, WILLYVALDO 2941 V396616 4,188.23 .00 LOWE, AUSTIN 2956 V396617 4,048.33 .00 MORALES, FRANK 3489 V396618 1,761.67 .00 O'DETTE, NANCY 1920 V396619 4,123.10 .00 ORTEGA, MICHAEL 104 V396620 3,723.88 .00 PANTOJA, DAVID 3986 V396621 6,124.41 .00 PLUMLEE, ROGER 4180 V396622 4,361.39 .00 SOLIS, DANIEL 5000 V396623 2,146.20 .00 SULLIVAN, STACEY 5160 V396624 3,086.76 .00 TREADWAY, SARA 4210 V396625 3,589.18 .00 VU, KRISTINE 63 V396626 2,555.22 .00 CAPISTRANO, FRANCES 74 V396627 1,764.49 .00 IBARRA, KRISTI 88 V396628 5,374.00 .00 MIKHAEL, MINA 3359 V396629 1,796.33 .00 ALMANZA, MINERVA 79 V396630 3,620.12 .00 ALQAM, NADER 71 V396631 3,821.95 .00 ARABOLU, DEEPTHI 178 SUNGARD PUBLIC SECTOR PAGE NUMBER: 5 DATE: 11/30/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:22:02 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MI1'
ALL CHECKS
V396632 2,485.22 .00 ESPARZA-ALMARAZ, AARON 383 V396633 3,436.03 .00 KIM, KENNETH 2587 V396634 2,934.57 .00 LANNAN, GREGORY 2791 V396635 3,088.62 .00 LEE, HYANG SUN 430 V396636 9,247.38 .00 ORTIZ, CESAR 92 V396637 2,617.50 .00 PENA, MANUEL 2933 V396638 486.55 .00 SYFRITT, MATTHEW-WAYNE 428 V396639 2,813.38 .00 TRAN, JASON 96 V396640 4,829.01 .00 WRAY, NORMAN 5725 V396641 2,121.45 .00 ZARAGOZA, EDUARDO 5788 V396642 2,720.48 .00 AUBUCHON, LAURIE 250 V396643 2,429.89 .00 GENERA, ELIZABETH 1685 V396644 4,012.49 .00 HUNT, JOSEPH 2249 V396645 1,698.69 .00 LUX, ANDREA 2972 V396646 938.87 .00 ARREOLA, ERIK 223 V396647 2,100.96 .00 BACA, ANDREW 315 V396648 1,211.91 .00 BANUELOS, CHRISTOPHER 345 V396649 2,289.84 .00 BRITO, MICHAEL 642 V396650 2,156.39 .00 ESCATEL-OROSCO, PEDRO 1537 V396651 2,244.22 .00 GONZALEZ, ALEJANDRO 1783 V396652 1,232.53 .00 GUZMAN, KEVIN 132 V396653 3,867.05 .00 LIBUNAO, NINO 2912 V396654 1,258.30 .00 LISCANO, CHRISTOPHER 850 V396655 1,301.22 .00 MARASCO, MATTHEW 289 V396656 1,346.57 .00 MUNOZ, GENE 3600 V396657 1,431.46 .00 MUNOZ, JOHNNY 144 V396658 1,211.91 .00 ORTIZ, RAYMOND 309 V396659 1,211.92 .00 PRECIADO, CAMDEN 134 V396660 1,211.95 .00 REYNOLDS, BILLY 417 V396661 1,211.91 .00 RIOS, DANNY 282 V396662 2,610.66 .00 RIVERA, JOE 4450 V396663 1,211.92 .00 RODRIGUEZ, NATHANIAL 288 V396664 1,479.13 .00 RODRIGUEZ, OSCAR 131 V396665 1,714.61 .00 SERNA, JUAN 4728 V396666 2,664.11 .00 TORREZ, JAVIER 69 V396667 1,877.39 .00 VAZQUEZ, JOE 5473 V396668 2,586.47 .00 CARRILLO, EDWARD 765 V396669 2,313.03 .00 ELLS, ZACHARY 1500 V396670 1,860.93 .00 ENNIS, JOSEPH 262 V396671 3,117.20 .00 FINCH, BARRETT 1574 V396672 2,692.21 .00 HAGAN, KEVIN 1947 V396673 3,135.00 .00 KVENBO, SCOTT 2750 V396674 1,898.17 .00 MARTINEZ, MARCO 215 V396675 3,951.64 .00 MCGEE, MICHAEL 9306 V396676 2,157.98 .00 MENDOZA, JOHN 3292 V396677 2,382.63 .00 MILLER, DAVID 3390 V396678 2,917.45 .00 MOJARRO, ANDREW 3082 V396679 3,134.10 .00 MOORE, FRANK 3486 V396680 2,474.07 .00 ROMERO, FIDEL 4530 V396681 2,078.65 .00 SANCHEZ, JUAN 4617 V396682 2,005.60 .00 SPEAR, ANTHONY 5011 V396683 2,902.89 .00 STEPHENSON, MARK 5122 V396684 2,911.34 .00 TAVARES, JAMEY 5231 V396685 2,595.91 .00 VENEGAS MENDEZ, JAVIER 5491 V396686 932.94 .00 ALVAREZ, CARLOS 136 V396687 2,333.26 .00 DAHL, TERRY 1084 SUNGARD PUBLIC SECTOR PAGE NUMBER: 6 DATE: 11/30/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:22:02 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MI1'
ALL CHECKS
V396688 2,372.19 .00 GARCIA ORTEGA, JOSE 1636 V396689 1,818.39 .00 GRIMES, DAVID 1881 V396690 2,172.86 .00 KOSS, MICHAEL 2718 V396691 2,877.62 .00 MARTINEZ, GABRIEL 3139 V396692 2,352.27 .00 MELLADO, KIM 3289 V396693 2,543.94 .00 MERROW, MATTHEW 3316 V396694 1,881.84 .00 OTTEN, DAVID 3869 V396695 1,761.55 .00 PEREZ, ADRIAN 257 V396696 3,233.14 .00 PORTER, JEFFREY 4174 V396697 2,623.89 .00 RODRIGUEZ, EDWARD 4479 V396698 932.94 .00 RUIZ, ALEJANDRO 416 V396699 1,073.73 .00 SOLOMAN, CARLOS 4891 V396700 1,670.94 .00 TORRES, SALVADOR 234 V396701 2,077.63 .00 WELLS, ANTHONY 5610 V396702 738.90 .00 AVERELL, ANDREW 349 V396703 2,394.59 .00 CAMPIZTA, ADAM 225 V396704 2,817.32 .00 MACIAS, RAYMOND 2998 V396705 1,938.17 .00 MILLER-SPARKS, WILLIAM 216 V396706 2,274.58 .00 WEAR, JOHN 5606 V396707 6,126.20 .00 BOX, JAMES 576 V396708 23.70 .00 CABALO, ORLANDO 396 V396709 1,869.44 .00 CHAVEZ, ARIANA 788 V396710 1,700.74 .00 CONTRERAS, SAUL 95 V396711 23.70 .00 HOLGUIN, COURTNEY 394 V396712 23.70 .00 HOQUE, LAMIYA 412 V396713 4,662.37 .00 KURATA, DALE 2749 V396714 23.70 .00 MCCANN, CAROL 439 V396715 1,996.63 .00 REYNOLDS, BRANDON 4384 V396716 23.70 .00 ROSS, IRVING 435 V396717 23.70 .00 RYU, MIN 411 V396718 799.71 .00 SANCHEZ, CHRISTOPHER 236 V396719 2,212.61 .00 SANCHEZ-REYES, KEVIN 83 V396720 3,106.92 .00 SAUCEDA, MARK 4642 V396721 23.70 .00 STAINE, NADINE 401 V396722 23.70 .00 WALLACE, DEAN 402 V396723 23.70 .00 WEINSTOCK, MICHAEL 410 V396724 23.70 .00 YUN, HYEWON 432 V396725 851.59 .00 ALVARADO, ADRIAN 89 V396726 608.51 .00 BAHENA, PEDRO 148 V396727 537.70 .00 BARENG, KATHERINE 33 V396728 737.81 .00 BELCHER-HALL, JACOB 333 V396729 824.62 .00 CARNES, ALISSA 34 V396730 497.70 .00 CARVENTE, GIANJAVIER 334 V396731 831.23 .00 CISNEROS, MICHELLE 812 V396732 356.68 .00 CLARK-PRUDHOMME, MATTHEW 307 V396733 132.72 .00 DIEGO, NICOLE 331 V396734 504.63 .00 DOWDLE, JACKSON 1386 V396735 774.16 .00 FERNANDEZ, GISSEL 330 V396736 248.85 .00 GARCIA, MICHELE 171 V396737 634.60 .00 GONZALEZ, ISAAC 294 V396738 630.60 .00 GONZALEZ, LUIS 1780 V396739 608.51 .00 GRANADOS, REGINA 145 V396740 505.99 .00 GRANDE, DANIELLE 124 V396741 737.81 .00 GUERRA, ATHZIRI 141 V396742 464.51 .00 GUILLEN, JAYDEN 339 V396743 589.12 .00 GUTIERREZ, MICHELLE 1925 SUNGARD PUBLIC SECTOR PAGE NUMBER: 7 DATE: 11/30/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:22:02 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MI1'
ALL CHECKS
V396744 556.00 .00 HERNANDEZ, KATE 2091 V396745 1,052.22 .00 HOLLOWAY, ELIZABETH 2185 V396746 645.63 .00 JUBRAN, NOAH 127 V396747 244.71 .00 LEWIS, ALEC 266 V396748 693.63 .00 MAGANA, ADAM 173 V396749 1,853.50 .00 MARTINEZ, SERENA 3147 V396750 605.57 .00 MEZA, ADRIAN 122 V396751 1,047.15 .00 MOLAR, BARBARA 3449 V396752 1,163.87 .00 MORENO, ANDREW 161 V396753 443.79 .00 NGHIEM, NATALIE 249 V396754 721.94 .00 NGUYEN, KEVIN 299 V396755 836.15 .00 NUNEZ, HAZEL 3806 V396756 258.69 .00 OLVERA, DAVID 3841 V396757 627.36 .00 ONTIVEROS, IZABELLA 3864 V396758 497.70 .00 RAY, SABRINA 286 V396759 1,155.97 .00 RIVERA GOMEZ, YAMILEX 4432 V396760 530.26 .00 RODRIGUEZ, MIKAYLA 295 V396761 348.39 .00 RONQUILLO, JAZZIE 172 V396762 817.76 .00 ROQUE, KATRINA 38 V396763 692.24 .00 RUSSELL, JEFFREY 150 V396764 672.66 .00 SALDANA, JONATHAN 4625 V396765 132.72 .00 SOLIMAN, MARSEL 322 V396766 414.75 .00 SOLTERO, JESSE 177 V396767 560.07 .00 SORIA, NOAH 5004 V396768 605.81 .00 STRICKLER, LINDA 5135 V396769 481.11 .00 TAPIA, ANGELICA 306 V396770 951.96 .00 THOMSEN, MATTHEW 194 V396771 340.10 .00 TOVAR, SOFIA 301 V396772 2,522.31 .00 VAN SICKLE, MICHELLE 2076 V396773 589.87 .00 VAZQUEZ, OSCAR 152 V396774 593.61 .00 VELOZ, SABRINA 146 V396775 947.15 .00 WONGSUPHAKPHAN, BRIANNA 337 V396776 273.00 .00 RODRIGUEZ, PERLA 4488 V396777 140.68 .00 SINGH, YASHPREET 48 V396778 257.15 .00 SMITH, JOHN 210 V396779 338.52 .00 ZAPATA, ALEXANDRIA 303 V396780 710.35 .00 AGUILAR, KALVIN 23 V396781 472.82 .00 BARTOLO, BRYAN 338 V396782 730.53 .00 BUSTAMANTE VALLADARES, DIANA 285 V396783 712.90 .00 CABUSAO, NINA MARINELLA 729 V396784 634.60 .00 CARDENAS, DIEGO 275 V396785 899.69 .00 CASTILLO, DARLENE 119 V396786 955.05 .00 CERVANTES, BRIANA 757 V396787 323.50 .00 CLARK-PRUDHOMME, MACKENZIE 206 V396788 2,076.62 .00 DAVIS, TANIKKA 1082 V396789 750.68 .00 DETERDING, CARSON 1132 V396790 1,919.24 .00 GILLIAM, VERONICA 218 V396791 792.01 .00 GUERRA, ROCCO 44 V396792 703.25 .00 HONG, YI 2189 V396793 3,050.81 .00 HURTADO, MARIA 353 V396794 773.76 .00 JIMENEZ, GLADIS 434 V396795 1,179.86 .00 LARIZ RUBALCAVA, CARLOS 429 V396796 1,741.87 .00 MARQUEZ PINEDO, ANALISA 3118 V396797 1,128.25 .00 MINIKEY, MOLLY 425 V396798 623.42 .00 MORISON, MATTHEW 243 V396799 2,082.47 .00 NIELSEN, ROSEMARY 3760 SUNGARD PUBLIC SECTOR PAGE NUMBER: 8 DATE: 11/30/2023 CITY OF BUENA PARK PAYREP83 TIME: 12:22:02 CHECK REGISTER(CONCISE) SELECTION CRITERIA: checkhis.pay_run='MI1'
ALL CHECKS
V396800 1,712.84 .00 NORIEGA, MICHELLE 3782 V396801 331.79 .00 ONTIVEROS, STEVEN 342 V396802 665.15 .00 ORTIZ, YAHAIRA 241 V396803 99.54 .00 PULIDO, MARLENE 39 V396804 265.10 .00 RUIZ, ANA 4591 V396805 489.40 .00 SERRATOS, DARIAN 160 V396806 489.40 .00 SOSA, ELIANNA 341 V396807 1,305.21 .00 SOTO, JOSE 229 V396808 199.07 .00 SOTO DONACIANO, ANGEL 287 V396809 614.18 .00 TAILOR, DIYA 175 V396810 908.82 .00 VALDEZ, NATALIA 46 V396811 436.50 .00 VEGA-MATA, PEDRO 278 V396812 389.87 .00 ZAZUETA, RYAN 267
PAYRUN TOTAL
CHECK: 399 976,617.78 .00
TOTAL
CHECKS: 399 976,617.78 .00
City of Buena Park
City Council Regular Meeting Agenda Report
TREASURER'S REPORT FOR THE MONTH OF OCTOBER 2023
Meeting
Tuesday, December 12, 2023, 5:00 PM
Agenda Group
CONSENT CALENDAR Item: 4B
Presented By
Sung Hyun, Director of Finance
Prepared By
Sung Hyun, Director of Finance
Approved By
Aaron France, City Manager
Attachments
Treasurers Report Att1of4.pdf
Treasurers Report Att2of4.pdf
Treasurers Report Att3of4.pdf
Treasurers Report Att4of4.pdf
RECOMMENDED ACTION
Receive and file the reports.
PREVIOUS CITY COUNCIL ACTION
None.
DISCUSSION
The City of Buena Park's Investment Policy adopted by the City Council on February 14, 2023, requires the City Treasurer to submit a detailed investment report to the City Council.
Attached for review are the Treasurer's Investment Reports for the month of October 2023. All of the investments listed meet the requirements of both the Government Code and the City Investment Policy.
BUDGET IMPACT
None.
RDA
City Bond Proceeds
DESCRIPTION Book Balance Series B Total
Union Bank - City Checking Account 4,253,139.27 - 4,253,139.27 Union Bank - Outstanding checks (447,166.23) - (447,166.23) Union Bank - Outstanding deposits 685,825.18 - 685,825.18 4,491,798.22 - 4,491,798.22 Local Agency Investment Fund 20,060,634.83 - 20,060,634.83 Governmental Agency Securities 32,320,831.90 - 32,320,831.90 Commercial Paper 971,071.11 - 971,071.11 Money Market Mutual 2,051,296.84 1,252,977.95 3,304,274.79 Supranational 2,954,743.50 - 2,954,743.50 Corporate 20,669,371.85 - 20,669,371.85 U S Treasury 43,860,279.33 - 43,860,279.33 122,888,229.36 1,252,977.95 124,141,207.31
Total 127,380,027.58 1,252,977.95 128,633,005.53 Cash
Fund Description Balance
11 - General Fund 46,420,634.27
12 - Economic Development Fund 6,584,964.28
17 - Opioid Settlement Fund 163,891.34
18 - Local Law Enforcement Fund 63,003.84
20 - Asset Forfeiture Fund 583,002.83
21 - Capital Project Fund (553,447.59)
22 - Prop 172 PD Augment Fund 181,526.20
23 - State Law Enf Supp Fund 184,574.71
24 - State Gas Tax Fund 6,738,996.19
25 - Measure M2 2,584,566.00
28 - HOME Deferred Loan Fund 1,791,184.49
29 - Economic Development Fund (CDBG) (183,290.61)
30 - State OCATT Fund (2,980.00)
31 - Calhome Program 1,191,994.96
32 - Park In-Lieu Fund 2,521,191.91
33 - Traffic Congestion Relief Fund 41,034.11
40 - AB 2766 (AQMD) Fund 613,272.31
52 - Water Enterprise Fund 35,613,024.52
62 - Workers' Comp Self-Ins Fund 2,205,065.33
63 - Public Liab Self-Ins Fund 1,985,872.74
65 - Accrued Leave Fund 54,261.53
71 - Equip Maint & Replacement Fund 8,010,502.43
73 - Payroll Revolving Fund -
74 - Management Info Systems Fund 1,645,881.12
77 - Gov't Buildings Maintenance Fund 805,088.70
96 - Tourism & Marketing Dist 558,039.45
97 - Successor Fund to RDA 5,827,763.86
98 - Housing Successor Fund 3,003,386.61
Total Cash 128,633,005.53
* All investments are made in accordance with the City's adopted investment policy. * The City has sufficient resources to meet expenditures for the next six (6) months. s:\shared\treasury\cash\invstrpt.xls
CITY OF BUENA PARK
Treasurer's Report of Monies on Deposit
Period Ending October 31, 2023
ACCOUNT SUMMARYBeg. Valuesas of 9/30/23End Valuesas of 10/31/23Market Value98,962,47999,117,499Accrued Interest507,914541,168Total Market Value99,470,39399,658,667Income Earned228,450229,988Cont/WD-7,644Par103,976,126104,131,297Book Value102,804,761102,993,850Cost Value102,673,852102,827,595TOP ISSUERSGovernment of United States 42.7%Federal Home Loan Bank 13.1%Federal National Mortgage Assoc 7.8%Federal Farm Credit Bank 5.4%Federal Home Loan Mortgage Corp 5.0%Federated GOVT Obligation MMF 2.1%Inter-American Dev Bank 1.5%Intl Bank Recon and Development 1.4%Total 79.0%PORTFOLIO CHARACTERISTICSAverage Modified Duration 1.88Average Coupon 2.31%Average Purchase YTM 2.71%Average Market YTM 5.28%Average S&P/Moody Rating AA/Aa1Average Final Maturity 2.02 yrsAverage Life 2.01 yrsCREDIT QUALITY (S&P)
MATURITY DISTRIBUTION
SECTOR ALLOCATION
Portfolio SummaryAs of October 31, 2023
City of Buena Park CoreAccount #405
PERFORMANCE REVIEWAnnualizedTOTAL RATE OF RETURN1M3MYTD1YR2YRS3YRS5YRS10YRS12/31/2005City of Buena Park Core 0.20% 0.36% 2.09% 3.30% -0.99% -0.80% 1.24% 1.05% 2.11%ICE BofA 0-5 Yr US Treasury Index 0.19% 0.35% 1.92% 2.98% -1.14% -0.94% 1.14% 0.91% 1.93%Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 1 Category Standard Comment U.S. TreasuriesNo limitations; U.S. Treasury and other government obligations for which the full faith and credit of the U.S. are pledged for the payment of principal and interest.CompliesFederal Agencies30% max per U.S. Agency issuer; 20% max callable agency securities; Federal Agency or U.S. government-sponsored enterprise obligations, participations, or other instruments, including those issued by or fully guaranteed as to principal and interest by federal agencies or U.S. government-sponsored enterprises.CompliesSupranational Obligations"AA" rating category or higher by a NRSRO; 30% max; 10% max per issuer; USD denominated senior unsecured unsubordinated obligations issued or unconditionally guaranteed by IBRD, IFC, or IADBCompliesMunicipal Securities"A" rating category or better by a NRSRO; 30% max; 5% max per issuer; Include obligations of the City, the State of California and any local agency within the State of California; Any of the other 49 states in addition to California, including bonds payable solely out of the revenues from a revenue-producing property owned, controlled, or operated by a state or by a department, board, agency, or authority of any of the other 49 states, in addition to California.CompliesCorporate Medium Term Notes"A" rating category or better by a NRSRO; 30% max; 5% max per issuer; Issued by corporations organized and operating within the U.S. or by depository institutions licensed by the U.S. or any state and operating within the U.S.CompliesAsset-Backed, Mortgage-Backed, Mortgage Pass-Through Securities, Collateralized Mortgage Obligations"AA" rating category or better by a NRSRO; 20% combined maximum; From issuers not defined in the U.S. Treasury Securities or U.S. Government Agency Obligations sections of the Authorized and Suitable Investments section of the investment policy. CompliesNegotiable Certificates of Deposit (NCDs)"A-1" short term rated or higher by a NRSRO; and/ or "A" long-term issuer rating category or higher by a NRSRO; 30% max; 5% max per issuerCompliesFDIC Insured Time Deposits (Non-negotiable CD/TD)Non-Negotiable Certificates of Deposit in state or federally chartered banks, savings and loans, or credit unions; The amount per institution is limited to maximum covered under FDIC; 20% max combined FDIC & Collateralized CD/TD; 5% max per issuerCompliesCollateralized Time Deposits (Non-negotiable CD/TD)Non-Negotiable Certificates of Deposit in state or federally chartered banks, savings and loans, or credit unions in excess of insured amounts which are fully collateralized with securities in accordance with California law; 20% max combined FDIC & Collateralized CD/TD; 5% max per issuerComplies"A-1" short term rated or higher by a NRSRO; and "A" long term debt rating category or higher by a NRSRO; 20% max; 5% max per issuer; 180 days max maturityCompliesCommercial Paper25% max; 5% max per issuer; 270 days maturity; 10% maximum of the outstanding commercial paper of any single issuer; Issued by an entity that meets all of the following conditions in either (a) or (b):a. Securities issued by corporations: (i) organized and operating within the U.S. with assets > $500 million; (ii) "A-1" rated or better by a NRSRO; (iii) "A" rating or better by a NRSRO, if issuer has debt obligations.b. Securities issued by other entities: (i) organized within the U.S. as a special purpose corporation, trust, or limited liability company; (ii) must have program-wide credit enhancements including, but not limited to, overcollateralization, letters of credit, or a surety bond; (iii) rated "A-1" or better by a NRSRO.Complies City of Buena ParkStatement of ComplianceAs of October 31, 2023
Money Market Mutual FundsRegistered with SEC under Investment Company Act of 1940 and issued by diversified management companies and meet either of the following criteria:(i) Highest rating by two NRSROs; or (ii) Retained an investment adviser registered or exempt from SEC registration with > 5 years experience managing money market mutual funds with AUM >$500 million;20% max combined Money Market Mutual Funds and Mutual FundsCompliesMutual FundsInvest in securities as authorized under CGC, Section 53601 (a) to (k) and (m) to (q) inclusive and meet either of the following criteria:(i) Highest rating by two NRSROs; or (ii) Retained an investment adviser registered or exempt from SEC registration with > 5 years experience investing in securities authorized by CGC, Section 53601 and with AUM >$500 million;20% max combined Money Market Mutual Funds and Mutual Funds; 10% max per Mutual FundCompliesLocal Agency Investment Fund (LAIF) Maximum permitted amount in LAIF; 35% max of portfolio; Not used by investment adviserCompliesRepurchase Agreements 15% max; 30 days max maturity; 102% Collateralized; Not used by investment adviserCompliesProhibited SecuritiesAny investments not specifically described in the policy; Futures and options; Inverse floaters; Ranges notes, Mortgage derived interest-only strips; Zero interest accrual securities if held to maturity; Trading securities for the sole purpose of speculating in the future direction of interest rates; Purchasing or selling securities on margin, Reverse Repurchase Agreements; Securities lending; Foreign Currency denominated securities CompliesSocially Responsible InvestingNo investments are to be made in companies: 1) whose primary business is the extraction, refining, processing, or distribution of fossil fuels; 2) that source the majority of their revenues from the production of tobacco-related products; 3) that source the majority of their revenues from the production of firearms, weapons, or nuclear power with the exception of those used for national defense of the U.S.;The City will strive to make investments in entities that support a clean and healthy environment, promote economic development, fair labor practices, and support equality of rights regardless of sex, race, age, disability, or sexual orientationCompliesMax Per Issuer5% max per single issuer, except U.S. Government, its agencies and enterprises, money market funds, local government pools, supranationals, or unless otherwise stated in the policyCompliesMaximum Maturity5 yearsCompliesThe City has sufficient resources to meet expenditures for the next six (6) months. Complies*Source: City of Buena Park.
BOOK VALUE RECONCILIATIONBEGINNING BOOK VALUE$102,804,760.88Acquisition+ Security Purchases$0.00+ Money Market Fund Purchases$1,862,815.30+ Money Market Contributions$0.00+ Security Contributions$0.00+ Security Transfers$0.00 Total Acquisitions$1,862,815.30Dispositions- Security Sales$0.00- Money Market Fund Sales$0.00- MMF Withdrawals$7,644.18- Security Withdrawals$0.00- Security Transfers$0.00- Other Dispositions$0.00- Maturities$1,700,000.00- Calls$0.00- Principal Paydowns$0.00 Total Dispositions$1,707,644.18Amortization/Accretion+/- Net Accretion$33,918.01$33,918.01Gain/Loss on Dispositions+/- Realized Gain/Loss$0.00$0.00ENDING BOOK VALUE$102,993,850.01 CASH TRANSACTION SUMMARYBEGINNING BALANCE$196,125.72Acquisition Contributions$0.00 Security Sale Proceeds$0.00 Accrued Interest Received$0.00 Interest Received$161,498.75 Dividend Received$1,316.55 Principal on Maturities$1,700,000.00 Interest on Maturities$0.00 Calls/Redemption (Principal)$0.00 Interest from Calls/Redemption$0.00 Principal Paydown$0.00Total Acquisitions$1,862,815.30Dispositions Withdrawals$7,644.18 Security Purchase$0.00 Accrued Interest Paid$0.00Total Dispositions$7,644.18ENDING BOOK VALUE$2,051,296.84 Reconciliation SummaryAs of October 31, 2023
City of Buena Park CoreAccount #405
Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 3 Holdings ReportAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionPar Value/UnitsPurchase DateBook YieldCost ValueBook ValueMkt PriceMkt YTMMarket ValueAccrued Int.% of Port.Gain/LossMoody/S&P FitchMaturityDurationAGENCY3137EAEZ8 FHLMC Note0.25% Due 11/6/20231,100,000.0012/10/20200.25%1,100,011.001,100,000.0599.935.35%1,099,220.101,336.811.10%(779.95)Aaa / AA+AA+0.020.013130A0F70 FHLB Note3.375% Due 12/8/20231,600,000.0012/14/20182.91%1,634,352.001,600,699.5299.775.51%1,596,395.2021,450.001.62%(4,304.32)Aaa / AA+NR0.100.103135G0V34 FNMA Note2.5% Due 2/5/2024925,000.0003/06/20192.58%921,808.75924,829.3399.255.37%918,078.235,524.310.93%(6,751.10)Aaa / AA+AA+0.270.263130AB3H7 FHLB Note2.375% Due 3/8/20241,600,000.0004/16/20192.47%1,593,136.001,599,508.3498.885.58%1,582,156.805,594.441.59%(17,351.54)Aaa / AA+NR0.350.353133EKNX0 FFCB Note2.16% Due 6/3/20241,500,000.0007/08/20191.94%1,515,675.001,501,881.7098.095.49%1,471,410.0013,320.001.49%(30,471.70)Aaa / AA+AA+0.590.573130A1XJ2 FHLB Note2.875% Due 6/14/20241,500,000.0006/12/20192.00%1,562,100.001,507,681.7798.395.55%1,475,865.0016,411.461.50%(31,816.77)Aaa / AA+NR0.620.603135G0V75 FNMA Note1.75% Due 7/2/20241,300,000.0007/23/20191.89%1,291,602.001,298,864.7697.565.51%1,268,304.707,520.141.28%(30,560.06)Aaa / AA+AA+0.670.653130A2UW4 FHLB Note2.875% Due 9/13/20241,400,000.0009/13/20191.78%1,472,646.001,412,625.4397.825.48%1,369,456.205,366.671.38%(43,169.23)Aaa / AA+NR0.870.843133XVDG3 FHLB Note4.375% Due 9/13/20241,500,000.0010/04/20224.25%1,503,525.001,501,576.0699.095.46%1,486,369.508,750.001.50%(15,206.56)Aaa / AA+NR0.870.833135G0W66 FNMA Note1.625% Due 10/15/20241,200,000.0003/31/20200.53%1,259,004.001,212,420.0296.435.51%1,157,194.80866.671.16%(55,225.22)Aaa / AA+AA+0.960.933137EAEP0 FHLMC Note1.5% Due 2/12/20251,350,000.0003/04/20200.87%1,391,053.501,360,667.0995.315.34%1,286,689.054,443.751.30%(73,978.04)Aaa / AA+AA+1.291.243130AUZC1 FHLB Note4.625% Due 3/14/20251,000,000.0003/16/20234.36%1,004,960.001,003,399.7899.035.36%990,298.006,038.191.00%(13,101.78)Aaa / AA+NR1.371.303135G03U5 FNMA Note0.625% Due 4/22/20251,300,000.0008/11/20200.43%1,311,492.001,303,607.1793.515.26%1,215,617.00203.131.22%(87,990.17)Aaa / AA+AA+1.481.433135G04Z3 FNMA Note0.5% Due 6/17/20251,400,000.0006/18/20200.52%1,398,866.001,399,630.7092.755.20%1,298,488.802,605.561.31%(101,141.90)Aaa / AA+AA+1.631.583137EAEU9 FHLMC Note0.375% Due 7/21/20251,300,000.0008/11/20200.43%1,296,334.001,298,723.8192.285.11%1,199,633.501,354.171.21%(99,090.31)Aaa / AA+AA+1.721.673135G05X7 FNMA Note0.375% Due 8/25/20251,000,000.0002/16/20210.52%993,538.00997,401.8891.755.19%917,468.00687.500.92%(79,933.88)Aaa / AA+AA+1.821.76Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 4 Holdings ReportAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionPar Value/UnitsPurchase DateBook YieldCost ValueBook ValueMkt PriceMkt YTMMarket ValueAccrued Int.% of Port.Gain/LossMoody/S&P FitchMaturityDurationAGENCY3137EAEX3 FHLMC Note0.375% Due 9/23/20251,500,000.0010/19/20200.47%1,492,845.001,497,247.7791.475.16%1,372,108.50593.751.38%(125,139.27)Aaa / AA+AA+1.901.843135G06G3 FNMA Note0.5% Due 11/7/20251,100,000.0011/18/20200.52%1,099,021.001,099,602.2591.225.14%1,003,415.602,658.331.01%(96,186.65)Aaa / AA+AA+2.021.953130ATUC9 FHLB Note4.5% Due 12/12/2025895,000.0005/31/20234.31%899,072.25898,398.6898.635.19%882,719.7115,550.630.90%(15,678.97)Aaa / AA+NR2.121.953133EPLC7 FFCB Note4.125% Due 2/26/20262,000,000.0006/07/20234.37%1,987,746.001,989,545.8897.985.06%1,959,618.0014,895.831.98%(29,927.88)Aaa / NRAA+2.332.163130AUU36 FHLB Note4.125% Due 3/13/20261,000,000.0003/16/20234.23%997,070.00997,684.4498.015.02%980,109.005,500.000.99%(17,575.44)Aaa / AA+NR2.372.213133EPHH1 FFCB Note4% Due 4/28/20262,000,000.0005/09/20233.90%2,005,460.002,004,578.5497.515.08%1,950,224.00666.671.96%(54,354.54)Aaa / AA+AA+2.492.343130AWLZ1 FHLB Note4.75% Due 6/12/20261,000,000.0008/24/20234.82%998,180.00998,296.0999.235.07%992,296.0014,645.831.01%(6,000.09)Aaa / AA+NR2.622.393130AWTR1 FHLB Note4.375% Due 9/8/20281,600,000.0009/11/20234.50%1,591,334.401,591,572.0797.604.94%1,561,537.6016,916.671.58%(30,034.47)Aaa / AA+NR4.864.27Total Agency32,070,000.002.33%32,320,831.9032,100,443.135.29%31,034,673.29172,900.5131.31%(1,065,769.84)Aaa / AA+AA+1.491.40COMMERCIAL PAPER62479LAR6 MUFG Bank Ltd Discount CP5.66% Due 1/25/20241,000,000.0007/24/20235.91%971,071.11971,071.1197.115.91%971,071.1115,565.000.99%0.00P-1 / A-1NR0.240.23Total Commercial Paper1,000,000.005.91%971,071.11971,071.115.91%971,071.1115,565.000.99%0.00P-1 / A-1NR0.240.23CORPORATE24422EVN6 John Deere Capital Corp Note0.45% Due 1/17/2024685,000.0003/01/20210.47%684,513.65684,964.3098.915.68%677,522.54890.500.68%(7,441.76)A2 / AA+0.210.21808513BN4 Charles Schwab Corp Callable Note Cont 2/18/20240.75% Due 3/18/20241,000,000.0005/26/20210.46%1,007,730.001,000,845.9597.996.14%979,937.00895.830.98%(20,908.95)A2 / A-A0.380.37023135BW5 Amazon.com Inc Note0.45% Due 5/12/2024495,000.0005/10/20210.50%494,277.30494,872.7497.365.58%481,907.251,045.690.48%(12,965.49)A1 / AAAA-0.530.52Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 5 Holdings ReportAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionPar Value/UnitsPurchase DateBook YieldCost ValueBook ValueMkt PriceMkt YTMMarket ValueAccrued Int.% of Port.Gain/LossMoody/S&P FitchMaturityDurationCORPORATE14913R2L0 Caterpillar Financial Service Note0.45% Due 5/17/2024750,000.0005/10/20210.50%748,995.00749,818.4497.205.74%729,032.251,537.500.73%(20,786.19)A2 / AA+0.550.5379466LAG9 Salesforce.com Inc Callable Note Cont 7/15/20220.625% Due 7/15/2024145,000.0006/29/20210.64%144,926.05144,982.7196.515.74%139,940.66266.840.14%(5,042.05)A2 / A+NR0.710.6869371RQ66 Paccar Financial Corp Note1.8% Due 2/6/2025750,000.0006/09/20223.35%720,862.50736,077.7595.515.52%716,343.003,187.500.72%(19,734.75)A1 / A+NR1.271.2287612EBL9 Target Corp Callable Note Cont 4/15/252.25% Due 4/15/2025700,000.0003/14/20222.55%693,847.00697,098.3695.485.53%668,327.80700.000.67%(28,770.56)A2 / AA1.461.4006367WB85 Bank of Montreal Note1.85% Due 5/1/2025750,000.0008/12/20210.96%774,285.00759,810.8593.986.11%704,857.506,937.500.71%(54,953.35)A2 / A-AA-1.501.4391159HHZ6 US Bancorp Callable Note Cont 4/11/20251.45% Due 5/12/20251,000,000.0012/29/20211.33%1,003,770.001,001,659.8193.226.16%932,179.006,806.940.94%(69,480.81)A3 / AA1.531.4678015K7H1 Royal Bank of Canada Note1.15% Due 6/10/2025750,000.0005/20/20210.95%756,082.50752,415.7292.895.85%696,641.253,378.130.70%(55,774.47)A1 / AAA-1.611.5589114QCK2 Toronto Dominion Bank Note0.75% Due 9/11/20251,000,000.0005/26/20210.91%993,120.00997,014.4291.095.88%910,850.001,041.670.92%(86,164.42)A1 / AAA-1.871.8089236TKK0 Toyota Motor Credit Corp Note5.4% Due 11/10/20251,000,000.0011/08/20225.36%1,000,960.001,000,648.1899.855.48%998,505.0025,650.001.03%(2,143.18)A1 / A+A+2.031.8546647PBK1 JP Morgan Chase & Co Callable Note Cont 4/22/20252.083% Due 4/22/2026750,000.0005/05/20211.14%777,262.50760,143.3193.986.41%704,868.75390.560.71%(55,274.56)A1 / A-AA-2.481.4200440EAV9 Chubb INA Holdings Inc Callable Note Cont 2/3/20263.35% Due 5/3/20261,000,000.0003/16/20234.64%962,870.00970,230.8694.705.64%947,036.0016,563.890.97%(23,194.86)A3 / AA2.512.3106428CAA2Bank Of America NA Callable Note cont 7/17/20265.526% Due 8/18/20261,000,000.0008/24/20235.47%1,001,440.001,001,353.8199.235.83%992,270.0011,205.501.01%(9,083.81)Aa1 / A+AA2.802.53084664CZ2Berkshire Hathaway Callable Note Cont 2/15/20272.3% Due 3/15/2027500,000.0003/14/20222.73%489,930.00493,213.1091.195.18%455,940.501,469.440.46%(37,272.60)Aa2 / AAA+3.373.1709247XAN1 Blackrock Inc Note3.2% Due 3/15/2027750,000.0006/03/20223.36%744,562.50746,160.6693.085.48%698,063.253,066.670.70%(48,097.41)Aa3 / AA-NR3.373.12Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 6 Holdings ReportAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionPar Value/UnitsPurchase DateBook YieldCost ValueBook ValueMkt PriceMkt YTMMarket ValueAccrued Int.% of Port.Gain/LossMoody/S&P FitchMaturityDurationCORPORATE023135CF1 Amazon.com Inc Callable Note Cont 3/13/20273.3% Due 4/13/2027500,000.0006/09/20223.59%493,600.00495,434.7993.685.33%468,408.00825.000.47%(27,026.79)A1 / AAAA-3.453.19665859AW4Northern Trust Company Callable Note Cont 4/10/20274% Due 5/10/2027750,000.0006/29/20223.91%752,805.00752,020.1193.995.91%704,955.0014,250.000.72%(47,065.11)A2 / A+A+3.533.16931142EX7 Wal-Mart Stores Callable Note Cont 09/09/20273.95% Due 9/9/2027750,000.0009/08/20223.92%751,140.00750,875.9995.725.19%717,922.504,279.170.72%(32,953.49)Aa2 / AAAA3.863.5091324PDE9 United Health Group Inc Note2.95% Due 10/15/2027750,000.0012/28/20224.66%695,400.00704,947.2091.005.51%682,509.00983.330.69%(22,438.20)A2 / A+A3.963.65037833DK3 Apple Inc Callable Note Cont 8/13/20273% Due 11/13/20271,000,000.0001/27/20234.12%951,990.00959,519.9091.945.24%919,410.0014,000.000.94%(40,109.90)Aaa / AA+NR4.043.6769371RS31 Paccar Financial Corp Note4.6% Due 1/10/2028500,000.0001/27/20234.30%506,670.00505,657.4996.785.47%483,891.007,091.670.49%(21,766.49)A1 / A+NR4.203.70713448FL7 Pepsico Inc. Callable Note Cont 1/18/20283.6% Due 2/18/20281,000,000.0003/16/20234.29%969,840.00973,635.1993.645.27%936,376.007,300.000.95%(37,259.19)A1 / A+NR4.303.8857636QAW4 MasterCard Inc Callable Note Cont 2/9/284.875% Due 3/9/20281,000,000.0003/16/20234.53%1,015,050.001,013,146.6498.385.30%983,756.007,041.670.99%(29,390.64)Aa3 / A+NR4.363.8458933YBH7 Merck & Co Callable Note Cont 4/17/20284.05% Due 5/17/20281,000,000.0005/09/20234.07%999,240.00999,309.8995.195.25%951,879.0018,450.000.97%(47,430.89)A1 / A+NR4.554.0024422EXB0 John Deere Capital Corp Note4.95% Due 7/14/2028535,000.0007/11/20234.98%534,202.85534,250.8497.545.55%521,853.457,871.190.53%(12,397.39)A2 / AA+4.714.07Total Corporate20,810,000.003.00%20,669,371.8520,680,109.015.64%19,805,181.70167,126.1920.04%(874,927.31)A1 / A+A+2.612.35Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 7 Holdings ReportAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionPar Value/UnitsPurchase DateBook YieldCost ValueBook ValueMkt PriceMkt YTMMarket ValueAccrued Int.% of Port.Gain/LossMoody/S&P FitchMaturityDurationMONEY MARKET FUND60934N104 Federated Investors Government Obligations Fund2,051,296.84Various5.22%2,051,296.842,051,296.841.005.22%2,051,296.840.002.06%0.00Aaa / AAAAAA0.000.00Total Money Market Fund2,051,296.845.22%2,051,296.842,051,296.845.22%2,051,296.840.002.06%0.00Aaa / AAAAAA0.000.00SUPRANATIONAL4581X0DP0 Inter-American Dev Bank Note0.25% Due 11/15/20231,500,000.0005/26/20210.23%1,500,628.501,500,009.7799.805.42%1,496,988.001,729.171.50%(3,021.77)Aaa / AAANR0.040.04459058KT9 Intl. Bank Recon & Development Note3.5% Due 7/12/20281,500,000.0007/24/20234.19%1,454,115.001,456,595.2793.874.98%1,408,021.5015,895.831.43%(48,573.77)Aaa / AAANR4.704.21Total Supranational3,000,000.002.18%2,954,743.502,956,605.045.20%2,905,009.5017,625.002.93%(51,595.54)Aaa / AAANR2.312.07US TREASURY912828V80 US Treasury Note2.25% Due 1/31/20241,300,000.0004/29/20192.33%1,295,531.251,299,765.8999.215.40%1,289,792.407,391.981.30%(9,973.49)Aaa / AA+AA+0.250.2591282CEA5 US Treasury Note1.5% Due 2/29/20241,100,000.0006/29/20235.48%1,071,640.631,086,052.7798.715.43%1,085,819.902,810.441.09%(232.87)Aaa / AA+AA+0.330.3391282CBV2 US Treasury Note0.375% Due 4/15/20241,500,000.0006/29/20210.42%1,498,125.001,499,694.8597.735.46%1,466,016.00261.271.47%(33,678.85)Aaa / AA+AA+0.460.4591282CEX5 US Treasury Note3% Due 6/30/20242,000,000.0005/31/20235.17%1,954,921.881,972,382.5298.365.54%1,967,188.0020,217.391.99%(5,194.52)Aaa / AA+AA+0.670.64912828YE4 US Treasury Note1.25% Due 8/31/20241,500,000.0005/26/20210.37%1,542,773.441,510,908.6696.585.50%1,448,730.003,193.681.46%(62,178.66)Aaa / AA+AA+0.840.81912828YM6 US Treasury Note1.5% Due 10/31/20241,500,000.0010/04/20224.14%1,422,187.501,462,481.4296.195.47%1,442,812.5061.811.45%(19,668.92)Aaa / AA+AA+1.000.97912828YV6 US Treasury Note1.5% Due 11/30/20241,500,000.0008/26/20210.51%1,547,988.281,515,915.5195.905.45%1,438,476.009,467.211.45%(77,439.51)Aaa / AA+AA+1.081.04Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 8 Holdings ReportAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionPar Value/UnitsPurchase DateBook YieldCost ValueBook ValueMkt PriceMkt YTMMarket ValueAccrued Int.% of Port.Gain/LossMoody/S&P FitchMaturityDurationUS TREASURY91282CDN8 US Treasury Note1% Due 12/15/20241,500,000.0012/15/20210.97%1,501,113.281,500,416.8495.265.41%1,428,867.005,696.721.44%(71,549.84)Aaa / AA+AA+1.131.09912828Z52 US Treasury Note1.375% Due 1/31/20251,300,000.0008/12/20210.55%1,336,714.841,313,242.8495.265.34%1,238,402.104,517.321.25%(74,840.74)Aaa / AA+AA+1.251.21912828ZF0 US Treasury Note0.5% Due 3/31/20251,250,000.0003/29/20210.61%1,244,531.251,248,068.5393.555.29%1,169,385.00546.451.17%(78,683.53)Aaa / AA+AA+1.421.38912828ZT0 US Treasury Note0.25% Due 5/31/20251,500,000.0005/26/20210.57%1,481,250.001,492,615.1992.545.22%1,388,145.001,577.871.39%(104,470.19)Aaa / AA+AA+1.581.5491282CFE6 US Treasury Note3.125% Due 8/15/20252,000,000.0005/31/20234.36%1,948,281.251,958,098.8396.585.14%1,931,640.0013,247.281.95%(26,458.83)Aaa / AA+AA+1.791.7091282CAT8 US Treasury Note0.25% Due 10/31/20251,000,000.0002/16/20210.50%988,398.44995,064.6090.935.07%909,336.006.870.91%(85,728.60)Aaa / AA+AA+2.001.9591282CBC4 US Treasury Note0.375% Due 12/31/20251,250,000.0001/11/20210.49%1,243,017.581,246,955.3090.615.00%1,132,666.251,579.481.14%(114,289.05)Aaa / AA+AA+2.172.1091282CBH3 US Treasury Note0.375% Due 1/31/20261,250,000.0003/29/20210.85%1,221,923.831,236,939.1090.245.02%1,127,978.751,184.611.13%(108,960.35)Aaa / AA+AA+2.252.1991282CGL9 US Treasury Note4% Due 2/15/20261,500,000.0005/31/20234.17%1,493,437.501,494,451.7097.835.01%1,467,421.5012,717.391.49%(27,030.20)Aaa / AA+AA+2.302.1491282CBT7 US Treasury Note0.75% Due 3/31/20261,500,000.0009/28/20210.93%1,487,871.091,493,496.3190.584.94%1,358,671.50983.611.36%(134,824.81)Aaa / AA+AA+2.422.349128286S4 US Treasury Note2.375% Due 4/30/20261,300,000.0008/29/20223.36%1,255,972.661,270,023.2493.984.96%1,221,797.2084.821.23%(48,226.04)Aaa / AA+AA+2.502.3891282CCF6 US Treasury Note0.75% Due 5/31/20261,500,000.0006/03/20222.96%1,376,484.381,420,033.1989.924.96%1,348,770.004,733.611.36%(71,263.19)Aaa / AA+AA+2.582.4991282CCP4 US Treasury Note0.625% Due 7/31/20261,500,000.0006/03/20222.95%1,364,414.061,410,295.0589.114.91%1,336,582.502,369.231.34%(73,712.55)Aaa / AA+AA+2.752.669128282A7 US Treasury Note1.5% Due 8/15/20261,600,000.0010/04/20224.02%1,457,250.001,496,936.5291.164.93%1,458,500.805,086.961.47%(38,435.72)Aaa / AA+AA+2.792.6791282CCZ2 US Treasury Note0.875% Due 9/30/20261,000,000.0005/26/20222.74%924,257.81949,090.5389.284.86%892,813.00765.030.90%(56,277.53)Aaa / AA+AA+2.922.8191282CDK4 US Treasury Note1.25% Due 11/30/20261,000,000.0005/26/20222.74%937,500.00957,230.8489.694.90%896,875.005,259.560.91%(60,355.84)Aaa / AA+AA+3.082.94Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 9 Holdings ReportAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionPar Value/UnitsPurchase DateBook YieldCost ValueBook ValueMkt PriceMkt YTMMarket ValueAccrued Int.% of Port.Gain/LossMoody/S&P FitchMaturityDurationUS TREASURY91282CDQ1 US Treasury Note1.25% Due 12/31/20261,500,000.0006/03/20222.96%1,391,015.631,424,514.1289.524.86%1,342,734.006,317.931.35%(81,780.12)Aaa / AA+AA+3.173.02912828Z78 US Treasury Note1.5% Due 1/31/20271,500,000.0006/09/20223.09%1,397,578.131,428,316.7789.934.89%1,348,945.505,686.141.36%(79,371.27)Aaa / AA+AA+3.253.09912828V98 US Treasury Note2.25% Due 2/15/20271,700,000.0010/04/20223.95%1,585,050.781,613,319.3592.084.88%1,565,394.008,107.341.58%(47,925.35)Aaa / AA+AA+3.303.0991282CEN7 US Treasury Note2.75% Due 4/30/20271,500,000.0006/09/20223.07%1,478,085.941,484,334.8293.194.89%1,397,812.50113.321.40%(86,522.32)Aaa / AA+AA+3.503.2791282CFH9 US Treasury Note3.125% Due 8/31/20271,500,000.0009/27/20224.20%1,428,808.591,444,606.9193.914.89%1,408,594.507,984.201.42%(36,012.41)Aaa / AA+AA+3.843.539128283F5 US Treasury Note2.25% Due 11/15/20271,150,000.0012/28/20224.02%1,060,560.551,075,969.0390.464.88%1,040,255.5011,953.131.06%(35,713.53)Aaa / AA+AA+4.043.7491282CGH8 US Treasury Note3.5% Due 1/31/20282,000,000.0002/23/20234.15%1,942,421.881,950,299.6494.824.86%1,896,328.0017,690.221.92%(53,971.64)Aaa / AA+AA+4.253.8591282CGT2 US Treasury Note3.625% Due 3/31/20282,000,000.0005/31/20233.84%1,981,171.881,982,804.0195.184.85%1,903,516.006,338.801.92%(79,288.01)Aaa / AA+AA+4.424.00Total US Treasury45,200,000.002.69%43,860,279.3344,234,324.885.11%42,350,266.40167,951.6742.66%(1,884,058.48)Aaa / AA+AA+2.252.12TOTAL PORTFOLIO104,131,296.842.71%102,827,594.53102,993,850.015.28%99,117,498.84541,168.37100.00%(3,876,351.17)Aa1 / AAAA+2.021.88TOTAL MARKET VALUE PLUS ACCRUED99,658,667.21Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 10 Transaction LedgerAs of October 31, 2023
City of Buena Park CoreAccount #405Transaction TypeSettlement DateCUSIPQuantitySecurity DescriptionPriceAcq/DispYieldAmountInterestPur/SoldTotal AmountGain/LossACQUISITIONSPurchase 10/02/2023 60934N1041,316.55Federated Investors Government Obligations Fund1.0005.18%1,316.550.001,316.550.00Purchase 10/10/2023 60934N10413,593.75Federated Investors Government Obligations Fund1.0005.18%13,593.750.0013,593.750.00Purchase 10/10/2023 60934N104750,000.00Federated Investors Government Obligations Fund1.0005.18%750,000.000.00750,000.000.00Purchase 10/13/2023 60934N1048,250.00Federated Investors Government Obligations Fund1.0005.18%8,250.000.008,250.000.00Purchase 10/15/2023 60934N10431,500.00Federated Investors Government Obligations Fund1.0005.18%31,500.000.0031,500.000.00Purchase 10/22/2023 60934N10411,873.75Federated Investors Government Obligations Fund1.0005.18%11,873.750.0011,873.750.00Purchase 10/28/2023 60934N10440,000.00Federated Investors Government Obligations Fund1.0005.18%40,000.000.0040,000.000.00Purchase 10/31/2023 60934N10456,281.25Federated Investors Government Obligations Fund1.0005.22%56,281.250.0056,281.250.00Purchase 10/31/2023 60934N104950,000.00Federated Investors Government Obligations Fund1.0005.22%950,000.000.00950,000.000.00Subtotal1,862,815.301,862,815.300.001,862,815.300.00TOTAL ACQUISITIONS1,862,815.301,862,815.300.001,862,815.300.00DISPOSITIONSMaturity 10/10/2023 02665WCQ2750,000.00American Honda Finance Note3.625% Due 10/10/2023100.000750,000.000.00750,000.000.00Maturity 10/31/2023 912828T91950,000.00US Treasury Note1.625% Due 10/31/2023100.000950,000.000.00950,000.000.00Subtotal1,700,000.001,700,000.000.001,700,000.000.00Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 11 Transaction LedgerAs of October 31, 2023
City of Buena Park CoreAccount #405Transaction TypeSettlement DateCUSIPQuantitySecurity DescriptionPriceAcq/DispYieldAmountInterestPur/SoldTotal AmountGain/LossDISPOSITIONSSecurity Withdrawal10/05/2023 60934N1047,644.18Federated Investors Government Obligations Fund1.0007,644.180.007,644.180.00Subtotal7,644.187,644.180.007,644.180.00TOTAL DISPOSITIONS1,707,644.181,707,644.180.001,707,644.180.00OTHER TRANSACTIONSInterest 10/10/2023 02665WCQ2750,000.00American Honda Finance Note3.625% Due 10/10/20230.00013,593.750.0013,593.750.00Interest 10/13/2023 023135CF1500,000.00Amazon.com Inc Callable Note Cont 3/13/20273.3% Due 4/13/20270.0008,250.000.008,250.000.00Interest 10/15/2023 3135G0W661,200,000.00FNMA Note1.625% Due 10/15/20240.0009,750.000.009,750.000.00Interest 10/15/2023 87612EBL9700,000.00Target Corp Callable Note Cont 4/15/252.25% Due 4/15/20250.0007,875.000.007,875.000.00Interest 10/15/2023 91282CBV21,500,000.00US Treasury Note0.375% Due 4/15/20240.0002,812.500.002,812.500.00Interest 10/15/2023 91324PDE9750,000.00United Health Group Inc Note2.95% Due 10/15/20270.00011,062.500.0011,062.500.00Interest 10/22/2023 3135G03U51,300,000.00FNMA Note0.625% Due 4/22/20250.0004,062.500.004,062.500.00Interest 10/22/2023 46647PBK1750,000.00JP Morgan Chase & Co Callable Note Cont 4/22/20252.083% Due 4/22/20260.0007,811.250.007,811.250.00Interest 10/28/2023 3133EPHH12,000,000.00FFCB Note4% Due 4/28/20260.00040,000.000.0040,000.000.00Interest 10/31/2023 9128286S41,300,000.00US Treasury Note2.375% Due 4/30/20260.00015,437.500.0015,437.500.00Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 12 Transaction LedgerAs of October 31, 2023
City of Buena Park CoreAccount #405Transaction TypeSettlement DateCUSIPQuantitySecurity DescriptionPriceAcq/DispYieldAmountInterestPur/SoldTotal AmountGain/LossOTHER TRANSACTIONSInterest 10/31/2023 912828T91950,000.00US Treasury Note1.625% Due 10/31/20230.0007,718.750.007,718.750.00Interest 10/31/2023 912828YM61,500,000.00US Treasury Note1.5% Due 10/31/20240.00011,250.000.0011,250.000.00Interest 10/31/2023 91282CAT81,000,000.00US Treasury Note0.25% Due 10/31/20250.0001,250.000.001,250.000.00Interest 10/31/2023 91282CEN71,500,000.00US Treasury Note2.75% Due 4/30/20270.00020,625.000.0020,625.000.00Subtotal15,700,000.00161,498.750.00161,498.750.00Dividend 10/02/2023 60934N1040.00Federated Investors Government Obligations Fund0.0001,316.550.001,316.550.00Subtotal0.001,316.550.001,316.550.00TOTAL OTHER TRANSACTIONS15,700,000.00162,815.300.00162,815.300.00 Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 13 Income EarnedAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionTrade DateSettle DateUnitsBook Value: BeginBook Value: AcqBook Value: DispBook Value: EndPrior AccruedInc. ReceivedEnding AccruedTotal InterestAccr. Of DiscountAmort. Of PremiumNet Accret/AmortIncome EarnedTotal IncomeFIXED INCOME 00440EAV9 Chubb INA Holdings Inc Callable Note Cont 2/3/2026 3.35% Due 05/03/202603/16/202303/20/20231,000,000.00969,221.180.000.00970,230.8613,772.220.0016,563.892,791.671,009.680.001,009.683,801.353,801.35023135BW5 Amazon.com Inc Note 0.45% Due 05/12/202405/10/202105/12/2021495,000.00494,852.290.000.00494,872.74860.060.001,045.69185.6320.450.0020.45206.08206.08023135CF1 Amazon.com Inc Callable Note Cont 3/13/2027 3.3% Due 04/13/202706/09/202206/13/2022500,000.00495,322.380.000.00495,434.797,700.008,250.00825.001,375.00112.410.00112.411,487.411,487.4102665WCQ2 American Honda Finance Note Due 10/10/202303/06/201903/08/20190.00750,097.490.00750,000.000.0012,914.0613,593.750.00679.690.0097.49(97.49)582.20582.20037833DK3 Apple Inc Callable Note Cont 8/13/2027 3% Due 11/13/202701/27/202301/31/20231,000,000.00958,667.980.000.00959,519.9011,500.000.0014,000.002,500.00851.920.00851.923,351.923,351.9206367WB85 Bank of Montreal Note 1.85% Due 05/01/202508/12/202108/16/2021750,000.00760,366.860.000.00759,810.855,781.250.006,937.501,156.250.00556.01(556.01)600.24600.2406428CAA2 Bank Of America NA Callable Note cont 7/17/2026 5.526% Due 08/18/202608/24/202308/28/20231,000,000.001,001,394.920.000.001,001,353.816,600.500.0011,205.504,605.000.0041.11(41.11)4,563.894,563.89084664CZ2 Berkshire Hathaway Callable Note Cont 2/15/20272.3% Due 03/15/202703/14/202203/16/2022500,000.00493,042.040.000.00493,213.10511.110.001,469.44958.33171.060.00171.061,129.391,129.3909247XAN1 Blackrock Inc Note 3.2% Due 03/15/202706/03/202206/07/2022750,000.00746,063.900.000.00746,160.661,066.670.003,066.672,000.0096.760.0096.762,096.762,096.76Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 14 Income EarnedAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionTrade DateSettle DateUnitsBook Value: BeginBook Value: AcqBook Value: DispBook Value: EndPrior AccruedInc. ReceivedEnding AccruedTotal InterestAccr. Of DiscountAmort. Of PremiumNet Accret/AmortIncome EarnedTotal Income14913R2L0 Caterpillar Financial Service Note 0.45% Due 05/17/202405/10/202105/17/2021750,000.00749,790.010.000.00749,818.441,256.250.001,537.50281.2528.430.0028.43309.68309.6824422EVN6 John Deere Capital Corp Note 0.45% Due 01/17/202403/01/202103/04/2021685,000.00684,949.930.000.00684,964.30633.630.00890.50256.8714.370.0014.37271.24271.2424422EXB0 John Deere Capital Corp Note 4.95% Due 07/14/202807/11/202307/14/2023535,000.00534,237.320.000.00534,250.845,664.310.007,871.192,206.8813.520.0013.522,220.402,220.403130A0F70 FHLB Note 3.375% Due 12/08/202312/14/201812/17/20181,600,000.001,601,285.600.000.001,600,699.5216,950.000.0021,450.004,500.000.00586.08(586.08)3,913.923,913.923130A1XJ2 FHLB Note 2.875% Due 06/14/202406/12/201906/14/20191,500,000.001,508,735.470.000.001,507,681.7712,817.710.0016,411.463,593.750.001,053.70(1,053.70)2,540.052,540.053130A2UW4 FHLB Note 2.875% Due 09/13/202409/13/201909/16/20191,400,000.001,413,860.090.000.001,412,625.432,012.500.005,366.673,354.170.001,234.66(1,234.66)2,119.512,119.513130AB3H7 FHLB Note 2.375% Due 03/08/202404/16/201904/17/20191,600,000.001,599,389.270.000.001,599,508.342,427.780.005,594.443,166.66119.070.00119.073,285.733,285.733130ATUC9 FHLB Note 4.5% Due 12/12/202505/31/202306/01/2023895,000.00898,535.150.000.00898,398.6812,194.380.0015,550.633,356.250.00136.47(136.47)3,219.783,219.783130AUU36 FHLB Note 4.125% Due 03/13/202603/16/202303/17/20231,000,000.00997,601.260.000.00997,684.442,062.500.005,500.003,437.5083.180.0083.183,520.683,520.68Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 15 Income EarnedAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionTrade DateSettle DateUnitsBook Value: BeginBook Value: AcqBook Value: DispBook Value: EndPrior AccruedInc. ReceivedEnding AccruedTotal InterestAccr. Of DiscountAmort. Of PremiumNet Accret/AmortIncome EarnedTotal Income3130AUZC1 FHLB Note 4.625% Due 03/14/202503/16/202303/17/20231,000,000.001,003,610.990.000.001,003,399.782,184.030.006,038.193,854.160.00211.21(211.21)3,642.953,642.953130AWLZ1 FHLB Note 4.75% Due 06/12/202608/24/202308/28/20231,000,000.00998,240.730.000.00998,296.0910,687.500.0014,645.833,958.3355.360.0055.364,013.694,013.693130AWTR1 FHLB Note 4.375% Due 09/08/202809/11/202309/12/20231,600,000.001,591,424.720.000.001,591,572.0711,083.330.0016,916.675,833.34147.350.00147.355,980.695,980.693133EKNX0 FFCB Note 2.16% Due 06/03/202407/08/201907/09/20191,500,000.001,502,153.020.000.001,501,881.7010,620.000.0013,320.002,700.000.00271.32(271.32)2,428.682,428.683133EPHH1 FFCB Note 4% Due 04/28/202605/09/202305/10/20232,000,000.002,004,734.690.000.002,004,578.5434,000.0040,000.00666.676,666.670.00156.15(156.15)6,510.526,510.523133EPLC7 FFCB Note 4.125% Due 02/26/202606/07/202306/08/20232,000,000.001,989,163.720.000.001,989,545.888,020.830.0014,895.836,875.00382.160.00382.167,257.167,257.163133XVDG3 FHLB Note 4.375% Due 09/13/202410/04/202210/05/20221,500,000.001,501,730.180.000.001,501,576.063,281.250.008,750.005,468.750.00154.12(154.12)5,314.635,314.633135G03U5 FNMA Note 0.625% Due 04/22/202508/11/202008/12/20201,300,000.001,303,815.020.000.001,303,607.173,588.544,062.50203.13677.090.00207.85(207.85)469.24469.243135G04Z3 FNMA Note 0.5% Due 06/17/202506/18/202006/19/20201,400,000.001,399,611.430.000.001,399,630.702,022.220.002,605.56583.3419.270.0019.27602.61602.61Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 16 Income EarnedAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionTrade DateSettle DateUnitsBook Value: BeginBook Value: AcqBook Value: DispBook Value: EndPrior AccruedInc. ReceivedEnding AccruedTotal InterestAccr. Of DiscountAmort. Of PremiumNet Accret/AmortIncome EarnedTotal Income3135G05X7 FNMA Note 0.375% Due 08/25/202502/16/202102/18/20211,000,000.00997,280.400.000.00997,401.88375.000.00687.50312.50121.480.00121.48433.98433.983135G06G3 FNMA Note 0.5% Due 11/07/202511/18/202011/19/20201,100,000.001,099,585.520.000.001,099,602.252,200.000.002,658.33458.3316.730.0016.73475.06475.063135G0V34 FNMA Note 2.5% Due 02/05/202403/06/201903/08/2019925,000.00924,774.210.000.00924,829.333,597.220.005,524.311,927.0955.120.0055.121,982.211,982.213135G0V75 FNMA Note 1.75% Due 07/02/202407/23/201907/24/20191,300,000.001,298,720.530.000.001,298,864.765,624.310.007,520.141,895.83144.230.00144.232,040.062,040.063135G0W66 FNMA Note 1.625% Due 10/15/202403/31/202004/01/20201,200,000.001,213,523.230.000.001,212,420.028,991.679,750.00866.671,625.000.001,103.21(1,103.21)521.79521.793137EAEP0 FHLMC Note 1.5% Due 02/12/202503/04/202003/05/20201,350,000.001,361,372.160.000.001,360,667.092,756.250.004,443.751,687.500.00705.07(705.07)982.43982.433137EAEU9 FHLMC Note 0.375% Due 07/21/202508/11/202008/12/20201,300,000.001,298,660.810.000.001,298,723.81947.920.001,354.17406.2563.000.0063.00469.25469.253137EAEX3 FHLMC Note 0.375% Due 09/23/202510/19/202010/20/20201,500,000.001,497,124.480.000.001,497,247.77125.000.00593.75468.75123.290.00123.29592.04592.043137EAEZ8 FHLMC Note 0.25% Due 11/06/202312/10/202012/14/20201,100,000.001,100,000.370.000.001,100,000.051,107.640.001,336.81229.170.000.32(0.32)228.85228.85Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 17 Income EarnedAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionTrade DateSettle DateUnitsBook Value: BeginBook Value: AcqBook Value: DispBook Value: EndPrior AccruedInc. ReceivedEnding AccruedTotal InterestAccr. Of DiscountAmort. Of PremiumNet Accret/AmortIncome EarnedTotal Income4581X0DP0 Inter-American Dev Bank Note 0.25% Due 11/15/202305/26/202105/28/20211,500,000.001,500,031.390.000.001,500,009.771,416.670.001,729.17312.500.0021.62(21.62)290.88290.88459058KT9 Intl. Bank Recon & DevelopmentNote 3.5% Due 07/12/202807/24/202307/26/20231,500,000.001,455,810.690.000.001,456,595.2711,520.830.0015,895.834,375.00784.580.00784.585,159.585,159.5846647PBK1 JP Morgan Chase & Co Callable Note Cont 4/22/2025 2.083% Due 04/22/202605/05/202105/07/2021750,000.00760,727.770.000.00760,143.316,899.947,811.25390.561,301.870.00584.46(584.46)717.41717.4157636QAW4 MasterCard Inc Callable Note Cont 2/9/284.875% Due 03/09/202803/16/202303/20/20231,000,000.001,013,407.720.000.001,013,146.642,979.170.007,041.674,062.500.00261.08(261.08)3,801.423,801.4258933YBH7 Merck & Co Callable Note Cont 4/17/2028 4.05% Due 05/17/202805/09/202305/17/20231,000,000.00999,296.990.000.00999,309.8915,075.000.0018,450.003,375.0012.900.0012.903,387.903,387.90665859AW4 Northern Trust Company Callable Note Cont 4/10/20274% Due 05/10/202706/29/202207/01/2022750,000.00752,069.970.000.00752,020.1111,750.000.0014,250.002,500.000.0049.86(49.86)2,450.142,450.1469371RQ66 Paccar Financial Corp Note 1.8% Due 02/06/202506/09/202206/13/2022750,000.00735,145.590.000.00736,077.752,062.500.003,187.501,125.00932.160.00932.162,057.162,057.1669371RS31 Paccar Financial Corp Note 4.6% Due 01/10/202801/27/202301/31/2023500,000.00505,772.040.000.00505,657.495,175.000.007,091.671,916.670.00114.55(114.55)1,802.121,802.12713448FL7 Pepsico Inc. Callable Note Cont 1/18/2028 3.6% Due 02/18/202803/16/202303/20/20231,000,000.00973,114.610.000.00973,635.194,300.000.007,300.003,000.00520.580.00520.583,520.583,520.58Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 18 Income EarnedAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionTrade DateSettle DateUnitsBook Value: BeginBook Value: AcqBook Value: DispBook Value: EndPrior AccruedInc. ReceivedEnding AccruedTotal InterestAccr. Of DiscountAmort. Of PremiumNet Accret/AmortIncome EarnedTotal Income78015K7H1 Royal Bank of Canada Note 1.15% Due 06/10/202505/20/202105/24/2021750,000.00752,543.290.000.00752,415.722,659.380.003,378.13718.750.00127.57(127.57)591.18591.1879466LAG9 Salesforce.com Inc Callable Note Cont 7/15/20220.625% Due 07/15/202406/29/202107/12/2021145,000.00144,980.620.000.00144,982.71191.320.00266.8475.522.090.002.0977.6177.61808513BN4 Charles Schwab Corp Callable Note Cont 2/18/2024 0.75% Due 03/18/202405/26/202105/28/20211,000,000.001,001,086.550.000.001,000,845.95270.830.00895.83625.000.00240.60(240.60)384.40384.4087612EBL9 Target Corp Callable Note Cont 4/15/252.25% Due 04/15/202503/14/202203/16/2022700,000.00696,928.960.000.00697,098.367,262.507,875.00700.001,312.50169.400.00169.401,481.901,481.9089114QCK2 Toronto Dominion Bank Note 0.75% Due 09/11/202505/26/202105/28/20211,000,000.00996,878.320.000.00997,014.42416.670.001,041.67625.00136.100.00136.10761.10761.1089236TKK0 Toyota Motor Credit Corp Note 5.4% Due 11/10/202511/08/202211/10/20221,000,000.001,000,675.330.000.001,000,648.1821,150.000.0025,650.004,500.000.0027.15(27.15)4,472.854,472.8591159HHZ6 US Bancorp Callable Note Cont 4/11/2025 1.45% Due 05/12/202512/29/202112/31/20211,000,000.001,001,757.440.000.001,001,659.815,598.610.006,806.941,208.330.0097.63(97.63)1,110.701,110.709128282A7 US Treasury Note 1.5% Due 08/15/202610/04/202210/05/20221,600,000.001,493,798.050.000.001,496,936.523,065.220.005,086.962,021.743,138.470.003,138.475,160.215,160.219128283F5 US Treasury Note 2.25% Due 11/15/202712/28/202212/29/20221,150,000.001,074,413.120.000.001,075,969.039,773.440.0011,953.132,179.691,555.910.001,555.913,735.603,735.60Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 19 Income EarnedAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionTrade DateSettle DateUnitsBook Value: BeginBook Value: AcqBook Value: DispBook Value: EndPrior AccruedInc. ReceivedEnding AccruedTotal InterestAccr. Of DiscountAmort. Of PremiumNet Accret/AmortIncome EarnedTotal Income9128286S4 US Treasury Note 2.375% Due 04/30/202608/29/202208/31/20221,300,000.001,269,003.170.000.001,270,023.2412,920.5215,437.5084.822,601.801,020.070.001,020.073,621.873,621.87912828T91 US Treasury Note Due 10/31/202306/29/202206/30/20220.00948,971.130.00950,000.000.006,460.267,718.750.001,258.491,028.870.001,028.872,287.362,287.36912828V80 US Treasury Note 2.25% Due 01/31/202404/29/201904/30/20191,300,000.001,299,686.130.000.001,299,765.894,927.990.007,391.982,463.9979.760.0079.762,543.752,543.75912828V98 US Treasury Note 2.25% Due 02/15/202710/04/202210/05/20221,700,000.001,611,083.820.000.001,613,319.354,885.190.008,107.343,222.152,235.530.002,235.535,457.685,457.68912828YE4 US Treasury Note 1.25% Due 08/31/202405/26/202105/27/20211,500,000.001,512,021.060.000.001,510,908.661,596.840.003,193.681,596.840.001,112.40(1,112.40)484.44484.44912828YM6 US Treasury Note 1.5% Due 10/31/202410/04/202210/05/20221,500,000.001,459,294.910.000.001,462,481.429,415.7611,250.0061.811,896.053,186.510.003,186.515,082.565,082.56912828YV6 US Treasury Note 1.5% Due 11/30/202408/26/202108/27/20211,500,000.001,517,164.570.000.001,515,915.517,561.480.009,467.211,905.730.001,249.06(1,249.06)656.67656.67912828Z52 US Treasury Note 1.375% Due 01/31/202508/12/202108/13/20211,300,000.001,314,141.150.000.001,313,242.843,011.550.004,517.321,505.770.00898.31(898.31)607.46607.46912828Z78 US Treasury Note 1.5% Due 01/31/202706/09/202206/10/20221,500,000.001,426,444.670.000.001,428,316.773,790.760.005,686.141,895.381,872.100.001,872.103,767.483,767.48Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 20 Income EarnedAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionTrade DateSettle DateUnitsBook Value: BeginBook Value: AcqBook Value: DispBook Value: EndPrior AccruedInc. ReceivedEnding AccruedTotal InterestAccr. Of DiscountAmort. Of PremiumNet Accret/AmortIncome EarnedTotal Income912828ZF0 US Treasury Note 0.5% Due 03/31/202503/29/202103/31/20211,250,000.001,247,952.490.000.001,248,068.5317.080.00546.45529.37116.040.00116.04645.41645.41912828ZT0 US Treasury Note 0.25% Due 05/31/202505/26/202105/27/20211,500,000.001,492,218.430.000.001,492,615.191,260.250.001,577.87317.62396.760.00396.76714.38714.3891282CAT8 US Treasury Note 0.25% Due 10/31/202502/16/202102/18/20211,000,000.00994,855.020.000.00995,064.601,046.201,250.006.87210.67209.580.00209.58420.25420.2591282CBC4 US Treasury Note 0.375% Due 12/31/202501/11/202101/12/20211,250,000.001,246,835.970.000.001,246,955.301,184.610.001,579.48394.87119.330.00119.33514.20514.2091282CBH3 US Treasury Note 0.375% Due 01/31/202603/29/202103/31/20211,250,000.001,236,446.530.000.001,236,939.10789.740.001,184.61394.87492.570.00492.57887.44887.4491282CBT7 US Treasury Note 0.75% Due 03/31/202609/28/202109/30/20211,500,000.001,493,267.460.000.001,493,496.3130.740.00983.61952.87228.850.00228.851,181.721,181.7291282CBV2 US Treasury Note 0.375% Due 04/15/202406/29/202106/30/20211,500,000.001,499,637.870.000.001,499,694.852,597.342,812.50261.27476.4356.980.0056.98533.41533.4191282CCF6 US Treasury Note 0.75% Due 05/31/202606/03/202206/06/20221,500,000.001,417,401.580.000.001,420,033.193,780.740.004,733.61952.872,631.610.002,631.613,584.483,584.4891282CCP4 US Treasury Note 0.625% Due 07/31/202606/03/202206/06/20221,500,000.001,407,522.520.000.001,410,295.051,579.480.002,369.23789.752,772.530.002,772.533,562.283,562.28Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 21 Income EarnedAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionTrade DateSettle DateUnitsBook Value: BeginBook Value: AcqBook Value: DispBook Value: EndPrior AccruedInc. ReceivedEnding AccruedTotal InterestAccr. Of DiscountAmort. Of PremiumNet Accret/AmortIncome EarnedTotal Income91282CCZ2 US Treasury Note 0.875% Due 09/30/202605/26/202205/31/20221,000,000.00947,607.270.000.00949,090.5323.910.00765.03741.121,483.260.001,483.262,224.382,224.3891282CDK4 US Treasury Note 1.25% Due 11/30/202605/26/202205/31/20221,000,000.00956,052.310.000.00957,230.844,200.820.005,259.561,058.741,178.530.001,178.532,237.272,237.2791282CDN8 US Treasury Note 1% Due 12/15/202412/15/202112/16/20211,500,000.001,500,448.360.000.001,500,416.844,426.230.005,696.721,270.490.0031.52(31.52)1,238.971,238.9791282CDQ1 US Treasury Note 1.25% Due 12/31/202606/03/202206/06/20221,500,000.001,422,489.850.000.001,424,514.124,738.450.006,317.931,579.482,024.270.002,024.273,603.753,603.7591282CEA5 US Treasury Note 1.5% Due 02/29/202406/29/202306/30/20231,100,000.001,082,449.730.000.001,086,052.771,405.220.002,810.441,405.223,603.040.003,603.045,008.265,008.2691282CEN7 US Treasury Note 2.75% Due 04/30/202706/09/202206/10/20221,500,000.001,483,954.240.000.001,484,334.8217,262.2320,625.00113.323,476.09380.580.00380.583,856.673,856.6791282CEX5 US Treasury Note 3% Due 06/30/202405/31/202306/01/20232,000,000.001,968,844.740.000.001,972,382.5215,163.040.0020,217.395,054.353,537.780.003,537.788,592.138,592.1391282CFE6 US Treasury Note 3.125% Due 08/15/202505/31/202306/01/20232,000,000.001,956,109.650.000.001,958,098.837,982.340.0013,247.285,264.941,989.180.001,989.187,254.127,254.1291282CFH9 US Treasury Note 3.125% Due 08/31/202709/27/202209/28/20221,500,000.001,443,379.470.000.001,444,606.913,992.100.007,984.203,992.101,227.440.001,227.445,219.545,219.54Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 22 Income EarnedAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionTrade DateSettle DateUnitsBook Value: BeginBook Value: AcqBook Value: DispBook Value: EndPrior AccruedInc. ReceivedEnding AccruedTotal InterestAccr. Of DiscountAmort. Of PremiumNet Accret/AmortIncome EarnedTotal Income91282CGH8 US Treasury Note 3.5% Due 01/31/202802/23/202302/28/20232,000,000.001,949,306.920.000.001,950,299.6411,793.480.0017,690.225,896.74992.720.00992.726,889.466,889.4691282CGL9 US Treasury Note 4% Due 02/15/202605/31/202306/01/20231,500,000.001,494,246.210.000.001,494,451.707,663.040.0012,717.395,054.35205.490.00205.495,259.845,259.8491282CGT2 US Treasury Note 3.625% Due 03/31/202805/31/202306/01/20232,000,000.001,982,473.310.000.001,982,804.01198.090.006,338.806,140.71330.700.00330.706,471.416,471.4191324PDE9 United Health Group Inc Note 2.95% Due 10/15/202712/28/202212/30/2022750,000.00703,980.000.000.00704,947.2010,202.0811,062.50983.331,843.75967.200.00967.202,810.952,810.95931142EX7 Wal-Mart Stores Callable Note Cont 09/09/2027 3.95% Due 09/09/202709/08/202209/12/2022750,000.00750,895.710.000.00750,875.991,810.420.004,279.172,468.750.0019.72(19.72)2,449.032,449.03Total Fixed Income101,080,000.00101,637,564.050.001,700,000.0099,971,482.06497,222.70161,498.75525,603.37189,879.4245,268.3111,350.3033,918.01223,797.43223,797.43CASH & EQUIVALENT 60934N104 Federated Investors Government Obligations Fund VariousVarious2,051,296.84196,125.721,862,815.307,644.182,051,296.840.001,316.550.001,316.550.000.000.001,316.551,316.55Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 23 Income EarnedAs of October 31, 2023
City of Buena Park CoreAccount #405CUSIPSecurity DescriptionTrade DateSettle DateUnitsBook Value: BeginBook Value: AcqBook Value: DispBook Value: EndPrior AccruedInc. ReceivedEnding AccruedTotal InterestAccr. Of DiscountAmort. Of PremiumNet Accret/AmortIncome EarnedTotal Income62479LAR6 MUFG Bank Ltd Discount CP 5.66% Due 01/25/202407/24/202307/25/20231,000,000.00971,071.110.000.00971,071.1110,691.110.0015,565.004,873.890.000.000.004,873.894,873.89Total Cash & Equivalent3,051,296.841,167,196.831,862,815.307,644.183,022,367.9510,691.111,316.5515,565.006,190.440.000.000.006,190.446,190.44TOTAL PORTFOLIO104,131,296.84102,804,760.881,862,815.301,707,644.18102,993,850.01507,913.81162,815.30541,168.37196,069.8645,268.3111,350.3033,918.01229,987.87229,987.87 Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 24 Cash Flow ReportAs of October 31, 2023
City of Buena Park CoreAccount #405Payment DateTransaction TypeCUSIPQuantitySecurity DescriptionPrincipal AmountIncomeTotal Amount11/01/2023 Interest 06367WB85750,000.00Bank of Montreal Note1.85% Due 5/1/20250.006,937.506,937.5011/01/2023 Purchase 3133EPZY41,000,000.00FFCB Note5% Due 7/30/2026-998,600.00-138.89-998,738.8911/01/2023 Sale 60934N104998,738.89Federated Investors Government Obligations Fund998,738.890.00998,738.8911/02/2023 Purchase 61690U7W41,000,000.00Morgan Stanley Bank NA Callable Note Cont 9/30/20265.882% Due 10/30/2026-999,160.00-163.39-999,323.3911/02/2023 Sale 60934N104999,323.39Federated Investors Government Obligations Fund999,323.390.00999,323.3911/03/2023 Interest 00440EAV91,000,000.00Chubb INA Holdings Inc Callable Note Cont 2/3/20263.35% Due 5/3/20260.0016,750.0016,750.0011/06/2023 Maturity 3137EAEZ81,100,000.00FHLMC Note0.25% Due 11/6/20231,100,000.001,375.001,101,375.0011/07/2023 Interest 3135G06G31,100,000.00FNMA Note0.5% Due 11/7/20250.002,750.002,750.0011/10/2023 Interest 665859AW4750,000.00Northern Trust Company Callable Note Cont 4/10/20274% Due 5/10/20270.0015,000.0015,000.0011/10/2023 Interest 89236TKK01,000,000.00Toyota Motor Credit Corp Note5.4% Due 11/10/20250.0027,000.0027,000.0011/12/2023 Interest 91159HHZ61,000,000.00US Bancorp Callable Note Cont 4/11/20251.45% Due 5/12/20250.007,250.007,250.0011/12/2023 Interest 023135BW5495,000.00Amazon.com Inc Note0.45% Due 5/12/20240.001,113.751,113.7511/13/2023 Interest 037833DK31,000,000.00Apple Inc Callable Note Cont 8/13/20273% Due 11/13/20270.0015,000.0015,000.0011/15/2023 Interest 9128283F51,150,000.00US Treasury Note2.25% Due 11/15/20270.0012,937.5012,937.5011/15/2023 Maturity 4581X0DP01,500,000.00Inter-American Dev Bank Note0.25% Due 11/15/20231,500,000.001,875.001,501,875.0011/17/2023 Interest 58933YBH71,000,000.00Merck & Co Callable Note Cont 4/17/20284.05% Due 5/17/20280.0020,250.0020,250.00Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 25 Cash Flow ReportAs of October 31, 2023
City of Buena Park CoreAccount #405Payment DateTransaction TypeCUSIPQuantitySecurity DescriptionPrincipal AmountIncomeTotal Amount11/17/2023 Interest 14913R2L0750,000.00Caterpillar Financial Service Note0.45% Due 5/17/20240.001,687.501,687.5011/30/2023 Interest 91282CCF61,500,000.00US Treasury Note0.75% Due 5/31/20260.005,625.005,625.0011/30/2023 Interest 91282CDK41,000,000.00US Treasury Note1.25% Due 11/30/20260.006,250.006,250.0011/30/2023 Interest 912828YV61,500,000.00US Treasury Note1.5% Due 11/30/20240.0011,250.0011,250.0011/30/2023 Interest 912828ZT01,500,000.00US Treasury Note0.25% Due 5/31/20250.001,875.001,875.00NOV 20232,600,302.28154,623.972,754,926.2512/03/2023 Interest 3133EKNX01,500,000.00FFCB Note2.16% Due 6/3/20240.0016,200.0016,200.0012/08/2023 Maturity 3130A0F701,600,000.00FHLB Note3.375% Due 12/8/20231,600,000.0027,000.001,627,000.0012/10/2023 Interest 78015K7H1750,000.00Royal Bank of Canada Note1.15% Due 6/10/20250.004,312.504,312.5012/12/2023 Interest 3130AWLZ11,000,000.00FHLB Note4.75% Due 6/12/20260.0020,055.5620,055.5612/12/2023 Interest 3130ATUC9895,000.00FHLB Note4.5% Due 12/12/20250.0020,137.5020,137.5012/14/2023 Interest 3130A1XJ21,500,000.00FHLB Note2.875% Due 6/14/20240.0021,562.5021,562.5012/15/2023 Interest 91282CDN81,500,000.00US Treasury Note1% Due 12/15/20240.007,500.007,500.0012/17/2023 Interest 3135G04Z31,400,000.00FNMA Note0.5% Due 6/17/20250.003,500.003,500.0012/31/2023 Interest 91282CDQ11,500,000.00US Treasury Note1.25% Due 12/31/20260.009,375.009,375.0012/31/2023 Interest 91282CEX52,000,000.00US Treasury Note3% Due 6/30/20240.0030,000.0030,000.0012/31/2023 Interest 91282CBC41,250,000.00US Treasury Note0.375% Due 12/31/20250.002,343.752,343.75DEC 20231,600,000.00161,986.811,761,986.81Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 26 Cash Flow ReportAs of October 31, 2023
City of Buena Park CoreAccount #405Payment DateTransaction TypeCUSIPQuantitySecurity DescriptionPrincipal AmountIncomeTotal Amount01/02/2024 Interest 3135G0V751,300,000.00FNMA Note1.75% Due 7/2/20240.0011,375.0011,375.0001/10/2024 Interest 69371RS31500,000.00Paccar Financial Corp Note4.6% Due 1/10/20280.0011,500.0011,500.0001/12/2024 Interest 459058KT91,500,000.00Intl. Bank Recon & Development Note3.5% Due 7/12/20280.0026,250.0026,250.0001/14/2024 Interest 24422EXB0535,000.00John Deere Capital Corp Note4.95% Due 7/14/20280.0013,241.2513,241.2501/15/2024 Interest 79466LAG9145,000.00Salesforce.com Inc Callable Note Cont 7/15/20220.625% Due 7/15/20240.00453.13453.1301/17/2024 Maturity 24422EVN6685,000.00John Deere Capital Corp Note0.45% Due 1/17/2024685,000.001,541.25686,541.2501/21/2024 Interest 3137EAEU91,300,000.00FHLMC Note0.375% Due 7/21/20250.002,437.502,437.5001/25/2024 Maturity 62479LAR61,000,000.00MUFG Bank Ltd Discount CP5.66% Due 1/25/2024971,071.1128,928.891,000,000.0001/31/2024 Interest 91282CCP41,500,000.00US Treasury Note0.625% Due 7/31/20260.004,687.504,687.5001/31/2024 Interest 912828Z521,300,000.00US Treasury Note1.375% Due 1/31/20250.008,937.508,937.5001/31/2024 Interest 912828Z781,500,000.00US Treasury Note1.5% Due 1/31/20270.0011,250.0011,250.0001/31/2024 Interest 91282CBH31,250,000.00US Treasury Note0.375% Due 1/31/20260.002,343.752,343.7501/31/2024 Interest 91282CGH82,000,000.00US Treasury Note3.5% Due 1/31/20280.0035,000.0035,000.0001/31/2024 Maturity 912828V801,300,000.00US Treasury Note2.25% Due 1/31/20241,300,000.0014,625.001,314,625.00JAN 20242,956,071.11172,570.773,128,641.8802/05/2024 Maturity 3135G0V34925,000.00FNMA Note2.5% Due 2/5/2024925,000.0011,562.50936,562.5002/06/2024 Interest 69371RQ66750,000.00Paccar Financial Corp Note1.8% Due 2/6/20250.006,750.006,750.00Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 27 Cash Flow ReportAs of October 31, 2023
City of Buena Park CoreAccount #405Payment DateTransaction TypeCUSIPQuantitySecurity DescriptionPrincipal AmountIncomeTotal Amount02/12/2024 Interest 3137EAEP01,350,000.00FHLMC Note1.5% Due 2/12/20250.0010,125.0010,125.0002/15/2024 Interest 9128282A71,600,000.00US Treasury Note1.5% Due 8/15/20260.0012,000.0012,000.0002/15/2024 Interest 91282CFE62,000,000.00US Treasury Note3.125% Due 8/15/20250.0031,250.0031,250.0002/15/2024 Interest 912828V981,700,000.00US Treasury Note2.25% Due 2/15/20270.0019,125.0019,125.0002/15/2024 Interest 91282CGL91,500,000.00US Treasury Note4% Due 2/15/20260.0030,000.0030,000.0002/18/2024 Call 808513BN41,000,000.00Charles Schwab Corp Callable Note Cont 2/18/20240.75% Due 3/18/20241,000,000.003,125.001,003,125.0002/18/2024 Interest 06428CAA21,000,000.00Bank Of America NA Callable Note cont 7/17/20265.526% Due 8/18/20260.0027,630.0027,630.0002/18/2024 Interest 713448FL71,000,000.00Pepsico Inc. Callable Note Cont 1/18/20283.6% Due 2/18/20280.0018,000.0018,000.0002/25/2024 Interest 3135G05X71,000,000.00FNMA Note0.375% Due 8/25/20250.001,875.001,875.0002/26/2024 Interest 3133EPLC72,000,000.00FFCB Note4.125% Due 2/26/20260.0041,250.0041,250.0002/29/2024 Interest 912828YE41,500,000.00US Treasury Note1.25% Due 8/31/20240.009,375.009,375.0002/29/2024 Interest 91282CFH91,500,000.00US Treasury Note3.125% Due 8/31/20270.0023,437.5023,437.5002/29/2024 Maturity 91282CEA51,100,000.00US Treasury Note1.5% Due 2/29/20241,100,000.008,250.001,108,250.00FEB 20243,025,000.00253,755.003,278,755.0003/08/2024 Interest 3130AWTR11,600,000.00FHLB Note4.375% Due 9/8/20280.0041,611.1141,611.1103/08/2024 Maturity 3130AB3H71,600,000.00FHLB Note2.375% Due 3/8/20241,600,000.0019,000.001,619,000.0003/09/2024 Interest 931142EX7750,000.00Wal-Mart Stores Callable Note Cont 09/09/20273.95% Due 9/9/20270.0014,812.5014,812.50Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 28 Cash Flow ReportAs of October 31, 2023
City of Buena Park CoreAccount #405Payment DateTransaction TypeCUSIPQuantitySecurity DescriptionPrincipal AmountIncomeTotal Amount03/09/2024 Interest 57636QAW41,000,000.00MasterCard Inc Callable Note Cont 2/9/284.875% Due 3/9/20280.0024,375.0024,375.0003/11/2024 Interest 89114QCK21,000,000.00Toronto Dominion Bank Note0.75% Due 9/11/20250.003,750.003,750.0003/13/2024 Interest 3130AUU361,000,000.00FHLB Note4.125% Due 3/13/20260.0020,625.0020,625.0003/13/2024 Interest 3133XVDG31,500,000.00FHLB Note4.375% Due 9/13/20240.0032,812.5032,812.5003/13/2024 Interest 3130A2UW41,400,000.00FHLB Note2.875% Due 9/13/20240.0020,125.0020,125.0003/14/2024 Interest 3130AUZC11,000,000.00FHLB Note4.625% Due 3/14/20250.0023,125.0023,125.0003/15/2024 Interest 084664CZ2500,000.00Berkshire Hathaway Callable Note Cont 2/15/20272.3% Due 3/15/20270.005,750.005,750.0003/15/2024 Interest 09247XAN1750,000.00Blackrock Inc Note3.2% Due 3/15/20270.0012,000.0012,000.0003/23/2024 Interest 3137EAEX31,500,000.00FHLMC Note0.375% Due 9/23/20250.002,812.502,812.5003/31/2024 Interest 912828ZF01,250,000.00US Treasury Note0.5% Due 3/31/20250.003,125.003,125.0003/31/2024 Interest 91282CGT22,000,000.00US Treasury Note3.625% Due 3/31/20280.0036,250.0036,250.0003/31/2024 Interest 91282CBT71,500,000.00US Treasury Note0.75% Due 3/31/20260.005,625.005,625.0003/31/2024 Interest 91282CCZ21,000,000.00US Treasury Note0.875% Due 9/30/20260.004,375.004,375.00MAR 20241,600,000.00270,173.611,870,173.6104/13/2024 Interest 023135CF1500,000.00Amazon.com Inc Callable Note Cont 3/13/20273.3% Due 4/13/20270.008,250.008,250.0004/15/2024 Interest 3135G0W661,200,000.00FNMA Note1.625% Due 10/15/20240.009,750.009,750.0004/15/2024 Interest 87612EBL9700,000.00Target Corp Callable Note Cont 4/15/252.25% Due 4/15/20250.007,875.007,875.00Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 29 Cash Flow ReportAs of October 31, 2023
City of Buena Park CoreAccount #405Payment DateTransaction TypeCUSIPQuantitySecurity DescriptionPrincipal AmountIncomeTotal Amount04/15/2024 Interest 91324PDE9750,000.00United Health Group Inc Note2.95% Due 10/15/20270.0011,062.5011,062.5004/15/2024 Maturity 91282CBV21,500,000.00US Treasury Note0.375% Due 4/15/20241,500,000.002,812.501,502,812.5004/22/2024 Interest 3135G03U51,300,000.00FNMA Note0.625% Due 4/22/20250.004,062.504,062.5004/22/2024 Interest 46647PBK1750,000.00JP Morgan Chase & Co Callable Note Cont 4/22/20252.083% Due 4/22/20260.007,811.257,811.2504/28/2024 Interest 3133EPHH12,000,000.00FFCB Note4% Due 4/28/20260.0040,000.0040,000.0004/30/2024 Interest 91282CEN71,500,000.00US Treasury Note2.75% Due 4/30/20270.0020,625.0020,625.0004/30/2024 Interest 9128286S41,300,000.00US Treasury Note2.375% Due 4/30/20260.0015,437.5015,437.5004/30/2024 Interest 912828YM61,500,000.00US Treasury Note1.5% Due 10/31/20240.0011,250.0011,250.0004/30/2024 Interest 91282CAT81,000,000.00US Treasury Note0.25% Due 10/31/20250.001,250.001,250.00APR 20241,500,000.00140,186.251,640,186.2505/01/2024 Interest 06367WB85750,000.00Bank of Montreal Note1.85% Due 5/1/20250.006,937.506,937.5005/03/2024 Interest 00440EAV91,000,000.00Chubb INA Holdings Inc Callable Note Cont 2/3/20263.35% Due 5/3/20260.0016,750.0016,750.0005/07/2024 Interest 3135G06G31,100,000.00FNMA Note0.5% Due 11/7/20250.002,750.002,750.0005/10/2024 Interest 89236TKK01,000,000.00Toyota Motor Credit Corp Note5.4% Due 11/10/20250.0027,000.0027,000.0005/10/2024 Interest 665859AW4750,000.00Northern Trust Company Callable Note Cont 4/10/20274% Due 5/10/20270.0015,000.0015,000.0005/12/2024 Interest 91159HHZ61,000,000.00US Bancorp Callable Note Cont 4/11/20251.45% Due 5/12/20250.007,250.007,250.0005/12/2024 Maturity 023135BW5495,000.00Amazon.com Inc Note0.45% Due 5/12/2024495,000.001,113.75496,113.75Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 30 Cash Flow ReportAs of October 31, 2023
City of Buena Park CoreAccount #405Payment DateTransaction TypeCUSIPQuantitySecurity DescriptionPrincipal AmountIncomeTotal Amount05/13/2024 Interest 037833DK31,000,000.00Apple Inc Callable Note Cont 8/13/20273% Due 11/13/20270.0015,000.0015,000.0005/15/2024 Interest 9128283F51,150,000.00US Treasury Note2.25% Due 11/15/20270.0012,937.5012,937.5005/17/2024 Interest 58933YBH71,000,000.00Merck & Co Callable Note Cont 4/17/20284.05% Due 5/17/20280.0020,250.0020,250.0005/17/2024 Maturity 14913R2L0750,000.00Caterpillar Financial Service Note0.45% Due 5/17/2024750,000.001,687.50751,687.5005/31/2024 Interest 912828ZT01,500,000.00US Treasury Note0.25% Due 5/31/20250.001,875.001,875.0005/31/2024 Interest 91282CCF61,500,000.00US Treasury Note0.75% Due 5/31/20260.005,625.005,625.0005/31/2024 Interest 912828YV61,500,000.00US Treasury Note1.5% Due 11/30/20240.0011,250.0011,250.0005/31/2024 Interest 91282CDK41,000,000.00US Treasury Note1.25% Due 11/30/20260.006,250.006,250.00MAY 20241,245,000.00151,676.251,396,676.2506/03/2024 Maturity 3133EKNX01,500,000.00FFCB Note2.16% Due 6/3/20241,500,000.0016,200.001,516,200.0006/10/2024 Interest 78015K7H1750,000.00Royal Bank of Canada Note1.15% Due 6/10/20250.004,312.504,312.5006/12/2024 Interest 3130ATUC9895,000.00FHLB Note4.5% Due 12/12/20250.0020,137.5020,137.5006/12/2024 Interest 3130AWLZ11,000,000.00FHLB Note4.75% Due 6/12/20260.0023,750.0023,750.0006/14/2024 Maturity 3130A1XJ21,500,000.00FHLB Note2.875% Due 6/14/20241,500,000.0021,562.501,521,562.5006/15/2024 Interest 91282CDN81,500,000.00US Treasury Note1% Due 12/15/20240.007,500.007,500.0006/17/2024 Interest 3135G04Z31,400,000.00FNMA Note0.5% Due 6/17/20250.003,500.003,500.0006/30/2024 Interest 91282CBC41,250,000.00US Treasury Note0.375% Due 12/31/20250.002,343.752,343.75Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 31 Cash Flow ReportAs of October 31, 2023
City of Buena Park CoreAccount #405Payment DateTransaction TypeCUSIPQuantitySecurity DescriptionPrincipal AmountIncomeTotal Amount06/30/2024 Interest 91282CDQ11,500,000.00US Treasury Note1.25% Due 12/31/20260.009,375.009,375.0006/30/2024 Maturity 91282CEX52,000,000.00US Treasury Note3% Due 6/30/20242,000,000.0030,000.002,030,000.00JUN 20245,000,000.00138,681.255,138,681.2507/02/2024 Maturity 3135G0V751,300,000.00FNMA Note1.75% Due 7/2/20241,300,000.0011,375.001,311,375.0007/10/2024 Interest 69371RS31500,000.00Paccar Financial Corp Note4.6% Due 1/10/20280.0011,500.0011,500.0007/12/2024 Interest 459058KT91,500,000.00Intl. Bank Recon & Development Note3.5% Due 7/12/20280.0026,250.0026,250.0007/14/2024 Interest 24422EXB0535,000.00John Deere Capital Corp Note4.95% Due 7/14/20280.0013,241.2513,241.2507/15/2024 Maturity 79466LAG9145,000.00Salesforce.com Inc Callable Note Cont 7/15/20220.625% Due 7/15/2024145,000.00453.13145,453.1307/21/2024 Interest 3137EAEU91,300,000.00FHLMC Note0.375% Due 7/21/20250.002,437.502,437.5007/31/2024 Interest 91282CGH82,000,000.00US Treasury Note3.5% Due 1/31/20280.0035,000.0035,000.0007/31/2024 Interest 91282CBH31,250,000.00US Treasury Note0.375% Due 1/31/20260.002,343.752,343.7507/31/2024 Interest 91282CCP41,500,000.00US Treasury Note0.625% Due 7/31/20260.004,687.504,687.5007/31/2024 Interest 912828Z521,300,000.00US Treasury Note1.375% Due 1/31/20250.008,937.508,937.5007/31/2024 Interest 912828Z781,500,000.00US Treasury Note1.5% Due 1/31/20270.0011,250.0011,250.00JUL 20241,445,000.00127,475.631,572,475.6308/06/2024 Interest 69371RQ66750,000.00Paccar Financial Corp Note1.8% Due 2/6/20250.006,750.006,750.0008/12/2024 Interest 3137EAEP01,350,000.00FHLMC Note1.5% Due 2/12/20250.0010,125.0010,125.0008/15/2024 Interest 9128282A71,600,000.00US Treasury Note1.5% Due 8/15/20260.0012,000.0012,000.00Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 32 Cash Flow ReportAs of October 31, 2023
City of Buena Park CoreAccount #405Payment DateTransaction TypeCUSIPQuantitySecurity DescriptionPrincipal AmountIncomeTotal Amount08/15/2024 Interest 91282CFE62,000,000.00US Treasury Note3.125% Due 8/15/20250.0031,250.0031,250.0008/15/2024 Interest 912828V981,700,000.00US Treasury Note2.25% Due 2/15/20270.0019,125.0019,125.0008/15/2024 Interest 91282CGL91,500,000.00US Treasury Note4% Due 2/15/20260.0030,000.0030,000.0008/18/2024 Interest 06428CAA21,000,000.00Bank Of America NA Callable Note cont 7/17/20265.526% Due 8/18/20260.0027,630.0027,630.0008/18/2024 Interest 713448FL71,000,000.00Pepsico Inc. Callable Note Cont 1/18/20283.6% Due 2/18/20280.0018,000.0018,000.0008/25/2024 Interest 3135G05X71,000,000.00FNMA Note0.375% Due 8/25/20250.001,875.001,875.0008/26/2024 Interest 3133EPLC72,000,000.00FFCB Note4.125% Due 2/26/20260.0041,250.0041,250.0008/31/2024 Interest 91282CFH91,500,000.00US Treasury Note3.125% Due 8/31/20270.0023,437.5023,437.5008/31/2024 Maturity 912828YE41,500,000.00US Treasury Note1.25% Due 8/31/20241,500,000.009,375.001,509,375.00AUG 20241,500,000.00230,817.501,730,817.5009/08/2024 Interest 3130AWTR11,600,000.00FHLB Note4.375% Due 9/8/20280.0035,000.0035,000.0009/09/2024 Interest 57636QAW41,000,000.00MasterCard Inc Callable Note Cont 2/9/284.875% Due 3/9/20280.0024,375.0024,375.0009/09/2024 Interest 931142EX7750,000.00Wal-Mart Stores Callable Note Cont 09/09/20273.95% Due 9/9/20270.0014,812.5014,812.5009/11/2024 Interest 89114QCK21,000,000.00Toronto Dominion Bank Note0.75% Due 9/11/20250.003,750.003,750.0009/13/2024 Interest 3130AUU361,000,000.00FHLB Note4.125% Due 3/13/20260.0020,625.0020,625.0009/13/2024 Maturity 3133XVDG31,500,000.00FHLB Note4.375% Due 9/13/20241,500,000.0032,812.501,532,812.5009/13/2024 Maturity 3130A2UW41,400,000.00FHLB Note2.875% Due 9/13/20241,400,000.0020,125.001,420,125.00Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 33 Cash Flow ReportAs of October 31, 2023
City of Buena Park CoreAccount #405Payment DateTransaction TypeCUSIPQuantitySecurity DescriptionPrincipal AmountIncomeTotal Amount09/14/2024 Interest 3130AUZC11,000,000.00FHLB Note4.625% Due 3/14/20250.0023,125.0023,125.0009/15/2024 Interest 084664CZ2500,000.00Berkshire Hathaway Callable Note Cont 2/15/20272.3% Due 3/15/20270.005,750.005,750.0009/15/2024 Interest 09247XAN1750,000.00Blackrock Inc Note3.2% Due 3/15/20270.0012,000.0012,000.0009/23/2024 Interest 3137EAEX31,500,000.00FHLMC Note0.375% Due 9/23/20250.002,812.502,812.5009/30/2024 Interest 91282CBT71,500,000.00US Treasury Note0.75% Due 3/31/20260.005,625.005,625.0009/30/2024 Interest 91282CGT22,000,000.00US Treasury Note3.625% Due 3/31/20280.0036,250.0036,250.0009/30/2024 Interest 91282CCZ21,000,000.00US Treasury Note0.875% Due 9/30/20260.004,375.004,375.0009/30/2024 Interest 912828ZF01,250,000.00US Treasury Note0.5% Due 3/31/20250.003,125.003,125.00SEP 20242,900,000.00244,562.503,144,562.5010/13/2024 Interest 023135CF1500,000.00Amazon.com Inc Callable Note Cont 3/13/20273.3% Due 4/13/20270.008,250.008,250.0010/15/2024 Interest 87612EBL9700,000.00Target Corp Callable Note Cont 4/15/252.25% Due 4/15/20250.007,875.007,875.0010/15/2024 Interest 91324PDE9750,000.00United Health Group Inc Note2.95% Due 10/15/20270.0011,062.5011,062.5010/15/2024 Maturity 3135G0W661,200,000.00FNMA Note1.625% Due 10/15/20241,200,000.009,750.001,209,750.0010/22/2024 Interest 46647PBK1750,000.00JP Morgan Chase & Co Callable Note Cont 4/22/20252.083% Due 4/22/20260.007,811.257,811.2510/22/2024 Interest 3135G03U51,300,000.00FNMA Note0.625% Due 4/22/20250.004,062.504,062.5010/28/2024 Interest 3133EPHH12,000,000.00FFCB Note4% Due 4/28/20260.0040,000.0040,000.00OCT 20241,200,000.0088,811.251,288,811.25TOTAL26,571,373.392,135,320.7928,706,694.18Execution Time: 11/2/2023 7:56:03 PMChandler Asset Management - CONFIDENTIALPage 34 ACCOUNT SUMMARYBeg. Valuesas of 9/30/23End Valuesas of 10/31/23Market Value13,873,24820,060,635Accrued Interest174,46060,571Total Market Value14,047,70820,121,206Income Earned45,97082,728Cont/WD5,990,770Par13,873,24820,060,635Book Value13,873,24820,060,635Cost Value13,873,24820,060,635TOP ISSUERSLocal Agency Investment Fund 100.0%Total 100.0%PORTFOLIO CHARACTERISTICSAverage Modified Duration 0.00Average Coupon 3.65%Average Purchase YTM 3.65%Average Market YTM 3.65%Average S&P/Moody Rating NR/NRAverage Final Maturity 0.00 yrsAverage Life 0.00 yrsCREDIT QUALITY (S&P)
MATURITY DISTRIBUTION
SECTOR ALLOCATION
Portfolio SummaryAs of October 31, 2023
City of Buena Park LiquidAccount #406
PERFORMANCE REVIEWAnnualizedTOTAL RATE OF RETURN1M3MYTD1YR2YRS3YRS5YRS10YRS12/31/2005City of Buena Park Liquid 0.43% 0.99% 2.78% 3.13% 1.97% 1.43% 1.68% 1.31% 1.65%ICE BofA 3-Month US Treasury Bill Index 0.45% 1.36% 4.06% 4.77% 2.76% 1.85% 1.77% 1.16% 1.34%Execution Time: 11/15/2023 10:15:07 AMChandler Asset Management - CONFIDENTIALPage 1 Holdings ReportAs of October 31, 2023
City of Buena Park LiquidAccount #406CUSIPSecurity DescriptionPar Value/UnitsPurchase DateBook YieldCost ValueBook ValueMkt PriceMkt YTMMarket ValueAccrued Int.% of Port.Gain/LossMoody/S&P FitchMaturityDurationLAIF90LAIF$00 Local Agency Investment Fund State Pool20,060,634.83Various3.65%20,060,634.8320,060,634.831.003.65%20,060,634.8360,571.26100.00%0.00NR / NRNR0.000.00Total LAIF20,060,634.833.65%20,060,634.8320,060,634.833.65%20,060,634.8360,571.26100.00%0.00NR / NRNR0.000.00TOTAL PORTFOLIO20,060,634.833.65%20,060,634.8320,060,634.833.65%20,060,634.8360,571.26100.00%0.00NR / NRNR0.000.00TOTAL MARKET VALUE PLUS ACCRUED20,121,206.09 Execution Time: 11/15/2023 10:15:07 AMChandler Asset Management - CONFIDENTIALPage 2 Transaction LedgerAs of October 31, 2023
City of Buena Park LiquidAccount #406Transaction TypeSettlement DateCUSIPQuantitySecurity DescriptionPriceAcq/DispYieldAmountInterestPur/SoldTotal AmountGain/LossACQUISITIONSPurchase 10/15/2023 90LAIF$00187,386.87Local Agency Investment Fund State Pool1.0003.61%187,386.870.00187,386.870.00Subtotal187,386.87187,386.870.00187,386.870.00Security Contribution10/04/2023 90LAIF$006,000,000.00Local Agency Investment Fund State Pool1.0006,000,000.000.006,000,000.000.00Subtotal6,000,000.006,000,000.000.006,000,000.000.00TOTAL ACQUISITIONS6,187,386.876,187,386.870.006,187,386.870.00OTHER TRANSACTIONSDividend 10/15/2023 90LAIF$001,866,921,058.33Local Agency Investment Fund State Pool0.000196,616.440.00196,616.440.00Subtotal1,866,921,058.33196,616.440.00196,616.440.00TOTAL OTHER TRANSACTIONS1,866,921,058.33196,616.440.00196,616.440.00 Execution Time: 11/15/2023 10:15:07 AMChandler Asset Management - CONFIDENTIALPage 3 Income EarnedAs of October 31, 2023
City of Buena Park LiquidAccount #406CUSIPSecurity DescriptionTrade DateSettle DateUnitsBook Value: BeginBook Value: AcqBook Value: DispBook Value: EndPrior AccruedInc. ReceivedEnding AccruedTotal InterestAccr. Of DiscountAmort. Of PremiumNet Accret/AmortIncome EarnedTotal IncomeLOCAL AGENCY INVESTMENT FUND 90LAIF$00 Local Agency Investment Fund State Pool VariousVarious20,060,634.8313,873,247.966,187,386.870.0020,060,634.83174,459.96196,616.4460,571.2682,727.740.000.000.0082,727.7482,727.74Total Local Agency Investment Fund20,060,634.8313,873,247.966,187,386.870.0020,060,634.83174,459.96196,616.4460,571.2682,727.740.000.000.0082,727.7482,727.74TOTAL PORTFOLIO20,060,634.8313,873,247.966,187,386.870.0020,060,634.83174,459.96196,616.4460,571.2682,727.740.000.000.0082,727.7482,727.74 Execution Time: 11/15/2023 10:15:07 AMChandler Asset Management - CONFIDENTIALPage 4 Cash Flow ReportAs of October 31, 2023
City of Buena Park LiquidAccount #406Payment DateTransaction TypeCUSIPQuantitySecurity DescriptionPrincipal AmountIncomeTotal Amount01/15/2024 Dividend 90LAIF$00595,068,876.68Local Agency Investment Fund State Pool0.0059,835.5159,835.51JAN 20240.0059,835.5159,835.51TOTAL0.0059,835.5159,835.51 Execution Time: 11/15/2023 10:15:07 AMChandler Asset Management - CONFIDENTIALPage 5 ACCOUNT SUMMARYBeg. Valuesas of 9/30/23End Valuesas of 10/31/23Market Value1,247,6681,252,978Accrued Interest00Total Market Value1,247,6681,252,978Income Earned5,4595,310Cont/WD0Par1,247,6681,252,978Book Value1,247,6681,252,978Cost Value1,247,6681,252,978TOP ISSUERSFederated GOVT Obligation MMF 100.0%Total 100.0%PORTFOLIO CHARACTERISTICSAverage Modified Duration 0.00Average Coupon 5.22%Average Purchase YTM 5.22%Average Market YTM 5.22%Average S&P/Moody Rating AAA/AaaAverage Final Maturity 0.00 yrsAverage Life 0.00 yrsCREDIT QUALITY (S&P)
MATURITY DISTRIBUTION
SECTOR ALLOCATION
Portfolio SummaryAs of October 31, 2023
City of Buena Park RDA Series B BondAccount #10033
PERFORMANCE REVIEWAnnualizedTOTAL RATE OF RETURN1M3MYTD1YR2YRS3YRS5YRS10YRS7/31/2008City of Buena Park RDA Series B Bond 0.43% 1.29% 4.01% 4.56% 2.59% 1.73% 1.63% 1.03% 1.22%Execution Time: 11/2/2023 8:16:25 PMChandler Asset Management - CONFIDENTIALPage 1 Category Standard Comment U.S. Treasury Securities No limitationsCompliesU.S. Gov't. Agency Issues No limitationsCompliesNo maximum; A-1CompliesNegotiable CDs No limitations; A-1CompliesState Municipal Obligations No maximum; A3/ACompliesCommercial Paper No maximum; A-1+/P-1CompliesRepurchase Agreements Currently not used by adviserCompliesLAIF Currently not used by adviserCompliesMoney Market Mutual Funds Aam/Aam-G ratedCompliesReverse Repurchase Agreements ProhibitedCompliesFinancial Futures & Options ProhibitedCompliesMaximum Maturity 5 yearsCompliesBuena Park 2008 Taxable Tax Allocation Bonds, Series BAs of October 31, 2023Assets managed by Chandler Asset Management are in full compliance with state law and with the investment policy. Statement of Compliance
BOOK VALUE RECONCILIATIONBEGINNING BOOK VALUE$1,247,668.39Acquisition+ Security Purchases$0.00+ Money Market Fund Purchases$5,309.56+ Money Market Contributions$0.00+ Security Contributions$0.00+ Security Transfers$0.00 Total Acquisitions$5,309.56Dispositions- Security Sales$0.00- Money Market Fund Sales$0.00- MMF Withdrawals$0.00- Security Withdrawals$0.00- Security Transfers$0.00- Other Dispositions$0.00- Maturities$0.00- Calls$0.00- Principal Paydowns$0.00 Total Dispositions$0.00Amortization/Accretion+/- Net Accretion$0.00$0.00Gain/Loss on Dispositions+/- Realized Gain/Loss$0.00$0.00ENDING BOOK VALUE$1,252,977.95 CASH TRANSACTION SUMMARYBEGINNING BALANCE$1,247,668.39Acquisition Contributions$0.00 Security Sale Proceeds$0.00 Accrued Interest Received$0.00 Interest Received$0.00 Dividend Received$5,309.56 Principal on Maturities$0.00 Interest on Maturities$0.00 Calls/Redemption (Principal)$0.00 Interest from Calls/Redemption$0.00 Principal Paydown$0.00Total Acquisitions$5,309.56Dispositions Withdrawals$0.00 Security Purchase$0.00 Accrued Interest Paid$0.00Total Dispositions$0.00ENDING BOOK VALUE$1,252,977.95 Reconciliation SummaryAs of October 31, 2023
City of Buena Park RDA Series B BondAccount #10033
Execution Time: 11/2/2023 8:16:25 PMChandler Asset Management - CONFIDENTIALPage 3 Holdings ReportAs of October 31, 2023
City of Buena Park RDA Series B BondAccount #10033CUSIPSecurity DescriptionPar Value/UnitsPurchase DateBook YieldCost ValueBook ValueMkt PriceMkt YTMMarket ValueAccrued Int.% of Port.Gain/LossMoody/S&P FitchMaturityDurationMONEY MARKET FUND60934N104 Federated Investors Government Obligations Fund1,252,977.95Various5.22%1,252,977.951,252,977.951.005.22%1,252,977.950.00100.00%0.00Aaa / AAAAAA0.000.00Total Money Market Fund1,252,977.955.22%1,252,977.951,252,977.955.22%1,252,977.950.00100.00%0.00Aaa / AAAAAA0.000.00TOTAL PORTFOLIO1,252,977.955.22%1,252,977.951,252,977.955.22%1,252,977.950.00100.00%0.00Aaa / AAAAAA0.000.00TOTAL MARKET VALUE PLUS ACCRUED1,252,977.95 Execution Time: 11/2/2023 8:16:25 PMChandler Asset Management - CONFIDENTIALPage 4 Transaction LedgerAs of October 31, 2023
City of Buena Park RDA Series B BondAccount #10033Transaction TypeSettlement DateCUSIPQuantitySecurity DescriptionPriceAcq/DispYieldAmountInterestPur/SoldTotal AmountGain/LossACQUISITIONSPurchase 10/02/2023 60934N1045,309.56Federated Investors Government Obligations Fund1.0005.18%5,309.560.005,309.560.00Subtotal5,309.565,309.560.005,309.560.00TOTAL ACQUISITIONS5,309.565,309.560.005,309.560.00OTHER TRANSACTIONSDividend 10/02/2023 60934N1041,247,668.39Federated Investors Government Obligations Fund0.0005,309.560.005,309.560.00Subtotal1,247,668.395,309.560.005,309.560.00TOTAL OTHER TRANSACTIONS1,247,668.395,309.560.005,309.560.00 Execution Time: 11/2/2023 8:16:25 PMChandler Asset Management - CONFIDENTIALPage 5 Income EarnedAs of October 31, 2023
City of Buena Park RDA Series B BondAccount #10033CUSIPSecurity DescriptionTrade DateSettle DateUnitsBook Value: BeginBook Value: AcqBook Value: DispBook Value: EndPrior AccruedInc. ReceivedEnding AccruedTotal InterestAccr. Of DiscountAmort. Of PremiumNet Accret/AmortIncome EarnedTotal IncomeCASH & EQUIVALENT 60934N104 Federated Investors Government Obligations Fund VariousVarious1,252,977.951,247,668.395,309.560.001,252,977.950.005,309.560.005,309.560.000.000.005,309.565,309.56Total Cash & Equivalent1,252,977.951,247,668.395,309.560.001,252,977.950.005,309.560.005,309.560.000.000.005,309.565,309.56TOTAL PORTFOLIO1,252,977.951,247,668.395,309.560.001,252,977.950.005,309.560.005,309.560.000.000.005,309.565,309.56 Execution Time: 11/2/2023 8:16:25 PMChandler Asset Management - CONFIDENTIALPage 6 Execution Time: 11/2/2023 8:16:25 PMChandler Asset Management - CONFIDENTIALPage 7 City of Buena Park
City Council Regular Meeting Agenda Report
RESOLUTION AUTHORIZING AND DIRECTING CERTAIN BANKS TO HONOR ALL CHECKS, DRAFTS, AND WARRANTS
WHEN BEARING CERTAIN SIGNATURES AND FACSIMILE SIGNATURES OF CITY OFFICIALS AND RESCINDING ALL
CONFLICTING RESOLUTIONS
Meeting
Tuesday, December 12, 2023, 5:00 PM
Agenda Group
CONSENT CALENDAR Item: 4C
Presented By
Sung Hyun, Director of Finance
Prepared By
Sung Hyun, Director of Finance
Approved By
Aaron France, City Manager
Attachments
mayor signature reso-city.pdf
RECOMMENDED ACTION
Adopt resolution.
RESOLUTION NO. ______
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF BUENA
PARK, CALIFORNIA, AUTHORIZING AND DIRECTING CERTAIN
BANKS TO HONOR ALL CHECKS, DRAFTS, AND WARRANTS WHEN
BEARING CERTAIN SIGNATURES AND FACSIMILE SIGNATURES OF
CITY OFFICIALS AND RESCINDING ALL CONFLICTING
RESOLUTIONS.
WHEREAS, the City has certain Banks as depositories of City funds, and
WHEREAS, the City Council determines that it is necessary for the efficient administration of fiscal affairs of the City that this Resolution be passed and adopted.
NOW, THEREFORE, the City Council of the City of Buena Park does hereby resolve, determine, and order as follows:
Section 1: Each depository of the City of Buena Park, be and it is hereby requested, authorized, and directed to honor all checks, drafts, warrants or other orders for the payment of money drawn in the name of the City of Buena Park on all of its accounts when bearing or purporting to bear the manual or facsimile signature of Mayor _________________ or Mayor Pro Te m _____________________, plus the manual or facsimile signature of the Director of Finance.
Section 2: Said banks, including their correspondent banks, shall be entitled to honor and charge the City for all such checks, warrants, drafts or other orders for the payment of money, regardless of by whom or by what means the actual or purported facsimile signature or signatures thereon may have been affixed hereto, if such facsimile signature or signatures resemble the specimens filed with the said bank by the City Clerk of the City of Buena Park.
Section 3: All previous Resolutions authorizing the honoring of signatures and facsimile signatures of City officials other than those set forth in this Resolution are hereby rescinded.
PASSED AND ADOPTED this ____ day of ________ ____, by the following called vote:
AYES: COUNCILMEMBERS:
NOES: COUNCILMEMBERS:
ABSENT: COUNCILMEMBERS:
ABSTAIN: COUNCILMEMBERS:
________________________________
Mayor
RESOLUTION NO. _______
ATTEST:
_______________________________
City Clerk
I, Adria M. Jimenez , City Clerk of the City of Buena Park, California, hereby certify that the foregoing resolution was duly and regularly passed and adopted at a regular meeting of the City Council of the City of Buena Park, held this _____ day of ________________ _____.
________________________________
City Clerk
City of Buena Park
City Council Regular Meeting Agenda Report
AGREEMENT WITH ORANGE COUNTY SHERIFF’S DEPARTMENT (OCSD) TO TRANSFER FUNDS RELATED TO THE 2023 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT (JAG) PROGRAM FOR SUPPLEMENTAL FUNDING
FOR THE LEASING OF FLOCK AUTOMATED LICENSE PLATE READER (ALPR) TECHNOLOGY Meeting
Tuesday, December 12, 2023, 5:00 PM
Agenda Group
CONSENT CALENDAR Item: 4D
Presented By
Brad Geyer, Police Captain
Prepared By
Brad Geyer, Police Captain
Approved By
Aaron France, City Manager
RECOMMENDED ACTION
1) Approve an agreement with the Orange County Sheriff’s Department (OCSD) to transfer funds for the 2023 Edward Byrne Memorial Justice Assistance Grant (JAG) Program for supplemental funding for the leasing of Flock Automated License Plate Reader technology to assist in criminal investigations and identify suspects involved in criminal activity; 2) Authorize the City Manager and City Attorney to make any necessary, non-monetary changes to the agreement; 3) Authorize the City Manager and City Clerk to execute the agreement; 4) Approve a budgetary action to appropriate funds in the amount of $16,948; and, 5) Authorize the police department to work with the vendor, Flock, to secure additional technology.
PREVIOUS CITY COUNCIL ACTION
On February 14, 2023, The City Council approved a similar agreement with the OCSD to accept JAG funding for the funding of overtime costs associated to working cold case overtime hours.
DISCUSSION
The Justice Assistance Grant (JAG) Program is a major source of federal criminal justice funding to state and local jurisdictions. JAG funds support all components of the criminal justice system, including taskforce operations, prosecution, crime prevention, and technology. The Bureau of Justice Statistics uses a formula for allocations, which is based upon population and Part I violent crime statistics (e.g. murder, non-negligent homicide, rape, robbery, aggravated assault, burglary, motor vehicle theft, larceny-theft, and arson).
The Police Department proposes to utilize these funds to supplement the costs associated to leasing Automated License Plate Reader (ALPR) technology. The department already has an ongoing lease agreement with Flock, Inc. to utilize this technology. The project’s goals are to assist detectives in criminal investigations, identify stolen vehicles or vehicles used in the commission of other crimes, and identify suspects entering/exiting the City limits who are involved in nefarious activity.
Attachments
JAG Memorandum of Understanding.PDF
JAG Acceptance Award Package FAW-177944.pdf
BUDGET IMPACT
The City’s allocation from the JAG Program is $16,738. This amount will be used to pay for additional cameras at a new location to be identified by police department staff.
Department of Justice (DOJ)
Office of Justice Programs
Bureau of Justice Assistance
Washington, D.C. 20531
Name and Address of Recipient: COUNTY OF ORANGE 10 CIVIC CENTER PLAZA STE 107
City, State and Zip: SANTA ANA, CA 92701
Recipient UEI: RFT6BJ98H2A5
Project Title: Orange County (Sheriff-
Coroner) BJA FY23 Edward Byrne Memorial
Justice Assistance Grant (JAG) Program -
Local Solicitation
Award Number: 15PBJA-23-GG-03185-JAGX
Solicitation Title: BJA FY 23 Edward Byrne Memorial Justice Assistance Grant (JAG) Program - Local Solicitation Federal Award Amount: $500,787.00 Federal Award Date: 9/25/23 Awarding Agency: Office of Justice Programs
Bureau of Justice Assistance
Funding Instrument Type: Grant
Opportunity Category: D
Assistance Listing:
16.738 - Edward Byrne Memorial Justice Assistance Grant Program Project Period Start Date: 10/1/22 Project Period End Date: 9/30/26 Budget Period Start Date: 10/1/22 Budget Period End Date: 9/30/26 Project Description:
Orange County will use JAG funds for technology improvements and equipment to enhance and increase the community’s security. The following disparate jurisdictions will use the JAG funds as follows:
Anaheim will purchase overt surveillance cameras to monitor criminal activity; Buena Park will install and lease automated license plate readers to detect vehicles associated with illegal activity; Costa Mesa and Irvine for a police canine to combat and reduce drug trafficking and educate the public on the threat of drugs; Fullerton for vests and automated external defibrillators to increase community and officer safety; Garden Grove for a software program to enhance the recruitment process and de-escalation training; Huntington Beach for officer overtime to address collision factors associated with electric bikes; La Habra for a digital collector and inspector software to increase evidence-viewing capabilities; Newport Beach for services to investigate and file criminal cases; Orange for equipment to respond to and combat current crime trends; Placentia for community outreach events to educate the community about crime prevention; Santa Ana for overtime and purchase of equipment, supplies, and miscellaneous for youth programming; Tustin for equipment to enhance the efficiency of law enforcement operations and improve community safety; and Westminster will hire two part-time Records Specialists as part of the Records Unit to assist the team with discovery and public records requests.
Page: 1 of 23
Award Letter
September 25, 2023
Dear Karla Lazaridis,
On behalf of Attorney General Merrick B. Garland, it is my pleasure to inform you the Office of Justice Programs (OJP) has approved the application submitted by COUNTY OF ORANGE for an award under the funding opportunity entitled 2023 BJA FY 23 Edward Byrne Memorial Justice Assistance Grant (JAG) Program - Local Solicitation. The approved award amount is $500,787.
Review the Award Instrument below carefully and familiarize yourself with all conditions and requirements before accepting your award. The Award Instrument includes the Award Offer (Award Information, Project Information, Financial Information, and Award Conditions) and Award Acceptance. For COPS Office and OVW funding the Award Offer also includes any Other Award Documents.
Please note that award requirements include not only the conditions and limitations set forth in the Award Offer, but also compliance with assurances and certifications that relate to conduct during the period of performance for the award. These requirements encompass financial, administrative, and programmatic matters, as well as other important matters (e.g., specific restrictions on use of funds). Therefore, all key staff should receive the award conditions, the assurances and certifications, and the application as approved by OJP, so that they understand the award requirements. Information on all pertinent award requirements also must be provided to any subrecipient of the award.
Should you accept the award and then fail to comply with an award requirement, DOJ will pursue appropriate remedies for non-compliance, which may include termination of the award and/or a requirement to repay award funds.
Prior to accepting the award, your Entity Administrator must assign a Financial Manager, Grant Award Administrator, and Authorized Representative(s) in the Justice Grants System (JustGrants). The Entity Administrator will need to ensure the assigned Authorized Representative(s) is current and has the legal authority to accept awards and bind the entity to the award terms and conditions. To accept the award, the Authorized Representative(s) must accept all parts of the Award Offer in the Justice Grants System (JustGrants), including by executing the required declaration and certification, within 45 days from the award date.
To access your funds, you will need to enroll in the Automated Standard Application for Payments (ASAP) system, if you haven’t already completed the enrollment process in ASAP. The Entity Administrator should have already received an email from ASAP to initiate this process.
Congratulations, and we look forward to working with you.
Maureen Henneberg
Deputy Assistant Attorney General
Office for Civil Rights Notice for All Recipients
The Office for Civil Rights (OCR), Office of Justice Programs (OJP), U.S. Department of Justice (DOJ) has been delegated the responsibility for ensuring that recipients of federal financial assistance from the OJP, the Office of Community Oriented Policing Services (COPS), and the Office on Violence Against Women (OVW) are not engaged in discrimination prohibited by law. Several federal civil rights laws, such as Title VI of the Civil Rights Act of 1964 and Section 504 of the Rehabilitation Act of 1973, require recipients of federal financial assistance to give assurances that they will comply with those laws. Taken together, these civil rights laws prohibit recipients of federal financial assistance from DOJ from discriminating in services and employment because of race, color, national origin, religion, disability, sex, and, for grants authorized under the Violence Against Women Act, sexual orientation and gender identity. Recipients are also prohibited from discriminating in services because of age. For a complete review of these civil rights laws and nondiscrimination requirements, in connection with DOJ awards, see https://ojp.gov/funding/ Explore/LegalOverview/CivilRightsRequirements.htm.
Under the delegation of authority, the OCR investigates allegations of discrimination against recipients from individuals, entities, or groups. In addition, the OCR conducts limited compliance reviews and audits based on regulatory criteria.
Page: 2 of 23
These reviews and audits permit the OCR to evaluate whether recipients of financial assistance from the Department are providing services in a nondiscriminatory manner to their service population or have employment practices that meet equal-opportunity standards.
If you are a recipient of grant awards under the Omnibus Crime Control and Safe Streets Act or the Juvenile Justice and Delinquency Prevention Act and your agency is part of a criminal justice system, there are two additional obligations that may apply in connection with the awards: (1) complying with the regulation relating to Equal Employment Opportunity Programs (EEOPs); and (2) submitting findings of discrimination to OCR. For additional information regarding the EEOP requirement, see 28 CFR Part 42, subpart E, and for additional information regarding requirements when there is an adverse finding, see 28 C.F.R. §§ 42.204(c), .205(c)(5).
The OCR is available to help you and your organization meet the civil rights requirements that are associated with DOJ grant funding. If you would like the OCR to assist you in fulfilling your organization's civil rights or nondiscrimination responsibilities as a recipient of federal financial assistance, please do not hesitate to contact the OCR at [email protected].
Memorandum Regarding NEPA
NEPA Letter Type
OJP - Ongoing NEPA Compliance Incorporated into Further Developmental Stages NEPA Letter
The Edward Byrne Memorial Justice Assistance Grant Program (JAG) allows states and local governments to support a broad range of activities to prevent and control crime and to improve the criminal justice system, some of which could have environmental impacts. All recipients of JAG funding must assist BJA in complying with NEPA and other related federal environmental impact analyses requirements in the use of grant funds, whether the funds are used directly by the grantee or by a subgrantee or third party.? Accordingly,?prior to obligating?funds for any of the specified activities, the grantee must first determine if any of the specified activities will be?funded by the grant.
The specified activities requiring environmental analysis are:
a. New construction;
b. Any renovation or remodeling of a property located in an environmentally or historically sensitive area, including properties located within a 100-year flood plain, a wetland, or habitat for endangered species, or a property listed on or eligible for listing on the National Register of Historic Places; c.? A renovation, lease, or any proposed use of a building or facility that will either (a) result in a change in its basic prior use or (b) significantly change its size;
d.? Implementation of a new program involving the use of chemicals other than chemicals that are (a) purchased as an incidental component of a funded activity and (b) traditionally used, for example, in office, household, recreational, or education environments; and
e. Implementation of a program relating to clandestine methamphetamine laboratory operations, including the identification, seizure, or closure of clandestine methamphetamine laboratories.
Complying with NEPA may require the preparation of an Environmental Assessment and/or an Environmental Impact Statement, as directed by BJA. Further, for programs relating to methamphetamine laboratory operations, the preparation of a detailed Mitigation Plan will be required. For more information about Mitigation Plan requirements, please see https://www.bja.gov/Funding/nepa.html.
NEPA Coordinator
First Name
Orbin Middle Name Last Name
Terry
Page: 3 of 23
Award Information
This award is offered subject to the conditions or limitations set forth in the Award Information, Project Information, Financial Information, and Award Conditions.
Recipient Information
Recipient Name
COUNTY OF ORANGE
UEI
RFT6BJ98H2A5
Street 1
10 CIVIC CENTER PLAZA STE 107 Street 2
City
SANTA ANA
State/U.S. Territory
California
Zip/Postal Code
92701
Country
United States
County/Parish
Province
Award Details
Federal Award Date
9/25/23
Award Type
Initial
Award Number
15PBJA-23-GG-03185-JAGX
Supplement Number
00 Federal Award Amount
$500,787.00
Funding Instrument Type
Grant
Assistance Listing
Number
Assistance Listings Program Title
16.738 Edward Byrne Memorial Justice Assistance Grant Program Statutory Authority
Title I of Public Law 90-351 (generally codified at 34 U.S.C. 10101-10726), including subpart 1 of part E (codified at 34 U.S.C. 10151-10158); see also 28 U.S.C. 530C(a)
[ ]
I have read and understand the information presented in this section of the Federal Award Instrument.
Project Information
Page: 4 of 23
This award is offered subject to the conditions or limitations set forth in the Award Information, Project Information, Financial Information, and Award Conditions.
Solicitation Title
2023 BJA FY 23 Edward Byrne Memorial Justice
Assistance Grant (JAG) Program - Local Solicitation
Application Number
GRANT13959460
Awarding Agency
OJP
Program Office
BJA
Grant Manager Name
Elaine Smokes
Phone Number
202-307-1611
E-mail Address
[email protected]
Project Title
Orange County (Sheriff-Coroner) BJA FY23 Edward Byrne Memorial Justice Assistance Grant (JAG) Program - Local Solicitation
Performance Period Start
Date
10/01/2022
Performance Period End Date
09/30/2026
Budget Period Start Date
10/01/2022
Budget Period End Date
09/30/2026
Project Description
Orange County will use JAG funds for technology improvements and equipment to enhance and increase the community’s security. The following disparate jurisdictions will use the JAG funds as follows:
Anaheim will purchase overt surveillance cameras to monitor criminal activity; Buena Park will install and lease automated license plate readers to detect vehicles associated with illegal activity; Costa Mesa and Irvine for a police canine to combat and reduce drug trafficking and educate the public on the threat of drugs; Fullerton for vests and automated external defibrillators to increase community and officer safety; Garden Grove for a software program to enhance the recruitment process and de-escalation training; Huntington Beach for officer overtime to address collision factors associated with electric bikes; La Habra for a digital collector and inspector software to increase evidence-viewing capabilities; Newport Beach for services to investigate and file criminal cases; Orange for equipment to respond to and combat current crime trends; Placentia for community outreach events to educate the community about crime prevention; Santa Ana for overtime and purchase of equipment, supplies, and miscellaneous for youth programming; Tustin for equipment to enhance the efficiency of law enforcement operations and improve community safety; and Westminster will hire two part-time Records Specialists as part of the Records Unit to assist the team with discovery and public records requests. [ ]
I have read and understand the information presented in this section of the Federal Award Instrument.
Page: 5 of 23
Financial Information
This award is offered subject to the conditions or limitations set forth in the Award Information, Project Information, Financial Information, and Award Conditions. [ ]
I have read and understand the information presented in this section of the Federal Award Instrument.
Award Conditions
This award is offered subject to the conditions or limitations set forth in the Award Information, Project Information, Financial Information, and Award Conditions. 1 Compliance with restrictions on the use of federal funds--prohibited and controlled equipment under OJP awards Consistent with Executive Order 14074, “Advancing Effective, Accountable Policing and Criminal Justice Practices To Enhance Public Trust and Public Safety,” OJP has prohibited the use of federal funds under this award for purchases or transfers of specified equipment by law enforcement agencies. In addition, OJP requires the recipient, and any subrecipient (“subgrantee”) at any tier, to put in place specified controls prior to using federal funds under this award to acquire or transfer any property identified on the “controlled equipment” list. The details of the requirement are posted on the OJP web site at https://www.ojp.gov/funding/explore/prohibited-and-controlled-equipment (Award condition:
Compliance with restrictions on the use of federal funds--prohibited and controlled equipment under OJP awards), and are incorporated by reference here.
2 Compliance with DOJ regulations pertaining to civil rights and nondiscrimination - 28 C.F.R. Part 54 The recipient, and any subrecipient ("subgrantee") at any tier, must comply with all applicable requirements of 28 C.F.R. Part 54, which relates to nondiscrimination on the basis of sex in certain "education programs." 3 Compliance with 41 U.S.C. 4712 (including prohibitions on reprisal; notice to employees) The recipient (and any subrecipient at any tier) must comply with, and is subject to, all applicable provisions of 41 U.S.C. 4712, including all applicable provisions that prohibit, under specified circumstances, discrimination against an employee as reprisal for the employee's disclosure of information related to gross mismanagement of a federal grant, a gross waste of federal funds, an abuse of authority relating to a federal grant, a substantial and specific danger to public health or safety, or a violation of law, rule, or regulation related to a federal grant.
The recipient also must inform its employees, in writing (and in the predominant native language of the workforce), of employee rights and remedies under 41 U.S.C. 4712.
Should a question arise as to the applicability of the provisions of 41 U.S.C. 4712 to this award, the recipient is to contact the DOJ awarding agency (OJP or OVW, as appropriate) for guidance. 4 Applicability of Part 200 Uniform Requirements
The Uniform Administrative Requirements, Cost Principles, and Audit Requirements in 2 C.F.R. Part 200, as adopted and supplemented by DOJ in 2 C.F.R. Part 2800 (together, the "Part 200 Uniform Requirements") apply to this FY 2022 award from OJP.
The Part 200 Uniform Requirements were first adopted by DOJ on December 26, 2014. If this FY 2022 award Page: 6 of 23
supplements funds previously awarded by OJP under the same award number (e.g., funds awarded during or before December 2014), the Part 200 Uniform Requirements apply with respect to all funds under that award number (regardless of the award date, and regardless of whether derived from the initial award or a supplemental award) that are obligated on or after the acceptance date of this FY 2022 award.
For more information and resources on the Part 200 Uniform Requirements as they relate to OJP awards and subawards ("subgrants"), see the OJP website at https://ojp.gov/funding/Part200UniformRequirements.htm.
Record retention and access: Records pertinent to the award that the recipient (and any subrecipient ("subgrantee") at any tier) must retain -- typically for a period of 3 years from the date of submission of the final expenditure report (SF 425), unless a different retention period applies -- and to which the recipient (and any subrecipient ("subgrantee") at any tier) must provide access, include performance measurement information, in addition to the financial records, supporting documents, statistical records, and other pertinent records indicated at 2 C.F.R. 200.334.
In the event that an award-related question arises from documents or other materials prepared or distributed by OJP that may appear to conflict with, or differ in some way from, the provisions of the Part 200 Uniform Requirements, the recipient is to contact OJP promptly for clarification. 5 Compliance with applicable rules regarding approval, planning, and reporting of conferences, meetings, trainings, and other events
The recipient, and any subrecipient ("subgrantee") at any tier, must comply with all applicable laws, regulations, policies, and official DOJ guidance (including specific cost limits, prior approval and reporting requirements, where applicable) governing the use of federal funds for expenses related to conferences (as that term is defined by DOJ), including the provision of food and/or beverages at such conferences, and costs of attendance at such conferences.
Information on the pertinent DOJ definition of conferences and the rules applicable to this award appears in the DOJ Grants Financial Guide (currently, as section 3.10 of "Postaward Requirements" in the "DOJ Grants Financial Guide"). 6 Requirement for data on performance and effectiveness under the award The recipient must collect and maintain data that measure the performance and effectiveness of work under this award. The data must be provided to OJP in the manner (including within the timeframes) specified by OJP in the program solicitation or other applicable written guidance. Data collection supports compliance with the Government Performance and Results Act (GPRA) and the GPRA Modernization Act of 2010, and other applicable laws. 7 Compliance with DOJ Grants Financial Guide
References to the DOJ Grants Financial Guide are to the DOJ Grants Financial Guide as posted on the OJP website (currently, the "DOJ Grants Financial Guide" available at https://ojp.gov/financialguide/DOJ/index.htm), including any updated version that may be posted during the period of performance. The recipient agrees to comply with the DOJ Grants Financial Guide.
8 Compliance with general appropriations-law restrictions on the use of federal funds (FY 2022) The recipient, and any subrecipient ("subgrantee") at any tier, must comply with all applicable restrictions on the use of federal funds set out in federal appropriations statutes. Pertinent restrictions, including from various "general provisions" in the Consolidated Appropriations Act, 2022, are set out at https://www.ojp.gov/funding/Explore/ FY22AppropriationsRestrictions.htm, and are incorporated by reference here.
Should a question arise as to whether a particular use of federal funds by a recipient (or a subrecipient) would or might fall within the scope of an appropriations-law restriction, the recipient is to contact OJP for guidance, and may not proceed without the express prior written approval of OJP.
Page: 7 of 23
9 Compliance with DOJ regulations pertaining to civil rights and nondiscrimination - 28 C.F.R. Part 38 The recipient, and any subrecipient ("subgrantee") at any tier, must comply with all applicable requirements of 28 C.F.R. Part 38 (as may be applicable from time to time), specifically including any applicable requirements regarding written notice to program beneficiaries and prospective program beneficiaries.
Currently, among other things, 28 C.F.R. Part 38 includes rules that prohibit specific forms of discrimination on the basis of religion, a religious belief, a refusal to hold a religious belief, or refusal to attend or participate in a religious practice. Part 38, currently, also sets out rules and requirements that pertain to recipient and subrecipient ("subgrantee") organizations that engage in or conduct explicitly religious activities, as well as rules and requirements that pertain to recipients and subrecipients that are faith-based or religious organizations.
The text of 28 C.F.R. Part 38 is available via the Electronic Code of Federal Regulations (currently accessible at https:/ /www.ecfr.gov/cgi-bin/ECFR?page=browse), by browsing to Title 28-Judicial Administration, Chapter 1, Part 38, under e-CFR "current" data.
10 Effect of failure to address audit issues
The recipient understands and agrees that the DOJ awarding agency (OJP or OVW, as appropriate) may withhold award funds, or may impose other related requirements, if (as determined by the DOJ awarding agency) the recipient does not satisfactorily and promptly address outstanding issues from audits required by the Part 200 Uniform Requirements (or by the terms of this award), or other outstanding issues that arise in connection with audits, investigations, or reviews of DOJ awards.
11 Requirements of the award; remedies for non-compliance or for materially false statements The conditions of this award are material requirements of the award. Compliance with any assurances or certifications submitted by or on behalf of the recipient that relate to conduct during the period of performance also is a material requirement of this award.
Limited Exceptions. In certain special circumstances, the U.S. Department of Justice ("DOJ") may determine that it will not enforce, or enforce only in part, one or more requirements otherwise applicable to the award. Any such exceptions regarding enforcement, including any such exceptions made during the period of performance, are (or will be during the period of performance) set out through the Office of Justice Programs ("OJP") webpage entitled "Legal Notices:
Special circumstances as to particular award conditions" (ojp.gov/funding/Explore/LegalNotices-AwardReqts.htm), and incorporated by reference into the award.
By signing and accepting this award on behalf of the recipient, the authorized recipient official accepts all material requirements of the award, and specifically adopts, as if personally executed by the authorized recipient official, all assurances or certifications submitted by or on behalf of the recipient that relate to conduct during the period of performance.
Failure to comply with one or more award requirements -- whether a condition set out in full below, a condition incorporated by reference below, or an assurance or certification related to conduct during the award period -- may result in OJP taking appropriate action with respect to the recipient and the award. Among other things, the OJP may withhold award funds, disallow costs, or suspend or terminate the award. DOJ, including OJP, also may take other legal action as appropriate.
Any materially false, fictitious, or fraudulent statement to the federal government related to this award (or concealment or omission of a material fact) may be the subject of criminal prosecution (including under 18 U.S.C. 1001 and/or 1621, and/or 34 U.S.C. 10271-10273), and also may lead to imposition of civil penalties and administrative remedies for false claims or otherwise (including under 31 U.S.C. 3729-3730 and 3801-3812).
Page: 8 of 23
Should any provision of a requirement of this award be held to be invalid or unenforceable by its terms, that provision shall first be applied with a limited construction so as to give it the maximum effect permitted by law. Should it be held, instead, that the provision is utterly invalid or -unenforceable, such provision shall be deemed severable from this award.
12 Compliance with DOJ regulations pertaining to civil rights and nondiscrimination - 28 C.F.R. Part 42 The recipient, and any subrecipient ("subgrantee") at any tier, must comply with all applicable requirements of 28 C.F.R. Part 42, specifically including any applicable requirements in Subpart E of 28 C.F.R. Part 42 that relate to an equal employment opportunity program.
13 Requirements related to "de minimis" indirect cost rate A recipient that is eligible under the Part 200 Uniform Requirements and other applicable law to use the "de minimis" indirect cost rate described in 2 C.F.R. 200.414(f), and that elects to use the "de minimis" indirect cost rate, must advise OJP in writing of both its eligibility and its election, and must comply with all associated requirements in the Part 200 Uniform Requirements. The "de minimis" rate may be applied only to modified total direct costs (MTDC) as defined by the Part 200 Uniform Requirements.
14 Employment eligibility verification for hiring under the award
1. The recipient (and any subrecipient at any tier) must-- A. Ensure that, as part of the hiring process for any position within the United States that is or will be funded (in whole or in part) with award funds, the recipient (or any subrecipient) properly verifies the employment eligibility of the individual who is being hired, consistent with the provisions of 8 U.S.C. 1324a(a)(1).
B. Notify all persons associated with the recipient (or any subrecipient) who are or will be involved in activities under this award of both--
(1) this award requirement for verification of employment eligibility, and (2) the associated provisions in 8 U.S.C. 1324a(a)(1) that, generally speaking, make it unlawful, in the United States, to hire (or recruit for employment) certain aliens.
C. Provide training (to the extent necessary) to those persons required by this condition to be notified of the award requirement for employment eligibility verification and of the associated provisions of 8 U.S.C. 1324a(a)(1).
D. As part of the recordkeeping for the award (including pursuant to the Part 200 Uniform Requirements), maintain records of all employment eligibility verifications pertinent to compliance with this award condition in accordance with Form I-9 record retention requirements, as well as records of all pertinent notifications and trainings.
2. Monitoring
The recipient's monitoring responsibilities include monitoring of subrecipient compliance with this condition.
3. Allowable costs
To the extent that such costs are not reimbursed under any other federal program, award funds may be obligated for the reasonable, necessary, and allocable costs (if any) of actions designed to ensure compliance with this condition.
4. Rules of construction
A. Staff involved in the hiring process
Page: 9 of 23
For purposes of this condition, persons "who are or will be involved in activities under this award" specifically includes (without limitation) any and all recipient (or any subrecipient) officials or other staff who are or will be involved in the hiring process with respect to a position that is or will be funded (in whole or in part) with award funds.
B. Employment eligibility confirmation with E-Verify
For purposes of satisfying the requirement of this condition regarding verification of employment eligibility, the recipient (or any subrecipient) may choose to participate in, and use, E-Verify (www.e-verify.gov), provided an appropriate person authorized to act on behalf of the recipient (or subrecipient) uses E-Verify (and follows the proper E-Verify procedures, including in the event of a "Tentative Nonconfirmation" or a "Final Nonconfirmation") to confirm employment eligibility for each hiring for a position in the United States that is or will be funded (in whole or in part) with award funds.
C. "United States" specifically includes the District of Columbia, Puerto Rico, Guam, the Virgin Islands of the United States, and the Commonwealth of the Northern Mariana Islands.
D. Nothing in this condition shall be understood to authorize or require any recipient, any subrecipient at any tier, or any person or other entity, to violate any federal law, including any applicable civil rights or nondiscrimination law.
E. Nothing in this condition, including in paragraph 4.B., shall be understood to relieve any recipient, any subrecipient at any tier, or any person or other entity, of any obligation otherwise imposed by law, including 8 U.S.C. 1324a(a)(1).
Questions about E-Verify should be directed to DHS. For more information about E-Verify visit the E-Verify website (https://www.e-verify.gov/) or email E-Verify at [email protected]. E-Verify employer agents can email E-Verify at E- [email protected].
Questions about the meaning or scope of this condition should be directed to OJP, before award acceptance. 15 OJP Training Guiding Principles
Any training or training materials that the recipient -- or any subrecipient ("subgrantee") at any tier -- develops or delivers with OJP award funds must adhere to the OJP Training Guiding Principles for Grantees and Subgrantees, available at https://www.ojp.gov/funding/implement/training-guiding-principles-grantees-and-subgrantees. 16 Determination of suitability to interact with participating minors SCOPE. This condition applies to this award if it is indicated -- in the application for the award (as approved by DOJ)(or in the application for any subaward, at any tier), the DOJ funding announcement (solicitation), or an associated federal statute -- that a purpose of some or all of the activities to be carried out under the award (whether by the recipient, or a subrecipient at any tier) is to benefit a set of individuals under 18 years of age.
The recipient, and any subrecipient at any tier, must make determinations of suitability before certain individuals may interact with participating minors. This requirement applies regardless of an individual's employment status.
The details of this requirement are posted on the OJP web site at https://ojp.gov/funding/Explore/Interact-Minors.htm (Award condition: Determination of suitability required, in advance, for certain individuals who may interact with participating minors), and are incorporated by reference here. 17 Potential imposition of additional requirements
The recipient agrees to comply with any additional requirements that may be imposed by the DOJ awarding agency (OJP or OVW, as appropriate) during the period of performance for this award, if the recipient is designated as "high- risk" for purposes of the DOJ high-risk grantee list.
Page: 10 of 23
18 Required training for Grant Award Administrator and Financial Manager The Grant Award Administrator and all Financial Managers for this award must have successfully completed an "OJP financial management and grant administration training" by 120 days after the date of the recipient's acceptance of the award. Successful completion of such a training on or after October 15, 2020, will satisfy this condition.
In the event that either the Grant Award Administrator or a Financial Manager for this award changes during the period of performance, the new Grant Award Administrator or Financial Manager must have successfully completed an "OJP financial management and grant administration training" by 120 calendar days after the date the Entity Administrator enters updated Grant Award Administrator or Financial Manager information in JustGrants. Successful completion of such a training on or after October 15, 2020, will satisfy this condition.
A list of OJP trainings that OJP will consider "OJP financial management and grant administration training" for purposes of this condition is available at https://onlinegfmt.training.ojp.gov/. All trainings that satisfy this condition include a session on grant fraud prevention and detection.
The recipient should anticipate that OJP will immediately withhold ("freeze") award funds if the recipient fails to comply with this condition. The recipient's failure to comply also may lead OJP to impose additional appropriate conditions on this award.
19 Restrictions and certifications regarding non-disclosure agreements and related matters No recipient or subrecipient ("subgrantee") under this award, or entity that receives a procurement contract or subcontract with any funds under this award, may require any employee or contractor to sign an internal confidentiality agreement or statement that prohibits or otherwise restricts, or purports to prohibit or restrict, the reporting (in accordance with law) of waste, fraud, or abuse to an investigative or law enforcement representative of a federal department or agency authorized to receive such information.
The foregoing is not intended, and shall not be understood by the agency making this award, to contravene requirements applicable to Standard Form 312 (which relates to classified information), Form 4414 (which relates to sensitive compartmented information), or any other form issued by a federal department or agency governing the nondisclosure of classified information.
1. In accepting this award, the recipient--
a. represents that it neither requires nor has required internal confidentiality agreements or statements from employees or contractors that currently prohibit or otherwise currently restrict (or purport to prohibit or restrict) employees or contractors from reporting waste, fraud, or abuse as described above; and b. certifies that, if it learns or is notified that it is or has been requiring its employees or contractors to execute agreements or statements that prohibit or otherwise restrict (or purport to prohibit or restrict), reporting of waste, fraud, or abuse as described above, it will immediately stop any further obligations of award funds, will provide prompt written notification to the federal agency making this award, and will resume (or permit resumption of) such obligations only if expressly authorized to do so by that agency.
2. If the recipient does or is authorized under this award to make subawards ("subgrants"), procurement contracts, or both--
a. it represents that--
(1) it has determined that no other entity that the recipient's application proposes may or will receive award funds (whether through a subaward ("subgrant"), procurement contract, or subcontract under a procurement contract) either requires or has required internal confidentiality agreements or statements from employees or contractors that currently prohibit or otherwise currently restrict (or purport to prohibit or restrict) employees or contractors from reporting waste, fraud, or abuse as described above; and
Page: 11 of 23
(2) it has made appropriate inquiry, or otherwise has an adequate factual basis, to support this representation; and b. it certifies that, if it learns or is notified that any subrecipient, contractor, or subcontractor entity that receives funds under this award is or has been requiring its employees or contractors to execute agreements or statements that prohibit or otherwise restrict (or purport to prohibit or restrict), reporting of waste, fraud, or abuse as described above, it will immediately stop any further obligations of award funds to or by that entity, will provide prompt written notification to the federal agency making this award, and will resume (or permit resumption of) such obligations only if expressly authorized to do so by that agency.
20 Reclassification of various statutory provisions to a new Title 34 of the United States Code On September 1, 2017, various statutory provisions previously codified elsewhere in the U.S. Code were editorially reclassified (that is, moved and renumbered) to a new Title 34, entitled "Crime Control and Law Enforcement." The reclassification encompassed a number of statutory provisions pertinent to OJP awards (that is, OJP grants and cooperative agreements), including many provisions previously codified in Title 42 of the U.S. Code.
Effective as of September 1, 2017, any reference in this award document to a statutory provision that has been reclassified to the new Title 34 of the U.S. Code is to be read as a reference to that statutory provision as reclassified to Title 34. This rule of construction specifically includes references set out in award conditions, references set out in material incorporated by reference through award conditions, and references set out in other award requirements. 21 Requirement to report actual or imminent breach of personally identifiable information (PII) The recipient (and any "subrecipient" at any tier) must have written procedures in place to respond in the event of an actual or imminent "breach" (OMB M-17-12) if it (or a subrecipient) -- (1) creates, collects, uses, processes, stores, maintains, disseminates, discloses, or disposes of "Personally Identifiable Information (PII)" (2 CFR 200.1) within the scope of an OJP grant-funded program or activity, or (2) uses or operates a "Federal information system" (OMB Circular A-130). The recipient's breach procedures must include a requirement to report actual or imminent breach of PII to an OJP Program Manager no later than 24 hours after an occurrence of an actual breach, or the detection of an imminent breach.
22 Requirement to disclose whether recipient is designated "high risk" by a federal grant-making agency outside of DOJ If the recipient is designated "high risk" by a federal grant-making agency outside of DOJ, currently or at any time during the course of the period of performance under this award, the recipient must disclose that fact and certain related information to OJP by email at [email protected]. For purposes of this disclosure, high risk includes any status under which a federal awarding agency provides additional oversight due to the recipient's past performance, or other programmatic or financial concerns with the recipient. The recipient's disclosure must include the following: 1. The federal awarding agency that currently designates the recipient high risk, 2. The date the recipient was designated high risk, 3. The high-risk point of contact at that federal awarding agency (name, phone number, and email address), and 4. The reasons for the high-risk status, as set out by the federal awarding agency. 23 Encouragement of policies to ban text messaging while driving Pursuant to Executive Order 13513, "Federal Leadership on Reducing Text Messaging While Driving," 74 Fed. Reg. 51225 (October 1, 2009), DOJ encourages recipients and subrecipients ("subgrantees") to adopt and enforce policies banning employees from text messaging while driving any vehicle during the course of performing work funded by this award, and to establish workplace safety policies and conduct education, awareness, and other outreach to decrease crashes caused by distracted drivers.
24 All subawards ("subgrants") must have specific federal authorization Page: 12 of 23
The recipient, and any subrecipient ("subgrantee") at any tier, must comply with all applicable requirements for authorization of any subaward. This condition applies to agreements that -- for purposes of federal grants administrative requirements -- OJP considers a "subaward" (and therefore does not consider a procurement "contract").
The details of the requirement for authorization of any subaward are posted on the OJP web site at https://ojp.gov/ funding/Explore/SubawardAuthorization.htm (Award condition: All subawards ("subgrants") must have specific federal authorization), and are incorporated by reference here. 25 Specific post-award approval required to use a noncompetitive approach in any procurement contract that would exceed $250,000
The recipient, and any subrecipient ("subgrantee") at any tier, must comply with all applicable requirements to obtain specific advance approval to use a noncompetitive approach in any procurement contract that would exceed the Simplified Acquisition Threshold (currently, $250,000). This condition applies to agreements that -- for purposes of federal grants administrative requirements -- OJP considers a procurement "contract" (and therefore does not consider a subaward).
The details of the requirement for advance approval to use a noncompetitive approach in a procurement contract under an OJP award are posted on the OJP web site at https://ojp.gov/funding/Explore/NoncompetitiveProcurement.htm (Award condition: Specific post-award approval required to use a noncompetitive approach in a procurement contract (if contract would exceed $250,000)), and are incorporated by reference here. 26 Requirements pertaining to prohibited conduct related to trafficking in persons (including reporting requirements and OJP authority to terminate award)
The recipient, and any subrecipient ("subgrantee") at any tier, must comply with all applicable requirements (including requirements to report allegations) pertaining to prohibited conduct related to the trafficking of persons, whether on the part of recipients, subrecipients ("subgrantees"), or individuals defined (for purposes of this condition) as "employees" of the recipient or of any subrecipient.
The details of the recipient's obligations related to prohibited conduct related to trafficking in persons are posted on the OJP web site at https://ojp.gov/funding/Explore/ProhibitedConduct-Trafficking.htm (Award condition: Prohibited conduct by recipients and subrecipients related to trafficking in persons (including reporting requirements and OJP authority to terminate award)), and are incorporated by reference here. 27 Requirement to report potentially duplicative funding If the recipient currently has other active awards of federal funds, or if the recipient receives any other award of federal funds during the period of performance for this award, the recipient promptly must determine whether funds from any of those other federal awards have been, are being, or are to be used (in whole or in part) for one or more of the identical cost items for which funds are provided under this award. If so, the recipient must promptly notify the DOJ awarding agency (OJP or OVW, as appropriate) in writing of the potential duplication, and, if so requested by the DOJ awarding agency, must seek a budget-modification or change-of-project-scope Grant Award Modification (GAM) to eliminate any inappropriate duplication of funding.
28 Reporting potential fraud, waste, and abuse, and similar misconduct The recipient, and any subrecipients ("subgrantees") at any tier, must promptly refer to the DOJ Office of the Inspector General (OIG) any credible evidence that a principal, employee, agent, subrecipient, contractor, subcontractor, or other person has, in connection with funds under this award-- (1) submitted a claim that violates the False Claims Act; or (2) committed a criminal or civil violation of laws pertaining to fraud, conflict of interest, bribery, gratuity, or similar Page: 13 of 23
misconduct.
Potential fraud, waste, abuse, or misconduct involving or relating to funds under this award should be reported to the OIG by--(1) online submission accessible via the OIG webpage at https://oig.justice.gov/hotline/contact-grants.htm (select "Submit Report Online"); (2) mail directed to: U.S. Department of Justice, Office of the Inspector General, Investigations Division, ATTN: Grantee Reporting, 950 Pennsylvania Ave., NW, Washington, DC 20530; and/or (3) by facsimile directed to the DOJ OIG Investigations Division (Attn: Grantee Reporting) at (202) 616-9881 (fax).
Additional information is available from the DOJ OIG website at https://oig.justice.gov/hotline. 29 Requirements related to System for Award Management and Universal Identifier Requirements The recipient must comply with applicable requirements regarding the System for Award Management (SAM), currently accessible at https://www.sam.gov/. This includes applicable requirements regarding registration with SAM, as well as maintaining the currency of information in SAM.
The recipient also must comply with applicable restrictions on subawards ("subgrants") to first-tier subrecipients (first- tier "subgrantees"), including restrictions on subawards to entities that do not acquire and provide (to the recipient) the unique entity identifier required for SAM registration.
The details of the recipient's obligations related to SAM and to unique entity identifiers are posted on the OJP web site at https://ojp.gov/funding/Explore/SAM.htm (Award condition: System for Award Management (SAM) and Universal Identifier Requirements), and are incorporated by reference here.
This condition does not apply to an award to an individual who received the award as a natural person (i.e., unrelated to any business or non-profit organization that he or she may own or operate in his or her name). 30 Restrictions on "lobbying"
In general, as a matter of federal law, federal funds awarded by OJP may not be used by the recipient, or any subrecipient ("subgrantee") at any tier, either directly or indirectly, to support or oppose the enactment, repeal, modification, or adoption of any law, regulation, or policy, at any level of government. See 18 U.S.C. 1913. (There may be exceptions if an applicable federal statute specifically authorizes certain activities that otherwise would be barred by law.)
Another federal law generally prohibits federal funds awarded by OJP from being used by the recipient, or any subrecipient at any tier, to pay any person to influence (or attempt to influence) a federal agency, a Member of Congress, or Congress (or an official or employee of any of them) with respect to the awarding of a federal grant or cooperative agreement, subgrant, contract, subcontract, or loan, or with respect to actions such as renewing, extending, or modifying any such award. See 31 U.S.C. 1352. Certain exceptions to this law apply, including an exception that applies to Indian tribes and tribal organizations.
Should any question arise as to whether a particular use of federal funds by a recipient (or subrecipient) would or might fall within the scope of these prohibitions, the recipient is to contact OJP for guidance, and may not proceed without the express prior written approval of OJP.
31 Justice Information Sharing
Information sharing projects funded under this award must comply with DOJ's Global Justice Information Sharing Initiative (Global) guidelines. The recipient (and any subrecipient at any tier) must conform to the Global Standards Package (GSP) and all constituent elements, where applicable, as described at: https:/ / it.ojp.gov/ gsp_grantcondition.
The recipient (and any subrecipient at any tier) must document planned approaches to information sharing and describe compliance with the GSP and appropriate privacy policy that protects shared information, or provide detailed justification for why an alternative approach is recommended.
Page: 14 of 23
32 Avoidance of duplication of networks
To avoid duplicating existing networks or IT systems in any initiatives funded by BJA for law enforcement information sharing systems which involve interstate connectivity between jurisdictions, such systems shall employ, to the extent possible, existing networks as the communication backbone to achieve interstate connectivity, unless the recipient can demonstrate to the satisfaction of BJA that this requirement would not be cost effective or would impair the functionality of an existing or proposed IT system.
33 Law enforcement task forces - required training
Within 120 days of award acceptance, each current member of a law enforcement task force funded with award funds who is a task force commander, agency executive, task force officer, or other task force member of equivalent rank, must complete required online (internet-based) task force training. Additionally, all future task force members must complete this training once during the period of performance for this award, or once every four years if multiple OJP awards include this requirement.
The required training is available free of charge online through the BJA-funded Center for Task Force Integrity and Leadership (www.ctfli.org). The training addresses task force effectiveness, as well as other key issues including privacy and civil liberties/rights, task force performance measurement, personnel selection, and task force oversight and accountability. If award funds are used to support a task force, the recipient must compile and maintain a task force personnel roster, along with course completion certificates.
Additional information regarding the training is available through BJA's web site and the Center for Task Force Integrity and Leadership (www.ctfli.org).
34 Required monitoring of subawards
The recipient must monitor subawards under this award in accordance with all applicable statutes, regulations, award conditions, and the DOJ Grants Financial Guide, and must include the applicable conditions of this award in any subaward. Among other things, the recipient is responsible for oversight of subrecipient spending and monitoring of specific outcomes and benefits attributable to use of award funds by subrecipients. The recipient agrees to submit, upon request, documentation of its policies and procedures for monitoring of subawards under this award. 35 Any written, visual, or audio publications funded in whole or in part under this award, with the exception of press releases, shall contain the following statements: "This project was supported by Grant No. <AWARD_NUMBER> awarded by the Bureau of Justice Assistance. The Bureau of Justice Assistance is a component of the Department of Justice's Office of Justice Programs, which also includes the Bureau of Justice Statistics, the National Institute of Justice, the Office of Juvenile Justice and Delinquency Prevention, the Office for Victims of Crime, and the SMART Office. Points of view or opinions in this document are those of the author and do not necessarily represent the official position or policies of the U.S. Department of Justice." The current edition of the DOJ Grants Financial Guide provides guidance on allowable printing and publication activities. 36 Any Web site that is funded in whole or in part under this award must include the following statement on the home page, on all major entry pages (i.e., pages (exclusive of documents) whose primary purpose is to navigate the user to interior content), and on any pages from which a visitor may access or use a Web-based service, including any pages that provide results or outputs from the service: "This Web site is funded in whole or in part through a grant from the Bureau of Justice Assistance, Office of Justice Programs, U.S. Department of Justice. Neither the U.S. Department of Justice nor any of its components operate, control, are responsible for, or necessarily endorse, this Web site (including, without limitation, its content, technical infrastructure, and policies, and any services or tools provided)." The full text of the foregoing statement must be clearly visible on the home page. On other pages, the statement may be included through a link, entitled "Notice of Federal Funding and Federal Disclaimer," to the full text of the statement.
Page: 15 of 23
37 Verification and updating of recipient contact information The recipient must verify its Grant Award Administrator, Financial Manager, and Authorized Representative contact information in JustGrants, including telephone number and e-mail address. If any information is incorrect or has changed, the award recipient’s Entity Administrator must make changes to contact information through DIAMD.
Instructions on how to update contact information in JustGrants can be found at https://justicegrants.usdoj.gov/training/ training-entity-management.
38 Compliance with National Environmental Policy Act and related statutes Upon request, the recipient (and any subrecipient at any tier) must assist BJA in complying with the National Environmental Policy Act (NEPA), the National Historic Preservation Act, and other related federal environmental impact analyses requirements in the use of these award funds, either directly by the recipient or by a subrecipient.
Accordingly, the recipient agrees to first determine if any of the following activities will be funded by the grant, prior to obligating funds for any of these purposes. If it is determined that any of the following activities will be funded by the award, the recipient agrees to contact BJA.
The recipient understands that this condition applies to new activities as set out below, whether or not they are being specifically funded with these award funds. That is, as long as the activity is being conducted by the recipient, a subrecipient, or any third party, and the activity needs to be undertaken in order to use these award funds, this condition must first be met. The activities covered by this condition are:
a. New construction;
b. Minor renovation or remodeling of a property located in an environmentally or historically sensitive area, including properties located within a 100-year flood plain, a wetland, or habitat for endangered species, or a property listed on or eligible for listing on the National Register of Historic Places; c. A renovation, lease, or any proposed use of a building or facility that will either (a) result in a change in its basic prior use or (b) significantly change its size;
d. Implementation of a new program involving the use of chemicals other than chemicals that are (a) purchased as an incidental component of a funded activity and (b) traditionally used, for example, in office, household, recreational, or education environments; and
e. Implementation of a program relating to clandestine methamphetamine laboratory operations, including the identification, seizure, or closure of clandestine methamphetamine laboratories.
The recipient understands and agrees that complying with NEPA may require the preparation of an Environmental Assessment and/or an Environmental Impact Statement, as directed by BJA. The recipient further understands and agrees to the requirements for implementation of a Mitigation Plan, as detailed at https://bja.gov/Funding/nepa.html, for programs relating to methamphetamine laboratory operations.
Application of This Condition to Recipient's Existing Programs or Activities: For any of the recipient's or its subrecipients' existing programs or activities that will be funded by these award funds, the recipient, upon specific request from BJA, agrees to cooperate with BJA in any preparation by BJA of a national or program environmental assessment of that funded program or activity.
39 Recipients utilizing award funds for forensic genealogy testing must adhere to the United States Department of Justice Interim Policy Forensic Genealogical DNA Analysis and Searching (https://www.justice.gov/olp/page/file/1204386/ download), and must collect and report the metrics identified in Section IX of that document to BJA. 40 Page: 16 of 23
Establishment of trust fund
If award funds are being drawn down in advance, the recipient (or a subrecipient, with respect to a subaward) is required to establish a trust fund account. Recipients (and subrecipients) must maintain advance payments of federal awards in interest-bearing accounts, unless regulatory exclusions apply (2 C.F.R. 200.305(b)(8)). The trust fund, including any interest, may not be used to pay debts or expenses incurred by other activities beyond the scope of the Edward Byrne Memorial Justice Assistance Grant Program (JAG). The recipient also agrees to obligate the award funds in the trust fund (including any interest earned) during the period of performance for the award and expend within 90 days thereafter. Any unobligated or unexpended funds, including interest earned, must be returned to OJP at the time of closeout.
41 All State and Local JAG recipients must submit quarterly Federal Financial Reports (SF-425). Additionally, State JAG and Local JAG Category Two ($25K or more) must submit semi-annual performance reports through JustGrants and Local JAG Category One (Less than $25K) must submit annual performance reports through JustGrants. Consistent with the Department's responsibilities under the Government Performance and Results Act (GPRA) and the GPRA Modernization Act of 2010, the recipient must provide data that measure the results of its work. The recipient must submit quarterly performance metrics reports through BJA's Performance Measurement Tool (PMT) website: https:// bjapmt.ojp.gov/. For more detailed information on reporting and other JAG requirements, refer to the JAG reporting requirements webpage (https://bjapmt.ojp.gov/help/jagdocs.html). Failure to submit required JAG reports by established deadlines may result in the freezing of grant funds and future High Risk designation. 42 Required data on law enforcement agency training
Any law enforcement agency receiving direct or sub-awarded funding from this JAG award must submit quarterly accountability metrics data related to training that officers have received on the use of force, racial and ethnic bias, de- escalation of conflict, and constructive engagement with the public. 43 Authorization to obligate (federal) award funds to reimburse certain project costs incurred on or after October 1, 2022 The recipient may obligate (federal) award funds only after the recipient makes a valid acceptance of the award. As of the first day of the period of performance for the award (October 1, 2022), however, the recipient may choose to incur project costs using non-federal funds, but any such project costs are incurred at the recipient's risk until, at a minimum- - (1) the recipient makes a valid acceptance of the award, and (2) all applicable withholding conditions are removed by OJP (via an Award Condition Modification (ACM)). (A withholding condition is a condition in the award document that precludes the recipient from obligating, expending, or drawing down all or a portion of the award funds until the condition is removed.)
Except to the extent (if any) that an award condition expressly precludes reimbursement of project costs incurred "at- risk," if and when the recipient makes a valid acceptance of this award and OJP removes each applicable withholding condition through an Award Condition Modification (ACM), the recipient is authorized to obligate (federal) award funds to reimburse itself for project costs incurred "at-risk" earlier during the period of performance (such as project costs incurred prior to award acceptance or prior to removal of an applicable withholding condition), provided that those project costs otherwise are allowable costs under the award. 44 If award funds are used for DNA testing of evidentiary materials, any resulting eligible DNA profiles must be uploaded to the Combined DNA Index System ("CODIS," the DNA database operated by the FBI) by a government DNA laboratory with access to CODIS. With the exception of Forensic Genetic Genealogy, no profiles generated under this award may be entered or uploaded into any non-governmental DNA database without prior express written approval from BJA. Award funds may not be used for the purchase of DNA equipment and supplies unless the resulting DNA profiles may be accepted for entry into CODIS. Booking agencies should work with their state CODIS agency to ensure all requirements are met for participation in Rapid DNA (see National Rapid DNA Booking Operational Procedures Manual).
Page: 17 of 23
45 Submission of eligible records relevant to the National Instant Background Check System Consonant with federal statutes that pertain to firearms and background checks -- including 18 U.S.C. 922 and 34 U.S.C. ch. 409 -- if the recipient (or any subrecipient at any tier) uses this award to fund (in whole or in part) a specific project or program (such as a law enforcement, prosecution, or court program) that results in any court dispositions, information, or other records that are "eligible records" (under federal or State law) relevant to the National Instant Background Check System (NICS), or that has as one of its purposes the establishment or improvement of records systems that contain any court dispositions, information, or other records that are "eligible records" (under federal or State law) relevant to the NICS, the recipient (or subrecipient, if applicable) must ensure that all such court dispositions, information, or other records that are "eligible records" (under federal or State law) relevant to the NICS are promptly made available to the NICS or to the "State" repository/database that is electronically available to (and accessed by) the NICS, and -- when appropriate -- promptly must update, correct, modify, or remove such NICS- relevant "eligible records".
In the event of minor and transitory non-compliance, the recipient may submit evidence to demonstrate diligent monitoring of compliance with this condition (including subrecipient compliance). DOJ will give great weight to any such evidence in any express written determination regarding this condition. 46 Prohibition on use of award funds for match under BVP program JAG funds may not be used as the 50% match for purposes of the DOJ Bulletproof Vest Partnership (BVP) program. 47 Certification of body armor "mandatory wear" policies, and compliance with NIJ standards If recipient uses funds under this award to purchase body armor, the recipient must submit a signed certification that each law enforcement agency receiving body armor purchased with funds from this award has a written "mandatory wear" policy in effect. The recipient must keep signed certifications on file for any subrecipients planning to utilize funds from this award for ballistic-resistant and stab-resistant body armor purchases. This policy must be in place for at least all uniformed officers before any funds from this award may be used by an agency for body armor. There are no requirements regarding the nature of the policy other than it be a mandatory wear policy for all uniformed officers while on duty.
Ballistic-resistant and stab-resistant body armor purchased with award funds may be purchased at any threat level, make or model, from any distributor or manufacturer, as long as the body armor has been tested and found to comply with applicable National Institute of Justice ballistic or stab standards, and is listed on the NIJ Compliant Body Armor Model List. In addition, ballistic-resistant and stab-resistant body armor purchased must be made in the United States and must be uniquely fitted, as set forth in 34 U.S.C. 10202(c)(1)(A). The latest NIJ standard information and the NIJ Compliant Body Armor List may be found by following the links located on the NIJ Body Armor page: https://nij.ojp.gov/ topics/equipment-and-technology/body-armor
48 Extreme risk protection programs funded by JAG must include, at a minimum: pre-deprivation and post-deprivation due process rights that prevent any violation or infringement of the Constitution of the United States, including but not limited to the Bill of Rights, and the substantive or procedural due process rights guaranteed under the Fifth and Fourteenth Amendments to the Constitution of the United States, as applied to the States, and as interpreted by State courts and United States courts (including the Supreme Court of the United States). Such programs must include, at the appropriate phase to prevent any violation of constitutional rights, at minimum, notice, the right to an in-person hearing, an unbiased adjudicator, the right to know opposing evidence, the right to present evidence, and the right to confront adverse witnesses; the right to be represented by counsel at no expense to the government; pre-deprivation and post-deprivation heightened evidentiary standards and proof which mean not less than the protections afforded to a similarly situated litigant in Federal court or promulgated by the State's evidentiary body, and sufficient to ensure the full protections of the Constitution of the United States, including but not limited to the Bill of Rights, and the substantive and procedural due process rights guaranteed under the Fifth and Fourteenth Amendments to the Constitution of the United States, as applied to the States, and as interpreted by State courts and United States courts Page: 18 of 23
(including the Supreme Court of the United States). The heightened evidentiary standards and proof under such programs must, at all appropriate phases to prevent any violation of any constitutional right, at minimum, prevent reliance upon evidence that is unsworn or unaffirmed, irrelevant, based on inadmissible hearsay, unreliable, vague, speculative, and lacking a foundation; and penalties for abuse of the program. 49 Expenditures prohibited without waiver
No funds under this award may be expended on the purchase of items prohibited by the JAG program statute, unless, as set forth at 34 U.S.C. 10152, the BJA Director certifies that extraordinary and exigent circumstances exist, making such expenditures essential to the maintenance of public safety and good order. 50 FFATA reporting: Subawards and executive compensation The recipient must comply with applicable requirements to report first-tier subawards ("subgrants") of $30,000 or more and, in certain circumstances, to report the names and total compensation of the five most highly compensated executives of the recipient and first-tier subrecipients (first-tier "subgrantees") of award funds. The details of recipient obligations, which derive from the Federal Funding Accountability and Transparency Act of 2006 (FFATA), are posted on the OJP web site at https://ojp.gov/funding/Explore/FFATA.htm (Award condition: Reporting Subawards and Executive Compensation), and are incorporated by reference here.
This condition, including its reporting requirement, does not apply to-- (1) an award of less than $30,000, or (2) an award made to an individual who received the award as a natural person (i.e., unrelated to any business or non-profit organization that he or she may own or operate in his or her name). 51 Exceptions regarding Prohibited and Controlled Equipment under OJP awards Notwithstanding any provision to the contrary in the other terms and conditions of this award, including in the condition regarding "Compliance with restrictions on the use of federal funds--prohibited and controlled equipment under OJP awards," the requirements for the “Transfer/Sale of Award-Funded Controlled Equipment to Other LEAs” and the requirements for the “Transfer/Sale of Award-Funded Controlled Equipment to NON-LEAs” do not apply to this award. 52 The recipient agrees that no funds under this grant award (including via subcontract or subaward, at any tier) may be used for unmanned aircraft systems (UAS), which includes unmanned aircraft vehicles (UAV), or for any accompanying accessories to support UAS.
53 Initial period of performance; requests for extension.
The recipient understands that for award amounts of less than $25,000 under JAG (Category 1), the initial period of performance of the award is two years. The recipient further understands that any requests for an extension of the period of performance for an award of less than $25,000 will be approved automatically for up to a total of two additional years, pursuant to 34 U.S.C. 10152(f) and in accordance with the program solicitation associated with this award.
Any request for an extension of the period of performance beyond a four-year award period will require approval, and the approval (if any) will be at the discretion of the Director of BJA. 54 Applicants must ensure that Limited English Proficiency persons have meaningful access to the services under this program(s). National origin discrimination includes discrimination on the basis of limited English proficiency (LEP). To ensure compliance with Title VI and the Safe Streets Act, recipients are required to take reasonable steps to ensure Page: 19 of 23
that LEP persons have meaningful access to their programs. Meaningful access may entail providing language assistance services, including oral and written translation when necessary. The U.S. Department of Justice has issued guidance for grantees to help them comply with Title VI requirements. The guidance document can be accessed on the Internet at www.lep.gov.
55 Cooperating with OJP Monitoring
The recipient agrees to cooperate with OJP monitoring of this award pursuant to OJP's guidelines, protocols, and procedures, and to cooperate with OJP (including the grant manager for this award and the Office of Chief Financial Officer (OCFO)) requests related to such monitoring, including requests related to desk reviews and/or site visits. The recipient agrees to provide to OJP all documentation necessary for OJP to complete its monitoring tasks, including documentation related to any subawards made under this award. Further, the recipient agrees to abide by reasonable deadlines set by OJP for providing the requested documents. Failure to cooperate with OJP's monitoring activities may result in actions that affect the recipient's DOJ awards, including, but not limited to: withholdings and/or other restrictions on the recipient's access to award funds; referral to the DOJ OIG for audit review; designation of the recipient as a DOJ High Risk grantee; or termination of an award(s). 56 Use of program income
Program income (as defined in the Part 200 Uniform Requirements) must be used in accordance with the provisions of the Part 200 Uniform Requirements. Program income earnings and expenditures both must be reported on the quarterly Federal Financial Report, SF 425.
57 Compliance with 28 C.F.R. Part 23
With respect to any information technology system funded or supported by funds under this award, the recipient (and any subrecipient at any tier) must comply with 28 C.F.R. Part 23, Criminal Intelligence Systems Operating Policies, if OJP determines this regulation to be applicable. Should OJP determine 28 C.F.R. Part 23 to be applicable, OJP may, at its discretion, perform audits of the system, as per the regulation. Should any violation of 28 C.F.R. Part 23 occur, the recipient may be fined as per 34 U.S.C. 10231(c)-(d). The recipient may not satisfy such a fine with federal funds. 58 Protection of human research subjects
The recipient (and any subrecipient at any tier) must comply with the requirements of 28 C.F.R. Part 46 and all OJP policies and procedures regarding the protection of human research subjects, including obtainment of Institutional Review Board approval, if appropriate, and subject informed consent. 59 Confidentiality of data
The recipient (and any subrecipient at any tier) must comply with all confidentiality requirements of 34 U.S.C. 10231 and 28 C.F.R. Part 22 that are applicable to collection, use, and revelation of data or information. The recipient further agrees, as a condition of award approval, to submit a Privacy Certificate that is in accord with requirements of 28 C.F.R. Part 22 and, in particular, 28 C.F.R. 22.23.
60 The recipient agrees to cooperate with any assessments, national evaluation efforts, or information or data collection requests, including, but not limited to, the provision of any information required for the assessment or evaluation of any activities within this project.
61 Page: 20 of 23
The recipient understands that, in accepting this award, the Authorized Representative declares and certifies, among other things, that he or she possesses the requisite legal authority to accept the award on behalf of the recipient entity and, in so doing, accepts (or adopts) all material requirements that relate to conduct throughout the period of performance under this award. The recipient further understands, and agrees, that it will not assign anyone to the role of Authorized Representative during the period of performance under the award without first ensuring that the individual has the requisite legal authority.
62 In accepting this award, the recipient agrees that grant funds cannot be used for Facial Recognition Technology (FRT) unless the recipient has policies and procedures in place to ensure that the FRT will be utilized in an appropriate and responsible manner that promotes public safety, and protects privacy, civil rights, and civil liberties and complies with all applicable provisions of the U.S. Constitution, including the Fourth Amendment’s protection against unreasonable searches and seizures and the First Amendment’s freedom of association and speech, as well as other laws and regulations. Recipients utilizing funds for FRT must make such policies and procedures available to DOJ upon request. 63 Recipient integrity and performance matters: Requirement to report information on certain civil, criminal, and administrative proceedings to SAM and FAPIIS
The recipient must comply with any and all applicable requirements regarding reporting of information on civil, criminal, and administrative proceedings connected with (or connected to the performance of) either this OJP award or any other grant, cooperative agreement, or procurement contract from the federal government. Under certain circumstances, recipients of OJP awards are required to report information about such proceedings, through the federal System for Award Management (known as "SAM"), to the designated federal integrity and performance system (currently, "FAPIIS").
The details of recipient obligations regarding the required reporting (and updating) of information on certain civil, criminal, and administrative proceedings to the federal designated integrity and performance system (currently, "FAPIIS") within SAM are posted on the OJP web site at https://ojp.gov/funding/FAPIIS.htm (Award condition:
Recipient Integrity and Performance Matters, including Recipient Reporting to FAPIIS), and are incorporated by reference here.
64 Withholding of funds for Memorandum of Understanding The recipient may not expend or draw down any award funds until OJP has reviewed and approved the Memorandum of Understanding (MOU), and an Award Condition Modification has been issued to remove this condition. 65 Withholding of Funds for Body Armor Certification
The recipient may not expend or draw down any award funds until the recipient submits, and OJP has reviewed, the required certification regarding body armor, and an Award Condition Modification has been issued to remove this condition.
[ ]
I have read and understand the information presented in this section of the Federal Award Instrument.
Award Acceptance
Declaration and Certification to the U.S. Department of Justice as to Acceptance By checking the declaration and certification box below, I-- Page: 21 of 23
A. Declare to the U.S. Department of Justice (DOJ), under penalty of perjury, that I have authority to make this declaration and certification on behalf of the applicant.
B. Certify to DOJ, under penalty of perjury, on behalf of myself and the applicant, to the best of my knowledge and belief, that the following are true as of the date of this award acceptance: (1) I have conducted or there was conducted (including by applicant’s legal counsel as appropriate and made available to me) a diligent review of all terms and conditions of, and all supporting materials submitted in connection with, this award, including any assurances and certifications (including anything submitted in connection therewith by a person on behalf of the applicant before, after, or at the time of the application submission and any materials that accompany this acceptance and certification); and (2) I have the legal authority to accept this award on behalf of the applicant.
C. Accept this award on behalf of the applicant.
D. Declare the following to DOJ, under penalty of perjury, on behalf of myself and the applicant: (1) I understand that, in taking (or not taking) any action pursuant to this declaration and certification, DOJ will rely upon this declaration and certification as a material representation; and (2) I understand that any materially false, fictitious, or fraudulent information or statement in this declaration and certification (or concealment or omission of a material fact as to either) may be the subject of criminal prosecution (including under 18 U.S.C. §§ 1001 and/or 1621, and/or 34 U.S.C. §§ 10271-10273), and also may subject me and the applicant to civil penalties and administrative remedies under the federal False Claims Act (including under 31 U.S.C. §§ 3729-3730 and/or §§ 3801-3812) or otherwise.
Agency Approval
Title of Approving Official
Deputy Assistant Attorney General
Name of Approving Official
Maureen Henneberg
Signed Date And Time
9/20/23 8:36 PM
Authorized Representative
Entity Acceptance
Title of Authorized Entity Official
Administrative Manager II
Signed Date And Time
Page: 22 of 23
Page: 23 of 23
City of Buena Park
City Council Regular Meeting Agenda Report
FINAL PAYMENT FOR THE ORANGETHORPE AVENUE REHABILITATION PROJECT Meeting
Tuesday, December 12, 2023, 5:00 PM
Agenda Group
CONSENT CALENDAR Item: 4E
Presented By
Mina Mikhael, P.E., Director of Public Works/City Engineer Prepared By
Mina Mikhael, Director of Public Works/City Engineer
Approved By
Aaron France, City Manager
RECOMMENDED ACTION
1) Accept project as complete and approve final payment to Hardy and Harper, Inc. in the amount of $96,436.78; and 2) Direct the Public Works Department to file a Notice of Completion.
PREVIOUS CITY COUNCIL ACTION
On July 11, 2023, the City Council approved a contract with Hardy and Harper, Inc. in the amount of $1,756,000 plus $175,000 in contingency funds and $100,000 in construction engineering funds for a total project cost of $2,031,000.
DISCUSSION
The Orangethorpe Avenue Rehabilitation Project has been completed between Western Ave. and Stanton Ave. This project consisted of asphalt grind and overlay, improvements to curb and gutter, cross gutters, sidewalks, curb ramps, driveway approaches, catch basins, and new signing and striping. Additional improvements were completed along Beach Blvd near the Orangethorpe Ave. intersection to repair asphalt rutting and improve drainage. Similarly, repairs were made to a portion of deteriorating curb and gutter and asphalt near the intersection of Orangethorpe Avenue and Knott Avenue.
Cost savings during this project allowed staff to complete additional repairs through change orders. Change Order No. 1 was approved to install a much needed concrete bus pad in front of City Hall. Change Order No. 2 was approved to raise all Orange County Sanitation District owned manholes to grade, which will be reimbursed by Orange County Sanitation District.
A third change order was approved to repair the City-owned parking lot at the intersection of Auto Center Dr. and Commonwealth Ave. The parking lot was resurfaced with new asphalt and ADA improvements were incorporated to bring it up to current standards.
The contractor has submitted a bill for work completed as of November 17, 2023. All items, quantities, and prices have been checked and found to be in accordance with the contract documents. The final payment is in the amount of $96,436.78. The final contract cost for this project is $1,780,636.62 or 16.8% below the approved contract budget of $2,140,484.40. The total retention is in the amount of $89,031.83, and will be released following the expiration of the 35- day lien period. An analysis of expenditures is listed as Appendix “A”.
Attachments
Att1of4 Memo to Finance.pdf
Att2of4 Final Report.pdf
Att3of4 Appendix A - Orangethorpe.pdf
Att4of4 Contractor Invoice.pdf
BUDGET IMPACT
The final cost of the project is $1,780,636.62. This project was included in the FY 2022-23 Capital Improvement Program budget, and was funded by RMRA, Measure M2, and Gas Tax Funds (Account No. 24-9806-590181).
MEMORANDUM
Department of Public Works
DATE: December 12, 2023
TO: Adrian Garcia, Fiscal Services Manager
FROM: Mina Mikhael, P.E., Director of Public Works/City Engineer
SUBJECT: ORANGETHORPE AVENUE REHABILITATION PROJECT
Amount: $96,436.78 Account No.: 24-9806-590181
Purchase Order: 240110
Contractor: HARDY & HARPER, INC.
32 RANCHO CIRCLE
LAKE FOREST, CA 92630
Payment Processed on Warrant Register: 12/20/2023
RECOMMENDATION
It is recommended that the Finance Officer issue a warrant for the final payment on this contract.
CERTIFICATION
This is to certify that the subject project has been completed satisfactorily. The contractor has submitted the final bill for the completed work and is entitled to a total to date payment in the amount of $101,512.40 less 5% retained (attached). Bid items, quantities and prices have been checked through this department and are found to be accurate in accordance with the contract documents. A copy of the final report is attached for your file. A “Notice of Completion” will be filed by Public Works upon approval of the City Council, and following the expiration of the 35- day lien period; the 5% retention, will be released to the contractor. Final Payment represents 100% completion to date.
CC: Gloria Hernandez, Account Clerk
Memorandum
Department of Public Works
Capital Improvement Project Final Report
PROJECT CONTRACTOR
Orangethorpe Avenue Rehabilitation Project Hardy & Harper, Inc.
CONTRACT DATES CONTRACT COSTS
Advertisement: 06/13/2023 Original Project Cost: $1,756,000.00 Contract Awarded: 07/11/2023 Contingency: $175,000.00 Notice to Proceed: 09/05/2023 Total Budget: $1,931,000.00 Work Completed:
Total Days Used:
11/17/2023
52 Appr. Change Orders:
Revised Budget:
$209,484.40
$2,140,484.40
Total Project Cost: $1,780,636.62
CONTRACTOR RATING
The contractor completed all phases of work in a satisfactory manner.
This project consisted of grind and overlay of 2.5 inches of asphalt concrete and various concrete repairs throughout the project limits.
On June 13, 2023, request for bids was advertised on Planwell. On June 29, 2023, bids were received. Hardy & Harper, Inc. was the lowest responsible bidder with the bid amount of $1,756,000.00. On July 11, 2023, a construction contract was awarded to Hardy & Harper, Inc.
Following contract execution, construction began on September 5, 2023. During construction, three change orders were approved in order to address poor pavement conditions. Change orders #1, #2 and #3 in the amount of $209,484.40 increased the contract amount to $2,140,484.40. The contractor accomplished all work, including punch list items by November 17, 2023.
CONTRACT CHANGE ORDERS:
CCO#1: This change order is to construct a concrete bus pad in front of City Hall.
CCO#2: This change order is to raise to grade manholes owned by OCSD.
CCO#3: This change order is to reconstruct the city-owned parking lot at the intersection of Auto Center Dr. and Commonwealth Avenue.
Page: 2 of 2
Date: December 12, 2023
Subject: Capital Improvement Project Final Report
QUANTITY ADJUSTMENT:
Quantity Increases: Various items of work: $4,378.00
Quantity Decreases: Various items of work: $197,085.78
CONTRACT COSTS
The final quantities resulted in a total contract cost of $1,780,636.62. This represents $359,847.78 or 16.8% below the approved contract budget of $2,140,484.40. An analysis of project costs is included as Appendix “A”.
CONCLUSION
It is hereby recommended that the City Council accept the project as complete and turn the public facility over to City forces for maintenance and operation.
Prepared by: Mina Mikhael, P.E., Director of Public Works/City Engineer Approved by: Mina Mikhael, P.E., Director of Public Works/City Engineer
CONTRACT
Original Contract Amount $1,756,000.00
Council Approved Contingency Funds $175,000.00
Approved Contract Amount $1,931,000.00
CONTRACT ADJUSTMENTS
Contract Change Orders
$80,672.00
$31,500.00
$97,312.40
Quantity Adjustments
Increases $4,378.00
Decreases -$197,085.78
Total -$192,707.78
Total Contract Adjustments $16,776.62
CONTRACT EXPENDITURES
Value of Work Done Previously $1,679,124.22
Value of Work Done This Period $101,512.40
Subtotal $1,780,636.62
Less Total Retention -$89,031.83
Less Previous Payments -$1,595,168.01
Total amount Due This Payment $96,436.78
$89,031.83
PROJECT SUMMARY
Original Contract Amount $1,756,000.00
$175,000.00
$209,484.40
Revised Contract $2,140,484.40
Cost of Work Completed to Date $1,780,636.62
Amount under the Approved Contract Amount $359,847.78
Percentage under the Approved Contract Amount 16.81%
Approved Change Orders
Council Approved Contingency Funds
CCO#3 - Reconstruct city-owned parking lot at Auto Center Dr. and Commonwealth
APPENDIX "A"
CCO#1 - Construct concrete bus pad in front of City Hall CCO#2 - Adjust OCSD manholes to grade
Total Retention
ORANGETHORPE AVENUE REHABILITATION PROJECT
DEPARTMENT OF PUBLIC WORKS
Contract Invoice
49944
PROJECT
Billed To:
Invoice Total:
Retention:
Amount Paid:
Amount Due
Due Date: Terms: Contract / PO# 12/17/2023
5,075.62
0.00 96,436.78
30DY
11/17/2023
INVOICE
DATE
JOB # 23719
101,512.40
Description Amount
PAY APP #3
SEE ATTACHED SCHEDULE OF VALUES 101,512.40
Notes:
ORANGETHORPE AVENUE REHABILITATION PR
VL: ORANGETHORPE AVE, WESTERN AVE, STA
BUENA PARK CA 90620
CITY OF BUENA PARK
6650 BEACH BLVD.
P .O. BOX 5009
BUENA PARK CA 90622-5009
Public Contract Code 20104.5. Prompt Payment By Local Governments To Contractors Upon receipt of this payment request, each local agency shall act in accordance with the following; Any payment request determined not to be a proper payment request suitable for payment shall be returned to the contractor no later than seven days, after receipt. A request returned shall be accompanied by a document setting forth in writing the reasons why the payment request is not proper.
Any local agency which fails to make any progress payment within 30 days after receipt of an undisputed payment request from a contractor on a construction contract shall pay interest to the contractor equivalent to the legal rate set forth in subdivision(a) of Section 685.010 of the Code of Civil Procedure and the interest shall accrue at 10%(0.833%/month). Within 60 days after the date of completion of the work improvement, the retention witheld by the public entity shall be released. In the event that retention payments are not made within the time periods required by this section, the public entity shall be subject to a charge of 2% per month on the improperly witheld amount.
Hardy and Harper, Inc. ENGINEERING CONTRACTORS
32 Rancho Circle Lake Forest, CA 92630 STATE LICENSE #215952 Office (714) 444-1851 Fax (714) 444-2801
CITY OF BUENA PARK DATE 17-Nov-23
ORANGETHORPE AVENUE REHABILITATION PROJECT PROGRESS 3
INVOICE NO.:
JOB LOCATION BUENA PARK
H&H JOB # 23719
ITEM
NUMBER DESCRIPTION CONTRACT
QUANTITY
UNIT
MEASURE
QUANTITY OR
% PREVIOUS
QUANTITY OR
% THIS
ESTIMATE
UNIT PRICE AMOUNT
THIS ESTIMATE
TOTAL
QUANTITY
OR % TO DATE
TOTAL AMOUNT
TO DATE
Schedule A - Orangethorpe Ave from
Western Ave to Stanton Ave
1 TRAFFIC CONTROL 1 LS 1.00 157,829.00$ -$ 1.00 157,829.00$ 2 SWPPP 1 LS 1.00 6,825.00$ -$ 1.00 6,825.00$ 3 COLD MILL 2.5" 324,700 SF 320648.00 0.48$ -$ 320,648.00 153,911.04$ 4 2.5" AC FINISH COURSE 4,910 TON 4727.02 129.00$ -$ 4,727.02 609,785.58$ 5 COLD MILL & OVERLAY AND CONSTRUCT 9" THICK AC
PAVEMENT 10,240 SF 8882.00 15.00$ -$ 8,882.00 133,230.00$ 6 REMOVE EXISTING & CONSTRUCT CURB RAMP 14 EACH 11.00 11,380.00$ -$ 11.00 125,180.00$ 7 REMOVE EXISTING & CONSTRUCT 4" THICK PCC
SIDEWALK 1,030 SF 935.00 17.00$ -$ 935.00 15,895.00$ 8 REMOVE EXISTING & CONSTRUCT DRIVEWAY
APPROACH 690 SF 330.00 24.00$ -$ 330.00 7,920.00$ 9 SURFACE APPLIED TRUNCATED DOMES 3 EACH 3.00 1,270.00$ -$ 3.00 3,810.00$ 10 PAINT TRUNCATED DOME SURFACE BLUE 1 EACH 1.00 735.00$ -$ 1.00 735.00$ 11 REMOVE EXISTING & CONSTRUCT CURB & GUTTER 880 LF 458.00 102.00$ -$ 458.00 46,716.00$ 12 REMOVE EXISTING & CONSTRUCT CROSS GUTTER 320 SF 300.00 32.00$ -$ 300.00 9,600.00$ 13 REMOVE EXISTING & CONSTRUCT PARKWAY DRAIN 5 EACH 5.00 4,725.00$ -$ 5.00 23,625.00$ 14 ADJUST WATER VALVE 41 EACH 35.00 1,310.00$ -$ 35.00 45,850.00$ 15 ADJUST MANHOLE 22 EACH 17.00 1,310.00$ -$ 17.00 22,270.00$ 16 ADJUST STORM DRAIN MANHOLE 4 EACH 0.00 1,310.00$ -$ 0.00 -$ 17 ADJUST BELL/GTE MANHOLE 2 EACH 2.00 1,310.00$ -$ 2.00 2,620.00$ 18 ADJUST MONITORING WELL 3 EACH 3.00 1,310.00$ -$ 3.00 3,930.00$ 19 ADJUST PULLBOX 2 EACH 2.00 1,310.00$ -$ 2.00 2,620.00$ 20 ADJUST WATER METER 1 EACH 1.00 1,310.00$ -$ 1.00 1,310.00$ 21 ADJUST SEWER CLEANOUT 1 EACH 7.00 1,310.00$ -$ 7.00 9,170.00$ 22 SIGNING & STRIPING 1 LS 1.00 49,400.00$ -$ 1.00 49,400.00$ 23 INSTALL LOOP DETECTORS 97 EACH 97.00 325.00$ -$ 97.00 31,525.00$ 24 RESET BENCHMARK/SURVEY MONUMENT 7 EACH 0.00 5.00 840.00$ 4,200.00$ 5.00 4,200.00$ 25 CALTRANS PERMIT 1 LS 1.00 1,575.00$ -$ 1.00 1,575.00$ Schedule B - Orangethorpe Ave at Knott
Ave
26 SWPPP 1 LS 1.00 1,170.00$ -$ 1.00 1,170.00$ 27 COLD MILL 2.5" 4,900 SF 4680.00 1.60$ -$ 4,680.00 7,488.00$ 28 2.5" AC FINISH COURSE 80 TON 76.71 260.00$ -$ 76.71 19,944.60$ 29 COLD MILL & OVERLAY AND CONSTRUCT 9" THICK AC
PAVEMENT 1,510 SF 286.00 20.00$ -$ 286.00 5,720.00$ 30 REMOVE EXISTING & CONSTRUCT CURB RAMP 2 EACH 2.00 11,400.00$ -$ 2.00 22,800.00$ 31 REMOVE EXISTING & CONSTRUCT 4" THICK PCC
SIDEWALK 90 SF 80.00 29.00$ -$ 80.00 2,320.00$ 32 REMOVE EXISTING & CONSTRUCT DRIVEWAY
APPROACH 230 SF 225.00 29.00$ -$ 225.00 6,525.00$ 33 REMOVE EXISTING & CONSTRUCT CURB & GUTTER 190 LF 180.00 107.00$ -$ 180.00 19,260.00$ 34 REMOVE EXISTING & CONSTRUCT LONGITUDINAL OR
PORTION 50 SF 40.00 39.00$ -$ 40.00 1,560.00$ 35 REMOVE EXISTING & CONSTRUCT CURB DRAIN 3 EACH 0.00 4,725.00$ -$ 0.00 -$ 36 REMOVE & INSTALL BOLLARD 1 EACH 1.00 1,260.00$ -$ 1.00 1,260.00$ 37 ADJUST INLET GRATE 1 EACH 1.00 1,310.00$ -$ 1.00 1,310.00$ 38 ADJUST PCC PAD 1 EACH 1.00 3,675.00$ -$ 1.00 3,675.00$ 39 ADJUST MANHOLE 1 EACH 1.00 1,310.00$ -$ 1.00 1,310.00$ 40 REPLACE EXISTING STRIPING & CURB MARKING 1 LS 1.00 2,900.00$ -$ 1.00 2,900.00$ Change Orders
REMOBILIZATION 1 LS 1.00 4,500.00$ -$ 1.00 4,500.00$ TRAFFIC CONTROL 1 LS 1.00 4,000.00$ -$ 1.00 4,000.00$ R&R CURB & GUTTER 140 LF 145.00 128.00$ -$ 145.00 18,560.00$ REMOVE EXISTING AC & CONSTRUCT 12" PCC BUS
PAD 1,200 ESF 1200.00 33.50$ -$ 1,200.00 40,200.00$ CONSTRUCT AC PATCH TO MATCH EXISTING GRADE 714 SF 1070.00 10.50$ -$ 1,070.00 11,235.00$ ADJUST WATER VALVE 2 EACH 2.00 1,310.00$ -$ 2.00 2,620.00$ ADJUST MANHOLE 1 EACH 1.00 1,310.00$ -$ 1.00 1,310.00$ REPLACE STRIPING IN KIND 1 LS 1.00 2,625.00$ -$ 1.00 2,625.00$ 1 2
ADJUST OCSD MANHOLES TO GRADE PER OCSD
STANDARD DWG. S-050A, S-055, S-055A 9 EACH 9.00 3,500.00$ -$ 9.00 31,500.00$ 3 PARKING LOT IMPROVEMENTS AT AUTO CENTER
DRIVE AND COMMONWEALTH AVENUE PER DRAWINGS
PROVIDED 10/24/23 (ATTACHED) 1 LS 1.00 97,312.40$ 97,312.40$ 1.00 97,312.40$ SUB-TOTALPG1 101,512.40$ 1,780,636.62$
LESS RETENTION 5,075.62$ 89,031.83$
LESS BILLING(S) -$
TOTAL AMOUNT DUE 96,436.78$ 1,691,604.79$
Public Contract Code § 20104.50. Prompt Payment By Local Governments To Contractors.
Upon receipt of this payment request, each local agency shall act in accordance with the following:
Any payment request determined not to be a proper payment request suitable for payment shall be returned to the contractor no later than seven days, after receipt. A request returned shall be accompanied by a document setting forth in writing the reasons why the payment request is not proper.
Any local agency which fails to make any progress payment within 30 days after receipt of an undisputed and payment request from a contractor on a construction contract shall pay interest to the contractor equivalent to the legal rate set forth in subdivision (a) of Section 685.010 of the Code of Civil Procedure and interest shall accrue at 10% (0.833%/month).
Within 60 days after the date of completion of the work of improvement, the retention withheld by the public entity shall be released. In the event that retention payments are not made within the time periods required by this section, the public entity shall be subject to a charge of 2 percent per month on the improperly withheld amount.
City of Buena Park
City Council Regular Meeting Agenda Report
FINAL PAYMENT FOR THE 2021-2022 AND 2022-2023 SEWER MAIN LINING PROJECT Meeting
Tuesday, December 12, 2023, 5:00 PM
Agenda Group
CONSENT CALENDAR Item: 4F
Presented By
Mina Mikhael, P.E., Director of Public Works/City Engineer Prepared By
Mina Mikhael, Director of Public Works/City Engineer
Approved By
Aaron France, City Manager
RECOMMENDED ACTION
1) Accept project as complete and approve final payment to Tunnelworks Services, Inc. in the amount of $13,617.06; and 2) Direct the Public Works Department to file a Notice of Completion.
PREVIOUS CITY COUNCIL ACTION
On February 14, 2023, the City Council approved a contract with Tunnelworks Services, Inc. in the amount of $790,897.50 plus $80,000 in contingency funds for a total project cost of $870,897.50.
DISCUSSION
The 2021-2022 and 2022-2023 Sewer Main Lining Project has been completed. This project consisted of rehabilitating old sewer mains with UV-cured glass reinforced plastic liners. These non-invasive improvements are much more cost effective compared to open trench pipe replacement and extend the life expectancy of sewer pipes significantly.
The contractor has submitted a bill for work completed as of November 20, 2023. All items, quantities, and prices have been checked and found to be in accordance with the contract documents. The final payment is in the amount of $13,617.06. The final contract cost for this project is $815,227.23. This figure is $55,670.27 or 6.4% below the approved contract budget of $870,897.50. The total retention is in the amount of $40,761.37, and will be released following the expiration of the 35-day lien period. An analysis of expenditures is listed as Appendix “A”.
BUDGET IMPACT
The final cost of the project is $815,227.23. This project was included in the FY 2022-23 Capital Improvement Program budget, and was funded by the Water Enterprise Fund (Account No. 52-9806-490015).
Attachments
Att1of4 Memo to Finance.pdf
Att2of4 Final Report.pdf
Att3of4 Appendix A - Sewer Main Lining.pdf
Att4of4 - Contractor Invoice.pdf
MEMORANDUM
Department of Public Works
DATE: December 12, 2023
TO: Adrian Garcia, Fiscal Services Manager
FROM: Mina Mikhael, P.E., Director of Public Works/City Engineer
SUBJECT: 2021-2022 AND 2022-2023 SEWER MAIN LINING PROJECT
Amount: $13,617.06 Account No.: 52-9806-490015
Purchase Order: 230384
Contractor: TUNNELWORKS SERVICES, INC.
13502 WHITTIER BLVD., STE. 165
WHITTIER, CA 90605
Payment Processed on Warrant Register: 12/20/2023
RECOMMENDATION
It is recommended that the Finance Officer issue a warrant for the final payment on this contract.
CERTIFICATION
This is to certify that the subject project has been completed satisfactorily. The contractor has submitted the final bill for the completed work and is entitled to a total to date payment in the amount of $14,333.75 less 5% retained (attached). Bid items, quantities and prices have been checked through this department and are found to be accurate in accordance with the contract documents. A copy of the final report is attached for your file. A “Notice of Completion” will be filed by Public Works upon approval of the City Council, and following the expiration of the 35- day lien period; the 5% retention, will be released to the contractor. Final Payment represents 100% completion to date.
CC: Gloria Hernandez, Account Clerk
Memorandum
Department of Public Works
Capital Improvement Project Final Report
PROJECT CONTRACTOR
2021-2022 AND 2022-2023 Sewer Main Lining
Project
Tunnelworks Services, Inc.
CONTRACT DATES CONTRACT COSTS
Advertisement: 12/19/2022 Original Project Cost: $790,897.50 Contract Awarded: 02/14/2023 Contingency: $80,000.00 Notice to Proceed: 05/01/2023 Total Budget: $870,897.50 Work Completed:
Total Days Used:
11/20/2023
120
Appr. Change Orders: $24,329.73
Total Project Cost: $815,227.23
CONTRACTOR RATING
The contractor completed all phases of work in a satisfactory manner.
This project consisted of installing UV-cured glass reinforced plastic liner in various locations throughout the City.
On December 19, 2022, request for bids was advertised on Planwell. On January 18, 2023, bids were received. Tunnelworks Services, Inc. was the lowest responsible bidder with the bid amount of $790,897.50. On February 14, 2023, a construction contract was awarded to Tunnelworks Services, Inc.
Following contract execution, construction began on May 1, 2023. During construction, one change order was approved to include an additional stretch of pipe to be lined.
CONTRACT CHANGE ORDERS:
CCO#1: This change order is to install UV liner on a section of failing sewer pipe on 8th St.
CCO#2: This change order is to install additional UV liner on McClellan Way.
Page: 2 of 2
Date: December 12, 2023
Subject: Capital Improvement Project Final Report
QUANTITY ADJUSTMENT:
Quantity Increases: Various items of work: $3,702.25
Quantity Decreases: Various items of work: $2,968.50
CONTRACT COSTS
The final quantities resulted in a total contract cost of $815,227.23. This represents $55,670.27 or 6.4% below the approved contract budget of $870,897.50. An analysis of project costs is included as Appendix “A”.
CONCLUSION
It is hereby recommended that the City Council accept the project as complete and turn the public facility over to City forces for maintenance and operation.
Prepared by: Cesar Ortiz, P.E., Principal Engineer Approved by: Mina Mikhael, P.E., Director of Public Works/City Engineer
CONTRACT
Original Contract Amount $790,897.50
Council Approved Contingency Funds $80,000.00
Approved Contract Amount $870,897.50
CONTRACT ADJUSTMENTS
Contract Change Orders
$10,027.48
$10,600.00
Quantity Adjustments
Increases $3,702.25
Decreases -$2,968.50
Total $733.75
Total Contract Adjustments $21,361.23
CONTRACT EXPENDITURES
Value of Work Done Previously $800,893.48
Value of Work Done This Period $14,333.75
Subtotal $815,227.23
Less Total Retention -$40,761.36
Less Previous Payments -$760,848.81
Total amount Due This Payment $13,617.06
$40,761.36
PROJECT SUMMARY
Original Contract Amount $790,897.50
$80,000.00
$870,897.50
$20,627.48
Cost of Work Completed to Date $815,227.23
Amount under the Approved Contract Amount $55,670.27
Percentage under the Approved Contract Amount 6.39%
Total Contract Amount
Approved Change Orders
Council Approved Contingency Funds
APPENDIX "A"
CCO#1 - Install UV liner on 8th Street
CCO#2 - Install UV liner on McClellan Way
Total Retention
2021-2022 and 2022-2023 Sewer Main Lining Project
DEPARTMENT OF PUBLIC WORKS