Question

Consider the following linear program:

Min		3A	+	5B
s.t.
		A	+	2B	≥	6
		A	+	B	≥	4
				A, B	≥	0

What is the value of the objective function? If required, round your answer to one decimal place.

Objective function value:

Thanks is advance.

Answer 1

Excel

Cell no.	B	C	D	E	F	G
6		X	Y	Z	Total		Max capacity
7	Decision variable
8	Maximize	3	5	0	0
9	Subject to
10	equation 1	1	2	0	0	>=	6
11	equation 2	1	1	0	0	>=	4

Formulas

Cell no.	B	C	D	E	F	G
6		X	Y	Z	Total		Max capacity
7	Decision variable
8	Maximize	3	5	0	=C8*$C$7 + D8*$D$7
9	Subject to
10	equation 1	1	2	0	=C10*$C$7 + D10*$D$7	>=	6
11	equation 2	1	1	0	=C11*$C$7 + D11*$D$7	>=	4

Excel solver

Answer:

Cell no.	B	C	D	E	F	G
6		X	Y	Z	Total		Max capacity
7	Decision variable	2.00	2.00
8	Maximize	3	5	0	16
9	Subject to
10	equation 1	1	2	0	6	>=	6
11	equation 2	1	1	0	4	>=	4

The minimum value of the objective function is 16