West Indies Batting Inc is again on the rise due to the increasing sale of cricket bats throughout the region. BATS R’ US, a cricket bat-making company located in Charlestown, Nevis has been at the forefront of this increasing sales for cricket bats. The monthly demand in sales at BATS R’ US is provided in the table below. 1. Compute a three-period moving average and a four-period moving average for weeks 5, 6, and 7. 2. Compute the MAD for both forecasting methods. 3. Which model is more accurate? 4. Forecast week 8 with the more accurate method. Month Sale of bats 1 119 2 147 3 189 4 217 5 133 6 119 7 147
West Indies Batting Inc is again on the rise due to the increasing sale of cricket bats throughout the region. BATS R’ US, a cricket bat-making company located in Charlestown, Nevis has been at the forefront of this increasing sales for cricket bats. The monthly demand in sales at BATS R’ US is provided in the table below.
1. Compute a three-period moving average and a four-period moving average for weeks 5, 6, and 7.
2. Compute the MAD for both
3. Which model is more accurate?
4. Forecast week 8 with the more accurate method.
Month |
Sale of bats |
1 |
119 |
2 |
147 |
3 |
189 |
4 |
217 |
5 |
133 |
6 |
119 |
7 |
147 |
Note: - Since we can answer only up to three subparts we will answer the first three subparts(1, 2, and 3) here. Please resubmit the question by specifying the exact or remaining subpart that has to be answered.
Given data is
Step by step
Solved in 4 steps with 7 images