Excel Models for Business and Operations Management

Author:
John F. Barlow
Format:
Softcover

Was:R709.95
Now:R596.95
eBucks:eB5970

United States of America

Delivery:
Usually within 16 working days.
Seller:
kalahari.com

Excel Models for Business and Operations Management

Short description

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.

Long description

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.

Product details

Publisher:
John Wiley & Sons
ISBN:
9780470015094
Publication date:
June 2005
Length:
235mm
Width:
188mm
Thickness:
24mm
Weight:
789g
Edition:
2nd Edition
Pages:
415
Illustrations:
Illustrated
Readership:
Tertiary education; Professional & scholarly
Illustrated:
Illustrated

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

Other available formats


Other products to consider

Business Analysis
Business Analysis

Author:
Keith Hindle; Malcolm Eva
Now R580.95
(eB 5810)
Visible Thinking: Unlocking Causal Mapping for Practical Business Results
Visible Thinking: Unlocking Causal Mapping for Practical Business Results

Author:
Fran Ackermann; John M. Bryson
Was R477.95
Now R401.95
(eB 4020)

Customer reviews & ratings

Buy this product

Excel Models for Business and Operations Management

Excel Models for Business and Operations Management

Was:R709.95
Now:R596.95
eBucks:eB5970
The basket has moved
 
Free delivery on orders over R250 *
 
My wishlists
Your wishlist is empty
Earn with Visa Premium
 
eBucks
 
m.kalahari.com
 
Become a corporate client with kalahari.com
 
Book donation project