Klein Industries Review
Monthly Sales
Small (x)
Medium(y)
Large (z)
Minimum
14,000
6,200
2,600
Maximum
21,000
12,500
4,200
Minutes
Small (x)
Medium(y)
Large (z)
Bending/Forming
0.40
0.70
0.80
Welding
0.60
1.00
1.20
Painting
1.40
2.60
3.10
Small (x)
Medium(y)
Large (z)
Unit profit
$20.50
$34.00
$42.00
Total production time
2.40
4.30
5.10
Production time per unit
2.40
4.30
5.10
Profit per production time
$8.54
$7.91
$8.24
Total Profit Maximization($)
20.50x + 34.00y + 42.00z
Production constraints:
x >= 14000
x <=21000
y >=6200
y <=12500
z >=2600
z <= 4200
Time constraints:
0.40x + 0.70y + 0.80z <= 23,400
0.60x + 1.00y + 1.20z <= 23,400
1.40x + 2.60y + 3.10z <= 46,800
Non Negativity Constaints:
x,y,z >= 0
Production (Calculated Values)
16157
6200
2600
Profit:
$651,221.43
Solver Table:
D Variable
x
y
z
Calc Value
16157.142857
6200
2600
Total
Obj Func
20.50
34.00
42.00
651221.43
Constraints:
Prcessing Time
0.40
0.70
0.80
12882.86
<=
23400
0.60
1.00
1.20
19014.29
<=
23400
1.40
2.60
3.10
46800.00
<=
46800
Sales
1.00
16157.14
<=
21000
1.00
6200.00
<=
12500
1.00
2600.00
<=
4200
1.00
16157.14
>=
14000
1.00
6200.00
>=
6200
1.00
2600.00
>=
2600
Hey (Production Manger)… It was great catching up with you yesterday at lunch. The team just
finished running the numbers on the air compressor line and came up with an ideal scenario I wanted
you to review. Based upon the timing and production information that you provided to us we've come
You've reached the end of your free preview.
Want to read all 6 pages?
- Fall '13
- Gerald
- Sales, calc value, Klein Industries.
