Deck 25: The Transportation Models

Full screen (f)
exit full mode
Question
17)A transportation problem in which the total number of supply units available is greater than the demand requirements or vice versa is called ______.

A)balanced transportation problem
B)unbalanced transportation problem
C)improved transportation problem
D)feasible transportation problem
Use Space or
up arrow
down arrow
to flip the card.
Question
1)Which of the following is a special case of linear programming problems in which the objective is to minimize the total cost of transporting goods from the various supply origins to the different demand destinations?

A)transportation model
B)Simplex LP
C)iso-profit line method
D)corner point solution method
Question
9)Which of the following statements is FALSE about methods involved in solving a transportation problem?

A)Matrix least cost method reduces the number of computations and the time required to determine the optimal solution.
B)Northwest corner rule is intuitively more appealing and has better rationale than the matrix least cost method.
C)Northwest corner rule begins at the top left-hand corner of the matrix and allocates units until either the supply is exhausted or demand is met.
D)Matrix least cost method begins with the cell that has the lowest per unit cost and allocates units until either the supply is exhausted or demand is met.
Question
5)Which of the following methods involves first allocating shipping units to the northwest (top left-hand)corner of the transportation matrix and then proceeding systematically by making allocations of shipping units to cells along either a row or column until the bottom right-hand corner of the matrix is reached?

A)matrix least cost method
B)matrix maximum profit method
C)northwest corner rule
D)stepping stone method
Question
19)A fictitious supply source created to arrive at a balanced transportation problem (i.e.,total demand = total supply)is called ______.

A)dummy supply destination
B)dummy demand destination
C)dummy supply source
D)fictitious supply source
Question
8)______ refer to the occupied cells in the initial solution of the transportation matrix,which are used in arriving at an improved solution.

A)Stepping stones
B)Reference cells
C)Variable cells
D)Improvement matrix methods
Question
15)Which of the following is a FALSE assumption about the transportation model?

A)Capacity at each supply location or origin is limited.
B)Demand requirements at each destination are known.
C)Regardless of their origin or destination,the items shipped are homogenous.
D)Between each origin and destination,there are multiple routes used.
Question
6)With the ______ method,an initial feasible solution to the transportation problem is obtained by allocating shipments beginning with the route that has the lowest cost of transportation.

A)matrix least cost method
B)matrix maximum profit method
C)northwest corner rule
D)stepping stone method
Question
12)In the stepping stone method,when the value is obtained by summing up the unit costs in the cells with a plus sign,and then from the resulting total,subtracting the sum obtained by adding the unit costs in cells containing a minus sign,it is called ______.

A)improvement index
B)performance index
C)evaluation index
D)selection index
Question
13)In the stepping stone model,a nondegenerate optimum solution obtained should satisfy ______ conditions.

A)two
B)three
C)four
D)five
Question
20)A condition that occurs when the solution to a transportation problem has occupied routes(cells)that are less than (number of origins + the number of destinations -1)is called ______.

A)degeneracy
B)nondegeneracy
C)optimality
D)feasibility
Question
3)Once an initial solution is established in a transportation model problem,we will use the ______ method to progress from the initial feasible solution to an optimal solution.

A)matrix least cost
B)matrix maximum profit
C)northwest corner
D)stepping stone
Question
18)A fictitious demand destination created to arrive at a balanced transportation problem (i.e.,total demand = total supply)is called ______.

A)dummy supply destination
B)dummy demand destination
C)dummy supply source
D)fictitious demand destination
Question
14)Which of the following is one of the conditions that a nondegenerate optimum solution obtained in the stepping stone method should satisfy?

A)The number of cells with positive allocations should be less than the number of rows plus the number of columns in the transportation matrix.
B)The number of cells with positive allocations should be greater than the number of rows minus the number of columns in the transportation matrix.
C)The number of cells with positive allocations should be equal to the number of rows plus the number of columns in the transportation matrix minus one.
D)The number of cells with positive allocations should be equal to the number of rows plus the number of columns in the transportation matrix.
Question
11)Which of the following statements is FALSE about the stepping stone method?

A)A closed path is drawn,using only horizontal and vertical moves.
B)Turning corners should occur only on occupied cells.
C)Stepping over any occupied or unoccupied cell is not allowed.
D)If the improvement indices have values greater than or equal to zero,then the current solution is optimal.
Question
4)Which of the following is one of the methods to establish an initial feasible solution in a transportation model problem?

A)matrix maximum profit method
B)stepping stone method
C)matrix least cost method
D)transportation matrix method
Question
16)A transportation problem in which the number of units demanded is equal to the total number of supply units available is called ______.

A)balanced transportation problem
B)unbalanced transportation problem
C)improved transportation problem
D)feasible transportation problem
Question
7)Which of the following is an iterative process that will enable us to move from an initial feasible solution to finding an optimal solution to the transportation problem?

A)matrix least cost method
B)matrix maximum profit method
C)northwest corner rule
D)stepping stone method
Question
10)To find the optimal solution using the stepping stone method,first select a(n)______ in the initial basic feasible solution to be evaluated.

A)occupied cell
B)empty cell
C)referenced cell
D)variable cell
Question
2)To solve a transportation model,we should first set up the problem as a ______.

A)transportation objective
B)transportation matrix
C)transportation product mix
D)northwest corner rule
Question
30)______ refers to a fictitious supply source created to arrive at a balanced transportation problem (i.e.,total demand = total supply).

A)Balanced transportation problem
B)Degeneracy
C)Dummy demand destinations
D)Dummy supply sources
Question
<strong>  40)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total transportation costs are ______.</strong> A)$57,500 B)$35,000 C)$48,900 D)$68,125 <div style=padding-top: 35px>
40)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total transportation costs are ______.

A)$57,500
B)$35,000
C)$48,900
D)$68,125
Question
21)To overcome the problem of degeneracy,it is required to create a(n)______.

A)artificially occupied cell
B)occupied cell
C)unoccupied cell
D)empty cell
Question
<strong>  39)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the highest transportation costs are from ______.</strong> A)Riverside to Visalia B)Bryan to Dayton C)Montgomery to Visalia D)Riverside to Huntsville <div style=padding-top: 35px>
39)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the highest transportation costs are from ______.

A)Riverside to Visalia
B)Bryan to Dayton
C)Montgomery to Visalia
D)Riverside to Huntsville
Question
<strong>  37)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total production at Montgomery is ______.</strong> A)2,500 B)3,500 C)4,500 D)5,500 <div style=padding-top: 35px>
37)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total production at Montgomery is ______.

A)2,500
B)3,500
C)4,500
D)5,500
Question
25)While using the stepping stone method,if the improvement indices for all unoccupied cells are positive,then the improved solution is ______.

A)optimal
B)feasible
C)erroneous
D)nondegenerate
Question
29)______ refers to a fictitious demand destination created to arrive at a balanced transportation problem (i.e.,total demand = total supply).

