Capstone+Answer+14+Excel

Capstone+Answer+14+Excel - 3 Greenwood 6 = 6 Dothan 5 = 5...

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

View Full Document Right Arrow Icon
CAPSTONE QUESTON 14 Costs (in cents) From / To Birmingham Atlanta Slidell 8 6 Greenwood 3 8 Dothan 9 3 Macon 44 57 Greenville 35 34 Jacksonville 24 28 Savannah 24 32 Containers Available Slidell 3 Greenwood 6 Dothan 5 Containers Required Macon 2 Greenville 4 Jacksonville 3 Savannah 3 Decision Variables From / To Birmingham Atlanta Slidell 2 1 Greenwood 6 0 Dothan 0 5 Total 8 6 To/From Birmingham Atlanta Macon 2 0 Greenville 0 4 Jacksonville 3 0 Savannah 3 0 Total 8 4 Constraints 1) Total Shipped from each facility = total containers available Total Shipped = Containers Available Slidell 3 =
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3 Greenwood 6 = 6 Dothan 5 = 5 2) Total Received in each city >= total sales available Total Received >= Sales Available Macon 2 >= 2 Greenville 4 >= 4 Jacksonville 3 >= 3 Savannah 3 >= 3 3) Total shipped out from each center <= total received at each center Birmingham Atlanta Shipped 8 4 <= <= <= Received 8 6 Objective Function Cost of origin to facility 55 Cost of facility to city 368 Total Cost $423.00 <- Minimize this...
View Full Document

Ask a homework question - tutors are online