Question

In the decision tables and expected values workshop the profit for a cinema call center was modelled. The profit per call and the staff cost numbers were entered in separate cells and the formulae in the decision tables referenced these cells rather than using the numbers. What is the advantage of doing this?

I: It avoids using absolute references in the formulae.

II: It makes experimentation and sensitivity analysis easier.

III: It simplifies the formulae as there are fewer arithmetic operators.

Which of the statements I, II, and III are true?

Answer 1

Statements I and II are true.

I: It avoids using absolute references in the formulae.

II: It makes experimentation and sensitivity analysis easier.

Statement III is false. Referencing the cells will not simplify the formula. Formula remains the same.