A)Balanced transportation problem
B)Degeneracy
C)Dummy demand destinations
D)Dummy supply sources
Question
24)XYZ has three supply chain locations with respective production capacities of an electronic component (Denver,Milwaukee,and Columbia)and three demand locations with their respective demand requirements for that electronic component.The demand requirements,production capacities,and the per-unit transportation costs are tabled in the transportation matrix shown here.Determine the initial shipping cost using the matrix least cost method. <strong>24)XYZ has three supply chain locations with respective production capacities of an electronic component (Denver,Milwaukee,and Columbia)and three demand locations with their respective demand requirements for that electronic component.The demand requirements,production capacities,and the per-unit transportation costs are tabled in the transportation matrix shown here.Determine the initial shipping cost using the matrix least cost method.  </strong> A)$30,000 B)$40,000 C)$24,000 D)$31,000 <div style=padding-top: 35px>

A)$30,000
B)$40,000
C)$24,000
D)$31,000
Question
31)The ______ is a special case of linear programming problems in which the objective is to minimize the total cost of transporting goods from the various supply origins to the different demand destinations.

A)transportation model
B)integer programming
C)warehousing problem
D)workforce scheduling model
Question
23)XYZ has three supply chain locations with respective production capacities of an electronic component (Denver,Milwaukee,and Columbia)and three demand locations with their respective demand requirements for that electronic component.The demand requirements,production capacities,and the per-unit transportation costs are tabled in the transportation matrix shown here.Determine the initial shipping cost using the northwest corner rule. <strong>23)XYZ has three supply chain locations with respective production capacities of an electronic component (Denver,Milwaukee,and Columbia)and three demand locations with their respective demand requirements for that electronic component.The demand requirements,production capacities,and the per-unit transportation costs are tabled in the transportation matrix shown here.Determine the initial shipping cost using the northwest corner rule.  </strong> A)$30,000 B)$40,000 C)$24,000 D)$34,000 <div style=padding-top: 35px>

A)$30,000
B)$40,000
C)$24,000
D)$34,000
Question
<strong>  36)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the shipment of widgets from Riverside to Huntsville is ______.</strong> A)2,500 B)4,200 C)4,500 D)5,000 <div style=padding-top: 35px>
36)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the shipment of widgets from Riverside to Huntsville is ______.

A)2,500
B)4,200
C)4,500
D)5,000
Question
32)______ refers to a problem in which the total number of supply units available is greater than the demand requirements,or vice versa.

A)An unbalanced transportation problem
B)An integer programming problem
C)A warehousing problem
D)A network problem
Question
<strong>  38)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the shipment from Montgomery to Huntsville is ______.</strong> A)0 B)3,500 C)4,500 D)5,500 <div style=padding-top: 35px>
38)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the shipment from Montgomery to Huntsville is ______.

A)0
B)3,500
C)4,500
D)5,500
Question
33)We can use the matrix least cost method to solve transportation problems.In this method,an initial feasible solution to the transportation problem is obtained by ______.

A)allocating shipments ending with the route that has the lowest unit cost of transportation
B)allocating shipments beginning with the route that has the lowest unit cost of transportation
C)allocating shipments beginning with the route that has the highest unit cost of transportation
D)allocating shipments ending with the route that has the highest unit cost of transportation
Question
26)Which of the following is true about the northwest corner rule?

A)It generates neither feasible solutions nor optimum least-cost solutions.
B)It generates both feasible solutions and optimum least-cost solutions.
C)It generates feasible solutions but not necessarily optimum least-cost solutions.
D)It generates optimum least-cost solutions but not necessarily feasible solutions.
Question
22)Consider the transportation matrix that follows.The transportation problem can be labeled as a(n)______ transportation problem. <strong>22)Consider the transportation matrix that follows.The transportation problem can be labeled as a(n)______ transportation problem.  </strong> A)balanced B)unbalanced C)partly occupied D)artificially occupied <div style=padding-top: 35px>

A)balanced
B)unbalanced
C)partly occupied
D)artificially occupied
Question
34)The matrix least cost method to solve transportation problems has several advantages.Which of the following is NOT one of them?

A)The matrix least cost method has better rationale than the northwest corner rule.
B)The matrix least cost method is less appealing than the northwest corner method.
C)The matrix least cost method reduces the number of computations required to determine the optimal solution.
D)The matrix least cost method reduces the time required to determine the optimal solution.
Question
28)______ refers to a condition that occurs when the solution to a transportation problem has occupied routes (cells)that are less than the (number of origins + the number of destinations - 1).

A)Balanced transportation problem
B)Degeneracy
C)Dummy demand destinations
D)Dummy supply sources
Question
<strong>  35)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total shipment of widgets from Bryan to Dayton is ______.</strong> A)2,000 B)3,500 C)4,500 D)3,000 <div style=padding-top: 35px>
35)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total shipment of widgets from Bryan to Dayton is ______.

A)2,000
B)3,500
C)4,500
D)3,000
Question
27)If,in a transportation problem,the total number of units demanded is equal to the total number of supply units available,the transportation problem is then described as ______.

A)balanced
B)degenerate
C)unbalanced
D)feasible
Question
<strong>  57)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Aberdeen to Kalamazoo are $5,920. B)The shipping costs from Cairo to Kalamazoo are $5,920. C)The shipping costs from Aberdeen to Navarre are $1,560. D)The shipping costs from Danbury to Navarre are $1,560. <div style=padding-top: 35px>
57)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Aberdeen to Kalamazoo are $5,920.
B)The shipping costs from Cairo to Kalamazoo are $5,920.
C)The shipping costs from Aberdeen to Navarre are $1,560.
D)The shipping costs from Danbury to Navarre are $1,560.
Question
<strong>  53)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The number of units shipped from Kolkata to Naples is one fourth of the total quantity produced by Tokyo. B)The Naples market requires more than can be produced by Tokyo alone. C)The quantity shipped from Tokyo to Naples is equal to the quantity shipped from Bangkok to Naples. D)The cost of producing/shipping from Tokyo to Naples is more than the cost of producing/shipping from Kolkata to Naples. <div style=padding-top: 35px>
53)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The number of units shipped from Kolkata to Naples is one fourth of the total quantity produced by Tokyo.
B)The Naples market requires more than can be produced by Tokyo alone.
C)The quantity shipped from Tokyo to Naples is equal to the quantity shipped from Bangkok to Naples.
D)The cost of producing/shipping from Tokyo to Naples is more than the cost of producing/shipping from Kolkata to Naples.
Question
<strong>  55)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Aberdeen to Kalamazoo are $10,920. B)The shipping costs from Aberdeen to Kalamazoo are $1,695. C)The shipping costs from Escondido to Winston are $10,506. D)The shipping costs from Danbury to Navarre are $10,908. <div style=padding-top: 35px>
55)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Aberdeen to Kalamazoo are $10,920.
B)The shipping costs from Aberdeen to Kalamazoo are $1,695.
C)The shipping costs from Escondido to Winston are $10,506.
D)The shipping costs from Danbury to Navarre are $10,908.
Question
<strong>  59)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Escondido to Kalamazoo are $10,908. B)The shipping costs from Aberdeen to Lakeland are $1,685. C)The shipping costs from Aberdeen to Madison are $18,414. D)The shipping costs from Fairview to Madison are $18,414. <div style=padding-top: 35px>
59)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Escondido to Kalamazoo are $10,908.
B)The shipping costs from Aberdeen to Lakeland are $1,685.
C)The shipping costs from Aberdeen to Madison are $18,414.
D)The shipping costs from Fairview to Madison are $18,414.
Question
<strong>  56)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Aberdeen to Kalamazoo are $10,920. B)The shipping costs from Cairo to Kalamazoo are $6,946. C)The shipping costs from Escondido to Winston are $10,606. D)The shipping costs from Danbury to Navarre are $10,908. <div style=padding-top: 35px>
56)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Aberdeen to Kalamazoo are $10,920.
B)The shipping costs from Cairo to Kalamazoo are $6,946.
C)The shipping costs from Escondido to Winston are $10,606.
D)The shipping costs from Danbury to Navarre are $10,908.
Question
<strong>  60)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Danbury to Lakeland are $23,280. B)The shipping costs from Aberdeen to Lakeland are $1,795. C)The shipping costs from Aberdeen to Madison are $18,414. D)The shipping costs from Fairview to Madison are $18,414. <div style=padding-top: 35px>
60)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Danbury to Lakeland are $23,280.
B)The shipping costs from Aberdeen to Lakeland are $1,795.
C)The shipping costs from Aberdeen to Madison are $18,414.
D)The shipping costs from Fairview to Madison are $18,414.
Question
<strong>  43)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero costs are from ______.</strong> A)Tokyo to Naples B)Tokyo to Paris C)Kolkata to Naples D)Bangkok to Naples <div style=padding-top: 35px>
43)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero costs are from ______.

