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 5 colon dollar sign G dollar sign 5 comma B6 colon E6 close parens.
Two tables are present in this sheet and both the tables have F, P1, P2, P3, P4, and P5 as the column headers.
In the first table:
The row headers are the variables, values and cost.
The first row has the values 10, 0, 7, 2, 5, and 0.
The second row has the values 100, 32, 32, 32, 32, and 32.
The value of total profit, 1448, is seen under column H in the sixth row.
In the second table:
The row headers are the constraints 9 a.m. to 10 a.m., 10 a.m. to 11 a.m., 11 a.m. to noon, noon to 1 p.m., 1 p.m. to 2 p.m., 2 p.m. to 3 p.m., ...
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.
