Delivery Tip

Excel Geo-Analytics & Optimization

STAR Summary

  • Built a geospatial heat map and pivot filters from 1,251 deliveries.
  • Compared tips by daypart, zone, and order size.
  • Mid-week shifts tended to have higher tips per delivery, while Friday evenings tended to have higher tips per hour.
  • Neighborhood and housing type differences explained a lot of the variation in this dataset.
  • Used the dashboard to make better shift and zone choices over time.

Notes

The Excel workflow is built from personal delivery-ticket history, so the findings are useful for shift planning but not intended as a universal tipping model.

Other Projects