Computer Solution to LP with Solver Quiz

OPRE 315 – Computer Solution to LP with Solver Quiz

1. Solve the following linear programming model:

a) graphically:

Maximize Z = 3x1 + 6x2

Subject to

b) Develop the Excel Solver model for the previous problem.

2. Develop the Excel Solver model for the following problems:

a) The diet model from the previous lecture

b) Jack is an aspiring freshman at University of Baltimore. He realizes that “all work and no play make Jack a dull young man.” Jack wants to apportion his available time of about 10 hours a day between work and play. He estimates that play is twice as much fun as work. He also wants to study at least as much as he plays. However, Jack realizes that if he is going to get all his homework assignments done, he cannot play more than 4 hours a day. How should Jack allocate his time to maximize his pleasure from both work and play.

18

2

3

2

1

£

+

x

x

5

2

1

³

+

x

x

4

1

£

x

0

,

2

1

³

x

x