a) Forecast demand for each week, including week 10, using exponential smoothing with a 5 .5 (initial forecast 5 20). b) Compute the MAD.
Q: three-period moving average. A weighted average using weights of .50 (most recent), .20 and .30.…
A: forecasting is a method which helps to predict the unknown future based on the known past…
Q: 12. Under the bottom-up approach, a central person or persons take the responsibility for…
A: The method of predicting future outcomes based on past and present data by analyzing the trends is…
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: 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: Ralph Billett is the manager of a real estate agency. He now wishes to develop a forecast of the…
A: Find the Given details below: Given details: Sales (Year) Quarter 1 2 3 1 30 59 71 2…
Q: nformation, What will be - forecast of June, using month weighted moving erage with the following…
A: Given Information:
Q: 1. Which of the following forecasting methods is (are) more appropriate for the demand given in this…
A: In the process of forecasting, known data is used to model historical trends across time and make…
Q: Four partners in a big consulting firm try to estimate the number of new recruits neededfor the next…
A: Forecast is an estimation of future data considering the historical behavior of the data. Forecast…
Q: Week Cheeseburger Sales 1 354 2 344 3 368 4 317 5 361 Based on historical observations…
A:
Q: Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10…
A: Given that:Initial Forecast = 20Remember the formula for calculating Forecast =Error = Demand -…
Q: i. What are the 3-months moving average forecasts for months 4, 5, 6 & 7? ii. What are the 3-month…
A: Forecasting is estimated predictions for the present as well as for the future as per the past data.…
Q: 3. You are using a 3 period moving average to calculate your forecast. Demand for period 1 was 90…
A: Given information:Demand period 1=90unitsDemand period 2=80unitsDemand period4=90unitsHere we have…
Q: How can the Forecast technique be improved?
A: Forecasting is a tool or technique which is used to predict future demand, risk and to analyze the…
Q: a. Nalve. Number of requests . A four-perlod moving average. (Round your answer to 2 decimal…
A: Given data, Week Requests 1 25 2 27 3 25 4 26 5 27 For the given data and as per…
Q: a Develop a 3-week moving average forecast for Weeks 4 through 9 Develop a 3-week weighted average…
A: Moving average forecast refers to a technique of getting all the ideas trend in the data set and…
Q: Sales of tablet computers at Ted Glickman's electronicsstore in Washington, D.C., over the past 10…
A: Given data is
Q: Sales of tablet computers at Ted Glickman’s electron-ics store in Washington, D.C., over the past 10…
A: Formula:
Q: National Scan, Ic., sells radio frequency inventory tags. Monthly sales for a seven-month period…
A: Equation: Y= mx + b Where Y is the y coordinate, m is the slope, x is the x coordinate and b is the…
Q: 6. Consider the following data table. (12 Points) a) Forecast demand using exponential smoothing…
A: Error = Real demand - Forecast Absolute Error = Positive value of Error Error Square = square of…
Q: Use simple exponential smoothing with a 0.6 to forecast chargers sales for February through May.…
A:
Q: In January, a car dealer predicted February demand for 150 Honda Accord. Actual February demand was…
A: The forecast value for March at 0.20 smoothing constant is 152.6. The forecast value for March at…
Q: The following data shows sales forecast of Axis Dealer for motorbikes. Month Demand 1 650 2 700 810…
A: Given data:
Q: F1 = F, + a(D, – F,) MA3 = (D1+D2+D3)/3 1+1 Week Calls МАЗ ES Squared Errors with MA3 Squared Errors…
A: 1) The 3-period moving average forecast can be determined in excel as follows: Thus, the forecast…
Q: a. Compute a weighted average forecast using a weight of 0.4 for the most recent period, 0.3 for the…
A: A weighted moving average forecast is a forecast of future values based on past values. A weighted…
Q: How do exponential smoothing have benefits over shifting.averages as a forecasting tool?
A: The benefits of exponential smoothing are as a prediction tool compared to moving averages.
Q: A check-processing center uses exponential smoothing to forecast the number of incoming checks each…
A: The forecasting technique is used to make predictions based on past and present data. Use in the…
Q: Assume that your stock of sales merchandise is maintained based on the forecast demand. If the…
A: The three-month moving average forecast can be determined by adding the past three month values and…
Q: Forecast the demand for the week of October 12 using a 3-week moving average. b) Use a 3-week…
A: Week ofPrints usedAug-31360Sep-07389Sep-14410Sep-21381Sep-28368Oct-05374
Q: After reviewing the forecasting demonstration and looking over the slides, complete the following…
A: Demand Forecasting is the cycle wherein verifiable deals information is utilized to foster a gauge…
Q: Forecast based on averages. Given the following data: Period Number of Complaints 1 70 2 75 3…
A: Forecast for Period 6 using weighted average = 0.5*Demand of Period 5 + 0.3*Demand of Period 4 +…
Q: Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for…
A: Ans) We will use alpha = 0.2 with initial forecast = 17000 miles or 17 ( in 1000's)
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: a) Forecasted sales for year 6 using a 3-year moving average is sales (round your response to one…
A: THE ANSWER IS AS BELOW:
Q: 1 The demand for automobiles at Crescent Auto Dealers for the past 8 weeks is as follows.…
A: Find the Given details below: Given details: Week Auto Demand Weights 1 9 0.1 2 11 0.3 3…
Step by step
Solved in 2 steps with 1 images
- Under what conditions might a firm use multiple forecasting methods?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 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 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?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?
- 12-1. The Hartley-Davis motorcycle dealer in the Minneapolis- St. Paul area wants to be able to forecast accurately the de- mand for the Roadhog Super motorcycle during the next month. From sales records, the dealer has accumulated the data in the following table for the past year. Month January February March April Мay June Motorcycle Sales 7 10 8 7 12 July August September 10 11 12 October 10 November December 14 16 a Compute a three-month moving average forecast of demand for April through January (of the next year). b. Compore a five-month moving average forecast for June drough January. c. Compare the two forecasts computed in parts (a) and (b) using MAD. Which one should the dealer use for January of dhe next year?Sales of hair dryers at the Walgreens stores in Youngstown,Ohio, over the past 4 months have been 100, 110, 120, and 130units (with 130 being the most recent sales).Develop a moving-average forecast for next month, usingthese three techniques:a) 3-month moving average.b) 4-month moving average.c) Weighted 4-month moving average with the most recentmonth weighted 4, the preceding month 3, then 2, and theoldest month weighted 1.d) If next month’s sales turn out to be 140 units, forecast the following month’s sales (months) using a 4-month mov-ing average.Hi, could you help solve 4.2 a b c & d. Thanks
- Following table shows the weekly sales of smart phones at electronic retail store: Week Number of smart phones Sold Forecast using 3 period moving average Error Forecast using exponential smoothing (with α =0.4) Error 1 48 2 41 3 55 4 64 5 62 6 55 7 8 Answer the following questions based on the data given above. Show all your calculations. What is the expected sales for the 7th week based on 3 period moving average. What is the forecast for the 8th week using the same method if the actual sales for week 7 happens to be 70? What is the expected sales for the 7th week based on exponential smoothing with α = 0.3? Which of the above two forecasting method is better based on MSE? Explain why?The demand (in number of units) for Apple iPad over the past 6 months at BestBuy is summarized below. Month Nov 2019 Dec 2019 Demand 45 48 Jan 2020 50 Feb 2020 Mar 2020 Apr 2020 42 46 51 Consider the following three forecasting methods: • Two-month weighted moving average, with weights 6 and 2 (more weight assigned to more recent data) Exponential smoothing with a = 0.7. Let the initial forecast for Nov 2019 be 46. • A trend line projection in the form ŷ = a+bx . To simplify computations, transform the value of x (time) to simpler numbers – designate Nov 2019 as x=1, Dec 2019 as x= 2, etc. (a ) For each of the above methods, forecast the demand of Apple iPad for May 2020. (b) Consider only the two-month weighted moving average method, compute the MAD measure and the MSE measure using the data from Jan 2020. (c) Use the trend line to forecast the demand of Apple iPad for Dec 2020. Give your opinion regarding the reliability of the forecast.Please solve the show solution for the FORECASTING problem. Thanks