Solve the problems using excel-Optimization Models with Integer Variables
Mark3433
Module5ProblemWorkbook.xlsxP326-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 |
