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 |
April | 400 |
May | 300 |
June | 200 |
July | 250 |
August | 350 |
September | 400 |
October | 350 |
November | 400 |
December | 500 |
a. 50.0
b. 45.3
c. 27.3
d. 15.4
Q1) To find the exponential smoothing forecast, smoothing constant (alpha) value is also required
In the question, alpha is not given. Therefore, there is no enough information to solve
Ans:d. not enough information is given to make a forecast
Q2)
Slope is C. 27.3
1. Using and exponential smoothing model, the forecast for next January sales is: Sales January 100...
(CO 3) Using the following information regarding actual sales for Sam’s Ski Supplies, project sales for March of Year 3 using simple linear regression. Sales for Sam’s Ski Supplies ($000s) Month First Year Second Year January 380 400 February 340 360 March 320 330 April 280 290 May 265 270 June 230 235 July 220 230 August 200 205 September 210 220 October 250 270 November 400 450 December 450 502 Group of answer choices 326.94 330.28 328.61 308.62
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...
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.
690 The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The owner has accumulated the following data on demand for unleaded gasoline from sales during the past 12 months: Month Gasoline Demanded (gal.) October 800 November 725 December 630 January 500 February 645 March 730 May 810 June 1,200 980 August 1,000 September 850 e. Compute linear trend line...
Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 330 285 February 450 385 March 455 355 April 455 410 May 410 440 June 435 350 July 400 390 August 310 300 September 355 395 October 480 November 555 December 540 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third...
PYHTON Try! Consider a dictionary for the month months Dictionary = { 1 : "January", 2 : "February", 3 : "March", 4: "April", 5 : "May", 6 : "June", 7 : "July", 8: "August", 9 : "September", 10 : "October", 11: "November", 12 : "December" } . Prints out all the items, both key and value, in the dictionary Prints out all the keys in the dictionary Prints out just the values in the dictionary Loops though using the keys...
Using exponential smoothing of the data, forecast the sales for the month of July. actual sale: March 1,210 April 1,280, May 1,260 June 1,275 Forecast April 1,240 Alpha 0.20
The past sales history for Store 7 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years. Report the MAD value for the re-seasonalized forecast. Month Year Period Store 7 January 1 1 54483 February 1 2 66981 March 1 3 87332 April 1 4 90292 May 1 5 82586 June 1 6 78925 July 1 7 68756 August 1 8 58782 September 1 9 32654 October 1 10 33480 November...
The past sales history for Store 7 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years. Report the MAD value for the re-seasonalized forecast. Month Year Period Store 7 January 1 1 54483 February 1 2 66981 March 1 3 87332 April 1 4 90292 May 1 5 82586 June 1 6 78925 July 1 7 68756 August 1 8 58782 September 1 9 32654 October 1 10 33480 November 1...
Demand 21,520 Period September 2018 October 201823,670 November 2018 December 2018 Period Demand 22,820 March 2018 April 2018 May 2018 23,280 24,490 24,810 June 2018 22,370 25,250 July 2018 August 2018 What is the forecast demand for March 2019 considering trend and seasonality? January 2019 25,990 February 2019 24,260 19,940 20,860 Demand 21,520 Period September 2018 October 201823,670 November 2018 December 2018 Period Demand 22,820 March 2018 April 2018 May 2018 23,280 24,490 24,810 June 2018 22,370 25,250 July 2018...