Variable Cost ($) Fixed Cost Facility Product Product Product ($) Y Facility 1 Facility 2 8,000,000 1200 1600 900 6,000,000 1500 1800 1100 4,000,000 Facility 3 Facility 4 1700 1900 1900 1200 3,000,000 2200 1400 A company has 4 production facilities. Each facility is eligible to produce Product X, Product Y or Product Z, but it can only produce one of these products. The annual fixed cost of operating each facility and the variable cost of producing a product of each type at each facility are given in the table. The company must produce 5000 units of each type of product in a year. Formulate an IP to minimize the total annual production cost satisfying the following constraints; Each facility can produce only one type of product. 1) The total production of each type of product must be at a single facility. For instance, if any Products X are produced at facility 1, then all Products X must be produced there. 2) If facilities 3 and 4 are used, then facility 1 must also be used.

Variable Cost ($) Fixed Cost Facility Product Product Product ($) Y Facility 1 Facility 2 8,000,000 1200 1600 900 6,000,000 1500 1800 1100 4,000,000 Facility 3 Facility 4 1700 1900 1900 1200 3,000,000 2200 1400 A company has 4 production facilities. Each facility is eligible to produce Product X, Product Y or Product Z, but it can only produce one of these products. The annual fixed cost of operating each facility and the variable cost of producing a product of each type at each facility are given in the table. The company must produce 5000 units of each type of product in a year. Formulate an IP to minimize the total annual production cost satisfying the following constraints; Each facility can produce only one type of product. 1) The total production of each type of product must be at a single facility. For instance, if any Products X are produced at facility 1, then all Products X must be produced there. 2) If facilities 3 and 4 are used, then facility 1 must also be used.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Some professions are too risky, insulting, or mundane for humans, therefore robots may be programmed to undertake them instead. If you believe a robot may be more efficient than a person in doing a certain work, please provide an example. Is there any particular reason why you think people would rather trust a machine with this responsibility rather than another human being?
select the correct type of the 1. All of us (must) solve the equations easy , (what is the answer Linking or Action or Auxiliary) 2.He was (wearing) a rain coat what is the answer (Linking or Action or Auxiliary) 3. The man (is) not a friend of nine what is the answer (Linking or Action or Auxiliary)
This is because computers these days are so powerful. Since when has the educational system become so reliant on computers, and how can this be demonstrated?
How might computers aid in solving scientific mysteries? Put forward your case and back it up with concrete details.
In the context of computer science, please explain why it is possible for an individual's constitutionally protected right to free speech to come into conflict with the ownership of a trademark. How can these seemingly opposing points of view be reconciled so that they may be in peace with one another?
Can computers help decide sentences for criminals? If so, who should program the computer? What would Nils Christie say about using computers in this way? Note: I encourage you to interpret "computer" to mean all forms of artificial intelligence, including machine-learning. Do not limit yourself to current technology. I am asking whether we should do it, not whether computers are capable of it.
Do many ways of thinking about things exist? Which ones are in a straight line, and which ones aren't?
Can a Mechanical Turk be used to successfully deceive modern humans? If you were to compare a modern Turk to a Turk from the 18th century, what would you notice?
What am I supposed to do? Do I not provide any examples in this chapter?
Walk me through the inner workings of a neural network in a computer. Could you explain it a bit more?
Computer science has nothing to do with computers, just as medicine has nothing to do with stethoscopes. Do you agree or disagree with this statement? Explain your position with specific examples.
This is an issue since today's computers are so powerful. Is there any way to verify that computers have had such an impact on schooling during the previous several decades?