运筹学2类电子表格建模艺术.ppt

Chapter 3. The Art of Modeling with Spreadsheets Table of Contents (主要内容) The Everglade Golden Years Co. Cash Flow Problem (Section 3.1)(大沼泽地金色年代公司的现金流问题[第3.1节]) The Process of Modeling with Spreadsheets (Section 3.2)(使用电子表格建模的过程[第3.2节]) Guidelines for Building “Good” Spreadsheet Models (Section 3.3)(建立好的电子表格模型的原则[第3.3节]) Debugging a Spreadsheet Model (Section 3.4)(调试电子表格模型[第3.4节]) The Everglade Cash Flow Problem The Everglade Cash Flow Problem Their short-term cash flow requirements cannot be met without borrowing. (短期的现金流难于满足需求，有必要贷款) A long-term (10 year) loan can be taken with an interest rate of 7%. (为期10年的长期贷款利率为7%) A series of short-term loans (1 year) can be taken with a projected interest rate of 10%. (为期1年的短期贷款利率为10%) The Everglade Cash Flow Problem The Process of Modeling Plan: Visualize Where You Want to Finish A common stumbling block in the modeling process occurs right at the beginning—How do I get started? (建模过程中的一个常见问题出现在最开始的时候——我应该如何开始工作？) At this point it can be useful to ask the question—Where do I want to end up? (此时询问“我想在哪里结束”这样的问题会很有帮助) What information do I need to provide in a report? (我应该在报告中提供什么信息？) Plan: Visualize Where You Want to Finish What should the “answer” look like? (“答案”看起来应该像什么样子？) What kinds of numbers need to be included in the recommendation? (建议中应该包含哪些数字？) What information is needed in the Everglade Cash Flow problem? (大沼泽地金色年代公司的现金流问题中，需要什么样的信息？) Plan: Do Some Calculations by Hand Plan: Do Some Calculations by Hand Plan: Sketch Out a Spreadsheet Build: Start with a Small Version Build: Start with a Small Version Test: Test the Small Version of the Model Test: Test the Small Version of the Model Analyze: Analyze the Model (Before Solver) Analyze: Analyze the Model (After Solver) Guidelines for Building “Good” Spreadsheet Models Guidelines for Building “Good” Spreadsheet Models Guidelines for Building “Good” Spreadsheet Models Guidelines for Building “Good” Spreadsheet Models Guidelines for Building “Good” Spreadsheet Models