Please solve this and provide steps to create model in excel.

Question A (30 Marks) A car manufacturer company manufactures Product Type 1 in three of its factories in Europe. Thefactories are located in the UK, Germany and Italy. The production capacity for each factory over tenext period is presented in Table 1: The company distributes this product through four distribution centres located in France, Netherlands, Poland, and Romania. The next period demand forecast for each of these distribution centres is presented in Table 2: The transportation cost () of moving each unit of product from origin to destination is presented in Table 3: Given the available data for the company: A. Formulate a linear programming model that can be used to determine a plan for minimising tetotal distribution costs. Explain every step of the modelling process, including defining the variables, objective function, and the constraints. (20 marks) B. Formulate the linear model in Excel and link it with Excel Solver. Ensure all functions are correctly included. (10 marks) Note: formulating the linear programming model is sufficient for this question; you do NOT need to solve the formulated model