ENGM451 ( Production and planning control )

Q3) You work for BMW as a planner. BMW sold 1,081,000 ofits BMW-X5 cars in 2019 and sold 1,189,100 ofits BMW-X5 cars in 2020.BMW is expecting to increase its annual sales for BMW-X5 in year 2021 by 10% compared to year 2020 (total sales volume=1,308,010). Find the monthly forecast and seasonal indices for year 2021, given the following data: (Please considers the monthly seasonal effect) MONTH Forecasted Car Sales (2021) Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec Actual Car Sales (2019) 80,000 85,000 86.000 90,000 92.000 100,000 120.000 90,000 86.000 85,000 84,000 83,000 Actual Car Sales (2020) 88,000 93,500 94,600 99,000 101,200 110,000 132.000 99,000 94.600 93,500 92,400 91,300