Elton Oil, a petroleum products company operating in Senegal, owned and operated 26 diesel/gas stations across the country and purchased diesel and gasoline from Senegal’s only refinery (SAR) or imported when necessary. Elton Oil was both a distributor and retailer of oil products and its head of distribution was responsible for planning the timely delivery of products to the gas stations. However, in the case, these duties are being temporarily handled by the export manager. Unfortunately, while filling in for the vacationing head of distribution, the export manager is faced with an unexpected 30% drop in supply from the country’s refiner.
Students are challenged to schedule deliveries to groups of Senegalese gas stations given constraints on storage, distribution, and supply capacity using a Microsoft Excel worksheet as a decision support tool. (This case is also available in French.)
This case was written and published with funding support provided by the Bill & Melinda Gates Foundation.