The industry demand curve in a perfectly competitive market is given by the equation P = 160 - 2Q, and the supply curve is given by the equation P = 40 + Q. The upward-sloping supply curve represents the increasing marginal cost of expanding industry output. The total industry cost of producing Q units of output is C = 800 + 40Q + .5Q2 (Note that taking the derivative of this equation produces the preceding industry MC equation.) In turn, the total benefit associated with consuming Q units of output is given by the equation B = 160Q - Q2 (Total benefit represents the trapezoidal area under the demand curve. It is also the sum of consumer surplus and revenue. Note that taking the derivative of the benefit equation produces the original industry demand curve MB = 160 - 2Q.)

a. Create a spreadsheet similar to the given example. Only the quantity cell (C5) contains a numerical value. All other cells are linked by formulas to the quantity cell.

b. Find the intersection of competitive supply and demand by equating the demand and supply equations or by varying quantity in the spreadsheet until MB equals MC.

c. Alternatively, find the optimal level of industry output by maximizing net benefits (cell F9) or, equivalently, the sum of consumer and producer gains (cell F10). Confirm that the perfectly competitive equilibrium of part (b) is efficient.