Question #2 (externalities—spreadsheet from the SEPTA case study) Please review and use the materials provided in the Ha

[answerhappygod]

Question #2 (externalities—spreadsheet from the SEPTA case study)
Please review and use the materials provided in the Harvard Case Study Readings for "The Quest for Sustainable Public Transit Funding: SEPTA's 2013 Capital Budget Crisis". This paper provides sufficient data in Exhibits 8 and 9 to answer the Total Revenue, Subsidy and Elasticity Questions. Exhibits 5 and 6 offer insight into the demographic information. This is an analytic question that uses math for a decision making process.
(a and b and c require numerical answers—to be clear, I need to be given the numbers)
Also, the elasticity equation you will need to use is:
Price Elasticity of Demand = (P/Q)times(Change in Q/Change in P)
You are provided different elasticity scenarios offered (based on price increases of between 5% and 20%)
How much is the initial Government Operating Subsidy? How much is the State's Operating Subsidy? (4 Points)
When reviewing Exhibits 5 and 6, what data stands out as the population that is more likely to use Public Transportation? (2 Points)
Would Total Revenue increase or decrease if the per ride fares were increased by 10% or 15% and How much will they go up (this requires a numeric answer and you must show your work)? (9 Points)
According to this analysis, can fare increases eliminate the State's Operating Subsidy and why? (2 Points)
What are the implications on fairness that these increases create? (3 points)