Question: Can someone help show me how I would plot this in Excel? Example 4.2 The travel time on a stretch of a highway lane connecting

Can someone help show me how I would plot this in Excel?

Example 4.2 The travel time on a stretch of a highway lane connecting two activity centers has been observed to follow the equation representing the service function: t= 15 + 0.0211 where t and v are measured in minutes and vehicles per hour, respectively. The demand function for travel connecting the two activity centers is v = 4000 120t (a) Sketch these two equations and determine the equilibrium time and speed of travel. (b) If the length of the highway lane is 20 mi, what is the average speed of vehicles traversing this length? Solution Solving the two equations: t = 15 + 0.02v v = 4000 120t results in the following values for v and t at equilibrium (as shown in gge E42): v = 647 veh/hr t = 27.94 min 20X60 Speed = 27.94 = 42.95 mph Time, t (min) t: 15 + 0.021! (647, 27.94) v = 4000 - 120t 2000 4000 v (vehicles/hr) Figure E42 Static equilibrium of demand and supply

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!

Insert the following problem into Excel, evaluate, and explain. How do you enter this information into Excel? What information can we determine from Excel? Example 4-2 The travel time on a stretch of...

Board CHAPTER 1 Economics: Foundations and Models n this book, we use economics to answer questions such as the following What determines the prices of goods and services from bottled water to smart...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Process Strategy Chapter 3 Copyright 2013 Pearson Education, Inc. publishing as Prentice Hall 03 -01 What is Process Strategy? Process Strategy The pattern of decisions made in managing processes, so...

TripIt: The Traveler's Agent TripIt is a platform opportunity. If we are successful, we will be the \"home base\" for all of a consumer's travel information. Gregg Brockway, president and cofounder...

5-407-753 MARK JEFFERY Air France Internet Marketing: Optimizing Google, Yahoo!, MSN, and Kayak Sponsored Search Rob Griffin, senior vice president and U.S. director of search for Media Contacts, a...

Cutting Edge This case was adapted from Hiller, Frederick S. & Mark S. Hillier (2014). Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets, 5th ed.,...

How can you summarize the compensation and reward system of the three organizations? What do they all have in common, if anything? Look up everything you can find that has been written about Lincoln...

Key issue/problem statement what is the key problem/s or issue/s addressed in the case? What is the main decision that manager/s need to make? Maximum = 2 issues . Options with pros and cons...

Journal of Autism and Developmental Disorders, Vol. 32, No. 3, June 2002 ( 2002) Descriptive Epidemiology of Autism in a California Population: Who Is at Risk? Lisa A. Croen,1,3 Judith K. Grether,1...

In an experiment of 40 college soccer players (20 women and 20 men), the total distance each participant could cover in three single-leg hops was recorded. The players also jumped vertically, and...

Define intellectual property and name the treaty that seeks to protect intellectual property?

15. Consider an employee who does not receive employer-based health insurance and must divide her $1,000 per week in after-tax income between health insurance and other goods. Draw this workers...

Assuming that you are a public relations officer in an non-government organization and your employer has assigned and awarded $100,000 to your team to do a campaign on overcoming an issue. Your task...

6. Give examples of circular patterns in a communication situation that you have participated in, where element A affects B, and B affects A.

3. Find examples from your everyday life of people or situations that fit the Ithaca Syndrome.

1. Discuss the following: a) If you want stability, you should focus on change. b) What happens when an effect becomes a cause? c) If you do the opposite of what is expected, the reaction is changed....