Please use excel to solve and please show how you did it thanks.

Suppose that a particular computer company has 12 sales representatives based in New York City and 18 sales representatives based in San Francisco. To staff an upcoming trade show in Dallas and another trade show in Chicago, this company wants to send at least 15 sales representatives to Dallas and at least 10 sales representatives to Chicago. Also, at least 5 of the sales representatives in San Francisco must be sent to Dallas. According to Travelocity, for October 2017, the lowest round-trip airfares (including taxes and fees) for a one-week stay, with tickets purchased two weeks in advance, are as follows: San Francisco to Dallas: $440; San Francisco to Chicago: $280; New York (LaGuardia) to Dallas: $380; New York (LaGuardia) to Chicago: $280. Using Excel Solver, determine how many sales representatives this company should send from New York City to each trade show and how many should be sent from San Francisco to each trade show in order to satisfy the staffing requirements while minimizing the total airfare required to send the representatives. Be sure to select keep the Solver solution and generate answer report. Solver Your task is to use Excel Solver and solve the optimization problem. (a) Create a workbook named Flight.xlsx. Insert a Documentation worksheet and add appropriate title for the workbook in cell Al. In cell B3 enter your name. In cell B4 enter your student number. In cell B5 enter the completion date of your assignment and in cell B6 enter a sentence to describe the purpose of the workbook. (b) Using a new worksheet, formulate and enter the flight problem as shown in class. You can also find several examples on this type of problems on Blackboard under Lecture 4 folder. (c) Enter Solver Parameters (Set Objective, To, By Changing Variable Cells and Subject to the Constraints) (d) Solve the problem. Be sure to select Keep the Solver Solution and generate Answer report. Note: If you get an internal memory error message, remove Solver as an add-in, close the workbook, open the workbook, add Solver in again, and finish using Solver. (e) Using the same worksheet, answer the following questions. i. How many sales representative this company should send from New York and San Francisco to each trade show? ii. What is the minimum total airfare required to send these representatives? (rounded your answer to the nearest cent) (t) Format your workbook as desired (Headings, Font, Fill color, Number format...)