7/25/2019 Solver Solution 1

1/22

5 3

DV X1 X2 Optimal Value RHS Consumption

10 20 110

2 1 40 40

1 2 50 50

constraints

7/25/2019 Solver Solution 1

2/22

40 50

DV X1 X2 Optimal Value RHS

24 8 1360

1 2 40

4 3 120

10

DV X1

answers are ater optimalit! test 0

2

1

1

7/25/2019 Solver Solution 1

3/22

5 4

DV X1 X2

Consumption 3 1"5

6 4

40 1 2

120 #1 1

0 1

60

X2 Optimal Value RHS Consumption

70 4200

1 70 70

1 40 70

3 90 210

0 0

7/25/2019 Solver Solution 1

4/22

Optimal Value RHS Consumption

21

24 24

6 6

1 #1"5

2 1"5

not ( consumptionco) in assumption' r consumin& n!p*!sical

7/25/2019 Solver Solution 1

5/22

Microsot !"cel 1#$0 %ns&er Report

'or(s)eet* +sol,er solution 1$"ls"-Sol,er 3

Report Create.* 21/01/2016 10*0*#

Result* Sol,er oun. a solution$ %ll Constraints an. optimalit con.itions a

Sol,er !nine

+n&ine, Simple- ./

Solution ime, 0"031 Secon(s"terations, 2 Su%pro%lems, 0

Sol,er Options

