Help with a case study in Optimization and Decision Support Modeling for Business HW1

profileRedhand
Case_Money-in-Motion_Template_withData.xlsx
Home>Business & Finance homework help>Operations Management homework help>Help with a case study in Optimization and Decision Support Modeling for Business HW1

Case MIM b

Transaction
Convert Limit Unit Net Flow Supply/Demand
From To ($thousands) ($thousands) Cost Nodes ($thousands) ($thousands) Range Name Cells
Yen Rupiah <= 5,000 0.50% Yen = Conversion J16:J18
Yen Ringit <= 5,000 0.50% Rupiah = Convert C4:C40
Yen US$ <= 2,000 0.40% Ringit = From A4:A40
Yen Can$ <= 2,000 0.40% Can$ = NetFlow I4:I11
Yen Euro <= 2,000 0.40% Euro = Nodes H4:H11
Yen Pound <= 2,000 0.25% Pound = StartingSupply I16:I18
Yen Peso <= 4,000 0.50% Peso = SupplyDemand K4:K11
Rupiah Yen <= 5,000 0.50% US$ = To B4:B40
Rupiah Ringit <= 2,000 0.70% TotalCost C42
Rupiah US$ <= 200 0.50% Starting TransactionLimit E4:E24
Rupiah Can$ <= 200 0.30% Supply Conversion Starting UnitCost F4:F40
Rupiah Euro <= 1,000 0.30% (thousands) ($ per) ($thousands)
Rupiah Pound <= 500 0.75% Yen 1,200,000 0.008
Rupiah Peso <= 200 0.75% Rupiah 10,500,000 0.00016
Ringit Yen <= 3,000 0.50% Ringgit 28,000 0.2
Ringit Rupiah <= 4,500 0.70%
Ringit US$ <= 1,500 0.70%
Ringit Can$ <= 1,500 0.70%
Ringit Euro <= 2,500 0.40%
Ringit Pound <= 1,000 0.45%
Ringit Peso <= 1,000 0.50%
Can$ US$ 0.05%
Can$ Euro 0.20%
Can$ Pound 0.10%
Can$ Peso 0.10%
Euro US$ 0.10%
Euro Can$ 0.20%
Euro Pound 0.05%
Euro Peso 0.50%
Pound US$ 0.10%
Pound Can$ 0.10%
Pound Euro 0.05%
Pound Peso 0.50%
Peso US$ 0.10%
Peso Can$ 0.10%
Peso Euro 0.50%
Peso Pound 0.50%
Total Cost

Case MIM c

Convert Unit Net Flow Supply/Demand
From To ($thousands) Cost Nodes ($thousands) ($thousands) Range Name Cells
Yen Rupiah 0.50% Yen = Conversion J16:J18
Yen Ringit 0.50% Rupiah = Convert C4:C40
Yen US$ 0.40% Ringit = From A4:A40
Yen Can$ 0.40% Can$ = NetFlow I4:I11
Yen Euro 0.40% Euro = Nodes H4:H11
Yen Pound 0.25% Pound = StartingSupply I16:I18
Yen Peso 0.50% Peso = SupplyDemand K4:K11
Rupiah Yen 0.50% US$ = To B4:B40
Rupiah Ringit 0.70% TotalCost C42
Rupiah US$ 0.50% Starting UnitCost F4:F40
Rupiah Can$ 0.30% Supply Conversion Starting
Rupiah Euro 0.30% (thousands) ($ per) ($thousands)
Rupiah Pound 0.75% Yen 1,200,000 0.008
Rupiah Peso 0.75% Rupiah 10,500,000 0.00016
Ringit Yen 0.50% Ringgit 28,000 0.2
Ringit Rupiah 0.70%
Ringit US$ 0.70%
Ringit Can$ 0.70%
Ringit Euro 0.40%
Ringit Pound 0.45%
Ringit Peso 0.50%
Can$ US$ 0.05%
Can$ Euro 0.20%
Can$ Pound 0.10%
Can$ Peso 0.10%
Euro US$ 0.10%
Euro Can$ 0.20%
Euro Pound 0.05%
Euro Peso 0.50%
Pound US$ 0.10%
Pound Can$ 0.10%
Pound Euro 0.05%
Pound Peso 0.50%
Peso US$ 0.10%
Peso Can$ 0.10%
Peso Euro 0.50%
Peso Pound 0.50%
Total Cost

Case MIM d

Convert Unit Net Flow Supply/Demand
From To ($thousands) Cost Nodes ($thousands) ($thousands) Range Name Cells
Yen Rupiah 0.50% Yen = Conversion J16:J18
Yen Ringit 0.50% Rupiah = Convert C4:C40
Yen US$ 0.40% Ringit = From A4:A40
Yen Can$ 0.40% Can$ = NetFlow I4:I11
Yen Euro 0.40% Euro = Nodes H4:H11
Yen Pound 0.25% Pound = StartingSupply I16:I18
Yen Peso 0.50% Peso = SupplyDemand K4:K11
Rupiah Yen 3.00% US$ = To B4:B40
Rupiah Ringit 4.20% TotalCost C42
Rupiah US$ 3.00% Starting UnitCost F4:F40
Rupiah Can$ 1.80% Supply Conversion Starting
Rupiah Euro 1.80% (thousands) ($ per) ($thousands)
Rupiah Pound 4.50% Yen 1,200,000 0.008
Rupiah Peso 4.50% Rupiah 10,500,000 0.00016
Ringit Yen 0.50% Ringgit 28,000 0.2
Ringit Rupiah 0.70%
Ringit US$ 0.70%
Ringit Can$ 0.70%
Ringit Euro 0.40%
Ringit Pound 0.45%
Ringit Peso 0.50%
Can$ US$ 0.05%
Can$ Euro 0.20%
Can$ Pound 0.10%
Can$ Peso 0.10%
Euro US$ 0.10%
Euro Can$ 0.20%
Euro Pound 0.05%
Euro Peso 0.50%
Pound US$ 0.10%
Pound Can$ 0.10%
Pound Euro 0.05%
Pound Peso 0.50%
Peso US$ 0.10%
Peso Can$ 0.10%
Peso Euro 0.50%
Peso Pound 0.50%
Total Cost