A company wants to forecast demand using the weighted moving average. If the company uses three prior yearly sales values (i.e., the year 2014 = 155, the year 2015 = 140 and year 2016 = 170), and we want to weight the year 2014 at 30%, the year 2015 at 35% and year 2016 at 40%, which of the following is the weighted moving average forecast for the year 2017? 170 158 O 164 O 160

A company wants to forecast demand using the weighted moving average. If the company uses three prior yearly sales values (i.e., the year 2014 = 155, the year 2015 = 140 and year 2016 = 170), and we want to weight the year 2014 at 30%, the year 2015 at 35% and year 2016 at 40%, which of the following is the weighted moving average forecast for the year 2017? 170 158 O 164 O 160

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Show the steps on excel to plot the graph and insert the equation on the graph
Use exponential smoothing with trend adjustment to forecast demand for period 11. Let α = 0.5, � = 0.3, and let the initial trend value be 12 and the initial forecast be 200
Demand for oil changes at Garcia's Garage has been as follows: Number of Oil Changes January 44 February 49 March 66 IT April 59 May 53 June 58 59 63 Month July August a. Use simple linear regression analysis to develop a forecasting model for monthly demand. In this application, the dependent variable, Y, is monthly demand and the independent variable, X, is the month. For Janu The forecasting model is given by the equation Y=+x. (Enter your responses rounded to two decimal places) J Show Transcribed Text >. Use the model to forecast demand for September, October, and November. Here, X=9, 10, and 11, respectively. (Enter your responses rounded to two decimal places.) Forecast for the number of Oil Changes Show Transcribed Text Month September October November can you do all the parts please corrrect
The observed demand from the four quarters of Year 1 can also be used to developinitial deseasonalized forecast estimates that are required to start making forecasts withthe exponential smoothing models. The first real forecast will be for Q1 of Year 2, andthe use of simple exponential smoothing requires an estimated deseasonalized forecastfrom Q4 of Year 1 to use as a starting point. The estimated deseasonalized “forecast” forQ4 of Year 1 should be obtained as the average deseasonalized quarterly demand fromYear 1. The estimate can also be used as the starting base forecast component for Q4 ofYear 1 for trend-adjusted exponential smoothing. The initial deseasonalized trendcomponent estimate for Q4 of Year 1 should be assumed to be zero.
B. The following table shows the number of televisions sold over the last ten years at a local electronic store. year TV sales 1 150 2 300 3 480 4 600 5 630 6 640 7 700 8 825 9 900 10 980 i. Using the trend projection, develop a formula to predict sales for years 11 and 12. Develop a table to calculate the slope and intercept. Please Show All Working. Use that formula to forecast television sales for years 11 and 12
The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: The value of the forecast is Week Actual No. of Patients 45 49 IT 56 40 44 55 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.250 one period ago, 0.250 two periods ago, and 0.167 three periods ago. a) What is the value of your forecast? patients (round your response to two decimal places). 123456
Demand for oil changes at Garcia's Garage has been as follows: Month January February March April May June July August Number of Oil Changes 38 55 56 60 58 01 70 52 a. Use simple linear regression analysis to develop a forecasting model for monthly demand. In this application, the dependent variable, Y, is monthly demand and the independent variable, X, is the month. For January, let X=1; for February, let X 2; and so on. The forecasting model is given by the equation Y=X (Enter your responses rounded to two decimal places)
A forecaster is assessing two different models for demand. The output from each model and the actual demand data appears in the table. Use MAD to compare the two models. Which model does a better job of forecasting? Demand Model 1 52 52 54 56 60 56 58 58 52 57 53 57 Model 2 21 55 54.7 51.9 54.5 52.0 53.8 55.8 59.6 56.4 52 53.5 53.5 55.5 56.5 57.5 57.8 58.0 58.0 56.0 52.6 56.3 56.6 55.0 53.4 O Model 2 is 9% better O Model 1 is 8% better O Model 2 is 15% better O Model 1 is 5% better
10. Quarterly demand for Jaguar XJ8’s at a Tacloban Auto dealership is forecast with the equation, Y = 10 + 3x Where; X = time period (quarterly): Quarter 1 of 2021 = 0Quarter 2 of 2021 = 1Quarter 3 of 2021 = 2Quarter 4 of 2021 = 3 and so on...The demand for the luxury car is seasonal, and the weights of quarter 1, 2, 3, and 4 are 80%, 100%,130%, and 90% respectively. Using the trend projection, forecast the demand for each quarter of2023 and 2024. Then adjust each forecast with the weighted indices.
We are using Winter’s method and monthly data toforecast the GDP. (All numbers are in billions of dollars.)At the end of January 2005, Lt 600 and Tt 5. We aregiven the following seasonalities: January, 0.80; February,0.85; December, 1.2. During February 2005, the GDP is ata level of 630. At the end of February what is the forecastfor the December 2005 level of the GDP? Use a b g 0.5.
Since the beginning of the year, the purchase manager at a department store has been recording sales data to be used to compute 4-period moving averages to forecast sales for an upcoming month. Sales data for the months of January through September are reported in the table below. Month January February March April May June July August September Sales 21 20 39 22 29 14 42 28 27 Computed forecast values are not rounded. Compute the four-period moving average forecast for October. value as a whole number by rounding. Specify the Compute the mean absolute deviation (MAD) for the four-period moving average forecasts. Specify the MAD as a whole number by rounding. Compute the mean squared error (MSE) for the four-period moving average forecasts. Specify the MSE as a whole number by rounding. Compute the mean absolute percentage error (MAPE) for the four-period moving average forecasts. Specify the MAPE as a whole number by rounding. CHECK ANSWER
The long-term financial forecast plays a crucial part in the company's long-term strategic plan. True or False True False 25 28 étv N 4