a- ime nlimite( terations nlimite( /recision 0"000001

a- Su%pro%lems nlimite( a- nte&er Sols nlimite( nte&er olerance 1 $s

O%7ecti'e Cell a-9

Cell ame Oriinal Value 5inal Value

:+:4 /ro;t otal 25600 254 >8 Contin

:C:3 Decision Varia%les ope(s 54 53 Contin

:D:3 Decision Varia%les C*il( Seats 0 0 Contin

Constraints

Cell ame Cell Value 5ormula Status:+:5 Capital otal >3000 :+:5?@:A:5 =in(in&

:+:6 Stora&e otal 102 :+:6?@:A:6 =in(in&

7/25/2019 Solver Solution 1

6/22

e satise.$

ume one&ati'e

Slac(0

0

7/25/2019 Solver Solution 1

7/22

Microsot !"cel 1#$0 Sensiti,it Report

'or(s)eet* +sol,er solution 1$"ls"-Sol,er 3

Report Create.* 21/01/2016 10*0*#

Varia%le Cells

5inal Re.uce. O8ecti,eCell ame Value Cost Coecient

:=:3 Decision Varia%les =ic!cle >8 0 100

:C:3 Decision Varia%les ope(s 53 0 300

:D:3 Decision Varia%les C*il( Seats 0 #20 50

Constraints

5inal S)a.o& Constraint

Cell ame Value :rice R$H$ Si.e

:+:5 Capital otal >3000 0"166666666< >3000

:+:6 Stora&e otal 102 100 102

7/25/2019 Solver Solution 1

8/22

%llo&ale %llo&alencrease Decrease

50 12"5

66"66666666< 100

201"000+B030

%llo&ale %llo&ale

ncrease Decrease

2>400 31800

53 24"5

7/25/2019 Solver Solution 1

9/22

Microsot !"cel 1#$0 %ns&er Report

'or(s)eet* +sol,er solution 1$"ls"-Sol,er 3

Report Create.* 21/01/2016 10*10*41

Result* Sol,er oun. a solution$ %ll Constraints an. optimalit con.itions a

Sol,er !nine

+n&ine, Simple- ./

Solution ime, 0"016 Secon(s"terations, 2 Su%pro%lems, 0

Sol,er Options

a- ime nlimite( terations nlimite( /recision 0"000001

a- Su%pro%lems nlimite( a- nte&er Sols nlimite( nte&er olerance 1 $s

O%7ecti'e Cell a-9

Cell ame Oriinal Value 5inal Value

:+:4 /ro;t otal 258 >4 Contin

:C:3 Decision Varia%les ope(s 53 54 Contin

:D:3 Decision Varia%les C*il( Seats 0 0 Contin

Constraints

Cell ame Cell Value 5ormula Status:+:5 Capital otal >3000 :+:5?@:A:5 =in(in&

:+:6 Stora&e otal 101 :+:6?@:A:6 =in(in&

7/25/2019 Solver Solution 1

10/22

e satise.$

ume one&ati'e

Slac(0

0

7/25/2019 Solver Solution 1

11/22

Microsot !"cel 1#$0 %ns&er Report

'or(s)eet* +sol,er solution 1$"ls"-Sol,er 3

Report Create.* 21/01/2016 10*11*#0

Result* Sol,er oun. a solution$ %ll Constraints an. optimalit con.itions are

Sol,er !nine

+n&ine, Simple- ./

Solution ime, 0"015 Secon(s"terations, 2 Su%pro%lems, 0

Sol,er Options

a- ime nlimite( terations nlimite( /recision 0"000001

a- Su%pro%lems nlimite( a- nte&er Sols nlimite( nte&er olerance 1 $ss

O%7ecti'e Cell a-9

Cell ame Oriinal Value 5inal Value

:+:4 /ro;t otal 25600 25600"166664 >3">>666666< Contin

:C:3 Decision Varia%les ope(s 54 54"00166666< Contin

:D:3 Decision Varia%les C*il( Seats 0 0 Contin

Constraints

Cell ame Cell Value 5ormula Status:+:5 Capital otal >3001 :+:5?@:A:5 =in(in&

:+:6 Stora&e otal 101 :+:6?@:A:6 =in(in&

7/25/2019 Solver Solution 1

12/22

satise.$

me one&ati'e

Slac(0

0

7/25/2019 Solver Solution 1

13/22

Microsot !"cel 1#$0 Sensiti,it Report

'or(s)eet* +sol,er solution 1$"ls"-Sol,er 3

Report Create.* 21/01/2016 10*11*#1

Varia%le Cells

5inal Re.uce. O8ecti,eCell ame Value Cost Coecient

:=:3 Decision Varia%les =ic!cle >3">>666666< 0 100

:C:3 Decision Varia%les ope(s 54"00166666< 0 300

:D:3 Decision Varia%les C*il( Seats 0 #20 50

Constraints

5inal S)a.o& Constraint

Cell ame Value :rice R$H$ Si.e

:+:5 Capital otal >3001 0"166666666< >3001

:+:6 Stora&e otal 101 100 101

7/25/2019 Solver Solution 1

14/22

%llo&ale %llo&alencrease Decrease

50 12"5

66"66666666< 100

201"00000+B030

%llo&ale %llo&ale

ncrease Decrease

281>> 32401

54"00166666< 23"4>>16666

7/25/2019 Solver Solution 1

15/22

Microsot !"cel 1#$0 %ns&er Report

'or(s)eet* +sol,er solution 1$"ls"-Sol,er 3

Report Create.* 21/01/2016 10*1#*0

Result* Sol,er oun. a solution$ %ll Constraints an. optimalit con.itions a

Sol,er !nine

+n&ine, Simple- ./

Solution ime, 0"016 Secon(s"terations, 2 Su%pro%lems, 0

Sol,er Options

a- ime nlimite( terations nlimite( /recision 0"000001

a- Su%pro%lems nlimite( a- nte&er Sols nlimite( nte&er olerance 1 $s

O%7ecti'e Cell a-9

Cell ame Oriinal Value 5inal Value

:+:4 /ro;t otal 25600"166666< 30>00

Varia%le Cells

Cell ame Oriinal Value 5inal Value nteer

:=:3 Decision Varia%les =ic!cle >3">>6666666< 306 Contin

:C:3 Decision Varia%les ope(s 54"001666666< 1 Contin

:D:3 Decision Varia%les C*il( Seats 0 0 Contin

Constraints

Cell ame Cell Value 5ormula Status:+:5 Capital otal >3000 :+:5?@:A:5 =in(in&

:+:6 Stora&e otal 154 :+:6?@:A:6 =in(in&

7/25/2019 Solver Solution 1

16/22

e satise.$

ume one&ati'e

Slac(0

0

7/25/2019 Solver Solution 1

17/22

Microsot !"cel 1#$0 %ns&er Report

'or(s)eet* +sol,er solution 1$"ls"-Sol,er 3

Report Create.* 21/01/2016 10*17*0

Result* Sol,er oun. a solution$ %ll Constraints an. optimalit con.itions a

Sol,er !nine

+n&ine, Simple- ./

Solution ime, 0"016 Secon(s"terations, 2 Su%pro%lems, 0

Sol,er Options

a- ime nlimite( terations nlimite( /recision 0"000001

a- Su%pro%lems nlimite( a- nte&er Sols nlimite( nte&er olerance 1 $s

O%7ecti'e Cell a-9

Cell ame Oriinal Value 5inal Value

:+:4 /ro;t otal 30>00 31000

Varia%le Cells

Cell ame Oriinal Value 5inal Value nteer

:=:3 Decision Varia%les =ic!cle 306 310 Contin

:C:3 Decision Varia%les ope(s 1 0 Contin

:D:3 Decision Varia%les C*il( Seats 0 0 Contin

Constraints

Cell ame Cell Value 5ormula Status:+:5 Capital otal >3000 :+:5?@:A:5 =in(in&

:+:6 Stora&e otal 155 :+:6?@:A:6 =in(in&

7/25/2019 Solver Solution 1

18/22

e satise.$

ume one&ati'e

Slac(0

0

7/25/2019 Solver Solution 1

19/22

Microsot !"cel 1#$0 %ns&er Report

'or(s)eet* +sol,er solution 1$"ls"-Sol,er 3

Report Create.* 21/01/2016 10*19*26

Result* Sol,er oun. a solution$ %ll Constraints an. optimalit con.itions are

Sol,er !nine

+n&ine, Simple- ./

Solution ime, 0"015 Secon(s"terations, 3 Su%pro%lems, 0

Sol,er Options

a- ime nlimite( terations nlimite( /recision 0"000001

a- Su%pro%lems nlimite( a- nte&er Sols nlimite( nte&er olerance 1 $ss

O%7ecti'e Cell a-9

Cell ame Oriinal Value 5inal Value

:+:4 /ro;t otal 31000 31033"333333

Varia%le Cells

Cell ame Oriinal Value 5inal Value nteer

:=:3 Decision Varia%les =ic!cle 310 308"6666666< Contin

:C:3 Decision Varia%les ope(s 0 0 Contin

:D:3 Decision Varia%les C*il( Seats 0 3"3333333333 Contin

Constraints

Cell ame Cell Value 5ormula Status:+:5 Capital otal >3000 :+:5?@:A:5 =in(in&

:+:6 Stora&e otal 156 :+:6?@:A:6 =in(in&

7/25/2019 Solver Solution 1

20/22

satise.$

me one&ati'e

Slac(0

0

7/25/2019 Solver Solution 1

21/22

=ic!cle ope(s C*il( Seats

Decision Varia%les 308"666< 0 3"3333333333

/ro;t 100 300 50

Capital 300 1200 120

Stora&e 0"5 1 0"5

7/25/2019 Solver Solution 1

22/22

otal a- Capacit!

31033"3333333333

>3000 >3000

156 156