3. Using Excel and prices in the range of $1 to $10, generate the demand and supply schedules for the initial equations.

4. Use Excel to plot a graph of your demand and supply curves that include the equilibrium point.

5. What are the new equilibrium price and quantity if supply remains constant and demand increases so that the new demand equation is: Q = 150 - 5P?

6. What are the new equilibrium price and quantity if demand remains contant and supply decreases so that the new supply equation is Q = 2P?

Solution Preview

Please refer attached file for graph.

1. What is the equilibrium price?

For determining equilibrium price, put Q (demand)=Q(supply)
100-5P=20P
100=25P
P=4
Equilibrium price is $4.

2. What is the equilibrium quantity?
Quantity demanded at equilibrium price (i.e. P=$4)=100-5*4=80
Quantity supplied at equilibrium price (i.e. P=$4)=20*4=80
Equilibrium quantity is 80 units.

3.Using Excel and prices in the range of $1 to $10, ...

Solution Summary

Solution describes the steps to calculate equilibrium price and quantity in the given cases.

Calculating Equilibrium Prices and Quantity. ... a)Calculate the equilibrium price of guitars and the equilibrium quantity of guitars in State College. ...

...Calculate the equilibrium price and quantity... So, equilibrium price=10 equilibrium quantity=20. ... describes the steps for calculating equilibrium price and quantity...

... Solution describes the steps to calculate the output of the firm at various price... It also determines the equilibrium price and output of the market. ...

... Solution describes the steps to calculate consumer and producer surplus in the ... It also calculates consumer and producer surplus in case of price ceiling ...

... 2)Calculate the equilibrium price and quantity in the gasoline market. ... 2. Calculate the equilibrium price and quantity in the gasoline market. ...

... suplliers=Initial equilibrium price-New price=800-764=$36 ie 40.00% of tax As calculated in above ... 1 What is the equilibrium price and quantity of guitars ...

... The solution to the second problem calculates equilibrium price and quantity from the ... the third problem depicts the steps to calculate price elasticity of ...