The SW Widget company owns manufacturing plants and distribution centers throughout the Sw. They manufacture widgets in Tucson, Albuquerque, Santa Fe, and San Diego. The widgets are shipped to distribution centers in El Paso, Las Vegas, Denver, and Phoenix This year the SW Widget is expected to produce 250,000 widgets from the Tucson plant, 300,000 widgets from the Albuquerque plant, 175,000 widgets from the Santa Fe Plant, and 225,000 widgets from the San Diego plant The maximum handling capacity for each distribution center is listed below. Distribution Center Handling Capacity El Paso 100,000 Las Vegas 200,000 Denver 300,000 Phoenix 400,000 The transportation costs between farms and processing plants are listed below: Transportation Costs (per widget) Widget Plant El Paso Las Vegas Denver Phoenix Tucson 1.43 136 1.93 1.76 Albuquerque 1.69 1.50 1.09 1.72 Santa Fe 1.19 1.38 1.71 1.80 San Diego 1.83 1.79 1.12 1.00 Which of the following is true This is an unbalanced problem where more widgets are available for handling at the distribution centers than are available to ship at the production plants. This is an unbalanced problem where more widents are available to ship at the production plants than are available forhandling at the distribution centers This is a balanced problem where the number of widgets available to ship at the production plants equals the widgets available for handling at the distribution centers The sw Widget company owns manufacturing plants and distribution centers throughout the SW They manufacture widgets in Tucson, Albuquerque, Santa Fe, and San Diego. The widgets are shipped to distribution centers in El Paso, Las Vegas, Denver, and Phoenix This year the SW Widget is expected to produce 250,000 widgets from the Tucson plant, 300,000 widgets from the Albuquerque plant, 175,000 widgets from the Santa Fe Plant, and 225.000 widgets from the San Diego plant. The maximum handling capacity for each distribution center is listed below Distribution Center Handling Capacity El Paso 100,000 Las Vegas 200,000 Denver 300.000 Phoenix 400,000 The transportation costs between farms and processing plants are listed below Transportation Costs (per widget) Widget Plant El Paso Las Vegas Derwer Phoenix Tucson 143 136 1.93 176 Albuquerque 169 1:50 109 1.72 Santa Fe 119 138 171 1.80 San Diego 183 1.79 1.12 1.00 Which of the following formulas is most appropriate for Cell B9/widgets Received at the El Paso Distribution Center - This cell is ghlighted in RED! Tartu Don Carter w W w ho -25.6.7+ BR-100.000 - 300.000 - 35-36-37-38 - 29.09.09 0-35 36-37-18 The SW Widget company owns manufacturing plants and distribution centers throughout the SW. They manufacture widgets in Tucson, Albuquerque, Santa Fe, and San Diego. The widgets are shipped to distribution centers in El Paso, Las Vegas, Denver, and Phoenix. This year the SW Widget is expected to produce 250,000 widgets from the Tucson plant, 300,000 widgets from the Albuquerque plant, 175,000 widgets from the Santa Fe Plant, and 225.000 widgets from the San Diego plant The maximum handling capacity for each distribution center is listed below: Distribution Center Handling Capacity El Paso 100,000 Las Vegas 200,000 Denver 300.000 Phoenix 400,000 The transportation costs between farms and processing plants are listed below: Transportation Costs (per widget) Widget Plant El Paso Las Vegas Denver Phoenix Tucson 1.43 1.36 1.93 1.76 Albuquerque 1.69 1.50 1.09 1.72 Santa Fe 1.19 1.38 1.71 1.80 San Diego 1.83 1.79 1.12 100 What is the minimum cost that the company can expect to spend transporting widgets in order to ensure all available widgets are shipped to the distribution centers? Do not include dollar signs, commas, or decimal points. Round your answer to the nearest whole number 4 - San Diego 1.83 1.79 1.12 1.00 The Widget Company has decided to ship directly to their customer warehouses Kansas, Oklahoma, Texas, and Washington. The Kansas customer requires at least 200,000 widgets. The Oklahoma customer requires 250,000 widgets. The Texas customer requires at least 250,000 widgets. The Washington customer requires at least 250,000 widgets. The distribution centers do not have any storage space. All widgets must arrive at the customer facilities. The transportation costs between distribution centers and the customer warehouses are listed below: Transportation Costs (per ton) Distribution Center 5 - Kansas 6 - Oklahoma 7-Texas 8- Washington $ A- El Paso $ 2.21 $ 1.51 $ 1.74 2.19 B - Las Vegas $ 1.77 $ 1.21 $ 1.40 $ 1.87 C - Denver $ 2.28 $ 1.93 $ 2.68 S 2.17 D - Phoenix $ 1.09 $ 1.79 $ 1.15 $ 197 Which of the following best describes the constraint to ensure that no widgets are left at the Las Vegas Distribution Center? Oxib+ x2 + x3 + x4b+*5b+x6bx7b+xBb - 0 o Minimize Z-51.36b+$1.50X2b +51 38x3b +$179*x4b+$1.7766512156b51407 $187x85 Oxib+ x2 + x3 + x4 - 5 - 6 - 7 - XBb=0 Oxib+ x2 + x3 + x4+x5b+x6b+x7b+xBb - 200,000 4 - San Diego 1.83 1.79 1.12 1.00 The Widget Company has decided to ship directly to their customer warehouses Kansas, Oklahoma, Texas, and Washington The Kansas customer requires at least 200,000 widgets. The Oklahoma customer requires 250,000 widgets. The Texas customer requires at least 250,000 widgets. The Washington customer requires at least 250,000 widgets. The distribution centers do not have any storage space. All widgets must arrive at the customer facilities. The transportation costs between distribution centers and the customer warehouses are listed below: Transportation Costs (per ton) Distribution Center 5 - Kansas 6 - Oklahoma 7 - Texas 8- Washington A- El Paso $ 2.19 $ 2.21 $ 1.51 $ 1.74 B - Las Vegas $ 1.77 $ 1.21 $ 1.40 $ 1.87 C- Denver $ 2.28 $ 2.17 1.93 2.68 D - Phoenix $ 1.09 $ 1.79 $ 1.97 1.15 How many Decision Variables are there in this problem? 4 - San Diego 1.83 1.79 1.12 1.00 The Widget Company has decided to ship directly to their customer warehouses Kansas, Oklahoma, Texas, and Washington The Kansas customer requires at least 200,000 widgets. The Oklahoma customer requires 250,000 widgets. The Texas customer requires at least 250,000 widgets. The Washington customer requires at least 250,000 widgets. The distribution centers do not have any storage space. All widgets must arrive at the customer facilities. The transportation costs between distribution centers and the customer warehouses are listed below: Transportation Costs (per ton) Distribution Center 5 - Kansas 6 - Oklahoma 7. Texas 8 - Washington $ A- El Paso $ 2.21 2.19 $ 1.51 $ 1.74 B - Las Vegas $ 1.77 $ 1.21 $ 1.40 $ 1.87 C - Denver $ 1.93 $ 2.68 2.28 $ 2.17 D - Phoenix $ 1.09 $ 1.79 $ 1.15 $ 1.97 What is the minimum cost to ship widgets from the manufacturing plants and the customer facilities? Do not include dollar signs, commas, or decimal points. Round your answer to the nearest whole number