Consider the market for corn in the United States. We are going to use Excel to examine changes in consumer and producer surplus in a competitive market when the market is not in equilibrium. Suppose the demand and supply functions for corn are as follows. Where Q is bushels of corn (in billions) and P is the market price per bushel. Using the template provided, enter the coefficients for demand and supply. When the market isn't in equilibrium, only the minimum of QD and QS values will actually be sold. Once you have this set up, answer the following questions. b) What happens to consumer, producer, and total surplus as you increase the price from $3 to the equilibrium? Start price =$3.00 c) Now increase the price from the equilibrium by $.25 two times. What happens to the market quantity, consumer, producer, and total surplus as you increase the price to a level higher than the equilibrium? prise increment =$sin2 C The d) Explain the effect of changing the price away from the equilibrium on the market efficiency. The further away from the equilibrium, the total surplus in the market meaning the dead-weight loss. Consider the market for corn in the United States. We are going to use Excel to examine changes in consumer and producer surplus in a competitive market when the market is not in equilibrium. Suppose the demand and supply functions for corn are as follows. Where Q is bushels of corn (in billions) and P is the market price per bushel. Using the template provided, enter the coefficients for demand and supply. When the market isn't in equilibrium, only the minimum of QD and QS values will actually be sold. Once you have this set up, answer the following questions. b) What happens to consumer, producer, and total surplus as you increase the price from $3 to the equilibrium? Start price =$3.00 c) Now increase the price from the equilibrium by $.25 two times. What happens to the market quantity, consumer, producer, and total surplus as you increase the price to a level higher than the equilibrium? prise increment =$sin2 C The d) Explain the effect of changing the price away from the equilibrium on the market efficiency. The further away from the equilibrium, the total surplus in the market meaning the dead-weight loss