2021 June 280 2022 June 339 2023 June 363 2024 June 393 2021 July 635 2022 July 432 2023 July 393 2024 July 406 Find: 1. Monthly seasonal factors by using De-seasonal method 2. Forecast for the monthly Apple iPad Pro with sizes of 11inch and 12.9 inch for August 2024 to July 2025. The Table below contains 4-year worth of monthly data of selling Apple iPad Pro with 11inch and 12.9 inch. They want to predict the forecast from August 2024 to July 2025 for the monthly Apple iPad Pro with sizes of 11inch and 12.9 inch. Year Month Actual Demand Actual Year Month Year Month Demand Actual Demand Actua Year Month Dema 2020 August 155 2021 August 257 2022 August 332 2023 August 363 2020 September 180 2021 September 345 2022 September 356 2023 September 386 2020 October 260 2021 October 319 2022 October 345 2023 October 377 2020 November 560 2021 November 374 2022 November 374 2023 November 394 2020 December 160 2021 December 228 2022 December 267 2023 December 318 2021 January 180 2022 January 215 2023 January 317 2024 January 369 2021 February 270 2022 February 341 2023 February 358 2024 February 387 2021 March 600 2022 March 421 2023 March 420 2024 March 441 2021 April 165 2022 April 301 2023 April 315 2024 April 358 2021 Mav 190 2022 May 300 2023 May 373 2024 May 398

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.6: Moving Averages Models
Problem 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...
icon
Related questions
Question

This is for my supply chain and logistics class. Please use deseasonal method using excel for the first problem.  Show all calculations in the cell please.

2021 June
280
2022 June
339
2023 June
363
2024 June
393
2021 July
635
2022 July
432
2023 July
393
2024 July
406
Find:
1. Monthly seasonal factors by using De-seasonal method
2. Forecast for the monthly Apple iPad Pro with sizes of 11inch and 12.9 inch for August 2024 to July
2025.
Transcribed Image Text:2021 June 280 2022 June 339 2023 June 363 2024 June 393 2021 July 635 2022 July 432 2023 July 393 2024 July 406 Find: 1. Monthly seasonal factors by using De-seasonal method 2. Forecast for the monthly Apple iPad Pro with sizes of 11inch and 12.9 inch for August 2024 to July 2025.
The Table below contains 4-year worth of monthly data of selling Apple iPad Pro with 11inch and 12.9
inch. They want to predict the forecast from August 2024 to July 2025 for the monthly Apple iPad Pro
with sizes of 11inch and 12.9 inch.
Year Month
Actual
Demand
Actual
Year Month
Year Month
Demand
Actual
Demand
Actua
Year Month
Dema
2020 August
155
2021 August
257
2022 August
332
2023 August
363
2020 September 180
2021 September 345
2022 September 356
2023 September 386
2020 October 260
2021 October 319
2022 October 345
2023 October 377
2020 November 560
2021 November 374
2022 November 374
2023 November 394
2020 December 160
2021 December 228
2022 December 267
2023 December 318
2021 January
180
2022 January 215
2023 January
317
2024 January
369
2021 February 270
2022 February 341
2023 February 358
2024 February 387
2021 March
600
2022 March
421
2023 March
420
2024 March 441
2021 April
165
2022 April
301
2023 April
315
2024 April
358
2021 Mav
190
2022 May
300
2023 May
373
2024 May
398
Transcribed Image Text:The Table below contains 4-year worth of monthly data of selling Apple iPad Pro with 11inch and 12.9 inch. They want to predict the forecast from August 2024 to July 2025 for the monthly Apple iPad Pro with sizes of 11inch and 12.9 inch. Year Month Actual Demand Actual Year Month Year Month Demand Actual Demand Actua Year Month Dema 2020 August 155 2021 August 257 2022 August 332 2023 August 363 2020 September 180 2021 September 345 2022 September 356 2023 September 386 2020 October 260 2021 October 319 2022 October 345 2023 October 377 2020 November 560 2021 November 374 2022 November 374 2023 November 394 2020 December 160 2021 December 228 2022 December 267 2023 December 318 2021 January 180 2022 January 215 2023 January 317 2024 January 369 2021 February 270 2022 February 341 2023 February 358 2024 February 387 2021 March 600 2022 March 421 2023 March 420 2024 March 441 2021 April 165 2022 April 301 2023 April 315 2024 April 358 2021 Mav 190 2022 May 300 2023 May 373 2024 May 398
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing