The historical sales for a certain model of a single serve coffee maker at a specialty cookware store in units is: January, 22; February, 17; March, 18; April, 24; May, 16, and June, 15. Use single exponential smoothing with α = 0.2, and compute the exponential smoothing forecasts for February through June. Do not round intermediate calculations. Round your answers to two decimal places.
| Month | Observation | Forecast |
| January | 22 | 22 |
| February | 17 | |
| March | 18 | |
| April | 24 | |
| May | 16 | |
| June | 15 |
α = 0.2
1-α = 1-0.2 =0.8
Fn = (An-1*α )+(Fn-1*(1-α))
| Month | Observation | Calculation | Forecast |
| January | 22 | 22 | 22 |
| February | 17 | =22*0.2+22*0.8 | 22 |
| March | 18 | =17*0.2+22*0.8 | 21 |
| April | 24 | =18*0.2+21*0.8 | 20.40 |
| May | 16 | =24*0.2+20.40*0.8 | 21.12 |
| June | 15 | =16*0.2+21.12*0.8 | 20.10 |
The historical sales for a certain model of a single serve coffee maker at a specialty...
1. The president of a small manufacturing firm is concerned about the continual growth in manufacturing costs in the past several years. The data series of the cost per unit for the firm’s leading product over the past 8 years is as follows: Year Cost/Unit ($) Year Cost/Unit ($) 1 18.00 5 27.00 2 22.50 6 28.00 3 30.00 7 36.00 4 26.00 8 35.00 Develop a simple linear regression model for these data. What average cost increase has the...
The historical demand for a product is as follows: Month Demand January 12 February 11 March 15 April 12 May 16 June 15 Stating any assumptions that you make answer the following questions. (i) Using a weighted moving average with weights of 0.60 for June; 0.30 for May and 0.10 for April, find the July forecast. (4 marks) (ii) Using a simple three-month moving average, find the July forecast. (4 marks) (iii) Using simple exponential smoothing with α=0,2 and a...
The monthly sales for Yazici batteries were as follows on January 21, February 20, March 16, April 15.May 15,June 18,July 17,August 18, September 22, October 20, November 21, December 24. forcast for the next month (Jan) using the naive method. The forecast for the next period (Jan) using the 3-month moving approach. Using smoothing with a=0.30 and a September forecast of 18.00 the forecast for the next period (Jan) sales.
she e A O AoCE A Cd Aaßbo AabCc T H Rp E Question 4 (20%) Historical demand for a product is Demand January February 11 March 12 15 April May June 12 16 15 a) Using a weighted moving average with weights of 0.60, 0.30 and 0.10, find the July forecast b) Using a simple three-month moving average, find the July forecast. c) Using single exponential smoothing with a 0.2 and a June forecast 13, find the July forecast....
1. Using and exponential smoothing model, the forecast for next January sales is: Sales January 100 February 200 March 150 April 400 May 300 June 200 July 250 August 350 September 400 October 350 November 400 December 500 a. 150.0 b. 477.3 c. 450.0 d. Not enough information is given to make a forecast 2. Apply regression to the data shown below. The slope of the line estimated using the regression model is: Sales January 100 February 200 March 150...
Please help. Im stuck on the exponential smoothing part of this problem. Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 110 February 130 March 150 April 170 May 160 June 180 July 140 August 130 September 140 a. Forecast April through September using a three-month moving average. (Round your answers to 1...
Please help with questions 7 - 10.
PART IV Planning and Controling Operations and Supply Chains 290 period 1 was 250. Plot the results. Which model appears to work better? Why? 10. After graduating from college, you and your friends start selling birdhouses made from recycled plast has caught on, as shown by the following sales figures For problems 4 through 6, use the following time series data: The idea DEMAND MONTH January 2012 February March April May June 119...
1. For the data below: Automobile Battery Sales 20 21 15 14 13 16 Automobile Battery Sales 17 18 20 20 21 23 Month Month anuary ebruary March pril May uly ugust eptember tober November une ecember a. Develop a three-month moving average b. Compute MAD Q.2 Usesimple exponential smoothing with a 0.33 to forecast the tire sales for February through May. Assume that the forecast for January was for 22 sets of tires Solve these both Qs Displaying 1...
Historical demand for a product is as follows: DEMAND April 59 May 54 June 74 July 59 August 79 September 74 a. Using a simple four-month moving average, calculate a forecast for October. (Round your answer to 2 decimal places.) Forecast for October b. Using single exponential smoothing with α = 0.30 and a September forecast = 64, calculate a forecast for October. (Round your answer to 2 decimal places.) Forecast for October c. Using simple linear regression,...
The past sales history for Store 10 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years. Report the MAPE value for the better of the two forecasts. That is, if the original trend projection forecast was better according to MAPE, then report that MAPE value. If however, the Re-Seasonalized forecast is better according to MAPE, then report the MAPE value for that forecast. Month Year Period Store 10 January 1 1...