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?

Question

Business

Maximo Collins

4 March, 23:32

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?

+2

Answers (1)

Know the Answer?

Dominique Dorsey · Answer 1

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