2. The use of quarterly data to develop the forecasting model Yt = a +bYt−1 is an example of which forecasting technique?…
Forecast personnel expenses for fiscal year 20X5 using moving averages weighted moving averages, exponential smoothing, and time series regression. For moving averages and weighted moving averages, use only the data for the past three fiscal years. For weighted moving averages, assign a value of 1 to the data for 20 X 2, a value of 2 to the data for 20 X 3, and a value of 3 to the data for 20 X 4. For exponential smoothing, assume that the last forecast for fiscal year 20 X 4 was $6,300,000. You decide on the alpha to be used for exponential smoothing. For time series regression, use the data for all four fiscal years. Which forecast will you use? Why?…
To obtain a forecast for the first quarter of 2009 using the model, which of the following sets of values should be used in the regression equation? A. X = 12, Q1 = 0, Q2 = 0, Q3 = 0 B. X = 13, Q1 = 0, Q2 = 0, Q3 = 0 C. X = 13, Q1 = 1, Q2 = 0, Q3 = 0 D. X = 12, Q1 = 1, Q2 = 0, Q3 = 0 16-5.To obtain a forecast for the fourth quarter of 2009 using the model, which of the following sets of values should be used in the regression equation? A. X = 16, Q1 = 1, Q2 = 0, Q3 = 0 B. X = 16, Q1 = 0, Q2 = 0, Q3 = 0 C. X = 15, Q1 = 1, Q2 = 0, Q3 = 0 D. X = 15, Q1 = 0, Q2 = 0, Q3 = 0 16-6. Using the regression equation, which of the following values is the best forecast for the number of contracts in the third quarter of 2009? A. 133352 B. 421697 C. 49091 D. 1482518 Note. The derivation of chi-squared statistic (approximation) Let O1 ~ b(n, p1 ), where 0 p1 1. According to the Central Limit Theorem, O1 np1 d Z N(0,1) np1 (1 p1…
2. The company determine their actual demand based on historical forecast errors. The historical forecast errors were computed for each item in the previous year and the frequency of these errors. The frequency of past forecast errors was used as a probability distribution for the future errors. For example, in the past year, if there were 50% of the forecast errors for “new” items were between 0.7 and 1.6. Then the company can assumed that the forecast errors for “new” item in the current year also would be between 0.7 and 1.6 with the possibility 50%. If the frozen forecast for an item is 1000 units, we can assume that with the probability 50%, the actual demand of the item would fall between 700 and 1600 units.…
2. Use the provided Excel file that contains demand and forecast data for a collection of items.…
The intercept of the trend line is 8.714, and the slope is 0.75. What is the forecast for period 8?…
Read the M & L Manufacturing case on page 126 in your text. Prepare a weekly forecast clearly labeling your calculations. Explain the benefits of a more formalized approach to forecasting using course related principles in 200 words. You…
The following shows the plot for Forecast by 3 MA, 5MA and Exponential Smoothing, 0.1…
11) To improve future analyst forecasts using the statistical properties of past forecasts, a regression model can be fitted to past forecasts. The intercept of the regression is a ______ coefficient, and the regression beta represents a…
3. Assume that May’s actual sales figure turns out to be 405. Complete the table’s columns and then calculate the mean absolute deviation for both Amit’s and Barbara’s methods.…
1. Sam’s cat hotel operate 52 weeks/yr, 6 days/week , and uses a continuous review…
Use the sales forecaster’s predication to describe a normal probability distribution that can be used to approximate the demand distribution. Sketch the distribution and show its mean and standard deviation.…
9) If we want to obtain the exponential smoothing time-series for forcasting, what would be the valus of F4 (use a=0.4)? A) 40.2 B) 45 C) 37 D) 41.8…
PROBLEM 4.1 A) (374 + 368 + 381) / 3 = 374.33 Pints B) Forecast: (381 x .1) = 38.1 (368 x .3) = 110.4 (374 x .6) = 224.4 38.1 + 110.4 + 224.4 = 372.9 Pints C) Week Of Pints Used Forecast with exponential smoothing applied 31st Aug 360 360.00 7th Sep 389 360.00 14th Sep 410 365.80 21st…
This report will evaluate the figures collected for the foodhall section of the Leeds store, and compare it to data collected on a new development, Toys and Games to see which could provide a greater value to the company. After evaluating the figures we will draw conclusions on which choice would be best for the company to take and provide evidence why.…