Ann’s department at a local department store has tracked the sales of a product over the last ten weeks. Forecast demand using exponential smoothing with an alpha of 0.5, and an initial forecast of 30.0 for period 1. Table 2 Period Demand 1 24 2 23 3 26 4 36 5 26 2. Jason Ltd. operates a store in the Byera area and sells a special brand of cologne to customers in the surrounding areas. The manager of the store has been tracking the sales of the cologne for the last ten years. Table 1 below gives information about the sale of this product. Table 1 Year Sales 2014 90 2015 110 2016 127 2017 165 2018 190 2019 220 2020 275 2021 390 2022 320 2023 350 (a) . Assuming a linear trend, use the tabular method to derive the values for:- the slope the intercept Formulate the linear equation for this problem. Plot the linear equation line on a graph. Develop a forecast for the store’s sales for the next year.
- Ann’s department at a local department store has tracked the sales of a product over the
last ten weeks.
an initial forecast of 30.0 for period 1.
Table 2
Period Demand
1 24
2 23
3 26
4 36
5 26
2. Jason Ltd. operates a store in the Byera area and sells a special brand of cologne to
customers in the surrounding areas. The manager of the store has been tracking the sales
of the cologne for the last ten years. Table 1 below gives information about the sale of
this product.
Table 1
Year Sales
2014 90
2015 110
2016 127
2017 165
2018 190
2019 220
2020 275
2021 390
2022 320
2023 350
(a) . Assuming a linear trend, use the tabular method to derive the values for:-
- the slope
- the intercept
- Formulate the linear equation for this problem.
- Plot the linear equation line on a graph.
- Develop a forecast for the store’s sales for the next year.
Step by step
Solved in 2 steps with 4 images