User Account

All Pages

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

Solution to a case study, I am looking for a solution to a case study : Sub...

I am looking for a solution to a case study : Subcontract Review and Consent by the Government. Main character is Lieutenant Ralph Sliden.

Discuss the validity in Zimbabwe of the grounds on w, Discuss the validity ...

Discuss the validity in Zimbabwe of the grounds on which the profit maximising model of the firm has been defended.

What are supply bills, Question 1 Corporate Banking represents the wide ra...

Question 1 Corporate Banking represents the wide range of banking and financial services provided to domestic and international operations of large local corporates and local oper

What is decision support system, What is Decision Support System? Explain i...

What is Decision Support System? Explain its structure and its functions. Decision Support System - meaning - Functions of DSS - Components or Structure of DSS - 1. Mode

Inventory, what is mrp2

what is mrp2

Challenge question, what is the potential negative or downside to the long-...

what is the potential negative or downside to the long-term Starbucks-OHL collaboration? identify what you can consider to be three major potential problems in such long-term relat

Student, What are the activities in promotional mix?

What are the activities in promotional mix?

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

Value Chains, How might the Internet of Things (Iot) and new emerging data-...

How might the Internet of Things (Iot) and new emerging data-analytical tools be used to disintermediate traditional customs brokers, freight consolidators and other 3PLs from your

Annual Inventory Costs., Harley Davidson purchases components from three su...

Harley Davidson purchases components from three suppliers. Components purchased from Supplier A are priced at $ 5 each and used at the rate of 240,000 units per year. Components pu

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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