The quarterly sales for a small leather manufacturer during the years 2005 to 2007 is shown in the table below: Year Quarterly sales in million I II III IV 2005 14 15 17 17 2006 15 16 18 19 2007 18 20 23 25 (i) Calculate a 4 moving average for the above data. (ii) Deseasonalize these sales using a multiplicative model.

The quarterly sales for a small leather manufacturer during the years 2005 to 2007 is shown in the table below: Year Quarterly sales in million I II III IV 2005 14 15 17 17 2006 15 16 18 19 2007 18 20 23 25 (i) Calculate a 4 moving average for the above data. (ii) Deseasonalize these sales using a multiplicative model.

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

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?
(b) Table 1 shows consumables usage data from a leading manufacturer. Forecast the demand for August, September and October using: i) a three-month moving average ii) a four-month weighted moving average using 50 percent of the actual usage for the most recent month, 20 percent of two months ago, 15 percent of three months ago and 15 percent of four months ago. Using an example, explain what are the benefits of using the weighted moving average method of forecasting instead? Month February 2023 March 2023 April 2023 May 2023 June 2023 July 2023 Consumables Used 884 892 972 990 956 880
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.
A group of researchers carried out a survey of household expenditure for an average family and the data are shown in Table 3. Table 3 Commodity 2016 2017 Quantity 105 Price Quantity 100 Price Rice (kg) Bread (loaf) Cocoa powder (kg) Milk (liter) Sugar (kg) 7.30 8.60 3.02 16 3.10 18 10.26 25 7.83 33 6.10 56 6.55 78 2.85 11 2.95 15 (i) Compute the Average Price Relative (APR) index for 2016 and 2017, using 2016 as the base year. (ii) Calculate Paasche Price Index for 2017 (year 2016 = 100). Interpret the answer. (iii) Calculate Laspeyres Price Index for 2017 (year 2016 = 100). Interpret the answer. (iv) Calculate the Fisher's Price index.
47. Given the following data : Weekly take-home pay (wages) Consumer price index Year 109.50 112.8 2012 2013 112.20 118.2 2014 116.40 127.4 2015 125.08 138.2 2016 135.40 143.5 2017 138.10 149.8 () What was the real average weekly wage for each year ? (i) In which year did the employees have the greatest buying power ? (ii) What percentage increase in the weekly wages for the year 2017 is required (if any) to provide the same buying power that the employees enjoyed in the year in which they had the highest real wages ?
Sales of a particular product for the years 2017 through 2020 have been 390, 455, 432 and 487 respectively. What sales would you predict for 2021 using a weighted moving average with weights of 0.45 for the immediate preceding year and 0.3, 0.15 and 0.1 for the three years before that?
The below data represent the advertising expenditure and sales of Little Liu Ltd from year 2008 to 2017. Table: Advertising Expenditure vs. Sales from 2008 to 2017 Year Advert. Expenditure Sales (x, £000) (y, £000) 2008 8 30 2009 12 40 2010 11 29 2011 5 29 2012 14 43 2013 3 17 2014 6 20 2015 8 30 2016 4 22 2017 9 40 Total 80 300 Figure: Scatter Diagram of Advertising Expenditure and Sales with Trend line ( See picture) What is the statistical relationship shown in the Figure and list out 3 characteristics of this relationship? 2. Work out the values of parameters of the relationship shown in the Figure (i.e. work out the equation of the relationship). 3.Explain the relationship and make recommendations to Little Liu Ltd based on the information given.