Question
Fuente de Vida distributes bottle water in Mexico City. The company serves customers from the traditional (mom & pop stores, kiosks, small restaurants, etc.) and
Fuente de Vida distributes bottle water in Mexico City. The company serves customers from the traditional (mom & pop stores, kiosks, small restaurants, etc.) and modern channel (convenience stores and supermarkets). Fuente de Vida uses different type of vehicles for their lastmile operations.
The company is analyzing to deploy electric cargo bikes (e-bikes) for their delivery operations in downtown. The characteristics and delivery conditions of downtown are such that e-bikes make a lot of sense. However, further analysis is required to assess their convenience from an economical point of view. For this purpose, you are asked to determine the total delivery cost that would be incurred using these new electric vehicles.
You divided downtown in 6 delivery territories or zones (A, B..., F). Each delivery zone is served by a single e-bike. A preliminary analysis showed that one cargo e-bike has enough capacity to fulfill the daily demand of any given zone. The table below shows the (X, Y) coordinates of the zone's centers and the area (in squared Km) of each zone. Additionally, it gives information about the number of customers and the number of bottles of water ordered that will be attended on an average day.
Zone | Coordinates (X,Y) (km) | Area (Km2) | Number of customers | Bottles ordered |
A | (7,10) | 0.61 | 70 | 840 |
B | (14,9) | 0.65 | 56 | 1080 |
C | (22,8) | 0.57 | 72 | 648 |
D | (5,2) | 0.59 | 60 | 420 |
E | (13,1) | 0.51 | 59 | 888 |
F | (20,1) | 0.42 | 73 | 222 |
Notice that the distribution center (DC) is located at coordinates (0,0).
The accounting department has shared with you cost information from similar vehicles. Based on this information, you estimated the following:
- The cost to load each e-bike at the DC is $5.
- The cost to stop at a customer location is $0.3 per stop.
- The cost to unload and deliver a single bottle of water at a destination is $0.01.
- The cost for riding the e-bikes is $3.5 per Km
Part 1
What is the daily cost for loading the e-bikes with bottles of water at the DC?
Part 2
What is the daily cost for delivering water to customers for downtown Mexico City? Include only the per stop charges and the per bottle charges.
Part 3
What is the daily cost for the linehaul riding of all the e-bikes from the DC to the center of each delivery zone and back (roundtrip linehaul cost)? Given the nearly perfect road network in downtown, estimate the linehaul distance based on L1 norm (Manhattan distance). Assume a linehaul circuity factor (KCF)of 1.0505
Part 4
What is the daily cost for the local riding of the e-bikes in downtown Mexico City? Assume a traveling salesman factor (KTSP) of 1.1.
Part 5
What is the total daily delivery cost per customer incurred using e-bikes? Include all costs (loading, unloading, and transportation).
Please answer all above 5 parts with step by step solutions
BOSII (7,1 (14,9) = (22,8) (20,1 BOSII (7,1 (14,9) = (22,8) (20,1Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started