What is the demand forecast for May if you use a 3 month moving average based...
|
What is the demand forecast for May if you use a 3 month moving average based on the following forecast and actual demand data?
|
12
11
10.67
11.67
Homework Answers
Forecast of March = {F(Feb) + F(March) + F(April)}/3
= (11 + 12 + 12)/3
= 35/3
= 11.67
Add Answer to:
What is the demand forecast for May if you use a 3
month moving average based...
Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average...
Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average values. Forecast and plot the upcoming period’s sales using the moving average series that fits best. Explain why you chose that particular MA. Why is it inadvisable to use the Moving Average approach to forecast far into the future? Month Sale Month Sale Month Sale Oct-12 13.30 Oct-13 24.01 Oct-14 50.56 Nov-12 1.70 Nov-13 32.67 Nov-14 60.06 Dec-12 11.44 Dec-13 23.19 Dec-14 61.73 Jan-13...
Given the following history, use a three-quarter moving average to forecast the demand for the third...
Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, Dec. JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Last year 170 200 210 240 250 270 225 215 215 275 280 300 This year 205 210 140 255 245 220 Forecast...
What is the forecast for July using a four-month moving average? DEC 96 APR 46 JAN...
What is the forecast for July using a four-month moving average? DEC 96 APR 46 JAN NIOOW 39 40 FEB 42 MAR 48
This is a table to show how to calculate a three-month moving average. Please use this...
This is a table to show how to calculate a three-month moving average. Please use this same data to calculate a four-month moving average. ACTUAL SHED SALES 10 12 13 16 19 23 26 30 28 18 16 MONTH 3-MONTH MOVING AVERAGE January March (10+ 12 + 13)3 -11.67 (12 13+ 16/3-13.67 (13 + 16 + 19)/3# 16.00 (16 + 19 +23Y3- 19.33 19 +23 + 26V3-22.67 (23+26 +30/3-26.33 (26+30 +28)V3-28.00 (30 +28 + 18/3-25.33 (28 + 18 + 163-20.67...
What is the forecast for May using a four-month moving average? Nov. Dec. Jan. Feb. Mar....
What is the forecast for May using a four-month moving average? Nov. Dec. Jan. Feb. Mar. April 29 26 30 32 38 36 38 34 33 32 Please explain how to arrive at the correct answer. Thanks a lot Step by step would be great.
Question 1 Calcuate a five-period moving average forecast for June Period Actual Forecsat Jan 545 Feb...
Question 1 Calcuate a five-period moving average forecast for June Period Actual Forecsat Jan 545 Feb 567 Mar 568 Apr 561 May 476 June
ASSIGNMENT 2 (CLOI: PLO1: C3) 1. Based on the data given below, Month Demand Jan Feb...
ASSIGNMENT 2 (CLOI: PLO1: C3) 1. Based on the data given below, Month Demand Jan Feb Mac Apr May Jun Jul Aug Sep Oct Nov Dec 37 40 41 37 4550434756 52 55 54 a) Calculate 4-period and 5-period moving average and forecast the demand in January next year. Which forecast gives the manager the best decision to use as (12 marks) b) the estimate for expenditure of a typical supplier. By giving your answers in 2 decimal places, forecast...
Use the following sales data to answer the questions. Month Sales January 
Use the following sales data to answer the questions. Month Sales January $250,000 February $200,000 March $300,000 April $350,000 May $450,000 Using a two month moving average, what are the expected sales for June? Using a three month moving average, what are the expected sales for June? Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six months are shown below, along with the results of two different...
question asking for moving average .. i used the data analysis tool in excel it gives...
question asking for moving average .. i used the data analysis
tool in excel it gives me the right answer but with wrong in
sequence
The normal Fourmal says = Sum of 3 months / 3 = F for
the 4th month
But in data analysis tool it comes in forecast of the
3rd month
please let me know why it does not come in the right sequence
and how to solve this issue
1 A-F^2 25.61 by using Normal...
Given the following data, what is the Mean Absolute Deviation (MAD): Month Demand Forecast Jan 100...
Given the following data, what is the Mean Absolute Deviation (MAD): Month Demand Forecast Jan 100 110 Feb 100 100 Mar 120 100 Apr 110 90 May 100 110 Jun 90 100 Jul 80 90 Aug 90 80 Sep 100 110 Oct 110 100 Nov 110 110 Dec 120 110 A. 10 B. 20 C. 30 D. 133.33
What is the forecast for July using a four-month moving average? DEC 96 APR 46 JAN NIOOW 39 40 FEB 42 MAR 48
This is a table to show how to calculate a three-month moving average. Please use this same data to calculate a four-month moving average. ACTUAL SHED SALES 10 12 13 16 19 23 26 30 28 18 16 MONTH 3-MONTH MOVING AVERAGE January March (10+ 12 + 13)3 -11.67 (12 13+ 16/3-13.67 (13 + 16 + 19)/3# 16.00 (16 + 19 +23Y3- 19.33 19 +23 + 26V3-22.67 (23+26 +30/3-26.33 (26+30 +28)V3-28.00 (30 +28 + 18/3-25.33 (28 + 18 + 163-20.67...
Question 1 Calcuate a five-period moving average forecast for June Period Actual Forecsat Jan 545 Feb 567 Mar 568 Apr 561 May 476 June
ASSIGNMENT 2 (CLOI: PLO1: C3) 1. Based on the data given below, Month Demand Jan Feb Mac Apr May Jun Jul Aug Sep Oct Nov Dec 37 40 41 37 4550434756 52 55 54 a) Calculate 4-period and 5-period moving average and forecast the demand in January next year. Which forecast gives the manager the best decision to use as (12 marks) b) the estimate for expenditure of a typical supplier. By giving your answers in 2 decimal places, forecast...
question asking for moving average .. i used the data analysis
tool in excel it gives me the right answer but with wrong in
sequence
The normal Fourmal says = Sum of 3 months / 3 = F for
the 4th month
But in data analysis tool it comes in forecast of the
3rd month
please let me know why it does not come in the right sequence
and how to solve this issue
1 A-F^2 25.61 by using Normal...
Most questions answered within 3 hours.
-
After watching the lectures I am still having a hard time
understanding these equations.
1. The...
asked 1 hour ago -
Testing:
H0:μ=56.9
H1:μ<56.9
Your sample consists of 23 subjects, with a mean of 56.3 and
standard...
asked 1 hour ago -
straight wire, labeled as Wire A, lies horizontally on a
tabletop and is oriented to run...
asked 1 hour ago -
For a Chi-Squared Goodness of Fit Test about a uniform
distribution, complete the table.
Round to...
asked 1 hour ago -
Milk of magnesia is only slightly soluble in water. Kc for the
reaction Mg(OHs)(s)>Mg2+(a) + 2OH-1(aq)...
asked 1 hour ago -
Excel's HYPGEOM.DIST function can be used to compute _____.
a. both hypergeometric probabilities and cumulative
hypergeometric...
asked 1 hour ago -
The rocket used for the human lunar missions was the Saturn V
rocket. At liftoff the...
asked 1 hour ago -
1. The East Street Bagel Shop has a weekly demand for 3,500
bagels, which they make...
asked 1 hour ago -
paraphrasing each paragraph
“Where two or more persons knowingly act together unlawfully,
the act of each...
asked 1 hour ago -
The lateral line system in fish is contained which of the
following?
chemoreceptors
photoreceptors
mechanoreceptors
odor...
asked 1 hour ago -
Find the y-intercept of y =-5 x. The y-intercept of y equals
negative 5 x is______...
asked 1 hour ago -
Customers arrive randomly at a gas station at the average rate
of 30 per hour, while...
asked 1 hour ago