Long description
The formula for total profit is seen under column R of a table in the fifth row as: equal to SUMPRODUCT open parens dollar sign B dollar sign 4 colon dollar sign Q dollar sign 4 comma B5 colon E5 close parens.
Four tables are present in the graph, all of them having the column headers as the variables: A1, A2, A3, A4, B1, B2, B3, B4, IA1, IA2, IA3, IA4, IB1, IB2, IB3, and IB4.
In the first table:
The row headers are solution and minimum cost.
The first row has the values: 1276.9, 223.1, 1757.7, 792.3, 1000, 2522.2, 77.8, 1700, 476.9, 0, 757.7, 450, 0, 1322.2, 0, and 300.
The second row has the values: 20, 20, 22, 22, 15, 15, 16.5, 16.5, 0.36, 0.36, 0.36, 0.36, 0.26, 0.26, 0.26, and 0.26.
The value of total cost, 169294.9, is present ...
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.
