Given below are the demands of a certain product over the past 10 weeks. Week | 1 | 2 | 3| 4 | 5 6 | 7| 8 | 9 | 10 Demand 50 64 66 68 67 63 69 67 65 66 (a) Forecast the demand for the 13th week using the following techniques: i. 3- week weighted moving average with weights 0.2, 0.3, and 0.5 ii. Exponential smoothing with a smoothing constant equal to 0.85 iii. Adjusted exponential smoothing with a smoothing constant equal to 0.85 and smoothing constant for trend equal to 0.65
Q: Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six…
A: Absolute Error = | Actual sales - Forecast | MAD = Average of Absolute Error
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: When forecasting demand for new products, sometimes i rms will use demand data from similar existing…
A: Demand forecasting is the technique used by managers to forecast the expected future demand and…
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: 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: Following are two weekly forecasts made by two different methods for the number of gallons of…
A: Formula to solve this problem: - MAD=Sum of errornMSE = Sum of Squared errorn
Q: Rosa’s Italian restaurant wants to develop forecasts of daily demand for the next week. Th e…
A: Solution - Given that Day Week 1 Week 2 No of Customers No of Customers Tuesday 52 48…
Q: What are the benefits of exponential smoothing over moving average forecasting?
A: The following are the advantages of exponential smoothing over moving averages as a forecasting…
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: Week 1 2 3 4 5 6 7 8 9 10 Demand 20 21 27 37 26 29 36 20 25 28 The forecast for weeks 2 through 10…
A: Forecasting is the procedure of doing estimations of upcoming activities on the basis of past and…
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: 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: 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: i. What are the 3-months moving average forecasts for months 4, 5, 6 & 7? ii. What are the 3-month…
A: Forecasting is estimated predictions for the present as well as for the future as per the past data.…
Q: What is meant by the term tracking the forecast? In which two ways can forecasts go wrong?
A: Tracking the forecast means comparing the actual demand with the forecasted demand. It is used to…
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: Kuwait-Arab Medical Supplies - started in January 2020 to help in protecting against COVID19. KAMS…
A: 1. Season 1 forecast with simple moving average method =(1000+4000+2000+5000)/4=3000 So, as per…
Q: The MAD for Method 1 = enter your response here thousand gallons (round your response to three…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In business…
Q: Part 1 The accompanying dataset provides the closing prices for four stocks and the stock exchange…
A: Given data for stock B is
Q: Why is accurate forecasting so important to companies thatuse a continuous replenishment inventory…
A: Continuous Replenishment is a method by which a supplier is told day by day of real deals or…
Q: Using seasonal relatives. Apple’s Citrus Fruit Farm ships boxed fruit anywhere in the world.…
A:
Q: Assuming actual product demand were 1,500; 1540; 1,520; 1,550; and 1,560 for Weeks 1, 2, 3, 4, and…
A: Forecasting is the process of estimating the future demand using previous or historic data or…
Q: why forecasting is needed in business a. to ascertain resource requirements b. to project profit…
A: Forecasting is a form of making knowledgeable predictions by utilizing historical data as the major…
Q: What should be our forecast accuracy target if there is a high degree of volatility in customer…
A: Thank you for you question. As per our guidelines, We will be answering the first question for you…
Q: Distinguish between Planning and Forecasting. Answer must briefly.
A: Future demand is the forecasted demand for the products and services expected from the customers.
Q: 1. Discuss the differences between Qualitative and Quantitative forecasting models. How do…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
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: Describe three different forecasting applications at Hard Rock.Name three other areas in which you…
A: Introduction: Hard Rock Cafe is a restaurant chain which is founded in the year 1971 in London and…
Q: Problem 1: Sheet 1 a) Find on the Internet a time series, which contains at least 20 entries.…
A: Find the Time series data below: Note that, the below data was collected from the website…
Q: 7. The following are forecasting steps done as part of financial planning. 1) Preparing projected…
A: The question is related to fill the blanks with appropriate answer.
Q: Table 1 shows two budget forecasts F1 and F2 for a project. The project contains a set of activity A…
A: Given data is
Q: Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for…
A: Given-
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: Assume that the actual sales volume were 1,800; 2,000; 1,700; 1,600; 1,900; and 2,100 for Days 1 to…
A:
Q: Exponential Smoothing, Exponentially Smoothed MAD, and Tracking SignalThe XYZ Company was flooded by…
A: Formula:
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: 4. A new car dealership is considering opening branches in three of the largest cities in the state.…
A: Forecasting is the practice of predicting future events by focusing on long-term trends. Basically,…
Q: a. A manufacturing firm manufactures electric motors. The sales during the last four months…
A: The mean absolute deviation is extremely high with a worth of 18.85% and this leads to extreme…
Q: The following table is given. What is the demand forecast for period 13 if the Winter model is used?…
A: Given data: Demand forecast for 8th period = 7056 Trend forecast for 8th period = 227 Observing the…
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: October 5 a) Forecast the demand for the week of October 12 using a 3-week moving average. b) Use a…
A:
Q: What are the advantages and disadvantages of aggregating deman from a forecasting view? Are there…
A: The upsides of accumulating request from an estimating view make it conceivable to have a general…
Q: Th e manager of a small health clinic would like to useexponential smoothing to forecast demand for…
A: In exponential smoothing; Here,
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: 1 demand of cotton(intones) by Westham textile S.C are shown below year 1 2 3 4 6 7 8 Actual demand…
A: Given information, Year Actual Demand 1 10 2 11 3 13 4 15 5 14 6 16 7 18 8 20
Q: If actual recent demand was 41.5, using the focus forecasting approach, the forecast technique to…
A: THE ANSWER IS AS BELOW:
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: 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 4 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.
- 11. 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).Weekly demand for dry pasta at a supermarket chain is as follows. Week Demands1 5172 5103 5574 4985 4986 4447 5268 4419 54110 445 a. Forecast the demand for week 11 by using five-period moving average.b. Calculate the same using weighted average methods with weights are 0.3, 0.2, 0.2, 0.1 and 0.2 with start assigning weights to the most recent data12-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?
- Tools View Week 3 Bonus Activity- DEMAND FORECASTING CASE STUDY After reviewing the forecasting demonstration and looking over the slides, complete the following case activity and transfer your answers to the appropriate questions in the Canvas activity quiz. You have been hired as a demand planning intern for Hawaiian Island Creations (HIC). They want you to de- velop a forecast for their HIC Papanui style of sun- glasses. The goal is to determine how many pair they will produce to meet retailer demand in July 2021. During your first meeting, you were handed some data to work with and the product team talked about the company's upcoming promotional blitz to support Summer Break '21 in major vacation destinations. Month Forecast Demand January 2021 4.000 3,300 February 2021 4,200 3,900 March 2021 4,500 4,300 April 2021 4.800 4,200 May 2021 5 000 5.400 of 4 P Type here to search 立When forecasting demand for new products, sometimes i rms will use demand data from similar existing products to help forecast demand for the new product. What technique is this an example of?4-Forecasting using Exponential Smoothing The first five periods of demand data are shown in the following table .Let the smoothing coefficient, alpha, equal 0.2.Compute the exponentially smoothed forecasts for periods one through four .Initialize the procedure with a forecast value for period one of 37. Period Aggregate Demand Forecast demand 0 - - 1 38 37 2 42 3 40 4 36 5 42 Determine the Running Sum of Forecast Errors (RSFE), the Mean Absolute Deviation, MADt-1,and the Tracking Signal(TS) at the end of each period. Let the initial MADt-1 for period 0 be equal to 2.
- 6. Consider the following data table. (12 Points) a) Forecast demand using exponential smoothing with an apha of 0.25, and an initial forecast of 128.0 for period 1. b) Calculate the MAD and MSE. Period Real demand 130 138 129 140 3 4 5 133b. 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.National Standard, Inc. sells radio frequency identification (RFID) tags. Monthly demand for a seven-month period is reported below: Sales (1000 units) Forecast Observation Month Yt Ft 1 February 19 2 March 18 3 April 15 4 May 20 5 June 18 6 July 22 7 August 20 8 September ? Use Excel to plot the data and forecast September sales using the following methods: The naïve forecast A three-month moving average Exponential smoothing with a smoothing coefficient of α = 0.2, assuming a February forecast of 19 A 3-month weighted moving average, with weights 0.60, 0.3, and 0.1. With 0.6 applied to the most recent past.