Question

A company produces products at 2 plants each of which have a capacity of producing 75 units. 50 units of each product must be shipped to each of three customers. We know the cost of shipping a unit of the product from each plant to each customer. Our goal is to minimize the total cost of shipping the needed units to the customers. If we use the Excel Solver to try and minimize the total cost of meeting customer demand we will need how many variable cells?

Answer 1

Answer:

the answer is 6

Explanation:

In this case we would need to have a combination of each plant with each customer. So the variable would be in this way (3C X 2P)

              Customer1            Customer2           Customer3

Plant1      P1C1                      P1C2                     P1C3

Plant2     P2C1                     P2C2                    P2C3

Once you have this you can calculate the best combination to minimize the cost of shipping