Please look at the second picture too!

Please help

Assume the demand for a company's drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can pro- duce x units of Wozac per year, it will cost $16r. unit of Wozac is sold for $3. Each unit of Wozac pro duced incurs a variable production cost of $0.20. It costs $0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years. 33. a. Each Assignment: Pharmaceutical Company- Wozac Modified version of question 33, page 86. Management has asked you to determine how large of a manufacturing plant to build. Ignore tax. Create a spreadsheet to model the annual profit for the pharmaceutical company assuming they build a plant to supply 60,000 units per year Calculate the demand for Wozac in years 1-10. Calculate how many units of Wozac are actually sold. Prepare an income statement for years 1-10. Find the total net income for the life of the plant (sum of years 1-10). o o o .Color-code the spreadsheet correctly to indicate inputs, decision variables, and outputs. Check your model: with a plant capacity of 60,000 units per year, the total net income for years 1-10 is $411,418. Create a one-way data table to show the total profit for a manufacturing plant with 50,000 to 60,000 annual capacity in 1,000 units/year increments. From this table, what size production plant maximizes profit? Use goal-seek to find the sales price per unit the company would need to charge per unit to make $1 million total net income in years 1-10 with a plant capable of producing 60,000 units per year. Record your answer to the penny (Sx.xx), then set the price back to $3 since this messes up the data table