please answer the questions on the sheet. it should not take long at all. please be done by 11:30!!
Transportation is a critical issue facing California. As its population expands, the State will need to develop a new form of travel to provide its residents with increased mobility and support its growing economy. Two solutions to this problem have risen to the forefront, the High-Speed Rail (underway) and the Hyperloop (compressed zero-friction form transportation). (Cite: USC Price School Hovanes Gasparian and Kelley Groves).
The Governor of California has asked you to perform a cost-benefit analysis on whether the state government should invest in a high-speed rail system or a hyperloop.
The high-speed rail will include 800 miles of track, run up to speeds of 220 mph, and have stops in Los Angeles, San Francisco, Sacramento, the Inland Empire, Orange County, and San Diego (Catherine et al., 2011).
The Hyperloop system of travel comprises reduced-pressure, elevated tubes that propel passenger capsules at a maximum of 586 mph (Musk, 2013). Its route would mirror California’s Interstate 5 between the Northern San Fernando Valley in Los Angeles to the Hayward/Castro Valley area in San Francisco and will have the ability to travel this distance of 327 miles in approximately 35 minutes. There will be a total of 40 capsules that have the capacity to carry 28 passengers each (Musk, 2013).
Below are data tables from the USC Price Hyperloop report.
Cost Tables
Benefit Tables
Part A: To complete this homework, you must use the provided tables to analyze the non-discounted values and assign a decision rule
Week 07 Homework is an excel assignment. Please complete the following assignment using excel. You do not need to provide the excel sheet. However, you are unable to complete a question without using the excel functions identified in each question. Please note that we will be asking you to develop a model and then solving for a set of functions.
Some advice on the homework…
Start Early: make sure to give yourself time to read the chapter before starting the homework. Make sure to flag concepts and use that to review material when doing the homework.
Use a Study Method: It is helpful to have a method for evaluating each question. Consider each concept raised in the question stem. There are no trick questions.
Check Your Work: review your work before submissions.
Proofread: Make sure to review your explanations and proofread.
