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 – 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 yourself" with it so as to understand the values, functions, formulas and cell relationships
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.

Page1 / 2

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

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