Suppose that a 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 5 of these sales representatives to dallas and at least 5 to chicago. according to travelocity, for april 2010, 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: $385; san francisco to chicago: $211; new york (laguardia) to dallas: $273;
new york (laguardia) to chicago: $182. for these two trade shows, this computer company has a total airfare budget
of $4830. determine how many sales representatives this company should send from new york city to each trade show
and how many sales representatives should be sent from san francisco to each trade show in order to satisfy the staffing
requirements and stay within the company’s airfare budget while maximizing the total number of sales representatives that
are sent.

a.) organize information from the problem shown.
b.) write and clearly label the objective function and constraints.
c.) solve the optimization problem using excel.
d.) write the solution using complete sentences.