1. CASE 8A: Solve the following LPP by graphical method

Maximize Z = 400X1 + 200X2

Subject to constraints

18X1 + 3X2 800

9X1 + 4X2 600

X2 150

X1, X2 0

CASE 8B: Use Excel Solver to solve the following Sample Model

Imagine that you are managing a factory that is building three products: TV sets, stereos and speakers. Each product is assembled from parts in inventory, and there are five types of parts: Chassis, picture tubes, speaker cones, power supplies and electronics units. Your goal is to produce the mix of products which will maximize profits, given the inventory of products on hand.

From this description, we can see that the decision variables are the number of products to build, and the objective function will be (gross) profit. Assume that you can sell TV sets for a gross profit of $75 each, stereos for a profit of $50 each, and speaker cones for $35 each.

To assemble a TV set, you need 1 chassis, 1 picture tube, 2 speaker cones, 1 power supply and 2 sets of electronics. To make a stereo, you need 1 chassis, 2 speaker cones, 1 power supply and 1 set of electronics. And to build a speaker, all you need is 1 speaker cone and 1 set of electronics. The parts you have on hand are 450 chassis, 250 picture tubes, 800 speaker cones, 450 power supplies and 600 sets of electronics. This defines the constraints in this problem: You can build only a limited number of products from the parts on hand.