Quantitative Methods for Decision Making Using Excel

Quantitative Methods for Decision Making Using Excelis a comprehensive guide that provides students with the key techniques and methodology they need in order to successfully engage with all aspects of quantitative analysis and decision making--both in their undergraduate studies and in the larger context of their future business environments. Organized in accordance with the enterprise functional structure where the decision making takes place, the textbook encompasses a broad range of functions, each of which is illustrated with clear examples using Microsoft Excel. The authors approach a range of methods, dividing them into major enterprise functions such as marketing, sales, business development, manufacturing, quality control, and finance. The authors illustrate how the methods can be applied in practice and translated into a working environment. Each chapter contains short case studies that exemplify the practical use of techniques. Exercises following key sections and concepts provide students with the opportunity to monitor their own progress using the solutions at the back of the book. The accompanyingCompanion Website(www.oup.com/uk/orc/bin/9780199694068) offers a variety of features: For students: - Numerical skills workbook with additional exercises, questions, and content - Data from the examples and exercises in the book - Online glossary of terms - Revision tips - Visual walkthrough videos covering the application of a range of quantitative methods - Appendices to the book For instructors: - Instructor's Manual containing solutions from the text and a guide to structuring lectures and seminars - PowerPoint presentations - Test Bank with questions for each chapter - Suggested assignment and examination questions

Part 1. Refresher Course in Business Mathematics and Statistics
1. Refresher Course in Key Numerical Skills
2. Descriptive Statistics and Basic Survey Processing
Part 2. Decision Making in Marketing, Sales, and Business Development
3. Fundamentals of Statistical Decision Making
4. Prediction and Forecasting
Part 3. Decision Making in Manufacturing and Quality
5. Optimization
6. Inventory and Stock Control
7. Statistical Quality Control
8. Project Planning and Control
Part 4. Decision Making in Finance
9. Decision Making in Business
10. Decision Making in Finance
11. Simulation