CIS3380+HW3+Fall2011+LnameFname(2)

CIS3380+HW3+Fall2011+LnameFname(2) - I Did NOT put my Name...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: I Did NOT put my Name Here! CIS3380 Fall, 2011 (Jetton) Acme Products Shipping Plan Step 1: Type in the solver specifications (using excel cell addresses) for the optimization problem into the table below FIRST! Description Field Content Description Constraint Values/Ref Target Cell? Total Cost To Deliever Goods To Warehouses $E52$ Function? Minimize n/a Changing/Decision Cells? Receiving Warehouses $F31:J34$ Initial Constraints 1. Changing cells >=0 $F31:J31$>=0 2. Plant Capacity $D31:D34$>=$E:31E34$ 3. Deliver>=Demand $F$36:$J$36>=$F$39:J39 NEW Case 1 Constraint? Chicago=0 $E$31=0 Step 2: Receiving Warehouses Shipping Plants San Diego Salt Lake Chicago Dallas New York Chicago 6.25 600 1 1 1 1 1 Phoenix 4.50 450 5 1 1 1 1 1 Dallas 3.80 480 5 1 1 1 1 1 Los Angeles 5.50 500 5 1 1 1 1 1--------------- Total Shipments Received by Warehouse: 4 4 4 4 4 350 140 290 310 250 Plant Chicago $4.00 $6.00 $1.00 $3.00 $7.00 Phoenix $3.00 $5.00 $7.00 $12.00 $12.00 Dallas $9.00 $7.00 $5.00 $1.00 $11.00 $11....
View Full Document

Ask a homework question - tutors are online