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 CDRom
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
Addins.
.
2.
Click “Solver Addin” and then click OK
3.
The setup is completed and Solver can be found under the “Tools” menu
1
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentIELM202
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
This is the end of the preview.
Sign up
to
access the rest of the document.
 Fall '10
 D
 Linear Programming, Decision Making, objective function, MS Solver

Click to edit the document details