Question: QUESTION 3 Calculate the 3 and 5-year Simple Moving Average for the following data: Annual Demand3 month moving average forecasted demand5 month moving average forecasted

QUESTION 3

Calculate the 3 and 5-year Simple Moving Average for the following data:

Annual Demand3 month moving average forecasted demand5 month moving average forecasted demandforecast error20132752014295201525020162752017325201840020192252020275

Calculate the Mean Absolute Deviation for the forecast error for both the 3- and 5-year calculations.

actual demand3 month moving average forecasted demand5 month moving average forecasted demandforecast error20132752014195201525020162752017325201840020192252020275

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 General Management Questions!

The four-bar mechanism lies in a vertical plane and is controlled by crank OA which rotates counterclockwise at a steady rate of 60 rev /min. Determine the torque M which must be applied to the crank...

Calculate the 3 and 5-month Simple Moving Average for the following data: 2013 2014 2015 2016 2017 2018 2019 2020 3 Month 5 Month Moving Moving Average Average Forecasted Forecasted Forecast Actual...

Assignment #5: Time Series Analysis Simple Moving Average E(most recent k data values) List-k+1 Vi = _yt -k+ 1 + ."+yt-1+yt yt+1 k k k where "t+1 = forecast of the time series for period t + 1 yt =...

A A A AaBbCcDE AaBbCcDdE AO AA EEEEE av Normal No Spacing 10 Points 10 Points 10 Points 10 Points 10 Points What is the difference between qualitative forecasting techniques and quantitative...

Please Answer the first 3 questions, I really need help understanding or getting at least something down for those 3 questions. Please explain as thoroughly as possible (I'm a slow learner). You can...

Forecasting Revenues Project The City of Colorado Springs depends on sales and use tax revenue for t_l_19_r_r_raj9rity_of the General Fund's annual revenue Since the Great Recession of 2008, the city...

1. A company wants to forecast demand using the simple moving average. If the company uses four prior yearly sales values (i.e., year 2014 = 100, year 2015 = 120, year 2016 = 140, and year 2017 =...

** PROBLEM 1 HAS ALREADY BEEN SOLVED AND IS POSTED JUST TO GIVE REFERENCE FOR PROBLEM 2, WHICH IS THE ONE I'M ASKING FOR HELP ON ** THE PROBLEM I NEED ASSITANCE IN: 1. Problem 1 (10pt) DigiSonic has...

ASSIGNMENT 1 (Demand forecasting on Excel) Question 1 A high-tech company wants to forecast the demand for their Kindle e-readers (in 000), based on the data below. (2 marks) Month 1 2 3 4 5 6 7...

ookman be To Water Oral US BTU A Merge Center 5 % ) Com Ce Tomobiles P18 x x F Directions Use the provided worksheets to develop forecast die the the data seting the indicated forecasting methods....

Instructions: Answer all the questions in the homework The number represented in parenthesis, e.g. (2pt) represents two points for the question You are welcome to use excel. Doing so, please take...

Multiple Choice Questions 1. What amount of liability should the city recognize on fund-based financial statements at December 31, Year 1? Assume that all remaining vacations will be taken in July....

The following information about ABC Inc. is useful in answering questions 2018 2019 $ 80,000 $ 95,000 16,000 19,000 75,000 $ 84,000 5,000 $ 11,000 Sales dollars Sales volume (units) Expenses Net...

Which of these is not an advantage of a corporation? Multiple choice question. Greater ability to transfer ownership Greater ability to raise capital Income is taxed only once Limited liability

4. The cost and revenue function for a particular brand of bag are C(x) = 6x + 3 and R(x) = 19 2x. What is the break even point? Please include the complete solution.