i. Three year moving average method ii. Six year moving average method iii. Single exponential smoothing method (smoothing constant = 0.2) iv. Single exponential smoothing method (smoothing constant = 0.05)

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Question 02: 
Following data set indicates the annual electricity consumption of Sri Lanka in Mega Watt Hours 
(MWh) from 1996 to 2022.

Year                   Electricity Consumption in MWh
1996                        1,588
1997                        1,558
1998                        1,753
1999                        1,408
2000                        1,310
2001                        1,424
2002                        1,677
2003                        1,937
2004                        1,685
2005                        1,488
2006                        1,562
2007                        1,619
2008                        1,687
2009                        1,841
2010                        1,865
2011                        1,637
2012                        1,653
2013                        1,699
2014                        1,698
2015                        1,523
2016                        1,557
2017                        1,795
2018                        1,934
2019                        2,125
2020                        2,543
2021                        2,616
2022                        3,191

You are required to forecast the electricity demand of Sri Lanka for the year 2023 using the 
following smoothing methods and recommend the most appropriate value. 
i. Three year moving average method
ii. Six year moving average method
iii. Single exponential smoothing method (smoothing constant = 0.2)
iv. Single exponential smoothing method (smoothing constant = 0.05) 

Expert Solution
steps

Step by step

Solved in 6 steps with 10 images

Blurred answer
Knowledge Booster
Introduction to Forecasting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.