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


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 Weighted Average Forecasting model and the information below, calculate the demand forecast for Period...
Using the Weighted Average Forecasting model and the information below, calculate the demand forecast for Period 19. Please Show Work Week Number 10 11 12 13 14 15 16 17 18 Weight 0 0 0 5% 10% 10% 20% 25% 30% Cases Shipped 2,500 2,650 2,325 2,200 2,700 2,750 2,900 2,850 2,925
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....
Task: The below table shows socio-economic data of two fictitious countries. From the perspective of a...
Task: The below table shows socio-economic data of two fictitious countries. From the perspective of a business considering the possibility of undertaking business in these countries, consider what the data could mean and present three conclusions. Each conclusion should compare both countries using at least two variables. You can relate each conclusion to any type of international business (eg. you can present a conclusion from the perspective of a business choosing a new export market, a business seeking an import...
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...
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...
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 ____________
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT