Reference no: EM132210658
1) Each __________ must be placed in separate cells in the spreadsheet.
a. Variable name.
b. Cell label.
c. Constraint name.
d. Decision variable.
2) The proper sequence of steps in implementing the model in Excel presented in the textbook is:
a. Organize the data, represent the objective function, represent the decision variables, represent the constraints, and represent the bounds on the decision variables.
b. Organize the data, represent the bounds on the decision variables, represent the objective function, represent the constraints, and represent the decision variables.
c. Organize the data, represent the decision variables, represent the objective function, represent the constraints, and represent the bounds on the decision variables.
d. Represent the decision variables, organize the data, represent the objective function, represent the constraints, and represent the bounds on the decision variables.
3) Representing the decision variables requires
a. Allocating a separate cell in a spreadsheet to each decision variable.
b. Determining the optimal solution.
c. Identifying the decision alternatives.
d. Finding the location of spreadsheet cells containing non-zero values.
4) Analytic Solver Platform (ASP) is
a. Equivalent to the Excel solver.
b. A complication that significantly affects the performance of Excel.
c. Not used in this textbook.
d. An advanced software that has added capabilities that enhance the performance of the basis Excel solver.