Long description
The formula for total cost is seen under column F of a table in the sixth row as: equal to SUMPRODUCT open parens dollar sign B dollar sign 5 colon dollar sign E dollar sign 5 comma B6 colon E6 close parens.
Two tables are present in this sheet and both the tables have X1, X2, X3, and X4, as the column headers between columns B and E in row 4. X1, X2, X3, and X4 represent X100 Regular, X100 Economy, X220 Regular, and X220 Economy, respectively.
In the first table:
The row headers are the variables, solution and cost.
The first row has the values 15000, 26666.67, 10000, and 5333.33.
The second row has the values 30, 30, 34.8, and 34.8.
The value of total cost, 1783600, is seen under column F in the sixth row.
In the second table: ...
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.
