Long description
The formula for total cost is seen under column E of a table in the sixth row as: equal to SUMPRODUCT open parens dollar sign B dollar sign 5 colon dollar sign D dollar sign 5 comma B6 colon D6 close parens.
Two tables are present in this sheet and both the tables have Xa, Xb, and Xc, as the column headers between columns B and D in row 4. Xa, Xb, Xc represent grain A, grain B, and grain C, respectively.
In the first table:
The row headers are the variables, solution and minimize.
The first row has the values 0.025, 0.05, and 0.05.
The second row has the values 0.33, 0.47, and 0.38.
The value of total cost, 0.05075, is seen under column E in the sixth row.
In the second table:
The row headers are the constraints total protein, ...
Get Quantitative Analysis for Management, 13/e now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
