BB5112 Business Decision Modelling

Assignment Briefing (Level 5)

Module Name

Business Decision Modelling

Module Code

BB5112

Assignment Title

Assignment 2

Type of Submission

Online through Canvas

Weighting of the assignment in the overall module grade

70%

Word Count/Time allocation (for presentations)

No limit

Issue Date

3rd March 2025

Submission Date

17th April 2025

Date of Feedback to Students

17th  May 2025

Where feedback can be found

CANVAS

Employability skills

Professional

Creative

Thoughtful

Resilient

Proactive

Literacy

✔

Communication

✔︎

Critical Thinking

✔︎

Relationship building

✔︎

Adaptability

✔︎

Numeracy

✔︎

Storytelling

✔︎

Critical Writing

✔︎

Networking

✔︎

Commercial Awareness

✔︎

Creativity

✔︎

Soft skills

✔︎

Presentation

✔︎

Problem Solving

✔︎

Teamwork

✔

Digital Skills

✔︎

Project Management

✔︎

How these skills are being developed in this assessment

Through the development of forecasting models to examine both stationary and trended time series. The steps taken will be developed in workshops 代写BB5112 Business Decision Modellingand will result in a mechanism to generate appropriate forecasts associated with supplied datasets accompanied by a comprehensive report. Workshops will involve peer discussion in development of the forecasting models but the submission must be an individual piece of work.

Data Driven Decision Making/Business Decision Modelling. TB2 Assignment 2

Individual Report– Forecasting 

Consider the two time series data sets below in Tables 1 and 2 where n=24 in both series. These datasets are also available on the Assignment Two page on Canvas as dataset1.xlsx and dataset2.xlsx. You are required to do the following:

TASK 1 (15 marks)

Conduct a diagnostic analysis on both datasets. From these diagnostics Identify which time series you think is stationary and which you think exhibits trend and seasonality. You should justify your conclusions with both visual and numerical evidence.

TASK 2 (35 marks)

Using the dataset you feel is stationary carry out the following:
Use the moving average (MA) approach to smooth the data using a moving average of period k = 2, 4, 6 and produce a forecast for period n+1 i.e. period 25. Determine which scheme appears to perform. best;
Use Solver to produce a weighted moving average for k = 2, 4, 6 with weights optimised on both MAPE and RMSE to produce a forecast for period n+1. Which scheme appears to perform. the best?
Compare your results obtained in a. and b. above,
Conduct a similar exercise using exponential smoothing, initially with alpha = 0.2 and 0.8. Then use Solver to optimise the value of alpha based on both MAPE and RMSE to produce a forecast for period n+1. 

TASK 3 (35 marks)

Using the dataset you feel exhibits Trend and Seasonality use an additive decomposition model to:
Extract a seasonal index for each quarter,
Deseasonlise the data for each quarter,
Produce a deseasonalised and seasonalised forecast for each period,
Produce a deseasonalised and seasonalised forecast for periods n+1, n+2, n+3 and n+4,
Plot the actual, deseasonalised and seasonalised data and forecasts on a single graph and comment on the results;

TASK 4  (15 marks)

Consolidate your results in 1 – 3 above into a short report, which should include a critical evaluation of the methods you have used and consideration of the potential impact on business strategy of effective use of the forecasting process.

Instructions

a) Upload two spreadsheets with the solutions for each dataset,
b) Upload a Word document containing your report,
c) The piece of work is individual,
d) The submission date for this assignment is by 23.59 on 17thApril 2025.
WX：codinghelp