Business Modeling with Spreadsheets: Problems, Principles and Practice

 
9789814595155: Business Modeling with Spreadsheets: Problems, Principles and Practice
View all copies of this ISBN edition:
 
 

This book is wholly dedicated to the art of exploratory spreadsheet modeling. Real problems that readers encounter on a day-to-day basis are presented, with the aim of helping them derive applicable principles and link principles to practice.

Users of this book will find it a refreshing learning guide and handy reference resource. It offers 101 spreadsheet exercises and tools, including a chapter featuring another 101 business challenges that readers can practice as modeling projects. Introduced for the first time in this third edition is a set of Discovery Points, 46 in total. They are included to enlighten readers and instructors on the underlying exploratory thinking employed in the exercises.

Though the book can be used with different versions of Microsoft Excel, LibreOffice and OpenOffice Calc, and other spreadsheet application software, this edition only presents Excel 2010-13 spreadsheet features and functions, and Visual Basic for Application in its appendices.

The notes for older Excel versions, and OpenOffice Calc and Basic from the earlier editions, and the newly added LibreOffice Calc and Basic are now found in a new Online Learning Center that accompanies this book. Completed spreadsheet workbooks in the different spreadsheet versions are also provided there.

This way, the book should remain helpful for any person, whether a novice, beginner, or expert, to learn business modeling using basic and advanced spreadsheet features, as well as macro programming.

NEW IN THIS EDITION

Discovery Points:

To better support underlying thinking and give pointers to guide business problem exploration. These are more general than the comments in the Concept sub-section of exercises and they are ideas many experienced modelers use intuitively. Listed at the start of each chapter to help consolidate the learning for seasoned modelers, and make it easier for instructors to impart the art of modeling to students. These points can be used for self-discovery, class discussion and project team deliberations. They can be applied to various settings and exercises found in this book.

Problem Sets:

Provides a means to test students to ensure that learning has taken place at the correct pace. A separate question sets of assignments, quizzes and examinations apart from the exercises in the book. These are simpler and more defined problems for students to practice and be evaluated on their spreadsheet skills. The questions with given data are easier and the harder questions are marked with an asterisk (*). TARGET AUDIENCE

Undergraduates, graduate students, and professionals involved in business development, finance, accounting and operations.

"synopsis" may belong to another edition of this title.

About the Author:

Dr Leong is currently Associate Professor at the SIM University in Singapore. He was Associate Dean (Strategic Planning and Initiatives) and a faculty member, for 10 years, of the School of Information Systems at the Singapore Management University. Before that, he was a faculty member, for 10 years, of the National University of Singapore s Business School. Over two decades, he had designed and taught many courses in operations management, logistics and supply chain management, and business spreadsheet modeling in undergraduate, MBA, and executive programs. In between academia, Dr Leong spent more than a decade in the industry and served as Vice-President (Operations Planning & Research) and Senior Vice-President (Information Technology) with the port operator that runs the world s busiest container terminal, where he spearheaded its operations improvements, and systems and technology development. He also provided many models that supported management decisions in strategy, capacity development, operational planning and scheduling, and financial and tax issues. One of his current pet teaching and research interests is spreadsheet modeling and analysis, leveraging his past experience for research as well as industry applications. Although in academia, he remains active in business consulting and has worked with many multinational corporations and local companies, particularly those in the electronics, petrochemical, medical, hospitality, banking, cargo logistics, passenger transport, and government sectors.

Dr Cheong is Associate Professor of Information Systems (Practice) at the Singapore Management University (SMU) and Director of the School of Information System s (SIS) Postgraduate Professional Programmes, where she is in charge of two master programmes and Continuing Education & Training. Cheong had worked eight years in the industry developing and implementing enterprise IT solutions for manufacturing companies. She had led teams to develop complex IT systems which were implemented enterprise-wide covering business functions from sales to engineering, inventory management, planning, production, and distribution. She consulted for precision engineering, printing, aerospace, and brewery companies in business process reengineering for IT solutions implementation. Upon obtaining her Ph.D. degree in Operations Management, she joined SMU in 2005 where she teaches the Business Modeling with Spreadsheets course at the undergraduate level. She also teaches different variants of spreadsheet modeling courses in 3 different master programmes at SMU, covering different domains, including financial modeling, innovation modeling and IT project management. She recently designed and delivered an Operations analytics and applications course for the Master of IT in Business (Analytics) programme at SIS.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Thin-Yin LEONG; Michelle L.F. CHEONG
ISBN 10: 9814595152 ISBN 13: 9789814595155
New Quantity Available: 4
Seller:
Books Puddle
(New York, NY, U.S.A.)

Book Description Condition: New. pp. 350. Seller Inventory # 26372807217

More information about this seller | Contact this seller

Buy New
US$ 30.53
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

2.

Thin-Yin LEONG; Michelle L.F. CHEONG
ISBN 10: 9814595152 ISBN 13: 9789814595155
New Quantity Available: 4
Seller:
Majestic Books
(London, United Kingdom)

Book Description Condition: New. pp. 350. Seller Inventory # 374286830

More information about this seller | Contact this seller

