2007 OEM DMOR Homework #1:
Six questions, each worth 10 points.
Due Monday, September 3
rd
(by 11:59pm, EDT)
Question 1:
Formulate the following problem as a linear program
(write or type as a
mathematical programming formulation).
Our manufacturing plant produces bookshelves, couches, and worktables.
We
have 400 hours of labor that are available to us each week, and 1000 units of
lumber as raw materials.
Each bookshelf produced yields a profit of $6,
consumes 12 hours of labor, and 40 units of lumber.
Each couch yields a profit of
$5, consumes 14 hours of labor, and 22 units of lumber.
Each worktables yields a
profit of $8, consumes 16 hours of labor, and 60 units of lumber.
How many
bookshelves, couches, and worktables should be produced to maximize profits,
subject to labor and lumber restrictions?
(You may allow fractional production.)
Question 2:
Formulate and solve your model in Excel using Solver.
Via WebCT, turn in
your Excel file with solution.
Question 3:
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.
 Fall '09
 VLADIMIRLBOGINSKI
 Linear Programming, Optimization, cans, Red paint, mathematical programming formulation

Click to edit the document details