Question: i) Build a forecast with 4-day moving average, ii) Model a forecast using exponential smoothing method with smoothing constant equal to 0.6, iii) Compute Root

i) Build a forecast with 4-day moving average,

ii) Model a forecast using exponential smoothing method with smoothing constant equal to 0.6,

iii) Compute Root Mean Squared Error (RMSE) and identify which of the two methods produces a forecast with better accuracy.

Day Sales

1 1735

2 1719

3 2025

4 1295

5 717

6 4317

7 2681

8 2669

9 6273

10 2049

11 2585

12 4895

13 2057

14 6955

15 2239

16 2369

17 6889

18 1697

19 309

20 715

21 5231

22 1503

23 1457

24 1785

25 2041

26 249

27 747

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

For the data listed below, conduct following in Excel i) Create a forecast with 4-day moving average, ii) Create a forecast using exponential smoothing method with smoothing constant equal to 0.6,...

1 . ( i ) One person using a hammer will take 5 days to nail new shingles on the roof of a 3 0 0 m 2 house. ( ii ) Two persons using a hammer but working together ( one holds a shingle, the other...

Stowe Automotive is considering an offer from the country of Indula to build a plant making automotive parts for use there. In preparation for a nal decision, Stowe's economists have been hard at...

Fill in the blanks. Choose the answers here from questions 1-10. Forecast Cyclical pattern Moving averages method Time series Forecast error Exponential smoothing Stationary time series Mean absolute...

please use excel and show formulas! thank you! 1. (2 points) Compute the moving-average forecast for the data in forecast data.xlsx, with a 3-day window. What is the forecast for 1/2/2016 ? 2. (2...

Forecasting Ticket Sales at Cineplex The Cineplex is a large cinema complex in Ottawa. The complex has 18 screens and a total of 4620 seats. Ticket sales vary from day to day but are generally higher...

* * * There are a total of 7 questions, I would be very happy if you could help me solve them all separately in an explanatory way? 1 ) Demand for heart transplant surgery at a hospital has decreased...

Please solve all. Part I. Answer the following 40 questions on the Scantron answer sheet by marking the appropriate bubble using a pencil. Use HB Pencils Only. Make dark marks. Erase any incorrect...

Please Answer Asap Thank you! A30. SUPPLEMENT A SPREADSHEET MODELING: AN INTRODUCTION Problems 1. Kaizer Plastic produces a variety of plastic items for pack Soek can work only with a single "Set...

How is the political environment likely to change during the future? Give one example and relate its significance to multinationals.

Suppose someone wants to accumulate $70,000 for a college fund over the next 15 years. Determine whether the following investment plans will allow the person to reach the goal. Assume the compounding...

Which one of the following is correct for stock issued under a firm commitment where the underwriter is to receive a spread of 8 % ? The underwriter must sell at least 9 2 % of the shares. The...

Please answer this without copy from website thanks ! a. Describe the purpose of the following documents: i. Bill of Materials (BOM) ii. Route Sheet (RS) iii. Materials Requisition (MR) iv. Work...

7. What is the extent (percentage) of errors detected in the information collected?

8. What are the costs of collecting the information?

6. How great is the time-lag between when an event occurs until we get information about it?