Chapter A, Problem 1OQ

Summary Introduction

To solve: The given problem using Excel Solver.

Explanation of Solution

Given information:

$\begin{array}{c}\text{Maximize Z}=3X+Y\\ \text{Subject to:}\\ 12X+14Y\le 85\\ 3X+2Y\le 18\\ Y\le 4\end{array}$

Solving using excel solver:

The solver add-in is selected under the data tab in Excel. The input is given shown below:

Excel input:

Solver input:

The solver input is given as shown below:

Formulas:

The formulas for the respective cells are given as shown below:

Solver output:

After providing the necessary excel inputs, solver inputs, and necessary formulas, the solver is run to give the below output:

Excel results:

X             = 6

Y             = 0

Maximum value     = 18