Barlow | Excel Models for Business 2e | Buch | sack.de

Barlow Excel Models for Business 2e



2. Auflage 2005, 432 Seiten, Kartoniert, Paperback, Format (B × H): 191 mm x 235 mm, Gewicht: 802 g
ISBN: 978-0-470-01509-4
Verlag: John Wiley & Sons


Barlow Excel Models for Business 2e

Lieferung vom Verlag mit leichten Qualitätsmängeln möglich

Autoren/Hrsg.


Weitere Infos & Material


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).


Barlow, John
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.



Ihre Fragen, Wünsche oder Anmerkungen

Vorname*
Nachname*
Ihre E-Mail-Adresse*
Kundennr.
Ihre Nachricht*
Lediglich mit * gekennzeichnete Felder sind Pflichtfelder.
Wenn Sie die im Kontaktformular eingegebenen Daten durch Klick auf den nachfolgenden Button übersenden, erklären Sie sich damit einverstanden, dass wir Ihr Angaben für die Beantwortung Ihrer Anfrage verwenden. Selbstverständlich werden Ihre Daten vertraulich behandelt und nicht an Dritte weitergegeben. Sie können der Verwendung Ihrer Daten jederzeit widersprechen. Das Datenhandling bei Sack Fachmedien erklären wir Ihnen in unserer Datenschutzerklärung.