TUGAS

PEMODELAN TEKNIK SIPIL (MK)

DOSEN PENGAMPU : DR.IR. IWAN K HADIHARDAJA, MSc

oleh : Jemmy J Rangan

L5A009010

PROGRAM DOKTOR TEKNIK SIPIL

PASCASARJANA UNIVERSITAS DIPONEGORO

SEMARANG

JUNI 2010

Langkah-langkah Pekerjaan :

1. Aktifkan Solver Add-Ins

2. Jalankan Solvernya

3. Masukkan cell target dan lain-lainnya

4. Jalankan pemecahannya dengan Solver (SOLVE)

Hasilnya sebagai berikut :

Microsoft Excel 12.0 Answer ReportWorksheet: [tugas pak DR Iwan.xlsx]coba 4 OKReport Created: 6/6/2010 19:15:21 Boy

Target Cell (Min)Cell Name Original Value Final Value

$K$4 cost 0.366666667 22.5Cost minimum untuk membuat barang tersebut sebesar $ 22.5

Adjustable CellsCell Name Original Value Final Value

$B$3 variables x1 1

5

$C$3 variables x2 1

25

$D$3 variables x3 1

5

$E$3variables d1+

1 -

$F$3variables d1-

1

175

$G$3variables d2+

1

5

$H$3 variables -

d2- 1

$I$3variables d3+

1 -

$J$3variables d3-

1

50

ConstraintsCell Name Cell Value Formula Status Slack

$K$6 profit 3,000 $K$6=$M$6Not Binding 0

$K$7 labor 400 $K$7=$M$7

Not Binding 0

$K$8 lumber 500 $K$8=$M$8

Not Binding 0

$K$9 chairs 5 $K$9>=$M$9 Binding -

$K$10 benches 25 $K$10>=$M$10

Not Binding

18

$K$11 tables 5 $K$11>=$M$11 Binding -

$K$12 overtime 5 $K$12<=$M$12

Not Binding 5.000000001

$B$3 variables x1 5 $B$3=integer Binding -

$C$3 variables x2 25 $C$3=integer Binding -

$D$3 variables x3 5 $D$3=integer Binding -

Yang lain lagi untuk w1 nya:

Dengan cara yang sama didapat :

Furniture Manufacture Example

minimize x1

x2

x3

d1+ d1-

d2+

d2-

d3+ d3- RHS

variables 39

8

5 -

5

5

-

-

135

cost 0.17

0.33 45.83333333

subject to :

profit 50

90

75

(1)

1

(10)

(1)

3,000

= 3000

labor 6

12

15

(1)

1

400

= 400

lumber 5

15

10

(1)

1

500

= 500

chairs 1

39

≥ 5

benches 1

8

≥ 7

tables 1

5

≥ 5

overtime 1

5

≤ 10

Microsoft Excel 12.0 Answer ReportWorksheet: [tugas pak DR Iwan.xlsx]coba 3Report Created: 6/6/2010 18:54:36 Boy

Target Cell (Min)Cell Name Original Value Final Value

$W$4 cost 0.5 45.83333333

Adjustable CellsCell Name Original Value Final Value

$N$3 variables x1 1

39

$O$3 variables x2 1

8

$P$3 variables x3 1

5

$Q$3variables d1+

1 -

$R$3variables d1-

1

5

$S$3variables d2+

1

5

$T$3variables d2-

1 -

$U$3variables d3+

1 -

$V$3variables d3-

1

135

ConstraintsCell Name Cell Value Formula Status Slack

$W$6 profit 3,000 $W$6=$Y$6Not Binding 0

$W$7 labor 400 $W$7=$Y$7

Not Binding 0

$W$8 lumber $W$8=$Y$8 Not 0

500 Binding

$W$9 chairs 39 $W$9>=$Y$9

Not Binding

34

$W$10 benches

8 $W$10>=$Y$10

Not Binding

1

$W$11 tables

5 $W$11>=$Y$11 Binding -

$W$12 overtime

5 $W$12<=$Y$12

Not Binding 5.000000001

$N$3 variables x1 39 $N$3=integer Binding -

$O$3 variables x2 8 $O$3=integer Binding -

$P$3 variables x3 5 $P$3=integer Binding -