A company makes 2 products, A and B, from 2 resources. The products have the following resource requirements and…

A company makes 2 products, A and B, from 2 resources. The products have the following resource requirements and…

Question:

Transcribed Image Text:

A company makes 2 products, A and B, from 2 resources. The products have the following resource requirements and
produce the accompanying profits. The available quantity of resources is also shown in the table.
Product
Labor (hr/unit)
Material (ounces/unit)
Profit (S/unit)
Let X1 Number of product A
X2 = Number of product B
Management has developed the following set of goals:
Goal 1: Produce approximately 40 units of product A.
Produce approximately 70 units of product B.
Goal 2:
Goal 3:
Achieve a profit over $400.
Goal 4:
Consume less than 150 hours of labor.
Goal 5: Consume less than 200 ounces of material.
The GP (Goal Programming) formulation of the problem and the associated spreadsheet are given as follows:
MIN:
Subject to:
11
2
3
4
S
6
7
8
9
10
11
12
13
14
X1+d1-d1=40
X2+d2-d2=70
di+d1 +d2+d2 +d3¯ +d4+ +d5t
B
A
3 2
1
2
7
6
7X1+6X2+d3″-d3=400
3 X1 +2X2 +d4-d4-150
1X1+2 X2+d5-d5=200
X₁, d₁, di 20 for all i
A
Problem data
Labor
Material
Profit
Goal constraints
Actual amount
+ Under
-Over
-Goal
Target value
Weights
Under
Over
B
A
3
1
7
A
a
a
0
d
40
B
2
d
B
d
d
d
Available Resources
150
200
d
70
Labor
a
O
0
150
product A
product B
profit
labor
material
Material
a
0
0
200
Profit
d
of
400 What formula goes in cell C9 of the above spreadsheet?
О А.
=C6+C7+C8
O B.
-C6-C7+C8
OC.
=C6+C7-C8
O D.
= C10-C8
Question 15
What formula goes in cell F6 of the above spreadsheet?
О А.
=B4°C4+B6 C6
O B.
= SUMPRODUCT(B4:C4,B6:C6)
OC
= SUMPRODUCT(B2:B4,B6:B8)
O D.
= SUMPRODUCT(B4:C4,B10:C10) Which cells in the above spreadsheet are the variable cells in this model?
OA
$B$9:$E$9
OB.
$B$9:$F$9
OC
$B$6:$E$8
D.
$B$6:$C$6, $B$7:$E$8
OE
$B$6:$C$6, $B$7:$F$8
Question 17
If the company is less concerned about not reaching the profit target, which cell value in the above spreadsheet should
change and how should it change?
OA
F13, increase
O B.
F13, decrease
OC
F14, increase
5 pts
D A company makes 2 products, A and B, from 2 resources. The products have the following resource requirements and
produce the accompanying profits. The available quantity of resources is also shown in the table.
Product
Labor (hr/unit)
Material (ounces/unit)
Profit (S/unit)
Let X1 Number of product A
X2 = Number of product B
Management has developed the following set of goals:
Goal 1: Produce approximately 40 units of product A.
Produce approximately 70 units of product B.
Goal 2:
Goal 3:
Achieve a profit over $400.
Goal 4:
Consume less than 150 hours of labor.
Goal 5: Consume less than 200 ounces of material.
The GP (Goal Programming) formulation of the problem and the associated spreadsheet are given as follows:
MIN:
Subject to:
11
2
3
4
S
6
7
8
9
10
11
12
13
14
X1+d1-d1=40
X2+d2-d2=70
di+d1 +d2+d2+d3 +d4*+d5t
B
A
3 2
1
2
7
6
7X1+6X2+d3″-d3=400
3 X1 +2X2 +d4-d4-150
1X1+2 X2+d5-d5=200
X₁, di, dit 20 for all i
A
Problem data
Labor
Material
Profit
Goal constraints
Actual amount
+ Under
-Over
-Goal
Target value
Weights
Under
Over
B
A
3
1
7
A
a
a
0
d
40
B
2
d
B
d
d
d
Available Resources
150
200
d
70
Labor
a
O
0
150
product A
product B
profit
labor
material
Material
a
0
0
200
Profit
d
of
400 What formula goes in cell C9 of the above spreadsheet?
О А.
=C6+C7+C8
O B.
-C6-C7+C8
OC.
=C6+C7-C8
O D.
= C10-C8
Question 15
What formula goes in cell F6 of the above spreadsheet?
О А.
=B4 C4+B6 C6
O B.
= SUMPRODUCT(B4:C4,B6:C6)
OC
= SUMPRODUCT(B2:B4,B6:B8)
O D.
= SUMPRODUCT(B4:C4,B10:C10) Which cells in the above spreadsheet are the variable cells in this model?
OA
$B$9:$E$9
OB.
$B$9:$F$9
OC
$B$6:$E$8
D.
$B$6:$C$6, $B$7:$E$8
OE
$B$6:$C$6, $B$7:$F$8
Question 17
If the company is less concerned about not reaching the profit target, which cell value in the above spreadsheet should
change and how should it change?
OA
F13, increase
O B.
F13, decrease
OC
F14, increase
5 pts
D A company makes 2 products, A and B, from 2 resources. The products have the following resource requirements and
produce the accompanying profits. The available quantity of resources is also shown in the table.
Product
Labor (hr./unit)
Material (ounces/unit)
Profit (S/unit)
Let X1 Number of product A
X2= Number of product B
Management has developed the following set of goals:
Goal 1: Produce approximately 40 units of product A.
Produce approximately 70 units of product B.
Goal 2:
Goal 3:
Achieve a profit over $400.
Goal 4:
Consume less than 150 hours of labor.
Goal 5: Consume less than 200 ounces of material.
The GP (Goal Programming) formulation of the problem and the associated spreadsheet are given as follows:
MIN:
Subject to:
11
2
3
4
S
6
7
8
9
10
11
12
13
14
X1+d1-d1=40
X2+d2-d2=70
di+d1 +d2+d2+d3 +d4*+d5t
B
A
3 2
1
2
7
6
7 X1 +6X2+d3″-d3=400
3 X1 +2X2 +d4-d4-150
1X1+2 X2+d5-d5=200
X₁, di, di* 20 for all i
A
Problem data
Labor
Material
Profit
Goal constraints
Actual amount
+ Under
-Over
-Goal
Target value
Weights
Under
Over
B
A
3
1
7
A
a
a
0
d
40
B
2
d
B
d
d
d
Available Resources
150
200
d
70
Labor
a
O
0
150
product A
product B
profit
labor
material
Material
a
0
0
200
Profit
d
of
400 What formula goes in cell C9 of the above spreadsheet?
О А.
=C6+C7+C8
O B.
-C6-C7+C8
OC.
=C6+C7-C8
O D.
= C10-C8
Question 15
What formula goes in cell F6 of the above spreadsheet?
О А.
=B4°C4+B6 C6
O B.
= SUMPRODUCT(B4:C4,B6:C6)
OC
= SUMPRODUCT(B2:B4,B6:B8)
O D.
= SUMPRODUCT(B4:C4,B10:C10) Which cells in the above spreadsheet are the variable cells in this model?
OA
$B$9:$E$9
OB.
$B$9:$F$9
OC
$B$6:$E$8
D.
$B$6:$C$6, $B$7:$E$8
OE
$B$6:$C$6, $B$7:$F$8
Question 17
If the company is less concerned about not reaching the profit target, which cell value in the above spreadsheet should
change and how should it change?
OA
F13, increase
O B.
F13, decrease
OC
F14, increase
5 pts
D

Expert Answer:

Answer rating: 100% (QA)

The detailed answer for the above question is provided below Answer Goal Programming F
View the full answer