Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Search for the location of distribution centers (DCs) and stores of a retail store (e.g., Target, Walmart, and Staples) in a specific area (e.g., in
- Search for the location of distribution centers (DCs) and stores of a retail store (e.g., Target, Walmart, and Staples) in a specific area (e.g., in a state).
- Develop a transportation problem for distributing an arbitrary item from the DCs to the stores. You can use made-up numbers for the demand at each store and inventory availability at each DC.
Hint: You need to think about what objective function to choose. For example, should it be based on travel time or distance
- Write the complete formulation.
- Use Excel to solve the formulated problem. Remember to generate and Answer and Sensitivity reports.
- Use the Sensitivity report to answer the following questions:
- If they have some extra inventory, at which DC should they store them?
- If they can manipulate the demand at stores through increasing the price, which store(s) should eb given priority for reducing demand?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started