When creating a time series–based forecast for the amount of soda to be sold in thecafeteria next week, which data sources can you include in your forecasting process?a. The opinion of the principalb. Old demand datac. Data about upcoming sports eventsd. The age of the cafeteria worker

When creating a time series–based forecast for the amount of soda to be sold in thecafeteria next week, which data sources can you include in your forecasting process?a. The opinion of the principalb. Old demand datac. Data about upcoming sports eventsd. The age of the cafeteria worker

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: A. The Naive Approach B. Three month moving average C.A weighted moving average using 0.60 for the…

A: Forecasting techniques are used to predict future events. Forecasting is the process of estimating…

Q: Canton Supplies, Inc., is a service firm that employs approximately 100 people. Because of the…

A: Find the given details below: Given details: Month ($ 1000) 1 186 2 219 3 216 4 270…

Q: Refer to Problem 4.2. Develop a forecast for years 2 through 12 using exponential smoothing with a =…

A: Given data is Alpha = 0.4 Forecast for year 1 = 6

Q: What tool should we use to know whether our forecasting was under forecasted or over forcasted? Is…

A: This question is related to forecasting, we use several tools or parameters to check Bias, accuracy…

Q: a. Using a simple three-month moving average, make a forecast for this month. (Round your answer to…

A: Forecasting is the process of predicting the future demand according to past data and demand.

Q: a. Construct a time series plot. What type of pattern exists in the data? b. Compare a two-week…

A: Forecasting is predicting in advance the values through various methods like moving averages,…

Q: The moving average forecasting method is typically bestfor products:a) Functional b) Innovativec)…

A: The correct answer is option c) Mature. Moving Average formula is used to average the number of…

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: Daily high temperatures in St. Louis for the lastweek were as follows: 93, 94, 93, 95, 96, 88, 90…

A: Since you have asked multiple questions, we will solve first question for you (a, b and c). If you…

Q: Given a 3-quarter period of actual and forecast demand as shown in the table. The company ABC sets a…

A: A forecasting method is a managerial tool which help to predict the unknown future based on…

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: It is a common saying that the only thing certain about a forecast is that it will be wrong. What is…

A: Forecasting is the process of predicting future demand values based on historical data. The…

Q: 2

A: Forecasting is a strategy that uses previous data as inputs to generate informed predictions about…

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: The forecast for week 6 is ___ service calls (round to two decimals and show your work)

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

Q: Contrast the use of MAD and MSE in evaluating forecasts?

A: Forecasting is the process of identifying the demand accurately for future production planning and…

Q: omplete the data on the table by considering the forecasting method indicated in each column. Show…

A: Forecasting means predicting in advance what would be the estimated sales of future periods by…

Q: You discovered that the forecasting error falls beyond the acceptable ranges in the past three…

A: Find the given details below: Given details: Period Actual Forecast (A-F) Error (A) (F)…

Q: What is an Advantage of the MAPE? a. It can be compared across different forecast items. b. It…

A: The mean absolute percentage blunder, otherwise called mean absolute percentage deviation, is a…

Q: Develop a 3-weck weighted average forecast for Week 4 through 9 with weights WI - W2 = W3 = 0.2 0.3…

A: A moving average based on weighted average puts weight on the data gathered recently, by multiplying…

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

A: Below is the solution;-

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: Marianne Kramer, the owner of Handy Man Rent-als, rents carpet cleaners to contractors and…

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

A: Forecasting is the process of making assumptions of the future on the basis of past and present data…

Q: Marianne Kramer, the owner of Handy Man Rent-als, rents carpet cleaners to contractors and…

A: MAD stands for Mean Absolute deviation which is defined as average distance among every data value…

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

A: Weighted moving average=∑Weight for period nDemand for period…

Q: Forecasting plays an important role in the operations of modern management. In fact, operational…

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

Q: Below you are given the first five values of a quarterly time series of sales. Year Time Series…

A: Find the Given details below: Given details: Year Quarter Time Series Value Y1 1 1 36 2 24…

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: Using MAD as a criterion, which technique has the better performance record?

A: MAD or Mean Absolute Deviation indicating the average value of the absolute errors. An efficient…

Q: 4. What is the forecast for the 13th period based on the four-period moving average? Round your…

A: Given data is

Q: 4 .Substitute for Problem # 4 on in attachment)-Calculate the MAD,revised MAD and the Revised…

A: Given data is The revised forecast using the Naive method and revised MAD is shown below. As the…

Q: Firms keep supplies of inventory for which of the following reasons? To provide a feeling of…

A: The company keeps inventory supplies to run the operations smoothly and to ensure that the company…

Q: constants of .6 and .9, develop fo recasts for the sales of VWBeetles. What effect did the smoothing…

A: Note: - Since the data for the 'Volkswagen Beetles' question is not given we will answer the…

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: Forecasting plays an important role in the operations of modern management. In fact, operational…

