00951nam1 2200253 450 00004371920180124112804.020171205d1968----km-y0itaa50------baitaITAttuazione della legge speciale per la Calabria nel periodo 1955-1967Roma[s.n.]1968Volumi29 cm.0010000437202001 RelazioneCalabriaSviluppo economicoInterventi statali1955-1967338.9(22. ed.)Produzione. Sviluppo e crescita economicaCassa per opere straordinarie di pubblico interesse nell'Italia meridionale287783ITUniversità della Basilicata - B.I.A.REICATunimarc000043719Attuazione della legge speciale per la Calabria nel periodo 1955-19671532333UNIBASSTD0170120171205BAS011800TTM3020180124BAS01112805564nam 2200709 a 450 991014101010332120170816123708.01-118-00897-91-280-76727-897866136780410-470-94910-40-470-94909-0(CKB)2670000000080895(EBL)675064(SSID)ssj0000477785(PQKBManifestationID)12157984(PQKBTitleCode)TC0000477785(PQKBWorkID)10513078(PQKB)10358473(MiAaPQ)EBC675064(CaSebORM)9780470928639(OCoLC)711779385(EXLCZ)99267000000008089520100907d2011 uy 0engur|n|---|||||txtccrOptimization modeling with spreadsheets[electronic resource] /Kenneth R. Baker2nd ed.Hoboken, N.J. Wiley20111 online resource (431 p.)Description based upon print version of record.0-470-92863-8 Includes bibliographical references and index.CONTENTS; Preface; 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; 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; 2.4 Blending Models; 2.5 Modeling Errors in Linear Programming; 2.5.1 Exceptions; 2.5.2 Debugging2.5.3 LogicSummary; Exercises; Case: JetGreen; 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; Case: Casey's Famous Roast Beef; Case: Hollingsworth Paper Company; Production and Distribution Facilities; Patterns of Distribution; Expansion Proposals4. Sensitivity Analysis in Linear Programs4.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; 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 Analysis5. Linear Programming: Data Envelopment Analysis5.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 Finding Reference Sets and HCUs; 5.6 Assumptions and Limitations of DEA; Summary; Exercises; Case: Branch Performance at Nashville National Bank; Branch Growth at Nashville National Bank; Assessing Branch Productivity; Branch Managers Revolt; Measuring Branches: Available Techniques; The DEA Study; 6. Integer Programming: Binary Choice Models; 6.1 Using Solver with Integer Requirements; 6.2 The Capital Budgeting Problem6.3 Set Covering6.4 Set Packing; 6.5 Set Partitioning; 6.6 Playoff Scheduling; 6.7 Solving a Large-Scale Set Partitioning Problem; 6.8 The Algorithm for Solving Integer Programs; Summary; Exercises; Case: Motel Location for Nature's Inn; 7. Integer Programming: Logical Constraints; 7.1 Simple Logical Constraints: Exclusivity and Contingency; 7.2 Linking Constraints: The Fixed Cost Problem; 7.3 Linking Constraints: The Threshold Level Problem; 7.4 Linking Constraints: The Facility Location Model; 7.4.1 Capacitated Version; 7.4.2 Uncapacitated Version7.5 Disjunctive Constraints: The Machine Sequencing ProblemReflects the latest applied research and features state-of-the-art software for building and solving spreadsheet optimization models Thoroughly updated to reflect the latest topical and technical advances in the field, Optimization Modeling with Spreadsheets, Second Edition continues to focus on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets to represent and analyze those models. Developed and extensively classroom-tested by the author, the book features a systematic approach that equips readers with the skilMathematical optimizationManagerial economicsMathematical modelsElectronic spreadsheetsProgramming (Mathematics)Electronic books.Mathematical optimization.Managerial economicsMathematical models.Electronic spreadsheets.Programming (Mathematics)005.54519.6028554Baker Kenneth R.1943-513780MiAaPQMiAaPQMiAaPQBOOK9910141010103321Optimization modeling with spreadsheets853508UNINA