Problem 4 - do both a three period moving average and an exponential smoothing forecast with an alpha of .2. Calculate the MAD and MPE for each. Months Actuals 1 400 2 350 3 325 4. 300 300 6. 285 290
Q: Sara manages one of the Albireds shoe lines, and is working to improve the group's forecasting…
A: Given data is
Q: Given the Actual Demand from January to June of 2021, along with the forecasts based on three (3)…
A: Find the Given details below: Given details: Jan Feb Mar Apr May Jun Actual 960 1230 1520…
Q: Forecast is calculating estimates of future cycle/s based on data of past cycles -- there is no?
A: The strategy is the set of different activities and plans that helps to achieve the organizational…
Q: Calculate the Tracking Signal to two decimal places.
A: SOLUTION: Tracking Signal = 2.35 Hence, the solution of this answer is as below:
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: Explain how flexibility in productions system relates to the forecast horizon and forecast accuracy?
A: Investigate how flexibility can be used in a manufacturing system to understand the concept of a…
Q: Chambers Hotel use the simple exponential smoothing technique to forecast its occupancy for every…
A: Given- Actual demand for last Saturday At = 42 rooms Forecast for last Saturday Ft = 50 rooms…
Q: 5-15 Develop a 4-month moving average forecast for Wallace Garden Supply, and compute the MAD. A…
A:
Q: New Accounts Period New Accounts Period 200 6 232 11 214 248 12 3 211 250 13 4 228 253 14 235 10 267…
A: Given data is
Q: a. Compute a three-week moving average forecast for the arrival of medical clinic patients in week…
A: It is a method which calculates the overall demand of past & present in data set. It is useful…
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: Using the moving average forecast, is it possible to forecast a demand that is biggerthan any…
A: Forecasting is the procedure of prediction making for the future grounded on past as well as present…
Q: Zeus Computer Chips Inc. used to have major contracts to produce the Centrino-type chips. The market…
A:
Q: Assignment What if we use a 3-month simple moving average? Kroger sells (among other stuff) bottled…
A:
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: Period 1 2 3 4 5 6 3. Using the table below, forecast using exponential smoothing. Assume the Alpha…
A:
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: 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: March demand was pridicted at 590 units of gear cycles of trevaa Itd. But the actual demand was 400…
A: Given: March forecasted demand (Ft-1) =590 Units Actual march demand(At-1) = 400 Units Alpha= 0.72…
Q: Using a weighted moving average with weights of 0.55, 0.35, and 0.15, for periods 3, 2, and 1…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Calculate the mean square error, mean absolute deviation and the Period Year Call Volume forecast…
A: Find the given details below: Given Details: Period Year Call Volume forecast Error 1 1 30 45…
Q: Dave's Bar-B-Q operated a moble kitchen that serviced construction sites, office buildings, and…
A: From the given data, Let F3 = forecast value for third week of june Y2= 6 F2=4.7…
Q: g Calcuiate fore cost sales for June using each of the fo llowing method: - i) Naive Method 1) 3…
A: Forecasting is the process of predicting future data based on previous or past data and information.…
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: 4. What is the difference between trend and seasonality in time series data? 5. Here are the errors…
A: Note: - Since the exact question that has to be answered is not specified, we will answer only the…
Q: Assuming actual product demand were 1,500; 1540; 1,520; 1,550; and 1,560 for Weeks 1, 2, 3, 4, and…
A: Error represents the deviations in the forecasted values in comparison to actual value. %error=…
Q: 1. Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of…
A: THE ANSWER IS AS BELOW:
Q: Question 18 A tire company needs a forecast for studded tires in the next forecast period. The…
A: Given: A smoothing constant of alpha = 0.20. The demand for the most recent period = 100 The…
Q: Can you either overestimate or underestimate the actual sales number for a poor forecast?
A: A forecast is a foresight of whatever will occur. While usually practiced in the circumstances of…
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: 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: Question 1. The dean of a school of business is forecasting total student enrollment for this year…
A: The concept of Operation Management: Operation management is the management that applies to a…
Q: Seatwork Compute for MAD, MSE and MAPE using Moving Average Model (past 3 Weeks), В. А. Exponential…
A: Forecasting is the process of estimating the future demand or sales using the previous years or…
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: 2. Using the same table above, compute the weighted moving average forecast for demand for four…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: What is Use a naive method to make a forecast?
A: Naïve method of forecasting is a simple forecasting method where the sales or demand of the previous…
Q: State the Common features that describe principles of forecasting. The lost Paradise of Dilmun Park…
A: (1) Principles of forecasting states that any forecasting technique that is being used must be such…
Q: a) Calculate the 3-month Moving Average Forecast for sales from April/2019 to Januar enter them in…
A: Below is the solution:-
Q: While monitoring the forecast values in last 5 months, the tracking signals are consistently coming…
A: The tracking signal is given the ratio of accumulated forecast error to average error, with 0 being…
Q: 5. Demand for patient surgery at Washington General Hospital has increased steadily in the past few…
A: Forecasting is the process of estimating the future demand and sales based on the previous month or…
Q: If actual recent demand was 41.5, using the focus forecasting approach, the forecast technique to…
A: THE ANSWER IS AS BELOW:
Q: Passenger miles flown on Northeast Airlines, a commuterfirm serving the Boston hub, a re shown for…
A: Given data is
Q: Daily demand for newspapers for the last 10 days has been as follows: 12, 13, 16, 15, 12, 18, 14,…
A: Given data; Weights ; (3/5) for period 10 (1/5) for period 9 (1/5) for period 8 Demand for ; 15…
Q: Using the double exponential smoothing forecast, is it possible to forecast a demand thatis bigger…
A: Forecasting is a prediction method that can use historical data and current market trends and…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 11 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?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 should Sharon do in this situation?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?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?
- Week Sales1 27502 31003 32504 28005 29006 30507 33008 31009 295010 300011 320012 3150Develop a three-week moving average. A.What is the forecast for week 5? (Make sure no decimal place and no comma. EX: 1234) B.What is the value of MSE (mean squared error) with regard to a three-week moving average? (Make sure no decimal place and no comma. EX: 1234) C.Develop the exponential smoothing with the alpha value of 0.20. What is the forecast for week 5? (Make sure no decimal place and no comma. EX: 1234) D.What is the value of MSE (mean squared error) with regard to the exponential smoothing? (Make sure no decimal place and no comma. EX: 1234) E.Which method is more accurate? (1 for Moving average, 2 for Exponential Smoothing)Given November actual demand of 61, November forecast of 58, and an alpha of 0.4, November trend value +1.03, Beta of 0.3 what would the forecast including trend (FIT) for the December period be using exponential smoothing model 2? Select one: a. 62.03 b. cannot be found c. 68.76 d. 65.72Solve the following:1. Sales of Volkwagen’s popular Beetle have grown steadily at autodealership in Nevada during the past 5 years (see table below). The sales manager had predicted before the new model was introduced that first-year sales would be 410 VWs. Using exponential smoothing with a weight of α= .30, develop forecast for years 2 through 6.Year Sales1 450 4102 4953 5184 5635 5846?2. The following data come from regression line projections:ForecastPeriod 1234Forecast Values 410419428435Actual values 406423423440Compute the MAD and MSE.
- Specific motors produces electronic motors for power-actuated valves for the Medicalconstruction industry. Specific's production plant has operated at near capacity forover a year now. JOSEPH Bakkabulindi, the plant manager thinks that the growth insales will continue, and he wants to develop a long- range forecast to be used to planfacility requirements for the next 3 years. Sales records for the past 10 years havebeen accumulated: N.B: Show all the workings. Solve with Linear regression. Year Annual sales (000's of units) Year Annual sales (000's of units 1 500 6 1,000 2 650 7 1,100 3 900 8 1,300 4 1,000 9 1,450 5 1,000 10 1,600A concert promoter is forecasting this year's attendance for one of his concerts based on the following historical data: Year Attendance 4 years ago 10,000 3 years ago 12,000 2 years ago 18,000 Last year 20,000 What is this year's forecast using exponential smoothing with alpha = .2, if last year's smoothed forecast was 15,000? %3D A. 20,000 B. 19,000o C.17,500 D.16,000 E.15,000b. Kim’s department at a local department store has tracked the sales of a product over thelast nine weeks. The demand can be seen in the table below.Period Demand1 242 233 264 365 266 307 328 269 25i. Forecast demand using exponential smoothing with an alpha of 0.3, and an initialforecast of 30.0 for period 2 to 9.ii. Use a 5-period moving average, forecast the demand up to period 9.iii. Using MAD, determine which forecasting technique is better.