Walmart has become the largest supermarket in America, and as Walmart grows, its net sales also increase. The table below shows Walmart's Net Sales data per quarter from 2015 to 2021. Using this data help Walmart to forecast (using solver excel step by step): • Make a forecast for the next period with the Moving Average method n: 5 • Make a forecast for the next period with the Weighted Moving Average method, 0,1; 0,3 ; 0,2; 0,4 • How much is the change in net sales per quarter? • Using liner trend method how much Net Sales in 2025 Quarter 2? Periods Net Sales 2015 Quarter 1 $ 115.000.000,00 2015 Quarter 2 $ 120.000.000,00 2015 Quarter 3 $ 117.000.000,00 2015 Quarter 4 $ 130.000.000,00 2016 Quarter 1 $ 116.000.000,00 2016 Quarter 2 $ 121.000.000,00 2016 Quarter 3 $ 118.000.000,00 2016 Quarter 4 $ 131.000.000,00 2017 Quarter 1 $ 118.000.000,00 2017 Quarter 2 $ 123.000.000,00 2017 Quarter 3 $ 123.000.000,00 2017 Quarter 4 $ 136.000.000,00 2018 Quarter 1 $ 123.000.000,00 2018 Quarter 2 $ 128.000.000,00 2018 Quarter 3 $ 125.000.000,00 2018 Quarter 4 $ 139.000.000,00 2019 Quarter 1 $ 124.000.000,00 2019 Quarter 2 $ 130.000.000,00 2019 Quarter 3 $ 128.000.000,00 2019 Quarter 4 $ 142.000.000,00 2020 Quarter 1 $ 135.000.000,00 2020 Quarter 2 $ 138.000.000,00 2020 Quarter 3 $ 135.000.000,00 2020 Quarter 4 $ 152.000.000,00 2021 Quarter 1 $ 138.000.000,00 2021 Quarter 2 $ 141.000.000,00 2021 Quarter 3 $ 141.000.000,00 2021 Quarter 4 $ 153.000.000,00

College Algebra

1st Edition

ISBN:9781938168383

Author:Jay Abramson

Publisher:Jay Abramson

Chapter4: Linear Functions

Section4.3: Fitting Linear Models To Data

Problem 24SE: Table 6 shows the year and the number ofpeople unemployed in a particular city for several years....

See similar textbooks

Related questions

Question

Walmart has become the largest supermarket in America, and as Walmart grows, its net sales also increase. The table below shows Walmart's Net Sales data per quarter from 2015 to 2021.

Using this data help Walmart to forecast (using solver excel step by step):

• Make a forecast for the next period with the Moving Average method n: 5

• Make a forecast for the next period with the Weighted Moving Average method, 0,1; 0,3 ; 0,2; 0,4

• How much is the change in net sales per quarter?

• Using liner trend method how much Net Sales in 2025 Quarter 2?

Periods Net Sales

2015 Quarter 1 $ 115.000.000,00
2015 Quarter 2 $ 120.000.000,00
2015 Quarter 3 $ 117.000.000,00
2015 Quarter 4 $ 130.000.000,00
2016 Quarter 1 $ 116.000.000,00
2016 Quarter 2 $ 121.000.000,00
2016 Quarter 3 $ 118.000.000,00
2016 Quarter 4 $ 131.000.000,00
2017 Quarter 1 $ 118.000.000,00
2017 Quarter 2 $ 123.000.000,00
2017 Quarter 3 $ 123.000.000,00
2017 Quarter 4 $ 136.000.000,00
2018 Quarter 1 $ 123.000.000,00
2018 Quarter 2 $ 128.000.000,00
2018 Quarter 3 $ 125.000.000,00
2018 Quarter 4 $ 139.000.000,00
2019 Quarter 1 $ 124.000.000,00
2019 Quarter 2 $ 130.000.000,00
2019 Quarter 3 $ 128.000.000,00
2019 Quarter 4 $ 142.000.000,00
2020 Quarter 1 $ 135.000.000,00
2020 Quarter 2 $ 138.000.000,00
2020 Quarter 3 $ 135.000.000,00
2020 Quarter 4 $ 152.000.000,00
2021 Quarter 1 $ 138.000.000,00
2021 Quarter 2 $ 141.000.000,00
2021 Quarter 3 $ 141.000.000,00
2021 Quarter 4 $ 153.000.000,00

Expert Solution

Step by step

Solved in 5 steps with 1 images

SEE SOLUTION Check out a sample Q&A here