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

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