Operational research problem, Supply Chain Management

Assignment Help:
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.

Related Discussions:- Operational research problem

Supply chain and sourcing management, The purpose of this project is to cri...

The purpose of this project is to critically analyze one major aspect of the supply chain of a specific company, preferably your own company.  You may choose to examine: Upst

What are the different methods for evaluating inventory cost, Q. What are t...

Q. What are the different methods for evaluating inventory cost? i. FIFO method ii. Average cost method iii. LIFO method iv. Actual cost method v. Base stock prices

Challenge question, what can be gained in stapling yourself to an order?

what can be gained in stapling yourself to an order?

Logistics, Identify and discuss the primary and secondary activities in sup...

Identify and discuss the primary and secondary activities in suply chain

Stages of strategic quality management process, Question 1: Show the ob...

Question 1: Show the objectives of strategic quality management. Describe the stages of strategic quality management process. Meaning of Strategic Quality Management

The 3c model by kenichi ohmae, The 3C model by Kenichi Ohmae The 3C mod...

The 3C model by Kenichi Ohmae The 3C model has been given by well known business strategist of Japanese origin, Kenichi Ohmae. The 3 C's of the model stands for: The

Errors of measurement in quality of product, Errors of Measurement To e...

Errors of Measurement To ensure the quality of a product, errors of measurement is very important, as test cases are executed at various levels defects if found any in the test

Stepping stone method to obtain an optimal solution, A company has three fa...

A company has three factories A, B and C which supply units to warehouses X, Y and Z every month. The capacities of the factories are 60, 70 and 80 units at A, B and C

Pricing Problem, Your job is to develop a prenegotiation position for all c...

Your job is to develop a prenegotiation position for all cost elements with explanations. Available information includes program information, a cost proposal, DCAS and DCAA reports

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd