Question

In: Math

​ Using the demand data supplied in the below table, please calculate the following from your company's forecasting perspective.

Using the demand data supplied in the below table, please calculate the following from your company's forecasting perspective. Please use Excel to calculate your forecasting answers, so behind the cells in Excel, there has to be formulas for answering the below questions. Your company wants to forecast the demand for their product, based on the data below 

a) Calculate the simple four-week moving average for weeks 5 through 12 

b) Calculate the weighted three-week moving average using weights of 0.40, 0.40, and 0.20 for weeks 4 through 12 

c) Calculate the exponential smoothing forecast for weeks 2 through 12 using an initial forecast of 4400 units and an alpha of 0.30 

d) Calculate the exponential smoothing forecast plus trend for week2 through 12 using an alpha of 0.10, delta of 0.20, a previous forecast including trend of 4600 units, a previous trend of 120 units 

e) Calculate the MAD and MAPE for all four of the forecasting models. Which forecast method do you recommend and why? 

WeekDemand
14500
24750
35400
45800
56250
66500
77000
87500
97920
108200
118500
128800


Solutions

Expert Solution

milcah answered 2 years ago
Next > < Previous

Related Solutions

Using the data in the table below, calculate the return for investing in the share from...
Using the data in the table below, calculate the return for investing in the share from 1 January to 31 December. Prices are after the dividend has been paid Date Price Dividend     Jan 1 $31.53 − Feb 5 $31.11 $0.22 May 14 $30.67 $0.18 Aug 13 $31.78 $0.21 Nov 12 $37.95 $0.22 Dec 31 $40.11 Return for the entire period is ................. ​%. ​(Enter your response as a percent rounded to two decimal​ places.)
1. From the data shown in the table below about demand for smart phones, calculate the...
1. From the data shown in the table below about demand for smart phones, calculate the price elasticity of demand (using the arc method) from: 1.1. Point B to point C 1.2. Point D to point E 1.3. Point G to point H Classify the elasticity at each point as elastic, inelastic or unit elastic. Points P Q A 60 3,000 B 70 2,800 C 80 2,600 D 90 2,400 E 100 2,200 F 110 2,000 G 120 1,800 H...
Using the data in the table​ below, estimate the demand function for cod.                                                                                                                           ​Price, dollars...
Using the data in the table​ below, estimate the demand function for cod.                                                                                                                           ​Price, dollars per pound ​Quantity, thousand pounds per day 1.90 1.5 1.35 2.2 1.25 4.4 1.20 5.9 0.95 6.5 0.85 7.0 0.73 8.8 Using the Excel trendline option to estimate a linear demand​ function, the linear demand function is Qequals=12.53 minus 6.25 p12.53−6.25p. Suppose the quantity in the first row of the table were 22 instead of 1.5. The linear demand function would now be Qequals=nothingminus−nothingp....
Using the data in the​ table, calculate the return for investing in the stock from January...
Using the data in the​ table, calculate the return for investing in the stock from January 1 to December 31. Prices are after the dividend has been paid. Date Price Dividend   Jan 1 $ 34.96 minus Feb 5 $ 30.19 $ 0.21 May 14 $ 28.61 $ 0.19 Aug 13 $ 32.06 $ 0.21 Nov 12 $ 37.48 $ 0.18 Dec 31 $ 42.57 minus Return for the entire period is nothing​%. ​(Round to two decimal​ places.
USING MATLAB: Using the data from table below fit a fourth-order polynomial to the data, but...
USING MATLAB: Using the data from table below fit a fourth-order polynomial to the data, but use a label for the year starting at 1 instead of 1872. Plot the data and the fourth-order polynomial estimate you found, with appropriate labels. What values of coefficients did your program find? What is the LMS loss function value for your model on the data? Year Built SalePrice 1885 122500 1890 240000 1900 150000 1910 125500 1912 159900 1915 149500 1920 100000 1921...
Using the following 8 weeks of demand data to determine the best forecasting method. Compare 3...
Using the following 8 weeks of demand data to determine the best forecasting method. Compare 3 period simple moving average, 3 period weighted moving average and exponential smoothing. Week Sales 1 133 2 137 3 145 4 146 5 150 6 124 7 135 8 130 a) What is the MAD using the 3 period simple moving average (SMA) method b) What is the forecast for Week 9 using the 3 period simple moving average forecasting method? c) What is...
Using the table below calculate the missing values.
Using the table below calculate the missing values.YearNominal GDPReal GDPGDP Deflator1 (2007)3,753____________812 (2008)4,5515,009____________3 (2009)5,150____________100.004 (2010)5,6665,255____________5 (2011)____________6,175          158Enter the missing values : the inflation/growth rates as indicated below.Inflation rate year 1-2 ____________Inflation rate year 3-4 ____________Real growth rate yr. 2-3 ____________Real growth rate yr. 4-5 ____________
3 - From the following data about the demand for dishwashers, calculate the elasticity of demand...
3 - From the following data about the demand for dishwashers, calculate the elasticity of demand from point A to B, from point C to D and from point E to point F. Classify the elasticity as elastic, inelastic or unitary elastic. Also calculate the total revenue of each point. What happens to total revenue as you approach unitary elasticity? If cost were not an issue what price would you choose for your selling price? Point Price In Dollars Quantity...
Use data from the table below to calculate the equilibrium constants at 25 ∘C for each...
Use data from the table below to calculate the equilibrium constants at 25 ∘C for each reaction. Standard Thermodynamic Quantities for Selected Substances at 25∘C Substance ΔH∘f(kJ/mol) ΔG∘f(kJ/mol) S∘(J/mol⋅K) H2(g) 0 0 130.7 N2(g) 0 0 191.6 Br2(g) 30.9 3.1 245.5 Cl2(g) 0 0 223.1 NO2(g) 33.2 51.3 240.1 N2O4(g) 9.16 99.8 304.4 NH3(g) -45.9 -16.4 192.8 P4(g) 58.9 24.4 280.0 PH3(g) 5.4 13.5 210.2 Part A 2NO2(g)⇌N2O4(g) Find K Part B Br2(g)+Cl2(g)⇌2BrCl(g) ΔG∘f for BrCl(g) is -1.0 kJ/mol Find...
The table below summarizes data from a survey of a sample of women. Using a 0.05...
The table below summarizes data from a survey of a sample of women. Using a 0.05 significance​ level, and assuming that the sample sizes of 900 men and 400 women are​ predetermined, test the claim that the proportions of​ agree/disagree responses are the same for subjects interviewed by men and the subjects interviewed by women. Does it appear that the gender of the interviewer affected the responses of​ women? Gender of Interviewer Man Woman Women who agree 619 314 Women...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT