Author: Monika Arora
"What-if" or sensitivity analysis is one of the most important and valuable concepts in management science (MS). To emphasize its practical relevance in a business environment, we teach students in our introductory MS course to analyze "goal seek" with Excel's built-in Goal seek. This case demonstrates the application of the goal seek tool with several examples.
Sesuki Mfg., Ltd. is a manufacturer of products such as electronic calculators. Sesuki has been searching for ways to increase quality and reduce production costs to remain competitive in world markets. Increasingly, they are substituting robots, automation, and computer-controlled manufacturing systems for blue- and white-collar workers. Sesuki is considering making some changes to automate the manufacture. Let us see how the manager takes the decision using a decision model. As one is aware about the popularity of excel as a tool for taking decision. The immense popularity of Microsoft Excel throughout the business world today for processing quantitative data and developing analytical solutions is widely acknowledged. We have increased the emphasis on sensitivity analysis in several of the modules by introducing the use of "goal seek". With Excel's built-in Goal seek o tool. Students learn to take full advantage of the spreadsheet to create and analyze goal seek addressing various what-if questions about the results from a model. Since these skills are applicable to any worksheet with formulas constructed for a particular set of calculations, students can carry their ability to perform sensitivity analysis over to other business classes, such as finance and marketing research, and ultimately, into the workplace. Breakeven analysis (cost-volume analysis) is concerned with the interrelationship of costs, volume (quantity of output or sales), and profit. The Break-Even Point (BEP) The...