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 shape did the short-run aggregate supply curve

1. What shape did the short-run aggregate supply curve have during the 1930s, according to Keynes? Explain

  Explain what this means for the price of physician services

Licensure of physicians means that to some extent, the supply of physicians can be viewed as a vertical line. Explain what this means for the price of physician services. How might this change over time?

  Estimate the cash flow to be included in the horizon year

Estimate the cash flow to be included in the horizon year and what will be the horizon value if there is no profit growth?

  Which consumers would purchase insurance at that priceare

suppose there are two types of people who need health insurance high-risk and low-risk consumers. high-risk consumers

  Positive cross-price elasticity between

We would expect to see positive cross-price elasticity between:

  Assume that every citizen of country x has the utility

assume that every citizen of country x has the utility function of ux y 5x4y. say that x denotes cigarettes and y

  Paid for treating a medicare patient

The amount that a hospital will be paid for treating a Medicare patient is determined before the patient ever sees a physician.

  Will deception be used in order to obtain agreement

In cases in which the human subject is dissatisfied or a complaint about the researcher or Yes No procedure, will the researcher explain to the human subject that he or she may express this complaint to the Subject Coordinator?

  Zero-coupon corporate bond with a face value

An investor purchases a three-year, zero-coupon corporate bond with a face value of $100,000. At the time the original purchase was made, the yield on the bond was five percent. One year later, the investor sold the bond, and realized a rate of retur..

  What are the values and interpretations of the slack

Southern Oil Company produces two grades of gasoline: regular and premium. The profit contributions are $0.30 per gallon for regular gasoline and .50 per gallon for premium gasoline.

  Real wages more accurately reflect the payment to labor

Real wages more accurately reflect the payment to labor because they are adjusted for the effects of inflation. Inflation tends to redistribute real income from lenders to borrowers.

  Explain the factors which must be considered when

explain in your own words the difference between survivor income benefits insurance and group term insurance. how is

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