Integer programming p6-40, p6-44 problem

goodjob
 (Not rated)
 (Not rated)
Chat

 

 

 

Capital budgeting           
             
Note: All cash amounts are in $millions.         
             
Cash outflows in various years, NPV of projects        
 Project 1Project 2Project 3Project 4Project 5Project 6Project 7Project 8Project 9Project 10Project 11Project 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 1Project 2Project 3Project 4Project 5Project 6Project 7Project 8Project 9Project 10Project 11Project 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) 
 CalculusORData StructuresBus StatsSimulationIntro to Comp ProgForecasting
OR       
Math       
Computer       
        
 CalculusORData StructuresBus StatsSimulationIntro to Comp ProgForecasting
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