Given is a historical time series for job services demand in the prior 6 months. Month...

Question

Question

Given is a historical time series for job services demand in the prior 6 months. Month...

Given is a historical time series for job services demand in the prior 6 months. Month Demand 1 625 2 734 3 711 4 603 5 668 6 785 The Period 6 forecast by using weighted moving average with weights of 0.05, 0.25, 0.40, and 0.30 = (in 2 decimal places)

business Operations-Management

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Forecast = Sigma(weight for period N * Demand for period N) / Sigma(weights)

FORECAST 6 = (0.05 * 734) + (0.25 * 711 ) + (0.4 * 603) + ( 0.3 * 668) / (0.05 +0.25 + 0.4 + 0.3) = 656.05

**PLEASE LEAVE A POSITIVE RATING

Add a comment

Answer 2

Similar Homework Help Questions

Take Test: Ch 03-A4 QUESTION 3 Given is a historical time series for job services demand...

Take Test: Ch 03-A4 QUESTION 3 Given is a historical time series for job services demand in the prior 6 months. Month Demand 1 635 2 754 3 706 4 618 725 6 745 The Period 5 forecast by using weighted moving average with weights of 0.05, 0.25, 0.40, and 0.30 decimal places) (in 2 3 points Save Answe Save All Answers Save and Submit 24
Given is a historical time series for job services demand in the prior 6 months. Month...

Given is a historical time series for job services demand in the prior 6 months. Month Demand 1 817 2 736 3 816 4 718 5 805 6 785 Use the table below to answer all questions: Month Demand Forecast 1 817 F1 2 736 F2 3 816 F3 4 718 F4 5 805 F5 6 785 F6 7 F7 If the demands forecast is Not Possible (NP) to generate for a particular month, then you must type in NP...
Given is a historical time series for iob services demand in the prior 6 months. Month...

Given is a historical time series for iob services demand in the prior 6 months. Month Demand 698 815 716 613 657 865 4 The Period 4 forecast by using exponential smoothing with 0.25 alpha (in 2 decimal places)

Given is a historical time series for job services demand. PeriodDemand Forecast 289 208 325 F1...

Given is a historical time series for job services demand. PeriodDemand Forecast 289 208 325 F1 F2 F3 F4 323 302 299 F6 F7 F8 F9 F10 F11 F12 If you were not able to generate a forecast for particular period, you should enter N. Also, F3 means Period 3 Forecast. Use Weighted moving average with weights of 0.09, 0.11, 0.16, 0.25, 0.39 to answer Questions 1) to 3). 1) The F5- 2) The F12 3) If you were told...
Given is a historical time series for job services demand. PeriodDemand Forecast 313 89 F1 F2...

Given is a historical time series for job services demand. PeriodDemand Forecast 313 89 F1 F2 F3 F4 F5 F6 219 323 302 299 F8 F9 F10 F11 F12 If you were not able to generate a forecast for particular period, you should enter N. Also, F3 means Period 3 Forecast. Use Weighted moving average with weights of 0.09, 0.11, 0.16, 0.25, 0.39 to answer Questions 1) to 3) 1)The F9- 2) The F10 3) If you were told to...
The historical demand for a product is as follows: Month Demand January 12 February 11 March...

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...

2. The historical demand for a product is below. Please forecast the demand in April. Month...

2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 © Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y=a+bx, and then forecast demand. (3 points)
2. The historical demand for a product is below. Please forecast the demand in April. Month...

2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 (c) Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y = a+bx, and then forecast demand. (3 points)
3. The following time series represent the annual demand for 50 lb bags of fertilizer for...

3. The following time series represent the annual demand for 50 lb bags of fertilizer for a garden supply company between 1991 and 2002. Year | Bags 1991 | 4000 1992 | 6000 1993 | 4000 1994 | 5000 1995 | 10,000 1996 | 8000 1997 | 7000 1998 | 9000 1999 | 12,000 2000 | 14,000 2001 | 15,000 2002 | 14,000 a. Use a 2-period moving average to forecast the demand for the bags of fertilizers in 2003....

The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36...

The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36 2 38 3 40 4 41 5 43 6 42 7 43 8 45 9 46 10 48 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 36. (Round your intermediate calculations and answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α...

Given is a historical time series for job services demand in the prior 6 months. Month...

Homework Answers

Add Answer to:
Given is a historical time series for job services demand in the prior 6 months. Month...

Post as a guest

Earn Coins

Take Test: Ch 03-A4 QUESTION 3 Given is a historical time series for job services demand...