Use spread sheet to find total revenue

Assignment Help Microeconomics
Reference no: EM13691256

1. Given demand function Q = 400 - .5P, we are interested to use spread sheet to find total revenue, marginal revenue, and price elasticity (point).
a. For the first row enter: price in column A, quantity in the column B, TR in column C, MR in column D, and Point elasticity in column E.
b. Using Excel starting at a price of 780 and decrease by 20 until P = 520.
c. Use the formula command to enter quantity using demand function Q = 400 - .5P and drag the formula command to fill out the rest of the column.
d. Using Excel chart wizard to produce a scatter plot for Q and Price. Make sure price is Y axis.
e. Find algebraic functions for inverse demand. Then derive TR, MR, and Point elasticity. Please write the functions before the next step.
f. Use the formula command to enter TR, MR, and point elasticity.

Reference no: EM13691256

Questions Cloud

A rigid well-insulated tank contains air : A rigid well-insulated tank contains air
How much was the presidents proposal in new tax measures : According to the text, budget Committee Chair Pete Domenici suggested a tax cut of how much as an immediate stimulus and how much room for representatives to gather at the cneter without the risk of angering the party leadership?
Capital investment decision techniques : Capital Investment Decision Techniques
A soft drink bottler collected monthly data : A soft drink bottler collected monthly data on its sales of 12 ounce cans at different prices.
Use spread sheet to find total revenue : Use spread sheet to find total revenue
Create a timeline of expected cash flow : Determine the interest rate Helen is currently earning on her inheritance by going to the Reserve Bank of Australia and click on the Cash Rate link in the key information section.
Using a budget line and indifference curves : Using a budget line and indifference curves
Support of education was increased : Suppose that government spending in support of education was increased
Unemployment levels rise and fall with the economy : Unemployment levels rise and fall with the economy

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