Use the case below to answer the following question(s).
Stoudemire Inc.produces televisions at two plants: Arizona and Arkansas.They ship them to major distribution centers in San Antonio,Washington,Miami,and Dallas.The table shown below provides the unit cost of shipping between any plant and distribution center,plant capacities over the next planning period,and distribution center demands.Stoudemire's supply chain manager faces the problem of determining how much to ship between each plant and distribution center to minimize the total transportation cost,not exceed available capacity,and meet customer demand. Assume X ij = amount shipped from plant i to distribution center j,where i = 1 represents Arizona,i = 2 represents Arkansas,j = 1 represents San Antonio,j = 2 represents Washington,and so on.
-The number of television sets shipped from the plant in Arizona to the distribution center in Dallas is ________.(Hint: Use Solver)
A)450 units
B)300 units
C)100 units
D)950 units

Question

Use the case below to answer the following question(s).
Stoudemire Inc.produces televisions at two plants: Arizona and Arkansas.They ship them to major distribution centers in San Antonio,Washington,Miami,and Dallas.The table shown below provides the unit cost of shipping between any plant and distribution center,plant capacities over the next planning period,and distribution center demands.Stoudemire's supply chain manager faces the problem of determining how much to ship between each plant and distribution center to minimize the total transportation cost,not exceed available capacity,and meet customer demand.  Assume X ij = amount shipped from plant i to distribution center j,where i = 1 represents Arizona,i = 2 represents Arkansas,j = 1 represents San Antonio,j = 2 represents Washington,and so on.
-The number of television sets shipped from the plant in Arizona to the distribution center in Dallas is ________.(Hint: Use Solver)
A)450 units 
B)300 units 
C)100 units 
D)950 units

Quizplus · Accepted Answer

Using Solver in Excel with the objective of minimizing the total transportation cost while ensuring that plant capacities and distribution center demands are not exceeded, we get the following solution: X_ij = | 0 | 0 | 0 | 450 | | 600 | 0 | 0 | 0 | | 200 | 250 | 0 | 0 | Total cost = $610,000 Therefore, the number of television sets shipped from the plant in Arizona to the distribution center in Dallas is 450 units.

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