will need toight if  possible Project Assignment BUSA 511, Business Analytics for Managers The 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

Chapter 4 Top Religions (online)  Online Individual Activity: Exploring the Top Religions Objective: To facilitate understanding and appreciation

Chapter 4 Top Religions (online)  Online Individual Activity: Exploring the Top Religions Objective: To facilitate understanding and appreciation of the world’s major religions through independent research and reflective writing, enhancing critical thinking and respectful engagement with diverse perspectives. Top Religions (by estimated followers): 1. Judaic Culture 2. Christianity 3. Byzatine

English  ENC 101 ENGLISH COMPOSITION 1 FINAL EXAM ANSWER SHEET

English  ENC 101 ENGLISH COMPOSITION 1 FINAL EXAM ANSWER SHEET Name ____________________________________ Date _________________ Complete all answers on this answer sheet and upload to Blackboard. Verbs (1-10) 1. 6. 2. 7. 3. 8. 4. 9. 5. 10. Punctuation Marks (1-10) 1. 6. 2. 7. 3. 8. 4. 9. 5. 10.

Redo  Required Readings & Resources Kolbert, J., Crothers, L., & Hughes, T. (2022). Introduction to school counseling: Theory, research, and

Redo  Required Readings & Resources Kolbert, J., Crothers, L., & Hughes, T. (2022). Introduction to school counseling: Theory, research, and practice (2nd ed.). ● Chapter 1: “History and Trends in the School Counseling Profession” ● Chapter 2: “Professional Identify of School Counselors and the American School Association National Model (2019)”

Thanks  Required Readings & Resources Kolbert, J., Crothers, L., & Hughes, T. (2022). Introduction to school counseling: Theory, research, and

Thanks  Required Readings & Resources Kolbert, J., Crothers, L., & Hughes, T. (2022). Introduction to school counseling: Theory, research, and practice (2nd ed.). ● Chapter 6: “Individual Counseling” ● Chapter 7: “Group Counseling” Part A-Discussion Topic: Discussion: Counseling Theories in an Academic Setting Discussion: Counseling Theories in an Academic Setting

Shankss Required Readings & Resources Kolbert, J., Crothers, L., & Hughes, T. (2022). Introduction to school counseling: Theory, research, and

Shankss Required Readings & Resources Kolbert, J., Crothers, L., & Hughes, T. (2022). Introduction to school counseling: Theory, research, and practice (2nd ed.). ● Chapter 8: “Consultation and Collaboration” ● Chapter 9: “Academic Development” Part A-Discussion: Engaging with Students Review the Discussion Requirements for this course before responding to the

will need speaker notes Create an 8- to 10-slide PowerPoint presentation discussing your cultural background (in addition, you should include a

will need speaker notes Create an 8- to 10-slide PowerPoint presentation discussing your cultural background (in addition, you should include a title slide and reference slide in your presentation). When discussing your culture, consider components of yourself such as race, ethnicity, religion, spiritual heritage, gender, sexual orientation, disabilities, socioeconomic status, traditions,