Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the 3-period weighted moving average method to forecast the number of sales to expect next month. Use the following weights: 0.4 for the most recent, 0.3 for the 2nd most recent, and 0.3 for the 3rd most recent. Month Demand Forecast 1 308 337 388 341.4 344 368 4. 400 342.8 341 378.4 2)

Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the 3-period weighted moving average method to forecast the number of sales to expect next month. Use the following weights: 0.4 for the most recent, 0.3 for the 2nd most recent, and 0.3 for the 3rd most recent. Month Demand Forecast 1 308 337 388 341.4 344 368 4. 400 342.8 341 378.4 2)

Understanding Business

12th Edition

ISBN:9781259929434

Author:William Nickels

Publisher:William Nickels

Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment

Section: Chapter Questions

Problem 1CE

See similar textbooks

Similar questions

4.
1. The table below shows the sales figure for a brand of shoe over the last 12 months. MONTHS SALES January 69 February 75 March 86 April 92 May 95 June 100 July 108 August 115 September 125 October 131 November 140 December 150 Using the following, forecast the sales for the months up to January the following year:- 1. A simple three month moving average.ii. A three period weighted moving average using weights of 1, 2 and 3. Assign the highest weight to the most recent data.iii. Exponential Smoothing when a= .6 and the forecast for March is 350.
A Use a simple moving average model. Experiment with the models using five weeks and three weeks past data. 3 week MA Week ATL BOS CHI DAL LA TOTAL 1 2 3 4 5 6 7 8 9 10 11 12 13 5 week MA Week ATL BOS CHI DAL LA TOTAL 1 2 3 4 5 6 7 8 9 10 11 12 13 B evaluate the forecast that would have been made over the 13 weeks using overall mean absolutely deviation, mean absolute percent error, and tracking signal as criteria.
Please don't provide handwriting solution
The following data show the number of liters of gasoline sold by Mackrin's in Colorado for the past 12 weeks. Which forecasting model would you recommend to Mackrin's manager? Why? What demand forecast would you recommend for week 13? Week Actual Demand (1000 liters) Forecasting (1000 liters) FSMA /A-F/ FWMA /A-F/ FES, α=0.3 /A-F/ 1 17 2 21 17 4 3 19 18.2 0.8 4 23 19 4 18.44 4.56 5 18 21 3 20.8 2.8 19.81 1.81 6 16 20 4 20 4 19.3 3.3 7 20 19 1 18.3 2.3 18.31 1.69 8 18 18 0 18.7 0.7 18.82 0.82 9 22 18 4 18.2 4.2 18.6 3.4 10 20 20 0 19.8 0.2 19.62 0.38 11 15 20 5 20.2 5.2 19.73 4.73 12 22 19 3 18.2 3.8 18.3 3.7 13 19 19.5 19.41 MAD 2.67 2.9 2.7 MSE 10.22…
Given the following data for demand at the XYZ Company, calculate the monthly forecast for 2003 using a 3-month moving average. Calculate the Forecast, Error, MAD (mean absolute percentage error), Bias and the TS (tracking signal) . Period Demand Forecast Error MAD Bias TS 2-Oct 2012 800 　　　　　 2-Nov 2012 1000 　　　　　 2-Dec 2012 950 　　　　　 2-Jan 2013 1100 2-Feb 2013 930 2-Mar 2013 1020 2-Apr 2013 870
a) Apply moving average and exponential smoothing to generate two forecasts of the closing price for the entire data period. Set appropriate values for the forecast parameters (e.g., k and a). b) Plot and compare the actual and predicted data values you calculated in part (b). Provide one chart that displays actual, moving average, and exponential smoothing lines. Hint: Calculate MSE, MAD, or MAPE to compare the different forecasts. Develop your own forecast from scratch. Do NOT use Excel’s Data Analysis or Forecast Sheets.
Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the 3-period weighted moving average method to forecast the number of sales to expect next month. Use the following weights: 0.4 for the most recent, 0.3 for the 2nd most recent, and 0.3 for the 3rd most recent. Month Demand Forecast 1 308 337 2 388 341.4 3 344 368 4 400 342.8 5 341 378.4
4. The sales (in millions of dollars) for an 18-month period are as follows. Month Sales Month Sales 1 600 600 775 10 775 3 600 11 600 4 650 12 575 700 13 625 800 14 650 550 15 600 8 775 a. Compare a three-month moving average forecast with an exponential smoothing forecast. Use a = 0.1. Which provides the better forecasts based on MSE? b. Find the forecast for the next month using the best forecast method. 2.
Below is the actual demand for electrical boxes for Abco Electric for the last nine periods along with a forecast. A) Complete the Mean Absolute Deviation for this forecast. B) Complete an additional forecast for periods 4-12 using a weighted moving average of your choice. Change the title to describe your method. C) Calculate the MAD for your forecast. D) In the text box below put your comment comparing the accuracy of your forecast versus the one given in A. Was your method more accurate? Why or why not? Use whole numbers for all forecasts. Use ONE decimal place for the MAD calculations. Period Demand Naïve Method Error (e) MAD Your Title here Your MAD 1 855 Abs e Abs e 2 910 3 930 4 890 930 5 935 890 6 980 935 7 1020 980 8 960 1020 9 905 960 10 895 905 11 955 895 12 820 955 MAD D. Your comment on Forecast Accuracy:
A firm uses simple exponential smoothing with trend adjustment to forecast demand, "a = 0.6" and "B=0.6". The Forecast including Trend (FIT) for the 1st month of 2022 was 434 units whereas the actual demand turned out to be 488 units, the trend over that period was 26. Calculate the demand forecast including trend for the 2nd month.
The following represents the actual demand and two different sets of forecasts using different methods. Compute the MAD for each forecasting method and determine the best method for this set of data. Year-Qtr Actual demand Forecast methos 1 MAD1 (A-F) Forecast Method 2 MAD2 (A-F) 2020-3 98 97 89 2020-4 108 110 106 2021-1 83 68 70 2021-2 100 101 102 2021-3 95 86 87 2021-4 90 94 92 2022-1 71 68 72 2022-2 104 105 106 2022-3 84 91 88 2022-4 80 93 91 2023-1 78 68 70 2023-2 120 118 122