a) Calculate the three-period moving-average forecast for periods 7 through 10. Three-period Period Actual moving average 64 21 84 91 4 97 115 135 137 8. 144 153 10 171 b) Calculate the weighted moving average for periods 7 through 10 using weights of 0.6, 0.3, c 0.1. 02 9 ENG
Q: When creating a time series–based forecast for the amount of soda to be sold in thecafeteria next…
A: Step 1: When creating a time series–based forecast for the amount of soda to be sold in thecafeteria…
Q: I Using a numerical example, demonstrate to Mr. Ferdinand how he can use a three- week and a…
A: Forecasting the future demand/sales can be done by various methods like moving average, weighted…
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: Below is a table containing data on product demand for the most recent five months along with the…
A: Forecast by using 3 period simple moving average method-
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: Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 18 15 Using the…
A: The naïve method of forecasting uses the value of the previous week as the current week's forecast.…
Q: Exponential Smoothing Forecasting Use the area below to draw a line chart for single exponential…
A: Exponential Smoothing Forecasting Ft+1 = At-1×α+1-αFt Error = Actual data -Forecast data Mean…
Q: a) Using exponential smoothing and given a, the forecast for the month of July =million checks…
A: Below is the solution
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: Time left 0:30:19 The sales of XYZ company for the previous three periods are 45,42, and 43…
A: The following is the data provided: Period Data January 45 February 42 March 43 The…
Q: forecast for weeks 7-24 using 6 week weighted moving average
A: Weighted moving average is a forecasting model which helps to identify the forecasting using the…
Q: Problem 4 - do both a three period moving average and an exponential smoothing forecast with an…
A: Forecasting is the process of predicting the future demand based on the previous data and demand.
Q: • 4.33 Storrs Cycles has just started selling the new Cyclone mountain bike, with monthly sales as…
A: a) Using excel for performing regression with Sales as the dependent variable and period as…
Q: a. A linear trend equation. b. A four-month moving average. C. Exponential smoothing with a…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: b) What is this year's forecast using a three-year weighted moving average with weights of 0.5, 0.3,…
A: The concept of Operation Management: Operation management is the management that applies to a…
Q: Employing a 4 period moving average, forecast periods 5-8 and determine the forecast error (round 2…
A: 4 Period Moving Average forecast = sum of the actual demand of last 4 periods / 4…
Q: A number of factors must be taken into consideration when selecting a particular forecasting model.…
A: A.The determination of a technique relies upon numerous elements—the setting of the estimate, the…
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: A supermarket has experienced weekly demand of milk of D1 = 120, D2 = 127, D3 = 114, and D4 = 122…
A: Note: I have answered for 1st question. Kindly post the second question separately. Compute forecast…
Q: Determine the Forecast Error for the data below using the Mean Absolute Percentage Error (MAPE)…
A: Error = Demand - Forecast Absolute Error = Positive value of Error Percent Error = (Absolute error…
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: Daily high temperatures in St. Louis for the last week were as follows: 93, 94, 93, 95, 96, 88, 90…
A:
Q: Given is a historical time series for job services demand in the prior 6 months. Month Demand 1…
A: The weighted average is a forecasting method in which higher weight is given to the most recent data…
Q: Indicate how and why each of these factors is important to thesuccessful operation of a…
A: Forecasting is used to predict future changes or demand patterns. It involves different approaches…
Q: Professor Z needs to allocate time among several tasks next week to include time for students'…
A:
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: Explain how can does the number of periods in a moving average affect the responsiveness of the…
A: Moving Average (MA) forecasting calculates the average over a certain number of periods in order to…
Q: b. Given the forecast demand and actual demand for a fishing boat, compute the tracking signal and…
A:
Q: What benefits does exponential smoothing have over moving averages as a forecasting tool?
A: As a forecasting function, exponential smoothing has the following benefits over running averages:…
Q: 5. Compute a three-period moving average forecast and five-period moving average forecast given…
A: Moving average forecast method is a simple average method in which forecast for next period is…
Q: How do you forecast a department or service area such as a pet store
A:
Q: Develop a forecast of enrolment beginning 2014 to 2021 using 3-years moving average forecast…
A: Forecasting is a technique that helps the business to predict the unknown future using the known…
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: QUESTIONS All Ans to 3 Decimal Places Use the Naiive method to forecast for Feb -Aug 2021 2…
A: As per our guidelines, we are supposed to answer only three sub-parts if multiples sub-parts are…
Q: A time-series trend equation is 25.3 + 21x. What is your forecast for period 7? A. 32.3 B.…
A: Forecasting is the process in which future demand is determined by estimation using previous data or…
Q: a) Using a 2-month moving average, the forecast for periods 11 and 12 is (round your responses to…
A: Forecasted demand is the future demand of customers predicted based on the previous data or demand.…
Q: What effect does the number of cycles in a moving average have on the forecast's responsiveness?
A: In order to estimate potential demand, the Moving Average (MA) projection method uses the MA formula…
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: (3) A weighted average using.60 for August, .30 for July, and .10 for June (4) Exponential smoothing…
A: Forecasting is the process of prediction in which sales demand is estimated using historic…
Q: b. Compute all possible forecasts using a five-period moving average. (Round your answers to 1…
A: Forecasting is the technique that is used to predict future trends on the basis of historical 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: 9 438 18 482 a. Explain why an averaging technique would not be appropriate for forecasting. b. Use…
A: Forecasting is an important part of any business. It helps to predict future demand and production…
Q: b. If 275 units were actually demanded this month, what would your forecast be for next month, again…
A:
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: orecast sales for the 11th period. For leveling, use exponential smoothing 0.20 and moving average 3…
A: THE ANSWER IS AS BELOW:
Q: If actual recent demand was 41.5, using the focus forecasting approach, the forecast technique to…
A: THE ANSWER IS AS BELOW:
Q: Local city government statistics show the rate of new driver’s license applications to be as…
A:
Q: Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for…
A:
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 5 images
- 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 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_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.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?
- At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.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_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_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 past two years sales at ACSR Inc. were 3 million and 5 million. Their forecast team used a two-period moving average to forecast its sales this year. But the actual sales for this year were 5 million. Now, the forecast team wants to forecast its sales for next year by using exponential smoothing with alpha equals 0.6. What is the forecast using exponential smoothing with alpha = .6? 2. If we decide to use an alpha of .2 instead of .6, will we be ‘weighting the error from the previous period higher or the Forecast from the previous period higher? Explain briefly or show using math! (In this question I am asking if we change the alpha to a lower alpha, what will be the effect – what will we be ‘weighing’ as more important?)Emergency calls to Winter Park, Florida’s 911 system, for the past 24 weeks are as follows: Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of 50 calls in the first week and use = 0.1. What is the forecast for the 25th week? Reforecast each period using = 0.6.