Welcome to your first Excel Exercise! Your first assignment is to ensure you have activated the Solver that is within your Excel software. This assignment should be completed after you read Chapters 1 and 2 and watched the video I have identified on the Assignment tab. Please click over to the Assignment tab (bottom left hand corner of this page) and please respond to the five questions. Have a great week and please let me know if there is anything I can do for you!
Please respond to these five questions and submit this file to me via the course dropbox no later than midnight Central Time Sunday night. Please type your answers in unbolded black font directly below the question.
1. (2 Points) Watch the following video: https://www.youtube.com/watch?v=KcM2-VEwhcY&t=67s. After watching the video, have you successfully enabled Solver?
2. (2 Points) In the video, in which cell is the Objective Function?
3. (2 Points) In the video, in which cells are the Decision Variables?
4. (2 Points) In the video, what is the value calcuated in cell E16?
5. (2 Points) From the assigned readings and video, once a linear programming model is solved and the value of the objective function is obtained, is that value considered the optimal solution? Or, are the values of the associated decision variables considered the optim
al solution?
