Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Order Quantity Per Mile is an important KPI that gives insight into the efficiency of the shipment process, balancing order quantity with the distance traveled,
Order Quantity Per Mile is an important KPI that gives insight into the efficiency of the shipment process, balancing order quantity with the distance traveled, and thereby helping to optimize logistics and reduce transportation costs. Create a KPI titled Order Quantity Per Mile for each shipment crteate a new column Compute the average shipment quantity for each warehouse in each month. Provide the warehouse and the corresponding month that have the lowest average value for this KPI among all the warehouses and months.
Hint: In the dataset, each row represents one trip, which is equivalent to one shipment or one order.
Step 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