Use quantitative methods for the data shown below: Period 1 2 3 4 5 6 7 Observation 24 34 36 37 41 44 45 i) Naïve method: ii) Three period moving average iii) Three period Weighted moving average iiii)Four-period Moving Average

Use quantitative methods for the data shown below: Period 1 2 3 4 5 6 7 Observation 24 34 36 37 41 44 45 i) Naïve method: ii) Three period moving average iii) Three period Weighted moving average iiii)Four-period Moving Average

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.7: Exponential Smoothing Models

Problem 29P: The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building...

See similar textbooks

Related questions

Q: Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six…

A: Absolute Error = | Actual sales - Forecast | MAD = Average of Absolute Error

Q: 1. a.) What is forecasting? b. Explain the importance of forecasting for managers like you? c.) What…

A: Forecasting is simply analyzing and evaluating the past or present data to determine or predict the…

Q: How forecasting helps in different disciplines of management science? Make a comparison between…

A: Forecasting is a prediction method that can use historical data and current market trends and…

Q: 17. Statistical and observational methods, where adequate data or settings are available in which to…

A: Forecasting: It means the prediction of the future period. The prediction will be done based on the…

Q: Judgmental forecasts have the following strengths, except___________. a. Can include “inside” and…

A: A prediction based on subjective data. A judgmental forecast is one that is made by someone who is…

Q: 4.27 Mark Cotteleer owns a company that manufactures sail- boats. Actual demand for Mark's sailboats…

A: Given - Forecasted demand of 2009 = 5,600 sailboats Season 2004 2005 2006 2007 Winter 1400…

Q: Consider the following time series: Period 1 2 3 4 5 6 7 8 Demand 15 24 26 33 20 22 27 20…

A: A time series forecasting technique called exponential smoothing can be expanded to support data…

Q: Forecasted Year Sales Sales 2005 455 415.00 2006 510 427.00 2007 516 451.90 2008 570 471.13 2009 585…

A: Given that: Smoothing constant = 0.6 Starting Forecast = 415 and Year Sales 2005 455 2006 510…

Q: Forecasting is critical in modern times. It is believed that it started as a consequence of the…

A: BUSINESS FORECASTING is a gauge or expectation of future advancements in business like deals,…

Q: When the American Airlines CEO developed yield management, what type of information was crucial to…

A: We know that, Forecasting is a strategy that utilizes previous data as inputs to produce…

Q: Managing forecasting projects involves many of the same management skills as managing other…

A: Project management is the type of management in which different types of skills and knowledge are…

Q: Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 a. Use α = 0.2 to…

Q: Identify one method that is used in forecasting and explain how it is applied.

A: Forecasting: It is a process of predicting future demand based on past values or demand and present…

Q: 6. Tutoring Center needs to allocate tutors this week for office appointments, so it needs to…

A: Note: - Since we can answer only up to three subparts we will answer the first three(a, b, and c)…

Q: Do you think that Hard Rock Cafemakes use of time horizons when forecasting?

A: What is Forecasting ? Anticipating is a method that utilizes chronicled information as contributions…

Q: Company ABC produces and sells 4 types of computer monitors of different features. The following…

A: A moving average is a technical indicator that financial backers and traders use to decide the…

Q: What are the seven steps taken in forecasting system?

A: Forecasting: Forecasting is the process of accurately estimating demand for future production…

Q: Using a weighted moving average with weights of 0.55, 0.35, and 0.15, for periods 3, 2, and 1…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: Q1 Given the Supply chain cost for a service is PKR 195 and the customer value is PKR 225. Determine…

A: Supply Chain Surplus= Revenue generated from customer - Total cost incurred to produce and deliver…

Q: Forecasting Forecasting is important relative to capacity requirements planning. What are some of…

A: Qualitative data forecasting techniques mainly describes the characteristics and qualities of the…

Q: A large Portland manufacturing would like to forecast the monthly demand for a piece of…

A: Given that: Month Actual Demand 1 14 2 17 3 20 4 21 5 25

Q: 1. A forecaster must decide on the value of this factor before he can use the simple moving average…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: Identify the key differences between qualitative and quantitative forecasting methods. Which is…

A: Forecasting is the planning process that helps to predict the future aspects of the business or…

Q: Compute seasonal relatives for this data using the SA method:Quarter Year 1 Year 2 Year 3 Year 41 2…

Q: Determine the Forecast Error for the data below using the Mean Absolute Deviation (MAD) formula.…

A: Given data is

Q: what are the benefits of exponential smoothing forecasting?

A: Forecasting is the process of prediction in which sales demand is estimated using historic…

Q: 1. Discuss the differences between Qualitative and Quantitative forecasting models. How do…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: Describe three different forecasting applications at Hard Rock.Name three other areas in which you…

A: Introduction: Hard Rock Cafe is a restaurant chain which is founded in the year 1971 in London and…

Q: 2. Calculate MA, WMA and ES and show me which method can forecast the following dataset better. Use…

A: Note that, there is missing information in the question. For Weighed moving average (WMA) the…

Q: Given the following data of actual sales and forecast for the five months: Month 1, Month 2, Month…

