Find out the distribution centers need to be added

Assignment Help Operation Management

Reference no: EM133689127

Question: Use the Excel SOLVER tool to solve the following total cover problem. Amazon try to increase its distribution centers (DCs) in Texas in order to deliver the orders to major cities wi 24 hour time frame. The following table shows capacity of the distribution centers to the cities. If the coefficient is I, that distribution center can deliver the order within 24 hours. Find out the distribution centers need to be added in order to achieve the one day delivery goal.

	DC1	DC2	DC3	DC4	DC5	DC6	DC7	DC8
Austin	I	I	I	I	0	0	0	0
Dallas	0	0	I	0	I	I	0	I
Houston	I	I	0	0	I	0	I	0
San Antonio	I	I	I	0	0	0	0	0
Corpus Christi	0	I	0	I	0	0	I	0
Brownsville	0	I	0	I	0	0	I	0
Kingsville	0	I	0	I	0	0	I	0

Reference no: EM133689127

Questions Cloud

Discuss how understanding global cultures enhance customer : Discuss how understanding global cultures can enhance customer satisfaction and loyalty. Metrics could include customer satisfaction scores, customer retention.

Analyse the shaping of the greek civilization : Analyse the shaping of the Greek civilization during The Golden Age of Athens, also known as the Classical Period inregards politics, philosphy, art.

How long would you wait before switching strategies : Your approach to see how well other platforms are working to get the best results is very smart! How long would you wait before switching strategies?

What method of targeting - segmentation would you recommend : What method of targeting / segmentation would you recommend on LinkedIn to reach this specific B2B segment?

Find out the distribution centers need to be added : Find out the distribution centers need to be added in order to achieve the one day delivery goal

Which soviet-american tanks faced off at checkpoint charlie : What was the cause of the "October confrontation" in Berlin in which Soviet and American tanks faced off at Checkpoint Charlie?

Can marketers make more accurate real-time predictions : Can marketers make more accurate real-time predictions and responses to these customer traits with the use of digital marketing tools and data analytics?

How could channel analysis help you in the task : How could channel analysis help you in this task? Imagine you're an analytics user trying to optimize. How could channel analysis help you in this task?

Explain their impact onadvertisers payments : Distinguish between impression, click base system and conversions, and explain their impact onadvertiser's payments.

User Account

All Pages