Solve this problem by clustering and followed by routing. Find the total cost write Gurobipy python code
Fantastic news! We've Found the answer you've been seeking!
Question:
Solve this problem by clustering and followed by routing. Find the total cost
write Gurobipy python code solution for the problem
Transcribed Image Text:
. Sree operates a cloud kitchen and has established a partnership with a delivery company to efficiently serve her customers. She offers a monthly lunch package, allowing customers to enjoy daily doorstep lunch deliveries at their workplaces on weekdays. The menu caters to both vegetarian and non-vegetarian preferences, with separate preparation and delivery for each. This service is utilized by a total of 50 customers, with each lunch package weighing 1.5 kg. The delivery team employs two types of vehicles: bicycles and motorcycles. The bicycles can transport up to 10 kg, while motorcycles can handle 25 kg. The delivery speeds are 20 kmph for bicycles and 40 kmph for motorcycles. Once the delivery personnel reach the customer's location, it takes them an average of 3 minutes to complete the delivery and collect the previous day's containers. The delivery partner charges a fixed fee of *40 for a bicycle and *150 for a motorcycle. Additionally, there is a variable cost of *3/km for bicycle deliveries and *10/ km for motorcycle deliveries. Only 3 bikes and 4 bicycles are available. The time from departing for deliveries to returning to the kitchen should not exceed 2.5 hours. The customer locations, and their meal preferences are provided in an Excel sheet. You can transform the data to your convenience and mention them in the answer sheet. Solve this problem by clustering (by method of your choice) and followed by routing. Find the total cost of your solution. 110 Morkel . Sree operates a cloud kitchen and has established a partnership with a delivery company to efficiently serve her customers. She offers a monthly lunch package, allowing customers to enjoy daily doorstep lunch deliveries at their workplaces on weekdays. The menu caters to both vegetarian and non-vegetarian preferences, with separate preparation and delivery for each. This service is utilized by a total of 50 customers, with each lunch package weighing 1.5 kg. The delivery team employs two types of vehicles: bicycles and motorcycles. The bicycles can transport up to 10 kg, while motorcycles can handle 25 kg. The delivery speeds are 20 kmph for bicycles and 40 kmph for motorcycles. Once the delivery personnel reach the customer's location, it takes them an average of 3 minutes to complete the delivery and collect the previous day's containers. The delivery partner charges a fixed fee of *40 for a bicycle and *150 for a motorcycle. Additionally, there is a variable cost of *3/km for bicycle deliveries and *10/ km for motorcycle deliveries. Only 3 bikes and 4 bicycles are available. The time from departing for deliveries to returning to the kitchen should not exceed 2.5 hours. The customer locations, and their meal preferences are provided in an Excel sheet. You can transform the data to your convenience and mention them in the answer sheet. Solve this problem by clustering (by method of your choice) and followed by routing. Find the total cost of your solution. 110 Morkel
Expert Answer:
Related Book For
Project Management A Managerial Approach
ISBN: 978-0470226216
7th Edition
Authors: Jack R. Meredith, Samuel J. Mantel,
Posted Date:
Students also viewed these programming questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
In terms of Federal tax consequences, why are lifetime transfers to charity preferable to testamentary transfers?
-
Adventure land Incorporated purchased metal to build a new roller coaster on December 31, 2017. Adventure land provided a $500,000 down payment and agreed to pay the balance in equal installments of...
-
Prepare the 2015 common- base year balance sheet for Just Dew It. Just Dew It Corporation reports the following balance sheet information for 2014 and 2015. Use this information to work Problems 13...
-
The variables of a system which are proportional to the size of the system are called (a) Extensive variables (b) Mass variables (c) Intensive variables (d) Thermodynamic variables.
-
Leslie and Leon Lazo are married and file a joint return for 2014. Leslie's Social Security number is 466-47-3311 and Leon's is 467-74-4451. They live at 143 Snapdragon Drive, Reno, NV 82102. For...
-
Find the points on the ellipse x+2y2 = 1 where f(x,y) = xy has its extreme values. 13.10.3 Minimum surface area with fixed volume. Find the dimensions of the closed right circular cylindrical can of...
-
Compute the hydraulic radius for the channel shown in Fig. 14.20 if the water depth is 0.50 m. 25 m 0.6 m 0.5 m 1.0 m 2.
-
The taxable wages and withheld taxes for Stafford Company (EIN 00-0001462), semiweekly depositor, for the first quarter of 2018 follow. Complete Schedule B of Form 941 below for the first quarter for...
-
A certain stock portfolio is selling for $1,000 and pays a 2.5% dividend yield. The risk-free rate is 1% per year. Suppose the one-year futures price is also $1,000. Explain why this represents an...
-
When making their suits to sell to the public. Armani Exchange has a choice of different types of cloth to use. All types of cloths have the same performance and are purely based on the amount Armani...
-
Describe one strategy you could use to eliminate cultural or social bias in the work-place. Think of and describe one situation when your work was impacted by diversity issues. Then apply the...
-
During April, Burke Company has budgeted cash collections from customers of $68,000 and cash disbursements of $86,500. The budgeted ending Cash balances for March and April are $10,000 and $12,000,...
-
How quickly do suspected unexpected serious adverse reactions (SUSARs) resulting in life-threatening events need to be reported to the IRB?
-
131. On graph paper, draw quadrilateral MNPQ if M(1,7), N(-2, 2), P(3, 1), and Q(6, 4). What are the slopes of MN and NP? What can you conclude about a. ZMNP? b. What is the best name for MNPQ?...
-
Define deferred revenue. Why is it a liability?
-
During the project audit, a tremendous amount of time can be wasted if a systematic method of information handling is not adopted. Briefly explain how this systematic method may be developed.
-
What are the pros and cons of the head of a Project Management Office reporting to senior management? To departmental management?
-
Contrast total slack and free slack.
-
All transactions below relate to Alpha Ltds uncollectable accounts for the financial year ended 30 June 2023. Ignore GST The Accounts Receivable account, prior to the transactions listed above, had a...
-
The accountant for Metro Motorcycles Ltd prepared an aged analysis of accounts receivable balances at 30 June 2023. The percentages of each age group are based on historical analysis and are...
-
Foodies Warehouse Supplies Ltd has traditionally made sales for cash and on credit only. Management has resisted accepting credit cards on the basis that the business would lose on average a credit...
Study smarter with the SolutionInn App