2 - CIS 3380(Jetton/White Homework Assignment#3 Decision Support Systems using Excel Solver Scenario Manager With Critical Analysis III Your

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CIS 3380 (Jetton/White) Homework Assignment #3 – With Critical Analysis III. Your Challenge: Minimize Total Costs The initial Excel model contains the calculations for total costs as well as the demand and production capacities for each plant. Using Solver, you are charged to find the optimal mix of product quantities that are to be shipped from your 4 plants to the 5 different receiving warehouses. The initial constraints or conditions placed on the model include: 1. Requirement: total shipments to each warehouse must be GE (>=) the Demand at that warehouse 2. Limitation: total shipments from each plant must be LE (<=) the Capacity of that plant 3. ALL of the shipment quantity values must be GE (>=) 0 IV: Time to Get Busy: Step 0. Setup: Obtain the Excel file from the TRACS Assignment Tab and save it as: CIS3380 HW3 Fall2011 <YourLnameFname>.xls or xlsx and OPEN it Verify that Excel Solver is installed (Data Tab Far Right) and if Solver does NOT
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

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

Page1 / 2

2 - CIS 3380(Jetton/White Homework Assignment#3 Decision Support Systems using Excel Solver Scenario Manager With Critical Analysis III Your

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online