Ive a operation research question needed to solve by excel sheet. plz mention hand calculation, so that I can create excel file. that I wonder if you can help me with. will give u surely likes if all question solved!

The eleven competing robotic R\&D/Manufacturing projects are given code names P1 to P11. Each project is associated with a single new product that could be developed by R\&D, with a prototype to be built by Manufacturing. The following is known for each project: a. The projected two year R\&D and initial manufacturing cost. b. The estimated five year NPV. c. The R\&D division's estimate of the probability of success of making the new product. d. The marketing division's qualitative estimate of the new product's ability to capture a 50% market share. The ATP Committee has allocated a budget of $750,000 to the eleven projects. The problem is to select the most beneficial subset of the eleven projects that does not exceed the total budget. The data for this example are given in the following Table. Assume that Cost (criterion)is 3 times important than NPV, and NPV is twice important than Probability of success and Market share. 1. Use appropriate method to find the weight of each criterion 2. Use SAW method to rank alternatives 3. Do sensitivity analysis for SAW method a. Scenario 1: all criteria has the same weight b. Scenario 2: cost is the most important criteria and the weight for that is 0.36