A: Given data is

Q: Problem 1: Sheet 1 a) Find on the Internet a time series, which contains at least 20 entries.…

A: Find the Time series data below: Note that, the below data was collected from the website…

Q: Explain what are some of the potential advantage of a more formalized approach to forecasting

A: Forecasting is a method of accurately anticipating future demand to plan for it. Manufacturing and…

Q: FORECASTING- EXPONENTIAL SMOOTHING QUESTION 3 PERIOD ACTUAL 1 42 40 3 43 4 40 41 39 7 46 8 44 9. 45…

A: In the question, we have time-series data, Actual data are presented over 11 periods, I would use…

Q: Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for…

A: Given-

Q: How has the technology had an impact on forecasting?

A: Technology plays an important role in forecasting and has the ability to have a huge impact. We will…

Q: What are the challenges involved in forecasting?

A: Concept Introduction : Organizations use forecasting as a tool to think about and plan for the…

Q: Using exponential smoothing with a weight ex of 0.6 on actual values: (a) if sales are $45,000 and…

A: Therefore, the forecast in 2012 is $48,000.

Q: 4. A new car dealership is considering opening branches in three of the largest cities in the state.…

A: Forecasting is the practice of predicting future events by focusing on long-term trends. Basically,…

Q: Given below are the demands of a certain product over the past 10 weeks. Week | 1 | 2 | 3| 4 | 5 6 |…

A: Since you have submitted multiple questions with multiple subparts as per guidelines I have answered…

Q: Assume that you have three forecasting models. For the first, MAD = 2.5, for the second, the MSE…

A: Answer : OPTION D ( One cannot conclude )

Q: Discuss the strategic importance of forecasting. What strategic decisions do organizations need to…

A: There is a huge competition between all the organizations these days to excel themselves in their…

Q: Quarter 1 2 3 1 11 14 17 2 20 23 26 3 29 32 35 4 38 41 44 Compute seasonal relatives for this…

Q: . The expert’s opinion and the test marketing methods are examples of Qualitative and Quantitative…

A: A sale forecast is an estimation of sales volume that a company can expect to attain within the plan…

Q: Discuss the techniques of forecasting and its types. Also explain the limitations of each technique?

A: Forecasting - The process which is related with making the predictions for the future and the basis…

Q: Q.2 Answer the following A large international sales organization has collected data on the number c…

A: Given data:

Q: October 5 a) Forecast the demand for the week of October 12 using a 3-week moving average. b) Use a…

Q: 9. For a specific model of a shoe brand, Carrefour (NIZWA) experienced a sales of 1000 units, 1100…

A: Formulas used: Weighted moving average = ∑widi where w is the weight. d is the actual demand/sales i…

Q: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week Auto Sales…

A: The formula for calculating the moving average: n = 3

Concept explainers

Forecasting

Forecasting is a methodology that uses historical data as inputs to make well-informed predictions about the course of future trends. Forecasting is the method of making forecasts based on historical and current data, most commonly by trend analysis. In the business world, forecasting is a basic statistical task. Forecasting is used by businesses to decide how to allocate their budgets or prepare for expected expenditures in the future. Forecasts help managers formulate and execute production plans by providing forecasts. The primary goal of forecasting is to make accurate predictions.

Question

Use quantitative methods for the data shown below:

Period	1	2	3	4	5	6	7
Observation	24	34	36	37	41	44	45

i) Naïve method:

ii) Three period moving average

iii) Three period Weighted moving average

iiii)Four-period Moving Average

iiiii)Four-period Weighted Moving Average

b. Plot the original time series and comment on the appropriateness of a linear trend.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step 4 Three period Weighted moving average

VIEW

Step 5 Note

VIEW

Step by step

Solved in 5 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions

The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
Under what conditions might a firm use multiple forecasting methods?
Do the sales prices of houses in a given community vary systematically with their sizes (as measured in square feet)? Answer this question by estimating a simple regression equation where the sales price of the house is the dependent variable, and the size of the house is the explanatory variable. Use the sample data given in P13_06.xlsx. Interpret your estimated equation, the associated R-square value, and the associated standard error of estimate.
The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?
The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?
Management of a home appliance store wants to understand the growth pattern of the monthly sales of a new technology device over the past two years. The managers have recorded the relevant data in the file P13_05.xlsx. Have the sales of this device been growing linearly over the past 24 months? By examining the results of a linear trend line, explain why or why not.
The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building materials (which includes retail sales of building materials, hardware and garden supply stores, and mobile home dealers). a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?
The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b?
The file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. a. Explain briefly whether the plot of the series visually supports the companys suspicion. b. By what percentage are sales increasing each month? c. What is the MAPE for the forecast model in part b? In words, what does it measure? Considering its magnitude, does the model seem to be doing a good job? d. In words, how does the model make forecasts for future months? Specifically, given the forecast value for the last month in the data set, what simple arithmetic could you use to obtain forecasts for the next few months?
The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?
The file P13_25.xlsx contains the quarterly numbers of applications for home mortgage loans at a branch office of Northern Central Bank. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b? Is it guaranteed to produce better forecasts for the future?