Page 189 -

FINANCIAL APPLICATIONS 169

Figure 4.7 Excel Solution for the Market Survey Problem

TARGET CELL (MIN)
Name Original Value Final Value
----------------- ------------- ----------
Objective function 0 20320
ADJUSTABLE CELLS
Name Original Value Final Value
--- ------------- ----------
DC 0 240
EC 0 160
DNC 0 240
ENC 0 360

CONSTRAINTS
Name Cell Value Status Slack
-------------------------------------------- --------- ---------- ----
Total interviews 1000 Not Binding 0
Households with children 400 Binding 0
Households without children 600 Not Binding 200
Evening interviews 40 Not Binding 40
Evening interviews in households with children 0 Binding 0
Evening interviews in households with children 0 Binding 0

ADJUSTABLE CELLS
Final Reduced Objective Allowable Allowable
Name Value Cost Coefficient Increase Decrease
--- ---- ------ ---------- ---------- ----------
DC 240 0 20 5 4.666666667
EC 160 0 25 1E+30 5
DNC 240 0 18 2 1E+30
ENC 360 0 20 4.666666667 2

CONSTRAINTS
Final Shadow Constraint Allowable Allowable
Name Value Price R.H. Side Increase Decrease
----------------------- ---- ----- --------- -------- --------
Total interviews 1000 19.2 1000 1E+30 200
Households with children 400 2.8 400 100 400
Households without 600 0 400 200 1E+30
children
Evening interviews 40 0 0 40 1E+30
Evening interviews in 0 5 0 240 20
households with
children
Evening interviews in 0 2 0 240 20
households with
children

EXCEL file
MARKET

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.