# Question: The following model was solved graphically in Chapter 2 Problem

The following model was solved graphically in Chapter 2 (Problem 22):

maximize Z = 5x1 + 8x2 ($, profit)

subject to

3x1 + 5x2 ≤ 50 (units, resource 1)

2x1 + 4x2 ≤ 40 (units, resource 2)

x1 ≤ 8 (units, resource 3)

x2 ≤ 10 (units, resource 4)

x1 , x2 ≥ 0

Given the following Excel spreadsheet for this model, indicate the formulas in cells F6, F7, F8, F9, G6, G7, G8, G9, and B14, and fill in the Solver Parameters window with the necessary information to solve the model. Solve the model usingExcel.

maximize Z = 5x1 + 8x2 ($, profit)

subject to

3x1 + 5x2 ≤ 50 (units, resource 1)

2x1 + 4x2 ≤ 40 (units, resource 2)

x1 ≤ 8 (units, resource 3)

x2 ≤ 10 (units, resource 4)

x1 , x2 ≥ 0

Given the following Excel spreadsheet for this model, indicate the formulas in cells F6, F7, F8, F9, G6, G7, G8, G9, and B14, and fill in the Solver Parameters window with the necessary information to solve the model. Solve the model usingExcel.

**View Solution:**## Answer to relevant Questions

Given the following graph of a linear programming model with a single constraint and the objective function maximize Z = 30x1 + 50x2 , determine the optimal solution point:Determine the values by which c1 and c2 must ...Solve Problem 10 graphically.a. Identify the amount of unused resources (i.e., slack) at each of the graphical extreme points.b. What would be the effect on the optimal solution if the production time on line 1 was reduced ...Solve the linear programming model formulated in Problem 16 for United Aluminum Company by using the computer.a. Identify and explain the shadow prices for each of the aluminum grade contract requirements.b. Identify the ...Solve the linear programming model formulated in Problem 25 for Rucklehouse Public Relations graphically.a. Determine the sensitivity ranges for the daily cost of a telephone interviewer and the number of personal interviews ...Alexis Harrington received an inheritance of $95,000, and she is considering two speculative investments—the purchase of land and the purchase of cattle. Each investment would be for 1 year. Under the present (normal) ...Post your question