Amex PLC has gathered following information on the sales of face mask from April 2020 to September 2020. 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. Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 August 21,000 September 23,000

Amex PLC has gathered following information on the sales of face mask from April 2020 to September 2020. 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. Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 August 21,000 September 23,000

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section4.5: Correlation And Causation

Problem 2CYU

See similar textbooks

Similar questions

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.
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 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. 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 to September 2020. You are required to; Using linear trend equation forecast the sales of face masks for October 2020. 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. Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 August 21,000 September 23,000
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 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
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?