Excel Models for Business and Operations Management
(Sprache: Englisch)
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...
Leider schon ausverkauft
versandkostenfrei
Buch (Kartoniert)
88.10 €
- Lastschrift, Kreditkarte, Paypal, Rechnung
- Kostenlose Rücksendung
- Ratenzahlung möglich
Produktdetails
Produktinformationen zu „Excel Models for Business and Operations Management “
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.
Klappentext zu „Excel Models for Business and Operations Management “
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.
Inhaltsverzeichnis zu „Excel Models for Business and Operations Management “
PrefaceA 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
... mehr
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
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
... weniger
Autoren-Porträt von John Barlow
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.
Bibliographische Angaben
- Autor: John Barlow
- 2005, 2. Aufl., 416 Seiten, mit Abbildungen, Maße: 19,1 x 23,5 cm, Kartoniert (TB), Englisch
- Verlag: Wiley & Sons
- ISBN-10: 0470015098
- ISBN-13: 9780470015094
- Erscheinungsdatum: 07.06.2005
Sprache:
Englisch
Kommentar zu "Excel Models for Business and Operations Management"
Schreiben Sie einen Kommentar zu "Excel Models for Business and Operations Management".
Kommentar verfassen