Question: Burger analysis by making a four months moving average a four month weighted moving average and and exponential smoothing alpha Actual 4 Month MA 4

Burger analysis by making a four months moving average a four month weighted moving average and and exponential smoothing

alpha
Actual 4 Month MA 4 Month Weighted MA Exp. Smoothing
Date Hamburger Forecast Deviation Absoluted Deviation Weights Forecast Deviation Absoluted Deviation Hamburger Deviation Absoluted Deviation
Jan-18 1474 0.1
Feb-18 1195 0.15
Mar-18 1296 0.25
Apr-18 1194 0.50
May-18 1299
Jun-18 819
Jul-18 691
Aug-18 869
Sep-18 1168
Oct-18 1314
Nov-18 1373
Dec-18 1340
Jan-19 2052
Feb-19 1680
Mar-19 1747
Apr-19 1750
May-19 1806
Jun-19 1054
Jul-19 884
Aug-19 1056
Sep-19 1647
Oct-19 1850
Nov-19 1788
Dec-19 1863
Jan-20 1176
Feb-20 940
Mar-20 1000
Apr-20 949
May-20 958
Jun-20 736
Jul-20 596
Aug-20 593
Sep-20 966
Oct-20 1007
Nov-20 1020
Dec-20 1099
Jan-21 1599
Feb-21 1404
Mar-21 1586
Apr-21 1461
May-21 1366
Jun-21 977
Jul-21 730
Aug-21 895
Sep-21 1412
Oct-21 1472
Nov-21 1554
Dec-21 1675
Jan-22 2163
Feb-22 1934
Mar-22 2096
Apr-22 1899
May-22 1975
Jun-22 1257
Jul-22 927
Aug-22 1183
Sep-22 1944
MAD MAD MAD

alpha value is 0.5

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!

Q:

options for C: a 3 month moving average a 6 month weighted moving average exponential smoothing the naive method a trend projection The monthly sales for Yazici Batteries, Inc., were as follows: This...

Q:

Copy analysis for month moving average four month weighted moving average and exponential smoothing Alpha Actual 4 Month MA 4 Month Weighted MA Exp. Smoothing Date Coffee Forecast Deviation Absoluted...

Q:

Data AutoSave ") : File Home Insert Draw Page Layout Formulas Calibri 11 A N E . BIU. . A. . Format Painter OSCM3503_Assignme Review View Help Seal . Wrap Text General Merge & Center $ % X cut Copy...

Q:

Use data in worksheet Time Series. Plot the data for each store. Develop a sales forecast for each of the 10 stores for the month of December, using: A three month moving average A 2- month weighted...

Q:

The following table shows Eagle Bee's monthly sales volumes: Actual Sales Volume January February March April May June July August September October November December 5000 8000 7000 3500 4000 4000...

Q:

You have taken over the finance function of a large and successful outdoor gear store that sells primarily camping equipment such as tents, cooking gear, backpacks, and other smaller items. The owner...

Q:

DO NOT TYPE ANYTHING IN THE BLUE AREA!!! Chapter 3 This problem is based on 813 on page 83, but has been modified. Answer the questions I have raised! Demand Month March April May June July August...

Q:

A-Below are the forecasts and actual demands for the first three months. What is the Mean Absolute Deviation (MAD) for these three months? Month 1 Month 2 Month 3 Forecast 15 16 25 Actual 15 18 25...

Q:

Penz, Inc. Penz, Inc. is a pen manufacturer specializing in colored pens. Located in Denver, CO., Penz has grown successfully over the past few years because of the addition of a new general manager,...

Q:

Penz, Inc. Penz, Inc. is a pen manufacturer specializing in colored pens. Located in Denver, CO., Penz has grown successfully over the past few years because of the addition of a new general manager,...

Q:

Mr. Li, a Chinese citizen, is an employee in NICE company. Mr. Li had the following income for the month of January 2019: (1) Monthly employment income from NICE company is RMB 14,500, and a bonus...

Q:

Explain the concept of the Cauchy-Riemann equations and describe how they are used to determine if a complex function is differentiable and holomorphic. Provide examples to illustrate your...

Q:

Which of the following is associated with the concept of the 'Ypahal turn' in the social sciences and humanities? A if placed a greater emphasis on space and place in subjects other than geography. B...

Q:

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...