Respuesta :
The proper sequence of steps in implementing the model in Excel presented in the textbook is option b which is organize the data, represent the decision variables, represent the objective function, represent the constraints and represent the bounds on the decision variables.
Given process of implementing the model in Excel and we have to choose the correct process.
The process of implementing the model in Excel is as under:
1) Organize the data: In excel, to organize the data we have to put similar items in the same column. We have to design the data so that all rows have similar items in the same column. We have to keep a range of data separate and leave at least one blank column and one blank row between a related data range.
2) Represent the decision variables: Now we have to represent the decision variables according to which logical function performs tasks.
3)Represent the objective function: It is important because on the basis of this all the logical function perform tasks.
4) Represent the constraints: In excel when we are using solver we have to now represent the constraints of the objective function.
5) Represents the bounds on the decision variables.
Hence the proper sequence of steps in implementing the model in excel is Organize the data, represent the decision variables, represent the objective function, represent the constraints, and represent the bounds on the decision variables.
Learn more about excel at https://brainly.com/question/25879801
#SPJ4
