Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
---|---|---|---|---|---|
Searching... | 30000010229085 | HF5548.4.M523 B37 2005 | Open Access Book | Book | Searching... |
On Order
Summary
Summary
The popularity of spreadsheets in both business and academia has increased considerably over the past five years. This new edition of a successful textbook will be thoroughly updated to reflect changing practices and technology.
This text adopts an active learning approach with the emphasis being placed on the utilization of software tools to help build models. The 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. Every day examples from business and operations management form the basis of the book's 'hands on' development models that help the reader to appreciate Excel's power and flexibility.
Author Notes
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.
Table of Contents
Preface | p. xiii |
1 A systems view of business | p. 1 |
Overview | p. 1 |
A systems view of business operations | p. 2 |
A manufacturing business model | p. 3 |
Finance and cost accounting | p. 3 |
The marketing function | p. 5 |
The production function | p. 5 |
Management decision-making | p. 12 |
Enterprise resource planning (ERP) | p. 15 |
References and further reading | p. 16 |
2 Model-building tools | p. 17 |
Overview | p. 17 |
Modelling characteristics | p. 18 |
Risk and uncertainty in decision-making | p. 20 |
Linear programming (LP) | p. 21 |
Using Excel's 'Analysis ToolPak' | p. 26 |
Statistical methods | p. 27 |
Decision analysis | p. 34 |
Simulation | p. 42 |
Excel functions used in model-building | p. 46 |
Exercises | p. 49 |
References and further reading | p. 51 |
Part 1 Business Models | p. 53 |
3 Financial models | p. 55 |
Overview | p. 55 |
Financial statements | p. 56 |
Ratio analysis | p. 56 |
Net present value (NPV) | p. 59 |
Investment appraisal | p. 61 |
Portfolio management | p. 64 |
Capital budgeting using decision trees | p. 68 |
Cash flow analysis | p. 69 |
Investment financing: a simulation model | p. 74 |
Financial planning | p. 78 |
Commercial add-in products for Excel | p. 82 |
Excel functions used in model-building | p. 82 |
Exercises | p. 86 |
References and further reading | p. 88 |
4 Investment analysis models | p. 89 |
Overview | p. 89 |
Risk preference attitudes | p. 90 |
Utility theory | p. 91 |
Portfolio theory: the Markowitz model | p. 94 |
Portfolio analysis: the efficient frontier | p. 97 |
Single index model (SIM) | p. 101 |
The capital asset pricing model (CAPM) | p. 106 |
Bond valuation | p. 108 |
Duration and bond volatility | p. 113 |
The Black-Scholes option pricing model | p. 117 |
Excel functions used in model-building | p. 120 |
Exercises | p. 124 |
References and further reading | p. 126 |
5 Worksheet applications in cost accounting | p. 127 |
Overview | p. 127 |
Cost-volume-profit analysis | p. 128 |
Depreciation | p. 130 |
Equipment replacement | p. 132 |
Statistical replacement analysis | p. 136 |
Simulation model for replacement/repairs | p. 140 |
Comparison between simulation and statistical results | p. 144 |
Budgeting | p. 144 |
Job costing | p. 150 |
The learning curve | p. 155 |
Checking the accuracy of learning curves | p. 158 |
Excel functions used in model-building | p. 160 |
Exercises | p. 163 |
References and further reading | p. 166 |
6 Marketing models | p. 167 |
Overview | p. 167 |
Organising and presenting data | p. 167 |
Correlation analysis and linear regression | p. 170 |
Forecasting - time series and exponential smoothing | p. 174 |
Forecasting - exponential smoothing | p. 178 |
Salesforce models | p. 186 |
Goal programming | p. 190 |
Excel functions used in model-building | p. 200 |
Exercises | p. 201 |
References and further reading | p. 205 |
7 Purchase order processing: a database application | p. 206 |
Overview | p. 206 |
Creating a simple macro | p. 207 |
Purchase order processing | p. 209 |
Creating the title screen | p. 210 |
Products and suppliers worksheets | p. 214 |
Creating the purchase order form | p. 215 |
Creating the database and its associated macros | p. 219 |
Macros for transferring data into the database | p. 221 |
Adding macros to buttons | p. 224 |
Amending purchase orders | p. 225 |
Printing purchase orders | p. 230 |
Protecting the POP database application | p. 232 |
Excel functions used in model-building | p. 236 |
Exercises | p. 237 |
References and further reading | p. 239 |
Part 2 Models for Operations Management | p. 241 |
8 Statistical applications in quality control | p. 243 |
Overview | p. 243 |
Probability distributions | p. 244 |
Acceptance sampling | p. 249 |
Estimation - drawing conclusions from samples | p. 253 |
Hypothesis testing - checking out a claim! | p. 257 |
Analysis of variance (ANOVA) | p. 258 |
Statistical process control | p. 263 |
Excel functions used in model-building | p. 272 |
Exercises | p. 275 |
References and further reading | p. 278 |
9 Inventory control models | p. 279 |
Overview | p. 279 |
Glossary of inventory terms | p. 280 |
Characteristics of inventory models | p. 281 |
Deterministic models | p. 282 |
Production order quantity model | p. 284 |
Inventory models with constraints | p. 291 |
Probabilistic models | p. 293 |
Inventory control: a simulation approach | p. 304 |
Material requirements planning | p. 307 |
Lot-sizing methods | p. 315 |
Just-in-time (JIT) approach to inventory management | p. 318 |
Excel functions used in model-building | p. 318 |
Exercises | p. 319 |
References and further reading | p. 323 |
10 Models for production operations | p. 324 |
Overview | p. 324 |
Logistics models | p. 325 |
Other network flow applications | p. 331 |
Production planning and scheduling | p. 339 |
Queuing models | p. 353 |
Excel functions used in model-building | p. 362 |
Exercises | p. 364 |
References and further reading | p. 369 |
11 Project management | p. 370 |
Overview | p. 370 |
Project management techniques | p. 371 |
The project network | p. 371 |
Simulation model for project management | p. 392 |
Exercises | p. 396 |
References and further reading | p. 399 |
Appendix Excel refresher notes | p. 400 |
Basic Excel commands | p. 400 |
Drawing charts with ChartWizard | p. 405 |
Object linking and embedding (OLE) | p. 407 |
Index | p. 409 |