GIVE ME ALL ANSWER IN FULL EXPLANATION

Q (1); The domestic demand and supply function for oil for a small country are given by: Qd = 210 1.5P and Qs = - 140 + 2P, where P is the price per barrel and Qd Qs are the quantities in million barrels.

(a) Use Excel to calculate quantity demanded and quantity supplied for P = $70, 75,80....140 (in $5 increments). Determine the equilibrium price and quantity in absence of any oil import.

(b) Assume that OPEC can sell unlimited quantity of oil at $80 per barrel. Using your calculations in (a), determine the equilibrium price, amount of domestic consumption, quantity supplied by domestic producers and the amount of oil import. (Assume that at a given price, the amount of import is the gap between domestic demand and domestic production.) Explain.

(c) Now, suppose the countrys government imposes a limit on the amount of oil that can be imported from OPEC at their price of $80. Given that the limit is set at 35 million barrels, use Excel and the spreadsheet created in part (a) above to calculate the aggregate supply of oil that includes the domestic supply and the import from OPEC. Calculate the domestic price for oil, domestic consumption, and domestic production. Explain.

(d) Algebraically determine the results that you calculated in (a), (b) and (c) above using Excel. Explain.