Answered: When forecasting demand for new…

When forecasting demand for new products, sometimes i rms will use demand data from similar existing products to help forecast demand for the new product. What technique is this an example of?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.6: Moving Averages Models

Problem 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...

See similar textbooks

Related questions

Q: How do exponential smoothing advantages have over moving averages as a forecasting tool?

A: The advantages of exponential smoothing as a forecasting method over operating averages are as…

Q: Explain why forecasting devices such as moving averages, weighted moving averages, and exponential…

A: The average is going The prediction is increased and n is flat, but less susceptible. It provides an…

Q: Explain what benefits as a forecasting tool does exponential smoothing have over moving averages?

A: In today's environment, when events change frequently, the exponential smoothing method is superior.…

Q: Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10…

A: Exponential Smoothing is a hugely familiar system to provide a smoothed time series. In the single…

Q: Contrast the reactive and proactive approaches to forecasting. Give several examples of types…

A: When one talks of proactive and reactive approaches to forecasting, it basically means that one has…

Q: What advantages does exponential smoothing have over movingcaverages as a forecasting tool?

A: The following are the benefits of exponential smoothing as a forecasting tool over moving averages.…

Q: What type of forecast model would be most appropriate for a company that was introducing a new…

A: Forecast model:A forecast model is a mathematical model used to forecast future demand for a…

Q: Explain what is seasonality and how forecast is done using data that has seasonality

A: In time series analysis, seasonalities are regarded as repeated up / down cyclic patterns in serial…

Q: Who needs to be involved in preparing forecasts?

A: The manager ultimately has the key responsibility to prepare the forecast. An organization should…

Q: Explain the trade-off between responsiveness and stability in a forecasting system that uses…

A: Time Series Data: statistic knowledge is outlined as during an amount of your time,…

Q: When should time series forecasting techniques be used?

A: The statistical data and, as a consequence, the projected features are analyzed using statistical…

Q: What does the word "biassed" mean when applied to a specific forecasting technique?

A: Forecasting is a common and widely used methodology in almost every area of endeavor, including…

Q: In order to increase the responsiveness (volatility) of following forecast models, what can you do?…

A: In order to increase the responsiveness of the forecast model using exponential smoothing, we need…

Q: DEMAND FORECAST WITH LINEAR REGRESSION Historical demand for a product is: Period MONTH DEMAND x2 XY…

A: Period (x) Month Demand (y) 1 January 12 2 February 11 3 March 15 4 April 12 5 May 16 6…

Q: a) Using a weighted moving average with three periods, determine the demand for period 13. Use 3, 2,…

A: Forecasting is the process of predicting future data based on previous or past data and information.…

Q: 20- Forecasting is very important in predicting the future sales of a company. Can you identify the…

A: Below is the solution;-

Q: What advantages as a forecasting tool does exponential smoothing have over moving averages?

A: A moving average forecast method takes into account instead of the last actual data, a number of…

Q: We have a new chief sales officer who is proposing that we should forecast in dollars, not in…

A: Salespeople are inexperienced with estimate exactness measures. They have no real excuse to be on…

Q: When forecasting demand for new products, sometimes firms will use demand data from similar existing…

A: When forecasting demand for new products, sometimes firms will use demand data from similar existing…

Q: (Round your answers to 2 decimal places.) Complete the table above, filling in the "Forecast for…

A: Forecast refers to the estimation of the future happening according to the previous and current data…

Q: Explain what are the benefits of exponential smoothing over moving average forecasting

A: The table below gives a prediction of the advantages of moving average over exponential smoothing.

Q: Develop an appropriate forecast model for bookstoremanagement to use to forecast computer demand for…

A: Forecasting is an indispensable method of managing sales by evaluating the future demand for…

Q: What type of forecasting method would you recommend to a start-up retailer in terms of quantities,…

A: Demand forecasting is very important for any startup when you have an absence of resources and…

Q: Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled…

A: Mean Absolute Deviation (MAD) is one of the measures used to summarize historical errors in…

Q: Why is accurate forecasting so important to companies thatuse a continuous replenishment inventory…

A: Continuous Replenishment is a method by which a supplier is told day by day of real deals or…

Q: Forecasting is utilized in which of the following areas? A) product demand B. process design (c) new…

A: Efficiency is the ability to reduce or eliminate the wastage of resources, money, and time in an…

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

A: Given-

Q: The manager of a large manufacturer of industrial pumps must choose between two alternative…

A: Both techniques have been used to prepare forecasts for a six month period as follows:

Q: All forecasts are subject to error. Do you think topmanagers would be concerned about the effectson…

