Questions from Spreadsheet Modeling


Q: Solve the following LP problem graphically by enumerating the corner points.

Solve the following LP problem graphically by enumerating the corner points. MAX: 3X1 + 4X2 Subject to: X1 ≤ 12 X2 ≤ 10 4X1 + 6X2 ≤ 72 X1, X2 ≥ 0

See Answer

Q: Solve the following LP problem graphically using level curves. MAX

Solve the following LP problem graphically using level curves. MAX: 2X1 + 5X2 Subject to: 6X1 + 5X2 ≤ 60 2X1 + 3X2 ≤ 24 3X1 + 6X2 ≤ 48 X1, X2 ≥ 0

See Answer

Q: Solve the following LP problem graphically by enumerating the corner points.

Solve the following LP problem graphically by enumerating the corner points. MIN: 5X1 + 20X2 Subject to: X1 + X2 ≥ 12 2X1 + 5X2 ≥ 40 X1 + X2 ≤ 15 X1, X2 ≥ 0

See Answer

Q: Are the following objective functions for an LP model equivalent? That

Are the following objective functions for an LP model equivalent? That is, if they are both used, one at a time, to solve a problem with exactly the same constraints, will the optimal values for X1 an...

See Answer

Q: Consider the following LP problem. MAX: 3X1 + 2X2

Consider the following LP problem. MAX: 3X1 + 2X2 Subject to: 3X1 + 3X2 ≤ 300 6X1 + 3X2 ≤ 480 3X1 + 3X2 ≤ 480 X1, X2 ≥ 0 a. Sketch the feasible region for this model. b. What is the optimal solution?...

See Answer

Q: Solve the following LP problem graphically using level curves. MIN

Solve the following LP problem graphically using level curves. MIN: 2X1 + 3X2 Subject to: 2X1 + 1X2 ≥ 3 4X1 + 5X2 ≥ 20 2X1 + 8X2 ≥ 16 5X1 + 6X2 ≤ 60 X1, X2 ≤ 0

See Answer

Q: Solve the following LP problem using level curves. MAX:

Solve the following LP problem using level curves. MAX: 4X1 + 5X2 Subject to: 2X1 + 3X2 ≤ 120 4X1 + 3X2 ≤ 140 X1 + X2 ≥ 80 X1, X2 ≥ 0

See Answer

Q: Solve the following LP problem graphically by enumerating the corner points.

Solve the following LP problem graphically by enumerating the corner points. MAX: 10X1 + 12X2 Subject to: 8X1 + 6X2 ≤ 98 6X1 + 8X2 ≤ 98 X1 + X2 ≥ 14 X1, X2 ≥ 0

See Answer

Q: Bibbins Manufacturing produces softball and baseballs for youth recreation leagues. Each

Bibbins Manufacturing produces softball and baseballs for youth recreation leagues. Each softball costs $11 to produce and sells for $17 while each baseball costs $10.50 and sells for $15. The materia...

See Answer

Q: Oakton Manufacturing makes two types of rocking chairs specifically designed for men

Oakton Manufacturing makes two types of rocking chairs specifically designed for men and women known as the His and Hers models. Each chair requires four legs and two rockers but differing numbers of...

See Answer