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 = 8A + 48
8A + 6B ≥ 60
5A + 17B ≥ 19
3B ≥ 20

Decision for A
Decision for B
Tulal cost

Resources Used
A
B
C

Answer 1

To minimize Z=8A+5B using Excel Solver, set up the equations and constraints in Excel, then use Solver to find A and B that minimize Z while satisfying the constraints 8A+6B≥60, 5A+17B≥19, and 3B≥20, with B≥20.

Step-by-step explanation:

To solve the given linear optimization problem using Excel's Solver, we need to set up our model to minimize the objective function Z = 8A + 5B. We're also given a set of constraints that must be satisfied:

• 8A + 6B ≥ 60
• 5A + 17B ≥ 19
• 3B ≥ 20

The decisions variables for A and B must be determined to ensure the total cost, Z, is minimized while adhering to the constraints. The solution involves setting up these equations in Excel, then using Solver to find the values of A and B that minimize Z.

The steps in Excel involve:

1. Entering the coefficients of the objective function and constraints into cells.
2. Using the 'Solver' add-in to specify the objective cell, decision variable cells, and constraint cells.
3. Running the Solver to get the optimized values for A and B.

Make sure all cells are populated (use 0s where necessary), and round your answers to two decimal places. Remember that B must be at least 20 to satisfy the third constraint directly.