In a perfectly competitive market, the inverse demand function is p = 50 Q. Market supply, Q

In a perfectly competitive market, the inverse demand function isp = 50 ˆ’ Q.Market supply,Q^s,is perfectly elastic at a price of 40, because each firm has a constant marginal costMC = 40. 

a. Create a spreadsheet with column headings Q, p, MC, and CS (consumer surplus). Fill in the spreadsheet for Q=1, 2, 3,€¦25.Q = 1, 2, 3,€¦25. Calculate the competitive market€™s equilibrium output and price.

b. One firm invests 200 in a successful R&D project that allows it to lower its marginal cost of production from 40 to 10. The firm gets a patent for its new process. Create a new spreadsheet showing the situation under this patent monopoly, with no competitive firms. The column headings are Q, p, MR, MC, CS, and Profit (including the investment of 200). Calculate the patent monopoly€™s profit-maximizing output, price, and profit. Did the R&D investment pay?