個案總覽

Yasir Qureshi, the proprietor of the Indian cooking gas agency Universal Indane (UI), has asked the company’s operations manager, Shruti Bhargava, to review the financial statement for fiscal year 2021–22 and prepare a report on the functioning of the various divisions. Although both the manager of human resources and the marketing manager had presented their reports, Qureshi wanted Bhargava to holistically audit the current inventory system at UI in terms of customer satisfaction levels and cost perspectives. Qureshi wanted Bhargava to prepare a report based on the representative data available from the company’s headquarters in Jahangirabad. UI’s inventory turnover ratio was reportedly improving, but the increasing inventory costs, year-on-year, seemed to suggest that new standard inventory practices needed to be adopted. The total operational cost for holding the inventory was calculated based on all relevant cost elements, including ordering cost, inventory holding cost, cost of delivery, and material costs. Standard inventory management principles from operations management literature were used for investigating inventory systems in natural business settings.

Yasir Qureshi, the proprietor of the Indian cooking gas agency Universal Indane (UI), has asked the company's operations manager, Shruti Bhargava, to review the financial statement for fiscal year 2021-22 and prepare a report on the functioning of the various divisions. Although both the manager of human resources and the marketing manager had presented their reports, Qureshi wanted Bhargava to holistically audit the current inventory system at UI in terms of customer satisfaction levels and cost perspectives. Qureshi wanted Bhargava to prepare a report based on the representative data available from the company's headquarters in Jahangirabad. UI's inventory turnover ratio was reportedly improving, but the increasing inventory costs, year-on-year, seemed to suggest that new standard inventory practices needed to be adopted. The total operational cost for holding the inventory was calculated based on all relevant cost elements, including ordering cost, inventory holding cost, cost of delivery, and material costs. Standard inventory management principles from operations management literature were used for investigating inventory systems in natural business settings.

The general manager at Gati, a well-known logistics services company in India, was worried about the number of complaints the company had received. The popular supply chain solutions and logistics service provider had introduced a premium express service scheme five months ago and, since then, had 231 complaints concerning the late delivery of goods. This new scheme charged a considerable markup and guaranteed shipment of goods within 72 hours. Being dedicated to ensuring quality, the general manager had to decide whether the process was under control and if the company was operating within tolerable error limits. Could he find a solution to streamline the delivery process and achieve a target defect of 0.0005 per cent? Using MS Excel, statistical techniques were used to unravel the multi-faceted dilemma and help in decision-making.

The general manager at Gati, a well-known logistics services company in India, was worried about the number of complaints the company had received. The popular supply chain solutions and logistics service provider had introduced a premium express service scheme five months ago and, since then, had 231 complaints concerning the late delivery of goods. This new scheme charged a considerable markup and guaranteed shipment of goods within 72 hours. Being dedicated to ensuring quality, the general manager had to decide whether the process was under control and if the company was operating within tolerable error limits. Could he find a solution to streamline the delivery process and achieve a target defect of 0.0005 per cent? Using MS Excel, statistical techniques were used to unravel the multi-faceted dilemma and help in decision-making.

Student spreadsheet for case W18199.

In September 2016, a senior consultant at the Indore campus of the Central Institute of Management and Consulting (CIMC) was busy preparing some documents for a meeting on a transportation problem the organization was facing. CIMC Indore's chief operating officer had requested his assistance to resolve the transport department's issues. Management was incurring substantial yearly costs for maintenance related to the drivers that operated the various vehicles of the organizations. There was also a need to rationalize the workload of the drivers to avoid dissonance among employees. Following his meeting with the chief operating officer, the senior consultant saw an opportunity to reduce the annual cost of drivers, while addressing some of the dissatisfaction that was present among drivers concerning their schedules and workload.

Instructor Spreadsheet for 8B18D005.

Student Spreadsheet for product 9B18D005.

In September 2016, a senior consultant at the Indore campus of the Central Institute of Management and Consulting (CIMC) was busy preparing some documents for a meeting on a transportation problem the organization was facing. CIMC Indore’s chief operating officer had requested his assistance to resolve the transport department’s issues. Management was incurring substantial yearly costs for maintenance related to the drivers that operated the various vehicles of the organizations. There was also a need to rationalize the workload of the drivers to avoid dissonance among employees. Following his meeting with the chief operating officer, the senior consultant saw an opportunity to reduce the annual cost of drivers, while addressing some of the dissatisfaction that was present among drivers concerning their schedules and workload.

Instructor Spreadsheet for product 8B17D014.

Student Spreadsheet for product 9B17D014.

In November 2014, a senior administrative service officer at Madhya Pradesh State Civil Supplies Corporation Limited was faced with the problem of determining how to best allocate food grain according to location demands. She needed to choose the best delivery routes and provide a cost-effective means of meeting demands for food grain from fair-price shops. How should she approach this problem? How should she manage any changes that she makes in the distribution plans?

Student spreadsheet for case W17581.

In November 2014, a senior administrative service officer at Madhya Pradesh State Civil Supplies Corporation Limited was faced with the problem of determining how to best allocate food grain according to location demands. She needed to choose the best delivery routes and provide a cost-effective means of meeting demands for food grain from "fair-price shops." How should she approach this problem? How should she manage any changes that she makes in the distribution plans?