11-14 Student Enterprises sells two sizes of wall posters, a large 3- by 4-foot poster and a smaller 2- by 3-foot poster. The profit earned from the sale of each large poster is $3; each smaller poster earns $2. The firm, although profitable, is not large; it consists of one art student, Jan Meising, at the University of Kentucky. Because of her classroom schedule, Jan has the following weekly constraints: (1) up to three large posters can be sold, (2) up to five smaller posters can be sold, (3) up to 10 hours can be spent on posters during the week, with each large poster requiring 2 hours of work and each small one taking 1 hour. With the semester almost over, Jan plans on taking a three- month summer vacation to England and doesn't want to leave any unfinished posters behind. Find the integer solution that will maximize her profit.

Solution Summary

This posting contains solution to following Integer programming problem using excel solver.

1. Integer Programming Problem Consider the following integer linear programming problem Max Z=3x1+2x2 Subject to: 3x1+5x2<=30 5X1+2x2<=28 x1<=8 x1,x2>=0 and ...

... Formulate this as an integer programming problem to maximize the number of pounds that may be carried. ... This is an integer programming model. ... x, y: integers. ...

... x ≥ (1/3)(x + y), that is (2/3)x - (1/3)y ≥ 0 0.8x + 0.5y ≤ 8 x, y integers and ≥ 0. ... This is a maximization integer linear programming problem. ...

Problem: List the advantages and disadvantages of solving integer programming problems by (a) rounding off, (b) enumeration, and (c) the branch and bound method ...

... a) 20 b) 22 c) 24 d) 26. 25. Integer Programming Problem 1 Consider the following integer linear programming problem. ... 27. Integer Programming Problem 2. ...

Integer Programming Model : Four Problems to Solve Using a Computer. ... Formulate an integer programming model foe this problem and solve it by using the computer. ...

... 3x1 + 5x2 <= 36 x1, x2 >= 0 and integer Find the optimal solution. This trashippment problem is formulates, set up and solved as a Linear programming problem: ...

... of Stereo Tuners) X3>=50,000/150 (Minimum Batches of Stereo Tuners) X1, X2, X3>=0 and Integer. b. Create a spreadsheet model for this problem and solve it. ...