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).
As a reminder, this is and individualassessment and the deadline for submission is April 24th, 12 noon.
Final Assignment
Final Assignment
Attached Files:
BN2255_Final Assignment_2015.pdf BN2255_Final Assignment_2015.pdf – Alternative Formats(262.096 KB)
Before you start with your first 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 generate the required forecasts 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. As well as being factually correct, the model should ideally be clearly labelled, have a good ‘flow’ and 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. This is a technical piece of writing, so the use of tables and/or charts to summarise and present data is strongly advisable. 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 8 pages (including tables and graphs); if you opt to produce a PowerPoint presentation instead, it should not exceed 18 slides.
As a reminder, this is and individual assessment and the deadline for submission is 1st May 2015.
Video – Overview of the case study for your final assessement
Video – Overview of the case study for your final assessement
Short video recording here
Final Assessment overview – Long version from the webinar
Final Assessment overview – Long version from the webinar
Marking scheme for the coursework assignments
Marking scheme for the coursework assignments
The Excel model carries 80% weight for your submission. Of that 80%:
70% of the mark relates to your overall implementation, ie whether your model is able to answer the questions of the coursework.
30% of the mark relates to the overall design of your model. The three areas in particular that I look out for are:
model flow
overall model structure and labelling
no hardcoded values
The report carries the remaining 20%. The report is marked on these general categories:
Structure
Content
Use of language
Use of graphs and tables
Good luck!
Marking scheme for the coursework assignments
Marking scheme for the coursework assignments
The Excel model carries 80% weight for your submission. Of that 80%:
70% of the mark relates to your overall implementation, ie whether your model is able to answer the questions of the coursework.
30% of the mark relates to the overall design of your model. The three areas in particular that I look out for are:
model flow
overall model structure and labelling
no hardcoded values
The report carries the remaining 20%. The report is marked on these general categories:
Structure
Content
Use of language
Use of graphs and tables
Good luck!
Final Assignment
Final Assignment
Attached Files:
BN2230_Final Assignment.docx BN2230_Final Assignment.docx – Alternative Formats (27.669 KB)
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).
As a reminder, this is and individualassessment and the deadline for submission is April 26th, 12 noon.
Video – Overview of the case study for your final assessement
Video – Overview of the case study for your final assessement
Short video recording here
Final Assessment overview – Long version from the webinar
Final Assessment overview – Long version from the webinar
Marking scheme for the coursework assignments
Marking scheme for the coursework assignments
The Excel model carries 80% weight for your submission. Of that 80%:
70% of the mark relates to your overall implementation, ie whether your model is able to answer the questions of the coursework.
30% of the mark relates to the overall design of your model. The three areas in particular that I look out for are:
model flow
overall model structure and labelling
no hardcoded values
The report carries the remaining 20%. The report is marked on these general categories:
Structure
Content
Use of language
Use of graphs and tables
Good luck!
