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.
Answer the question on a worddocs. Present your answers and working to each question in a excel spreadsheet
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.
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
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
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
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
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