CIS3380+HW3+Fall2011+LnameFname(1)

CIS3380+HW3+Fall2011+LnameFname(1) - $237.25 Step 3:...

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

View Full Document Right Arrow Icon
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? Function? n/a Changing/Decision Cells? Initial Constraints 1. 2. 3. NEW Case 1 Constraint? Step 2: Receiving Warehouses Shipping Plants San Diego Salt Lake Chicago Dallas New York Chicago 6.25 600 5 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 Los Angeles $2.00 $5.00 $12.00 $10.00 $15.00 --- --- --- --- --- $18.00 $23.00 $25.00 $26.00 $45.00 Total Shipping Cost $137.00 Total Production Cost $100.25 Total Cost To Deliver Goods To Warehouses
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $237.25 Step 3: Initially Solved Base Case: "Total Cost to Deliver Goods to Warehouses" Step 4: Case 1: Minimum cost to deliver goods without the Chicago plant ==> Step 5: Case 2 Adj Minimum cost to deliver goods without the Chicago *AND* the proposed Phoenix prices from the new shipper candidate/proposal: Case 2 Total Costs ==> Does the offer from the new Phoenix potential shipper make sense and reduces your total cost of delivering goods to your warehouses? Justify your answer with numbers from the solution. Step 6: Take the Offer? Yes or No???? WHY? State why you should or should not take the offer What is the $ impact (difference) between case #1 & case #2? Production Cost/uinit Plant Capacity (units) Total Shipments from Plant Demands by Warehouse Shipping costs (per unit) from plant (row) to warehouse (column):...
View Full Document

This document was uploaded on 11/03/2011 for the course CIS 3380 at Texas State.

Ask a homework question - tutors are online