This article was downloaded by: [71.126.122.25] On: 14 January 2015, At: 08:10
Publisher: Institute for Operations Research and the Management Sciences (INFORMS)
INFORMS is located in Maryland, USA
INFORMS Transactions on Education
Publication details, in
Excels Solver
Use Excels Solver as a tool to assist the
decision maker in identifying the optimal solution
for a business decision.
Business decisions are often subject to
constraints or business rules to solve business
problems.
Solver can be used for de
IE/MSE 362
Logistics & Supply Chain Management
Facility Location Assignment
1 Utilizing the set covering heuristic, determine a least cost
covering of the row elements of the following table. The xs indicate
what customers can be covered by a facility at
Problem 1: Walmart Financials C
ase S
tudy
(a) T he table be
low lists Wal-Marts 2010 financial measures, as well as Amazons 2009
measures and a comparison.
Financial Measure
ROE
ROA
Profit Margin
Asset Turnove
r
APT
INVT
ART
C2C
P P E T
Wal-Mart 2010
20.
Data(1)
Input Data
Demand Forecast
Month
January
February
March
April
May
June
July
August
September
October
November
December
January
February
Costs
Demand
Forecast
10,000
11,000
15,000
18,000
25,000
26,000
30,000
29,000
21,000
18,000
14,000
11,000
10,00
Solutions to HW problems assigned from Ch 11
10.
(a)
In situations where full truckloads are used the number of deliveries for large, medium, and small
customers in a given year is 5, 2, and 0.7, respectively, which is obtained by dividing annual demand b
Chapter 6: Network Design in an Uncertain Environment
Exercise Solutions
3.
Answer:
The high reliability but more costly supplier, Multichem, turns out to have the lower expected cost. This type of outcome is often the case as the increased
flexibility th
Homework 1
Tong Huang
5-2.
objective fuction:
n
n
m
f i y i + c ij xij
i=1
i=1 j=1
subject to:
n
x ij=D j for j=1, m
i=1
m
x ij K i y i for i=1, n
j=1
y i cfw_ 0,1 , for i=1, n , x ij 0
5-3
(a).
The result is that the United States plant should produc