A)Tokyo to Naples
B)Tokyo to Paris
C)Kolkata to Naples
D)Bangkok to Naples
Question
<strong>  41)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero quantity shipped is from ______.</strong> A)Montgomery to Visalia B)Riverside to Visalia C)Montgomery to Dayton D)Bryan to Huntsville <div style=padding-top: 35px>
41)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero quantity shipped is from ______.

A)Montgomery to Visalia
B)Riverside to Visalia
C)Montgomery to Dayton
D)Bryan to Huntsville
Question
<strong>  46)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Tokyo to Naples is ______.</strong> A)$42,120 B)$26,080 C)$123,743 D)$160,132 <div style=padding-top: 35px>
46)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Tokyo to Naples is ______.

A)$42,120
B)$26,080
C)$123,743
D)$160,132
Question
<strong>  58)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Danbury to Lakeland are $10,908. B)The shipping costs from Aberdeen to Lakeland are $1,695. C)The shipping costs from Aberdeen to Madison are $18,414. D)The shipping costs from Fairview to Madison are $18,414. <div style=padding-top: 35px>
58)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Danbury to Lakeland are $10,908.
B)The shipping costs from Aberdeen to Lakeland are $1,695.
C)The shipping costs from Aberdeen to Madison are $18,414.
D)The shipping costs from Fairview to Madison are $18,414.
Question
<strong>  42)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero transportation costs are from ______.</strong> A)Montgomery to Visalia B)Riverside to Visalia C)Montgomery to Dayton D)Bryan to Huntsville <div style=padding-top: 35px>
42)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero transportation costs are from ______.

A)Montgomery to Visalia
B)Riverside to Visalia
C)Montgomery to Dayton
D)Bryan to Huntsville
Question
<strong>  48)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Bangkok to Naples are ______.</strong> A)$42,120 B)$86,100 C)$123,743 D)$160,132 <div style=padding-top: 35px>
48)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Bangkok to Naples are ______.

A)$42,120
B)$86,100
C)$123,743
D)$160,132
Question
<strong>  49)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,demand in which market can be met only by producing in all three production areas?</strong> A)Naples B)Paris C)Amsterdam D)both Naples and Paris <div style=padding-top: 35px>
49)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,demand in which market can be met only by producing in all three production areas?

A)Naples
B)Paris
C)Amsterdam
D)both Naples and Paris
Question
<strong>  52)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Tokyo to all three markets is ______.</strong> A)7,200 B)4,850 C)3,500 D)2,475 <div style=padding-top: 35px>
52)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Tokyo to all three markets is ______.

A)7,200
B)4,850
C)3,500
D)2,475
Question
<strong>  47)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Tokyo to Amsterdam is ______.</strong> A)$42,120 B)$26,080 C)$123,743 D)$160,132 <div style=padding-top: 35px>
47)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Tokyo to Amsterdam is ______.

A)$42,120
B)$26,080
C)$123,743
D)$160,132
Question
<strong>  45)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Kolkata to Naples is ______.</strong> A)$42,120 B)$26,080 C)$123,743 D)$160,132 <div style=padding-top: 35px>
45)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Kolkata to Naples is ______.

A)$42,120
B)$26,080
C)$123,743
D)$160,132
Question
<strong>  50)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the production area is shipping to all three markets?</strong> A)Bangkok B)Kolkata C)Tokyo D)none of these <div style=padding-top: 35px>
50)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the production area is shipping to all three markets?

A)Bangkok
B)Kolkata
C)Tokyo
D)none of these
Question
<strong>  51)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Tokyo to Naples is ______.</strong> A)500 B)1,200 C)3,500 D)4,850 <div style=padding-top: 35px>
51)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Tokyo to Naples is ______.

A)500
B)1,200
C)3,500
D)4,850
Question
<strong>  44)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total costs are ______.</strong> A)$283,475 B)$438,175 C)$356,787 D)$523,412 <div style=padding-top: 35px>
44)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total costs are ______.

A)$283,475
B)$438,175
C)$356,787
D)$523,412
Question
<strong>  54)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Aberdeen to Kalamazoo are $8,112. B)The shipping costs from Aberdeen to Kalamazoo are $1,695. C)The shipping costs from Danbury to Navarre are $6,946. D)The shipping costs from Danbury to Navarre are $10,908. <div style=padding-top: 35px>
54)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Aberdeen to Kalamazoo are $8,112.
B)The shipping costs from Aberdeen to Kalamazoo are $1,695.
C)The shipping costs from Danbury to Navarre are $6,946.
D)The shipping costs from Danbury to Navarre are $10,908.
Question
<strong>  63)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Brighton to Navarre are $21,672. B)The shipping costs from Cairo to Navarre are $5,580. C)The shipping costs from Cairo to Sacramento are $9,570. D)The shipping costs from Fairview to Madison are $18,414. <div style=padding-top: 35px>
63)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Brighton to Navarre are $21,672.
B)The shipping costs from Cairo to Navarre are $5,580.
C)The shipping costs from Cairo to Sacramento are $9,570.
D)The shipping costs from Fairview to Madison are $18,414.
Question
<strong>  72)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The quantity shipped from Birmingham to Madison is more than double the quantity shipped from Brighton to Madison. B)The quantity shipped from Danbury to Navarre is more than the quantity shipped from Cairo to Kalamazoo. C)The quantity shipped from Birmingham to Madison is less than the quantity shipped from Brighton to Madison. D)The quantity shipped from Escondido to Winston is less than the quantity shipped from Danbury to Sacramento. <div style=padding-top: 35px>
72)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The quantity shipped from Birmingham to Madison is more than double the quantity shipped from Brighton to Madison.
B)The quantity shipped from Danbury to Navarre is more than the quantity shipped from Cairo to Kalamazoo.
C)The quantity shipped from Birmingham to Madison is less than the quantity shipped from Brighton to Madison.
D)The quantity shipped from Escondido to Winston is less than the quantity shipped from Danbury to Sacramento.
Question
<strong>  78)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Downey to Norfolk is ______.</strong> A)69 B)617 C)243 D)433 <div style=padding-top: 35px>
78)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Downey to Norfolk is ______.

