Page 143 -

THE TAIWAN ELECTRONIC COMMUNICATIONS (TEC) PROBLEM 123

Target Cell (Max)
Original
Name Value Final Value
Obj.
Function 0 10800

Adjustable Cells
Original
Name Value Final Value
Units B 0 600
Units A 0 700
Units C 0 200

Constraints
Cell Name Cell Value Status Slack
Shaping time <= 7200 Binding 0
Grinding time <= 6300 Not Binding 300
Max sales of C <= 200 Binding 0
Max sales of B <= 600 Not Binding 400
Max sales of A <= 700 Not Binding 300
Min sales of B >= 600 Binding 0

Adjustable Cells
Final Reduced Objective Allowable Allowable
Name Value Cost Coefficient Increase Decrease
Units B 600 0 8 1 1E + 30
Units A 700 0 6 3 0.666666667
Units C 200 0 9 1E + 30 3

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
Shaping time <= 7200 1.5 7200 240 2800
Grinding time <= 6300 0 6600 1E + 30 300
Max sales of C <= 200 3 200 700 100
Max sales of B <= 600 0 1000 1E + 30 400
Max sales of A <= 700 0 1000 1E + 30 300
Min sales of B >= 600 –1 600 400 85.71428571

Problems

1 Recall the RMC problem (Chapter 2, Problem 12). Letting:
F ¼ kilos of fuel additive
S ¼ kilos of solvent base

Copyright 2014 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has
deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.