Advertisement
| excel for operations management: Excel Models for Business and Operations Management John F. Barlow, 2005 Market_Desc: · Business Studies, Accounting, Finance, and Operations Management courses that offer practical computing skills as an integral part of the course syllabus· Managers and Analysts who want to develop their model-building skills Special Features: · The use of spreadsheet models in finance, business and management decision-making is on the increase· Other books on spreadsheet modeling tend to focus on applied management science and complex financial models, which restricts the market· This new edition will follow the active learning approach which focuses on the practical aspect of how to build computer models while summarizing the mathematical logic as to why the model is so constructed· A website will accompany the text, containing hands on development models to enable the reader to put theory into practice.· A new chapter entitled Investment Analysis Models will be added to widen the appeal to students in finance and accounting.· All references to Excel (including the Excel refresher notes in the appendix) have been upgraded to reflect the latest version of Microsoft Office (e. g. Excel 2003 and Windows XP)· Job sequencing including a VBA routine for Johnson s Rule· Multiplicative Holt-Winter s model About The Book: This text adopts an active learning approach with the emphasis being placed on the utilization of software tools to help build models. 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. |
| excel for operations management: Applied Statistics for Business and Management using Microsoft Excel Linda Herkenhoff, John Fogli, 2013-11-26 Applied Business Statistics for Business and Management using Microsoft Excel is the first book to illustrate the capabilities of Microsoft Excel to teach applied statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical statistical problems in industry. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in statistics courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Applied Business Statistics for Business and Management capitalizes on these improvements by teaching students and practitioners how to apply Excel to statistical techniques necessary in their courses and workplace. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand business problems. Practice problems are provided at the end of each chapter with their solutions. |
| excel for operations management: Balanced Scorecards and Operational Dashboards with Microsoft Excel Ron Person, 2010-08-26 Created in Excel, balanced scorecards enable you to monitor operations and tactics, while operational dashboards is a set of indicators regarding the state of a business metric or process—both features are in high demand for many large organizations. This book serves as the first guide to focus on combining the benefits of balanced scorecards, operational dashboards, performance managements, and data visualization and then implement them in Microsoft Excel. |
| excel for operations management: Operations Research Using Excel Vikas Singla, 2021-09-16 The field of operations research provides a scientific approach to managerial decision making. In a contemporary, hypercompetitive ever-changing business world, a manager needs quantitative and factual ways of solving problems related to optimal allocation of resources, profit/loss, maximization/minimization etc. In this endeavor, the subject of doing research on how to manage and make operations efficient is termed as Operations Research. The reference text provides conceptual and analytical knowledge for various operations research techniques. Readers, especially students of this subject, are skeptic in dealing with the subject because of its emphasis on mathematics. However, this book has tried to remove such doubts by focusing on the application part of OR techniques with minimal usage of mathematics. The attempt was to make students comfortable with some complicated topics of the subject. It covers important concepts including sensitivity analysis, duality theory, transportation solution method, Hungarian algorithm, program evaluation and review technique and periodic review system. Aimed at senior undergraduate and graduate students in the fields of mechanical engineering, civil engineering, industrial engineering and production engineering, this book: • Discusses extensive use of Microsoft Excel spreadsheets and formulas in solving operations research problems • Provides case studies and unsolved exercises at the end of each chapter • Covers industrial applications of various operations research techniques in a comprehensive manner • Discusses creating spreadsheets and using different Excel formulas in an easy-to-understand manner • Covers problem-solving procedures for techniques including linear programming, transportation model and game theory |
| excel for operations management: Management Science Stephen G. Powell, Kenneth R. Baker, 2010-10-26 Now in its third edition, Management Science helps business professionals gain the essential skills needed to develop real expertise in business modeling. The biggest change in the text is the conversion of software from Crystal Ball to Risk Solver to reflect changes in the field. More coverage of management science topics has been added. Broader coverage of Excel demonstrates how to create models. Additional open-ended case studies that are less structured have also been included along with new exercises. These changes will help business professionals learn how to apply the information in the field. |
| excel for operations management: Operations Management Robert Dan Reid, Nada R. Sanders, 2010 With its abundance of step-by-step solved problems, concepts, and examples of major real-world companies, this text brings unparalleled clarity and transparency to the course. |
| excel for operations management: Analytics for Managers Peter C. Bell, Gregory S. Zaric, 2013-01-04 Analytics is one of a number of terms which are used to describe a data-driven more scientific approach to management. Ability in analytics is an essential management skill: knowledge of data and analytics helps the manager to analyze decision situations, prevent problem situations from arising, identify new opportunities, and often enables many millions of dollars to be added to the bottom line for the organization. The objective of this book is to introduce analytics from the perspective of the general manager of a corporation. Rather than examine the details or attempt an encyclopaedic review of the field, this text emphasizes the strategic role that analytics is playing in globally competitive corporations today. The chapters of this book are organized in two main parts. The first part introduces a problem area and presents some basic analytical concepts that have been successfully used to address the problem area. The objective of this material is to provide the student, the manager of the future, with a general understanding of the tools and techniques used by the analyst. |
| excel for operations management: Excel for Marketing Managers Ivana Taylor, Bill Jelen, 2006-01-01 The most powerful Microsoft Excel features that can be used to sort through data to produce meaningful marketing analyses are outlined in this manual. Marketing managers will learn the math functions to produce budgets and forecasts, and how to use survey analysis to quickly spot trends using pivot tables and other analysis tools. Ideas for launch schedules, life cycle management, and other date-related information are also presented. |
| excel for operations management: Data Analysis for Managers with Microsoft Excel S. Christian Albright, Wayne L. Winston, Christopher James Zappe, 2004 This text presents statistical concepts and methods in a unified, modern, spreadsheet-oriented approach. Featuring a wealth of business applications, this examples-based text illustrates a variety of statistical methods to help students analyze data sets and uncover important information to aid decision-making. DATA ANALYSIS FOR MANAGERS contains professional StatPro add-ins for Microsoft Excel from Palisade, valued at one hundred fifty dollars packaged at no additional cost with every new text. |
| excel for operations management: Principles of Operations Management Jay H. Heizer, Barry Render, 2004 In this textbook, Heizer (business administration, Texas Lutheran U.) and Render (operations management, Rollins College) provide a broad introduction to the field of operations management. A sampling of topics includes operations strategy for competitive advantage, forecasting, design of goods and services, human resources, e- commerce, project management, inventory management, and maintenance. The CD-ROM contains video case studies, lecture notes, Excel OM and Extend software, and additional practice problems. Annotation copyrighted by Book News Inc., Portland, OR |
| excel for operations management: Operations Analysis Using Microsoft Excel Nancy C. Weida, Ronny Richardson, Andrew Vazsonyi, 2001 This book offers practical approaches to managerial decision making using spreadsheets. The operations management problems reflect overall organizational issues and integrate other functional areas such as marketing and finance. This book presupposes only a familiarity with Microsoft Excel to learn both basic and advanced techniques. |
| excel for operations management: The Encyclopedia of Operations Management Arthur V. Hill, 2012 This is the perfect field manual for every supply chain or operations management practitioner and student. The field's only single-volume reference, it's uniquely convenient and uniquely affordable. With nearly 1,500 well-organized definitions, it can help students quickly map all areas of operations and supply chain management, and prepare for case discussions, exams, and job interviews. For instructors, it serves as an invaluable desk reference and teaching aid that goes far beyond typical dictionaries. For working managers, it offers a shared language, with insights for improving any process and supporting any training program. It thoroughly covers: accounting, customer service, distribution, e-business, economics, finance, forecasting, human resources, industrial engineering, industrial relations, inventory management, healthcare management, Lean Sigma/Six Sigma, lean thinking, logistics, maintenance engineering, management information systems, marketing/sales, new product development, operations research, organizational behavior/management, personal time management, production planning and control, purchasing, reliability engineering, quality management, service management, simulation, statistics, strategic management, systems engineering, supply and supply chain management, theory of constraints, transportation, and warehousing. Multiple figures, graphs, equations, Excel formulas, VBA scripts, and references support both learning and application. ... this work should be useful as a desk reference for operations management faculty and practitioners, and it would be highly valuable for undergraduates learning the basic concepts and terminology of the field. Reprinted with permission from CHOICE http: //www.cro2.org, copyright by the American Library Association. |
| excel for operations management: Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) Wayne Winston, 2021-12-17 Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winston's hands-on, scenario-focused guide helps you use today's Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts. Solve real problems with Microsoft Excel—and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Use recent Power Query enhancements to connect, combine, and transform data sources more effectively Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music Build more sophisticated and compelling charts Use the new XLOOKUP function to revolutionize your lookup formulas Master new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries Illuminate insights from geographic and temporal data with 3D Maps Improve decision-making with probability, Bayes' theorem, and Monte Carlo simulation and scenarios Use Excel trend curves, multiple regression, and exponential smoothing for predictive analytics Use Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook |
| excel for operations management: Fundamentals of operations management María Teresa Nogueras Lozano, Eva Ballesté-Morillas, We want to welcome you to both an exciting and tactical discipline: operations management. This manual on Fundamentals of operations management is an effective tool to understand one of the main functions of any organisation: the creation of goods and services. That is, to understand what resources are needed to generate the goods and services of an organisation in a global and highly competitive environment, while also incorporating new technologies. In this manual, along with the classic fundamentals of operations management, we will look forward towards what is coming and how it will impact process improvement in companies. The main goal of this book is to equip the reader with the fundamental concepts in operations management. To do this, it will present the main qualitative and quantitative models for managing operations both in public and private companies. As the reader will see, the chapters are structured with an easy-to-follow and rigorous thematic thread that will make each and every step understandable. All this book has been designed with a distance learning student or a self-taught reader, such as an entrepreneur, in mind. We aim to facilitate the learning of a discipline that for years has been considered complicated and specifically focused on certain professions, and to highlight its relevance and future opportunities. We strive for the reader to enjoy learning from this manual and to discover an exciting discipline with many career opportunities. The book combines both theory and practical exercises with real life cases whose examples will allow the learner to understand the day-to-day and the myriad of challenges and opportunities faced by operations management. The manual covers classic management topics such as process design, inventories, demand forecasting, etc., as well as newer concepts such as digitisation of the supply chain. As for the way the content is conveyed, we have opted for a simple language that facilitates understanding, while also being rigorous and precise. The methodology used is distance learning, which means that this manual is mainly intended for self-learning, and consequently, its structure is designed to promote the understanding of its contents. To achieve this goal: 1. The text is divided into eight chapters that present a logical and coherent sequence to understanding what operations management consists of: Chapter I “Operations in the Current Environment” defines what operations are in a company, teaching the reader about the evolution of this discipline in a global environment. The chapter shows the importance of the company’s competitiveness generators, and explains key concepts such as the value chain, the extended network, and digitisation, which are crucial in current production processes and serve as an introduction to other concepts that will be explained in further detail in the following chapters, which are aimed to teaching how to achieve a right tactical decision-making in operations management. Chapter II “Managing Operations” addresses the main topics in the day-to-day of operations management in order to get the reader in the context of the type of decisions that must be made in matters related to the supply chain, inventory management costs, planning the necessary materials, project management, among others, and understand the implications of such decisions in the proper functioning of the company. After having defined what operations are (Chapter I) and the types of decisions that need to be made for a successful operation (Chapter II), Chapter III, “Tools to Support Decision Making in Operations”, aims to provide the necessary tools to support decision-making in two main categories: quantitative and qualitative techniques. Quantitative techniques include decision trees, linear programming, transportation modelling, queuing models, learning curves, simulations, and sales forecasting. On the other hand, qualitative techniques include concepts such as judgment based on experience, customer surveys, and the Delphi method. By understanding these techniques, readers will be able to delve into key concepts in the following chapters in order to properly plan resources to respond to anticipated demand while avoiding cost overruns and waste and aligning with the company’s production capacity. Chapter IV, “Aggregate Planning,” addresses medium-term production planning, which typically spans between 6 and 18 months. Its main objective is to meet demand, which requires determining the production quantity, inventory levels, and the amount of work or labour force needed by the company, whether in-house or outsourced. To achieve this, it is necessary to develop an Aggregate Production Plan, which is essential for an efficient production. As determining the inventory level is one of the key factors in Aggregate Planning, this manual devotes two chapters to inventory management: Chapter V, “Inventory Management: Independent Demand” and Chapter VI, “Inventory Management: Dependant Demand”. In both chapters, inventory management and being able to determine the optimal quantity of supplies that should be ordered are critical factors for the company’s costs and productivity. Therefore, calculating the optimal order quantity is the central focus of both chapters. The decision to divide inventory management into two chapters is mainly due to the methods used to determine the optimal order quantities, which differ for materials with dependent and independent demand. For the latter case, classic or traditional methods (Chapter V) are not valid (initial assumptions change), and more complex systems, such as MRP (Material Requirements Planning), studied in Chapter VI of this manual, are required. In addition, inventory management has become a critical factor for a company’s competitiveness in today’s globalized world. The emergence of philosophies or approaches that practically eliminate inventory, such as the Just-In-Time (JIT) or Lean Manufacturing systems, cannot be overlooked, so they have their space in Chapter VI. Chapter VII, “Operational Scheduling,” constitutes the final link in operations management. Operational scheduling or short-term planning translates medium to long-term plans into short-term decisions aimed at allocating human resources, machines, and materials in the workplace to plan the most optimal work sequence possible. In short, it translates the Master Production Schedule (Chapter IV) and MRP (Chapter VI) into work sequences and specific assignments of people, materials, and machines to the work centres. Usually, assignments are made on a weekly, daily, and even hourly basis. The last chapter (Chapter VIII), “Quality in the Age of Planned Obsolescence”, tackles the concept of quality from the perspective of operations management and how it has evolved towards process improvement theories while addressing the phenomenon of planned obsolescence, waste generation, and the ethical commitment of operations management to preserve the environment. 2. Each chapter is structured as follows: · The title that identifies it. · A descriptive content section of its main sections. · The educational goals to be achieved after studying it, · Keywords. · An outline that orderly structures the content. · A summary that presents the most important contents and ideas of the chapter The text itself is complemented by graphics, examples, diagrams, and practical situations that occur in our business reality and highlight the application of theoretical concepts. · Glossary of terms · A series of self-assessment questionnaires for every chapter that aims to evaluate the reader’s degree of understanding of its contents (in the online portion of the manual). · Recommended readings (in the online portion of the manual) to reinforce the contents learned through articles, manuals or a combination of both that will allow the reader to establish their learning of all the key issues. Some chapters are also reinforced with videos found on the Internet that contain practical application cases of the studied contents. As can be seen, this book concludes with an extensive bibliography made up of manuals related to Operations Management. Finally, it is our wish that the reader enjoys the manual and that it opens the doors to new and interesting opportunities for them. Dr. Mª Teresa Nogueras Lozano Dr. Eva Ballesté-Morillas |
| excel for operations management: Operations Management Ray R. Venkataraman, Jeffrey K. Pinto, 2018-11-29 Operations Management: Managing Global Supply Chains takes a holistic, integrated approach to managing operations and supply chains by exploring the strategic, tactical, and operational decisions and challenges facing organizations worldwide. Authors Ray R. Venkataraman and Jeffrey K. Pinto address sustainability in each chapter, showing that sustainable operations and supply chain practices are not only attainable, but are critical and often profitable practices for organizations to undertake. With a focus on critical thinking and problem solving, Operations Management provides students with a comprehensive introduction to the field and equips them with the tools necessary to thrive in today’s evolving global business environment. |
| excel for operations management: Production & Operations Management Upendra Kachru, 2009 This book takes a pedagogical approach that is participative and interactive, involving the case study method of learning. Chapters start with an Indian case study of a well known company. This is used as a capstone case for the chapter. The student will find this an easy learning experience as data and additional information for these enterprises is readily available. The selection of such cases makes classroom learning truly suited to the Indian business environment.The value driven approach to Operations Management is used in structuring the text into three modules. The first module discusses the infrastructure function of Operations Management. Infrastructure function is considered to be product, process, capacity and location. Module Two describes the structure of the operations function. This includes quality and other product transformation processes. Module Three focuses on the organization, people and processes i.e. the job, the work, and the workplace. In addition, most of the mathematical techniques have been separated into supplements attached to the relevant chapters. Software solutions for the techniques have been explained in the text. Every mathematical technique is exemplified with a number of solved problems. Unlike many Production and Operations Management texts, this book covers E-commerce, Industrial Safety, Maintenance, Environmental Management (Green Productivity) and new technological trends in the discipline. These sections should add to the significance of exploring how firms can gain competitive advantage and promote sustainable development at the same time. The last section of the book comprises of a selection of cases from The Indian Institute of Management at Ahmedabad. The cases encompass the entire spectrum of Indian Industry the private and the public sectors, professional and family managed business organizations, service and manufacturing industries, single industry and conglomerates. The cases relate to Operations Strategy, Supply Chain Management, Capacity Planning, New Products, Manufacturing Technologies, etc. The Case Studies are of world class. Prof. Tirupati, one of the authors of the case studies, according to Management Science, has penned one of the top 100 management articles in the 50 years.The book is comprehensive, lucid and easy to read and understand. It should be of great value both to students and faculty. |
| excel for operations management: Operations Management B. Mahadevan, 2010 Covers the core concepts and theories of production and operations management in the global as well as Indian context. Includes boxes, solved numerical examples, real-world examples and case studies, practice problems, and videos. Focuses on strategic decision making, design, planning, and operational control--Provided by publisher. |
| excel for operations management: Operations Management David Barnes, 2018-01-30 This fascinating new core textbook, authored by a highly respected academic with over a decade of industry experience, takes a global and strategic approach to the important topic of operations management (OM). Integrating contemporary and traditional theories the text covers everything a student needs to understand the reality of operations in the modern world and combines the latest cutting-edge thinking with innovative learning features. Written in a concise and engaging style and based on up-to-date research in the field, the book provides a range of international case studies and examples that help students to apply theoretical knowledge to real-world practice. This is a must-have textbook for students studying operations management modules on undergraduate, postgraduate and MBA programmes. In addition, this is an ideal textbook to accompany modules on operations strategy, production management and services management. Accompanying online resources for this title can be found at bloomsburyonlineresources.com/operations-management. These resources are designed to support teaching and learning when using this textbook and are available at no extra cost. |
| excel for operations management: Next Generation Excel Isaac Gottlieb, 2013-02-04 Take Excel to the next level in accounting and financial modeling In this new Second Edition of Next Generation Excel, Isaac Gottlieb shows financial analysts how to harness the full power of Excel to move forward into the new world of accounting and finance. Companies of all sizes use financial models to analyze their finances and plan business operations, as well as to create financial accounting reports like balance sheets, income statements, and statements of cash flows. While many businesspeople are quite familiar with the reports created with financial models, most are not as familiar with the creation of the models themselves. This book shows them how to build an accurate and effective financial model using the solid functionality and easy usability of Excel. Fully updated and revised to include support for Apple users Written by a professor of management and statistics who has taught the discipline for fifteen years Appropriate for professional financial analysts, as well as MBA students For professionals and students whose responsibilities or studies include a full understanding of financial modeling, Next Generation Excel, Second Edition offers comprehensive training. |
| excel for operations management: MOS Study Guide for Microsoft Excel Exam MO-200 Joan Lambert, 2020-03-11 Advance your everyday proficiency with Excel! And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you’ve learned Ready-made practice files Sharpen the skills measured by these objectives: Manage Worksheets and Workbooks Manage Data Cells and Ranges Manage Tables and Table Data Perform Operations by Using Formulas and Functions Manage Charts About MOS A Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to successfully pass Microsoft Certification exams. |
| excel for operations management: EBOOK: Operations Management: Theory and Practice: Global Edition STEVENSON, WILL, 2019-01-11 EBOOK: Operations Management: Theory and Practice: Global Edition |
| excel for operations management: Production and Operations Management Systems Sushil Gupta, Martin Starr, 2014-02-07 Since the beginning of mankind on Earth, if the busyness process was successful, then some form of benefit sustained it. The fundamentals are obvious: get the right inputs (materials, labor, money, and ideas); transform them into highly demanded, quality outputs; and make it available in time to the end consumer. Illustrating how operations relate to the rest of the organization, Production and Operations Management Systems provides an understanding of the production and operations management (P/OM) functions as well as the processes of goods and service producers. The modular character of the text permits many different journeys through the materials. If you like to start with supply chain management (Chapter 9) and then move on to inventory management (Chapter 5) and then quality management (Chapter 8), you can do so in that order. However, if your focus is product line stability and quick response time to competition, you may prefer to begin with project management (Chapter 7) to reflect the continuous project mode required for fast redesign rapid response. Slides, lectures, Excel worksheets, and solutions to short and extended problem sets are available on the Downloads / Updates tabs. The project management component of P/OM is no longer an auxiliary aspect of the field. The entire system has to be viewed and understood. The book helps students develop a sense of managerial competence in making decisions in the design, planning, operation, and control of manufacturing, production, and operations systems through examples and case studies. The text uses analytical techniques when necessary to develop critical thinking and to sharpen decision-making skills. It makes production and operations management (P/OM) interesting, even exciting, to those who are embarking on a career that involves business of any kind. |
| excel for operations management: Excel Basics to Blackbelt Elliot Bendoly, 2008-07-07 Excel Basics to Blackbelt is intended to serve as an accelerated guide to decision support designs. Its structure is designed to enhance the skills in Excel of those who have never used it for anything but possibly storing phone numbers, enabling them to reach a level of mastery that will allow them to develop user interfaces and automated applications. To accomplish this, the major theme of the text is 'the integration of the basic'; as a result readers will be able to develop decision support tools that are at once highly intuitive from a working-components perspective but also highly significant from the perspective of practical use and distribution. Applications integration discussed includes the use of MS MapPoint, XLStat and RISKOptimizer, as well as how to leverage Excel's iteration mode, web queries, visual basic code, and interface development. There are ample examples throughout the text. |
| excel for operations management: Decision Modeling with Microsoft Excel Jeffrey H. Moore, Larry R. Weatherford, Lawrence R. Weatherford, 2001 CD-ROM contains: Premium Solver for Education -- Solver Table add-in software -- Extend LT 4.0 (simulation software) -- TreePlan -- GLP, a graphic visualization program -- Excel templates for in-text examples. |
| excel for operations management: Operations Management Antonella Petrillo, Fabio De Felice, Germano Lambert-Torres, Erik Bonaldi, 2021-03-03 Global competition has caused fundamental changes in the competitive environment of the manufacturing and service industries. Firms should develop strategic objectives that, upon achievement, result in a competitive advantage in the market place. The forces of globalization on one hand and rapidly growing marketing opportunities overseas, especially in emerging economies on the other, have led to the expansion of operations on a global scale. The book aims to cover the main topics characterizing operations management including both strategic issues and practical applications. A global environmental business including both manufacturing and services is analyzed. The book contains original research and application chapters from different perspectives. It is enriched through the analyses of case studies. |
| excel for operations management: OMLS Kenneth Cutright, CLARENCE AUTOR MARTIN, 2003-10-01 This Microsoft Excel based online simulation teaches operations management processes. The program offers the flexibility to choose from simple to complex production environments. This makes it feasible to use the simulation in a problem-based learning approach or as a project/case study. |
| excel for operations management: Operational Risk with Excel and VBA Nigel Da Costa Lewis, 2004-04-09 A valuable reference for understanding operational risk Operational Risk with Excel and VBA is a practical guide that only discusses statistical methods that have been shown to work in an operational risk management context. It brings together a wide variety of statistical methods and models that have proven their worth, and contains a concise treatment of the topic. This book provides readers with clear explanations, relevant information, and comprehensive examples of statistical methods for operational risk management in the real world. Nigel Da Costa Lewis (Stamford, CT) is president and CEO of StatMetrics, a quantitative research boutique. He received his PhD from Cambridge University. |
| excel for operations management: Excellence in Supply Chain Management Balram Avittathur, Debabrata Ghosh, 2020-05-12 Recent decades have witnessed an explosion in supply chain complexity. Very few firms have succeeded in building excellent supply chains and employing supply chain management (SCM) as a competitive advantage. For the ones which have developed enhanced supply chain design and process capabilities, their performance has far exceeded their competitors'. While for the vast majority of firms, SCM still remains a means of reducing costs and improving efficiency, for the excellent ones, SCM has turned into a source for value creation. What factors drive firms towards supply chain excellence? How can real differentiation be created through supply chains? Excellence in Supply Chain Management examines the characteristics and features of firms that excel in SCM. |
| excel for operations management: Operations Management R. Dan Reid, Nada R. Sanders, 2005-06-24 This 2nd Value Edition features all the content of Operations Management, 2nd Edition in a paperback format for a new low price. Taking a balanced, integrative approach, Operations Management, 2nd Value Edition demonstrates the critical impact OM has in today's business environments, and shows how it relates to every department in an organization. Authors R. Dan Reid and Nada R. Sanders provide clear, focused, and highly engaging coverage of key operations management topics, and make strong connections across concepts and chapters. |
| excel for operations management: Introduction to Operations Management: Joel D. Wisner, 2020-07-24 Introduction to Operations Management: A Supply Chain Process Approach details how firms buy, make, deliver, and return goods and services around the globe, providing students with a solid foundation of operations management concepts and techniques. The text offers a set of activities that guide the effectiveness of organizations and prepare operations managers and other employees to ensure their firms are competitive. The book is organized from a strategic to a tactical perspective, beginning with foundational concepts and ending with broader discussions of managing supply chains. Dedicated chapters address corporate strategy, services design, inventory management, aggregate planning, forecasting, lean systems, quality management, integrating processes along the supply chain, and more. Numerous real-world examples, cases, and engaging exercises allow students to place themselves in the shoes of working operations management professionals. The second edition features examples of real companies using analytical tools in decision-making situations, as well as extensive web-based content including flashcards, YouTube videos, and graded chapter quizzes. The textbook's coverage also includes emerging trends for most chapters, such as sustainability, customer relationships, and working in the global marketplace. Written for today's students and the exciting, ever-evolving marketplace, the second edition of Introduction to Operations Management is the text to bring operations management into the modern era. |
| excel for operations management: Operations Management in Context Frank Rowbotham, Masoud Azhashemi, Les Galloway, 2012-05-23 Operations Management in Context provides students with excellent grounding in the theory and practice of operations management and its role within organizations. Structured in a clear and logical manner, it gradually leads newcomers to this subject through each topic area, highlighting key issues, and using practical case study material and examples to contextualize learning. Each chapter is structured logically and concludes with summary material to aid revision. Exercises and self-assessment questions are included to reinforce learning and maintain variety, with answers included at the end of the text. |
| excel for operations management: Integrated Operations Management Mark Hanna, W. Rocky Newman, 2001 *Excel OM is Prentice Hall's exclusive user-friendly Excel add-in. Excel OM automatically creates worksheets to model and solve problems. Students select a topic from the pull-down menu, fill in the data, and then Excel will display and graph (where appropriate) the results. This software is great for student homework, what if analysis, or classroom demonstrations. *Extend+ is a graphic simulation program that allows you to build dynamic models and systems. A limited version of Extend+ is included on the CD. This version contains 10 manufacturing and service models that correspond to chapter topics. These models are described in Word documents and can be used for homework, team projects, or classroom demonstrations. The limited version of Extend+ is an excellent package for demonstrating operations processes and teaching simulation. *Extensive Lecture Notes provide reinforcement of the main points of each chapter and allow students to review the chapter material. The Lecture Notes are available in both a slide-show format, with audio clips, for in-class viewing, and in a printable format to be used as a helpful study guide. *Exercises: Miami Rec Center. These interactive exercises, developed by Scott Sampson in conjunction with the textbook authors, feature operational issues at Miami University's Recreational Center. Each of the 13 exercises ask students to view a short video clip, read about a key topic, and then answer follow-up discussion questions. Students can e-mail their answers to their instructor after they've finished. |
| excel for operations management: EBOOK: Operations Management in the Supply Chain: Decisions and Cases SCHROEDER, 2013-02-16 EBOOK: Operations Management in the Supply Chain: Decisions and Cases |
| excel for operations management: Operations and Supply Chain Management Roberta S. Russell, Bernard W. Taylor, 2019-09-24 Russell and Taylor's Operations and Supply Chain Management, 10th Edition is designed to teach students understand how to create value and competitive advantage along the supply chain in a rapidly changing global environment. Beyond providing a solid foundation, this course covers increasingly important OM topics of sustainability, corporate social responsibility, global trade policies, securing the supply chain, and risk and resilience. Most importantly, Operations Management, Tenth Edition makes the quantitative topics easy for students to understand and the mathematical applications less intimidating. Appropriate for all business students, this course takes a balanced approach to the foundational understanding of both qualitative and quantitative operations management processes. |
| excel for operations management: Operations Management for Healthcare Jan Vissers, Sylvia Elkhuizen, Nathan Proudlove, 2022-11-25 This fully updated edition of the bestselling textbook on Health Service Operations Management provides an invaluable reference for students and researchers in the fields of healthcare management, operations management and patient flow logistics. Featuring theoretical frameworks and a comprehensive set of practical case studies, this book also covers subjects such as hospital planning and supply chain management in healthcare, quality assurance and performance management. Healthcare managers work together with healthcare professionals in a multitude of challenging scenarios. Trade-offs have to be made between waiting times for customers and efficient use of scarce resources, between quality of care and quality of services, between the perspective of a single pathway and the total system, and between the perspective of a single provider and that of a network of providers working together in the chain of primary care, hospitals, nursing homes and home care. This book guides healthcare students and professionals through a set of practical tools and resources, ranging from simple queueing models to more complicated analytical models, to help address these issues. The book can be used at an undergraduate level by introducing concepts, definitions and approaches, and at a postgraduate level through the application of approaches to operations management problems in healthcare practice. It will serve as a primary textbook for a health service operations management course module in a Master's program on healthcare management. |
| excel for operations management: Developing Spreadsheet-based Decision Support Systems , 2011 |
| excel for operations management: Operations Management Roberta S. Russell, Bernard W. Taylor, 2006 Russell and Taylor, both affiliated with the Pamplin College of Business at Virginia Polytechnic Institute and State University, use rice production and distribution as an ongoing example to convey the global nature and pervasive impact of operations management in this text for business students. |
| excel for operations management: Operations Management in the Hospitality Industry Peter Szende, Alec N. Dalton, Michelle (Myongjee) Yoo, 2021-06-10 From restaurants to resorts, the hospitality industry demands strong operations management to delight guests, develop employees, and deliver financial returns. This introductory textbook provides students with fundamental techniques and tools to analyse and improve operational capabilities of any hospitality organization. |
| excel for operations management: Excel Data Analysis Hector Guerrero, 2018-12-14 This book offers a comprehensive and readable introduction to modern business and data analytics. It is based on the use of Excel, a tool that virtually all students and professionals have access to. The explanations are focused on understanding the techniques and their proper application, and are supplemented by a wealth of in-chapter and end-of-chapter exercises. In addition to the general statistical methods, the book also includes Monte Carlo simulation and optimization. The second edition has been thoroughly revised: new topics, exercises and examples have been added, and the readability has been further improved. The book is primarily intended for students in business, economics and government, as well as professionals, who need a more rigorous introduction to business and data analytics – yet also need to learn the topic quickly and without overly academic explanations. |
| excel for operations management: Student's Guide to Operations Research Paul A. Jensen, 1986 |
What does the "@" symbol mean in Excel formula (outside a table)
Oct 24, 2021 · Excel has recently introduced a huge feature called Dynamic arrays. And along with that, Excel also started to make a " substantial upgrade " to their formula language. One …
excel - How to show current user name in a cell? - Stack Overflow
if you don't want to create a UDF in VBA or you can't, this could be an alternative. =Cell("Filename",A1) this will give you the full file name, and from this you could get the user …
How to represent a DateTime in Excel - Stack Overflow
The underlying data type of a datetime in Excel is a 64-bit floating point number where the length of a day equals 1 and 1st Jan 1900 00:00 equals 1. So 11th June 2009 17:30 is about …
excel - Check whether a cell contains a substring - Stack Overflow
Sep 4, 2013 · Is there an in-built function to check if a cell contains a given character/substring? It would mean you can apply textual functions like Left/Right/Mid on a conditional basis without …
How to keep one variable constant with other one changing with …
The $ tells excel not to adjust that address while pasting the formula into new cells. Since you are dragging across rows, you really only need to freeze the row part: =(B0+4)/A$0
Excel: Searching for multiple terms in a cell - Stack Overflow
Feb 11, 2013 · In addition to the answer of @teylyn, I would like to add that you can put the string of multiple search terms inside a SINGLE cell (as opposed to using a different cell for each …
How to freeze the =today() function once data has been entered
Aug 2, 2015 · Excel's default format handling doesn't know to format this as date - so you would need to do this separately. More work than Ctrl + ; , but there might be some other use-cases …
excel - Return values from the row above to the current row
Jun 15, 2012 · To solve this problem in Excel, usually I would just type in the literal row number of the cell above, e.g., if I'm typing in Cell A7, I would use the formula =A6. Then if I copied that …
Assign a value to a cell depending on content of another cell
Jan 16, 2020 · I am trying to use the IF function to assign a value to a cell depending on another cells value So, if the value in column 'E' is 1, then the value in column G should be the same …
excel - Remove leading or trailing spaces in an entire column of …
Mar 6, 2012 · I've found that the best (and easiest) way to delete leading, trailing (and excessive) spaces in Excel is to use a third-party plugin. I've been using ASAP Utilities for Excel and it …
What does the "@" symbol mean in Excel formula (outside a table)
Oct 24, 2021 · Excel has recently introduced a huge feature called Dynamic arrays. And along with that, Excel also started to make a " substantial upgrade " to their formula language. One …
excel - How to show current user name in a cell? - Stack Overflow
if you don't want to create a UDF in VBA or you can't, this could be an alternative. =Cell("Filename",A1) this will give you the full file name, and from this you could get the user …
How to represent a DateTime in Excel - Stack Overflow
The underlying data type of a datetime in Excel is a 64-bit floating point number where the length of a day equals 1 and 1st Jan 1900 00:00 equals 1. So 11th June 2009 17:30 is about …
excel - Check whether a cell contains a substring - Stack Overflow
Sep 4, 2013 · Is there an in-built function to check if a cell contains a given character/substring? It would mean you can apply textual functions like Left/Right/Mid on a conditional basis without …
How to keep one variable constant with other one changing with …
The $ tells excel not to adjust that address while pasting the formula into new cells. Since you are dragging across rows, you really only need to freeze the row part: =(B0+4)/A$0
Excel: Searching for multiple terms in a cell - Stack Overflow
Feb 11, 2013 · In addition to the answer of @teylyn, I would like to add that you can put the string of multiple search terms inside a SINGLE cell (as opposed to using a different cell for each …
How to freeze the =today() function once data has been entered
Aug 2, 2015 · Excel's default format handling doesn't know to format this as date - so you would need to do this separately. More work than Ctrl + ; , but there might be some other use-cases …
excel - Return values from the row above to the current row
Jun 15, 2012 · To solve this problem in Excel, usually I would just type in the literal row number of the cell above, e.g., if I'm typing in Cell A7, I would use the formula =A6. Then if I copied that …
Assign a value to a cell depending on content of another cell
Jan 16, 2020 · I am trying to use the IF function to assign a value to a cell depending on another cells value So, if the value in column 'E' is 1, then the value in column G should be the same as …
excel - Remove leading or trailing spaces in an entire column of …
Mar 6, 2012 · I've found that the best (and easiest) way to delete leading, trailing (and excessive) spaces in Excel is to use a third-party plugin. I've been using ASAP Utilities for Excel and it …
