Exercise 2-13: Solve the following LP problem by using the graphical procedure and by using excel: For all problems use Excel Solver
Maximize Profit = 2X+Y
Subject to the constraints
3X+6Y=32
7X+Y=20
3X-Y=3
X,Y =0 Exercise 2-16: Solve the following LP problem using the corner point graphical method. At the
optimal solution calculate the slack for each constraint:
maximize profit 4x +7y
subject to the constraints
2X + 3Y
4X + 2Y
X
X,Y ≥ 60
≥ 80
≤ 24
≥ 0 Exercise 2-18: Solve the following LP problem using graphical procedure and by using
Excel:
Maximize cost = 4X + 7Y
Subject to the constraints
3X + 6Y ≥ 100
10X + 2Y ≥ 160
2Y ≥ 40 2X ≤ 75 X,Y ≥0 Exercise 2-24: A small motor manufacturer makes two types of motors, model A and B. The
assembly process for each is similar in that both require a certain amount of wiring,
drilling, and assembly. Each model A takes 3 hours of wiring, 2 hours of drilling, and 1.5
hours of assembly. Each model B must go through 2 hours of wiring, 1 hour of drilling, and
0.5 hours of assembly. During the next production period, 240 hours of wiring time, 210 hours of drilling, and 120 hours of assembly time is available. Each model A sold yields a
profit of $22. Each model B can be sold for a $15 profit. If all motors that are assembled
can be sold, find the best combination of motors to yield the highest profit. Exercise 3-2: A contestant on the hit reality television show Top Bartender was asked to mix a
variety of drinks, each consisting of 4 fluid ounces. No other ingredients were permitted. She
was given the following quantities of liquor:
Liquor Qty. in (ounces)
Bourbon 128
Brandy 128
Vodka 128
Dry Vermouth 32
Sweet Vermouth 32
The contestant is considering making the following four drinks:
• The New Yorker: 25% each of bourbon, brandy, vodka, and sweet vermouth
• The Garaboldi: 25% each of brandy and dry vermouth; 50% sweet vermouth
• The Kentuckian: 100% bourbon
• The Russian: 75% vodka and 25% dry vermouth
The contestant's objective is to make the largest number of drinks with the available liquor. What
is the combination of drinks to meet her objective? How I do solve this problem using Excel?
solver function? Exercise 3-8: A gear manufacturer is planning next week’s production run for four types of
gears. If necessary, it is possible to outsource any type of gear from another gear company
located nearby. The following table and the table at the bottom of this page show next
week’s demand, revenue per unit, outsource cost per unit, time (in hours) required per unit
in each production process, and the availability and cost of these processes. The nearby
company can supply a maximum of 300 units of each type of gear next week. What should
be the production and/or outsource pan for the next week to maximize profit?
Gear Type Gear A Gear B Gear C Gear D Demand 400 500 450 600 Revenue $12.50 $15.60 $17.40 $19.30 Outsource $7.10 $8.10 $8.40 Exercise 3-12: A political candidate is planning his media budget for an upcoming election.
He has $90,500 to spend. His political consultants have provided him with the following
estimates of additional votes as a result of the advertising effort:
• For every small sign placed by the roadside, he will gamer 10 additional