Buy New
US$ 29.96
Convert currency

Add to Basket

Shipping: US$ 6.87
From United Kingdom to U.S.A.
Destination, rates & speeds
International Edition
International Edition

3.

Leong, Cheon
ISBN 10: 9814595152 ISBN 13: 9789814595155
New Quantity Available: 1
International Edition
Seller:
firstbookstore
(New Delhi, India)

Book Description Condition: Brand New. Brand New Paperback International Edition, Perfect Condition. Printed in English. Excellent Quality, Service and customer satisfaction guaranteed!. Seller Inventory # ABINN-22075

More information about this seller | Contact this seller

Buy New
US$ 38.28
Convert currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, rates & speeds
International Edition
International Edition

4.

Leong, Cheong
ISBN 10: 9814595152 ISBN 13: 9789814595155
New Quantity Available: 5
International Edition
Seller:
EBOOKSTORE2010
(New Delhi, ND, India)

Book Description Condition: Brand New. New. SoftCover International edition. Different ISBN and Cover image but contents are same as US edition. Customer Satisfaction guaranteed!!. Seller Inventory # SHUB134236

More information about this seller | Contact this seller

Buy New
US$ 39.29
Convert currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, rates & speeds
International Edition
International Edition

5.

Leong, Cheong
ISBN 10: 9814595152 ISBN 13: 9789814595155
New Quantity Available: 5
International Edition
Seller:
Bookshub
(Karol Bagh, India)

Book Description Condition: New. New. SoftCover International edition. Different ISBN and Cover image but contents are same as US edition. Perfect condition. Customer satisfaction our priority. Seller Inventory # ABE-DEC-134236

More information about this seller | Contact this seller

Buy New
US$ 39.42
Convert currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, rates & speeds
International Edition
International Edition

6.

Leong, Cheong
ISBN 10: 9814595152 ISBN 13: 9789814595155
New Softcover Quantity Available: 5
International Edition
Seller:
Basi6 International
(Irving, TX, U.S.A.)

Book Description Condition: Brand New. New.SoftCover International edition. Different ISBN and Cover image but contents are same as US edition. Expediting shipping for all USA and Europe orders excluding PO Box. Excellent Customer Service. Seller Inventory # ABEUSADEC19-134236

More information about this seller | Contact this seller

Buy New
US$ 40.71
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds
International Edition
International Edition

7.

Leong, Cheon
ISBN 10: 9814595152 ISBN 13: 9789814595155
New Softcover Quantity Available: 1
International Edition
Seller:
Romtrade Corp.
(STERLING HEIGHTS, MI, U.S.A.)

Book Description Condition: New. Brand New Paperback International Edition.We Ship to PO BOX Address also. EXPEDITED shipping option also available for faster delivery.This item may ship fro the US or other locations in India depending on your location and availability. Seller Inventory # AUDECC-22075

More information about this seller | Contact this seller

Buy New
US$ 40.71
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

8.

Thin-Yin LEONG; Michelle L.F. CHEONG
Published by U.S.A.: McGraw-Hill Education (Asia) (2014)
ISBN 10: 9814595152 ISBN 13: 9789814595155
New Soft cover Quantity Available: 1
Seller:
Supernew USA
(Bangkok, BKK, Thailand)

Book Description U.S.A.: McGraw-Hill Education (Asia), 2014. Soft cover. Condition: New. 3rd Edition. New, 3rd Edition .Delivery time is 3-5 business days via either UPS, FedEx, DHL. Premium quality books. Seller Inventory # 9814595152

More information about this seller | Contact this seller

Buy New
US$ 50.99
Convert currency

Add to Basket

Shipping: US$ 10.00
From Thailand to U.S.A.
Destination, rates & speeds

9.

Cheong Leong
ISBN 10: 9814595152 ISBN 13: 9789814595155
New Paperback Quantity Available: 1
Seller:
Grand Eagle Retail
(Wilmington, DE, U.S.A.)

Book Description 2014. Paperback. Condition: New. 3rd. Paperback. This book is wholly dedicated to the art of exploratory spreadsheet modeling. Real problems that readers encounter on a day-to-day basis are presented with the aim of helping them derive a.Shipping may be from multiple locations in the US or from the UK, depending on stock availability. 350 pages. 0.710. Seller Inventory # 9789814595155

More information about this seller | Contact this seller

Buy New
US$ 85.92
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

10.

Cheong Leong
ISBN 10: 9814595152 ISBN 13: 9789814595155
New Paperback Quantity Available: 1
Seller:
AussieBookSeller
(Lidcombe, NSW, Australia)

Book Description 2014. Paperback. Condition: New. 3rd. Paperback. This book is wholly dedicated to the art of exploratory spreadsheet modeling. Real problems that readers encounter on a day-to-day basis are presented with the aim of helping .Shipping may be from our Sydney, NSW warehouse or from our UK or US warehouse, depending on stock availability. 350 pages. 0.710. Seller Inventory # 9789814595155

More information about this seller | Contact this seller

Buy New
US$ 78.79
Convert currency

Add to Basket

Shipping: US$ 37.00
From Australia to U.S.A.
Destination, rates & speeds