tag:blogger.com,1999:blog-7394321342583943115.post3778329721927315719..comments2023-07-19T23:10:12.122-07:00Comments on Geek: MUPHORIA organized by MU SigmaVikashhttp://www.blogger.com/profile/11059616688071310835noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7394321342583943115.post-42831788428148238662014-02-16T09:41:18.861-08:002014-02-16T09:41:18.861-08:00can you also share the dataset to help us understa...can you also share the dataset to help us understand it?Piyush Bhatthttps://www.blogger.com/profile/00282160756302925967noreply@blogger.comtag:blogger.com,1999:blog-7394321342583943115.post-79876324247414930352013-10-25T00:07:57.539-07:002013-10-25T00:07:57.539-07:00PROBLEM STATEMENT
GroceryKart.com is responsible f...PROBLEM STATEMENT<br />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<br />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<br />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<br />prevents any truck from making more than 35 stops or travelling more than 65 KM in any trip.<br />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<br />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<br />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.<br />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<br />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.<br />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<br />dataset)<br />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<br />the stores so as to minimize the total cost over the first three years?<br />The output of the code should clearly mention:<br />The number of trucks needed<br />Routing for each truck and<br />The total miles travelled each day<br />The output should be in a csv where every column of the output is a truck and the entries in the column correspond to the stops the truck makes.Vikashhttps://www.blogger.com/profile/11059616688071310835noreply@blogger.comtag:blogger.com,1999:blog-7394321342583943115.post-23283896122143632952013-10-25T00:06:09.473-07:002013-10-25T00:06:09.473-07:00No, I used simply notepad++.No, I used simply notepad++.Vikashhttps://www.blogger.com/profile/11059616688071310835noreply@blogger.comtag:blogger.com,1999:blog-7394321342583943115.post-77261782386143774952013-10-12T22:57:07.527-07:002013-10-12T22:57:07.527-07:00how could you write such a lengthy code?...have yo...how could you write such a lengthy code?...have you used SAS software?rajhttps://www.blogger.com/profile/10893162129844097158noreply@blogger.comtag:blogger.com,1999:blog-7394321342583943115.post-31573250989378476162013-10-12T12:06:51.463-07:002013-10-12T12:06:51.463-07:00Can share you the problem statement of Muphoria 20...Can share you the problem statement of Muphoria 2012 . I tried googling but i didnt find any.Please respond soon.Thanks in advanceAnonymoushttps://www.blogger.com/profile/06174613536893242159noreply@blogger.com