The demand curve for a maker of spare parts is given by: Q = 300 – 0.5P, and its cost function by C= 20,000 + 2000 + 0.50. a Treating price as the relevant decision variabie, create a spreadsheet based on the example shown below (enter formulas for all numerical values except for price). Compute the price elasticity according to Ep = (dQ/dP)(P/Q). b. Use your spreadsheet's optimizer to find the optimal price. The markup rate, (P-MCYP, must be the same as -1/Ep at the optimal (profit- max) price. c. Save your Excel fine and upload it by clicking on Browse Local Files below. 1 Price(P) Quantity(Q) Revenue(R) Cost(C) Profit Elasticity(Ep) MC (P-MC)/P (-1/Ep) 540 30 16200 26430 -10250 230 0.574074 0.111111

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question

10

The demand curve for a maker of spare parts is given by: Q= 300 - 0.5P, and its cost function by C = 20,000 + 200Q + 0.5Q2.
a Treating price as the relevant decision variable, create a spreadsheet based on the example shown below (enter formulas for all
b. Use your spreadsheet's optimizer to find the optimal price. The markup rate, (P-MC/P, must be the same as -1/Ep at the optimal (profit-
max) price.
c. Save your Excel fine and upload it by clicking on Browse Local Files below.
G
1 Price(P) Quantity(a) Revenue(R) Cost(C) Profit
Elasticity(Ep) MC
(P-MC)/P (-1/Ep)
S40
30
16200
26450
10250
230 0.574074 0.111111
Attach File
Browse Local Files
Transcribed Image Text:The demand curve for a maker of spare parts is given by: Q= 300 - 0.5P, and its cost function by C = 20,000 + 200Q + 0.5Q2. a Treating price as the relevant decision variable, create a spreadsheet based on the example shown below (enter formulas for all b. Use your spreadsheet's optimizer to find the optimal price. The markup rate, (P-MC/P, must be the same as -1/Ep at the optimal (profit- max) price. c. Save your Excel fine and upload it by clicking on Browse Local Files below. G 1 Price(P) Quantity(a) Revenue(R) Cost(C) Profit Elasticity(Ep) MC (P-MC)/P (-1/Ep) S40 30 16200 26450 10250 230 0.574074 0.111111 Attach File Browse Local Files
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education