Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Solve the following with explanation : 1. Bring 2017 data from SHEET 1. 2. In 2018, determine the values by considering: forecast a decrease of
Solve the following with explanation :
1. Bring 2017 data from SHEET 1.
2. In 2018, determine the values by considering: forecast a decrease of 8.4%
3. In 2019, determine the values by considering: forecast an increase of 2.4%
4. In 2020, we will use the VLOOKUP function to lookup table (found in colums J and K) to determine multiple forecasts based on the Forecast Code.
5. Calculate the % change in column G.
6. There are 260 operating days per year. The % under Median represents the % change in Median packages from the previous year.