Managerial Decision Making

Managerial Decision Making

This individual report will require to you analyse a set of data using the forecasting and linear programming modelling approaches covered in the module. You will be tested both on your ability to apply the correct set of quantitative analytical techniques to a set of forecasting data, but also your ability to diagnose the data, select appropriate models, interpret the output generated and evaluate your analysis appropriately so that the data you produce can be used for future managerial decision making.


Jake Fearne is the owner of Garrett Magazines, which produces two food magazines:
• Tom’s Treats, published monthly and which Jake Fearne thinks the circulation data is stationary
• Cass’s Cakes, published quarterly and which Jake Fearne thinks the circulation data is non-stationary

Circulation data for each magazine is provided in GM Circulation Data.xlsx.

Write a brief report discussing your answers to the tasks below using the GM circulation data and submit your quantitative analysis on a supporting spreadsheet. The aim of this assignment is to model and analyse the data appropriately and interpret your output to provide recommendations to the owner of Garrett Magazines on how to manage the business going forward.

For the Tom’s Treats magazine data:
Task 1: Carry out appropriate diagnostic analysis to confirm whether you agree with Jake Fearne’s conclusion that the data for Tom’s Treats is stationary. Make sure you provide a body of evidence to back up your reasoning.

Task 2: In your spreadsheet, apply the following FOUR updating schemes: Naïve Forecasting, Updating the Mean, Moving Average of Length k and either Weighted Moving Average of length k OR Simple Exponential Smoothing.

In your report, provide a summary table to present the forecast for the next time period under each of the schemes and write a short statement to justify the values you introduce, ie: k, weights, alpha, method of optimisation.

Task 3: Evaluate each updating scheme you have used in task 2 using statistical and graphical analysis. Recommend which one updating scheme should be used to forecast the next time period value. In your discussion explain why you have selected your chosen scheme over the other methods and discuss how suitable you think your model is.

For the Cass’s Cakes magazine data:
Task 4: Carry out diagnostic analysis and build an appropriate model to forecast the circulation data for Cass’s Cakes. Make sure you are clear about which time series components you believe this data exhibits and back up your reasoning with graphical and statistical analysis. Present your forecast for the next time period.

Task 5: Evaluate your model in task 4 using statistical and graphical analysis and discuss any factors that the manager should consider when forecasting data that is exhibiting this/these time series components.

For all magazine data:
Task 6: Given your analysis of Garrett Magazine’s circulation data what factors, issues or developments should Jake Fearne consider for the future?

The marking criteria guidelines are published in advance so you know how you will be judged for this piece of work and are available on Studyspace.

You need to submit two files for this piece of coursework:

1. Written Report
You are required to submit a written report with a maximum word limit of 1250 words. As this is not a formal management report, you are not required to do a summary, introduction etc. Rather, your report should be laid out into sub-sections to reflect the tasks above, although the sections will not be of equal size. The report is for the manager, so keep the audience in mind when you write up your analysis. You should be to the point, supplementing any statements, conclusions or comments with statistics and/or graphs where appropriate. Any graphs or tables used to illustrate a particular point should be included in the main body of your report, labelled clearly and referenced within the text. Remember however, that your report will be marked alongside your spreadsheet so there is no need to include screenshots of the models themselves.

The written report should be submitted online via Turnitin on Studyspace in one document.

2. Supporting Spreadsheet
All of the quantitative analysis eg: diagnostic analysis, application and evaluation of the models, graphs and/or tables you generate, should be included in a separate spreadsheet file organised appropriately. The work in this file will be reviewed alongside your written report so it should be clear what you have done. This means that tables and charts should have headings (especially if you use them in the written report), and tabs in the worksheet named accordingly.

This supporting spreadsheet should be submitted on Studyspace under ‘Spreadsheet Submission’ in the Individual Assignment tab.