Concept explainers
An electrical contractor’s records during the last five weeks indicate the number of job requests:
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
a)
To forecast: The number of requests for week 6 using naïve approach.
Introduction: Forecasting is the planning process that helps to predict the future aspects of the business or operation using present or past data. It uses certain assumptions based the knowledge and experience of the management.
Explanation of Solution
Given information:
Given that an electrical contractor had the following job requests during the last five weeks
Forecast the number of requests for week 6 using the naïve approach as shown below.
Given that the number of job requests for week 5 was 22, the likely job requests for week 6 would also be 22.
b)
To forecast: The number of requests for week 6 using a four-period moving average.
Introduction: Forecasting is the planning process that helps to predict the future aspects of the business or operation using present or past data. It uses certain assumptions based the knowledge and experience of the management.
Explanation of Solution
Given information:
Given that an electrical contractor had the following job requests during the last five weeks
Forecast the number of requests for week6 using a four period moving average as shown below.
Substitute the values to obtain the forecast for week 6 as shown below.
The forecast for week6 would be 20.75
c)
To forecast: The number of requests for week 6 using a exponential smoothing.
Introduction: Forecasting is the planning process that helps to predict the future aspects of the business or operation using present or past data. It uses certain assumptions based the knowledge and experience of the management.
Explanation of Solution
Given information:
Given that an electrical contractor had the following job requests during the last five weeks
Forecast the number of requests for week6 using exponential smoothing as shown below.
Forecast the number of requests for week 6 using an exponential smoothing methodology, given that the forecast for week 2 was 20 and the actual job requests in week 2 was 22, and the exponential smoothing constant
- Given the week 2 forecast was 20, the actual number of jobs in week2 was 22 and the smoothing constant α was 0.3, prepare a forecast for week 3 as shown below.
Therefore, forecasted week3 job requests 20.6.
- Given the week3 forecast was 20.6, the actual number of jobs was 18 and the smoothing constant α was 0.3, prepare a forecast for week4 as shown below.
Therefore, forecasted week4 job requests 19.82.
- Given the week4 forecast was 19.82, the actual number of jobs was 21 and the smoothing constant α was 0.3, prepare a forecast for week5 as shown below.
Therefore, forecasted week5 job requests 20.17.
- Given the week5 forecast was 20.17, the actual number of jobs was 22 and the smoothing constant α was 0.3, prepare a forecast for week 6 as shown below.
Therefore, the forecast for week 6 would be 20.72.
Want to see more full solutions like this?
Chapter 3 Solutions
Operations Management (Comp. Instructor's Edition)
- 17arrow_forwardA dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. August usage was forecasted to be 45 percent of capacity, actual usage was 52 percent of capacity. A smoothing constant of .05 is used. a. Prepare a forecast for September. (Round your final answer to 2 decimal places.) Forecast for September percent of capacity b. Assuming actual September usage of 52 percent, prepare a forecast for October usage. (Round your answer to 2 decimal places.) Forecast for October percent of capacityarrow_forwarderarrow_forward
- The table shows the values found in the error analysis. What method of forecasting would be best to use? What is the forecasted value? MSE forecast for week 13 Time Series 1.08 14.76 3-week MA 3.04 13.67 exp smoothing 11.04 9.5 Group of answer choices A.) Time Series, forecasted value = 14.76 B.) 3-week MA, forecasted value = 13.67 C.) exp smoothing, forecasted value = 9.5 D.) Time Series, forecasted value = 1.08 E.) 3-week MA, forecasted value = 3.04 F.) exp smoothing, forecasted value = 11.04arrow_forward53 Can you help me find MSE in this chart?arrow_forwardWalmart’s Human Resource Planning Forecasting. Walmart’s human resource management forecasts its workforce needs to ensure capacity to address changes in consumer demand. While other forecasting methods and techniques are also used, these three are the most notable at Walmart:arrow_forward
- Problem 3-4 (Static) An electrical contractor's records during the last five weeks indicate the number of job requests: 2 3 22 18 Week: Requests: 1 20 4 21 Click here for the Excel Data File Predict the number of requests for week 6 using each of these methods: a. Naive. 5 22 Answer is complete but not entirely correct. Number of requests 24 X requests b. A four-period moving average. (Round your answer to 2 decimal places.). Answer is complete but not entirely correct. Number of 23.25 c. Exponential smoothing with a = 0.30. Use 20 for week 2 forecast. (Round your intermediate calculations and fina mal nisenelarrow_forwardProfessor Shethinks Shesverybusy needs to allocate time this week for office appointments, so she needs to forecast the number of students who will seek appointments. The professor has gathered the following time series data recently: Period Student Appointments 4 weeks ago 95 3 weeks ago 80 2 weeks ago 65 Last week 50 What is this week's forecast for student appointments using a three-week moving average? а. 52 b. 80 Ос. 65 d. 78 e. 50 O O O Oarrow_forwardIn exponential smoothing, if ɑ = 0.3, then the damping factor for use in forecasting should be: * o .70 o .60 o .40 o .50 o .30arrow_forward
- I understand the moving average concept but not the weighted moving average and exponential smoothingarrow_forward5arrow_forwardAn electronic contractor's records during the last five weeks indicate the number of jobs requests. Week 1 Requests 20 22 18 21 22 Predict the number of requests for week 6 using each of these methods: a. Naïve b. A four period moving average c. Exponential smoothing with a 0.3. Use 20 for week 2 forecast,arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,