1. Project Title Project # Sponsor Logo Project Team Principal Investigator name Co-Principal Investigator name (s) Graduate Assistant name (s) Undergraduate Assistant name (s) Project Motivation • Gallo Company • The world’s foremost winery in the art and science of grape growing and winemaking • Produces wines in every category, to suit every taste • Gallo’s tank piping network • Age/store • Blend • Bottle • Problems in current pipe routing • Manual tank selection • Reactive scheduling Project Objectives • Model and analyze the current Cellar Tank Piping Network • Research optimal pipe routing path algorithm • Develop customer solution software Project Activities • Current Process Analysis • Problem Formulation • Data Collection and Model Building • Experimental Design • Documentation • Implementation • Validation Research Methodology Network Optimization • Optimization-based piping network analysis • Heuristic-based minimum path analysis with blocking considerations • Analysis of the impact of resource relaxation (i.e., adding pipelines to improve throughput) Model E&J Gallo’s Piping Network • Multi-objective decision making • Minimizes wine damage (routing distance) • Minimizes labor requirement • Maximizes throughput • Resource and piping constraints • Order • Wine assortment • Barrel/tank size • Existing piping network • Proactive scheduling • Order history • Predictive allocation GRAPHIC GRAPHIC GRAPHIC