個案總覽

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?