Search results

The managing director of a steel plant faces the decision of how much of each raw material to order for the plant for the following month. Due to lower and upper bounds on the amounts of each raw material in a batch and varying amounts of electricity and time consumed for different raw materials, one can't simply use the cheapest raw material. A linear program and the solver optimization function of Excel will provide the optimal amounts that meet the constraints. Interestingly, the best mixture for a batch is not the best mixture for a monthly plan. Shadow prices indicate the value of relaxing constraints. The typical monthly model from a student will be nonlinear, although it can be written as a linear model. This case provides the basis for an introductory class on linear programming and linear versus nonlinear models.

This case can be used to develop students’ understanding of optimization and the development of a linear programing (LP) model and solution. The instructor’s manual provides one possible solution based on the LP tools available in excel.

This case is based on real events at waypoint adventure and is derived from the authors’ experience consulting with this organization as they sought to improve pricing and scholarship management.

A young non-profit organization serving the disabled community in Boston sought growth but lacked clarity and consistency in their program pricing and scholarship structures. The case analysis centers on revising program prices to achieve specific cost and revenue requirements and determining a scholarship policy that will maximize participation in their outdoor adventure programing for the upcoming year. This case allows the exploration of optimization with an atypical objective, as the organization seeks to maximize participant engagement rather than profit.

The target audience includes upper-level undergraduate and MBA or early graduate-level students studying the optimization techniques of operations management, revenue and pricing management or marketing. The case would also be useful for discussing the challenges faced by non-profits and the non-traditional objectives that can arise for these organizations.

Operations Research and Operation Management.

Undergraduate/MBA/Postgraduate.

The case depicts an opportunity for students to be exposed to optimization techniques using linear programming (LP). This case intends to: generate the LP model (identification of objective function and constraints); apply MS-Excel solver to arrive at an optimal solution; analyse manufacturing scenarios; and plan decision dependencies.

VBK Fibreo Tech Industries was a manufacturer of fibre reinforced plastic (FRP) products for industrial and domestic applications. Despite being a new entrant, it managed to exhibit great performance and attract a loyal base of customers. This case brings to light the problem that the company was facing that is demand exceeding capacity. The protagonist of the case Madhav, the Production Manager, was tasked to solve the problem of “product mix”. He was in a dilemma on how to fulfill customer orders while minimizing losses for his company. He knew that while losses were inevitable in the current scenario, they could be minimized with appropriate planning. Students are expected to use data and facts from the case and exhibit to formulate LP, by identifying the objective function and the constraints. They are also encouraged to use MS-Excel solver to find the optimal product mix and understand the decision dependencies.

This case can be used to teach LP in an undergraduate/postgraduate-level course on operations research. Students are exposed to the creation of a mathematical model for optimization and along with devising the implementation plan.

Teaching notes are available for educators only.

CSS 9: Operations and logistics.

The subject areas are Operations Management, Operations Research, Transportation and Logistics.

The following courses (MBA/Post Graduate level) can use the case as part of their teaching material: Applied Forecasting Techniques; Optimization Methods; Operations Research.

The case details a problem faced by the Gokuldhaam Society. The society was located a great distance from the city, as the majority of the residents who live in the society work in the nearby industrial area. To cater to the daily needs of residents, the society has shuttle buses plying to and from the city at different times during the day. However, due to operational inefficiencies, the administration faced excessive transportation costs. Looking for advice in this regard, the chairman of the society contacted the Head of Department at Operations Management, Indira Institute of Management, Indore hoping to find a way to reduce some of the operational costs.

The expected learning outcomes are as follows: to make the students apply two different stationary time series forecasting techniques to a real-life problem and data set; to make the students carefully choose a specific trend-based time series forecasting technique due to the inherent constraints in the availability of data set; and to make students appreciate the importance of application of linear programming in a time series problem.

Teaching Notes are available for educators only. Please contact your library to gain login details or email support@emeraldinsight.com to request teaching notes.

CSS 9 Operations and logistics

The case of Bertelsmann China: Supply Chain for Books (B) is situated in China in the beginning of 2006. Bertelsmann Direct Group, the Chinese subsidiary of the worldwide Bertelsmann AG, is one of the leading book retailers in the country. Supply chain management is essential for success in retailing, which is why Bertelsmann puts a lot of effort into the optimization of its supply chain design. As costs are paramount to importance in the low-margin book retailing sector, linear programming methods are applied to optimize the network

The learning outcomes are to remember the overall context of global supply chain management from a stakeholder perspective, to understand the context of material handling movement in a mining industry, to apply the overall knowledge of linear programming in a supply chain context, to analyze the different constraints with flow of goods at different nodes in various location hubs and convert the same into the optimization problem and to evaluate carefully the different costs associated at different levels and then finding the optimal solution that minimizes the total cost.

This case proposes a mixed integer multi-echelon analytical model integrated with the scenario tree analysis. The integrated model is used to optimize the allocation of volumes at various stages of the supply chain of exporters of bulk materials like iron ore from Goa, India, to various countries in Asia. The scenario tree analysis is then used to evaluate decisions under certainty with demand as the stochastic parameter. The proposed integrated model has potential for collaboration in the supply chain and facilitating network design, inventory and transportation planning and policy analysis.

This course is suitable at the MBA level for the following courses: Operations Research (Focus/Session: Applications on Supply Chain Management), Supply Chain Management (Focus/Session: Global Supply Chain Management, Logistics Planning, Distribution Network), Logistics Management (Focus/Session: Transportation Planning) nd Operations Strategy (Focus/Session: Location Node Strategy).

Teaching Notes are available for educators only.

CSS 9: Operations and Logistics.

Rivigo, a new entrant in the trucking business in India, believed that a new paradigm in the trucking/logistics industry could be brought about that would not only improve the quality of service dramatically, but also upgrade a truck driver's lifestyle. While the industry faced driver shortage largely due to long stays away from home, Rivigo hoped to attract drivers by offering them roles which would bring them back home in 24 hours. Drivers would be part of a relay, handing over the truck at pit stops. Further, they leveraged an IT-enabled IoT platform on a fleet of owned trucks. All this revolutionized most of the traditions then followed in the industry. The entrepreneur and his core team comprised professionals from premium institutes of the country, with experience in professional organizations in related domains. By offering services like assured delivery at half the time and full shipment visibility, Rivigo had to charge a premium to market segments that would value this. The case raises the question of sustainability in the future.

Familiarize with the retail operations of handicrafts, facility location problem, apply multi-criteria decision through the goal programming approach and solving the same with MS Excel.

The case portrays a dilemma in the context of retail operations of a small-scale handicraft company known as Odisha Craft. Located in Odisha, Susanta Mohanty, the owner, was finding it a challenge to decide on the most promising location for his new retail outlet in the neighbouring city of Kolkata. He had five choices for the locations. Odisha craft was established by his father-in-law in 2009 with an objective to preserve and promote the rich culture of the handicrafts designed by the local artisans and ensure sustainable rural livelihood. The company had been facing numerous challenges and the pandemic has given a very formidable blow to the monthly revenues. The case brings out the multi-faceted dilemma of deciding on the facility location in 2020, involving a set of conflicting criteria. The case unfolds a systematic solution approach resolving the dilemma using MS Excel.

Courses such as operations research, operations management, service operations and retail operations for MBA students and trainings for junior-middle level executives.

Teaching notes are available for educators only.

CSS 09: Operations and Logistics

Operations Management

MBA/Post Graduate

This case attempts to highlight a very common resource allocation dilemma in a real-life scenario. The majority of today’s problems are solved by the methodology of trial and error. This case shows how a generic trial-and-error solution, if buttressed by a proper quantitative methodology, can have substantial impact on the bottom-line of an organization. The case concentrates on three disparate focus areas in a didactic fashion, namely, the ability to retrieve raw data and convert it into a utilizable form if a quantitative method is to be applied; the ability to comprehend the resource constraints of a typical real-life situation; and the skill required to develop and solve an optimization problem in Excel Solver, a product which can easily be accessed by any practitioner.

Expected learning outcomes are as follows: students learn to formulate a Mixed-Integer programming model; to interpret optimal solutions and appreciate the application of “Optimization”; to recommend a resource allocation strategy; and to understand the importance of cost minimization in organizations.

Teaching Notes are available for educators only. Please contact your library to gain login details or email support@emeraldinsight.com to request teaching notes.

CSS: 9: Operations and Logistics

In this case, students assume the roles of FK Day and Dave Neiswander, leaders of the social enterprise World Bicycle Relief (WBR), which donates and sells bicycles in sub-Saharan Africa. As a social enterprise, WBR combines not-for-profit and for-profit activities. Starting as a traditional not-for-profit organization formed to donate bicycles after the Indian Ocean tsunami in 2004, WBR eventually added a for-profit arm to facilitate growth and reduce its dependence on donations and grants. As a result, by 2017 WBR had distributed around 400,000 bicycles, primarily to schoolgirls, entrepreneurs, and health workers. As the organization grows, its leaders are interested in optimizing operations and entering new countries in Africa. What is the optimal distribution of WBR's resources between its for-profit and not-for-profit operations? How should it define the objective of its operations: should WBR maximize its social impact or the total number of bicycles in the field? Which countries should it enter?

To answer those questions, students are required to analyze the social enterprise business model. This analysis starts at the strategic level and ties into the operational level. If desired, this analysis can be followed by an Excel optimization of WBR's operations. The case contains historical data on the organization and poses questions that can be analyzed from the perspectives of a number of academic fields. It can be used in various types of courses including strategy, not-for-profit organizations, operations, and finance. The instructor materials include a prepared Excel model that can be used to make the quantitative analysis accessible to students without quantitative backgrounds, videos from WBR, and a video that shows FK Day and Dave Neiswander answering questions in the inaugural use of the case at Kellogg.