Assignment $3$: Demand Estimation and Price Optimization

Please finish the following assignments in Excel and submit the Excel file onto Pilot. Please indicate your result in Excel clearly.

Suppose it costs $$250$ to produce a video game console. Estimated demand for the game console is shown in the following table. What price should you charge for game console to maximize profit? A price between $$200$ and $$400$ is under consideration. $($Please use linear demand function$)$

Price Demand

$$20050,000$

$$30025,000$

$$40012,000$