The government decided on opening new grant scheme for pharmaceutical

The government decided on opening new grant scheme for pharmaceutical.

The government decided on opening new grant scheme for pharmaceutical research aiming to support the development of new drugs that eventually reduce the yearly budget the government allocates to drug subsidies for blood related diseases. Each university will not be allowed to ask for more than $1.7 million of funding overall (for all different grants from this Uni.). An internal committee at Wales University received 6 different grant proposals. They need to decide which of these proposals to be sent for the government competition. The amount asked for each of the 6 grants and the estimated saving amounts for the government is given bellow. See picture 2
The Wales committee think that it is possible to estimate the probability of the selection of the grant proposal by the government as a function of the number of young researchers allocated to work on the proposed grant and the past years success coefficient of the leading professor. The success coefficients of the leading professors associated with each grant are 3.1, 2.5, 4.5, 5.6, 8.2 and 8.5 for grants 1 to 6, respectively.
The exact formula for the probability is  “The number of Young Researcher”https://www.sweetstudy.com/”The number of young researcher” + “the success coefficient”.
Another limitation of the Wales committee is that Faculty of Pharmacy has no more than 25 young researchers.
1. Develop a model to help to Wales committee decide which grant to select for the government scheme and how many of the young researchers to include in each grant proposal. (Wales University is interested to save government’s drug subsidies as a result of research conducted in Wales). [12 points]
 2. Solve the problem in Excel. [5 points]
3. Which grant proposals should Wales committee submit for the government scheme? [4 points]
4. How many young researchers to include in each of the selected grant proposals? [4 points] Hint: it is a non-linear problem. Make sure you use multi-starts, as the initial solution plays a crucial role for non-linear problems. To increase the chances to get the best solution, rerun the model once again after receiving the first optimal solution. 

Answer the question on a worddocs. Present your answers and working to each question in a excel spreadsheet

The government decided on opening new grant scheme for pharmaceutical

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
All your data is secure and will never be disclosed to third parties. Your essay or assignment is treated as your intellectual property and can never be shared or provided as a sample to aspiring customers.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
You will never have to worry about deadlines – 98% of our assignments are completed on time.
Money Back
We give refunds anytime you feel the work did not meet your expectations. However, we have not refunded any papers in the last 6 months as our team keeps improving their quality and customer service.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of writers and tutors. We are here for you.
Power up Your Study Success with Experts We’ve Got Your Back.