FOR THE FOLLOWING QUESTION, PLEASE ANSWER USING EXCEL SOLVER. FORMULATE THE EXCEL FILE AND POST PICTURES ON HOW IT IS DONE.

Question $1$:

When you lease $800$ phone numbers from AT&T for telemarketing, AT&T uses an optimization model to tell you where you should locate calling centers to minimize your operating costs over a $12-$year horizon. To illustrate the model, suppose you are considering six calling center locations: Boston, New York, Dallas, Chicago, Los Angeles, and Omaha. You know the average cost $($in dollars$)$ incurred if a telemarketing call is made from any these cities to any region of the country. This information is listed in the attached spreadsheet.

Assume that an average call requires $3$ minutes of labor. You make calls $280$ days per year, and the average number of calls made per day to each region of the country is provided in the attached spreadsheet.

The cost $($in millions of dollars$)$ of building a calling center in each possible location and the hourly wage that you must pay workers in each city is listed in spreadsheet. Each calling center can make up to $5000$ calls per day.

Given this information, you want to minimize the discounted cost $($at $10\%$ per year$)$ of running the telemarketing operation for $12$ years. Assume all wage and calling costs are paid at the ends of the respective years.