b) What is this year's forecast using a three-year weighted moving average with weights of 0.5, 0.3, and 0.2?
Q: The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest…
A: C) Using a two-period weighted moving average method the forecast for a period is calculated as the…
Q: snip
A: Forecast Error = 4, 8, and -3 Forecast Error | Forecast Error| Error2 1 4 4 16 2 8 8 64 3…
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: Identify the critical conditions and trade-offs to take into account when selecting forecasting…
A: When choosing the forecasting technology, the important considerations cost and accuracy are…
Q: State the various uses of forecasting in points wise answer
A: The pattern is regarded as the predictive method to decide on the company.
Q: a) Using exponential smoothing and given a, the forecast for the month of July =million checks…
A: Below is the solution
Q: Explain why it's important to keep track of forecasting errors.
A: For a time series or other phenomenon of interest, forecast error is the difference between the…
Q: 2. The department manager using a combination of methods has forecast sales of toasters at a local…
A: Below is the solution:-
Q: Explain when to use of a time series forecasting techniques and what assumption are made ?
A: The statistical procedures perform statistical analysis on historical data to forecast the…
Q: a. Using a three-week moving average, what would you forecast the next week to be number.) Forecast…
A: Forecasting is predicting in advance what future sales/demand can be.
Q: List specific weaknesses of consumer surveys, sales composite and committee manager to develop a…
A: Consumer survey is a way to gauge the customer satisfaction and demand. through conducting a survey.…
Q: State when is the time series forecasting is used ?
A: Forecasting is a process that utilizes historical information and reports to forecast future events.
Q: Explain the basic assumptions made when using time series forecasting techniques as opposed to…
A: The Time Series Initial Phase makes a variety of assumptions.
Q: snip
A: Given errors are: 3, 2, -2, 9 Running Sum of Forecast Errors (RSFE), is given by: RSFE = ∑ Errors…
Q: Explain what are the use of a time series forecasting and discuss what assumption are made ?
A: Globalization is the process of bringing together individuals, businesses, and governments on a…
Q: What is a time series and the rationale for forecasting based on a time series analysis?
A: Forecasting refers to the prediction of the future based on some evidence or a strong base.…
Q: List the various type of analytical tools and methods used in forecasting?
A: Numerous statistical approaches are used to examine the data, which enables the data to be…
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: Discuss when is time series forecasting used?
A: Forecasting is a strategy for forecasting future events using historical data and knowledge.
Q: Calculate the forecast for Week 16 using - a 2-period moving average - a 3-period moving average…
A: Given data is
Q: Explain the relationship between forecasting and quality management?
A: Total quality management (TQM) is a continual process of identifying and avoiding or eliminating…
Q: Explain what are some of the potential advantage of a more formalized approach to forecasting
A: Forecasting is a method of accurately anticipating future demand to plan for it. Manufacturing and…
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: How has the technology had an impact on forecasting?
A: Technology plays an important role in forecasting and has the ability to have a huge impact. We will…
Q: snip
A:
Q: Based on the time series data presented above, do the forecasts using 2-month moving average (2-MA)…
A: THE ANSWER IS AS BELOW:
Q: Justify the trade-off between responsiveness and consistency in a time-series forecasting system.
A: TradeoffTradeoff is a situational decision taken approach, that involves diminishing quality,…
Q: Choose the type of forecasting technique (survey, Delphi, averaging, seasonal, naive, trend,…
A: Seasonal forecast is a type where the prediction is done only in that particular season. This is…
Q: Describe when to use of a time series forecasting techniques and what assumption are made?
A: Statistical approaches are used to forecast variables by analysing historical data. Forecasts are…
Q: b) If the check-processing center received 45 million checks in the month of July, then using…
A: Forecasting is the process of predicting the future demand or sales of customers based on previous…
Q: Explain the difference between qualitative and quantitative approaches to forecasting. Describe…
A: Forecasting is the method of forming foresight dependent on historical and existing or present…
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: Use simple exponential smoothing with a 0.6 to forecast chargers sales for February through May.…
A:
Q: What factors would you consider in deciding whether to use wide or narrow control limits for…
A: Control limits are the boundaries defined in a control chart within which all the random errors that…
Q: onsider the following time series data. Week 1 2 3 4 5 6 Value 18 12 15 11 18 13 Using the…
A: Given that: Week Value 1 18 2 12 3 15 4 11 5 18 6 13
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: MSE
A: 3 period moving average = First month + Second month + Third month 3
Q: You have quarterly training data on beer production From 2006 to the end of 2007. Use the average…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
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: Discuss the basic assumptions made when using time series forecasting techniques as apposed to…
A: Time series forecasting fundamental assumptions:
Q: Explain when is time series forecasting used ?
A: Forecasting is the process of predicting future events based on previous data and information.
Q: A)- Explain the calculation method for the Naive Forecast model. B) If at the end of every month…
A: Forecasting the values in advance helps to reduce the cost, and increase profits by reducing wastage…
Q: What is bias error in forecasting? What are some of the causes?
A: Bias error refers to the mistake in forecasting, which shows difference between the actual outcome…
Q: b) The forecast for the next month (Jan) using the naive method= 22 sales (round your response to a…
A: Forecasting is the process of predicting future events or trends based on past and present data.…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- Under what conditions might a firm use multiple forecasting methods?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 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.Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?
- Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?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.Sales of hair dryers at the Walgreens stores in Youngstown, Ohio, over the past 4 months have been 100, 110, 120, and 130 units (with 130 being the most recent sales). Develop a moving-average forecast for next month, using these three techniques:a) 3-month moving average.b) 4-month moving average.c) Weighted 4-month moving average with the most recent month weighted 4, the preceding month 3, then 2, and the oldest 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 moving average.
- If the demand in the current week was 102 units and we had forecast it to be 125, what would be next week’s forecast using an exponential smoothing model with an alpha of 0.3?Sales of hair dryers at the NOVO Store in City of San Fernando over the past 4 months have been 100, 110, 120 and 130 units (with 130 being the most recent sales). Develop as moving-average forecast for next month, using these three techniques: a. 3-month moving average b. 4-month moving average. c. Weighted 4-month moving average with the most recent month weighted 4, the preceding month 3, then 2 and the oldest month 1The 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?)