Download Traffic Forecasting for Infrastructure Planning and more Thesis Accounting in PDF only on Docsity!
Question You are to use the supplied historic data to develop forecasts that can inform KCB's decision whether and when to add additional high bay capacity to the toll station. 1. Plot the historic data and provide an estimate of seasonality of the leisure traffic. 2. Provide a forecast of the expected traffic up to the end of 2025, based on the complete data set you have been given. Create a suitable chart to visualise the data. 3. Provide a forecast of the expected traffic up to the end of 2025, based solely on data recorded after the onset of the COVID-19 pandemic in January 2020. Create a suitable chart to visualise the data. 4. Discuss the similarity and differences between the two forecasts. 5. What advice would you offer KCB regarding the decision to invest in additional capacity? Note that there is no expectation that you will use specialist software to undertake this assignment. No additional credit will be given for doing so. Microsoft Excel is quite sufficient. Show your working; simple, auditable steps are preferred to the use of complex models.
Answer & Explanation To address the questions regarding the traffic forecasting for KCB, we'll proceed step by step using basic forecasting techniques. Here's a structured approach using Excel:
1. Plot the Historic Data and Estimate Seasonality Firstly, let's plot the historic data and estimate the seasonality. Suppose we have monthly traffic data from January 2017 to December 2023 (7 years). - Step-by-step: a. Enter the historic traffic data into Excel. b. Create a line chart to visualize the traffic data over time. c. Calculate the seasonal indices to estimate seasonality. This can be done by
For forecasting based on the complete data set:
on analysis) ``` - Extend this method to forecast up to December 2025.
- Create a chart showing historical traffic and the forecasted values. 3. Forecast of Expected Traffic up to End of 2025 (Post-COVID Data Only) For forecasting based solely on data recorded after January 2020 (post-COVID):
- Repeat the same forecasting method (e.g., Moving Averages) but only use data from January 2020 onwards.
- Create a separate chart to visualize this forecasted data. 4. Discuss Similarity and Differences Between the Two Forecasts Compare the forecasts from steps 2 and 3:
- Similarities: Look for trends and overall patterns that are consistent between the two forecasts.
- Differences: Highlight any shifts or changes in traffic patterns post-COVID compared to the long-term trends. 5. Advice to KCB Regarding the Decision to Invest in Additional Capacity Consider the following factors based on your analysis:
- Long-term Forecast (Complete Data Set): Assess if there's a consistent growth trend that suggests a need for additional capacity.
Lana, I., Del Ser, J., Velez, M., & Vlahogianni, E. I. (2018). Road traffic forecasting: Recent advances and new challenges. IEEE Intelligent Transportation Systems Magazine, 10(2), 93-109. Vlahogianni, E. I., Karlaftis, M. G., & Golias, J. C. (2014). Short-term traffic forecasting: Where we are and where we're going. Transportation Research Part C: Emerging Technologies, 43, 3-19. Step-by-step explanation Traffic forecasting is a crucial aspect of urban planning and transportation management, aimed at predicting future traffic patterns to optimize infrastructure and improve overall efficiency. This process involves analyzing historical data, current trends, and various influencing factors to make informed predictions about traffic volumes, congestion levels, and travel patterns. Firstly, historical data plays a fundamental role in traffic forecasting. By examining past traffic patterns, including peak hours, seasonal variations, and event-related traffic surges, analysts can identify recurring trends and patterns. This data forms the basis for creating models that simulate future scenarios, helping planners anticipate potential bottlenecks and congestion points.
Secondly, demographic and economic factors significantly impact traffic forecasts. Population growth, employment trends, and residential development patterns influence travel demand and commuting behaviors. For instance, rapid urbanization or industrial growth in specific areas can lead to increased traffic volumes on certain routes, necessitating infrastructure upgrades or changes in traffic management strategies. Thirdly, advancements in technology have revolutionized traffic forecasting techniques. The integration of real-time data from sensors, GPS devices, and mobile apps allows for more accurate and dynamic predictions. These technologies provide instant feedback on traffic conditions, enabling authorities to adjust signals, reroute traffic, or deploy resources more effectively to alleviate congestion. Moreover, environmental considerations are increasingly shaping traffic forecasting practices. Cities are striving to reduce carbon emissions and promote sustainable transportation options such as public transit, cycling, and walking. Traffic forecasts help assess the impact of these initiatives on overall
