Solve the problems using excel-Optimization Models with Integer Variables
March 26, 2022ITS632_Chapter7.ppt
March 26, 2022
P326-40
| Capital budgeting |
|
| Note: All cash amounts are in $millions. |
|
| Cash outflows in various years, NPV of projects |
|
Project 1 |
Project 2 |
Project 3 |
Project 4 |
Project 5 |
Project 6 |
Project 7 |
Project 8 |
Project 9 |
Project 10 |
Project 11 |
Project 12 |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| NPV |
|
| Selected projects (1 if selected, 0 if not) |
|
Project 1 |
Project 2 |
Project 3 |
Project 4 |
Project 5 |
Project 6 |
Project 7 |
Project 8 |
Project 9 |
Project 10 |
Project 11 |
Project 12 |
|
|
| Budget constraints |
|
Outflow |
|
Budget |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
|
| Total NPV |
Problem 5.10
P326-44
| Choosing college courses |
|
| Requirements (along side) that are met by taking available courses (along top) (1 if it fills reqt, 0 if not) |
|
Calculus |
OR |
Data Structures |
Bus Stats |
Simulation |
Intro to Comp Prog |
Forecasting |
| OR |
| Math |
| Computer |
|
|
Calculus |
OR |
Data Structures |
Bus Stats |
Simulation |
Intro to Comp Prog |
Forecasting |
| Course taken |
|
| Prerequisite constraints |
|
|
|
|
|
(Calculus for Bus Stats) |
|
|
|
|
|
(Intro to Comp Prog for Simulation) |
|
|
|
|
|
(Intro to Comp Prog for Data Structures) |
|
|
|
|
|
(Bus Stats for Forecasting) |
|
| Major requirement constraints |
|
Courses taken |
|
Required |
| OR |
| Math |
| Computer |
|
| Total courses |
