Formulate and Solve Optimization Models with Binary Variables and Logical

question 6

Multiple Choice

Formulate and solve optimization models with binary variables and logical constraints. LO2: Use a modern software tool to perform statistical calculations.
Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for a plant location model: $\begin{array}{|l|l|l|l|l|l|l|}\hline &{\text { A }} & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } \\\hline 1 & \begin{array}{l}\text { Plant Location } \\\text { Model }\end{array} & & & & & \\\hline 2 & & & & & & \\\hline 3 & \text { Data } & & & & & \\\hline4&&&\text { Distribution Center }\\\hline 5 & \text { Plant } & \text { Houston } & \text { San Jose } & \text { Jacksonville } & \text { Memphis } & \text { Capacity } \\\hline 6 & \text { Dallas } & \$ 11.80 & \$ 16.48 & \$ 12.35 & \$ 18.56 & 1,300 \\\hline 7 & \text { Atlanta } & \$ 8.54 & \$ 14.65 & \$ 9.58 & \$ 18.25 & 750 \\\hline 8 & \text { Detroit } & \$ 12.89 & \$ 10.78 & \$ 7.85 & \$ 10.28 & 1,400 \\\hline 9 & \text { Baltimore } & \$ 14.36 & \$ 18.95 & \$ 14.61 & \$ 6.64 & 1,300 \\\hline 10 & \text { Demand } & 350 & 450 & 800 & 1,700 & \\\hline 11 & \\\hline 12 & \text { Model } \\\hline 13 & \\\hline 14 & \text { Amount Shipped }&&\text { Distribution Center } \\\hline 15 & \text { Plant } & \text { Houston } & \text { San Jose } & \text { Jack sonville } & \text { Memphis } & \text { Total Shipped } \\\hline 16 & \text { Dallas } & & & & & \\\hline 17 & \text { Atlanta } \\\hline 18 & \text { Detroit } \\\hline 19 & \text { Baltimore } \\\hline 20 & \text { Supply } \\\hline 21 & \\\hline 22 & \text { Total Cost } \\\hline 23 & \$ 0.00 \\\hline\end{array}$
-What is the total amount shipped by the Detroit plant to the distribution centers?

• A) 750
• B) 1,000
• C) 1,400
• D) 1,300

---

Definitions:

Ascribed Status

A social position assigned to an individual at birth or assumed involuntarily later in life, often based on race, ethnicity, gender, and family background.

Oprah Winfrey

An influential American media executive, actress, talk show host, television producer, and philanthropist, known for her talk show "The Oprah Winfrey Show."

Tutsi Genocide

The mass slaughter of Tutsi in Rwanda by members of the Hutu majority government in 1994, resulting in the deaths of hundreds of thousands of Tutsi and moderate Hutu.

International Community

A term referring to the collective groups of nations or states and their governments, organizations, and people interacting on a global scale.