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
We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.
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
The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.Read more
The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.Read more
The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.Read more
By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.Read more