Page 164 -

144 CHAPTER 4 LINEAR PROGRAMMING APPLICATIONS

Figure 4.1 The Excel Solution for the Janders Make-or-Buy Problem

TARGET CELL (MIN)
Name Original Value Final Value
------------------ -------------- -----------
Objective Function 0 24443.33333
ADJUSTABLE CELLS
Name Original Value Final Value
------ -------------- -----------
BM 0 5000
BP 0 0
FCM 0 666.6666667
FCP 0 2333.333333
TCM 0 2000
TCP 0 0
FTM 0 0
FTP 0 3000
TTM 0 0
TTP 0 2000
OT 0 0

CONSTRAINTS
Name Cell Value Status Slack
-------------------- ---------- ----------- ------
Bases 5000 Not Binding 0
Financial cartridges 3000 Not Binding 0
Technician cartridges 2000 Not Binding 0
Financial tops 3000 Not Binding 0
Technician tops 2000 Not Binding 0
Overtime 0 Not Binding 50
Manf capacity 12000 Binding 0

ADJUSTABLE CELLS
Final Reduced Objective Allowable Allowable
Name Value Cost Coefficient Increase Decrease
----- ---------- ---------- ----------- ---------- ----------
BM 5000 0 0.5 0.016666667 1E+30
BP 0 0.016666667 0.6 1E+30 0.016666667
FCM 666.6666667 0 3.75 0.1 0.05
FCP 2333.333333 0 4 0.05 0.1
TCM 2000 0 3.3 0.391666667 1E+30
TCP 0 0.391666667 3.9 1E+30 0.391666667
FTM 0 0.033333333 0.6 1E+30 0.033333333
FTP 3000 0 0.65 0.033333333 1E+30
TTM 0 0.095 0.75 1E+30 0.095
TTP 2000 0 0.78 0.095 1E+30
OT 0 4 9 1E+30 4

EXCEL file
Janders

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.