This assignment requires you to set up a transportation network for the state of Texast Please see the above introduction powerpoint and introduction video for further dotals. Each submission should be done in Excel, and needs to include the following information: 1. Where the 2DC s are located, as well as which customers are serviced by which DCs. 2. The milenge from each DC to each customer. 3. The number of trucks to each customer. 4. The totai mikage and cost for each transportation rovte. 5. The total overali cost of the network. Demand for next 12 months Our current distribution center closed. I need you to identify two new locations for distribution centers. Rules - Assign no more than 10 stores to one DC - Texarkana =10 \& Huntsville 6 - Texarkana =8 \& Huntsville 8 - Texarkana =6 \& Huntsville 10 - Assume 200 units per truck - Amarillo will need 19 trucks to fulfill the 3700 units. - Assume fixed cost of $100 per truck - They should be within 5 miles of an interstate. Send directions to your phone - Assume variable cost $0.50 per mile one way - Texarkana to Amarillo = 491 miles (Google maps) - All customers must be served in 1 day, so no more than 600 miles This assignment requires you to set up a transportation network for the state of Texast Please see the above introduction powerpoint and introduction video for further dotals. Each submission should be done in Excel, and needs to include the following information: 1. Where the 2DC s are located, as well as which customers are serviced by which DCs. 2. The milenge from each DC to each customer. 3. The number of trucks to each customer. 4. The totai mikage and cost for each transportation rovte. 5. The total overali cost of the network. Demand for next 12 months Our current distribution center closed. I need you to identify two new locations for distribution centers. Rules - Assign no more than 10 stores to one DC - Texarkana =10 \& Huntsville 6 - Texarkana =8 \& Huntsville 8 - Texarkana =6 \& Huntsville 10 - Assume 200 units per truck - Amarillo will need 19 trucks to fulfill the 3700 units. - Assume fixed cost of $100 per truck - They should be within 5 miles of an interstate. Send directions to your phone - Assume variable cost $0.50 per mile one way - Texarkana to Amarillo = 491 miles (Google maps) - All customers must be served in 1 day, so no more than 600 miles