Integer programming p6-40, p6-44

profilesengkuni
 (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               
                
                
                
                
                
                
QUESTION: You are given a group of possible investment projects for your company's capital. For each project, ou are given the NPV the project would add to the firm,
as well as the cash outflow required by each project during each year. Given the information above, determine the ivnestments that maximize the firm's NPV. The firm
has $30 million available during each of the next five years. All numbers are in millions of dollars.        
  • 9 years ago
Integer programming p6-40, p6-44
NOT RATED

Purchase the answer to view it

blurred-text
  • attachment
    integer_programming_p6-40_p6-44.xlsx