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””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
Order Essay

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

Place your order
(550 words)

Approximate price: $22

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:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
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.

Read more

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.

Read more

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.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more