Lecture 3 Spreadsheet - Constraints Resources Used Avail...

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

View Full Document Right Arrow Icon
Inputs Frame A Frame B Frame C Frame D Max amount Labor 2 1 3 2 4000 Metal 4 2 1 2 6000 Glass 6 2 1 2 10000 Profit contribution $6.00 $2.00 $4.00 $3.00 Maximal production 1000 2000 500 1000 Changing cells Frame type A B C D Amount produced 0 0 0 0 Objective function Profit $-
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Constraints Resources Used Avail Labor 0 <= 4000 Metal 0 <= 6000 Glass 0 <= 10000 Maximal production Produced Demand Frame 1 0 <= 1000 Frame 2 0 <= 2000 Frame 3 0 <= 500 Frame 4 0 <= 1000...
View Full Document

This note was uploaded on 03/17/2010 for the course IOE 202 taught by Professor Marinaepelman during the Fall '09 term at University of Michigan-Dearborn.

Ask a homework question - tutors are online