Trend projection with regression forecast:
>> Exponential
Both MAD and MAPE are lower for trend projection with regression. It is the best method in both the cases
Answer all parts please :) A convenience store recently started to carry a new brand of...
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to detemine whether it should continue another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing (let 0.4 with an initial forecast for week 1 of 577) methods to forecast demand for week 13. Compare these methods by using the mean absolute deviation and mean...
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing (let alpha α=0.4with an initial forecast for week 1 of 567) methods to forecast demand for week 13. Compare these...
i. Find the forecast for week 13. ii. Now obtain the exponential smoothing forecast for the weeks. A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing (let a =...
Complete PART (b) ONLY. Please use answer from Part (a). Please complete this using EXCEL; SHow the steps/ excel calculations. Month Actual Demand 1 62 2 65 3 67 4 68 5 71 6 73 7 76 8 78 9 78 10 80 11 84 12 85 part (a) MY answer to Part (a): Part (b) (b) Now calculate all the measures of forecasting accuracy listed below for the single exponential smoothing forecast completed in part (a) -i) MAPE (Mean...
please answer part 2 of C Storrs Cycles has just started selling the new Cyclone mountain bike, with monthly sales as shown in the table. Month Sales Jan 400 Feb 380 Mar 414 Apr 365 a) Based on the given monthly sales data, it can be said that there is not a strong linear trend in sales over time. b) First, co-owner Bob Day wants to forecast by exponential smoothing by initially setting February's forecast equal to January's sales with...
Community Federal Bank in Dothan, Alabama, recently increased its fees to customers who use employees as tellers. Management is interested in whether its new fee policy has increased the number of customers now using its automatic teller machines to that point that more machines are required. The following table provides the number of automatic teller transactions by week. Use trend projection with regression to forecast usage for weeks 13minus16. Period 1 2 3 4 5 6 7 8 9 10...
Problem II The following time series shows the sales of a clothing store over a 10-week period. Week Sales ($1,000s) 15 a. Compute a 4-week moving average for the above time series. b. Compute the mean square error (MSE) and mean Absolut deviation (MAD) for the 4. week moving average forecast. c. Use a -0.3 to compute the exponential smoothing values and MSE and MAD for the time series. d. Forecast sales for week 11. e. Which model is the...
1. Regression is always a superior forecasting method to exponential smoothing, so regression should be used whenever the appropriate software is available. (Points :1)TrueFalse2. Time-series models rely on judgment in an attempt to incorporate qualitative or subjective factors into the forecasting model. (Points : 1)TrueFalse3. A trend-projection forecasting method is a causal forecasting method. (Points : 1)TrueFalse4. Qualitative models attempt to incorporate judgmental or subjective factors into the forecasting model. (Points : 1)TrueFalse5. The naive forecast for the next period...
question 3 View 9/08/2010 B C Date D A 09/03/2010 09/07/2010 09/08/2010 09/09/2010 09/10/2010 09/13/2010 2 B C 127.88 Stock Exchange 3 18.42 20.95 125.76 15.54 18.06 10390.38 10434 81 20.57 15.36 15.74 15.85 15.92 126.44 17.98 20.58 10326.59 10315.28 126.35 17.85 20.51 127.66 17.89 20.58 10374.84 130.84 18.72 21.15 16.13 10632.82 129.46 09/14/2010 21.24 1044131 10570.39 10569.85 10697 94 10778.19 18.64 16.19 16.26 18,73 21.47 21.87 09/15/2010 128.56 16.26 19.03 130,67 09/16/2010 16.28 22.04 18.77 129.89 09/17/2010 16.71 21.91...