VIPSolutions logo ✨ VIPSolutions

can you do this using excel ( decision tree ) . Prezcott Pharma Anyone who has fed with an acute or chcnkc is pecbably very appeeciative whainer drup . " avalable ? anr or managr the disease. In the Foold and Diug Administration ( FDA ) is the premmenitl agency hat ove Drugs / ) . Developing new drugs that safely address particular medical issues without producing unpleasant oe dangerous side - effects is a very long and expensive process, often taking 1 0 - 1 5 years of work and costing an average of $ 4 billion. The long lead - time for brining drugs to market is mostly due to required clinical trials. Thus, drug manufacturers have to make very important, high - stakes decisions when they consider whether or not to place a new drug into the clinical trials process Suppose scientists at Prezcott Pharma have discovered a potential drug break - through for the treatment of Alzheimer's disease, and corporate executives now need to decide whether to go forward to conduct clinical trials and seek FDA approval to market the drug. The company has spent $ 2 9 5 million to date in research expenses The cost of clinical trials is expected to be $ 1 4 5 million, and the probability of a suc cessful outcome with only minor side effects is 0 . 1 5 whereas the probability of a suc - cessful outcome with major side effects is 0 . 2 . After the clinical trials are completed the company may seek approval from the Food and Drug Administration ( FDA ) at arn estimated cost of $ 2 5 million. If the clinical trials suggested the drug produced only minor side effects, the chance of FDA approval is 0 . 6 . Alternatively, the chance of gain - ing FDA approval if the drug has major side effects is 0 . 3 5 . The market potential for the drug has been estimated as large, medium, or small, with the following probabili - Minor Side Effects Major Side ffects Revenue Probability 5 8 % 3 % 1 0 % 3 % 5 0 % 1 5 % Large S 4 , 2 0 0 Medium 2 , 1 5 0 s 1 , 5 0 0 5 2 . 3 0 0 S 1 , 4 0 0 Small Revenue is expressed in millions of dellars If Preacott cannot secure FDA approval, it can still try to sell the drug to an interna tional company known to seek drugs that have successfully completed clinical trials but failed to get FDA approval. A business analyst at Prencott estimates that if the drug fails to secure FDA approval, there is a 5 0 % chance that the company can sell the drug for 5 3 0 0 million if the clinical trials reported minor side effects and a 3 0 % chance the com - pany could get $ 2 0 0 million for the drug if the dlinical trials reported major side effects 1 . Develop a decision tree to determine the best course of action recommended by the EMV criterion 2 . Which sequence of decisions may lead to the worst outcome 3 . What is your recommended sequence of decisions and why?

Question:

can you do this using excel ( decision tree ) . Prezcott Pharma Anyone who has fed with an acute or chcnkc is pecbably very appeeciative whainer drup . " avalable ? anr or managr the disease. In the Foold and Diug Administration ( FDA ) is the premmenitl agency hat ove Drugs / ) . Developing new drugs that safely address particular medical issues without producing unpleasant oe dangerous side - effects is a very long and expensive process, often taking 1 0 - 1 5 years of work and costing an average of $ 4 billion. The long lead - time for brining drugs to market is mostly due to required clinical trials. Thus, drug manufacturers have to make very important, high - stakes decisions when they consider whether or not to place a new drug into the clinical trials process Suppose scientists at Prezcott Pharma have discovered a potential drug break - through for the treatment of Alzheimer's disease, and corporate executives now need to decide whether to go forward to conduct clinical trials and seek FDA approval to market the drug. The company has spent $ 2 9 5 million to date in research expenses The cost of clinical trials is expected to be $ 1 4 5 million, and the probability of a suc cessful outcome with only minor side effects is 0 . 1 5 whereas the probability of a suc - cessful outcome with major side effects is 0 . 2 . After the clinical trials are completed the company may seek approval from the Food and Drug Administration ( FDA ) at arn estimated cost of $ 2 5 million. If the clinical trials suggested the drug produced only minor side effects, the chance of FDA approval is 0 . 6 . Alternatively, the chance of gain - ing FDA approval if the drug has major side effects is 0 . 3 5 . The market potential for the drug has been estimated as large, medium, or small, with the following probabili - Minor Side Effects Major Side ffects Revenue Probability 5 8 % 3 % 1 0 % 3 % 5 0 % 1 5 % Large S 4 , 2 0 0 Medium 2 , 1 5 0 s 1 , 5 0 0 5 2 . 3 0 0 S 1 , 4 0 0 Small Revenue is expressed in millions of dellars If Preacott cannot secure FDA approval, it can still try to sell the drug to an interna tional company known to seek drugs that have successfully completed clinical trials but failed to get FDA approval. A business analyst at Prencott estimates that if the drug fails to secure FDA approval, there is a 5 0 % chance that the company can sell the drug for 5 3 0 0 million if the clinical trials reported minor side effects and a 3 0 % chance the com - pany could get $ 2 0 0 million for the drug if the dlinical trials reported major side effects 1 . Develop a decision tree to determine the best course of action recommended by the EMV criterion 2 . Which sequence of decisions may lead to the worst outcome 3 . What is your recommended sequence of decisions and why?

This is AI generated Response.
Asked by: Test User 100150
Created at: 2025-05-14 08:23:20

Final Answer:

