Barlow: Excel Models for Business 2e

2. Auflage 2005
ISBN: 978-0-470-01509-4
Verlag: Wiley John + Sons

Buch, Englisch, 432 Seiten, Format (B × H): 190 mm x 236 mm, Gewicht: 788 g

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.

Autoren/Hrsg.

Barlow, John

Fachgebiete

• Wirtschaftswissenschaften Betriebswirtschaft Management
• Mathematik | Informatik EDV | Informatik Business Application Tabellenkalkulation Microsoft Excel

Inhaltsverzeichnis

Preface

A SYSTEMS VIEW OF BUSINESS

Overview

A systems view of business operations

A manufacturing business model

Finance and cost accounting

The marketing function

The production function

Management decision-making

References and further reading

MODEL-BUILDING TOOLS

Overview

Modelling characteristics

Risk and uncertainty in decision-making

Linear programming (LP)

Using Excel's 'Analysis ToolPak'

Statistical methods

Decision analysis

Simulation

Excel functions used in model-building

Exercises

References and further reading

PART 1: BUSINESS MODELS

FINANCIAL MODELS

Overview

Financial statements

Ratio analysis

Net present value (NPV)

Investment appraisal

Portfolio management

Capital budgeting using decision trees

Cash flow analysis

Investment financing: a simulation model

Financial planning

Excel add-ins: small business financial manager

Excel functions used in model-building

Exercises

References and further reading

INVESTMENT ANALYSIS MODELS

Overview

Risk Preference Attitudes

Utility Theory

Portfolio theory - the Markowitz model

Portfolio analysis - the efficient frontier

Single index model (SIM)

Using SIM to derive the covariance matrix

Capital asset pricing model (CAPM)

Bond valuation

Duration and bond volatility

Black-Scholes option pricing model

Excel functions used in model-building

Exercises

References and further reading

WORKSHEET APPLICATIONS IN COST ACCOUNTING

Overview

Cost-volume-profit analysis

Depreciation

Equipment replacement

Statistical replacement analysis

Simulation model for replacement/repairs

Comparison between simulation and statistical results

Budgeting

Job costing

The learning curve

Checking the accuracy of learning curves

Excel functions used in model-building

Exercises

References and further reading

MARKETING MODELS

Overview

Organising and presenting data

Correlation analysis and linear regression

Forecasting - time series and exponential smoothing

Forecasting - exponential smoothing

Salesforce models

Goal programming

Excel functions used in model-building

Exercises

References and further reading

PURCHASE ORDER PROCESSING

Overview

Creating a simple macro

Purchase order processing

Creating the title screen

Products and suppliers worksheets

Creating the purchase order form

Creating the database and its associated macros

Macros for transferring data into the database

Adding macros to buttons

Amending purchase orders

Printing purchase orders

Protecting the POP database application

Excel functions used in model-building

Exercises

References and further reading

PART 2: MODELS FOR OPERATIONS MANAGEMENT

STATISTICAL APPLICATIONS IN QUALITY CONTROL

Overview

Probability distributions

Acceptance sampling

Estimation - drawing conclusions from samples

Hypothesis testing - checking out a claim!

Analysis of variance (ANOVA)

Statistical process control

Excel functions used in model-building

Exercises

References and further reading

INVENTORY CONTROL MODELS

Overview

Glossary of inventory terms

Characteristics of inventory models

Deterministic models

Production order quantity model

Inventory models with constraints

Probabilistic models

Inventory controls: a simulation approach

Material requirements planning (MRP)

Lot-sizing methods

Just-in-time (JIT) approach to inventory management

Excel functions used in model-building

Exercises

References and further reading

MODELS FOR PRODUCTION OPERATIONS

Overview

Logistics models

Other network flow applications

Production planning and scheduling

Queuing models

Excel functions used in model-building

Exercises

References and further reading

PROJECT MANAGEMENT

Overview

Project management techniques

The project network

Critical path method (CPM)

Simulation model for project management

Exercises

References and further reading

Appendix: Excel refresher notes

Basic Excel commands

Drawing graphs with ChartWizard

Object linking and embedding (OLE).

Über Autor(innen)

Dr Barlow holds degrees in mathematics, computer science, and mechanical engineering. As well as extensive teaching experience - previously at the Universities of Cape Town, South Africa and Wollongong, Australia - he has held various positions in computer consultancy and the petroleum industry. He has published numerous papers in the areas of computer applications and systems management.