Given the following demand data,a. Compute a weighted average forecast using a weight of .40 for the most recent period,. 30 for the next most recent, .20 for the next, and .10 for the next.b. If the actual demand for period 6 is 39, forecast demand for period 7 using the sameweights as in part a.Period Demand1 422 403 434 405 41
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: Given the following data, use exponential smoothing(a = 0.2) to develop a demand forecast. Assume…
A: Given data Exponential smoothing (a) or α= 0.2 Initial time period (F1) = 5 To develop the demand…
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: Explain the word "false" for a successful forecast?
A: A difference between real and forecasted values is referred to as "fake" in forecasting strategies.…
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: Tracy is the the Director of Supply Chain at Circuits Inc. An accurate forecast at Circuits Inc. is…
A: Error = Actual demand - Forecast Absolute Error = Positive Value of Error MAD = Average of Absolute…
Q: Given a 3-quarter period of actual and forecast demand as shown in the table. The company ABC sets a…
A: A forecasting method is a managerial tool which help to predict the unknown future based on…
Q: The historical data for 4 periods demand are 65, 60, 80, and 70 respectively. Calculate the weighted…
A: The answers would be as follows:
Q: (a) Compute a weighted average forecast for the data listed below using a weight of 0.40 for the…
A:
Q: Given the following demand data, Period Demand 57 1 2 55 3 59 4 56 5 60 a. Compute a weighted…
A: Forecasting is the process of estimation in which future demand is determined using the previous and…
Q: Given current demand in this period of 103, a forecast for this current period of 99, and an alpha…
A: Exponential smoothing is a forecasting model which helps to identify the forecasting value based on…
Q: Given the following history, use a three-quarter moving average to forecast the demand for the third…
A: Sum of the Last Quarter = 200+260+260 = 720 Sum of Second last quarter = 165+200+175 = 540 Sum of…
Q: The demand data for Double T Computer Services appears below. The company wants you to forecast the…
A: THE ANSWER IS AS BELOW:
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: 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: Forecasted Year Sales Sales 2005 455 415.00 2006 510 427.00 2007 516 451.90 2008 570 471.13 2009 585…
A: Given that: Smoothing constant = 0.6 Starting Forecast = 415 and Year Sales 2005 455 2006 510…
Q: Consider the following actual (A,) and forecast (F,) demand levels for a commercial multiline…
A: The forecast for period 5 can be computed as follows:
Q: The Yummy Ice Cream Company uses the exponential smoothing method. Last week the forecast was…
A:
Q: The following table shows the actual demand observed over the last 11 years: Year 1 2 4 7 8 10 11…
A: Given - Table for demand seen in past years- Year Actual Demand 1 6 2 9 3 4 4 9 5 13…
Q: a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.55 and a week 1…
A: Exponential smoothing formula : Ft = At-1*α + (1- α)*Ft-1 Error = Actual value - Forecasted value…
Q: Sales for a product for the past three months have been 200,350, and 287. Use a three-month moving…
A: A three-month moving average method averages the actual demand for the previous three months to…
Q: (Round your answers to 2 decimal places.) Complete the table above, filling in the "Forecast for…
A: Forecast refers to the estimation of the future happening according to the previous and current 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: a) The forecasted demand for the week of October 12 using a 3-week moving average = pints (round…
A: Forecasted demand is the future demand of customers predicted based on the previous data or demand.…
Q: A large Portland manufacturing would like to forecast the monthly demand for a piece of…
A: Given that: Month Actual Demand 1 14 2 17 3 20 4 21 5 25
Q: Clinic administrator Marc Schniederjans wants you to forecastpatient demand at the clinic for week 7…
A: Weighted moving average=∑Weight for period nDemand for period…
Q: orecast demand for each week, including week 10, using exponential smoothing with a 5 .5 (initial…
A: Exponential smoothing is forecasting method which identifying the farecasting value based on the…
Q: Period 1 2 3 4 5 6 1. Compute the four period moving average forecast for period 6 and 7. Assume the…
A:
Q: 1. The Southern Pizza Parlor is a small restaurant. One of the customers' favorites is Southern…
A: Forecasting helps to know the sales of the product in advance so that appropriate stock levels are…
Q: Using exponential smoothing with a weight of 0.6 on actual values: (a) If sales are $45,000 and…
A: Serial No Years Actual sales(At) Forecast sales(Ft) F1 2017 45000 - F2 2018 50000 45000 F3…
Q: (a) Suppose the data in the table below represents total revenues (in $ millions) for one real…
A: Below is the solution:-
Q: A firm uses simple exponential smoothing with trend adjustment to forecast demand, "a = 0.6" and…
A: Given, TAF for first month TAF1 = 434 units Actual demand for first period A1= 488 units Trend T1 =…
Q: Sales of tablet computers at Ted Glickman's electronicsstore in Washington, D.C., over the past 10…
A: Given data is
Q: Plot the demand data. What do you observe? Forecast XR-42S demand for month 7, using a weighted…
A: Given data - Month Number of lenses sold 1 12 2 17 3 15 4 20 5 18 6 23
Q: Sales of tablet computers at Ted Glickman’s electron-ics store in Washington, D.C., over the past 10…
A: Formula:
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: 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: 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: How does this forecast differ from that using employment as the independent variable? What is the…
A: Forecasting is a method of making well-informed forecasts regarding the direction of future trends…
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: 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: Interpret the MAD of the most accurate among the forecasting models below. A. Naïve approach; B.…
A: Find the Given details below: Given Details: Month Demand (100 Liters) 1 39 2 47 3 39 4…
Q: Th e manager of a small health clinic would like to useexponential smoothing to forecast demand for…
A: In exponential smoothing; Here,
Q: If actual recent demand was 41.5, using the focus forecasting approach, the forecast technique to…
A: THE ANSWER IS AS BELOW:
Q: Given the following demand data, compute a simple exponential smoothing forecast for alpha values of…
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…
Given the following demand data,
a. Compute a weighted average
b. If the actual demand for period 6 is 39, forecast demand for period 7 using the same
weights as in part a.
Period Demand
1 42
2 40
3 43
4 40
5 41
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
- Under what conditions might a firm use multiple forecasting methods?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?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 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?
- Given the following demand data, Period Demand 1 47 2 44 3 47 4 44 5 48 a. Compute a weighted average forecast using a weight of 0.4 for the most recent period, 0.3 for the next most recent, 0.2 for the next, and 0.1 for the next. (Round all your answers to two decimal points.) b. If the actual demand for period 6 is 48, forecast demand for period 7 using the same weights as in part a. Forecast Period 7 ______B). Using exponential smoothing, calculate the forecasts for months 2, 3, 4, 5, and 6. The smoothing constant is 0.2, and the old forecast for month I is 245. Month Actual Demand Forecast Demand 1 260 2. 230 3 225 4 245 5 250 6. C). Given the following average demand for each month, calculate the seasonal indices for each month. Month Average Demand Seasonal Index January 30 February 50 March 85 April 110 May 125 June 245 July 255 August 135 September 100 October 90 November 50 December 30 Total 3 D). Using the data in part A and the seasonal indices you have calculated, calculate expected monthly demand if the annual forecast is 2000 units. Month Seasonal Forecast Index January February March April May June July August September October November DecemberPlease do not give solution in image format thanku supose that the demand in period 1 was 7 units and the demand in period 2 was 9units . Assume that the forecast for period 1 was for 5 units .If the firm uses exponential smoothing with an alpha value of .20. what should be the forecast for period 3
- Given the following data, use exponential smoothing (α = 0.10) to develop a demand forecast. Assume the forecast for the initial period is 9. Period Demand 1 2 10 13 1 9.00 3 7 The exponential smoothing forecast is (round your responses to two decimal places): Period 2 Forecast 9.10 3 9.40 4 6 4 8.80 5 8.70 5 10 6 9.10 6 4 7 8.50Given the Actual Demand from January to June of 2021, along with the forecasts based on three (3) selected methods. JAN FEB MAR APR MAY JUN Actual 960 1,230 1,520 1,350 1,800 1,920 Method 1 1,308 1,073 1,150 1,467 1,425 1,682 Method 2 1,324 1,215 1,219 1,310 1,322 1,465 Method 3 867 979 1,340 1,330 1,930 2,524 From the different methods, which is best? 1, 2, or 3? py What is the MAD value of the best method? What is the MSE value of the best method? What is the MAPE value of the best method? Answer using two decimal places.a. Use a 3-month moving average to estimate the month-in-advance forecast of demand for months 4–12 and generate a forecast for the first month of next year. Calculate the average forecast error and mean absolute error. b. Use a 3-month weighted moving average with weights of 0.6, 0.3, 0.1 (most recent to least recent, respectively) to calculate month-in-advance forecasts for months 4–12 and forecast for the first month of next year. Calculate the average forecast error and mean absolute error. c. Compare the average forecast error and MAD for the forecasting methods in parts a and b. Based on these error calculations, which of the two forecast methods would you recommend? Why?