In: Economics
Your car gets 25 miles per gallon (mpg) at 60 miles per hour (mph) and 18 mpg at 70 mph. At what speed should you make a 600-mile trip:
1. If gas costs $3 per gallon and your time is worth $12 per hour?
2. If gas costs $4 per gallon and your time is worth $15 per hour?
3. If gas costs $5 per gallon and your time is worth $10 per hour?
4. Build a spreadsheet to calculate the total trip cost for gas costs of $3, $4, and $5, and values of time of $10, $12, $15, 18 and $20 per hour. Do two tables: one at 60mph and one at 70 mph
PLEASE WRITE WHAT EQUATIONS THAT MUST BE WRITTEN IN EXCEL IN ORDER TO GET THE DATA FOR PART 4.
Distance=600 m
1) @60 miles per hour
total Number of hours= distance / speed
=600/60
=10 hr
cost due to hours =Rate per hour * number of hours
=$12*10
=$120
Number of gallons required = Distance / miles per galon
=600/25
=24 galons
cost of fuel = number of galons * cost per galon
=24*$3
=$72
Total cost =72+120
=$192
@70 miles per hour
total Number of hours= distance / speed
=600/70
=8.57 hr
cost due to hours =Rate per hour * number of hours
=$12*8.57
=$102.85
Number of gallons required = Distance / miles per galon
=600/18
=33.33 galons
cost of fuel = number of galons * cost per galon
=33.33*$3
=$100
Total cost =102.85+100
=$202.85
Therfore going at 60 mile per hour is better
2) @60 miles per hour
total Number of hours= distance / speed
=600/60
=10 hr
cost due to hours =Rate per hour * number of hours
=$15*10
=$150
Number of gallons required = Distance / miles per galon
=600/25
=24 galons
cost of fuel = number of galons * cost per galon
=24*$4
=$96
Total cost =96+150
=$246
@70 miles per hour
total Number of hours= distance / speed
=600/70
=8.57 hr
cost due to hours =Rate per hour * number of hours
=$15*8.57
=$128.57
Number of gallons required = Distance / miles per galon
=600/18
=33.33 galons
cost of fuel = number of galons * cost per galon
=33.33*$4
=$133.33
Total cost =128.57+133.33
=$261.9
Therfore going at 60 mile per hour is better
3) @60 miles per hour
total Number of hours= distance / speed
=600/60
=10 hr
cost due to hours =Rate per hour * number of hours
=$10*10
=$100
Number of gallons required = Distance / miles per galon
=600/25
=24 galons
cost of fuel = number of galons * cost per galon
=24*$5
=$120
Total cost =100+120
=$220
@70 miles per hour
total Number of hours= distance / speed
=600/70
=8.57 hr
cost due to hours =Rate per hour * number of hours
=$10*8.57
=$85.7
Number of gallons required = Distance / miles per galon
=600/18
=33.33 galons
cost of fuel = number of galons * cost per galon
=33.33*$5
=$166.65
Total cost =85.7+166.64
=$252.35
Therfore going at 60 mile per hour is better
4)
@ 60 mile per hour | ||||||
Hours Taken = | 600/60 | 10 | ||||
Miles Per galon | 25 | |||||
total galons | distance/ miles per galon | 24 | ||||
=Cost per gallon ($) * total galons | =Cost per hour ($)* Hours Taken | |||||
CASE | Cost per gallon ($) | Cost per hour ($) | Cost of fuel | Cost of hours | Total Cost | |
1 | 3 | 10 | 72 | 100 | 172 | |
2 | 3 | 12 | 72 | 120 | 192 | |
3 | 3 | 15 | 72 | 150 | 222 | |
4 | 3 | 18 | 72 | 180 | 252 | |
5 | 3 | 20 | 72 | 200 | 272 | |
6 | 4 | 10 | 96 | 100 | 196 | |
7 | 4 | 12 | 96 | 120 | 216 | |
8 | 4 | 15 | 96 | 150 | 246 | |
9 | 4 | 18 | 96 | 180 | 276 | |
10 | 4 | 20 | 96 | 200 | 296 | |
11 | 5 | 10 | 120 | 100 | 220 | |
12 | 5 | 12 | 120 | 120 | 240 | |
13 | 5 | 15 | 120 | 150 | 270 | |
14 | 5 | 18 | 120 | 180 | 300 | |
15 | 5 | 20 | 120 | 200 | 320 | |
@ 70 mile per hour | ||||||
Hours Taken = | 600/70 | 8.571428571 | ||||
Miles Per galon | 18 | |||||
total galons | distance/ miles per galon | 33.33333333 | ||||
=Cost per gallon ($) * total galons | =Cost per hour ($)* Hours Taken | |||||
CASE | Cost per gallon ($) | Cost per hour ($) | Cost of fuel | Cost of hours | Total Cost | |
1 | 3 | 10 | 100 | 85.71428571 | 185.7142857 | |
2 | 3 | 12 | 100 | 102.8571429 | 202.8571429 | |
3 | 3 | 15 | 100 | 128.5714286 | 228.5714286 | |
4 | 3 | 18 | 100 | 154.2857143 | 254.2857143 | |
5 | 3 | 20 | 100 | 171.4285714 | 271.4285714 | |
6 | 4 | 10 | 133.3333333 | 85.71428571 | 219.047619 | |
7 | 4 | 12 | 133.3333333 | 102.8571429 | 236.1904762 | |
8 | 4 | 15 | 133.3333333 | 128.5714286 | 261.9047619 | |
9 | 4 | 18 | 133.3333333 | 154.2857143 | 287.6190476 | |
10 | 4 | 20 | 133.3333333 | 171.4285714 | 304.7619048 | |
11 | 5 | 10 | 166.6666667 | 85.71428571 | 252.3809524 | |
12 | 5 | 12 | 166.6666667 | 102.8571429 | 269.5238095 | |
13 | 5 | 15 | 166.6666667 | 128.5714286 | 295.2380952 | |
14 | 5 | 18 | 166.6666667 | 154.2857143 | 320.952381 | |
15 | 5 | 20 | 166.6666667 | 171.4285714 | 338.0952381 | |
Related SolutionsYour car gets 29 miles per gallon (mpg) at 60 miles per hour (mph) and 25...Your car gets 29 miles per gallon (mpg) at 60 miles
per hour (mph) and 25 mpg a 70 mph. At what speed should you make a
525-mile trip:
If gas costs $3 per gallon and your time is worth $18 per
hour
If gas costs $4 per gallon and your time is worth $12 per
hour
If gas costs $5 per gallon and your time is worth $9 per
hour
Your car gets 22 miles per gallon (MPG) at 55 miles per hour (MPH) and 18...Your car gets 22 miles per gallon (MPG) at 55 miles per hour
(MPH) and 18 MPG at 65 MPH. At what speed should you make a
450-mile trip 1. If gas costs $2.95 per gallon and your time is
worth $17/hour? 2. If gas costs $3.80 per gallon and your time is
worth $11.5/hour? 3. If gas costs $4.75 per gallon and your time is
worth $8.9/hour? 4. Building an Excel spreadsheet to calculate the
total trip cost for...
For a car that travels 70 mph for 60 miles and then 80 mph for 60...For a car that travels 70 mph for 60 miles and then 80 mph for
60 miles. The total time traveled is given by calculating the
distance per rate traveled for each part and then summing the
values. •Have the program in c++ that calculates the most
appropriate mean rate of the two different rates and the two equal
distances, and output the result to the text file. The “best” mean
rate is the rate at which T=D/R is same...
The manufacturer of a new compact car claims the miles per gallon (mpg) for the gasoline...The manufacturer of a new compact car claims the miles per
gallon (mpg) for the gasoline consumption is mound-shaped and
symmetric with a mean of 27.4 mpg and a standard deviation of 12.3
mpg. If 30 such cars are tested, what is the probability the
average mpg achieved by these 30 cars will be greater than 28?
you currently drive 300 miles per week in a car that gets 20 miles per gallon...you currently drive 300 miles per week in a car that gets 20
miles per gallon of gas. you are considering buying a new
fuel-efficient car for $12,000 ( after trade-in on your current
car) that gets 50 miles per gallon. Insurance premiums for the new
and old car are $900 and $500 per year, respectively. you
anticipate spending $1300 per year on repairs for the old car and
having no repairs on the new car. assume gas costs $3.50...
Suppose gas costs $3 a gallon and the average car gets 28 miles per gallon. If...Suppose gas costs $3 a gallon and the average car gets 28 miles
per gallon. If Congress mandates that cars have to get 36 miles per
gallon, by what percentage will this lower the costs of driving? If
the elasticity of total miles driven (per year) with respect to the
cost of driving is –1, by how much will total miles driven per year
increase, assuming it is 10,000 miles at the beginning? How much
will total annual gas consumption...
Suppose gas costs $3 a gallon and the average car gets 28 miles per gallon. If...Suppose gas costs $3 a gallon and the average car gets
28 miles per gallon. If Congress mandates that cars have to get 36
miles per gallon, by what percentage will this lower the costs of
driving? If the elasticity of total miles driven (per year) with
respect to the cost of driving is –1, by how much will total miles
driven per year increase, assuming it is 10,000 miles at the
beginning? How much will total annual gas consumption...
A car manufacturer claims that the miles per gallon (mpg) of all its midsize cars can...A car manufacturer claims that the miles per gallon (mpg) of all
its midsize cars can be modeled with a normal model with N(33,
1.70).
What proportion of cars have miles per gallon less than 31.2
[P(x ≤31.2 mpg)]?
What proportion of cars will have miles per gallon greater than
36 [P(x ≥36 mpg)]?
What proportion of cars will have miles per gallon less than
30[P(x ≤30 mpg)]?
What proportion of cars will have miles per gallon between 32
and...
When traveling 40 mph (miles per hour), the distance that it takes Fred’s car to stop...When traveling 40 mph (miles per hour), the distance that it
takes Fred’s car to stop varies evenly between 120 and 155 feet.
(This includes the reaction distance and the braking distance.) All
of the questions are related to the stopping distance when Fred is
traveling 40 mph.
a) Let S be the distance it takes for Fred’s car to stop at when
traveling 40 mph. Find the distribution, parameter(s), and support
of S.
b) What is the probability that...
A car company advertises that their Super Spiffy Sedan averages 29 mpg (miles per gallon). You...A car company advertises that their Super Spiffy Sedan averages
29 mpg (miles per gallon). You randomly select a sample of Super
Spiffies from local dealerships and test their gas mileage under
similar conditions.
You get the following MPG scores:
33 27 32 34 34 28 27 31
Note: SSx = 63.50
Using alpha =.01, conduct the 8 steps to hypothesis testing to
determine whether the actual gas mileage for these cars differs
significantly from 29mpg.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|