Use the template to create a spreadsheet describing Amazon$$s output and pricing choices with respect to the Kindle e$-$reader. $($Use the template from Problem S$1$ with price equation: P $=29435$Q and MC $=$ $$126.)$ Use your solver in excel to find the combination of output and price that maximizes profit.

Next, include the extra net revenue from e$-$book sales, $$100$ per Kindle. $($Compute this total in cell G$7$ according to the formula: $=100*$B$7.)$ Finally, in cell H$7,$ compute total profit $($from both Kindles and e$-$book sales$).$ What combination of Kindle output and price maximizes Amazon$$s total profit? Explain why Amazon should cut its price relative to the price in part a$.\backslash$table$[[1,,,,,],[2,,,,,],[3,,,,,],[4,,,,,],[5,,,,,],[6,$Quantity,Price,Revenue,Cost,Profit$],[7,,,,,],[8,,x,$x$,$x$,$x$],[9,,,,,],[10,,,,,],[11,,,$MR$,$MC$,$MP$],[12,,,,,],[13,,,$x$,$x$,$x$],[14,,,,,]]$