will need toight if  possibleProject Assignment BUSA 511, Business Analytics for ManagersThe case

will need toight if  possible

Project Assignment BUSA 511, Business Analytics for Managers

The case

Considering monthly demands for the ABC Corporation as shown below.

Question

Forecast the monthly demands for Year 6 using

moving average
,

simple exponential smoothing
,

Holts’ model
, and

Winter’s model
. In each case, evaluate the bias, TS, MAD, MAPE, and MSE.


Project Assignment Guidance

1. To answer the question above, firstly based on the monthly sales data of Year 1, 2, 3, 4 and 5, you should forecast the 12 monthly demands of Year 6 from January to December using ”

moving average”
, ”

simple exponential smoothing”
, ”

Holts’ model
“, and ”

Winter’s model”, respectively
. Secondly, you should calculate the forecast-error indicators of bias, TS, MAD, MAPE, and MSE regarding these four models. Thirdly, based on your findings, you should identify the best forecasting methods and provide your justifications.

2. Two documents should be submitted for this assignment.

The first
is the Excel file in which the formula, the calculation processes and solutions of the four forecasting methods, and the related forecast-error estimates of bias, TS, MAD, MAPE, and MSE should be given.

The second
is the word file template as report by answering questions asked in the report template. This word file template will be posted on D2L.


(
Note: Sample of the work in excel and Video recording of the tutorial is posted on D2L)

3. The mark weighting of the analysis of the above four forecasting methods will be listed in the report template posted on D2L.

4. The submission deadline is stated on D2L page for the course.

5. You should submit e-copy of your assignment (word-format report with Excel file(s), through the submission portal on D2L (no hard copy needed)

2

image1.emf

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Policy Analysis #2 (250 points)PH 528 Final ExamGraduate

Policy Analysis #2 (250 points) PH 528 Final Exam Graduate Students Only Introduction: State Representative Joey Hood (Mississippi District 35) is the chairman of the Mississippi State House of Representatives Medicaid Committee. In 2022, the House let a measure die without a vote that would have allowed pregnant women who

 Discuss the classification of reverse logistics components and definitions of reverse logistics components in the reading. The types or processes

 Discuss the classification of reverse logistics components and definitions of reverse logistics components in the reading. The types or processes listed and the descriptions in the textbook provide insight. Paraphrase, and cite/reference material from the class reading and library articles (for elaborating in the participating posts). Consider the components the

 Course Project 2Tesla CompanyIsdory Lyamuya DeVry University BUSN412 Professor: Jasmine McKinney February 8, 2025

 Course Project  2 Tesla Company Isdory Lyamuya DeVry University BUSN412 Professor: Jasmine McKinney February 8, 2025 Porter’s Generic Strategies Porter’s Generic Strategies help Tesla secure and maintain a competitive position throughout the electric vehicle (EV) sector. Tesla implements a differentiation strategy through its advanced EVs that combine exceptional performance capabilities,

Need Liife Rewound Project: Character Timeline Create a detailed timeline or storyboard showcasing the key moments in the character’slife

Need  Liife Rewound Project: Character Timeline Create a detailed timeline or storyboard showcasing the key moments in the character’s life journey, working backward from their death to their birth. Each stage of the character’s life will be visually represented, accompanied by annotations or descriptions highlighting important events and developmental milestones.

Policy Analysis Section 4- Final Draft (100 points)

Policy Analysis Section 4- Final Draft (100 points) PH 528 Introduction: State Senator Hob Bryan (Mississippi District 7) is the chairman of the Mississippi State Senate Public Health and Welfare Committee. Now that the state legislature has passed a bill legalizing medical marijuana use in the state, members of the

Assignment #5PH 528Directions: Read the “Incarceration

Assignment #5 PH 528 Directions: Read the “Incarceration Case Study”, which outlines policy efforts to address public health in prisons and among incarcerated populations. Respond to the following questions, with each response a minimum of 150 words. Due Date: Upload your assignment to Blackboard as a .doc or .docx file