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 $

$2$

$5$

$0$

$$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 $

$2$

$0$

$0$

$$and $

$4$

$0$

$0$

$$is under consideration.

$($

Please use linear demand function

$)$