Excel Models for Business and Operations Management

Informationen zum Autor 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. Klappentext 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 ExcelExcel 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. Zusammenfassung 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 ExcelExcel 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 PrefaceA SYSTEMS VIEW OF BUSINESSOverviewA systems view of business operationsA manufacturing business modelFinance and cost accountingThe marketing functionThe production functionManagement decision-makingReferences and further readingMODEL-BUILDING TOOLSOverviewModelling characteristicsRisk and uncertainty in decision-makingLinear programming (LP)Using Excel's 'Analysis ToolPak'Statistical methodsDecision analysisSimulationExcel functions used in model-buildingExercisesReferences and further readingPART 1: BUSINESS MODELSFINANCIAL MODELSOverviewFinancial statementsRatio analysisNet present value (NPV)Investment appraisalPortfolio managementCapital budgeting using decision treesCash flow analysisInvestment financing: a simulation mo...

List of contents

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

Product details

• Authors: Barlow, Jf Barlow, John Barlow, John (Dublin Institute of Technology) Barlow, John F. Barlow
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 22.04.2005
• EAN: 9780470015094
• ISBN: 978-0-470-01509-4
• No. of pages: 432
• Subjects: Social sciences, law, business > Business > Management; Management, Excel, Business & management, Produktionssteuerung, Wirtschaft u. Management, Production Operations Management