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

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

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

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

View Full Document
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
Ask a homework question - tutors are online