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

  What according to the mainstream theory of the business

what according to the mainstream theory of the business cycle is the most common source of recession a decrease in

  Land along the yarra river in melbourne has high value as

land along the yarra river in melbourne has high value as developed property but in undeveloped form increases the

  Be sure to explain your answers completely and show you

be sure to explain your answers completely and show you read each article and thought about what it said.question1

  How to decline in the price of nova corporations stock

Nova corporation just announced that it had a record year. Its earnings have increased nearly 10%. Explain how this announcement can lead to a decline in the price of Nova Corporation's Stock

  What is inseparable from the production of commodities

The mysterious character of the commodity-form consists therefore simply in the fact that the commodity reflects the social characteristics of men's own labor as objective characteristics of the products of labor themselves, as the socio-natural p..

  Firm facing a downward sloping demand curve is producing

A firm facing a downward sloping demand curve is producing a level of output at which price is $7, marginal revenue is $5, and average total cost, which is at its minimum value, is $3. In order to maximize profit, the firm should

  Given the same minimum wage and training program

Given the same minimum wage and training program

  Determine market structure of low-calorie food company

Determine the market structure in which the low-calorie food company operates and analyze short-run and long-run production and cost functions.

  Describe the analysis tools at their disposal to estimate

our company wants to invest in a new technology driven product. it is a significant investment so management wants a

  1 what is the legislationpolicy that will be analyzed in

1. what is the legislationpolicy that will be analyzed in this paper?2. what is the problemissue that this legislation

  Show graphically cost of income taxation of 30 to consumers

demonstrate graphically the cost of income taxation of 30 to consumers and producers for an income of 27908?how does

  Has birger violated the corporate opportunity doctrine

Ulrick and Birger started an air taxi service in Berlin, Germany, under the name Berlinair, Inc. Biger was approached by a group of travel agents who were interested in hiring an air charter business to take German tourists on vacation. Birger for..

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