Integer programming p6-40, p6-44 problem
(Not rated)
(Not rated)
| 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 | $1 | $3 | $4 | $6 | $5 | $4 | $2 | $0 | $1 | $3 | $9 | $8 |
| Year 2 | $3 | $4 | $4 | $5 | $1 | $5 | $3 | $0 | $1 | $2 | $2 | $7 |
| Year 3 | $4 | $2 | $3 | $3 | $2 | $2 | $1 | $3 | $4 | $4 | $4 | $1 |
| Year 4 | $1 | $1 | $2 | $2 | $3 | $5 | $4 | $6 | $8 | $1 | $1 | $1 |
| Year 5 | $1 | $2 | $1 | $3 | $8 | $5 | $6 | $7 | $3 | $6 | $1 | $1 |
| NPV | $20 | $25 | $30 | $35 | $40 | $42 | $31 | $33 | $35 | $37 | $38 | $39 |
| 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 | ||||||||||||
| 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 | |||||||
12 years ago
Integer programming p6-40, p6-44
NOT RATED
Purchase the answer to view it

- integer_programming_p6-40_p6-44.xlsx