|
|
|
|
| LEADER |
00000cam a2200000Mu 4500 |
| 001 |
on1347026528 |
| 003 |
OCoLC |
| 005 |
20240909213021.0 |
| 006 |
m o d |
| 007 |
cr cnu|||||||| |
| 008 |
230209s2015 xx o ||| 0 eng d |
| 040 |
|
|
|a EBLCP
|b eng
|c EBLCP
|d OCLCQ
|d OCLCO
|d EBLCP
|d OCLCQ
|d OCLCL
|d OCLCQ
|d UEJ
|d OCLCQ
|
| 020 |
|
|
|a 9781118937709
|
| 020 |
|
|
|a 1118937708
|
| 035 |
|
|
|a (OCoLC)1347026528
|
| 050 |
|
4 |
|a HB143.7
|b .B35 2016
|
| 049 |
|
|
|a HCDD
|
| 100 |
1 |
|
|a Baker, Kenneth R.
|
| 245 |
1 |
0 |
|a Optimization Modeling with Spreadsheets
|h [electronic resource].
|
| 260 |
|
|
|a Newark :
|b John Wiley & Sons, Incorporated,
|c 2015.
|
| 300 |
|
|
|a 1 online resource (391 p.).
|
| 490 |
1 |
|
|a New York Academy of Sciences Ser.
|
| 500 |
|
|
|a Description based upon print version of record.
|
| 505 |
0 |
|
|a Intro -- Title Page -- Copyright Page -- Contents -- PREFACE -- CHAPTER 1 INTRODUCTION TO SPREADSHEET MODELS FOR OPTIMIZATION -- 1.1 ELEMENTS OF A MODEL -- 1.2 SPREADSHEET MODELS -- 1.3 A HIERARCHY FOR ANALYSIS -- 1.4 OPTIMIZATION SOFTWARE -- 1.5 USING SOLVER -- SUMMARY -- EXERCISES -- REFERENCES -- CHAPTER 2 LINEAR PROGRAMMING: ALLOCATION, COVERING, AND BLENDING MODELS -- 2.1 LINEAR MODELS -- 2.1.1 Linear Constraints -- 2.1.2 Formulation -- 2.1.3 Layout -- 2.1.4 Results -- 2.2 ALLOCATION MODELS -- 2.2.1 The Product Mix Problem -- 2.3 COVERING MODELS -- 2.3.1 The Staff-Scheduling Problem
|
| 505 |
8 |
|
|a 2.4 BLENDING MODELS -- 2.5 MODELING ERRORS IN LINEAR PROGRAMMING -- 2.5.1 Exceptions -- 2.5.2 Debugging -- 2.5.3 Logic -- SUMMARY -- EXERCISES -- Case: JetGreen -- CHAPTER 3 LINEAR PROGRAMMING: NETWORK MODELS -- 3.1 THE TRANSPORTATION MODEL -- 3.2 THE ASSIGNMENT MODEL -- 3.3 THE TRANSSHIPMENT MODEL -- 3.4 FEATURES OF SPECIAL NETWORK MODELS -- 3.5 BUILDING NETWORK MODELS WITH BALANCE EQUATIONS -- 3.6 GENERAL NETWORK MODELS WITH YIELDS -- 3.6.1 Models with Yield Losses -- 3.6.2 Models with Yield Gains -- 3.7 GENERAL NETWORK MODELS WITH TRANSFORMED FLOWS -- SUMMARY -- EXERCISES
|
| 505 |
8 |
|
|a Case: Casey's Famous Roast Beef -- Case: Hollingsworth Paper Company -- Production and Distribution Facilities -- Patterns of Distribution -- Expansion Proposals -- CHAPTER 4 SENSITIVITY ANALYSIS IN LINEAR PROGRAMS -- 4.1 PARAMETER ANALYSIS IN THE TRANSPORTATION EXAMPLE -- 4.2 PARAMETER ANALYSIS IN THE ALLOCATION EXAMPLE -- 4.3 THE SENSITIVITY REPORT AND THE TRANSPORTATION EXAMPLE -- 4.4 THE SENSITIVITY REPORT AND THE ALLOCATION EXAMPLE -- 4.5 DEGENERACY AND ALTERNATIVE OPTIMA -- 4.6 PATTERNS IN LINEAR PROGRAMMING SOLUTIONS -- 4.6.1 The Transportation Model -- 4.6.2 The Product Portfolio Model
|
| 505 |
8 |
|
|a 4.6.3 The Investment Model -- 4.6.4 The Allocation Model -- 4.6.5 The Refinery Model -- SUMMARY -- EXERCISES -- Case: Cox Cable and Wire Company -- Background -- The Contract -- The Analysis -- CHAPTER 5 LINEAR PROGRAMMING: DATA ENVELOPMENT ANALYSIS -- 5.1 A GRAPHICAL PERSPECTIVE ON DEA -- 5.2 AN ALGEBRAIC PERSPECTIVE ON DEA -- 5.3 A SPREADSHEET MODEL FOR DEA -- 5.4 INDEXING -- 5.5 REFERENCE SETS AND HCUs -- 5.6 ASSUMPTIONS AND LIMITATIONS OF DEA -- SUMMARY -- EXERCISES -- Case: Branch Performance at Nashville National Bank -- Branch Growth at NNB -- Assessing Branch Productivity
|
| 505 |
8 |
|
|a Branch Managers Revolt -- Measuring Branches: Available Techniques -- The DEA Study -- CHAPTER 6 INTEGER PROGRAMMING: BINARY-CHOICE MODELS -- 6.1 USING SOLVER WITH INTEGER REQUIREMENTS -- 6.2 THE CAPITAL BUDGETING PROBLEM -- 6.3 SET COVERING -- 6.4 SET PACKING -- 6.5 SET PARTITIONING -- 6.6 PLAYOFF SCHEDULING -- 6.7 THE ALGORITHM FOR SOLVING INTEGER PROGRAMS -- SUMMARY -- EXERCISES -- Case: Motel Location for Nature's Inn -- CHAPTER 7 INTEGER PROGRAMMING: LOGICAL CONSTRAINTS -- 7.1 SIMPLE LOGICAL CONSTRAINTS: EXCLUSIVITY -- 7.2 LINKING CONSTRAINTS: THE FIXED COST PROBLEM
|
| 500 |
|
|
|a 7.3 LINKING CONSTRAINTS: THE THRESHOLD LEVEL PROBLEM
|
| 650 |
|
0 |
|a Electronic spreadsheets.
|0 http://id.loc.gov/authorities/subjects/sh85042371
|
| 650 |
|
0 |
|a Managerial economics
|x Mathematical models.
|
| 650 |
|
0 |
|a Mathematical optimization.
|0 http://id.loc.gov/authorities/subjects/sh85082127
|1 http://www.wikidata.org/entity/Q202843.
|
| 650 |
|
0 |
|a Programming (Mathematics)
|0 http://id.loc.gov/authorities/subjects/sh85107312
|1 http://www.wikidata.org/entity/Q141495.
|
| 655 |
|
0 |
|a Electronic books.
|
| 758 |
|
|
|i has work:
|a Optimization modeling with spreadsheets (Text)
|1 https://id.oclc.org/worldcat/entity/E39PCFDrpKKTM9wJ8KwQx3XVvd
|4 https://id.oclc.org/worldcat/ontology/hasWork
|
| 776 |
0 |
8 |
|i Print version:
|a Baker, Kenneth R.
|t Optimization Modeling with Spreadsheets
|d Newark : John Wiley & Sons, Incorporated,c2015
|z 9781118937693
|
| 830 |
|
0 |
|a New York Academy of Sciences Ser.
|
| 856 |
4 |
0 |
|u https://ebookcentral.proquest.com/lib/holycrosscollege-ebooks/detail.action?docID=7104253
|y Click for online access
|
| 903 |
|
|
|a EBC-AC
|
| 994 |
|
|
|a 92
|b HCD
|