GroceryKart.com is responsible for supplying fresh vegetables and produce to all mom-and-pop retail stores in Mumbai and adjoining suburbs. There are about 600 stores in their network. They have a fleet of old Matador vans that are being used to haul the goods from their central warehouse in Andheri. Given the perishable nature of the goods, all vans leave at 5:00 AM and all deliveries have to happen before 8:00 AM. Each van can make multiple stops but the union contract prevents any truck from making more than 20 stops or travelling more than 65 KM in any trip.

In an effort to reduce costs and minimize greenhouse emissions, GroceryKart.com is planning to retire all the old Matador vans and purchase a new fleet of Mahindra vans. They believe the cost of purchasing the Mahindra vans will more or less be covered by the sale of Matador vans and the rest of the money will come from the existing savings fund. However, maintaining each truck costs Rs. 20,000 a month (including driver, etc.). Also, the variable cost/km of travel is around Rs. 30 for the first three years of the truck usage. Each Mahindra truck can carry up to 1000 kg at full capacity and at the end of the trip, all trucks return back to the warehouse. Each stop at the store takes 5 minutes to download (irrespective of the weight) and every KM travelled takes 90 seconds on an average.

The distance between each store and the warehouse is provided in Table 1. The daily demand for each store is provided in Table 2. (Click here to download the dataset)

Can you write a program to determine the number of Mahindra vans required to be purchased and the total KM that will be travelled to service the daily demand of all the stores so as to minimize the total cost over the first three years?

The output of the code should clearly mention:

The number of trucks needed
Routing for each truck and
The total miles travelled each day.

Posted Date: 9/11/2012 11:56:34 AM | Location : United States

Ask an Expert

Related Discussions:- Operational research problem, Assignment Help, Ask Question on Operational research problem, Get Answer, Expert's Help, Operational research problem Discussions

Write discussion on Operational research problem
Your posts are moderated

Write your message here..

Related Questions

Definition - inspection, Definition - Inspection, Test and Measurement in Q... Definition - Inspection, Test and Measurement in Quality Inspection can be defined as the formal evaluation exercise which studies the  characteristics  of  the  product  to

Supply Chain Management, i wanted to know how much will it cost to a assign... i wanted to know how much will it cost to a assignment could you please guide me..

Managing commercial relationship for the small-scale company, Question: ... Question: What are the challenges that suppliers face when managing commercial relationship for the small-scale company? Check customers capable of adding value Check cus

Business law:, What are 10 demerit of delagated legislature What are 10 demerit of delagated legislature

Western Pharmaceuticals A B, what should the case fill rate be for each pro... what should the case fill rate be for each product given the current uncertainty levels and order quantities and how does the calculated aggregate case fill rate fill rate differ f

BASF, How has BASF''s differentiated supply chain models worked to leverage... How has BASF''s differentiated supply chain models worked to leverage its economies of scale and extensive knowledge of its customers'' industries?

Sensitivity analysis, If I follow your recommended approach to managing my ... If I follow your recommended approach to managing my farm so as to maximize my operating income next month, how much will I earn from selling the 100 hogs?” asks Igor. “How many ho

Components of a supply chain management, Question: a) Distinguish betwe... Question: a) Distinguish between a Venture capitalists and Internet Incubator . b) What are the components of a supply chain management? c) What is included in the develo

H, Will the pricing and product policy of a multinational firm be different... Will the pricing and product policy of a multinational firm be different in a developed and an underdeveloped country? Justify your answer.n..

How to manage a company''s sales force?, Question 1 How to manage a compan... Question 1 How to manage a company's sales force? Question 2 Explain Gap analysis with SERVQUAL model Question 3 Write a short notes on-              A Elements of Ph