Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January February March 345 290 395 375 470 365 April Мay 460 475 400 440 June 470 325 July August September October 430 365 325 280 375 375 535 November 570 December 550 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third 0.25. Solve the problem using quarters, as opposed to forecasting separate months. (Round your answer to 2 decimal places.) Forecast for the fourth quarter

Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January February March 345 290 395 375 470 365 April Мay 460 475 400 440 June 470 325 July August September October 430 365 325 280 375 375 535 November 570 December 550 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third 0.25. Solve the problem using quarters, as opposed to forecasting separate months. (Round your answer to 2 decimal places.) Forecast for the fourth quarter

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

Repair revenues from labor costs of the bicycle shop are given below: X 7.1 2.2 7.2 3.1 3.3 3.5 7.7 4.1 6.8 4.7 5.3 5.5 6.1 Y 3.9 1.7 3.7 1.5 2.2 1.4 4.9 2.5 4.5 3.4 2.3 3.6 3.2 Determine whether there is significant relationship at 0.05 level of significance Predict the value of Y if x are 2.7 and 1.5.
You collect data of average annual returns for Amazon Stock and Microsoft Stock and make the following table: (This data can be copied into Excel.) Year Amazon Return Microsoft Return 2013 0.5896 0.1221 2014 -0.2218 0.2416 2015 1.1778 0.1944 2016 0.1095 0.1200 2017 0.5596 0.3766 2018 0.2843 0.1874 2019 0.3216 0.5526 You use this data to answer the research question: are true population Amazon Returns greater than true population Microsoft Returns?
53. Calculate seasonal index numbers from the following data : RATIO OF OBSERVED TO TREND VALUES (%). Year II IV 2012 108 130 107 93 2013 86 120 110 91 2014 92 118 104 88 2015 78 100 94 78 2016 82 110 98 00 86 2017 X3 If the sales of goods X by a firm in the first quarter of 2018 are worth Rs. 2,00,000, determine how much worth of the goods should be kept in stock by the firm to meet the demand in each of the remaining three quarters of 2018 by using the seasonal index numbers calcuiated above. 106 118 105 98
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.
Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note that the 1st quarter is January, February, and March; 2nd quarter April, May, June: 3rd quarter July, August, September; and 4th quarter October, November, December. Note: Round final answer to a whole number. JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER Last year 120 145 155 195 205 220 170 160 150 220 245 270 This year 145 155 175 210 215 210
The table below represents the monthly unemployment rates in the US from January of 2005 through May of 2016. Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2005 5.3% 5.4% 5.2% 5.2% 5.1% 5.0% 5.0% 4.9% 5.0% 5.0% 5.0% 4.9% 2006 4.7% 4.8% 4.7% 4.7% 4.6% 4.6% 4.7% 4.7% 4.5% 4.4% 4.5% 4.4% 2007 4.6% 4.5% 4.4% 4.5% 4.4% 4.6% 4.7% 4.6% 4.7% 4.7% 4.7% 5.0% 2008 5.0% 4.9% 5.1% 5.0% 5.4% 5.6% 5.8% 6.1% 6.1% 6.5% 6.8% 7.3% 2009 7.8% 8.3% 8.7% 9.0% 9.4% 9.5% 9.5% 9.6% 9.8% 10.0% 9.9% 9.9% 2010 9.7% 9.8% 9.9% 9.9% 9.6% 9.4% 9.5% 9.5% 9.5% 9.5% 9.8% 9.4% 2011 9.1% 9.0% 9.0% 9.1% 9.0% 9.1% 9.0% 9.0% 9.0% 8.8% 8.6% 8.5% 2012 8.2% 8.3% 8.2% 8.2% 8.2% 8.2% 8.2% 8.1% 7.8% 7.8% 7.8% 7.9% 2013 7.9% 7.7% 7.5% 7.5% 7.5% 7.5% 7.3% 7.2%…
48. From the data given below, calculate seasonal indices for I, II, III and IV quarters assuming the trend is absent : Quarter Year 2014 2015 2016 2017 2013 41 45 44 40 42 35 36 38 35 37 II 38 36 38 38 39 II 40 41 42 IV 40 38
The following table shows the price per share of Apple stock at the beginning of different months. Calculate the four-month weighted moving average for October 2021. Round your answer to the nearest cent. Month July 2021 August 2021 September 2021 October 2021 November 2021 December 2021 Apple Stock Price Simple Moving Average Weighted Moving Average $136.60 $146.36 $152.83 $141.90 $148.99 $167.48 ???
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.
PArt C D
Suppose that a firm's sales were $3,750,000 five years ago and are $5,250,000 today. What was the geometric mean growth rate in sales over the past five years?
The following table shows the average monthly production of coal in tonnes for the year 2010-2019. Year Production (in tonnes) Year Production (in tonnes) 2010 50.0 2015 38.1 2011 36.5 2016 32.6 2012 43.0 2017 41.7 2013 44.5 2018 41.1 2014 38.9 2019 33.8 Compute the price indices from 2010 to 2019 by taking 2019 as the base year. Compare the price of 2014 and 2017. What is the percentage (%) change in the production from 2016 to 2019?