Q6. Demand Forecasting A car company has the historical sales data below. Please use the following two methods to predict the demand in the future. The demand of this company has an assumption: the demand in a month depends on the last three months' demand. Use Excel to get the prediction results (copy the Excel results and paste here, including a figure to show your prediction result) 1. Three-month moving average 2. Autoregressive model based on the last three months Month Demand 2021-10 154632 |2021-11 155378 2021-12 154902 2022-1 155071 2022-2 155660 2022-3 156288 2022-4 156665 2022-5 156865 2022-6 157445 2022-7 158138 2022-8 157967 2022-9 158055 2022-10 Please predict Q7. Weighted Center of Gravity A food company needs to build a warehouse facility at the center of gravity weighted by the demand volume (measured by tons) given the following information of five marketplaces. Find this facility's location (find the weighted center of gravity), represented by the horizontal coordinate and vertical coordinate. Marketplaces Demand (tons) Horizontal coordinates Vertical coordinates 200 ABCDE 1 11 300 7 11 400 5 9 500 7 7 700 1 1