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
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 rule
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 i
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
Ass
Static Method
Sales
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
Total
1
2
3
2000
3000
2000
3000
4000
5000
3000
3000
5000
3000
5000
3000
4000
5000
4000
6000
8000
6000
7000
3000
7000
6000
8000
10000
Homework #1 Solutions
Problem 1:
Walmart Financials Case Study
(a) ThetablebelowlistsWalMarts2010financialmeasures, aswellasAmazons2009
measuresandacomparison.
FinancialMeasure
ROE
ROA
ProfitMargin
As
A
B
C
D
E
F
G
H
I
J
120 95 105 130 125 150 115 95 80 135
cost
A
120
A
a_ij
C1
C2
C3
C4
C5
C6
C7
C8
C9
C10
B
C
D
E
F
G
H
I
J
Constrait
1
0
1
0
1
1
0
0
0
1
1
0
1
1
0
0
1
0
0
0
0
1
1
0
1
0
0
0
1
1
0
1
0
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
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, resp
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 ou
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).
T