Use the table below to answer the following question(s)using the standard Solver.
Below is the spreadsheet for a plant location model:

-What is the total amount shipped by the Dallas plant to the distribution centers?
A)750
B)1,000
C)1,250
D)1,300

Question

Use the table below to answer the following question(s)using the standard Solver.
Below is the spreadsheet for a plant location model:
 
-What is the total amount shipped by the Dallas plant to the distribution centers?
A)750 
B)1,000 
C)1,250 
D)1,300

Quizplus · Accepted Answer

Using the standard Solver in Excel, the optimal solution shows that the Dallas plant should ship 250 units to Distribution Center 1, and 1,000 units to Distribution Center 2. Therefore, the total amount shipped by the Dallas plant to the distribution centers is 1,250 (250+1,000). Hence, the correct answer is C.

Use the Table Below to Answer the Following Question(s)using the Standard