Weekly sales of copy paper at Cubicle Suppliers are in the table below. Compute a three- period moving average and a four-period moving average for weeks 5, 6, and 7. Compute each forecast. Which model is more accurate? Forecast week 8 with the more accurate method. Week Sales (cases) 1 17 21 3 27 4 31 19 17 21 +567
Q: a) The demand forecast for Month 6 would be: A. 565 haircuts B. 574 haircuts C. 578…
A: Demand forecast and MAD-
Q: The actual number of patients at Omaha Emergency Medical Clinic for the first sIX weeks of this year…
A: This problem can be solved using the weighted moving average method of forecasting.
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: 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: Sales volume of July was 390. Use exponential smoothing with a smoothing constant o.2 to find the…
A:
Q: (a) Compute a weighted average forecast for the data listed below using a weight of 0.40 for the…
A:
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: for the 8th week using weights of 3, 2, and 1 (where the most recent week receives the highest…
A: THE ANSWER IS AS BELOW:
Q: The following table shows the actual demand observed over the last 11 years: year 1 2…
A: We can calculate a three-year forecast by using the formula- Three-year moving average method ( Year…
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: Complete the "Forecast for tomorrow" column in the table above. Use an exponential smoothing…
A:
Q: When a business is started, or a patent idea needs funding, venture capitalists or investment…
A: A profitability forecast is a set of figures included in a business plan. The result of forecasting…
Q: In order to increase the responsiveness (volatility) of following forecast models, what can you do?…
A: In order to increase the responsiveness of the forecast model using exponential smoothing, we need…
Q: The Hartley-Davis motorcycle dealer in the Minneapolis– St. Paul area wants to be able to forecast…
A: Given Data
Q: DEMAND FORECAST WITH LINEAR REGRESSION Historical demand for a product is: Period MONTH DEMAND x2 XY…
A: Period (x) Month Demand (y) 1 January 12 2 February 11 3 March 15 4 April 12 5 May 16 6…
Q: a) Using a weighted moving average with three periods, determine the demand for period 13. Use 3, 2,…
A: Forecasting is the process of predicting future data based on previous or past data and information.…
Q: Using the exponential smoothing forecast, is it possible to forecast a demand that isbigger than any…
A: Exponential Smoothing:- Like the past 2 techniques, guileless and moving midpoints, the dramatic…
Q: Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for…
A:
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: Explain what are the benefits of exponential smoothing over moving average forecasting
A: The table below gives a prediction of the advantages of moving average over exponential smoothing.
Q: The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts…
A: Given data: Period 1 2 3 4 5 6 7 8 9 10 Actual value 155 145 155 162 180 165 172 149 170 172
Q: Compute the weighted average forecast using the following weights: 0.20, 0.30, 0.10, and 0.40
A:
Q: What should be our forecast accuracy target if there is a high degree of volatility in customer…
A: Forecasting is the process of estimating the future demand according to the historic or previous…
Q: Develop an appropriate forecast model for bookstoremanagement to use to forecast computer demand for…
A: Forecasting is an indispensable method of managing sales by evaluating the future demand for…
Q: Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past…
A: A) Formulae used : Forecast = (1 - smoothing factor) * Most recent period forecast) + (Smoothing…
Q: Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled…
A: Mean Absolute Deviation (MAD) is one of the measures used to summarize historical errors in…
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: 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: Storrs Cycles has just started selling the new Cyclone mountain bike, with monthly sales as shown in…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: Professor Z needs to allocate time among several tasks next week to include time for students'…
A:
Q: Simple exponential smoothing (with a 0.2) is beingused to forecast monthly beer sales at Gordon’s…
A: Formula:
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: Suppose you are working for a baking company in Bangladesh. What are the relevant factors you will…
A: Forecasting is the activity of making estimations of future activities based on past and present…
Q: The table below shows actual demands for Fastway. Week Actual demand 20 63 21 62 22 67 23 66 24 67…
A: Formula for exponential smoothing model : Ft = At-1*alpha + (1-alpha)*Ft-1 The demand table is :…
Q: Suppose you need to forecast the amount of relief aid needed following an earthquake. What type of…
A: Answer: Relief aid needed following an earthquake, belong to the category of disaster relied supply…
Q: 4.31 Emergency calls to the 911 system of Durham, North Carolina, for the past 24 weeks are shown in…
A: Given data is
Q: Forecast is calculating estimates of future cycle/s based on data of past cycles -- there is no…
A: Forecasting is a prediction method that can use historical data and current market trends and…
Q: The manager of a popular tourist resort wants to use the manual trend projection forecasting…
A: The equation for exponential smoothing is- Ft = F t-1 + α(A t-1 – Ft-1) Ft = the exponentially…
Q: The department manager is using a combination of methods to forecast sales of toasters at a local…
A: Weighted moving average means we have different weights and we calculate on previous months data as…
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: A Dallas, TX-based manufacturer of small gasoline engines has developed monthly forecasts for a…
A: Find the Given details below: Month Jan Feb Mar Apr May June Total Expected Demand 800 700 800…
Q: Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for…
A:
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: 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: 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…
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…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 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 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 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?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?
- 1. Solve manually. The following gives the number of pints of type A blood used at Woodlawn Hospital in the past 6 weeks. Pints Used 360 Week August 31 September 7 September 14 September 21 September 28 389 410 381 368 October 5 374 a. Forecast the demand for the week of October 12 using a 3-week moving average. b. Use a 3-week weighted moving average, with weights of 0.1, 0.3 and 0.6, using 0.6 for the most recent week. Forecast demand for the week of October 12. c. Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 360 and c=0.2. d. Compute the MAD for the 3-week moving average, 3-week weighted moving average and exponential smoothing models above.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)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?
- Using naïve method to make a forecast involving data with trend, the forecasted sales volume for week 4 must be ________ units if the actual sales are 500, 510, and 508 in weeks 1, 2, & 3, respectively: * o 506 o 508 o 510 o 50011. Consider the following actual and forecast demand levels for Big Mac hamburgers at a local McDonald's restaurant: Day Actual Demand Forecast Demand Monday 88.00 88.00 Tuesday 72.00 88.00 Wednesday 68.00 84.00 Thursday 48.00 80.00 Friday − ? Part 2 The forecast for Monday was derived by observing Monday's demand level and setting Monday's forecast level equal to this demand level. Subsequent forecasts were derived by using exponential smoothing with a smoothing constant of 0.25. Using this exponential smoothing method, the forecast for Big Mac demand for Friday is __________ Big Macs (round your response to one decimal place).Week Forecast Actual Demand 52 48 42 46 3 56 52 4 45 47 true or false Assume that the actual demand is representative of a repeating pattern over 4 weeks. The cyclical index for Week 1 is (approximately) 1.07 The forecast of demand for Week 5 (F5) using a Simple Moving Average (SMA) with 3 weeks is 48.75. The forecast of demand for Week 5 (F5) using exponential smoothing with alpha = 0.3 is 46.4.