ANSWER USING EXCEL ONLY

CEMEX is a global building materials company that provides high-quality products and reliable services U.S. network includes 10 cement plants, close to 50 strategically located cement terminals, nearly 50 aggregate quarries and more than 280 ready-mix concrete plants In Texas, CEMEX operates 1 cement plant (Balcones), 3 domestic terminals (Fort Worth, Katy, Houston), and 1 marine import terminal (DeZavala), shown in Figure 1 The 5 facilities are responsible for supplying the cement to internal and external customers in the Texas Region Figure 1 Plant: Balcones - Produce clinker and cement, rail and truck cement to domestic terminals, and source both external and ready-mix customers Domestic Terminals: (Mainly supplied with cement from the Balcones plant) Fort Worth - Receive rail from Balcones, only source external customers Katy - Receive rail and truck from Balcones, source both external and ready-mix customers Houston - Receive rail and truck from Balcones, source both external and ready-mix customers Marine Import Terminal: (Mainly supplied with import cement in vessels) DeZavala - Receive vessels from other countries, source both internal and external customers SUPPLY CHAIN CASE: Create analysis and give recommendations for different supply scenarios