Each problem in a separate worksheet

Assignment Help Microeconomics
Reference no: EM13978382

Submit solutions to the following two problems.  Submit in an Excel workbook with each problem in a separate worksheet (tab).  Show your calculations in Excel.  That is, use Excel to make the calculations.

Problem 1

Please be sure to use excel for calculations and to solve the problem. I know how to do the first part and I have the answer to the first part, but I am not sure how to do the graph in excel and how to calculate A & B. 


In a competitive market, the industry demand and supply curves are:

P = 200 - .3Qd   (Demand)

P = 100 + .4Qs    (Supply)

a. Find the market's equilibrium price and output.

b. Suppose the government imposes a tax of $15 per unit of output on all firms in the industry. What effect does this have on the industry supply curve? Find the new competitive price and output. What portion of the tax has been passed on to consumers via a higher price?

c. Suppose a $15-per-unit sales tax is imposed on consumers. What effect does this have on the industry demand curve? Find the new competitive price and output. Compare this answer to your findings in part (b). 

Reference no: EM13978382

Questions Cloud

What is the new capacitance of the capacitor : Consider two parallel-plate capacitors identical in shape, one aligned so that the plates are horizontal (Figure 1) , and the other with the plates vertical (Figure 2) . The horizontal capacitor is filled halfway with a material that has dielectri..
Explain how does the fact that a number of counties : Explain how does the fact that a number of counties and cities also have their own income taxes affect the top marginal tax rate for some higher earners.
The producer of a snack food claims that each package : Find and interpret the p value for testing that the mean weight of the snack food is less than 175 grams.
Increasing capital gains tax rates : What could happen if the government seeks to collect higher taxes by increasing capital gains tax rates?
Each problem in a separate worksheet : Submit solutions to the following two problems.  Submit in an Excel workbook with each problem in a separate worksheet (tab).  Show your calculations in Excel.  That is, use Excel to make the calculations.
What conclusion can be made at the significance level : What conclusion can be made at the 10% significance level? How about at the 5% significance level?
Reforming the financial system : Topic: Reforming the financial system.   Pick a sub-topic within this general topic area.  It must be a minimum of 7 pages long (basic text), double-spaced, and typed.  Title pages, bibliography, etc., are extra.
Develop a data dictionary defining each of the data element : Research the recommended core elements of a single-entity MPI and a multi-facility enterprise MPI through professional journals and list reference used (e.g., Journal of AHIMA)
Assignment details assignment description : Suppose that there are two products: clothing and soda. Both Brazil and the United States produce each product. Brazil can produce 100,000 units of clothing per year and 50,000 cans of soda. The United States can produce 65,000 units of clothing per ..

Reviews

Write a Review

Microeconomics Questions & Answers

  Monetary policy contribute to the economic crisis of 2008

Did monetary policy contribute to the economic crisis of 2008?

  Which project for a percent change in weekly burrito revenue

The Burrito Barn is considering a price reduction on the Firegut Burrito. Giuseppe, the proprietor of Burrito Barn, has recorded sales data at different price levels over the last year. He is quite confident that no other demand factors, such as c..

  What is the cost-benefit analysis

A special interest group cannot impose its will on the majority because the perceived costs and benefits from government programs are the same for both groups. Cost-benefit analysis can be applied to individual decision-making and public choice th..

  World bank and international monetary fund

Discuss how these terms individually apply to both supply and demand and to a business owner who is contemplating expanding internationally.

  The profit from each of the four possible combinations of

A firm is focal point for a set of contracts. Explain the problems that (1) agency relationships, (2) asymmetric information, and (3) adverse selection can introduce to building a successful contract between two people.

  Determine the optimal volume for the product

A company produces an electronic timing switch that is used in consumer and commercial products. The fixed cost (CF) is $73,000 per month, and the variable cost (CV) is $94 per unit.

  What effect is the diet likely to have on housing prices

What effect is the diet likely to have on housing prices in Ulster County

  Question related to monopolistic competition

Do you think the overall level of R&D would rise or reduce over the next twenty to thirty years if the lengths of new patents were extended from twenty years to, say "forever"?

  Assume the us government institutes buy american campaign

suppose that u.s. citizens start saving more. what does this imply about the supply of loanable funds and the

  How you would determine marginal utility at any given point

Suppose Debbie purchases only hamburgers. Assume that her marginal utility is always positive and diminishing. Draw a graph with total utility on the vertical axis and the number of hamburgers on the horizontal axis. Explain how you would determin..

  Does contain a clear upward trend over entire sample period

Using the data through 1979, estimate a cubic time trend model for gfr (that is, regress gfr on t, t2, and t3, along with an intercept). Comment on the R-squared of the regression.

  What role does expected price level play in the adjustment

Use the sticky wage theory of aggregate supply to explain what will happen to output and the price level in the long run. What role does expected price level play in the adjustment?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd