Ask Question
5 August, 09:29

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?

+4
Answers (1)
  1. 5 August, 12:30
    0
    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
Know the Answer?
Not Sure About the Answer?
Get an answer to your 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 ...” in 📙 Business if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers