Question

Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.)

Minimize Z	=	4A + 6B.
7A + 13B	≥	100
2A + 12B	≥	38
4B	≥	20

Decision for A
Decision for B
Total cost	$

	Resources Used
A
B
C

Answer 1

Using excel solver to solve the LP,we get the following output:

In excel :

F4=4*B3+6*C3

D7=SUMPRODUCT(B3:C3,B7:C7)

D8=SUMPRODUCT(B3:C3,B8:C8)

D9=SUMPRODUCT(B3:C3,B9:C9)

Decision for A=0

Decision for B=7.69

Total cost=z=$ 46.15

Resoures Used 100 92.31 30.77

Calculations are as shown below:

F4 7.69 46.15 6 Constraints Resoures Used 100 92.31 30.77 13 100 2 2 38 4 10 Solver Parameters Set Target Cell: Equal To: O Max 12 13 14 15 16 17 SF$4 C) yalue of: 10 O Min By Changing Cells: $8$3:$C$3 Subject to the Constraints: Options 19 Reset All 21 Delete 23 24