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

Month Actual demand Forecasted Demand 1 950 1000 2 1070 1000 3 1100 1000 4 960 1000 5 1090 1000 6 1050 1000 For the dataset above, compute the overall MAPE.
Amex PLC has gathered following information on the sales of face mask from April 2020 to September 2020. Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 August 21,000 September 23,000 You are required to; a. Using linear trend equation forecast the sales of face masks for October 2020. b. Calculate the forecasted sales difference if you use 3-period weighted moving average designed with the following weights: July 0.2, August 0.3 and September 0.5.
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?
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 ?
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…
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.