DO THIS PROBLEM IN EXCEL

PortaCom is a company that manufactures notebook computers and related equipment. PortaComs product design group developed a prototype for a new high-quality portable printer. PortaCom has been doing research about the price sensitivity of their consumers and has concluded that the demand for their new printer is likely to start at 400,000 units. Each increase in the price by $1 decreases their expected demand by 1000 units. Their initial price is set to be $50, but they want to know what the best price is that optimizes their revenue based on these parameters.

USING THE SOLVER TOOL IN EXCEL, create a model that takes in these parameters and yields an optimal price for the revenue based on this information.