Using excel solver, How can you solve and Improve thiscapacitated model?
Using Excel Solver How Can You Solve And Improve This Capacitated Model 1 (74 KiB) Viewed 9 times
1 Inputs - Costs, Capacities, Demands 2 3 Supply Region 4 N. America 5 S. America 6 Europe 7 Asia 8 Africa 9 Demand 10 11 Decision Variables Demand Region High Production and Transportation Cost per 1,000,000 Units Fixed Low Fixed N. America S. America Europe Africa Cost ($) Capacity Cost ($) Capacity Asia 10 10 10 10 10 15 S. America 16 Europe 17 Asia 18 Africa 19 20 Constraints 81 117 102 115 142 42 8 92 77 105 125 100 0 101 108 95 90 103 8 14 12 13 Supply Region |N. America S. America Europe Asia 14 N. America 20 0 0 12 0 0 0 10 16 0 0 0 O O O O O 004의 Demand Region - Production Allocation (1000 Units) Africa 0 130 98 119 59 105 16 10 115 6,000 100 4,500 111 6,500 74 4,100 71 4,000 7 OOON 7 Small Large Plants Plants (1=open)| (1=open) 0 1 1 0 1 1 OO 0 0 ܝ ܘ 9,000 6,750 9,750 6,150 6,000 Total Plants 1 1 0 2 1 20 20 20 20 20
20 Constraints 21 Supply Region Excess Capacity 22 N. America 23 S. America 24 Europe 25 Asia 26 Africa 27 28 Unmet Demand 29 30 Objective Function 31 Cost = 0 0 0 0 3 N. America S. America 0 0 $ 39,621 Europe 0 Asia 0 Africa 0
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!