SETZER_HW02_01 - Problem 1A...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Problem 1A 03cb1ad87ab9d7cef2a4214c571c619e89159de0.xls page 1 of 6 TABLE 5-5 Costs and Number of Trips for SC Consulting Costs Source STATE Tulsa Denver Seattle LA Tulsa Denver Seattle Costs $165,428 $131,230 $140,000 $145,000 0 0 1 0 1 $140,000 Washington 40 $150 $250 $200 $25 0 0 40 0 40 $8,000 0 Oregon 35 $150 $250 $200 $75 0 0 35 0 35 $7,000 0 California 100 $75 $200 $150 $125 0 0 100 0 100 $15,000 0 ldaho 25 $150 $200 $125 $125 0 0 25 0 25 $3,125 0 Nevada 40 $100 $200 $125 $150 0 0 40 0 40 $5,000 0 Montana 25 $175 $175 $125 $125 0 0 25 0 25 $3,125 0 Wyoming 50 $150 $175 $100 $150 0 0 50 0 50 $5,000 0 Utah 30 $150 $150 $100 $200 0 0 30 0 30 $3,000 0 Arizona 50 $75 $200 $100 $250 0 0 50 0 50 $5,000 0 Colorado 65 $150 $125 $25 $250 0 0 65 0 65 $1,625 0 New Mexico 40 $125 $125 $75 $300 0 0 40 0 40 $3,000 0 North Dakota 30 $300 $200 $150 $200 0 0 30 0 30 $4,500 0 South Dakota 20 $300 $175 $125 $200 0 0 20 0 20 $2,500 0 Nebraska 30 $250 $100 $125 $250 0 0 30 0 30 $3,750 0 Kansas 40 $250 $75 $75 $300 0 0 40 0 40 $3,000 0 Oklahoma 55 $250 $25 $125 $300 0 0 55 0 55 $6,875 0 Consultant Trips 675 0 0 675 0 675 $219,500 0 Consultant Qty 0 0 27 0 Each consultant will take up to 25 trips each year. 1. SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 16 states listed in Table 5-5. There are four potential sites for home offices: Los Angeles, Tulsa, Denver, and Seattle. Total Trips (Sink) Los Angeles Totals (Source) Trip Surpl
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Problem 1A 03cb1ad87ab9d7cef2a4214c571c619e89159de0.xls page 2 of 6 See Table 5-5. What is the annual cost in terms of the facility and travel? Facilities $140,000 Travel $79,500 TOTAL $219,500 the four binary (1 or 0) quantities of facilities in each candidate city; the number of trips from each city to each state per year. the binary nature of the four candidate cities;
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/12/2010 for the course ESI 6323 taught by Professor Guan during the Summer '09 term at University of Florida.

Page1 / 6

SETZER_HW02_01 - Problem 1A...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online