a) Plot the monthly sales data. b) Forecast January sales using each of the following: i) Naive method. ii) A 3-month moving average. iii) A 6-month weighted average using .1, .1, .1, .2, .2, and with the heaviest weights applied to the most recent montE iv) Exponential smoothing using an a = .3 and a Septemt forecast of 18.
Q: Sara manages one of the Albireds shoe lines, and is working to improve the group's forecasting…
A: Given data is
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: Explain the benefits does exponential smoothing have over moving avarages as a forecasting tool ?
A: While in Moving Averages the previous perceptions are weighted similarly, Exponential Smoothing…
Q: Week Passengers 440 11 446 12 451 13 455 14 464 15 996 474 17 476 18 482 a. Explain why an averaging…
A: After observing the data, we can see that there is an upward increasing trend. In case the average…
Q: b) The forecast for the next month (Jan) using the naive method = sales (round your response to a…
A: Below is the solution:-
Q: (a) Compute four-week and five-week moving averages for the time series. 4-Week 5-Week Moving…
A: (a) (b)
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: 2. The department manager using a combination of methods has forecast sales of toasters at a local…
A: Below is the solution:-
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: a. Plot the monthly sales data. Do you observe any trend, cycles or random variations? b. Forecast…
A: Forecasting is a technique that uses recorded data as inputs to make instructed estimates that are…
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: A check-processing center uses exponential smoothing to forecast the number of incoming checks each…
A: Given Forecast S(June) = 42 million Checks in June X(June) = 40 million Smoothing constant α=0.2
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: 2. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period…
A: Note: - Since we can answer only up to three subparts we will answer the first three subparts(a,…
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: c) What is this year's forecast using exponential smoothing with alpha = 0.4, if year 2017's…
A: The concept of Operation Management: Operation management is the management that applies to a…
Q: a) Plot the monthly sales data. b) Forecast January sales using each of the following: i) Naive…
A: Forecasting is deciding in advance what your future sales/demand will be based on various methods of…
Q: Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for…
A:
Q: a) Forecast the demand for the week of October 12 using a 3-week moving average. b) Use a 3-week…
A: Forecasting is the process of estimating the future demand according to previous or historic…
Q: What is meant by the term tracking the forecast? In which two ways can forecasts go wrong?
A: Tracking the forecast means comparing the actual demand with the forecasted demand. It is used to…
Q: Marianne Kramer, the owner of Handy Man Rent-als, rents carpet cleaners to contractors and…
A:
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: Consider the data below which includes sales data and the forecasts that would have been made using…
A: Given data is
Q: At the ABC Floral Shop, an argument developed between two of the owners, Bob and Henry, over the…
A: A simple exponential smoothing method is used for smoothing time series data by assigning…
Q: a. Plot the monthly data b. Forecast September sales using: i. A linear trend equation ii. A…
A: THE ANSWER IS AS BELOW:
Q: The company's sales history (in thousands of units) is shown in the table below. Use exponential…
A: Concept and formulas used: FIT = Forcast Including Trend FIT = Ft + Tt Ft = FITt-1 + a…
Q: 2)Auto sales over a 4-month period were forecasted as follows: 89, 98, 105, and 97. The actual…
A: Auto sales over a 4-month period - Month Actual Forecast 1 92 89 2 96 98 3 101 105 4 100…
Q: A) What makes a forecast optimal?
A: A) Practically all administrative choices depend on Forecasting. Each choice becomes functional…
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: Corporate triple-A bond interest rates for 12 consecutive months follow. Month 1 2 3 4 5 6 7 8 9 10…
A: a)
Q: Marianne Schwartz, the owner of Handy Man Rentals, rents carpet cleaners to contractors and walk-in…
A:
Q: Given the following data of actual sales and forecast for the five months: Month 1, Month 2, Month…
A: The mean absolute error percentage (MAPE) is the average value of absolute error values. Mean square…
Q: 1. Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of…
A: THE ANSWER IS AS BELOW:
Q: Sales Month (000 units) Feb. 19 Mar. 18 Apг. May 15 20 Jun. 18 Jul. 22 Aug. 20 a. Plot the monthly…
A: The known data is given below:
Q: Forecasting time horizons include:a) long range. b) medium range.c) short range. d) all of the…
A: Forecasting refers to making decisions and predicting on the basis of previous or past experiences.
Q: What forecasting technique makes use of written surveys or telephone interviews? Historical…
A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question…
Q: Use simple exponential smoothing with a 0.6 to forecast chargers sales for February through May.…
A:
Q: b. Using exponential smoothing with a = 0.40, if the exponential forecast for week 3 was estimated…
A: Exponential smoothing is a forecasting model which helps to identify forecasting value using the…
Q: . What is the mean square error for time periods 2 through 4 using the average forecasting method?…
A: I am using the 2 periods simple moving average method to find average forecasts. It is the average…
Q: Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for…
A: Given, Week 1 2…
Q: October 5 a) Forecast the demand for the week of October 12 using a 3-week moving average. b) Use a…
A:
Q: b) Use a 3-week weighted moving average, with weights of.1, .3, and .6, using.6 for the most recent…
A: Forecasting is the process of determining the estimated future demand using historical information…
Q: Justify exponential smoothing's superiority to moving averages as a forecasting method
A: In today's climate, at which events keep changing, the quantile approach is superior.
Q: he monthly sales for Yazici Batteries, Inc., were as follows: Month Sales his exercise contains only…
A: Ans) In Naive forecasting, forecast is equal to previous demand. In 3 Month Moving Average forecast…
Q: a. Naive b. A four-period moving average c. Exponential smoothing with a = .30; use 20 for week 2…
A: Forecasting is the process of prediction in which sales demand is estimated using historic…
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 9 images
- 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 monthly sales for Yazici Batteries, Inc., wereas follows: a) Plot the monthly sales data.b) Forecast January sales using each of the following:i) Naive method.ii) A 3-month moving average.iii) A 6-month weighted average using .1, .1, .1, .2, .2, and.3, with the heaviest weights applied to the most recentmonths.iv) Exponential smoothing using an a = .3 and aSeptember forecast of 18.v) A trend projection.c) With the data given, which method would allow you toforecast next March’s sales?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.04
- a. what are forecasts? b. what are the costs associated with forecasting, and with not forecasting?q 1 An analyst must decide between two different forecasting techniques for weekly sales of roller blades. Based on the following data, answer the below questions. time Units sold 1 147 2 148 3 151 4 145 5 155 6 152 7 155 8 157 9 160 10 165 What's the MAD if the exponential smoothing technique with alpha 0.4 is used?What forecasting technique makes use of written surveys or telephone interviews? Historical analogy, Delphi method, Marketing research, Ad hoc forecasting, or Collaborative forecasting? 2 Which qualitative forecasting technique was developed to ensure that the input from every participant in the process is weighted equally? Historical analogy, Delphi method, Marketing research, Ad hoc forecasting, or Collaborative forecasting? 3 When forecasting demand for new products, sometimes firms will use demand data from similar existing products to help forecast demand for the new product. What technique is this an example of? Historical analogy, Delphi method, Marketing research, Ad hoc forecasting, or Collaborative forecasting
- a. What is the mean square error for time periods 2 through 4 using the average forecasting method? b. What is the mean absolute error for time periods 2 through 4 using the average forecasting method? c. What is the mean absolute percentage error for time period 2 through 4 using the average forecasting method? Round all answers to two decimal places. Time Period 1 2 3 4 Mean absolute error (MAE) Mean squared error (MSE) Mean absolute percentage error (MAPE) Electric Bill 510 315 420 480 Average Forecast Forecast ErrorConsider the following sales data for Bell, Inc. Month Sales ($ Millions) Jan. 10 Feb. 12 March 14 April 16 May 18 June 23 July 26 Aug. 31 Sept. 27 Oct. 18 Nov. 16 Dec. 14 a. Use a three-month weighted moving average to forecast the sales for the months April through December. Use weights of (3/6), (2/6), and (1/6), giving more weight to more recent data. b. Use exponential smoothing with α = 0.30 to forecast the sales for the months April through December. The forecast for January was $12 million. c. Compare the performance of the two methods by using the bias and MAD as the performance criteria. Which performance method is the most reasonable? Why?17. Statistical and observational methods, where adequate data or settings are available in which to apply them, are superior to survey methods of forecasting. Select one O True O False
- 2)Auto sales over a 4-month period were forecasted as follows: 89, 98, 105, and 97. The actual results over the 4-month period were as follows: 92, 96, 101, and 100. What was the MAD of the 4-month forecast? (use an excel sheet to make all calaculations and show formulas used in excel)Corporate triple-A bond interest rates for 12 consecutive months follow. Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 9.5 9.3 9.4 9.6 9.8 9.7 9.8 10.5 9.9 9.7 9.6 9.6 a. Construct a time series plot. What type of pattern exists in the data? b. Develop the three-month moving averages for this time series. Compute MSE. c. Compute MAE. d. Compute MAPE. e. What is the three-month moving average forecast for the next month (month 13)?10 Community General Hospital finds itself treating many bicycle accident victims. Data from the last seven 24-hour periods is shown below: Day Bicycle Victims 1 8 2 14 3 8 4 14 5 18 6 15 What is the forecast for day 4 using a 3-period moving average model? (1 mark) (Round to two decimal places). 11 What is the forecast for day 5 using a 3-period moving average model? (Round to two decimal places). 12 What is the forecast for day 6 using a 3-period moving average model? (1 mark) (Round to two decimal places). 13