A)69
B)617
C)243
D)433
Question
<strong>  70)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The lowest non-zero shipment is from Aberdeen to Lakeland. B)The lowest non-zero shipment is from Birmingham to Kalamazoo. C)The lowest non-zero shipment is from Cairo to Winston. D)The lowest non-zero shipment is from Fairview to Navarre. <div style=padding-top: 35px>
70)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The lowest non-zero shipment is from Aberdeen to Lakeland.
B)The lowest non-zero shipment is from Birmingham to Kalamazoo.
C)The lowest non-zero shipment is from Cairo to Winston.
D)The lowest non-zero shipment is from Fairview to Navarre.
Question
<strong>  61)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Danbury to Lakeland are $2,418. B)The shipping costs from Aberdeen to Lakeland are $1,795. C)The shipping costs from Birmingham to Madison are $18,910. D)The shipping costs from Fairview to Madison are $18,414. <div style=padding-top: 35px>
61)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Danbury to Lakeland are $2,418.
B)The shipping costs from Aberdeen to Lakeland are $1,795.
C)The shipping costs from Birmingham to Madison are $18,910.
D)The shipping costs from Fairview to Madison are $18,414.
Question
<strong>  80)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Downey to Shreveport is ______.</strong> A)527 B)617 C)243 D)433 <div style=padding-top: 35px>
80)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Downey to Shreveport is ______.

A)527
B)617
C)243
D)433
Question
<strong>  62)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Danbury to Lakeland are $2,418. B)The shipping costs from Aberdeen to Lakeland are $1,795. C)The shipping costs from Brighton to Madison are $0. D)The shipping costs from Fairview to Madison are $18,414. <div style=padding-top: 35px>
62)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Danbury to Lakeland are $2,418.
B)The shipping costs from Aberdeen to Lakeland are $1,795.
C)The shipping costs from Brighton to Madison are $0.
D)The shipping costs from Fairview to Madison are $18,414.
Question
<strong>  73)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total shipping costs are approximately ______.</strong> A)$150,000 B)$950,000 C)$215,000 D)$425,000 <div style=padding-top: 35px>
73)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total shipping costs are approximately ______.

A)$150,000
B)$950,000
C)$215,000
D)$425,000
Question
<strong>  64)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Brighton to Navarre are $12,462. B)The shipping costs from Cairo to Navarre are $5,580. C)The shipping costs from Cairo to Sacramento are $18,414. D)The shipping costs from Fairview to Madison are $18,414. <div style=padding-top: 35px>
64)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Brighton to Navarre are $12,462.
B)The shipping costs from Cairo to Navarre are $5,580.
C)The shipping costs from Cairo to Sacramento are $18,414.
D)The shipping costs from Fairview to Madison are $18,414.
Question
<strong>  65)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Brighton to Navarre are $12,462. B)The shipping costs from Fairview to Winston are $18,368. C)The shipping costs from Cairo to Sacramento are $2,244. D)The shipping costs from Fairview to Madison are $18,414. <div style=padding-top: 35px>
65)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Brighton to Navarre are $12,462.
B)The shipping costs from Fairview to Winston are $18,368.
C)The shipping costs from Cairo to Sacramento are $2,244.
D)The shipping costs from Fairview to Madison are $18,414.
Question
<strong>  77)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Knoxville to Mobile is ______.</strong> A)592 B)617 C)243 D)433 <div style=padding-top: 35px>
77)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Knoxville to Mobile is ______.

A)592
B)617
C)243
D)433
Question
<strong>  67)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping cost from all plants to Kalamazoo is $15,656. B)The shipping cost from all plants to Lakeland is $24,975. C)The shipping cost from all plants to Madison is $23,225. D)The shipping cost from all plants to Winston is $21,123. <div style=padding-top: 35px>
67)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping cost from all plants to Kalamazoo is $15,656.
B)The shipping cost from all plants to Lakeland is $24,975.
C)The shipping cost from all plants to Madison is $23,225.
D)The shipping cost from all plants to Winston is $21,123.
Question
<strong>  74)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total shipping costs are approximately:</strong> A)$2,321 B)$4,384 C)$3,310 D)$5,921 <div style=padding-top: 35px>
74)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total shipping costs are approximately:

A)$2,321
B)$4,384
C)$3,310
D)$5,921
Question
<strong>  75)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the highest shipping costs are from ______.</strong> A)Lowell to Shreveport B)Lowell to Norfolk C)Lowell to Mobile D)Lowell to Richmond <div style=padding-top: 35px>
75)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the highest shipping costs are from ______.

A)Lowell to Shreveport
B)Lowell to Norfolk
C)Lowell to Mobile
D)Lowell to Richmond
Question
<strong>  71)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The quantity shipped from Danbury to Navarre is more than the quantity shipped from Cairo to Kalamazoo. B)The quantity shipped from Escondido to Kalamazoo is more than the quantity shipped from Cairo to Kalamazoo. C)The quantity shipped from Birmingham to Madison is less than the quantity shipped from Brighton to Madison. D)The quantity shipped from Escondido to Winston is less than the quantity shipped from Danbury to Sacramento. <div style=padding-top: 35px>
71)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The quantity shipped from Danbury to Navarre is more than the quantity shipped from Cairo to Kalamazoo.
B)The quantity shipped from Escondido to Kalamazoo is more than the quantity shipped from Cairo to Kalamazoo.
C)The quantity shipped from Birmingham to Madison is less than the quantity shipped from Brighton to Madison.
D)The quantity shipped from Escondido to Winston is less than the quantity shipped from Danbury to Sacramento.
Question
<strong>  66)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping cost from all plants to Kalamazoo is $25,966. B)The shipping cost from all plants to Lakeland is $17,000. C)The shipping cost from all plants to Madison is $23,225. D)The shipping cost from all plants to Winston is $21,123. <div style=padding-top: 35px>
66)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping cost from all plants to Kalamazoo is $25,966.
B)The shipping cost from all plants to Lakeland is $17,000.
C)The shipping cost from all plants to Madison is $23,225.
D)The shipping cost from all plants to Winston is $21,123.
Question
<strong>  68)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping cost from all plants to Kalamazoo is $15,656. B)The shipping cost from all plants to Lakeland is $14,280. C)The shipping cost from all plants to Madison is $28,810. D)The shipping cost from all plants to Winston is $21,123. <div style=padding-top: 35px>
68)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping cost from all plants to Kalamazoo is $15,656.
B)The shipping cost from all plants to Lakeland is $14,280.
C)The shipping cost from all plants to Madison is $28,810.
D)The shipping cost from all plants to Winston is $21,123.
Question
<strong>  76)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero shipping costs are from ______.</strong> A)Downey to Norfolk B)Knoxville to Mobile C)Bloomington to Norfolk D)Chattanooga to Saginaw <div style=padding-top: 35px>
76)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero shipping costs are from ______.

