Create a spreadsheet similar to the given example

Assignment Help Microeconomics
Reference no: EM13880848

The industry demand curve in a perfectly competitive market is given by the equation P = 160 - 2Q, and the supply curve is given by the equation P = 40 + Q. The upward-sloping supply curve represents the increasing marginal cost of expanding industry output. The total industry cost of producing Q units of output is C = 800 + 40Q + .5Q2 (Note that taking the derivative of this equation produces the preceding industry MC equation.) In turn, the total benefit associated with consuming Q units of output is given by the equation B = 160Q - Q2 (Total benefit represents the trapezoidal area under the demand curve. It is also the sum of consumer surplus and revenue. Note that taking the derivative of the benefit equation produces the original industry demand curve MB = 160 - 2Q.)

a. Create a spreadsheet similar to the given example. Only the quantity cell (C5) contains a numerical value. All other cells are linked by formulas to the quantity cell.

b. Find the intersection of competitive supply and demand by equating the demand and supply equations or by varying quantity in the spreadsheet until MB equals MC.

c. Alternatively, find the optimal level of industry output by maximizing net benefits (cell F9) or, equivalently, the sum of consumer and producer gains (cell F10). Confirm that the perfectly competitive equilibrium of part (b) is efficient.

 

A

B

C

D

E

F

G

1

 

 

 

 

 

 

 

2

 

 

EFFICIENCY OF

 

 

3

 

 

PERFECT COMPETITION

 

 

4

 

 

 

 

 

 

 

5

 

Quantity

32

 

Price

96

 

6

 

 

 

 

 

 

 

7

 

Benefit

4,096

 

Con Surplus

1,024

 

8

 

P = MB

96

 

 

 

 

9

 

 

 

 

B - C

1,504

 

10

 

Revenue

3,072

 

CS + Profit

1,504

 

11

 

MR

32

 

 

 

 

12

 

 

 

 

Profit

480

 

13

 

Cost

2,592

 

 

 

 

14

 

MC

72

 

 

 

 

15

 

 

 

 

 

 

 

Reference no: EM13880848

Questions Cloud

Create an implementation plan to integrate business analytic : Create an implementation plan to integrate business analytics
The mchs conducted a walk your pet day fundraising drive : The MCHS conducted a Walk Your Pet Day fundraising drive
Proposal that provides catacomb with converged network : Using this case study, you are to identify a minimum of five (5) requirements, analyze them, and offer a proposal that provides Catacomb with a converged network solution and explains how the components of the solution, and the solution as a whole..
Write a program to that finds lowest n closing dow jones : You are to write a program to that finds lowest N closing Dow Jones Industrial averages and their dates in order by closing average. The program should prompt for the number of lowest closing averages requested by the user to be output.
Create a spreadsheet similar to the given example : Create a spreadsheet similar to the given example. Only the quantity cell (C5) contains a numerical value. All other cells are linked by formulas to the quantity cell.
Information concerning its postretirement benefit for 2012 : information available concerning its postretirement benefit plan for 2012.
Determine the critical path and identify the activities : Develop an estimated duration for each activity and determine the critical path and identify the activities that make up the critical path.
What equilibrium price will prevail in the short run : In a perfectly competitive market, the cost structure of the typical firm is given by C = 25 + Q2- 4Q, and industry demand is given by Q = 400 - 20P. Currently, 24 firms serve the market - Create a spreadsheet
Find and fix the bug that is creating the exception error : Find and fix the bug that is creating the exception error message in the program in our AVL tree implementation. Make sure to explain the bug and how to fix it.

Reviews

Write a Review

Microeconomics Questions & Answers

  Describe exactly how change in federal funds rate can

according to the federal reserves federal open market committee 2011 the federal reserve controls the three tools of

  The richest quin tile now shares

Question #2. Suppose that the voters in the U.S. have decided through a ballot measure to tax the richest quintile by 10 percent. The tax will then be redistributed evenly to the poorest two quintiles.  (2A) What is the share of income that the riche..

  You make a decision to educate yourself about organic

after hearing of you taking this course in business economics uncle dan has e-mailed you asking for advice on his

  Question on cross-price elasticity

The demand for personal computers can be characterized by following point elasticity = -5, cross-price elasticity with software = -4, and income elasticity = 2.5. Indicate whether each of following statements is true or false, and describe your an..

  Netflix has revolutionized the movie rental business

Netflix has revolutionized the movie rental business by charging $7.99 a month for unlimited streaming movie service. On the other hand rental movie kiosks like Redbox are popping up by the thousands in supermarkets, drugstores, restaurants and..

  John barks owns barks computer screens inc and wants to

john barks owns barks computer screens inc. and wants to identify the supply and demand for screens in his market. the

  Calculate the price of elasticity of demand

When te price of milk increases from $2.35 to $2.50 per gallon, the quanitity demanded falls from 100 gallons to 90 gallons. When the price of paperback books fall from $7.00 to $6.50, the quantity demanded rises from 100 to 150.When the rent on apar..

  What is equilibrium price and quantity of apartment rental

Suppose the demand for apartment rentals in Los Angeles is Q = 1000 - P and the supply of apartment rentals is Q = 4P. What is the equilibrium price and quantity of apartment rentals in LA? Suppose the government imposes a price ceiling of $150. What..

  How to establish the vicinity of all major college

A group of five students has decided to form a company to publish a guide to eating establishments located in the vicinity of all major college and university campuses in Texas. In planning for an initial publication of 6,000 copies, they estimate..

  What is the value of the adjustment factor

In trip calculation, it is observed that a Wal-Mart store driver successfully made a total of 104 trips in a given period of time. During field calculation, it is shown that the calculated number of trips is actually 128. What is the value of t..

  Determine the low wages that occur in the competitive market

Hospital administrators sometimes complain about a "shortage" of nurses. The shortage is the result of a higher wages that occur in the competitive market and could be eliminated if nurses earn wages closer to their MRC.

  Factoring ceteris paribus what economic advice would give

A customer quit her job and now runs her own business. Her business an accounting profit of $33,700 and an opportunity cost of $36,700. There is an economic loss of -$3,000. Factoring ceteris paribus what economic advice would you give her

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