Amex PLC has gathered following information on the sales of face mask from April 2020 toSeptember 2020.MonthSales ($)April17,000May18,000June19,500July22,000August21,000September23,000You 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 averagedesigned with the following weights: July 0.2, August 0.3 and September 0.5.

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; 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.

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; 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.

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

Related questions

Q: None

A: Step 1:Assign time values to each month starting from January 2006January 2006 = 1February 2006 =…

Q: The following scatterplot shows the relationship between the sizes of several condominiums in a…

A: The independent variable is condo size in 100 sq ft (x) and the dependent variable is listing sale…

Q: Amex PLC has gathered following information on the sales of face mask from April 2020 to September…

A: Given, information gathered by PLC on the sales of face mask from April 2020 to September 2020. a)…

Q: Suppose that the waiting times for patients at a local hospital are normally distributed with a…

A: solutionGiven the waiting time forpatients at a local hospital arenormally distributedPopulation…

Q: Year Gross Federal Debt ($millions) 1945 260,123 1950 256,853 1955 274,366 1960…

Q: Consider the following from an estate agent’s business nationally: Month Houses Sold Jan 380…

A: The moving average are used to estimate the average changes that happen over a period of time. There…

Q: 1. Perform a Trend and Seasonal analysis with the following data. Include the trend formula and the…

A: The provided data table:A trend and seasonal analysis must be performed the forecast sales for the…

Q: ompanying table gives the population (in hundred thousands) and number of people not covered by…

Q: Determine the equation of the trend line for the data shown below on Canadian balance of payments…

Q: 18,000 16,000 14,000 12,000.- 10,000

A: Here we have given that A figure consisting of a scatter plot between the Price(dollars) and Weight…

Q: Here are data on the monthly price of gas for a certain year, which is a component of the Consumer…

A: Given data is:Month: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov…

Question

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.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Time Series Analyses, Forecasting Methods, and Indices$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions

Which of the following best describes the trend of the graph? Scatterplot of High School GPA vs Shoe Size 4.0 3.5 3.0 2.5 2.0 5 6 7 8. 9. 10 11 12 Shoe Size There is a positive linear trend. O There is a negative linear trend. O There is no linear trend. High School GPA
r 31. You are given the following trend equation : Y 50 +.8X Origin 2012 ; X units one year ; Y units-profits in (000) rupees. Convert the trend equation to a monthly trend equation and shift the origin to Jan. 1, 2013. aigin on Ist Jul2012 1st 1, i,
Consider the following data:Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Profit ($) 5,9015,901 5,6535,653 5,1545,154 4,8774,877 5,2455,245 5,7985,798 6,9196,919 6,2346,234 5,9585,958 Step 1 of 5 : Determine the three-period moving average for the next time period. If necessary, round your answer to one decimal place.
2021 2020 2019 2018 2017 Sales $ 497,289 $ 327, 164 $ 267,073 $ 197, 102 $ 141,800 Cost of goods sold 251,145 165, 182 137, 037 99,651 70,900 Accounts receivable 23,969 19, 172 18,214 11,511 9,699 Compute trend percents for the above accounts, using 2017 as the base year.
A company has the following monthly sales for the past year. Plot the data points on a line graph and describe the results. Month Sales 1 145 2 146 3 145 4 150 5 148 6 150 7 156 8 160 9 158 10 153 11 152 12 154
please answer within 30 minutes.
Please help with the corrected answers in details: The following time series shows the sales of a particular product over the past 12 months. Month Sales 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 What type of pattern exists in the data? The data appear to follow a trend pattern. The data appear to follow a horizontal pattern. The data appear to follow a cyclical pattern.The data appear to follow a seasonal pattern. (b) Use ? = 0.2 to compute the exponential smoothing values for the time series. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 (c) Use a smoothing constant of ? = 0.4 to compute the exponential smoothing forecasts. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135…
U.S. Civilian Labor Force (thousands) Year Labor Force Year Labor Force 2007 153,918 2012 155,628 2008 154,655 2013 155,151 2009 153,111 2014 156,238 2010 153,650 2015 157,957 2011 153,995 2016 159,640 1. Fit three trend models: linear, exponential, and quadratic. Which model would offer the most believable forecasts? 2. Make forecasts using the following fitted trend models for years 2017-2019. t Exponential 11 12 13
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 ???
The following graph shows the average grade point average for a particular college from 2004 until 2011. Average GPA 3.20 OA OC OD 3.15 3.10 3.05 3.00 2.95 2.90 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Year Which one of the following statements is correct? A) Historically, the Average GPA of the college tends to decrease. B) There appears to be no relationship between Year and Average GPA. C) Year is the dependent variable in the graph. D) Average GPA is the dependent variable in the graph.
a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and use it to predict expected new checking accounts for periods 16 through 19. (Round your intermediate calculations and final answers to 2 deci places.) Period New Accounts Period, New Accounts Period New Accounts 1 2 3 4 Y Y16 Y17 Y18 Y19 200 214 211 220 235 6 7 8 9 10 237 248 250 258 267 11 12 13 14 15 281 275 287 288 316
The following data report total, monthly U.S. gasoline sales in millions of dollars from January 2017 toDecember 2018. (To find the data, go to the site https://www.census.gov/retail/index.html#mrts, find“Monthly Retail Trade Report,” then select “Time Series/Trend Charts.”)Year Month Sales ($ millions)2017 Jan $35,6302017 Feb 33,9722017 Mar 38,6222017 Apr 38,9732017 May 40,7392017 Jun 40,0092017 Jul 39,7972017 Aug 41,2172017 Sep 41,3462017 Oct 41,7172017 Nov 40,1862017 Dec 40,0462018 Jan 39,2232018 Feb 37,3772018 Mar 42,6482018 Apr 43,1092018 May 48,0492018 Jun 47,5462018 Jul…