A 1 A drug company is trying to determine the correct plant capacity for a new drug. 2 Develop a model that computes the company's 10 year profit and variable costs given the chosen annual capacity level and the annual demand for the drug. 3 Assume demand is the same for every year. 4 When you change the annual capacity level or the annual demand, the profit should update as well. Note that you can not produce beyond the capacity you choose in cell B9. 5 max 10 points A 1 A drug company is trying to determine the correct plant capacity for a new drug. 2 Develop a model that computes the company's 10 year profit and variable costs given the chosen annual capacity level and the annual demand for the drug. 3 Assume demand is the same for every year. 4 When you change the annual capacity level or the annual demand, the profit should update as well. Note that you can not produce beyond the capacity you choose in cell B9. 5 max 10 points