Excel Models for Business 2e

Adopting an active learning approach with the emphasis being placed on the utilization of software tools to help build models, this book's primary approach is to help the reader put theory into practice. The 'learn by example' approach used throughout the book guides the user through the complexities of model building. Excel Models for Business and Operations Management, Second Edition, adopts a structured approach to management decision-making by integrating the activities of a manufacturing organization. The text is entirely assignment-based and uses Microsoft’s Excel software to develop over eighty models. Everyday examples from finance, marketing and operations management form the basis of the book’s ‘hands-on’ development models. As in the previous edition, the emphasis is on the practical implementation of real-world models rather than traditional theoretical concepts. The book’s learn-by-example approach helps to develop both analytical and mathematical skills by focusing on the formulation and building of business models. New features in the second edition include Finance models in a new chapter on investment analysis models Job sequencing including a VBA routine for Johnson’s Rule Multiplicative Holt-Winter’s model All models and reference notes updated to the latest version of Excel Excel Models for Business and Operations Management is ideally suited to intermediate and advanced undergraduate courses, as well as MBA courses, in business studies, finance, accounting, information technology, and operations management. It should be of interest to managers and analysts who want to develop their model-building skills. The popularity of spreadsheets in both business and academia has increased considerably over the past five years. This new edition of a successful textbook will be thoroughly updated to reflect changing practices and technology. This text adopts an active learning approach with the emphasis being placed on the utilization of software tools to help build models. The book’s primary approach is to help the reader put theory into practice. The ‘learn by example’ approach used throughout the book guides the user through the complexities of model building. Every day examples from business and operations management form the basis of the book’s ‘hands on’ development models that help the reader to appreciate Excel’s power and flexibility.