A: Answer: Reference: Wikipedia, Operations Management book, Pearson Publication, 12e Kimberly-Clark…

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: Explain the nature of forecasting when it's periods are farthest into the future in forecasting ?

A: To be determined: the nature of forecasting when it's periods are farthest into the future in…

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

A: Below is the solution:-

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

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

Q: sing data in columns A-C create a forecast using the Simple Moving Average method based on 10 weeks…

A: Forecasting means predicting in advance the values of future sales/demand by using different methods…

Q: 1. It has been said that forecasting using exponential smoothing is like driving a car by looking in…

A: As specified, I have solved the second question for you. Kindly find it's answer ahead and post the…

Q: Let's say you are playing the stock market and below period 2020 data was provided. For "stock A"…

A: The answer is as below

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

A: In exponential smoothing; Here,

Q: Herman Hahn is attempting to set up an integrated forecasting and inventory controlsystem for his…

A: Time-series forecasting and seasonality factors in it:

Q: Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of…

A: Given data-

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

Question

When creating a time series–based forecast for the amount of soda to be sold in the
cafeteria next week, which data sources can you include in your forecasting process?
a. The opinion of the principal
b. Old demand data
c. Data about upcoming sports events
d. The age of the cafeteria worker

Leveraging special tenchniques in analyzing historical data to predict future trends. Forecasting covers the methods and types of forecasting and their application to case studies.

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

Trending now

This is a popular solution!

Step by step

Solved in 2 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

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?
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 tool should we use to know whether our forecasting was under forecasted or over forcasted? Is it possible to get the same value of CFE and MAD? How? What does the value of MSE signify?
The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c. a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3. Complete the exponential smoothing forecast model for stock A. (Type integers or decimals rounded to two decimal places as needed.) Date Forecast A 09/03/2010 09/07/2010 enter your response here 09/08/2010 enter your response here 09/09/2010 enter your response here 09/10/2010 enter your response here 09/13/2010 enter your response here 09/14/2010 enter your response here 09/15/2010 enter your response here 09/16/2010 enter your response here 09/17/2010 enter your response here 09/20/2010 enter your response here 09/21/2010 enter your response here Date A B C D Stock Exchange…
You have the following data: Actual Forecast 1 50 50 2 46 3 52 4 51 5 48 6 45 7 52 8 46 9 51 10 48 Compute the forecast using exponential smoothing with Using MSE, which of the above gives the best forecast of "Actual"? A) 0.8 B) 0.6 C) 0.4 D) 0.1 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.
At the ABC Floral Shop, an argument developed between two of the owners, Bob and Henry, over the accuracy of forecasting methods. Bob argued that exponential smoothing with α = .1 would be the best method. Henry argued that the shop would get a better forecast with α = .3.a. Using F1 = 100 and the data from problem 3, which of the two managers is right?b. Graph the two forecasts and the original data using Excel. What does the graph reveal?c. Maybe forecast accuracy could be improved. Try additional values of α = .2, .4, and .5 to see if better accuracy is achieved.
Accuracy of forecasts. The manager of a large manufacturer of industrial pumps must choose betweentwo alternative forecasting techniques. Both techniques have been used to prepare forecasts for a sixmonth period. Using MAD as a criterion, which technique has the better performance record?FORECASTMonth Demand Technique 1 Technique 21 492 488 4952 470 484 4823 485 480 4784 493 490 4885 498 497 4926 492 493 493
It has been said that forecasting using exponential smoothing is like driving a car by looking in therear-view mirror. What are the conditions that would have to exist for driving a car that are analogous to the assumptions made when using exponential smoothing?2. What capability would an organization have to have to not need forecasts?3. When a new business is started, or a patent idea needs funding, venture capitalists or investmentbankers will want to see a business plan that includes forecast information related to a profit andloss statement. What type of forecasting information do you suppose would be required?4. Discuss how you would manage a poor forecast.5. Omar has heard from some of his customers that they will probably cut back on order sizes in thenext quarter. The company he works for has been reducing its sales force due to falling demand andhe worries that he could be next if his sales begin to fall off. Believing that he may be able to convince his customers not to cut…
4 .Substitute for Problem # 4 on in attachment)-Calculate the MAD,revised MAD and the Revised Forecast for months 1-6 for the following three groups,where the Forecast stands for Forecast Demand.Has your forecast improved ? Tell me how would you go about improving the revised forecast( for each of the three groups)without actually doing so? Estate Planning Group Auditing and Accounting Group Business Consulting Group Month Actual Demand Forecast Actual Demand Forecast Actual Demand Forecast 1 100 125 270 230 140 135 2 90 125 240 230 130 135 3 110 125 280 230 160 135 4 115 125 260 230 180 135 5 130 125 300 230 200 135 6 115 125 220 230 190 135