Genesis Pharmaceutical has developed a new diabetes medication. It estimates that the sales volume during the first year will be 200,000 units. The sales volume is projected to grow by 20% each year. The price of each unit is $50 during the first year and will increase by 5% each year. The fixed manufacturing costs for the medication are $500,000 for every 100,000 units, and the variable costs are $25 per unit. The variable costs will increase by 10% each year due to increased material and labor costs. 

a. Develop a spreadsheet model to estimate the total profit Genesis Pharmaceutical makes on this medication over the next five years. Note: Round your answer to 2 decimal places.

Answer rating: 100% (QA)

To estimate the total profit that Genesis Pharmaceutical makes on the diabetes medication over the n... View the full answer