Formulate and Solve Optimization Models with Binary Variables and Logical

question 19

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}$
-In which of the following plants is the total amount shipped to the distribution centers equal to zero?

• A) Dallas
• B) Atlanta
• C) Detroit
• D) Baltimore

---

Definitions:

Otoscopic Examination

A visual examination of the ear canal and eardrum using an otoscope, a tool that provides light and magnification.

Buccal Mucosa

The lining of the inside of the cheeks, part of the mouth's mucous membrane.

Child Abuse

Physical, sexual, emotional abuse, or neglect of a child by a caregiver or other person, resulting in harm or potential harm.

Clinic

A facility or a part of a facility that provides outpatient medical care or treatment.