solution

/in /by

From the 10-K reports on sec.gov on GAP INC. what are the 13-16 quarters of sales data for GAP INC from 2018-2020 on an excel spreadsheet? (Calculate the deseasonalized sales).

Obtaining the sales for the latest 13-16 quarters (data should have sales for all of 2018 thru 2020 and some of 2021). You can get this information from www.sec.gov link. Quarterly sales are in the 10-Q reports and annual sales are in the 10-K reports. This is the sec link to GAP INC. https://www.sec.gov/edgar/browse/?CIK=39911&owner=exclude

Forecast using the following methods (use the deseasonalized data) Start each forecast in period 5 and continue through four periods into the future. .

1) Moving Average

2) Weighted Moving Average

  1. Exponential Smoothing (use both values of a). Discuss which a is best in your case.
  2. Trend Adjusted Forecast.

5) Least Squares (use all your data to calculate your ‘a’ and ‘b’ value.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"