# 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.homeworkmarket.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.

Don't use plagiarized sources. Get Your Custom Essay on
The government decided on opening new grant scheme for pharmaceutical
Just from \$13/Page

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

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.