Use the Case Below to Answer the Following Question(s)

question 86

Multiple Choice

Use the case below to answer the following question(s) .
Rolling Inc.produces cars at two plants: Baltimore,Maryland,and Orlando,Florida.They ship them to major distribution centers in Minnesota,Dallas,Los Angeles,and Memphis.The Accounting,Production,and Marketing departments have provided the information in the table below,which shows the unit cost of shipping between any plant and distribution center to minimize the total transportation cost,not exceed available capacity,and meet customer demand. Suppose demand forecasts exceed the existing capacity and the company is considering adding a new plant from among two choices: Ohio or Kansas.Both plants would have a capacity of 3,000 units but only one can be built.The table below shows the revised data. Use double-subscripted variables to simplify the formulation.Define X_ij = amount shipped from plant i to distribution center j,where i = 1 represents Baltimore,and j = 1 represents Minnesota.
Define a binary variable for the decision of which plant to build: Y₁ = 1 if the Ohio plant is built,and Y₂ = 1 if the Kansas plant is built.
-Using Solver,determine the optimal cost involved in shipping cars from Kansas to Memphis.

• A)$48,090
• B)$84,009
• C)$49,080
• D)$98,004

---

Definitions:

Setback

An obstacle or delay in progress that hinders achievement of goals.

Opportunity

A situation or condition that presents a chance for progress or advancement.

Resilient

Able to recover from or adjust easily to misfortune or change.

Responsible

Being responsible involves taking accountability for one's actions and fulfilling obligations and duties.