Quantitative Analysis for Management, 13/e

Long description

The formula for total return is seen under column F of a table in the fourth row as: equal to SUMPRODUCT open parens dollar sign B dollar sign 4 colon dollar sign E dollar sign 4 comma B5 colon E5 close parens.

Two tables are present in this sheet and both the tables have X1, X2, X3, and X4, as the column headers.

In the first table:

• The row headers are the variables, solution and maximum return.

• The first row has the values 750000, 950000, 1500000, and 1800000.

• The second row has the values 0.07, 0.11, 0.19, and 0.15.

• The value of total return, 71200, is seen under column F in the fifth row.

In the second table:

• The row headers are the constraints trade, bonds, gold, construction, minimum of the sum of gold and construction, minimum ...