QuickExpress charges $10 per vehicle transported plus $0.10 per vehicle and per kilometer. For example, transporting 300 vehicles from Beijing to Client 1 and 500 vehicles from Beijing to Client 2 will cost $17,900 = 300×(10 + 0.1×130) + 500×(10 + 0.1×120).Question 1.1: (5 points)Optimization Models代写Considering that QuickExpress will be transporting all the vehicles manufactured by X treme, propose a mathematical model that will allow X-treme to determine its production plan for Beijing, Shanghai, and Suzhou that minimizes total production and transportation costs. Clearly define all the decision variables, the objective function and each of the constraints.Question 1.2: (3 points)Implement and solve your model in Excel. Clearly describe the optimal solution found.During the latest board meeting at X-treme, the directors have realized that the transportation costs are high probably because of the lack of competition among logistic firms. X-treme has therefore asked different companies that specialize in transportation to provide them with an estimate for the transportation costs of its ATVs. Two (new) companies have submitted their offer, and X-treme has decided to go forward with only one of them. Before choosing which one, X-treme must examine the different possibilities.Optimization Models代写The first company, BeijingExpress, has proposed the following transportation costs: $5,000 each time it must send a vehicle from a plant to a client (for each shipment from a plant to a client and independently of the number of ATVs transported) and an additional $0.05 per ATV and per km. For example, if BeijingExpress transports 300 vehicles from Beijing to Client 1 and 500 vehicles from Beijing to Client 2, the total transportation cost will be $14,950 = (5,000 + 300×0.05×130) + (5,000 + 500×0.05×120).Question 1.3: (5 points)Optimization Models代写Considering that both QuickExpress and BeijingExpress can be hired to transport the vehicles manufactured by X-treme, propose a new mathematical model that will allow X treme to determine its production plan for Beijing, Shanghai, and Suzhou that minimizes total production and transportation costs. (We consider that each plant can have some of its production transported to a given client by QuickExpress, the remaining by BeijingExpress).Question 1.4: (3 points)Implement and solve your new model in Excel. Clearly describe the optimal solution found.Optimization Models代写RapidTransans has also proposed to transport some ATVs. It proposes a transportation cost of $25 for the first 150 vehicles shipped from a plant to a client, and of $20 for all  the other vehicles shipped from the same plant to the same client (independently of the distance). For example, if RapidTransans transports 300 vehicles from Beijing to Client 1 and 500 vehicles from Beijing to Client 2, the total transportation cost will be $17,500 = (150×25 + 150×20) + (150×25 + 350×20).Question 1.5: (5 points)Optimization Models代写Considering that both QuickExpress and RapidTransans can be hired to transport the vehicles manufactured by X-treme, propose a new mathematical model with that will allow X-treme to determine its production plan for Beijing, Shanghai, and Suzhou that minimizes total production and transportation costs. (We consider that each plant can have some of its production transported to a given client by QuickExpress, the remaining by RapidTransans).Question 1.6: (3 points)Implement and solve your new model in Excel. Clearly describe the optimal solution found.Optimization Models代写Question 1.7: (1 point)What is your final recommendation for X-treme: should the company contract BeijingExpress or RapidTransans?PROBLEM 2 (30 points)Optimization Models代写 ABCGrid is planning a maintenance in five power plants (A, B, C, D, E). This maintenance occurs each four years and lasts three consecutive months at each plant. During that time, the capacity of the plant is reduced.The two last columns of Table 2.1 indicate the months during which the maintenance can start at each plant. For example, maintenance at plant A can start at the earliest at the beginning of month 1, and at the latest at the beginning of month 3. The maintenance is specific to each plant. Consequently, the number of maintenance teams required per plant varies. The number of teams required for the maintenance of each plant is also presented in Table 2.1. For example, plant A needs 4 maintenance teams for the first month of the maintenance, 3 teams the following month, and 2 teams for the last month of the maintenance.Optimization Models代写

所有的数学代写范围：essayghost为美国、加拿大、英国、澳洲的留学生提供数学代写、math代写、数学作业代写、math作业代写、数学代考、math代考等留学生数学作业代写、exam代考服务。