Chapter 4, Problem 6QP

a)

Summary Introduction

To determine: The sensitivity report using solver.

b)

Summary Introduction

To solve: The problem in spreadsheet.

c)

Summary Introduction

To determine: The optimal solution.

d)

Summary Introduction

To determine: Whether the optimal solution degenerate.

e)

Summary Introduction

To determine: Whether the optimal solution is unique.

f)

Summary Introduction

To determine: The change in solution when the plant in City C shuts for one day.

g)

Summary Introduction

To determine: The optimal objective function value for the given condition.

h)

Summary Introduction

To interpret: The reduced cost for shipping from City E to City M.