Natural Furniture Company manufactures three outdoor products, chairs, benches, and tables. Each product must pass through the following departments before it is shipped: sawing, sanding, assembly, and painting. The time requirements (in hours) are summarized in the tables below.
The production time available in each department each week and the minimum weekly production requirement to fulfill contracts are as follows:
|
|
|
|
Minimum
|
|
|
Capacity
|
|
Production
|
|
Department
|
(In Hours)
|
Product
|
Level
|
|
Sawing
|
450
|
Chairs
|
100
|
|
Sanding
|
400
|
Benches
|
50
|
|
Assembly
|
625
|
Tables
|
50
|
|
Painting
|
550
|
|
|
|
|
Hours Required
|
Unit
|
|
Product
|
Sawing
|
Sanding
|
Assembly
|
Painting
|
Profit
|
|
Chairs
|
1.5
|
1.0
|
2.0
|
1.5
|
$15
|
|
Benches
|
1.5
|
1.5
|
2.0
|
2.0
|
$10
|
|
Tables
|
2.0
|
2.0
|
2.5
|
2.0
|
$20
|
The production manager has the responsibility of specifying production levels for each product for the coming week. Formulate as a linear programming problem to maximize profit.
What mix of products would yield maximum profit?
Formulate as an LP problem to maximize profit.What is the maximum profit? Use SOLVER in EXCEL to calculate
| |
A. |
|
| |
B. |
|
| |
C. |
|
| |
D. |
|