: Ineed this problem solved in an excel template and detailed step by step. ECT PICKINGS Tazer, a pharmaceutical manufacturingcompany, entered the pharmaceutical market $12$ years ago with the introduction of six new drugs. Five of the six drugs were simplypermutations of existing drugs and therefore did not sell very heavily. The sixth drug, however, addressed hypertension and wasahuge success. Since Tazer had a patent on the hypertension drug, it experienced no competition, and profits from the hypertensiondrug alone kept Tazer in business. During the past $12$ years, Tazer continued a moderate amount of research and development, but itnever stumbled upon a drug as successful as the hypertension drug. One reason is that the company never had the motivation toinvest heavily in innovative research and development. The company was riding the profit wave generated by its hypertension drugand did not feel the need to commit significant resources to finding new drug breakthroughs. Now Tazer is beginning to fear thepressure of competition. The patent for the hypertension drug expires in $5$ years, A$1$ and Tazer knows that once the patent expires,generic drug manufacturing companies will swarm into the market ike vultures. Historical trends show that generic drugs decreasedsales of branded drugs by $75$ percent. Tazer is therefore looking to invest significant amounts of money in research and developmentthis year to begin the search for a new breakthrough drug that will offer the company the same success as the hypertension drug.Tazer believes that if the company begins extensive research and development now, the probability of finding a successful drug shortlyafter the expiration of the hypertension patent will be high. As head of research and development at Tazer, you are responsible forchoosing potential projects and assigning project directors to lead each of the projects. After researching the needs of the market,analyzing the shortcomings of current drugs, and interviewing numerous scientists concerning the promising areas of medicalresearch, you have decided that your department will pursue five separate projects, which are listed below: $[$ Project Up Develop anantidepressant that does not cause serious mood swings.; Project Stable Develop a drug that addresses manic$-$depression.; ProjectChoice Develop a less intrusive birth control method for women., Project Hope Develop a vaccine to prevent HIV infection.; ProjectRelease Develop a more effective drug to lower blood pressure. $]^1$ In general, patents protect inventions for $17$ years. In $1995,$ GATTlegislation extending the protection given by new pharmaceutical patents to $20$ years became effective. The patent for Tazer'shypertension drug was issued prior to the GATT legislation, however. Thus, the patent only protects the drug for $17$ years.For each ofthe five projects, you are only able to specify the medical ailment the research should address, since you do not know what compoundswill exist and be effective without research. You also have five senior scientists to lead the five projects. You know that scientists arevery temperamental people and will work well only if they are challenged and motivated by the project. To ensure that the seniorscientists are assigned to projects they find motivating, you have established a bidding system for the projects. You have given each ofthe five scientists $1000$ bid points. They assign bids to each project, giving a higher number of bid points to projects they most preferto lead. The following table provides the bids from the five individual senior scientists for the five individual projects: You decide toevaluate a variety of scenarios you think are likely. $($a$)$ Given the bids, you need to assign one senior scientist to each of the five projectsto maximize the preferences of the scientists. What are the assignments? $($b$)$ Dr$.$ Rollins is being courted by Haord Madieal Chlta