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