question archive The same drug company is producing a new drug
The same drug company is producing a new drug
Subject:BusinessPrice: Bought3
The same drug company is producing a new drug. The company has made the following assumptions:
a. During Year 1 - 100,000 units will be sold.
b. Sales will grow for three years and then decline for seven years.
c. During the growth period, sales will grow at a rate of 15 percent per year. During the decline, sales will drop at a rate of 10 percent per year.
Develop a worksheet that takes values for Year 1 sales, the length of the growth cycle, the length of the decline cycle, the growth rate during the growth cycle, and the rate of decrease during the decline cycle, and then computes unit sales for Years 1-11.
