pleas I want a solution by using excel and as required by liner programming please and thank you so much for helpe us

my subject is Modelling of Engineering Management Systems

General Motor produced a lightweight, all-terrain vehicle named as Terrain-2010 for military use. The company is now planning to sell the vehicle to public. It has five plants that manufacture the vehicle and four regional distribution centres. The company is unsure of public demand for the Terrain-2010, so it is considering reducing its fixed operating costs by closing one or more plants, even though it would incur an increase in transportation costs. The relevant costs for the problem are provided in the following table (Table 1). The transportation costs are per thousand vehicles shipped; for example, the cost of shipping 1,000 vehicles from plant A to warehouse W3 is $30,000. The annual demand from each warehouse of W1, W_2, W3 and W4 is 15,000,12,000,10,000 and 12,000, respectively. The annual production capacity and annual fixed operating costs of each plant are given in the table; for example, the annual production capacity and annual fixed operating cost for Plant A is 12,000 and $2,000,000, respectively. Spring 2022 - ENGG9S3 - Assignment 1 - Tieleg Dang Table 1 Data for Question 4 a) Formulate a linear programming model for this problem (7.5 marks) b) Solve this model by using the computer (7.5 marks) c) Interpret the solution obtained in b) to assist the company in determining which plants should remain open and which should be closed and the number of vehicles that should be shipped from each plant to each warehouse to minimize the total cost