please show how to put in excel and solve it i have no idea how to do that

Homework#6 Total points: 100 (Must submit a pdf with an Excel file) 1. The projects review committee of Microsoft has $20 million to allocate next year to new software product development. Any or all of five projects in Table may be accepted. All amounts in the Table are in $1000 units. Each project has an expected life of 9 years. MARR is 15%. (a) Formulate the linear programming model, develop a spreadsheet, and solve the capital rationing problem with a budget limit of (1) 20 million, (2) 13 million, and (3) 30 million. (b) If each project requires 20 employees and each employee's salary is 2,500 USD, does your decision in (a) change? Show via linear programming and spreadsheet as well. Homework#6 Total points: 100 (Must submit a pdf with an Excel file) 1. The projects review committee of Microsoft has $20 million to allocate next year to new software product development. Any or all of five projects in Table may be accepted. All amounts in the Table are in $1000 units. Each project has an expected life of 9 years. MARR is 15%. (a) Formulate the linear programming model, develop a spreadsheet, and solve the capital rationing problem with a budget limit of (1) 20 million, (2) 13 million, and (3) 30 million. (b) If each project requires 20 employees and each employee's salary is 2,500 USD, does your decision in (a) change? Show via linear programming and spreadsheet as well