Quantitative Analysis for Management, 13/e

Long description

Chandeliers and fans are represented by X1 and X2 respectively. The screenshot shows two tables with X1 and X2 as the column headers between columns B and C.

In the first table:

• The row headers are the variables, values and profit.

• The first row has the values 5 and 0.

• The second row has the values 7 and 6

• The value of total profit, 35, is seen under column D in the fifth row.

In the second table:

• The row headers are the constraints, wiring hours, and assembly hours.

• The first row has the values 2 and 3.

• The second row has the values 6 and 5.

• The LHS values for the rows are 10 and 30, under column D.

• The RHS values for the rows are 12 and 30, under column F.

Change constraint dialog box overlaps the Excel and displays Cell reference ...