Before you start with your final assignment, please read the provided guidance! This can be found at the end of the attached case study and below.
The analysis required for this assessment can be divided into three parts. First, you need to create a model that forecasts passenger and freight demand for the different scenarios, using all the relevant information provided by the case study. Secondly, you need to utilise (and adjust when necessary) the demand forecasts in order to estimate the likely revenues for the three options that Midlands Rail is considering, again taking into account the different demand scenarios. Thirdly, you need to make adjustments to your primary data as necessary and carry out the required sensitivity analysis.    
This assignment has two outputs: the Excel model that you used to set out and explore the decision problem and a report that summarises your findings.
Of the two, the output that carries the most weight is the Excel model. The model should be clear to follow and have a clear audit trail. Remember to use best practice:
clear formatting,
label your inputs and outputs,
don’t be afraid to add notes,
no hardcoded values,
document your assumptions and your logic,
keep your data separate from your calculations
have a separate area to document important outputs.
The report should either be a Word document or a PowerPoint presentation (I have no preference). The written output should describe and analyse the forecasting and decision problem, describe your modelling process and the criteria you used for the analysis, summarise any interesting findings from your analysis and present your recommendations. As with your first assessment, your focus should mainly be on the results of your analysis and your recommendations, but you should also be able to provide a convincing case for your forecast.
This is a technical piece of writing, so the use of tables and/or charts to summarise and present data is required. Use a readable font and neutral colours and always keep readability in mind. There is no word limit for the report but it should not exceed 6 pages (including tables and graphs, but excluding title page and table of contents); if you opt to produce a PowerPoint presentation instead, it should not go above 10 pages (again, including tables and graphs, but excluding title page and table of contents).