A)Downey to Norfolk
B)Knoxville to Mobile
C)Bloomington to Norfolk
D)Chattanooga to Saginaw
Question
<strong>  69)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping cost from all plants to Kalamazoo is $15,656. B)The shipping cost from all plants to Lakeland is $14,280. C)The shipping cost from all plants to Madison is $18,345. D)The shipping cost from all plants to Winston is $28,874. <div style=padding-top: 35px>
69)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping cost from all plants to Kalamazoo is $15,656.
B)The shipping cost from all plants to Lakeland is $14,280.
C)The shipping cost from all plants to Madison is $18,345.
D)The shipping cost from all plants to Winston is $28,874.
Question
<strong>  79)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Downey to Saginaw is ______.</strong> A)191 B)617 C)243 D)433 <div style=padding-top: 35px>
79)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Downey to Saginaw is ______.

A)191
B)617
C)243
D)433
Unlock Deck
Sign up to unlock the cards in this deck!
Unlock Deck
Unlock Deck
1/100
auto play flashcards
Play
simple tutorial
Full screen (f)
exit full mode
Deck 25: The Transportation Models
1
17)A transportation problem in which the total number of supply units available is greater than the demand requirements or vice versa is called ______.

A)balanced transportation problem
B)unbalanced transportation problem
C)improved transportation problem
D)feasible transportation problem
B
2
1)Which of the following is a special case of linear programming problems in which the objective is to minimize the total cost of transporting goods from the various supply origins to the different demand destinations?

A)transportation model
B)Simplex LP
C)iso-profit line method
D)corner point solution method
A
3
9)Which of the following statements is FALSE about methods involved in solving a transportation problem?

A)Matrix least cost method reduces the number of computations and the time required to determine the optimal solution.
B)Northwest corner rule is intuitively more appealing and has better rationale than the matrix least cost method.
C)Northwest corner rule begins at the top left-hand corner of the matrix and allocates units until either the supply is exhausted or demand is met.
D)Matrix least cost method begins with the cell that has the lowest per unit cost and allocates units until either the supply is exhausted or demand is met.
B
4
5)Which of the following methods involves first allocating shipping units to the northwest (top left-hand)corner of the transportation matrix and then proceeding systematically by making allocations of shipping units to cells along either a row or column until the bottom right-hand corner of the matrix is reached?

A)matrix least cost method
B)matrix maximum profit method
C)northwest corner rule
D)stepping stone method
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
5
19)A fictitious supply source created to arrive at a balanced transportation problem (i.e.,total demand = total supply)is called ______.

A)dummy supply destination
B)dummy demand destination
C)dummy supply source
D)fictitious supply source
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
6
8)______ refer to the occupied cells in the initial solution of the transportation matrix,which are used in arriving at an improved solution.

A)Stepping stones
B)Reference cells
C)Variable cells
D)Improvement matrix methods
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
7
15)Which of the following is a FALSE assumption about the transportation model?

A)Capacity at each supply location or origin is limited.
B)Demand requirements at each destination are known.
C)Regardless of their origin or destination,the items shipped are homogenous.
D)Between each origin and destination,there are multiple routes used.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
8
6)With the ______ method,an initial feasible solution to the transportation problem is obtained by allocating shipments beginning with the route that has the lowest cost of transportation.

A)matrix least cost method
B)matrix maximum profit method
C)northwest corner rule
D)stepping stone method
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
9
12)In the stepping stone method,when the value is obtained by summing up the unit costs in the cells with a plus sign,and then from the resulting total,subtracting the sum obtained by adding the unit costs in cells containing a minus sign,it is called ______.

A)improvement index
B)performance index
C)evaluation index
D)selection index
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
10
13)In the stepping stone model,a nondegenerate optimum solution obtained should satisfy ______ conditions.

A)two
B)three
C)four
D)five
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
11
20)A condition that occurs when the solution to a transportation problem has occupied routes(cells)that are less than (number of origins + the number of destinations -1)is called ______.

A)degeneracy
B)nondegeneracy
C)optimality
D)feasibility
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
12
3)Once an initial solution is established in a transportation model problem,we will use the ______ method to progress from the initial feasible solution to an optimal solution.

A)matrix least cost
B)matrix maximum profit
C)northwest corner
D)stepping stone
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
13
18)A fictitious demand destination created to arrive at a balanced transportation problem (i.e.,total demand = total supply)is called ______.

A)dummy supply destination
B)dummy demand destination
C)dummy supply source
D)fictitious demand destination
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
14
14)Which of the following is one of the conditions that a nondegenerate optimum solution obtained in the stepping stone method should satisfy?

A)The number of cells with positive allocations should be less than the number of rows plus the number of columns in the transportation matrix.
B)The number of cells with positive allocations should be greater than the number of rows minus the number of columns in the transportation matrix.
C)The number of cells with positive allocations should be equal to the number of rows plus the number of columns in the transportation matrix minus one.
D)The number of cells with positive allocations should be equal to the number of rows plus the number of columns in the transportation matrix.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
15
11)Which of the following statements is FALSE about the stepping stone method?

A)A closed path is drawn,using only horizontal and vertical moves.
B)Turning corners should occur only on occupied cells.
C)Stepping over any occupied or unoccupied cell is not allowed.
D)If the improvement indices have values greater than or equal to zero,then the current solution is optimal.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
16
4)Which of the following is one of the methods to establish an initial feasible solution in a transportation model problem?

A)matrix maximum profit method
B)stepping stone method
C)matrix least cost method
D)transportation matrix method
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
17
16)A transportation problem in which the number of units demanded is equal to the total number of supply units available is called ______.

A)balanced transportation problem
B)unbalanced transportation problem
C)improved transportation problem
D)feasible transportation problem
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
18
7)Which of the following is an iterative process that will enable us to move from an initial feasible solution to finding an optimal solution to the transportation problem?

A)matrix least cost method
B)matrix maximum profit method
C)northwest corner rule
D)stepping stone method
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
19
10)To find the optimal solution using the stepping stone method,first select a(n)______ in the initial basic feasible solution to be evaluated.

A)occupied cell
B)empty cell
C)referenced cell
D)variable cell
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
20
2)To solve a transportation model,we should first set up the problem as a ______.

A)transportation objective
B)transportation matrix
C)transportation product mix
D)northwest corner rule
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
21
30)______ refers to a fictitious supply source created to arrive at a balanced transportation problem (i.e.,total demand = total supply).

A)Balanced transportation problem
B)Degeneracy
C)Dummy demand destinations
D)Dummy supply sources
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
22
<strong>  40)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total transportation costs are ______.</strong> A)$57,500 B)$35,000 C)$48,900 D)$68,125
40)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total transportation costs are ______.

A)$57,500
B)$35,000
C)$48,900
D)$68,125
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
23
21)To overcome the problem of degeneracy,it is required to create a(n)______.

A)artificially occupied cell
B)occupied cell
C)unoccupied cell
D)empty cell
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
24
<strong>  39)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the highest transportation costs are from ______.</strong> A)Riverside to Visalia B)Bryan to Dayton C)Montgomery to Visalia D)Riverside to Huntsville
39)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the highest transportation costs are from ______.

A)Riverside to Visalia
B)Bryan to Dayton
C)Montgomery to Visalia
D)Riverside to Huntsville
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
25
<strong>  37)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total production at Montgomery is ______.</strong> A)2,500 B)3,500 C)4,500 D)5,500
37)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total production at Montgomery is ______.

A)2,500
B)3,500
C)4,500
D)5,500
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
26
25)While using the stepping stone method,if the improvement indices for all unoccupied cells are positive,then the improved solution is ______.

