A major drug company is trying to determine the correct plant capacity for a new drug. A unitof annual capacity can be built for a cost of $10. Each unit of the drug sells for $12 and incurs variable costs of $2. The drug will be sold for 10 years. Develop a worksheet that computes the companys 10-year profit given the chosen annual capacity level and the annual demand for the drug. Assume demand for the drug is the same each year. You can ignore the time value of money in this problem.

Martin Luther King Day occurs on the third Monday in January. Write a formula that computes(given the year) the date of Martin Luther King Day. Hint: First determine the day of the week for January 1 of the given year.

USE EXCEL AND IF STATEMENTS

Suppose the price of a product will change at dates in the future, as follows: Date On or before February 15, 2004 From February 16, 2004, through April 10, 2005 From April 11, 2005, through January 15, 2006 After January 15, 2006 Price $8 $9 $10 $11 Write a formula that computes the price of the product based on the date the product is sold. Suppose the price of a product will change at dates in the future, as follows: Date On or before February 15, 2004 From February 16, 2004, through April 10, 2005 From April 11, 2005, through January 15, 2006 After January 15, 2006 Price $8 $9 $10 $11 Write a formula that computes the price of the product based on the date the product is sold