Assignment:
Given the following demand and supply equations:
Demand: Q=100 - 5P
Supply: Q=20P
Q1. What is the equilibrium price?
Q2. What is the equilibrium quantity?
Q3. Using Excel and prices in the range of $1 to $10, generate the demand and supply schedules for the initial equations.
Q4. Use Excel to plot a graph of your demand and supply curves that include the equilibrium point.
Q5. 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?
Q6. What are the new equilibrium price and quantity if demand remains contant and supply decreases so that the new supply equation is Q = 2P?
Provide complete and step by step solution for the question and show calculations and use formulas.