Excel Homework

a. Please answer all questions.

b. This is an individual assignment – no group work.

c. Submissions must be made via Assignments on OnCourse

d. Failure to turn in the assignment will result in a Zero for this component

Q1

Please answer problem 7.5 a) and b) from Chapter 7 in your text book (20 points).

7.5a (10 points)

7.5b (10 points)

Q2

Please answer problem 7.10 a) and b) from Chapter 7 in your text book (20 points).

7.10a (10 points)

7.10b (10 points)

Q3

Please answer problem 7.11from Chapter 7 in your text book (20 points).

Q4

Please answer problem 7.12 a) and b) from Chapter 7 in your text book (20 points).

7.12a (10 points)

7.12b (10 points)

Q5

a. What is a Binary Integer Problem? (5 points)

b. What is meant by the term “contingent decision” in the context of a Binary Integer problem? (5 points)

c. What is meant by the term “mutually exclusive alternatives” in the context of a Binary Integer problem? (5 points)

d. Explain using an example: What is a set covering constraint? (5 points)

Good Luck!