Tutorial 1 - IELM202 Tutorial 1 1/8 User Guide of MS Solver...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
IELM202 Tutorial 1 1/8 User Guide of MS Solver Installation of Solver Installing the Solver is simple. The following steps guide you to the setup. 1. Insert the course book CD into the CD-Rom 2. Open the “X:\software\PermSolv” directory, where X is the disk index of the CD- Rom. 3. Run setup.exe 4. Follow the instruction of the setup package to install the solver. Setup of Solver in MS Excel Setting up Solver in the Microsoft Excel environment is easy. The following steps help you to run solver in MS Excel. 1. Select Tools Add-ins. . 2. Click “Solver Add-in” and then click OK 3. The setup is completed and Solver can be found under the “Tools” menu -1-
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
IELM202 Tutorial 1 2/8 Implementation of Solver in MS Excel Recall the most familiar example in the course. That involves the production decision for products P, Q, R respectively with the constraints of the Machine A, B, C and D availability and the demand constraints of the products. The machine hour required for different products and the availability of different machines are as following: Unit Processing Time (min) Machine Availability (min) P Q R Machine A 20 10 10 2400 Machine B 12 28 16 2400 Machine C 15 6 16 2400 Machine D 10 15 0 2400 The demand and profit of the products are as following: Product P Product Q Product R Profit $45 $60 $50 Maximum Sales 100 40 60 The problem can be formulated as the following linear programming: Define: P = number of the production of P Q = number of the production of Q R = number of the production of R Objective function: Max Z = 45P + 60Q + 50R Subject to: 20P + 10Q + 10R 2400 12P + 28Q + 16R 2400 15P + 6Q + 16R 2400 10P + 15Q 2400 P 100, Q 40, R 60 P 0, Q 0, R 0 From the example, the following steps guide you how to solve the problem in MS
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

Tutorial 1 - IELM202 Tutorial 1 1/8 User Guide of MS Solver...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online