A)optimal
B)feasible
C)erroneous
D)nondegenerate
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
27
29)______ refers to a fictitious demand destination created to arrive at a balanced transportation problem (i.e.,total demand = total supply).

A)Balanced transportation problem
B)Degeneracy
C)Dummy demand destinations
D)Dummy supply sources
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
28
24)XYZ has three supply chain locations with respective production capacities of an electronic component (Denver,Milwaukee,and Columbia)and three demand locations with their respective demand requirements for that electronic component.The demand requirements,production capacities,and the per-unit transportation costs are tabled in the transportation matrix shown here.Determine the initial shipping cost using the matrix least cost method. <strong>24)XYZ has three supply chain locations with respective production capacities of an electronic component (Denver,Milwaukee,and Columbia)and three demand locations with their respective demand requirements for that electronic component.The demand requirements,production capacities,and the per-unit transportation costs are tabled in the transportation matrix shown here.Determine the initial shipping cost using the matrix least cost method.  </strong> A)$30,000 B)$40,000 C)$24,000 D)$31,000

A)$30,000
B)$40,000
C)$24,000
D)$31,000
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
29
31)The ______ is a special case of linear programming problems in which the objective is to minimize the total cost of transporting goods from the various supply origins to the different demand destinations.

A)transportation model
B)integer programming
C)warehousing problem
D)workforce scheduling model
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
30
23)XYZ has three supply chain locations with respective production capacities of an electronic component (Denver,Milwaukee,and Columbia)and three demand locations with their respective demand requirements for that electronic component.The demand requirements,production capacities,and the per-unit transportation costs are tabled in the transportation matrix shown here.Determine the initial shipping cost using the northwest corner rule. <strong>23)XYZ has three supply chain locations with respective production capacities of an electronic component (Denver,Milwaukee,and Columbia)and three demand locations with their respective demand requirements for that electronic component.The demand requirements,production capacities,and the per-unit transportation costs are tabled in the transportation matrix shown here.Determine the initial shipping cost using the northwest corner rule.  </strong> A)$30,000 B)$40,000 C)$24,000 D)$34,000

A)$30,000
B)$40,000
C)$24,000
D)$34,000
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
31
<strong>  36)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the shipment of widgets from Riverside to Huntsville is ______.</strong> A)2,500 B)4,200 C)4,500 D)5,000
36)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the shipment of widgets from Riverside to Huntsville is ______.

A)2,500
B)4,200
C)4,500
D)5,000
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
32
32)______ refers to a problem in which the total number of supply units available is greater than the demand requirements,or vice versa.

A)An unbalanced transportation problem
B)An integer programming problem
C)A warehousing problem
D)A network problem
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
33
<strong>  38)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the shipment from Montgomery to Huntsville is ______.</strong> A)0 B)3,500 C)4,500 D)5,500
38)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the shipment from Montgomery to Huntsville is ______.

A)0
B)3,500
C)4,500
D)5,500
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
34
33)We can use the matrix least cost method to solve transportation problems.In this method,an initial feasible solution to the transportation problem is obtained by ______.

A)allocating shipments ending with the route that has the lowest unit cost of transportation
B)allocating shipments beginning with the route that has the lowest unit cost of transportation
C)allocating shipments beginning with the route that has the highest unit cost of transportation
D)allocating shipments ending with the route that has the highest unit cost of transportation
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
35
26)Which of the following is true about the northwest corner rule?

A)It generates neither feasible solutions nor optimum least-cost solutions.
B)It generates both feasible solutions and optimum least-cost solutions.
C)It generates feasible solutions but not necessarily optimum least-cost solutions.
D)It generates optimum least-cost solutions but not necessarily feasible solutions.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
36
22)Consider the transportation matrix that follows.The transportation problem can be labeled as a(n)______ transportation problem. <strong>22)Consider the transportation matrix that follows.The transportation problem can be labeled as a(n)______ transportation problem.  </strong> A)balanced B)unbalanced C)partly occupied D)artificially occupied

A)balanced
B)unbalanced
C)partly occupied
D)artificially occupied
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
37
34)The matrix least cost method to solve transportation problems has several advantages.Which of the following is NOT one of them?

A)The matrix least cost method has better rationale than the northwest corner rule.
B)The matrix least cost method is less appealing than the northwest corner method.
C)The matrix least cost method reduces the number of computations required to determine the optimal solution.
D)The matrix least cost method reduces the time required to determine the optimal solution.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
38
28)______ refers to a condition that occurs when the solution to a transportation problem has occupied routes (cells)that are less than the (number of origins + the number of destinations - 1).

A)Balanced transportation problem
B)Degeneracy
C)Dummy demand destinations
D)Dummy supply sources
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
39
<strong>  35)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total shipment of widgets from Bryan to Dayton is ______.</strong> A)2,000 B)3,500 C)4,500 D)3,000
35)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total shipment of widgets from Bryan to Dayton is ______.

A)2,000
B)3,500
C)4,500
D)3,000
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
40
27)If,in a transportation problem,the total number of units demanded is equal to the total number of supply units available,the transportation problem is then described as ______.

A)balanced
B)degenerate
C)unbalanced
D)feasible
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
41
<strong>  57)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Aberdeen to Kalamazoo are $5,920. B)The shipping costs from Cairo to Kalamazoo are $5,920. C)The shipping costs from Aberdeen to Navarre are $1,560. D)The shipping costs from Danbury to Navarre are $1,560.
57)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Aberdeen to Kalamazoo are $5,920.
B)The shipping costs from Cairo to Kalamazoo are $5,920.
C)The shipping costs from Aberdeen to Navarre are $1,560.
D)The shipping costs from Danbury to Navarre are $1,560.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
42
<strong>  53)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The number of units shipped from Kolkata to Naples is one fourth of the total quantity produced by Tokyo. B)The Naples market requires more than can be produced by Tokyo alone. C)The quantity shipped from Tokyo to Naples is equal to the quantity shipped from Bangkok to Naples. D)The cost of producing/shipping from Tokyo to Naples is more than the cost of producing/shipping from Kolkata to Naples.
53)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The number of units shipped from Kolkata to Naples is one fourth of the total quantity produced by Tokyo.
B)The Naples market requires more than can be produced by Tokyo alone.
C)The quantity shipped from Tokyo to Naples is equal to the quantity shipped from Bangkok to Naples.
D)The cost of producing/shipping from Tokyo to Naples is more than the cost of producing/shipping from Kolkata to Naples.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
43
<strong>  55)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Aberdeen to Kalamazoo are $10,920. B)The shipping costs from Aberdeen to Kalamazoo are $1,695. C)The shipping costs from Escondido to Winston are $10,506. D)The shipping costs from Danbury to Navarre are $10,908.
55)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Aberdeen to Kalamazoo are $10,920.
B)The shipping costs from Aberdeen to Kalamazoo are $1,695.
C)The shipping costs from Escondido to Winston are $10,506.
D)The shipping costs from Danbury to Navarre are $10,908.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
44
<strong>  59)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Escondido to Kalamazoo are $10,908. B)The shipping costs from Aberdeen to Lakeland are $1,685. C)The shipping costs from Aberdeen to Madison are $18,414. D)The shipping costs from Fairview to Madison are $18,414.
59)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Escondido to Kalamazoo are $10,908.
B)The shipping costs from Aberdeen to Lakeland are $1,685.
C)The shipping costs from Aberdeen to Madison are $18,414.
D)The shipping costs from Fairview to Madison are $18,414.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
45
<strong>  56)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Aberdeen to Kalamazoo are $10,920. B)The shipping costs from Cairo to Kalamazoo are $6,946. C)The shipping costs from Escondido to Winston are $10,606. D)The shipping costs from Danbury to Navarre are $10,908.
56)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Aberdeen to Kalamazoo are $10,920.
B)The shipping costs from Cairo to Kalamazoo are $6,946.
C)The shipping costs from Escondido to Winston are $10,606.
D)The shipping costs from Danbury to Navarre are $10,908.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
46
<strong>  60)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Danbury to Lakeland are $23,280. B)The shipping costs from Aberdeen to Lakeland are $1,795. C)The shipping costs from Aberdeen to Madison are $18,414. D)The shipping costs from Fairview to Madison are $18,414.
60)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Danbury to Lakeland are $23,280.
B)The shipping costs from Aberdeen to Lakeland are $1,795.
C)The shipping costs from Aberdeen to Madison are $18,414.
D)The shipping costs from Fairview to Madison are $18,414.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
47
<strong>  43)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero costs are from ______.</strong> A)Tokyo to Naples B)Tokyo to Paris C)Kolkata to Naples D)Bangkok to Naples
43)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero costs are from ______.

