Abstract: This research introduces an Excel-based Corridor Planning Tool designed to evaluate and enhance the resilience of California’s agricultural supply chain. The tool utilizes a multi-metric framework to identify and prioritize critical infrastructure components essential for freight movement. A central feature of the methodology is the calculation of a Risk Priority Number (RPN), which identifies high-risk segments for strategic investment. The RPN is calculated by multiplying three distinct scores ranked from 1 to 10: Severity (S), representing the impact of a failure; Occurrence (O), the likelihood of a disruption; and Detection (D), the ease of identifying potential failures. To generate these metrics, the tool requires key inputs including regional agricultural freight volumes, infrastructure condition ratings, and connectivity markers. 

Application of the tool to empirical data demonstrates its utility in identifying specific critical failure points; for instance, results from the research example indicate that a bridge on I-5 in Los Angeles County emerges as the most critical component for maintenance and preservation with an RPN of 443. The second most critical component identified is a ramp on I-5 in Glenn County in California with an RPN of 100. This decision-support system provides Caltrans and regional stakeholders with the necessary insights to move from reactive maintenance to proactive, data-driven management, ensuring that California’s high-value agricultural products move reliably from farm to market.

Dr. Shailesh Chandra is an Associate Professor in the Department of Civil Engineering and Construction Engineering Management (CECEM) at California State University, Long Beach. A recognized expert in connected and automated vehicle (CAV) technology, freight logistics, and intermodal transportation resilience, his research integrates artificial intelligence, big data analytics, and optimization-based modeling to enhance freight transportation network. His extensive work spans critical infrastructure domains, including maritime container ports and urban freight corridors, often in collaboration with major partners like the Port of Long Beach, Caltrans, and the U.S. Department of Transportation. Dr. Chandra was recently honored with a Best Paper Award in 2024 for his impactful analysis of port vehicle efficiency.