Rendered Raw Text
Did you like this answer?
Certainly! Let's break down how to **develop this decision tree and calculate the EMVs (Expected Monetary Values) in Excel** for the Prezcott Pharma scenario. --- ## **Step 1: Structure the Decision Tree** **Key Decisions & Outcomes:** - **Stage 1:** Decide to proceed with Clinical Trials (cost: $145M). - **Stage 2:** Clinical Trials outcome: - Minor Side Effects (prob = 0.15) - Major Side Effects (prob = 0.20) - Failure (prob = 1 - 0.15 - 0.20 = 0.65) → End, no further action, sunk cost. - **Stage 3:** Seek FDA Approval (cost: $25M) - If Minor Side Effects: Approval (prob = 0.6), Rejection (prob = 0.4) - If Major Side Effects: Approval (prob = 0.35), Rejection (prob = 0.65) - **Stage 4:** If FDA Approval: - Market Size (probabilities and payoffs depend on side effects) - **If FDA Rejection:** Possible sell to international company: - Minor Side Effects: 50% chance to sell for $300M, else $0 - Major Side Effects: 30% chance to sell for $200M, else $0 **Initial Research Cost:** $295M (already spent, so not included in incremental EMV comparisons) --- ## **Step 2: Organize the Probabilities and Revenues** ### **A. Market Probabilities and Revenues** | Side Effects | Market Size | Probability | Revenue (M) | | -------------- | ----------- | ----------- | ----------- | | Minor | Large | 0.58 | 4200 | | | Medium | 0.32 | 2150 | | | Small | 0.10 | 1500 | | Major | Large | 0.03 | 2300 | | | Medium | 0.50 | 1400 | | | Small | 0.47 | 400 | --- ### **B. International Sale (if FDA fails)** - **Minor:** 50% chance of $300M, else $0 - **Major:** 30% chance of $200M, else $0 --- ## **Step 3: Lay Out Calculations in Excel** ### **1. Calculate the EMV for Each Outcome** #### **A. If Clinical Trials Show Minor Side Effects** **i. FDA Approval (prob = 0.6)** - Revenue = (0.58 \* 4200) + (0.32 \* 2150) + (0.10 \* 1500) - Revenue = (2436 + 688 + 150) = **$3274M** - Net profit = $3274M - $145M (trials) - $25M (FDA) = **$3104M** **ii. FDA Rejection (prob = 0.4)** - EMV = 0.5 \* $300M + 0.5 \* $0 = $150M - Net profit = $150M - $145M (trials) = **$5M** **Total EMV for Minor Side Effects:** = 0.6 \* $3104M + 0.4 \* $5M = $1862.4M + $2M = **$1864.4M** But this is **before** multiplying by the probability of Minor Side Effects (0.15). #### **B. If Clinical Trials Show Major Side Effects** **i. FDA Approval (prob = 0.35)** - Revenue = (0.03 \* 2300) + (0.50 \* 1400) + (0.47 \* 400) - Revenue = (69 + 700 + 188) = **$957M** - Net profit = $957M - $145M - $25M = **$787M** **ii. FDA Rejection (prob = 0.65)** - EMV = 0.3 \* $200M + 0.7 \* $0 = $60M - Net profit = $60M - $145M = **-$85M** (a loss) **Total EMV for Major Side Effects:** = 0.35 \* $787M + 0.65 \* -$85M = $275.45M - $55.25M = **$220.2M** Multiply by probability of Major Side Effects (0.20). #### **C. Failure in Clinical Trials (prob = 0.65)** - All money spent is lost: Loss = -$145M --- ### **2. Calculate Overall EMV** EMV (Proceed) = = (0.15 \* $1864.4M) + (0.20 \* $220.2M) + (0.65 \* -$145M) = $279.66M + $44.04M - $94.25M = **$229.45M** --- ## **Step 4: Excel Layout** ### **Suggested Excel Table** | Step | Probability | Payoff (Net, M) | Product (M) | |--------------|-------------|-----------------|-------------| | Minor | 0.15 | =1864.4 | =0.15\*1864.4| | Major | 0.20 | =220.2 | =0.20\*220.2 | | Failure | 0.65 | =-145 | =0.65\*-145 | | **Total EMV**| | | =SUM(...above...)| **You can break out the Minor/Major net payoffs into their FDA approval/rejection branches as above.** --- ## **Step 5: Answers to Questions** ### **1. Develop a decision tree and determine the best course of action by EMV** - **Best action:** Proceed with clinical trials and FDA approval. - **EMV:** $229.45M net profit (not including sunk $295M research cost). ### **2. Sequence of decisions leading to the worst outcome** - **Worst case:** Clinical trials fail (probability 0.65) → lose $145M. - **Second-worst:** Major side effects found, FDA rejection, no international sale → lose $145M. ### **3. Recommended sequence and why** - **Proceed with clinical trials and seek FDA approval.** **Reason:** The Expected Monetary Value is positive ($229M), significantly outweighing the possible losses, and the upside is large. The EMV criterion identifies this as the best financial decision. --- ## **How to do this in Excel (Step-by-step)** 1. **Set up probability and payoff tables as shown above.** 2. **Multiply each outcome's probability by its net payoff.** 3. **Sum the products for total EMV.** 4. **(Optional) Use a tree diagram or indented rows to visualize the branches.** --- **If you want, I can provide a ready-to-copy Excel table for this scenario. Let me know if you'd like that!**

📢 Instructions:

  • Ask anything relatd to above question only.
  • For new Question goto :

Study Help, Fast Answers

VIPSolutions focuses on clear, step‑by‑step explanations so you can learn quickly. Whether you need an AI‑generated walkthrough or a short hint to get unstuck, each solution is organized for fast reading and easy review later.

Search similar questions, compare approaches, and bookmark the best answers for revision. Our goal is simple: quick, reliable study help that feels natural—not noisy.