National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Sales (000)Units 14 Month Feb. Mar. 17 Apr May. Jun. 11 19 21 Jul. 22 Aug. 26 b. Forecast September sales volume using each of the following: (1) A linear trend equation.(Round your intermediete calculations end final answer to 2 decimal places.) Yt thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average thousands (3) Exponential smoothing with a smoothing constant equal to 20, assuming a March forecast of 16(000). (Round your intermediate forecast values and final answer to 2 decimal places) Forecast |thousands (4) The naive approach. Naive approach thousands (5) A weighted average using .50 for August, .20 for July, and 30 for June. (Round your answer to 2 decimal places.) Weighted average thousands

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Sales (000)Units 14 Month Feb. Mar. 17 Apr May. Jun. 11 19 21 Jul. 22 Aug. 26 b. Forecast September sales volume using each of the following: (1) A linear trend equation.(Round your intermediete calculations end final answer to 2 decimal places.) Yt thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average thousands (3) Exponential smoothing with a smoothing constant equal to 20, assuming a March forecast of 16(000). (Round your intermediate forecast values and final answer to 2 decimal places) Forecast |thousands (4) The naive approach. Naive approach thousands (5) A weighted average using .50 for August, .20 for July, and 30 for June. (Round your answer to 2 decimal places.) Weighted average thousands

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 president of State University wants to forecast student enrollments for this Year academic year based on the following historical data: 5 years ago 4 years ago 3 years ago 2 years ago Last year Enrollments 15.000 16.000 18.000 20.000 21.000 a- What is the forecast for this year using a 3-year weighted moving average where the weights are halved in a descending order from newest to oldest ? b. What is the forecast for this year using the trend line for these data? c. using the MAD find which forecasting technique may be appropriate for this quetion
The following time series shows the sales of supermarket chain over the last six months. Month Sales ($ 000) August 2021 250 Sep 2021 280 Oct 2021 295 Nov 2021 320 Dec 2021 380 Jan 2022 360 Develop a linear trend equation that can be used to forecast sales in Feb 2022. Forecast the sales in Feb 2021 using a three-period weighted moving average designed with the following weights: Nov 2021 weight 0.6, Dec 2021 weight 0.3 and Jan 2022 weight 0.1. Which method (A or B) is the best? Explain why.
Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 a) Develop a trend line for the demand for fertilizer using any computer software? b) For these three forecasts, 3-year moving average, a weighted moving average, and a trend line, which one would you use? Explain your answer?
Compute the forecasted values for Yt for July and August in 2020 by using the modelsstated in (c) and (d)
What would we call March 2020’s data point? What happened at that point in time to cause this?
Which of the time series forecasting methods would not be used to forecast seasonal data?
Amex PLC has gathered following information on the sales of face mask from April 2020 toSeptember 2020. Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 Augus 21,000September 23,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. Note: You need to show all the steps in your calculation. No excel files will be graded.
Amex PLC has gathered following information on the sales of face mask from April 2020 toSeptember 2020.Month Sales ($)April 17,000May 18,000June 19,500July 22,000August 21,000September 23,000You are required to;a. Using linear trend equation forecast the sales of face masks for October 2020.
The report “Daily Cigarette Use: Indicators on Children and Youth" (Child Trends Data Bank, childtrends.org/wp-content/uploads/2012/11/03 _Smoking_new.pdf, retrieved April 17, 2017) included the accompanying data on the percentage of students who report smoking cigarettes daily, for students in grades 8, 10, and 12. Construct a time series plot for students in grade 12, and comment on any trend over time. Construct a time series plot that shows trends over time for each of the three grade levels. Graph each of the three-time series on the same set of axes, using different colors to distinguish the different grade levels. Either label the time series in the plot or include a legend to indicate which time series corresponds to which grade level. Write a paragraph based on the plot from Part (b). Discuss the similarities and differences for the three grade levels
Which of the following time series forecasting methods would not be used to forecast seasonal data?
Amex PLC has gathered following information on the sales of face mask from April 2020 toSeptember 2020. Month Sales ($)April 17,000May 18,000June 19,500July 22,000August 21,000September 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 averagedesigned with the following weights: July 0.2, August 0.3 and September 0.5. (2
The table given below indicates New Holding Ltd.’s quarterly profits in 2019 and 2020.Time Period Profit (Thousands Of Rands)2019 Q1 2502019 Q2 2102019 Q3 1652019 Q4 1952020 Q1 2652020 Q2 2182020 Q3 1782020 Q4 204 Determine the trend regression function for this data set. Given that the typical seasonal index for Q3 is 87.3, use this informationand the trend regression function obtained to determine theseasonally adjusted trend estimate for profits in Q3 of 2022.