Question

2- This business is dedicated to produce different types of bookshelves. The following table describe the amount of resources to do so: Glass 4 Wood 4 Resources $$ $14 $18 S12 Paint Bookshelf 1 Bookshelf 2 Bookshelf 3 Available Resources 4 4 16 4 13 15 Determine the qty of each bookshelf this company should produce in order to maximize resources Using Simplex Method anL a -

Answer 1

Using the Simplex Method:

Solution Glass Wood Paint Resource $S 2 Bookshelf 1 3 Bookshelf 2 4 Bookshelf 3 5 Available 14 18 12 0 15 13 16 0 0 7 Result

The formulas are shown below:

The solver parameters are shown below. Remember to select the Simplex

A1 Glass Paint Resourc 2 Bookshelf 1 3 Bookshelf 2 4 Bookshelf 3 Available 14 18 12 15 13 16 SUMPRODUCT(B2:84,$G$2:$G$4) SUMPRODUCT C2:C4,$6$2:$6$4) SUMPRODUCT D2D4,$G$2:$6S4) SUMPRODUT(E2. 7 Result

LINEAR PROGRAMMING Method :

Glass Wood Pa nt Bookshelf2 5 Availeble 15 ↓3 15 952555 rt 7 Result Delet 10 1.2 13 1 15 10 ster slang e.od nullm«, .nd mi ,,tire troeth'에ne!.. 1.11

The result is shown below. Ideal solution is to create 2 units of Bookshelf 1 and 1 unit of Bookshelf 2. The maximum possible resource $$ is 46. :-

Resource $$ 14 18 12 Wood Paint Solution 3 3ookshelf 2 1 3ockshelf 3 5 Avallable 0 15 13 16 7 Result 8 13 13 16 46 Solver Reult 0