Operations Management Project

see all attachments please 🙂

Walmart (2012-2023)

find- Trend-adjusted exponential smoothing, compute the mean absolute deviations (MAD)

Data pulled from: https://www.macrotrends.net/stocks/charts/WMT/walmart/revenue

2

>Sheet

1 Walmart Brooke

Brooke

Brandon Period Month/Quarter/Year Actual Data Values (In Millions) Moving Average (

3

year) Weighed Moving Average (3 year) Exponential smoothing Linear trend Trend-adjusted exponential smoothing 1

20

12 $

4

4

6

,

5

0

9 $425,4

8

1 $431,885 2

2013 $468,651 $445,6

7

0 $453,470 3

2014 $476,294 $463,818 $468,782 4

2015 $485,651 $476,865 $479,699 5

2016 $482,130 $481,358 $482,331 6

2017 $485,873 $484,551 $484,588 7

2018 $500,343 $489,449 $492,484 8

2019 $514,405 $500,207 $504,962 9

2020 $523,964 $512,904 $516,841 10 2021 $559,151 $532,507 $539,964 11 2022 $572,754 $551,956 $560,088 12

2023 $611,289 $581,065 $589,754 Forecasting methods MAD Moving average $29,712.00 Weighted moving average $31,770.00 Exponential smoothing
Linear trend

Trend-adjusted exponential smoothing

*Data from

https://www.macrotrends.net/stocks/charts/WMT/walmart/revenue

https://www.macrotrends.net/stocks/charts/WMT/walmart/revenue