A)Tokyo to Naples
B)Tokyo to Paris
C)Kolkata to Naples
D)Bangkok to Naples
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
48
<strong>  41)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero quantity shipped is from ______.</strong> A)Montgomery to Visalia B)Riverside to Visalia C)Montgomery to Dayton D)Bryan to Huntsville
41)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero quantity shipped is from ______.

A)Montgomery to Visalia
B)Riverside to Visalia
C)Montgomery to Dayton
D)Bryan to Huntsville
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
49
<strong>  46)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Tokyo to Naples is ______.</strong> A)$42,120 B)$26,080 C)$123,743 D)$160,132
46)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Tokyo to Naples is ______.

A)$42,120
B)$26,080
C)$123,743
D)$160,132
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
50
<strong>  58)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Danbury to Lakeland are $10,908. B)The shipping costs from Aberdeen to Lakeland are $1,695. C)The shipping costs from Aberdeen to Madison are $18,414. D)The shipping costs from Fairview to Madison are $18,414.
58)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Danbury to Lakeland are $10,908.
B)The shipping costs from Aberdeen to Lakeland are $1,695.
C)The shipping costs from Aberdeen to Madison are $18,414.
D)The shipping costs from Fairview to Madison are $18,414.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
51
<strong>  42)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero transportation costs are from ______.</strong> A)Montgomery to Visalia B)Riverside to Visalia C)Montgomery to Dayton D)Bryan to Huntsville
42)Refer to the data given in the table for Acme Widgets,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero transportation costs are from ______.

A)Montgomery to Visalia
B)Riverside to Visalia
C)Montgomery to Dayton
D)Bryan to Huntsville
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
52
<strong>  48)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Bangkok to Naples are ______.</strong> A)$42,120 B)$86,100 C)$123,743 D)$160,132
48)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Bangkok to Naples are ______.

A)$42,120
B)$86,100
C)$123,743
D)$160,132
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
53
<strong>  49)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,demand in which market can be met only by producing in all three production areas?</strong> A)Naples B)Paris C)Amsterdam D)both Naples and Paris
49)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,demand in which market can be met only by producing in all three production areas?

A)Naples
B)Paris
C)Amsterdam
D)both Naples and Paris
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
54
<strong>  52)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Tokyo to all three markets is ______.</strong> A)7,200 B)4,850 C)3,500 D)2,475
52)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Tokyo to all three markets is ______.

A)7,200
B)4,850
C)3,500
D)2,475
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
55
<strong>  47)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Tokyo to Amsterdam is ______.</strong> A)$42,120 B)$26,080 C)$123,743 D)$160,132
47)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Tokyo to Amsterdam is ______.

A)$42,120
B)$26,080
C)$123,743
D)$160,132
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
56
<strong>  45)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Kolkata to Naples is ______.</strong> A)$42,120 B)$26,080 C)$123,743 D)$160,132
45)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the costs for production and shipping from Kolkata to Naples is ______.

A)$42,120
B)$26,080
C)$123,743
D)$160,132
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
57
<strong>  50)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the production area is shipping to all three markets?</strong> A)Bangkok B)Kolkata C)Tokyo D)none of these
50)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the production area is shipping to all three markets?

A)Bangkok
B)Kolkata
C)Tokyo
D)none of these
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
58
<strong>  51)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Tokyo to Naples is ______.</strong> A)500 B)1,200 C)3,500 D)4,850
51)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Tokyo to Naples is ______.

A)500
B)1,200
C)3,500
D)4,850
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
59
<strong>  44)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total costs are ______.</strong> A)$283,475 B)$438,175 C)$356,787 D)$523,412
44)Refer to the data given for production and shipping costs for Auto Parts,Inc.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total costs are ______.

A)$283,475
B)$438,175
C)$356,787
D)$523,412
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
60
<strong>  54)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Aberdeen to Kalamazoo are $8,112. B)The shipping costs from Aberdeen to Kalamazoo are $1,695. C)The shipping costs from Danbury to Navarre are $6,946. D)The shipping costs from Danbury to Navarre are $10,908.
54)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Aberdeen to Kalamazoo are $8,112.
B)The shipping costs from Aberdeen to Kalamazoo are $1,695.
C)The shipping costs from Danbury to Navarre are $6,946.
D)The shipping costs from Danbury to Navarre are $10,908.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
61
<strong>  63)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Brighton to Navarre are $21,672. B)The shipping costs from Cairo to Navarre are $5,580. C)The shipping costs from Cairo to Sacramento are $9,570. D)The shipping costs from Fairview to Madison are $18,414.
63)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Brighton to Navarre are $21,672.
B)The shipping costs from Cairo to Navarre are $5,580.
C)The shipping costs from Cairo to Sacramento are $9,570.
D)The shipping costs from Fairview to Madison are $18,414.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
62
<strong>  72)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The quantity shipped from Birmingham to Madison is more than double the quantity shipped from Brighton to Madison. B)The quantity shipped from Danbury to Navarre is more than the quantity shipped from Cairo to Kalamazoo. C)The quantity shipped from Birmingham to Madison is less than the quantity shipped from Brighton to Madison. D)The quantity shipped from Escondido to Winston is less than the quantity shipped from Danbury to Sacramento.
72)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The quantity shipped from Birmingham to Madison is more than double the quantity shipped from Brighton to Madison.
B)The quantity shipped from Danbury to Navarre is more than the quantity shipped from Cairo to Kalamazoo.
C)The quantity shipped from Birmingham to Madison is less than the quantity shipped from Brighton to Madison.
D)The quantity shipped from Escondido to Winston is less than the quantity shipped from Danbury to Sacramento.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
63
<strong>  78)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Downey to Norfolk is ______.</strong> A)69 B)617 C)243 D)433
78)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Downey to Norfolk is ______.

