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

  The free rider problem

Question: Explain why the free rider problem makes it difficult for perfectly competitive markets to provide the Pareto efficient level of a public good.

  Failure of the super committee is good thing for economy

Some commentators have argued that the failure of the “Super committee” is good thing for the economy?  Do you agree?

  Case study analysis about optimum resource allocation

Case study analysis about optimum resource allocation: -  Why might you suspect (even without evidence) that the economy might not be able to produce all the schools and clinics the Ministers want? What constraints are there on an economy's productio..

  Fixed cost and vairiable cost

Questions:  :   Which of the following are likely to be fixed costs and which variable costs for a chocolate factory over the course of a month?  Explain your choice.

  Problem - total cost, average cost, marginal cost

Problem - Total Cost, Average Cost, Marginal Cost: -  Complete the following table of costs for a firm.  (Note: enter the figures in the  MC   column  between  outputs of  0 and 1, 1 and 2, 2 and 3, etc.)

  Oligopoly and demand curve problem

Problem based on Oligopoly and demand curve,  Draw and explain the demand curve facing each firm, and given this demand curve, does this mean that firms in the jeans industry do or do not compete against one another?

  Impact of external costs on resource allocation

Explain the impact of external costs and external benefits on resource allocation;  Why are public goods not produced in sufficient quantities by private markets?  Which of the following are examples of public goods (or services)? Delete the incorrec..

  Shifts in demand and movements along the demand curve

Describe the differences between shifts in demand and movements along the demand curve. What are the main factors which can shift the demand curve? Explain why they cause the demand curve to shift. Use examples and draw graphs to support your discuss..

  Article review question

Article Review Question: Read the following excerpts from the article "Fruit, veg costs surge' by Todd, Dagwell, published in the Herald on January 25th 2011 and answer questions below:

  Long-term growth, international trade & globalization

Long-term Growth, International Trade & Globalization:- This question deals with concepts such as long-term growth, international trade and globalization. Questions related to trade deficit, trade surplus, gains from trade, an international trade sce..

  European monetary union (emu) in crisis

"Does the economic bailout of Spain and Greece spell the beginning of the end for the European Monetary Union (EMU)?"

  Development game “settlers of catan”

Read the rules of the game, the overview and the almanac for the Development Game "Settlers of Catan"

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