Scribd
Upload
9 views2 pages

Menggunakan Solver di Excel 2013

The document provides instructions for setting up an optimization problem in Microsoft Excel using the Solver add-in as follows: 1) Check for the Data Solver menu and if not present, load the Solver Add-in 2) Enter the objective function and constraints in a table with coefficients 3) Enter a formula using SUMPRODUCT to calculate the values in the solution column 4) Access the Solver from the Data menu and input the model to find the optimal solution

Uploaded by

Frandes Reynaldo Sitio
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views2 pages

Menggunakan Solver di Excel 2013

The document provides instructions for setting up an optimization problem in Microsoft Excel using the Solver add-in as follows: 1) Check for the Data Solver menu and if not present, load the Solver Add-in 2) Enter the objective function and constraints in a table with coefficients 3) Enter a formula using SUMPRODUCT to calculate the values in the solution column 4) Access the Solver from the Data menu and input the model to find the optimal solution

Uploaded by

Frandes Reynaldo Sitio
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Tahap persiapan Microsoft Office Excel :

- Cek menu : Data Solver

- Jika tidak ada : Load the Solver Add-in


Caranya :

The Solver Add-in is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or
Excel. To use it in Excel, however, you need to load it first.

1. Click the Microsoft Office Button , and then click Excel Options.

2. Click Add-Ins, and then in the Manage box, select Excel Add-ins.

3. Click Go.

4. In the Add-Ins available box, select the Solver Add-in check box, and then click OK.

Tip If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.

If you get prompted that the Solver Add-in is not currently installed on your computer, click Yes to install
it.

5. After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data
tab.

Soal :

Min Z=X1+X2
Kendala
3X1+X2 >= 6
X2 >= 3
X1 <= 4

Tuliskan fungsi objektif dan kendala pada excel seperti berikut ini :

(Misalnya penulisan x1 pada sel D9 : )

x1 x2 solusi batasan
1 1 0 0
3 1 0 >= 6
0 1 0 >= 3
1 0 0 <= 4

X1 X2
0 0
Kolom x1 dan x2 diisi dengan koefisien dari fungsi objektif dan kendala.

Kolom solusi diisi dengan berikut ini :

F10 : =SUMPRODUCT(D10:E10,$D$16:$E$16)

F11 : =SUMPRODUCT(D11:E11,$D$16:$E$16)

F12 : =SUMPRODUCT(D12:E12,$D$16:$E$16)

F13 : =SUMPRODUCT(D13:E13,$D$16:$E$16)

D16 dan E16 di-nol-kan, nanti terupdate setelah di-solve..

Pilih menu data solver : isikan data berikut :

Tekan Solve, pilih report : answer

Print out sheet : answer report

You might also like