2. The use of quarterly data to develop the forecasting model Yt = a +bYt−1 is an example of which forecasting technique?…
Forecasting the total revenues for fiscal year 20X5 I will use the moving averages, weighted moving averages, exponential smoothing, and time series regression.…
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?…
Which of the following are (always) true about Naive and Moving Average forecasting methods? II. Moving Average method is not appropriate when there is trend in the data & III. Moving Average forecasts are less responsive to data when n is large…
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…
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…
4.47 City Cycles has just started selling the new Z-10 mountain bike, with monthly sales as show in the table. First, co-owner Amit wants to forecast by exponential smoothing by initially setting February’s forecast equal to January’s sales with α=1. Co-owner Barbara wants to use a three-period moving average.…
1. Sam’s cat hotel operate 52 weeks/yr, 6 days/week , and uses a continuous review…
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…
Ping! Pong! The guns fired in the school. In 1999 April 20 school shooting broke out. Dylan Klebold and Eric Harris were responsible for the deaths of Rachel Scott and other boys and girls. Rachel was the first person to die in the shootings Columbine High School. Rachel was asked if she loved God, she replied and said yes. Dylan Klebold shot her in the head because she said she believed in God. Dylan and Eric planed this attack very well. They put bombs everywhere. They went into the school and shot 12 kids and 1 teacher. Dylan and Eric’s parents should not go to jail for what the kids did.…
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.…