Create a spreadsheet illustrating the determination of a competitive firm's profit maximization decision.

1. Below are the equations necessary for the competitive firm's profit maximization decision.

 p = TR - TC Profit Equation TR = P * Q Total Revenue Equation TC = F + cQ + dQ2 Total Cost Equation ATC = F/Q + c + dQ Average Total Cost Equation AVC = c + dQ Average Variable Cost Equation MC = c + 2dQ Marginal Cost Equation P = MR Market Price = Marginal Revenue

Begin by choosing your own values for the following parameters:

F = Fixed Cost
c = cost parameter, c > 1
d = cost parameter, d > 1
P = market price.

2. Create a table showing Quantity, TR, TC, p, ATC, AVC, MC, and P. Use this table to create two X-Y charts. In creating your table, please make sure that you "anchor" the parameter values to the ones chosen in Step 1. (By doing this, your graphs and calculations will adjust automatically whenever you change any of the parameter values).

• In Chart 1 you will plot profit (on the vertical axis) versus quantity (on the horizontal axis).
• In Chart 2 you will plot price, ATC, AVC, and MC (all on the vertical axis) versus quantity (on the horizontal axis).

3. Create an area on your spreadsheet that illustrates the calculation of the profit-maximizing quantity and each of the equations from Step 1 above. Your equations for these values should refer to the "anchored" parameter values chosen in Step 1.