2. [40% ] A growing city has installed a monorail system connecting the down- town to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. [40% ] A growing city has installed a monorail system connecting the down- town to its international airport. It has been tracking daily monorail passenger load for the last 5 years. The monorail operates 7 days per week, 52 weeks per year. The data containing the daily passenger load for each week is in file BA3653M3Monorail.xlsx, accompanying this midterm. (a) Calculate the total number of passengers per week for each week in the data. Using this total, obtain the trend projection with regression that models the monorail passenger load growth (on a weekly basis). (b) Is a trendline appropriate for this situation? Calculate the coefficient of determination to show that a trendline is appropriate. (c) Daily passenger usage varies during the week. Use the seasonal index method to create a model that can predict the daily passenger load for any given week. (d) The city considers that any passenger load larger than 50,000 passen- gers per week will require the expansion of the monorail network. Esti- mate approximately how many weeks it will take for this situation to be reached given the current level of passenger load growth. (e) Engineers estimate that it will take 3 years to complete the monorail ex- pansion. Calculate what the passenger load will be 3 years (153 weeks) after the expansion. Obtain the passenger load for the busiest day on that week. (f) A daily usage larger than 10,000 passengers/day will overwhelm the monorail and cause a bottleneck. Will the current plan (begin expansion at 50,000 passengers/week) cause a bottleneck? Is your recommendation that the plan be followed, or should it be revised? 2. [40% ] A growing city has installed a monorail system connecting the down- town to its international airport. It has been tracking daily monorail passenger load for the last 5 years. The monorail operates 7 days per week, 52 weeks per year. The data containing the daily passenger load for each week is in file BA3653M3Monorail.xlsx, accompanying this midterm. (a) Calculate the total number of passengers per week for each week in the data. Using this total, obtain the trend projection with regression that models the monorail passenger load growth (on a weekly basis). (b) Is a trendline appropriate for this situation? Calculate the coefficient of determination to show that a trendline is appropriate. (c) Daily passenger usage varies during the week. Use the seasonal index method to create a model that can predict the daily passenger load for any given week. (d) The city considers that any passenger load larger than 50,000 passen- gers per week will require the expansion of the monorail network. Esti- mate approximately how many weeks it will take for this situation to be reached given the current level of passenger load growth. (e) Engineers estimate that it will take 3 years to complete the monorail ex- pansion. Calculate what the passenger load will be 3 years (153 weeks) after the expansion. Obtain the passenger load for the busiest day on that week. (f) A daily usage larger than 10,000 passengers/day will overwhelm the monorail and cause a bottleneck. Will the current plan (begin expansion at 50,000 passengers/week) cause a bottleneck? Is your recommendation that the plan be followed, or should it be revised?
Expert Answer:
Answer rating: 100% (QA)
solution a Weekly Passenger Load Week 1 34444 Week 2 33425 Week 3 32375 Week 4 32025 Week 5 33150 Total Passenger Load 164419 Regression Model y a bx ... View the full answer
Related Book For
Financial Markets and Institutions
ISBN: 978-0077861667
6th edition
Authors: Anthony Saunders , Marcia Cornett
Posted Date:
Students also viewed these accounting questions
-
The Pedal Pusher Bicycle Shop operates 7 days per week, closing only on Christmas Day. The shop pays $300 for a particular bicycle purchased from the manufacturer. The annual holding cost per bicycle...
-
Calculate the total number of germ-line-encoded VH and VL domains that can be constructed from the available Ig genes. Compare this to the numbers of germ-line-encoded V and V domains of the TCR. How...
-
Calculate the total number of electrons that can occupy (a) One s orbital, (b) Three p orbitals, (c) Five dorbitals, (d) Seven forbitals.
-
Consider the following limit order book for a stock.The last trade in the stock occurred at a price of $55. Buy Order Limit Sell Order Limit Precio share Precio share ps 54.75 500 ps 55.25 200 54.50...
-
A bank manager of MetroBank Financial Inc. uses the managerial accounting system to track the costs of operating the various departments within the bank. The departments include Cash Management,...
-
Why has the AMT become a controversial tax in recent years? ________________________________________________________________________________________
-
Identify constraint, then determine product mix (Learning Objective 5) Lifemaster produces two types of exercise treadmills: Regular and Deluxe. The exercise craze is such that Lifemaster could use...
-
Xenold, Inc., manufactures and sells cooktops and ovens through three divisions: Home, Restaurant, and Specialty. Each division is evaluated as a prot center. Data for each division for last year are...
-
Foxx Corporation acquired all of Greenburg Company's outstanding stock on January 1 , 2 0 1 9 , for $ 6 0 0 , 0 0 0 cash. Greenburg's accounting records showed net assets on that date of $ 4 7 0 , 0...
-
Dwight Donovan, the president of Donovan Enterprises, is considering 2 Investment opportunities. Because of limited resources, he will be able to invest in only 1 of them. Project A is to purchase a...
-
Explain how risk is measured.
-
Miyagi Data, Inc., sells earnings forecasts for Japanese securities. Its credit terms are 1/30, net 50. Based on experience, 75 percent of all customers will take the discount. a.What is the average...
-
Prepare written essay where you present the following information: 1. Describe four (4) benefits of responsibility center accounting. 2. Discuss the conditions necessary for an effective...
-
A building is expected to generate no cash flows for several years and then generate annual cash flows forever.What is the value of the building if the first annual cash flow is expected in 7 years,...
-
Deed Co. owns 2% of Beck Cosmetic Retailers. A property dividend by Beck consisted of merchandise with a fair value lower than the listed retail price. Deed in turn gave the merchandise to its...
-
Provide an example where you compared good and services by its value and compared perceived benefits and price? How dod your assessment of value led to purchase decision? Do you think you will be...
-
A retailer is importing a product from an overseas supplier. If there are q units on the market, the unit price of the product will be a-bq dollars (this is called the market clearing price). The unit
-
Under what conditions is the following SQL statement valid?
-
Bank 1 can issue five-year CDs at an annual rate of 11 percent fixed or at a variable rate of LIBOR + 2 percent. Bank 2 can issue five-year CDs at an annual fixed rate of 13 percent or at a variable...
-
Consider an investor who, on January 1, 2016, purchases a TIPS bond with an original principal of $ 100,000, an 8 percent annual (or 4 percent semiannual) coupon rate, and 10 years to maturity. a. If...
-
Consider a 12-year, 12 percent annual coupon bond with a required rate of return of 10 percent. The bond has a face value of $ 1,000. a. What is the fair present value of the bond? b. If the required...
-
appraise the methods to foster creativity and innovation,
-
recognize the value of creativity and innovation for an organization,
-
What could you suggest to Graham to improve the decision-making process in his organization? Graham ruled with an iron will. He felt that the only way to motivate his employees was by giving them...
Study smarter with the SolutionInn App