Long description
The formula for total cost 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 4 comma B5 colon G5 close parens.
The screenshot shows two tables with X1, X2, X3, X4, X5, and X6 as the column headers between columns B and G.
In the first table:
The row headers are the variables solution and minimum cost.
The first row has the values 0, 600, 140, 1000, 0, and 560.
The second row has the values 7.5, 6.8, 5.5, 6.9, 7.25, and 6.1.
The value of total cost, 15166, is seen under column H in the fifth row.
In the second table:
The row headers are the constraints total households, 30 and younger, 31 to 50, border states, and 51 plus border states. ...
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.