A: Forecasting is described as a tool that will allow the businesses in the budgeting process and also…

Q: Suppose you need to forecast the amount of relief aid needed following an earthquake. What type of…

A: Answer: Relief aid needed following an earthquake, belong to the category of disaster relied supply…

Q: exponential smoothing superior to moving averages

A: Remarkable smoothing is a general guideline method for smoothing time arrangement information…

Q: Forecast is calculating estimates of future cycle/s based on data of past cycles, there is no…

A: Forecasting is the way toward making expectations dependent on over a significant time span…

Q: What three methods are used to determine the accuracy of any given forecasting method? How would you…

A: Forecasting is the process of making assumptions of future events based on past and present…

Q: An example of the Quantitative Method of forecasting is

A: Businesses and salespeople can use quantitative forecasting, an objective, data-based process, to…

Q: Clinic administrator Marc Schniederjans wants you to forecast patient demand at the clinic for week…

A: Below is the solution:-

Q: Explain how do exponential smoothing have benefits over shifting averages as forecasting tool

A: The merits of autoregressive moving as a prediction approach are considerable in comparison to…

Q: what is the advantage of using double exponential smoothing over regression?

A: You can use both double exponential smoothing and regression to forecast a demand pattern with a…

Q: Explain why is accurate forecasting so important to companies that use a continuous replenishment…

A: Forecasting is the practice of making future assumptions based on historical and current data, most…

Q: The following data shows sales forecast of Axis Dealer for motorbikes. Month Demand 1 650 2 700 810…

A: Given data:

Q: Apply the following forecasting techniques of the data to estimate the demand in period 13: a.…

A: In the question, There are time-series data, actual demand data are given over the past 12 quarters.…

Q: Using a numerical example, demonstrate to Mr. John how he can use the manual trend projection method…

A: The trend projection method is a classical forecasting method, concerned with variable movement…

Q: What are the advantages and disadvantages of aggregating deman from a forecasting view? Are there…

A: The upsides of accumulating request from an estimating view make it conceivable to have a general…

Q: The manager of a travel agency asked you to come up with a forecasting technique that will best fit…

A: Given - Smoothing constant (α) = 0.25 Period Demand F1 F2 1 115 - - 2 176 - - 3 97 146…

Q: Th e manager of a small health clinic would like to useexponential smoothing to forecast demand for…

A: In exponential smoothing; Here,

Q: Explain how the technology of forecasting can be improved

A: Forecasting is a long-term and short-term activity that the company engages in on a regular basis.…

Q: Discuss what is seasonality and how forecast is done using data that has seasonality?

A: Time series analysis describes seasonal patterns as recurrent upward and downward cyclic patterns in…

Q: Discuss what advantages as a forecasting tool does exponential smoothing have over moving averages?

A: In today's environment, when events change often, the exponential smoothing method is optimal.…

Concept explainers

Forecasting in Business

Forecasting is the process of predicting the future based on the past and the present data and circumstances. In other words, forecasting is the act of making a detailed analysis of future events based on the decisions made in the past as well as the present. Forecasting plays a very important role in operational management as it helps in planning and decision-making. It is not only important for the success of a business but also contributes to individual growth and success. Many business organizations or companies have failed due to the shortcomings of their forecasting.

Question

When forecasting demand for new products, sometimes i rms will use demand data from similar existing products to help forecast demand for the new product. What technique is this an example of?

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

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, management and related others by exploring similar questions and additional content below.

Similar questions

Under what conditions might a firm use multiple forecasting methods?
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.
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?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
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?
What should be our forecast accuracy target if there is a high degree of volatility in customer orders and long lead times? We have a new chief sales officer who is proposing that we should forecast in dollars, not in units/cases. I have never heard of anyone forecasting in dollars. It is true that dollarized forecasts can help Sales in knowing precisely what sales target they should be hitting. But, is it the best practice?
What are the advantages and disadvantages of aggregating demand from a forecasting view? Are there other things that should be considered when going from multiple DCs to a DC?
In order to increase the responsiveness (volatility) of following forecast models, what can you do? Exponential Smoothing – describe in terms of “alpha value” (smoothing constant): Simple moving average - describe in terms of “averaging periods” (number of data points to use):
Explain what are the benefits of exponential smoothing over moving average forecasting ?
The worksheet Hudson Demand Case Data in MindTap provides the number of visits over one year from January to December (52 weeks). Chart the data and explain the characteristics of the time series. How would you forecast future demand for customer visits? What criteria will you use to determine a “good” forecast? What methods would you use, and why? What is your final recommendation with respect to a forecasting method? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.