Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DO THIS IN EXCEL and use only the formulas he said to use and show them please. A drug company is planning to invest in

DO THIS IN EXCEL and use only the formulas he said to use and show them please.
A drug company is planning to invest in a new drug. The cost of research has a uniform distribution on $300,000 to $500,000. There is a 40% chance that the drug will not be effective, in which case th H D F G I J K L M Total Profit 17 20 16 A drug company is planning to invest in a new drug. The cost of research has a 18 uniform distribution on $300,000 to $500,000. There is a 40% chance that the 19 drug will not be effective, in which case there will be no sales. If the drug is 21 effective, then the total market for the drug is 400,000 people. The company expects their share of the market to have a triangular distribution with minimum 24 5%, maximum 30%, and most likely 20% of the people. For each person who uses the new drug, the company expects to make $100 in sales during the first 27 year. The drug company would like to know the distribution of profit they can expect from undertaking this investment. 23 Cost of Drug Development Function Library Question 2 Question 1 Accessibility: Investigate Question 3 Effectiveness Market Share Revenue per person Number of People Total Revenue Revenue Question 4 Question 5 Calculate Sheet E Calculation Use binomial inverse function to simulate if the drug will be effective or not. Use traingular Inverse function to simulate the market share. Use uniform function to simulate the cost of research. E B p
image text in transcribed
A drug company is planning to invest in a new drug. The cost of research has a uniform distribution on $300,000 to $500,000. There is a 40% chance that the drug will not be effective, in which case there will be no sales. If the drug is effective, then the fotal market for the drug is 400,000 people. The company expects their share of the market to have a triangular distribution with minimum 5%, maximum 30%, and most likely 20% of the people. For each person who uses the new drug, the company expects to make $100 in sales during the first year. The drug company would like to know the distribution of profit they can expect from undertaking this imvestment: A drug company is planning to invest in a new drug. The cost of research has a uniform distribution on $300,000 to $500,000. There is a 40% chance that the drug will not be effective, in which case there will be no sales. If the drug is effective, then the fotal market for the drug is 400,000 people. The company expects their share of the market to have a triangular distribution with minimum 5%, maximum 30%, and most likely 20% of the people. For each person who uses the new drug, the company expects to make $100 in sales during the first year. The drug company would like to know the distribution of profit they can expect from undertaking this imvestment

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Theory And Analysis Text Reading And Cases

Authors: Richard G. Schroeder, Jack M. Cathey, Myrtle W. Clark

7th Edition

0471379549, 9780471379546

More Books

Students also viewed these Accounting questions

Question

Discuss various types of training methods.

Answered: 1 week ago

Question

Illustrate the value of different types of employment tests.

Answered: 1 week ago

Question

Outline key considerations when making a hiring decision.

Answered: 1 week ago