A)69
B)617
C)243
D)433
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
64
<strong>  70)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The lowest non-zero shipment is from Aberdeen to Lakeland. B)The lowest non-zero shipment is from Birmingham to Kalamazoo. C)The lowest non-zero shipment is from Cairo to Winston. D)The lowest non-zero shipment is from Fairview to Navarre.
70)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The lowest non-zero shipment is from Aberdeen to Lakeland.
B)The lowest non-zero shipment is from Birmingham to Kalamazoo.
C)The lowest non-zero shipment is from Cairo to Winston.
D)The lowest non-zero shipment is from Fairview to Navarre.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
65
<strong>  61)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Danbury to Lakeland are $2,418. B)The shipping costs from Aberdeen to Lakeland are $1,795. C)The shipping costs from Birmingham to Madison are $18,910. D)The shipping costs from Fairview to Madison are $18,414.
61)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Danbury to Lakeland are $2,418.
B)The shipping costs from Aberdeen to Lakeland are $1,795.
C)The shipping costs from Birmingham to Madison are $18,910.
D)The shipping costs from Fairview to Madison are $18,414.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
66
<strong>  80)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Downey to Shreveport is ______.</strong> A)527 B)617 C)243 D)433
80)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Downey to Shreveport is ______.

A)527
B)617
C)243
D)433
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
67
<strong>  62)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Danbury to Lakeland are $2,418. B)The shipping costs from Aberdeen to Lakeland are $1,795. C)The shipping costs from Brighton to Madison are $0. D)The shipping costs from Fairview to Madison are $18,414.
62)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Danbury to Lakeland are $2,418.
B)The shipping costs from Aberdeen to Lakeland are $1,795.
C)The shipping costs from Brighton to Madison are $0.
D)The shipping costs from Fairview to Madison are $18,414.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
68
<strong>  73)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total shipping costs are approximately ______.</strong> A)$150,000 B)$950,000 C)$215,000 D)$425,000
73)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total shipping costs are approximately ______.

A)$150,000
B)$950,000
C)$215,000
D)$425,000
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
69
<strong>  64)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Brighton to Navarre are $12,462. B)The shipping costs from Cairo to Navarre are $5,580. C)The shipping costs from Cairo to Sacramento are $18,414. D)The shipping costs from Fairview to Madison are $18,414.
64)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Brighton to Navarre are $12,462.
B)The shipping costs from Cairo to Navarre are $5,580.
C)The shipping costs from Cairo to Sacramento are $18,414.
D)The shipping costs from Fairview to Madison are $18,414.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
70
<strong>  65)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping costs from Brighton to Navarre are $12,462. B)The shipping costs from Fairview to Winston are $18,368. C)The shipping costs from Cairo to Sacramento are $2,244. D)The shipping costs from Fairview to Madison are $18,414.
65)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping costs from Brighton to Navarre are $12,462.
B)The shipping costs from Fairview to Winston are $18,368.
C)The shipping costs from Cairo to Sacramento are $2,244.
D)The shipping costs from Fairview to Madison are $18,414.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
71
<strong>  77)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Knoxville to Mobile is ______.</strong> A)592 B)617 C)243 D)433
77)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Knoxville to Mobile is ______.

A)592
B)617
C)243
D)433
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
72
<strong>  67)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping cost from all plants to Kalamazoo is $15,656. B)The shipping cost from all plants to Lakeland is $24,975. C)The shipping cost from all plants to Madison is $23,225. D)The shipping cost from all plants to Winston is $21,123.
67)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping cost from all plants to Kalamazoo is $15,656.
B)The shipping cost from all plants to Lakeland is $24,975.
C)The shipping cost from all plants to Madison is $23,225.
D)The shipping cost from all plants to Winston is $21,123.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
73
<strong>  74)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total shipping costs are approximately:</strong> A)$2,321 B)$4,384 C)$3,310 D)$5,921
74)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the total shipping costs are approximately:

A)$2,321
B)$4,384
C)$3,310
D)$5,921
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
74
<strong>  75)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the highest shipping costs are from ______.</strong> A)Lowell to Shreveport B)Lowell to Norfolk C)Lowell to Mobile D)Lowell to Richmond
75)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the highest shipping costs are from ______.

A)Lowell to Shreveport
B)Lowell to Norfolk
C)Lowell to Mobile
D)Lowell to Richmond
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
75
<strong>  71)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The quantity shipped from Danbury to Navarre is more than the quantity shipped from Cairo to Kalamazoo. B)The quantity shipped from Escondido to Kalamazoo is more than the quantity shipped from Cairo to Kalamazoo. C)The quantity shipped from Birmingham to Madison is less than the quantity shipped from Brighton to Madison. D)The quantity shipped from Escondido to Winston is less than the quantity shipped from Danbury to Sacramento.
71)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The quantity shipped from Danbury to Navarre is more than the quantity shipped from Cairo to Kalamazoo.
B)The quantity shipped from Escondido to Kalamazoo is more than the quantity shipped from Cairo to Kalamazoo.
C)The quantity shipped from Birmingham to Madison is less than the quantity shipped from Brighton to Madison.
D)The quantity shipped from Escondido to Winston is less than the quantity shipped from Danbury to Sacramento.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
76
<strong>  66)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping cost from all plants to Kalamazoo is $25,966. B)The shipping cost from all plants to Lakeland is $17,000. C)The shipping cost from all plants to Madison is $23,225. D)The shipping cost from all plants to Winston is $21,123.
66)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping cost from all plants to Kalamazoo is $25,966.
B)The shipping cost from all plants to Lakeland is $17,000.
C)The shipping cost from all plants to Madison is $23,225.
D)The shipping cost from all plants to Winston is $21,123.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
77
<strong>  68)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping cost from all plants to Kalamazoo is $15,656. B)The shipping cost from all plants to Lakeland is $14,280. C)The shipping cost from all plants to Madison is $28,810. D)The shipping cost from all plants to Winston is $21,123.
68)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping cost from all plants to Kalamazoo is $15,656.
B)The shipping cost from all plants to Lakeland is $14,280.
C)The shipping cost from all plants to Madison is $28,810.
D)The shipping cost from all plants to Winston is $21,123.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
78
<strong>  76)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero shipping costs are from ______.</strong> A)Downey to Norfolk B)Knoxville to Mobile C)Bloomington to Norfolk D)Chattanooga to Saginaw
76)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the lowest non-zero shipping costs are from ______.

A)Downey to Norfolk
B)Knoxville to Mobile
C)Bloomington to Norfolk
D)Chattanooga to Saginaw
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
79
<strong>  69)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?</strong> A)The shipping cost from all plants to Kalamazoo is $15,656. B)The shipping cost from all plants to Lakeland is $14,280. C)The shipping cost from all plants to Madison is $18,345. D)The shipping cost from all plants to Winston is $28,874.
69)Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?

A)The shipping cost from all plants to Kalamazoo is $15,656.
B)The shipping cost from all plants to Lakeland is $14,280.
C)The shipping cost from all plants to Madison is $18,345.
D)The shipping cost from all plants to Winston is $28,874.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
80
<strong>  79)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Downey to Saginaw is ______.</strong> A)191 B)617 C)243 D)433
79)Refer to the Shipping Costs for The Allied Motors Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,the number of units shipped from Downey to Saginaw is ______.

A)191
B)617
C)243
D)433
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
locked card icon
Unlock Deck
Unlock for access to all 100 flashcards in this deck.