Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Read the following case and answer the seven questions that follow: A company based in Dallas is considering expanding its operation into the Western United
Read the following case and answer the seven questions that follow: A company based in Dallas is considering expanding its operation into the Western United States (Montana, Wyoming, Colorado, New Mexico, Idaho, Utah, Arizona, Nevada, Washington, Oregon, California, Alaska, and Hawaii). Currently, the company does not have any operations in any of these 13 states. For the first phase of the expansion, the company would prefer to select the minimum number of states, such that, for any specific state, either that state is selected or an adjacent state. The 13 states and adjacent states are demonstrated on the next map. For example, New Mexico is adjacent to Colorado, Utah, and Arizona; Alaska does not have an adjacent state; and so on. Formulate and solve this project on Excel and answer the following questions: Washington Montana Oregon Idaho Wyoming . . Nevada Utah Colorado California Arizona New Mexico Hawaii 12. For the second phase of the expansion, the company introduces its operations in more states. The company would prefer to select the minimum number of states, such that, for any specific state, at least two states are selected out of either adjacent states or that state. This new requirement does not apply to Alaska and Hawaii as they don't have adjacent states in this case, treat them as before). Also, the company prefers New Mexico to be nominated in the second phase (if it is not selected in the first phase already). Considering the optimal solution for the second phase of expansion, how many states should be nominated totally in the Western United States? 08 07 11 10 09 15. Which state would definitely is not selected for the second phase of expansion? Wyoming California O Montana Arizona None of the above. 11. Considering the optimal solution, which state would definitely is not selected for the first phase of expansion? None of the above. Utah O Alaska Hawaii Idaho 16. The company would like to update its objective for the first phase of the expansion. It now prefers to maximize the total population of selected states instead of minimizing the number of selected states. It still requires that, for any specific state, at least one state should be selected out of adjacent states or that states. The total number of selected states should not be more than five. The list of states and their latest population estimates (in 1,000,000) are given as follows: Arizona 7 Colorado 5.6 Idaho 1.7 Montana Nevada New Mexico 1 29 2 Utah 3. 1 Wyoming 05 Alaska 0.7 California Hawaii 39.5 14 Oregon Washington 41 74 Considering the optimal solution, which state would definitely is not selected for the updates plan? Colorado Idaho Washington Arizona California Read the following case and answer the seven questions that follow: A company based in Dallas is considering expanding its operation into the Western United States (Montana, Wyoming, Colorado, New Mexico, Idaho, Utah, Arizona, Nevada, Washington, Oregon, California, Alaska, and Hawaii). Currently, the company does not have any operations in any of these 13 states. For the first phase of the expansion, the company would prefer to select the minimum number of states, such that, for any specific state, either that state is selected or an adjacent state. The 13 states and adjacent states are demonstrated on the next map. For example, New Mexico is adjacent to Colorado, Utah, and Arizona; Alaska does not have an adjacent state; and so on. Formulate and solve this project on Excel and answer the following questions: Washington Montana Oregon Idaho Wyoming . . Nevada Utah Colorado California Arizona New Mexico Hawaii 12. For the second phase of the expansion, the company introduces its operations in more states. The company would prefer to select the minimum number of states, such that, for any specific state, at least two states are selected out of either adjacent states or that state. This new requirement does not apply to Alaska and Hawaii as they don't have adjacent states in this case, treat them as before). Also, the company prefers New Mexico to be nominated in the second phase (if it is not selected in the first phase already). Considering the optimal solution for the second phase of expansion, how many states should be nominated totally in the Western United States? 08 07 11 10 09 15. Which state would definitely is not selected for the second phase of expansion? Wyoming California O Montana Arizona None of the above. 11. Considering the optimal solution, which state would definitely is not selected for the first phase of expansion? None of the above. Utah O Alaska Hawaii Idaho 16. The company would like to update its objective for the first phase of the expansion. It now prefers to maximize the total population of selected states instead of minimizing the number of selected states. It still requires that, for any specific state, at least one state should be selected out of adjacent states or that states. The total number of selected states should not be more than five. The list of states and their latest population estimates (in 1,000,000) are given as follows: Arizona 7 Colorado 5.6 Idaho 1.7 Montana Nevada New Mexico 1 29 2 Utah 3. 1 Wyoming 05 Alaska 0.7 California Hawaii 39.5 14 Oregon Washington 41 74 Considering the optimal solution, which state would definitely is not selected for the updates plan? Colorado Idaho Washington Arizona California
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started