Quantitative Analysis for Management, 13/e

Long description

The formula for total value is seen under column H of a table in the fifth row as: equal to SUMPRODUCT open parens dollar sign B dollar sign 4 colon dollar sign G dollar sign 5 comma B5 colon E5 close parens.

Two tables are present in this sheet and both the tables have X1, X2, X3, X4, X5, and X6 as the column headers between columns B and G in row 3.

In the first table:

• The row headers are the variables, values and load value in dollars.

• The first row has the values 0.3333, 1, 0, 0, 0, and 0.

• The second row has the values 22500, 24000, 8000, 9500, 11500, and 9750.

• The value of total value, 31500, is seen under column H in the fifth row.

In the second table:

• The row headers are the constraints total weight, percentage of item 1, ...