5 http://comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1594862983 1/4/2022 Attachment 6, Voided Checks #12..
- 406 -
United States
550339 11-JUN-21 CoM Misc MODESTO 1010, 10th Street 80.00 29-DEC-21 Modesto, CA 95354 United States 550340 11-JUN-21 CoM Misc MODESTO 1010, 10th Street 183.00 29-DEC-21 Modesto, CA 95354 United States 550341 11-JUN-21 CoM Misc MODESTO 1010, 10th Street 55.00 29-DEC-21 Modesto, CA 95354 United States 550343 11-JUN-21 CoM Misc MODESTO 1010, 10th Street 39.00 29-DEC-21 CoM PRIMARY Report Date: 04-JAN-2022 10:03 Void Payment Register Page: 2 Include Zero Amount Payments: No Period From: 01-DEC-21 To: 31-DEC-21 Display Payee Address: Yes Date: Void Date Bank: Bank of the West Branch: Main Branch Account: BoTW Main Acount AP Checks Bank Account Currency: USD Payment Currency: USD ( US Dollar ) Payment Number Date Payee Name Site Address Payment Amount Void Date --------------- --------- --------------------------- --------------- --------------------------------- ----------------- --------- Payment Document: CoM AP BoTW Check 550343 1010, 10th Street Modesto, CA 95354 United States 550345 11-JUN-21 CoM Misc MODESTO 1010, 10th Street 27.00 29-DEC-21 Modesto, CA 95354 United States 550346 11-JUN-21 CoM Misc MODESTO 1010, 10th Street 20.00 29-DEC-21 Modesto, CA 95354 United States 550349 11-JUN-21 CoM Misc MODESTO 1010, 10th Street 10.33 29-DEC-21 Modesto, CA 95354 United States 550407 11-JUN-21 BRYAN AND RITA GRIMES MAIN 4112 AZROCK COURT 316.33 29-DEC-21 ANTIOCH, CA 94531 United States 550931 25-JUN-21 Valencia, Ivan H OFFICE 0.03 29-DEC-21 550932 25-JUN-21 Valencia, Ivan H OFFICE 0.03 29-DEC-21 550936 25-JUN-21 COM HDL MODESTO 1010 10TH STREET 100.00 29-DEC-21 MODESTO, CA 95354 United States 550941 25-JUN-21 COM HDL MODESTO 1010 10TH STREET 100.00 29-DEC-21 MODESTO, CA 95354 United States 550945 25-JUN-21 COM HDL MODESTO 1010 10TH STREET 100.00 29-DEC-21 MODESTO, CA 95354 United States Page
2 of
5 http://comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1594862983 1/4/2022 Attachment 6, Voided Checks #12..
- 407 -
551173 25-JUN-21 CoM Misc MODESTO 1010, 10th Street 122.44 29-DEC-21 Modesto, CA 95354 United States 551219 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 208.05 29-DEC-21 Modesto, CA 95354 United States 551222 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 262.24 29-DEC-21 Modesto, CA 95354 United States 551224 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 102.95 29-DEC-21 Modesto, CA 95354 United States 551225 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 130.59 29-DEC-21 Modesto, CA 95354 United States 551226 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 117.23 29-DEC-21 Modesto, CA 95354 United States 551228 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 113.30 29-DEC-21 Modesto, CA 95354 United States CoM PRIMARY Report Date: 04-JAN-2022 10:03 Void Payment Register Page: 3 Include Zero Amount Payments: No Period From: 01-DEC-21 To: 31-DEC-21 Display Payee Address: Yes Date: Void Date Bank: Bank of the West Branch: Main Branch Account: BoTW Main Acount AP Checks Bank Account Currency: USD Payment Currency: USD ( US Dollar ) Payment Number Date Payee Name Site Address Payment Amount Void Date --------------- --------- --------------------------- --------------- --------------------------------- ----------------- --------- Payment Document: CoM AP BoTW Check 551240 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 72.57 29-DEC-21 Modesto, CA 95354 United States 551243 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 58.50 29-DEC-21 Modesto, CA 95354 United States 551245 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 241.61 29-DEC-21 Modesto, CA 95354 United States 551248 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 51.86 29-DEC-21 Modesto, CA 95354 United States 551257 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 59.60 29-DEC-21 Modesto, CA 95354 United States 551258 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 12.23 29-DEC-21 Page
3 of
5 http://comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1594862983 1/4/2022 Attachment 6, Voided Checks #12..
- 408 -
Modesto, CA 95354
United States 551265 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 20.67 29-DEC-21 Modesto, CA 95354 United States 551272 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 102.72 29-DEC-21 Modesto, CA 95354 United States 551278 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 88.56 29-DEC-21 Modesto, CA 95354 United States 551283 25-JUN-21 CoM Utilities MODESTO 1010, 10th Street 86.12 29-DEC-21 Modesto, CA 95354 United States 553947 03-SEP-21 PROJECT SENTINEL MAIN 1490 EL CAMINO REAL 6,400.71 15-DEC-21 SANTA CLARA, CA 95050 United States 555251 08-OCT-21 DECKARD TECHNOLOGIES INC. MAIN 2223 AVENIDA DE LA PLAYA 1,400.00 15-DEC-21 SUITE 206 LA JOLLA, CA 92037 United States 556210 29-OCT-21 WILLDAN ENGINEERING MAIN 2401 E KATELLA AVENUE 868.50 08-DEC-21 SUITE 300 ANAHEIM, CA 92806 United States 556470 12-NOV-21 Garza, Janet OFFICE 315.00 08-DEC-21 556531 12-NOV-21 CALIFORNIA WATER ENVIRONMEN MAIN 7677 OAKPORT STREET #600 106.00 08-DEC-21 OAKLAND, CA 94621 United States 556820 17-NOV-21 HOME DEPOT MAIN DEPT 32-2500077379 1,750.00 08-DEC-21 PO BOX 78047 CoM PRIMARY Report Date: 04-JAN-2022 10:03 Void Payment Register Page: 4 Include Zero Amount Payments: No Period From: 01-DEC-21 To: 31-DEC-21 Display Payee Address: Yes Date: Void Date Bank: Bank of the West Branch: Main Branch Account: BoTW Main Acount AP Checks Bank Account Currency: USD Payment Currency: USD ( US Dollar ) Payment Number Date Payee Name Site Address Payment Amount Void Date --------------- --------- --------------------------- --------------- --------------------------------- ----------------- --------- Payment Document: CoM AP BoTW Check 556820 DEPT 32-2500077379 PO BOX 78047 PHOENIX, AZ 85062 United States 556827 19-NOV-21 Caldwell, Tyler OFFICE 672.35 08-DEC-21 557721 07-DEC-21 HOME DEPOT MAIN DEPT 32-2500077379 1,267.80 15-DEC-21 Page
4 of
5 http://comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1594862983 1/4/2022 Attachment 6, Voided Checks #12..
- 409 -
PO BOX 78047
PHOENIX, AZ 85062 United States ----------------- Payment Document Subtotal 17,668.21 ----------------- Bank Account Subtotal 17,668.21 ----------------- Report Count: 51 Report Total 17,668.21 *** End of Report *** Page
5 of
5 http://comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1594862983 1/4/2022 Attachment 6, Voided Checks #12..
- 410 -
CITY OF MODESTO
COUNCIL AGENDA REPORT
DATE OF MEETING:
February 8, 2022
Date: January 19, 2022
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
SUBJECT: Monthly Investment Report – November 2021
CONTACT: Calogero Maniscalco, Senior Financial Analyst
[email protected], (209) 577-5219
DESCRIPTION:
Consider accepting the Monthly Investment Report for November 2021. (Funding Source:
Various Funds)
STRATEGIC PLAN ELEMENT:
This item supports the City of Modesto 2020-2025 Strategic Plan focus of Governance and Service Delivery under Goal H: Achieve Financial Sustainability.
BACKGROUND:
The City’s Finance Department submits a monthly investment report to Council and the City Manager. Attached are the November investment reports (see attachment list below) generated by Public Financial Management, the City’s investment advisor. Investments in the portfolio (attachment 4) are for the City of Modesto, Modesto Public Financing Authority, Community Facilities Districts, Tuolumne River Regional Park, Successor Agency to the Redevelopment Agency, and the Modesto-Ceres Fire Protection Agency Joint Powers Authority.
DISCUSSION:
It is the function of the Finance Department to deposit and invest funds in accordance with sound treasury management and to safeguard the principal and maintain the liquidity needs of the City. The purpose of the Monthly Investment Report is to keep the City Council and City Manager informed of the City’s investment portfolio. As shown in Attachment 2, on November 30, 2021 the City had a closing market value of $400,080,555. in its investment portfolio. #13..
- 411 -
City Council, February 8, 2022
Monthly Investment Report – November 2021
FISCAL IMPACT:
In November, the approximate yield of the City’s combined investments was 0.90% (see attachment 3) on a weighted average. For the portfolio of securities alone, the yield to maturity on cost was 1.28%. For comparative purposes, the yields (as of November 30, 2021) of other investments commonly used by public agencies are listed below:
Local Agency Investment Fund: 0.21%
1-Year U.S. Treasury Note: 0.21%
2-Year U.S. Treasury Note: 0.49%
The Portfolio maintains sufficient liquidity to meet the City's projected expenditure requirements for at least the next six months.
COMMITTEE RECOMMENDATION:
This item has not gone before a committee.
CEQA/NEPA REQUIREMENTS:
N/A
RECOMMENDED COUNCIL ACTION:
Staff Recommendations:
Motion accepting the Monthly Investment Report for November 2021.
Approved by:
DeAnna Christensen, Director of Finance
Joseph P. Lopez, City Manager
Attachments:
1. Monthly Investment Report
2. Account Statement
3. Combined Yields
4. Portfolio Holdings and Earnings Projections
5. Cash with Fiscal Agent
#13..
- 412 -
PORTFOLIO HOLDINGS
Attachment 1
Percentages may not total to 100% due to rounding.
Investment Type No. of Investments Amount Invested
CAMP 1 123,749,270
Federal Agency 33 79,982,052
Federal Home Loan Bank 2 4,471,317
Federal Home Loan Mortgage Co. 10 25,826,075
Federal Nat’l Mortgage Assc. 20 47,352,203
Federal Farm Credit Bank 1 2,332,457
Federal Agency CMO 5 3,998,942
U.S. Treasury 37 120,442,831
Negotiable CD 5 12,553,287
Corporate Note 15 34,338,357
Asset-Backed 19 11,553,122
Municipal 10 7,642,323
Supranational 2 5,820,371
Total Invested 127 400,080,555
Sector Allocation
November 30, 2021 versus October 31, 2021
Sector November 30, 2021 October 31, 2021 Change in Allocation Permitted by Policy
U.S. Treasury 30.1% 29.8% 0.32% 100%
Federal Agency 20.0% 20.1% -0.06% 100%
Federal Agency CMO 1.0% 1.1% -0.11% 100%
Negotiable CD 3.1% 3.1% -0.01% 30%
Corporate Note 8.6% 8.6% -0.04% 30%
Asset-Backed 2.9% 2.9% -0.06% 20%
Municipal 1.9% 1.9% 0.00% 100%
Supranational 1.5% 1.5% -0.01% 30%
CAMP 30.9% 31.0% -0.04% 100%
* Total invested includes only the bolded numbers
* * Amount invested are market values excluding accrued interest Additional, detailed information regarding security types and investment activity may be found in Attachment 2 accompanying this memo. Moreover, the addendum data will confirm continued compliance with the investment policy as well as with California Government Code.
RECENT ACTIVITY & CORPORATE EXPOSURE
The yield curve flattened over the month as yields on maturities beyond 5 years moved lower and yields on securities with maturities of 5 years and under moved slightly higher. The flattening across longer-date tenors may indicate dwindling prospects for further monetary support. The yield curve remains steep out to five years, as very short-term rates are anchored near zero percent by the Fed's near zero interest rate policy, and securities with maturities from 1 to 5 years are pricing in expected 2022 rate hikes. Spreads in most sectors remain tight but we have seen widening in corporates and ABS over the month. We found value in the U.S. Treasury sector, purchasing a slightly longer-duration note, and one ABS using proceeds from the sale of two short-duration Treasury notes.
#13..
- 413 -
PERFORMANCE
The City’s portfolio has consistently outperformed its benchmark since the inception of performance reporting.
1. Performance is calculated on trade-date basis, gross (i.e., before fees) in accordance the CFA Institute's Global Investment Performance Standards (GIPS).
2. Performance numbers for periods greater than 1 year are presented on an annualized basis unless otherwise noted.
3. The performance calculation excludes any funds not invested in the 1-5 year strategy.
4. Performance benchmark through December 31, 2018 was the ICE BofAML 1-3 Year U.S. Treasury Index, and is now the ICE BofAML 1-5 Year U.S. Treasury Index, sourced from Bloomberg.
5. Inception date is 3/31/04.
Percentages may not add due to rounding.
Total Return
November 30, 2021
1 Month Trailing
12 Months
Trailing 36
Months
Trailing 60
Months
Since
Inception5
City of Modesto Investment Portfolio1,2,3-0.05% -0.62% 3.06% 2.18% 2.31% Modesto Performance Benchmark4 0.05% -0.75% 2.78% 1.83% 2.03% Average Portfolio Yields
November 30, 2021
Past
Month
Past 3
Months
Past
Year
Past 3
Years
Past 5
Years
City of Modesto Investment Portfolio 1.28% 1.30% 1.49% 2.10% 1.94% $124.3
$11.0
$93.9
$48.5
$88.5
$34.0
$-
$30.0
$60.0
$90.0
$120.0
$150.0
$180.0
Under 6
Months
6-12
Months
1-2 Years 2-3 Years 3-4 Years 4-5 Years
millions
Maturity Distribution
November 30, 2021
#13..
- 414 -
INVESTMENT POLICY
The City’s investment policy embraces the following standards: the prudent investor rule, requiring the safety of principal, through prudent and safe investments; sufficient liquidity to meet expected and unforeseen cash flows; generation of an above-market, risk-adjusted rate of return (meaning, returnsexpectations taking safety and liquidity into account). No investments longer than five years are permitted.
Some investments have maturity limits of 270 days or less. The table below details the City’s permitted investments.
Investment Type
Maximum
Maturity
Maximum Specified
% of Portfolio
Maximum
% per
Issuer
Minimum Quality
Requirements
Local Agency Bonds 5 Years None None None
Treasury Obligations 5 Years None None None
State Obligations 5 Years None None A rating
CA Local Agency Obligations 5 Years None None A rating
Federal Agencies 5 Years None None None
Supranationals 5 Years 30 percent 5 percent AA
Banker’s Acceptances 180 days 40 percent 5 percent Federal Reserve eligible Commercial Paper 270 days 25 percent 5 percent A1/P1 rating Negotiable Certificates of Deposit 5 Years 30 percent 5 percent A rating Certificates of Deposit 1 Year 20 percent 5 percent FDIC insured or collateralized Repurchase Agreements 90 days None 5 percent None
Reverse Repurchase Agreements 92 days 20 percent of
combined base value 5 percent None
Medium Term Notes 5 Years 30 percent 5 percent A rating Money Market Mutual Funds N/A 20 percent 10 percent Multiple Mortgage and Asset-backed Securities 5 Years 20 percent 5 percent AA Rating CAMP N/A None None N/A
LAIF N/A N/A None N/A
The City is not required to include a list of investments held by our bond trustees; however, staff believes the City Council should be kept informed of these investments. These investments are identified on Attachment A.
INCOME RETURN
Monthly Income Return
0.11%
Fiscal Year-to-Date Income Return
0.59%
Prior 12 Months Income Return
1.54%
#13..
- 415 -
Source: Bloomberg, as of October 2021. Forecasts by Goldman Sachs Group, Deutsche Bank, ING Group, JPMorgan Chase, BMO Capital, Barclays, UBS, Morgan Stanley, and Wells Fargo.
Economic Summary
Inflationary Pressures Continue to Grow
-0.50%
0.50%
1.50%
2.50%
3.50%
4.50%
5.50%
6.50%
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021
Percent (%)
PCE CPI
Personal Consumption Expenditures (PCE) and Consumer Price Index (CPI) #13..
- 416 -
Source: Bloomberg, as of 11/30/2021.
Economic Summary
Unemployment Rate Continues to Fall in Late 2021
April 20
14.8%
November 21
4.2%
2%
4%
6%
8%
10%
12%
14%
16%
2018 2019 2020
Unemployment Rate
#13..
- 417 -
Source: ICE BofAML 1-5 year Indices via Bloomberg, MarketAxess and PFM as of 11/30/2021. Spreads on ABS are option-adjusted spreads of 0-5 year indices based on weighted average life; spreads on agencies are relative to comparable maturity Treasuries.
Economic Summary
Sector Yield Spreads Begin to Widen Slightly
#13..
- 418 -
Shorter-Term Yields Stay Steep, With Longer Dated
Treasury Yields Flattening
Source: Bloomberg as of 11/30/2021.
Economic Summary
U.S. Treasury Yield Curve
#13..
- 419 -
This material is based on information obtained from sources generally believed to be reliable and available to the public, however, PFM Asset Management LLC cannot guarantee its accuracy, completeness or suitability. This material is for general information purposes only and is not intended to provide specific advice or a specific recommendation. All statements as to what will or may happen under certain circumstances are based on assumptions, some but not all of which are noted in the presentation. Assumptions may or may not be proven correct as actual events occur, and results may depend on events outside of your or our control. Changes in assumptions may have a material effect on results. Past performance does not necessarily reflect and is not a guaranty of future results. The information contained in this presentation is not an offer to purchase or sell any securities.
Investment advisory services are provided by PFM Asset Management LLC (“PFMAM”), an investment adviser registered with the U.S. Securities and Exchange Commission and a subsidiary of U.S. Bancorp Asset Management, Inc. (“USBAM”). USBAM is a subsidiary of U.S. Bank National Association (“U.S. Bank”). U.S. Bank is a separate entity and subsidiary of U.S. Bancorp. U.S. Bank is not responsible for and does not guarantee the products, services or performance of PFMAM. The information contained is not an offer to purchase or sell any securities. Additional applicable regulatory information is available upon request.
For more information regarding PFMAM’s services or entities, please visit www.pfmam.com.
Disclosures
#13..
- 420 -
For the Month Ending November 30, 2021
Account Statement
Consolidated Summary Statement
CITY OF MODESTO
Investment Allocation
Investment Type Closing Market Value Percent
Asset-Backed Security 11,553,121.64 2.89
Federal Agency Bond / Note 79,982,051.76 19.99
Corporate Note 34,338,357.15 8.58
Certificate of Deposit 12,553,286.90 3.14
Federal Agency Commercial Mortgage-Backed Security 3,998,942.25 1.00 Municipal Bond / Note 7,642,323.30 1.91
Supra-National Agency Bond / Note 5,820,371.20 1.45
U.S. Treasury Bond / Note 120,442,831.44 30.10
CAMP Pool 123,749,269.51 30.94
Total $400,080,555.15 100.00%
Portfolio Summary
and Income
Closing
Portfolio Holdings Market Value
Cash Dividends
PFM Managed Account 529,991.04 276,331,285.64
CAMP Pool 0.00 123,749,269.51
Total $529,991.04 $400,080,555.15
Maturity Distribution (Fixed Income Holdings)
Portfolio Holdings Closing Market Value Percent
123,749,269.51
543,836.82
0.00 0.00
10,958,530.35
97,277,147.77
45,087,105.63
88,450,300.03
34,014,365.04
0.00 30.93
0.14 0.00
0.00 2.74
24.31 11.27
22.11 8.50
0.00 Under 30 days
31 to 60 days
61 to 90 days
91 to 180 days
181 days to 1 year
1 to 2 years
2 to 3 years
3 to 4 years
4 to 5 years
Over 5 years
Total $400,080,555.15
674
100.00%
Weighted Average Days to Maturity
Sector Allocation
2.89%
ABS
19.99%
Fed Agy Bond /
Note
8.58%
Corporate Note
3.14%
Cert of Deposit
1.00%
Federal Agency
Commercial
Mortgage-Backed
Security
1.91%
Muni Bond / Note
1.45%
Supra-National
Agency Bond / Note
30.10%
US TSY Bond / Note
30.94%
CAMP Pool
Summary Page 1
#13..
- 421 -
Managed Account Summary Statement For the Month Ending November 30, 2021 Total Cash Basis Earnings
Plus Net Realized Gains/Losses
Less Purchased Interest Related to Interest/Coupons
Interest/Dividends/Coupons Received
Earnings Reconciliation (Cash Basis) - Managed Account
Less Beginning Accrued Interest
Less Beginning Amortized Value of Securities
Less Cost of New Purchases
Plus Coupons/Dividends Received
Plus Proceeds of Maturities/Calls/Principal Payments
Plus Proceeds from Sales
Ending Accrued Interest
Ending Amortized Value of Securities
Earnings Reconciliation (Accrual Basis)
$275,829,674.69
(1,066,212.99)
(2,590,727.73)
4,598,187.23
0.00 (439,635.56)
$276,331,285.64
417,831.71
(6,749.49)
118,908.82
$529,991.04
Total
275,079,950.15
785,584.21
2,594,174.61
1,066,212.99
414,384.83
(4,604,936.72)
(274,089,339.67)
(890,569.74)
Total Accrual Basis Earnings $355,460.66
Closing Market Value
Change in Current Value
Unsettled Trades
Principal Acquisitions
Principal Dispositions
Maturities/Calls
Opening Market Value
Transaction Summary - Managed Account
_________________
_________________
_______________________________________________ _______________________________________________ Reconciling Transactions Net Cash Contribution
Security Purchases
Principal Payments
Coupon/Interest/Dividend Income
Sale Proceeds
Maturities/Calls
Cash Transactions Summary - Managed Account
0.00 2,594,174.61
414,384.83
1,066,212.99
(4,604,936.72)
0.00 0.00
Cash Balance
Closing Cash Balance $1,265,303.23
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 1
#13..
- 422 -
Portfolio Summary and Statistics For the Month Ending November 30, 2021 Description Par Value Market Value Percent
U.S. Treasury Bond / Note 119,871,000.00 120,442,831.44 43.58 Supra-National Agency Bond / Note 5,885,000.00 5,820,371.20 2.11 Municipal Bond / Note 7,590,000.00 7,642,323.30 2.77
Federal Agency Commercial
Mortgage-Backed Security
3,923,185.35 3,998,942.25 1.45
Federal Agency Bond / Note 79,810,000.00 79,982,051.76 28.94 Corporate Note 33,615,000.00 34,338,357.15 12.43
Certificate of Deposit 12,440,000.00 12,553,286.90 4.54 Asset-Backed Security 11,528,079.72 11,553,121.64 4.18
Managed Account Sub-Total 274,662,265.07 276,331,285.64 100.00% Accrued Interest 785,584.21
Total Portfolio 274,662,265.07 277,116,869.85
Unsettled Trades 0.00 0.00
Sector Allocation
4.18%
ABS
4.54%
Cert of Deposit
12.43%
Corporate Note
28.94%
Fed Agy Bond /
Note
1.45%
Federal Agency
Commercial
Mortgage-Backed
Security
2.77%
Muni Bond / Note
2.11%
Supra-National
Agency Bond / Note
43.58%
US TSY Bond / Note
0 - 6 Months 6 - 12 Months 1 - 2 Years 2 - 3 Years 3 - 4 Years 4 - 5 Years Over 5 Years
0.19%
3.97%
35.20%
16.32%
32.01%
12.31%
0.00%
Maturity Distribution Characteristics
Yield to Maturity at Cost
Yield to Maturity at Market
Weighted Average Days to Maturity 975
1.28%
0.83%
CITY OF MODESTO - XXXX0050
Account Summary
Account XXXX0050 Page 2
#13..
- 423 -
Managed Account Issuer Summary For the Month Ending November 30, 2021 Credit Quality (S&P Ratings)
1.22%
A
6.20%
A+
2.07%
A1.97%
A-1
1.26%
A-1+
3.86%
AA
74.32%
AA+
2.56%
AA5.24%
AAA
1.30%
NR
Issuer Summary
Issuer of Holdings Percent
Market Value
ALLY AUTO RECEIVABLES TRUST 203,830.08 0.07
AMAZON.COM INC 3,955,648.67 1.43
BANK OF AMERICA CO 2,072,941.14 0.75
BRISTOL-MYERS SQUIBB CO 2,179,227.36 0.79
CALIFORNIA DEPARTMENT OF WATER RESOURCES 99,214.00 0.04 CALIFORNIA STATE UNIVERSITY 596,298.00 0.22
CAPITAL ONE FINANCIAL CORP 244,251.17 0.09
CARMAX AUTO OWNER TRUST 2,358,944.08 0.85
CREDIT SUISSE GROUP RK 1,852,963.70 0.67
DISCOVER FINANCIAL SERVICES 763,546.59 0.28
DNB ASA 1,772,893.83 0.64
FANNIE MAE 48,559,366.49 17.57
FEDERAL FARM CREDIT BANKS 2,332,456.60 0.84
FEDERAL HOME LOAN BANKS 4,471,316.73 1.62
FLORIDA STATE BOARD OF ADMIN FIN CORP 1,800,126.00 0.65 FREDDIE MAC 28,617,854.19 10.36
HONDA AUTO RECEIVABLES 2,497,207.07 0.90
HYUNDAI AUTO RECEIVABLES 1,236,287.21 0.45
INTER-AMERICAN DEVELOPMENT BANK 4,045,647.06 1.46
INTL BANK OF RECONSTRUCTION AND DEV 1,774,724.14 0.64
JP MORGAN CHASE & CO 3,651,723.71 1.32
LOS ANGELES COMMUNITY COLLEGE DISTRICT 915,185.75 0.33
MASTERCARD INC 1,806,397.12 0.65
NEW JERSEY TURNPIKE AUTHORITY 499,338.95 0.18
NISSAN AUTO RECEIVABLES 1,071,942.14 0.39
NORDEA BANK ABP 3,478,208.08 1.26
NOVARTIS AG 2,324,047.72 0.84
PACCAR FINANCIAL CORP 1,840,246.91 0.67
PFIZER INC 3,597,889.10 1.30
SKANDINAVISKA ENSKILDA BANKEN AB 3,599,804.36 1.30
STATE OF CALIFORNIA 2,390,896.20 0.87
STATE OF MARYLAND 617,352.60 0.22
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 3
#13..
- 424 -
Managed Account Issuer Summary For the Month Ending November 30, 2021 SUMITOMO MITSUI FINANCIAL GROUP INC 1,849,416.93 0.67
THE BANK OF NEW YORK MELLON CORPORATION 3,372,422.13 1.22 TOYOTA MOTOR CORP 5,514,414.21 2.00
UNITED STATES TREASURY 120,442,831.44 43.59
UNIVERSITY OF CALIFORNIA 723,911.80 0.26
US BANCORP 3,009,672.38 1.09
WAL-MART STORES INC 4,190,840.00 1.52
Total $276,331,285.64 100.00%
CITY OF MODESTO - XXXX0050
Market Value
Issuer of Holdings Percent
Account XXXX0050 Page 4
#13..
- 425 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
U.S. Treasury Bond / Note
US TREASURY NOTES
DTD 04/30/2018 2.750% 04/30/2023
9128284L1 4,445,000.00 AA+ Aaa 04/29/21 04/30/21 4,673,500.78 0.17 10,467.85 4,606,202.61 4,592,934.93
US TREASURY NOTES
DTD 05/15/2013 1.750% 05/15/2023
912828VB3 4,300,000.00 AA+ Aaa 12/28/18 12/31/18 4,160,417.97 2.54 3,325.97 4,253,647.57 4,384,656.25
US TREASURY NOTES
DTD 06/30/2016 1.375% 06/30/2023
912828S35 5,100,000.00 AA+ Aaa 01/30/19 01/31/19 4,848,386.72 2.56 29,345.79 5,010,037.71 5,176,500.00
US TREASURY NOTES
DTD 08/01/2016 1.250% 07/31/2023
912828S92 3,155,000.00 AA+ Aaa 02/08/19 02/12/19 2,997,126.76 2.44 13,181.55 3,096,209.17 3,196,902.19
US TREASURY NOTES
DTD 08/01/2016 1.250% 07/31/2023
912828S92 5,625,000.00 AA+ Aaa 04/02/19 04/04/19 5,386,816.41 2.28 23,501.19 5,533,437.34 5,699,706.75
US TREASURY NOTES
DTD 08/31/2016 1.375% 08/31/2023
9128282D1 1,750,000.00 AA+ Aaa 07/01/19 07/03/19 1,723,886.72 1.75 6,115.33 1,739,039.29 1,777,070.40
US TREASURY NOTES
DTD 10/01/2018 2.875% 09/30/2023
9128285D8 2,700,000.00 AA+ Aaa 05/01/19 05/02/19 2,769,820.31 2.26 13,221.84 2,728,932.98 2,816,015.76
US TREASURY NOTES
DTD 11/15/2020 0.250% 11/15/2023
91282CAW1 3,910,000.00 AA+ Aaa 04/29/21 04/30/21 3,909,389.06 0.26 432.04 3,909,530.45 3,887,395.51
US TREASURY NOTES
DTD 11/15/2013 2.750% 11/15/2023
912828WE6 8,790,000.00 AA+ Aaa 03/06/19 03/08/19 8,878,930.08 2.52 10,683.98 8,827,067.18 9,166,321.88
US TREASURY NOTES
DTD 11/30/2016 2.125% 11/30/2023
912828U57 3,275,000.00 AA+ Aaa 01/07/19 01/09/19 3,216,408.21 2.52 191.19 3,251,084.31 3,376,832.20
US TREASURY NOTES
DTD 12/31/2018 2.625% 12/31/2023
9128285U0 270,000.00 AA+ Aaa 01/30/19 01/31/19 270,801.56 2.56 2,965.96 270,339.38 281,306.25
US TREASURY NOTES
DTD 02/28/2019 2.375% 02/29/2024
9128286G0 457,000.00 AA+ Aaa 08/11/21 08/12/21 480,671.17 0.33 2,758.41 477,848.94 474,565.94
US TREASURY NOTES
DTD 02/28/2019 2.375% 02/29/2024
9128286G0 1,564,000.00 AA+ Aaa 08/11/21 08/12/21 1,644,582.66 0.35 9,440.17 1,634,975.06 1,624,116.25
US TREASURY N/B NOTES
DTD 04/15/2021 0.375% 04/15/2024
91282CBV2 4,890,000.00 AA+ Aaa 04/29/21 04/30/21 4,893,629.30 0.35 2,367.75 4,892,907.47 4,853,325.00 CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 5
#13..
- 426 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
U.S. Treasury Bond / Note
US TREASURY NOTES
DTD 07/31/2017 2.125% 07/31/2024
9128282N9 2,450,000.00 AA+ Aaa 08/01/19 08/06/19 2,489,142.58 1.79 17,401.32 2,470,914.73 2,538,046.88
US TREASURY NOTES
DTD 08/31/2017 1.875% 08/31/2024
9128282U3 1,630,000.00 AA+ Aaa 09/04/19 09/05/19 1,672,214.45 1.34 7,767.27 1,653,261.97 1,678,135.86
US TREASURY NOTES
DTD 10/02/2017 2.125% 09/30/2024
9128282Y5 1,850,000.00 AA+ Aaa 10/01/19 10/03/19 1,905,283.20 1.50 6,696.09 1,881,339.27 1,918,507.72
US TREASURY NOTES
DTD 10/31/2017 2.250% 10/31/2024
9128283D0 460,000.00 AA+ Aaa 11/01/19 11/05/19 475,039.84 1.57 886.33 468,791.12 478,831.25
US TREASURY NOTES
DTD 11/30/2017 2.125% 11/30/2024
9128283J7 1,215,000.00 AA+ Aaa 12/02/19 12/04/19 1,239,964.45 1.69 70.93 1,229,995.10 1,260,942.19
US TREASURY NOTES
DTD 11/30/2017 2.125% 11/30/2024
9128283J7 3,450,000.00 AA+ Aaa 01/03/20 01/07/20 3,529,916.02 1.63 201.41 3,498,914.50 3,580,453.13
US TREASURY NOTES
DTD 11/30/2017 2.125% 11/30/2024
9128283J7 4,585,000.00 AA+ Aaa 04/29/21 04/30/21 4,848,816.60 0.50 267.67 4,805,518.46 4,758,370.31
US TREASURY NOTES
DTD 04/30/2020 0.375% 04/30/2025
912828ZL7 4,945,000.00 AA+ Aaa 04/29/21 04/30/21 4,894,777.34 0.63 1,588.00 4,902,168.08 4,848,418.22
US TREASURY NOTES
DTD 08/31/2020 0.250% 08/31/2025
91282CAJ0 4,340,000.00 AA+ Aaa 08/02/21 08/06/21 4,291,514.06 0.53 2,757.46 4,295,331.59 4,216,581.25
US TREASURY NOTES
DTD 09/30/2020 0.250% 09/30/2025
91282CAM3 1,100,000.00 AA+ Aaa 09/27/21 09/28/21 1,076,023.44 0.80 468.41 1,077,072.31 1,068,375.00
US TREASURY NOTES
DTD 09/30/2020 0.250% 09/30/2025
91282CAM3 4,550,000.00 AA+ Aaa 09/07/21 09/09/21 4,473,574.22 0.67 1,937.50 4,477,854.48 4,419,187.50
US TREASURY NOTES
DTD 10/31/2020 0.250% 10/31/2025
91282CAT8 5,010,000.00 AA+ Aaa 04/29/21 04/30/21 4,894,339.45 0.77 1,072.58 4,909,456.18 4,856,568.75
US TREASURY NOTES
DTD 10/31/2020 0.250% 10/31/2025
91282CAT8 6,930,000.00 AA+ Aaa 10/04/21 10/06/21 6,783,278.91 0.78 1,483.64 6,788,808.10 6,717,768.75
US TREASURY NOTES
DTD 11/30/2020 0.375% 11/30/2025
91282CAZ4 4,250,000.00 AA+ Aaa 11/01/21 11/02/21 4,133,291.02 1.07 43.78 4,135,564.06 4,134,453.13 CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 6
#13..
- 427 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
U.S. Treasury Bond / Note
US TREASURY NOTES
DTD 12/31/2020 0.375% 12/31/2025
91282CBC4 500,000.00 AA+ Aaa 02/02/21 02/04/21 498,613.28 0.43 784.65 498,845.56 486,093.75
US TREASURY NOTES
DTD 12/31/2020 0.375% 12/31/2025
91282CBC4 1,040,000.00 AA+ Aaa 01/07/21 01/08/21 1,035,978.13 0.45 1,632.06 1,036,701.54 1,011,075.00
US TREASURY NOTES
DTD 12/31/2020 0.375% 12/31/2025
91282CBC4 3,735,000.00 AA+ Aaa 04/05/21 04/07/21 3,646,439.65 0.89 5,861.31 3,658,630.14 3,631,120.31
US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 2,400,000.00 AA+ Aaa 07/02/21 07/07/21 2,353,875.00 0.80 3,008.15 2,357,937.54 2,330,250.00
US TREASURY NOTES
DTD 02/28/2019 2.500% 02/28/2026
9128286F2 3,210,000.00 AA+ Aaa 03/01/21 03/01/21 3,492,881.25 0.70 20,395.03 3,450,255.31 3,397,584.38
US TREASURY N/B NOTES
DTD 03/31/2021 0.750% 03/31/2026
91282CBT7 2,480,000.00 AA+ Aaa 09/07/21 09/09/21 2,479,031.25 0.76 3,168.13 2,479,079.57 2,442,800.00
US TREASURY N/B NOTES
DTD 03/31/2021 0.750% 03/31/2026
91282CBT7 4,925,000.00 AA+ Aaa 04/29/21 04/30/21 4,896,719.73 0.87 6,291.55 4,900,105.17 4,851,125.00
US TREASURY N/B NOTES
DTD 05/31/2021 0.750% 05/31/2026
91282CCF6 2,260,000.00 AA+ Aaa 06/23/21 06/25/21 2,247,110.94 0.87 46.57 2,248,248.84 2,223,275.00
US TREASURY N/B NOTES
DTD 05/31/2021 0.750% 05/31/2026
91282CCF6 2,325,000.00 AA+ Aaa 06/07/21 06/07/21 2,319,732.42 0.80 47.90 2,320,244.99 2,287,218.75 Security Type Sub-Total 119,871,000.00 119,531,924.94 1.27 211,876.76 119,776,298.07 120,442,831.44 Supra-National Agency Bond / Note
INTL BK RECON & DEVELOP NOTES
DTD 11/24/2020 0.250% 11/24/2023
459058JM6 1,790,000.00 AAA Aaa 11/17/20 11/24/20 1,786,151.50 0.32 87.01 1,787,458.94 1,774,724.14
INTER-AMERICAN DEVEL BK NOTES
DTD 09/23/2021 0.500% 09/23/2024
4581X0DZ8 4,095,000.00 AAA Aaa 09/15/21 09/23/21 4,091,969.70 0.52 3,867.50 4,092,160.48 4,045,647.06 Security Type Sub-Total 5,885,000.00 5,878,121.20 0.46 3,954.51 5,879,619.42 5,820,371.20 Municipal Bond / Note
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 7
#13..
- 428 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Municipal Bond / Note
CA ST TXBL GO BONDS
DTD 10/24/2019 2.400% 10/01/2023
13063DRJ9 2,310,000.00 AA- Aa2 10/16/19 10/24/19 2,356,223.10 1.87 9,240.00 2,331,504.35 2,390,896.20
MD ST TXBL GO BONDS
DTD 08/05/2020 0.510% 08/01/2024
574193TQ1 620,000.00 AAA Aaa 07/23/20 08/05/20 619,826.40 0.52 1,054.00 619,883.95 617,352.60
CA ST UNIV TXBL REV BONDS
DTD 09/17/2020 0.685% 11/01/2024
13077DMK5 600,000.00 AA- Aa2 08/27/20 09/17/20 600,000.00 0.69 342.50 600,000.00 596,298.00
CA ST DEPT WTR RES WTR SYS TXBL REV
BNDS
DTD 08/06/2020 0.560% 12/01/2024
13067WRB0 100,000.00 AAA Aa1 07/30/20 08/06/20 100,000.00 0.56 280.00 100,000.00 99,214.00
UNIV OF CAL TXBL REV BONDS
DTD 07/16/2020 0.883% 05/15/2025
91412HGE7 220,000.00 AA Aa2 07/14/20 07/16/20 220,796.40 0.81 86.34 220,565.38 218,165.20
UNIV OF CAL TXBL REV BONDS
DTD 07/16/2020 0.883% 05/15/2025
91412HGE7 510,000.00 AA Aa2 07/10/20 07/16/20 510,000.00 0.88 200.14 510,000.00 505,746.60
FL ST BOARD OF ADMIN TXBL REV BONDS
DTD 09/16/2020 1.258% 07/01/2025
341271AD6 505,000.00 AA Aa3 09/03/20 09/16/20 508,570.35 1.11 2,647.04 507,670.11 505,035.35
FL ST BOARD OF ADMIN TXBL REV BONDS
DTD 09/16/2020 1.258% 07/01/2025
341271AD6 1,295,000.00 AA Aa3 09/03/20 09/16/20 1,295,000.00 1.26 6,787.96 1,295,000.00 1,295,090.65
LOS ANGELES CCD, CA TXBL GO BONDS
DTD 11/10/2020 0.773% 08/01/2025
54438CYK2 925,000.00 AA+ Aaa 10/30/20 11/10/20 925,000.00 0.77 2,383.42 925,000.00 915,185.75
NJ TURNPIKE AUTHORITY TXBL REV BONDS
DTD 02/04/2021 1.047% 01/01/2026
646140DP5 505,000.00 A+ A2 01/22/21 02/04/21 505,000.00 1.05 2,203.06 505,000.00 499,338.95 Security Type Sub-Total 7,590,000.00 7,640,416.25 1.22 25,224.46 7,614,623.79 7,642,323.30 Federal Agency Commercial Mortgage-Backed Security
FHLMC MULTIFAMILY STRUCTURED P
DTD 05/01/2015 2.791% 01/01/2022
3137BHXY8 542,850.82 AA+ Aaa 05/16/19 05/21/19 546,243.64 2.54 1,262.58 542,960.84 543,836.82
FHLMC MULTIFAMILY STRUCTURED P
DTD 11/01/2015 2.716% 06/01/2022
3137BLUR7 934,437.28 AA+ Aaa 04/02/19 04/05/19 936,773.38 2.63 2,114.94 934,806.03 939,968.97 CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 8
#13..
- 429 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Federal Agency Commercial Mortgage-Backed Security
FHLMC MULTIFAMILY STRUCTURED P
DTD 12/01/2012 2.307% 08/01/2022
3137AWQH1 1,080,000.00 AA+ Aaa 09/04/19 09/09/19 1,095,946.88 1.78 2,076.30 1,083,666.12 1,091,132.01
FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
3136AJB54 1,152,273.42 AA+ Aaa 12/13/19 12/18/19 1,208,266.70 2.14 3,212.92 1,182,221.62 1,207,163.39 FHMS KJ27 A1
DTD 11/01/2019 2.092% 07/01/2024
3137FQ3V3 213,623.83 AA+ Aaa 11/20/19 11/26/19 213,618.72 2.09 372.42 213,620.96 216,841.06 Security Type Sub-Total 3,923,185.35 4,000,849.32 2.21 9,039.16 3,957,275.57 3,998,942.25 Federal Agency Bond / Note
FREDDIE MAC NOTES
DTD 05/07/2020 0.375% 05/05/2023
3137EAER6 4,000,000.00 AA+ Aaa 08/03/20 08/04/20 4,019,600.00 0.20 1,083.33 4,010,151.39 3,998,852.00
FANNIE MAE NOTES
DTD 05/22/2020 0.250% 05/22/2023
3135G04Q3 3,660,000.00 AA+ Aaa 05/20/20 05/22/20 3,648,983.40 0.35 228.75 3,654,597.34 3,652,193.22
FREDDIE MAC NOTES
DTD 06/11/2018 2.750% 06/19/2023
3137EAEN5 3,615,000.00 AA+ Aaa 01/07/19 01/09/19 3,640,377.30 2.58 44,735.63 3,623,839.81 3,744,698.97
FREDDIE MAC NOTES
DTD 06/11/2018 2.750% 06/19/2023
3137EAEN5 4,170,000.00 AA+ Aaa 11/01/18 11/05/18 4,114,455.60 3.06 51,603.75 4,151,397.40 4,319,611.26
FREDDIE MAC NOTES
DTD 06/26/2020 0.250% 06/26/2023
3137EAES4 3,315,000.00 AA+ Aaa 06/24/20 06/26/20 3,305,320.20 0.35 3,568.23 3,309,943.52 3,305,926.85
FANNIE MAE NOTES
DTD 07/10/2020 0.250% 07/10/2023
3135G05G4 3,395,000.00 AA+ Aaa 07/08/20 07/10/20 3,387,700.75 0.32 3,324.27 3,391,093.73 3,383,307.62
FREDDIE MAC NOTES
DTD 08/21/2020 0.250% 08/24/2023
3137EAEV7 2,200,000.00 AA+ Aaa 08/19/20 08/21/20 2,197,756.00 0.28 1,481.94 2,198,710.42 2,190,718.20
FANNIE MAE NOTES
DTD 09/14/2018 2.875% 09/12/2023
3135G0U43 3,745,000.00 AA+ Aaa 11/07/18 11/09/18 3,699,610.60 3.15 23,627.31 3,728,312.72 3,901,421.16
FANNIE MAE NOTES
DTD 09/14/2018 2.875% 09/12/2023
3135G0U43 5,665,000.00 AA+ Aaa 12/03/18 12/06/18 5,653,556.70 2.92 35,740.64 5,660,727.66 5,901,615.72
FEDERAL FARM CREDIT BANK (CALLABLE)
DTD 09/21/2020 0.250% 09/21/2023
3133EMAM4 2,345,000.00 AA+ Aaa 10/07/20 10/09/20 2,341,013.50 0.31 1,139.93 2,342,560.72 2,332,456.60 CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 9
#13..
- 430 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Federal Agency Bond / Note
FANNIE MAE NOTES
DTD 11/25/2020 0.250% 11/27/2023
3135G06H1 900,000.00 AA+ Aaa 01/25/21 01/26/21 901,368.00 0.20 25.00 900,959.58 894,221.10
FREDDIE MAC NOTES
DTD 12/04/2020 0.250% 12/04/2023
3137EAFA2 2,015,000.00 AA+ Aaa 12/02/20 12/04/20 2,013,005.15 0.28 2,476.77 2,013,664.63 2,001,136.80
FEDERAL HOME LOAN BANKS NOTES
DTD 12/09/2013 3.375% 12/08/2023
3130A0F70 2,025,000.00 AA+ Aaa 01/30/19 01/31/19 2,084,684.63 2.72 32,842.97 2,049,823.69 2,137,828.95
FANNIE MAE NOTES
DTD 01/10/2020 1.625% 01/07/2025
3135G0X24 3,500,000.00 AA+ Aaa 03/04/20 03/05/20 3,628,135.00 0.85 22,750.00 3,582,067.24 3,575,687.50
FREDDIE MAC NOTES
DTD 02/14/2020 1.500% 02/12/2025
3137EAEP0 640,000.00 AA+ Aaa 02/27/20 02/28/20 649,676.80 1.18 2,906.67 646,246.37 651,345.28
FEDERAL HOME LOAN BANK NOTES
DTD 04/16/2020 0.500% 04/14/2025
3130AJHU6 2,370,000.00 AA+ Aaa 04/15/20 04/16/20 2,358,244.80 0.60 1,547.08 2,362,072.97 2,333,487.78
FANNIE MAE NOTES
DTD 04/24/2020 0.625% 04/22/2025
3135G03U5 475,000.00 AA+ Aaa 04/29/20 04/30/20 475,731.50 0.59 321.61 475,498.13 469,611.13
FANNIE MAE NOTES
DTD 04/24/2020 0.625% 04/22/2025
3135G03U5 1,910,000.00 AA+ Aaa 06/03/20 06/05/20 1,919,779.20 0.52 1,293.23 1,916,793.85 1,888,331.05
FANNIE MAE NOTES
DTD 04/24/2020 0.625% 04/22/2025
3135G03U5 3,195,000.00 AA+ Aaa 04/22/20 04/24/20 3,188,418.30 0.67 2,163.28 3,190,532.82 3,158,752.73
FANNIE MAE NOTES
DTD 04/24/2020 0.625% 04/22/2025
3135G03U5 3,345,000.00 AA+ Aaa 05/01/20 05/04/20 3,347,475.30 0.61 2,264.84 3,346,689.32 3,307,050.97
FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 200,000.00 AA+ Aaa 09/17/20 09/18/20 200,712.00 0.42 455.56 200,531.64 196,280.20
FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 1,075,000.00 AA+ Aaa 10/01/20 10/05/20 1,080,041.75 0.40 2,448.61 1,078,801.88 1,055,006.07
FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 1,190,000.00 AA+ Aaa 01/04/21 01/05/21 1,197,223.30 0.36 2,710.56 1,195,755.51 1,167,867.19
FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 3,675,000.00 AA+ Aaa 06/17/20 06/19/20 3,667,392.75 0.54 8,370.83 3,669,603.19 3,606,648.68 CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 10
#13..
- 431 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Federal Agency Bond / Note
FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 3,820,000.00 AA+ Aaa 10/02/20 10/05/20 3,836,311.40 0.41 8,701.11 3,832,300.09 3,748,951.82
FREDDIE MAC NOTES
DTD 07/23/2020 0.375% 07/21/2025
3137EAEU9 2,220,000.00 AA+ Aaa 07/21/20 07/23/20 2,208,944.40 0.48 3,006.25 2,211,950.75 2,170,818.12
FANNIE MAE NOTES
DTD 08/27/2020 0.375% 08/25/2025
3135G05X7 450,000.00 AA+ Aaa 10/22/20 10/23/20 447,480.00 0.49 450.00 448,056.16 439,452.00
FANNIE MAE NOTES
DTD 08/27/2020 0.375% 08/25/2025
3135G05X7 550,000.00 AA+ Aaa 10/15/20 10/16/20 548,289.50 0.44 550.00 548,685.79 537,108.00
FANNIE MAE NOTES
DTD 08/27/2020 0.375% 08/25/2025
3135G05X7 2,360,000.00 AA+ Aaa 08/25/20 08/27/20 2,348,955.20 0.47 2,360.00 2,351,746.68 2,304,681.60
FREDDIE MAC NOTES
DTD 09/25/2020 0.375% 09/23/2025
3137EAEX3 130,000.00 AA+ Aaa 09/29/20 09/30/20 129,829.70 0.40 92.08 129,869.68 126,794.85
FREDDIE MAC NOTES
DTD 09/25/2020 0.375% 09/23/2025
3137EAEX3 3,400,000.00 AA+ Aaa 09/23/20 09/25/20 3,389,766.00 0.44 2,408.34 3,392,189.84 3,316,173.00
FANNIE MAE NOTES
DTD 11/12/2020 0.500% 11/07/2025
3135G06G3 2,040,000.00 AA+ Aaa 11/19/20 11/24/20 2,039,224.80 0.51 680.00 2,039,384.21 1,996,378.68
FANNIE MAE NOTES
DTD 11/12/2020 0.500% 11/07/2025
3135G06G3 2,215,000.00 AA+ Aaa 11/09/20 11/12/20 2,207,070.30 0.57 738.33 2,208,742.46 2,167,636.66 Security Type Sub-Total 79,810,000.00 79,876,133.83 1.07 268,096.90 79,863,301.19 79,982,051.76 Corporate Note
AMAZON.COM INC BONDS
DTD 06/06/2018 2.400% 02/22/2023
023135AW6 2,335,000.00 AA A1 04/11/19 04/15/19 2,312,513.95 2.66 15,411.00 2,327,850.43 2,384,200.79
TOYOTA MOTOR CREDIT CORP CORP
NOTES
DTD 09/20/2018 3.450% 09/20/2023
89236TFN0 2,230,000.00 A+ A1 11/13/18 11/15/18 2,210,175.30 3.65 15,173.29 2,222,630.14 2,337,300.91
US BANK NA CINCINNATI CORP NOTES
(CALLAB
DTD 02/04/2019 3.375% 02/05/2024
91159HHV5 2,860,000.00 A+ A2 07/19/19 07/23/19 2,995,535.40 2.27 31,102.50 2,923,727.46 3,009,672.38 CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 11
#13..
- 432 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Corporate Note
BANK OF AMERICA CORP NOTE
DTD 03/05/2018 3.550% 03/05/2024
06051GHF9 2,010,000.00 A- A2 09/28/20 09/30/20 2,142,318.30 1.57 17,045.92 2,097,190.57 2,072,941.14
PFIZER INC CORP NOTES
DTD 03/11/2019 2.950% 03/15/2024
717081ES8 3,445,000.00 A+ A2 04/02/19 04/04/19 3,486,374.45 2.69 21,454.69 3,463,755.80 3,597,889.10 AMAZON.COM INC CORPORATE NOTES
DTD 05/12/2021 0.450% 05/12/2024
023135BW5 1,590,000.00 AA A1 05/10/21 05/12/21 1,587,678.60 0.50 377.63 1,588,108.57 1,571,447.88
JP MORGAN CHASE BANK CORP NOTE
DTD 05/13/2014 3.625% 05/13/2024
46625HJX9 1,320,000.00 A- A2 09/22/20 09/24/20 1,461,028.80 0.65 2,392.50 1,415,011.11 1,398,644.28
WALMART INC CORPORATE NOTES
DTD 04/23/2019 2.850% 07/08/2024
931142EL3 4,000,000.00 AA Aa2 07/10/19 07/12/19 4,124,840.00 2.19 45,283.33 4,045,462.49 4,190,840.00
JPMORGAN CHASE & CO CORPORATE
NOTES (CAL
DTD 09/16/2020 0.653% 09/16/2024
46647PBS4 1,405,000.00 A- A2 09/09/20 09/16/20 1,405,000.00 0.65 1,911.39 1,405,000.00 1,397,907.56
PACCAR FINANCIAL CORP CORPORATE
NOTES
DTD 02/06/2020 1.800% 02/06/2025
69371RQ66 1,810,000.00 A+ A1 05/11/20 05/13/20 1,839,014.30 1.45 10,407.50 1,829,504.99 1,840,246.91
NOVARTIS CAPITAL CORP
DTD 02/14/2020 1.750% 02/14/2025
66989HAP3 2,290,000.00 AA- A1 05/07/20 05/11/20 2,378,050.50 0.92 11,911.18 2,348,734.68 2,324,047.72
MASTERCARD INC CORPORATE NOTES
DTD 12/03/2019 2.000% 03/03/2025
57636QAN4 1,760,000.00 A+ A1 05/04/20 05/06/20 1,836,225.60 1.08 8,604.44 1,811,393.88 1,806,397.12
JPMORGAN CHASE & CO CORPORATE
NOTES
DTD 06/01/2021 0.824% 06/01/2025
46647PCH7 865,000.00 A- A2 05/24/21 06/01/21 865,000.00 0.82 3,563.80 865,000.00 855,171.87
BRISTOL-MYERS SQUIBB CO CORPORATE
NOTES
DTD 11/13/2020 0.750% 11/13/2025
110122DN5 2,230,000.00 A+ A2 06/23/21 06/25/21 2,210,888.90 0.95 836.25 2,212,785.69 2,179,227.36
BANK OF NY MELLON CORP (CALLABLE)
CORPOR
DTD 01/28/2021 0.750% 01/28/2026
06406RAQ0 3,465,000.00 A A1 02/02/21 02/04/21 3,465,831.60 0.75 8,879.06 3,465,692.07 3,372,422.13 CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 12
#13..
- 433 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Security Type Sub-Total 33,615,000.00 34,320,475.70 1.70 194,354.48 34,021,847.88 34,338,357.15 Certificate of Deposit
SUMITOMO MITSUI BANK NY CERT DEPOS
DTD 07/14/2020 0.700% 07/08/2022
86565CKU2 1,845,000.00 A-1 P-1 07/10/20 07/14/20 1,845,000.00 0.70 5,237.75 1,845,000.00 1,849,416.93
NORDEA BANK ABP NEW YORK CERT DEPOS
DTD 08/29/2019 1.850% 08/26/2022
65558TLL7 3,440,000.00 A-1+ P-1 08/27/19 08/29/19 3,440,000.00 1.84 17,147.44 3,440,000.00 3,478,208.08
SKANDINAV ENSKILDA BANK LT CD
DTD 09/03/2019 1.860% 08/26/2022
83050PDR7 3,560,000.00 A-1 P-1 08/29/19 09/03/19 3,560,000.00 1.85 17,841.53 3,560,000.00 3,599,804.36
DNB BANK ASA/NY LT CD
DTD 12/06/2019 2.040% 12/02/2022
23341VZT1 1,745,000.00 AA- Aa2 12/05/19 12/06/19 1,745,000.00 2.03 17,996.77 1,745,000.00 1,772,893.83
CREDIT SUISSE NEW YORK CERT DEPOS
DTD 03/23/2021 0.590% 03/17/2023
22552G3C2 1,850,000.00 A+ A1 03/19/21 03/23/21 1,850,000.00 0.59 7,670.82 1,850,000.00 1,852,963.70 Security Type Sub-Total 12,440,000.00 12,440,000.00 1.52 65,894.31 12,440,000.00 12,553,286.90 Asset-Backed Security
HAROT 2019-1 A3
DTD 02/27/2019 2.830% 03/20/2023
43814WAC9 169,574.81 AAA NR 02/19/19 02/27/19 169,570.27 2.83 173.30 169,573.36 170,752.20
HYUNDAI AUTO RECEIVABLES TRUST
DTD 04/10/2019 2.660% 06/15/2023
44932NAD2 264,272.25 AAA NR 04/03/19 04/10/19 264,237.47 2.66 312.43 264,259.47 265,763.01 HAROT 2019-2 A3
DTD 05/29/2019 2.520% 06/21/2023
43815MAC0 492,600.23 NR Aaa 05/21/19 05/29/19 492,581.86 2.52 344.82 492,593.21 496,569.36 TAOT 2019-A A3
DTD 02/13/2019 2.910% 07/15/2023
89239AAD5 606,265.83 AAA Aaa 02/05/19 02/13/19 606,155.37 2.91 784.10 606,225.36 611,701.67 ALLYA 2019-1 A3
DTD 02/13/2019 2.910% 09/15/2023
02004WAC5 202,569.31 NR Aaa 02/05/19 02/13/19 202,544.84 2.91 261.99 202,559.77 203,830.08 NAROT 2019-A A3
DTD 02/13/2019 2.900% 10/15/2023
65479KAD2 482,979.99 NR Aaa 02/05/19 02/13/19 482,906.83 2.90 622.51 482,950.68 487,010.75 COPAR 2019-1 A3
DTD 05/30/2019 2.510% 11/15/2023
14042WAC4 242,452.17 AAA Aaa 05/21/19 05/30/19 242,403.05 2.51 270.47 242,430.65 244,251.17 CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 13
#13..
- 434 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Asset-Backed Security
NAROT 2019-B A3
DTD 05/28/2019 2.500% 11/15/2023
65479HAC1 579,856.72 NR Aaa 05/21/19 05/28/19 579,725.61 2.51 644.29 579,799.36 584,931.39 CARMX 2019-2 A3
DTD 04/17/2019 2.680% 03/15/2024
14316LAC7 398,752.02 AAA NR 04/09/19 04/17/19 398,711.28 2.68 474.96 398,733.06 402,922.17 HAROT 2020-1 A3
DTD 02/26/2020 1.610% 04/22/2024
43813RAC1 1,172,706.46 NR Aaa 02/19/20 02/26/20 1,172,476.61 1.61 524.46 1,172,574.19 1,182,066.65 TAOT 2020-A A3
DTD 02/12/2020 1.660% 05/15/2024
89232HAC9 1,581,804.13 AAA Aaa 02/04/20 02/12/20 1,581,689.92 1.66 1,167.02 1,581,738.28 1,593,671.46 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
14315XAC2 799,245.80 AAA NR 01/14/20 01/22/20 799,088.99 1.89 671.37 799,148.47 807,108.38 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
43813GAC5 650,000.00 NR Aaa 02/17/21 02/24/21 649,988.11 0.27 48.75 649,990.30 647,818.86 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
44933LAC7 510,000.00 AAA NR 04/20/21 04/28/21 509,946.35 0.38 86.13 509,953.62 507,115.85 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
14316NAC3 385,000.00 AAA NR 01/20/21 01/27/21 384,923.92 0.34 58.18 384,937.06 382,904.52 TAOT 2021-C A3
DTD 09/27/2021 0.430% 01/15/2026
89239BAC5 980,000.00 AAA Aaa 09/21/21 09/27/21 979,921.89 0.43 187.29 979,925.12 971,740.17 CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
14314QAC8 770,000.00 AAA NR 04/13/21 04/21/21 769,834.07 0.52 177.96 769,855.15 766,009.01 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
44935FAD6 465,000.00 AAA NR 11/09/21 11/17/21 464,896.21 0.75 133.82 464,897.10 463,408.35 DCENT 2021-A1 A1
DTD 09/27/2021 0.580% 09/15/2026
254683CP8 775,000.00 AAA Aaa 09/20/21 09/27/21 774,834.07 0.58 199.78 774,840.02 763,546.59 Security Type Sub-Total 11,528,079.72 11,526,436.72 1.52 7,143.63 11,526,984.23 11,553,121.64 Managed Account Sub-Total 274,662,265.07 275,214,357.96 1.28 785,584.21 275,079,950.15 276,331,285.64 CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 14
#13..
- 435 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2021 $274,662,265.07 $275,214,357.96 1.28% $785,584.21 $275,079,950.15 $276,331,285.64 $277,116,869.85
$785,584.21
Total Investments
Accrued Interest
Securities Sub-Total
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 15
#13..
- 436 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
U.S. Treasury Bond / Note
US TREASURY NOTES 9128284L1 4,445,000.00 CITIGRP 103.33 4,592,934.93 (80,565.85) (13,267.68) DTD 04/30/2018 2.750% 04/30/2023
1.40 0.39
US TREASURY NOTES 912828VB3 4,300,000.00 BNP_PARI 101.97 4,384,656.25 224,238.28 131,008.68 DTD 05/15/2013 1.750% 05/15/2023
1.45 0.39
US TREASURY NOTES 912828S35 5,100,000.00 MERRILL 101.50 5,176,500.00 328,113.28 166,462.29 DTD 06/30/2016 1.375% 06/30/2023
1.56 0.42
US TREASURY NOTES 912828S92 3,155,000.00 RBC 101.33 3,196,902.19 199,775.43 100,693.02 DTD 08/01/2016 1.250% 07/31/2023
1.65 0.45
US TREASURY NOTES 912828S92 5,625,000.00 NOMURA 101.33 5,699,706.75 312,890.34 166,269.41 DTD 08/01/2016 1.250% 07/31/2023
1.65 0.45
US TREASURY NOTES 9128282D1 1,750,000.00 RBS 101.55 1,777,070.40 53,183.68 38,031.11 DTD 08/31/2016 1.375% 08/31/2023
1.73 0.49
US TREASURY NOTES 9128285D8 2,700,000.00 TD 104.30 2,816,015.76 46,195.45 87,082.78 DTD 10/01/2018 2.875% 09/30/2023
1.79 0.52
US TREASURY NOTES 91282CAW1 3,910,000.00 MERRILL 99.42 3,887,395.51 (21,993.55) (22,134.94) DTD 11/15/2020 0.250% 11/15/2023
1.95 0.55
US TREASURY NOTES 912828WE6 8,790,000.00 TD 104.28 9,166,321.88 287,391.80 339,254.70 DTD 11/15/2013 2.750% 11/15/2023
1.92 0.55
US TREASURY NOTES 912828U57 3,275,000.00 BNP_PARI 103.11 3,376,832.20 160,423.99 125,747.89 DTD 11/30/2016 2.125% 11/30/2023
1.97 0.56
US TREASURY NOTES 9128285U0 270,000.00 MERRILL 104.19 281,306.25 10,504.69 10,966.87 DTD 12/31/2018 2.625% 12/31/2023
2.02 0.60
US TREASURY NOTES 9128286G0 457,000.00 WELLS_F 103.84 474,565.94 (6,105.23) (3,283.00) DTD 02/28/2019 2.375% 02/29/2024
2.19 0.65
US TREASURY NOTES 9128286G0 1,564,000.00 WELLS_F 103.84 1,624,116.25 (20,466.41) (10,858.81) DTD 02/28/2019 2.375% 02/29/2024
2.19 0.65
US TREASURY N/B NOTES 91282CBV2 4,890,000.00 BARCLAY 99.25 4,853,325.00 (40,304.30) (39,582.47) DTD 04/15/2021 0.375% 04/15/2024
2.36 0.69
US TREASURY NOTES 9128282N9 2,450,000.00 TD 103.59 2,538,046.88 48,904.30 67,132.15 DTD 07/31/2017 2.125% 07/31/2024
2.59 0.76
US TREASURY NOTES 9128282U3 1,630,000.00 MERRILL 102.95 1,678,135.86 5,921.41 24,873.89 DTD 08/31/2017 1.875% 08/31/2024
2.68 0.79
US TREASURY NOTES 9128282Y5 1,850,000.00 HSBC 103.70 1,918,507.72 13,224.52 37,168.45 DTD 10/02/2017 2.125% 09/30/2024
2.76 0.80
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 16
#13..
- 437 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
U.S. Treasury Bond / Note
US TREASURY NOTES 9128283D0 460,000.00 MORGAN_S 104.09 478,831.25 3,791.41 10,040.13 DTD 10/31/2017 2.250% 10/31/2024
2.84 0.83
US TREASURY NOTES 9128283J7 1,215,000.00 NOMURA 103.78 1,260,942.19 20,977.74 30,947.09 DTD 11/30/2017 2.125% 11/30/2024
2.92 0.85
US TREASURY NOTES 9128283J7 3,450,000.00 RBS 103.78 3,580,453.13 50,537.11 81,538.63 DTD 11/30/2017 2.125% 11/30/2024
2.92 0.85
US TREASURY NOTES 9128283J7 4,585,000.00 HSBC 103.78 4,758,370.31 (90,446.29) (47,148.15) DTD 11/30/2017 2.125% 11/30/2024
2.92 0.85
US TREASURY NOTES 912828ZL7 4,945,000.00 JPM_CHA 98.05 4,848,418.22 (46,359.12) (53,749.86) DTD 04/30/2020 0.375% 04/30/2025
3.40 0.96
US TREASURY NOTES 91282CAJ0 4,340,000.00 WELLS_F 97.16 4,216,581.25 (74,932.81) (78,750.34) DTD 08/31/2020 0.250% 08/31/2025
3.73 1.03
US TREASURY NOTES 91282CAM3 1,100,000.00 BNP_PAR 97.13 1,068,375.00 (7,648.44) (8,697.31) DTD 09/30/2020 0.250% 09/30/2025
3.81 1.02
US TREASURY NOTES 91282CAM3 4,550,000.00 HSBC 97.13 4,419,187.50 (54,386.72) (58,666.98) DTD 09/30/2020 0.250% 09/30/2025
3.81 1.02
US TREASURY NOTES 91282CAT8 5,010,000.00 HSBC 96.94 4,856,568.75 (37,770.70) (52,887.43) DTD 10/31/2020 0.250% 10/31/2025
3.90 1.05
US TREASURY NOTES 91282CAT8 6,930,000.00 TD 96.94 6,717,768.75 (65,510.16) (71,039.35) DTD 10/31/2020 0.250% 10/31/2025
3.90 1.05
US TREASURY NOTES 91282CAZ4 4,250,000.00 WELLS_F 97.28 4,134,453.13 1,162.11 (1,110.93) DTD 11/30/2020 0.375% 11/30/2025
3.97 1.07
US TREASURY NOTES 91282CBC4 500,000.00 HSBC 97.22 486,093.75 (12,519.53) (12,751.81) DTD 12/31/2020 0.375% 12/31/2025
4.05 1.07
US TREASURY NOTES 91282CBC4 1,040,000.00 CITIGRP 97.22 1,011,075.00 (24,903.13) (25,626.54) DTD 12/31/2020 0.375% 12/31/2025
4.05 1.07
US TREASURY NOTES 91282CBC4 3,735,000.00 JPM_CHA 97.22 3,631,120.31 (15,319.34) (27,509.83) DTD 12/31/2020 0.375% 12/31/2025
4.05 1.07
US TREASURY NOTES 91282CBH3 2,400,000.00 BNP_PAR 97.09 2,330,250.00 (23,625.00) (27,687.54) DTD 01/31/2021 0.375% 01/31/2026
4.13 1.09
US TREASURY NOTES 9128286F2 3,210,000.00 GOLDMAN 105.84 3,397,584.38 (95,296.87) (52,670.93) DTD 02/28/2019 2.500% 02/28/2026
4.04 1.09
US TREASURY N/B NOTES 91282CBT7 2,480,000.00 WELLS_F 98.50 2,442,800.00 (36,231.25) (36,279.57) DTD 03/31/2021 0.750% 03/31/2026
4.27 1.11
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 17
#13..
- 438 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
U.S. Treasury Bond / Note
US TREASURY N/B NOTES 91282CBT7 4,925,000.00 MORGAN_ 98.50 4,851,125.00 (45,594.73) (48,980.17) DTD 03/31/2021 0.750% 03/31/2026
4.27 1.11
US TREASURY N/B NOTES 91282CCF6 2,260,000.00 MERRILL 98.38 2,223,275.00 (23,835.94) (24,973.84) DTD 05/31/2021 0.750% 05/31/2026
4.43 1.12
US TREASURY N/B NOTES 91282CCF6 2,325,000.00 RBC 98.38 2,287,218.75 (32,513.67) (33,026.24) DTD 05/31/2021 0.750% 05/31/2026
4.43 1.12
Security Type Sub-Total 119,871,000.00 120,442,831.44 910,906.50 666,533.37 2.89 0.79 Supra-National Agency Bond / Note
INTL BK RECON & DEVELOP NOTES 459058JM6 1,790,000.00 TD 99.15 1,774,724.14 (11,427.36) (12,734.80) DTD 11/24/2020 0.250% 11/24/2023
1.98 0.68
INTER-AMERICAN DEVEL BK NOTES 4581X0DZ8 4,095,000.00 JPM_CHA 98.79 4,045,647.06 (46,322.64) (46,513.42) DTD 09/23/2021 0.500% 09/23/2024
2.80 0.93
Security Type Sub-Total 5,885,000.00 5,820,371.20 (57,750.00) (59,248.22) 2.55 0.85 Municipal Bond / Note
CA ST TXBL GO BONDS 13063DRJ9 2,310,000.00 MORGAN_S 103.50 2,390,896.20 34,673.10 59,391.85 DTD 10/24/2019 2.400% 10/01/2023
1.80 0.48
MD ST TXBL GO BONDS 574193TQ1 620,000.00 JPM_CHA 99.57 617,352.60 (2,473.80) (2,531.35) DTD 08/05/2020 0.510% 08/01/2024
2.65 0.67
CA ST UNIV TXBL REV BONDS 13077DMK5 600,000.00 GOLDMAN 99.38 596,298.00 (3,702.00) (3,702.00) DTD 09/17/2020 0.685% 11/01/2024
2.89 0.90
CA ST DEPT WTR RES WTR SYS TXBL REV 13067WRB0 100,000.00 MORGAN_ 99.21 99,214.00 (786.00) (786.00) BNDS
DTD 08/06/2020 0.560% 12/01/2024
2.97 0.83
UNIV OF CAL TXBL REV BONDS 91412HGE7 220,000.00 JPM_CHA 04/15/25 99.17 218,165.20 (2,631.20) (2,400.18) DTD 07/16/2020 0.883% 05/15/2025
3.33 1.13
UNIV OF CAL TXBL REV BONDS 91412HGE7 510,000.00 JPM_CHA 04/15/25 99.17 505,746.60 (4,253.40) (4,253.40) DTD 07/16/2020 0.883% 05/15/2025
3.33 1.13
FL ST BOARD OF ADMIN TXBL REV BONDS 341271AD6 505,000.00 MERRILL 100.01 505,035.35 (3,535.00) (2,634.76) DTD 09/16/2020 1.258% 07/01/2025
3.50 1.26
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 18
#13..
- 439 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Municipal Bond / Note
FL ST BOARD OF ADMIN TXBL REV BONDS 341271AD6 1,295,000.00 MERRILL 100.01 1,295,090.65 90.65 90.65 DTD 09/16/2020 1.258% 07/01/2025
3.50 1.26
LOS ANGELES CCD, CA TXBL GO BONDS 54438CYK2 925,000.00 MERRILL 98.94 915,185.75 (9,814.25) (9,814.25) DTD 11/10/2020 0.773% 08/01/2025
3.62 1.07
NJ TURNPIKE AUTHORITY TXBL REV 646140DP5 505,000.00 CITIGRP 98.88 499,338.95 (5,661.05) (5,661.05) BONDS
DTD 02/04/2021 1.047% 01/01/2026
3.99 1.33
Security Type Sub-Total 7,590,000.00 7,642,323.30 1,907.05 27,699.51 2.88 0.90 Federal Agency Commercial Mortgage-Backed Security
FHLMC MULTIFAMILY STRUCTURED P 3137BHXY8 542,850.82 JPM_CHAS 100.18 543,836.82 (2,406.82) 875.98 DTD 05/01/2015 2.791% 01/01/2022
0.11 0.68
FHLMC MULTIFAMILY STRUCTURED P 3137BLUR7 934,437.28 JPM_CHAS 100.59 939,968.97 3,195.59 5,162.94 DTD 11/01/2015 2.716% 06/01/2022
0.36 1.53
FHLMC MULTIFAMILY STRUCTURED P 3137AWQH1 1,080,000.00 CANT_FIT 101.03 1,091,132.01 (4,814.87) 7,465.89 DTD 12/01/2012 2.307% 08/01/2022
0.67 0.76
FANNIEMAE-ACES 3136AJB54 1,152,273.42 JPM_CHAS 104.76 1,207,163.39 (1,103.31) 24,941.77 DTD 04/01/2014 3.346% 03/01/2024
2.10 1.20
FHMS KJ27 A1 3137FQ3V3 213,623.83 JPM_CHAS 101.51 216,841.06 3,222.34 3,220.10 DTD 11/01/2019 2.092% 07/01/2024
1.16 1.50
Security Type Sub-Total 3,923,185.35 3,998,942.25 (1,907.07) 41,666.68 0.98 1.10 Federal Agency Bond / Note
FREDDIE MAC NOTES 3137EAER6 4,000,000.00 DEUTSCH 99.97 3,998,852.00 (20,748.00) (11,299.39) DTD 05/07/2020 0.375% 05/05/2023
1.43 0.40
FANNIE MAE NOTES 3135G04Q3 3,660,000.00 CITIGRP 99.79 3,652,193.22 3,209.82 (2,404.12) DTD 05/22/2020 0.250% 05/22/2023
1.48 0.39
FREDDIE MAC NOTES 3137EAEN5 3,615,000.00 MORGAN_S 103.59 3,744,698.97 104,321.67 120,859.16 DTD 06/11/2018 2.750% 06/19/2023
1.51 0.43
FREDDIE MAC NOTES 3137EAEN5 4,170,000.00 CITIGRP 103.59 4,319,611.26 205,155.66 168,213.86 DTD 06/11/2018 2.750% 06/19/2023
1.51 0.43
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 19
#13..
- 440 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Federal Agency Bond / Note
FREDDIE MAC NOTES 3137EAES4 3,315,000.00 TD 99.73 3,305,926.85 606.65 (4,016.67) DTD 06/26/2020 0.250% 06/26/2023
1.57 0.42
FANNIE MAE NOTES 3135G05G4 3,395,000.00 CITIGRP 99.66 3,383,307.62 (4,393.13) (7,786.11) DTD 07/10/2020 0.250% 07/10/2023
1.61 0.46
FREDDIE MAC NOTES 3137EAEV7 2,200,000.00 CITIGRP 99.58 2,190,718.20 (7,037.80) (7,992.22) DTD 08/21/2020 0.250% 08/24/2023
1.73 0.49
FANNIE MAE NOTES 3135G0U43 3,745,000.00 JPM_CHAS 104.18 3,901,421.16 201,810.56 173,108.44 DTD 09/14/2018 2.875% 09/12/2023
1.74 0.52
FANNIE MAE NOTES 3135G0U43 5,665,000.00 TD 104.18 5,901,615.72 248,059.02 240,888.06 DTD 09/14/2018 2.875% 09/12/2023
1.74 0.52
FEDERAL FARM CREDIT BANK (CALLABLE) 3133EMAM4 2,345,000.00 TD 09/21/22 99.47 2,332,456.60 (8,556.90) (10,104.12) DTD 09/21/2020 0.250% 09/21/2023
0.81 0.55
FANNIE MAE NOTES 3135G06H1 900,000.00 MORGAN_ 99.36 894,221.10 (7,146.90) (6,738.48) DTD 11/25/2020 0.250% 11/27/2023
1.99 0.57
FREDDIE MAC NOTES 3137EAFA2 2,015,000.00 CITIGRP 99.31 2,001,136.80 (11,868.35) (12,527.83) DTD 12/04/2020 0.250% 12/04/2023
2.00 0.59
FEDERAL HOME LOAN BANKS NOTES 3130A0F70 2,025,000.00 BARCLAYS 105.57 2,137,828.95 53,144.32 88,005.26 DTD 12/09/2013 3.375% 12/08/2023
1.94 0.60
FANNIE MAE NOTES 3135G0X24 3,500,000.00 CITIGRP 102.16 3,575,687.50 (52,447.50) (6,379.74) DTD 01/10/2020 1.625% 01/07/2025
3.02 0.92
FREDDIE MAC NOTES 3137EAEP0 640,000.00 WELLS_FA 101.77 651,345.28 1,668.48 5,098.91 DTD 02/14/2020 1.500% 02/12/2025
3.12 0.94
FEDERAL HOME LOAN BANK NOTES 3130AJHU6 2,370,000.00 CITIGRP 98.46 2,333,487.78 (24,757.02) (28,585.19) DTD 04/16/2020 0.500% 04/14/2025
3.35 0.97
FANNIE MAE NOTES 3135G03U5 475,000.00 WELLS_F 98.87 469,611.13 (6,120.37) (5,887.00) DTD 04/24/2020 0.625% 04/22/2025
3.36 0.97
FANNIE MAE NOTES 3135G03U5 1,910,000.00 HSBC 98.87 1,888,331.05 (31,448.15) (28,462.80) DTD 04/24/2020 0.625% 04/22/2025
3.36 0.97
FANNIE MAE NOTES 3135G03U5 3,195,000.00 CITIGRP 98.87 3,158,752.73 (29,665.57) (31,780.09) DTD 04/24/2020 0.625% 04/22/2025
3.36 0.97
FANNIE MAE NOTES 3135G03U5 3,345,000.00 WELLS_F 98.87 3,307,050.97 (40,424.33) (39,638.35) DTD 04/24/2020 0.625% 04/22/2025
3.36 0.97
FANNIE MAE NOTES 3135G04Z3 200,000.00 WELLS_F 98.14 196,280.20 (4,431.80) (4,251.44) DTD 06/19/2020 0.500% 06/17/2025
3.51 1.04
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 20
#13..
- 441 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Federal Agency Bond / Note
FANNIE MAE NOTES 3135G04Z3 1,075,000.00 NOMURA 98.14 1,055,006.07 (25,035.68) (23,795.81) DTD 06/19/2020 0.500% 06/17/2025
3.51 1.04
FANNIE MAE NOTES 3135G04Z3 1,190,000.00 RBS 98.14 1,167,867.19 (29,356.11) (27,888.32) DTD 06/19/2020 0.500% 06/17/2025
3.51 1.04
FANNIE MAE NOTES 3135G04Z3 3,675,000.00 NOMURA 98.14 3,606,648.68 (60,744.07) (62,954.51) DTD 06/19/2020 0.500% 06/17/2025
3.51 1.04
FANNIE MAE NOTES 3135G04Z3 3,820,000.00 RBS 98.14 3,748,951.82 (87,359.58) (83,348.27) DTD 06/19/2020 0.500% 06/17/2025
3.51 1.04
FREDDIE MAC NOTES 3137EAEU9 2,220,000.00 WELLS_F 97.78 2,170,818.12 (38,126.28) (41,132.63) DTD 07/23/2020 0.375% 07/21/2025
3.61 1.00
FANNIE MAE NOTES 3135G05X7 450,000.00 NOMURA 97.66 439,452.00 (8,028.00) (8,604.16) DTD 08/27/2020 0.375% 08/25/2025
3.71 1.02
FANNIE MAE NOTES 3135G05X7 550,000.00 CITIGRP 97.66 537,108.00 (11,181.50) (11,577.79) DTD 08/27/2020 0.375% 08/25/2025
3.71 1.02
FANNIE MAE NOTES 3135G05X7 2,360,000.00 BARCLAY 97.66 2,304,681.60 (44,273.60) (47,065.08) DTD 08/27/2020 0.375% 08/25/2025
3.71 1.02
FREDDIE MAC NOTES 3137EAEX3 130,000.00 WELLS_F 97.53 126,794.85 (3,034.85) (3,074.83) DTD 09/25/2020 0.375% 09/23/2025
3.79 1.04
FREDDIE MAC NOTES 3137EAEX3 3,400,000.00 CITIGRP 97.53 3,316,173.00 (73,593.00) (76,016.84) DTD 09/25/2020 0.375% 09/23/2025
3.79 1.04
FANNIE MAE NOTES 3135G06G3 2,040,000.00 NOMURA 97.86 1,996,378.68 (42,846.12) (43,005.53) DTD 11/12/2020 0.500% 11/07/2025
3.90 1.06
FANNIE MAE NOTES 3135G06G3 2,215,000.00 BARCLAY 97.86 2,167,636.66 (39,433.64) (41,105.80) DTD 11/12/2020 0.500% 11/07/2025
3.90 1.06
Security Type Sub-Total 79,810,000.00 79,982,051.76 105,917.93 118,750.57 2.51 0.73 Corporate Note
AMAZON.COM INC BONDS 023135AW6 2,335,000.00 DAIWA 102.11 2,384,200.79 71,686.84 56,350.36 DTD 06/06/2018 2.400% 02/22/2023
1.21 0.67
TOYOTA MOTOR CREDIT CORP CORP 89236TFN0 2,230,000.00 JPM_CHAS 104.81 2,337,300.91 127,125.61 114,670.77 NOTES
DTD 09/20/2018 3.450% 09/20/2023
1.76 0.76
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 21
#13..
- 442 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Corporate Note
US BANK NA CINCINNATI CORP NOTES 91159HHV5 2,860,000.00 GOLDMAN 01/05/24 105.23 3,009,672.38 14,136.98 85,944.92 (CALLAB
DTD 02/04/2019 3.375% 02/05/2024
2.02 0.94
BANK OF AMERICA CORP NOTE 06051GHF9 2,010,000.00 MERRILL 103.13 2,072,941.14 (69,377.16) (24,249.43) DTD 03/05/2018 3.550% 03/05/2024
2.18 2.12
PFIZER INC CORP NOTES 717081ES8 3,445,000.00 BONY 02/15/24 104.44 3,597,889.10 111,514.65 134,133.30 DTD 03/11/2019 2.950% 03/15/2024
2.14 0.99
AMAZON.COM INC CORPORATE NOTES 023135BW5 1,590,000.00 JPM_CHA 98.83 1,571,447.88 (16,230.72) (16,660.69) DTD 05/12/2021 0.450% 05/12/2024
2.44 0.93
JP MORGAN CHASE BANK CORP NOTE 46625HJX9 1,320,000.00 JPM_CHA 105.96 1,398,644.28 (62,384.52) (16,366.83) DTD 05/13/2014 3.625% 05/13/2024
2.37 1.15
WALMART INC CORPORATE NOTES 931142EL3 4,000,000.00 CITIGRP 04/15/23 104.77 4,190,840.00 66,000.00 145,377.51 DTD 04/23/2019 2.850% 07/08/2024
1.34 0.99
JPMORGAN CHASE & CO CORPORATE 46647PBS4 1,405,000.00 JPM_CHA 09/16/23 99.50 1,397,907.56 (7,092.44) (7,092.44)
NOTES (CAL
DTD 09/16/2020 0.653% 09/16/2024
1.78 0.84
PACCAR FINANCIAL CORP CORPORATE 69371RQ66 1,810,000.00 MITSU 101.67 1,840,246.91 1,232.61 10,741.92 NOTES
DTD 02/06/2020 1.800% 02/06/2025
3.09 1.26
NOVARTIS CAPITAL CORP 66989HAP3 2,290,000.00 CITIGRP 01/14/25 101.49 2,324,047.72 (54,002.78) (24,686.96) DTD 02/14/2020 1.750% 02/14/2025
3.04 1.27
MASTERCARD INC CORPORATE NOTES 57636QAN4 1,760,000.00 JSEB 102.64 1,806,397.12 (29,828.48) (4,996.76) DTD 12/03/2019 2.000% 03/03/2025
3.16 1.17
JPMORGAN CHASE & CO CORPORATE 46647PCH7 865,000.00 JPM_CHA 98.86 855,171.87 (9,828.13) (9,828.13) NOTES
DTD 06/01/2021 0.824% 06/01/2025
3.44 1.16
BRISTOL-MYERS SQUIBB CO CORPORATE 110122DN5 2,230,000.00 MERRILL 10/13/25 97.72 2,179,227.36 (31,661.54) (33,558.33) NOTES
DTD 11/13/2020 0.750% 11/13/2025
3.82 1.34
BANK OF NY MELLON CORP (CALLABLE) 06406RAQ0 3,465,000.00 US_BANC 12/28/25 97.33 3,372,422.13 (93,409.47) (93,269.94) CORPOR
DTD 01/28/2021 0.750% 01/28/2026
4.01 1.41
Security Type Sub-Total 33,615,000.00 34,338,357.15 17,881.45 316,509.27 2.44 1.12 CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 22
#13..
- 443 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Certificate of Deposit
SUMITOMO MITSUI BANK NY CERT DEPOS 86565CKU2 1,845,000.00 SMBC 100.24 1,849,416.93 4,416.93 4,416.93 DTD 07/14/2020 0.700% 07/08/2022
0.61 0.29
NORDEA BANK ABP NEW YORK CERT 65558TLL7 3,440,000.00 MERRILL 101.11 3,478,208.08 38,208.08 38,208.08 DEPOS
DTD 08/29/2019 1.850% 08/26/2022
0.74 0.33
SKANDINAV ENSKILDA BANK LT CD 83050PDR7 3,560,000.00 BARCLAYS 101.12 3,599,804.36 39,804.36 39,804.36 DTD 09/03/2019 1.860% 08/26/2022
0.74 0.33
DNB BANK ASA/NY LT CD 23341VZT1 1,745,000.00 GOLDMAN 101.60 1,772,893.83 27,893.83 27,893.83 DTD 12/06/2019 2.040% 12/02/2022
0.99 0.43
CREDIT SUISSE NEW YORK CERT DEPOS 22552G3C2 1,850,000.00 CSFB 100.16 1,852,963.70 2,963.70 2,963.70 DTD 03/23/2021 0.590% 03/17/2023
1.29 0.46
Security Type Sub-Total 12,440,000.00 12,553,286.90 113,286.90 113,286.90 0.84 0.36 Asset-Backed Security
HAROT 2019-1 A3 43814WAC9 169,574.81 MERRILL 100.69 170,752.20 1,181.93 1,178.84 DTD 02/27/2019 2.830% 03/20/2023
0.29 2.29
HYUNDAI AUTO RECEIVABLES TRUST 44932NAD2 264,272.25 SOCGEN 100.56 265,763.01 1,525.54 1,503.54 DTD 04/10/2019 2.660% 06/15/2023
0.25 2.29
HAROT 2019-2 A3 43815MAC0 492,600.23 JPM_CHAS 100.81 496,569.36 3,987.50 3,976.15 DTD 05/29/2019 2.520% 06/21/2023
0.38 1.99
TAOT 2019-A A3 89239AAD5 606,265.83 MITSU 100.90 611,701.67 5,546.30 5,476.31 DTD 02/13/2019 2.910% 07/15/2023
0.37 2.35
ALLYA 2019-1 A3 02004WAC5 202,569.31 JPM_CHAS 100.62 203,830.08 1,285.24 1,270.31 DTD 02/13/2019 2.910% 09/15/2023
0.28 2.55
NAROT 2019-A A3 65479KAD2 482,979.99 MITSU 100.83 487,010.75 4,103.92 4,060.07 DTD 02/13/2019 2.900% 10/15/2023
0.32 2.44
COPAR 2019-1 A3 14042WAC4 242,452.17 JPM_CHAS 100.74 244,251.17 1,848.12 1,820.52 DTD 05/30/2019 2.510% 11/15/2023
0.37 2.12
NAROT 2019-B A3 65479HAC1 579,856.72 WELLS_FA 100.88 584,931.39 5,205.78 5,132.03 DTD 05/28/2019 2.500% 11/15/2023
0.42 2.04
CARMX 2019-2 A3 14316LAC7 398,752.02 RBC 101.05 402,922.17 4,210.89 4,189.11 DTD 04/17/2019 2.680% 03/15/2024
0.45 2.21
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 23
#13..
- 444 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2021 Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Asset-Backed Security
HAROT 2020-1 A3 43813RAC1 1,172,706.46 JPM_CHAS 100.80 1,182,066.65 9,590.04 9,492.46 DTD 02/26/2020 1.610% 04/22/2024
0.67 1.27
TAOT 2020-A A3 89232HAC9 1,581,804.13 MITSU 100.75 1,593,671.46 11,981.54 11,933.18 DTD 02/12/2020 1.660% 05/15/2024
0.59 1.35
CARMX 2020-1 A3 14315XAC2 799,245.80 MERRILL 100.98 807,108.38 8,019.39 7,959.91 DTD 01/22/2020 1.890% 12/16/2024
0.72 1.56
HAROT 2021-1 A3 43813GAC5 650,000.00 JPM_CHA 99.66 647,818.86 (2,169.25) (2,171.44) DTD 02/24/2021 0.270% 04/21/2025
1.26 0.37
HART 2021-A A3 44933LAC7 510,000.00 BARCLAY 99.43 507,115.85 (2,830.50) (2,837.77) DTD 04/28/2021 0.380% 09/15/2025
1.62 0.53
CARMX 2021-1 A3 14316NAC3 385,000.00 MITSU 99.46 382,904.52 (2,019.40) (2,032.54) DTD 01/27/2021 0.340% 12/15/2025
1.28 0.48
TAOT 2021-C A3 89239BAC5 980,000.00 BARCLAY 99.16 971,740.17 (8,181.72) (8,184.95) DTD 09/27/2021 0.430% 01/15/2026
2.07 0.64
CARMX 2021-2 A3 14314QAC8 770,000.00 MERRILL 99.48 766,009.01 (3,825.06) (3,846.14) DTD 04/21/2021 0.520% 02/17/2026
1.39 0.64
HART 2021-C A3 44935FAD6 465,000.00 SMBC 99.66 463,408.35 (1,487.86) (1,488.75) DTD 11/17/2021 0.740% 05/15/2026
2.24 0.82
DCENT 2021-A1 A1 254683CP8 775,000.00 CITIGRP 98.52 763,546.59 (11,287.48) (11,293.43) DTD 09/27/2021 0.580% 09/15/2026
2.77 0.90
Security Type Sub-Total 11,528,079.72 11,553,121.64 26,684.92 26,137.41 1.03 1.34 Managed Account Sub-Total 274,662,265.07 276,331,285.64 1,116,927.68 1,251,335.49 2.52 0.83 Total Investments $277,116,869.85
$785,584.21
$276,331,285.64
Accrued Interest
Securities Sub-Total $274,662,265.07 $1,116,927.68 $1,251,335.49 2.52 0.83% CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 24
#13..
- 445 -
Managed Account Security Transactions & Interest For the Month Ending November 30, 2021 Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
BUY
11/02/21 US TREASURY NOTES
DTD 11/30/2020 0.375% 11/30/2025
11/01/21 91282CAZ4 4,250,000.00 (4,133,291.02) (6,749.49) (4,140,040.51) 11/17/21 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
11/09/21 44935FAD6 465,000.00 (464,896.21) 0.00 (464,896.21) Transaction Type Sub-Total 4,715,000.00 (4,598,187.23) (6,749.49) (4,604,936.72)
INTEREST
11/01/21 CA ST UNIV TXBL REV BONDS
DTD 09/17/2020 0.685% 11/01/2024
11/01/21 13077DMK5 600,000.00 0.00 2,055.00 2,055.00
11/01/21 11/01/21 MONEY MARKET FUND MONEY0002 0.00 0.00 11.26 11.26 11/25/21 FHLMC MULTIFAMILY STRUCTURED P
DTD 11/01/2015 2.716% 06/01/2022
11/01/21 3137BLUR7 957,300.99 0.00 2,166.69 2,166.69
11/25/21 FHMS KJ27 A1
DTD 11/01/2019 2.092% 07/01/2024
11/01/21 3137FQ3V3 214,299.37 0.00 373.60 373.60
11/25/21 FHLMC MULTIFAMILY STRUCTURED P
DTD 12/01/2012 2.307% 08/01/2022
11/01/21 3137AWQH1 1,080,000.00 0.00 2,076.30 2,076.30
11/25/21 FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
11/01/21 3136AJB54 1,154,514.83 0.00 3,219.17 3,219.17
11/25/21 FHLMC MULTIFAMILY STRUCTURED P
DTD 05/01/2015 2.791% 01/01/2022
11/01/21 3137BHXY8 926,635.26 0.00 2,155.20 2,155.20
11/05/21 FREDDIE MAC NOTES
DTD 05/07/2020 0.375% 05/05/2023
11/05/21 3137EAER6 4,000,000.00 0.00 7,500.00 7,500.00
11/07/21 FANNIE MAE NOTES
DTD 11/12/2020 0.500% 11/07/2025
11/07/21 3135G06G3 4,255,000.00 0.00 10,637.50 10,637.50 11/12/21 AMAZON.COM INC CORPORATE NOTES
DTD 05/12/2021 0.450% 05/12/2024
11/12/21 023135BW5 1,590,000.00 0.00 3,577.50 3,577.50
11/13/21 JP MORGAN CHASE BANK CORP NOTE
DTD 05/13/2014 3.625% 05/13/2024
11/13/21 46625HJX9 1,320,000.00 0.00 23,925.00 23,925.00 11/13/21 BRISTOL-MYERS SQUIBB CO
CORPORATE NOTES
DTD 11/13/2020 0.750% 11/13/2025
11/13/21 110122DN5 2,230,000.00 0.00 8,362.50 8,362.50
11/15/21 CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
11/15/21 14314QAC8 770,000.00 0.00 333.67 333.67
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 25
#13..
- 446 -
Managed Account Security Transactions & Interest For the Month Ending November 30, 2021 Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
INTEREST
11/15/21 TAOT 2019-A A3
DTD 02/13/2019 2.910% 07/15/2023
11/15/21 89239AAD5 681,805.12 0.00 1,653.38 1,653.38
11/15/21 US TREASURY NOTES
DTD 11/15/2013 2.750% 11/15/2023
11/15/21 912828WE6 8,790,000.00 0.00 120,862.50 120,862.50 11/15/21 UNIV OF CAL TXBL REV BONDS
DTD 07/16/2020 0.883% 05/15/2025
11/15/21 91412HGE7 730,000.00 0.00 3,222.95 3,222.95
11/15/21 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
11/15/21 44933LAC7 510,000.00 0.00 161.50 161.50
11/15/21 ALLYA 2019-1 A3
DTD 02/13/2019 2.910% 09/15/2023
11/15/21 02004WAC5 235,431.82 0.00 570.92 570.92
11/15/21 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
11/15/21 14315XAC2 815,000.00 0.00 1,283.63 1,283.63
11/15/21 CARMX 2019-2 A3
DTD 04/17/2019 2.680% 03/15/2024
11/15/21 14316LAC7 437,842.70 0.00 977.85 977.85
11/15/21 TAOT 2020-A A3
DTD 02/12/2020 1.660% 05/15/2024
11/15/21 89232HAC9 1,702,856.00 0.00 2,355.62 2,355.62
11/15/21 NAROT 2019-B A3
DTD 05/28/2019 2.500% 11/15/2023
11/15/21 65479HAC1 640,606.84 0.00 1,334.60 1,334.60
11/15/21 NAROT 2019-A A3
DTD 02/13/2019 2.900% 10/15/2023
11/15/21 65479KAD2 547,383.41 0.00 1,322.84 1,322.84
11/15/21 US TREASURY NOTES
DTD 11/15/2020 0.250% 11/15/2023
11/15/21 91282CAW1 3,910,000.00 0.00 4,887.50 4,887.50
11/15/21 HYUNDAI AUTO RECEIVABLES TRUST
DTD 04/10/2019 2.660% 06/15/2023
11/15/21 44932NAD2 313,880.40 0.00 695.77 695.77
11/15/21 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
11/15/21 14316NAC3 385,000.00 0.00 109.08 109.08
11/15/21 COPAR 2019-1 A3
DTD 05/30/2019 2.510% 11/15/2023
11/15/21 14042WAC4 273,152.40 0.00 571.34 571.34
11/15/21 TAOT 2021-C A3
DTD 09/27/2021 0.430% 01/15/2026
11/15/21 89239BAC5 980,000.00 0.00 351.17 351.17
11/15/21 US TREASURY NOTES
DTD 05/15/2013 1.750% 05/15/2023
11/15/21 912828VB3 4,300,000.00 0.00 37,625.00 37,625.00 11/15/21 DCENT 2021-A1 A1
DTD 09/27/2021 0.580% 09/15/2026
11/15/21 254683CP8 775,000.00 0.00 374.58 374.58
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 26
#13..
- 447 -
Managed Account Security Transactions & Interest For the Month Ending November 30, 2021 Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
INTEREST
11/18/21 HAROT 2019-1 A3
DTD 02/27/2019 2.830% 03/20/2023
11/18/21 43814WAC9 197,549.92 0.00 465.89 465.89
11/21/21 HAROT 2020-1 A3
DTD 02/26/2020 1.610% 04/22/2024
11/21/21 43813RAC1 1,250,000.00 0.00 1,677.08 1,677.08
11/21/21 HAROT 2019-2 A3
DTD 05/29/2019 2.520% 06/21/2023
11/21/21 43815MAC0 554,219.00 0.00 1,163.86 1,163.86
11/21/21 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
11/21/21 43813GAC5 650,000.00 0.00 146.25 146.25
11/22/21 FANNIE MAE NOTES
DTD 05/22/2020 0.250% 05/22/2023
11/22/21 3135G04Q3 3,660,000.00 0.00 4,575.00 4,575.00
11/24/21 INTL BK RECON & DEVELOP NOTES
DTD 11/24/2020 0.250% 11/24/2023
11/24/21 459058JM6 1,790,000.00 0.00 2,237.50 2,237.50
11/27/21 FANNIE MAE NOTES
DTD 11/25/2020 0.250% 11/27/2023
11/27/21 3135G06H1 900,000.00 0.00 1,125.00 1,125.00
11/30/21 US TREASURY NOTES
DTD 11/30/2020 0.375% 11/30/2025
11/30/21 91282CAZ4 4,250,000.00 0.00 7,968.75 7,968.75
11/30/21 US TREASURY N/B NOTES
DTD 05/31/2021 0.750% 05/31/2026
11/30/21 91282CCF6 4,585,000.00 0.00 17,193.75 17,193.75 11/30/21 US TREASURY NOTES
DTD 11/30/2016 2.125% 11/30/2023
11/30/21 912828U57 3,275,000.00 0.00 34,796.88 34,796.88 11/30/21 US TREASURY NOTES
DTD 11/30/2017 2.125% 11/30/2024
11/30/21 9128283J7 9,250,000.00 0.00 98,281.25 98,281.25 Transaction Type Sub-Total 75,487,478.06 0.00 414,384.83 414,384.83
PAYDOWNS
11/25/21 FHLMC MULTIFAMILY STRUCTURED P
DTD 11/01/2015 2.716% 06/01/2022
11/01/21 3137BLUR7 22,863.71 22,863.71 0.00 22,863.71 (57.16) 0.00 11/25/21 FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
11/01/21 3136AJB54 2,241.41 2,241.41 0.00 2,241.41 (108.92) 0.00 11/25/21 FHLMC MULTIFAMILY STRUCTURED P
DTD 05/01/2015 2.791% 01/01/2022
11/01/21 3137BHXY8 383,784.44 383,784.44 0.00 383,784.44 (2,398.66) 0.00 11/25/21 FHMS KJ27 A1
DTD 11/01/2019 2.092% 07/01/2024
11/01/21 3137FQ3V3 675.54 675.54 0.00 675.54 0.02 0.00
CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 27
#13..
- 448 -
Managed Account Security Transactions & Interest For the Month Ending November 30, 2021 Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
PAYDOWNS
11/15/21 CARMX 2019-2 A3
DTD 04/17/2019 2.680% 03/15/2024
11/15/21 14316LAC7 39,090.68 39,090.68 0.00 39,090.68 3.99 0.00 11/15/21 ALLYA 2019-1 A3
DTD 02/13/2019 2.910% 09/15/2023
11/15/21 02004WAC5 32,862.51 32,862.51 0.00 32,862.51 3.97 0.00 11/15/21 HYUNDAI AUTO RECEIVABLES TRUST
DTD 04/10/2019 2.660% 06/15/2023
11/15/21 44932NAD2 49,608.15 49,608.15 0.00 49,608.15 6.53 0.00 11/15/21 COPAR 2019-1 A3
DTD 05/30/2019 2.510% 11/15/2023
11/15/21 14042WAC4 30,700.23 30,700.23 0.00 30,700.23 6.22 0.00 11/15/21 TAOT 2019-A A3
DTD 02/13/2019 2.910% 07/15/2023
11/15/21 89239AAD5 75,539.29 75,539.29 0.00 75,539.29 13.76 0.00 11/15/21 NAROT 2019-A A3
DTD 02/13/2019 2.900% 10/15/2023
11/15/21 65479KAD2 64,403.42 64,403.42 0.00 64,403.42 9.76 0.00 11/15/21 TAOT 2020-A A3
DTD 02/12/2020 1.660% 05/15/2024
11/15/21 89232HAC9 121,051.87 121,051.87 0.00 121,051.87 8.74 0.00 11/15/21 NAROT 2019-B A3
DTD 05/28/2019 2.500% 11/15/2023
11/15/21 65479HAC1 60,750.12 60,750.12 0.00 60,750.12 13.74 0.00 11/15/21 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
11/15/21 14315XAC2 15,754.20 15,754.20 0.00 15,754.20 3.09 0.00 11/18/21 HAROT 2019-1 A3
DTD 02/27/2019 2.830% 03/20/2023
11/18/21 43814WAC9 27,975.11 27,975.11 0.00 27,975.11 0.75 0.00 11/21/21 HAROT 2019-2 A3
DTD 05/29/2019 2.520% 06/21/2023
11/21/21 43815MAC0 61,618.77 61,618.77 0.00 61,618.77 2.30 0.00 11/21/21 HAROT 2020-1 A3
DTD 02/26/2020 1.610% 04/22/2024
11/21/21 43813RAC1 77,293.54 77,293.54 0.00 77,293.54 15.15 0.00 Transaction Type Sub-Total 1,066,212.99 1,066,212.99 0.00 1,066,212.99 (2,476.72) 0.00 SELL
11/02/21 US TREASURY NOTES
DTD 03/31/2016 1.500% 03/31/2023
11/01/21 912828Q29 2,340,000.00 2,378,664.84 3,182.14 2,381,846.98 124,860.93 68,044.67 FIFO 11/17/21 US TREASURY NOTES
DTD 04/30/2018 2.750% 04/30/2023
11/15/21 9128284L1 205,000.00 212,062.89 264.74 212,327.63 (3,475.39) (573.75) FIFO Transaction Type Sub-Total 2,545,000.00 2,590,727.73 3,446.88 2,594,174.61 121,385.54 67,470.92 CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 28
#13..
- 449 -
Managed Account Security Transactions & Interest For the Month Ending November 30, 2021 Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
Managed Account Sub-Total (941,246.51) 411,082.22 (530,164.29) 118,908.82 67,470.92 Total Security Transactions ($941,246.51) $411,082.22 ($530,164.29) $118,908.82 $67,470.92 CITY OF MODESTO - XXXX0050
Account XXXX0050 Page 29
#13..
- 450 -
Attachment 3
City of Modesto Combined Yields
Month
Ending
Combined
Yield
CAMP
Balance
CAMP Monthly
Distribution Yields
Amortized Cost
Balance
Investment
Portfolio Yield
11/30/2019 2.38% 77,352,977.97 1.88% 231,850,852.00 2.55% 12/31/2019 2.35% 66,461,014.55 1.80% 232,100,852.87 2.51% 1/31/2020 2.32% 74,570,281.11 1.78% 232,412,119.69 2.49% 2/29/2020 2.24% 96,240,070.75 1.75% 233,159,902.98 2.44% 3/31/2020 2.16% 79,857,017.19 1.50% 233,703,772.60 2.38% 4/30/2020 2.04% 69,919,614.53 0.98% 234,292,746.21 2.35% 5/31/2020 1.84% 84,960,159.59 0.67% 234,544,432.04 2.26% 6/30/2020 1.74% 84,995,885.29 0.51% 235,131,341.49 2.18% 7/31/2020 1.70% 70,022,491.13 0.37% 236,269,407.98 2.10% 8/31/2020 1.58% 70,040,261.05 0.30% 236,780,335.74 1.96% 9/30/2020 1.53% 70,055,998.31 0.27% 236,959,922.49 1.90% 10/31/2020 1.46% 70,067,223.80 0.19% 238,332,735.73 1.83% 11/30/2020 1.41% 70,075,022.52 0.14% 237,871,749.29 1.79% 12/31/2020 1.33% 85,083,671.36 0.12% 237,485,609.39 1.77% 1/31/2021 1.31% 85,092,301.61 0.12% 238,149,298.87 1.74% 2/28/2021 1.14% 120,099,726.01 0.10% 232,079,913.81 1.68% 3/31/2021 1.08% 137,608,358.86 0.08% 234,986,337.21 1.67% 4/30/2021 1.09% 99,414,400.76 0.06% 273,342,506.45 1.47% 5/31/2021 1.00% 134,419,293.96 0.05% 273,479,692.78 1.46% 6/30/2021 0.97% 134,424,844.05 0.05% 273,831,695.68 1.42% 7/31/2021 1.02% 108,729,978.62 0.05% 273,119,224.63 1.40% 8/31/2021 1.01% 108,734,764.86 0.05% 272,424,046.82 1.39% 9/30/2021 0.97% 108,739,293.68 0.05% 275,543,849.60 1.33% 10/31/2021 0.91% 123,744,124.02 0.05% 274,089,339.67 1.30% 11/30/2021 0.90% 123,749,269.51 0.05% 275,079,950.15 1.28% Notes:
1. Investment Portfolio AC Balance is the amortized cost value of the separately managed portfolio.
2. Investment Portfolio Yield is the separately managed portfolio yield at cost. #13..
- 451 -
Attachment 4
City of Modesto - Portfolio Holdings and Earnings Projections Issuer Par Maturity Date Current Yield
Years to
Maturity
Expected Earnings
Rate to June 30, 2022
Expected Earnings to
June 30, 2022
Main Portfolio
Federal Agency
FHLMC 4,000,000 5/5/2023 0.400% 1 11,215 0.20% 4,563
FNMA 3,660,000 5/22/2023 0.390% 1 18,933 0.35% 7,461
FHLMC 3,615,000 6/19/2023 0.430% 2 144,717 2.58% 54,205 FHLMC 4,170,000 6/19/2023 0.430% 2 197,918 3.06% 74,132 FHLMC 3,315,000 6/26/2023 0.420% 2 18,106 0.35% 6,699
FNMA 3,395,000 7/10/2023 0.460% 2 17,585 0.32% 6,351
FHLMC 2,200,000 8/24/2023 0.490% 2 10,821 0.28% 3,630
FNMA 3,745,000 9/12/2023 0.520% 2 210,157 3.15% 68,438
FNMA 5,665,000 9/12/2023 0.520% 2 295,048 2.92% 96,083
FFCB 2,345,000 9/21/2023 0.550% 2 13,057 0.31% 4,194
FNMA 900,000 11/27/2023 0.570% 2 3,518 0.20% 1,026
FHLMC 2,015,000 12/4/2023 0.590% 2 11,474 0.28% 3,314
FHLB 2,025,000 12/8/2023 0.600% 2 111,463 2.72% 32,019
FNMA 3,500,000 1/7/2025 0.920% 3 92,544 0.85% 17,301
FHLMC 640,000 2/12/2025 0.940% 3 24,309 1.18% 4,405
FHLB 2,370,000 4/14/2025 0.970% 3 48,035 0.60% 8,272
FNMA 3,195,000 4/22/2025 0.970% 3 72,340 0.67% 12,378
FNMA 475,000 4/22/2025 0.970% 3 9,570 0.59% 1,638
FNMA 3,345,000 4/22/2025 0.970% 3 69,246 0.61% 11,848
FNMA 1,910,000 4/22/2025 0.970% 3 33,624 0.52% 5,753
FNMA 3,675,000 6/17/2025 1.040% 4 70,678 0.54% 11,571
FNMA 200,000 6/17/2025 1.040% 4 3,010 0.42% 493
FNMA 1,075,000 6/17/2025 1.040% 4 15,224 0.40% 2,492
FNMA 3,820,000 6/17/2025 1.040% 4 55,320 0.41% 9,056
FNMA 1,190,000 6/17/2025 1.040% 4 15,299 0.36% 2,505
FHLMC 2,220,000 7/21/2025 1.000% 4 38,478 0.48% 6,138
FNMA 2,360,000 8/25/2025 1.020% 4 41,443 0.47% 6,441
FNMA 550,000 8/25/2025 1.020% 4 9,039 0.44% 1,405
FNMA 450,000 8/25/2025 1.020% 4 8,278 0.49% 1,287
FHLMC 3,400,000 9/23/2025 1.040% 4 56,574 0.44% 8,610
FHLMC 130,000 9/23/2025 1.040% 4 1,992 0.40% 303
FNMA 2,215,000 11/7/2025 1.060% 4 49,997 0.57% 7,371
FNMA 2,040,000 11/7/2025 1.060% 4 40,810 0.51% 6,017
Federal Agency CMO
FHLMC 542,851 1/1/2022 0.680% 0 1,210 1.04% 3,286
FHLMC 934,437 6/1/2022 1.530% 1 12,337 2.40% 13,009
FHLMC 1,080,000 8/1/2022 0.760% 1 12,874 1.78% 11,186
FNMA 1,152,273 3/1/2024 1.200% 2 55,430 2.14% 14,296
FHLMC 213,624 7/1/2024 1.500% 3 11,561 2.09% 2,596
U.S. Treasury
U.S. Treasury 4,445,000 4/30/2023 0.390% 1 10,940 0.17% 4,495 U.S. Treasury 4,300,000 5/15/2023 0.390% 1 158,813 2.54% 63,406 U.S. Treasury 5,100,000 6/30/2023 0.420% 2 206,719 2.56% 75,952 U.S. Treasury 3,155,000 7/31/2023 0.450% 2 128,187 2.44% 44,697 U.S. Treasury 5,625,000 7/31/2023 0.450% 2 213,946 2.28% 74,600 U.S. Treasury 1,750,000 8/31/2023 0.490% 2 53,562 1.75% 17,770 U.S. Treasury 2,700,000 9/30/2023 0.520% 2 111,631 2.26% 35,375 U.S. Treasury 8,790,000 11/15/2023 0.550% 2 433,805 2.52% 128,625 U.S. Treasury 3,910,000 11/15/2023 0.550% 2 19,621 0.26% 5,818 U.S. Treasury 3,275,000 11/30/2023 0.560% 2 164,789 2.52% 47,857 U.S. Treasury 270,000 12/31/2023 0.600% 2 14,411 2.56% 4,015 U.S. Treasury 1,564,000 2/29/2024 0.650% 2 12,140 0.35% 3,135 U.S. Treasury 457,000 2/29/2024 0.650% 2 3,440 0.33% 888 U.S. Treasury 4,890,000 4/15/2024 0.690% 2 40,626 0.35% 9,934 U.S. Treasury 2,450,000 7/31/2024 0.760% 3 116,926 1.79% 25,450 U.S. Treasury 1,630,000 8/31/2024 0.790% 3 59,977 1.34% 12,652 U.S. Treasury 1,850,000 9/30/2024 0.800% 3 78,761 1.50% 16,133 U.S. Treasury 460,000 10/31/2024 0.830% 3 21,035 1.57% 4,183 U.S. Treasury 1,215,000 11/30/2024 0.850% 3 61,794 1.69% 11,953 U.S. Treasury 3,450,000 11/30/2024 0.850% 3 168,930 1.63% 32,676 U.S. Treasury 4,585,000 11/30/2024 0.850% 3 69,317 0.50% 13,408 U.S. Treasury 4,945,000 4/30/2025 0.960% 3 106,862 0.63% 18,167 U.S. Treasury 4,340,000 8/31/2025 1.030% 4 86,002 0.53% 13,308 U.S. Treasury 4,550,000 9/30/2025 1.020% 4 116,986 0.67% 17,715 U.S. Treasury 1,100,000 9/30/2025 1.020% 4 33,926 0.80% 5,137 U.S. Treasury 5,010,000 10/31/2025 1.050% 4 151,829 0.77% 22,493 U.S. Treasury 6,930,000 10/31/2025 1.050% 4 211,857 0.78% 31,386 U.S. Treasury 4,250,000 11/30/2025 1.070% 4 181,199 1.07% 26,293 U.S. Treasury 1,040,000 12/31/2025 1.070% 4 19,286 0.45% 2,740 U.S. Treasury 500,000 12/31/2025 1.070% 4 8,834 0.43% 1,255 U.S. Treasury 3,735,000 12/31/2025 1.070% 4 135,538 0.89% 19,259 U.S. Treasury 2,400,000 1/31/2026 1.090% 4 80,564 0.80% 11,214 U.S. Treasury 3,210,000 2/28/2026 1.090% 4 95,798 0.70% 13,094 U.S. Treasury 4,925,000 3/31/2026 1.110% 4 185,605 0.87% 24,873 U.S. Treasury 2,480,000 3/31/2026 1.110% 4 81,554 0.76% 10,929 U.S. Treasury 2,325,000 5/31/2026 1.120% 5 83,357 0.80% 10,756 U.S. Treasury 2,260,000 5/31/2026 1.120% 5 88,340 0.87% 11,399 Negotiable CD
Sumitomo Mitsui Financial Group Inc 1,845,000 7/8/2022 0.290% 1 7,742 0.70% 7,460 Nordea Bank Ab 3,440,000 8/26/2022 0.330% 1 46,728 1.84% 36,827 Skandinaviska Enskilda Banken Ab 3,560,000 8/26/2022 0.330% 1 48,665 1.85% 38,353 DNB Bank ASA 1,745,000 12/2/2022 0.430% 1 35,693 2.03% 20,618 Credit Suisse Group 1,850,000 3/17/2023 0.460% 1 14,017 0.59% 6,296 Earnings to
Maturity
November 30, 2021
#13..
- 452 -
Attachment 4
City of Modesto - Portfolio Holdings and Earnings Projections Issuer Par Maturity Date Current Yield
Years to
Maturity
Expected Earnings
Rate to June 30, 2022
Expected Earnings to
June 30, 2022
Earnings to
Maturity
November 30, 2021
Corporate Note
Amazon.Com Inc 2,335,000 2/22/2023 0.670% 1 76,526 2.66% 36,132 Toyota Motor Corp 2,230,000 9/20/2023 0.760% 2 146,998 3.65% 47,289 US Bancorp 2,860,000 2/5/2024 0.940% 2 141,692 2.27% 37,690 Bank Of America Co 2,010,000 3/5/2024 2.120% 2 71,465 1.57% 18,342 Pfizer Inc 3,445,000 3/15/2024 0.990% 2 212,161 2.69% 53,801 Amazon.Com Inc 1,590,000 5/12/2024 0.930% 2 19,437 0.50% 4,609 JPMorgan Chase & Co 1,320,000 5/13/2024 1.150% 2 20,944 0.65% 4,961 Wal-Mart Stores Inc 4,000,000 7/8/2024 0.990% 3 227,847 2.19% 50,792 JPMorgan Chase & Co 1,405,000 9/16/2024 0.840% 3 25,664 0.65% 5,329 Paccar Financial Corp 1,810,000 2/6/2025 1.260% 3 83,581 1.45% 15,223 Novartis Capital Corp 2,290,000 2/14/2025 1.270% 3 67,804 0.92% 12,265 Mastercard Inc 1,760,000 3/3/2025 1.170% 3 61,709 1.08% 11,003 JPMorgan Chase & Co 865,000 6/1/2025 1.160% 4 24,976 0.82% 4,140 Bristol-Myers Squibb Co 2,230,000 11/13/2025 1.340% 4 83,815 0.95% 12,305 The Bank Of New York Mellon Corporation 3,465,000 1/28/2026 1.410% 4 107,512 0.75% 14,995 Asset-Backed Securities
Honda Auto Receivables 169,575 3/20/2023 2.290% 1 6,247 2.83% 2,788 Hyundai Auto Receivables 264,272 6/15/2023 2.290% 2 10,837 2.66% 4,088 Honda Auto Receivables 492,600 6/21/2023 1.990% 2 19,325 2.52% 7,213 Toyota Motor Corp 606,266 7/15/2023 2.350% 2 28,658 2.91% 10,263 Ally Auto Receivables Trust 202,569 9/15/2023 2.550% 2 10,572 2.91% 3,427 Nissan Auto Receivables 482,980 10/15/2023 2.440% 2 26,279 2.90% 8,145 Capital One Prime Auto Receivables 242,452 11/15/2023 2.120% 2 11,944 2.51% 3,541 Nissan Auto Receivables 579,857 11/15/2023 2.040% 2 28,458 2.51% 8,438 Carmax Auto Owner Trust 398,752 3/15/2024 2.210% 2 24,497 2.68% 6,212 Honda Auto Receivables 1,172,706 4/22/2024 1.270% 2 45,345 1.61% 10,999 Toyota Motor Corp 1,581,804 5/15/2024 1.350% 2 64,598 1.66% 15,267 Carmax Auto Owner Trust 799,246 12/16/2024 1.560% 3 46,121 1.89% 8,793 Honda Auto Receivables 650,000 4/21/2025 0.370% 3 5,962 0.27% 1,021 Hyundai Auto Receivables 510,000 9/15/2025 0.530% 4 7,401 0.38% 1,133 Carmax Auto Owner Trust 385,000 12/15/2025 0.480% 4 5,357 0.34% 769 Toyota Motor Corp 980,000 1/15/2026 0.640% 4 17,474 0.43% 2,458 Carmax Auto Owner Trust 770,000 2/17/2026 0.640% 4 17,038 0.52% 2,346 Hyundai Auto Receivables 465,000 5/15/2026 0.820% 4 15,443 0.75% 2,012 Discover Card Execution Note Trust 775,000 9/15/2026 0.900% 5 21,714 0.58% 2,630 Municipal Securities
California St 2,310,000 10/1/2023 0.480% 2 79,313 1.87% 25,096 Maryland St 620,000 8/1/2024 0.670% 3 8,564 0.52% 1,862 California State University 600,000 11/1/2024 0.900% 3 12,014 0.68% 2,387 State Of California 100,000 12/1/2024 0.830% 3 1,683 0.56% 325 University Of California 510,000 5/15/2025 1.130% 3 15,571 0.88% 2,616 University Of California 220,000 5/15/2025 1.130% 3 6,135 0.81% 1,031 Florida State Board of Administration Finance 1,295,000 7/1/2025 1.260% 4 58,430 1.26% 9,463 Florida State Board of Administration Finance 505,000 7/1/2025 1.260% 4 20,034 1.11% 3,245 Los Angeles Community College District 925,000 8/1/2025 1.070% 4 26,252 0.77% 4,153 New Jersey Turnpike Authority 505,000 1/1/2026 1.330% 4 21,628 1.05% 3,071 Supranational Securities
Intl Bank Of Reconstruction And Dev 1,790,000 11/24/2023 0.680% 2 11,435 0.32% 3,348 Inter-American Development Bank 4,095,000 9/23/2024 0.930% 3 60,538 0.52% 12,484 Overnight Investments 123,749,270 Varies Varies 0.10% 72,029 Totals (Main Portfolio) 398,411,535 7,989,986 0.90% 2,085,895 Notes:
1. Earnings projections are based on stated par value, future market expectations and current investment positions.
2. Earnings on overnight investments are based on the investment balances and the Fed Funds Futures rates.
3. Callable securities priced above par are considered to be called on their next call date. #13..
- 453 -
Attachment 5
Issue Name / Type Trustee Bank Investment Total Amount
1993 Community Center Refinancing U.S. Bank First American Treasury Obligation Fund $1,977,084.79 1993 Golf Course Refinancing U.S. Bank First American Treasury Obligation Fund $603,160.59 Instl Res Tre and Agny Cash Adv6541 $127,918.29
Financial Guaranty Insurance Pol $1.00
CAMP $1,930,676.47
Total $2,058,595.76
Instl Res Tre and Agny Cash Adv6541 $135,822.29
CAMP $4,794,333.12
Total $4,930,155.41
2018 Wastewater Refunding Bank of New York Fidelity Inv MM Trsy Only $1.92 Fairview Village Refunding US Bank First American Government $195,192.98 Blackrock Federal Fund Instl 30 $513.43
CAMP $2,738,547.24
Total $2,739,060.67
PCE Litigation Bank of America Business Interest Maximizer $491,927.96 Modesto Irrigation District JP Morgan Collateral towards bonds $8,758,884.07 Water ARRA Grants Bank of the West Business Money Market $36,289.42 Innovative Claim Solutions (Third Party
Administrator - Worker's Compensation) Wells Fargo Bank Business Money Market $104,814.07 George Hills Company - General Liability
Claims Administration Services California Bank & Trust $9,707.41 Kemper Sports Management Inc. BMO Harris Bank Business Money Market $29,685.07 Stanislaus Community Foundation Modesto Commerce Bank Charles Schwab $806,525.41 California Bank of
Commerce $2,730,266.19
Bank of Stockton $759,162.56
Farmers & Merchant $465,719.95
Banner Bank $19,282.55
Village One #2 Refunding Bank of New York
Third-Party Construction Contract
Retention
Cash with Fiscal Agent Investments
As of November 30, 2021
2008 Water Refunding COP Bank of New York
2008 Lease Revenue Bonds Bank of New York
#13..
- 454 -
CITY OF MODESTO
COUNCIL AGENDA REPORT
DATE OF MEETING:
February 8, 2022
Date: January 18, 2022
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
Bill Sandhu, Public Works Director
SUBJECT: Fleet Replacement Vehicles- Dump Truck, One-Ton Trucks and Wheel Loader CONTACT: Cynthia Kline, Purchasing Manager, [email protected], (209) 577-5412 DESCRIPTION:
Consider approving the award of bid for a Low-Profile Dump Truck to Towne Ford Sales, Redwood City, CA for a total amount not to exceed $99,797; approving the award of bid for two One-Ton Extended Cab Trucks to Napa Ford, Napa, CA for a total amount not to exceed $110,114; and approving the competitive bidding process from Sourcewell (formerly National Joint Powers Alliance) with Pape Machinery, French Camp, CA for a John Deere Wheel Loader for a total amount not to exceed $288,135. (Funding Source: Fleet Replacement Fund) STRATEGIC PLAN ELEMENT:
These items support the City of Modesto 2020-2025 Strategic Plan Focus of Governance and Service Delivery under goal H: Achieve Financial Stability.
BACKGROUND:
Every year, City vehicles and equipment are individually evaluated based on their age, condition, mileage and maintenance costs. Following this process, a Fleet Replacement List is submitted to Council and is approved as part of a new fiscal year’s Fleet Replacement Budget.
Once a unit is replaced and placed into City service, funds for its replacement are charged out as monthly recurring charges until the end of the unit’s service life. These funds are specifically designated for the replacement of City vehicles and equipment. Listed below are vehicles that will be replaced based on competitive process as outlined in the discussion.
RFB Vehicle # Description Dept. Year of
Vehicle
Meter Repair
Cost
2122-36 40320 Low-Profile Dump
Truck
UTL – Water
Construction
2003 76,683 $ 42,778
This vehicle is used to support utility operations for the Utilities Water Construction Division. #14..
- 455 -
City Council, February 8, 2022
Fleet Replacement Vehicles- Dump Truck, One-Ton Trucks and Wheel Loader Trucks
RFB Vehicle # Description Dept. Year of
Vehicle
Meter Repair
Cost
41121 Truck 3/4 Ton
with Utility
2122-37 UTL – Water 2011 104,872 $19,632
41142 Truck 3/4 Ton
with Utility
UTL – Water 2011 90,104 $11,738
This vehicle is used to support utility operations for the Utilities Water, Wells and Treatment functions.
RFB Vehicle
#
Description Dept. Year of
Vehicle
Hours Repair
Cost
Sourcewell
2122-19
50304 Loader 4WD 1
1/2-2 YD
UTL – Water
Construction
2003 3,476 $ 57,785
This wheel loader is used to support utility operations for the Utilities Water Construction Division.
DISCUSSION:
RFB 2122-36 – Low-Profile Dump Truck
On November 29, 2021, the Purchasing Division issued Request for Bids (RFB) 2122-36 for one Low-Profile Dump truck on the City’s website under commodity codes1. Prospective bidders were notified online and via email of the bid opportunity. Twenty-four (24) companies downloaded the RFB document. On January 4, 2022, bids were formally opened in the City Clerk’s office and broadcast via Microsoft Teams Livestream2. One vendor chose to respond, there was no local bids received. Based on providing the one bid being a responsive and responsible bid, City staff recommends awarding the bid for one Low-Profile Dump Truck to Towne Ford Sales, Redwood City, CA for a total amount not to exceed $99,797.
Modesto Municipal Section 8-3.203 requires all purchases, which meet or exceed $50,000 for material, equipment or contractual services to be formally bid. Based on providing the lowest responsive and responsible bid which conforms to the Modesto Municipal Code, 8-3.203 City staff recommends the award of bid for one Low-Profile Dump Truck to Towne Ford Sales, Redwood City, CA.
RFB 2122-37 – Two One-Ton Extended Cab Trucks
On November 30, 2021, the Purchasing Division issued Request for Bids (RFB) 2122-37 for two One-Ton Extended Cab Trucks on the City’s website under commodity codes3. Prospective bidders were notified online and via email of the bid opportunity. Fifteen (15) companies downloaded the RFB document. On January 18, 2022, bids were formally opened in the City Clerk’s office and broadcast via Microsoft Teams Livestream4. One vendor chose to respond, there was no local bids received. Based on providing the one bid being a responsive and responsible bid, City staff recommends awarding the bid for two One-Ton Extended Cab Trucks to Napa Ford, Napa, CA for a total amount not to exceed $110,114. 1 07051-Trucks (Over One-Ton Capacity), 07053 – Trucks with specialized bodies 2 Staff implemented a virtual bid opening process in an effort to slow the spread of COVID-19 3 07051-Trucks (Over One-Ton Capacity), 07053 – Trucks with specialized bodies 4 Staff implemented a virtual bid opening process in an effort to slow the spread of COVID-19 #14..
- 456 -
City Council, February 8, 2022
Fleet Replacement Vehicles- Dump Truck, One-Ton Trucks and Wheel Loader Trucks
Modesto Municipal Section 8-3.203 requires all purchases, which meet or exceed $50,000 for material, equipment or contractual services to be formally bid. Based on providing the lowest responsive and responsible bid which conforms to the Modesto Municipal Code, 8-3.203 City staff recommends the award of bid for two One-Ton Extended Cab Trucks to Napa Ford, Napa, CA.
RFB 2122-19 – John Deere Wheel Loader
On January 31, 2019, Sourcewell issued Request for Proposals (RFP) #032119 JPC for Heavy Construction Equipment with Related Accessories, Attachments, and Supplies on the Sourcewell website5, the New York State Contract Reporter website6, the Onvia website7, and the PublicPurchase.com website. The RFP was also advertised and distributed to 98 vendors.
On March 22, 2019 proposals were formally opened at the Sourcewell offices. Fifteen proposals were received and based on the Sourcewell Proposal Review Committee and criteria outlines in the RFP8, fourteen contracts were awarded9 for Heavy Construction Equipment with Related Accessories, Attachments and Supplies.
Sourcewell’s analysts streamline the procurement process by developing RFP’s for national competitive solicitations that meet or exceed local requirements. The competitive process is continually refined to best meet agency needs and allows Sourcewell to offer exceptional products from nationally acclaimed vendors. The Purchasing Division recommends utilizing the existing competitively bid contract with Pape Machinery one John Deere Wheel Loader to the for a total amou t not to exceed $288,135.
Modesto Municipal Code Section 8-3.203 generally requires all purchases that meet or exceed $50,000 for material, equipment or contractual services to be formally bid. However, exceptions to the formal bidding process are granted in MMC 8-3.204(d) “Where the Purchasing Manager, in her discretion, determines that a process other than the formal bid procedure set for in Section 8-3.203 will result in a procurement for the City at the lowest possible cost commensurate with the desired quality.” In addition, MMC 8-3.202(h) encourages the Purchasing Manager to join with the State of California or other units of government in cooperative purchasing plans when the best cost savings interest of the City would be served.
FISCAL IMPACT:
Sufficient funds for the one Low-Profile Dump Truck, two One-Ton Extended Cab Trucks and John Deere Wheel Loader are budgeted in Fiscal Year 21-22 in the Fleet Replacement Fund.
COMMITTEE RECOMMENDATION:
This item was presented at the October 25, 2021 Finance Committee and the final list of replacements has been approved by Council on November 2, 2021. 5 www.sourcewell-mn.gov
6 www.nyscr.ny.gov
7 www.onvia.com
8 Conformance to Terms/Conditions to Include Documentation, Pricing, Financial, Industry and Marketplace Successes, Bidder’s Ability to Sell/Service Contract Nationally, Bidder’s Marketing Plan, Value Added Attributes, Warranty Coverages and Information, and Selection and Variety of Products and Services Offered 9 Caterpillar Inc., Volvo Construction, BOMAG Americas, CNH Industrial America, Doosan, Dynapac North America, Grove, Hyundai Construction, John Deere, Kobelco Construction, Komatsu America, Link Belt, Roadtec and Wirtgen America #14..
- 457 -
City Council, February 8, 2022
Fleet Replacement Vehicles- Dump Truck, One-Ton Trucks and Wheel Loader Trucks
RECOMMENDED COUNCIL ACTION:
Staff Recommendations:
Resolution approving the award of bid for a Low-Profile Dump Truck to Towne Ford Sales, Redwood City, CA for a total amount not to exceed $99,797; and authorizing the Purchasing Manager, or her designee, to issue the purchase order.
Resolution approving the award of bid for two One-Ton Extended Cab Trucks to Napa Ford, Napa, CA for a total amount not to exceed $110,114; and authorizing the Purchasing Manager, or her designee, to issue the purchase order.
Resolution approving the competitive bidding process from Sourcewell (formerly National Joint Powers Alliance) with Pape Machinery, French Camp, CA for a John Deere Wheel Loader for a total amount not to exceed $288,135; and authorizing the Purchasing Manager, or her designee, to issue the purchase order.
Approved by:
DeAnna Christensen, Director of Finance
Bill Sandhu, Public Works Director
Joseph P. Lopez, City Manager
Attachments:
1. Resolutions (3)
2. RFB 2122-36 – Low-Profile Dump Truck– Financial Interest Disclosure, Pricing Schedule Cost Abstract
3. RFB 2122-37 – Two One-Ton Extended Cab Trucks - Financial Interest Disclosure, Pricing Schedule Cost Abstract
4. Sourcewell Quote - RFB 2122-19 – John Deere Wheel Loader #14..
- 458 -
1 MODESTO CITY COUNCIL
RESOLUTION NO. 2022-XX
RESOLUTION APPROVING THE AWARD OF BID FOR A LOW-PROFILE
DUMP TRUCK TO TOWNE FORD SALES, REDWOOD CITY, CA FOR A
TOTAL AMOUNT NOT TO EXCEED $99,797; AND AUTHORIZING THE
PURCHASING MANAGER, OR HER DESIGNEE, TO ISSUE THE PURCHASE ORDER
WHEREAS, this vehicle is used to support utility operations for the Utilities Water Construction Division; and
WHEREAS, Modesto Municipal Code Section 8-3.203 requires all purchases, which meet or exceed $50,000 for material, equipment or contractual services to be formally bid; and
WHEREAS, on November 29, 2021, the Purchasing Division issued Request for Bids (RFB) 2122-36 for one Low-Profile Dump Truck on the City’s website under commodity codes - 07051-Trucks (Over One-Ton Capacity), 07053 – Trucks with specialized bodies; and
WHEREAS, twenty-four (24) companies downloaded the RFB document, one vendor chose to submit a bid, there was no local bid received; and WHEREAS, on January 4, 2022, bids were formally opened in the City Clerk’s office and Towne Ford Sales, Redwood City, CA, was the only responsive and responsible bidder; and
WHEREAS, based on providing the only responsive and responsible bid which conforms to the Modesto Municipal Code, Section 8-3.203 City staff recommends the award of bid for a Low-Profile Dump Truck to Towne Ford Sales, Redwood City, CA. #14..
- 459 -
2 NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves the award of bid for a Low-Profile Dump Truck to Towne Ford Sales, Redwood City, CA for a total amount not to exceed $99,797.
BE IT FURTHER RESOLVED, that the Purchasing Manager, or her designee, is hereby authorized to execute the purchase order.
The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 8th day of February 2022, by Councilmember ________, who moved its adoption, which motion being duly seconded by Councilmember ______, was upon roll call carried and the resolution adopted by the following vote:
AYES: Councilmembers:
NOES: Councilmembers:
ABSENT: Councilmembers:
ATTEST: _____________________________
DANA SANCHEZ, Interim City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: _______________________________________
JOSE M. SANCHEZ, City Attorney
#14..
- 460 -
1 MODESTO CITY COUNCIL
RESOLUTION NO. 2022-XX
RESOLUTION APPROVING THE AWARD OF BID FOR TWO ONE-TON
EXTENDED CAB TRUCKS TO NAPA FORD, NAPA, CA FOR A TOTAL
AMOUNT NOT TO EXCEED $110,114; AND AUTHORIZING THE
PURCHASING MANAGER, OR HER DESIGNEE, TO ISSUE THE PURCHASE ORDER
WHEREAS, this vehicle is used to support utility operations for the Utilities Water, Wells and Treatment functions; and
WHEREAS, Modesto Municipal Code Section 8-3.203 requires all purchases, which meet or exceed $50,000 for material, equipment or contractual services to be formally bid; and
WHEREAS, on November 30, 2021, the Purchasing Division issued Request for Bids (RFB) 2122-37 for two One-Ton Extended Cab Trucks on the City’s website under commodity codes - 07051-Trucks (Over One-Ton Capacity), 07053 – Trucks with specialized bodies; and
WHEREAS, fifteen (15) companies downloaded the RFB document, one vendor chose to submit a bid, there was no local bid received; and WHEREAS, on January 18, 2022, bids were formally opened in the City Clerk’s office and XX, was the only responsive and responsible bidder; and WHEREAS, based on providing the only responsive and responsible bid which conforms to the Modesto Municipal Code, Section 8-3.203 City staff recommends the award of bid for a two One-Ton Extended Cab Trucks to Napa Ford, Napa, CA.
NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves the award of bid for two One-Ton Extended Cab Trucks to Napa Ford, Napa, CA for a total amount not to exceed $110,114. #14..
- 461 -
2 BE IT FURTHER RESOLVED, that the Purchasing Manager, or her designee, is hereby authorized to execute the purchase order.
The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 8th day of February 2022, by Councilmember ________, who moved its adoption, which motion being duly seconded by Councilmember ______, was upon roll call carried and the resolution adopted by the following vote:
AYES: Councilmembers:
NOES: Councilmembers:
ABSENT: Councilmembers:
ATTEST: _____________________________
DANA SANCHEZ, Interim City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: _______________________________________
JOSE M. SANCHEZ, City Attorney
#14..
- 462 -
1 MODESTO CITY COUNCIL
RESOLUTION NO. 2022-XX
RESOLUTION APPROVING THE COMPETITIVE BIDDING PROCESS FROM
SOURCEWELL (FORMERLY NATIONAL JOINT POWERS ALLIANCE)
WITH PAPE MACHINERY, FRENCH CAMP, CA FOR A JOHN DEERE
WHEEL LOADER FOR A TOTAL AMOUNT NOT TO EXCEED $288,135 AND
AUTHORIZING THE PURCHASING MANAGER, OR HER DESIGNEE, TO
ISSUE THE PURCHASE ORDER
WHEREAS, every year, City vehicles and equipment are individually evaluated based on their age, condition, mileage and maintenance costs; and WHEREAS, Sourcewell’s analysts streamline the procurement process by developing RFP’s for national competitive solicitations that meet or exceed local requirements; and
WHEREAS, on January 31, 2019, Sourcewell issued Request for Proposals (RFP) #032119 JPC for Heavy Construction Equipment with Related Accessories, Attachments, and Supplies on the Sourcewell website; and
WHEREAS, the RFP was also advertised and distributed to ninety-eight (98) vendors; and
WHEREAS, fifteen proposals were received and based on the Sourcewell Proposal Review Committee and criteria outlines in the RFP, fourteen contracts were awarded for Heavy Construction Equipment with Related Accessories, Attachments and Supplies; and
WHEREAS, Modesto Municipal Code (MMC) Section 8-3.203 generally requires all purchases that meet or exceed $50,000 for material, equipment or contractual services to be formally bid. However, exceptions to the formal bidding process are granted in MMC 8-3.204(d) “Where the Purchasing Manager, in her discretion, determines that a process other than the formal bid procedure set for in Section 8-3.203 will result in a #14..
- 463 -
2 procurement for the City at the lowest possible cost commensurate with the desired quality;” and
WHEREAS, MMC 8-3.202(h) encourages the Purchasing Manager to join with the State of California or other units of government in cooperative purchasing plans when the best cost savings interest of the City would be served.
NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves the competitive bidding process from Sourcewell (formerly National Joint Powers Alliance) with Pape Machinery, French Camp, CA for a John Deere Wheel Loader for a total amount not to exceed $288,135.
BE IT FURTHER RESOLVED, that the Purchasing Manager, or her designee, is hereby authorized to execute the purchase order.
The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 8th day of February 2022, by Councilmember ________, who moved its adoption, which motion being duly seconded by Councilmember ______, was upon roll call carried and the resolution adopted by the following vote:
AYES: Councilmembers:
NOES: Councilmembers:
ABSENT: Councilmembers:
ATTEST: _____________________________
DANA SANCHEZ, Interim City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: _______________________________________
JOSE M. SANCHEZ, City Attorney
#14..
- 464 -
#14..
- 465 -
#14..
- 466 -
#14..
- 467 -
#14..
- 468 -
#14..
- 469 -
ITEM # STOCK # ITEM/DESCRIPTION QTY UNIT OF
ISSUE UN PRC EXTENSION
1 2022-F
Series New and Unused - Low Profile Dump Truck as Specified in Spec A (Page 27-37) 1 $92,500.00 $92,500.00
2 Tire Recycling Fee (Non-Taxable) 1 $12.25 $12.25
SUB-TOTAL: $92,512.25
SALES TAX 7.875%: $7,284.38
TOTAL: $99,796.63
CITY OF MODESTO
PO BOX 642 MODESTO CA 95353
RFB NO. 2022-36 LOW PROFILE DUMP TRUCK
Redwood City, CA
TOWNE FORD SALES
#14..
- 470 -
#14..
- 471 -
#14..
- 472 -
#14..
- 473 -
#14..
- 474 -
#14..
- 475 -
#14..
- 476 -
ITEM # STOCK # ITEM/DESCRIPTION QTY UNIT OF
ISSUE UN PRC EXTENSION
1 F-350 New & Unused - One-Ton Truck per Specification A 1 $50,467.00 $50,467.00 2 Tire Recycling Fee (Non-Taxable) 1 $8.75 $8.75
SUB-TOTAL: $50,475.75
SALES TAX 7.875%: $3,974.28
TOTAL: $54,450.03
ITEM # STOCK # ITEM/DESCRIPTION QTY UNIT OF
ISSUE UN PRC EXTENSION
1 F-350 New & Unused - One-Ton Truck per Specification B 1 $51,592.00 $51,592.00 2 Tire Recycling Fee (Non-Taxable) 1 $8.75 $8.75
SUB-TOTAL: $51,600.75
SALES TAX 7.875%: $4,062.87
TOTAL: $55,663.62
Speck A & B 1 $110,113.65
Napa, CA
Napa Ford
Grand Total
CITY OF MODESTO
PO BOX 642 MODESTO CA 95353
RFB NO. 2122-37 Two (2) One-Ton Extended Cab Trucks
Napa, CA
Napa Ford
#14..
- 477 -
Date: 10 December 2021 Offer Expires: 28 February 2022
Confidential
Quote Id: 25751544
Prepared For:
CITY OF MODESTO
Prepared By: SCOTT HENDERSON
Pape Machinery, Inc.
8621 S El Dorado Street
French Camp, CA 95231
Tel: 209-983-8122
Mobile Phone: 209-649-3004
Fax: 209-983-1105
Email: [email protected]
#14..
- 478 -
Salesperson : X ______________ Accepted By : X ______________ Confidential
Quote Summary
Prepared For:
CITY OF MODESTO
1001 9TH ST STE A
MODESTO, CA 95354
Business: 209-521-1274
Prepared By:
SCOTT HENDERSON
Pape Machinery, Inc.
8621 S El Dorado Street
French Camp, CA 95231
Phone: 209-983-8122
Mobile: 209-649-3004
[email protected]
Sourcewell Discount 37% off List Quote Id: 25751544
10 December 2021
19 January 2022
Created On:
Last Modified On:
Expiration Date: 28 February 2022
Equipment Summary Suggested List Selling Price Qty Extended JOHN DEERE 644 P WHEEL
LOADER
$ 415,408.00 $ 267,151.86 X 1 = $ 267,151.86
Equipment Total $ 267,151.86
Quote Summary
Equipment Total $ 267,151.86
California Tire Fee $ 7.00
SubTotal $ 267,158.86
Sales Tax - (7.875%) $ 20,975.21
Total $ 288,134.07
Down Payment (0.00)
Rental Applied (0.00)
Balance Due $ 288,134.07
#14..
- 479 -
Selling Equipment
Quote Id: 25751544 Customer: CITY OF MODESTO
Confidential
JOHN DEERE 644 P WHEEL LOADER
Hours:
Stock Number:
Suggested List
$ 415,408.00
Selling Price
$ 267,151.86
Code Description Qty Unit Extended
6050DW 644 P WHEEL LOADER 1 $ 314,514.00 $ 314,514.00
Standard Options - Per Unit
170K JDLink™ 1 $ 0.00 $ 0.00
0924 John Deere PowerTech Engine 1 $ 37,509.00 $ 37,509.00 1010 Standard Wheel Loader 1 $ 0.00 $ 0.00
1105 4-Speed Powershift Transmission 1 $ -3,900.00 $ -3,900.00 1217 140 amp Alternator 1 $ 347.00 $ 347.00
1310 Flat Black Curved Stack 1 $ 0.00 $ 0.00
1430 Engine Air Intake System with
Centrifugal Precleaner
1 $ 667.00 $ 667.00
1520 Automatic Reversing Hydraulic Fan 1 $ 1,792.00 $ 1,792.00 1610 Standard Fuel Filter with Water
Separator and Standard Fuel Fill
1 $ 0.00 $ 0.00
1905 Standard Cab 1 $ 0.00 $ 0.00
1940 7 inch Monitor 1 $ 0.00 $ 0.00
1970 Hydrau Hydraulic Fluid 1 $ 0.00 $ 0.00
2010 Standard Z-BAR 1 $ 0.00 $ 0.00
2120 Steering Wheel Only 1 $ 0.00 $ 0.00
2240 Premium Seat, Heated and Ventilated
with Heavy Duty Air Suspension
1 $ 1,295.00 $ 1,295.00
2360 Joystick Controls 1 $ 0.00 $ 0.00
2403 Three Function Hydraulics 1 $ 2,231.00 $ 2,231.00
2510 Ride Control 1 $ 4,818.00 $ 4,818.00
2605 English Decals and Manuals 1 $ 0.00 $ 0.00
2715 15 Amp Converter 1 $ 115.00 $ 115.00
2870 No Payload Scale with Cycle Counter 1 $ 119.00 $ 119.00 3046 Front Hydraulically Locking Differential
and Rear Conventional Differential
Axles
1 $ 0.00 $ 0.00
3120 Manual Axle Differential Lock 1 $ 0.00 $ 0.00
4935 No Brand Preferred, 23.5R25 L3 Single
Star Radial On 3pc. Rims
1 $ 21,812.00 $ 21,812.00
5320 Less Tire Pressure Monitoring System 1 $ 0.00 $ 0.00 5540 Full Width Front Fenders 1 $ 430.00 $ 430.00
5610 Left Side Steps Only 1 $ 0.00 $ 0.00
5840 No Fork Frame 1 $ 0.00 $ 0.00
5940 No Tines 1 $ 0.00 $ 0.00
#14..
- 480 -
Selling Equipment
Quote Id: 25751544 Customer: CITY OF MODESTO
Confidential
7120 Halogen Work and Drive Lights 1 $ 0.00 $ 0.00
8220 Rear Hitch and Counterweight 1 $ 0.00 $ 0.00
8240 Rear Camera 1 $ 0.00 $ 0.00
8275 LED Strobe Beacon with Left Beacon
Bracket
1 $ 275.00 $ 275.00
8310 Standard Exterior Mirrors 1 $ 0.00 $ 0.00
8380 No Radio 1 $ 0.00 $ 0.00
8450 Cab with Air A/C Charge 1 $ 0.00 $ 0.00
8559 Hydraulic Coupler - JRB 418 Pattern 1 $ 7,589.00 $ 7,589.00 8860 Bolt-on Cutting Edge 1 $ 2,487.00 $ 2,487.00
8937 4.25 Cu. Yd. Bucket 1 $ 9,337.00 $ 9,337.00
9045 Quick Fluid Service 1 $ 867.00 $ 867.00
9115 Powered Cab Fresh Air Pre-Cleaner 1 $ 945.00 $ 945.00 9140 Fire Extinguisher 1 $ 149.00 $ 149.00
9240 Engine Compartment Light 1 $ 180.00 $ 180.00
9410 Transmission and Bottom Guards 1 $ 2,550.00 $ 2,550.00 9710 23.5R25 L3 Single Star No Brand
Preferred Radial On 3pc. Rims
1 $ 0.00 $ 0.00
Standard Options Total $ 91,614.00
Value Added Services Total $ 0.00
Other Charges
Freight 1 $ 7,280.00 $ 7,280.00
Setup 1 $ 1,200.00 $ 1,200.00
Deliver Charge 1 $ 800.00 $ 800.00
Other Charges Total $ 9,280.00
Suggested Price $ 415,408.00
Customer Discounts
Customer Discounts Total $ -148,256.14 $ -148,256.14
Total Selling Price $ 267,151.86
#14..
- 481 -
CITY OF MODESTO
COUNCIL AGENDA REPORT
DATE OF MEETING:
February 8, 2022
Date: January 25, 2022
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
Charlie Haase, Chief Information Officer
SUBJECT: Cisco Annual Licensing and Maintenance Support CONTACT: Cynthia Kline, Purchasing Manager, 209-577-5412, [email protected] DESCRIPTION:
Consider approving the competitive bidding process from Merced County, Fast Open Contracts Utilization Services (FOCUS), Merced, CA for Cisco Annual Licensing and Support Maintenance with Telcion Communications Group, Turlock, CA for a three-year agreement for a total amount not to exceed $554,814. (Funding Source: Information Technology Fund) STRATEGIC PLAN ELEMENT:
This item supports the City of Modesto 2020-2025 Strategic Plan focuses of Governance and Service Delivery under Goal H: Achieve Financial Sustainability.
BACKGROUND:
The City of Modesto has standardized all switching and routing network equipment on Cisco Systems, Inc. The city’s networking infrastructure is key to providing host connectivity to all dispatch services, Wi-Fi, and Internet access for all City departments and locations.
In 2018, the Information Technology (IT) Department began a network update project to replace all out of warranty and end-of-life Cisco networking equipment. The current annual licensing and maintenance support has ended September 2021.
Cisco annual licensing and maintenance support is a support service that provides City staff with direct, 24-hour access to Cisco engineers and an extensive range of technical resources.
The support service includes emergency equipment repair, rapid network resolution, critical security device updates, continued use of Cisco VPN and Cisco software. Cisco VPN (virtual private networking) is especially critical in the city’s COVID-19 response, providing I.T. the ability to support a remote workforce.
#15..
- 482 -
City Council, February 8, 2022
Cisco Annual Licensing and Maintenance Support
DISCUSSION:
On November 30, 2020, the Merced County FOCUS Division issued Request for Proposal #7370 for Technology Expertise, Equipment, Service and Systems on the Merced County Purchasing Division website1. Proposals were formally opened at the Merced County Purchasing Division office on January 15, 2021. Based on the scoring criteria2 defined in the RFP, four (4) companies were awarded contracts3. Contract No. 2021106 was awarded to Telcion Communications Group, Turlock, CA for Technology Expertise, Equipment, Services and Systems effective June 8, 2021 through June 7, 2024.
Fast Open Contracts Utilization Services (FOCUS) is California’s only nationwide, local government-to-government purchasing program. It allows cities, counties, schools, special districts and other public entities to acquire technology products and services quickly, easily and at competitive rates. The competitive process is continually refined to best meet needs and offer exceptional productions from nationally acclaimed vendors. The Purchasing Division recommends utilizing the existing competitively bid contract with Telcion Communications Group, Turlock, CA, Contract No. 2021106 for a three-year agreement for Cisco annual licensing and maintenance support for a total amount not to exceed $554,814. Per agreement with supplier, specific language referencing the terms and conditions of the FOCUS Group piggy-back will be added to the Purchase Order.
Modesto Municipal Code Section 8-3.203 generally requires all purchases, which meet or exceed $50,000 for material, equipment or contractual services to be formally bid. However, exceptions to the formal bidding process are granted in MMC 8-3.204(d) “Where the Purchasing Manager, in her discretion, determines that a process other than the formal bid procedure set forth in Section 8-3.203 will result in a procurement for the City at the lowest cost commensurate with the desired quality.” In addition, MMC 8-3.202(h) encourages the Purchasing Manager to join with the State of California and other units of government in cooperative purchasing plans when the best cost savings interest of the City would be served.
FISCAL IMPACT:
Sufficient funds for the Cisco annual licensing and maintenance support services for a threeyear agreement have been budgeted in the FY 21-22 in the Information Technology Fund in account 5230-17810-57005.
COMMITTEE RECOMMENDATION:
This item was presented at the January 24, 2022 Finance Committee and approved to move forward to Council.
RECOMMENDED COUNCIL ACTION:
Staff Recommendations:
Resolution approving the competitive bidding process from Merced County, Fast Open Contracts Utilization Services (FOCUS), Merced, CA for Cisco Annual Licensing and Support 1 www.co.merced.ca.us/Purchasing-Bids
2 Overall responsiveness to the RFP; which includes clarity, completeness and general quality of proposal submitted; comprehensiveness of the bidder’s submitted proposal; Related technical capability, expertise and experience of the Bidder and staff personnel in providing similar services; Performance capabilities, reputation, reliability and service history as determined by reference validations; Capability of the bidder to complete the “Scope of Work” within time frames requires; Bidders acceptance of Terms and Conditions of the RFP and Pricing
3 AMS.net, AT&T, NTT America Solutions, Inc. and Telcion Communications Group #15..
- 483 -
City Council, February 8, 2022
Cisco Annual Licensing and Maintenance Support
Maintenance with Telcion Communications Group, Turlock, CA for a three-year agreement for a total amount not to exceed $554,814; and authorizing the Purchasing Manager, or her designee, to issue a purchase order.
Approved by:
DeAnna Christensen, Director of Finance
Charlie Haase, Chief Information Officer
Joseph P. Lopez, City Manager
Attachments:
1. Resolution
2. Telcion Security Quote TCG000837
3. Telcion Cisco Quote TCG0008314
4. FOCUS RFP 7370
5. Merced County Contract 2021106
6. Telcion Bid Submittal
7. RFB 7370 Consolidated Score Sheet
#15..
- 484 -
1 MODESTO CITY COUNCIL
RESOLUTION NO. 2022-XX
RESOLUTION APPROVING THE COMPETITIVE BIDDING PROCESS FROM
MERCED COUNTY, FAST OPEN CONTRACTS UTILIZATION SERVICES (FOCUS), MERCED, CA FOR CISCO ANNUAL LICENSING AND SUPPORT
MAINTENANCE WITH TELCION COMMUNCIATIONS GROUP, TURLOCK,
CA FOR A THREE-YEAR AGREEMETN FOR A TOTAL AMOUNT NOT TO EXCEED $554,814; AND AUTHORIZING THE PURCHASING MANAGER, OR
HER DESIGNEE, TO ISSUE A PURCHASE ORDER
WHEREAS, the City of Modesto has standardized all switching and routing network equipment on Cisco Systems, Inc; and
WHEREAS, Cisco annual licensing and maintenance support is a support service that provides City staff with direct, 24-hour access to Cisco engineers and an extensive range of technical resources; and
WHEREAS, on November 30, 2020, the Merced County FOCUS Division issued Request for Proposal #7370 for Technology Expertise, Equipment, Service and Systems on the Merced County Purchasing Division website; and
WHEREAS, proposals were formally opened at the Merced County Purchasing Division office on January 15, 2021; and
WHEREAS, based on the scoring criteria defined in the Request for Proposals, four (4) companies were awarded contracts; Contract No. 2021106 was awarded to Telcion Communications Group, Turlock, CA for Technology Expertise, Equipment, Services and Systems effective June 8, 2021 through June 7, 2024; and WHEREAS, Fast Open Contracts Utilization Services (FOCUS) is California’s only nationwide, local government-to-government purchasing program and allows cities, counties, schools, special districts and other public entities to acquire technology products and services quickly, easily and at competitive rates; and #15..
- 485 -
2 WHEREAS, Modesto Municipal Code Section 8-3.203 generally requires all purchases, which meet or exceed $50,000 for material, equipment or contractual services to be formally bid; and
WHEREAS, exceptions to the formal bidding process are granted in MMC 8-
3.204(d) “Where the Purchasing Manager, in her discretion, determines that a process other than the formal bid procedure set forth in Section 8-3.203 will result in a procurement for the City at the lowest cost commensurate with the desired quality.” In addition, MMC 8-3.202(h) encourages the Purchasing Manager to join with the State of California and other units of government in cooperative purchasing plans when the best cost savings interest of the City would be served.
NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves the competitive bidding process from Merced County, Fast Open Contracts Utilization Services (FOCUS), Merced, CA for Cisco Annual Licensing and Support Maintenance with Telcion Communications Group, Turlock, CA for a three-year agreement for a total amount not to exceed $554,814.
BE IT FURTHER RESOLVED, that the Purchasing Manager, or her designee, is hereby authorized to issue a purchase order, a form approved by the City Attorney.
The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 8th day of February 2022, by Councilmember ________, who moved its adoption, which motion being duly seconded by Councilmember ______, was upon roll call carried and the resolution adopted by the following vote:
AYES: Councilmembers:
NOES: Councilmembers:
#15..
- 486 -
3 ABSENT: Councilmembers:
ATTEST: _____________________________
DANA SANCHEZ, Interim City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: _____________________________
JOSE M. SANCHEZ, City Attorney
#15..
- 487 -
Prepared for City of Modesto
2021-9 COM - Cisco DNA/Security Renewal - 3 Years
Quote#TCG008037 v2
PREPARED FOR PREPARED BY
Trina Armendariz
[email protected]
(209) 571-2908
Darren Rodrigues
[email protected]
209 656 5740
140 W. Main Street Turlock, CA 95380
#15..
- 488 -
www.telcion.com - (209) 632-5700
LINE # DESCRIPTION QTY UNIT PRICE EXT. PRICE
Renewal
Past Due Security/DNA Renewals
The pricing offered is less than or equal to the discount provided by the Merced FOCUS contract (45% off minimum).
Cisco has provided addditional promotional discount of approximately $40k if completed by end of January.
This quote includes all DNA and Security Product subscriptions you included in your spreadsheet.
This quote does NOT include any SmartNet renewals (such as CON-ECMUS-SFFMCK9V in spreadsheet.
Thousand Eyes activation comes with the DNA Advantage licensing. City of Modesto will need to activate their Thousand Eyes licensing again once the new DNA Advantage licensing hits the Smart Account to cause the TE-ACTIVE-BF to show up. 1 C9500-DNA-32CA=
C9500 32C, DNA Advantage, Prime Infra LF+AS 2 $0.00 $0.00 2 C9500-DNA-A-3Y Cisco Catalyst 9500 DNA Advantage 3 Year License 2 $6,375.75 $12,751.50 3 C9500-DNA48Y4C-A=
C9500 48Y4C, DNA Advantage, Prime Infra LF+AS 2 $0.00 $0.00 4 C9500-DNA-A-3Y Cisco Catalyst 9500 DNA Advantage 3 Year License 2 $6,375.75 $12,751.50 5 C9300-DNA-A24=
C9300 24P, DNA Adv Lic, Prime Infra LF+AS,
ThousandEyes
36 $0.00 $0.00
6 C9300-DNA-A-24
-3Y
C9300 DNA Advantage, 24-Port, 3 Year Term License 36 $1,059.11 $38,127.96 7 C9300-DNA-A48=
C9300 48P, DNA Adv Lic, Prime Infra LF+AS,
ThousandEyes
30 $0.00 $0.00
8 C9300-DNA-A-48
-3Y
C9300 DNA Advantage, 48-Port, 3 Year Term License 30 $1,986.49 $59,594.70 9 C3560CX-DNA-A
-12=
C3560CX DNA Advantage, 12-port Term license 28 $0.00 $0.00 10 C3560CX-DNA-A
-12-3
C3560CX DNA Advantage, 12-port, 3 Year Term license 28 $368.85 $10,327.80 11 C3850-DNA-A24=
C3850 DNA Advantage, 24-port Term licenses spare 1 $0.00 $0.00 Quote #TCG008037 v2 Page: 2 of 4
#15..
- 489 -
www.telcion.com - (209) 632-5700
LINE # DESCRIPTION QTY UNIT PRICE EXT. PRICE
Renewal
12 C3850-DNA-A-24
-3Y
C3850 DNA Advantage, 24-port, 3 Year Term license 1 $1,059.11 $1,059.11 13 C3850-DNA-A48=
C3850 DNA Advantage, 48-port Term licenses spare 15 $0.00 $0.00 14 C3850-DNA-A-48
-3Y
C3850 DNA Advantage, 48-port, 3 Year Term license 15 $1,986.49 $29,797.35 15 L-FPR2130TTM=
Cisco FPR2130 Threat Defense Threat and Malware
License
2 $0.00 $0.00
16 L-FPR2130T-TM3Y
Cisco FPR2130 Threat Defense Threat and Malware 3Y
Subs
2 $11,525.18 $23,050.36
17 L-FPR2130T-T= Cisco FPR2130 Threat Defense Threat Protection License
4 $0.00 $0.00
18 L-FPR2130T-T3Y
Cisco FPR2130 Threat Defense Threat Protection 3Y
Subs
4 $6,779.52 $27,118.08
19 L-AC-APX-LIC= Cisco AnyConnect Apex Term License, Total Authorized Users
1000 $0.00 $0.00
20 L-AC-APX-3Y-S5 Cisco AnyConnect Apex License, 3YR, 1000-2499 Users
1000 $4.54 $4,540.00
21 L-ISE-PLS-LIC= Cisco ISE Plus License 1500 $0.00 $0.00 22 L-ISE-PLS-3Y-S4 Cisco ISE Plus License, 3Y, 1000 - 2499 Sessions 1500 $12.61 $18,915.00 23 L-ISE-APX-LIC= Cisco ISE Apex License 1500 $0.00 $0.00 24 L-ISE-APX-3Y-S4 Cisco ISE Apex License, 3Y, 1000 - 2499 Sessions 1500 $8.18 $12,270.00 25 AIR-DNA-A= Wireless Cisco DNA On-Prem Advantage, Term, Spare Lic
44 $0.00 $0.00
26 AIR-DNA-A-3Y Wireless Cisco DNA On-Prem Advantage, 3Y Term Lic 44 $292.44 $12,867.36 Subtotal: $263,170.72
Quote #TCG008037 v2 Page: 3 of 4
#15..
- 490 -
www.telcion.com - (209) 632-5700
Prepared by: Prepared for: Quote Information:
2021-9 COM - Cisco DNA/Security Renewal - 3 Years
Telcion
Darren Rodrigues
209 656 5740
[email protected]
City of Modesto
1010 10th Street
Modesto, CA 95354
Trina Armendariz
(209) 571-2908
[email protected]
TCG008037
Version: 2
Quoted Date: 12/22/2021
Expiration Date: 01/31/2022
Ship To:
City of Modesto
1010 10th Street
Modesto, CA 95354
Trina Armendariz
(209) 571-2908
[email protected]
DESCRIPTION AMOUNT
Quote Summary
Renewal $263,170.72
Total: $263,170.72
The pricing on this proposal is valid for 30 days. All prices exclude freight and sales tax.
Payment Terms:
PO: Net 30
Lease: All leasing terms subject to final approval by Cisco Capital. All leases require progress payments.
Telcion
Signature:
Name: Trina Armendariz
Date:
Signature:
Name: Darren Rodrigues
Title: Business Technology Consultant
Date: 12/22/2021
City of Modesto
Quote #TCG008037 v2 Page: 4 of 4
#15..
- 491 -
Prepared for City of Modesto
2021-12 Modesto SmartNet Renewal
Quote#TCG008314 v1
PREPARED FOR PREPARED BY
Larry Chavez
[email protected]
(209) 577-5482
Darren Rodrigues
[email protected]
209 656 5740
140 W. Main Street Turlock, CA 95380
#15..
- 492 -
www.telcion.com - (209) 632-5700
LINE # DESCRIPTION QTY UNIT PRICE EXT. PRICE
SmartNet Contracts:
1 Cisco Quote
#201890469
3 years of SMartNet for all equipment listed in Cisco
quote
1 $291,642.93 $291,642.93
Subtotal: $291,642.93
Quote #TCG008314 v1 Page: 2 of 3
#15..
- 493 -
www.telcion.com - (209) 632-5700
Prepared by: Prepared for: Quote Information:
2021-12 Modesto SmartNet Renewal
Telcion
Darren Rodrigues
209 656 5740
[email protected]
City of Modesto
1010 10th Street
Modesto, CA 95354
Larry Chavez
(209) 577-5482
[email protected]
TCG008314
Version: 1
Quoted Date: 12/30/2021
Expiration Date: 01/27/2022
Ship To:
City of Modesto
1010 10th Street
Modesto, CA 95354
Larry Chavez
(209) 577-5482
[email protected]
DESCRIPTION AMOUNT
Quote Summary
SmartNet Contracts: $291,642.93
Total: $291,642.93
Taxes, shipping, handling and other fees may apply. We reserve the right to cancel orders arising from pricing or other errors.
Telcion
Signature:
Name: Larry Chavez
Date:
Signature:
Name: Darren Rodrigues
Title: Business Technology Consultant
Date: 12/30/2021
City of Modesto
Quote #TCG008314 v1 Page: 3 of 3
#15..
- 494 -
SECTION 1
INTRODUCTION
1.1 INTENT OF THE REQUEST FOR PROPOSAL
It is the intention of Merced County to establish national contracts that satisfy the needs of participating governmental entities in the purchase of technology solutions.
Agencies will be able to purchase on an “as needed” basis from competitively awarded contracts. Respondents are requested to submit their catalog of available products and services as requested in Exhibit 1.
Specifically, the purpose of this Fast Open Contracts Utilization Services (FOCUS) request is to solicit proposals from firms specializing in providing technology solutions that consist of equipment and services. Respondents are encouraged to submit an offering on any and all products or services available that they currently perform in their normal course of business for the opportunity to participate in an innovative County public-private relationship that has national opportunities.
Selected firms will enter into contractual relationships with Merced County. It is anticipated that multiple providers will be selected.
1.2 BACKGROUND INFORMATION
For Public Entities: The Fast Open Contracts Utilization Services (FOCUS) program established over two decades ago, and under State of California procurement guidelines (Gov. Code §25330 – 25338), is a competitively bid procurement vehicle for counties, cities, schools, special districts as well as Federal and state governments to use in the direct purchase of their technology needs through established public entity (County) contracts.
Purpose of FOCUS:
• Provide governmental agencies opportunities for greater efficiency and economy in procuring technology goods and services.
• Take advantage of state-of-the-art purchasing procedures to insure the most competitive contracts are available.
• Provide competitive price and bulk purchasing for multiple government agencies that yields economic benefits unobtainable by the individual entity. • Provide quick and efficient delivery of goods and services. • Equalize purchasing power for smaller agencies that are unable to command the best contracts for themselves.
• Help in assisting with use of best business practices. #15..
- 495 -
For Firms: Under existing FOCUS contracts which begin to expire in 2021, Merced County provides its standing as a governmental jurisdiction offering a contract for government purchasing, marketing assistance, and advocacy at appropriate meetings, conferences, or similar events in return for an administration/marketing fee. In addition, Merced County is authorized to provide and offer, for a fee, consulting services/expertise to a vendor for preparing responses to other government’s bids, general or specific management assistance and other selected areas. Authority for Merced County to engage in these innovative and non-traditional activities is granted under California Government Code.
Respondents shall provide pricing based on a discount from a manufacturer’s price list. A multiple percentage discount structure is also acceptable. Please specify where different percentage discounts apply. Additional pricing and/or discounts may be included. If respondent has existing cooperative contracts in place, Merced County requests equal or better than pricing to be submitted.
Each category proposed is to be priced separately with all ineligible items identified.
Services may be awarded to multiple vendors. Respondents may elect to limit their proposals to a single service within any category, or multiple services within any or all categories.
Merced County is seeking service providers that have the depth, breadth and quality of resources necessary to complete all phases of technology projects. In addition, Merced County also requests any value add commodity or service that could be provided under this contract.
1.3 AGREEMENT TERM
The Agreement term shall be for a period of three (3) years. The start date shall commence upon Merced County Board of Supervisors written approval. Through mutual written agreement, contract term may be extended for two (2) additional, one (1) year terms, not to exceed five (5) years in total, contingent on appropriate and sufficient funding.
A Sample Agreement is included as an attachment to this proposal. This agreement will become part of the final agreement with successful Bidder awarded the proposal.
Any exceptions to the terms and conditions as stated herein and in the Sample Agreement must be identified separately. The County will execute the Agreement upon final selection of successful Bidder with the approval of the County’s Board of Supervisors.
#15..
- 496 -
REQUIREMENTS
1.4 SCOPE OF WORK
The purpose of this FOCUS RFP is to provide the means for counties, cities, schools, special districts and other governmental entities in California and nationally to purchase their needed technology solutions through a formally bid contractual relationship. FOCUS also provides the means for governments to reduce their costs of procurement while leveraging their dollars with other governments to achieve greater buying power. FOCUS offers the possibility of choosing more than one provider in each category. Further, this competitively bid program offers an alternative to existing non-competitively bid programs that may charge the buyer for administrative handling.
Merced County may select multiple vendors in each category for use by other governmental entities. This will allow agencies to pick and choose vendors that best suit their specific needs.
The program design shall incorporate the following requirements and principles to support the proposed technology goods and services described in Exhibit 1, “Category of Services”:
1.4.1. The categories reflect a wide array of requirements under which vendors may propose creative ideas to assist governmental needs with technology solutions.
1.4.2. Organizations/businesses may choose to respond to this Proposal in one or more of the categories. Merced County may choose more than one respondent per category to participate in FOCUS.
1.4.3. Selected FOCUS partners are authorized to add new product lines as needed to replace discontinued product lines. Merced County will be notified in writing of such product changes (with pricing) as they occur with all pricing evaluated by researching the General Services Administration’s online “GSA Advantage!”
1.4.4. Not Specifically Priced Items (NSP) – FOCUS users may order non-contracted products and services that are in support of the contracted items listed on the Purchase Order. Any NSP items must be peripheral and subordinate to the contracted items. The total value of all NSP items shall not exceed 10% of the total price of the Purchase Order.
1.4.5. Merced County reserves the right to receive and process all orders at a future date.
#15..
- 497 -
1.4.6. VENDORS NOT SELECTED FOR A FOCUS CONTRACT MAY NOT USE ANOTHER FIRM’S FOCUS CONTRACT TO QUALIFY FOR OTHER
POLITICAL JURISDICTION CONTRACTS OR SALES AUTHORITY
WITHOUT THE EXPRESS WRITTEN CONSENT FROM THE COUNTY OF
MERCED.
1.4.7. Corporate level management support and resource commitment to the FOCUS program.
1.4.8. Corporate level dedication to at least a California marketing program.
1.4.9. Corporate level commitment to their sales force in promoting the FOCUS program and rewarding successes.
1.4.10. An aggressive marketing strategy.
1.4.11. Excellence in customer support and service.
1.4.12. A commitment to use local providers and/or contracted services where a corporate presence does not exist.
1.4.13. A commitment to include Merced County in semi-annual FOCUS planning/strategy meetings.
1.4.14. A commitment to meet on FOCUS progress each quarter.
1.4.15. A product and service quality assurance program that meets or exceeds industry excellence standards.
1.4.16. The most competitive pricing given to a state/local government agency for the array of products and/or services offered. All pricing is evaluated by researching the General Services Administration’s online “GSA Advantage!” NOTE: Pricing offered must reflect across the board percentages of discount for every item/service submitted. Bidder must state in their proposal what percentages of discount are being offered in their proposal.
1.4.17. An ability to include industry leaders in the corporate and product suites offered through subcontractor relationships.
1.4.18. An on-line order placement/tracking system for immediate input or retrieval of information/acknowledgments.
1.4.19. Describe the level of availability for access and customer support.
1.4.20. As required, a customer help desk (800 number/on-line access) to assist customer technical and administrative issues.
#15..
- 498 -
1.4.21. Product, service, and installation excellence to any location that meets industry’s highest standards.
1.4.22. The availability and inclusion of product supplies, product training, networking services (if appropriate), and product maintenance.
1.4.23. All product installations and modifications performed by supplier will be by manufacturer-authorized personnel and meet manufacturer-documented specifications, unless otherwise specifically stated in the purchase order/ Statement of Work.
1.4.24. All respondents offering technology services must be certified by the California Public Utilities Commission (CPUC) to offer those services.
Evidence of certification from CPUC must be provided with response.
1.4.25. All products offered in response to this FOCUS RFP must meet or exceed the specifications of the referenced brands.
1.5 PROGRAM REQUIREMENTS:
The following are the minimum requirements in Bidder’s administration of the program and must fully demonstrate an understanding and commitment to this creative business (public-private) alliance.
1.5.1. MANDATORY ADMINISTRATIVE REQUIREMENTS
1.5.2. Notify Merced County of all sales made under FOCUS, including order/delivery progress, within fourteen (14) business days of order.
1.5.3. Quarterly and annual sales reports.
1.5.4. A product/service documents, paper or electronic – to be produced at least four (4) times per year. NOTE: Electronic documents shall be updated immediately for price reductions. The document must show the array of product/service offerings, product/service descriptions, and pricing schedules based on single item purchases. If appropriate, greater price reductions are expected as volume on identical items is increased. A percent of volume discount must be provided prior to order.
1.5.5. Price increase/price decline policies. Note: All price reduction changes must be published within 72 hours.
1.5.6. Ordering, reporting, and reconciliation procedures: All FOCUS purchase orders must state F.O.B. Destination. In the event that a FOCUS user requests expedited shipping, only the expedited shipping charges may be passed through to that specific FOCUS user.
1.5.7. New product/service offerings expected within six (6) months.
1.5.8. Support services including help desk phone numbers. #15..
- 499 -
1.5.9. Warranty statements.
1.5.10. Return procedures, if applicable.
1.5.11. Point of contact including phone/fax/e-mail information.
1.6 ELECTRONIC CATALOG CONFIGURATION
The following are the minimum requirements in respondent’s electronic document configurations:
1.6.1. Ordering procedures.
1.6.2. Product listing/pricing.
1.6.3. System configurations, if applicable.
1.7 OTHER ADMINISTRATIVE REQUIREMENTS
In order to make the FOCUS a complete procurement tool for all governmental entities, the respondent to the Proposal must concisely address their policies regarding:
1.7.1. Invoices and payments.
1.7.2. Taxes on sales and services.
1.8 ADMINISTRATIVE FEES
The awarded vendor agrees to pay quarterly administrative fees to County as calculated as follows:
(Sales will be calculated for fiscal year of January 1st through December 31st and reset each year)
Annual Sales Through Contract Administrative Fee
$0 - $2,000,000 1%
$2,000,000+ 0.5%
#15..
- 500 -
SECTION 2
RESPONSE FORMAT AND CONTENT
2.1 GENERAL INFORMATION
This section describes the required response format and content. The response should contain the requested information organized by the prescribed section and subsection numbers and titles. Any information provided beyond that required in the response should be contained in a section entitled "Optional Exhibits and Attachments”.
Each Bidder shall submit a complete response, providing all information requested and a complete description of the functional operation of the program/project proposed. Failure to follow the prescribed format may result in rejection of your response.
Responses must be complete in all aspects. A response may be rejected if it is conditional or incomplete, or if it contains any alteration of form or other irregularities of any kind. A response may be rejected if any such defect or irregularity constitutes a material deviation from the proposal requirements. The response must contain all costs required by the proposal.
2.2 RESPONSE FORMAT
The response must be developed on the forms provided in this package, or must follow the proposal content requirements in the order in which they appear in the proposal. Responses that do not conform to this format may not be considered for evaluation. All responses must be submitted in the name of the legal entity or authorized agency. Responses must be signed in ink by the officer or officers legally authorized to bind the company, partnership or corporation.
The content and sequence of the response will be as follows:
2.2.1 Signature Page (Attachment A)
2.2.2 Bond(s) (If any)
2.2.3 Table of Contents
2.2.4 Executive Summary
2.2.5 Exceptions
2.2.6 Approach
2.2.7 Bidder's Qualifications
2.2.8 Cost Proposal
2.2.1 Signature Page
Bidder must complete and return the enclosed Signature Page (Attachment A, “Signature Page”). The Signature Page must be signed in blue ink by the officer or officers legally authorized to bind the company, partnership, or corporation.
#15..
- 501 -
2.2.2 Bond(s)
Bidder must enclose any bonds as required in the RFP.
2.2.3 Table of Contents
The Table of Contents must be a comprehensive listing of the contents included in your response. This section must include a clear definition of the material, exhibits and supplemental information identified by sequential page numbers and by section reference numbers.
2.2.4 Executive Summary
The Executive Summary shall condense and highlight the contents of the Bidder’s Business Response to provide the Evaluation Committee with a broad understanding of the Bidder’s approach, qualification, experience and staffing.
2.2.5 Exceptions
This portion of the response will note any exceptions to the requirements and conditions taken by the Bidder. Exceptions should clearly explain why the Bidder is taking exception to the requirements. If exceptions are not noted, the County will assume that the Bidder's response meets those requirements as specified herein and that the Bidder accepts and intends to abide by all stated terms, conditions, and requirements. Exceptions will be considered by the County, and will form a part of any resulting Agreement, only if the County explicitly so states in writing.
Exceptions shall be noted as follows:
• Exceptions to the Requirements
• Exceptions to any other part of this RFP
• Exceptions to terms in the Sample Agreement
2.2.6 Approach
The Bidder’s response shall clearly describe in detail how the Bidder will meet the requirements of this proposal and perform the Requirements.
Additionally, the response should provide any special or unique qualifications which the Bidder believes it possesses to meet the requirements of this proposal. Only those levels of performance the Bidder actually believes can be accomplished should be stated as measurable objectives. Each of the major tasks, or activities to be undertaken, as a means of reaching such objectives, must be specifically identified. Display the essential points of activity in a time sequence showing the amount of time allotted to each activity.
#15..
- 502 -
The merit of each response received in response to this proposal will be judged largely on the basis of each Bidder’s narrative description as described in the Approach of their response. It is important that your response contain all information required for an effective review process. The response should be written in such a manner to provide sufficient detail to enable the Evaluation Committee members to know what is planned at every stage, and to make a judgment as to the probable success of the proposed effort.
(A benchmark chart may be completed to display the time frame for achieving and accomplishing each major program/project task or activity. Flowcharts and other related graphics may accompany this section.)
2.2.7 Bidder's Qualifications
Bidder shall provide a concise statement demonstrating that the Bidder’s company has the qualifications, experience, and capability to perform the requirements of this proposal. The following sections must be included:
a) History
Provide a brief history of your company, including the number of years in business. State whether your organization is an individual proprietorship, partnership, corporation, or private nonprofit organization, and the date your company was formed or incorporated. Provide a statement as to any judgment, litigations, licensing violations, or other violations, outstanding or resolved, against your company in the past five (5) years. b) Background and Experience
A summary of relevant background information describing your company’s experience of major accomplishments and/or activities similar to the requirements set forth under this proposal, which demonstrates your company's ability to provide the service described in your response. c) References
Provide a list of at least three (3) customer references. Include the firm’s name; the name, title, and telephone number of a contact person; the dollar amount of the Agreement; and the dates that these services were completed.
Bidder may provide sample material of your company's work to substantiate your previous experience.
d) Staff Assignment
A brief description of the experience and qualifications of the proposed key staff members assigned to this program/project and what percentage of their time will be devoted to the program/project. Show their function, level of education, degree and license, if appropriate, and a detailed resume for each #15..
- 503 -
person. Additionally, the Bidder must specify where the staff will be located and identify the program/project manager.
2.2.8 Cost Proposal
It is essential that all responding Bidders include and clearly detail all costs, payment schedules, categorization of line items, and/or other related costs associated with your response. All responses must have a narrative providing a thorough and clear explanation of your costs.
#15..
- 504 -
SECTION 3
BASIS OF AWARD, SELECTION PROCESS AND EVALUATION CRITERIA
3.1 BASIS OF AWARD
Award will be made to the Bidder(s) whose response demonstrates to be the most qualified, responsive and advantageous to the County. The County shall not be obligated to accept the lowest cost response or limit their award to a single Bidder, but will make an award in the best interests of the County after all factors have been evaluated (“most responsive response(s)”).
THE COUNTY RESERVES THE RIGHT, AT ITS SOLE DISCRETION, TO REJECT
ANY OR ALL RESPONSES OR ANY PART THEREOF, OR TO WAIVE ANY
INFORMALITIES IN THE RESPONSE AND MINOR IRREGULARITIES,
TECHNICAL DEFECTS OR CLERICAL ERRORS, TO MAKE AN AWARD ON THE
BASIS OF SUITABILITY, QUALITY OF SERVICE(S) TO BE SUPPLIED, THEIR
CONFORMITY WITH THE SPECIFICATIONS AND FOR THE PURPOSES FOR WHICH THEY ARE REQUIRED, AND NOT CONFINED TO COST ALONE. THE
COUNTY SHALL NOT BE LIABLE FOR ANY COSTS INCURRED BY THE BIDDER
IN CONNECTION WITH THE PREPARATION AND SUBMISSION OF THIS OR ANY OTHER RESPONSE.
False, incomplete, or nonresponsive statements in connection with the response may be deemed sufficient cause for rejection. The County shall be the sole judge in making such determination. The County reserves the right to cancel or discontinue with the response process and reject any or all responses in the event it determines that there is no longer a requirement for the furnishing of such items, materials, equipment and/or services, funding is no longer available for this proposal, or it is otherwise in the County's best interest to cancel the proposal process.
3.2 EVALUATION PROCESS
The Evaluation Committee will consider only those responses which have been considered responsive to the proposal. Any response which fails to meet the requirements of the proposal will be considered non-responsive and may be rejected. Responsiveness includes attention to detail in following the proposal format. The Evaluation Committee may also contact and evaluate the Bidder’s and the Sub-Contractors references; contact any current users of a Bidder’s services; solicit information from any available source concerning any aspect of a response; and seek and review any other information deemed pertinent to the evaluation process. The Evaluation Committee shall not be obligated to accept the lowest priced response, but shall recommend such response that is the most qualified, responsive and cost-effective response and in the best interest of the County (“most responsive response”).
The RFP responses will be evaluated based on the below scoring criteria and county may award to multiple bidders, if necessary:
#15..
- 505 -
CRITERIA POINTS
1. Overall responsiveness to the Request for Proposal; which includes clarity, completeness and general quality of the proposal submitted. 10
2. Comprehensiveness of the Bidder’s submitted proposal; which takes into account the Bidders understanding of the desired “Scope of Work” and the ability to perform such work as evidenced by Bidder’s proposal response.
30 3. Related technical capability, expertise and experience of the Bidder and staff personnel in providing similar services; which includes current and past experience.
20 4. Performance capabilities, reputation, reliability and service history as determined by reference validations. 10
5. Capability of the Bidder to complete the “Scope of Work” within time frames required. 10
6. Bidder’s acceptance of Terms and Conditions of the RFP. 10 7. Pricing.
10 Total Possible Points 100
#15..
- 506 -
SECTION 4
TERMS AND CONDITIONS
4.1 REQUEST FOR PROPOSAL CLOSING DATE
Without law or policy to the contrary, if the Bidder took reasonable steps to submit the response in due time, and failure of the response to be on hand at the time of closing was not the result of negligence or other fault of the Bidder, but was the result of negligence by the County, the County reserves the right to accept such response.
All responses shall remain firm for at least one hundred twenty (120) days following the proposal closing date. The County reserves the right to withhold an award of the proposal for one hundred twenty (120) days from date of closing.
All responses and accompanying documentation submitted by the Bidders, will become the property of the County. Responses shall be based on the material contained in the proposal. Bidders are instructed to disregard any prospective oral representations it may have received prior to the solicitation of the proposal.
Cost for developing and preparing the response is solely the responsibility of the Bidder whether or not any award results from this solicitation. Further, the cost of developing and preparing responses to the proposal will not be allowed as direct or indirect charges under any resulting Agreement.
No alteration in any of the terms, conditions, delivery, price, quality, quantities, or specifications will be effective without prior written consent of the County.
THE COUNTY RESERVES THE RIGHT, AT ITS SOLE DISCRETION, TO REJECT
ANY OR ALL RESPONSES OR ANY PART THEREOF, OR TO WAIVE ANY
INFORMALITIES IN THE PROPOSAL AND MINOR IRREGULARITIES,
TECHNICAL DEFECTS OR CLERICAL ERRORS, TO MAKE AN AWARD ON THE
BASIS OF SUITABILITY, QUALITY OF SERVICE(S) TO BE SUPPLIED, THEIR
CONFORMITY WITH THE SPECIFICATIONS AND FOR THE PURPOSES FOR WHICH THEY ARE REQUIRED, AND NOT CONFINED TO PRICE ALONE. THE
COUNTY SHALL NOT BE LIABLE FOR ANY COSTS INCURRED BY THE BIDDER
IN CONNECTION WITH THE PREPARATION AND SUBMISSION OF THIS OR ANY OTHER PROPOSAL.
4.2 ANNOUNCEMENT OF RESPONSES
All responses received by the published date and time for submission will be publicly displayed at the Department of Administrative Services-Purchasing at 2222 “M” Street, Merced, California 95340 and our Supplier Portal Site. All information contained in the responses shall be confidential to avoid disclosure of contents prejudicial to competing Bidders during the evaluation process. No award decision, pricing, or exchange of views will be discussed at time of opening. #15..
- 507 -
4.3 INTERPRETATION, CORRECTIONS AND AMENDMENTS
The Bidder must carefully examine the specifications, terms and conditions provided in the Request for Proposal and become fully informed as to the requirements set forth therein. If anyone planning to submit a response discovers any ambiguity, conflict, discrepancy, omission or error in the proposal, has any questions in relationship to the “REQUIREMENTS”, or any other related matters, Bidder shall immediately submit their request for clarification or modification of the RFP no later than the Question and Answer deadline. No further requests for clarification or objections to the proposal will be accepted or considered after this date. Any change in the proposal will be made only by written amendment, issued by the Department of Administrative Services-Purchasing to each vendor on the Bidders list as well as posted on the County website, and shall be incorporated in the proposal. Any oral communication by the County’s designated contact person or any other County staff member concerning this proposal is not binding on the County and shall in no way modify this proposal or the obligations of the County or any Bidders.
4.4 DISCUSSION WITH RESPONSIBLE BIDDERS AND CLARIFICATIONS TO
PROPOSAL
All Bidders submitting a response for consideration agree that their company will be willing to enter into a final Agreement if awarded this proposal. The County may, in its sole discretion, negotiate certain terms and conditions of such final Agreement after identification of the apparent successful Bidder. However, Bidders should not assume that any terms of this RFP or other applicable terms and conditions are subject to later negotiation, and should instead assume that all such terms and conditions are mandatory conditions of participation in this RFP process. Negotiated changes, if any, will not change the “Requirements”.
4.5 FALSE OR MISLEADING STATEMENTS
Responses which contain false or misleading statements, or which provide references which do not support an attribute or condition claimed by the Bidder, may be rejected. If, in the opinion of the County, such information was intended to mislead the County in its evaluation of the response, and the attribute, condition or capability is a requirement of this proposal, it will be the basis for rejection of the response.
4.6 INDEPENDENT CONTRACTOR
It is expressly understood that in the performance of any services resulting from this proposal, Bidder is an Independent Contractor and is not an agent or employee of the County and warrants that all persons assigned to the program/project are employees, or subcontractors, of the Bidder. In the event the awarded Bidder shall employ others to complete or perform the services provided, Bidder shall be solely responsible and hold the County harmless from all matters relating to the payment of such person(s).
#15..
- 508 -
It is mutually understood and agreed that no employee-employer relationship will be created between County and Bidder or County and Bidder’s employees, and that the awarded Bidder shall hold County harmless and be solely responsible for withholding, reporting and payment of any federal, state or local taxes, contributions or premium imposed or required by workers' compensation, unemployment insurance, social security, income tax or other statutes or codes applying to Bidder, or its sub-Contractor(s) and employees, if any. It is mutually agreed and understood that the Bidder, its Sub-Contractor(s) and employees, if any, shall have no claim under any Agreement that may result from this proposal or otherwise against County for vacation pay, sick leave, retirement or social security benefits, occupational or non-occupational injury, disability or illness, or loss of life or income, by whatever cause.
4.7 EXPLANATION OF USE OF SUB-CONTRACTORS
Any Bidder using a Sub-Contractor(s) must clearly explain the use of the SubContractor(s) and list the name(s) of the Sub-Contractor(s) providing work under this proposal. The selected Bidder will be fully responsible for all work performed under this proposal and will be considered as the Prime Contractor. Any Sub-Contracting, or other legal arrangements made by the Bidder are the sole responsibility of the Bidder. Any Agreement that is entered into between the selected Bidder and the Sub-Contractor(s) shall contain provisions for federal and state access to the books, documents, records, and inspection of work. Bidder awarded any Agreement as a result of this proposal shall obtain County written approval of sub-contractors identified in Bidder submittal prior to execution of Agreement.
4.8 JOINT VENTURES
In the event a response is submitted jointly by more than one organization, one legal entity must be designated as the Prime Contractor. All other participants shall be designated as Sub-Contractors.
4.9 CONFIDENTIALITY
The contents of all responses, correspondence, agenda, memoranda, or any other medium which discloses any aspect of a Bidder’s response shall be held in the strictest confidence until after negotiations for the contract are negotiated. If you contend that any submission contains trade secrets or proprietary data, please be advised that the County cannot and does not give any assurances or guarantees that such information will not be released under the California Public Records Act.
The Bidder should clearly mark any of the information within their response that is proprietary, however, the County will be guided by the California Public Records Act and the definition of Trade Secrets under California Civil Code Section 3426.1, but in no case will the following be considered proprietary: a) the final cost of the bid or response; b) information that is not clearly marked as proprietary in nature; c) information that, though marked as proprietary, is not actually proprietary d) information that is otherwise generally available as information or technology within the subject trade, industry or profession.
#15..
- 509 -
BIDDER SHALL NOT DESIGNATE THE ENTIRE RESPONSE AS PROPRIETARY.
SUCH ATTEMPTED DESIGNATION WILL NOT BE HONORED.
Submission of a response by a Bidder shall constitute an agreement to the provision for public announcement. The County shall not be obligated to release information contained in any Bidder’s RFP submittal that has been marked as proprietary, without the written consent of the Bidder. Any agency requesting such information so marked as proprietary must obtain such written authorization directly from Bidder and forwarded to County.
County shall not be required to contact any Bidder for information on behalf of any requesting agency. Merced County shall have the sole discretion and exclusive authority to determine if any other party has properly obtained the right to have access to proprietary information.
4.10 PUBLIC AGENCY PARTICIPATION
Any public agency, i.e., city, district, public authority, public agency, municipality and other political subdivision or a public corporation (hereinafter referred to as Public Agency) shall have the option of participating in any award made as a result of this proposal at the same prices, and terms and conditions. The County is not an agent, partner, or representative of the Public Agency, and is not obligated or liable for any financial responsibility in connection with purchase orders issued by any Public Agency. The Public Agency shall accept sole responsibility for placing orders or payments to the successful Bidder.
4.11 PRICING CONDITIONS
All responses shall remain firm for at least one hundred twenty (120) calendar days after RFP Submittal Deadline unless otherwise specified. Within one hundred twenty (120) calendar days after the RFP Submittal Deadline opening, a purchase order and/or an Agreement may be awarded by the County, as it may deem proper, in its absolute discretion. The time for awarding a purchase order and/or an Agreement may be extended at the sole discretion of the County, if required to evaluate responses or for such other purposes as the County may determine.
4.12 DETERMINATION OF BIDDER’S RESPONSIBILITY
• Responsible Bidder
A responsible Bidder is a Bidder who has demonstrated the attribute of trustworthiness, as well as quality, fitness, capacity, financial strength, and experience to satisfactorily perform the Agreement. It is the County’s policy to conduct business only with responsible Bidders.
• Non-responsible Bidder
The County may declare a Bidder to be non-responsible for purposes of this proposal for a variety of reasons, some of which are listed below. This is not #15..
- 510 -
an exclusive list - reasons may include the following but are limited to the below:
Committed any act or omission which negatively reflects on the Bidder’s quality, fitness, financial strength, or capacity to perform any Agreement that may be derived from this proposal with the County or an Agreement with any other public entity, or engaged in a pattern or practice which negatively reflects on same; or Committed an act or omission which indicates a lack of business integrity or business honesty; or
Made or submitted a false claim against the County or any other public entity; or
Submitted false, incomplete or unresponsive statements or omitted requested documentation in connection with this proposal.
4.13 PUBLIC DISCLOSURE
All public records of the County are available for disclosure except the contents of the responses received in response to an RFP, which are not open for public review until the contract between the awarded Bidder and the County is agendized with the Board of Supervisors. In the event that an unsuccessful Bidder files an official request to view the awarded Bidder’s response, the County must comply with appropriate public disclosure procedures. However, if information specifically designated in the response as proprietary is requested County may attempt to notify Bidder should Bidder wish to pursue protections against disclosure, at its own cost, so that the information will not be made available.
Pursuant to the California Public Records Act, Government Code Sections 6250 et seq., any contract that eventually arises from this Request for Proposal is a public record, in its entirety. Also, all information submitted in response to this Request for Proposals is itself a public record without exception, and will be disclosed upon request, but only after negotiations are complete. Submission of any materials in response to this Request for Proposals constitutes your consent to release materials, and a waiver of any claim that the information is protected from disclosure.
Furthermore, by submitting materials, you agree to indemnify and hold harmless Merced County for release of such information.
4.14 QUALIFICATIONS OF BIDDER
The County may make such investigation as it deems necessary to determine the ability of the Bidder to provide the services requested herein, and the Bidder shall furnish to the County all information and data for this purpose as the County may request. The County reserves the right to reject any response should the evidence submitted by, or investigation of, the Bidder fails to satisfy the County that such Bidder is properly qualified to carry out the obligations of the proposal and to complete the requirements contemplated therein.
#15..
- 511 -
4.15 DISQUALIFICATION OF BIDDER
A Bidder may be disqualified and the response rejected, in addition to any other cause for rejection as set forth elsewhere in this proposal, for any of, but not limited to, one of the following reasons:
• Proof of collusion among Bidders, in which case all responses involved in the collusive action will be rejected and any participant to such collusion will be barred from future bidding until reinstated as a qualified Bidder. • Lack of responsibility or cooperation as shown by past work or services provided to the County or others.
• Being in arrears on existing Agreements with the County or having defaulted on previous Agreements.
• Incomplete information or missing documents as required in the proposal.
4.16 INTEGRITY OF EXPENDITURE
The Bidder assures that every reasonable course of action will be taken to maintain the integrity of expenditure of public funds and to avoid any favoritism, questionable, or improper conduct.
4.17 GRATUITIES
Neither the Bidder nor any person, firm, or corporation employed by the Bidder shall give, directly or indirectly, to any employee or agent of the County, any gift, money, or anything of value, or any promise, obligation, or Agreement for future reward or compensation, neither during the proposal process nor during the performance of any Agreement period resulting from this proposal.
4.18 CONFLICT OF INTEREST
The Bidder covenants that it presently has no interest and shall not acquire any interest, direct or indirect, which would conflict in any manner or degree with the performance of this proposal. Bidder shall make all reasonable efforts to ensure that no conflict of interest exists between its officers, employees, or sub-Contractor(s), and the County. Bidder shall make all reasonable efforts to ensure that no County officer or employee, whose position in the County enables them to influence any award of this proposal or any competing offer, shall have any direct or indirect financial interest resulting from any Agreement that may be derived from this proposal or shall have any relationship to the Bidder or officer or employee of the Bidder, nor that any such person will be employed by Bidder in the performance of any Agreement that may be derived from this proposal without immediate divulgence or such fact to the County.
4.19 FEDERAL, STATE, AND LOCAL TAXES
The awarded Bidder shall pay all taxes lawfully imposed upon it with respect to this proposal or any product delivered with respect to the Agreement. The County makes #15..
- 512 -
no representation whatsoever as to the exemption from liability to any tax imposed by any government entity on the awarded Bidder.
4.20 OSHA REQUIREMENTS
All material, equipment, or labor submitted under this proposal by Bidder shall meet the required standards of OSHA 1970 and CA-OSHA 1973. Bidder warrants that the described material, equipment or labor meets all appropriate OSHA safety and health requirements. Further, it warrants that the said material or equipment will not produce or discharge in any manner or form, directly or indirectly, chemicals or toxic substance that could pose a hazard to the health or safety of anyone who may use the material or equipment or come into contact with the material or equipment.
4.21 ENVIRONMENTAL PROTECTION
The Bidder awarded the Agreement resulting from this proposal shall be in compliance with all applicable standards, orders or requirements issued under Section 306 of the Clean Air Act (41 USC 1857(h)), Section 508 of the Clean Water Act (33 USC, 1368), Executive Order 11738, and Environmental Protection Agency regulations (40 CFR, Part 15) which prohibits the use under nonexempt federal Agreements, grants, and loans of facilities included on the EPA List of Violating Facilities. The Contractor shall report violations to the applicable federal agency and the US EPA Assistant Administrator for enforcement.
4.22 DRUG FREE WORK PLACE
The awarded Bidder must certify that it will provide a drug-free workplace as set forth by the Federal Drug-Free Workplace Act of 1988.
4.23 PREVAILING WAGE RATES
Should the proposal call for the Bidder to be responsible for any site preparation activities, the Bidder will be required to certify adherence to the requirements of all state and federal laws relating to the payment of prevailing wage rates for work performance under public works project laws, specifically, as covered by the federal Davis-Bacon Act and California Labor Code 1720 et seq. A copy of this wage scale may also be obtained from the office of the Director of Industrial relations, State of California, or http://www.dir.ca.gov/DLSR/PWD/mer.xls
It shall be mandatory upon the Bidder to whom the Agreement is awarded, and upon all sub-Contractor under him, to ascertain and pay not less than the latest general prevailing hourly rates for Saturday, Sunday, holidays, and overtime work for each workman or mechanic employed in the execution of the work of this project as per determination made by the Director of Industrial Relations, California Labor Code, Part 7, Chapter 1, Article 2, Sections 1770, 1773, and 1773.1. #15..
- 513 -
4.24 COMPLIANCE WITH APPLICABLE LAWS
The successful Bidder shall otherwise perform all obligations under the resulting Agreement in compliance with all applicable federal, state, and local laws, rules, regulations, and policies.
No Contractor or sub-Contractor(s) may be listed on a bid response for a public works project (submitted on or after March 1, 2015) unless registered with the Department of Industrial Relations pursuant to Labor Code section 1725.5 [with limited exceptions from this requirement for bid purposes only under Labor Code section 1771.1(a)].
No Contractor or sub-Contractor(s) may be awarded an Agreement for public work on a public works project (awarded on or after April 1, 2015) unless registered with the Department of Industrial Relations pursuant to Labor Code section 1725.5.
This project is subject to compliance monitoring and enforcement by the Department of Industrial Relations.
4.25 LEGAL CONSIDERATIONS
Any Bidder, by submission of a response to this proposal, and any subsequent Agreement that may be derived from this proposal, shall be deemed and have agreed to be bound by the laws of the State of California in all respects as to interpretation, construction, operation, effect and performance.
Notwithstanding any other provisions of this proposal, any dispute concerning any question of fact or law arising under this proposal, or arbitration arising out of any Agreement that may be awarded as a result of this proposal, shall be tried in Merced County, unless the parties agree otherwise or are otherwise required by law.
4.26 OUT-OF-STATE BIDDER
Where the Bidder is an Out-Of-State Bidder, not doing business in the State of California, the package bid or purchase price, for the purpose of determining the lowest price bid, shall be increased by applicable retail rate of general sales tax and use tax when and where applicable.
4.27 LOCAL BUSINESS PURCHASING PREFERENCE
Notwithstanding any other provision contained herein to the contrary, a ten percent (10%) preference shall be granted to local business whenever the purchasing agent of Merced County purchases services, supplies, materials and/or equipment for county use through the competitive bid process, which shall be defined herein to include quotes, bids, and proposals. The purchasing agent in evaluating competitive bids shall determine the lowest responsive Bidder, and if the lowest responsive Bidder is a non-local Bidder then a ten percent (10%) preference shall be granted to local Bidders. Local preference only applies to the procurement of services, supplies, materials and/or equipment, and will not apply to bids conducted with other public agencies nor when prohibited by state or federal statutes or regulations to be #15..
- 514 -
awarded to the “lowest responsible Bidder” or otherwise exempted from local preference. A local bidder is defined as:
a. A principal place of business located within the County of Merced with a valid and verifiable business license, if applicable, issued by a city within the County or a business located in the unincorporated areas of the County. Post Office Boxes do not qualify as verifiable local business addresses; b. Employs at least one (1) full-time employee within the County, or if the business has no employees, shall be at least fifty percent (50%) owned by one or more persons whose primary residence(s) is located within the County; and
c. Has had a fixed office or place of business having a street address within the County for at least six (6) months immediately prior to the issuance of the request for competitive bids by the County.
The ten percent (10 %) local preference shall be deducted from the total dollar amount bid by local Bidders on competitive quotes and bids, and assess on the total evaluated aggregate score obtained by local Bidders on proposals (County of Merced County Policy, Chapter 5.12.025, “Local Business Purchasing Preference” Policy).
4.28 BUSINESS LICENSE
Prior to the issuance of any purchase order and/or the performance of any Agreement derived from this bid, the successful bidder and its sub-Contractors shall be required to maintain a Merced County Business License in accordance with the County of Merced Ordinance No. 1705, “An Ordinance Establishing a requirement for a Business License and Temporary Business License and/or persons operating in the unincorporated areas of Merced County”
(http://www.qcode.us/codes/mercedcounty/).
It is the intent of the Board of Supervisors of the County of Merced to authorize that no person shall maintain, conduct, or carry-on a business, whether or not for profit, located in whole or in part at a fixed place of business within the County and outside the limits of any incorporated city, without first obtaining a license to operate as provided under the County of Merced Ordinance No. 1705. #15..
- 515 -
DEFINITIONS
Agreement - Comprises the Request for Proposal (RFP), any amendment thereto, the bid proposal, and the purchase order if appropriate. The Agreement constitutes the entire agreement between the County and the awarded Bidder.
Bidder - A person, partnership, firm, corporation, or joint venture submitting a bid response for the purpose of obtaining a County Agreement.
Bonds –
Fidelity Bond - Also referred to as a Dishonesty Bond. A fidelity bond is a form of protection that covers the County for losses as a result of fraudulent acts by the Contractor.
Proposal Security Bond – Also referred to as Bid Security. A bond that is submitted with Bidder’s response to compensate the County for damages it might suffer if successful bidder refuses to execute the Agreement that may be derived from their response.
Generally, it is 10% of the amount of Bidder’s bid as bid security.
Performance Bond – A bond to ensure completion of the project as requested under the “Scope of Work”. The Performance Bond is backed by a surety who guarantees the project will be completed in accordance with the specifications of the proposal.
Payment Bond – This bond is to protect sub-Contractors and suppliers. It ensures that the surety backing the bond will pay the sub-Contractors and suppliers if the general Contractor does not.
County - The County of Merced, a political subdivision of the State of California.
Deliverable - The physical evidence such as documentation, certification of completion, hardware/software delivery, etc. which shows that a specific work has been completed as specified in the "Requirements".
Evaluation Committee - A committee established to review and evaluate responses to determine the Agreement award. The committee includes representatives of the department seeking the goods or services.
Goals/Tasks - A discrete unit of work to be performed.
Joint Ventures - Two or more corporations or entities that form a temporary union for the purpose of the RFP.
Prime Contractor – The Bidder who is awarded the Agreement and designated as the legal entity. The Prime Contractor will hereafter also be known as the Contractor. Any subContracting, Joint Ventures, or other legal arrangements made by the Contractor during this project are the sole responsibility of the Contractor.
Proposal Deadline - The closing date associated with this proposal. #15..
- 516 -
Proprietary – The information provided that is considered exempt from public disclosure defined as Trade Secrets under Civil Code Section 3426.1, pursuant to Public Records Act.
Scope of Work - The mutually agreed to document which describe tasks, dependencies, the sequence and timing of events, deliverables, and responsible parties associated with the various phases of the proposal.
Sub-Contractors - Any person, entity or organization, to which Contractor or County has delegated any of its obligations hereunder.
Work Plan - The mutually agreed to document, which describes task, dependencies, the sequence and timing of events, deliverables, and responsible parties, associated with the various phases of the proposal.
#15..
- 517 -
EXHIBIT 1- CATEGORY OF SERVICES
Contractor should be prepared to demonstrate how they will provide standard and advanced information technology, telecommunications, imaging, homeland security technology
CATEGORY HOW
SUPPLIED
% DISCOUNT
OFF LIST
PRICE
1.0 Communications Services
Call Center Solutions (with ACD)
Emergency Notification Solutions (Reverse 911)
Engineering/Consulting Services
Integrated Voice Response (IVR)
/
Voice over Internet Protocol (VOIP)
Unified Messaging (UM)
Long Distance Services (Switched, Dedicated)
Telecommunications Systems (PBX)
Telephone Handsets
Voice Mail Solutions
Wireless Voice Communication Services
2.0 Application Systems
Development
Installation Solutions
Version Control Solutions
3.0 Infrastructure
Battery Backup Systems
Cabling Services
Energy Auditing and Management Solutions
4.0 Enterprise Mobility Solutions
#15..
- 518 -
Mobile Device Management
Mobile Devices (Tablets)
Mobile Applications
5.0 Maintenance Services
6.0 Network & Enterprise Security Solutions
Firewall & Virtual Private Network (VPN) Solutions
Intrusion Detection/Prevention Solutions
Network, Host & Enterprise Management Solutions
Transport Solutions (PRI, MPLS, Super-trunks, CO
Business Lines, Optical, Satellite, Wireless)
Video Solutions
Wireless Solutions (Wi-Fi)
7.0 E-Government
Web Site Analytics
Web Site Content Management Solutions
Web Site Design, Development, Hosting Services
Web Site Development Tools
Web Site Intranet Solutions
Web Monitoring & Filtering Solutions
Web Site Portal Solutions
8.0 Enterprise Systems
Virtualization (Servers)
Virtual Desktop Infrastructure (VDI)
Anti-Virus, Spam, Spyware Solutions
Data Encryption Products & Services
Helpdesk Solutions
Hosting Services and Applications (Cloud and SaaS)
#15..
- 519 -
Radio Frequency Identification (RFID)
Server, Storage & Data Management Products
Telepresence/Video Conferencing
9.0 Training Solutions
10.0 Consulting Services
11.0 Other Goods and Services
#15..
- 520 -
AGREEMENT FOR SPECIAL SERVICES
MERCED COUNTY
CONTRACT NO.
THIS AGREEMENT, is made and entered into by and between the County of Merced, a political subdivision of the State of Califomia, (hereinafter referred to as "County"), and Telcion Communications Group, a Califomia corporation, located at 140 West Main Street, Turlock, California, 95380 (hereinafter referred to as "Contractor").
WHEREAS, County desires to retain Contractor to perform the services in connection with the Fast Open Contracts Utilization Services (FOCUS) pursuant to Government Code Sections 25330 - 25338; and,
WHEREAS, Contractor represents it has considerable knowledge and experience relating to the performance of such services; and,
WHEREAS, the parties desire to set forth herein the terms and conditions under which said services shall be furnished.
NOW, THEREFORE, in consideration of the mutual covenants and promises herein contained, the parties hereby agree as follows:
1, SCOPE OF SERVICES
1.1 FOCUS Program Overview
The purpose of this FOCUS Agreement will be to provide the means for counties, cities, schools, special districts and other governmental entities in California and nationally to purchase their needed telecommunications technology solutions through a formally bid contractual relationship.
FOCUS iiso provides the means for govemments to reduce their costs of procurement while leveraging their dollars with other governments to achieve greater buying power. FOCUS offers the possibility of choosing more than one provider in each category'
1.2 FOCUS Program Design for Contractor
The program design shall incorporate the principles as they apply to the following awarded telecommunications technology categories:
Communications Services:
. Call Center Solutions (with ACD)
. Emergency Notification Solutions (Reverse 911)
. Engineering/Consulting Services
I,i i.:
-: | -r.r,iil .!riiI:r\ rr r'O Zl?) IDL
#15..
- 521 -
. lntegrated Voice Response (lVR)
. Voice over lnternet Protocol (VOIP)
. Unified Messaging (UM)
. TelecommunicationsSystems(PBX)
. Telephone Handsets
. Voice Mail Solutions
. Wireless Voice Communication Services
lnfrastructu re:
. Cabling Services
Enterprise l\ilobility Solutions:
. Mobile Device Management
Maintenance Services
Network & Enterprise Security Solutions:
. Firewall and Virtual Private Network (VPN)
. lntrusionDetection/PreventionSolutions
. Network, Host and Enterprise Management Solutions
. Video Solutions
. Wireless Solutions (Wi-Fi)
E-Governmeni
. Web Monitoring and Filtering Solutions
Enterprise Systems:
. Virtualization(Servers)
. Virtual Desktop lnfrastructure (VDl)
. Anti-Virus, Spam, Spyware Solutions
. Data Encryption Products and Services
. Hosting Services and Applications (Cloud and SaaS)
. Radio Frequency ldentification (RFID)
. Server, Storage and Data Management Products
. Telepresencely'ideoConferencing
Training Solutions
Consulting Services
Other Goods and Services
'1.3 Services
Contractor shall provide such services in a good and professional manner in accordance with the terms and conditions stated herein, and any #15..
- 522 -
1.4 specifically referenced attachments hereto. The following exhibits are specifically inmrporated by reference, aftached hereto, and made a part hereof, except when in conflict with this Agreement or modified herein:
Exhibit A - County's Request for Proposal #7370
Exhibit B - Contractor's Responding Proposal
Services shall include all activities of Contractor necessary to its performance of the work included in the scope herein described and shall perform all seryices as an independent contractor; not as an agent or employee ofthe County.
ln the performance of Contracto/s duties to perform such services, Contractor's services include, but are not limited to, the following:
a. Provide telecommunications products and services, using a competitively bid procurement tool, to public entities nationally. b. Offer superior products and services, at competitively bid prices, to insure public entity telecommunications goals are being achieved. c. Service FOCUS needs in specifically awarded telecommunications technology categories as listed in Section 1.2.
Conlractor Commitments
a. Selected FOCUS partners are authorized to add new product lines as needed to replace discontinued product lines. Merced County will be notified in writing of such product changes (with pricing) as they occur.
b. Not Specifically Priced ltems (NSP) - FOCUS users may order non-contracted products and services lhat are in support of the contracted items listed on the Purchase Order. Any NSP items must be peripheral and subordinate to the contracted items. The total value of all NSP items shall not exceed ten percent (10%) of the total price of the Purchase Order.
c. Merced County reserves the right to receive and process all orders at a future date.
d. Corporate level management support and resource commitment to the FOCUS Program.
e. Corporate level dedication to at least a California marketing proglzlm.
#15..
- 523 -
f. Corporate level commitment to their sales force in promoting the FOCUS Program and rewarding successes.
g. An aggressive marketing strategy.
h. Excellence in customer support and service.
i. A commitment to use local providers and/or contracted seNices where a corporate presence does not exist.
j. A product and service quality assurance program that meets or exceeds industry excellence standards.
k. The most competitive pricing given to a state/local government agency for the array of products and/or services offered. l. An ability to include industry leaders in the corporate and product suites offered through subcontractor relationships.
m. An on-line order placemenutracking system for immediate input or retrieval of information/acknowledgments by vendor.
n. As required, a customer help desk (800 number/on-line access) to assist customer technical and administralive issues.
o. Product, service, and installation excellence to any location that meets industry's highest standards.
p. The availability and inclusion of product supplies, product training, networking services (if appropriate), and product maintenance' q. All product installations and modifications performed by supplier will be by manufacturer-authorized personnel and meet manufaclurerdocumented specifications, unless otherwise specmcally stated in the purchase order/Statement of Work.
r. All contractors offering technology services must be certified by the California Public Utilities Commission (CPUC) to offer those services. Evidence of certification from CPUC is required' s. All products offered as a part of FOCUS must meet or exceed the specifications of the referenced brands.
#15..
- 524 -
2. 1.5 MandatoryAdministrative Requirements
a. Notify Merced County of all saies made under FOCUS, including order/delivery progress, within fourteen ('14) business days of orderb. Quarterly and annual sales reports. c. A producuservice document, paper or electronic
-
to be produced
at least four (4) times per year. Electronic documents shall be updated immediately for price reductions. The document must show the array of producvservice offerings, producvservice descriptions, and pricing schedules based on single item purchases. lf appropriate, greater price reductions are expected as volume on identical items is increased. A percent of volume discount must be provided prior to order.
d. Price increase/price decline policies. All price reduction changes must be published within seventy-two (72) hours.
e. Quarterly Administrative fees for Merced County.
f. Subcontractor list (See Agreement Attachment 1).
g. Ordering (including invoices, payments, taxes on sales and services, and retum procedures), reporting, and reconciliation procedures (See Agreement Attachment 2).
h. Support services including help desk phone numbers.
i. Wananty statements.
j. Point of contact including phone/faxle-mail informationTERM The term of this Agreement shall commence on the 8th day of June, 202'1, and continue until the 7ih day of June, 2024, unless sooner terminated in accordance with the sections entitled 'TERMINATION FOR CONVENIENCE", 'TERMINATION FOR CAUSE", or "CONDITION SUBSEQUENT/NONAPPROPRIATION OF FUNDING', as set forth elsewhere in this Agreement'
ADMINISTRATIVE FEES
Contractor agrees to pay Merced County administrative fees in accordance with the following schedule on a quarterly basis. Payment is to be made not later
3. #15..
- 525 -
than thirty (30) days following the end of the quarter (April 30, July 31 , October 31 , January 31).
(Sales will be calculated for fiscal year of January 1st through December 31st and reset each year)
Annual Sales Through Contract Administrative Fee
$o - $2,ooo,o0o 1Yo
$2,000,000+ 0.5%
4. PUBLIC AGENCY PARTICIPATION
Any public agency, i.e., city, district, public authority, public agency, municipality and other political subdivision or a public corporation of california (hereinafter refened to as public agency) located in the state of california or any other state shall have the option of participating in any award made as a result of this proposal at the same prices, F.O.B. destination, and terms and conditions. The public agency shall make purchases in their own name, have deliveries made to their facilities, and be responsible for tax liability and payments directly to the Contractor. The public agency will hold harmless the County from all claims, demands, actions, or causes of actions of every kind resulting directly or indirectly, arising out of, or in any way connected with use of this Contract.
Public Agencies may not qualiff vendors for their contract offerings by using FOGUS Terms and Conditions.
PROGRAM UTILIZATION REQUIREMENTS
ln order for a public agency to utilize FOCUS contracts, the public agency must first complete an agreement with Merced county. Agreements are accomplished by referencing vendor's specific FOCUS contract number on each public agency's purchase order, forwarding original to Contractor, and providing an informltion copy to the Merced County Department of Community and Economic Development via U.S. Mail, fax, or e-mail. For ordering, reporting, and reconciliation procedures, see Contract Attachment 2'
NOTICES
All notices, requests, demands or other communications under this Agreement shall be in writing. Notice shall be sufficiently given for all purposes as follows:
A. Personal Delivery. When personally delivered to the recipient, notice is effective uPon delivery.
5. o.
#15..
- 526 -
B. First Class Mail. When mailed first class to the last address of the recipient known to the party giving notice, notice is effective three mail delivery days after deposit in a United States Postal Service office or mailbox.
C. Certified Mail. When mailed by certified mail, return receipt requested, notice is effective upon receipt, if delivery is confirmed by a return receipt.
D. Ovemight Delivery. When delivered by an ovemight delivery service, charges prepaid or charged to the sender's account, notice is effective on delivery, if delivery is confirmed by the delivery service.
Any correctly addressed notice that is refused, unclaimed or undeliverable because of an acf or omission of the party to be notified shall be deemed effective as of the first date that the notice was refused, unclaimed or deemed undeliverable by the postal authorities, messengersi or ovemight delivery service lnformation for notice to the parties to this Agreement at the time of endorsement of this Agreement is as follows:
county of lverced c/o
Director
Community & Economic Development
Merced county
2222 M Slrcel
Merced, CA 95340
Contractor
Telcion Communications Group, lnc.
Danen Rodrigues
Business Technology Consultant
'140 West Main Street
Turlock, CA 95380
7. Any party may change its address by giving the other party notice of the change in any manner permitted by this Agreement.
CONDITION SUBSEQUENT/NON-APPROPRIATION OF FUNDING
The compensation paid to Contractor pursuant to this Agreement is based on County's continued appropriation of funding for the purpose of this.Agreement, as well as the receipt of local, county, stale and/or federal funding for this purpose. The parties acknowledge that the nature of govemment finance is unpredictable, and that the rights and obligations set forth in this Agreement are therefore contingent upon the receipt and/or appropriation of the necessary funds. ln the event that funding is terminated, in whole or in part' for any reason' at any time, this Agreement and all obligations of the County aising-from this Agreement shall be immediately discharged. County agrees to inform Contractor ni later than ten (10) calendar days after the County determines, in its sole judgment, that funding will be terminated and the final date for which funding will -be -available. Under these circumstances, all billing or other claims for compensation or reimbursement by Contractor arising out of performance of this Agreement must be submitted to County prior to the final date for which funding is available. ln the altemative, County and Contractor may agree, in such #15..
- 527 -
6. circumstance, to a suspension or modification of either party's rights and obligations under this Agreement. Such a modification, if the pafiies agree thereto, may permit a restoration of previous contract terms in the event funding is reinstated. Also in the alternative, if funding is pmvided to the County in the form of promises to pay at a later date, whether referred to as "government warrants;', "lOU's", or by any other name, the County may' in its sole discretion, provide similar promises to pay to the Contractor, which the Contractor hereby agrees to accept as sufficient payment until cash funding becomes available'
TERMINATION FOR CONVENIENCE
This Agreement, notwithstanding anything to the contrary herein above or hereinafter set forth, may be terminated by County at any time without cause or legal excuse by poviding the other party with thirty (30) calendar days written notice of such termination.
Upon effective date of termination, County shall have no further .liability to Contractor except for payment for actual services incurred during the performance hereunder. Such liability is limited to th,e time specified in said notice and for services not previously reimbursed by County Such liability is further limited to the extent such costs are actual, necessary, reasonable, and verifiable costs and have been incuned by Contractor prior to, and in connection with, discontinuing the work hereunder.
TERMINATION FOR CAUSE
The County may terminate this Agreement and be relieved -of making any payments to Contractor and all duties to Contractor should the Contractor fail to ir"itor, ,ny material duty or obligation of the Agreement Notice shall be given as otherwiie pmvided herein. ln the event of such termination the County may proceed with ihe work in any manner deemed proper by the County All costs to [tre County shall be deduct,ed from any sum otheMise due the. Contractor and in" Ortan"", if any, shall be paid to the Contractor upon dem€nd- Such remedy Lin aodition to such other remedies as may be available to the County provided by law.
MODIFICATION OF THE AGREEMENT
Notwithstanding any of the provisions of this Agreement, the parties may agree to amend thiJ Ag;eement. No alteration or variation of the terms of this Agreement shall b; valid unless made in writing and signed.by the.parties hereto' N6 oral understanding or agreement not incorporated herein shall be binding on any of the parties hereto
9. t0.
#15..
- 528 -
11. INSURANCE
A. Prior to the commencement of work, and as a precondition to this Agreement, Contractor shall purchase and maintain the following types of iniurance for the stated minimum limits indicated during the term of this Agreement. Contractor shall provide a certificate of insurance and endorsements on each policy as required in this section. Each certificate of insurance shall specify if Contractor has a self-insured retention (SlR), and if so, Contractor shall be required to provide the entire policy of insurance with which it has an SIR and/or deduciible. All deductibles and SlRs shall be fully disclosed in the Certificates of lnsurance and are subject to the express written permission of the County Risk Manager.
1. Commercial General Liability: $2,000,000 per occunence and $4,OOO,OO0 annual aggregate covering products and completed operations, bodily injury, personal injury and property damage. The County and its officers, employees and agents shall be endorsed to above policy as additional insured, using ISO form CG2026 or an alternate form that is at least as broad as form CG2026, as to any liability arising from the performance of this Agreement.
2. Automobile Liability: $1,000,000 per accident for bodily injury and property damage, or altematively split limits of $500,000 per person ;nd $l,OOO,OOo per accident for bodily inlury with $250,000 per accident for property damage.
3. Workers Compensation: Statutory coverage, if and as required according to the California Labor Code, including Employers' Liability limits of $1,OoO,OOO per accident. The policy shall be endorsed to waive the insurer's subrogation rights against the County.
4. Professional Liability (Enors and Omissions): $1,000,000 limit per occurrence and $5,000,000 annual aggregate limit covering Contractor's wrongfulacts, errors and omissions. Any aggregate limit for professional liability must be separate and in add-ition toany CGL aggregate limit. Claims - made coverage requires Contractor to main'tiini minimum of three (3) years extended reporting period or tail coverage.
5. Technology Professional Liability Errors and Omissions lnsurance appropriai; to the Contractor's profession and work hereunder, with limits not less than $2,OOO,OOO per occulrence. Coverage shall be sufficiently broad to respond to the duties and obligations as is undertaken by the Contractor in this agreement and shall include, but not be limited to, claims involving infringement of intellectual #15..
- 529 -
B.
property, copyright, trademark, invasion of privacy violations, information theft, release of private information, extortion and network security. The policy shall provide coverage for breach response costs as well as regulatory fines and penalties as well as credit monitoring expenses with limits sufflcient to respond to these obligations.
The Policy shall include, or be endorsed to include, property damage liability coverage for damage to, alteration of, loss of, or destruction of electronic data and/or information "property" of the Agency in the care, custody, or control of the Contractor. lf not covered under the Contracto/s liability policy, such "property" coverage of the Agency may be
endorsed onto the Contracto/s Cyber Liability Policy as covered property as follows;
Cyber Liability coverage not less than $2,000,000 per
occurrence, and sufficient to cover, the full replacement value of damage to, alteration of, loss of, or destruction of electronic data and/or information "property' of the Agency that will be in the care, custody, or control of Contractor.
INSURANCE CONDITIONS
1. lnsurance is to be primary and non-contributory with any insurance of the County and placed with admitted insurers rated by A M. Best Co. as A: Vll or higher. Lower rated, or approved but not admitted insurers, or any other requirement changes (such as limits) are subject to the prior approval of the County Risk Manager'
2. Each of the above required policies shall be endorsed to provide the County with thirty (30) days prior written notice of cancellation.
The County is not liable for the payment of premiums or assessments on the policy. No cancellation provisions in the insurance policy shall be construed in derogation of the continuing duty of Gontractor to furnish insurance during the term of this Agreement.
3. lf the Contractor maintains broader coverage and/or higher limits than the minimums shown above, the County requires and shall be entitled to the broader coverage and/or the higher limits maintained by the Contractor. Any available insurance proceeds in excess of the specified minimum limits of insurance and coverage shall be available to the County.
'10
#15..
- 530 -
12. 4. lf the Contractor uses Sub-Contractors or others to perform work under this Agreement, such Sub-Contractor or other persons shall be Named lnsured or Additionally lnsured to the Contractor's required insurance coverage, or required by the Contractor to comply with equivalent insurance and conditions of this Section.
INDEMNIFICATION
Contractor has the mntracted duty (hereinafter "the duty") to indemnify, defend and hold harmless, County, its Board of Supervisors, officers, employees, agents and assigns from and against any and all claims, demands, liability, judgments, awards, interest, attorney's fees, costs, experts' fees and expenses of whatsoever kind or nature, at any time arising out of or in any way connected with the performance of this Agreement, whether in tort, contract or otherwise.
This duty shall include, but not be limited to, claims for bodily injury, pmperty damage, personal injury, and mntractual damages or otheMise alleged to be caused to any person or entity including, but not limited to employees, agents and officers of Contractor.
Contractor's liability for indemnity under this Agreement shall apply, regardless of fault, to any acts or omissions, willful misconduct or negligent conduct of any kind, on the part of the Contractor, its agents, subcontractor and employees. The duty shall extend to any allegation or claim of liability except in circumstances found by a jury or judge to be the sole and legal result of the willful misconduct of County. This duty shall arise at the first claim or allegation of liability against County. Contractor will on request and at its expense defend any action suit or proceeding arising hereunder. This clause for indemnification shall be interpreted to the broadest extent permitted by law.
PATENT INDEMNITY
The awarded Bidder shall hold the County, its officers, agents, and employees, harmless from liability of any nature in kind, including costs and expenses, from infringement or use of any copyrighted or un-copyrighted composition, secret prccess, patented or unpatented invention, article, or appliance furnished or used in connection with this proposal. The Bidder may also be required to furnish a bond or other indemnification to the County against any and all loss' damage, costs, expenses, claims, and liability for patent or copyright infringement.
INDEPENDENT CONTRACTOR
It is mutually understood and agreed that Contractor is an independent Contractor in the performance of the work duties and obligations devolving upon Contractor under this Agreement. County shall neither have, nor exercise any control or direction over the methods by which Contractor shall perform the assigned work and functions. The contractual interest of County is to assure that
13. 14.
11 #15..
- 531 -
15. the services covered by this Agreement shall be performed and rendered in a competent, efficient and satisfactory manner.
It is agreed that no employer-employee relationship is created and Contractor shall hold County harmless and be solely responsible for withholding, reporting and payment of any federal, state or local taxes; any contributions or premiums imposed or required by workers' compensation; any unemployment insurance; any social security income tax; and any other obligations from statutes or codes applying to Contractor, or its subcontractors and employees, if any.
It is mutually agreed and understood that Contractor, its subcontractors and employees, if any, shall have no claim under this Agreement or otheMise against the County for vacation pay, sick leave, retirement or social security benefits, occupational or non-occupational injury, disability or illness, or loss of life or income, by whatever cause.
Contractor shall insure that all its personnel and employees, subcontractors and their employees, and any other individuals used to perform the contracted seNices are aware and expressly agree that County is not responsible for any benefits, coverage or payment for their efforts.
RECORDS, INFORMATION AND REPORTS
Contractor shall maintain full and accurate records with respect to all matters covered under this Agreement. To the extent permitted by law, County shall have free access at all poper times or until the expiration of four (4) years after the fumishing of services to such records, and the right to examine and audit the same and to make transcrjpts therefrom, and to inspect all data, documents, proceedings, and activities pertaining to this Agreement.
To the extent permitted by law, Contractor shall furnish County such periodic reports as County may request pertaining to the work or services undertaken pursuant to this Agreement. The costs and obligations incurred or to be incurred in connection therewith shall be borne by the Contractor.
OWNERSHIP OF DOCUMENTS
To the extent permitted by law, all technical data, evaluations, plans, specifications, reports, documents, or other work products developed by Contractor hereunder are the exclusive property of County and upon request of County shall be delivered to County upon completion of the services authorized hereunder. ln the event of termination, all finished or unfinished documents and other materials, if any, at the option of County, and to the extent permitted by law, shall become the property of the County. Contractor may retain copies thereof for its files and internal use.
16. 12
#15..
- 532 -
17. Any publication of information directly derived fmm work performed or data obiained in connection with services rendered under this Agreement must be first approved by County.
QUALITY OF SERVICE
Contractor shall perform its services with care, skill, and diligence, in accordance with the applicable professional standards currently recognized by such profession, and shall be responsible for the professional quality, technical accuracy, completeness, and coordination of all reports, designs, drawings, plans, information, specifications, and/or other items and services fumished under this Agreement.
Contractor shall, without additional compensation, conect or revise any elrors or deficiencies immediately upon discovery in its reports' drawings, specifications, designs, and/or other related items or services.
PERSONAL SATISFACTION AS A CONDITION PRECEDENT
The obligations of County as provided in this Agreement are expressly condition;d upon Contractols compliance with the provisions of this Agreement to the personal satisfaction of the County. County shall determine compliance in good faith as a reasonable person would under the circumstances'
ENTIRE AGREEMENT
This Agreement and any additional or supplementary document or.documents incorpoiated herein by specific reference contain all the terms and conditions agreed upon by the parties hereto, and no other contracts' oral or.otherwise' re-garding tne suUlect matter of this Agreement or any part thereof shall have any validity or bind any of the parties hereto.
PRICING
lf the FOCUS partnering contractor's prices decline, or should Contractor, at any time during ttrb term oi this Agreement, provide the same or similar goods or services uider similar quantity and delivery conditions and terms and conditions oi purchase to the State of Cilifomia or any county, municipality or district of the stjte at prices below those set forth in this Agreement,. then-such lower prices shall be immediately extended to Merced County and the FOCUS users up to and including date of shipment from Contractor's shipping point
COUNTY NOT OBLIGATED TO THIRD PARTIES
County shall not be obligated or liable hereunder to any party other than Contractor.
18. t9-
20-
2',t.
13 #15..
- 533 -
23. 22.
25. LAWS, LICENSES, PERMITS AND REGULATIONS
Contractor and County agree to comply with all State laws and regulations that pertain to construction, health and safety, labor, minimum wage, fair employment practice, equal opportunity, and all other matters applicable to Contractor and County, their sub-grantees, Contractors, or subcontractor, and their work.
Contractor shall possess and maintain all necessary licenses, permits, certificates and credentials required by the laws of the United States, the State of Califomia, County of Merced and all other appropriate govemmental agencies, including any certification and credentials required by County. Failure to maintain the licenses, permits, certificates, and credentials shall be deemed a breach of this Agreement and constitutes grounds for the termination of this Agreement by County.
LIMITED AFFECT OF WAIVER OR PAYMENT
ln no event shall the making, by County, of any payment to Contractor constitute, or be construed as, a waiver by County of any breach of covenant, or any default which may then exist, on the part of Contractor. The making of any such payment by County while any such breach or default shall exist, shall not be construed as acceptance of substandard or careless work or as relieving Contractor from its full responsibility under this Agreement.
No waiver by either party of any default, breach or condition precedent shall be valid unless made in writing and signed by the parties hereto. No oral waiver of any default, breach or condition precedent shall be binding on any of the parties hereto. Waiver by either party of any default, breach or condition precedent shall not be construed as a waiver of any other default, breach or condition precedent, or any other right hereunder.
PERSONNEL
Contractor represents that it has, or will secure at its own expense, all personnel required in performing the services under this Agreement. All of the services required hereunder will be performed by Contractor or under its supervision, and all personnel engaged in the work shall be qualified to perform such services.
APPLICABLE LAw; VENUE
All parties agree that this Agreement and all documents issued or executed pursuant to this Agreement as well as the rights and obligations of the parties hereunder are subject to and govemed by the laws of the State of California in all respects as to interpretation, construction, operation, effect and performance. No
24. 14
#15..
- 534 -
27. 26.
24. interpretation of any provision of this Agreement shall be binding upon County unless agreed in writing by County and counsel for County.
Notwithstanding any other provision of this Agreement, any disputes conceming any question of fact or law arising under this Agreement or any litigation or arbitration arising out of this Agreement, shall be tried in lvlerced County, unless the parties agree otheMise or are otheMise required by law.
BREACH OF CONTRACT
Upon breach of this Agreement by Contractor, County shall have all remedies available to it both in equity and/or at law.
REMEDY FOR BREACH AND RIGHT TO CURE
Notwithstanding anything else in this Agreement to the contrary, if Contractor fails to perform any obligation of this Agreement, the County may itself perform, or cause the performance of, such agreement or obligation. ln that event, Contractor will, on demand, fully reimburse County for all such expenditures Altematively, County, at its option, may deduct from any funds owed to Contractor the amount necessary to cover any expenditures under this provision.
This is in addition to any other remedies available to the County by law or as otheMise stated in this Agreement.
SUCCESSORS IN INTEREST
All the terms, covenants, and conditions of this Agreement shall be binding and in full force and effect upon any successors in interest and assigns of the parties hereto. This paragraph shall not be deemed as a waiver of any of the conditions against assignment set forth herein.
CONFLICT OF INTEREST
Contractor covenants that it presently has no inlerest and shall not acquire any interest, direct or indirect, which would conflict in any manner or degree with the performance of this Agreement. Contractor shall ensure that no mnflict of interest exists between its officers, employees, or subcontractors, and the County. Contractor shall ensure that no County officer or employee in a position that enables them to influence this Agreement will have any direct or indirect financial interest resulting from this Agreement. Contractor shall ensure that no County employee shall have any relationship to the Contractor or officer or employee of the Contractor, nor that any such person will be employed by Contrrctor in the performance of this Agreement without immediate divulgence of such fact to the County.
29. #15..
- 535 -
30. NONDISCRIMINATION IN EMPLOYMENT, SERVICES, BENEFITS AND
FACILITIES
Contractor and any subcontractors shall comply with all applicable federal, state, and local Anti-discrimination iaws, regulations, and ordinances and shall not unlawfully discriminate, deny family care leave, harass, or allow harassment against any employee, applicant for employment, employee or agent of County, oi recipient of services contemplated to be provided or provided under this Agreement, because of race, ancestry, marital status, color, religious creed, political belief, national origin, ethnic group identification, sex, sexual orientation, age (over 4o), medical condition (including HIV and AIDS), or physical or mental disability. Contractor shall ensure that the evaluation and treatment of its employees and applicants for employment, the treatment of County employees and agents, and recipients of services are free from such discrimination and harassment.
Contractor represents that it is in compliance with and agrees that it will continue to comply with the Americans with Oisabilities Act of 1990 (42 U.S.C. S 12101 et seq.), the Fair Employment and Housing Act (Government Code SS 12900 et seq.), and ensure a workplace free of sexual harassment pursuant to Government Code 12950 and regulations and guidelines issued pursuant thereto.
Contractor agrees to compile data, maintain records and submit reports to permit effective enforcement of all applicable antidiscrimination laws and this provision' Contractor shall include this nondiscrimination pmvision in all subcontracts related to this Agreement and when applicable give notice of these obligations to labor organizations with which they have Agreements.
CAPTIONS
The captions of each paragraph in this Agreement are inserted as a matter of convenience and reference only, and in no way define, limit, or describe the scope or intent of this Agreement or in any way affect it.
SUBCONTRACTS. ASSIGNMENT
Contractor shall not subcontract or assign this Agreement, or any part thereof, or interest therein, directly or indirectly, voluntarily or involuntarily' to any person without obtaining the prior written consent by County. Contractor remains legally responsible for the performance of all contract terms including work performed by third parties undei subcontracts. Any subcontracting will be subject to all applicable provisions of this Agreement. Contractor shall be held responsible by County for the performance of any submntractor whether approved by County or not.
31. 32.
'16
#15..
- 536 -
34. Contractor hereby assigns to the County all rights, title, and interest in and to all causes of action it may have under Section 4 of the Clayton Act (15 U.S.C. Sec. 1 5) or under the Cartwright Act (Chapter 2 (commencing with Section 16700) of Parl 2 ol Division 7 of the Business and Professions Code), arising from the purchase if goods, materials, or services by the Contractor for sale to the County pursuant to this Agreement.
SEVERABILITY
lf a court of competent jurisdiction holds any provision of this Agreement to be illegal, unenforceable or invalid, in whole or in part, for any reason, the validity and enforceability of the remaining provisions, or portion of them, will not be affected. Compensation due to Contractor from the County may, however, be adjusted in proportion to the benefit received despite the removal of the effected provision.
DUPLICATE COUNTERPARTS
This Agreement may be executed in duplicate counterparts, each of which shall be deemed a duplicate original. The Agreement shall be deemed executed when it has been signed bY both Parties.
Signature page to follow
17 #15..
- 537 -
COUNTY OF TIIERCED
Daron McDaniel
Name
Chairman. Board of Suoervisott
Title
JUN 8 2021
Dat6d
APPROVEDASTO FORM
FORRESTW HANSEN
Telcion Gommunications GrouP
Name
hr:rav"l tnq t Ola-{''
Title
s ln\zt
Jeff Grant, Deputy County Counsel lV
g 6ir,P f{^,r, t, tnt-,
MERCED COUNTY COUNSEL
18 #15..
- 538 -
ATTACHMENT 1
SUBCONTRACTORS
Berk-tek
Cisco
Panduit
19 #15..
- 539 -
ATTACHMENT 2
ORDERING, REPORTING, AND RECONCILIATION PROCEDURES
ORDERING:
To order from the FOCUS Contract, Contractor needs:
1. A public agency purchase order (P'O.), stating the FOCUS Contract Number, made out to Contractor.
2. Confirmation that a copy of the P.o. has been sent to county via u.s. Mail or email.
Contractor can receive information in the following ways: U.S. Mail or email:
US mail:
Telcion Communications
Sales/FOCUS Contract orders
140 West Main Street
Turlock, Ca 95380
Email:
[email protected]
Upon receiving the above, Contractor will proceed with the ordering of the equipment delivered to Contractor ior delivery to the customer. The Order Administrator will also send a copy of the P.O. to the County.
REPORTING AND RECONCILIATION:
Contractor will report to County on a quarterly basis. The report and associated lees will be sent by Contractor no later than the 30h of the month, following the end of the q-uarter.(January 30s April 30th, July 30th, october 3oh) to the county via carrier. copies of P.o.'s will also be included.
#15..
- 540 -
#15..
- 541 -
Telcion Communications Group
140 West Main | Turlock, CA 95380 | 209.632.5700 | www.telcion.com
Proposal: RFP #7370 – Fast Open Contracts
Utilization Services (FOCUS)
Prepared For:
County of Merced
Requested By:
Jose Hurtado
January 15, 2021
Prepared by:
Darren Rodrigues
Business Communications Consultant
209.656.5740
[email protected]
Lance Reid
Voice CCIE #14888
209.656.5750
[email protected]
#15..
- 542 -
Telcion Communications Group
140 West Main | Turlock, CA 95380 | 209.632.5700 | www.telcion.com Notice
The information contained in this document is confidential information between Telcion and County of Merced. Its purpose is to communicate the details of a proposed business solution from Telcion to the client. All information is to be kept confidential and used only to determine the feasibility and acceptability of the proposed solution by Telcion.
This document is the property of, and is proprietary to Telcion. It is not to be disclosed in whole or in part without the express, written authorization of Telcion, and shall be returned upon request.
All Trademarks are the property of their respective owners. #15..
- 543 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 1
EXECUTIVE SUMMARY .............................................................................................................................................. 2 EXCEPTIONS ................................................................................................................................................................... 3 APPROACH ....................................................................................................................................................................... 4 BIDDER’S QUALIFICATION ...................................................................................................................................... 7 History: ............................................................................................................................................................................. 7 Background and Experience: ........................................................................................................................................ 7 References:..................................................................................................................................................................... 10 #15..
- 544 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 2
EXECUTIVE SUMMARY
County of Merced desires a means for counties, cities, schools, special districts and other governmental entities in California and nationally to purchase their needed technology solutions through a formally bid contractual relationship. Telcion is very familiar with the needs of these organizations and the difficulty of RFPs and delays due to them. Telcion has several CMAS contracts in place already, which are based upon federal GSAs in place, as well as a master contract in place at Stanislaus County with a similar structure as we are proposing in our offering. Pricing is available on‐line via GSA Advantage for latest list price. We have a track record with Merced County already, as well as hundreds of government and education clients in the Central Valley.
Telcion has provided two pricing options for County of Merced based upon project size and whether Merced works with Telcion exclusively in the presales phase to develop the product list/scope. (1A and 1B Category of Service).
#15..
- 545 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 3
EXCEPTIONS
Telcion does not take any exceptions to the requirements, RFP or sample agreement. #15..
- 546 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 4
APPROACH
Telcion will meet the requirements of the RFP and perform the duties outlined.
Telcion will provide FREE pre‐sales engineering help for any solution desired by the agency and utilizing this service will provide the highest levels of discounts for the organization.
Telcion has published pricing available on‐line (via GSA) as retail prices tend to change often. Our pricing provided is % off list price.
For any sales, Telcion will accept any P.O.s via e‐mail, or mailed to the office. Telcion will process any orders and provide etas weekly. For any projects (with labor), a project manager will be assigned, timeline with milestones and detailed scope of work. Weekly project meetings will occur.
Telcion will provide reports of usage of this contract on a quarterly basis, as specified by the RFP.
Here is an example project milestone we provided to a local education institution in 2020.
Task Name Start Finish Duration
Milestones 5/1/2020 7/7/2020 68d
Project Planning 5/1/2020 5/14/2020
Project Kickoff 5/1/2020 5/1/2020
All Parts have arrived 5/14/2020 5/14/2020
Base equipment staged and ready for final configuration 5/14/2020 6/7/2020 System ready for initial testing 6/7/2020 6/14/2020
System ready for final testing 6/14/2020 6/21/2020
User Training 6/14/2020 6/21/2020
Go live 6/21/2020 6/21/2020
Day 1 Support 6/21/2020 6/28/2020
Project Documentation and As‐builts 6/28/2020 7/7/2020
Project Closure 7/7/2020 7/7/2020
Cisco BE6K Servers 5/21/2020 5/22/2020 2d
Update all Firmware 5/21/2020 5/21/2020
Vmware ESXi and vCenter Installation 5/22/2020 5/23/2020 CUCM Servers 5/23/2020 5/27/2020 5d
Licensing 5/23/2020 5/23/2020
High Availability 5/23/2020 5/23/2020
Dial plan 5/24/2020 5/24/2020
LDAP or AD Integration 5/25/2020 5/25/2020
End User Profiles 5/26/2020 5/26/2020
Media Resources (MOH,Transcode,MTP, etc.) 5/27/2020 5/27/2020 #15..
- 547 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 5
TFTP and Separate CFB Servers 5/27/2020 5/27/2020
Gateways 5/27/2020 5/27/2020
End User Features 5/28/2020 5/28/2020
Documentation 7/1/2020 7/7/2020
Task Name Start Finish Duration
Unity Connection Servers 5/23/2020 5/27/2020 5d
Licensing 5/23/2020 5/23/2016
High Availability 5/24/2020 5/24/2020
Call Handlers 5/25/2020 5/25/2020
CUCM Integration 5/25/2020 5/25/2020
COS/Templates 5/26/2020 5/26/2020
Users/Mailboxes 5/26/2020 5/26/2020
Single Inbox 5/27/2020 5/27/2020
Documentation 7/1/2020 7/7/2020
CUCM IM&P Servers 5/23/2020 5/27/2020 5d
Certificate Verification 5/23/2020 5/23/2020
Domains 5/23/2020 5/23/2020
Service Configuration 5/23/2020 5/23/2020
High Availability 5/23/2020 5/24/2020
Documentation 7/1/2020 7/7/2020
InformaCast Advanced Paging 5/23/2020 5/27/2020 5d
Licensing 5/23/2020 5/23/2020
High Availability 5/23/2020 5/23/2020
Paging Groups 5/24/2020 5/24/2020
Advanced Notifications 5/24/2020 5/24/2020
Documentation 7/1/2020 7/7/2020
ISR 4000 Routers 6/1/2020 6/7/2020 7d
Licensing 6/1/2020 6/1/2020
Voice Gateway configuration 6/1/2020 6/4/2020
Failover Path Testing 6/5/2020 6/5/2020
Integration to Existing On Premise Paging 6/6/2020 6/7/2020
#15..
- 548 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 6
Estimated Project Schedule (continued)
Task Name Start Finish Duration
Emergency Responder 5/23/2020 5/25/2020 7d
Licensing 5/23/2020 5/23/2020
High Availability 5/24/2020 5/24/2020
Subnet Configurations 5/24/2020 5/24/2020
CUCM Integration 5/24/2020 5/25/2020
PSAP Configuration 5/25/2020 5/25/2020
Documentation 7/1/2020 7/7/2020
Varify Call Accounting / Reporting 5/30/2020 5/30/2020 1d Project Go Live 6/21/2020 6/21/2020 0.5d
Test in/outbound dialing 6/21/2020 6/21/2020
Confirm inbound call flow 6/21/2020 6/21/2020
#15..
- 549 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 7
BIDDER’S QUALIFICATION
History:
Telcion Communications Group, based in Turlock, California, was founded in 2002. From the beginning, Telcion has been regionally focused, serving Northern California. Now in its 18th year, Telcion was created to concentrate on the growing Voice over IP trend and unified communications industry. Since then, Telcion has expanded its offerings to include video and data center solutions. To ensure the solutions we offer are on a stable and secure platform, we are also experts in the underlying technologies: switches and routers, security, wireless, virtualization, and structured cabling.
Telcion was co‐founded by Lance Reid and Darren Rodrigues. Lance has led the company as CEO for 18 years.
Telcion is headquartered in the heart of downtown Turlock on the corner of Main Street & Broadway.
We occupy a 6,000sq ft office on the 2nd floor where our admin, sales, and network operations center are housed. We also have a warehouse & office in the industrial area west of Hwy 99 off of West Main Street which supports our structured cabling operations and project staging. 18 years of dedicated service to California’s Central Valley Our staff collectively has over 75 years of experience in design, engineering, installation, and support in telecommunications
Background and Experience:
Who We Are
An IT company that specializes in voice, video, virtualization, and data center solutions A team of highly qualified engineers and support professionals A private employer based in the heart of California’s Central Valley What We Do
Design, install, and support all aspects of our solutions Help our clients achieve higher productivity and cost savings #15..
- 550 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 8
Focus on superior service over the longest possible term Forge partnerships with our technology partners and clients alike What We Believe
Communication defines every business, non‐profit, and government entity. Good internal communication facilitates teamwork; good external communication is the cornerstone of superior service.
Our technology partnerships with Cisco, VMWare, and Nimble Storage form the bedrock of our business. Their product lines give the broadest possible range of options, from simple to complex, focused to robust.
We are successful when our client’s operations improve and they become more effective at what they do
Our Commitment
We pledge to help our clients embrace new technologies so they can reap the cost savings and benefits
We focus on delivering and installing projects on time and on budget We strive to exceed customer expectations for service and support Our Expertise
We have CCIE, CCNP, and PMP certified individuals on staff to ensure the right quality solution is developed for your organizational needs
We design it right the first time, helping our customers avoid project overruns in time and budget
We are an engineering‐focused company that is driven to quickly respond, assess, and troubleshoot any situation or network‐down emergency
The target client sweet spot for Telcion are organizations with 100‐3000 users, headquartered in California, multiple sites, and have at least one dedicated IT person on staff. As a result, the majority of our clients fit within these parameters, with a few outliers. #15..
- 551 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 9
About 30% of our business comes from local government and education. The remaining 70% comes from commercial business.
Within the government and education sectors, we count major local clients (meaning we have completed multiple large projects and have long‐term support agreements) such as the following:
City of Modesto
City of Stockton
Stanislaus County IT Central (centralized IT services for various county agencies) Stanislaus County Sheriff’s Office
Salida Union School District
#15..
- 552 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 10
References:
Stanislaus County IT Central
801 11th Street, Suite 4100, Modesto, Ca 95354
Paul Gibson, CIO
(209) 525‐6529
[email protected]
4000+ Knowledge Workers
Telcion has been engaged with the County since 2009 in the county wide transition to VOIP. This was initially done in the core data center to support many of the smaller agencies, and then rolled out over the following years to larger departments. Today the system supports over 3,000 phones and includes multiple call centers and multiple redundancies. Telcion is engaged with an annual support agreement to for on‐going support of the system, and has been repeatedly engaged to provide software upgrades and new features.
Stanislaus County Sheriff Department
205 E. Hackett Ave, Modesto, CA
Scott Campbell, IT Director
(209) 567‐4435
[email protected]
800+ Knowledge Workers
The Sheriff Department is one of Telcion’s longest standing customers, having engagements beginning in 2002. During the early years, we provided the solutions for all network and communication infrastructure, including all switching, routing, and firewalls. In 2009, Telcion migrated the entire department from a Fujitsu phone system to a Cisco VOIP solution across 10 sites, and started a 24/7 Premium Support Contract which is still in effect today.
City of Stockton
400 East Main St. 4th Floor, Stockton, CA 95202
Erie Luces, Network Support Services Supervisor
(209) 937‐7061
[email protected]
1000+ Knowledge Workers
The City awarded a 5‐year contract to Telcion for a hosted Cisco VOIP solution. Telcion was awarded this 750k project in July of 2017 and completed it within about 6months for full operation during Q1 of 2018. The city already owned an aging Cisco telephony solution and had a desire to migrate to a cloud solution. Telcion proposed leveraging the existing Cisco solution in place, upgrade key hardware and software components, and migrate it to the Telcion Cloud so it could be operated as a fully managed hosted solution. This solution consisted of over 1000 phones and voicemail, 50+ contact center agents within various agencies, across dozens of sites. The City has a 5‐year agreement with Telcion to manage and support this solution on a 24x7 basis. Telcion handles 30+ requests per month for various moves, adds, or changes.
#15..
- 553 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 11
City of Modesto
This project is notable because of its recent completion and sheer size. The City of Modesto awarded a network infrastructure upgrade project to Telcion in the fall of 2018. The project took nearly 18 months to complete (finished Jan of 2020) and involved the coordination of nearly 40 sites. The project had a value of $1.5mil and was completed within the budget. This upgrade consisted of the replacement of the entire network switching layer in the core and access layers throughout the City, new firewalls for the City and Police Departments, new wireless infrastructure, the implementation of network access control, software defined networking, new network monitoring tools, along with new fiber and wiring cleanup in some locations. The customer gave Telcion an A+ on this project and was very pleased with the outcomes.
United Health Centers
UHC awarded Telcion a 5 year hosted, Voice over IP, cloud solution that included a 50+ agent call center, 20 sites+ sites, and 800 phones. This project has a total value of 1.2mil over 5 years. The cloud migration was completed in the fall of 2019 after 6 months of project planning and preparation. UHC is expanding fast, and wanted a telephony solution that was completely hosted and managed by a vendor.
They did not want to invest in the IT skills required to maintain the voice solution or have a dedicated voice engineer on their staff. Telcion has been fully engaged in the ongoing support of this solution since the cutover to the TelcionCloud.
San Joaquin General Hospital
This was a $1.2mil Cisco Voice over IP project awarded to Telcion in 2017. This was a new voice install – meaning SJGH was converting over from very antiquated phone technology (centrex) and migrating to VOIP. They had complex voice needs including a 35 agent call center, multiple redundancies, integration with the County phone system, E911 paging and notification, collaboration software, custom reports, etc. The most complex component of this project however was the 24x7 nature of the hospital and their Level 2 Trauma status within the region. Their voice services could not be interrupted. This project was completed in the summer of 2017.
Modesto City Schools VOIP Project
Telcion has been working with MCS on Voice over IP (VoIP) solution design and installations since 2006, when we first worked with the MCS district office to upgrade their voice system for ~150 users. In 2009, Telcion developed the plan for a comprehensive VoIP rollout to all 35 schools; this acted as a roadmap for implementation over the next several years, including the VoIP buildout, and the underlying networking infrastructure needed to support it, at 2 brand new schools. In 2014, we designed and provided the solution for a Core network upgrade, including moving all switches to Power over Ethernet Gigabit (to power all the phones), across all 35 schools. In 2015, we provided the solution and services to successfully migrate all 5‐ digit extensions off of the old Centrex service to an IP PBX solution for better management and feature set.
Finally, 2015 saw the beginning of a VoIP upgrade involving new voice gateways (routers) and new phones to all 35 schools and ~3,000 users, deployed in 3 phases. The final phase was completed in 2019.
The latest project was 3 phases of phone deployments to all school sites. Start date: Fall 2015 – Completion Date: Fall 2019. Budget – over $500k. Size – over 2000 phones to approximately 40 sites. #15..
- 554 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 12
Staff Assignment:
We have a staff of approximately 30 people, with 20+ individuals focused on the technical delivery of projects and on‐going support of our clients. Here are the individuals that would be assigned to your account.
Ryan Flud, VP Engineering
Ryan manages our engineering team, oversees all project implementations, and creates new tools and services for enhanced client support. In addition, Ryan is an experienced and seasoned voice engineer, having personally installed, upgraded, and managed dozens of our largest client installations over the last several years. Besides holding Cisco certifications for nearly 15 years, he has maintained his professional status of certified Project Manager from the Project Management Institute for over 10 years. He has 20+ years experience, 15 years at Telcion.
Cisco Certifications
CCNP
Other Certifications
Project Management Institute – PMP
Jeff Senger, Consulting Systems Engineer
Jeff is responsible for the design and architecture of complex projects. Jeff is our subject matter expert for collaboration solutions and various Cisco voice applications. Jeff spent 9 years as a voice engineer implementing and supporting Cisco voice solutions, and specializes in contact center deployments. He has passed the CCIE Voice written exam and is currently working to become a Voice CCIE. He has 20+ years experience, 14 years at Telcion.
Cisco Certifications
CCNP‐Voice
CCDA
Other Certifications
VMWare – VCP
Nimble Storage – NIOP
John Hinckley, Security and Wireless Engineer
John specializes in the deployment of security and wireless projects and works on project teams to support voice implementations. John understands both voice and wireless technologies which is a key skill set when deploying wireless IP Phones. John is our subject matter expert for security. He has 15+ years experience, 4 years at Telcion.
Cisco Certifications
CCNP – Security
CCNA – Wireless
#15..
- 555 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 13
Jeff Shear, Sr. Voice Engineer
Jeff is the Sr. Voice Engineer on this project and will be the primary implementation engineer for all of the voice applications. Jeff has been implementing Cisco voice solutions for over a decade. He has installed several dozen Cisco Unified Communication systems with multi‐thousand phone deployments and zero downtime tolerance. He has 15+ years experience, 4 years at Telcion.
Cisco Certifications
CCNP ‐ Voice
Other Certifications
RCDD
Blake Carpenter, Data Center Engineer
Blake is responsible for implementing data center and enterprise routing/switching solutions. He is a subject matter expert on data center solutions including the implementation of Cisco Unified Computing Systems, iSCSI and Fiber Channel storage networks, the Nexus switching platform, and enterprise VMware deployments. In addition, he has garnered significant experience in the deployment of cloud based data centers including hosted VOIP. He has over 10+ years experience deploying these type of solutions.
Cisco Certifications
CCNP – Data Center
Other Certifications
VMWare – VCP
Nimble Storage – NIOP
Eric Grimm, Security Engineer
Eric specializes in the deployment and management of security and voice projects and works on project teams to support voice implementations. Eric has a Masters in CyberSecurity, and has managed security policies and projects in large banking environments and hospitals. He is a subject matter expert for security and has 15+ years experience, 1 years at Telcion.
Cisco Certifications
CCNA – Security
Other Certifications
Masters in CyberSecurity
#15..
- 556 -
Telcion Communications Group
140 W. Main Street | Turlock, CA 95380
209.632.5700 | www.telcion.com
January 13, 2021 14
Leo Ruelas, Voice Engineer
Leo specializes in the management and troubleshooting of voice and contact center projects and works on project teams to support voice implementations. Leo works with our clients to troubleshoot complex voice issues post‐ implementation. Prior to Telcion, he was the sole voice engineer for a 2,000 phone hospital in the central valley.
He has 10+ years experience, 1 year at Telcion.
Cisco Certifications
CCNP – Voice
Derek Whitmore, Cisco Voice Engineer
Derek is providing post‐cutover help desk support for our voice solutions. He is adept at determining the nature of the issue and either resolving the issue or escalating as needed for resolution. His primary role in this project will be in the support of helpdesk issues post‐cutover.
Cisco Certifications
CCNA
Jose Hernandez, Structured Cabling Services
Jose has over 20 years experience implementing structured cabling services including fiber and copper plants. Jose will be responsible for circuit cross‐connects.
Certifications
BICSI
Panduit
Fluke
Lance Reid, CEO & Chief Solutions Architect
Besides managing the company, Lance works closely with clients to architect new solutions that solve specific client needs. Lance has been a Voice CCIE for over 12 years, and has been designing, installing, and supporting Cisco voice solutions since 2000. He has 25+ years experience, 18 years at Telcion.
Cisco Certifications
CCIE #14888 – Voice
#15..
- 557 -
EXHIBIT 1A- CATEGORY OF SERVICES
Contractor should be prepared to demonstrate how they will provide standard and advanced information technology, telecommunications, imaging, homeland security technology.
Option A – County of Merced works with Telcion on an exclusive pre-sales basis to determine solution/products/scope and project/order is $10k or higher
CATEGORY HOW
SUPPLIED
%
DISCOUNT
OFF LIST
PRICE
1.0 Communications Services
Call Center Solutions (with ACD) Cisco 45%
Emergency Notification Solutions (Reverse
911)
Cisco 45%
Engineering/Consulting Services Cisco 10%
Integrated Voice Response (IVR) Cisco 45%
Voice over Internet Protocol (VOIP) Cisco 45%
Unified Messaging (UM) Cisco 45%
Long Distance Services (Switched, Dedicated)
Telecommunications Systems (PBX) Cisco 45%
Telephone Handsets Cisco 45%
#15..
- 558 -
Voice Mail Solutions Cisco 45%
Wireless Voice Communication Services Cisco 45%
2.0 Application Systems
Development
Installation Solutions
Version Control Solutions
3.0 Infrastructure
Battery Backup Systems
Cabling Services Panduit/Berktek20%
Energy Auditing and Management Solutions
4.0 Enterprise Mobility Solutions
Mobile Device Management Cisco/Meraki 45%
Mobile Devices (Tablets)
Mobile Applications
5.0 Maintenance Services Telcion 10%
#15..
- 559 -
6.0 Network & Enterprise Security Solutions
Firewall & Virtual Private Network (VPN)
Solutions
Cisco 45%
Intrusion Detection/Prevention Solutions Cisco 45%
Network, Host & Enterprise Management
Solutions
Cisco 45%
Transport Solutions (PRI, MPLS, Super-trunks,
CO Business Lines, Optical, Satellite, Wireless)
Video Solutions Cisco 45%
Wireless Solutions (Wi-Fi) Cisco 45%
7.0 E-Government
Web Site Analytics
Web Site Content Management Solutions
Web Site Design, Development, Hosting
Services
Web Site Development Tools
Web Site Intranet Solutions
#15..
- 560 -
Web Monitoring & Filtering Solutions Cisco 45%
Web Site Portal Solutions
8.0 Enterprise Systems
Virtualization (Servers) VMWare 10%
Virtual Desktop Infrastructure (VDI) VMWare 10%
Anti-Virus, Spam, Spyware Solutions Cisco 45%
Data Encryption Products & Services Cisco 45%
Helpdesk Solutions
Hosting Services and Applications (Cloud and
SaaS)
Cisco 30%
Radio Frequency Identification (RFID) Cisco 45%
Server, Storage & Data Management Products Cisco 45%
Telepresence/Video Conferencing Cisco 45%
9.0 Training Solutions Telcion 10%
10.0 Consulting Services Telcion 10%
#15..
- 561 -
11.0 Other Goods and Services
Cisco SmartNet Contracts
Cisco Cloud Services (Webex Calling/Webex etc.)
Labor: Project Manager
Labor: Systems Engineer CCVP VOICE
Labor: Systems Engineer CCIE
Labor: Systems Engineer LAN/WAN/WIRELESS
Labor: Systems Engineer Security
Labor: Systems Engineer Telepresense
Labor: Systems Engineer Training
Labor: Cabling (Team of 2)
Labor: Project Manager Cabling
List Price
Cisco
Cisco
$225
$225
$250
$225
$225
$225
$200
$120
$200
Discount
19%
30%
10%
10%
10%
10%
10%
10%
10%
10%
10%
#15..
- 562 -
EXHIBIT 1A- CATEGORY OF SERVICES
Contractor should be prepared to demonstrate how they will provide standard and advanced information technology, telecommunications, imaging, homeland security technology.
Option A – Project/order is $10k or less OR does not work with Telcion exclusively in presales design for product/scope.
CATEGORY HOW
SUPPLIED
%
DISCOUNT
OFF LIST
PRICE
1.0 Communications Services
Call Center Solutions (with ACD) Cisco 41%
Emergency Notification Solutions (Reverse
911)
Cisco 41%
Engineering/Consulting Services Cisco 10%
Integrated Voice Response (IVR) Cisco 41%
Voice over Internet Protocol (VOIP) Cisco 41%
Unified Messaging (UM) Cisco 41%
Long Distance Services (Switched, Dedicated)
Telecommunications Systems (PBX) Cisco 41%
Telephone Handsets Cisco 41%
#15..
- 563 -
Voice Mail Solutions Cisco 41%
Wireless Voice Communication Services Cisco 41%
2.0 Application Systems
Development
Installation Solutions
Version Control Solutions
3.0 Infrastructure
Battery Backup Systems
Cabling Services Panduit/Berktek20%
Energy Auditing and Management Solutions
4.0 Enterprise Mobility Solutions
Mobile Device Management Cisco/Meraki 41%
Mobile Devices (Tablets)
Mobile Applications
5.0 Maintenance Services Telcion 10%
#15..
- 564 -
6.0 Network & Enterprise Security Solutions
Firewall & Virtual Private Network (VPN)
Solutions
Cisco 41%
Intrusion Detection/Prevention Solutions Cisco 41%
Network, Host & Enterprise Management
Solutions
Cisco 41%
Transport Solutions (PRI, MPLS, Super-trunks,
CO Business Lines, Optical, Satellite, Wireless)
Video Solutions Cisco 41%
Wireless Solutions (Wi-Fi) Cisco 41%
7.0 E-Government
Web Site Analytics
Web Site Content Management Solutions
Web Site Design, Development, Hosting
Services
Web Site Development Tools
Web Site Intranet Solutions
Web Monitoring & Filtering Solutions Cisco 45%
#15..
- 565 -
Web Site Portal Solutions
8.0 Enterprise Systems
Virtualization (Servers) VMWare 10%
Virtual Desktop Infrastructure (VDI) VMWare 10%
Anti-Virus, Spam, Spyware Solutions Cisco 41%
Data Encryption Products & Services Cisco 41%
Helpdesk Solutions
Hosting Services and Applications (Cloud and
SaaS)
Cisco 30%
Radio Frequency Identification (RFID) Cisco 41%
Server, Storage & Data Management Products Cisco 41%
Telepresence/Video Conferencing Cisco 41%
9.0 Training Solutions Telcion 10%
10.0 Consulting Services Telcion 10%
11.0 Other Goods and Services List Price Discount
#15..
- 566 -
Cisco SmartNet Contracts
Cisco Cloud Services (Webex Calling/Webex etc.)
Labor: Project Manager
Labor: Systems Engineer CCVP VOICE
Labor: Systems Engineer CCIE
Labor: Systems Engineer LAN/WAN/WIRELESS
Labor: Systems Engineer Security
Labor: Systems Engineer Telepresense
Labor: Systems Engineer Training
Labor: Cabling (Team of 2)
Labor: Project Manager Cabling
Cisco
Cisco
$225
$225
$250
$225
$225
$225
$200
$120
$200
19%
25%
10%
10%
10%
10%
10%
10%
10%
10%
10%
#15..
- 567 -
#15..
- 568 -
#15..
- 569 -
Criteria Calculated
Points AMS.NET, Inc. AT&T
1 Overall Responsiveness to the RFP 10 9 9.67
2 Comprehensiveness 30 28 28
3 Experience 20 19.33 18.67
4 Performance and History 10 9.33 9.67
5 Scope of Work Time Frame 10 9.33 9.67
6 Acceptance to the Terms and Conditions
of RFP 10 9.67 8.67
7 Pricing 10 9.67 8.67
Total Points 94.33 93
RFP #7370
#15..
NTT America
Solutions, Inc
Telcion
Communications
Group
8.33 7.67
25 23
18 15.33
9 8
7.33 9
7.67 9
8.67 8.33
84 80.33
#15..
CITY OF MODESTO
COUNCIL AGENDA REPORT
DATE OF MEETING:
February 8, 2022
Date: January 25, 2022
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
Will Wong, Director of Utilities
SUBJECT: New Closed-Circuit Television (CCTV) Van for Utilities Department CONTACT: Cynthia Kline, Purchasing Manager, [email protected], (209) 577-5412 DESCRIPTION:
Consider approving the competitive bidding process from Sourcewell (formerly National Joint Powers Alliance) with Rapid View IBAK North America under authorized dealer Jack Doheny Company, Northville, MI, for a Closed-Circuit Television (CCTV) van for a total amount not to exceed $264,154. (Funding Source: Wastewater Fund)
STRATEGIC PLAN ELEMENT:
These items support the City of Modesto 2020-2025 Strategic Plan Focus of Governance and Service Delivery under Goal D: Provide safe, efficient, and reliable infrastructure through proactive community investment, maintenance and sustainability efforts and Goal H: Achieve Financial Sustainability.
BACKGROUND:
In 2006, the State Water Resources Control Board (Regional Board) implemented a general Waste Discharge Requirements (WDR) governing the operations and maintenance of wastewater collection systems. The WDR requires a Sanitary Sewer Management Plan (SSMP) be adopted by the “Enrollees” governing board at a public meeting.
In March 2007, HDR, a consultant group, completed a “WDR Gap Analysis” for the City with recommendations for maintaining compliance with the WDR1.
On July 24, 2007, by Resolution No. 2007-460, the City Council approved the development of the SSMP.
On April 07, 2009, by Resolution No. 2009-150, the City Council approved the completed SSMP2.
1 The WDR Gap Analysis determined the purchase of an additional CCTV inspection unit was recommended at that time. 2 Several updates to the SSMP have been approved since that time: February 07, 2012, March 03, 2015 and August 17, 2017. #16..
- 572 -
City Council, February 8, 2022
New CCTV Van for Utilities Department
A key element in the SSMP, as outlined in the WDR, is the development of a rehabilitation and replacement plan. The program should include regular visual and TV inspections of manholes and sewer pipes.
The additional CCTV unit is critical in improving the City’s Sanitary Sewer Overflow (SSO) reduction program. The City owns approximately 3,432,000 linear feet of pipe. However, the current CCTV van inspects approximately 24,000 linear feet of pipe per month. At this rate, it will take 11.9 years to inspect the entire system one time. The industry standard is to inspect all lines every six (6) to ten (10) years. This is only possible with the purchase of a second CCTV van. In doing so, it will aid in identifying areas within the system in need of maintenance and thereby reduce SSOs. The reduction in SSOs will aid in preventing future fines and potential lawsuits from non-governmental entities (NGOs).
Throughout the fiscal year, new vehicles need to be added to the City’s Fleet inventory due to the operational needs for the City departments. When these vehicles are added, they will be added to the Fleet Replacement list to prepare for future replacement.
RFB Vehicle # Description Dept. Year of
Vehicle
Meter Repair
Cost
Source
well
NEW
ADD
CCTV Van Utilities N/A N/A N/A
This vehicle is needed to increase the amount of pipe the City of Modesto inspects each year.
DISCUSSION:
On November 16, 2017, Sourcewell issued Request for Proposals (RFP) #122017 for Sewer Vacuum, Hydro-Excavation, and Street Sweeper Equipment, with Related Accessories and Supplies, on the Sourcewell website3, the Onvia website 4, PublicPurchase.com website5, Merx, Biddingo, AAMDC, and the New York State Contract Reporter. The RFP was also advertised and distributed to fifty-eight (58) vendors. On December 21, 2017 proposals were formally opened at the Sourcewell offices. Thirty (30) proposals were received and based on the Sourcewell Proposal Review Committee and criteria outlines in the RFP6, thirteen (13) contracts were awarded7 for Sewer Vacuum, Hydro-Excavation, and Street Sweeper Equipment, with Related Accessories and Supplies.
Sourcewell’s analysts streamline the procurement process by developing RFP’s for national competitive solicitations that meet or exceed local requirements. The competitive process is continually refined to best meet agency needs and allows Sourcewell to offer exceptional products from nationally acclaimed vendors. The Purchasing Division recommends utilizing the existing competitively bid contract with Rapid View IBAK North America under authorized dealer Jack Doheny Company, Northville, MI for a CCTV for a total amount not to exceed $264,154. 3 www.sourcewll-mn.gov
4 www.onvia.com
5 www.PublicPurchase.com
6 Conformance to Terms/Conditions to Include Documentation, Pricing, Financial, Industry and Marketplace Successes, Bidder’s Ability to Sell/Service Contract Nationally, Bidder’s Marketing Plan, Value Added Attributes, Warranty Coverages and Information, and Selection and Variety of Products and Services Offered 7 Atlantic Machinery, Inc., Exprolink Inc., Federal Signal Corporation, GapVax Inc., Global Environmental Products, Inc., Grandall Industries, Inc., Hi-Vac Corporation, Johnston North America, NiteHawk Sweepers, LLC, RapidView, LLC, Schwarze Industries, Inc.
Sewer Equipment Company, and TYMCO, Inc.
#16..
- 573 -
City Council, February 8, 2022
New CCTV Van for Utilities Department
Modesto Municipal Code Section 8-3.203 generally requires all purchases that meet or exceed $50,000 for material, equipment or contractual services to be formally bid. However, exceptions to the formal bidding process are granted in MMC 8-3.204(d) “Where the Purchasing Manager, in her discretion, determines that a process other than the formal bid procedure set for in Section 8-3.203 will result in a procurement for the City at the lowest possible cost commensurate with the desired quality.” In addition, MMC 8-3.202(h) encourages the Purchasing Manager to join with the State of California or other units of government in cooperative purchasing plans when the best cost savings interest of the City would be served.
FISCAL IMPACT:
Sufficient funds for the one CCTV van are budgeted in Fiscal Year 21-22 in the Wastewater Fund in account 4210-44211-57003.
Due to the increase in market costs, the pricing for the CCTV inspection unit under the Sourcewell agreement is only valid until February 20, 2022.
After that date, the price will increase by 5.0% which will increase costs to the City by an additional $13,208 for a new total of $277,362.
COMMITTEE RECOMMENDATION:
This item was presented at the January 24, 2022 Finance Committee and approved to move forward to Council.
RECOMMENDED COUNCIL ACTION:
Staff Recommendations:
Resolution approving the competitive bidding process from Sourcewell (formerly National Joint Powers Alliance) with Rapid View IBAK North America under authorized dealer Jack Doheny Company, Northville, MI, for a Closed-Circuit Television (CCTV) van for a total amount not to exceed $264,154; and authorizing the Purchasing Manager, or her designee, to issue the purchase order.
Approved by:
DeAnna Christensen, Director of Finance
Will Wong, Director of Utilities
Joseph P. Lopez, City Manager
Attachments:
1. Resolution
2. Rapid View IBAK_Jack Doheny Quote
3. Financial Interest Disclosure
4. Scoring Abstract
#16..
- 574 -
1 MODESTO CITY COUNCIL
RESOLUTION NO. 2022-XX
RESOLUTION APPROVING THE COMPETITIVE BIDDING PROCESS FROM
SOURCEWELL (FORMERLY NATIONAL JOINT POWERS ALLIANCE)
WITH RAPID VIEW IBAK NORTH AMERICA UNDER AUTHORIZED
DEALER JACK DOHENY COMPANY, NORTHVILLE, MI, FOR A CLOSEDCIRCUIT TELEVISION (CCTV) VAN FOR A TOTAL AMOUNT NOT TO EXCEED $264,154; AND AUTHORIZING THE PURCHASING MANAGER, OR
HER DESIGNEE, TO ISSUE THE PURCHASE ORDER
WHEREAS, in 2006, the State Water Resources Control Board (Regional Board) implemented a general Waste Discharge Requirements (WDR) governing the operations and maintenance of wastewater collection systems; and
WHEREAS, the WDR requires a Sanitary Sewer Management Plan (SSMP) be adopted by the “Enrollees” governing board at a public meeting which occurred on April 7, 2009; and
WHEREAS, a key element in the SSMP, as outlined in the WDR, is the development of a rehabilitation and replacement plan; the program should include regular visual and TV inspections of manholes and sewer pipes; and WHEREAS, the additional CCTV unit is critical in improving the City’s Sanitary Sewer Overflow (SSO) reduction program and to maintain the required inspections for the system by industry standards; and
WHEREAS, on November 16, 2017, Sourcewell issued Request for Proposals (RFP) #122017 for Sewer Vacuum, Hydro-Excavation, and Street Sweeper Equipment, with Related Accessories and Supplies, on the Sourcewell website, the Onvia website, PublicPurchase.com website, Merx, Biddingo, AAMDC, and the New York State Contract Reporter; and
#16..
- 575 -
2 WHEREAS, the RFP was also advertised and distributed to fifty-eight (58) vendors; and
WHEREAS, thirty (30) proposals were received and based on the Sourcewell Proposal Review Committee and criteria outlines in the RFP, thirteen (13) contracts were awarded for Sewer Vacuum, Hydro-Excavation, and Street Sweeper Equipment, with Related Accessories and Supplies; and
WHEREAS, Modesto Municipal Code (MMC) Section 8-3.203 generally requires all purchases that meet or exceed $50,000 for material, equipment or contractual services to be formally bid. However, exceptions to the formal bidding process are granted in MMC 8-3.204(d) “Where the Purchasing Manager, in her discretion, determines that a process other than the formal bid procedure set for in Section 8-3.203 will result in a procurement for the City at the lowest possible cost commensurate with the desired quality;” and
WHEREAS, MMC 8-3.202(h) encourages the Purchasing Manager to join with the State of California or other units of government in cooperative purchasing plans when the best cost savings interest of the City would be served.
NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves the competitive bidding process from Sourcewell (formerly National Joint Powers Alliance) with Rapid View IBAK North America under authorized dealer Jack Doheny Company, Northville, MI, for a Closed-Circuit Television (CCTV) van for a total amount not to exceed $264,154.
BE IT FURTHER RESOLVED, that the Purchasing Manager, or her designee, is hereby authorized to execute the purchase order.
#16..
- 576 -
3 The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 8th day of February 2022, by Councilmember ________, who moved its adoption, which motion being duly seconded by Councilmember ______, was upon roll call carried and the resolution adopted by the following vote:
AYES: Councilmembers:
NOES: Councilmembers:
ABSENT: Councilmembers:
ATTEST: _____________________________
DANA SANCHEZ, Interim City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: _______________________________________
JOSE M. SANCHEZ, City Attorney
#16..
- 577 -
1 1
1 1
1 1
1 1
1 1
1 1
1 Date: 12/28/2021
1 Branch: 1700
1 1
1 1
1 1
1 1
1 1
1 1
1 1
1 1
1 1 CUSTOMER:
1 ADDRESS:
1 CITY, STATE, ZIP:
1 PHONE:
1 ATTN:
1 1
1 1
1 1
1 1
25631
17111
1 Sourcewell Contract #122017-RVL
City of Modesto
1221 Sutter Avenue
Modesto, CA 95353
209/577-5440
Robert Englent
DOHENYCOMPANY.COM
RAPIDVIEW ID:
PROPOSAL ID:
2021 Price List
Rev: 8/1/2021 Customer Initials: ____
#16..
- 578 -
1 List Net
1 Standard Cameras:
1 V0494050 $ 20,466.00 $ 20,466.00
1 1 Camera Head Accessories:
1 901601040 $ 491.00 $ 491.00
1 1 T66 Tractor and Accessories:
1 905211031 $ 726.00 $ 726.00
1 905253031 $ 324.00 $ 324.00
1 905210091 $ 636.00 $ 636.00
1 905210191 $ 869.00 $ 869.00
1 905216291 $ 1,161.00 $ 1,161.00
1 905215991 $ 1,350.00 $ 1,350.00
1 905216791 $ 1,539.00 $ 1,539.00
1 902211090 $ 1,354.00 $ 1,354.00
1 1 Vehicle Mounted Control Units:
1 V1976007 $ 31,793.00 $ 31,793.00
1 1 Reels:
1 V8029020 $ 35,640.00 $ 35,640.00
1 Camera Cable:
1 80071900 $ 14,223.60 $ 14,223.60
1 1 Reel Accessories:
1 904350020 $ 702.00 $ 702.00
1 802617031 $ 1,069.00 $ 1,069.00
1 800500841 $ 1,003.00 $ 1,003.00
1 8025975001 $ 486.00 $ 486.00
1 1 HD Systems:
1 V9052009 $ 12,550.00 $ 12,550.00
1 V9052021 $ 2,106.00 $ 2,106.00
1 1 Computer Systems:
1 V0001017 $ 3,032.00 $ 3,032.00
1 1 Chassis:
1 VZ000700 $ 50,377.00 $ 50,377.00
1 Tungsten Carbide Wheels for T66/PANO 150 in 6" and up Tungsten Carbide Wheels for T66/PANO 150 in 8" and up
T66/PANORAMO 150 Pneumatic Wheels for large pipe w/ adapters T66.1 HD Camera Tractor
HD FO4 Camera Cable Type 00/12 - 1640 feet
F550 Gas 4x2
ORION 3 Zoom HD/SD Adaptive
Pressure Test Set
Additional Weight Kit for T66 (Heavy and Light)
Larger T66 hook for use with poles (optional)
Treaded Wheel set for 5" pipe for T66/6" for PANORAMO 150 (HARD) Treaded Wheel set for 6" pipe for T66/8" for PANORAMO 150 (HARD) Tungsten Carbide Wheels for T66 in 5" and up
KW505 FO2 4K (PANORAMO 4K capable) Synchronized Power Cable Reel BS 7 - Vehicle Mounted Control EDI for ALL SYSTEMS
Camera Connection Type 2-8 HD for SD Camera and Orion (SD or HD Modes 19" Industrial PC Package
KUV 2.7 Cable Deflection Pulley for Standard and Fiber Optic Cable with holder and rope Foot switch for winch (KW505 and KW305)
KW305/505 Upper deflection pulley (attaches to boom)
Cable Cleaning Brush for KW305/310/505
2021 Price List
Rev: 8/1/2021 Customer Initials: ____
#16..
- 579 -
0 Rapidview Build Out Options:
0 1 VZ000741 $ 45,652.00 $ 45,652.00
1 VZ000802 $ 929.00 $ 929.00
1 VZ000703 $ 265.00 $ 265.00
1 VZ000306 $ 2,025.00 $ 2,025.00
1 Equip Sales $ 675.00 $ 675.00
1 VZ000825 Fold-Out Steps (Side Access) $ 877.50 $ 877.50 1 VZ000826 Fold-down Steps (rear) $ 1,147.50 $ 1,147.50 1 VZ000817 $ 3,240.00 $ 3,240.00
1 Equip Sales Bathroom Addition $ 5,521.00 $ 5,521.00
17" 4:3 Monitor - Metal Case/Glass Front - HDMI, DP, DVI, CVBS, S Video, VGA Powered Rear Canopy - Push button
* Chassis purchased separately, call for required chassis specifications * Includes installation of box on approved chassis
* Dual swing open rear doors
* Side entry door
* Rear backup camera
* Commercial Genset (GAS)
* Walk-thru design with partition wall and door
* Tinted glass viewing window in Bulkhead Wall
* 12v LED Lighting
* Aluminum plank flooring/easy cleaning and improved grip when wet * Roof Air
* Exterior shore power package with extension cord
* Auxiliary battery and charging system
Front Office:
* Carpeted walls in studio
* Laminated base cabinetry
* Laminate countertops in studio
* Vibration resistant electronics cabinet with rear door access to outside of truck * Bench seat over generator
* Mounted high-quality monitor in office
Workspace:
* Heavy-duty, 5 drawer toolbox
* High-quality monitor in workspace for monitoring camera operation * 14 gallon pressurized wash down system
* Butcher block workbench
* Laminate Cabinets
* Aluminum storage shelves
* Overhead laminate cabinets with easy-open hardware
Safety:
* Directional Arrow board at rear
* Strobe light mounted on front roof.
* LED side markers on Box
Small sink in counter
Rear LED arrow board mounted
KW Reel Cabinet with 2 sliding aluminum drawers
Inspection Vehicle Conversion for GAS Chassis - 16' FRP Box. Dim: 16'x8'x6'6" 2021 Price List
Rev: 8/1/2021 Customer Initials: ____
#16..
- 580 -
0 1 JDC Accessories: Non-Sourcewell
1 TRP01 $ 450.00 $ 450.00
1 Poleset $ 343.00 $ 343.00
1 52846 $ 37.00 $ 37.00
1 Additional Options Sale Price
1 HD Vid Cap $ 500.00 $ 500.00
1 1 Sourcewell Build-Quote Summary
1 $ 242,229.60
1 $ 9,689.18
1 $ 232,540.42
1 1 $ 1,330.00
1 $ 233,870.42
1 1 $ 7,500.00
1 $ 3,500.00
1 $ 244,870.42
$ 19,283.55
$ 264,153.96
V4011004 $ 5,345.00 $ 5,345.00
V9052023 $ 4,239.00 $ 4,239.00
1 1
1 1
1 Customer:
1 By:
1 Date:
JDC -Top Manhole Roller
HD Vid Cap for IT Pipes Software (Magewell)
• Acceptance of this Proposal is subject to availability of the Equipment listed above.
Field Training:
Total:
Module/Options/Chassis Total:
Options Sourcewell Discount 4%:
Module/Options Total per Sourcewell Price Schedule:
Additional
Freight and PDI:
Total with Module, Chassis and All Options:
Terms and Conditions
Total with Sales Tax:
Modesto, CA Sales Tax - 7.875%:
Additional Items:
4.1 LIFT FOR T66 Type 4-8 HD for SD Camera and Orion (SD or HD Modes) RETRUS 16 Back-Eye Camera For HD systems
This proposal becomes a contract for delivery and payment of the merchandise listed above only when signed by the customer or one of its officers. • If this Proposal is not executed by both parties within thirty (30) calendar days from the Proposal Date, this Proposal shall become null and void, unless subsequently executed by both Buyer and Seller.
Thank you for your consideration of this proposal.
Sincerely yours,
Stephanie Prescott
Stephanie Prescott
Regional Sales Representative
760/644-5147
[email protected]
• Execution of this Proposal by Seller and Buyer constitutes a binding agreement between the parties. • Sales Price does not include any applicable sales taxes. Buyer is responsible for and agrees to pay all applicable sales tax. • The Sale of New Equipment Terms and Conditions are incorporated into and made a part of this Proposal upon acceptance and execution of this Proposal by both parties.
JDC-18' of Fiberglas Poles, Mounting Bracket and IBAK Adapter 3" Tiger Tail
2021 Price List
Rev: 8/1/2021 Customer Initials: ____
#16..
- 581 -
1. THE AGREEMENT. Jack Doheny Companies, Inc., (the “Seller”) agrees to sell, transfer and convey its right, title and interest in the new goods, equipment, vehicles and/or other new items (collectively, the “Equipment”) described in Seller’s written Invoice for the Sale of New Equipment (the “Invoice”) to the Buyer subject to the terms and conditions contained herein, which are incorporated into the Invoice, agreed to by the parties hereto, and together consists of the entire agreement between the Seller and Buyer (collectively, the “Agreement”). The Agreement shall be for the benefit of the Seller and Buyer and not for the benefit of any other person or entity. Prior courses of dealing, trade usage and verbal agreements not reduced to a writing signed by the Seller and Buyer, to the extend they differ from, modify, add to or change from the Agreement shall not be binding on the Seller.
2. TERMS OF PAYMENT.
2.1 Payment Date. All payments for the Equipment are due from Buyer on the date of the invoice unless other terms are agreed to in writing between Seller and Buyer. Payment shall be made to Seller at the address specified in the Agreement, without any offset or deduction for any reason.
2.2 Shipping Delays. If any shipment is delayed at the request of Buyer, payment shall become due based on the date Seller is prepared to make shipment, and Seller may invoice Buyer based on such date. All prices for Equipment are F.O.B. Seller's shipping point.
2.3 Delinquent Payments.
2.3.1 Any payment not made by Buyer on or before its due date shall be subject to a late charge on any unpaid balance at a rate of 18% per annum, or the highest interest rate allowed by law, whichever is greater.
2.3.2 If a payment is not made on or before its due date, Buyer agrees that Seller may elect, in addition to any other remedy at law or in equity, to cease performance under the Agreement and any other agreement between Buyer and Seller until such payment is rendered to Seller .
3. DELIVERY. Seller does not guarantee delivery dates.
4. RISK OF LOSS. Buyer assumes all risk of loss of Equipment upon delivery by Seller to carrier if Equipment is shipped. For Equipment that is shipped, Seller agrees to: (a) prepare the Equipment for shipment to Buyer; (b) deliver custody of the Equipment to carrier; (c) make appropriate arrangements for the transportation to carrier; and deliver documents to enable Buyer to obtain possession of the Equipment. Seller shall not be obligated to obtain insurance or to prepay transportation/carrier costs for the Equipment. Buyer agrees to be responsible for and to timely pay all loading, unloading and other charges incidental to transportation of the Equipment. Whether Seller pays transportation charges or not, risk of loss shall pass to Buyer upon delivery of the Equipment to a carrier.
5. INSPECTION OF EQUIPMENT. Buyer has inspected the Equipment and is satisfied with the Equipment’s condition.
6. INDEMNIFICATION. Buyer shall indemnify, hold harmless and release Seller from any and all liabilities, losses, damages, claims, costs and expenses, including attorney fees, arising out of, in whole or in part, from (a) the design, or manufacture of the Equipment; or (b) the use of the Equipment by Buyer and those acting on Buyer’s behalf.
7. MISCELLANEOUS.
7.1 No Assignment. There shall be no assignment of the Agreement by Buyer without the prior written approval of Seller. Any assignment of the Agreement shall not relieve Buyer of its obligations under the Agreement.
7.2 Force Majeure. Neither party will be liable for any delay or failure to perform its obligations hereunder, other than a payment obligation, due to any cause beyond its reasonable control including without limitation, acts of God or of the public enemy, including terrorists, acts of the government in its sovereign capacity, fires, floods, epidemic, strikes, picketing or boycotts, or any other circumstances caused by natural occurrences or third party actions beyond the reasonable control and without the fault or negligence of the party whose performance is affected (“Force Majeure Events”); provided that the affected party provides the other party prompt notice of the applicable circumstance and uses commercially reasonable efforts to re -commence performance as promptly as possible; provided, further, that if the duration of such Force Majeure Event exceeds thirty (30) days, the other party may terminate the Agreement upon delivery of written notice to the affected party.
7.3 Venue. The parties agree that any dispute under the Agreement shall be brought in the applicable state or federal court located in the county in which the Originating Branch is located and the parties waive any right to a jury trial.
7.4 Construction and Captions. The parties acknowledge that each has reviewed the Agreement and that the normal rules of construction to the effect that any ambiguities are to be resolved against the drafting party shall not be employed in the interpretation of the Agreement or any exhibits or amendments hereto ; and that section headings appearing in the Agreement are for convenience of reference only and they are not intended, to any extent or for any purpose, to limit or define the text of any section or any subsection hereof. In the event any part of the Agreement is found to be ambiguous, such ambiguity shall not be construed against any party.
7.5 Entire Agreement. The Agreement constitutes the sole and entire agreement between the parties and supersedes all prior and contemporaneous statements , promises, understandings or agreements, whether written or oral.
7.6 Amendments. The Agreement may be amended, modified or altered at any time upon the approval of the Seller and Buyer; however, any such amendment must be in writing and signed by the Seller and Buyer in order for such amendment to be of any force and effect .
7.7 Partial Invalidity. In the event that any provision of the Agreement is declared by any court of competent jurisdiction or any administrative judge to be void or otherwise invalid, all of the other terms, conditions and provisions of the Agreement shall remain in full force and effect to the same extent as if that part declared void or invalid had never been incorporated in the Agreement and in such form, the remainder of the Agreement shall continue to be binding upon the parties.
7.8 Counterparts. The Agreement and any amendment thereto may be signed and executed in one or more counterparts, each of which shall be deemed an original and all of which together shall constitute one Agreement. Delivery of an executed counterpart of a signature page of the Agreement by facsimile or email shall be effective as delivery of an originally executed counterpart of the Agreement.
7.9 Authority. Each person(s) executing the Agreement as an agent or in a representative capacity warrants that he or she is duly authorized to do so .
NO WARRANTY. SELLER MAKES NO WARRANTIES OR REPRESENTATIONS EXPRESS OR IMPLIED BY OPERATION OF LAW OR OTHERWISE,
INCLUDING WITHOUT LIMITATION, ANY IMPLIED WARRANTY OF MARKETABILITY OR FITNESS FOR PARTICULAR PURPOSE, ALL OF WHICH ARE SPECIFICALLY HEREBY DISCLAIMED. To the extent allowed by law and those agreements, Seller transfers and assigns to Buyer the Equipment manufacturer’s warranties, if any such warranty is provided by the Equipment manufacturer. In no event shall Seller be liable to Buyer for any incidental , consequential, special, exemplary, and/or punitive damages, including without limitations, loss of revenue or profit.
SALE OF NEW EQUIPMENT
TERMS AND CONDITIONS
702-665-5397
[email protected]
dohenycompany.com
#16..
- 582 -
INVOICE INFORMATION
Sold to: Name
Address
Contact
Phone #
Email Address:
Ship to: Name
Address
Contact
Phone #
Email Address
PLEASE SELECT TYPE OF BUSINESS
Environmental ___________Petro Chemical_______ Gas & Oil_________________ Sewer & Water_______ Industrial Plant___________Utility_______________ Municipal________________ Other_______________ Customer Signature:
#16..
- 583 -
TITLE INFORMATON FORM
Must be typed. Please ensure accurate information provided with submission of this document. Any re-issuance of title resulting from inaccurate data may be subject to a $250.00 processing fee.
Name
Address
Contact
Phone #
Email Address
County: _________________________________
Fed ID# _________________________________
Title Mailed to: Name
Contact
Phone #
Email Address
Lienholder: Name
Address
Contact
Phone #
Email Address
Customer Signature:
(If no lienholder exists,
'Not Applicable' must be
notated in Name field)
Title Assigned to:
(Name and information
for purchaser of the unit)
(Must be Physical Address)
(Company or business that will
be registering the unit)
777 Doheny Drive
Northville, MI 48167
t 248-349-0904
p 248-349-2774
Address
#16..
- 584 -
#16..
- 585 -
#16..
- 586 -
#16..
- 587 -
CITY OF MODESTO
COUNCIL AGENDA REPORT
DATE OF MEETING:
February 8, 2022
TO: Mayor and City Council Date: January 25, 2022
THROUGH: Joseph P. Lopez, City Manager
FROM: Alan Ernst, Fire Chief
SUBJECT: Turlock Fire Administrative Contract
CONTACT: Alan Ernst, Fire Chief, [email protected], 209.572.9590 DESCRIPTION:
Consider approving an Agreement to provide fire administrative services between the City of Modesto and the City of Turlock for a four-year, four and one-half month term, with one two-year extension option, amending the Position Allocation for Fiscal Year 2021-2022 as adopted in the operating budget, and amending the Fiscal Year 2021-22 Operating Budget by $126,555 in revenues and $107,805 in expenses. (Funding Source: General Fund) STRATEGIC PLAN ELEMENT:
This action supports the City of Modesto 2020-2025 Strategic Plan focus on quality of life under Goal A: Improve Community Safety.
BACKGROUND:
The City of Modesto Fire Department (“COM”) and City of Turlock Fire Department (“Turlock”) both provide fire protection, prevention, suppression services, and related services such as emergency medical services, emergency preparedness, mitigation of hazardous materials incidents, and special operations including, but not limited to, confined space rescue, technical rescue, and water rescue, in addition to administrative services, including, but not limited to, payroll, human resources, budgeting, data analysis and overall department oversight within the territorial limits of the cities of Modesto and Turlock.
The Turlock City Council recently requested a proposal to provide fire administrative services to their city.
DISCUSSION:
In order to maintain fire services, the City of Turlock is requesting the City of Modesto to represent Turlock and provide roles and responsibilities of the Fire Chief, overseeing and administering Turlock operations including budget, training, personnel, facilities, and all other operations. All City of Turlock employees, under the terms of this agreement, will be under the supervision and control of the City of Modesto Fire Chief. #17..
- 588 -
City Council, February 8, 2022
Turlock Fire Administrative Contract
The initial term of the Agreement will be for four years, four and one-half months, from February 15, 2022 through June 30, 2026. The Agreement may be extended for one additional two-year term, if all parties agree no later than June 30, 2025. Turlock will compensate COM for all services provided, pursuant to the terms and conditions of the Agreement.
FISCAL IMPACT:
This Agreement positively impacts the General Fund through the economies of scale from regionalization. There is no negative impact to the General Fund, as revenues from the agreement will compensate for the position needed to provide administrative support.
In order to represent Turlock and provide roles and responsibilities of the Fire Chief, the department is requesting one (1) Deputy Chief at the Assistant Fire Chief pay rate. Such individual will remain an employee of the City of Modesto, under the supervision and control of the Modesto Fire Chief.
The total anticipated cost of the contract, over the four-year, four and one-half month term, is $1,628,999. The anticipated revenue generated from the administrative fee, over the four-year, four and one-half month term, is $218,750.
COMMITTEE RECOMMENDATION:
This item was not reviewed at the Committee level and was approved by City Manager to go straight to Council.
RECOMMENDED COUNCIL ACTION:
Staff Recommendations:
Resolution approving an Agreement to provide fire administrative services between the City of Modesto and the City of Turlock for a four-year, four and one-half month term, with one two-year extension option, and authorizing the City Manager, or his designee, to execute the agreement.
Resolution amending the Position Allocation for Fiscal Year 2021-2022 as adopted in the operating budget.
Resolution amending the Fiscal Year 2021-22 Operating Budget by $126,555 in revenues and $107,805 in expenses and authorizing the City Manager, or his designee, to implement the provisions the resolution.
Approved by:
Alan Ernst, Fire Chief
Joseph P. Lopez, City Manager
Attachments:
1. Resolutions (3)
2. Agreement
3. Exhibit A
#17..
- 589 -
1 MODESTO CITY COUNCIL
RESOLUTION NO. 2022-XXX
RESOLUTION APPROVING AN AGREEMENT TO PROVIDE FIRE
ADMINISTRATIVE SERVICES BETWEEN THE CITY OF MODESTO AND
THE CITY OF TURLOCK FOR A FOUR-YEAR, FOUR AND ONE-HALF
MONTH TERM, WITH ONE TWO-YEAR EXTENSION OPTION, AND
AUTHORIZING THE CITY MANAGER, OR HIS DESIGNEE, TO EXECUTE
THE AGREEMENT
WHEREAS, the City of Modesto (“COM”) and City of Turlock Fire Department (“Turlock”) both provide fire protection services, as well as emergency medical services, special operations and administrative services; and
WHEREAS, Turlock recently requested a proposal to provide fire administrative services to their city; and
WHEREAS, in order to maintain fire services for Turlock, the department is requesting one Deputy Chief, at the Assistant Chief pay rate, to represent the city and serve as their Fire Chief, overseeing and administering Turlock operations including budget, training, personnel, facilities, and all other district operations; and WHEREAS, the Deputy Chief will remain an employee of the City of Modesto, under the supervision and control of the Modesto Fire Chief; and WHEREAS, the initial term of the agreement will be for four years, four and onehalf months, from February 15, 2022 through June 30, 2026, with the option to extend for an additional two-year term if all parties agree no later than June 30, 2025; and WHEREAS, this agreement positively impacts the General Fund through the economies of scale from regionalization; and
WHEREAS, the total anticipated cost of the contract, over the four-year, four and one-half month term is $1,628,999; and
#17..
- 590 -
2 WHEREAS, the anticipated revenue generated from the administrative fee, over the four-year, four and one-half month term is $218,750.
NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that the Council hereby approves the agreement to provide fire administrative services between the City of Modesto and the City of Turlock for a four-year, four and one-half month, with one two-year extension option.
BE IT FURTHER RESOLVED that the City Manager, or his designee, is hereby authorized to execute the agreement, in a form approved by the City Attorney.
The foregoing resolution was introduced at a regular meeting of the Council of the City of Modesto held on the 8th day of February, 2022, by Councilmember ?, who moved its adoption, which motion being duly seconded by Councilmember ?, was upon roll call carried and the resolution adopted by the following vote:
AYES: Councilmembers:
NOES: Councilmembers:
ABSENT: Councilmembers:
ATTEST: _____________________________
DANA SANCHEZ, Interim City Clerk
(SEAL)
APPROVED AS TO FORM:
BY:
JOSE M. SANCHEZ, City Attorney
#17..
- 591 -
MODESTO CITY COUNCIL
RESOLUTION NO. 2022-XXX
RESOLUTION AMENDING THE POSITION ALLOCATION FOR FISCAL
YEAR 2021-2022 AS ADOPTED IN THE OPERATING BUDGET
WHEREAS, per Personnel Administrative Order 2.2-87-12, a classification study may be conducted in response to a reclassification request, to develop/revise a classification specification, or to assist in a reorganization; and WHEREAS, classifications are being added to support a contract for fire administrative services with the City of Turlock Fire Department; and WHEREAS, position changes will be effective the pay period in which February 15, 2022 falls, (Pay Period beginning February 15, 2022).
NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves amending the Position Allocation and the Fiscal Year 2021-2022 Operating Budget for various departments as follows:
1. Create one (1) Deputy Chief at the Assistant Fire Chief pay rate.
The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 8th day of February 2022, by Councilmember ________, who moved its adoption, which motion being duly seconded by Councilmember ______, was upon roll call carried and the resolution adopted by the following vote:
AYES: Councilmembers:
NOES: Councilmembers:
ABSENT: Councilmembers:
#17..
- 592 -
ATTEST:
DANA SANCHEZ, Interim City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: ___________________________________
JOSE M. SANCHEZ, City Attorney
#17..
- 593 -
1 MODESTO CITY COUNCIL
RESOLUTION NO. 2022-XXX
RESOLUTION AMENDING THE FISCAL YEAR 2021-22 OPERATING
BUDGET BY $126,555 IN REVENUES AND $107,805 IN EXPENSES AND
AUTHORIZING THE CITY MANAGER, OR HIS DESIGNEE TO IMPLEMENT
THE PROVISIONS OF THIS RESOLUTION
WHEREAS, the City of Modesto (“COM”) and City of Turlock Fire Department (“Turlock”) both provide fire protection services, as well as emergency medical services, special operations and administrative services; and
WHEREAS, Turlock recently requested a proposal to provide fire administrative services to their city; and
WHEREAS, in order to maintain fire services for Turlock, the department is requesting one Deputy Chief, at the Assistant Chief pay rate, to represent the city and serve as their Fire Chief, overseeing and administering Turlock operations including budget, training, personnel, facilities, and all other district operations as directed by the City of Turlock; and
WHEREAS, this agreement positively impacts the General Fund through the economies of scale from regionalization; and
WHEREAS, the total anticipated cost of the contract, over the four-year, four and one-half month term is $1,628,999; and
WHEREAS, the anticipated revenue generated from the administrative fee, over the four-year, four and one-half month term is $218,750.
WHEREAS, certain budgetary adjustments are necessary to fund this action.
NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves amending the Fiscal Year 2021-22 Operating Budget by $126,555 #17..
- 594 -
2 in revenues and $107,805 in expenses in Modesto Fire Department – Fire Services Cost Center (18214) in the General Fund to support this action.
BE IT FURTHER RESOLVED, that the City Manager, or his designee is hereby authorized to implement the provisions of this resolution.
The foregoing resolution was introduced at a regular meeting of the Council of the City of Modesto held on the 8th day of February, 2022, by Councilmember ??, who moved its adoption, which motion being duly seconded by Councilmember ??, was upon roll call carried and the resolution adopted by the following vote:
AYES: Councilmembers:
NOES: Councilmembers:
ABSENT: Councilmembers:
ATTEST: _____________________________
DANA SANCHEZ, Interim City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: ________________________________
JOSE M. SANCHEZ, City Attorney
#17..
- 595 -