internal grant application forms to manage the types of grants being applied for and to ensure local match requirements will be managed within our current budget.
City departments continue to actively pursue new grant applications as part of notifications received from federal, state, and local agencies they have subscribed to, such as Department of Housing, Department of Transportation, State Water Resources Control Board, Department of Justice and professional government associations. City departments have staff assigned to monitor these grant application notices to determine if the City meets the required qualifications to apply for the grant.
On October 11, 2022 under resolutions 2022-418, 2022-419, and 2022-420, City Council approved three one-year agreements with two one-year extension options, for On-call Water Resource grant research and writing services with Provost & Pritchard Consulting Group, West Yost Associates and Woodard & Curran to assist with grant research opportunities for the Utilities Department.
DISCUSSION:
During the months of September and October 2022, City Council approved the below grant application and award acceptance agreements recommended by City staff based on opportunities to receive federal, state and/or local grant funds for the City with required local match or which exceeded $1,000,000 with no local match.
Public Works Department:
(Grant Application $ To Be Determined – Local Match 20% Measure L Funds) Safe Streets and Roads for All (SS4A) Grants from the U.S. Department of Transportation. Funds from these grants will allow the City to utilize safety metrics to analyze roadway accidents within the City and will fund improvement projects to help with ongoing traffic safety concern within the City.
(Grant Application $ To Be Determined – Local Match 20% Measure L Funds) Strengthening Mobility and Revolutionizing Transportation (SMART) Grants from the U.S.
Department of Transportation. Funds from this grant will be used to fund future transportation technologies. Some eligible projects include; coordinating automation, connected vehicles, sensors, system integration, delivery/logistics, innovative aviation, smart grid, and traffic signals.
(Grant Application $1,050,000 – Local Match $0) Regional Climate Collaboratives Program (RCCP) Grant from the California Strategic Growth Council. Funds from this grant will be used to fund further developing relationships between the City and local food recovery agencies so that they are better prepared for the influx of edible food they will receive under Senate Bill 1383, and also divert textiles and mattresses from landfills.
Some of the major goals for this grant funds include; expanding capacity of local donation sites for perishable food and textiles, reducing emissions associated with transporting, collecting, and distributing food and textiles from producer to donation sites, providing education and resources for donors and expanding methods for large scale distribution, through home drop offs or alternative pickup locations. (Grant Application $275,000 – Local Match $0) California Department of Resources Recycling and Recovery Beverage Container Competitive Grant from CalRecycle. Funds #14..
- 691 -
City Council, February 14, 2023
September and October 2022Grant Application and Awards
from this grant will be used to reach and maintain an 80 percent recycling rate for California Redemption Value beverage containers composed of aluminum, glass, plastic, and bimetal. The City of Modesto uses grant funds to implement many of the waste reduction and recycling programs offered to City residents and businesses. Some of the major goals for this grant include; purchase and install water refill stations throughout City buildings, Modesto schools and the Modesto Children’s museum, and create education and outreach materials with the sole focus on recycling, reusing and reducing.
Modesto Fire Department:
(Grant Award $19,900 – Local Match $19,900, General Fund) Cal Fire Rural Fire Capacity (RFC) Program Grant from CalFire. Funds from this grant will be used for the purchase of wildland firefighting equipment in order to replace aging and outdated wildland equipment that is no longer in service or does not meet current standards.
During the months of September and October 2022, City Manager and Director of Finance approved the below grant applications and awards recommended by City staff based on opportunities to receive federal, state and/or local grant funds for the City with no local match requirement and which did not exceed $1,000,000.
Modesto Police Department:
(Grant Application $2,500 – Local Match $0) Shelter Cove Community Church Law Enforcement Fund from Shelter Cove Community Church. The Shelter Cove Community Church will procure and deliver one camera lens for the Modesto Police Department media unit to use for community event photos and general community engagement.
FISCAL IMPACT:
No fiscal impact will result from the acceptance of this informational report on September and October 2022 grant application and awards. A monthly summary by grant application and awards is below:
Grant Applications: $1,325,000
Grant Applications Local Match, Measure L Funds TBD
Grant Awards: $22,400
Grant Awards Local Match, Current Department Budget $19,900 COMMITTEE RECOMMENDATION:
This item was accepted by the Finance Committee on January 23, 2023 and approved to forward to Council.
RECOMMENDED COUNCIL ACTION:
Staff Recommendations:
Motion accepting an Informational Report for the September and October 2022 Grant Applications and Awards.
Approved by:
DeAnna Christensen, Director of Finance
#14..
- 692 -
City Council, February 14, 2023
September and October 2022Grant Application and Awards
Joseph P. Lopez, City Manager
Attachments:
1. September and October 2022 Grant Applications and Award #14..
- 693 -
September and October 2022 Grant Applications
Grant Application
Grant Title Month Grant Awarding Agency City Department Name/Division Grant
Application
Amount
Grant
Application
Local Match
Amount Local Match Source
Safe Streets and Roads for All (SS4A) Grants SEP-22 U.S. Department of Transportation Public Works Department TBD 20% Measure L Funds Strengthening Mobility and Revolutionizing Transportation (SMART) Grants SEP-22 U.S. Department of Transportation Public Works Department TBD 20% Measure L Funds Regional Climate Collaboratives Program (RCCP) Grant SEP-22 California Strategic Growth Council Public Works Department 1,050,000 - N/A California Department of Resources Recycling and Recovery Beverage Container Recycling Competitive Grant OCT-22 CalRecycle Public Works Department 275,000 - N/A Total $ 1,325,000 TBD
September and October 2022 Grant Awards
Grant Awards
Grant Title Month Grant Awarding Agency City Department Name/Division Grant Award
Amount
Grant Award
Local Match
Amount Local Match Source
Shelter Cove Community Church Law Enforcement Fund OCT-22 Shelter Cove Community Church Modesto Police Department 2,500 - N/A Cal Fire Rural Fire Capacity (RFC) Program Grant OCT-22 CalFire Modesto Fire Department 19,900 19,900 General Fund Total $ 22,400 $ 19,900
#14..
- 694 -
CITY OF MODESTO
COUNCIL AGENDA REPORT
DATE OF MEETING:
February 14, 2023
Date: January 23, 2023
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
SUBJECT: Transient Occupancy Tax Audit
CONTACT: Gina Brown, Revenue Collection and Compliance Manager, [email protected], 209-577-5381
DESCRIPTION:
Consider accepting an informational update on the Transient Occupancy Tax Audit. (Funding Source: General Fund)
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 of Modesto Finance Department oversees the collection of Transient Occupancy Tax (TOT) from the City’s local lodging providers. On October 12, 2004, under Resolution 2004-529, City Council approved the City Finance Department enter into an agreement with Municipal Resources Consultants (now MuniServices, LLC) for various tax consultant services which included tax audits, analysis, and reporting services. In 2017, the Finance Department contracted MuniServices to analyze the records of twenty-five (25) lodging providers and they selected eight (8) lodging businesses to be audited. MuniServices identified a total of $124,200 in tax deficiencies; in accordance with Municipal Code 8-2.610 several hotels requested a hearing. As a result of the hearings held, the hearing officer determined that the lodging providers were required to pay a total of $106,884 in under reported taxes. The taxes were collected in full and MuniServices was paid twenty-five (25) percent of the revenue collected, totaling $26,721, for their services.
On January 14, 2020, under Resolution 2020-008, the City Council approved the Finance Department enter a new two (2) year agreement with three (3) one (1) year extensions with MuniServices LLC. On August 21, 2021, the City Finance Department contacted MuniServices to conduct Transient Occupancy Tax Audits and conduct a comprehensive review of all local lodging providers to ensure compliance with the City’s Transient Occupancy Tax Ordinance and State #15..
- 695 -
City Council, February 14, 2023
Transient Occupancy Tax Audit
Law. Phase I consisted of MuniServices analyzing the reported revenue and tax of the nineteen (19) operational hotels and they select seven (7) lodging businesses to be audited. In October 2021, Phase II was initiated to validate the tax reported for the period January 1, 2018, through December 31, 2020.
DISCUSSION:
As part of Phase I, the Finance Department’s staff provided MuniServices a listing of the nineteen (19) local lodging providers and their business license tax filing records from the January 1, 2018, through December 31, 2020 period. MuniServices analyzed the nineteen (19) lodging providers.
On October 21, 2021, as part of Phase II, MuniServices selected seven (7) hotels at six (6) locations to be audited to ensure compliance with the requirements of the collection of the TOT.
The City sent out compliance review letters introducing MuniServices as the contracted auditors to each of the hotels. The letters asked the businesses for their cooperation with the tax consultants to ensure a complete and accurate audit.
MuniServices worked directly with each selected hotel to examine relevant records and complete their audit review. Once the assessment was complete, MuniServices provided the City with a finalized accounting of deficiency. The Municipal Code requires TOT to be collected on any fees charged for the privilege of occupying a hotel room. However, the audit determined that some hotels were not collecting TOT on certain required fees, causing a deficiency in taxable rents:
Below is a breakdown of the under reported Transient Occupancy Tax by finding type.
Findings # of Hotels Tax Under
Reported
Roll-away Bed Fees 3 $34
Pet Fees 4 $7,163
Early Check-ins 1 $1,593
Late Check-out/Cancellation Fees 4 $6,023
No Show Fees 2 $4,329
Room Upgrade Fees 1 $2
Under Reported Gross Receipts 3 $8,158
Disallowed Deductions 3 $2,156
Total $29,458
These audit findings were reviewed by the Revenue Collection and Compliance Manager and City staff. The Finance Department sent a letter of good standing to one (1) hotel that did not have any findings. The Finance Department also sent deficiency determination notifications to six (6) hotel locations, identifying each deficiency and the tax due. The deficiency determination letters sent to the local lodging providers informed the businesses of their opportunity to dispute the findings and as part of the City’s dispute process, and the need for the business to submit supporting documentation to the City if the auditor’s findings were disputed. Modesto Municipal Code section 8-2.610 provides the local lodging providers with a right to appeal the determination by hearing with the City’s Tax Administrator. None of the six (6) hotel locations exercised their right to an appeal. All TOT taxes related to the deficiency determination have been paid by the hotels.
#15..
- 696 -
City Council, February 14, 2023
Transient Occupancy Tax Audit
As part of this audit, the City of Modesto’s Finance Department partnered with the Convention Visitors Bureau to compare the taxability of hotel fees to other jurisdictions and worked with the City Attorney’s Office to identify which fees are taxable in accordance with the City’s Municipal Code. The Finance Department compiled a list of hotel fees subject to TOT which are currently posted to the City’s website. Email and mail communication containing the web address of the taxable hotel fees posted online were sent to all hotels to avoid or reduce future audit findings. In addition, the Monthly Transient Occupancy Tax Reporting form also provides a link the City’s web address where the taxable hotel fees are posted. Based on the results of this review, Cancellation Fees, No-Show Fees, Attrition Fees, and Forfeited Deposits will no longer be taxable beginning January 1, 2023.
FISCAL IMPACT:
Based on MuniServices final audit report and findings, the amount of under reported taxes determined due to the City was $29,458. The contracted payment for services rendered to MuniServices was $700 per hotel for Phase I (for a total of $13,300) and $1,000 per hotel for Phase II (for a total of $7,000), for a grand total of $20,300.
COMMITTEE RECOMMENDATION:
This item was presented at the January 23, 2023 Audit Committee and approved to move forward to Council.
RECOMMENDED COUNCIL ACTION:
Staff Recommendations:
Motion accepting the informational update on the Transient Occupancy Tax Audit. #15..
- 697 -
Approved by:
DeAnna Christensen, Director of Finance
Joseph P. Lopez, City Manager
#15..
- 698 -
CITY OF MODESTO
COUNCIL AGENDA REPORT
DATE OF MEETING:
February 14, 2023
Date: January 17, 2023
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
SUBJECT: Purchase of one Fleet Replacement and Updated Pricing for Three Bid Events CONTACT: Dianne Love, Senior Buyer, [email protected], 209-571-5614 DESCRIPTION:
Consider approving the purchase for one (1) Fleet Replacement in the amount not to exceed $53,148; and approving updated pricing for three (3) bid events for Fleet Replacement Vehicles by $110,217. (Funding Source: Fleet Replacement Fund)
STRATEGIC PLAN ELEMENT:
This item advances the City of Modesto 2020-2025 Strategic Plan Area: Governance and Service Delivery: “build community trust in City government through responsive, transparent and efficient service delivery”; Goal J: “build a high-performance organization”.
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.
Fleet Replacements:
RFB Vehicle
#
Description Dept. Year of
Vehicle
Meter Repair
Cost
2223-36 32137 Patrol Vehicle Police Dept 2021 26,008 $15,785 This vehicle is used by the Police Department for patrol services and needs to be replaced because the patrol car was totaled in a rollover crash.
IFB Vehicle
#
Description Dept. Year of
Vehicle
Meter Repair
Cost
2122-36 40320 Low-Profile
Dump Truck
UTL – Water
Construction
2003 83,099 $45,306
#16..
- 699 -
City Council, February 14, 2023
Purchase of one Fleet Replacement and Updated Pricing for Three Bid Events
This vehicle is used to support utility operations for the Utilities Water Construction Division.
RFB Vehicle
#
Description Dept. Year of
Vehicle
Meter Repair
Cost
40208 One-Ton Stake
Side Dump Truck
PRN-Ops 2002 127,991 $60,747
40210 One-Ton Stake
Side Dump Truck
PRN-Ops 2002 129,165 $37,633
40214 One-Ton Stake
Side Dump Truck
PRN-Ops 2002 126,664 $37,063
40215 One-Ton Stake
Side Dump Truck
PRN-Ops 2002 124,328 $28,744
40216 One-Ton Stake
Side Dump Truck
PRN-Ops 2002 98,252 $29,060
40219 One-Ton Stake
Side Dump Truck
PRN-Ops 2002 81,762 $22,439
RFB 1819-
49RB2
40220 One-Ton Stake
Side Dump Truck
PRN-Ops 2002 123,850 $45,083
These vehicles are all used by the Parks Division in their normal duties maintaining the various parks around the City of Modesto.
RFB Vehicle # Description Dept. Year of
Vehicle
Meter Repair
Cost
40710 One-Ton Truck UTL - Water 2007 131,041 $25,719
40873 One-Ton Truck UTL – Water 2008 163,119 $57,124
41175 One-Ton Truck UTL – Water 2011 178,790 $30,752
40828 One-Ton Truck UTL – Water 2008 97,666 $57,874
40207 One-Ton Truck PRN-Ops 2002 99,490 $32,096
RFB
2122-50
40484 One-Ton Truck UTL-Stormwater 2004 90,211 $26,314
These vehicles are used by various Divisions to carry out their normal service to the community hauling parts and supplies to make repairs to infrastructure around the City of Modesto.
Updating pricing for the three bid events:
RFB 2122-36 - One (1) Low-Profile Dump Truck
On November 29, 2021, the Purchasing Division issued Request for Bids (RFB) 2122-36 for one (1) Low-Profile Dump Truck. Twenty-four (24) companies chose to download the RFB document. On January 4, 2022, bids were formally opened by the City Clerk and broadcast via Microsoft Teams Livestream. One (1) vendor chose to respond, there were no local bids received. Based on providing the only lowest responsive and responsible bid, City staff recommended on February 8, 2022, under Resolution 2022-083 to award the bid to Towne Ford Sales, Redwood City, CA for a total cost not to exceed $99,797.
RFB 1819-49RB2 – Seven (7) One-Ton Stake Side Dump Trucks On June 10, 2022, the Purchasing Division issued RFB 1819-049RB2 for seven (7) One-Ton Side Dump Trucks. Eighteen (18) companies downloaded the RFB document. On July 19, 2022, bids were formally opened in the City Clerk’s office and broadcast via Microsoft Teams Livestream. Two (2) vendors chose to respond, there was no local bid received. Based on providing the lowest responsive and responsible bid, City staff recommended on August 23, 2022, under Resolution 2022-355 to award the seven (7) One-Ton Stake Side Dump Trucks to Towne Ford Sales, Redwood City, CA, for a total cost not to exceed $602,868. #16..
- 700 -
City Council, February 14, 2023
Purchase of one Fleet Replacement and Updated Pricing for Three Bid Events
RFB 2122-50 – Six (6) One-Ton Trucks
On June 10, 2022, the Purchasing Division issued RFB 2122-50 for six (6) One-Ton Trucks.
Fourteen (14) companies downloaded the RFB document. On July 19, 2022, bids were formally opened in the City Clerk’s office and broadcast via Microsoft Teams Livestream. One (1) vendor chose to respond, there was no local bid received. Based on providing the only responsive and responsible bid, City staff recommended on August 23, 2022, under Resolution 2022-354 to award the six (6) One-Ton Trucks to Towne Ford Sales, Redwood City, CA, for a total cost not to exceed $536,924.
DISCUSSION:
The Police Department currently has a need for a new Ford Mustang vehicle to replace a fleet vehicle of the same make and model that is no longer in operation due to damage received in for a rollover car accident. Towne Ford Sales notified City staff about a 2023 Ford Mustang available in the dealership lot to purchase immediately. The City’s Fleet Manager was contacted about the availability of this vehicle. Towne Ford had known about the need for the City, via a previous request made months ago from the Fleet Manager concerning the replacement of the damaged vehicle in the Police Department at the department’s request. Towne Ford contacted the Fleet Manager to let him know of the availability of the 2023 Ford Mustang due to a cancellation of a purchase by another agency. Towne Ford offered the vehicle to the City for the same purchase price that was quoted to the cancelling agency.
With the significant lead times ranging from 9-12 months and the inflation increases occurring there is a critical need to obtain new vehicles to address over 214 Fleet replacements needed for the City. City staff will continue to complete formal bidding events or utilize a cooperative agreement, but in this situation, there is a cost savings with taking advantage of purchasing this vehicle now. With the delay of these vehicles being available for use, the increases of new vehicles continue to increase due to the current inflation changes. Further price comparisons were reviewed to evaluate pricing and a similar type of vehicle was identified that was about $500 less. The concern with the comparable vehicle is that it would not be available and would need to be placed for ordering. The lead time could take 9-12 months and based on the current market, the price would increase at time of delivery based on current estimated inflation increases ranging from 7-9%. City staff recommends to award to Towne Ford Sales to purchase one (1) Ford Mustang for an amount not to exceed $53,148.
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.” This vehicle purchase falls under this exception due to the increase in cost due to inflation that will occur due to the significant lead times occurring for the purchase of new vehicles.
#16..
- 701 -
City Council, February 14, 2023
Purchase of one Fleet Replacement and Updated Pricing for Three Bid Events
Updating pricing for the three bid events:
RFB 2122-36 - One (1) Low-Profile Dump Truck
On February 28, 2022, the Purchasing Division issued Purchase Order (PO) 219280 to Towne Ford Sales, Redwood City, CA in the amount of $99,797. Once the PO was issued, the vendor informed he City about significant manufacturing delays related to the current COVID-19 pandemic. After further follow-up with Towne Sales, it was determined that they could no longer hold the bid price because of continued global inflation increases from manufacturers, steel surcharges, semiconductor chip shortage. Based on this issue, the vendor is requesting to increase the original bid amount by $16,552 for the Low-Profile Dump Truck which is a 17% increase from the original bid. When the original bid was issued, there was only one bid response received. With the current inflation ranging from 8-10% and the steel prices ranging from 15-25% this bid increase seems very reasonable with the current vehicle market. If a new bid is issued, it will further delay this purchase and continue to trigger these price increases including the cost for repair for the current vehicle in-service. City staff recommends increasing the Purchase Order amount for the one (1) Low-Profile Dump Truck in the amount of $16,552 to a revised Purchase Order amount not to exceed $116,349.
RFB 1819-49RB2 – Seven (7) One-Ton Stake Side Dump Trucks On August 29, 2022, the Purchasing Division issued Purchase Order (PO)231187 to Towne Ford Sales, Redwood City, CA in the amount of $602,868. Once the PO was issued, the vendor informed he City about significant manufacturing delays related to the current COVID-19 pandemic. After further follow-up with Towne Sales, it was determined that they could no longer hold the bid price because of continued global inflation increases from manufacturers, steel surcharges, semiconductor chip shortage. Based on this issue, the vendor is requesting to increase the original bid amount by $64,194 for the seven (7) One-Ton Stake Side Dump Trucks which is a 11% increase from the original bid. When the original bid was issued, there was two bid responses received and with this proposed increase Towne Ford Sales is still the lowest bidder. With the current inflation ranging from 8-10% and the steel prices ranging from 15-25% this bid increase seems very reasonable with the current vehicle market. If a new bid is issued, it will further delay this purchase and continue to trigger these price increases including the cost for repair for the current vehicle in-service. City staff recommends increasing the Purchase Order amount for the seven (7) One-Ton Stake Side Dump Trucks in the amount of $64,194 to a revised Purchase Order amount not to exceed $667,062.
RFB 2122-50 – Six (6) One-Ton Trucks
On August 29, 2022, the Purchasing Division issued Purchase Order (PO)231525 to Towne Ford Sales, Redwood City, CA in the amount of $536,924. The vendor was able to fulfill three of the six trucks submitted on this order, but the vendor informed the City that the remaining three trucks would require a price increase. Based on our five-year average Super Duty purchase history our anticipated allocation Towne Ford Sales could only fulfill 3 units which these orders have been ordered in the order inventory available. After further follow-up with Towne Sales, it was determined they could no longer hold the bid price for the remaining three trucks because of continued global inflation increases from manufacturers, steel surcharges, semiconductor chip shortage. Based on this issue, the vendor is requesting to increase the original bid amount for the remaining three trucks by $29,471 which is a 13.4% increase from the original bid. With the current inflation ranging from 8-10% and the steel prices ranging from 15-25% this bid increase seems very reasonable with the current vehicle market. If a new bid is issued, it will further delay this purchase and continue to trigger these price increases including the cost for #16..
- 702 -
City Council, February 14, 2023
Purchase of one Fleet Replacement and Updated Pricing for Three Bid Events
repair for the current vehicle in-service. City staff recommends increasing the Purchase Order amount for the remaining three (3) One-Ton Trucks in the amount of $29,471 to a revised Purchase Order amount not to exceed $566,395.
FISCAL IMPACT:
Sufficient funds are budgeted in the Fiscal Year 2022-23 Fleet Replacement Fund for the purchase of the 2023 Ford Mustang. The updated bid pricing for the one (1) Low-Profile Dump Truck, seven (7) One-Ton Stake Dump Trucks and three (3) of the six (6) One-Ton Trucks in the amount of $110,265 is budgeted in the Fiscal Year 22-23 Fleet Replacement Fund. Below is summary to outline the change in pricing for each bid event.
RFB No. Original Account Revised Amount Increase
2122-36 $ 99,797 $ 116,349 $ 16,552
1819-49RB2 $ 602,868 $ 667,062 $ 64,194
2122-50 $ 536,924 $ 566,395 $ 29,471
TOTAL $ 1,239,589 $ 1,349,806 $ 110,217
COMMITTEE RECOMMENDATION:
This item was not presented at a Committee meeting due to the time constraints with the City holding the current quote pricing.
RECOMMENDED COUNCIL ACTION:
Staff Recommendations:
Resolution approving the purchase with Towne Ford Sales, Redwood City, CA for one (1) Ford Mustang for an amount not to exceed $53,148; and authorizing the Purchasing Manager, or her designee, to issue the Purchase Order.
Resolution approving an increase to the amount for the purchase of One (1) Low-Profile Dump Truck to Towne Ford Sales, Redwood City, CA by $16,552, increasing the Purchase Order from $99,797 to a new total amount not to exceed $116,349, and authorizing the Purchasing Manager, or her designee, to update the Purchase Order.
Resolution approving an increase to the amount for the purchase of Seven (7) One-Ton Stake Side Dump Trucks to Towne Ford Sales, Redwood City, CA by $64,194, increasing the Purchase Order from $602,868 to a new total amount not to exceed $667,062, and authorizing the Purchasing Manager, or her designee, to update the Purchase Order.
Resolution approving an increase to the amount for the purchase of six (6) One-Ton Trucks to Towne Ford Sales, Redwood City by $29,471, increasing the Purchase Order from $536,924 to a new total amount not to exceed $566,395, and authorizing the Purchasing Manager, or her designee, to update the Purchase Order.
Approved by:
DeAnna Christensen, Director of Finance
Joseph P. Lopez, City Manager
#16..
- 703 -
City Council, February 14, 2023
Purchase of one Fleet Replacement and Updated Pricing for Three Bid Events
Attachments:
1. Resolution (4)
2. Quote – One Ford Mustang
3 Revised Quote – One Low Profile Dump Truck
4. Revised Quote – Seven One-Ton Stake
5. Revised Quote – Six (6) One-Ton Trucks
#16..
- 704 -
1 Meeting Date/Dept/Contact/Item # 2023-xxx
MODESTO CITY COUNCIL
RESOLUTION NO. 2023-XX
RESOLUTION APPROVING THE PURCHASE WITH TOWNE FORD SALES, REDWOOD CITY, CA FOR ONE (1) FORD MUSTANG FOR AN AMOUNT NOT TO EXCEED $53,148; 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, Vehicle #32137 which is utilized to the Modesto Police Department Patroll needs to be replaced due to the vehicle being totaled in a rollover crash; and WHEREAS, the Police Department currently has a need for a new Ford Mustang vehicle to replace a fleet vehicle of the same make and model that is no longer in operation due to damage received in for a rollover car accident; and WHEREAS, Towne Ford had known about the need for the City, via a previous request made months ago from the Fleet Manager concerning the replacement of the damaged vehicle in the Police Department at the department’s request; and WHEREAS, Towne Ford contacted the Fleet Manager to let him know of the availability of the 2023 Ford Mustang due to a cancellation of a purchase by another agency and offered the vehicle to the City for the same purchase price that was quoted to the cancelling agency; and
WHEREAS, with the significant lead times ranging from 9-12 months and the inflation increases occurring there is a critical need to obtain new vehicles to address over 214 Fleet replacements needed for the City; and
WHEREAS, further price comparisons were reviewed to evaluate pricing and a similar type of vehicle was identified that was about $500 less; and #16..
- 705 -
2 Meeting Date/Dept/Contact/Item # 2023-xxx
WHEREAS, the concern with the comparable vehicle is that it would not be available and would need to be placed for ordering which will create lead times of 9-12 months and based on the current market, the price would increase at time of delivery based on current estimated inflation increases ranging from 7-9%; and WHEREAS, 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.” NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves the purchase with Towne Ford Sales, Redwood City, CA for one (1) Ford Mustang for an amount not to exceed $53,148.
BE IT FURTHER RESOLVED, that the Purchasing Manager, or her designee, is hereby authorized to issue the Purchase Order.
The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 14th day of February 2023, 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:
#16..
- 706 -
3 Meeting Date/Dept/Contact/Item # 2023-xxx
ATTEST: _____________________________
DIANE NAYARES-PEREZ, CMC, City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: _______________________________________
JOSE M. SANCHEZ, City Attorney
#16..
- 707 -
1 Meeting Date/Dept/Contact/Item # 2023-xxx
MODESTO CITY COUNCIL
RESOLUTION NO. 2023-XX
RESOLUTION APPROVING AN INCREASE TO THE AMOUNT FOR THE
PURCHASE OF ONE (1) LOW-PROFILE DUMP TRUCK TO TOWNE FORD SALES, REDWOOD CITY, CA BY $16,552, INCREASING THE PURCHASE ORDER FROM $99,797 TO A NEW TOTAL AMOUNT NOT TO EXCEED
$116,349, AND AUTHORIZING THE PURCHASING MANAGER, OR HER
DESIGNEE, TO UPDATE THE PURCHASE ORDER
WHEREAS, on February 8, 2022 under Resolution 2022-083 Council approved the award to bid to Towne Ford Sales, Redwood City, CA for a total cost not to exceed $99,797; and
WHEREAS, on February 28, 2022, the Purchasing Division issued Purchase Order (PO) 219280 to Towne Ford Sales, Redwood City, CA in the amount of $99,797; and
WHEREAS, it was determined that they could no longer hold the bid price because of continued global inflation increases from manufacturers, steel surcharges, semiconductor chip shortage; and
WHEREAS, the vendor is requesting to increase the original bid amount by $16,552 for the one (1) Low-Profile Dump Truck.
NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves an increase to the amount for the purchase of One (1) Low-Profile Dump Truck to Towne Ford Sales, Redwood City, CA by $16,552, increasing the Purchase Order from $99,797 to a new total amount not to exceed $116,349.
BE IT FURTHER RESOLVED, that the Purchasing Manager, or her designee, is hereby authorized to update the Purchase Order.
The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 14th day of February 2023, by Councilmember #16..
- 708 -
2 Meeting Date/Dept/Contact/Item # 2023-xxx
________, 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: _____________________________
DIANE NAYARES-PEREZ, CMC, City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: _______________________________________
JOSE M. SANCHEZ, City Attorney
#16..
- 709 -
1 Meeting Date/Dept/Contact/Item # 2023-xxx
MODESTO CITY COUNCIL
RESOLUTION NO. 2023-XX
RESOLUTION APPROVING AN INCREASE TO THE AMOUNT FOR THE
PURCHASE OF SEVEN (7) ONE-TON STAKE SIDE DUMP TRUCKS TO TOWNE FORD SALES, REDWOOD CITY, CA BY $64,194, INCREASING THE PURCHASE ORDER FROM $602,868 TO A NEW TOTAL AMOUNT NOT TO EXCEED $667,062, AND AUTHORIZING THE PURCHASING MANAGER, OR
HER DESIGNEE, TO UPDATE THE PURCHASE ORDER
WHEREAS, on August 23, 2022 under Resolution 2022-355 Council approved to award the seven (7) One-Ton Stake Side Dump Trucks to Towne Ford Sales, Redwood City, CA, for a total cost not to exceed $602,868; and
WHEREAS, on August 29, 2022, the Purchasing Division issued Purchase Order (PO)231187 to Towne Ford Sales, Redwood City, CA in the amount of $602,868; and WHEREAS, it was determined that they could no longer hold the bid price because of continued global inflation increases from manufacturers, steel surcharges, semiconductor chip shortage; and
WHEREAS, the vendor is requesting to increase the original bid amount by $64,194 for the seven (7) One-Ton Stake Side Dump Trucks; and WHEREAS, when the original bid was issued, there was two bid responses received and with this proposed increase Towne Ford Sales is still the lowest bidder.
NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves an increase to the amount for the purchase of Seven (7) One-Ton Stake Side Dump Trucks to Towne Ford Sales, Redwood City, CA by $64,194, increasing the Purchase Order from $602,868 to a new total amount not to exceed $667,062.
BE IT FURTHER RESOLVED, that the Purchasing Manager, or her designee, is hereby authorized to update the Purchase Order.
#16..
- 710 -
2 Meeting Date/Dept/Contact/Item # 2023-xxx
The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 14th day of February 2023, 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: _____________________________
DIANE NAYARES-PEREZ, CMC, City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: _______________________________________
JOSE M. SANCHEZ, City Attorney
#16..
- 711 -
1 Meeting Date/Dept/Contact/Item # 2023-xxx
MODESTO CITY COUNCIL
RESOLUTION NO. 2023-XX
RESOLUTION APPROVING AN INCREASE TO THE AMOUNT FOR THE
PURCHASE OF SIX (6) ONE-TON TRUCKS TO TOWNE FORD SALES, REDWOOD CITY BY $29,471, INCREASING THE PURCHASE ORDER FROM $536,924 TO A NEW TOTAL AMOUNT NOT TO EXCEED $566,395, AND
AUTHORIZING THE PURCHASING MANAGER, OR HER DESIGNEE, TO
UPDATE THE PURCHASE ORDER
WHEREAS, on August 23, 2022 under Resolution 2022-354 Council approved to award the six (6) One-Ton Trucks to Towne Ford Sales, Redwood City, CA, for a total cost not to exceed $536,924; and
WHEREAS, on August 29, 2022, the Purchasing Division issued Purchase Order (PO)231525 to Towne Ford Sales, Redwood City, CA in the amount of $536,924; and WHEREAS, the vendor was able to fulfill three of the six trucks submitted on this order but the vendor informed the City that the remaining three trucks would require a price increase; and
WHEREAS, based on our five-year average Super Duty purchase history our anticipated allocation Towne Ford Sales could only fulfill 3 units which these orders have been ordered in the order inventory available; and
WHEREAS, it was determined that they could no longer hold the bid price for the remaining three trucks because of continued global inflation increases from manufacturers, steel surcharges, semiconductor chip shortage; and WHEREAS, the vendor is requesting to increase the original bid amount by $29,471 for the six (6) One-Ton Trucks.
NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves an increase to the amount for the purchase of six (6) One-Ton #16..
- 712 -
2 Meeting Date/Dept/Contact/Item # 2023-xxx
Trucks to Towne Ford Sales, Redwood City by $29,471, increasing the Purchase Order from $536,924 to a new total amount not to exceed $566,395.
BE IT FURTHER RESOLVED, that the Purchasing Manager, or her designee, is hereby authorized to update the Purchase Order.
The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 14th day of February 2023, 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: _____________________________
DIANE NAYARES-PEREZ, CMC, City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: _______________________________________
JOSE M. SANCHEZ, City Attorney
#16..
- 713 -
#16..
- 714 -
#16..
- 715 -
#16..
- 716 -
#16..
- 717 -
#16..
- 718 -
#16..
- 719 -
CITY OF MODESTO
COUNCIL AGENDA REPORT
DATE OF MEETING:
February 14, 2023
Date: January 25, 2023
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
SUBJECT: Monthly Investment Report – November 2022
CONTACT: Calogero Maniscalco, Senior Financial Analyst
[email protected], (209) 577-5219
DESCRIPTION:
Consider accepting the Monthly Investment Report for November 2022. (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, 2022 the City had a closing market value of $426,166,070 in its investment portfolio. #17..
- 720 -
City Council, February 14, 2023
Monthly Investment Report – November 2022
FISCAL IMPACT:
In November, the approximate yield of the City’s combined investments was 2.18% (see attachment 3) on a weighted average. For the portfolio of securities alone, the yield to maturity on cost was 1.78%. For comparative purposes, the yields (as of November 30, 2022) of other investments commonly used by public agencies are listed below:
Local Agency Investment Fund: 2.01%
1-Year U.S. Treasury Note: 4.80%
2-Year U.S. Treasury Note: 4.39%
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 2022.
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
#17..
- 721 -
PORTFOLIO HOLDINGS
Attachment 1
Percentages may not total to 100% due to rounding.
Investment Type No. of Investments Amount Invested
CAMP 1 46,648,407
Federal Agency 31 66,149,816
Federal Home Loan Bank 2 4,165,689
Federal Home Loan Mortgage Co. 9 18,879,975
Federal Nat’l Mortgage Assc. 19 40,844,352
Federal Farm Credit Bank 1 2,259,799
Federal Agency CMO 1 745,394
U.S. Treasury 59 208,586,209
Commercial Paper 4 40,143,576
Negotiable CD 3 7,912,745
Corporate Note 18 38,279,606
Asset-Backed 11 5,111,867
Municipal 10 7,065,476
Supranational 2 5,522,974
Total Invested 140 426,166,070
Sector Allocation
November 30, 2022 versus October 31, 2022
Sector November 30, 2022 October 31, 2022 Change in Allocation Permitted by Policy
U.S. Treasury 48.9% 51.0% -2.08% 100%
Federal Agency 15.5% 15.6% -0.05% 100%
Federal Agency CMO 0.2% 0.2% -0.03% 100%
Commercial Paper 9.4% 7.1% 2.32% 25%
Negotiable CD 1.9% 1.9% -0.01% 30%
Corporate Note 9.0% 9.0% 0.00% 30%
Asset-Backed 1.2% 1.3% -0.07% 20%
Municipal 1.7% 1.7% -0.01% 100%
Supranational 1.3% 1.3% -0.01% 30%
CAMP 10.9% 11.0% -0.07% 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
Throughout the month, recession probabilities remain elevated at 60% while the labor market added 263,000 jobs in November. We currently see 1.7 jobs open for every unemployed person, emphasizing the strength in the labor market despite Federal Reserve action. Treasury yields across the curve fell over the month as expectations for the December 14th FOMC meeting transition from a 75 basis point (0.75%) hike, to 50 basis points (0.50%). Expectations are for Federal Reserve Chair Powell to remain hawkish and reiterate the need for continued Fed action at the December 14th meeting. In the Long-Term Portfolio, we purchased two longer duration Treasuries replacing two short duration Treasuries sold. In the Short-Term Portfolio we purchased a 3-month Commercial paper security replacing a Treasury that matured. #17..
- 722 -
PERFORMANCE
Interest rates fell across the curve, resulting in positive total return performance for the Long-Term Portfolio and the benchmark. Over the past month, we slightly underperformed the benchmark due to our defense duration positioning. Since inception, the portfolio continues to outperform relative to the benchmark. As interest rates remain at elevated levels, the portfolio yield at cost has steadily increased over the past month.
Income earnings potential has continued to gravitate higher due to the elevated interest rate environment.
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.
Long-Term Portfolio Total Return
November 30, 2022
1 Month Trailing
12 Months
Trailing 36
Months
Trailing 60
Months
Since
Inception5
City of Modesto Investment Portfolio1,2,3 1.04% -4.95% -0.41% 0.99% 1.92% Modesto Performance Benchmark41.08% -5.57% -0.75% 0.62% 1.63% Average Portfolio Yields
November 30, 2022
Past
Month
Past 3
Months
Past
Year
Past 3
Years
Past 5
Years
City of Modesto Investment Portfolio 1.78% 1.74% 1.55% 1.53% 1.97% City of Modesto Short-Term Portfolio 3.76% 3.48% - - -
$91.4
$57.2
$62.9
$101.1
$84.0
$29.5
$-
$30.0
$60.0
$90.0
$120.0
$150.0
Under 6
Months
6-12
Months
1-2 Years 2-3 Years 3-4 Years 4-5 Years
Millions
Maturity Distribution
November 30, 2022
#17..
- 723 -
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.
Monthly Income Return
0.11%
Fiscal Year-to-Date Income Return
0.52%
Prior 12 Months Income Return
1.25%
LONG TERM PORTFOLIO INCOME RETURN #17..
- 724 -
7.1%
6.0%
0%
2%
4%
6%
8%
10%
2016 2017 2018 2019 2020 2021 2022
Consumer Price Index (YOY)
CPI Core CPI
Source: Bloomberg, Bureau of Labor Statistics as of November 2022.
Economic Summary
Continued Inflation Deceleration Is Welcome News, But Still Remains Much Too High
A second softer-thanexpected Core CPI
reading could give the Fed
justification to slow the
pace of rate hikes.
-4%
-2%
0%
2%
4%
6%
8%
10%
12%
14%
Nov-16 Nov-17 Nov-18 Nov-19 Nov-20 Nov-21 Nov-22
Producer Price Index
% Change YoY
November ’22
7.4%
#17..
- 725 -
Source: Bloomberg, as of December 2022.
Economic Summary
Recession Probabilities Remain Elevated While Consumer
Sentiment Improves from June Lows
60%
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22 U.S. 1-Year Recession Probability
50 60
70 80
90 100
110
120
2012 2014 2016 2018 2020 2022
Index Value (1996=100)
Consumer Sentiment Index
#17..
- 726 -
Source: ICE BofAML 1-5 year Indices via Bloomberg, MarketAxess and PFM as of 11/30/2022. 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 Spreads Experience Elevated levels of Volatility Over the Month
-0.05%
0.00%
0.05%
0.10%
0.15%
0.20%
0.25%
0.30%
0.35%
Nov-21 Feb-22 May-22 Aug-22 Nov-22
Federal Agency Yield Spreads
0.30%
0.40%
0.50%
0.60%
0.70%
0.80%
0.90%
1.00%
1.10%
Nov-21 Feb-22 May-22 Aug-22 Nov-22
Corporate Notes A-AAA Yield Spreads
0.20%
0.30%
0.40%
0.50%
0.60%
0.70%
0.80%
0.90%
1.00%
1.10%
1.20%
Nov-21 Feb-22 May-22 Aug-22 Nov-22
Asset-Backed Securities AAA Yield Spreads
#17..
- 727 -
Treasury Yield Volatility Continues
Source: Bloomberg as of 11/30/2022.
Economic Summary
4.65%
4.69%
4.05%
3.61%
3.74%
2.50%
2.75%
3.00%
3.25%
3.50%
3.75%
4.00%
4.25%
4.50%
4.75%
5.00%
3M1Y 2Y 3Y 4Y 5Y 10Y 30Y
U.S. Treasury Yield Curve
November 30, 2022
October 31, 2022
September 30, 2022
#17..
- 728 -
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
#17..
- 729 -
For the Month Ending November 30, 2022
Account Statement
Consolidated Summary Statement
CITY OF MODESTO
Investment Allocation
Investment Type Closing Market Value Percent
Asset-Backed Security 5,111,867.25 1.20
Federal Agency Bond / Note 66,149,815.58 15.52
Corporate Note 38,279,605.97 8.98
Certificate of Deposit 7,912,744.75 1.86
Federal Agency Commercial Mortgage-Backed Security 745,394.31 0.17 Commercial Paper 40,143,575.96 9.42
Municipal Bond / Note 7,065,476.00 1.66
Supra-National Agency Bond / Note 5,522,974.36 1.30
U.S. Treasury Bond / Note 208,586,209.48 48.94
CAMP Pool 46,648,406.54 10.95
Total $426,166,070.20 100.00%
Portfolio Summary
and Income
Closing
Portfolio Holdings Market Value
Cash Dividends
PFMAM Managed Account 637,211.78 379,517,663.66
CAMP Pool 0.00 46,648,406.54
Total $637,211.78 $426,166,070.20
Maturity Distribution (Fixed Income Holdings)
Portfolio Holdings Closing Market Value Percent
56,714,876.66
20,014,018.74
12,795,755.57
1,825,528.20
60,415,781.74
59,748,656.54
101,119,586.63
84,005,680.52
29,526,185.60
0.00 13.30
4.70 3.00
0.43 14.18
14.02 23.73
19.71 6.93
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 $426,166,070.20
693
100.00%
Weighted Average Days to Maturity
Sector Allocation
1.20% ABS
15.52%
Fed Agy Bond /
Note
8.98%
Corporate Note
1.86%
Cert of Deposit
0.17%
Federal Agency
Commercial
Mortgage-Backed
Security
9.42%
Commercial Paper
1.66%
Muni Bond / Note
1.30%
Supra-National
Agency Bond / Note 48.94%
US TSY Bond / Note
10.95%
CAMP Pool
Summary Page 1
#17..
- 730 -
For the Month Ending November 30, 2022
Account Statement
Consolidated Summary Statement
CITY OF MODESTO
and Income
Closing Market
Value
Change in
Account Name Value Deposits Maturities Trades Value
Account
Number
Opening Market Purchases / Redemptions / Sales/ Unsettled Cash Dividends 57710050 CITY OF MODESTO 335,814,853.83 6,199,877.35 (5,770,140.34) 0.00 3,129,496.86 339,374,087.70 534,499.28 57710062 CITY OF MODESTO SHORT-TERM 39,929,806.47 10,037,202.00 (9,960,000.00) 0.00 136,567.49 40,143,575.96 102,712.50 Total $375,744,660.30 $16,237,079.35 ($15,730,140.34) $0.00 $3,266,064.35 $379,517,663.66 $637,211.78 Summary Page 2
#17..
- 731 -
Managed Account Summary Statement For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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)
$335,814,853.83
(404,847.37)
(5,365,292.97)
6,199,877.35
0.00 3,129,496.86
$339,374,087.70
443,190.27
(24,541.76)
115,850.77
$534,499.28
Total
357,994,150.30
1,006,101.09
5,383,040.93
404,847.37
425,442.31
(6,224,419.11)
(357,511,536.00)
(1,050,298.08)
Total Accrual Basis Earnings $427,328.81
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 5,383,040.93
425,442.31
404,847.37
(6,224,419.11)
3,723.00
0.00 Cash Balance
Closing Cash Balance $7,831.02
Account 57710050 Page 1
#17..
- 732 -
Portfolio Summary and Statistics For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
Account Summary
Description Par Value Market Value Percent
U.S. Treasury Bond / Note 225,986,000.00 208,586,209.48 61.46 Supra-National Agency Bond / Note 5,885,000.00 5,522,974.36 1.63 Municipal Bond / Note 7,590,000.00 7,065,476.00 2.08
Federal Agency Commercial
Mortgage-Backed Security
757,331.41 745,394.31 0.22
Federal Agency Bond / Note 70,230,000.00 66,149,815.58 19.49 Corporate Note 40,100,000.00 38,279,605.97 11.28
Certificate of Deposit 7,955,000.00 7,912,744.75 2.33
Asset-Backed Security 5,346,356.12 5,111,867.25 1.51
Managed Account Sub-Total 363,849,687.53 339,374,087.70 100.00% Accrued Interest 1,006,101.09
Total Portfolio 363,849,687.53 340,380,188.79
Unsettled Trades 0.00 0.00
Sector Allocation
1.51%
ABS
2.33%
Cert of Deposit
11.28%
Corporate Note
19.49%
Fed Agy Bond /
Note
0.22%
Federal Agency
Commercial
Mortgage-Backed
Security
2.08%
Muni Bond / Note
1.63%
Supra-National
Agency Bond / Note
61.46%
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
1.34%
17.80% 17.61%
29.80%
24.75%
8.70%
0.00%
Maturity Distribution Characteristics
Yield to Maturity at Cost
Yield to Maturity at Market
Weighted Average Days to Maturity 865
1.78%
4.32%
Account 57710050 Page 2
#17..
- 733 -
Managed Account Issuer Summary For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
Credit Quality (S&P Ratings)
2.00%
A
4.06%
A+
2.17%
A0.81%
A-1
0.54%
A-2
3.24%
AA
81.42%
AA+
1.60%
AA3.92%
AAA
0.24%
NR
Issuer Summary
Issuer of Holdings Percent
Market Value
AMAZON.COM INC 4,821,352.50 1.42
BANK OF AMERICA CO 3,922,571.66 1.16
BARCLAYS PLC 2,732,668.47 0.81
BRISTOL-MYERS SQUIBB CO 2,007,885.31 0.59
CALIFORNIA DEPARTMENT OF WATER RESOURCES 92,281.00 0.03 CALIFORNIA STATE UNIVERSITY 553,398.00 0.16
CARMAX AUTO OWNER TRUST 1,331,123.73 0.39
CREDIT SUISSE GROUP RK 1,825,528.20 0.54
DISCOVER FINANCIAL SERVICES 712,429.21 0.21
FANNIE MAE 41,589,746.55 12.25
FEDERAL FARM CREDIT BANKS 2,259,799.12 0.67
FEDERAL HOME LOAN BANKS 4,165,688.88 1.23
FLORIDA STATE BOARD OF ADMIN FIN CORP 1,618,866.00 0.48 FREDDIE MAC 18,879,975.34 5.56
HONDA AUTO RECEIVABLES 816,350.95 0.24
HYUNDAI AUTO RECEIVABLES 924,501.44 0.27
INTER-AMERICAN DEVELOPMENT BANK 3,808,616.18 1.12
INTL BANK OF RECONSTRUCTION AND DEV 1,714,358.18 0.51
JP MORGAN CHASE & CO 3,452,146.18 1.02
LOS ANGELES COMMUNITY COLLEGE DISTRICT 838,938.00 0.25
MASTERCARD INC 1,675,095.84 0.49
MICROSOFT CORP 2,815,998.00 0.83
NEW JERSEY TURNPIKE AUTHORITY 454,813.10 0.13
NOVARTIS AG 2,163,951.53 0.64
PACCAR FINANCIAL CORP 1,709,320.56 0.50
PFIZER INC 3,380,296.01 1.00
STATE OF CALIFORNIA 2,265,786.60 0.67
STATE OF MARYLAND 583,159.60 0.17
TARGET CORP 334,130.86 0.10
THE BANK OF NEW YORK MELLON CORPORATION 3,088,292.13 0.91 TORONTO-DOMINION BANK 3,354,548.08 0.99
TOYOTA MOTOR CORP 3,531,248.27 1.04
Account 57710050 Page 3
#17..
- 734 -
Managed Account Issuer Summary For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
Issuer of Holdings Percent
Market Value
UNITED STATES TREASURY 208,586,209.48 61.45
UNIVERSITY OF CALIFORNIA 658,233.70 0.19
US BANCORP 2,811,563.04 0.83
WAL-MART STORES INC 3,893,216.00 1.15
Total $339,374,087.70 100.00%
Account 57710050 Page 4
#17..
- 735 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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 08/01/2016 1.250% 07/31/2023
912828S92 3,280,000.00 AA+ Aaa 04/02/19 04/04/19 3,141,112.50 2.28 13,703.80 3,258,713.89 3,205,687.66
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,745,309.92 1,706,796.88
US TREASURY NOTES
DTD 09/15/2020 0.125% 09/15/2023
91282CAK7 4,395,000.00 AA+ Aaa 04/06/22 04/07/22 4,264,523.44 2.24 1,168.56 4,323,560.36 4,238,428.13
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,713,123.79 2,659,078.26
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,770.49 3,746,268.75
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,808,118.27 8,622,440.63
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,263,058.56 3,190,566.57
US TREASURY NOTES
DTD 12/15/2020 0.125% 12/15/2023
91282CBA8 4,430,000.00 AA+ Aaa 04/06/22 04/07/22 4,263,528.91 2.41 2,556.93 4,327,743.04 4,223,728.13
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,176.39 264,009.38
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 468,568.62 444,503.88
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,603,382.50 1,521,234.30
US TREASURY NOTES
DTD 03/15/2021 0.250% 03/15/2024
91282CBR1 4,450,000.00 AA+ Aaa 04/06/22 04/07/22 4,262,960.94 2.49 2,366.37 4,325,835.65 4,206,640.63
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,891,682.03 4,614,937.50
US TREASURY N/B NOTES
DTD 06/15/2021 0.250% 06/15/2024
91282CCG4 4,485,000.00 AA+ Aaa 04/06/22 04/07/22 4,262,852.34 2.59 5,177.36 4,328,941.27 4,197,679.69 Account 57710050 Page 5
#17..
- 736 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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,463,069.02 2,355,062.50
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,644,805.18 1,557,923.36
US TREASURY N/B NOTES
DTD 09/15/2021 0.375% 09/15/2024
91282CCX7 4,505,000.00 AA+ Aaa 04/06/22 04/07/22 4,264,440.04 2.65 3,593.42 4,328,625.32 4,191,761.94
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,870,276.57 1,775,711.03
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 465,778.20 442,031.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,224,996.74 1,163,552.28
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,482,609.67 3,303,913.89
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,732,012.30 4,390,853.68
US TREASURY N/B NOTES
DTD 12/15/2021 1.000% 12/15/2024
91282CDN8 4,445,000.00 AA+ Aaa 04/06/22 04/07/22 4,251,920.31 2.68 20,524.73 4,298,667.99 4,156,769.31
US TREASURY N/B NOTES
DTD 02/15/2022 1.500% 02/15/2025
91282CDZ1 4,400,000.00 AA+ Aaa 04/06/22 04/07/22 4,255,109.38 2.70 19,369.57 4,288,108.39 4,140,125.00
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,914,715.15 4,513,084.91
US TREASURY NOTES
DTD 07/02/2018 2.750% 06/30/2025
912828XZ8 4,230,000.00 AA+ Aaa 04/06/22 04/07/22 4,232,148.05 2.73 48,679.48 4,231,714.80 4,087,237.50
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,307,240.99 3,904,643.75
US TREASURY NOTES
DTD 08/31/2020 0.250% 08/31/2025
91282CAJ0 4,635,000.00 AA+ Aaa 04/06/22 04/07/22 4,262,932.62 2.74 2,944.89 4,334,230.56 4,170,051.56 Account 57710050 Page 6
#17..
- 737 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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 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,083,054.16 989,484.32
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,496,677.29 4,092,866.96
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,935,119.46 4,489,429.94
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,824,846.59 6,209,930.03
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.79 4,164,173.05 3,809,062.50
US TREASURY NOTES
DTD 11/30/2020 0.375% 11/30/2025
91282CAZ4 4,635,000.00 AA+ Aaa 04/06/22 04/07/22 4,254,785.16 2.75 47.75 4,322,670.48 4,154,118.75
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 499,128.17 447,578.10
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,037,509.01 930,962.45
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,677,325.65 3,343,408.41
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,368,024.79 2,139,750.00
US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 5,000,000.00 AA+ Aaa 02/17/22 02/18/22 4,719,531.25 1.85 6,266.98 4,775,119.65 4,457,812.50
US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 5,775,000.00 AA+ Aaa 01/04/22 01/06/22 5,570,167.97 1.27 7,238.37 5,615,517.73 5,148,773.44
US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 7,980,000.00 AA+ Aaa 05/03/22 05/04/22 7,256,812.50 2.95 10,002.11 7,368,356.77 7,114,668.75
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,393,679.06 3,058,528.13 Account 57710050 Page 7
#17..
- 738 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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 02/28/2021 0.500% 02/28/2026
91282CBQ3 4,645,000.00 AA+ Aaa 04/06/22 04/07/22 4,259,973.05 2.76 5,902.49 4,324,369.69 4,146,388.05
US TREASURY NOTES
DTD 02/28/2021 0.500% 02/28/2026
91282CBQ3 6,000,000.00 AA+ Aaa 12/03/21 12/07/21 5,838,281.25 1.15 7,624.31 5,875,882.95 5,355,937.20
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,292.07 2,230,062.62
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,905,852.56 4,428,652.59
US TREASURY N/B NOTES
DTD 05/31/2021 0.750% 05/31/2026
91282CCF6 1,405,000.00 AA+ Aaa 06/23/21 06/25/21 1,396,987.11 0.87 28.95 1,399,318.46 1,255,938.21
US TREASURY N/B NOTES
DTD 05/31/2021 0.750% 05/31/2026
91282CCF6 4,615,000.00 AA+ Aaa 04/06/22 04/07/22 4,253,551.76 2.76 95.09 4,310,333.73 4,125,377.11
US TREASURY N/B NOTES
DTD 05/31/2021 0.750% 05/31/2026
91282CCF6 4,800,000.00 AA+ Aaa 06/06/22 06/08/22 4,399,125.00 2.99 98.90 4,447,682.47 4,290,749.76
US TREASURY N/B NOTES
DTD 08/31/2021 0.750% 08/31/2026
91282CCW9 4,640,000.00 AA+ Aaa 04/06/22 04/07/22 4,258,106.25 2.75 8,844.20 4,314,665.50 4,120,900.00
US TREASURY N/B NOTES
DTD 09/30/2021 0.875% 09/30/2026
91282CCZ2 4,310,000.00 AA+ Aaa 04/05/22 04/07/22 3,968,398.83 2.77 6,423.56 4,018,063.51 3,838,593.75
US TREASURY NOTES
DTD 11/15/2016 2.000% 11/15/2026
912828U24 4,545,000.00 AA+ Aaa 06/06/22 06/08/22 4,355,920.90 3.01 4,017.68 4,376,450.15 4,220,458.82
US TREASURY NOTES
DTD 02/15/2017 2.250% 02/15/2027
912828V98 9,220,000.00 AA+ Aaa 07/05/22 07/07/22 8,981,576.56 2.85 60,882.07 9,002,389.06 8,623,581.25
US TREASURY N/B NOTES
DTD 03/31/2022 2.500% 03/31/2027
91282CEF4 910,000.00 AA+ Aaa 11/29/22 11/30/22 854,973.44 4.03 3,875.00 855,008.22 859,239.11
US TREASURY N/B NOTES
DTD 04/30/2020 0.500% 04/30/2027
912828ZN3 6,480,000.00 AA+ Aaa 08/03/22 08/05/22 5,791,500.00 2.92 2,774.59 5,838,488.43 5,601,150.00
US TREASURY NOTES
DTD 06/30/2020 0.500% 06/30/2027
912828ZV5 5,545,000.00 AA+ Aaa 08/09/22 08/10/22 4,920,754.30 2.99 11,602.31 4,960,272.38 4,765,234.38 Account 57710050 Page 8
#17..
- 739 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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 08/15/2017 2.250% 08/15/2027
9128282R0 1,200,000.00 AA+ Aaa 08/29/22 08/31/22 1,142,625.00 3.30 7,923.91 1,145,541.30 1,117,500.00
US TREASURY NOTES
DTD 08/15/2017 2.250% 08/15/2027
9128282R0 2,985,000.00 AA+ Aaa 09/01/22 09/06/22 2,830,036.52 3.40 19,710.74 2,837,423.91 2,779,781.25
US TREASURY N/B NOTES
DTD 09/30/2022 4.125% 09/30/2027
91282CFM8 5,380,000.00 AA+ Aaa 11/01/22 11/03/22 5,344,903.91 4.27 37,800.41 5,345,452.29 5,445,568.75 Security Type Sub-Total 225,986,000.00 218,758,372.23 2.01 453,204.48 219,822,524.20 208,586,209.48 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,788,741.77 1,714,358.18
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,093,169.65 3,808,616.18 Security Type Sub-Total 5,885,000.00 5,878,121.20 0.46 3,954.51 5,881,911.42 5,522,974.36 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,319,771.78 2,265,786.60
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,927.44 583,159.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 553,398.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 92,281.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,397.74 198,371.80
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 459,861.90 Account 57710050 Page 9
#17..
- 740 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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
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 506,925.01 454,181.85
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,164,684.15
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 838,938.00
NJ TURNPIKE AUTHORITY TXBL REV BONDS
DTD 02/04/2021 1.047% 01/01/2026
646140DP5 505,000.00 AA- A1 01/22/21 02/04/21 505,000.00 1.05 2,203.06 505,000.00 454,813.10 Security Type Sub-Total 7,590,000.00 7,640,416.25 1.22 25,224.46 7,602,021.97 7,065,476.00 Federal Agency Commercial Mortgage-Backed Security
FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
3136AJB54 757,331.41 AA+ Aaa 12/13/19 12/18/19 794,132.98 2.14 2,111.69 768,263.99 745,394.31 Security Type Sub-Total 757,331.41 794,132.98 2.14 2,111.69 768,263.99 745,394.31 Federal Agency Bond / Note
FREDDIE MAC NOTES
DTD 06/11/2018 2.750% 06/19/2023
3137EAEN5 2,250,000.00 AA+ Aaa 11/01/18 11/05/18 2,220,030.00 3.06 27,843.75 2,246,446.95 2,226,039.75
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,618,129.14 3,576,503.87
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,313,170.12 3,232,483.02
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,393,526.82 3,304,604.73
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,199,456.37 2,129,397.60
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,737,683.27 3,690,487.78 Account 57710050 Page 10
#17..
- 741 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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 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,663,126.74 5,582,540.26
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,343,911.76 2,259,799.12
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,477.15 860,727.60
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,014,329.58 1,928,201.86
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,037,529.73 1,999,108.35
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,555,628.99 3,304,371.00
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 644,296.05 601,244.80
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,364,425.30 2,166,580.53
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,351.26 435,201.65
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,914,790.82 1,749,968.74
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,191,849.88 2,927,303.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,191.26 3,064,735.83
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,381.68 182,085.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,077,729.48 978,707.95 Account 57710050 Page 11
#17..
- 742 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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 1,190,000.00 AA+ Aaa 01/04/21 01/05/21 1,197,223.30 0.36 2,710.56 1,194,132.05 1,083,406.94
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,671,125.47 3,345,815.55
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,828,830.59 3,477,827.32
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,214,163.08 2,009,888.10
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,576.71 406,078.20
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 549,037.72 496,317.80
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,353,956.85 2,129,654.56
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,903.85 116,971.14
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,394,237.76 3,059,245.20
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,540.62 1,833,611.16
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,210,331.88 1,990,906.24 Security Type Sub-Total 70,230,000.00 70,313,124.83 1.11 243,024.82 70,272,268.93 66,149,815.58 Corporate Note
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,226,718.28 2,203,786.35 Account 57710050 Page 12
#17..
- 743 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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
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,893,321.55 2,811,563.04
BANK OF AMERICA CORP NOTE (CALLABLE)
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,024,038.28 1,997,021.43
PFIZER INC CORP NOTES
DTD 03/11/2019 2.950% 03/15/2024
717081ES8 3,445,000.00 A+ A1 04/02/19 04/04/19 3,486,374.45 2.69 21,454.69 3,455,262.17 3,380,296.01 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,881.66 1,497,384.09
JP MORGAN CHASE BANK CORP NOTE
DTD 05/13/2014 3.625% 05/13/2024
46625HJX9 1,320,000.00 A- A1 09/22/20 09/24/20 1,461,028.80 0.65 2,392.50 1,376,220.22 1,297,872.84
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,038,642.61 3,893,216.00
JPMORGAN CHASE & CO CORPORATE
NOTES (CAL
DTD 09/16/2020 0.653% 09/16/2024
46647PBS4 1,405,000.00 A- A1 09/09/20 09/16/20 1,405,000.00 0.65 1,911.39 1,405,000.00 1,349,671.10
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,823,383.47 1,709,320.56
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,329,929.28 2,163,951.53
MASTERCARD INC CORP NOTES (CALLABLE)
DTD 12/03/2019 2.000% 03/03/2025
57636QAN4 1,760,000.00 A+ Aa3 05/04/20 05/06/20 1,836,225.60 1.08 8,604.44 1,794,947.72 1,675,095.84 AMAZON.COM INC CORPORATE NOTES
DTD 04/13/2022 3.000% 04/13/2025
023135CE4 3,430,000.00 AA A1 04/11/22 04/13/22 3,424,546.30 3.06 13,720.00 3,425,700.73 3,323,968.41
JPMORGAN CHASE & CO (CALLABLE) CORP
NOTE
DTD 06/01/2021 0.824% 06/01/2025
46647PCH7 865,000.00 A- A1 05/24/21 06/01/21 865,000.00 0.82 3,563.80 865,000.00 804,602.24 Account 57710050 Page 13
#17..
- 744 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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
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,217,139.97 2,007,885.31
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,522.31 3,088,292.13
BANK OF AMERICA CORP NOTES
(CALLABLE)
DTD 03/22/2022 3.384% 04/02/2026
06051GKM0 2,025,000.00 A- A2 03/17/22 03/22/22 2,025,000.00 3.38 11,230.65 2,025,000.00 1,925,550.23
MICROSOFT CORP (CALLABLE) NOTES
DTD 08/08/2016 2.400% 08/08/2026
594918BR4 3,000,000.00 AAA Aaa 02/23/22 02/25/22 3,033,150.00 2.14 22,600.00 3,027,116.83 2,815,998.00
TARGET CORP CORP NOTES (CALLABLE)
DTD 01/24/2022 1.950% 01/15/2027
87612EBM7 365,000.00 A A2 01/19/22 01/24/22 364,379.50 1.99 2,688.83 364,485.71 334,130.86 Security Type Sub-Total 40,100,000.00 40,855,037.55 1.88 229,182.96 40,346,310.79 38,279,605.97 Certificate of Deposit
BARCLAYS BANK PLC NY CERT DEPOS
DTD 02/03/2022 1.050% 02/01/2023
06742TG34 2,750,000.00 A-1 P-1 02/02/22 02/03/22 2,750,000.00 1.05 24,142.71 2,750,000.00 2,732,668.47
CREDIT SUISSE NEW YORK CERT DEPOS
DTD 03/23/2021 0.590% 03/17/2023
22552G3C2 1,850,000.00 A-2 P-2 03/19/21 03/23/21 1,850,000.00 0.59 7,852.74 1,850,000.00 1,825,528.20
TORONTO DOMINION BANK NY CERT
DEPOS
DTD 10/31/2022 5.470% 10/25/2024
89115B6F2 3,355,000.00 A A1 10/27/22 10/31/22 3,355,000.00 5.44 15,802.98 3,355,000.00 3,354,548.08 Security Type Sub-Total 7,955,000.00 7,955,000.00 2.80 47,798.43 7,955,000.00 7,912,744.75 Asset-Backed Security
CARMX 2019-2 A3
DTD 04/17/2019 2.680% 03/15/2024
14316LAC7 9,574.22 AAA NR 04/09/19 04/17/19 9,573.24 2.68 11.40 9,573.96 9,564.96 Account 57710050 Page 14
#17..
- 745 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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
HAROT 2020-1 A3
DTD 02/26/2020 1.610% 04/22/2024
43813RAC1 345,649.06 NR Aaa 02/19/20 02/26/20 345,581.30 1.61 154.58 345,626.37 341,969.83 TAOT 2020-A A3
DTD 02/12/2020 1.660% 05/15/2024
89232HAC9 405,347.61 AAA Aaa 02/04/20 02/12/20 405,318.34 1.66 299.06 405,337.61 402,447.27 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
14315XAC2 296,010.08 AAA NR 01/14/20 01/22/20 295,952.00 1.89 248.65 295,985.87 292,011.46 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
43813GAC5 490,397.05 NR Aaa 02/17/21 02/24/21 490,388.07 0.27 36.78 490,391.89 474,381.12 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
44933LAC7 506,424.61 AAA NR 04/20/21 04/28/21 506,371.34 0.38 85.53 506,390.70 488,186.69 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
14316NAC3 302,953.49 AAA NR 01/20/21 01/27/21 302,893.62 0.34 45.78 302,916.22 291,248.67 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,943.27 925,014.65 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,889.51 738,298.64 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 152.93 464,920.20 436,314.75 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,873.40 712,429.21 Security Type Sub-Total 5,346,356.12 5,345,564.15 0.73 1,599.74 5,345,849.00 5,111,867.25 Managed Account Sub-Total 363,849,687.53 357,539,769.19 1.78 1,006,101.09 357,994,150.30 339,374,087.70 $363,849,687.53 $357,539,769.19 1.78% $1,006,101.09 $357,994,150.30 $339,374,087.70 $340,380,188.79
$1,006,101.09
Total Investments
Accrued Interest
Securities Sub-Total
Account 57710050 Page 15
#17..
- 746 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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 912828S92 3,280,000.00 NOMURA 97.73 3,205,687.66 64,575.16 (53,026.23) DTD 08/01/2016 1.250% 07/31/2023
0.67 4.73
US TREASURY NOTES 9128282D1 1,750,000.00 RBS 97.53 1,706,796.88 (17,089.84) (38,513.04) DTD 08/31/2016 1.375% 08/31/2023
0.75 4.77
US TREASURY NOTES 91282CAK7 4,395,000.00 NOMURA 96.44 4,238,428.13 (26,095.31) (85,132.23) DTD 09/15/2020 0.125% 09/15/2023
0.79 4.77
US TREASURY NOTES 9128285D8 2,700,000.00 TD 98.48 2,659,078.26 (110,742.05) (54,045.53) DTD 10/01/2018 2.875% 09/30/2023
0.83 4.75
US TREASURY NOTES 91282CAW1 3,910,000.00 MERRILL 95.81 3,746,268.75 (163,120.31) (163,501.74) DTD 11/15/2020 0.250% 11/15/2023
0.96 4.77
US TREASURY NOTES 912828WE6 8,790,000.00 TD 98.09 8,622,440.63 (256,489.45) (185,677.64) DTD 11/15/2013 2.750% 11/15/2023
0.95 4.81
US TREASURY NOTES 912828U57 3,275,000.00 BNP_PARI 97.42 3,190,566.57 (25,841.64) (72,491.99) DTD 11/30/2016 2.125% 11/30/2023
0.99 4.80
US TREASURY NOTES 91282CBA8 4,430,000.00 NOMURA 95.34 4,223,728.13 (39,800.78) (104,014.91) DTD 12/15/2020 0.125% 12/15/2023
1.04 4.76
US TREASURY NOTES 9128285U0 270,000.00 MERRILL 97.78 264,009.38 (6,792.18) (6,167.01) DTD 12/31/2018 2.625% 12/31/2023
1.06 4.75
US TREASURY NOTES 9128286G0 457,000.00 WELLS_F 97.27 444,503.88 (36,167.29) (24,064.74) DTD 02/28/2019 2.375% 02/29/2024
1.23 4.65
US TREASURY NOTES 9128286G0 1,564,000.00 WELLS_F 97.27 1,521,234.30 (123,348.36) (82,148.20) DTD 02/28/2019 2.375% 02/29/2024
1.23 4.65
US TREASURY NOTES 91282CBR1 4,450,000.00 RBS 94.53 4,206,640.63 (56,320.31) (119,195.02) DTD 03/15/2021 0.250% 03/15/2024
1.29 4.67
US TREASURY N/B NOTES 91282CBV2 4,890,000.00 BARCLAY 94.38 4,614,937.50 (278,691.80) (276,744.53) DTD 04/15/2021 0.375% 04/15/2024
1.37 4.65
US TREASURY N/B NOTES 91282CCG4 4,485,000.00 NOMURA 93.59 4,197,679.69 (65,172.65) (131,261.58) DTD 06/15/2021 0.250% 06/15/2024
1.54 4.60
US TREASURY NOTES 9128282N9 2,450,000.00 TD 96.13 2,355,062.50 (134,080.08) (108,006.52) DTD 07/31/2017 2.125% 07/31/2024
1.64 4.56
US TREASURY NOTES 9128282U3 1,630,000.00 MERRILL 95.58 1,557,923.36 (114,291.09) (86,881.82) DTD 08/31/2017 1.875% 08/31/2024
1.72 4.53
US TREASURY N/B NOTES 91282CCX7 4,505,000.00 BARCLAY 93.05 4,191,761.94 (72,678.10) (136,863.38) DTD 09/15/2021 0.375% 09/15/2024
1.78 4.46
Account 57710050 Page 16
#17..
- 747 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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 9128282Y5 1,850,000.00 HSBC 95.98 1,775,711.03 (129,572.17) (94,565.54) DTD 10/02/2017 2.125% 09/30/2024
1.80 4.43
US TREASURY NOTES 9128283D0 460,000.00 MORGAN_S 96.09 442,031.25 (33,008.59) (23,746.95) DTD 10/31/2017 2.250% 10/31/2024
1.88 4.40
US TREASURY NOTES 9128283J7 1,215,000.00 NOMURA 95.77 1,163,552.28 (76,412.17) (61,444.46) DTD 11/30/2017 2.125% 11/30/2024
1.97 4.36
US TREASURY NOTES 9128283J7 3,450,000.00 RBS 95.77 3,303,913.89 (226,002.13) (178,695.78) DTD 11/30/2017 2.125% 11/30/2024
1.97 4.36
US TREASURY NOTES 9128283J7 4,585,000.00 HSBC 95.77 4,390,853.68 (457,962.92) (341,158.62) DTD 11/30/2017 2.125% 11/30/2024
1.97 4.36
US TREASURY N/B NOTES 91282CDN8 4,445,000.00 BNP_PAR 93.52 4,156,769.31 (95,151.00) (141,898.68) DTD 12/15/2021 1.000% 12/15/2024
2.01 4.35
US TREASURY N/B NOTES 91282CDZ1 4,400,000.00 RBS 94.09 4,140,125.00 (114,984.38) (147,983.39) DTD 02/15/2022 1.500% 02/15/2025
2.17 4.33
US TREASURY NOTES 912828ZL7 4,945,000.00 JPM_CHA 91.27 4,513,084.91 (381,692.43) (401,630.24) DTD 04/30/2020 0.375% 04/30/2025
2.41 4.21
US TREASURY NOTES 912828XZ8 4,230,000.00 BARCLAY 96.63 4,087,237.50 (144,910.55) (144,477.30) DTD 07/02/2018 2.750% 06/30/2025
2.48 4.14
US TREASURY NOTES 91282CAJ0 4,340,000.00 WELLS_F 89.97 3,904,643.75 (386,870.31) (402,597.24) DTD 08/31/2020 0.250% 08/31/2025
2.74 4.15
US TREASURY NOTES 91282CAJ0 4,635,000.00 BNP_PAR 89.97 4,170,051.56 (92,881.06) (164,179.00) DTD 08/31/2020 0.250% 08/31/2025
2.74 4.15
US TREASURY NOTES 91282CAM3 1,100,000.00 BNP_PAR 89.95 989,484.32 (86,539.12) (93,569.84) DTD 09/30/2020 0.250% 09/30/2025
2.82 4.04
US TREASURY NOTES 91282CAM3 4,550,000.00 HSBC 89.95 4,092,866.96 (380,707.26) (403,810.33) DTD 09/30/2020 0.250% 09/30/2025
2.82 4.04
US TREASURY NOTES 91282CAT8 5,010,000.00 HSBC 89.61 4,489,429.94 (404,909.51) (445,689.52) DTD 10/31/2020 0.250% 10/31/2025
2.91 4.06
US TREASURY NOTES 91282CAT8 6,930,000.00 TD 89.61 6,209,930.03 (573,348.88) (614,916.56) DTD 10/31/2020 0.250% 10/31/2025
2.91 4.06
US TREASURY NOTES 91282CAZ4 4,250,000.00 WELLS_F 89.63 3,809,062.50 (324,228.52) (355,110.55) DTD 11/30/2020 0.375% 11/30/2025
2.98 4.08
US TREASURY NOTES 91282CAZ4 4,635,000.00 WELLS_F 89.63 4,154,118.75 (100,666.41) (168,551.73) DTD 11/30/2020 0.375% 11/30/2025
2.98 4.08
Account 57710050 Page 17
#17..
- 748 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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 91282CBC4 500,000.00 HSBC 89.52 447,578.10 (51,035.18) (51,550.07) DTD 12/31/2020 0.375% 12/31/2025
3.06 4.02
US TREASURY NOTES 91282CBC4 1,040,000.00 CITIGRP 89.52 930,962.45 (105,015.68) (106,546.56) DTD 12/31/2020 0.375% 12/31/2025
3.06 4.02
US TREASURY NOTES 91282CBC4 3,735,000.00 JPM_CHA 89.52 3,343,408.41 (303,031.24) (333,917.24) DTD 12/31/2020 0.375% 12/31/2025
3.06 4.02
US TREASURY NOTES 91282CBH3 2,400,000.00 BNP_PAR 89.16 2,139,750.00 (214,125.00) (228,274.79) DTD 01/31/2021 0.375% 01/31/2026
3.15 4.06
US TREASURY NOTES 91282CBH3 5,000,000.00 NOMURA 89.16 4,457,812.50 (261,718.75) (317,307.15) DTD 01/31/2021 0.375% 01/31/2026
3.15 4.06
US TREASURY NOTES 91282CBH3 5,775,000.00 MORGAN_ 89.16 5,148,773.44 (421,394.53) (466,744.29) DTD 01/31/2021 0.375% 01/31/2026
3.15 4.06
US TREASURY NOTES 91282CBH3 7,980,000.00 JPM_CHA 89.16 7,114,668.75 (142,143.75) (253,688.02) DTD 01/31/2021 0.375% 01/31/2026
3.15 4.06
US TREASURY NOTES 9128286F2 3,210,000.00 GOLDMAN 95.28 3,058,528.13 (434,353.12) (335,150.93) DTD 02/28/2019 2.500% 02/28/2026
3.12 4.06
US TREASURY NOTES 91282CBQ3 4,645,000.00 NOMURA 89.27 4,146,388.05 (113,585.00) (177,981.64) DTD 02/28/2021 0.500% 02/28/2026
3.22 4.06
US TREASURY NOTES 91282CBQ3 6,000,000.00 WELLS_F 89.27 5,355,937.20 (482,344.05) (519,945.75) DTD 02/28/2021 0.500% 02/28/2026
3.22 4.06
US TREASURY N/B NOTES 91282CBT7 2,480,000.00 WELLS_F 89.92 2,230,062.62 (248,968.63) (249,229.45) DTD 03/31/2021 0.750% 03/31/2026
3.29 4.01
US TREASURY N/B NOTES 91282CBT7 4,925,000.00 MORGAN_ 89.92 4,428,652.59 (468,067.14) (477,199.97) DTD 03/31/2021 0.750% 03/31/2026
3.29 4.01
US TREASURY N/B NOTES 91282CCF6 1,405,000.00 MERRILL 89.39 1,255,938.21 (141,048.90) (143,380.25) DTD 05/31/2021 0.750% 05/31/2026
3.46 4.03
US TREASURY N/B NOTES 91282CCF6 4,615,000.00 NOMURA 89.39 4,125,377.11 (128,174.65) (184,956.62) DTD 05/31/2021 0.750% 05/31/2026
3.46 4.03
US TREASURY N/B NOTES 91282CCF6 4,800,000.00 CITIGRP 89.39 4,290,749.76 (108,375.24) (156,932.71) DTD 05/31/2021 0.750% 05/31/2026
3.46 4.03
US TREASURY N/B NOTES 91282CCW9 4,640,000.00 RBC 88.81 4,120,900.00 (137,206.25) (193,765.50) DTD 08/31/2021 0.750% 08/31/2026
3.69 3.99
US TREASURY N/B NOTES 91282CCZ2 4,310,000.00 RBC 89.06 3,838,593.75 (129,805.08) (179,469.76) DTD 09/30/2021 0.875% 09/30/2026
3.77 3.98
Account 57710050 Page 18
#17..
- 749 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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 912828U24 4,545,000.00 RBC 92.86 4,220,458.82 (135,462.08) (155,991.33) DTD 11/15/2016 2.000% 11/15/2026
3.82 3.97
US TREASURY NOTES 912828V98 9,220,000.00 JPM_CHA 93.53 8,623,581.25 (357,995.31) (378,807.81) DTD 02/15/2017 2.250% 02/15/2027
4.01 3.93
US TREASURY N/B NOTES 91282CEF4 910,000.00 BARCLAY 94.42 859,239.11 4,265.67 4,230.89 DTD 03/31/2022 2.500% 03/31/2027
4.11 3.91
US TREASURY N/B NOTES 912828ZN3 6,480,000.00 NOMURA 86.44 5,601,150.00 (190,350.00) (237,338.43) DTD 04/30/2020 0.500% 04/30/2027
4.37 3.87
US TREASURY NOTES 912828ZV5 5,545,000.00 WELLS_F 85.94 4,765,234.38 (155,519.92) (195,038.00) DTD 06/30/2020 0.500% 06/30/2027
4.52 3.88
US TREASURY NOTES 9128282R0 1,200,000.00 BNP_PAR 93.13 1,117,500.00 (25,125.00) (28,041.30) DTD 08/15/2017 2.250% 08/15/2027
4.45 3.86
US TREASURY NOTES 9128282R0 2,985,000.00 HSBC 93.13 2,779,781.25 (50,255.27) (57,642.66) DTD 08/15/2017 2.250% 08/15/2027
4.45 3.86
US TREASURY N/B NOTES 91282CFM8 5,380,000.00 MERRILL 101.22 5,445,568.75 100,664.84 100,116.46 DTD 09/30/2022 4.125% 09/30/2027
4.40 3.85
Security Type Sub-Total 225,986,000.00 208,586,209.48 (10,172,162.75) (11,236,314.72) 2.66 4.23 Supra-National Agency Bond / Note
INTL BK RECON & DEVELOP NOTES 459058JM6 1,790,000.00 TD 95.77 1,714,358.18 (71,793.32) (74,383.59) DTD 11/24/2020 0.250% 11/24/2023
0.98 4.70
INTER-AMERICAN DEVEL BK NOTES 4581X0DZ8 4,095,000.00 JPM_CHA 93.01 3,808,616.18 (283,353.52) (284,553.47) DTD 09/23/2021 0.500% 09/23/2024
1.81 4.56
Security Type Sub-Total 5,885,000.00 5,522,974.36 (355,146.84) (358,937.06) 1.55 4.60 Municipal Bond / Note
CA ST TXBL GO BONDS 13063DRJ9 2,310,000.00 MORGAN_S 98.09 2,265,786.60 (90,436.50) (53,985.18) DTD 10/24/2019 2.400% 10/01/2023
0.83 4.76
MD ST TXBL GO BONDS 574193TQ1 620,000.00 JPM_CHA 94.06 583,159.60 (36,666.80) (36,767.84) DTD 08/05/2020 0.510% 08/01/2024
1.66 4.23
CA ST UNIV TXBL REV BONDS 13077DMK5 600,000.00 GOLDMAN 92.23 553,398.00 (46,602.00) (46,602.00) DTD 09/17/2020 0.685% 11/01/2024
1.91 4.98
Account 57710050 Page 19
#17..
- 750 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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
CA ST DEPT WTR RES WTR SYS TXBL REV 13067WRB0 100,000.00 MORGAN_ 92.28 92,281.00 (7,719.00) (7,719.00) BNDS
DTD 08/06/2020 0.560% 12/01/2024
1.99 4.64
UNIV OF CAL TXBL REV BONDS 91412HGE7 220,000.00 JPM_CHA 04/15/25 90.17 198,371.80 (22,424.60) (22,025.94) DTD 07/16/2020 0.883% 05/15/2025
2.35 5.19
UNIV OF CAL TXBL REV BONDS 91412HGE7 510,000.00 JPM_CHA 04/15/25 90.17 459,861.90 (50,138.10) (50,138.10) DTD 07/16/2020 0.883% 05/15/2025
2.35 5.19
FL ST BOARD OF ADMIN TXBL REV BONDS 341271AD6 505,000.00 MERRILL 89.94 454,181.85 (54,388.50) (52,743.16) DTD 09/16/2020 1.258% 07/01/2025
2.54 5.48
FL ST BOARD OF ADMIN TXBL REV BONDS 341271AD6 1,295,000.00 MERRILL 89.94 1,164,684.15 (130,315.85) (130,315.85) DTD 09/16/2020 1.258% 07/01/2025
2.54 5.48
LOS ANGELES CCD, CA TXBL GO BONDS 54438CYK2 925,000.00 MERRILL 90.70 838,938.00 (86,062.00) (86,062.00) DTD 11/10/2020 0.773% 08/01/2025
2.64 4.51
NJ TURNPIKE AUTHORITY TXBL REV 646140DP5 505,000.00 CITIGRP 90.06 454,813.10 (50,186.90) (50,186.90) BONDS
DTD 02/04/2021 1.047% 01/01/2026
3.03 4.53
Security Type Sub-Total 7,590,000.00 7,065,476.00 (574,940.25) (536,545.97) 1.89 4.89 Federal Agency Commercial Mortgage-Backed Security
FANNIEMAE-ACES 3136AJB54 757,331.41 JPM_CHAS 98.42 745,394.31 (48,738.67) (22,869.68) DTD 04/01/2014 3.346% 03/01/2024
1.16 4.64
Security Type Sub-Total 757,331.41 745,394.31 (48,738.67) (22,869.68) 1.16 4.64 Federal Agency Bond / Note
FREDDIE MAC NOTES 3137EAEN5 2,250,000.00 CITIGRP 98.94 2,226,039.75 6,009.75 (20,407.20) DTD 06/11/2018 2.750% 06/19/2023
0.55 4.66
FREDDIE MAC NOTES 3137EAEN5 3,615,000.00 MORGAN_S 98.94 3,576,503.87 (63,873.43) (41,625.27) DTD 06/11/2018 2.750% 06/19/2023
0.55 4.66
FREDDIE MAC NOTES 3137EAES4 3,315,000.00 TD 97.51 3,232,483.02 (72,837.18) (80,687.10) DTD 06/26/2020 0.250% 06/26/2023
0.57 4.71
FANNIE MAE NOTES 3135G05G4 3,395,000.00 CITIGRP 97.34 3,304,604.73 (83,096.02) (88,922.09) DTD 07/10/2020 0.250% 07/10/2023
0.61 4.72
Account 57710050 Page 20
#17..
- 751 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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 3137EAEV7 2,200,000.00 CITIGRP 96.79 2,129,397.60 (68,358.40) (70,058.77) DTD 08/21/2020 0.250% 08/24/2023
0.73 4.75
FANNIE MAE NOTES 3135G0U43 3,745,000.00 JPM_CHAS 98.54 3,690,487.78 (9,122.82) (47,195.49) DTD 09/14/2018 2.875% 09/12/2023
0.78 4.78
FANNIE MAE NOTES 3135G0U43 5,665,000.00 TD 98.54 5,582,540.26 (71,016.44) (80,586.48) DTD 09/14/2018 2.875% 09/12/2023
0.78 4.78
FEDERAL FARM CREDIT BANK (CALLABLE) 3133EMAM4 2,345,000.00 TD 96.37 2,259,799.12 (81,214.38) (84,112.64) DTD 09/21/2020 0.250% 09/21/2023
0.81 4.89
FANNIE MAE NOTES 3135G06H1 900,000.00 MORGAN_ 95.64 860,727.60 (40,640.40) (39,749.55) DTD 11/25/2020 0.250% 11/27/2023
0.99 4.81
FREDDIE MAC NOTES 3137EAFA2 2,015,000.00 CITIGRP 95.69 1,928,201.86 (84,803.29) (86,127.72) DTD 12/04/2020 0.250% 12/04/2023
1.01 4.66
FEDERAL HOME LOAN BANKS NOTES 3130A0F70 2,025,000.00 BARCLAYS 98.72 1,999,108.35 (85,576.28) (38,421.38) DTD 12/09/2013 3.375% 12/08/2023
1.00 4.67
FANNIE MAE NOTES 3135G0X24 3,500,000.00 CITIGRP 94.41 3,304,371.00 (323,764.00) (251,257.99) DTD 01/10/2020 1.625% 01/07/2025
2.06 4.44
FREDDIE MAC NOTES 3137EAEP0 640,000.00 WELLS_FA 93.94 601,244.80 (48,432.00) (43,051.25) DTD 02/14/2020 1.500% 02/12/2025
2.16 4.42
FEDERAL HOME LOAN BANK NOTES 3130AJHU6 2,370,000.00 CITIGRP 91.42 2,166,580.53 (191,664.27) (197,844.77) DTD 04/16/2020 0.500% 04/14/2025
2.36 4.35
FANNIE MAE NOTES 3135G03U5 475,000.00 WELLS_F 91.62 435,201.65 (40,529.85) (40,149.61) DTD 04/24/2020 0.625% 04/22/2025
2.38 4.35
FANNIE MAE NOTES 3135G03U5 1,910,000.00 HSBC 91.62 1,749,968.74 (169,810.46) (164,822.08) DTD 04/24/2020 0.625% 04/22/2025
2.38 4.35
FANNIE MAE NOTES 3135G03U5 3,195,000.00 CITIGRP 91.62 2,927,303.73 (261,114.57) (264,546.15) DTD 04/24/2020 0.625% 04/22/2025
2.38 4.35
FANNIE MAE NOTES 3135G03U5 3,345,000.00 WELLS_F 91.62 3,064,735.83 (282,739.47) (281,455.43) DTD 04/24/2020 0.625% 04/22/2025
2.38 4.35
FANNIE MAE NOTES 3135G04Z3 200,000.00 WELLS_F 91.04 182,085.20 (18,626.80) (18,296.48) DTD 06/19/2020 0.500% 06/17/2025
2.53 4.25
FANNIE MAE NOTES 3135G04Z3 1,075,000.00 NOMURA 91.04 978,707.95 (101,333.80) (99,021.53) DTD 06/19/2020 0.500% 06/17/2025
2.53 4.25
FANNIE MAE NOTES 3135G04Z3 1,190,000.00 RBS 91.04 1,083,406.94 (113,816.36) (110,725.11) DTD 06/19/2020 0.500% 06/17/2025
2.53 4.25
Account 57710050 Page 21
#17..
- 752 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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 3,675,000.00 NOMURA 91.04 3,345,815.55 (321,577.20) (325,309.92) DTD 06/19/2020 0.500% 06/17/2025
2.53 4.25
FANNIE MAE NOTES 3135G04Z3 3,820,000.00 RBS 91.04 3,477,827.32 (358,484.08) (351,003.27) DTD 06/19/2020 0.500% 06/17/2025
2.53 4.25
FREDDIE MAC NOTES 3137EAEU9 2,220,000.00 WELLS_F 90.54 2,009,888.10 (199,056.30) (204,274.98) DTD 07/23/2020 0.375% 07/21/2025
2.63 4.20
FANNIE MAE NOTES 3135G05X7 450,000.00 NOMURA 90.24 406,078.20 (41,401.80) (42,498.51) DTD 08/27/2020 0.375% 08/25/2025
2.72 4.19
FANNIE MAE NOTES 3135G05X7 550,000.00 CITIGRP 90.24 496,317.80 (51,971.70) (52,719.92) DTD 08/27/2020 0.375% 08/25/2025
2.72 4.19
FANNIE MAE NOTES 3135G05X7 2,360,000.00 BARCLAY 90.24 2,129,654.56 (219,300.64) (224,302.29) DTD 08/27/2020 0.375% 08/25/2025
2.72 4.19
FREDDIE MAC NOTES 3137EAEX3 130,000.00 WELLS_F 89.98 116,971.14 (12,858.56) (12,932.71) DTD 09/25/2020 0.375% 09/23/2025
2.80 4.19
FREDDIE MAC NOTES 3137EAEX3 3,400,000.00 CITIGRP 89.98 3,059,245.20 (330,520.80) (334,992.56) DTD 09/25/2020 0.375% 09/23/2025
2.80 4.19
FANNIE MAE NOTES 3135G06G3 2,040,000.00 NOMURA 89.88 1,833,611.16 (205,613.64) (205,929.46) DTD 11/12/2020 0.500% 11/07/2025
2.92 4.20
FANNIE MAE NOTES 3135G06G3 2,215,000.00 BARCLAY 89.88 1,990,906.24 (216,164.06) (219,425.64) DTD 11/12/2020 0.500% 11/07/2025
2.92 4.20
Security Type Sub-Total 70,230,000.00 66,149,815.58 (4,163,309.25) (4,122,453.35) 1.69 4.49 Corporate Note
TOYOTA MOTOR CREDIT CORP CORP 89236TFN0 2,230,000.00 JPM_CHAS 98.82 2,203,786.35 (6,388.95) (22,931.93) NOTES
DTD 09/20/2018 3.450% 09/20/2023
0.80 4.95
US BANK NA CINCINNATI CORP NOTES 91159HHV5 2,860,000.00 GOLDMAN 01/05/24 98.31 2,811,563.04 (183,972.36) (81,758.51) (CALLAB
DTD 02/04/2019 3.375% 02/05/2024
1.08 4.86
BANK OF AMERICA CORP NOTE (CALLABLE) 06051GHF9 2,010,000.00 MERRILL 03/05/23 99.35 1,997,021.43 (145,296.87) (27,016.85) DTD 03/05/2018 3.550% 03/05/2024
0.27 4.08
PFIZER INC CORP NOTES 717081ES8 3,445,000.00 BONY 02/15/24 98.12 3,380,296.01 (106,078.44) (74,966.16) DTD 03/11/2019 2.950% 03/15/2024
1.19 4.46
Account 57710050 Page 22
#17..
- 753 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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
AMAZON.COM INC CORPORATE NOTES 023135BW5 1,590,000.00 JPM_CHA 94.18 1,497,384.09 (90,294.51) (91,497.57) DTD 05/12/2021 0.450% 05/12/2024
1.45 4.65
JP MORGAN CHASE BANK CORP NOTE 46625HJX9 1,320,000.00 JPM_CHA 98.32 1,297,872.84 (163,155.96) (78,347.38) DTD 05/13/2014 3.625% 05/13/2024
1.43 4.83
WALMART INC CORPORATE NOTES 931142EL3 4,000,000.00 CITIGRP 06/08/24 97.33 3,893,216.00 (231,624.00) (145,426.61) DTD 04/23/2019 2.850% 07/08/2024
1.48 4.59
JPMORGAN CHASE & CO CORPORATE 46647PBS4 1,405,000.00 JPM_CHA 09/16/23 96.06 1,349,671.10 (55,328.90) (55,328.90)
NOTES (CAL
DTD 09/16/2020 0.653% 09/16/2024
0.79 2.92
PACCAR FINANCIAL CORP CORPORATE 69371RQ66 1,810,000.00 MITSU 94.44 1,709,320.56 (129,693.74) (114,062.91) NOTES
DTD 02/06/2020 1.800% 02/06/2025
2.14 4.50
NOVARTIS CAPITAL CORP 66989HAP3 2,290,000.00 CITIGRP 01/14/25 94.50 2,163,951.53 (214,098.97) (165,977.75) DTD 02/14/2020 1.750% 02/14/2025
2.08 4.39
MASTERCARD INC CORP NOTES 57636QAN4 1,760,000.00 JSEB 02/03/25 95.18 1,675,095.84 (161,129.76) (119,851.88) (CALLABLE)
DTD 12/03/2019 2.000% 03/03/2025
2.13 4.26
AMAZON.COM INC CORPORATE NOTES 023135CE4 3,430,000.00 JPM_CHA 96.91 3,323,968.41 (100,577.89) (101,732.32) DTD 04/13/2022 3.000% 04/13/2025
2.30 4.39
JPMORGAN CHASE & CO (CALLABLE) CORP 46647PCH7 865,000.00 JPM_CHA 06/01/24 93.02 804,602.24 (60,397.76) (60,397.76) NOTE
DTD 06/01/2021 0.824% 06/01/2025
1.49 3.77
BRISTOL-MYERS SQUIBB CO CORPORATE 110122DN5 2,230,000.00 MERRILL 10/13/25 90.04 2,007,885.31 (203,003.59) (209,254.66) NOTES
DTD 11/13/2020 0.750% 11/13/2025
2.84 4.38
BANK OF NY MELLON CORP (CALLABLE) 06406RAQ0 3,465,000.00 US_BANC 12/28/25 89.13 3,088,292.13 (377,539.47) (377,230.18) CORPOR
DTD 01/28/2021 0.750% 01/28/2026
3.04 4.48
BANK OF AMERICA CORP NOTES 06051GKM0 2,025,000.00 MERRILL 04/02/25 95.09 1,925,550.23 (99,449.77) (99,449.77) (CALLABLE)
DTD 03/22/2022 3.384% 04/02/2026
2.25 5.00
MICROSOFT CORP (CALLABLE) NOTES 594918BR4 3,000,000.00 TD 05/08/26 93.87 2,815,998.00 (217,152.00) (211,118.83) DTD 08/08/2016 2.400% 08/08/2026
3.29 4.21
Account 57710050 Page 23
#17..
- 754 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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
TARGET CORP CORP NOTES (CALLABLE) 87612EBM7 365,000.00 CITIGRP 12/15/26 91.54 334,130.86 (30,248.64) (30,354.85) DTD 01/24/2022 1.950% 01/15/2027
3.87 4.20
Security Type Sub-Total 40,100,000.00 38,279,605.97 (2,575,431.58) (2,066,704.82) 1.85 4.45 Certificate of Deposit
BARCLAYS BANK PLC NY CERT DEPOS 06742TG34 2,750,000.00 BARCLAY 99.37 2,732,668.47 (17,331.53) (17,331.53) DTD 02/03/2022 1.050% 02/01/2023
0.18 4.64
CREDIT SUISSE NEW YORK CERT DEPOS 22552G3C2 1,850,000.00 CSFB 98.68 1,825,528.20 (24,471.80) (24,471.80) DTD 03/23/2021 0.590% 03/17/2023
0.31 5.06
TORONTO DOMINION BANK NY CERT 89115B6F2 3,355,000.00 TD 99.99 3,354,548.08 (451.92) (451.92) DEPOS
DTD 10/31/2022 5.470% 10/25/2024
1.85 5.44
Security Type Sub-Total 7,955,000.00 7,912,744.75 (42,255.25) (42,255.25) 0.92 5.08 Asset-Backed Security
CARMX 2019-2 A3 14316LAC7 9,574.22 RBC 99.90 9,564.96 (8.28) (9.00) DTD 04/17/2019 2.680% 03/15/2024
0.04 2.76
HAROT 2020-1 A3 43813RAC1 345,649.06 JPM_CHAS 98.94 341,969.83 (3,611.47) (3,656.54) DTD 02/26/2020 1.610% 04/22/2024
0.30 2.39
TAOT 2020-A A3 89232HAC9 405,347.61 MITSU 99.28 402,447.27 (2,871.07) (2,890.34) DTD 02/12/2020 1.660% 05/15/2024
0.22 2.16
CARMX 2020-1 A3 14315XAC2 296,010.08 MERRILL 98.65 292,011.46 (3,940.54) (3,974.41) DTD 01/22/2020 1.890% 12/16/2024
0.38 2.57
HAROT 2021-1 A3 43813GAC5 490,397.05 JPM_CHA 96.73 474,381.12 (16,006.95) (16,010.77) DTD 02/24/2021 0.270% 04/21/2025
0.61 1.66
HART 2021-A A3 44933LAC7 506,424.61 BARCLAY 96.40 488,186.69 (18,184.65) (18,204.01) DTD 04/28/2021 0.380% 09/15/2025
0.70 1.70
CARMX 2021-1 A3 14316NAC3 302,953.49 MITSU 96.14 291,248.67 (11,644.95) (11,667.55) DTD 01/27/2021 0.340% 12/15/2025
0.67 1.64
TAOT 2021-C A3 89239BAC5 980,000.00 BARCLAY 94.39 925,014.65 (54,907.24) (54,928.62) DTD 09/27/2021 0.430% 01/15/2026
1.13 2.29
Account 57710050 Page 24
#17..
- 755 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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
CARMX 2021-2 A3 14314QAC8 770,000.00 MERRILL 95.88 738,298.64 (31,535.43) (31,590.87) DTD 04/21/2021 0.520% 02/17/2026
0.70 1.84
HART 2021-C A3 44935FAD6 465,000.00 SMBC 93.83 436,314.75 (28,581.46) (28,605.45) DTD 11/17/2021 0.740% 05/15/2026
1.27 2.61
DCENT 2021-A1 A1 254683CP8 775,000.00 CITIGRP 91.93 712,429.21 (62,404.86) (62,444.19) DTD 09/27/2021 0.580% 09/15/2026
1.74 2.83
Security Type Sub-Total 5,346,356.12 5,111,867.25 (233,696.90) (233,981.75) 0.88 2.19 Managed Account Sub-Total 363,849,687.53 339,374,087.70 (18,165,681.49) (18,620,062.60) 2.27 4.32 Total Investments $340,380,188.79
$1,006,101.09
$339,374,087.70
Accrued Interest
Securities Sub-Total $363,849,687.53 ($18,165,681.49) ($18,620,062.60) 2.27 4.32% Account 57710050 Page 25
#17..
- 756 -
Managed Account Security Transactions & Interest For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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/03/22 US TREASURY N/B NOTES
DTD 09/30/2022 4.125% 09/30/2027
11/01/22 91282CFM8 5,380,000.00 (5,344,903.91) (20,729.26) (5,365,633.17) 11/30/22 US TREASURY N/B NOTES
DTD 03/31/2022 2.500% 03/31/2027
11/29/22 91282CEF4 910,000.00 (854,973.44) (3,812.50) (858,785.94) Transaction Type Sub-Total 6,290,000.00 (6,199,877.35) (24,541.76) (6,224,419.11)
INTEREST
11/01/22 11/01/22 MONEY MARKET FUND MONEY0002 0.00 0.00 2,720.67 2,720.67 11/01/22 CA ST UNIV TXBL REV BONDS
DTD 09/17/2020 0.685% 11/01/2024
11/01/22 13077DMK5 600,000.00 0.00 2,055.00 2,055.00
11/25/22 FHMS KJ27 A1
DTD 11/01/2019 2.092% 07/01/2024
11/01/22 3137FQ3V3 6,425.11 0.00 11.20 11.20
11/25/22 FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
11/01/22 3136AJB54 894,082.44 0.00 2,504.19 2,504.19
11/07/22 FANNIE MAE NOTES
DTD 11/12/2020 0.500% 11/07/2025
11/07/22 3135G06G3 4,255,000.00 0.00 10,637.50 10,637.50 11/12/22 AMAZON.COM INC CORPORATE NOTES
DTD 05/12/2021 0.450% 05/12/2024
11/12/22 023135BW5 1,590,000.00 0.00 3,577.50 3,577.50
11/13/22 BRISTOL-MYERS SQUIBB CO
CORPORATE NOTES
DTD 11/13/2020 0.750% 11/13/2025
11/13/22 110122DN5 2,230,000.00 0.00 8,362.50 8,362.50
11/13/22 JP MORGAN CHASE BANK CORP NOTE
DTD 05/13/2014 3.625% 05/13/2024
11/13/22 46625HJX9 1,320,000.00 0.00 23,925.00 23,925.00 11/15/22 US TREASURY NOTES
DTD 11/15/2020 0.250% 11/15/2023
11/15/22 91282CAW1 3,910,000.00 0.00 4,887.50 4,887.50
11/15/22 US TREASURY NOTES
DTD 11/15/2013 2.750% 11/15/2023
11/15/22 912828WE6 8,790,000.00 0.00 120,862.50 120,862.50 11/15/22 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
11/15/22 44933LAC7 510,000.00 0.00 161.50 161.50
11/15/22 UNIV OF CAL TXBL REV BONDS
DTD 07/16/2020 0.883% 05/15/2025
11/15/22 91412HGE7 730,000.00 0.00 3,222.95 3,222.95
11/15/22 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
11/15/22 14315XAC2 328,167.04 0.00 516.86 516.86
Account 57710050 Page 26
#17..
- 757 -
Managed Account Security Transactions & Interest For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
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/22 CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
11/15/22 14314QAC8 770,000.00 0.00 333.67 333.67
11/15/22 TAOT 2021-C A3
DTD 09/27/2021 0.430% 01/15/2026
11/15/22 89239BAC5 980,000.00 0.00 351.17 351.17
11/15/22 US TREASURY NOTES
DTD 11/15/2016 2.000% 11/15/2026
11/15/22 912828U24 4,545,000.00 0.00 45,450.00 45,450.00 11/15/22 CARMX 2019-2 A3
DTD 04/17/2019 2.680% 03/15/2024
11/15/22 14316LAC7 34,854.16 0.00 77.84 77.84
11/15/22 TAOT 2020-A A3
DTD 02/12/2020 1.660% 05/15/2024
11/15/22 89232HAC9 479,946.41 0.00 663.93 663.93
11/15/22 NAROT 2019-B A3
DTD 05/28/2019 2.500% 11/15/2023
11/15/22 65479HAC1 19,752.72 0.00 41.15 41.15
11/15/22 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
11/15/22 14316NAC3 320,660.03 0.00 90.85 90.85
11/15/22 DCENT 2021-A1 A1
DTD 09/27/2021 0.580% 09/15/2026
11/15/22 254683CP8 775,000.00 0.00 374.58 374.58
11/15/22 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
11/15/22 44935FAD6 465,000.00 0.00 286.75 286.75
11/21/22 HAROT 2020-1 A3
DTD 02/26/2020 1.610% 04/22/2024
11/21/22 43813RAC1 398,011.81 0.00 534.00 534.00
11/21/22 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
11/21/22 43813GAC5 526,635.18 0.00 118.49 118.49
11/24/22 INTL BK RECON & DEVELOP NOTES
DTD 11/24/2020 0.250% 11/24/2023
11/24/22 459058JM6 1,790,000.00 0.00 2,237.50 2,237.50
11/27/22 FANNIE MAE NOTES
DTD 11/25/2020 0.250% 11/27/2023
11/27/22 3135G06H1 900,000.00 0.00 1,125.00 1,125.00
11/30/22 US TREASURY NOTES
DTD 11/30/2017 2.125% 11/30/2024
11/30/22 9128283J7 9,250,000.00 0.00 98,281.25 98,281.25 11/30/22 US TREASURY NOTES
DTD 11/30/2020 0.375% 11/30/2025
11/30/22 91282CAZ4 8,885,000.00 0.00 16,659.38 16,659.38 11/30/22 US TREASURY N/B NOTES
DTD 05/31/2021 0.750% 05/31/2026
11/30/22 91282CCF6 10,820,000.00 0.00 40,575.00 40,575.00 11/30/22 US TREASURY NOTES
DTD 11/30/2016 2.125% 11/30/2023
11/30/22 912828U57 3,275,000.00 0.00 34,796.88 34,796.88 Account 57710050 Page 27
#17..
- 758 -
Managed Account Security Transactions & Interest For the Month Ending November 30, 2022 CITY OF MODESTO - 57710050
Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
Transaction Type Sub-Total 69,398,534.90 0.00 425,442.31 425,442.31
PAYDOWNS
11/25/22 FHMS KJ27 A1
DTD 11/01/2019 2.092% 07/01/2024
11/01/22 3137FQ3V3 6,425.11 6,425.11 0.00 6,425.11 0.16 0.00 11/25/22 FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
11/01/22 3136AJB54 136,751.03 136,751.03 0.00 136,751.03 (6,645.24) 0.00 11/15/22 TAOT 2020-A A3
DTD 02/12/2020 1.660% 05/15/2024
11/15/22 89232HAC9 74,598.80 74,598.80 0.00 74,598.80 5.39 0.00 11/15/22 NAROT 2019-B A3
DTD 05/28/2019 2.500% 11/15/2023
11/15/22 65479HAC1 19,752.72 19,752.72 0.00 19,752.72 4.47 0.00 11/15/22 CARMX 2019-2 A3
DTD 04/17/2019 2.680% 03/15/2024
11/15/22 14316LAC7 25,279.94 25,279.94 0.00 25,279.94 2.58 0.00 11/15/22 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
11/15/22 14316NAC3 17,706.54 17,706.54 0.00 17,706.54 3.50 0.00 11/15/22 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
11/15/22 44933LAC7 3,575.39 3,575.39 0.00 3,575.39 0.38 0.00 11/15/22 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
11/15/22 14315XAC2 32,156.96 32,156.96 0.00 32,156.96 6.31 0.00 11/21/22 HAROT 2020-1 A3
DTD 02/26/2020 1.610% 04/22/2024
11/21/22 43813RAC1 52,362.75 52,362.75 0.00 52,362.75 10.26 0.00 11/21/22 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
11/21/22 43813GAC5 36,238.13 36,238.13 0.00 36,238.13 0.66 0.00 Transaction Type Sub-Total 404,847.37 404,847.37 0.00 404,847.37 (6,611.53) 0.00 SELL
11/03/22 US TREASURY NOTES
DTD 08/01/2016 1.250% 07/31/2023
11/01/22 912828S92 3,155,000.00 3,077,727.15 10,180.88 3,087,908.03 80,600.39 (51,122.07) FIFO 11/03/22 US TREASURY NOTES
DTD 08/01/2016 1.250% 07/31/2023
11/01/22 912828S92 2,345,000.00 2,287,565.82 7,567.08 2,295,132.90 41,861.91 (40,455.11) FIFO Transaction Type Sub-Total 5,500,000.00 5,365,292.97 17,747.96 5,383,040.93 122,462.30 (91,577.18) Managed Account Sub-Total (429,737.01) 418,648.51 (11,088.50) 115,850.77 (91,577.18) Total Security Transactions ($429,737.01) $418,648.51 ($11,088.50) $115,850.77 ($91,577.18) Account 57710050 Page 28
#17..
- 759 -
Managed Account Summary Statement For the Month Ending November 30, 2022 CITY OF MODESTO SHORT-TERM - 57710062
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)
$39,929,806.47
(9,960,000.00)
0.00 10,037,202.00
0.00 136,567.49
$40,143,575.96
80,925.00
0.00 21,787.50
$102,712.50
Total
40,170,337.16
0.00 0.00
10,040,925.00
0.00 (10,037,202.00)
(39,981,172.30)
(74,767.66)
Total Accrual Basis Earnings $118,120.20
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
10,040,925.00
0.00 0.00
0.00 (10,037,202.00)
(3,723.00)
0.00 Cash Balance
Closing Cash Balance $0.00
Account 57710062 Page 1
#17..
- 760 -
Portfolio Summary and Statistics For the Month Ending November 30, 2022 CITY OF MODESTO SHORT-TERM - 57710062
Account Summary
Description Par Value Market Value Percent
Commercial Paper 40,355,000.00 40,143,575.96 100.00
Managed Account Sub-Total 40,355,000.00 40,143,575.96 100.00% Accrued Interest 0.00
Total Portfolio 40,355,000.00 40,143,575.96
Unsettled Trades 0.00 0.00
Sector Allocation
100.00%
Commercial Paper
0 - 6 Months 6 - 12 Months 1 - 2 Years 2 - 3 Years 3 - 4 Years 4 - 5 Years Over 5 Years 100.00%
0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Maturity Distribution Characteristics
Yield to Maturity at Cost
Yield to Maturity at Market
Weighted Average Days to Maturity 43
3.76%
4.42%
Account 57710062 Page 2
#17..
- 761 -
Managed Account Issuer Summary For the Month Ending November 30, 2022 CITY OF MODESTO SHORT-TERM - 57710062
Credit Quality (S&P Ratings)
100.00%
A-1
Issuer Summary
Issuer of Holdings Percent
Market Value
COLLAT COMM PAPER V CO 10,064,848.74 25.07
LMA AMERICAS LLC 9,949,170.00 24.78
MANHATTAN ASSET FUNDING CO LLC 10,066,470.12 25.08
MITSUBISHI UFJ FINANCIAL GROUP INC 10,063,087.10 25.07
Total $40,143,575.96 100.00%
Account 57710062 Page 3
#17..
- 762 -
Managed Account Detail of Securities Held For the Month Ending November 30, 2022 CITY OF MODESTO SHORT-TERM - 57710062
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
Commercial Paper
MANHATTAN ASSET FDG CO COMM PAPER
DTD 09/22/2022 0.000% 12/19/2022
56274MMK5 10,090,000.00 A-1 P-1 09/23/22 09/23/22 10,000,997.79 3.68 0.00 10,071,585.75 10,066,470.12
COLLAT COMM PAPER V CO COMM PAPER
DTD 09/02/2022 0.000% 01/05/2023
19424JN51 10,110,000.00 A-1 P-1 09/12/22 09/12/22 9,999,871.21 3.45 0.00 10,076,482.54 10,064,848.74
LMA AMERICAS LLC COMM PAPER
DTD 07/12/2022 0.000% 01/11/2023
53944RNB0 10,000,000.00 A-1 P-1 08/01/22 08/01/22 9,857,375.00 3.20 0.00 9,964,125.00 9,949,170.00
MUFG BANK LTD/NY COMM PAPER
DTD 11/14/2022 0.000% 02/13/2023
62479MPD9 10,155,000.00 A-1 P-1 11/14/22 11/15/22 10,037,202.00 4.69 0.00 10,058,143.87 10,063,087.10 Security Type Sub-Total 40,355,000.00 39,895,446.00 3.76 0.00 40,170,337.16 40,143,575.96 Managed Account Sub-Total 40,355,000.00 39,895,446.00 3.76 0.00 40,170,337.16 40,143,575.96 $40,355,000.00 $39,895,446.00 3.76% $0.00 $40,170,337.16 $40,143,575.96 $40,143,575.96
$0.00
Total Investments
Accrued Interest
Securities Sub-Total
Account 57710062 Page 4
#17..
- 763 -
Managed Account Fair Market Value & Analytics For the Month Ending November 30, 2022 CITY OF MODESTO SHORT-TERM - 57710062
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
Commercial Paper
MANHATTAN ASSET FDG CO COMM PAPER 56274MMK5 10,090,000.00 CSFB 99.77 10,066,470.12 65,472.33 (5,115.63) DTD 09/22/2022 0.000% 12/19/2022
0.05 4.43
COLLAT COMM PAPER V CO COMM PAPER 19424JN51 10,110,000.00 RBC 99.55 10,064,848.74 64,977.53 (11,633.80) DTD 09/02/2022 0.000% 01/05/2023
0.10 4.49
LMA AMERICAS LLC COMM PAPER 53944RNB0 10,000,000.00 GOLDMAN 99.49 9,949,170.00 91,795.00 (14,955.00) DTD 07/12/2022 0.000% 01/11/2023
0.12 4.38
MUFG BANK LTD/NY COMM PAPER 62479MPD9 10,155,000.00 MITSU 99.09 10,063,087.10 25,885.10 4,943.23 DTD 11/14/2022 0.000% 02/13/2023
0.22 4.38
Security Type Sub-Total 40,355,000.00 40,143,575.96 248,129.96 (26,761.20) 0.12 4.42 Managed Account Sub-Total 40,355,000.00 40,143,575.96 248,129.96 (26,761.20) 0.12 4.42 Total Investments $40,143,575.96
$0.00
$40,143,575.96
Accrued Interest
Securities Sub-Total $40,355,000.00 $248,129.96 ($26,761.20) 0.12 4.42% Account 57710062 Page 5
#17..
- 764 -
Managed Account Security Transactions & Interest For the Month Ending November 30, 2022 CITY OF MODESTO SHORT-TERM - 57710062
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/15/22 MUFG BANK LTD/NY COMM PAPER
DTD 11/14/2022 0.000% 02/13/2023
11/14/22 62479MPD9 10,155,000.00 (10,037,202.00) 0.00 (10,037,202.00) Transaction Type Sub-Total 10,155,000.00 (10,037,202.00) 0.00 (10,037,202.00)
MATURITY
11/15/22 US TREASURY NOTES
DTD 11/15/2012 1.625% 11/15/2022
11/15/22 912828TY6 9,960,000.00 9,960,000.00 80,925.00 10,040,925.00 21,787.50 0.00 Transaction Type Sub-Total 9,960,000.00 9,960,000.00 80,925.00 10,040,925.00 21,787.50 0.00 Managed Account Sub-Total (77,202.00) 80,925.00 3,723.00 21,787.50 0.00 Total Security Transactions ($77,202.00) $80,925.00 $3,723.00 $21,787.50 $0.00 Account 57710062 Page 6
#17..
- 765 -
Attachment 3
City of Modesto Combined Yields
Month
Ending
Combined
Yield
CAMP
Balance
CAMP Monthly
Distribution Yields
Long Term
Amortized Cost
Balance
Long Term
Portfolio Yield
Short Term
Amortized Cost
Balance
Short Term
Portfolio Yield
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% 12/31/2021 0.91% 123,754,558.86 0.05% 274,968,424.92 1.29% 1/31/2022 0.92% 123,759,932.29 0.05% 276,103,753.02 1.31% 2/28/2022 0.92% 106,765,158.19 0.06% 276,530,404.21 1.31% 39,948,433.34 0.53% 3/31/2022 0.98% 106,788,084.24 0.25% 277,035,730.56 1.33% 39,948,380.00 0.53% 4/30/2022 1.39% 30,016,017.61 0.50% 353,203,903.46 1.56% 39,984,016.67 0.53% 5/31/2022 1.47% 50,044,305.28 0.82% 353,781,386.85 1.59% 39,880,961.12 1.26% 6/30/2022 1.56% 75,106,114.53 1.14% 354,423,884.74 1.64% 39,871,394.45 1.66% 7/31/2022 1.66% 46,186,072.35 1.64% 354,553,148.20 1.66% 39,928,141.66 1.66% 8/31/2022 1.79% 46,276,184.59 2.30% 356,564,454.56 1.69% 39,858,625.00 2.14% 9/30/2022 1.95% 46,375,593.86 2.61% 356,228,719.05 1.71% 39,880,797.64 3.34% 10/31/2022 2.03% 46,499,174.80 3.14% 357,511,536.00 1.74% 39,981,172.30 3.34% 11/30/2022 2.18% 46,648,406.54 3.90% 357,994,150.30 1.78% 40,170,337.16 3.76% Notes:
1. Long and Short Term Portfolio AC Balance is the amortized cost value of the separately managed portfolios.
2. Long and Short Term Portfolio Yields are the separately managed portfolios yield at costs. #17..
- 766 -
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, 2023
Expected Earnings to
June 30, 2023
Main Portfolio
Federal Agency
FHLMC 3,615,000 6/19/2023 4.660% 1 51,392 2.65% 55,601
FHLMC 2,250,000 6/19/2023 4.660% 1 37,924 3.10% 40,543
FHLMC 3,315,000 6/26/2023 4.710% 1 6,573 0.41% 7,976
FNMA 3,395,000 7/10/2023 4.720% 1 6,650 0.32% 6,351
FHLMC 2,200,000 8/24/2023 4.750% 1 4,572 0.28% 3,630
FNMA 3,745,000 9/12/2023 4.780% 1 92,327 3.15% 68,438
FNMA 5,665,000 9/12/2023 4.780% 1 129,622 2.92% 96,083
FFCB 2,345,000 9/21/2023 4.890% 1 5,836 0.31% 4,194
FNMA 900,000 11/27/2023 4.810% 1 1,752 0.20% 1,026
FHLMC 2,015,000 12/4/2023 4.660% 1 5,768 0.28% 3,314
FHLB 2,025,000 12/8/2023 4.670% 1 56,336 2.72% 32,019
FNMA 3,500,000 1/7/2025 4.440% 2 62,757 0.85% 17,301
FHLMC 640,000 2/12/2025 4.420% 2 16,725 1.18% 4,405
FHLB 2,370,000 4/14/2025 4.350% 2 33,792 0.60% 8,272
FNMA 3,195,000 4/22/2025 4.350% 2 51,029 0.67% 12,378
FNMA 475,000 4/22/2025 4.350% 2 6,751 0.59% 1,638
FNMA 3,345,000 4/22/2025 4.350% 2 48,847 0.61% 11,848
FNMA 1,910,000 4/22/2025 4.350% 2 23,719 0.52% 5,753
FNMA 3,675,000 6/17/2025 4.250% 3 50,757 0.54% 11,571
FNMA 200,000 6/17/2025 4.250% 3 2,161 0.42% 493
FNMA 1,075,000 6/17/2025 4.250% 3 10,933 0.40% 2,492
FNMA 3,820,000 6/17/2025 4.250% 3 39,728 0.41% 9,056
FNMA 1,190,000 6/17/2025 4.250% 3 10,987 0.36% 2,505
FHLMC 2,220,000 7/21/2025 4.200% 3 27,910 0.48% 6,138
FNMA 2,360,000 8/25/2025 4.190% 3 30,353 0.47% 6,441
FNMA 550,000 8/25/2025 4.190% 3 6,620 0.44% 1,405
FNMA 450,000 8/25/2025 4.190% 3 6,063 0.49% 1,287
FHLMC 3,400,000 9/23/2025 4.190% 3 41,750 0.44% 8,610
FHLMC 130,000 9/23/2025 4.190% 3 1,470 0.40% 303
FNMA 2,215,000 11/7/2025 4.200% 3 37,307 0.57% 7,371
FNMA 2,040,000 11/7/2025 4.200% 3 30,452 0.51% 6,017
Federal Agency CMO
FNMA 757,331 3/1/2024 4.640% 1 20,254 2.14% 9,396
U.S. Treasury
U.S. Treasury 3,280,000 7/31/2023 4.730% 1 49,861 2.28% 43,500 U.S. Treasury 1,750,000 8/31/2023 4.770% 1 22,967 1.75% 17,770 U.S. Treasury 4,395,000 9/15/2023 4.770% 1 77,777 2.24% 57,055 U.S. Treasury 2,700,000 9/30/2023 4.750% 1 50,726 2.26% 35,375 U.S. Treasury 3,910,000 11/15/2023 4.770% 1 9,605 0.26% 5,818 U.S. Treasury 8,790,000 11/15/2023 4.810% 1 212,352 2.52% 128,625 U.S. Treasury 3,275,000 11/30/2023 4.800% 1 82,395 2.52% 47,857 U.S. Treasury 4,430,000 12/15/2023 4.760% 1 111,058 2.41% 61,959 U.S. Treasury 270,000 12/31/2023 4.750% 1 7,499 2.56% 4,015 U.S. Treasury 1,564,000 2/29/2024 4.650% 1 6,743 0.35% 3,135 U.S. Treasury 457,000 2/29/2024 4.650% 1 1,911 0.33% 888 U.S. Treasury 4,450,000 3/15/2024 4.670% 1 142,720 2.49% 64,239 U.S. Treasury 4,890,000 4/15/2024 4.650% 1 23,523 0.35% 9,934 U.S. Treasury 4,485,000 6/15/2024 4.600% 2 179,277 2.59% 67,507 U.S. Treasury 2,450,000 7/31/2024 4.560% 2 73,109 1.79% 25,450 U.S. Treasury 1,630,000 8/31/2024 4.530% 2 38,194 1.34% 12,652 U.S. Treasury 4,505,000 9/15/2024 4.460% 2 214,371 2.65% 69,384 U.S. Treasury 1,850,000 9/30/2024 4.430% 2 50,986 1.50% 16,133 U.S. Treasury 460,000 10/31/2024 4.400% 2 13,833 1.57% 4,183 U.S. Treasury 1,215,000 11/30/2024 4.360% 2 41,215 1.69% 11,953 U.S. Treasury 3,450,000 11/30/2024 4.360% 2 112,671 1.63% 32,676 U.S. Treasury 4,585,000 11/30/2024 4.360% 2 46,232 0.50% 13,408 U.S. Treasury 4,445,000 12/15/2024 4.350% 2 243,888 2.68% 69,309 U.S. Treasury 4,400,000 2/15/2025 4.330% 2 263,400 2.70% 69,110 U.S. Treasury 4,945,000 4/30/2025 4.210% 2 75,583 0.63% 18,167 U.S. Treasury 4,230,000 6/30/2025 4.140% 3 298,645 2.73% 67,140 U.S. Treasury 4,340,000 8/31/2025 4.150% 3 63,089 0.53% 13,308 U.S. Treasury 4,635,000 8/31/2025 4.150% 3 349,820 2.74% 73,793 U.S. Treasury 4,550,000 9/30/2025 4.040% 3 86,486 0.67% 17,715 U.S. Treasury 1,100,000 9/30/2025 4.040% 3 25,081 0.80% 5,137 U.S. Treasury 5,010,000 10/31/2025 4.060% 3 113,103 0.77% 22,493 U.S. Treasury 6,930,000 10/31/2025 4.060% 3 157,819 0.78% 31,386 U.S. Treasury 4,250,000 11/30/2025 4.080% 3 135,930 1.07% 26,293 U.S. Treasury 4,635,000 11/30/2025 4.080% 3 383,242 2.75% 74,131 U.S. Treasury 1,040,000 12/31/2025 4.020% 3 14,568 0.45% 2,740 U.S. Treasury 500,000 12/31/2025 4.020% 3 6,673 0.43% 1,255 U.S. Treasury 3,735,000 12/31/2025 4.020% 3 102,380 0.89% 19,259 U.S. Treasury 2,400,000 1/31/2026 4.060% 3 61,256 0.80% 11,214 U.S. Treasury 5,775,000 1/31/2026 4.060% 3 233,131 1.27% 42,680 U.S. Treasury 5,000,000 1/31/2026 4.060% 3 294,129 1.85% 53,848 U.S. Treasury 7,980,000 1/31/2026 4.060% 3 746,850 2.95% 136,729 U.S. Treasury 3,210,000 2/28/2026 4.060% 3 73,254 0.70% 13,094 U.S. Treasury 6,000,000 2/28/2026 4.060% 3 225,135 1.15% 40,243 U.S. Treasury 4,645,000 2/28/2026 4.060% 3 416,279 2.76% 74,411 U.S. Treasury 4,925,000 3/31/2026 4.010% 3 142,782 0.87% 24,873 U.S. Treasury 2,480,000 3/31/2026 4.010% 3 62,738 0.76% 10,929 U.S. Treasury 1,405,000 5/31/2026 4.030% 4 42,719 0.87% 7,086 U.S. Treasury 4,615,000 5/31/2026 4.030% 4 446,149 2.76% 74,009 U.S. Treasury 4,800,000 5/31/2026 4.030% 4 502,922 2.99% 83,427 U.S. Treasury 4,640,000 8/31/2026 3.990% 4 478,959 2.75% 74,116 U.S. Treasury 4,310,000 9/30/2026 3.980% 4 457,580 2.77% 69,291 U.S. Treasury 4,545,000 11/15/2026 3.970% 4 541,768 3.01% 79,429 U.S. Treasury 9,220,000 2/15/2027 3.930% 4 1,108,236 2.85% 152,761 U.S. Treasury 910,000 3/31/2027 3.910% 4 159,129 4.03% 21,325 U.S. Treasury 6,480,000 4/30/2027 3.870% 4 835,102 2.92% 109,827 U.S. Treasury 5,545,000 6/30/2027 3.880% 5 760,572 2.99% 96,379 U.S. Treasury 1,200,000 8/15/2027 3.860% 5 186,699 3.30% 23,025 U.S. Treasury 2,985,000 8/15/2027 3.860% 5 478,010 3.40% 58,952 U.S. Treasury 5,380,000 9/30/2027 3.850% 5 1,111,656 4.27% 133,525 November 30, 2022
Earnings to
Maturity
#17..
- 767 -
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, 2023
Expected Earnings to
June 30, 2023
November 30, 2022
Earnings to
Maturity
Commercial Paper
Sumitomo Mitsui Financial Group Inc 10,090,000 12/19/2022 4.430% 0 19,342 4.01% 234,825 Collat Commercial Paper V Co 10,110,000 1/5/2023 4.490% 0 34,377 3.93% 230,599 LMA Americas LLC 10,000,000 1/11/2023 4.380% 0 36,771 3.86% 224,002 Mitsubishi Ufj Financial Group Inc 10,155,000 2/13/2023 4.380% 0 97,957 4.24% 249,944 Negotiable CD
Barclays PLC 2,750,000 2/1/2023 4.640% 0 4,984 3.12% 49,877 Credit Suisse Group 1,850,000 3/17/2023 5.060% 0 3,178 2.25% 24,214 Toronto-Dominion Bank 3,355,000 10/25/2024 5.440% 2 347,535 5.44% 106,011 Corporate Note
Toyota Motor Corp 2,230,000 9/20/2023 4.950% 1 65,580 3.65% 47,289 US Bancorp 2,860,000 2/5/2024 4.860% 1 76,802 2.27% 37,690 Bank Of America Co 2,010,000 3/5/2024 4.080% 1 39,885 1.57% 18,342 Pfizer Inc 3,445,000 3/15/2024 4.460% 1 119,531 2.69% 53,801 Amazon.Com Inc 1,590,000 5/12/2024 4.650% 1 11,501 0.50% 4,609 JPMorgan Chase & Co 1,320,000 5/13/2024 4.830% 1 12,403 0.65% 4,961 Wal-Mart Stores Inc 4,000,000 7/8/2024 4.590% 2 140,398 2.19% 50,792 JPMorgan Chase & Co 1,405,000 9/16/2024 2.920% 2 16,489 0.65% 5,329 Paccar Financial Corp 1,810,000 2/6/2025 4.500% 2 57,372 1.45% 15,223 Novartis Capital Corp 2,290,000 2/14/2025 4.390% 2 46,688 0.92% 12,265 Mastercard Inc 1,760,000 3/3/2025 4.260% 2 42,765 1.08% 11,003 Amazon.Com Inc 3,430,000 4/13/2025 4.390% 2 248,400 3.06% 60,880 JPMorgan Chase & Co 865,000 6/1/2025 3.770% 3 17,848 0.82% 4,140 Bristol-Myers Squibb Co 2,230,000 11/13/2025 4.380% 3 62,629 0.95% 12,305 The Bank Of New York Mellon Corporation 3,465,000 1/28/2026 4.480% 3 81,695 0.75% 14,995 Bank Of America Co 2,025,000 4/2/2026 5.000% 3 228,843 3.38% 39,799 Microsoft Corp 3,000,000 8/8/2026 4.210% 4 236,746 2.14% 37,261 Target Corp 365,000 1/15/2027 4.200% 4 29,931 1.99% 4,211 Asset-Backed Securities
Carmax Auto Owner Trust 9,574 3/15/2024 2.760% 1 331 2.68% 149 Honda Auto Receivables 345,649 4/22/2024 2.390% 1 7,784 1.61% 3,242 Toyota Motor Corp 405,348 5/15/2024 2.160% 1 9,818 1.66% 3,912 Carmax Auto Owner Trust 296,010 12/16/2024 2.570% 2 11,475 1.89% 3,257 Honda Auto Receivables 490,397 4/21/2025 1.660% 2 3,172 0.27% 770 Hyundai Auto Receivables 506,425 9/15/2025 1.700% 3 5,412 0.38% 1,125 Carmax Auto Owner Trust 302,953 12/15/2025 1.640% 3 3,173 0.34% 605 Toyota Motor Corp 980,000 1/15/2026 2.290% 3 13,242 0.43% 2,458 Carmax Auto Owner Trust 770,000 2/17/2026 1.840% 3 13,000 0.52% 2,346 Hyundai Auto Receivables 465,000 5/15/2026 2.610% 3 11,979 0.75% 2,012 Discover Card Execution Note Trust 775,000 9/15/2026 2.830% 4 17,185 0.58% 2,630 Municipal Securities
California St 2,310,000 10/1/2023 4.760% 1 36,105 1.87% 25,096 Maryland St 620,000 8/1/2024 4.230% 2 5,358 0.52% 1,862 California State University 600,000 11/1/2024 4.980% 2 7,904 0.68% 2,387 State Of California 100,000 12/1/2024 4.640% 2 1,123 0.56% 325 University Of California 510,000 5/15/2025 5.190% 2 11,068 0.88% 2,616 University Of California 220,000 5/15/2025 5.190% 2 4,360 0.81% 1,031 Florida State Board of Administration Finance 1,295,000 7/1/2025 5.480% 3 42,137 1.26% 9,463 Florida State Board of Administration Finance 505,000 7/1/2025 5.480% 3 14,448 1.11% 3,245 Los Angeles Community College District 925,000 8/1/2025 4.510% 3 19,101 0.77% 4,153 New Jersey Turnpike Authority 505,000 1/1/2026 4.530% 3 16,341 1.05% 3,071 Supranational Securities
Intl Bank Of Reconstruction And Dev 1,790,000 11/24/2023 4.700% 1 5,670 0.32% 3,348 Inter-American Development Bank 4,095,000 9/23/2024 4.560% 2 39,043 0.52% 12,484 Overnight Investments 46,648,407 Varies Varies 4.36% 1,181,777 Totals (Main Portfolio) 450,853,094 16,591,784 2.26% 5,917,508 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. #17..
- 768 -
Attachment 5
Issue Name / Type Trustee Bank Investment Total Amount
1993 Community Center Refinancing U.S. Bank First American Treasury Obligation Fund $1,700,929.00 1993 Golf Course Refinancing U.S. Bank First American Treasury Obligation Fund $507,135.26 Instl Res Tre and Agny Cash Adv6541 $244,425.85
Financial Guaranty Insurance Pol $1.00
CAMP $1,951,212.53
Total $2,195,639.38
Instl Res Tre and Agny Cash Adv6541 $198,157.63
Cash $67,804.73
CAMP $4,827,087.71
Total $5,093,050.07
2018 Wastewater Refunding Bank of New York Fidelity Inv MM Trsy Only $22.64 Fairview Village Refunding US Bank First American Government $196,613.40 Blackrock Federal Fund Instl 30 $2,031.61
CAMP $2,763,634.66
Total $2,765,666.27
PCE Litigation Bank of America Business Interest Maximizer $491,977.15 Water ARRA Grants Bank of the West Business Money Market $36,289.42 Other Post Employment Benefits Section 115
Trust PARS HighMark Plus Moderate $1,420,096.10
Pension Section 115 Trust PARS HighMark Plus Moderately Conservative $2,514,557.62 Innovative Claim Solutions* (Previous Third
Party Administrator - Worker's Compensation) Wells Fargo Bank Business Money Market $165,973.56 Athens Administrators (New Third Party
Administrator - Worker's Compensation) Wells Fargo Bank $463,449.17 George Hills Company - General Liability Claims
Administration Services California Bank & Trust $12,269.80 Kemper Sports Management Inc. BMO Harris Bank Business Money Market $27,268.96 Stanislaus Community Foundation Modesto Commerce Bank Charles Schwab $716,253.42 California Bank of
Commerce $3,317,398.08
Columbia Bank $199,721.16
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, 2022
2008 Water Refunding COP Bank of New York
2008 Lease Revenue Bonds Bank of New York
#17..
- 769 -
CITY OF MODESTO
COUNCIL AGENDA REPORT
DATE OF MEETING:
February 14, 2023
Date: January 19, 2022
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: Alan Ernst, Fire Chief
SUBJECT: Purchase of 2019 Chevrolet Tahoe
CONTACT: Alan Ernst, Fire Chief, [email protected] , 209-572-9590 DESCRIPTION:
Consider approving the purchase of the 2019 Chevrolet Tahoe SUV to Salida Fire Protection District (SFPD), Salida, CA, for a total amount not to exceed $60,000. (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:
On September 13, 2022, by Resolution 2022-370, the Modesto Fire Department (MFD) entered into a contract for services with Salida Fire Protection District (SFPD). This created a need to cover a greater service area. In addition to the growing jurisdiction, there is a need to replace existing vehicles within the MFD fleet that have high mileage and have become unreliable.
On May 23, 2022, the Finance Committee approved the Authorization to Purchase submitted by Fleet Services and which was issued on July 6, 2021. MFD is allotted one new addition to fleet.
The costs associated with the purchase of a new vehicle and equipment buildup costs to outfit a Fire vehicle will be significantly more in the future than they are today. Additionally, there is also a concern that supply chain delays will increase the time it takes to put the vehicle in service.
Purchasing this specific vehicle from SFPD will bring significant savings in time and expenses.
Additionally, with the approval of this bid, MFD will be able to surplus an existing vehicle.
DISCUSSION:
Salida Fire Protection District (SFPD) is conducting a sealed bid for a 2019 Chevy Tahoe SUV that is fully outfitted with radios, a light package and command board. The vehicle has 26,000 miles and was appraised by SFPD with a minimum bid set at $45,000. According to Kelley Blue Book, a comparable Chevy Tahoe with similar mileage without the radios, light package, Mobile Data Computer mount, and command board is estimated at $46,355. Researching #18..
- 770 -
City Council, February 14, 2023
Purchase of 2019 Chevrolet Tahoe
comparisons, staff found similar vehicles for sale with a listed price ranging from $42,000 to $50,000. With the additional specialized equipment already installed within the SFPD Chevy Tahoe, it is estimated to add a total value of $29,600 (see below for cost breakdown). MFD has submitted a bid of $55,000, which was accepted by SFPD pending Council approval.
Unit estimated cost breakdown for additional equipment on Salida Tahoe Chevy Tahoe Vehicle $46,355
Tri Band Radios $7000 X 3 $21,000
Docking Station for MDC $600
Command Board Build up $2,000
Code 3 Light Package $6,000
Total Vehicle Value $75,955
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 his or her discretion, determines that a process other than the formal bid procedure set for in Section 8-3.203 will result in procurement for the City at the lowest possible cost commensurate with the desired quality.” In purchasing this vehicle, MFD will procure an item with the highest operational quality available at a cost significantly less than market value.
FISCAL IMPACT:
SFPD accepted a bid of $55,000 for the Chevy Tahoe SUV as noted above. In addition to the bid amount, MFD will be responsible for paying $5,000 to support vehicle licensing fees and applying department logo decals to put the vehicle into service. Combined, these costs are estimated at approximately $60,000 and are budgeted within the department in the General Fund.
COMMITTEE RECOMMENDATION:
This item was presented to Safety and Communities Committee on January 18, 2023 and was recommended to forward to Council for approval.
RECOMMENDED COUNCIL ACTION:
Staff Recommendations:
Resolution approving the purchase of a 2019 Chevrolet Tahoe SUV from Salida Fire Protection District, Salida, CA, for a total amount not to exceed $60,000 and authorizing the Purchasing Manager, or her designee to issue the Purchase Order.
Approved by:
Alan Ernst, Fire Chief
Joseph P. Lopez, City Manager
#18..
- 771 -
City Council, February 14, 2023
Purchase of 2019 Chevrolet Tahoe
Attachments:
1. Resolution
2. Bid for Purchase
3. Vehicle Comps
4. Bid Waiver
#18..
- 772 -
1 02/14/2023/Fire/AErnst/Item # 2023-xxx
MODESTO CITY COUNCIL
RESOLUTION NO. 2023-XX
RESOLUTIONAPPROVING THE PURCHASE OF THE 2019 CHEVROLET
TAHOE SUV TO SALIDA FIRE PROTECTION DISTRICT (SFPD), SALIDA, CA, FOR A TOTAL AMOUNT NOT TO EXCEED $60,000; AND AUTHORIZING
THE PURCHASING MANAGER, OR HER DESIGNEE TO ISSUE THE
PURCHASE ORDER
WHEREAS, as of September 13, 2022, by Resolution 2022-370, the Modesto Fire Department (MFD) entered into a contract for services with Salida Fire Protection District (SFPD). This created a need to cover a greater service area. In addition to the growing jurisdiction, there is a need to replace existing vehicles within the MFD fleet that have high mileage and have become unreliable; and
WHEREAS, on May 23, 2022, Finance Committee approved the Authorization to Purchase submitted by Fleet Services and issued on July 6, 2021. MFD is allotted one new addition to fleet; and
WHEREAS, Salida Fire Protection District (SFPD) is conducting a sealed bid for a 2019 Chevy Tahoe SUV that is fully outfitted with radios, a light package and command board. The vehicle has 26,000 miles and was appraised by SFPD with a minimum bid set at $45,000; and
WHEREAS, researching comparisons, staff found similar vehicles for sale with a listed price ranging from $42,000 to $50,000. With the additional specialized equipment already installed within the SFPD Chevy Tahoe, it is estimated to add a total value of $29,600.MFD has submitted a bid of $55,000, which was accepted by SFPD pending Council approval; and
WHEREAS, in addition to the bid amount, MFD will be responsible for paying $5,000 to support vehicle licensing fees and applying department logo decals to put the #18..
- 773 -
2 02/14/2023/Fire/AErnst/Item # 2023-xxx
vehicle into service. Combined, these costs are estimated at approximately $60,000 and are budgeted within the department in the General Fund.
NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves the purchase of the 2019 Chevrolet Tahoe SUV to Salida Fire Protection District (SFPD), Salida, CA, for a cost not to exceed $60,000.
BE IT FURTHER RESOLVED, that the Purchasing Manager, or her designee, is hereby authorized to issue the Purchase Order.
The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 14th day of February 2023, 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: _____________________________
DIANE NAYARES-PEREZ, City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: _______________________________________
JOSE M. SANCHEZ, City Attorney
#18..
- 774 -
#18..
- 775 -
#18..
- 776 -
#18..
- 777 -
#18..
- 778 -
#18..
- 779 -
#18..
- 780 -
#18..
- 781 -
#18..
- 782 -
#18..
- 783 -
#18..
- 784 -
#18..
- 785 -
#18..
- 786 -
CITY OF MODESTO
COUNCIL AGENDA REPORT
DATE OF MEETING:
February 14, 2023
Date: January 24, 2023
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: Brandon Gillespie, Chief of Police
SUBJECT: Modesto Police Hiring and Recruitment Incentive Program CONTACT: Chris Adams, Lieutenant, [email protected], 209-572-9500 DESCRIPTION:
Consider approving the revisions and additions to the Modesto Police Department’s Hiring and Recruiting Incentive Program, increasing the estimated annual allocated amount by $365,000 to a new estimated annual total of $415,000; and rescinding Resolution Nos. 2014-467 and 2016- 378. (Funding Source: General Fund)
STRATEGIC PLAN ELEMENT:
The recommended action supports the City’s 2020-2025 Strategic Plan Initiative: Build a HighPerforming Organization by Attracting and Retaining High-Performing Employees.
BACKGROUND:
The Modesto Police Department (MPD) continues to face recruitment challenges for several employment position allocations, including Lateral Police Officers, Academy Recruits, and several non-sworn professional staff entry level positions. Agencies in the region and state are also experiencing these same challenges, and the Modesto Police Department has explored methods of remaining competitive in this declining market. Although increased internal hiring efficiencies and stronger recruitment efforts are underway, additional recruitment incentives are still needed to meet the critical need to urgently fill vacant positions.
Unfortunately, many law enforcement agencies have seen a sharp decline in applicants interested in becoming sworn police officers. The Modesto Police Department processed 2,200 applicants for sworn positions in 2015. Each year following, however, that number has steadily declined, ending with 571 applicants in 2021 and 522 applicants in 2022 year-to-date.
MPD currently has 25 vacant police officer positions, with an additional 8 frozen police officer positions, which has created critical staffing issues in both the Field Operations and Investigative Services Divisions. Additionally, professional staff positions continue to be a challenge for which to recruit and hire. Moreover, MPD has 12.5 vacant positions in the professional staff ranks, including Crime Analysts, Community Service Officers, and Police #19..
- 787 -
City Council, February 14, 2023
Modesto Police Hiring and Recruitment Incentive Program
Support Specialists. In the last two years, MPD has conducted multiple recruitments, including continuous recruitments for the position of Support Specialist and have only been able to hire six new employees, while the department continues to hold five vacancies. Police Support Specialists staff the MPD’s Records Unit which is a 24-hour, 7-day per week, operation and these vacancies have created critical staffing levels and an increased demand for overtime.
In November of 2014, by Resolution No. 2014-467, Council approved a Hiring and Recruitment Incentive Program to include $5,500 to be paid to a Lateral Police Officer, a $2,000 incentive to be paid to any Police Officer Recruit or Trainee (entry level), and a $1,500 incentive to any full time MPD Employee who is able to successfully recruit and mentor a sworn officer candidate. A total of $90,000 was approved to be allocated to this Hiring and Recruitment Incentive program.
In September of 2016, by Resolution No. 2016-378, Council approved the increase of the Lateral Police Officer Incentive to $15,000. In recent years, the department has not provided the $2,000 incentive to Police Officer Recruit or Trainee (entry level), but has continued both the Lateral Incentive and the $1,500 incentive paid to any employee who recruits and mentors a sworn officer position. The department currently budgets $50,000 per year to support the incentive program.
DISCUSSION:
In the Summer of 2022, MPD formed a committee that included both sworn and professional staff to examine our current Hiring and Recruitment Incentive Program, research other programs in the State of California, and to make recommendations to Executive Staff regarding any changes or additions that could increase department recruitment and retention efforts. The committee’s efforts focused primarily on making Modesto competitive in the law enforcement job market based on surrounding agency models, as well as determining what is most important to employees as they seek employment at any organization. The Modesto Police Department has identified enhancements and additions to the program based on the committee’s work and input from Executive Staff.
Staff recommends the modifications and additions to the Hiring and Recruitment Incentive Program as outlined below. It is important to note that each set milestone in each category must be met before the cash is dispersed. For all cash incentives, employees who voluntarily leave the City of Modesto would have a pro-rated repayment agreement over the course of five (5) years, which is a safeguard currently in place for existing incentives. The Support Division Assistant Division Commander and the Recruitment Sergeant are responsible for monitoring both the milestone payments as well as the repayment schedules in the event an employee voluntarily separates.
Lateral Incentive –Currently, the Lateral Police Officer (PO) Incentive is $15,000; paid $10,000 at date of hire and $5,000 on the officer’s five-year anniversary. MPD is proposing to increase the Lateral Officer Hiring Incentive to $20,000. The payment schedule would be modified so that the Lateral Police Officer (PO) would be paid $5,000 at hire, $5,000 when they complete the field training program, $5,000 at the end of their probationary period, and $5,000 upon completion of their two-year anniversary. The repayment schedule for this incentive, should the employee leave prior to the end of the 5th year is outlined as follows:
TIMEFRAME AMOUNT OWED
Hire to < 6 months $5,000.00
#19..
- 788 -
City Council, February 14, 2023
Modesto Police Hiring and Recruitment Incentive Program
6 months to < 1 year $10,000.00
1 year to < 18 months $12,500.00
18 months to < 2 years $15,000.00
2 years to < 2.5 years $12,500.00
2.5 years to < 3 years $10,000.00
3 years to < 3.5 years $7,500.00
3.5 years to < 4 years $5,000.00
4 years to < 4.5 years $2,500.00
4.5 years to < 5 years $1,000.00
Recruitment Incentive – Any current full-time City of Modesto employee who is able to successfully recruit a Police Officer Recruit (POR), Police Officer Trainee (POT), or Lateral Police Officer (PO) to Modesto Police Department will receive their choice of a one-time payment of $3,000 or 40 hours of leave in a special leave time bank (the hours would not be cashable at any time). The employee would receive $1,000 on the candidate’s hire date and $2,000 when the candidate completes the Field Training Program. If the employee chooses the 40 hours of leave, they will receive 20 hours on the date of hire and 20 hours when the candidate completes the Field Training Program. This modifies the current recruitment incentive, which is solely for Police Department employees who are paid $1,500 if they successfully recruit a Police Officer Recruit (POR), Police Officer Trainee (POT), or Police Officer (PO); $750 on the date of hire and $750 when the candidate completes their probationary period. There is no repayment schedule for this incentive. If an employee leaves City service prior to the second payout, they would not receive the second installment. If the employee elected the special leave time bank in lieu of the cash incentive, those hours are not cashable at any time and would therefore be forfeited upon separation if not used.
Sick/Vacation Front Loading for Laterals – All Lateral Police Officers (PO) will have 40 hours of sick leave and 40 hours of vacation time placed in their leave balances upon date of hire.
However, the employee would not accrue additional time until their time at the department equaled the accrual of 40 hours of each, based on their accrual rate. The sick leave hours are not cashable at any point and the vacation hours would not be cashable until such a time as the employee would have accrued the time. There are no expiration dates on either leave type.
There is no repayment schedule for this incentive.
Sick/Vacation Front Loading for FTE’s – All full-time employees (other than the abovementioned Lateral Police Officer) will begin employment with 20 hours of sick leave and 20 hours of vacation time placed in their leave balances upon date of hire. The employee would not accrue additional time until their time at the department equaled the accrual of 20 hours of each based on their accrual rate. The sick leave hours are not cashable at any point and the vacation hours would not be cashable until such a time as the employee would have accrued the time.
There are no expiration dates on either leave type. There is no repayment schedule for this incentive.
#19..
- 789 -
City Council, February 14, 2023
Modesto Police Hiring and Recruitment Incentive Program
Police Support Specialist, Community Service Officer, and Animal Control Officer Hiring Incentive – All employees hired as a Police Support Specialist (PSS), Community Service Officer (CSO), or Animal Control Officer (ACO) would receive a $2,500 hiring incentive. $1,000 would be paid at date of hire and $1,500 upon completion of the Field Training Program. The repayment schedule for this incentive, should the employee leave prior to the end of the 5th year is outlined as follows:
TIMEFRAME AMOUNT OWED
Hire to < 6 months $1,000.00
6 months to < 1 year $2,200.00
1 year to < 18 months $1,900.00
18 months to < 2 years $1,700.00
2 years to < 2.5 years $1,500.00
2.5 years to < 3 years $1,300.00
3 years to < 3.5 years $1,100.00
3.5 years to < 4 years $900.00
4 years to < 4.5 years $700.00
4.5 years to < 5 years $500.00
Sworn Hiring Incentive – All employees hired as a Police Officer Recruit (POR) or Police Officer Trainee (POT) would receive a $5,000 hiring incentive. For POR, $2,500 would be paid upon successful completion of the police academy, and $2,500 would be paid upon completion of the Field Training Program. For POT, $2,500 would be paid upon their date of hire and $2,500 would be paid upon completion of the Field Training Program. The repayment schedule for this incentive, should the employee leave prior to the end of the 5th year is outlined as follows:
TIMEFRAME AMOUNT OWED
Academy Graduation < 6
months $2,500.00
6 months to < 1 year $4,500.00
1 year to < 18 months $4,000.00
18 months to < 2 years $3,500.00
2 years to < 2.5 years $3,000.00
#19..
- 790 -
City Council, February 14, 2023
Modesto Police Hiring and Recruitment Incentive Program
2.5 years to < 3 years $2,500.00
3 years to < 3.5 years $2,000.00
3.5 years to < 4 years $1,500.00
4 years to < 4.5 years $1,000.00
4.5 years to < 5 years $500.00
Lateral Service Credit – Any lateral hire to any position assigned to the Police Department (sworn or non-sworn/professional) will accrue leave balances based on their years of experience in a prior public safety position. For example, a police officer or CSO who laterals to the City of Modesto and has 10 years of experience in the same classification at another agency, will accrue leave at the rate of a 10-year tenured employee with the City of Modesto based on their appropriate bargaining group’s Memorandum of Understanding. There is no repayment schedule for this incentive.
Sworn Military Hiring Incentive – All employees hired as a Police Officer Recruit (POR), Police Officer Trainee (POT), or Police Officer Lateral (PO) who have served in any branch of the United States Military and received an Honorable or General Discharge as denoted on the DD214, would receive a $5,000 hiring incentive. For POR, $2,500 would be paid after successful completion of the academy and $2,500 would be paid after completion of the Probationary Period. For POT, $2,500 would be paid upon hire and $2,500 would be paid after completion of the Probationary Period. For PO, $2,500 would be paid upon hire and $2,500 would be paid after completion of the Probationary Period. The repayment schedule for this incentive, should the employee leave prior to the end of the 5th year is outlined as follows by position type:
For Police Officer Recruit or Trainee:
TIMEFRAME AMOUNT OWED
Academy Graduation < 6
months $2,500.00
6 months to < 1 year $2,000.00
1 year to < 18 months $1,500.00
18 months to < 2 years $3,500.00
2 years to < 2.5 years $3,000.00
2.5 years to < 3 years $2,500.00
3 years to < 3.5 years $2,000.00
3.5 years to < 4 years $1,500.00
4 years to < 4.5 years $1,000.00
#19..
- 791 -
City Council, February 14, 2023
Modesto Police Hiring and Recruitment Incentive Program
4.5 years to < 5 years $500.00
For Lateral Police Officer:
TIMEFRAME AMOUNT OWED
Date of Hire < 6 months $2,500.00
6 months to < 1 year $2,000.00
1 year to < 18 months $4,000.00
18 months to < 2 years $3,500.00
2 years to < 2.5 years $3,000.00
2.5 years to < 3 years $2,500.00
3 years to < 3.5 years $2,000.00
3.5 years to < 4 years $1,500.00
4 years to < 4.5 years $1,000.00
4.5 years to < 5 years $500.00
Non-Sworn Military Hiring Incentive – All employees hired as a Police Support Specialist (PSS), Community Service Officer (CSO), or Animal Control Officer (ACO) who have served in any branch of the United States Military and received an Honorable or General Discharge as denoted on the DD214, would receive a $2,000 military hiring incentive. $1,000 would be paid at time of hire and $1,000 after completion of the Probationary Period. The repayment schedule for this incentive, should the employee leave prior to the end of the 5th year is outlined as follows:
TIMEFRAME AMOUNT OWED
Hire to < 6 months $1,000.00
6 months to < 1 year $900.00
1 year to < 18 months $800.00
18 months to < 2 years $1,700.00
2 years to < 2.5 years $1,500.00
2.5 years to < 3 years $1,300.00
3 years to < 3.5 years $1,100.00
#19..
- 792 -
City Council, February 14, 2023
Modesto Police Hiring and Recruitment Incentive Program
3.5 years to < 4 years $900.00
4 years to < 4.5 years $700.00
4.5 years to < 5 years $500.00
Additionally, staff recommends rescinding Resolution Numbers 2014-467 and 2016-378 in order to provide a comprehensive single resolution that outlines the updated and enhanced Hiring and Recruiting Incentives Program as outlined above.
FISCAL IMPACT:
Below is a general breakdown of the fiscal projection for the proposed programs. It should be noted, however, that not all payouts will occur in the same fiscal year, inevitably lowering the actual amounts paid versus the maximum amount allotted. How the program is utilized in a given fiscal year will depend upon the positions available for hiring and the candidates interested. As such, the department will work within the annual allowable spending total to best facilitate recruitment and hiring within the defined categories as listed below.
Funding for FY 2022-2023 will come from the Police Department’s current “Appropriation A” savings due to the high vacancy rate. Funding for future Fiscal Years will be budgeted at the $415,000 amount during the annual budgeting process.
COMMITTEE RECOMMENDATION:
This item was presented to Finance Committee on January 23, 2023, and was recommended to forward to Council for approval.
Incentive Type Position Amount
Lateral Incentive (Sworn) Police Officer $20,000
Recruitment Incentive
(for POR, POT and PO positions)
All City FTE’s $3,000 or 40 hours of Specialized
Time Bank
Sick/Vacation Front Loading Lateral Police Officers 40 Hours Sick/40 Hours Vacation Sick/Vacation Front Loading All FTE’s
(Except Lateral Police Officer)
20 Hours Sick/20 Hours Vacation
Hiring Incentive (Non-sworn) PSS $2,500
Hiring Incentive (Non-sworn) CSO $2,500
Hiring Incentive (Non-sworn) ACO $2,500
Hiring Incentive (Sworn) POR/POT $5,000
Lateral Service Credit
(Sworn and Non-Sworn)
All Public Safety FTE’s
(Sworn and Non-Sworn)
Equal to Service Credit
Military Hiring Incentive (Sworn) POR/POT/PO $5,000
Military Hiring Incentive (Non -Sworn) PSS/CSO/ACO $2,000 Estimated $415,000 Annually
#19..
- 793 -
City Council, February 14, 2023
Modesto Police Hiring and Recruitment Incentive Program
RECOMMENDED COUNCIL ACTION:
Staff Recommendations:
Resolution approving the revisions and additions to the Modesto Police Department’s Hiring and Recruitment Incentive Program and increasing the estimated annual allocated amount by $365,000 to a new estimated annual total of $415,000; and rescinding Resolution Nos. 2014- 467 and 2016-378.
Approved by:
Brandon Gillespie, Chief of Police
Joseph P. Lopez, City Manager
Attachments:
1. Resolution
2. Incentive and Repayment Agreements Ex. A
#19..
- 794 -
MODESTO CITY COUNCIL
RESOLUTION NO. 2023-XX
RESOLUTION APPROVING THE REVISIONS AND ADDITIONS TO THE MODESTO POLICE DEPARTMENT’S HIRING AND RECRUITMENT
INCENTIVE PROGRAM AND INCREASING THE ESTIMATED ANNUAL
ALLOCATED AMOUNT BY $365,000 TO A NEW ESTIMATED ANNUAL
TOTAL OF $415,000; AND RESCINDING RESOLUTION NOS. 2014-467 AND 2016-378
WHEREAS, in November of 2014, by Resolution No. 2014-467, Council approved a Hiring and Recruitment Incentive Program to include $5,500 to be paid to a Lateral Police Officer, a $2,000 incentive to be paid to any Police Officer Recruit or Trainee (entry level), and a $1,500 incentive to any full time Modesto Police Department (MPD) employee who is able to successfully recruit and mentor a sworn officer candidate; and
WHEREAS, in September of 2016, by Resolution No. 216-378, Council approved the increase of the Lateral Police Officer incentive to $15,000; and WHEREAS, the MPD continues to face recruitment challenges for several employment position allocations, including Lateral Police Officers, Academy Recruits, and several non-sworn professional staff entry level positions; and WHEREAS, agencies in the region and state are also experiencing these same challenges, and the Modesto Police Department has explored methods of remaining competitive in this declining market; and
WHEREAS, although increased internal hiring efficiencies and stronger recruitment efforts are underway, additional recruitment incentives are still needed to meet the critical need to urgently fill vacant positions; and #19..
- 795 -
WHEREAS, in the summer of 2022, MPD formed a committee that included both sworn and professional staff to examine the current Hiring and Recruitment Incentive Program, research other programs in the State, and to make recommendations regarding any changes or additions that could increase department recruitment and retention efforts; and
WHEREAS, staff recommends the modifications and additions to the Hiring and Recruitment Incentive Program as outlined below:
WHEREAS, how the program is utilized in a given fiscal year will depend upon the positions available for hiring and the candidates interested; and WHEREAS, as such, the department will work within the annual allowable spending total to best facilitate recruitment and hiring within the defined categories as listed above; and
Incentive Type Position Amount
Lateral Incentive (Sworn) Police Officer $20,000
Recruitment Incentive
(for POR, POT and PO positions)
All City FTE’s $3,000 or 40 hours of Specialized
Time Bank
Sick/Vacation Front Loading Lateral Police Officers 40 Hours Sick/40 Hours Vacation Sick/Vacation Front Loading All FTE’s
(Except Lateral Police Officer)
20 Hours Sick/20 Hours Vacation
Hiring Incentive (Non-sworn) PSS $2,500
Hiring Incentive (Non-sworn) CSO $2,500
Hiring Incentive (Non-sworn) ACO $2,500
Hiring Incentive (Sworn) POR/POT $5,000
Lateral Service Credit
(Sworn and Non-Sworn)
All Public Safety FTE’s
(Sworn and Non-Sworn)
Equal to Service Credit
Military Hiring Incentive (Sworn) POR/POT/PO $5,000
Military Hiring Incentive (Non -Sworn) PSS/CSO/ACO $2,000 Estimated $415,000 Annually
#19..
- 796 -
WHEREAS, funding for FY 2022-2023 will come from the MPD’s current “Appropriation A” savings due to the high vacancy rate; and WHEREAS, funding for future Fiscal Years will be budgeted at the $415,000 amount during the annual budgeted process; and WHEREAS, each cash incentive category has set milestones that must be met before cash is dispersed, and there are set pro-rated repayment schedules (for employees who voluntarily leave City employment) – both the milestones and the repayment schedules are outlined in agreements for each incentive category as shown in Exhibit A, attached.
NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves the revisions and additions to the Modesto Police Department’s Hiring and Recruitment Incentive Program and increasing the estimated annual allocated amount by $365,000 to a new estimated annual total of $415,000.
BE IT FURTHER RESOLVED, Resolution Nos. 2014-467 and 2016-378 are hereby rescinded by this Resolution.
The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 14th day of February 2023, 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:
#19..
- 797 -
ATTEST: _____________________________
DIANE NAYARES-PEREZ, CMC,
City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: _________________________________
JOSE M. SANCHEZ, City Attorney
#19..
- 798 -
Modesto Police Department
ANIMAL CONTROL OFFICER INCENTIVE
REPAYMENT AGREEMENT
The Modesto Police Department offers a voluntary monetary incentive at the time of successful employment into the Animal Control Officer classification listed below. Eligibility requires acknowledgement and execution of this Repayment Agreement. Participation in the Incentive Program is not a required component of employment with the City of Modesto.
The monetary incentive listed below is a contractual four (4) year incentive package. Incentive recipients choosing to voluntarily leave employment with the Modesto Police Department in advance of their fifth-year anniversary (four complete years of service) shall agree to repay the applicable prorated portion of the monetary incentive from the time of their voluntary departure. (Refer to the attached Repayment Schedule.) Animal Control Officer Incentive
$1,000 at the time of successful hiring
$1,500 at the time of successful completion of the Field Training Program
ACKNOWLEDGEMENT
I hereby acknowledge that participation in the Incentive Program is voluntary. I understand that eligible monetary incentives must be approved by the Chief of Police, Administrative Services Director and Director of Finance, or designees, prior to disbursement.
Furthermore, I agree to repay (on a prorated basis) the applicable portion of my monetary incentive upon voluntary separation from an Animal Control Officer classification prior to the fifth anniversary of the date of hire/appointment. I also understand and acknowledge that my final paycheck will be reduced by the final prorated amount owed should voluntary separation occur. If the final paycheck is insufficient to cover the balance owed, I also agree that I am responsible for payment of the remaining balance.
Name of Recipient:
Date:
Recipient Signature
Routing: MPD Personnel File (original agreement)
Support Division Captain
Support Division Assistant Division Commander
Support Division Administrative Assistant
#19..
- 799 -
Modesto Police Department
ANIMAL CONTROL OFFICER INCENTIVE
REPAYMENT AGREEMENT
REPAYMENT SCHEDULE
TIMEFRAME AMOUNT OWED
Hire to < 6 months $1,000.00
6 months to < 1 year $2,200.00
1 year to < 18 months $1,900.00
18 months to < 2 years $1,700.00
2 years to < 2.5 years $1,500.00
2.5 years to < 3 years $1,300.00
3 years to < 3.5 years $1,100.00
3.5 years to < 4 years $900.00
4 years to < 4.5 years $700.00
4.5 years to < 5 years $500.00
#19..
- 800 -
Modesto Police Department
COMMUNITY SERVICE OFFICER INCENTIVE
REPAYMENT AGREEMENT
The Modesto Police Department offers a voluntary monetary incentive at the time of successful employment into the Community Service Officer classification listed below. Eligibility requires acknowledgement and execution of this Repayment Agreement. Participation in the Incentive Program is not a required component of employment with the City of Modesto.
The monetary incentive listed below is a contractual four (4) year incentive package. Incentive recipients choosing to voluntarily leave employment with the Modesto Police Department in advance of their fifth-year anniversary (four complete years of service) shall agree to repay the applicable prorated portion of the monetary incentive from the time of their voluntary departure. (Refer to the attached Repayment Schedule.) Community Service Officer Incentive
$1,000 at the time of successful hiring
$1,500 at the time of successful completion of the Field Training Program
ACKNOWLEDGEMENT
I hereby acknowledge that participation in the Incentive Program is voluntary. I understand that eligible monetary incentives must be approved by the Chief of Police, Administrative Services Director and Director of Finance, or designees, prior to disbursement.
Furthermore, I agree to repay (on a prorated basis) the applicable portion of my monetary incentive upon voluntary separation from a Community Service Officer classification prior to the fifth anniversary of the date of hire/appointment. I also understand and acknowledge that my final paycheck will be reduced by the final prorated amount owed should voluntary separation occur. If the final paycheck is insufficient to cover the balance owed, I also agree that I am responsible for payment of the remaining balance.
Name of Recipient:
Date:
Recipient Signature
Routing: MPD Personnel File (original agreement)
Support Division Captain
Support Division Assistant Division Commander
Support Division Administrative Assistant
#19..
- 801 -
Modesto Police Department
COMMUNITY SERVICE OFFICER INCENTIVE
REPAYMENT AGREEMENT
REPAYMENT SCHEDULE
TIMEFRAME AMOUNT OWED
Hire to < 6 months $1,000.00
6 months to < 1 year $2,200.00
1 year to < 18 months $1,900.00
18 months to < 2 years $1,700.00
2 years to < 2.5 years $1,500.00
2.5 years to < 3 years $1,300.00
3 years to < 3.5 years $1,100.00
3.5 years to < 4 years $900.00
4 years to < 4.5 years $700.00
4.5 years to < 5 years $500.00
#19..
- 802 -
Modesto Police Department
LATERAL POLICE OFFICER INCENTIVE
REPAYMENT AGREEMENT
The Modesto Police Department offers a voluntary monetary incentive at the time of successful employment into the Police Officer classification listed below. Eligibility requires acknowledgement and execution of this Repayment Agreement. Participation in the Incentive Program is not a required component of employment with the City of Modesto.
The monetary incentive listed below is a contractual four (4) year incentive package. Incentive recipients choosing to voluntarily leave employment with the Modesto Police Department in advance of their fifth-year anniversary (four complete years of service) shall agree to repay the applicable prorated portion of the monetary incentive from the time of their voluntary departure. (Refer to the attached Repayment Schedule.) Lateral Police Officer Incentive
$5,000 at the time of successful hiring
$5,000 at the time of successful completion of the Field Training Program $5,000 at the time of successful completion of probationary period $5,000 at the completion of two years of service
ACKNOWLEDGEMENT
I hereby acknowledge that participation in the Incentive Program is voluntary. I understand that eligible monetary incentives must be approved by the Chief of Police, Administrative Services Director and Director of Finance, or designees, prior to disbursement.
Furthermore, I agree to repay (on a prorated basis) the applicable portion of my monetary incentive upon voluntary separation from a Police Officer classification prior to the fifth anniversary of the date of hire/appointment. I also understand and acknowledge that my final paycheck will be reduced by the final prorated amount owed should voluntary separation occur. If the final paycheck is insufficient to cover the balance owed, I also agree that I am responsible for payment of the remaining balance.
Name of Recipient:
Date:
Recipient Signature
Routing: MPD Personnel File (original agreement)
Support Division Captain
Support Division Assistant Division Commander
Support Division Administrative Assistant
#19..
- 803 -
Modesto Police Department
LATERAL POLICE OFFICER INCENTIVE
REPAYMENT AGREEMENT
REPAYMENT SCHEDULE
TIMEFRAME AMOUNT OWED
Hire to < 6 months $5,000.00
6 months to < 1 year $10,000.00
1 year to < 18 months $12,500.00
18 months to < 2 years $15,000.00
2 years to < 2.5 years $12,500.00
2.5 years to < 3 years $10,000.00
3 years to < 3.5 years $7,50000
3.5 years to < 4 years $5,000.00
4 years to < 4.5 years $2,500.00
4.5 years to < 5 years $1,000.00
#19..
- 804 -
Modesto Police Department
NON-SWORN MILITARY INCENTIVE
REPAYMENT AGREEMENT
The Modesto Police Department offers a voluntary monetary incentive at the time of successful employment into the Community Service Officer (CSO), Police Support Specialist (PSS), or Animal Control Officer (ACO) classification for those who have served in the United States Military and received an Honorable, General, or Medical Discharge. Eligibility requires acknowledgement and execution of this Repayment Agreement.
Participation in the Incentive Program is not a required component of employment with the City of Modesto.
The monetary incentive listed below is a contractual four (4) year incentive package. Incentive recipients choosing to voluntarily leave employment with the Modesto Police Department in advance of their fifth-year anniversary (four complete years of service) shall agree to repay the applicable prorated portion of the monetary incentive from the time of their voluntary departure. (Refer to the attached Repayment Schedule.) CSO, PSS, and ACO Military Incentive
$1,000 at the time of successful hiring
$1,000 at the time of probationary period
ACKNOWLEDGEMENT
I hereby acknowledge that participation in the Incentive Program is voluntary. I understand that eligible monetary incentives must be approved by the Chief of Police, Administrative Services Director and Director of Finance, or designees, prior to disbursement.
Furthermore, I agree to repay (on a prorated basis) the applicable portion of my monetary incentive upon voluntary separation from a Community Service Officer, Police Support Specialist, or Animal Control Officer classification prior to the fifth anniversary of the date of hire/appointment. I also understand and acknowledge that my final paycheck will be reduced by the final prorated amount owed should voluntary separation occur. If the final paycheck is insufficient to cover the balance owed, I also agree that I am responsible for payment of the remaining balance.
Name of Recipient:
Date:
Recipient Signature
Routing: MPD Personnel File (original agreement)
Support Division Captain
Support Division Assistant Division Commander
Support Division Administrative Assistant
#19..
- 805 -
Modesto Police Department
NON-SWORN MILITARY INCENTIVE
REPAYMENT AGREEMENT
REPAYMENT SCHEDULE
TIMEFRAME AMOUNT OWED
Hire to < 6 months $1,000.00
6 months to < 1 year $900.00
1 year to < 18 months $800.00
18 months to < 2 years $1,700.00
2 years to < 2.5 years $1,500.00
2.5 years to < 3 years $1,300.00
3 years to < 3.5 years $1,100.00
3.5 years to < 4 years $900.00
4 years to < 4.5 years $700.00
4.5 years to < 5 years $500.00
#19..
- 806 -
Modesto Police Department
POLICE OFFICER LATERAL MILITARY
REPAYMENT AGREEMENT
The Modesto Police Department offers a voluntary monetary incentive at the time of successful employment into the Police Officer Lateral (PO) classification for those who have served in the United States Military and received an Honorable, General, or Medical Discharge. Eligibility requires acknowledgement and execution of this Repayment Agreement. Participation in the Incentive Program is not a required component of employment with the City of Modesto.
The monetary incentive listed below is a contractual four (4) year incentive package. Incentive recipients choosing to voluntarily leave employment with the Modesto Police Department in advance of their fifth-year anniversary (four complete years of service) shall agree to repay the applicable prorated portion of the monetary incentive from the time of their voluntary departure. (Refer to the attached Repayment Schedule.) Police Officer Lateral Military Incentive
$2,500 on date of hire
$2,500 at the time of successful completion of the Probationary Period
ACKNOWLEDGEMENT
I hereby acknowledge that participation in the Incentive Program is voluntary. I understand that eligible monetary incentives must be approved by the Chief of Police, Administrative Services Director and Director of Finance, or designees, prior to disbursement.
Furthermore, I agree to repay (on a prorated basis) the applicable portion of my monetary incentive upon voluntary separation from a Police Officer Lateral (PO) classification prior to the fifth anniversary of the date of hire/appointment. I also understand and acknowledge that my final paycheck will be reduced by the final prorated amount owed should voluntary separation occur. If the final paycheck is insufficient to cover the balance owed, I also agree that I am responsible for payment of the remaining balance.
Name of Recipient:
Date:
Recipient Signature
Routing: MPD Personnel File (original agreement)
Support Division Captain
Support Division Assistant Division Commander
Support Division Administrative Assistant
#19..
- 807 -
Modesto Police Department
POLICE OFFICER LATERAL MILITARY
REPAYMENT AGREEMENT
REPAYMENT SCHEDULE
TIMEFRAME AMOUNT OWED
Date of Hire < 6 months $2,500.00
6 months to < 1 year $2,000.00
1 year to < 18 months $4,000.00
18 months to < 2 years $3,500.00
2 years to < 2.5 years $3,000.00
2.5 years to < 3 years $2,500.00
3 years to < 3.5 years $2,000.00
3.5 years to < 4 years $1,500.00
4 years to < 4.5 years $1,000.00
4.5 years to < 5 years $500.00
#19..
- 808 -
Modesto Police Department
POLICE OFFICER RECRUIT INCENTIVE
REPAYMENT AGREEMENT
The Modesto Police Department offers a voluntary monetary incentive at the time of successful employment into the Police Officer Recruit classification listed below. Eligibility requires acknowledgement and execution of this Repayment Agreement. Participation in the Incentive Program is not a required component of employment with the City of Modesto.
The monetary incentive listed below is a contractual four (4) year incentive package. Incentive recipients choosing to voluntarily leave employment with the Modesto Police Department in advance of their fifth-year anniversary (four complete years of service) shall agree to repay the applicable prorated portion of the monetary incentive from the time of their voluntary departure. (Refer to the attached Repayment Schedule.) Police Officer Recruit Incentive
$2,500 at the time of Academy Graduation
$2,500 at the time of successful completion of the Field Training Program
ACKNOWLEDGEMENT
I hereby acknowledge that participation in the Incentive Program is voluntary. I understand that eligible monetary incentives must be approved by the Chief of Police, Administrative Services Director and Director of Finance, or designees, prior to disbursement.
Furthermore, I agree to repay (on a prorated basis) the applicable portion of my monetary incentive upon voluntary separation from a Police Officer/Police Officer Trainee/Police Officer Recruit classification prior to the fifth anniversary of the date of hire/appointment. I also understand and acknowledge that my final paycheck will be reduced by the final prorated amount owed should voluntary separation occur. If the final paycheck is insufficient to cover the balance owed, I also agree that I am responsible for payment of the remaining balance.
Name of Recipient:
Date:
Recipient Signature
Routing: MPD Personnel File (original agreement)
Support Division Captain
Support Division Assistant Division Commander
Support Division Administrative Assistant
#19..
- 809 -
Modesto Police Department
POLICE OFFICER RECRUIT INCENTIVE
REPAYMENT AGREEMENT
REPAYMENT SCHEDULE
TIMEFRAME AMOUNT OWED
Academy Graduation < 6
months $2,500.00
6 months to < 1 year $4,500.00
1 year to < 18 months $4,000.00
18 months to < 2 years $3,500.00
2 years to < 2.5 years $3,000.00
2.5 years to < 3 years $2,500.00
3 years to < 3.5 years $2,000.00
3.5 years to < 4 years $1,500.00
4 years to < 4.5 years $1,000.00
4.5 years to < 5 years $500.00
#19..
- 810 -
Modesto Police Department
POLICE OFFICER RECRUIT MILITARY INCENTIVE
REPAYMENT AGREEMENT
The Modesto Police Department offers a voluntary monetary incentive at the time of successful employment into the Police Officer Recruit classification listed below for those who have served in the United States Military and received an Honorable, General, or Medical Discharge. Eligibility requires acknowledgement and execution of this Repayment Agreement. Participation in the Incentive Program is not a required component of employment with the City of Modesto.
The monetary incentive listed below is a contractual four (4) year incentive package. Incentive recipients choosing to voluntarily leave employment with the Modesto Police Department in advance of their fifth-year anniversary (four complete years of service) shall agree to repay the applicable prorated portion of the monetary incentive from the time of their voluntary departure. (Refer to the attached Repayment Schedule.) Police Officer Recruit Military Incentive
$2,500 at the time of Academy Graduation
$2,500 at the time of successful completion of the Probationary Period
ACKNOWLEDGEMENT
I hereby acknowledge that participation in the Incentive Program is voluntary. I understand that eligible monetary incentives must be approved by the Chief of Police, Administrative Services Director and Director of Finance, or designees, prior to disbursement.
Furthermore, I agree to repay (on a prorated basis) the applicable portion of my monetary incentive upon voluntary separation from a Police Officer Recruit classification prior to the fifth anniversary of the date of hire/appointment. I also understand and acknowledge that my final paycheck will be reduced by the final prorated amount owed should voluntary separation occur. If the final paycheck is insufficient to cover the balance owed, I also agree that I am responsible for payment of the remaining balance.
Name of Recipient:
Date:
Recipient Signature
Routing: MPD Personnel File (original agreement)
Support Division Captain
Support Division Assistant Division Commander
Support Division Administrative Assistant
#19..
- 811 -
Modesto Police Department
POLICE OFFICER RECRUIT MILITARY INCENTIVE
REPAYMENT AGREEMENT
REPAYMENT SCHEDULE
TIMEFRAME AMOUNT OWED
Academy Graduation < 6
months $2,500.00
6 months to < 1 year $2,000.00
1 year to < 18 months $1,500.00
18 months to < 2 years $3,500.00
2 years to < 2.5 years $3,000.00
2.5 years to < 3 years $2,500.00
3 years to < 3.5 years $2,000.00
3.5 years to < 4 years $1,500.00
4 years to < 4.5 years $1,000.00
4.5 years to < 5 years $500.00
#19..
- 812 -
Modesto Police Department
POLICE OFFICER TRAINEE INCENTIVE
REPAYMENT AGREEMENT
The Modesto Police Department offers a voluntary monetary incentive at the time of successful employment into the Police Officer Trainee classification listed below. Eligibility requires acknowledgement and execution of this Repayment Agreement. Participation in the Incentive Program is not a required component of employment with the City of Modesto.
The monetary incentive listed below is a contractual four (4) year incentive package. Incentive recipients choosing to voluntarily leave employment with the Modesto Police Department in advance of their fifth-year anniversary (four complete years of service) shall agree to repay the applicable prorated portion of the monetary incentive from the time of their voluntary departure. (Refer to the attached Repayment Schedule.) Police Officer Trainee Incentive
$2,500 at the date of hire
$2,500 at the time of successful completion of the Field Training Program
ACKNOWLEDGEMENT
I hereby acknowledge that participation in the Incentive Program is voluntary. I understand that eligible monetary incentives must be approved by the Chief of Police, Administrative Services Director and Director of Finance, or designees, prior to disbursement.
Furthermore, I agree to repay (on a prorated basis) the applicable portion of my monetary incentive upon voluntary separation from a Police Officer/Police Officer Trainee classification prior to the fifth anniversary of the date of hire/appointment. I also understand and acknowledge that my final paycheck will be reduced by the final prorated amount owed should voluntary separation occur. If the final paycheck is insufficient to cover the balance owed, I also agree that I am responsible for payment of the remaining balance.
Name of Recipient:
Date:
Recipient Signature
Routing: MPD Personnel File (original agreement)
Support Division Captain
Support Division Assistant Division Commander
Support Division Administrative Assistant
#19..
- 813 -
Modesto Police Department
POLICE OFFICER TRAINEE INCENTIVE
REPAYMENT AGREEMENT
REPAYMENT SCHEDULE
TIMEFRAME AMOUNT OWED
Hire to < 6 months $2,500.00
6 months to < 1 year $4,500.00
1 year to < 18 months $4,000.00
18 months to < 2 years $3,500.00
2 years to < 2.5 years $3,000.00
2.5 years to < 3 years $2,500.00
3 years to < 3.5 years $2,000.00
3.5 years to < 4 years $1,500.00
4 years to < 4.5 years $1,000.00
4.5 years to < 5 years $500.00
#19..
- 814 -
Modesto Police Department
POLICE OFFICER TRAINEE MILITARY
REPAYMENT AGREEMENT
The Modesto Police Department offers a voluntary monetary incentive at the time of successful employment into the Police Officer Trainee classification for those who have served in the United States Military and received an Honorable, General, or Medical Discharge. Eligibility requires acknowledgement and execution of this Repayment Agreement. Participation in the Incentive Program is not a required component of employment with the City of Modesto.
The monetary incentive listed below is a contractual four (4) year incentive package. Incentive recipients choosing to voluntarily leave employment with the Modesto Police Department in advance of their fifth-year anniversary (four complete years of service) shall agree to repay the applicable prorated portion of the monetary incentive from the time of their voluntary departure. (Refer to the attached Repayment Schedule.) Police Officer Trainee Military Incentive
$2,500 on date of hire
$2,500 at the time of successful completion of the Probationary Period
ACKNOWLEDGEMENT
I hereby acknowledge that participation in the Incentive Program is voluntary. I understand that eligible monetary incentives must be approved by the Chief of Police, Administrative Services Director and Director of Finance, or designees, prior to disbursement.
Furthermore, I agree to repay (on a prorated basis) the applicable portion of my monetary incentive upon voluntary separation from a Police Officer Trainee classification prior to the fifth anniversary of the date of hire/appointment. I also understand and acknowledge that my final paycheck will be reduced by the final prorated amount owed should voluntary separation occur. If the final paycheck is insufficient to cover the balance owed, I also agree that I am responsible for payment of the remaining balance.
Name of Recipient:
Date:
Recipient Signature
Routing: MPD Personnel File (original agreement)
Support Division Captain
Support Division Assistant Division Commander
Support Division Administrative Assistant
#19..
- 815 -
Modesto Police Department
POLICE OFFICER TRAINEE MILITARY
REPAYMENT AGREEMENT
REPAYMENT SCHEDULE
TIMEFRAME AMOUNT OWED
Date of Hire < 6 months $2,500.00
6 months to < 1 year $2,000.00
1 year to < 18 months $1,500.00
18 months to < 2 years $3,500.00
2 years to < 2.5 years $3,000.00
2.5 years to < 3 years $2,500.00
3 years to < 3.5 years $2,000.00
3.5 years to < 4 years $1,500.00
4 years to < 4.5 years $1,000.00
4.5 years to < 5 years $500.00
#19..
- 816 -
Modesto Police Department
POLICE OFFICER RECRUITMENT INCENTIVE
AGREEMENT
The Modesto Police Department offers a Recruitment incentive for full-time City of Modesto Employees. Eligibility requires that the current employee complete this form in advance of the prospective candidate’s formal application for qualifying Police Officer positions with the City of Modesto.
Name of Employee: ID/IBM #
Name of Prospective Candidate:
Position: Police Officer Lateral Police Officer Recruit Police Officer Trainee Describe the details of your recruitment efforts for the candidate listed above. Include your relationship to the candidate and the qualities and/or traits that make you believe they would be an acceptable Police Officer with the City of Modesto. Attach additional pages, if necessary. ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ #19..
- 817 -
ACKNOWLEDGEMENT
I hereby acknowledge that participation in the Recruitment Program is voluntary. I understand that eligible monetary incentives must be approved by the Chief of Police and the Director of Finance, or designees, prior to disbursement. Furthermore, I acknowledge that eligibility is contingent upon successful hiring of the prospective Police Officer Candidate and the successful completion of their Field Training Program. I understand I will receive my choice of $3,000 or 40 hours of leave in a special leave time bank (the hours would not be cashable at any time).
Please Select One:
Cash Payment – I choose to receive the cash payment and understand I will receive $1,000 on the candidate’s hire date and $2,000 when the candidate completes the Field Training Program.
I choose to receive the special leave of 40 hours and understand I will receive 20 hours on the date of hire and 20 hours when the candidate completes the Field Training Program. I understand these hours are not cashable at any time.
Name of Employee:
Date:
Employee Signature
For Internal Use Only:
Candidate’s Hire Date: ___________________________________ Candidate’s Completion of Field Training Date: _____________________________________ Routing: MPD Personnel File (original agreement)
Support Division Captain
Support Division Assistant Division Commander
Support Division Administrative Assistant
#19..
- 818 -
Modesto Police Department
SUPPORT SPECIALIST INCENTIVE
REPAYMENT AGREEMENT
The Modesto Police Department offers a voluntary monetary incentive at the time of successful employment into the Police Support Specialist classification listed below. Eligibility requires acknowledgement and execution of this Repayment Agreement. Participation in the Incentive Program is not a required component of employment with the City of Modesto.
The monetary incentive listed below is a contractual four (4) year incentive package. Incentive recipients choosing to voluntarily leave employment with the Modesto Police Department in advance of their fifth-year anniversary (four complete years of service) shall agree to repay the applicable prorated portion of the monetary incentive from the time of their voluntary departure. (Refer to the attached Repayment Schedule.) Police Support Specialist Incentive
$1,000 at the time of successful hiring
$1,500 at the time of successful completion of the Training Program
ACKNOWLEDGEMENT
I hereby acknowledge that participation in the Incentive Program is voluntary. I understand that eligible monetary incentives must be approved by the Chief of Police, Administrative Services Director and Director of Finance, or designees, prior to disbursement.
Furthermore, I agree to repay (on a prorated basis) the applicable portion of my monetary incentive upon voluntary separation from a Police Support Specialist classification prior to the fifth anniversary of the date of hire/appointment. I also understand and acknowledge that my final paycheck will be reduced by the final prorated amount owed should voluntary separation occur. If the final paycheck is insufficient to cover the balance owed, I also agree that I am responsible for payment of the remaining balance.
Name of Recipient:
Date:
Recipient Signature
Routing: MPD Personnel File (original agreement)
Support Division Captain
Support Division Assistant Division Commander
Support Division Administrative Assistant
#19..
- 819 -
Modesto Police Department
SUPPORT SPECIALIST INCENTIVE
REPAYMENT AGREEMENT
REPAYMENT SCHEDULE
TIMEFRAME AMOUNT OWED
Hire to < 6 months $1,000.00
6 months to < 1 year $2,200.00
1 year to < 18 months $1,900.00
18 months to < 2 years $1,700.00
2 years to < 2.5 years $1,500.00
2.5 years to < 3 years $1,300.00
3 years to < 3.5 years $1,100.00
3.5 years to < 4 years $900.00
4 years to < 4.5 years $700.00
4.5 years to < 5 years $500.00
#19..
- 820 -
CITY OF MODESTO
COUNCIL AGENDA REPORT
DATE OF MEETING:
February 14, 2023
Date: January 20, 2023
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: Laurie A. Smith, Director of Parks, Recreation and Neighborhoods Department SUBJECT: Dry Creek Regional Park to Tuolumne River Regional Park (TRRP) Trail Connection Design Award
CONTACT: Nathan Houx, Parks Planning and Development Manager, [email protected], 209-571-5526
DESCRIPTION:
Consider approving an Agreement with Mark Thomas & Company, Inc. to prepare construction documentation for the Dry Creek Regional Park to Tuolumne River Regional Park (TRRP) Trail Connection Project for a total amount not to exceed $511,424. (Funding Source: Parks & Air Quality Capital Facility Fee Fund)
STRATEGIC PLAN ELEMENT:
This item is consistent with the following 2020-2025 Strategic Plan Areas of Focus: Quality of Life and Governance and Service Delivery.
BACKGROUND:
The Dry Creek Regional Park (Peggy Mensinger Trail) starts at Moose/Kewin Park and continues east to Claus Road. Additionally, Tuolumne River Regional Park (TRRP) has a developed trail that starts just south of Beard Brook Park. Historically, the gap between these trails has been a significant challenge for pedestrians and bike riders over the past few decades.
There have been some informal routes to traverse this gap; however, the main goal of this project is to formalize a safe pedestrian and bicycle connection between the Dry Creek Regional Park and the TRRP. This trail section will likely require construction of a trail side retaining wall structure along South Morton Blvd and various different classifications of trail sections, including separated Class I bike trail, bike lanes, bike routes and other innovative trail solutions. #20..
- 821 -
City Council, February 14, 2023
Dry Creek Regional Park to Tuolumne River Regional Park (TRRP) Trail Connection Design Award
DISCUSSION:
In accordance with Administrative Directive 3.1, “Selection Procedures for Professional Consultants Who Provide Architectural Design & Engineering Services for Capital Projects”, staff initiated a Request for Qualifications and Proposals (RFQ/P) to perform Professional Design Consulting Services.
On October 6, 2021, the City’s Parks Planning and Development Division issued a Request for Proposals (RFP) # PRN-21-101164 for professional design consulting services for the Tuolumne River Regional Park (TRRP) Three Trails Connection Project. On November 10, 2021, staff received two (2) consultant proposals. A consultant selection committee was formed and met to review the proposals received. The committee decided that the project be split into three different sections (Section One – TRRP Riverwalk Trail - Gateway to Neece, Section Two – TRRP Riverwalk Trail - Gateway to Legion, and Section Three – Dry Creek Regional Park to TRRP Trail Connection). The committee also determined that the prospective professional design consultant, Mark Thomas & Company, Inc., is well qualified to design Section Three – Dry Creek Regional Park to TRRP Trail Connection, of the project.
In addition, staff recommends Council approve a 10% additional services budget in the amount of $46,493 to allow for additional services that may be required due to unforeseen conditions, delays or expenses for an agreement total not to exceed $511,424. This additional services budget does not commit the City to spend the additional funding, but allows the Department Director to approve change orders up to the additional services limit, without further council action.
In accordance with Modesto Municipal Code 8-3.204(a) Exceptions to Formal Bidding Requirements, this agreement is for professional services and, therefore, exempt from the bid requirement. However, staff proceeded with the RFP process pursuant to Administrative Directive 3.1.
FISCAL IMPACT:
The project design will be funded by the Parks & Air Quality Capital Facility Fee Fund. Funding is housed in Project 101233 – Dry Creek to TRRP Trail. The construction is currently not funded but completing the design of the project will make the City more competitive for grant funding to complete the construction of this project.
Revenue:
Current Budgeted Revenue (Parks & Air Quality Facility Fee Fund) $ 400,000 Additional Revenue from Parks & Air Quality Capital Facility Fee Fund $ 200,000 Total Revenue $ 600,000
Anticipated Expenses:
Mark Thomas & Company Agreement (not to exceed) $ 511,424 Current staff cost $ 17,358
Additional staff and other incidental costs (Estimated) $ 71,218 Total Anticipated Expenses $ 600,000
COMMITTEE RECOMMENDATION:
#20..
- 822 -
City Council, February 14, 2023
Dry Creek Regional Park to Tuolumne River Regional Park (TRRP) Trail Connection Design Award
This item was reviewed by the Safety and Communities Committee on January 18, 2023, and the Committee recommended the item be forwarded to Council for approval.
CEQA/NEPA REQUIREMENTS:
No environmental review is needed for this action as it is an administrative action.
Environmental review of the project will be completed as a part of the design process for this project.
RECOMMENDED COUNCIL ACTION:
Staff Recommendations:
Resolution approving an Agreement with Mark Thomas & Company, Inc. to prepare construction documentation for the Dry Creek Regional Park to Tuolumne River Regional Park (TRRP) Trail Connection Project for an amount of $464,931, plus $46,493 for additional services, if needed, for an Agreement total not to exceed $511,424, and authorizing the City Manager, or his designee, to execute the Agreement.
Approved by:
Laurie A. Smith, Director of Parks, Recreation and
Neighborhoods Department
Joseph P. Lopez, City Manager
Attachments:
1. Resolution
2. Agreement – Mark Thomas & Company, Inc.
3. Financial Interest Disclosure Form – Mark Thomas & Company, Inc. #20..
- 823 -
02/14/2023/PRN/NHoux/Item XX 1 2023-XXX
MODESTO CITY COUNCIL
RESOLUTION NO. 2023-
RESOLUTION APPROVING AN AGREEMENT WITH MARK THOMAS &
COMPANY, INC. TO PREPARE CONSTRUCTION DOCUMENTATION FOR THE
DRY CREEK REGIONAL PARK TO TUOLUMNE RIVER REGIONAL PARK (TRRP) TRAIL CONNECTION PROJECT FOR AN AMOUNT OF $464,931, PLUS $46,493 FOR
ADDITIONAL SERVICES, IF NEEDED, FOR AN AGREEMENT TOTAL NOT TO EXCEED $511,424, AND AUTHORIZING THE CITY MANAGER, OR HIS DESIGNEE,
TO EXECUTE THE AGREEMENT
WHEREAS, the Dry Creek Regional Park (Peggy Mensinger Trail) starts at Moose/Kewin Park and continues east to Claus Road; and
WHEREAS, Tuolumne River Regional Park (TRRP) has a developed trail that starts just south of Beard Brook Park; and
WHEREAS, historically, the gap between these trails has been a significant challenge for pedestrians and bike riders over the past few decades; and WHEREAS, there have been some informal routes to traverse this gap; however, the main goal of this project is to formalize a safe pedestrian and bicycle connection between the Dry Creek Regional Park and the TRRP, and
WHEREAS, this trail section will likely require construction of a trail side retaining wall structure along South Morton Blvd and various different classifications of trail sections, including separated Class I bike trail, bike lanes, bike routes and other innovative trail solutions; and
WHEREAS, in accordance with Administrative Directive 3.1, “Selection Procedures for Professional Consultants Who Provide Architectural & Engineering for Capital Projects”, staff initiated a Request for Qualifications and Proposals (RFQ/P) to perform Professional Design Consulting Services; and
#20..
- 824 -
02/14//2023/PRN/NHoux/Item XX 2 2023-XX
WHEREAS, on October 6, 2021, the City’s Parks Planning and Development Division issued a Request for Proposals (RFP) # PRN-21-101164 for professional design consulting services for the Tuolumne River Regional Park (TRRP) Three Trails Connection Project; and WHEREAS, on November 10, 2021, staff received two (2) consultant proposals, and a consultant selection committee was formed and met to review the proposals received; and WHEREAS, the committee decided that the project be split into three different sections (Section One – TRRP Riverwalk Trail - Gateway to Neece, Section Two – TRRP Riverwalk Trail - Gateway to Legion, and Section Three – Dry Creek Regional Park to TRRP Trail Connection) and determined that the prospective professional design consultant, Mark Thomas & Company, Inc., is well qualified to design Section Three – Dry Creek Regional Park to TRRP Trail Connection, of the project; and
WHEREAS, in addition, staff recommends Council approve a 10% additional services budget in the amount of $46,493 to allow for additional services that may be required, for an agreement total not to exceed $511,424; and
WHEREAS, this additional services budget does not commit the city to spend the additional funding, but allows the Department Director to approve change orders up to the additional services limit, without further council action; and WHEREAS, in accordance with Modesto Municipal Code 8-3.204(a) Exceptions to Formal Bidding Requirements, this agreement is for professional services and, therefore, exempt from the bid requirement. However, staff proceeded with the RFP process pursuant to Administrative Directive 3.1.
#20..
- 825 -
02/14//2023/PRN/NHoux/Item XX 3 2023-XX
NOW, THEREFORE BE IT RESOLVED, by the Council of the City of Modesto that it hereby approves an Agreement with Mark Thomas & Company, Inc. to prepare construction documentation for the Dry Creek Regional Park to Tuolumne River Regional Park (TRRP) Trail Connection Project for an amount of $464,931, plus $46,493 for additional services, if needed, for an Agreement total not to exceed $511,424.
BE IT FURTHER RESOLVED that the City Manager, or his designee, is 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 day of , 2023, 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: _____________________________
DIANE NAYARES-PEREZ, CMC,
City Clerk
(SEAL)
APPROVED AS TO FORM:
BY: ________________________________
JOSE M. SANCHEZ, City Attorney
#20..
- 826 -
-1-
MARK THOMAS AND COMPANY, INC AGREEMENT WITH THE CITY OF
MODESTO FOR THE DRY CREEK REGIONAL PARK TO TUOLUMNE RIVER
REGIONAL PARK (TRRP) TRAIL CONNECTION PROJECT
THIS AGREEMENT, made and entered into in the City of Modesto, State of California, this day of , 2023, (“Effective Date”) by and between the CITY OF MODESTO, a municipal corporation of the State of California, hereinafter referred to as "City", and MARK THOMAS & COMPANY, INC, a California corporation, hereinafter referred to as "Consultant".
This Agreement is made with regard to the following recitals:
A. The City has determined that construction documentation should be prepared; Profession Design Consulting Services are needed for the Dry Creek Regional Park to Tuolumne River Regional Park (TRRP) Trail Connection Project.
B. Consultant represents that it is qualified, willing and able to provide the services to prepare said document(s).
NOW, THEREFORE, in consideration of this agreement, and the mutual promises, covenants, and stipulations hereinafter contained, the parties agree as follows:
1. SCOPE OF SERVICES.
Consultant shall undertake and complete the preparation of the scope of work as set forth and described in the documents attached hereto and referred to as Exhibit "A" or "project". The Consultant shall perform the services as described in Exhibit "A" in a manner compatible with the standards of its profession, and shall produce a fully complete project that is acceptable to City.
2. TERM OF AGREEMENT.
#20..
- 827 -
-2-
This Agreement is effective as of the date first written above and will continue in effect until City's acceptance of and payment for all services authorized by City and performed by Consultant, unless terminated earlier in accordance with the provisions of the termination clause in this Agreement.
Consultant shall undertake and complete the preparation of the scope of work as set forth and described in the documents commonly referred to as “project” attached hereto as Exhibit "A" and made a part hereof. City hereby gives Consultant notice to proceed with the preparation of the project in the manner described in Exhibit "A", as of the Effective Date of this agreement. Consultant shall diligently proceed with the Professional Design Consulting Services of the Project until the completion of items shown in Exhibit “A”.
3. COMPENSATION.
Consultant agrees to accept a sum not to exceed FOUR HUNDRED SIXTY-FOUR THOUSAND NINE HUNDRED THIRTY-ONE AND 00/100 DOLLARS ($464,931 maximum compensation) as full remuneration for performing all services and furnishing all staffing and materials for Modesto in accordance with Exhibit "A" attached hereto and for performance by Consultant of all of its duties and obligations under this Agreement, except that additional services may be compensated as described below.
The Compensation shall be paid pursuant in the manner and at the times set forth below:
City shall pay Consultant on a time and materials basis for Consultant’s actual costs for all work called for in Exhibit “A” to this Agreement. All work to be performed under this Agreement shall be billed at the hourly rates set forth in Exhibit “B” attached hereto, Consultant shall submit monthly invoices to City which include detailed tasks, hours worked, #20..
- 828 -
-3-
and billable rates for all work completed, and detailed receipts for any out-of-pocket costs paid by Consultant in connection with work performed on this project.
No retainage will be withheld by City from progress payments due the Consultant. Retainage by the Consultant or subconsultants is prohibited, and no retainage will be held by the Consultant from progress due subconsultants. Any violation of this provision shall subject the violating Consultant or subconsultants to the penalties, sanctions, and other remedies specified in Section 7108.5 of the California Business and Professions Code. This requirement shall not be construed to limit or impair any contractual, administrative, or judicial remedies, otherwise available to the Consultant or subconsultant in the event of a dispute involving late payment or nonpayment by the Consultant or deficient subconsultant performance, or noncompliance by a subconsultant. This provision applies to both DBE and non-DBE Consultants and subconsultants.
Reimbursable Expenses including all printing and reproduction, travel, vehicle mileage, delivery and horticultural soils samples expenses will be billed at cost. The total cost for all reimbursable expenses for the Project shall not exceed $4,208, and is included in the not exceed figure of $464,931. It is the responsibility of the Consultant to manage reimbursable expenses to ensure that they do not exceed this budget. Reimbursable expenses shall be invoiced to the City by monthly invoices and shall itemize the reimbursable expenses incurred during the preceding month and indicate the amount due.
Additional services may be authorized by the Department Director in an amount up to, but not to exceed 10% of the agreed maximum compensation, or FORTY-SIX THOUSAND FOUR HUNDRED NINETY-THREE AND 00/100 DOLLARS ($46,493). In the event that additional services are deemed necessary, the Consultant shall provide a written #20..
- 829 -
-4-
request to the Department Director, or designee, indicating the reason for additional work, scope and cost of such work. The Department Director, or designee, shall provide a written response to the request, either approving or denying the additional expenditure. If additional services are requested and approved, they will be billed at the hourly rates set forth in Exhibit “B” and may not exceed the amount requested and approved in writing by the Department Director. In that event, the new total compensation shall not exceed FIVE HUNDRED ELEVEN THOUSAND FOUR HUNDRED TWENTY-FOUR AND 00/100 DOLLARS ($511,424). If additional services in excess of this amount are deemed necessary by City Staff, an amendment to this Agreement will be required and must be approved by the City Council prior to commencing the work, as provided in Paragraph 9 of this agreement.
4. OBLIGATIONS OF CONSULTANT.
Throughout the term of this Agreement, Consultant shall possess, or secure all licenses, permits, qualifications and approvals legally required to conduct business.
Consultant warrants that it has all of the necessary professional capabilities and experience, as well as all tools, instrumentalities, facilities and other resources necessary to provide the City with the services contemplated by this Agreement. Consultant further warrants that it will follow the current, generally accepted and professional practices to make findings, render opinions, prepare factual presentations, and provide professional advice and recommendations regarding this project.
5. PERFORMANCE BY KEY EMPLOYEE.
Consultant has represented to City that Ed Noriega, Project Manager, will be the person primarily responsible for the performance of the services referred to in this Agreement. City has entered into this Agreement in reliance on that representation by #20..
- 830 -
-5-
Consultant. Consultant therefore agrees that twenty percent (20%) or more of the time to be devoted to the project that is the subject of this Agreement will be that of the above-named person.
6. OWNERSHIP OF DOCUMENTS/TITLE TO DATA.
Ownership of Documents
All reports, drawings, designs, graphics, working papers and other incidental work or materials furnished hereunder shall become and remain the property of the City, and may be used by City as it may require without any additional cost to City. No reports shall be used by the Consultant for purposes other than this contract without the express prior written consent of City.
Title to Data
If, as a part of the agreement, Consultant is required to produce data such as, but not limited to, drawings, plans, specifications, calculations, models, flow diagrams, visual aids and other related materials, the originals of all such data generated under this agreement will be delivered to City upon the completion or termination of services under the contract.
All materials, documents, data or information obtained from the City data files or any City medium furnished to Consultant in the performance of this Agreement will at all times remain the property of the City. Such data or information may not be used or copied for direct or indirect use by Consultant after termination of this Agreement without written consent of the City.
7. NEWS AND INFORMATION RELEASE.
Consultant agrees that it will not issue any news releases in connection with either the award of this Agreement, or any subsequent amendment of or efforts under this #20..
- 831 -
-6-
Agreement, without first obtaining review and approval of said news releases from City through the City Manager.
8. INTEREST OF CONTRACTOR.
Consultant warrants 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 services required to be performed under this Agreement. Consultant warrants that, in performance of this Agreement, Consultant shall not employ any person having any such interest. Consultant agrees to file a Statement of Economic Interests with the City Clerk at the start and end of this contract if so required at the option of City.
Consultant warrants that he/she has not employed or retained any company or person, other than a bona fide employee working for the consultant; to solicit or secure this contract; and that he/she has not paid or agreed to pay any company or person other than a bona fide employee, any fee, commission, percentage, brokerage fee, gift, or any other consideration, contingent upon or resulting from the award, or formation of this contract. For breach or violation of this warranty, City shall have the right to annul this contract without liability, or at its discretion; to deduct from the contract price or consideration, or otherwise recover the full amount of such fee, commission, percentage, brokerage fee, gift or contingent fee.
9. AMENDMENTS.
Both parties to this Agreement understand that it may become desirable or necessary during the execution of this Agreement, for City or Consultant to modify the scope of services provided for under this Agreement. Any material extension or change in the scope of #20..
- 832 -
-7-
work shall be discussed with City and the change and cost shall be memorialized in a written amendment to the original contract prior to the performance of the additional work.
Until a change order is so executed, City will not be responsible to pay any charges Consultant may incur in performing such additional services, and Consultant shall not be required to perform any such additional services.
10. INDEPENDENT CONTRACTOR.
All acts of Consultant, its agents, officers, and employees and all others acting on behalf of Consultant relating to the performance of this Agreement, shall be performed as independent contractors and not as agents, officers, or employees of City. Consultant, by virtue of this Agreement, has no authority to bind or incur any obligation on behalf of City.
Consultant has no authority or responsibility to exercise any rights or power vested in the City.
No agent, officer, or employee of the City is to be considered an employee of Consultant. It is understood by both Consultant and City that this Agreement shall not under any circumstances be construed or considered to create an employer-employee relationship or a joint venture.
Consultant, its agents, officers and employees are and, at all times during the terms of this Agreement, shall represent and conduct themselves as independent contractors and not as employees of City.
Consultant shall determine the method, details and means of performing the work and services to be provided by Consultant under this Agreement. Consultant shall be responsible to City only for the requirements and results specified in this Agreement, and, except as expressly provided in this Agreement, shall not be subjected to City's control with respect to the physical action or activities of the Consultant in fulfillment of this Agreement. Consultant has control over the manner and means of performing the services under this Agreement. #20..
- 833 -
-8-
Consultant is permitted to provide services to others during the same period service is provided to City under this Agreement. If necessary, Consultant has the responsibility for employing other persons or firms to assist Consultant in fulfilling the terms and obligations under this Agreement.
If in the performance of this Agreement any third persons are employed by Consultant, such persons shall be entirely and exclusively under the direction, supervision, and control of Consultant. All terms of employment including hours, wages, working conditions, discipline, hiring, and discharging or any other term of employment or requirement of law shall be determined by the Consultant.
It is understood and agreed that as an independent contractor and not an employee of City neither the Consultant or Consultant's assigned personnel shall have any entitlement as a City employee, right to act on behalf of the City in any capacity whatsoever as an agent, or to bind the City to any obligation whatsoever.
It is further understood and agreed that Consultant must issue W-2 forms or other forms as required by law for income and employment tax purposes for all of Consultant's personnel.
As an independent contractor, Consultant hereby indemnifies and holds City harmless from any and all claims that may be made against City based upon any contention by any third party that an employer-employee relationship exists by reason of this Agreement.
11. ASSIGNMENT.
Neither this Agreement nor any portion thereof shall be subcontracted or assigned without the express prior written consent of the City in each and every instance. #20..
- 834 -
-9-
12. PATENT/COPYRIGHT MATERIALS.
Unless otherwise expressly provided in the contract, Consultant shall be solely responsible for obtaining the right to use any patented or copyrighted materials in the performance of this Agreement. Consultant shall furnish a warranty of such right to use to City at the request of City.
13. NOTICES.
Notice required by this Agreement shall be given in writing and shall be deemed given and effective upon receipt provided that such are delivered in accordance with the provisions of this Section. Notices shall be delivered either by: (a) personal delivery (including delivery by an overnight courier service which obtains confirmation of receipt); or (b) by facsimile, provided that such transmission is followed by delivery by an overnight courier service which obtains confirmation of receipt; or (c) postage prepaid, return receipt requested, certified mail; or (d) by electronic transmission subject to reasonable proof that the notice was both transmitted and received. Each such notice shall be sent to the parties at the address respectively set forth below or to such other address as a party may designate by written notice given in accordance with the provisions of this Section:
#20..
- 835 -
-10-
FOR CONSULTANT: Name: Mark Thomas & Company
Address: 7571 North Remington Ave, Suite 102
Fresno, CA 93711
Attention: Ed Noriega, Project Manager
Phone: Office: (559) 374-3111
Mobile: (530)484-1222
Facsimile: (559) 447-8586
Email: [email protected]
FOR CITY: Name: City of Modesto
Address: P.O. Box 642
Modesto, CA 95353
Attention: Laurie A. Smith
Phone: (209) 577-5344
Email: [email protected]
14. INSURANCE REQUIREMENTS.
The Consultant shall provide at its own expense and maintain at all times the following insurance with insurance companies licensed in the State of California and shall provide evidence of such insurance to the City as may be required by the Risk Manager of the City. The policies or certificates thereof shall provide that, thirty (30) days prior to cancellation or material change in the policy, notices of same shall be given to the Risk Manager of the City by certified mail, return receipt requested, for all of the following stated insurance policies.
In the event the certificates of insurance required hereunder do not provide for notice of cancellation to the certificate holder and/or additional insureds, the Consultant shall provide, and shall require its subcontractors to provide, as an express condition precedent to payment hereunder, an endorsement from their insurers providing that the additional insureds identified herein shall be provided 30 days notice of the cancellation on the policies of insurance required hereunder (10 days notice if the policies are cancelled for non-payment of premium). In addition, the named insured on all such policies shall provide to the additional insureds identified #20..
- 836 -
-11-
herein any notices of cancellation of said insurance policies within 5 business days of receipt of such notice. The Consultant shall, as a further express condition precedent to payment for work performed, affirm under penalty of perjury that the required insurance on the project remains in place and said insurance has not been cancelled.
(a) Worker's Compensation - in compliance with the statutes of the State of California, plus employer's liability with a minimum limit of liability of $1,000,000. (b) General Liability insurance with a minimum limit of liability per occurrence of $1,000,000 for bodily injury and property damage. If Commercial General Liability Insurance or other form with a general aggregate limit is used, either the general aggregate limit shall apply separately to this project/location or the general aggregate limit shall be twice the required occurrence limit. This insurance shall indicate on the certificate of insurance the following coverages and indicate the policy aggregate limit applying to: premises and operations; broad form contractual; independent consultants and subcontractors; products and completed operations as applicable.
(c) Automobile Liability insurance with a minimum limit of liability per occurrence of $1,000,000 for bodily injury and property damage. This insurance shall cover any automobile for bodily injury and property damage.
(d) Professional Liability insurance with a minimum limit of $1,000,000 per claim and $2,000,000 policy aggregate. If coverage is on a claims made basis it shall be maintained for at least three (3) years following completion of the work.
If at any time any of said policies shall be unsatisfactory to the City or State of California, as to form or substance, or if a company issuing such policy shall be unsatisfactory to the City or State of California, the Consultant shall promptly obtain a new #20..
- 837 -
-12-
policy, submit the same to the Risk Manager for approval and submit a certificate thereof as hereinabove provided. Upon failure of the Consultant to furnish, deliver or maintain such insurance and certificates as above provided, this Agreement, at the election of the City or State of California, may be forthwith declared suspended or terminated. Failure of the Consultant to obtain and/or maintain any required insurance shall not relieve the Consultant from any liability under this Agreement, nor shall the insurance requirements be construed to conflict with or otherwise limit the obligations of the Consultant concerning indemnification. The City and State of California, its agents, officers, employees, and volunteers shall be named as an additional insured on all insurance policies required herein, except Workers' Compensation and Professional Liability. The Workers' Compensation insurer shall agree to waive all rights of subrogation against the City and State of California, its agents, officers, employees, and volunteers for losses arising from work performed by Consultant for the City or State of California. The Consultant's insurance policy(ies) shall include a provision that the coverage is primary as respects the City or State of California; shall include no special limitations to coverage provided to additional insured; and, shall be placed with insurer(s) with acceptable Best's rating of A:VII or with approval of the Risk Manager. The Consultant must deliver certificates evidencing existence of the insurance listed above to the City prior to the time the contract is signed.
CONSULTANT shall provide CITY with separate endorsements evidencing proof of the CITY’s additional insured status as to both the general liability and automobile liability insurance policies. In addition, CONSULTANT shall provide CITY with a Workers Compensation subrogation waiver by way of a separate endorsement. All endorsements referenced above must include the applicable policy number. #20..
- 838 -
-13-
For any claims related to this project, the CONSULTANT’S insurance coverage shall be primary insurance as respects the Entity, its officers, officials, employees, and volunteers. Any insurance or self-insurance maintained by the Entity, its officers, officials, employees, or volunteers shall be excess of the CONSULTANT’S insurance and shall not contribute with it.
15. TERMINATION OF AGREEMENT.
Termination by City for Default of Consultant
Should Consultant default in the performance of this Agreement or materially breach any of its provisions, at its option, City may terminate this Agreement by giving written notification to Consultant. The termination date shall be the effective date of the notice. For the purposes of this section, material breach of this Agreement shall include, but not be limited to, any of the following: failure to perform required services or duties, willful destruction of City's property by Consultant, dishonesty or theft.
Termination by City for Convenience
TheCitymay also terminate theConsultant's performance underthe Agreement, eitherin whole orin part, at its own discretion, or when conditions encountered duringthe Work make it impossible orimpracticable to proceed, or when theCityis prevented fromproceeding with the Agreement by act of God, by law, or by official action of a public authority, or upon a determination by the City that such termination is in the best interest and convenience of the City, or whenever the City is prohibited from completing the Work for any reason. TheCityshall provide no lessthan ten (10) calendar days written notice of its intent to terminate the Agreement for convenience, and shall endeavor to provide the Consultant with consultation with the City prior to termination.
#20..
- 839 -
-14-
Post-Termination Procedure
Upon receipt of a written notice of termination pursuant to either of the foregoing paragraphs, the Consultant shall:
a. Cease its work as directed in the notice of termination as of the termination date and see to it that its employees, subconsultants and agents are notified of such termination and act as specified in the notice of termination;
b. Terminate all orders and Subcontractors except as necessary to complete any portion of the Work that is not terminated; c. If directed in writing by the City to do so, assign all right, title and interest in subcontracts and materials in progress to City, in which case the City will have the right at its discretion to settle, or pay any or all claims arising out of the termination of such subconsultants, but in no event shall recovery by any Consultant or subconsultant include lost profits for portions of the Work not completed or undertaken, including materials not delivered; d. Deliver or otherwise make available to the City all data, drawings, specifications, reports, estimates,summaries and such other information and material as mayhave been accumulated by the Consultant in performing the Work whether completed or in process; e. Settle outstanding liabilities and claims, subject to the approval of City;
f. Complete performance of such part of the Work as has not been #20..
- 840 -
-15-
terminated;
g. Take such other actions as may be necessary, or as may be directed by the City for the protection and preservation of the Work and/or property related to the Work;
h. If City so requests, and at City's cost, Consultant shall provide sufficient oral or written status reports to make City reasonably aware of the status of Consultant's work on the project. i. The Consultant understands and agrees that City may, in City's sole discretion, refuse to pay Consultant for that portion of Consultant's services which were performed by Consultant on the project prior to the termination date and which remain
unacceptable and/or not useful to City as of the termination date.
City will pay Consultant an amount based on the percentage of satisfactory work completed in accordance with the notice of termination. The final payment to the Consultant after termination for convenience shall be limited to amounts due and owing under the Agreement at time of termination, including the following:
a. The cost of settling and paying valid claims arising out of the termination of the Work such as subconsultant agreements or contracts for materials;
b. The Agreement price allocable to the portion of the Work properly performed or goods supplied to the work site by the Consultant as of the date of termination, as determined in accordance with the notice of termination, reduced by any sums #20..
- 841 -
-16-
previously paid to the Consultant.
Authorization to Terminate Agreement
Termination of the Agreement may be invoked by the City Manager, or his/her designee, subject to the right of the Consultant to appeal the City Manager, or his/her designee’s, decision to the City Council. The Consultant shall appeal by notifying the City Clerk in writing within ten (10) calendar days of receipt of written notification from City of termination of the Agreement. In the event that termination of this Agreement is upheld by the City Council, any cessation of payment of delay claims, extended claims, Eichleay claims, or any other claims for delay shall be retroactive to the date of termination selected by the City Manager, or his/her designee.
16. CERTIFIED PAYROLL REQUIREMENT.
For consultants performing field work on public works contracts on which prevailing wages are required: The Consultant shall comply with the provisions of Section 1776 of the California Labor Code, regarding payroll records, and shall require its subconsultants and subcontractors to comply with that section as may be required by law.
17. INDEMNITY.
The Consultant shall hold the City and State of California, it agents , officers, employees, and volunteers, harmless from and save, defend and indemnify them against any and all claims, losses, liabilities, judgments or damages from every cause, including but not limited to injury to person or property or wrongful death, including reasonable costs and expenses of defense, to the proportionate extent caused by any negligent or intentional wrongful act or omission of Consultant, or its agents, officers, employees, or volunteers relating to or #20..
- 842 -
-17-
during the performance of its obligations under this Agreement. Consultant’s cost of defense shall not exceed the Consultant’s proportionate percentage of fault.
Consultant's obligation to defend, indemnify, and hold the City and State of California, its agents, officers, and employees harmless under the provisions of this paragraph is not limited to or restricted by any requirement in this Agreement for Consultant to procure and maintain a policy of insurance.
18. DISPUTE RESOLUTION.
All claims, controversies, or disputes arising out of, or relating to the formation of this Agreement, or the breach, termination execution, enforcement, interpretation, or validity of this Agreement, including the determination of the scope or applicability of this contract provision shall be determined by binding arbitration in Modesto, California by one arbitrator, except as otherwise specified in this Agreement. The American Arbitration Association shall administer the arbitration under its Arbitration Rules then in effect, subject to the modifications of those rules contained in this paragraph. This agreement to arbitrate shall be specifically enforceable under the prevailing law of any court having jurisdiction, and the award rendered by the arbitrator may be entered in any court having jurisdiction. The appropriate venue for any arbitration or court proceeding relating to or arising out of this provision shall be in Stanislaus County, California.
This paragraph is not intended to and does not waive the claim filing requirements found in California Government Code section 900 et seq. In the event that a timely and legally sufficient, arbitrable claim is filed by Consultant with City, and the claim is rejected in whole or in part by City, this paragraph shall result in the conclusive, final, and binding resolution of all the issues presented in the claim by Consultant so long as any issues presented #20..
- 843 -
-18-
by the claim are arbitrable. Claims rejected by City or by operation of law, shall be submitted by Consultant to arbitration pursuant to the Arbitration Rules of the American Arbitration Association within ninety (90) days after mailing of the written rejection by City to Consultant.
Otherwise, the claim or claims shall be deemed waived in their entirety.
The “fast track’ rules of the American Arbitration Association shall apply to any claim or counterclaim less than ONE HUNDRED FIFTY THOUSAND AND 00/100 ($150,000.00) DOLLARS. In arbitration not proceeding under the “fast track” rules, the arbitrator shall have the power to order that depositions be taken and other discovery be made.
Both City and Consultant shall have the right, upon written notice, to take no more than three (3) depositions of the other as a matter of right in an arbitration proceeding under the “fast track” rules.
Whether or not City and Consultant may be engaged in interstate commerce, any controversy or dispute mentioned above shall be determined by, and the parties shall be bound by, the substantive law of the State of California, and not the Federal Arbitration Act at 9 USC Section 1 et seq.
The arbitrator may grant any remedy or relief deemed by the arbitrator just and equitable under the circumstances, whether or not such relief could be awarded in a court of law. The arbitrator shall be empowered to award monetary sanctions against a party for failure of cooperation in the arbitration. The arbitrator shall, in written award, allocate all the costs of the arbitration, including the fees of the arbitrator and the reasonable attorney fees of the prevailing party, against the party who did not prevail. The prevailing party shall be the party in whose favor the majority of the central issues in the case are resolved. #20..
- 844 -
-19-
Notwithstanding anything in this provision to the contrary, the arbitrator shall have no power to award punitive damages or other damages not measured by the party’s actual damages (excluding litigation costs and fees) against any party. This limitation of the arbitrator’s powers under this Agreement shall not operate as an exclusion of the issue of punitive damages from this Agreement to Arbitrate sufficient to vest jurisdiction in a court with respect to that issue.
Consultant shall include in all subcontracts a specification whereby the subcontractor consents to being joined in an arbitration between City and Consultant involving the work of the subcontractor to be joined. Consultant’s failure to do so shall be a breach of this Agreement.
The parties hereby waive any rights provided by Title 9.2 of the California Code of Civil Procedure, Section 1296. The arbitrator’s award shall be deemed final, conclusive and binding to the fullest extent allowed by California law.
19. ENTIRE AGREEMENT.
This Agreement and its exhibits contain the entire understanding between Consultant and City. Additional or new terms contained in this Agreement which vary from Consultant's proposal are controlling and are deemed accepted by Consultant by shipment of any article or other commencement of performance hereunder. All previous proposals, offers and communications relative to this Agreement, whether oral or written, are hereby superseded except to the extent that they have been incorporated into this Agreement. No future waiver of or exception to any of the terms, conditions, and provisions of this Agreement shall be considered valid unless specifically agreed to in writing by all the parties.
20. PARTIAL INVALIDITY.
#20..
- 845 -
-20-
If any provision in this Agreement is held by a court of competent jurisdiction to be invalid, void, or unenforceable, the remaining provisions shall nevertheless continue in full force without being impaired or invalidated in any way.
21. WAIVER.
The waiver by any party to this Agreement of a breach of any provision hereof shall be in writing and shall not operate or be construed as a waiver of any other or subsequent breach hereof unless specifically stated in writing.
22. AUDIT.
The City's duly authorized representative shall have access at all reasonable times to all reports, contract records, contract documents, contract files, and personnel necessary to audit and verify Consultant's charges to City under this Agreement.
Consultant agrees to retain reports, records, documents, and files related to charges under this Agreement for a period of four (4) years following the date of final payment for Consultant services. City's representative shall have the right to reproduce any of the aforesaid documents.
23. GOVERNING LAW.
This Agreement shall be governed according to the laws of the State of California.
24. HEADINGS NOT CONTROLLING.
Headings used in the Agreement are for reference purposes only and shall not be considered in construing this Agreement.
25. COMPLIANCE WITH LAWS.
#20..
- 846 -
-21-
Consultant shall insure compliance with all safety and hourly requirements for employees, in accordance with federal, state, and county safety and health regulations and laws. Consultant shall fully comply with all applicable federal, state, and local laws, ordinances, regulations and permits.
26. CITY BUSINESS LICENSE.
Consultant will have a City of Modesto business license.
IN WITNESS WHEREOF, the City of Modesto, a municipal corporation, has authorized the execution of this Agreement in duplicate by its City Manager and attestation by its City Clerk under authority of Resolution No. 2023- , adopted by the Council of the City of Modesto on the day of , 2023, and ____________ has caused this agreement to be duly executed in duplicate as of the Effective Date.
#20..
- 847 -
Parks, Recreation and
Neighborhoods Department
Parks Planning and
Development Division
P.O. Box 642
Modesto, California 95354
209.577.5344
EXHIBIT ‘A’
SCOPE OF WORK
PROJECT DESCRIPTION
DRY CREEK REGIONAL PARK TO TUOLUMNE RIVER REGIONAL PARK (TRRP) TRAIL CONNECTION:
This project includes design construction documentation for a mixed Class 1, 2 and 3 trail connection along the east side of South Morton Blvd. from the south parking lot of Beardbrook Park traversing north through the intersection at Yosemite Blvd. and continuing to the Moose or Kewin Park Trailhead site. This trail section will likely require construction of trail side retaining wall structure along South Morton Blvd.
In addition to the Trail Section Components listed, construction plans and details shall include, at minimum, the following items:
• A 10’-12’ wide permeable concrete paved Class 1 trail. Trail design to include an adjacent 4’ wide decomposed granite trail running parallel to the paved path where applicable and space permits.
• Engineered retaining wall structure(s), where applicable. • Recreation trailheads, with small concrete paved plaza space, information kiosk, bench seating, waste receptacle and area lighting at South Morton Ave. intersection, Yosemite Blvd. intersection and Moose or Kewin Park.
• Pre-manufactured concrete park site signage at South Morton Avenue trailhead. • (5) Bench seating resting areas along trail section.
• Steel rail fencing adjacent to the trail along South Morton Drive and Yosemite Blvd.
The work to be accomplished in this project consists of preparation of construction documentation and completion of permit application documentation as necessary to obtain permit acceptance. Emphasis on continuing and improving the existing conceptual and Master Plan designs, value engineering, simplicity and quality design will be essential to the success of this project.
The project will require an experienced full-service consultant (team) with the ability to evaluate the existing conditions and make recommendations in a wide range of design services including but not limited to: structural engineering, civil engineering, electrical engineering, landscape architectural, and surveying. This project will also require the services of geotechnical specialists, archeological specialists, habitat restoration specialists and environmental consultants familiar with state and federal requirements and permit processes involving projects adjacent to or in navigable waters of the United States. Design services work shall be prepared by persons licensed by the State of California to undertake the type of design work required by the Project (engineer’s/landscape architect’s license number to appear on construction contract design documents).
#20..
- 848 -
Plans and specifications shall conform with the most recent version of all applicable local building codes (City of Modesto), Stanislaus County Health Department codes, the TRRP Master Plan (and any applicable Master Plan Updates), TRRP MEIR, TRRP Gateway Precise Plan, Initial Study/Finding of Conformance for the TRRP Gateway Precise Plan, City of Modesto Standards and Caltrans Specifications, Modesto Urban Area General Plan and MEIR.
The Construction Documentation will be comprehensive and will include some, if not all, the following items:
• Rough grading and storm water pollution prevention.
• Site preparation, finish grading and drainages.
• Sensitive habitat protection plans and removal of non-native species. • Riparian habitat landscape plantings, with installation of a rigid temporary irrigation system to establish riparian habitat plantings for a period of three years, where applicable.
• Parkway landscaping and permanent irrigation system at roadway intersections and plaza spaces.
• Site Furnishings: bench(s), picnic table(s), bike rack(s), bollard(s), kiosks and comprehensive wayfinding signage.
• Street curb, gutter replacement and repair, where applicable. • 25’ light pole fixtures along trail sections. Fixtures to include hardwired and solar options.
General Project Assumptions – The project scope:
• Does not include R/W Acquisition Documents
• Does not include R/W Appraisal and Acquisition
• Assumes rights-of-entry will be provided by City.
PROFESSIONAL DESIGN CONSULTING SERVICES TO INCLUDE
Based on the above, the following scope of services to be performed in chronological order.
Listed below are tasks and conditions that the consultant is expected to perform and meet on this project. It is not intended the tasks shown are the only tasks required on this project. The City will provide electronic copies of the necessary background documentation TASK #1 – PROJECT MANAGEMENT / PERMITTING
1.1 Kick-off meeting (Meeting #1) in Modesto with City Staff to:
a. Confirm project description/schedule.
b. Obtain information and data regarding the project.
c. Advise the City of Modesto on the approach to be taken in preparing the Phase I/Environmental Site Assessment and Biological Assessment for this project. d. Provide utility coordination services to determine existing utilities to generate preliminary utility plans. Physical potholes are not included in the scope of work.
If needed, Mark Thomas will request authorization from the City prior to completing any work.
#20..
- 849 -
1.2 Conduct a detailed site visit and collect and review all pertinent documentation including but not limited to the TRRP Master Plan (and any applicable Master Plan Updates), the Initial Study/Finding of Conformance for this project and the TRRP Master Plan MEIR.
1.3 Prepare a final project description through data collection, field work, and research which will be the basis for the preparation of the permits.
1.4 Conduct and prepare an Administrative Draft Phase I/Environmental Site Assessment as required by CEQA determinations and as directed by City of Modesto Staff.
1.5 Prepare Biological Assessment Report for use in permitting with State Agencies that includes site identification of plant species; tree species, location and DBH; and potentially impacted wildlife.
1.6 Complete Section 106 Report (Cultural Resources Inventory Report), Native American consultation, and Agency Coordination.
1.7 Provide the City with one (1) reproducible original and one (1) electronic copy of the above said documents for reproduction and distribution.
1.8 Based on comments from City staff, prepare a final Phase I/Environmental Site Assessment, Cultural Resources Inventory Report and Biological Assessment.
1.9 Coordinate and prepare all necessary permit applications and additional information if and as required by the CA Department of Fish and Wildlife, San Joaquin Valley Air Quality Control Board, Regional Water Quality Control Board, Department of Water Resources, Bureau of Reclamation. If additional permitting beyond the agencies listed above is required Mark Thomas will request authorization from the City prior to completing any work. Consultant shall assist City staff in ensuring the necessary permits are obtained prior to bidding the project.
1.10 Mark Thomas and Team will perform ongoing internal project coordination to share project information, identify critical issues, make decisions, assign project tasks, identify design criteria, and any other items critical to project delivery. Mark Thomas will prepare and maintain a project CPM schedule for the City and Design Teams’ review. Team will also submit monthly invoices and progress reports to the City.
1.11 Mark Thomas will perform ongoing general project coordination meetings with Caltrans.
Tasks include coordinating an encroachment permit to connect the trail to sidewalks along Yosemite Blvd. Scope assumes that no studies will be required by Caltrans.
1.12 Environmental Assumptions
• Tree inventory will be performed for trees that are in the project features alignments and no more than 25 feet outside of the alignments.
• Anticipate no built environment or other historic-era resources will be affected in the project area and therefore no built environment field survey is included or required. • Anticipate that there are no archaeological or Tribal cultural resources in the project area. Field surveys will take one 10-hour day.
#20..
- 850 -
• GEI assumes that the City will make the necessary arrangements to provide access.
One GEI archaeological survey crew consisting of two archaeologists will conduct a cultural resources inventory of the APE to intensive standards. • Does not include Hydrology and Hydraulics Study. Assume Dry Creek Bridge will not require H&H study.
• Does not include preconstruction surveys.
• Does not include Traffic Study at SR 132.
• Does not include signal modification at SR 132.
• Does not include Phase 2 Hazmat Study.
• Fee for permits shall be City’s responsibility.
TASK #2 – ALIGNMENT ALTERNATIVES AND COMMUNITY MEETINGS
2.1 Draft Alignment Alternatives
The Design Team will prepare two (2) draft conceptual level trail alignment plans. Each plan will be color rendered and at a scale sufficient for clarity and legibility to facilitate the discussion of issues and opportunities with City staff and will depict alternate solutions to program needs, show pedestrian crossing locations, linkage to existing trails, sidewalks, and major utility locations. The main difference between the two conceptual level plans will be the method of crossing Yosemite Blvd and the placement of the trail north of Yosemite Boulevard. For the placement of the trail north of Yosemite, through the La Loma neighborhood, the alignments will depict a Class I trail along the east side of Dry Creek, the west side of Dry Creek, and the application of a Class III bike facility on the west side of Dry Creek in lieu of a Class 1. Prepare concept level cost estimate and up to three illustrative cross sections of critical locations for each plan.
2.2 Alignment Alternatives Review (Meeting #2)
The design team will present the draft alignment alternatives to City Staff for comment and feedback.
2.3 Public Outreach
The O’Dell team will work closely with City of Modesto staff to schedule and conduct community meetings and outreach efforts. The team intends to conduct a total of two community meetings, and individual stakeholder interviews during the course of the project. The City will be responsible for securing a meeting site. Mark Thomas and O'Dell will hold two public workshops throughout the process in an effort to better understand community issues and concerns, as well as develop consensus on the trail alignment.
The first workshop is to be held after the development of the initial conceptual alignment alternatives. The second workshop will be held after incorporating feedback and developing the preferred alternative. Workshop materials including workshop announcements (to be distributed by City), agendas, questionnaires, and other materials will be prepared. The design team will prepare audio/visual PowerPoint presentation for each workshop describing the project, process, alternatives and facilitate feedback. The #20..
- 851 -
team will also provide design for meeting announcements, and coordinate online announcements.
City will be responsible for invitations and arranging the meeting location. a. Community Meeting 1 (Meeting #3)
b. Community Meeting 2 (Meeting #4)
TASK #3 – CONSTRUCTION DOCUMENTATION
3.1 Conduct an interdepartmental start up meeting in Modesto to begin the construction documentation process. (Meeting #5)
3.2 Topographic survey to locate the existing visible improvements and visible utilities. The Topographic Survey will include existing grades, any above ground utility structures, utility lines, trees (dbh) and all above ground structures, including the M&ET and La Loma Avenue bridges. For design options of the trail north of Yosemite Boulevard, it will be necessary to survey Morton Boulevard, and east and west sides of Dry Creek. The Topographic Survey limits include five feet behind the existing or proposed back of trail/sidewalk and extend out to the centerline of the road. Field Topographic Survey will be performed to cross-section each of the roadways on 50-foot stations to include the existing lip of gutter and crown. The Topographic Survey will include the existing pavement, striping, visible utilities (storm drain, sanitary sewer, water, dry utilities within the area of pavement), and fire hydrants.
Topographic base mapping to include an existing ground digital surface generated from Topographic Design Field Survey and refined using break lines to result in accurate surface triangulations and smooth, realistic contours. All surveyed field features will be included as a part of the base mapping. The Topographic Survey will be provided in an AutoCAD format that can operate with AutoCAD 2019 version and include the appropriate labeling.
3.3 Provide geotechnical evaluation of existing soils as warranted for pavements, walls, lighting foundations and minor grading. Utilize historical information, along with geologic and soil survey maps of the area to minimize field explorations. Obtain Boring and Encroachment permits as necessary and follow all required regulations for soil borings.
Submit geotechnical report to City staff and incorporate recommendations into the 30% construction documents. The following explorations are expected:
a. Three borings to between 5 and 40 feet deep (deeper boring located at the railroad crossing location) and two to three DCP tests. b. In general, explorations will be located about every 750 to 1,000 feet along the proposed trail and at key proposed amenity locations. DCP test will be advanced to depths ranging from 5 to 10 feet, or essential refusal. c. Selected soil samples will have laboratory tests for moisture content/unit weight, 200 wash analysis, grain size analysis, plasticity index, unconfined compressive and landscape suitability.
d. Geotechnical report shall contain a project description, summary of explorations and conditions, laboratory test results, Caltrans Seismic information for structure #20..
- 852 -
design, CBC values assuming exemptions in code, potential for seismic impacts, recommendations for construction of project elements and grading, minimum unreinforced permeable and concrete flatwork sections, risk management and limitations, vicinity map, site plan with exploration locations and exploration logs with laboratory test results.
3.4 Provide a horticultural soils report for landscape soil preparation. Submit report to City staff and incorporate recommendations into the 30% construction documents.
3.5 Prepare preliminary 30% construction documents including:
e. Preliminary Site Plan
f. Preliminary Utility Relocation Plans
g. Preliminary Structural Wall Plans at the M&ET Rail Bridge h. Preliminary Trail Civil Plans, including plans and profiles i. Preliminary Landscape Plans with up to three (3) illustrative cross sections.
Including site furnishings, plant palette, irrigation equipment list, schematic irrigation design.
j. Preliminary construction cost estimate.
k. Preliminary Electrical Plans with photometric analysis as necessary. Provide options for solar and hardwired lighting, with plan and renderings of lighting options.
Deliver one (1) PDF sets of plans and specifications to City. City staff will require a minimum of four (4) weeks for review of 30% construction documents. In addition, provide a Final Rendered Plan (full color printed 24” x 36” in size and electronic image) to the City.
3.6 Conduct an interdepartmental review session in Modesto to review City comments on 30% plans and prepare a response to comments including intended resolution. (Meeting #6)
3.7 Based on comments received, prepare 75% construction documents including plans, specifications, and refined cost estimates. Submittal will include status of permits, comments from outside agencies and preliminary estimate of costs associated with permitting the project. Deliver one (1) PDF and four (4) hardcopy sets of plans and specifications to City. City staff will require a minimum of six (6) weeks for review of 75% construction documents. The 75% construction document submittal shall include updates/further development to all of the items listed in the 30% submittal.
3.8 Conduct an interdepartmental review session in Modesto to review City comments on 75% plans and prepare a response to comments including intended resolution. (Meeting #7)
3.9 Based on comments received, prepare 100% construction documents including plans, specifications, bid form and detailed estimate. In addition, provide a status of permits and final costs associated with permitting the project. Plans will be prepared to allow for deductive and additive alternates or phased construction as necessary. Deliver one (1) #20..
- 853 -
PDF and five (5) hardcopy sets of plans and specifications to City. City staff may require a minimum of four (4) weeks for review of 100% construction documents.
The construction documents for the park will include, (as applicable):
• title sheet
• general notes
• project control
• typical sections
• demolition plan
• grading & drainage plan, with utility information & existing conditions and demolition (using 1’ contours, scaled at 1”=40’ minimum) • erosion and sediment control plans and details
• sign and trail marking plans and details
• site construction plans and details
• planting plan and details
• irrigation plan and details
• electrical plans and details
• structural details and calculations
• technical specifications (CSI format), city will provide boiler plate specifications • bid form
Provide one (1) set of final wet stamped Bond original plans and specifications for reproduction and a signed pdf of the plan set, one (1) AutoCAD (version 2019 compatible) drawings file. Use “D” size plan sheet and City of Modesto Title Block and Standards. All final plans & specifications shall be stamped & signed by a registered professional (Landscape Architect or Engineer), as appropriate.
Specifications should be CSI 6-digit provided in Microsoft Word and organized to match the format requested by the City during the design process. The Consultant must use the City of Modesto typical “front end” documents. Consultants may request additional sections be added to either division and/or recommend changes to the current “front ends”. Any changes must be requested in writing and are subject to review and approval by the City. Plans and Specifications shall meet all local, state and federal requirements as necessary. All construction shall be designed to be in accordance with current Americans with Disabilities Act and Title 24 requirements.
TASK #4 – BIDDING AND CONSTRUCTION SUPPORT
4.1 Assist City staff in bidding process as required, including helping answer questions from bidders.
4.2 Review and process shop drawings and submittals required by technical specifications; with use of digital E-Builder Construction Management software. Free training will be provided by City for E-Builder Software.
#20..
- 854 -
4.3 Provide site visit review and prepare report on construction progress and quality, with recommendations for correction of any deficiencies (approximately one-(1) Field Meeting).
4.4 Assist in determining and processing requests for information and change orders.
PROJECT SCHEDULE
Proposed milestones for the project tasks are as follows:
MILESTONE DATE
Award Design Contract Tuesday, February 14, 2023
Design Start March 2023
Design Completion Approx. March 2024
PROPOSED COMPENSATION`
The following fees are based on the scope of work described previously in Exhibit ‘A’.
Payments will be made on a monthly basis when portions of the tasks are completed.
The monthly billing at the Hourly Rates included in Exhibit ‘B’, and verifiable documentation on any reimbursable expenses incurred.
Task #1 – Project Management / Permitting (not to exceed) $ 58,860 Task #2 – Community Meetings (not to exceed) $ 29,334
Task #3 – Construction Documentation (not to exceed) $ 343,725 Task #4 - Bidding and Construction Support (not to exceed) $ 28,804 Reimbursable Expenses (not to exceed) $ 4,208
Total Contract Amount $ 464,931
Additional Services (not to exceed 10%) $ 46,493
Grand Total $ 511,424
#20..
- 855 -
Parks, Recreation and
Neighborhoods Department
Parks Planning and
Development Division
P.O. Box 642
Modesto, California 95354
209.577.5344
EXHIBIT ‘B’
HOURLY RATES
The following hourly rates will be used for billable hours within this Agreement and for additional work requested and approved. In addition, monthly progress payment invoices shall include the minimum attachments: Detailed description or itemization of work completed for the time period, task billing summary, hourly rates from all consultants.
Mark Thomas
Engineering & Planning
Engineer Manager $305
Design Engineer II $135
Design Engineer I $110
Sr. Project Manager $252
Sr. Project Engineer $177
Sr. Technician $138
LAUD Division Manager $246
LAUD Project Manager $201
Landscape Architect $141
Landscape Designer II $111
Sr. Project Coordinator $138
O’Dell Engineering
Survey/Outreach/Landscape
Principal $280
Senior Civil Engineer $215
Senior Engineer 2 $200
Senior Engineer 1 $185
Engineer 2 $180
Engineer 1 $170
Assistant Engineer 2 $145
Assistant Engineer 1 $130
Senior Landscape Architect 2 $200
Senior Landscape Architect 1 $180
#20..
- 856 -
Landscape Architect 2 $170
Landscape Architect 1 $160
Landscape Designer 3 $155
Landscape Designer 2 $145
Landscape Designer 1 $135
Planner $175
Assistant Planner $140
Dry Utility Project Manager 2 $170
Dry Utility Project Manager 1 $150
Utility Engineer $135
CADD Operator 2 $115
CADD Operator 1 $95
Surveyor Manager $205
Senior Land Surveyor $195
Senior Surveyor 2 $190
Senior Surveyor 1 $170
Surveyor 2 $150
Surveyor 1 $140
Assistant Surveyor 2 $130
Assistant Surveyor 1 $115
Survey Crew 2-man/1-man $320/$180
Survey Crew 2-man/1-man (Prevailing
Wage) $396/$225
Administrative $96
GEI
Environmental/Permitting
Staff Professional – Grade 1 $ 89
Staff Professional – Grade 2 $ 105
Project Professional – Grade 3 $ 118
Project Professional – Grade 4 $ 143
Senior Professional – Grade 5 $ 164
Senior Professional – Grade 6 $ 188 - $ 205
Senior Professional – Grade 7 $ 243
Senior Consultant – Grade 8 $ 274
#20..
- 857 -
Senior Consultant – Grade 9 $ 279
Senior Principal – Grade 10 $ 279
Senior Drafter and Designer $145
Drafter / Designer and Senior
Technician $118
Field Professional $106
Technician, Word Processor,
Administrative Staff $84
Office Aide $83
Fehr & Peers
Electrical
Principal $240 - $375
Senior Associate $205 - $300
Associate $175 - $225
Senior Engineer/Planner $160 - $215
Engineer/Planner $130 - $175
Senior Engineering Technician $150 - $215
Senior Project Accountant $170 - $190
Senior Project Coordinator $130 - $180
Project Coordinator $120 - $170
Technician $150 - $170
Intern $95 - $140
Crawford
Geotechnical
Principal $200
Senior Project Manager $180
Project Manager $175
Senior Geologist $155
Senior Engineer $155
Project Engineer II $145
Project Engineer I $135
Staff Engineer $115
Drafter $95
Project Assistant $70
#20..
- 858 -
Technician (PW) $110
Technician (Non-PW) $95
#20..
- 859 -
#20..
- 860 -
#20..
- 861 -
CITY OF MODESTO
COUNCIL AGENDA REPORT
DATE OF MEETING:
February 14, 2023
Date: January 19, 2023
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: Bill Sandhu, Public Works Director
SUBJECT: Amendment to Article 14, Chapter 2, Title 3 of the Modesto Municipal Code related to Speed Limits
CONTACT: Mark G. Murphy, Traffic Engineer, [email protected], 209-577-5431 DESCRIPTION:
Consider an Ordinance amending Section 3-2.1401.1 of Article 14, Chapter 2, Title 3 of the Modesto Municipal Code relating to speed limits to determine and designate speed limit changes. (Funding: Surface Transportation Fund (Gas Tax)) STRATEGIC PLAN ELEMENT:
This item is consistent with Council’s Strategic Commitment Area of Focus: “Quality of Life Goals and Strategies”; engage partners across the community to ensure the safety, resilience, and attractiveness of Modesto; Goal A: “Improve community safety and quality of life through a combination of prevention and intervention efforts that address safety and it’s underlying issues.”
BACKGROUND:
The California Vehicle Code (CVC) Section 22358 authorizes local agencies to post speed limits less than 65 miles per hour on local streets. However, in order to use radar to enforce these speed limits, the CVC mandates the following conditions:
The local agency shall prepare an engineering and traffic survey. The engineering and traffic survey shall be updated every five years, seven, or ten years, per CVC Section 40802.
The speed limit shall be based upon the 85th percentile travel speed and an engineering and traffic survey.
The speed limit may be reduced by 5 mph with proper justification from the nearest 5 mph increment of the 85th percentile speed, per CVC Section 627 and 22358. In cases in which the speed limit needs to be rounded up to the nearest 5 mph increment of the 85th percentile speed, the local authority can decide to instead round down the speed #21..
- 862 -
City Council, February 14, 2023
Amendment of Speed Limit Ordinance, Article 14, Chapter 2, Title 3
limit to the lower 5 mph increment, but then the local authority would be prohibited from reducing the speed limit any further for any reason, per State Assembly Bill No. 529. The local agency may declare a school zone 15 MPH speed limit when children are present, in accordance with CVC Section 22358.
DISCUSSION:
At the present time, the speed limit is 25 mph in front of schools and near schools “when children are present” as permitted by CVC Section 22352 “Prima Facie Speed Limits.” CVC Section 22358.4 allows the school zone speed to be reduced to 20 mph or 15 mph on two lane roadways in residential districts where the existing posted speed limit is 25 mph or 30 mph when engineering and traffic survey conditions indicate a lower speed limit is justified at that location based on the survey results.
Lowering the speed limits to 15 mph in school zones provides increased protection of children in several different ways. First, it provides motorists additional time to see a child and slow or stop if required. Children are more difficult to see than adults because they are smaller in size.
Additionally, according to the National Safe Kids Foundation Pedestrian Injury Fact Sheet, children do not fully develop their auditory and visual acuity, depth perception and ability to scan for oncoming cars until they are at least 10 years of age.
Second, the lower speed limit in school zones will provide children with additional safety if an accident were to occur. Most school zone speed limits are 25 mph and below, and this is supported by several sources, including the National Safe Kids Campaign’s brochure Child Pedestrians at Risk in America. The brochure states: A National Survey of Speeding in School Zones, children are eight times more likely to survive an impact, if the vehicle is traveling 30 miles per hour than if they are struck by a vehicle traveling 20 mph or less. Setting the speed limit at 15 mph not only reduces the likelihood of a child being struck by a vehicle, it also reduces the chances of serious injury or death in the case of a collision.
The engineering and traffic survey results could also indicate the existing 25 mph school zone speed limit is appropriate. In those locations, the CVC would not allow posting of a lower speed limit.
In accordance with CVC Section 22358.4, the local agency may establish a 15-mph speed limit in a school zone when children are present when the following criteria are met:
Street (or highway) is in a residential district.
Street (or highway) outside of a school zone has a posted speed limit no greater than 30 mph.
Street (or highway) has no more than a total of two through traffic lanes (one in each direction or two in one direction).
The reduced school zone speed limit of 15 mph is within 500 feet of school grounds. The extended school zone speed limit of 25 mph is within 500 to 1,000 feet of school grounds.
A. The following streets are recommended to have 25 mph school zone speed limits reduced to 15 mph and will conclude all the schools within the City of Modesto limits that are eligible for this reduction.
#21..
- 863 -
City Council, February 14, 2023
Amendment of Speed Limit Ordinance, Article 14, Chapter 2, Title 3
NAME OF STREET OR PORTION AFFECTED EXISTING
SPEED
LIMIT
PROPOSED
PRIMA FACIE
SPEED LIMIT
1.BOWEN AVENUE, between Fremont Avenue and
College Avenue 25 15
2.CHEYENNE WAY, between Seminole Lane and
Shawnee Drive 25 15
3.COLDWELL AVENUE, between Brady Avenue and
Enslen Avenue 25 15
4.ENCINA AVENUE, between North Conejo Avenue and
Rosina Avenue 25 15
5.ESCUELITA AVENUE, between North Santa Ana
Avenue and Las Palmas Avenue 25 15
6.GLENN AVENUE, between Las Vegas Street and
Rutherford Street 25 15
7. JANNA AVENUE, between Easter Drive and Peach
Drive 25 15
8.KIRSCHEN DRIVE, between Crippen Avenue and Pine
Tree Lane 25 15
9.LAS VEGAS STREET, between Butte Avenue and
Glenn Avenue 25 15
10. LUCERN AVENUE, between Coffee Road and El Terino
Avenue 25 15
11. MIDDLEBORO PLACE, between Lakewood Avenue and
Eastridge Drive 25 15
12. MOUNT VERNON DRIVE, between Hemminger Way
and Sharondell Drive 30 15
13. w NORTHVIEW DRIVE, between Mable Avenue and
Kentwood Avenue 25 15
14. ROSE AVENUE, between Crestview Drive and Wylie
Drive 30 15
15. EAST RUMBLE ROAD, between Claremont Avenue and
Hampshire Lane 30 15
16. WEST RUMBLE ROAD, between Napier Drive and Tully
Road 30 15
#21..
- 864 -
City Council, February 14, 2023
Amendment of Speed Limit Ordinance, Article 14, Chapter 2, Title 3
17. NAME OF STREET OR PORTION AFFECTED EXISTING
SPEED
LIMIT
PROPOSED
PRIMA FACIE
SPEED LIMIT
18. SHELDON DRIVE, between Janet Drive and Pembroke
Drive 25 15
19. SONOMA AVENUE, between East Orangeburg Avenue
and Meadow Rue Drive 25 15
20. SUNRISE AVENUE, between East Coolidge Avenue and
East Orangeburg Avenue 30 15
21. TOKAY AVENUE, between Sunrise Avenue and La
Cienega Drive 25 15
22. WARM SPRINGS DRIVE, between Eastport Drive and
Eastren Avenue 25 15
23. WISDOM WAY, between Whole Court 25 15
*The local agency may declare a 15-mph speed limit when children are present in accordance with CVC Section 22358.4.
B. The following streets have 15 MPH reduced speeds in school zones.
NAME OF STREET OR PORTION AFFECTED DECLARED
PRIMA FACIE
SPEED LIMIT
BEAR CUB LANE, between Kodiak Drive and Hillglen Avenue 15 BOWIE AVENUE, between School Avenue and El Paso Avenue 15 CALIFORNIA AVENUE, between Champagne Lane and S. Emerald Avenue
15 CONANT AVENUE, between Nancy Lane and W. Rumble Road 15 ELISE STREET, between Hudson Lane and Sutter Avenue 15
SOUTH EMERALD AVENUE, between California Avenue and Muriel Avenue
15 FINE AVENUE, between Lauding Way and Kodiak Drive 15 FINE AVENUE, between Merle Avenue and Sharon Avenue 15
FLOYD AVENUE, between Newport Drive and Vicki Drive 15
HAMMOND STREET, between Robertson Road and Red Pine Drive 15 KODIAK DRIVE, between Litt Road and Fine Avenue 15
KODIAK DRIVE, between Tagura Drive and Bear Cub Lane 15 #21..
- 865 -
City Council, February 14, 2023
Amendment of Speed Limit Ordinance, Article 14, Chapter 2, Title 3
MAID MARIANE LANE, between Merle Avenue and Sharon Avenue 15 MERLE AVENUE, between Wisdom Way and Walnut Tree Drive 15 MONTEREY AVENUE, between Kerr Avenue and Empire Avenue 15 POUST ROAD, between Chapparal Place and Kidd Avenue 15
ROBERTSON ROAD, between Pine Tree Lane and Hammond Street 15 WEST RUMBLE ROAD, between Conant Avenue and Marvin Gardens 15 WEST RUMBLE ROAD, between Park Place and Holiday Lane 15 SCHOOL AVENUE, between Crows Landing Road and Bowie Avenue 15 SHARON AVENUE, between Maid Mariane Lane and Fine Avenue 15 SUTTER AVENUE, between Elsie Street and South Avenue 15 TERESA STREET, between Seasons Way and Grape Avenue 15
WOODROW AVENUE, between Tully Road and Lord Avenue 15
FISCAL IMPACT:
If Council chooses to approve the proposed speed limit changes, new signs will cost approximately $75 each to install. The total cost is estimated to be $3,600. There is no direct cost to the city for enforcing the speed limit. Officers can issue a citation for speed violation with a current and valid speed survey on file.
Funds are budgeted in the existing Fiscal Year 2022/2023 Traffic Operations accounts to support the recommended action:
1700-53550-53150, Real Property Maintenance and Repair Supplies 1700-53550-51001, Salaries and Wages
COMMITTEE RECOMMENDATION:
This item was presented to the Safety and Communities Committee on February 18, 2023, and the Committee recommended forwarding to Council for approval.
CEQA/NEPA REQUIREMENTS:
This is not a project as defined by CEQA guidelines, Categorical Class III, Section 15303. #21..
- 866 -
City Council, February 14, 2023
Amendment of Speed Limit Ordinance, Article 14, Chapter 2, Title 3
RECOMMENDED COUNCIL ACTION:
Staff Recommendations:
Motion introducing and waiving the first reading of an Ordinance amending Section 3-2.1401.1 of Article 14, Chapter 2, Title 3 of the Modesto Municipal Code relating to speed limits.
Approved by:
Bill Sandhu, Public Works Director
Joseph P. Lopez, City Manager
Attachments:
1. Redlines MMC Article 14
2. Updated Ordinance
3. State of California Vehicle Code Section 22358.4
4. CA Senate Bill No. 529
#21..
- 867 -
Created: 2022-07-27 10:51:55 [EST]
(Supp. No. 61)
3-2.1401.1 Change in Speed Limits Set by State Law; For Purpose of Enforcement Using Radar or Other Electronic Device.
By authority of, and upon the basis of engineering and traffic surveys conducted pursuant to Vehicle Code and the Traffic Manual of the Department of Transportation, it is determined that the prima facie speed limits which follow would facilitate the orderly movement of vehicular traffic and would be reasonable and safe.
NAME OF STREET OR PORTION AFFECTED DECLARED
PRIMA FACIE
SPEED LIMIT
DATE
SURVEYED
BANGS AVENUE, between Dale Road and McHenry
Avenue *ES10
45 miles per
hour
February 1,
2012
BLUE GUM AVENUE, between Morse Road and
Carpenter Road
40 miles per
hour
December 20,
2019
BRIGGSMORE AVENUE, between Claus Road and
Santa Fe Railroad Tracks *ES10
45 miles per
hour
December 22,
2011
BRIGGSMORE AVENUE, between Coffee Road and
Oakdale Road
50 miles per
hour
August 7, 2018
BRIGGSMORE AVENUE, between McHenry Avenue
and Coffee Road
45 miles per
hour
August 7, 2018
BRIGGSMORE AVENUE, Between Oakdale Road
and Claus Road *ES10
50 miles per
hour
December 22,
2011
BRIGGSMORE AVENUE, between Prescott Road
and Tully Road *ES10
45 miles per
hour
February 3,
2015
BRIGGSMORE AVENUE, between Tully Road and
McHenry Avenue
45 miles per
hour
August 7, 2018
BRIGHTON AVENUE, between Coffee Road and
Locke Road *ES10
30 miles per
hour
May 8, 2013
CALIFORNIA AVENUE, between Carpenter Road
and Martin Luther King Drive *ES10
30 miles per
hour
January 17,
2013
CARPENTER ROAD, between Blue Gum Avenue
and Woodland Avenue
40 miles per
hour
December 27,
2019
CARPENTER ROAD, between Woodland Avenue
and Maze Boulevard *ES10
40 miles per
hour
February 16,
2012
CARPENTER ROAD, between Maze Boulevard and
Paradise Road
50 miles per
hour
December 20,
2019
CARVER ROAD, between Bangs Avenue and
Pelandale Avenue *ES10
35 miles per
hour
December 22,
2011
#21..
- 868 -
Created: 2022-07-27 10:51:55 [EST]
(Supp. No. 61)
CARVER ROAD, between Pelandale Avenue and
Brixton Lane *ES10
30 miles per
hour
December 28,
2011
CARVER ROAD, between Brixton Lane and
Briggsmore Avenue *ES10
30 miles per
hour
December 28,
2011
CARVER ROAD, between Briggsmore Avenue and
Orangeburg Avenue *ES10
30 miles per
hour
December 28,
2011
CARVER ROAD, between Orangeburg Avenue and
9th Street *ES10
30 miles per
hour
December 28,
2011
CELESTE DRIVE, between Coffee Road and Oakdale
Road *ES10
30 miles per
hour
May 8, 2013
CLARATINA AVENUE, between Coffee Road and
Oakdale Road
55 miles per
hour
August 6, 2018
CLAUS ROAD, between Sylvan Avenue and
Briggsmore Avenue *ES10
50 miles per
hour
January 26,
2012
CLAUS ROAD, between Briggsmore Avenue and
Scenic Drive
45 miles per
hour
December 19,
2019
CLAUS ROAD, between Scenic Drive and Yosemite
Boulevard *ES10
45 miles per
hour
January 26,
2012
COFFEE ROAD, between Claratina Avenue and
Sylvan Avenue
40 miles per
hour
August 6, 2018
COFFEE ROAD, between Sylvan Avenue and Floyd
Avenue
40 miles per
hour
December 20,
2019
COFFEE ROAD, between Floyd Avenue and
Briggsmore Avenue
40 miles per
hour
December 20,
2019
COFFEE ROAD, between Briggsmore Avenue and
Scenic Drive
40 miles per
hour
December 20,
2019
COLLEGE AVENUE, between Rumble Road and
Bowen Avenue
30 miles per
hour
December 20,
2019
COLLEGE AVENUE, between Bowen Avenue and
Princeton Avenue *ES10
35 miles per
hour
September 29,
2015
COLLEGE AVENUE, between Princeton Avenue and
Needham Avenue *ES10
25 miles per
hour
September 29,
2015
CREEKWOOD DRIVE, between Claus Road and
Yosemite Boulevard
35 miles per
hour
December 27,
2019
CROWS LANDING ROAD, between 7th Street and
Hatch Road *ES10
35 miles per
hour
May 8, 2013
#21..
- 869 -
Created: 2022-07-27 10:51:55 [EST]
(Supp. No. 61)
CROWS LANDING ROAD, between Hatch Road and
Whitmore Avenue
40 miles per
hour
December 20,
2019
DALE ROAD, northbound and southbound,
between Bangs Avenue and Kiernan Avenue*ES10
40 miles per
hour
December 20,
2011
DALE ROAD, between Bangs Avenue and Snyder
Avenue*ES10
35 miles per
hour
February 1,
2012
DALE ROAD, between Snyder Avenue and
Veneman Avenue*ES10
35 miles per
hour
February 1,
2012
DALE ROAD, between Veneman Avenue and
Standiford Avenue*ES10
30 miles per
hour
February 1,
2012
EASTRIDGE DRIVE, between Orangeburg Avenue
and Scenic Drive
30 miles per
hour
December 29,
2019
EL VISTA AVENUE, between Scenic Drive and
Yosemite Boulevard
35 miles per
hour
August 8, 2018
EMERALD AVENUE, between Maze Boulevard and
California Avenue
35 miles per
hour
December 20,
2019
EVERGREEN AVENUE, between Orangeburg
Avenue and Carver Road *ES10
30 miles per
hour
February 22,
2012
FINE AVENUE, between Hillglen Avenue and Merle
Avenue *ES10
30 miles per
hour
May 8, 2013
FLOYD AVENUE, between Coffee Road and
Oakdale Road*ES10
30 miles per
hour
February 23,
2012
FLOYD AVENUE, between McHenry Avenue and
Coffee Road*ES10
30 miles per
hour
February 24,
2012
FLOYD AVENUE, eastbound and westbound,
between Oakdale Road and Roselle Avenue*ES10
35 miles per
hour
January 26,
2012
FLOYD AVENUE, between Roselle Avenue and
Claus Road
40 miles per
hour
August 6, 2018
G STREET, between 9th Street and 17th Street 25 miles per hour
August 7, 2018
GRANGER AVENUE, between Tully Road and
McHenry Avenue
35 miles per
hour
December 27,
2019
GRANGER AVENUE, between McHenry Avenue
and Sunrise Avenue
35 miles per
hour
December 27,
2019
H STREET, between 9th Street and 17th Street 25 miles per hour
December 20,
2019
#21..
- 870 -
Created: 2022-07-27 10:51:55 [EST]
(Supp. No. 61)
HASHEM DRIVE, between Sylvan Avenue and
Oakdale Road *ES10
30 miles per
hour
April 23, 2012
HATCH ROAD, between Carpenter Road and Crows
Landing Road *ES10
45 miles per
hour
February 15,
2012
JEFFERSON STREET, between Maze Boulevard and
Paradise Road *ES10
25 miles per
hour
March 25,
2015
KANSAS AVENUE, between Morse Road and
Rosemore Avenue *ES10
40 miles per
hour
March 30,
2015
KANSAS AVENUE, between Rosemore Avenue and
Carpenter Road
35 miles per
hour
December 20,
2019
KANSAS AVENUE, between Carpenter Road and
Emerald Avenue
35 miles per
hour
December 20,
2019
KANSAS AVENUE, between Emerald Avenue and
Franklin Street *ES10
30 miles per
hour
December 20,
2011
KODIAK DRIVE, between La Force Drive and
Roselle Avenue *ES10
30 miles per
hour
May 8, 2013
LA LOMA AVENUE, between Burney Street and
Yosemite Boulevard *ES10
30 miles per
hour
March 20,
2012
LAKEWOOD AVENUE, between Briggsmore Avenue
and Scenic Drive
40 miles per
hour
December 20,
2019
LINCOLN AVENUE, between Dry Creek and
Yosemite Boulevard *ES10
35 miles per
hour
February 15,
2012
MABLE AVENUE, between Coffee Road and
Oakdale Road *ES10
30 miles per
hour
March 21,
2012
MARTIN LUTHER KING DRIVE, between Maze
Boulevard and Paradise Road *ES10
30 miles per
hour
February 16,
2012
MCCLURE ROAD, between Dry Creek Drive and
Yosemite Ave *ES10
30 miles per
hour
January 13,
2013
MERLE AVENUE, between Oakdale Road and
Roselle Avenue *ES10
30 miles per
hour
December 23,
2014
MERLE AVENUE, between Roselle Avenue and
Claus Road
35 miles per
hour
December 20,
2019
MILLBROOK AVENUE, between Sylvan Avenue and
Floyd Avenue *ES10
25 miles per
hour
January 10,
2013
MILLER AVENUE, between La Loma Avenue and El
Vista Avenue
35 miles per
hour
December 27,
2019
#21..
- 871 -
Created: 2022-07-27 10:51:55 [EST]
(Supp. No. 61)
MITCHELL ROAD, between Finch Road and the
southerly City limits *ES10
50 miles per
hour
December 29,
2011
MORRIS AVENUE, between McHenry Avenue and
Coffee Road *ES10
30 miles per
hour
March 22,
2012
MORSE ROAD, between Blue Gum Avenue and
Kansas Avenue *ES10
40 miles per
hour
February 22,
2012
MT. VERNON DRIVE, between Prescott Road and
College Avenue *ES10
30 miles per
hour
February 3,
2010
NEECE DRIVE, between Tuolumne Boulevard and
Rouse Avenue *ES10
35 miles per
hour
February 22,
2012
NEEDHAM STREET, between 9th Street and L
Street *ES10
35 miles per
hour
March 6, 2012
NORWEGIAN AVENUE, between McHenry Avenue
and Coffee Road
35 miles per
hour
February 20,
2019
OAKDALE ROAD, between Claratina Avenue and
Sylvan Avenue *ES10
45 miles per
hour
March 7, 2012
OAKDALE ROAD, between Sylvan Avenue and
Floyd Avenue
45 miles per
hour
January 8,
2020
OAKDALE ROAD, between Floyd Avenue and
Briggsmore Avenue *ES10
40 miles per
hour
February 3,
2015
OAKDALE ROAD, between Briggsmore Avenue and
Scenic Drive
40 miles per
hour
December 27,
2019
ORANGEBURG AVENUE, between Briggsmore
Avenue and Martin Avenue
35 miles per
hour
September 7,
2018
ORANGEBURG AVENUE, between Martin Avenue
and McHenry Avenue *ES10
40 miles per
hour
March 21,
2012
ORANGEBURG AVENUE, between McHenry
Avenue and Coffee Road *ES10
40 miles per
hour
March 22,
2012
ORANGEBURG AVENUE, between Coffee Road and
Oakdale Road *ES10
35 miles per
hour
March 22,
2012
ORANGEBURG AVENUE, between Oakdale Road
and Lakewood Avenue *ES10
35 miles per
hour
May 17, 2012
ORANGEBURG AVENUE, between Lakewood
Avenue and Claus Road *ES10
35 miles per
hour
May 23, 2013
PARADISE ROAD, between Carpenter Road and
Martin Luther King Drive *ES10
35 miles per
hour
May 23, 2012
#21..
- 872 -
Created: 2022-07-27 10:51:55 [EST]
(Supp. No. 61)