Supply
mrsaiz
Prb3_25_empty_Solver1.xlsxStorage Plan
| Leased in month | Through month | Total | Total | |||||||||||||||
| 1 | 2 | 3 | 4 | 5 | Available | Needed | ||||||||||||
| 1 |
: Variable cell |
: Variable cell |
: Variable cell | 20000 | ||||||||||||||
| 2 | -- |
: Variable cell |
: Variable cell |
: Variable cell | 30000 | |||||||||||||
| 3 | -- | -- : Variable cell |
: Variable cell |
: Variable cell |
: Variable cell |
: Constraint cell |
: Variable cell |
: Variable cell |
: Constraint cell |
: Variable cell | 40000 | |||||||
| 4 | -- | -- | -- |
: Variable cell |
: Constraint cell |
: Variable cell |
: Constraint cell | 35000 | ||||||||||
| 5 | -- | -- | -- | -- |
: Variable cell |
: Constraint cell | 50000 | |||||||||||
| Leasing costs | ||||||||||||||||||
| $55 | $95 | $130 | $155 | $185 | ||||||||||||||
| -- | $55 | $95 | $130 | $155 | ||||||||||||||
| -- | -- | $55 | $95 | $130 | ||||||||||||||
| -- | -- | -- | $55 | $95 | ||||||||||||||
| -- | -- | -- | -- | $55 | ||||||||||||||
| Total leasing cost | ||||||||||||||||||
|
: Objective cell |
Shop @ Home
Minimize: F19 By Changing: C6:G6,D7:G7,E8:G8,F9:G9,G10 Subject to: H6:H10>=I6:I10 C6:G6,D7:G7,E8:G8,F9:G9,G10>=0
Part d
| Leased in month: | Through month: | Total | Total | |||||||||||||||
| 1 | 2 | 3 | 4 | 5 | Available | Needed | ||||||||||||
| 1 |
: Variable cell |
: Variable cell |
: Variable cell | 20000 | ||||||||||||||
| 2 | -- |
: Variable cell |
: Variable cell |
: Variable cell | 30000 | |||||||||||||
| 3 | -- | -- : Variable cell |
: Variable cell |
: Variable cell |
: Variable cell |
: Constraint cell |
: Variable cell |
: Variable cell |
: Constraint cell |
: Variable cell | 40000 | |||||||
| 4 | -- | -- | -- |
: Variable cell |
: Constraint cell |
: Variable cell |
: Constraint cell | 35000 | ||||||||||
| 5 | -- | -- | -- | -- |
: Variable cell |
: Constraint cell | 50000 | |||||||||||
| Leasing costs | ||||||||||||||||||
| $55 | $95 | $130 | $155 | $185 | ||||||||||||||
| -- | $55 | $95 | $130 | $155 | ||||||||||||||
| -- | -- | $55 | $95 | $130 | ||||||||||||||
| -- | -- | -- | $55 | $95 | ||||||||||||||
| -- | -- | -- | -- | $55 | ||||||||||||||
| Total leasing cost | ||||||||||||||||||
|
: Set cell |
Shop @ Home
