Best Gemini prompts for Logisticians

Given a dataset of shipping carrier performance metrics, including on-time delivery rates, transit times, and claims rates, calculate the total cost of shipping for each carrier over the past quarter, including fuel surcharges and accessorials. Then, compare the results to our internal benchmarking data and identify the top 3 carriers that are underperforming. Finally, generate a report that summarizes the findings and provides recommendations for carrier optimization, including potential cost savings and service improvements.

Using a 3D model of our warehouse layout and a dataset of inventory levels, storage capacity, and product dimensions, generate a optimized inventory layout that minimizes travel distance and reduces congestion in high-traffic areas. Then, calculate the total storage capacity and inventory turnover rate for the optimized layout and compare it to our current layout. Finally, provide a step-by-step plan for implementing the new layout, including equipment relocation and staff training.

Given a dataset of delivery routes, including stop locations, time windows, and vehicle capacities, generate a optimized route plan that minimizes total distance traveled and reduces fuel consumption. Then, calculate the total cost savings and emissions reduction for the optimized plan and compare it to our current routing plan. Finally, provide a detailed plan for implementing the new routing plan, including driver training and vehicle allocation.

Using a dataset of inventory levels, shipping records, and receiving reports, identify the root causes of inventory discrepancies over the past month, including stockouts, overstocking, and misships. Then, analyze the data to determine the frequency and severity of each type of discrepancy and calculate the total cost impact on our operations. Finally, provide a report that summarizes the findings and provides recommendations for process improvements, including staff training and system upgrades.