Problems:
Linear Optimization
Develop a linear programming model with the data from tables 1-5
Make or Buy(maximize profit /minimize cost)
There are Four orders for the next 90 days
Orders are to be Completed 90 Days
Products are shown in Table 1.
The orders are shown in Table 2
Table 3 lists the amount of plate steel required to produce one unit of each product and the total amount of steel on hand
The total time available (in hours) and the processing time requirements of each product (in minutes) are shown in Table 4.
Table 5 contains the cost to manufacture and purchase each product. Note: material and labor costs are included in the costs shown in the second column of the table.
Table 1
|
Part#
|
Description
|
|
106C
|
10' x 6" Casing
|
|
206C
|
20' x 6" Casing
|
|
206C10R
|
10' Radius Casing
|
|
206C20R
|
20' Radius Casing
|
|
1012C
|
10' x 12" Casing
|
|
2012C
|
20' x 12" Casing
|
|
2524RW
|
25' x 24" R&W Pipe
|
|
5024RW
|
50' x 24" R&W Pipe
|
|
5036RW
|
50' x 36" R&W Pipe
|
|
5072RW
|
50' x 72" R&W Pipe
|
|
5084RW
|
50' x 84" R&W Pipe
|
|
24ME
|
24" Mitered Elbow
|
|
36ME
|
36" Mitered Elbow
|
|
72ME
|
72* Mitered Elbow
|
|
84ME
|
84" Mitered Elbow
|
Part-2
|
Part #
|
Produce
|
Purchase from Midnight
|
|
106C
|
$512
|
$640
|
|
206C
|
$925
|
$1,156
|
|
206C10R
|
$650
|
|
|
206C20R
|
$1,039
|
|
|
1012C
|
$1,428
|
$1,785
|
|
2012C
|
$1,817
|
$2,271
|
|
2524RW
|
$2,206
|
$2,758
|
|
5024RW
|
$2,595
|
$3,244
|
|
5036RW
|
$2,984
|
$3,730
|
|
5072RW
|
$3,373
|
$4,216
|
|
5084RW
|
$3,762
|
$4,703
|
|
24ME
|
$4,151
|
|
|
36ME
|
$4,540
|
|
|
72ME
|
$4,929
|
|
|
84ME
|
$5,318
|
|