UESTION3 1. The table below shows the one-year sales data for a certain part. Month Demand Month Demand January Marc February March 138 July August September October 140 142 107 185 145 April May June 131 113 144 November 189 135 December 128 a. Compute the one-step-ahead 3-month and 6-month moving-average forecasts for July through December. b. Compute the MAD for the forecasts obtained in part (a). What effect does increasing N from 3 to 6 have on the forecasts? c. Use the arithmetic average of the first six months of data as a baseline to initialize the exponential smoothing. Compute the one-step-ahead exponential smoothing forecasts for July through December, assuming a = 0.25. d. Compare the accuracy of the forecasts obtained in part (c) with the one-step ahead six-month moving-average forecasts obtained in part (a).

UESTION3 1. The table below shows the one-year sales data for a certain part. Month Demand Month Demand January Marc February March 138 July August September October 140 142 107 185 145 April May June 131 113 144 November 189 135 December 128 a. Compute the one-step-ahead 3-month and 6-month moving-average forecasts for July through December. b. Compute the MAD for the forecasts obtained in part (a). What effect does increasing N from 3 to 6 have on the forecasts? c. Use the arithmetic average of the first six months of data as a baseline to initialize the exponential smoothing. Compute the one-step-ahead exponential smoothing forecasts for July through December, assuming a = 0.25. d. Compare the accuracy of the forecasts obtained in part (c) with the one-step ahead six-month moving-average forecasts obtained in part (a).

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

The following table present quarterly sales for a company over the three years (a) Fit the trend as a linear function of time t and predict the sales for the 4th year? Year 2 Year 3 309 405 326 429 369 446 416 465 quarter 1 2 3 4 Year 1 241 263 273 292
Consider the monthly unit sales for 2019, the company's full year 2020 forecast, and year-to-date monthly unit sales for 2020. 2020 Company Forecast 2020 YTD 2019 Month Actual Actual Jan 104 101 100 Feb 92 93 103 Mar 105 109 101 Apr 90 101 103 May 95 95 100 Jun 97 99 106 Jul 99 100 102 Aug 101 98 100 Sep 104 106 108 Oct 98 101 101 Nov 91 95 Dec 94 95 You have been asked to revise the 2020 forecast for November. What has the mean absolute deviation been for the first ten months of 2020? Answer with one decimal point. What has the bias been for the first ten months of 2020? Answer with one decimal point. What is your forecast for November, 2020, using the Naive method? Answer as an integer.| What is the forecast for November, 2020 using a three month moving average? Answer as an Integer. What is the forecast for November, 2020 using a weighted average with welghts of 20%, 30% and 50% for August, September and October, respectively? Answer as an integer.
Here is civilian unemployment cate 1982-1995 Civilian Unemployment Cate 1982-1995 year 1982 1986 1988 1990 1992 । ११५ Rode 9.7 7.0 5.4 5.5 7.4 6.1 yeRr 1984 1987 198% 1991 1993 1995 Rode 7.5 6.2 5.3 6.7 6.8 5.6 Make deta. dime plot o the
6. The Motion Picture Association of America reports a drop-off of video disc sales. The data in the table below shows consumer spending on video discs (DVD, Blue-ray, and UltraHD Blu-ray) in the United States in the years 2015-2018. Year Consumer Spending on video discs (in billions of dollars) 2015 9.1 2016 8.0 2017 6.8 2018 5.8 (a) What was the average rate of change in consumer spending from 2015 to 2018? (Be sure to include units.) (b) Use the average rate of change calculated above to predict consumer spending on video discs in 2020?
Quarterly Glass Container Demand Year 1990 1991 1992 First Qtr. 17,446. 17,748. 17,595. Second Qtr. 17,785. 19,360. 18,338. Third Qtr. 18,971. Fourth Qtr. 19140. 17,802. 19,413. 18,315. 18,083. Question: Quarterly sales (in thousands of units) of a product over the last two years have been 26, 29, 30, 27, 28, 32, 33, and 30. Plot the data and forecast for the next period using Winter's Seasonal Model. Now, assume sales for the ninth quarter turned out to be 32. Update your parameter estimates and forecast sales for period 10.
Given the following, determine yesterday’s residual for sales if 18 people were working and sales were $24,000.
Given the following data and seasonal index: Month Sales Year 1 Year 2 Jan 8 8 Feb 7 9 Mar 5 6 Apr 10 11 May 9 12 June 12 16 July 15 20 Aug 20 25 Sept 4 4 Oct 3 2 Nov 8 7 Dec 9 9 (a) Compute the seasonal index using only year 1 data. (b) Determine the deseasonalized demand values using year 2 data and year 1's seasonal indices.
3. Below you are given the first four values of a monthly time series of sales. You want to predict the sales of May based the time series data. Month Time Series Value Yt January 120 February 135 March 150 April 175
II.
Illustration 13.1. Construct index numbers of prices from the following data using (a) Laspeyre's (b) Paasche's (c) Marshall and fEdgeworth, and (d) Fisher's methods. 1960 1970 Commodity Price Qиantity Price Quantity A 4 50 10 40 3 10 9. 2 C 4 2
Illustration 12.2. The sale of a commodity in tonnes varied from January 1961 to December 1961 in the following manner: 280 300 280 280 270 240 230 230 220 200 210 200 Fit a trend by the method of semi-average.
An entrepreneur who owns and operates two businesses (A and B) would like to analyze their profitability. They would like your help in the analysis. They give you the annual net profit (in thousands of $) for each business from 2008-2020. Table 1: Annual Net Profits for Businesses A and B Business Year Profit Business Year Profit 2008 -50 2008 -10 2009 57 2009 30 2010 71 2010 27 2011 64 2011 22 2012 60 2012 21 2013 50 2013 20 A 2014 41 2014 24 2015 59 2015 24 2016 71 2016 32 2017 71 2017 36 2018 74 2018 37 019 81 20 40 2020 97 2020 49 a. Suppose you want to graph the distribution of profits. Explain why using only one stem- plot might not be optimal for the analysis. b. Describe the correct stemplot to use. Generate this stemplot. Explain your steps. What can you say about the distribution from this stemplot? c. When are stemplots useful? And why is that? d. Suppose that instead of having 26 observations you have 200 observations. What graph should you generate? e. What other type of…