Perform the following work • Assume that Supply has a quadratic relationship with the price. Find this relationship (the help buttons contain an article to compute trend-lines in Excel): S(p) = Round your answer to 3 decimal places • Assume that the Demand has a quadratic relationship with the price. Find this relationship (the help button links to an article to compute trend-lines in Excel): D(p) Round your answer to 3 decimal places Use the trendlines to find the price corresponding to the equlibrium price between supply and demand: $ per gallon Round your answer to 2 decimal places From the price above what is the equilibrum quantity between supply and demand: million of gallons Round your answer to closest whole number

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question
The table below shows how supply and demand of gasoliine vary depending on the price:
Demand (million of gal.)
Price ($/gal)
Supply (million of gal.)
1
787
483
1.2
700
550
1.4
640
600
1.6
580
623
1.85
531
660
2.2
450
680
2.4
430
700
2.6
420
720
2.8
390
735
2.9
357
765
Note: there is some randomization in the above data to account for price fluctuations. Make sure to check that you input
the correct data in your device.
Perform the following work
• Assume that Supply has a quadratic relationship with the price. Find this relationship (the help buttons contain an
article to compute trend-lines in Excel):
S(p) =
Round your answer to 3 decimal places
• Assume that the Demand has a quadratic relationship with the price. Find this relationship (the help button links to
an article to compute trend-lines in Excel):
D(p) =
Round your answer to 3 decimal places
Use the trendlines to find the price corresponding to the equlibrium price between supply and demand:
$ per gallon Round your answer to 2 decimal places
• From the price above what is the equilibrum quantity between supply and demand:
million of gallons Round your answer to closest whole number
• Under these conditions, what is the consumer surplus?
million of gallons Round your answer to closest whole number
• Under these conditions, what is the producer surplus?
million of gallons Round your answer to closest whole number
Discuss what is a mathematical model in general, and how mathematical models are used in this activity.
Transcribed Image Text:The table below shows how supply and demand of gasoliine vary depending on the price: Demand (million of gal.) Price ($/gal) Supply (million of gal.) 1 787 483 1.2 700 550 1.4 640 600 1.6 580 623 1.85 531 660 2.2 450 680 2.4 430 700 2.6 420 720 2.8 390 735 2.9 357 765 Note: there is some randomization in the above data to account for price fluctuations. Make sure to check that you input the correct data in your device. Perform the following work • Assume that Supply has a quadratic relationship with the price. Find this relationship (the help buttons contain an article to compute trend-lines in Excel): S(p) = Round your answer to 3 decimal places • Assume that the Demand has a quadratic relationship with the price. Find this relationship (the help button links to an article to compute trend-lines in Excel): D(p) = Round your answer to 3 decimal places Use the trendlines to find the price corresponding to the equlibrium price between supply and demand: $ per gallon Round your answer to 2 decimal places • From the price above what is the equilibrum quantity between supply and demand: million of gallons Round your answer to closest whole number • Under these conditions, what is the consumer surplus? million of gallons Round your answer to closest whole number • Under these conditions, what is the producer surplus? million of gallons Round your answer to closest whole number Discuss what is a mathematical model in general, and how mathematical models are used in this activity.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Demand and Supply Curves
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
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