Formulate and Solve Optimization Models with Binary Variables and Logical

question 9

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 cost incurred?

• A) $ 27,297
• B) $ 35,233
• C) $ 42,675
• D) $ 47,864

---

Definitions:

Skinner

B.F. Skinner, an American psychologist known for his work in behaviorism and the development of the theory of operant conditioning.

Language Acquisition

The method through which people develop the ability to notice, create, and apply words for the purposes of understanding and interaction.

Telegraphic Speech

A form of communication typical in young children, consisting of short and simple sentences.

Social Interaction

The dynamic process by which people communicate, act, and react in relation to others.