QUANATIVE REASONING FOR PROFESSOR ELIUD PETERSON : Solution Essays

You own a delivery service in your local area, but you are thinking of expanding to another market.  You’re concerned that you might need to set different prices in the new market because the cost of gas might be much different.

****Identify 10 gas stations in your local area and record price per gallon for each gas station

(Below are 10 gas stations in my local area)

Sam’s Club

$1.87

Dodge’s Store

$1.90

Circle K

$1.90

Flying J

$1.91

Spaceway

$1.92

Kroger

$1.93

MurphyExpress

$1.93

Shell

$1.95

Mapco

$1.95

Citgo

$1.97

*****Research supply and demand curves for gasoline. (to reference prices around Unites States) . ——à  https://www.fueleconomy.gov/feg/gasprices/states/

Create an Excel® spreadsheet  with a Scatter chart (Scatter with Smooth Lines & Markers)

in which you do the following:

  *  Create a supply curve for gasoline.

  *  Create a demand curve for gasoline.

  *  Calculate the average cost of gas in your local area.

  *  Calculate the standard deviation.

*****Determine whether the prices in your local area are higher or lower than the national average.

Create a 600-word proposal in which you include the following:

  *  Explain elasticity of supply and demand and how this relates to your pricing decision.

  *  Determine if your prices will be higher, lower, or the same for the new location.

  *  Defend the pricing decision including all supporting documentation.