Question: Would you please complete the problem using excel We have 4 Rectories & Warehouses and 4 Stores Factories Pittsburgh Phoenix Chloego Atlanta Supply 8,000.00 11,500.00
We have 4 Rectories & Warehouses and 4 Stores Factories Pittsburgh Phoenix Chloego Atlanta Supply 8,000.00 11,500.00 9,200.00 9,750.00 Warehouses Indianapolis Denver Portland Memphis Stores San Franco Miami Minneapolis Charlotte Demand 8,000.00 8,500.00 8,800.00 12,500.00 Shipping costs Indianapolis Pitsburgh $20.00 Denver $49.00 Portland $74.00 Memphis $43.00 Charlotte $79.00 Indianapolis $53.00 Denver $19.00 Portland $28.00 Memphis $39.00 San Francisco Miami $29.00 $90.00 Phoenix Indianapolis $17.00 Denver $27.00 Portland $63.00 Memphis $51.00 Chicago Memphis $28.00 Atlanta Miami $29.00 Denver $28.00 Indianapolis Memphis $10.00 Miami $49.00 Minneapolis Charlotte $27.00 $43.00 Indianapolis $25.00 Memphis $42.00 San Francisco Minneapolis Charlotte $24.00 $46.00 $62.00 Denver San Francisco Minneapolis $29.00 $71.00 Portland Indianapolis $18.00 Denver $42.00 San Francisco Miami $82.00 $36.00 Minneapolis $65.00 Charlotte $44.00 Memphis When you answer questions in ecourseware you will be asked some questions about: 1) The initial optimal solution and 2) You will be given an explanation for additional constraints that will make the problem more realistic. You will need to figure out how to represent and incorporate these constraints and then update your model accordingly. We have 4 Rectories & Warehouses and 4 Stores Factories Pittsburgh Phoenix Chloego Atlanta Supply 8,000.00 11,500.00 9,200.00 9,750.00 Warehouses Indianapolis Denver Portland Memphis Stores San Franco Miami Minneapolis Charlotte Demand 8,000.00 8,500.00 8,800.00 12,500.00 Shipping costs Indianapolis Pitsburgh $20.00 Denver $49.00 Portland $74.00 Memphis $43.00 Charlotte $79.00 Indianapolis $53.00 Denver $19.00 Portland $28.00 Memphis $39.00 San Francisco Miami $29.00 $90.00 Phoenix Indianapolis $17.00 Denver $27.00 Portland $63.00 Memphis $51.00 Chicago Memphis $28.00 Atlanta Miami $29.00 Denver $28.00 Indianapolis Memphis $10.00 Miami $49.00 Minneapolis Charlotte $27.00 $43.00 Indianapolis $25.00 Memphis $42.00 San Francisco Minneapolis Charlotte $24.00 $46.00 $62.00 Denver San Francisco Minneapolis $29.00 $71.00 Portland Indianapolis $18.00 Denver $42.00 San Francisco Miami $82.00 $36.00 Minneapolis $65.00 Charlotte $44.00 Memphis When you answer questions in ecourseware you will be asked some questions about: 1) The initial optimal solution and 2) You will be given an explanation for additional constraints that will make the problem more realistic. You will need to figure out how to represent and incorporate these constraints and then update your model accordingly
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
