{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

1 - CIS 3380(Jetton/White Homework Assignment#3 Decision...

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 – Decision Support Systems using Excel Solver & Scenario Manager With Critical Analysis I. Problem Statement Acme Products is planning its production and shipping for its widgit product for the next month. Acme has 4 production plants and 5 warehouses. Its goal is to satisfy the demand at its 5 warehouses (located at regional points and which serve the retailers located in the associated region) at minimum cost. The total cost includes the production cost at each plant (which differ due to local conditions for energy, labor, taxes, etc.) and the cost to ship from each plant to each warehouse. Your challenge is to find the optimal mix of production and shipping quantities which ultimately minimizes total costs given a few different scenarios. II. Familiarization of the Model, Understanding Optimization and the Use of Solver Like any word problem and/or a pre-defined spreadsheet, you must first "familiarize
Background image of page 1

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

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

{[ snackBarMessage ]}