In: Economics
Nadine Chelesvig has patented her invention. She is offering a
patent manufacturer two contracts for the exclusive right to
manufacture and market her product. Plan A calls for an immediate
single lump payment to her of $27,000. Plan B calls for an annual
payment of $900 plus a royalty of $0.48 per unit sold. The
remaining life of the patent is 10 years. Nadine uses a MARR of 11
%/year.
a. What must be the uniform annual sales volume of the product for Nadine to be indifferent between the contracts, based on a present worth analysis?
The image below contains the formula behind the cells:
This will finally look like this :
Now the final step is to run the goal seek function, set pw of plan b to 27000(pw of A) by changing cell of units sold
now click OK and cell B12 is your answer (the number of units to be sold)
Please do not forget to like the solution if you found it helpful. For further query/doubts related to this solution, please drop a comment in the section below. I will get back you ASAP.