For this section, no need to solve the questions and submit answers Your company is a major distributor of coffee in the UAE. You can buy coffee from 5 roasters and distribute the coffee to three UAE cities (Al-Ain, Abu Dhabi, and Dubai). The monthly demand in the three cities is as follows: City Monthly Demand (tons) 1- Al-Ain 50 2- Abu Dhabi 120 3- Dubai 280 In order to guarantee supplies from the five coffee roasters, you need to sign a monthly contract with fee. If you decide to sign a contract with a roaster, you need to pay the contract fee and then you need to pay for transportation cost of any coffee supplied from the roaster to the 3 cities. The production capacity of each roaster and their monthly fee are as follows: Roaster Monthly Supply (tons) Monthly Fee (contract) A 75 $800 B 150 $1200 C 175 $1350 D 200 $1500 E 125 $1000 The transportation cost per ton of coffee from roasters to the 3 UAE cities is as follows: Roaster Al-Ain Abu Dhabi Dubai A $5 $8 $6 B $3 $6 $7 C $4 $9 $6 D $8 $5 $9 E $7 $9 $2 Your company asked you to minimize the total monthly cost of coffee supply from the five roasters and distribution to the three UAE cities. 12. How many binary decision variables are needed for the formulation? (1 Point) 15 20 5 3 13. If Y is used to represent the binary decision variable, one of the following is the correct formulation for the constraint that represents the capacity of Roaster C: (1 Point) Xc1 + Xc2 +Xc3 - 175Yc <= 0 X1c + X2c +X3c <= 175 X1c + X2c +X3c-175Yc <= 0 Xc1 + Xc2 +Xc3 <= 175
For this section, no need to solve the questions and submit answers Your company is a major distributor of coffee in the UAE. You can buy coffee from 5 roasters and distribute the coffee to three UAE cities (Al-Ain, Abu Dhabi, and Dubai). The monthly demand in the three cities is as follows: City Monthly Demand (tons) 1- Al-Ain 50 2- Abu Dhabi 120 3- Dubai 280 In order to guarantee supplies from the five coffee roasters, you need to sign a monthly contract with fee. If you decide to sign a contract with a roaster, you need to pay the contract fee and then you need to pay for transportation cost of any coffee supplied from the roaster to the 3 cities. The production capacity of each roaster and their monthly fee are as follows: Roaster Monthly Supply (tons) Monthly Fee (contract) A 75 $800 B 150 $1200 C 175 $1350 D 200 $1500 E 125 $1000 The transportation cost per ton of coffee from roasters to the 3 UAE cities is as follows: Roaster Al-Ain Abu Dhabi Dubai A $5 $8 $6 B $3 $6 $7 C $4 $9 $6 D $8 $5 $9 E $7 $9 $2 Your company asked you to minimize the total monthly cost of coffee supply from the five roasters and distribution to the three UAE cities. 12. How many binary decision variables are needed for the formulation? (1 Point) 15 20 5 3 13. If Y is used to represent the binary decision variable, one of the following is the correct formulation for the constraint that represents the capacity of Roaster C: (1 Point) Xc1 + Xc2 +Xc3 - 175Yc <= 0 X1c + X2c +X3c <= 175 X1c + X2c +X3c-175Yc <= 0 Xc1 + Xc2 +Xc3 <= 175
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
Related questions
Question
100%
Please solve below questions.
Transcribed Image Text:For this section, no need to solve the questions and submit answers
Your company is a major distributor of coffee in the UAE. You can buy coffee from 5 roasters and distribute the coffee to
three UAE cities (Al-Ain, Abu Dhabi, and Dubai). The monthly demand in the three cities is as follows:
City
Monthly Demand (tons)
1- Al-Ain
50
2- Abu Dhabi
120
3- Dubai
280
In order to guarantee supplies from the five coffee roasters, you need to sign a monthly contract with fee. If you decide
to sign a contract with a roaster, you need to pay the contract fee and then you need to pay for transportation cost of
any coffee supplied from the roaster to the 3 cities. The production capacity of each roaster and their monthly fee are as
follows:
Roaster
Monthly Supply (tons)
Monthly Fee (contract)
A
75
$800
B
150
$1200
C
175
$1350
D
200
$1500
E
125
$1000
The transportation cost per ton of coffee from roasters to the 3 UAE cities is as follows:
Roaster
Al-Ain
Abu Dhabi
Dubai
A
$5
$8
$6
B
$3
$6
$7
C
$4
$9
$6
D
$8
$5
$9
E
$7
$9
$2
Your company asked you to minimize the total monthly cost of coffee supply from the five roasters and distribution to
the three UAE cities.
12. How many binary decision variables are needed for the formulation?
(1 Point)
15
20
5
3
13. If Y is used to represent the binary decision variable, one of the following is the correct
formulation for the constraint that represents the capacity of Roaster C:
(1 Point)
Xc1 + Xc2 +Xc3 - 175Yc <= 0
X1c + X2c +X3c <= 175
X1c + X2c +X3c - 175Yc <= 0
Xc1 + Xc2 +Xc3 <= 175
Transcribed Image Text:14. One of the following is the correct formulation of the constraint that represents the demand in
Al-Ain:
(1 Point)
Xa1 + Xb1 +Xc1 + Xd1 + Xe1 >= 50
Xa1 + Xb1 +Xc1 + Xd1 + Xe1 <= 50
X1a + X1b +X1c + X1d + X1e = 50
X1a + X1b +X1c + X1d + X1e >= 50
15. How many elements are needed in the Z-function to minimize both fixed costs of roasters and
variable transportation costs from roasters to the three cities?
(1 Point)
15
5
20
8
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education