An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...

Question

Question

An electrical contractors records during the last five weeks indicate the number of job requests: Week: Requests: 27 29 21 2

business Operations-Management

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Exponential smoothening

F3= F2 + ɑ * (A2- F2)

where

A2= Actual demand for Wk 2

F2 = Forecast for Week 2

ɑ= Smoothening constant

Hence here

F3 = 27 + 0.15* (29-27)

F3 = 27.30

F4 = 27.3 + 0.15 * (21-27.3)

F4=26.36

Similarly

F5 = 26.61

F6= 26.97

Add a comment

Answer 2

Similar Homework Help Questions

An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...

An electrical contractor's records during the last five weeks indicate the number of job requests: Week: 1 2 3 4 5 Requests: 25 27 25 26 27 Predict the number of requests for week 6 using each of these methods: a. Naive. Number of requests b. A four-period moving average. (Round your answer to 2 decimal places.) Number of requests c. Exponential smoothing with α = .25. Use 25 for week 2 forecast. (Round your intermediate...
An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...

An electrical contractor's records during the last five weeks indicate the number of job requests: Week: 1 2 3 4 5 Requests: 24 26 24 25 26 Predict the number of requests for week 6 using each of these methods: a. Naive. Number of requests b. A four-period moving average. (Round your answer to 2 decimal places.) Number of requests c. Exponential smoothing with α = .30. Use 24 for week 2 forecast. (Round your intermediate...
An electrical contractor’s records during the last five weeks indicate the number of job requests: Week:...

An electrical contractor’s records during the last five weeks indicate the number of job requests: Week: 1 2 3 4 5 Requests: 20 22 18 21 22 Predict the number of requests for week 6 using each of these methods: a. Naive. b. A four-period moving average. c. Exponential smoothing with .30. Use 20 for week 2 forecast.

An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...

An electrical contractor's records during the last five weeks indicate the number of job requests: Week: Requests: 25 27 23 26 27 1 2 3 45 sed wees uaing hiese methods We were unable to transcribe this image
The following is the data for the number of complains a telephone company received during the...

The following is the data for the number of complains a telephone company received during the past 5 weeks for the service they offer. Use the data to forecast the number of complaints for week 6, based on the following methods: Week Demand 1 111 2 100 3 105 4 112 5 114 Naive approach. Simple moving average with span of 3. Weighted moving average with weights of 0.55, 0.25, and 0.2. Simple exponential smoothing with smoothing factor of 0.4....
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...

11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next week. The following table sum...

11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next week. The following table summarizes the number of new cars sold during each of the past 12 weeks: (PLEASE ANSWER BY USING EXCEL) week number sold 1 22 2 26 3 23 4 27 5 21 6 25 7 28 8 26 9 29 10 29 11 27 12 31 (a) Provide a forecast by using a 3-week weighted moving average technique with weights...
Using the data below, what is the simple exponential smoothing forecast for the 3rd week where...

Using the data below, what is the simple exponential smoothing forecast for the 3rd week where a=0.3? Week Time Series Value 2.00 8.00 6.00 3.00 Submit Answer format: Number: Round to: 1 decimal places Based on the data below for chocolate demand per week and using the naive forecasting method, how much you should order for 5th week? Week Time Series Value 15.00 14.00 23.00 6.00 Submit Answer format: Number: Round to: O decimal places.
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...

Using the data below, what is the simple exponential smoothing forecast for the 4th week where...

Using the data below, what is the simple exponential smoothing forecast for the 4th week where a=0.4? Week Time Series Value 6.00 4.00 3.00 Submit Answer format: Number: Round to: 1 decimal places. Using the data below, what is the value of MSE? Month Actuals Forecast 4.00 8.00 4.00 5.00 Submit Answer format: Number: Round to: 2 decimal places.

An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...

Homework Answers

Add Answer to:
An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...

Post as a guest

Earn Coins

An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...

An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...

An electrical contractor’s records during the last five weeks indicate the number of job requests: Week:...

An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...

The following is the data for the number of complains a telephone company received during the...

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

11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next week. The following table sum...

Using the data below, what is the simple exponential smoothing forecast for the 3rd week where...

Given is a historical time series for job services demand. PeriodDemand Forecast 313 89 F1 F2...

Using the data below, what is the simple exponential smoothing forecast for the 4th week where...

An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...

Homework Answers

Add Answer to: An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...

Post as a guest

Earn Coins

Add Answer to:
An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...