Business Modelling With Spreadsheet

Author

Thin-Yin Leong/ Michelle Cheong

3rd Edition

Publisher

McGraw-Hill Education

Publishing Year

2014

Conditions

New

ISBN

9789814595155

Pricing Information

Delivery Information

Delivery using City-Link Express. It should be arrived in 3-5 working days.

Shipping Cost
Shipping cost for Peninsular Malaysia is free. For Sabah and Sarawak, another RM 10 will be charged.

~Description / table of content~

CHAPTER 1 SPREADSHEET MODELING
Pt 1: Concrete versus abstract
Pt 2: Ratio and relativity
Pt 3: Projection versus targeting
Pt 4: Questions and givens
Pt 5: Case study and analysis

CHAPTER 2 PROBLEM SOLVING AND SPREADSHEET ENGINEERING
Pt 6: Exploratory modeling
Pt 7: Linear approximation
Pt 8: What-if, trade-off and sensitivity
Pt 9: Validity, pros and cons
Pt 10: Business excellence

CHAPTER 3 DATA LOOKUP AND LINKUP
Pt 11: Business functions
Pt 12: Plans are just plans
Pt 13: Price differentiation
Pt 14: Discount and rebate
Pt 15: Search and iteration

CHAPTER 4 RELATIONSHIPS
Pt 16: Money over time
Pt 17: Spot, future and option
Pt 18: Simple is hard; hard is simple
Pt 19: Graphic representation
Pt 20. Business strategy analyses

CHAPTER 5 MAKING ASSUMPTIONS
Pt 21: Market and auction
Pt 22: Complexity and competition
Pt 23: Policy, not numbers
Pt 24: Parametric analysis

CHAPTER 6 RISKS AND UNCERTAINTIES
Pt 25: Status quo and change
Pt 26: Follow the contender
Pt 27: Predictably irrational
Pt 28: Flaw of averages

CHAPTER 7 PROCESSES AND TIME
Pt 29: Waiting in line
Pt 30: Power of observation
Pt 31: Single and multiple queues
Pt 32: Queue inference

CHAPTER 8 ANALYZING THE DATA
Pt 33: Practical data analysis
Pt 34: Black swans and data you don’t have
Pt 35: Inadequate and missing data
Pt 36: Correlations and unintended effects

CHAPTER 9 MODELING PROJECTS
Pt 37: Community and individual
Pt 38: Business and services
Pt 39: New venture
Pt 40: Finance and administration
Pt 41: Transportation and supply chain
Pt 42: Manufacturing and operations
Pt 43: Information technology and communications
Pt 44: Global and environmental
Pt 45: Phase out skeuomorphs
Pt 46: Design thinking and social change

APPENDIX A EXCEL 2010-13 FEATURES AND FUNCTIONS
APPENDIX B VISUAL BASIC FOR APPLICATION