Question: Based on Spencer et al. (1990). When you lease 800 phone numbers from AT&T for telemarketing, AT&T uses an optimization model to tell you where

Based on Spencer et al. (1990). 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 10-year horizon. To illustrate the model, suppose you are considering seven calling center locations: Boston, New York, Charlotte, Dallas, Chicago, Los Angeles, and Omaha. You know the average cost incurred if a telemarketing call is made from any of these cities to any region of the country. You also know the hourly wage that you must pay workers in each city. This information is listed in the file P06_85.xlsx. Assume that an average call requires four minutes of labor. You make calls 250 days per year, and the average number of calls made per day to each region of the country is listed in the same file. The cost of building a calling center in each possible location is also listed in this file. Each calling center can make up to 5000 calls per day. Given this information, how can you minimize the discounted cost (at 10% per year) of running the telemarketing operation for 10 years? Assume all wage and calling costs are paid at the end of the respective years.

Telemarketing data Boston New York Charlotte Dallas Chicago LA Omaha Daily calls

Telemarketing data Boston New York Charlotte Dallas Chicago LA Omaha Daily calls Cost per call New England Middle Atlantic Southeast Southwest Great Lakes Plains $0.60 $0.70 $0.55 $1.00 $1.10 $0.65 $0.90 $0.95 $0.75 $1.05 $1.15 $1.00 $0.85 $1.10 $1.05 $0.45 $0.65 $1.25 $0.85 $0.75 $1.10 $0.70 $0.30 1000 $1.30 $0.50 $1.10 $0.65 $0.70 $0.45 $0.95 $0.90 $0.60 $0.50 $0.95 $1.15 $0.75 $1.05 $0.95 $0.60 $1.05 $1.00 $0.65 2000 2000 2000 3000 1000 Rockies Pacific $1.40 $1.10 $1.25 $1.401 $1.30 $1.65 $0.90 $1.35 $0.60 $1.10 $0.70 $0.50 $0.45 $0.75 2000 4000 Hourly wage Building cost $14 $2,700,000 $16 $3,000,000 $11 $2,100,000 $12 $2,100,000 $13 $2,400,000 $18 $3,600,000 $10 $2,100,000

Step by Step Solution

3.57 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Locating and assigning calling centers Days per year 250 Minutes per call 4 Max calls per center per ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (3 attachments)

PDF file Icon

1497_60b741247da6f_696550.pdf

180 KBs PDF File

Excel file Icon

1497_6045ff3f7227a_696550.xlsx

300 KBs Excel File

Word file Icon

1497_60b741247da6f_696550.docx

120 KBs Word File

Students Have Also Explored These Related Practical Management Science Questions!